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
Similar Profiles
Abhishek SinhaAbhishek Sinha
R&D Manager at AVEVA Group PLC, A Schneider Electric, Schneider Electric SoftwareR&D Manager at AVEVA Group PLC, A Schneider Electric, Schneider Electric Software
Süleyman KEYKUBATSüleyman KEYKUBAT
R&D Mold and Project Executive at GÜNSAN ELECTRIC (SCHNEIDER ELECTRIC)R&D Mold and Project Executive at GÜNSAN ELECTRIC (SCHNEIDER ELECTRIC)
Enrique DiazEnrique Diaz
Logistics Shipping Coordinator at Schneider ElectricLogistics Shipping Coordinator at Schneider Electric
Nichole KellyNichole Kelly
Customer Support Manager at Schneider ElectricCustomer Support Manager at Schneider Electric
Niraj DigheNiraj Dighe
Lead Software Engineer at Cloud Software GroupLead Software Engineer at Cloud Software Group