We provide IT Staff Augmentation Services!

Etl Developer Resume

Dayton, OH

PROFESSIONAL SUMMARY:

  • 8 years of strong experience with demonstrated success in the Database Design, development of SQL Server 2008 R 2/2012/2014.
  • Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions and SQL joins.
  • Expert in using tools like MS SQL Profiler, Query execution plan, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
  • Very good in optimizing the Performance of SQL code.
  • Well versed in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas, tables, FKs, PKs, etc. by providing a structure that meets the business needs.
  • Responsible for preparing Technical design document, Mapping documents, data definition documents, Detail design document for the Source/Target mapping
  • 7 years of strong experience in SQL Server Integration Services (SSIS) and used various SSIS tool box transformations.
  • Experience in providing Logging, Error handling, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
  • Responsible for Package configurations or Catalog Scripts and deployments between Development and QA and Production servers.
  • 6 years of experience in creating, managing, and deploying various types of reports using Server Reporting Services (SSRS).
  • Hands on experience in developing Custom Reports, Tabular Reports, Matrix Reports, Adhoc reports and distributed reports in multiple formats using SSRS.
  • Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached and Adhoc reports using SSRS.
  • 3+ years of ETL experience in Informatica Power Center 9.6.1 and developing ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping designer, Mapplet Designer), Repository Manager, Workflow Manager and Workflow Monitor.
  • Used various Power Center transformations to meet Business logic in the mappings.
  • Performance tuning at the Mapping level as well as the Database level to increase the data throughput
  • Profound experience in migrating projects from Informatica to SSIS and vice versa
  • 4 years of hands on experience in SQL Server Analysis Services (SSAS) to analyze Data warehouse and building cubes
  • Good experience in writing MDX queries while creating and customizing Cubes using SSAS 2008 R2 and 2012.
  • Solid Knowledge on Facts, Dimensions, Star and Snowflake schemas, Partitions, KPI’s, and Perspectives, Slowly Changing Dimensions etc. in SSAS.
  • 2+ years of Hands-on experience in Microsoft Power BI
  • Power Query ("M" language), and DAX language experience.
  • Experience in transforming existing SSRS reports/Dashboards using Power BI
  • Experience in getting requirements directly from Business users and building Power BI reports and dashboards
  • Knowledge on creating dashboards and reports in Tableau. Created report schedules on Tableau server.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Worked in Agile Methodology and Microsoft Team Foundation Server (TFS)
  • Highly skilled and experienced in Agile Development process for diverse requirements
  • 4 years of experience in Healthcare domain

TECHNICAL SKILLS:

Microsoft Tools: SSMS,BIDS 2008 R2, 2012, Visual Studio 2012 & 2016, Power BI

ETL & Reporting Tools: SSIS, SSRS, SSAS, Informatica Power center 9.6, Power BI Desktop, Tableau

Databases: MS SQL Server 2008 R2/2012/2014, Oracle, TeraData

Programming Languages: T-SQL, PL/SQL, C#

Query languages: Power Query ( M ), MDX, DAX

Operating System: Windows Server 2008, 2008 R2, Windows 10 Enterprise

Software methodology & Tools: Agile ; Rally & TFS

PROFESSIONAL EXPERIENCE:

Confidential, Dayton, OH

ETL Developer

Responsibilities:

  • Gather business requirements and - work on the Analysis & provide skeleton of new design
  • Actively involved in requirements gathering/analysis meetings with Client and provide description about the analysis and approach
  • Involve in Data modeling, created Tables, PKs, FKs and referential Integrity Constraints.
  • Create excel reports dynamically in Reconciliation process of Provider Roster files in SSIS
  • Deploy ETL project and create SQL Server Agent job in higher environments using a Catalog script.
  • Create tables in relational database model with referential integrity constraints .
  • Write SQL script to create various SQL server Roles and Users and restrict access on SQL objects.
  • Develop SQL program to perform bulk insertion of data from any formatted flat file to Provider transaction tables bound with referential constraints.
  • Develop SQL stored procedure that generates a XML file with information from various Provider transaction tables.
  • Design and develop SSIS to do incremental load in Change Data Capture (CDC) fashion in SCD type 2
  • Develop dynamic SQL program that performs CDC and SCD type 2 based on the metadata of any table using Hash sum and Merge statement.
  • Write batch script for file copy, delete and archival process
  • Create complex ETL Packages to import CSV/ Excel files with more than 200 columns and different file layouts to SQL Server database .
  • Create, monitor and maintain jobs in job scheduling tool Tidal.
  • Develop mappings/sessions using Informatica Power Center 9.6.1.
  • Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
  • Import various types of flat files into database in Informatica .
  • Migrate a module from SSIS to Informatica that involve CDC in the data load.
  • Develop various SSRS Dashboards in SQL Server (2012) that shows the coverage and performance of Confidential in different areas.
  • Create Parametrized reports, Chart reports, Gauge Reports with KPI’s and combined report from different databases.
  • Migrate existing SSRS reports/Dashboards and adhoc reports to Power BI
  • Write queries in Power Query ("M" language), and DAX language for customizing data.
  • Develop Dashboard Report, Parameterized Reports, Sub reports by Region, Year, Quarter, Month and Week.
  • Provide continued maintenance and development of bug fixes for the existing and new Power BI Reports.
  • Use Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
  • Deliver Adhoc reports requested by Business within SLA.
  • On-call duty with teammate’s on daily basis and active involvement in Go-live activities
  • Work in Agile Methodology and Microsoft Team Foundation Server (TFS)
  • High ability to work on Agile projects

