We provide IT Staff Augmentation Services!

Etl Developer Resume

Summary

  • Over 12+ years of IT experience in the Analysis, Design, Testing, Development, Implementation and Maintenance of applications.
  • Certified as Informatica Designer, Administrator and Consultant with Excellent ETL experience using, Informatica PowerCenter 8.6.1/7.1.4/6.2 (Source Analyzer, Warehouse Designers, Repository Manager, Server manager, Mapping/Mapplet/Transformations, Repository Server, Workflow Manager).
  • Have a proven experience in activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center, Power Mart and Power Connect.
  • Experience in FACT and Dimensions,star schema and snow-Flake Modeling.
  • Extensive Database experience using Oracle 9i/8i/7.x, DB2, MS SQL Server 2000/7.0/6.5, MS Access 7.0/2000, Oracle Report Writer ,TOAD, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000.
  • Have extensive knowledge in Database Performance Tuning and Backup.
  • Experience inSun Solaris 2.7, HP-UX, SCO-Unix, Linux, Win NT4.0, Win 95/98/NT/2000/XP.
  • Good exposure with operating systems Windows NT/2000/XP and UNIX with load utility Scripts.
  • Worked on Client/Server applications by using VB 6.0, ASP, COM+
  • Experience in Financial, Chemical, Textile, Pharmaceutical and Tele Communications industries.
  • Excellent analytical and problem solving skills.
  • Actively involved in production support.

Technical Skills

