Neha Karangutkar
Associate Manager
Washington
Summary
Former Associate Manager in Accenture's Technology Consulting practice, has close to 11+ years of wide experience in designing and developing datalakes/datawarehouse/databases applications using Informatica and Big data framework.Primary area of expertise is in Data warehousing and Data Engineering applications and tools like Informatica,Apache Spark,Apache Hive,Kafka,HBase,Airflow and AWS.
Overview
11
11
years of professional experience
2
2
Certifications
Work History
Associate Manager
Accenture
Mumbai
07.2021 - 01.2022
- Interacted with the Business Analysts to understand the business & gather technical requirements.
- Involved in translating the business requirements to technical requirements.
- Provided technical leadership and hands on implementation role in the areas of data techniques including data access,modelling,implementation and visualization.
- Lead the design, development and implementation of the migration project from Informatica Powercenter/Aptitude to Big data setup.
- Helped establish best practice standards and guidelines which increased efficiency by 21%
- Worked on optimizing and tuning the Teradata views and SQLs to improve the performance of batch and response time of data for users.
- Coordinated resources from stakeholders and mapped out project deliverables.
Senior Consultant
Deloitte
Mumbai
04.2018 - 01.2020
- Leading the team to implement regulatory and management reporting
requirements for Telecom Client. - Used Informatica and Big data tools, processes and methodologies for designing and developing solutions.
- Proactively identified and found ways to resolve issues to prevent distractions and keep projects on track.
- Worked effectively with multiple Scrum teams both internally and off-shore.
- Work on new enhancements in the Revenue Recognition project using
Informatica Powercenter and Big data framework. - Systemize ASC 606 & IFRS 15 processes with the Big data framework
- Perform code migrations and deployments between different environments.
- Leading the efforts for implementing agile methodologies in project.
- Provide formal training and knowledge transfer sessions.
Senior Consultant
Deloitte
Mumbai
04.2016 - 05.2018
- Working with the Business Analysts to gather business requirements and implementing the same into a functional data warehouse design.
- Involving in creating logical and physical design of data models using Visio.
- Collaborated with product owners, team members, technologists, and other scrum masters to define solutions and drive progress.
- Actively involving in requirements gathering and completing the life cycle of the project.
- Extensively working on Informatica client tools - source analyzer, warehouse designer, transformation developer, mapplet designer, mapping designer, workflow designer, worklet designer and task developer.
- Successfully loading data into different targets from various source systems like Oracle database, flat files, xml files etc. Into the staging table and then to the target database.
- Creating different parameter files and changed session parameters, mapping parameters, and variables at run time.
- Developing new and maintaining existing Informatica mappings and workflows based on specifications.
- Creating mapplets, reusable transformations, worklets and used them in different mappings, workflows.
- Using source qualifier, expression, aggregator, lookup, router, normalizer, sorter, stored procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into target systems.
Consultant
Deloitte
Mumbai
12.2013 - 04.2016
- Detailed analysis of data feeds from the source systems was prioritized to focus on the "Common Source Systems" that feed data to both the Chicago ABC and Carmel ABC ledgers first and then Chicago based feeds.
- Creating Informatica mappings for pre-processing Staging warehouse and Data Mart Designing and ETL coding at various loading stages.
- Was involved in SIT testing phase of Release 3.1.Was involved in estimation ,analysis,preparation of queries and execution of cases and status reporting as well.
Senior Software Engineer
IGate Computer Systems
Navi Mumbai
07.2010 - 12.2013
- Creation of Low Level Design Documents with detailed explanation of the logic used.
- Creation of mappings with the purpose of Automated Testing and reusable capabilities.
- Preparation of Maestro documents for scheduling the jobs on Maestro.
- Creation of Unit Test Cases and Integration Test Cases for Mappings
Education
Bachelor of Science - Information Technology
Pillai's College of Arts,Commerce And Science
Navi Mumbai 06.2010 - 07.2010
Skills
Informatica Powercenter
Big data
Apache Spark
Hive
Hbase
Sqoop
Teradata
SQL
Amazon Redshift
Oracle
Agile Project Management
Project Management
IFRS
DAP Aptitude
Aptitude Accounting Engine(AAH)
Aptitude Revenue Recognition Engine(ARRE)
Certification
AWS Solutions Architect-Associate
Timeline
AWS Solutions Architect-Associate
12-2021
Associate Manager
Accenture
07.2021 - 01.2022
Senior Consultant
Deloitte
04.2018 - 01.2020
Aptitude revenue recognition engine
07-2016
Senior Consultant
Deloitte
04.2016 - 05.2018
Consultant
Deloitte
12.2013 - 04.2016
Senior Software Engineer
IGate Computer Systems
07.2010 - 12.2013
Bachelor of Science - Information Technology
Pillai's College of Arts,Commerce And Science
06.2010 - 07.2010