NEHA SINGH

Performed gap analysis to identify areas of improvement.

• Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures. Central repository helped team of 22 members to have a single source of truth for all existing processes.
• Streamlined project management with effective communication and collaboration across cross-functional teams. Engage with stakeholders to understand the requirements. Once the process was set up it saved 40 Man hours monthly.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline proposed solution
• Collaborating with cross functional teams, business users and stakeholders to understand the requirements, gather feedback and deliver BI solutions that meet their needs.
• Collaborated closely with stakeholders to identify opportunities for process improvements and drive continuous innovation in the organization.
• Supported software development projects by defining clear requirements and effectively communicating them to technical teams.

• Provided expert support, troubleshooting complex technical problems for end-users in a timely manner.
• Promoted collaboration among IT team members, facilitating knowledge sharing and skill development opportunities.
• Contributed to continuous improvement initiatives by staying current on industry trends and emerging technologies. Accomplished c 1 PI per quarter
• Reduced risk exposure by ensuring compliance with industry standards and regulatory requirements during system design phases.
• Evaluated vendor proposals to determine best-fit technology solutions aligned with company objectives. Success rate .85

• Developed automation scripts using scope language
• Designed and developed SSIS packages to transform and load data
• Developed Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance
• Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions as required
• Used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Created customized views in the database which are used to fetch the data in the tabular cube (SSAS)
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart
• Migration of the data between the heterogeneous sources like Flat File, Excel Source, and SQL server using SSIS
• Used SSIS transformations such as Lookup, Derived column, Data conversion
• Used Aggregate, Conditional split, SQL task, Script task and Send Mail task etc
• Created UAT test cases and scenarios based on Use Cases, and made sure that UAT test cases meets the business requirements
• Provided maintenance support for ETL systems, Job Monitoring and Failure Reporting.