PROFESSIONAL SUMMARY:

• Microsoft Business Intelligence Developer with 5 years of work experience in developing Business Intelligence solutions in an Agile environment.
• Strong experience in using the Microsoft SQL server 2012/2016 and SSIS.
• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration from various type of sources (Excel, flat file, XML, OLTP DB etc.), Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors. Expert in troubleshooting SSIS packages using a variety of techniques/tools.
• Strong troubleshooting and critical thinking skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self - managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

SUMMARY OF TECHNICAL SKILLS

Platforms: Windows (2000, XP, Vista,7,8), MS SQL Server 2012/2014

T: SQL, Visual Basic

Applications / BI Tools: Microsoft Data Transformation Services (DTS), SQL Server Integration (SSIS), SQL Server Reporting (SSRS), SQL Server Business Intelligence Development Studio (BIDS), MS Access, SQL SERVER, SQL Profiler, Query Optimizer

Miscellaneous: Visible Analysis and Troubleshooting

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer (SQL Server, SSIS, SSRS)

Responsibilities:

• Exposure to Business Analyst activities: I have been involved in the requirements gathering planning and implementation process of small to medium projects, I participated in the creation and review of the Business Requirements Document.
• Involved in the development and maintenance of Database Schema, Entity relationship diagrams, Data modeling. Developed tables, constraints, schemas, indexes, views, creating complex stored procedures, triggers, functions.
• Have developed and maintained complex SQL queries using joins, sub queries and correlated sub queries. Developed complex store procedure and user-defined functions.
• Troubleshoot slow performing queries by using SQL Profiler. Created traces in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures.
• Created packages using Integration Services (SSIS) for extracting data from Flat Files, XML files, CSV files, Access, Excel files, OLE DB to SQL Server, and load data to the Data Warehouse.
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup transformations, merge joins, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.
• Render reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscriptions.
• Worked on Customers onboarding, requirement gathering, feed development and data reconciliation.

Confidential

ETL Developer (SQL Server, SSIS, SSRS)

Responsibilities:

• Designed and created an ETL solution to consolidate applications received from various sources. Numerous reports were also created to meet the client’s need.
• Worked on all activities related to the development, implementation, administration and support of ETL processes.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Used advanced SSIS tools (Derived Columns, Conditional Split, Look-up Transformation, Aggregations, Multicasting).
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for optimized performance.
• Enhanced performance using optimization techniques-normalization and indexing
• Performance tuning of Queries and Stored Procedures.
• Performance tuning on existing ETL packages.
• Designed various SSRS reports as requested by the client.
• Rendered reports in different formats like pdf, excel etc. Scheduled to be executed automatically on weekly or monthly basis and managed subscriptions.
• Applied security to reports on item and folder level.
• Scheduled report and exported in PDF format.
• Documented all database objects, procedures, views, functions & packages for future s.
• Generated Reports and designed packages using global variables, Expression and functions.
• Written and reviewed functional specifications, performed unit and system tests, troubleshoot and implement logged bug fixes.
• Designed and Developed Technical specifications for the packages created, for future as per the client’s request.