Databases: IBM UDB DB2 7/8, Oracle 7.x/8.x/9i and SQL server7.x/8.x/2000/2005, Ms Access
ETL Tools: Informatica Power Center6.x/7.x/8.x and
OLAP Tools: Business Objects 5.x/6.1, Power Play, Crystal Reports 6/7/8.0/9.0/10
Database Modeling: Erwin 3.5.2/4.1, Star-Schema and Snowflakes Modeling.
Operating Systems: Sun Solaris 2.7, HP-UX, SCO-Unix, Linux, Win NT4.0, Win
95/98/NT/2000/XP.
Languages: SQL, PL/SQL, Shell Scripting, C, C++ and Java
GUI: VB. NET, VS.NET, ADO.NET, VB 6.0/5.0 (COM/ DCOM, ActiveX
DLL/EXE, ADO, RDO, DAO, ODBC, OLE-DB, ActiveX, Developer 2000.
Web Technologies: HTML, DHTML, VBScript, CSS, JavaScript, ASP, XML and XSL
Web Servers: IIS
Web Tools:Front Page, Visual Studio, XML and Dream weaver
Other Tools: Visual SourceSafe, TOAD and Crystal Reports 9.0/8.5/6.x

Confidential, Hartford, CT Aug’09–Present
Data Warehouse / ETL Developer

Currently working on Monthly Management Information Pack (MIPack) project.

The primary objective of MI Pack Phase 1 is to automate the creation of the Management reports that comprise the MI Pack and the secondary objective is to build business hierarchies within the OBI reporting tool or IDW, or both. This will be accomplished by leveraging the data consolidation efforts performed by the Insurance Data Warehouse (IDW) and reporting functions of Oracle Business Intelligence (OBI).

Confidential, Hartford, CT Jul’07–Aug’09
Data Warehouse / ETL Developer

XL Capital Ltd (XL) is a provider of insurance and reinsurance coverage to industrial, commercial and professional service firms, insurance companies and other enterprises on a worldwide basis. The Company operates through four business segments: Insurance, Reinsurance, Life Operations and Other Financial Lines.
Worked as a developer on a project to acquire data from Insurance Financial Reporting and Controls database and produce a data mart for Financial Reporting needs. This was successfully implemented on time, meeting all deliverables within a very tight timeframe.

Responsibilities:

  • Extensively used ETL to load data from AS400, SQL Server and Flat files to feed the General Ledger.
  • Involved in Designing generic Mapping tables and Helper tables.
  • Used Transformations mostly as Expressions, Filters, Joiners, aggregators, Lookups and Routers, Normalizers and unions to load consistent data into Database.
  • Worked with Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
  • Dynamically generated param files by using windows batch scripts.
  • Involved in Dimensional Modeling Techniques to create Dimensions, Detail Fact and summary fact tables.
  • Monitoring the workflow performance and status with Workflow Monitor.
  • Developed Various Command Tasks to automate the Pre session jobs.
  • Used various Performance Tuning techniques to improve the load.
  • Have written complex SQL Queries involving multiple tables with joins.
  • Involved in Converting SQL server Procedures and SQL Loader scripts to Informatica mappings.
  • Tuning SQL server procedures and Functions with different utilities like EXPLAIN PLAN.
  • Tuning complex ETL mappings
  • Created Automation EMAIL process to notify users for OOB issues.
  • Involved in writing stored procedures, Pre-session and Post- Session Scripts.
  • Used PMCMD to interact with Informatica workflow’s and automated individual object import and export process.
  • Developed Autosys jobs to schedule the informatica jobs.
  • Involved in consolidated error processing mechanism.
  • Extensively worked with QA and PROD and Volume estimations.
  • Involved in Informatica Version up gradation from 7.1.4 to 8.6.1
  • Involved in Production defects and enhancements.

Environment: SQL server 2000/2005, Windows server 2003, Power Center 7.1.4/8.6.1, oracle 8/9.

Previous projects

Confidential, Hartford, CT Sep’04–Jul’07
Data Warehouse / ETL Developer

This project is about to maintain the Accounts and Transactions details information. ING has distinctive assets from legacy Source Systems into Operational data Store (ODS) and transforming them into the Data Ware-House and accumulating into Data Marts using IAA Business Model using INFORMATICA. The data cleansing process is done at Stage, HUB, Warehouse, Info HUB levels and finally loaded into the ODS and Data Marts. Balance Controls and Error Recycling Process takes place at each level to validate the ETL Process and to provide accurate and valid data for the customers.

Responsibilities:

  • Scheduling meetings with the business users to gather the business analysis reporting requirements.
  • Extensively used ETL to load data from DB2, SQL Server, Sybase databases and Flat files to e-business application database.
  • Involved in Designing and creating mappings and mapplets using Informatica Source Analyzer, Warehouse designer, Mapplet Designer &, Transformation Designer.
  • Used all Transformations mostly as Expressions, Filters, Joiners, aggregators, Lookups and Routers to load consistent data into Database.
  • Worked with Informatica Workflow Manager to create Workflows, database connections, sessions, and batches to run the mappings.
  • Developed Transactions for ACES (source system) data.
  • Involved in Dimensional Modeling Techniques to create Dimensions, Detail Fact and summary fact tables.
  • Monitoring the workflow performance and status with Workflow Monitor.
  • Developed Various Command Tasks to automate the Pre session jobs.
  • Used various Performance Tuning techniques to improve the load.
  • Designed and Developed Dynamic SQL Scripts in DB2 UDB.
  • Have written complex SQL Queries involving multiple tables with joins.
  • Involved in Converting SQL/Procedures and SQL Loader scripts to Informatica mappings.
  • Tuning PL/SQL procedures and Functions with different utilities like EXPLAIN PLAN.
  • Scheduling the Workflows and sessions for daily loads.
  • Automation of FTP process to and from source systems.
  • Involved in writing UNIX shell scripts and PL/SQL procedures, Pre-session and Post- Session Scripts.
  • Used PMCMD to interact with Informatica workflow.
  • Have very good experience in developing Control M jobs to schedule the informatica jobs.
  • Have Good experience in IBM DB2 Export/Load utility Scripts.
  • Involved in consolidated error processing mechanism.
  • Extensively worked with Test Director in QA and Volume Environments.
  • Involved in Informatica Version upgradation from 6.2.2 to 7.1.4
  • Defeats created by users involved in different source systems and re implementing them in production and providing valid data with user acceptance.
  • Involved in small other projects and working in Production Support

Environment: IBM DB2 UDB 7/8/8.1, Sun Solaris 8, Power Center 6.2.2/7.1.4, oracle 8/9, SQL Loader, Erwin, Business Objects 6.x and XML, SUN FIRE 10000, Mercury Test Director

Confidential, Parsippany, NJ Mar’03 – June’04
Business Intelligence System - Data Warehouse Developer

The project main objective is to create a central database and provide a set of standard reports. It extracts data from legacy systems through flat files, Mainframes data, transforming and loading into Oracle target database using Informatica Power Center

Responsibilities:

  • Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy (Informatica 6.1 is used) & Dimensional modeling.
  • Extensively used Informatica Power Center Client Tools – Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Informatica Repository
  • Developed Mappings between source systems and Warehouse components.
  • Developed mapplets, mappings and configured sessions.
  • Extensively used almost all the transformations.
  • Created reusable transformations and mapplets to use in multiple mappings.
  • Used debugger to test the data flow and fix the mappings.
  • Created and monitored workflows and tasks using Informatica Power Center Work flow Manager.
  • Managed Informatica Workflow Manager and Workflow Monitor.
  • Involved in designing the Data Model using Erwin and integrating E - R models with the Oracle Database.
  • Created global repository, Groups, Users and assigned privileges using repository manager.
  • Developed Unix scripts to automate the Data Load processes to target Datawarehouse.
  • Created reports using Business Objects
  • Developed Universes using Business Objects Designer based on business requirements to feed the reports.
  • Created various queries using Business Query.
  • Publishing reports on the web browser as well as saving reports in corporate environment.
  • Created the reports (Master/Detail, Cross tab, Chart templates) in Business objects and Web Intelligence using the universes as the main data providers and writing the complex queries including sub queries
  • Created, modified, maintained the business complex reports using business objects reporting module.
  • Involved in generation of complex reports charts based on functional specifications using Business Objects documents for inquiry transactions from database.

Environment: Informatica Power Center 6.1/6.2, Business Objects 5.1/6.0/6.1, Web Intelligence2.6/6, DB2, Oracle 9i, SQL, PL/SQL, ASP, Erwin and UNIX Shell Scripts.

Confidential, (Pharmaceutical Company), Alpharetta, GA Mar’02 – Jan’03
Operational Data Store - Data Warehouse Developer

This project is an extraction of data from SIEBEL and legacy systems and building the common operational data store (ODS) and Analytical Data Store (ADS)

Responsibilities:

  • Analysis of Source, Requirement, existing OLTP system and Identification of required dimensions and facts from the Database.
  • Identified business rules for data migration.
  • Parsing high-level design spec to simple ETL coding and mapping standards.
  • Involved in designed new database tables to meet business information needs. Design Mapping document, which is a guideline to ETL Coding.
  • Worked on Informatica Power Center 5.1 tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
  • Using Informatica Designer designed Mappings, which populated the Data into the Target Star Schema, which is on Oracle 8i Instance.
  • Used Workflow Manager (Server Manager) for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time.
  • Maintained and improved integrity by identifying and creating relations-ships between tables.
  • Shell Scripts and PMCMD to interact with Informatica Server from command mode.
  • Created Daily Reports, Dynamic Reports and Ad-hoc Reports.

Environment: Informatica Power Center 5.1 on HP-Unix, DB2, Oracle 8i (Staging, Data Warehouse), Toad (Oracle Query Tool), XML, HTML, Erwin (Data Modeling), Cognos Impromptu and Power play 6.6, Power Play Web viewer, Power Play web explorer.

Confidential, Birmingham, AL Mar’01 – Oct’01
Central Data Warehouse - Data Warehouse Developer

This project was built with an objective to help top-level management is decision making. The data from different departments is collected and integrated into a data warehouse which has been sent to data marts that are built based on subject areas.

Responsibilities:

  • Involved in designing the target Data Warehouse using Star Schema.
  • Extensively used Informatica Power Center in Extraction, Transformation and Loading (ETL) Process.
  • Created Dimension Tables and Fact Tables based on the warehouse design.
  • Wrote Triggers and Stored Procedures using PL / SQL for Incremental updates.
  • Created necessary Repositories to handle the metadata in the ETL process.
  • Created the Source and Target Definitions in Informatica Power Center Designer.
  • Created Reusable Transformations and Mapplets to use in Multiple Mappings.
  • Created Sessions and Batches using Server Manager for data movement through Mappings.
  • Created reports using Business Objects.
  • Built Universes using Business Objects Designer to feed the reports.
  • Performed Drill down and Slice and dice operations in business objects.
  • Created various queries using Business Query.
  • Customized Info View portal in Web Intelligence.
  • Implementing security among the Business Object tools using Supervisor.
  • Scheduled and refreshed reports using Broadcast Agent.
  • Creating various financial reports as per the requirement.

Environment: Informatica Power Center 5.0, Oracle8i, Business Objects4.x/5.1, Web Intelligence 2.5 and Windows NT

Confidential, Norway Feb’00 – Mar’01
Oracle/Web Developer

This project is complete, well arranged and centralized management system for internal filing and distribution of SDSs. As chemical card index for raw materials and finished products, and it will also be filing system for former versions of our SDS

Responsibilities:

  • Designed Database and Functional Flow Diagram.
  • Written PL/SQL Procedures in oracle 8.0.5.
  • Created Web interface screens using ASP, JavaScript, VB script, visual Studio
  • Involved in creating Components by using VB 6 DLL.
  • Developed Error Handling and Error hook application
  • Created MSI packages for Support libraries.
  • Created Crystal Reports 7.0.
  • Involved in Setting Configuration Files.
  • Involved in production support and help desk

Environment: VB6.0, ASP, Visual Studio, Oracle 8.0.5, COM/COM+, Windows 2000

Confidential, Oslo, Norway Dec'99-Feb'00
Web Developer/SQL server

The purpose of this project is to provide a tool that gives salespeople the ability to add new cellular customers from any location where the Internet is available.

Responsibilities:

  • Designed and developed web pages using HTML, VBScript, JavaScript, ASP
  • Used COM + Technology and VBScript to achieve functional specifications
  • Used ADO 2.0 objects to handle the database
  • Created stored procedures in SQL Server and used in web pages
  • Development of COM objects using VB 6.0, installed packages in MTS
  • Created various sessions and design database
  • Performed Production support and Help Desk on weekly basis.

Environment: VB6.0, ASP2.0, Visual InterDev6.0, SQL Server 2000, Transact SQL, COM/COM+, MTS 2.0 , and Windows 2000, IIS 6.0

Confidential, Phonm Penh, Cambodia Mar’99-Nov’99
System Developer & Support

This Project(Smart suite) is basically Smart Card based application, which is a ideal solution for Payroll system and Attendance monitoring

Responsibilities:

  • Collected requirements and prepared requirement specifications.
  • Designed and developed in VB 5.0
  • Created smartcard interface using visual basic DLL.
  • Installed Smartcard Readers.
  • Involved in documentation, implementation and testing of the system.
  • Written views and functions in Oracle 8.0.
  • Generated various reports.
  • Involved in offshore support

Environment: VB 5.0, Oracle 8.0, Smartcard Reader

Confidential, Bangalore Jan'98-Jan'99
Programmer/Analyst

This Project is a Client-Server Architecture for computerizing Horticultural Producers Co-operative Marketing and processing Society.

Responsibilities:

  • Involved in documentation, implementation of the system.
  • Designed and created database tables in Oracle and user interface forms by using Visual Basic.
  • Written views and functions
  • Generated various reports using Crystal reports 4.5.

Environment Visual Basic5.0, Oracle 7.3

Education

Master in Computer Science

Hire Now