ETL Developer Resume Examples

Built a decision support model for the insurance policies of two lines of Business- workers compensation and business owners’ policy.

Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications.

Worked on the maintenance and enhancements for VMware Entitlements related data mart.

Worked on the maintenance and enhancements for VMware Entitlements related data mart.

Technical environment/Tools used: MS SQL 2008, SSAS, SSRS, SSIS, MS Office, MS Project, Visio, Acorn EPS tools.

Developed ETL procedures to migrate data from an existing data warehouse to an integrated enterprise level data warehouse.

[company name] Resource Planning Database

Established consulting firm specializing in data integration, Microsoft business intelligence, data warehousing, SSAS, SSIS, ETL solutions, and more. Plan and lead all projects and oversee requirements gathering. Supervise project teams. Carried out ETL development, process maintenance, flow documenting, and management, plus T-SQL tuning and SSIS for clients of Analyst Int’l, including Bank of America, Commonwealth of Pennsylvania, and Nordstrom.

Interacted with end users and line managers to gather business requirements and conducted user acceptance.

Utilize my ETL background for the creation and execution of informatica workflow processes and complex SQL code.

[company name] & Company is a diversified financial services company providing banking, insurance, investments, mortgage, and consumer and commercial finance through more than 9,000 stores, [company name] enterprise data warehouse is built for shipment planning and Order to Remittance to facilitate end-to-end visibility through the order fulfillment process. Data is extracted from various source systems like EOM (external order management), Oracle Apps OM (Order Management) and Excel Files. The reports are built using Cognos.

Served as enterprise primary subject matter expert for Tealeaf. Maintained Tealeaf instance through event creation, capture configuration, software installation/upgrades, and troubleshooting.

Designed complex job modules to generate customer Healthcare reports for all insured members in the states of Wisconsin and New Hampshire with populations of 5 million and 1 million, respectively

Enhanced and developed rapidly growing internet marketing Data Warehouse.

Latin America Data Warehouse. Analyzed, developed and created stored procedures in PL/SQL to maintenance Warehouse’s catalogs.

[company name] is a total health care management system, which manages the total patientinformation maintained in three different modules. Patient Information, Accounts Information, Monitoring. The Patient information module contains the patient details, up to date health information. In the Accounts Information module day-to-day bill settlements will be entered in to the online system. In Monitoring, it monitors from the day one to discharge date of the patient and Case Sheet will be maintained which is confidential.

Worked on providing ETL extracts from various source systems to Master Data Management application. Also worked on extracting data from MDM to external vendors and other applications within the enterprise in the form of XML

End to end ETL design and implementation for Master Data Management (MDM) batch processing using Datastage from ODS (Teradata) and various sources which are xmls/flat files/oracle DB

Designed, developed, and tested mappings, sessions and workflows using Informatica PowerCenter in both Relational and Data Warehouse databases

Developed and implemented ETL jobs that facilitated OLTP processing for systems integration.

ETL Developer, Cigna Information Management

Responsible for setting up customer reporting system as a part of new report engine to allow customers self service report development and analytics in Jasper Server.

This highly visible data warehousing project represented an effort to provide a view into and interact with wealth data using a single OBI (Oracle Business Intelligence) Dashboard utilizing agile methodology. This dashboard provided flexible investment reporting functionality, views and client-facing reports, as well as integration of Risk Monitoring functionality and Risk Optics product information.

Responsible for setting up customer reporting system as a part of new report engine to allow customers self service report development and analytics in Jasper Server.

Implemented procedures and methods to minimize the gap between business users and development team and improve communication

Created database to track project management to help with managing contractor’s projects, hours and billing.

Worked on several data integration projects for the extraction, transformation and loading of data from various
database source systems into the datawarehouse using Pentaho.Involved in data profiling, data modeling, design,
implementation and monitoring of several ETL projects.

RDW (retail sales data warehouse) serviced financial and marketing groups that needed this data warehouse to better understand the customer purchases so this system will allow company to analyze what products were selling in which stores on what days and under what promotional condition. It was also used for calculating gross profit, gross margin, product-revenue ratios, promotions, trend analysis, and information from various dimensions.

Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Enterprise Data Warehouse Sourcing factory is capable of fulfilling mandatory FR Y-14 reporting needs for M&T. FR Y reports are a stress testing model for large BHC’s to check for Liquidity and capital adequacy. Various reports are generated. EDW is used for strategic thinking and planning from the part of the organization for overall development, fraud detection and to envision future prospects.

[company name] has been the leading provider of group disability benefits in the U.S., providing crucial income when people can’t work because of injury or illness. [company name] is also a leading provider of voluntary benefits in the country, offering a variety of valuable, affordable benefits that help protect the financial foundations of millions of U.S. workers.

Data warehousing solutions is to build a consolidated repository of client, portfolio, position and transaction data (Data which was originally residing on local, disparate databases across geographies). It is a centralized repository for cross regional data like Client, Portfolio, Positions, Transactions, Performance and Attribution, with all the supporting reference data to support global/local products, e- applications and processes.

Working on Project to Provide Minnesota State with Minnesota Basic Skill Test Reports for all Schools within the State.

Build 4 levels Risk Data Warehouse for Risk Weighted Asset (RWA) application.

To understand the existing business processes and the required solution using Datastage

The Problem of Obtaining customer and account information directly from mainframe operational systems, affects mainframe utilization, operational system performance, size of the mainframe environment and availability of mainframe. The objective of this project is to improve availability of key business data and processes by replicating the static or near static data into a non-mainframe database. A successful implementation will reduce mainframe load and in the long run will save money by not having to constantly invest in increasing mainframe capacity including best available quality of data and controlling it and populate it to Data Warehouse database going forward.

Mostly, I have been working on report designing and ETL and some cube modifications. Designed several SSRS/SharePoint reports for clients like AAA, Macy’s, Barclaycards, Chase etc. Also designing reports, troubleshooting report failures, creating SSIS packages for ETL jobs, Analysis server Cubes and some minor DBA work are some other things that I have been working on. Minor DBA works includes setting up users in Active directory, moving data from one environment to another, working on SQL agent job information, categorizing SQL job agents jobs, minor troubleshooting of user access to different domains etc.

Leaded in Oracle/ETL full development cycle and code promotion. Only allow thorough tested and reviewed code to check into Subversion to ensure the quality of our programs. Followed closely with [company name] customer’s needs and promptly deliver high quality products.

Develop & manage the design, coding, testing, implementation & debugging of Ab Initio Graphs using the GDE environment

Provided development to integrate enterprise systems to help the Finance Directors, Marketing and Sales Team for their vital decisions. Business decisions were based on the reports produced using this data warehouse.

Involved in creating specification document and requirement gathering for What-If analysis, Scheduling, Accounting, and Agreement.

Involved in requirement gathering and Business Analysis.

Develop ETLs for the conversion of Legacy data to the new CMIPS II system.

Develop and maintain data marts on an enterprise data warehouse to support various UHC defined dashboards such as Imperative for Quality (IQ) program.