Senior Informatica Developer Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Jason Jones

Ph: 810-610-7123

jasonjones@yahoo.com

ETL-Informatica Developer

Summary:

·         Overall 8 years of IT experience in the Business Analysis, Design, Data Modeling, Coding, Implementation and Testing of Applications using wide range of Technologies including Data Warehousing, Database and reporting systems for Banking, Finance, HR, Retail Sales & Distribution and Telecom Industries.

·         Five years of Datawarehousing experience using Informatica Power Center 9.1.0/8.6/8.5/8.0/7.x/ 6.2/5.0, Power Connect, Power Exchange and extracting data from Oracle, MS SQL Server and MS Access.

·         Experience in developing the conversions and interfaces for SAP  by using Power Center 8.5.(SAP BW Infospoke & Infosource)

·         Worked with RFC, BAPI and IDOC in SAP-ABAP .

·         Experience in Relational Data Modeling and Dimensional Data Modeling using Star Schema and snowflake schema, Physical and Logical Data Modeling, Erwin 4.0/3.x, Oracle Designer.

·         Sound knowledge of Oracle 9i/8i/8.0/7.x, DB2, MS SQL Server 2008/2005/2000, MS Access 2000, PL/SQL, SQL*Plus.

·         Having 5 years of experience in developing PL/SQL functions, stored procedures for processing complex data calculations.

·         Experience in Unit Testing, UAT, Integration Testing for the Conversions and Interface objects.

·         Worked with IDE (Informatica Data Explore) and IDQ (Informatica Data Quality) for cleansing and exploring the data acquired by the Conversions object.

·         Experience in Installation and maintenance of Power Center and Power Exchange on Windows and Unix operating systems.

·         Extensive experience in UNIX shell scripting (Ksh/Csh), Job scheduling using Crontab.

·         Analyzed data sources and targets using Informatica Data Profiling option.

·         Experience in Dimensional Data Modeling using Immon & Kimball methodology.

·         Designed complex Mappings and expertise in Performance tuning.

·         Implemented all SCD types (Slowly Changing Dimensions), with out history, complete history, and recent history.

·         Ability to understand the business environment and translate business requirements into technical solutions.

·         Excellent analytical, programming abilities to create elegant, flexible and maintainable solutions for complex development problems.

·         Effective team effort skills with good written, verbal communication and presentation skills. Self-motivated with result oriented approach.

Technical Skills

Data Warehousing& BI                 : Informatica Power Center 9.1.0/8.6.1/8.6/8.5/7.x/6.x/5.x,OLAP,

OLTP, Power Exchange, Power Connect

Reporting Tools                            : Business Objects XI R2/6.x/5.x., Crystal Reports 2.5

ERP Tool                                          : SAP-BW/ABAP.

Databases                                     : Oracle 9i/8.x/7.x, MS SQL Server 2008/2005/2000, MS Access,

Dbase IV.

Programming                                : C, UNIX Shell Scripting, PL/SQL, Visual Basic 6.0.

Environment                                : UNIX, Windows

Other tools                                                   : Perforce, Toad, Sharepoint, Microsoft Visio/Excel, 

L, DHTML,

            JavaScript, Adobe Photoshop, Flash MX, Front Page

Professional Experience

Client: Saxon Mortgage, Irving, TX                                                                      Jan ’09 – Till date

Role: Senior Informatica Developer

Project Description: Saxon Mortgage is the Mortgage company which deals with the finance and loans. Providing the vast analysis of the Loans from different banks and loan status is the main scope of the Project. To accommodate the data from the different service providers in place of existing service provider is also the role of the project. Datawarehouse is build using SQL Server 2008/2005. Merging of data from 2 different service providers in to one database as staging area (ODS) and building the mappings from ODS to Datawarehouse is the Project scope.

Responsibilities:

·         As a developer played a key role in the designing the data modeling for the Datawarehouse and staging area to accommodate the data from the different service providers and implemented the mappings in Informatica to upload the data from different sources in the EDW.

·         Involved in analyzing the data from existing service provider and developed a matching criteria to accommodate the data from new service provider.

·         Worked with Informatica creating mapping and mapplets using various transformations like Joiner, Filter, Aggregator, Lookup, Application Source Qualifier, Router, Sorter, Rank, Normalizer, SQL Transformation, Stored Procedure and Update Strategy.

·         Developed the SCD TypeII Methodology mappings to upload the data in the Dimension tables in the EDW.

