Nidhi Pathak

Operations Associate

Noida, Uttar Pradesh, India22 yrs 8 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Proven expertise in Data Warehousing and Business Intelligence.
Led successful ETL teams for major clients like TD Bank and Cigna.
Skilled in both Agile and Waterfall methodologies.

Stackforce AI infers this person is a Data Warehousing and Business Intelligence expert with strong ETL capabilities.

Contact

Skills

Core Skills

Business Intelligence (bi)EtlData WarehousingData Analysis

Other Skills

Software Quality AssuranceDataStageUNIXProject ManagementPerformance TuningInterpersonal SkillsAnalytical SkillsSQLShell ScriptingWritten CommunicationService-Level Agreements (SLA)TimelinesChange RequestsMicrosoft ExcelRelease Management

About

Vast and proven experience in Data Warehousing (Dimensional Modeling, Database design and ETL) and Business Intelligence (Report, KPI, Scorecard, Dashboards) Skills in designing and delivering solution deployment architecture, Infrastructure sizing, performance and scalability options for test, development and production environment Managed complete Data Warehouse Development Lifecycle including Enterprise Architecture, Data Analysis, ETL Design, Query Performance Tuning & Optimization, Enhancements and Production Support. Showcased excellence in business intelligence and data warehouse environments including system administration, database design, dimensional modelling, security, reporting & analytics Expertise in Agile and Waterfall Methodologies; exposure to Cloud Computing, Data Vault Modelling 2.0, Snowflake DB, AWS S3 Skilled in communicating the project health/status/risks to key stakeholders for enabling organizations to meet business challenges Experienced in Data Warehouse/Data Mart Development Life Cycle and performing ETL procedure to extract, transform and load data from different sources into Data Warehouse using various ETL Tools like DataStage/Informatica/Alteryx An effective communicator with excellent leadership and interpersonal skills

Experience

22 yrs 8 mos

Total Experience

7 yrs 6 mos

Average Tenure

14 yrs 4 mos

Current Experience

Ibm india private limited

Technical Manager

Jan 2012 – Present · 14 yrs 4 mos · Noida Area, India

I have been involved in servicing premier clients like TD Bank, Canada & Wind, Italy. My set of responsibilities in these roles include:
Involved in Full SDLC from analyzing business requirements to Go Live into Production.
Leading ETL team to create DataStage solutions for various business requirements.
Working independently to gather requirements, create technical specifications and design ETL processes.
Designed Complex Jobs/Sequences for extracting data from multiple sources and loading them into a Client’s Target System.
Involved in formation of Unit and Integration test strategy and planning.
Created ETL and DataStage standards to be followed during the project.
Designed and developed UNIX scripts to run and manage ETL jobs.
Leading the Application Monitoring Team with the monitoring and recovery of the daily as well as weekly applications. Co-ordinating the Post-production support for all the change requests and Quality activities.
Involved in the Unit Testing, System testing and Integration testing.
Conducted Peer Code Review for the Developed Jobs.
Responsible for getting object developed from team and delivery of object.
Preparation of technical specifications & providing technical support.
Involved in the migration of ETL and Database objects from development to test/production environment.
Following Programming standards and Quality procedures.
Other than the Technical responsibilities also involved in the team management activities like Status Reporting to senior management team from IBM and Client, Vacation Planning, Risk Management, Comfort Matrix, Project Audit – Both Product and Process, recruitment of new resources, handover-takeover responsibilities etc.

Business Intelligence (BI)Software Quality AssuranceETLDataStageUNIXProject Management

Tata consultancy services

Assistant Consultant

Sep 2004 – Jan 2012 · 7 yrs 4 mos · Columbus, Ohio Area

During my period at TCS, I worked onsite and offshore servicing blue chip clients like Cigna, Cardinal Health & one of the worlds top consulting firms. My roles and responsibilities include:
Involved in Full SDLC from analyzing business requirements to Go Live into Production.
Leading ETL team to create DataStage solutions for various business requirements.
Working independently to gather requirements, create technical specifications and design ETL processes.
Designed jobs for extracting data from multiple sources and loading them into a Client’s Central Data Warehouse.
Involved in formation of Unit and Integration test strategy and planning.
Created ETL and DataStage standards to be followed during the project.
Designed and developed UNIX scripts to run and manage ETL jobs.
Designed jobs for extraction, loading and Change Capture (CDC) for SCD Type 1 and 2 Dimension Tables.
Involved in Review, Troubleshooting and Resolving Technical Design and Architectural issues.
Acted as Onsite Lead for On-Site and Off-Shore Teams in coordinating work efforts.
Designed jobs for different source systems, for data movement from source to target.
Implemented Slowly Changing Dimension Type 2 and Type 1 for some dimensions.
Extensively worked with DataStage to implement different transformations satisfying business rules.
Assisted Data Modeler in data analysis for various source systems while creating Model.
Involved in high level technical design meetings with business analysts to discuss mappings.
Designed complex jobs to handle data in multi millions of records and loading them to Target.
Prepared Detail Design documentation to be reviewed by client.
Created unit test cases and documented them for approval
Was responsible for code move, Exporting and Importing from and to DEV, QA and PROD.
Involved in meetings with manager and Architect to discuss work distribution for other resources.

Business Intelligence (BI)Software Quality AssuranceETLDataStageUNIX

Infosys

Software Engineer

Jul 2003 – Jul 2004 · 1 yr · Bangalore

Serviced Fortune 100 clients like DHL. Contributions include:
Enhance and developed the existing data-mart with Informix to scheduled loads
Developed / designed various new processes and fixed the existing process with new business requirements, various meetings with users Input.
Business analysis and requirements gathering, analyzed the hierarchy for Fact & Dimensions Used Ascential DataStage Manager for importing new job categories & creating new data elements. Used the DataStage Designer to develop processes for extracting and loading data into data warehouse.
Used the SQL, Shell Scripts to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
Did Unit Testing and tuned for better performance with updates on data warehouse tables & extensively used Ascential
DataStage Director for jobs monitoring and troubles shooting.
Extensively used Sequential File Stage, Aggregator Stage, and
Hashed File Stage etc. Used Shared Containers for Server Jobs & shell scripts for job sequences, for handling rejected data, handling NULL values and complete email reporting of data

Interpersonal SkillsAnalytical SkillsSQLShell Scripting