Summary
Overview
Work History
Education
Skills
Accomplishments
Interests
Trekking, Travelling, Gardening
Timeline
SeniorSoftwareEngineer
PRACHI NIMBALKAR

PRACHI NIMBALKAR

Senior Software Engineer
Pune,India

Summary

Creative Senior Software Engineer offering 6.9 years of experience. Enthusiastic about developing forward-thinking solutions to tomorrow's productivity problems. Enthusiastic technical professional with complete understanding of entire software development lifecycle. Highly trained in ETL, Data warehousing, SQL and Cloud Data Integration.

Overview

6
6
years of professional experience
4
4
years of post-secondary education

Work History

Senior Software Engineer

Tech Mahindra, Bristol, Squibb Pharmaceuticals Limited
Pune, India
02.2021 - Current
  • Global Pharmaceutical company whose mission is to discover, develop and deliver innovative medicines that help patients prevail over serious diseases
  • Responsibilities:
  • Responsible for handling Data warehousing, ETL and Reporting for BMS
  • Working with AWS Redshift, EC2, SQL, Unix, Python and MSTR Reporting
  • Currently leading team for 5 developers for ETL development and enhancement
  • Discussed project progress with customers, collected feedback on different stages and directly addressed concerns.
  • Working in different environments simultaneously and with multiple integrations like flat files, relational tables, CSV files
  • Responsible for End-to-End deployment of small projects, well aware of SDLC.
  • Worked with project managers, developers, quality assurance and customers to resolve technical issues.

Consultant

Capgemini Pvt. Ltd , Grant Thornton
Mumbai, India
09.2017 - 01.2021
  • Extensively worked on data extraction, Transformation and loading data from various sources like SQL Server and Flat files
  • Strong experience in Data Warehousing and ETL using Informatica Cloud Application Integration (CAI), Informatica Cloud Data Integration (CDI) and Informatica Power Center.
  • Aligned closely with business owners and employees to gather information and gain operational insight for Ariba and Fieldglass Vendor Platform.
  • Extensive experience in ETL design, development and maintenance using SQL, PostgreSQL, UNIX.
  • Experience of managing data from multiple data sources including XML, Web Services, API, Relational Database & flat file.
  • Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in interacting with clients. Managed over 10 customer calls per day.
  • Improved performance, hiring practices and management systems to facilitate success of client's organization. Improved ETL execution time by 10% by applying performance tuning at ETL and data base side.

Informatica developer

Capgemini , Schlumberger
Mumbai, India
12.2015 - 06.2017
  • Schlumberger is world’s leading supplier of technology, integrated project management and information solutions to customers working in oil and gas industry worldwide
  • Reporter is Business Intelligence tool for Schlumberger Oilfield system
  • Developed mappings, workflows and tasks using Informatica Power center.
  • Identified, troubleshot and corrected bugs and bottlenecks.
  • Interaction with clients and end users to gather requirements, existing flow and changes, impact analysis and proposed solutions
  • Wrote SQL overrides in source Qualifier according to business requirements
  • Used Debugger to troubleshoot predefined mapping and also to check for data error and data validations. Involved extensively in Unit testing, System testing and UAT testing.
  • Involved in Production Support, Handling support that includes Job monitoring, Job scheduling, Data issues, Enhancement in projects, Deployments. Handled daily 10 production support calls.
  • Developed mappings, workflows and tasks using Informatica Power center.
  • Prepared technical design documents and specifications for Data movement project.

Education

Bachelor of Engineering - Electrical, Electronics And Communications Engineering

Singhgad Technical Education Society's Institute
Maharashtra, India
06.2011 - 05.2015

Skills

    Technical Skill – AWS Redshift, S3, EC2, Python, Snaplogic,ETL Informatica Cloud Application Integration(CAI & API), ETL Informatica Cloud Data Integration (CDI), ETL Informatica Cloud (ICS, IICS & CIH), ETL Informatica Power Center 9x/10, SQL 2008, 2012, 2016, Azure DB Data Warehousing

undefined

Accomplishments

  • Out Stretched Award:
  • Rewarded with BRAVO AWARD for demonstrating the core values for Rise and Drive position change at work from Tech Mahindra (2022)
  • Rewarded with Informatica Certificate of Appreciation from Informatica Global Technical Alliances team for successful completion of cloud IICS and Application Integration migration project (2020)
  • Rewarded with Extra Mile AWARD for successful completion of cloud migration project (2019)
  • Rewarded with SPOT AWARD for project recognition and contribution in Capgemini India Private Limited (2018)
  • Rewarded with RISING STAR AWARD in Capgemini India Private Limited (2017).

Interests

Trekking, Travelling & Gardening

Trekking, Travelling, Gardening

Achieved milestone by reaching to the highest mountain of Maharashtra state. Also have visited most risky places in Sikkim, Gangtok. Also have experienced the thrill of Leh, Ladakh.

Timeline

Senior Software Engineer

Tech Mahindra, Bristol, Squibb Pharmaceuticals Limited
02.2021 - Current

Consultant

Capgemini Pvt. Ltd , Grant Thornton
09.2017 - 01.2021

Informatica developer

Capgemini , Schlumberger
12.2015 - 06.2017

Bachelor of Engineering - Electrical, Electronics And Communications Engineering

Singhgad Technical Education Society's Institute
06.2011 - 05.2015
PRACHI NIMBALKARSenior Software Engineer