We provide IT Staff Augmentation Services!

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:

  • Contributed in data warehouse design
  • Created OLAP cube
  • Developed reports and deployed to SharePoint
  • Query optimizations and performance tuning

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

Hire Now