Environment: SQL Server 2012 Enterprise Edition, SQL, SSIS, SSRS 2012, OLTP, Windows Server 2010, Informatica Power Center 9.6.1, Power BI and Agile.

Confidential - Eden Prairie, MN

ETL & SQL server Developer

Responsibilities:

  • Use various transformations in ETL (SSIS) to load data from flat files/Excel Files to the SQL databases.
  • Design and develop data load jobs using ETL package and scheduled in SQL Agent.
  • Write stored procedures and User Define scalar Functions (UDFs) to be used in the ETL packages and SQL scripts.
  • Develop Source to Target Mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions for ETL team.
  • Creat ETL packages to read files dynamically and perform business operations using various transformations in SSIS.
  • Create ETL packages for File Transfer from one location to the other using FTP task.
  • Create, monitor and maintain jobs in job scheduling tool TWS (Tivoli Work Scheduler).
  • As part of the SSIS to Informatica migration - Develop and maintain Informatica mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into SQL Server
  • Involve in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
  • Develop Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica.
  • Implement database standards and naming convention for the database objects and documentation of all the processes involved to maintain the database for future reference.
  • Participated in Databases Architecture and data modeling design.
  • Develop tabular models in SQL Server Data Tools SSDT for analytic reporting as well as aggregated data reports.
  • Create complex SSAS cubes with multiple data partitions to selectively refresh smaller subsets of data to save on processing time in terms of heavy transactional data.
  • Extensive use of perspectives and hierarchies in models to efficiently serve reporting needs.
  • Use of Multidimensional expressions MDX to query multi - dimensional objects and return with result set for reports.
  • Extensive use of DAX expressions in tabular models as per business requirements.
  • Use various OLAP operations like slice / dice, drill down and roll up as per business requirements.
  • Extensive use of Pivot Tables and Power Pivot Excel for reports.
  • Create Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Monitor Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor and Performance monitoring.
  • Develop various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
  • Ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Prepare Dashboards using action filters, parameters, calculated sets and parameters in Tableau.
  • Involve in creating dashboards and reports in Tableau. Created report schedules on Tableau server
  • Performance tuning of stored procedures and SSIS packages.
  • Work on Change Management Cases to resolve the production change request issues based on the Specifications provided.
  • Work in Agile Methodology and Microsoft Team Foundation Server (TFS)

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, T-SQL, MS Excel, Windows 2008 server,.NET, Business Intelligent technologies like SSIS,SSAS, Tableau, Informatica Power Center and Agile.

Confidential, Santa Clara, CA

Sr. MS SQL server BI Developer

Responsibilities:

  • Extensively involved in designing the SSRS reports and ETL packages to export data of flat file source to SQL Server database.
  • Involve in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Design high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
  • Schedule jobs in Tidal environment
  • Design and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI’s in SSRS.
  • Generate and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
  • Design and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
  • Used Power BI for developing reports, data marts, KPI’s and charts for the Organization and departments.
  • Develop reports for Business with SSRS and Power BI
  • Experience in creating complex Packages in ETL for Data Migration from Oracle/Access/Excel Sheet to SQL Server 2008/2012 and Transformation.

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2008 server,.NET, Business Intelligent technologies like SSIS,SSRS,SSAS.

Confidential

SQL Server/BI Developer

Responsibilities:

  • Involve in reviewing the Investments application and interacting with business users to understand the user requirements.
  • Involve in migration of SQL Server 2005 to 2008/2012.
  • Created ETL packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Transfer data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
  • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling.
  • Involve in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
  • Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries
  • Involve in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Implement Event Handlers and Error Handling in ETL packages and notified process results to various user communities.
  • Test, clean and Standardize data in order to meet the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Design and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI’s in SSRS.
  • Generate and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
  • Design and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
  • Perform maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

Environment: SQL Server 2005/2008 R2/2012, T-SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, MDX, ASP.NET, C#, Agile, Visual Studio 2005/2008

Hire Now