Roshan Ghogare
Pune
Summary
Dependable SSIS & SQL server Developer with 3+ years of experience in creating reliable and accurate data transformation tools. Designed and Developed SSIS Packages, stored procedure, configuration file, tables, views, functions and implemented best to maintain optimal performance. And data warehousing with a strong understanding of database design and optimization. Well-versed in technologies such as SQL. Designed SSIS packages to scale overwhelming data transition tasks into manageable projects with realistic timeframes and achievable budgets.
Overview
3
3
years of professional experience
Work History
Software Engineer
Iceico Technologies Pvt. Ltd
Nagpur, Maharashtra
05.2023 - Current
- Worked on a banking domain as a SQL & SSIS developer
- Working on data Migration to load data into the system from different sources
- Experience in writing Stored Procedures, Functions and Views
- Experienced in importing/exporting data between different sources like Sal Server/Excel etc
- Using
- SSIS utility
- Implemented error handling and logging mechanisms in SSIS packages to monitor and troubleshoot
- ETL processes
- Designed high-level ETL architecture for overall data transfer from the OLTP to OLAP
- Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS
- Package Designer
- Writing SQL queries as per the requirement received and the for the bug fixes
- Worked on reporting stored procedures for the business requirements
- Collaborated with business analysts and stakeholders to understand data requirements and deliver solutions
- Handling a small team of two resources.
Trainee Engineer
CitiusTech Healthcare Technology
Pune, Maharashtra
11.2021 - 05.2023
- Worked on a healthcare Domain
- Worked as an SQL & SSIS developer
- Designed integration tools to combine data from multiple, varied data sources such as
- RDBMS, SQL
- Experience in writing stored procedures, functions, and views
- Experienced in creating complex SSIS packages using proper control and data flow elements with error handling
- Used PuttxGen Wine to connect SFTP servers
- Created source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts
- Collaborated with business analysts to understand and define requirements
- Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and
- SSIS Package Designer
- Experienced in importing/exporting data between different sources like Sal Server/Excel etc
- Using SSIS utility
- Designed high-level ETL architecture for overall data transfer from the OLTP to OLAP
- Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases, and Data Migration Document.
Education
Bachelor of Engineering - Information Technology,
Sipna College of Engineering & Technology
Amravati, Maharashtra05.2021
2017
Skills
- Good Knowledge of SQL SERVER INTEGRATION SERVICE(SSIS), ETL
- Hands-on databases - SQL SERVER Strong in ETL data validation developed using the
- SSIS ETL environment
- Experience in writing stored procedures, functions, and views
- Good knowledge of Data Warehouse concepts, Master data management, Data
- Warehouse methodologies, Data Warehousing, Data Modeling, Performance Tuning
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Marathi
Bilingual or Proficient (C2)
Timeline
Software Engineer
Iceico Technologies Pvt. Ltd
05.2023 - Current
Trainee Engineer
CitiusTech Healthcare Technology
11.2021 - 05.2023
Bachelor of Engineering - Information Technology,
Sipna College of Engineering & Technology