·         Extensively worked with Designer to manipulate source definitions, create Mappings, Mapplets.

·         Created workflows using Session, Command task, Event waits, Decision task, Control task, Email task and Timer.

·         Worked with Power Exchange to upload the data from Cobol Files into SQL Server by extensive use of Normalizer transformation.

·         Involved in the creating copy books to upload the data from Cobol Files.

·         Worked with SQL Stored Procedures and converted the logic to put in Informatica to integrate the data from different databases.

·         Identified and resolved performance issues in Informatica Power Center mappings and workflows.

·         Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.

·         Involved in Unit Testing, UAT and Integration Testing with extensive knowledge of Testing concepts.

·         Involved in developing the Test scenarios, Test Cases and Test Data to assist the QA Team.

·         Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions

·         Worked with Production team to solve most of the Production Support Tickets.

·         Developed the Documentation for all the mappings/workflows, and also developed the run books which were extensively helpful to the Production support team for all the recovery situations.

Environment: Informatica Power Center 9.1.0/8.6/8.6.1, Informatica Power Exchange 8.1.1, Informatica Power connect, SQL Server 2008/2005, Flat Files, PL/SQL, Perforce, VSS, SharePoint.

Client: BNSF Railways, Fortworth, TX                                                                      Jan ’08 – Nov, 08

Role: Senior Informatica Developer

Project Description: The BNSF Railways, headquartered in Fort Worth, Texas, is one of the four remaining transcontinental railroads and one of the largest railroad networks in North America. BNSF Railways is goods carrier railways covered wide area in USA. SAP has been implemented in place of Legacy systems (Mainframes, DB2, etc.). The major modules like Finance and HR were implemented. The scope of the project is to build the Interfaces between legacy systems and SAP. The purpose of this project is the enhancement of the Envision to provide external and internal users with reliable, timely and accurate data that can be easily analyzed. Accuracy and fast delivery are paramount to the success of this project, as financial teams continuously monitor the content the moment the information becomes available

Responsibilities:

·         Played a key role in designing and developing ETL model for the (Finance and HR & Payroll)project.

·         Analyzed data sources and targets using Informatica Data Profiling option.

·         Created mapping and mapplets using various transformations like Joiner, Filter, Aggregator, Lookup, Application Source Qualifier, Router, Sorter, Rank, Normalizer and Update Strategy.

·         Extracted data from sources such as VSAM, DB2 and loaded the data into SAP using BAPI'S,RFC’s,IDOC’s.

·         Worked extensively for developing mappings to build Interfaces and Conversions between Legacy and SAP.

·         Created mappings using the transformations RFC, BAPI and IDOC’S to connect to SAP.

·         Worked with SAP BW (Infospoke & Infosource).

·         Extensively used SAP-RFC/BAPI Transformations and IDOC Interpretor and IDOC Preparator.

·         Migrated the legacy PL/SQL code functionality into a mappings using Informatica Power Center 8.5.

·         Involved in Unit Testing, UAT and Integration Testing of Conversions and Interface objects.

·         Involved in Data Analysis for the conversion object with IDQ and IDE.

·         Identified and resolved performance issues in Informatica Power Center mappings and workflows.

·         Defined structure of dataflow for seamless migration from large mix data systems.

·         Writing UNIX Shell Scripts for processing/cleansing incoming text files.

·         Developed the Technical Specifications based on the Functional Specification understanding the business rules and requirements.

·         Designed and implemented complex data transformation mappings using Informatica PowerCenter.

Environment: Informatica Power Center 8.5, Informatica Power Exchange 8.1.1, Informatica Power connect, DB2, VSAM, SAP R/3 7.1, SQL Server 2000, Flat Files, Jay SQL, TOAD 9.0, SAP R/3, SAP BW/ABAP,PL/SQL, UNIX, WindowsNT4.0

Client : Central Bank, Jefferson City, MO                                              Feb'07 – Jan ‘08

Role : Informatica Developer        

Project Description: Central Bank is one of the nation's largest bank-based financial services companies, with assets of approximately $45 billion. Central Bank provides investment management, retail and commercial banking, consumer finance, and investment banking products and services to individuals and companies throughout the United States. The project scope is to build several reports from several universes using Oracle 9i as the data source. The data is built from data received from various other branches in the US.

Responsibilities:

·         Extensively worked with Designer, Workflow Manager, Workflow Monitor and Repository Manager.

·         Extensively used Designer to manipulate source definitions, create Mappings, Mapplets.

