Himanshi
Application Development Senior Analyst
Noida
Summary
Committed Application Development Senior Analyst with exceptional leadership and technical skills required to drive teams toward optimal results. Around 4 years experience in Data Analyst/Data Modeling, Data Migration and Data Quality. Skilled in implementing SQL tuning techniques such as Joins, Indexes, Stored Procedure, Views, Function, Triggers, Performance tuning and Optimization. Good experience in production support and identifying root causes. Responsible for creating physical model and application based tables using Erwin tool.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
1
1
Language
Work History
Application Development Senior Analyst
Accenture Solutions Pvt. Ltd
Noida
05.2021 - Current
- Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
- Developed a Conceptual model using Erwin based on requirements analysis
- Developed normalized Logical and Physical database models to design OLTP system for the applications
- Created model for the reporting system by identifying required dimensions and facts using Erwin Data Modeler 2021 R1.
- Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
- Designed database and table schemas as per the Physical model
- Created complex queries, stored procedures, views in a fast-paced iteration driven environment to achieve required business
- Worked on stored procedure and merge scripts which helps in loading data from JSONs and handled multiple environments using dynamic query
- Managing database on production environment
- Communicated directly with project stakeholders, providing timely updates on project advancement.
- Designed best practice documentation for development.
- Managed software development and support using formal specifications, data flow diagrams and other design techniques.
- Implemented consistent coding practices.
- Developed standardized work processes, tools and methodologies to improve quality and profitability.
Software Engineer
CPA Global
09.2018 - 05.2021
- Experienced SQL developer adept in bringing forth expertise in DataMigration
- Proficient in various kind of source data to migrate
- Used SSRS to create, execute and deliver tabular, matrix and chartsreports
- Created package, staged data from different data sources into a SQL Server Database using SQL Server Integration Services
- Worked Closely with QA Team and helped them come up with testscenarios
- Managed individual project priorities, deadline and deliverables.
Education
Bachelor of Computer Science - Engineering, Cloud Computing and Virtualization
Galgotias University
09.2014 - 04.2018
Skills
SQL Server, T-SQL
Relational Database
Data Modeling
Microsoft Visual Studio
Erwin Data Modeler
SQL Server Management Studio
Microsoft Excel
Python
HTML and XML
Accomplishments
Extra Mile Award
On wining the Accenture Extra Mile award in the Individual category. This award recognizes me for the staying agile and resilient and successfully prioritizing critical tasks to work more efficiently.
Timeline
Application Development Senior Analyst
Accenture Solutions Pvt. Ltd
05.2021 - Current
Software Engineer
CPA Global
09.2018 - 05.2021
Bachelor of Computer Science - Engineering, Cloud Computing and Virtualization
Galgotias University
09.2014 - 04.2018