We provide IT Staff Augmentation Services!

Etl Developer Resume

Raleigh North, CarolinA

SUMMARY

  • Industry expert possessing keen understanding and hands - on exposure of all phases of Project / Program Life Cycle, which includes critical functions such as requirement gathering and analysis, project scoping, task allocation, resource optimization and timely project delivery, with focus on quality and costs
  • Hands on experience on understanding Electronic Health Record (EHR) systems and applying different predictive models to cluster and predict
  • Designed, developed & implemented datawarehousing solutions using MSBI tools (SSIS, SSAS, SSRS & PowerBI)
  • Efficient Team Leader & Player, combining communication, interpersonal & problem solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives

TECHNICAL SKILLS

Project Management tools: MS Project, MS office (word, excel, PowerPoint, MS Access)

Software: TSQL, vb.net, PLSQL, HTML, XML, R

DataBase: MSSQL, Oracle, DB2, MYSQL,MongoDB

Platform: Windows, DOS, UNIX, Linux

Tools: MSBI(SSIS, SSRS, SSAS), Shell, SAS Enterprise miner-14.1, Tableau, Power BI

Domain Expertise: Health Care, Banking, Insurance

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, North Carolina

ETL Developer

Responsibilities:

  • Experience using SQL Server database for creation of databases & stored procedures, MS SQL Server Analysis Service (SSAS) for creation of Cubes, Dimensions & MS SQL Server Integration Service (SSIS) for implementing ETL
  • Gather specifications and requirements for the development/enhancement of HL7 data exchange.
  • Develop web APIs to communitae health data using HL7 standards.
  • Develop datawarehouse to store Electronic Medical/Health Records (EMR & HER) using MSBI tools such as SSIS
  • Maintain the patient portal which access to their health records (CCD) and to ensure all the SLA’s are met
  • Perform complex analysis and troubleshooting for various clinical and business applications and have a solid understanding of workflows
  • Experience with HL7 (Health Level-7) standards
  • Build the logic to accept the data from different vendors/clients in different HL7 formats (V2 & V3) and accept all the message types (ADT-A01, ADT-A04 etc)
  • Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for secondary datasets
  • Demonstrated ability to respond to internal and external customers’ business questions and/or requirements with succinct, accurate and timely informatics solutions with strong emphasis on a customer-centric final product.
  • Participate in user meetings with management as a consultant to get a better understanding of user requirements and brainstorm improvement opportunities
  • Expert in Managing the relation between Visualizations in Powe BI
  • Created various database tables and procedures to update and clean the old data .
  • Good at using Page level filters, Drill through filters and Report level filters in Power BI.
  • Wrote various T-SQL queries, Stored Procedures and used them to build packages
  • Created ETL process using SSIS Packages to populate data from various data sources
  • Created packages using SSIS for Data Extraction from Flat Files, Excel Files, and OLE-DB to SQL Server
  • Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder

Confidential, Dayton, Ohio

ETL Developer

Responsibilities:

  • Work closely with business analysts to understand business requirements and deliver ETL / database solutions
  • Responsible for Development and Maintenance of Revenue Cycle Business Intelligence Dashboard user SSRS/Power BI, that helps Health care providers to better manage their cash flow
  • Hands on experience on developing, maintaining automation solutions using MSBI tools (SSIS, SSRS, SSAS) for Master Data Management (MDM)
  • Creating user stories by interacting with highly demanding sales teams, proposing technical solutions, configurations and some basic on-need development activities
  • Establish Master Data standards/procedures and matching rules
  • Detail Design for application UI screens and views including application flows and business logic
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2
  • Developed SSIS solution for developing a full-fledged data warehouse solution
  • Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting
  • Administered and enhanced SQL Server Integration Services (SSIS) data loads
  • Created and Maintained Database Maintenance Plans
  • Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
  • Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
  • Created OLAP Dimensions, Measures and Cubes using SSAS.
  • Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS) and Power BI
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS
  • Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server
  • Monitored Performance and Fine-Tuned the database objects and server to ensure efficient data retrieval

Confidential, Miami

ETL Developer

Responsibilities:

  • Collaborate with developers, project managers and analysts in requirement gathering, testing and constructive feedback.
  • Participate in user meetings with management as a consultant to get a better understanding of user requirements and brainstorm improvement opportunities
  • Involved in dimensional modelling with Star &Snowflake schemas and created the Data Source Views Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues
  • Involved in designing the physical databases model on SQL Server 2008R2 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing Constraints and Triggers for data integrity in development database
  • Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity
  • Collaborated with various business groups while developing their applications, assisting in Database design, creating E-R diagrams
  • Wrote various T-SQL queries, Stored Procedures and used them to build packages
  • Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables
  • Implemented Performance tuning to optimize SQL queries using query analyzer
  • Tested to optimize the procedures and triggers to be used in production
  • Worked with Date/time manipulations in SQL Server built in functionalities as well as Data Integrator Date functions.
  • Generated Parameterized/dropdown SSRS Reports
  • Developed various charts/reports in Tableau which are not available in "Show Me " like Donut Chart, Alert Chart/Table, Lollipop Chart, Motion Chart, Population Pyramid, Waterfall Chart and many more.
  • Create Parameterized SSRS Reports and ETL packages using SSAS Cubes
  • Experience in creating XML files and XSD schema files.
  • Conducted trainings on SQL 2008/2012 SSIS 2008/2012

Confidential

ETL Developer

Responsibilities:

  • Created SSIS Packages to populate data from various data sources
  • Created packages using SSIS for Data Extraction from Flat Files, Excel Files, and OLE-DB to SQL Server
  • Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder
  • Practice Kimball datawarehousing concepts for desgning developing and implementing the datawarehousing solutions
  • Monitored Performance and Fine-Tuned the database objects and server to ensure efficient data retrieval
  • OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports
  • Implement the datacleansing system as per the guidelines in Kimball standards/framework
  • Constructed Cubes based on data volumes mostly adhering to Star Schema
  • Developed SSIS packages with Package Configurations
  • Have implemented SCD type1, type2, and type 3 in SSIS Packages
  • Developed a Tabular Reports, Ad-Hoc Reports using SSRS Report Designer

Hire Now