Nitin Ambhore

Software Engineer

skylex technologies pvt ltd pune•  February 2022 - February 2024•  Pune, Maharashtra

Key Responsibilities and Achievements: • Business Intelligence Development: Two years of experience in developing business intelligence solutions. • SSIS Package Creation and Optimization: Successfully created and optimized SSIS packages to aggregate data from various origins including OLE DB, flat files, Excel files, ODBC, and CSV, improving data integration workflows. • Advanced SSIS Features Implementation: Implemented advanced SSIS features like fuzzy lookup and merge join, advancing data accuracy by 30% and streamlining reporting processes, significantly reducing manual data handling errors. • SQL Stored Procedures Analysis: Expertise in analyzing complex SQL stored procedures to perform root cause analysis (RCA), resulting in a 20% reduction in query execution time and improved database performance. • Database Solutions Development: Developed, tested, Deployed, and maintained comprehensive database solutions with SQL Server and SSIS, contributing to optimized data accuracy and system reliability. • Data Integration: Developed an SSIS package for data integration that consolidated information from diverse sources such as OLE DB, flat files, Excel, ODBC, and CSV, enhancing reporting accuracy by 25% and significantly increasing team productivity. • SQL Joins and Stored Procedures: Designed and Executed SQL Joins, Subqueries, and Stored Procedures to improve the efficiency and accuracy of complex queries. • SSIS Transformations: Extensively utilized SSIS transformations, including Lookup, Data Conversions, and Conditional Split, to streamline ETL processes and enhance data accuracy. • SSIS Package Configuration: Experienced in writing expressions, declaring local variables and configuring packages in SSIS to optimize data processing and ensure seamless integration. • SQL Query Optimization: Successfully performed SQL query optimization, progressing query performance and reducing server load.