SUMMARY

• 7 years of experience in SQL Server, SQL Server Integration Services, Data Ware Housing.
• Extensively worked with different data sources non - relational databases such as Flat files, XML files, and other relational sources such as Oracle, SQL Server and DB2.
• Involved in different stages of data warehouse development for moving Heterogeneous sources to a Data Mart/Data warehouse using ETL tool SSIS.
• Strong Experience in Data Analysis and profiling based on functional and business requirements.
• Strong data analysis skills and BI / data warehousing knowledge.
• Strong understanding of Extraction Transformation and Loading (ETL) Process.
• Comfortable in both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Extensively worked in Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Good knowledge in tuning the performance of SQL queries and ETL process.
• Analyzed data with discrepancies through Error files and Log files for further data processing.
• Strong in Data warehousing concepts, Dimensional Star Schema and Snowflake Schema methodologies.
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.
• Experience in converting business requirements into technical specifications.
• Exposure to reporting using SQL Server Reporting Services.
• Ability to work with multiple cross functional teams (technical / non-technical).
• Involved in Monthly/Dailyproduction support duties as required.
• Good understanding of aviation administration.
• Self-motivated to learn new technologies, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.

TECHNICAL SKILLS:

Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Databases: SQL Server 2008/2008 R2/2012, MySQL, Oracle

Programming & Scripting: Python, Core JAVA, C#, C/C++

Web Technologies: HTML, CSS, JavaScript, ASP.NET, Angular JS, Knockout JS, MVC, WCF, Web API

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

ETL Developer

Responsibilities:

• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets
• Monitoring the data and check if the data has been loaded properly into the databases.
• Extraction, Transforming & Loading the data from source to target.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue.
• Optimized SQL queries to improve the performance of daily SQL jobs.
• Preparing Test Cases and worked on executing the cases.
• Analyzed data with discrepancies through Error files and Log files further data processing
• Handling data irregularities in the data being sourced from different operational systems.
• Utilized SQL Server, SQL Server Integration Services (SSIS) and C#.

Environment: SQL Server, SQL Server Integration Services (SSIS), C#

Confidential

Programmer Analyst

Responsibilities:

• Responsible for Evaluation, Analysis, Design and Development of new ETL packages for Enterprise Data Warehousing team that supports Scandinavian Airlines.
• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Involved in collecting user requirements, designed, implemented and supported client's reporting needs.
• Extracted data from sources like SQL server, DB2, Oracle, Fixed width and Delimited Flat files. Transformed the data according to the business requirement and then Loaded into SQL databases.
• Handled data irregularities in the system.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Provide Production Support, create Production Run book and Operations Manuals, address and resolve critical production issues.
• Optimized and fine-tuned mappings for faster load.
• Utilized SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Developed code fixes and enhancements for inclusion in future code releases and patches.
• Responsible for changing the report layout according to the specifications of the client using SQL Server Reporting Services (SSRS).
• Involved in the documentation of different strategies for the migration.

Environment: SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and C#

Confidential

Associate Software Engineer

Responsibilities:

• Involved in collecting user requirements, designed, implemented and supported client's reporting needs.
• Worked closely with clients to establish problem specifications and system designs.
• Implement the Database components (Stored procedures). Alter the existing stored procedures as per design.
• Monitoring daily jobs to check if the data has been loaded properly into the mart database.
• Handled data irregularities in the system by coordinating with the business team.
• Provided functional knowledge to team members.
• Involved in fixing the bugs raised by the business team.
• Responsible for release and delivery preparation in various iterations during the Project.
• Responsible for Post production support of the application.
• Utilized C#, ASP.Net, SQL Server and SQL Server Integration Services (SSIS).

Environment: SQL Server, SQL Server Integration Services (SSIS) and C#

Confidential

Associate Software Engineer

Responsibilities:

• Developed new business requirements for the Internet Booking Platform used by Scandinavian Airlines.
• Utilized C#, ASP.Net, VB.Net and SQL Server.
• Provided functional knowledge to team members.
• Debugged and modified software components.
• Developed code fixes and enhancements for inclusion in future code releases and patches.

Environment: VB.Net, ASP.NET and SQL Server