·         Converted procedures into mappings using various transformations like Source Qualifier, Expression, sorter, Update Strategy, Filter, Lookup, Aggregator etc.

·         Created extract mappings and load mappings

·         Altered mappings to accommodate new business requirements due to single instance impact at the source.

·         Validation of Informatica mappings for source compatibility due to version changes at the source.

·         Implemented Type1 SCD Methodology.

·         Extensively used Power Exchange to integrate different source of application and extract the data from different sources.

·         Worked on database connections, SQL joins, aliases, views, aggregate conditions, used SQL and PL/SQL code to implement business logic in Oracle.

·         Created and refreshed repositories for test phase’s crp1, crp2, uat with prod repository.

·         Trouble shooting of long running sessions and fixing the issues.

·         Created workflows using Session, Command, and Email tasks

·         Experienced with Installation and maintenance of Power Center, Power Exchange on Unix Platform.

·         Monitoring of workflows and running of workflows by changing the incremental windows for test purposes.

·         Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions

·         Report Migration from Business Objects 6.5 to Web Intelligence XIR2

·         Design new  Universe Objects  to accommodate new business requirements

·         Created new joins ,Pre Defined Filters in the Designer and added them in the right contexts

·         Created new  Desk reports  and Web reports   as per user requirements

·         Created ad hoc and canned reports involving sections, blocks, filters, breaks, alerts.

·         Created new connections in the Designer for Development purpose. Developed objects in the universe using some calculations on existing columns in database tables.

·         Developed objects in the universe using with calculations on existing columns in database tables.

·         Resolved various production tickets

·         Scheduled reports to be delivered to the users mail boxes.

·         Created groups in Central Management Console and added users to the groups

Environment: Informatica 7.1/8.x, Oracle Data integrator (ODI), BO XI R2, Oracle 9i, PL/SQL, SQL Server 2000, Windows XP, Unix.

Client :  Schering-Plough, Kenilworth, NJ                                                       Apr’06- Feb'07

Role : ETL/Informatica Developer

Project Description: Schering-Plough is a global pharmaceutical company providing a steady flow of innovative medicines that improve health and well being of people around the world. The project is focused on gathering Customers, Products and Orders Data and Loading it into Warehouse for analysis.

Responsibilities:

·         Created Mappings, Mapplets and Transformations using ETL tool Informatica Power Center/Mart.

·         Created Source Qualifier, Filter, Expression, Router, and Update strategy transformations.

·         Converted procedures into mappings using various transformations like Source Qualifier, Expression, Sorter, Update Strategy, Filter, Lookup, Aggregator etc.

·         Integrated data from Oracle Financial system to Data Warehouse.

·         Experience with Installation and Configuration of all Business objects modules.

·         Used Business Objects 5.1.2 for developing reports

·         Developed Hierarchies to support drill down reports

·         Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill-down, @Functions, Cross Tab, Master/Detail and Formulas etc.

·         Exported the Business Objects reports to WEBI 2.6 to be viewed by all users on the intranet.

·         Involved in creating reports on the web using Business Objects Web Intelligence 2.6

·         Developed, implemented and maintained Universes using Business Objects Designer.

·         Created several simple, complex and Ad hoc reports for various Portfolios using Universes as the main Data Providers.

·         Created Master Detail and Cross Tab reports to view the data in an analyzed way.

·         Involved in formatting the reports to the user requirements. Extensively used the Drill mode and the Slice and Dice tools to modify the reports accordingly.

·         Tuned the reports for better performance using SQL and PL/SQL.

·         Tested the created reports and modified the relevant object(s) in the Universe.

Environment: Informatica 6.1, Business Objects 5.1, Broadcast Agent and Web Intelligence2.7, SQL Server, PL/SQL .

Client :  Sprint/Nextel Wireless, VA                                                         Mar’05- Dec'05         

Role :  ETL Developer

Project Description: Sprint/Nextel Wireless is one of the leading providers of unprecedented mobility solutions to their customers, as their services ranging from wireless communications services to IP broadband services. The scope of the project is to design and build universes for decision support and then to generate reports for the analysis of personal phone usage data. The application provides customers with a means for tracking their call time in the billing cycle and their liability. The generated reports provide users with their detailed customer information, Billing information, Account details and Service usages.

Responsibilities:

·         Created new mappings and updating old mappings according to changes in Business logic.

·         Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).

·         Used ETL (Informatica) to load data from source to ODS.

·         Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.

