Ayan Putatunda

• Leading data engineering projects at scale in high visibility role working across multiple teams • Establishing engineering best practices and mentoring other engineers in making technical decisions on projects • Successfully plans and delivers complex, multi-team or system, long-term projects, including ones with external dependencies • Owns one or more large, mission-critical systems or multiple complex, team level projects, overseeing all aspects from design through implementation and operation • Cross functional and team collaboration on researching and brainstorming different solutions for technical challenges we face • Design and build end to end analytics solutions that provide practical insights into customer 360, finance, product, sales and other key business domains; can do critical R&D, PoC, vendor evaluation • Mentoring team members to help them grow in their technical responsibilities • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery

*** Achieve was previously known as Freedom Financial Network. • Lead product requirements and advanced analytics requirements gathering efforts, interfacing with Data Engineering, Data Scientists, Analytics, and stakeholder teams • Work with analytics, data science, and wider engineering teams to help with automating data analysis and visualization needs, advise on transformation processes to populate data models, and explore ways to design and develop data infrastructure • Use technology to solve business problems and drive positive outcomes • Build a scalable technology platform to support a growing business • Deliver high-quality code to production, consistently • Integration with various third-party systems • Play a key role in building out a large scale distributed and event-based Data Platform that serves as an underpinning for all of Freedom’s businesses and products.

Tech Stack: Python | SQL | Snowflake | R | PySpark | Airflow | Docker As technical lead of Athena core data pipeline team, responsibilities include but not limited to: • Design and architect the end-to-end data pipeline for core Athena product. • Dis-integrate business logic from code keeping configurability in mind. • Develop common codebase which is deployable across customers. • Make the core data pipelines scalable, resilient and fault tolerant. • Plan the sprint objectives with agreement from product team. • Lead a team of 5+ software and data engineers and ensure sprint goal completion.

TECH STACK : Postgresql, MS SQL Server, Python, Airflow and Shell Scripting  Design, develop and enhance AI application data models, data pipelines and database schemas. Collaborate with Data Scientists on the various tasks related to database development, data models & data pipelines in the application.  Analyze customer datasets to understand the underlying structures and relationship between entities through customer provided data dictionaries (if any) and other reference documentation. In the absence of suitable documentation write exploratory queries to understand the data and underlying data model.  Write queries to understand various statistical & technical data quality metrics like Mean, Median, Variance, Count of Nulls, Missing data percentage, Date ranges, Min & Max values etc.  Write user defined functions and stored procedures to clean customer datasets, join various tables to create de-normalized tables for analysis, perform rollups and aggregations etc.  Write SQL queries to subset and anonymize data as needed. Prepare test, train and validation datasets for testing various hypothesis.  Rapid prototyping of new data pipelines, unit testing and integration of data pipeline components in the overall AI Application pipeline design.  Troubleshoot data pipeline issues, review code, performance tuning & code optimization, integration testing of data pipelines.  Provide advisory support to customer teams in non-tech industries on Noodle Data & Application integrations strategies, SaaS best practices and help integrate customer infra with Noodle cloud.  Co-ordinate with Technology Program Management team and Product Sales & Marketing teams on various backlog requests related to changes in database structures &data pipelines.  Provide technical guidance to Associate Data Engineers in various customer deployment teams on building or enhancing core data features & customer specific customization on data pipelines.

TECHNOLOGY STACK : MS SQL Server, SSIS, SSRS, C# and Batch Scripting  Delegation as one of the onsite team leads for the retail production support domain of the client  Devising of new workflow and process diagrams through business requirement analysis to obtain the same result as reviewed by client  Documentation of business requirement by collaborating with client  Transcribing of business requirement unto technical workflow post feasibility analysis  Coordination with offshore team in India and “Nearshore” team in Argentina through technical guidance toward the attainment of requirement compliance and set timeframe  Partnership with Onsite Teams including Development, Infrastructural, and Testing teams within client location  Integral role as one of the global leads of the retail production support area  Prompt resolution of issues on IT systems involving cross group and vendor coordination  Provision of high-service delivery standards including SLA across global teams  Management of all incident, change, and problem management in the retail production application  Close monitoring of application system and job, as well as process improvement for the retail production support area  Full responsibility in handling third-party application interface support

