ETL Development Resume

SUMMARY:

Over 11+ years of skillful experience in Business Intelligence designing and development
8+ years of experience in developing complex ETL module using SSIS (SQL Server Integration Services)
Proficient in T - SQL programming for OLTP, ETL and reporting models
Has experience in re-engineering legacy application and designing ETL for strategic application
Has experience of database designing logical and physical model for OLTP and OLAP
Has in depth understanding Dimensions, Fact, different type of relation between entities
Has experience in designing the ETL flow to load data warehouse and for migration projects
Has experience of starting BI projects, from requirement analysis to design and development
Experience in converting complex business logic into technical solutions
Experience in performance tuning and writing optimized query
Experience in Capital Market domain as Technical Analyst and ETL developer
Experience in developing visuals of different type using SSRS ( SQL Server Reporting Services)
Experience of development of OLAP cube using SSAS ( SQL Server Analysis Services)
Hands-on experience on MS SQL Server 2008/ 2008 R 2/2012/2014/2017, SSAS, SSRS, SSIS, T-SQL
Used TFS and GitHub as source control
Thorough understanding of each phase of SDLC, from concept to implementation
Experience on working in agile environment

PROFESSIONAL EXPERIENCE:

Confidential

ETL Development

Responsibilities:

Work closely wif business team on requirements and technical team for design solutions
Understanding the input data and implementing the ETL solution to store data in staging tables
Impact analysis and coordination wif different team to schedule the changes to existing feeds
Implementing the reconciliation process between the input data and after processes data
Getting data from heterogeneous sources like SQL, flat file, Oracle DB etc and load them in staging tables
Perform the data validation and data quality check as part of SSIS package to get quality data and raise exceptions
Implementing the threshold check based on predefined rules and send notifications
Performance tuning to improve query performance to meet SLA
Coordination wif upstream and downstream team for TEMPeffective data flow design
Create report using SSRS
Perform unit testing and Integration testing

Environment: MS SQL Server 2014, SQL Server Integration Service 2012/2017, SSDT 2014/2017

Confidential

Technical Analyst, Onsite Coordinator

Responsibilities:

Discussion wif business team on requirements and design of CoRS system
Understand the data received from SORs, related it to CoRS database design and convert it in technical mapping for development team
Decoding the existing code for legacy application and make understanding which will fit in new application.
Discussion wif business and technical team for database design
Validate the requirement written by business team and get it corrected in case of discrepancy found, to make it align to CORS system
Validation of data at high level before providing environments to business users
Coordination wif downstream team to make them understand how data is stored in CoRS and they can use it for their purpose.

Environment: MS SQL Server 2012, Ab-Initio ETL tool used for development

Confidential

Requirement gathering and convert into design

Responsibilities:

Coordination wif onshore team
Understand the requirement, Design the ETL flow and development of OLAP cube, Creating reports based on client requirements
Development of SSIS packages to load data marts
Development of SSAS cubes implemented on top of data warehouse
Designing dimensional data model and converting logical model into physical model
SSRS reports development and provide subscriptions
Tuned the SQL queries using SQL profiler, reading execution plan and Database engine tuning advisor

Environment: MS SQL Server 2008 R2, SSIS, SSAS, SSRS, Active Batch

Confidential

Individual Developer

Responsibilities:

Environment: MS SQL Server 2008 R2, MySQL, SSRS, SSAS

Confidential

Individual Developer

Responsibilities:

Discussed wif respective Function Lead, understood their business process/ requirement, and converted the design
Created OLAP cube
Created reports and deployment
Created dashboard in PPS

Environment: MS SQL Server 2008 R2, SSRS, SSAS, Performance Point Service

Individual Developer

Confidential

Responsibilities:

Understood and analyze the new application, and checked the feasibility of the reports
Development of Bars, Lines and Pies, Maps, drilldown, drill through, sub report etc based on client requirements.
SSRS report development using stored procedure and inline queries
Develop and deploy reports, and perform Unit testing

Environment: MS SQL Server 2008, SSRS