·         Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.

·         Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.

·         Used Debugger to troubleshoot the mappings.

·         Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.

·         Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.

·         Defined Target Load Order Plan for loading data into Target Tables.

·         Prepared Unit Test Cases.

·         Generated various reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas as per client requirements.

·         Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Informatica Power Center 6.x, Business Objects 5.1, Crystal Reports, CMC, ORACLE 8i and windows 2000.

Client : Bristol-Myers Squibb, Princeton, NJ                                                             Jan, 04 – Feb, 05

Role: Informatica Programmer

Project Description: Bristol-Myers Squibb Co. is one of the biggest Pharmaceutical Companies. HR@BMS project is regarding the total HR data of organization. It provided access to Managers and HR Generalists when they logged into web based on their role. The total HR data is extracted from Oracle Database to Data Warehouse using Informatica and PL/SQL stored procedures. Reports in the web were created by calling the stored procedures in Oracle.

Responsibilities:

·         Converted the business requirements into technical specifications for ETL process.

·         Involved in creating Star schema in dimensional data modeling using Erwin.

·         Populated the Fact and Dim. Table of data warehouse from various sources like Oracle, Ms Access, Flat files and XML files.

·         Created staging tables to do validations against data before loading data into original fact and dim. Tables.

·         Configured Informatica Power Center Server and Client components.

·         Extensively used Update Strategy and Lookup transformations for updating the target tables and also extensively used the Debugger to check the data flow and the mappings were modified depending on the requirements.

·         Handled alerting mechanisms, system utilization issues, performance statistics, capacity planning, integrity monitoring, population and maintenance.

·         Designed and developed complex Aggregator, Joiner, Router, Lookup and Update strategy transformation rules.

·         Created sessions, database connections and worklets using Informatica server manager.

·         Involved in performance tuning by identifying bottlenecks, eliminating them and tuning the SQL used in Transformations.

·         Used Pre-session and Post-session procedures to Drop and recreate indexes while the session runs to improve performance while loading to the target.

·         Created session partitions to increase the performance of Informatica Server Manager.

·         Created Stored Procedures using PL/SQL to extract the existing HR data from SAP tables and to load the data in to the Fact and Dim tables of Data warehouse.

·         Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.

·         Automated the daily scheduling of ETL process for populating the data warehouse.

·         Scheduled the ETL jobs daily, weekly and monthly based on the business requirement.

Environment: Informatica 5.x, Oracle 8i, Windows NT, MS SQL server 2000, PL/SQL, UNIX Shell scripting

Client: Global Trust Bank, India                                                                                              Dec, ‘02-Dec, ‘03

Role: Database Analyst

Project Description: Developed software for keeping track of checking account, savings account, Investment Information and responsible for generating reports. Involved in the design phase and responsible for creating GUI interface for the personnel information system module. The system includes the software application tools development to convert data from dbase IV to oracle and generation of reports by using Oracle tools

Responsibilities:

·         Involved in design, development and implementation.

·         Responsible for development of forms and interfacing the data selection from the database.

·         Created various GUI for the personnel Information System Module.

·         Assisted in developing reports on Branch turnover and profits.

·         Assisted in the Development of several reports including tabular, master detail, daily reports.

Environment: Oracle 6.x/7.x, Forms 4.5, Report 2.5, Visual Basic, Crystal Report, Windows NT/95/98.

Education:

              Bachelor of Science in Computer Science.

              Master Diploma in Software Engineering.

References:

Available upon Request.

Additional Info

Career Information

Most recent employer

-

Relevant work experience

7+ to 10 Years

Highest Education

Bachelor's Degree

Career Level

Experienced (Non-Manager)

Availability

Within 2 weeks

Location

US-TX-Fort Worth

Relocate

Will Relocate

Travel

Up to 25% travel

Willing to work weekends

-

Active security clearance

No

Willing to work shifts

-

Target Job

Company size

-

Desired status

Job type

Temporary / Contract / Project

Salary

-

Locations

US MN Minneapolis
US NY Buffalo
US PA Pittsburgh
US TX Austin
US TX Dallas
US TX Houston
US TX San Antonio
US TX Waco
US TX Wichita Falls
US WI Madison
US WI Milwaukee
US MN St. Paul
US TX Fort Worth

Work authorization

US - I am authorized to work in this country for any employer.

Job titles

Informatica Developer

Industry

Banking
Financial Services
Telecommunications Services

Occupation

Database Development/Administration

Download Resume Format