- ETL Development: Proficient in developing, deploying, and optimizing ETL (Extract, Transform, Load) packages using SSIS (SQL Server Integration Services).
- SQL Expertise: Skilled in writing SQL queries, stored procedures, and functions for data analysis, reporting, and ETL integration.
- Query Performance Tuning: Experienced in fine-tuning SQL queries for enhanced performance and efficiency.
- Data Analysis: Strong foundational knowledge of SQL and relational databases, with a focus on data analysis.
- Data Tools: Familiarity with SAP BW for extracting and reporting on business data.
- Version Control & DevOps: Proficient in Git for version control and understanding of DevOps practices.
- Cloud Expertise: Microsoft Azure Fundamental (AZ-900) certified, showcasing cloud computing knowledge. Capable of working with Azure services like Logic Apps, Data Factory, storage accounts, and Blob Storage.
- Programming Languages: Capable of working with .NET and Java programming languages and HTML.
- SDLC and Methodologies: Proficient in SDLC processes with experience in Agile and Waterfall methodologies. Familiar with development principles like KISS, SOLID, and YAGNI.
- Production Support: Experience in production support and on-call responsibilities for ETL jobs, including code and data analysis, and providing solutions.
- ITIL Knowledge: Familiarity with ITIL concepts for IT service management.
- Tools - SSMS, Visual Studio Data Tools, GitHub, Multiple SAP BW Systems, Bex Query Designer, Bex Analyzer, SNOW, JIRA Work Experience
Software Development Engineer – MResult Services, Bangalore(India) Client – BioMarin (USA)
06/2023 - Current Project – Commercial Datamart Development Technologies Involved - SQL(SSMS),SSIS, Azure Devops, JIRA Data Gathering and Processing
- Collect and process pharmaceutical data from various sources.
- Execute Extract, Transform, Load (ETL) processes for data transformation.
10/2023 – Current
Development
- Develop and modify database tables/SSIS Packages to meet project-specific requirements.
Rigorous Unit Testing
- Conduct thorough unit testing to ensure data reliability and quality.
- Ensure data is production-ready after testing.
Jira Ticket Management
- Utilize Jira for efficient project management.
- Prioritize and address tasks according to project needs.
Process Chain Correction and Optimization:
- Periodically correct and optimize data process chains.
- Maintain the smooth and efficient flow of data throughout the system. Project - Source Code Migration from TFS 2018 to Azure Devops Technologies Involved - SQL(SSMS) , Visual Studios
06/2023 – 09/2023
- Project Analysis: Conducted a thorough project analysis and proposed three migration strategies and built POC for the selected solution option.
- Development: Actively contributed to the migration of the code repository from TFS 2018 to Azure DevOps, working alongside the solution architect and Tech Leads.
- Successful Project Delivery: Collaborated effectively with the project team, ensuring the successful completion of the project within the stipulated time frame.
Application Development Analyst – Accenture, Bangalore(India) 01/2021 – 05/2023 Client - Ab InBev (Belgium) Project – Sales Data Warehouse(ETL) Technologies Involved - SQL(SSMS) , SSIS, Visual Studio, Bex Query Designer, Bex Analyzer, SNOW, JIRA
- Support: Managed and supported an ETL application, overseeing data stored in the database.
- Development: Designed and modified SSIS packages in alignment with provided requirements and specifications.
- Client Engagement: Represented the internal team in daily and weekly meetings with onshore client teams, fostering effective communication.
- Project Tracking: Executed essential project activities and maintained ticketing tools like SNOW and JIRA, ensuring project progress tracking.
- 24/7 On-Call Support: Provided round-the-clock on-call support for live systems and assisted clients across different time zones.
- Data Analysis: Investigated data anomalies, job failures, and managed tickets (Incidents, Service Requests, and Change Requests).
- Cross-Team Collaboration: Collaborated with diverse teams to expedite ticket resolution and enhance efficiency.