TECHNOLOGY STACK : MS SQL Server, SSIS, SSRS, C# and Batch Scripting  Mentorship to 19 members and delivery of numerous support and enhancement projects within various regions and global location as an offshore team lead  Fulfillment of role as one of the Cognizant Academy mentors and project evaluators for new joiners in the company  Selection as entry level trainee (ELT) from Cognizant Academy by interviewing them for retail production support team  Promotion as associate projects with a high year end appraisal for exemplifying excellent work ethic  Alignment with changing business needs by handling multiple retail enhancement requests  Generation of reports through SSRS based on the business requirement  Establishment of strategic direction to the manual work automation by creating excels based tools that provide accuracy and minimize the manual work load  Spearheading of POS data integration designing which went live production with zero errors by using SSIS package  Significant decrease on incident count through continuous service improvement  Application of critical thinking ability in managing complex situations in production support as well as in leading the team

TECHNOLOGY STACK : MS SQL Server, SSIS, SSRS, C#, VBA and Batch Scripting.  Collaboration with multiple junior members as part of the Offshore Team and as production support shift lead  Facilitation of training to junior resources both technically and productively toward seamless operations in the retail production support team

TECHNOLOGY STACK : MS SQL Server, SSIS, SSRS, C#, VBA and Batch Scripting.  Building of near shore location in Argentina with emphasis on production support in the US business operation hours  Administration of multichannel retail ERP package through the following efforts:  Initiation of the version upgrade in USA by working closely with onsite team without business disruption  Achievement of high-level client feedback and appreciations on post upgrade  Demonstration of superior program management to the third-party software used for assortment planning in the Unites States  Partnership with European business partners to understand and analyze the requirements  Collection and completion of code analysis which helped the team to support the application  Proactive involvement with Cognizant Argentina management to attend to all challenges in setting up the project from a new delivery location  Updating of client management regarding the project operation from new “Nearshore” location and win their confidence by achieving seamless delivery  Keen evaluation of business requirements through active coordination with business partners in retail domain and imparting of knowledge to offshore team  Record of exceeding client expectations on delivery while complying with service level agreement across all regions  Oversight of project launch in the near shore location at Buenos Aires along with two team members

 Upgrading and maintenance of Business Process diagrams and transcribing them into knowledge for future reference by other team members  Incident/Problem/Change Management as a part of retail production support team  SQL server job monitoring taking corrective actions in case of job failures  SQL server job logic analysis to document the back-end data interactions within database tables  Integration of two divided stores, named legacy stores and Levis products, into one business umbrella with the following responsibilities: • Management of all back-end data migration, job scheduling and implementation into the new Single Instance Server • Vital role in the migration project while working on SQL jobs analysis and support pre- and post-implementation • Acquisition of high-level client and organizational appreciations and recognition for the success of GO LIVE project • Delivery of optimum quality results within the areas of merchandising, retail accounting, and store operations • Quick response to critical issues causing business outages in retail domain while finding the root cause of the outage

 Completion of all tests and evaluation criteria to demonstrate experience in Dot Net technologies.  Carrying out of various programming responsibilities in the retail domain of the notable client.  Interface with Production Support Team as retail IT analyst  Communication of business to client, chief executive officer, and senior vice president level regarding global issues and outages

The Master of Computer Science in Data Science (MCS-DS) track is a non-thesis (coursework-only) program of study that leads to the MCS degree using courses that focus on data science. The MCS-DS track requires 32 credit hours of graduate coursework, completed through eight graduate-level courses each at the four credit hour level. The MCS-DS includes required coursework in machine learning, data mining, data visualization and cloud computing.