Summary
Overview
Work History
Skills
Accomplishments
Timeline
Generic
Neha Singh

Neha Singh

Pune

Summary

Seasoned Lead Data Architect with a proven track record at Schneider Electric, adept in enterprise information architecture and demonstrating exceptional analytical skills. Excelled in designing data models, enhancing warehouse models, and significantly improving data quality. Showcased leadership in migrating and optimizing data processes, embodying a blend of technical expertise and strategic foresight.

Overview

9
9
years of professional experience

Work History

Lead Data Architect

Schneider electric
05.2022 - Current
  • Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies
  • Designing data model as per the business requirement
  • Creating entity relationships
  • Developing mappings to load data from flat files into landing/staging using Informatica power center
  • Create metrics calculation logic
  • Performing Data Analysis and Data Correction in data in production, to meet sharp deadlines regarding customer issues
  • Performing defect analysis and fixes
  • Deploy the code in SIT/UAT/PROD environment
  • Worked on Python script to download files from sharepoint to infa server
  • Migration of code in higher environment
  • Used snaplogic to fetch API based data
  • Analyze and resolve issues/defects related to incorrect customer data, incorrect data cleansing
  • I worked as the architect for this project and designed the end-to-end flow
  • Thoroughly understand the business
  • Played a key role in designing/structuring the tables

Senior Software Engineer

Yash Technology
01.2020 - 05.2022
  • Developing mappings to load data from flat files into landing/staging using Pentaho tool
  • Create metrics calculation logic
  • Performing Data Analysis and Data Correction in data in production, to meet sharp deadlines regarding customer issues
  • Performing defect analysis and fixes
  • Migration of code in higher environment
  • Analyze and resolve issues/defects related to incorrect customer data, incorrect data cleansing

Software Engineer

Saama Technologies India Private Limited
01.2017 - 01.2020
  • Developing mappings to load data from flat files into landing/staging using informatica powercenter
  • Developing UNIX shell scripts for file processing, validation and generating reports as required by the project
  • Performing Data Analysis and Data Correction in data in production, to meet sharp deadlines regarding customer issues
  • Performing defect analysis and fixes
  • Migration of code in higher environment
  • Analyze and resolve issues/defects related to incorrect customer data, incorrect data cleansing
  • Used Hadoop tech to get the data
  • Developed program for stemming, wordcount, and stopword removal with Big data

ETL Informatica Developer

Saama Technologies India Private Limited
01.2016 - 12.2016
  • Developed ETL programs using Informatica to implement the business requirements
  • Communicated with business customers to discuss the issues and requirements
  • Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections
  • Effectively worked in Informatica version based environment and used deployment groups to migrate the objects
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations
  • Pre and post session assignment variables were used to pass the variable values from one session to other
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting
  • Performed unit testing at various levels of the ETL
  • Identified problems in existing production data and developed jobs to correct them

Skills

  • Enterprise information architecture
  • Structure designs
  • Quality analysis
  • Warehouse models
  • Information modeling
  • Data warehousing expertise

Accomplishments

  • On the Spot Award
  • Recognized for designing and implementing an optimized ETL pipeline that reduced data processing time by 30%.
    •Improved data availability and reliability for stakeholders, significantly impacting business decision-making.

Timeline

Lead Data Architect

Schneider electric
05.2022 - Current

Senior Software Engineer

Yash Technology
01.2020 - 05.2022

Software Engineer

Saama Technologies India Private Limited
01.2017 - 01.2020

ETL Informatica Developer

Saama Technologies India Private Limited
01.2016 - 12.2016
Neha Singh