SUMMARY:

ETL/Informatica and Oracle/Teradata/DB2 Developer with over 11+ years of experience, expertise in Dimensional Data Modeling and Data Warehouse Architecture with the last five years focusing on data warehousing in a Cognos/DB2/Oracle environment within the Financial, Telecommunications, Pharmaceutical, and Retail industry. Additionally, have excellent user interface and communication skills.

TECHNICAL SKILLS:

• ETL
• Informatica 5.1/6.1/7.1/8.6
• Power Exchange 5.2.2
• Business Objects 6/XIR2
• Cognos
• Impromptu
• Oracle
• PL/SQL
• SQL Server 2000
• DB2
• DTS
• BCP
• Import
• Export
• Java
• Visual Basic 6.0
• SQL
• SQL*Plus
• ERWin
• Oracle Designer
• WebLogic
• Application Server
• Servlets
• Javascript
• HTML
• Forms 6i
• Reports 6I
• Window NT
• WINDOWS 98
• Sun Solaris
• UNIX
• Shell Scripting
• Navigator and TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

ETL Lead Developer

Responsibilities:

• Manage a Team of 6 developers in an Agile Environment.
• Interfacing with business, source system subject matter experts in translating business requirements To technical solutions.
• Interfacing with Enterprise Data Architecture team in resolving ETL Architecture bottlenecks.
• Work with business and technical teams on Data validation rules to populate ODS store.
• Extraction of data from ODS to Enterprise Datawarehouse EDW on Netezza.
• ETL Architecture and Solution effort in an agile envi ronment spread across 8 teams.
• Design and development of Integrating 4 different sources as it relates to Mortgage backed Securities.
• Worked with SOA Teams in deploying ETL Solutions that are based on Event Driven Architecture.
• Orchestration of ETL Workflow based on Real Time push and pull methodology.
• Setting up of JMS Message Queue for the ETL Teams to facilitate writing to TOPICS and QUEUE.
• Worked with Deployment Teams in setting up Jenkins for Migration of code to 6 different environments for a team Of 30 ETL Developers.
• Development of ETL Design Patterns for Integration.
• Resolution of code defects and support the testing team.
• Interfacing with Architecture team, Source System experts and Business teams in addressing issues impacting successful product development.
• Consuming Data from External Web Services API through REST protocol using TIBCO.
• Setup SVN Components and Jenkin pipelines for Informatica and Abinitio code base to cater to different environments.
• Implementation of Cucumber testing framework for the project.
• Unix Autosys scripts development.

Environment: Informatica 9.6.1 (PowerCenter), XML, JMS Queues, SOA, Informatica DT Studio, Oracle 10G, Visio, TOAD, Linux, UNIX Shell Scripting, SQL, PL/SQL, Autosys, Cucumber, TIBCO, Hadoop, PIG.

Confidential, Washington, DC

Senior Informatica Developer

Responsibilities:

• Worked with Informatica Java Transformation to load Oracle BLOB Data in zip file format.
• Worked with Informatics XML Transformation to parse XML Data stored in Oracle XML Database.
• Worked extensively with SOAP webservices using Informatica http transformation.
• Worked with Informatica Power Exchange adapters to connect to Analytical database.
• Create and troubleshoot Control M Jobs for Informatica and Oracle Packages.
• Troubleshoot Existing Informatica mappings and Performance bottlenecks.
• Troubleshoot Existing Oracle packages performance bottlenecks.
• Created Informatica ETL Exception handling Routines.
• Troubleshoot Informatica server problems and applying hot fixes.
• UNIX Shell Scripting.
• Informatica Production support and troubleshooting production related errors.
• Extensive Analysis and testing of SSIS mappings before converting to Informatica.
• Troubleshooting of SSIS Mappings in production.
• Enhancements to SSIS Mappings.
• Source System Analysis and data profiling.
• Create DQ Metrics for the Source system to Identify potential data issues.
• Understand Existing logical/physical data models for Warehouse.
• Performane troubleshooting of Existing PL/SQL Code.
• Creation of Cognos Reports and Modifications to Semantic Layer through Cognos FM.
• Configuration of Analytical database on Informatica Platform.
• Developed and Published Packages in Cognos Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements.

Environment: Informatica 9.1 (PowerCenter), SSIS, XML, Cognos 8, Informatica Data Quality, Paraccel Analytic Database, Oracle 10G, Visio, TOAD, Linux, UNIX Shell Scripting, SQL, PL/SQL, Control - M

Confidential, Miami, FL

Senior Informatica Developer

Responsibilities:

• Assist business partners in requirements gathering.
• Define logical/physical data models for operational data stores. Work with the DBAs on implementation.
• Document and maintain the data dictionary, estimating data volume and data growth.
• Defining data standards, data security and data audit standards.
• Interface with the Project Management and design teams early in the development effort in order to understand the scope of the business problem and its solution.
• Designed and developed complicated ETL mappings using Informatica PowerCenter.
• Optimizing ETL and Database performance issues.
• Advanced knowledge of UNIX and Shell Scripting (Sed and Awk).
• Wrote PL/SQL Functions and Procedures to be called from BO Universes.
• Integrating XML Schema generation into Informatica Repository.
• Extensively worked with XML and Informatica Integration.
• Extensively Worked with SAP RFC Using Informatica.
• Creation of Conceptual, Logical and Physical Modelling using ERWin.
• Creation of BO Reports.
• Developed VB Macro’s for generating Excel Based Reports from Excel Templates using BO Reports as source.
• Developed Dashboards Integrating SAP into Xcelsius
• Designed and Developed Data marts and Aggregation tables decommissioning SAS application.
• Migration of SAS Code and Data into Oracle Data warehouse using Informatica.
• Creation of Business Objects Universe and Reports to phase out SAS Reports.

Environment: Informatica 8.6(PowerCenter), XML, SAS, MDM, Metadata, SQL Server 2005, SSIS, Oracle 10G, Visio, TOAD, AIX, UNIX Shell Scripting, SQL, PL/SQL, SQL Loader, Business Objects XI, Excel Reports, Xcelsius.

Confidential, Miramar, FL

Technical Lead ETL

Responsibilities:

• Ability to understand existing architecture and create High / Low Level ETL Design for future solutions.
• Work closely with Solution architect/Enterprise data modeler for design of Data mart or Data warehouse, prepare technical design /specifications, creating proto types, and study data cleansing needs.
• Interact with users for analyzing, cleansing and loading of data into the warehouse.
• Development of metadata required for the DW.
• Expert knowledge of data warehouse implementation process; from business requirements through logical modeling, physical database design, data sourcing and data transformation; data loading, SQL end-user tools, database and SQL performance tuning.
• Designing creating and tuning physical database objects (tables, views, indexes) to support normalized And dimensional models. Maintain the referential integrity of the database.
• Perform Informatica code reviews and act as a gatekeeper for all migrations to production environment
• Handling overall Informatica project deliverables and ensuring projects are on time
• Building the ETL/Informatica process to meet product specific requirements
• Participates in the development and preparation of Informatica documentation for procedural; program and user documentation.
• Extensive Report development Using Hyperion Brio.
• Javascript Programming for Hyperion Brio Reports.
• Analyze ETL/Informatica application and data integration problems, provide solutions and recommend corrective actions.
• Data Loading from SQL*Loader and troubleshooting existing SQL Loader routines.
• Advance UNIX shell scripting using awk and sed.
• Enhancements and Modifications to Informatica Mappings
• PL/SQL enhancements and Modifications.
• Identifying and trouble shooting SQL Performance bottlenecks.
• Technical Production support for Informatica and PL/SQL.
• Perform code reviews for all migrations to production environment
• Handling overall project deliverables and ensuring projects are on time
• Building the ETL/Informatica process to meet product specific requirements
• Participates in the development and preparation of documentation for procedural; program and user Documentation

Environment: Informatica 8.1.1(PowerCenter), Oracle 10G, Visio, TOAD, AIX, UNIX Shell Scripting, SQL, PL/SQL, SQL Loader, Hyperion Interactive Reporting, Essbase, Javascript, Windows NT, Tivoli, Remedy Change Management.

Confidential, Miami, FL

Informatica Lead/BO Administrator

Responsibilities:

• Extensive experience defining ETL architecture solutions with data movement (ETL/informatica) processes.
• Enhancement, performance tuning and documenting Informatica components.
• Informatica code reviews, standards implementation, QA.
• Informatica project deliverables and ensuring projects are on time
• Building the ETL/informatica process to meet product specific requirements
• Participates in the development and preparation of documentation for procedural, program and user documentation
• Analyze application and data integration problems, provide solutions and recommend corrective actions.
• Expert knowledge of data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, end-user tools, database and SQL performance tuning.
• Support and Enhancement of Oracle Stored Procedures and Packages.
• Troubleshoot and Optimize Oracle Stored Procedures and Packages.
• Designing, creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models. Maintain the referential integrity of the database.
• BO Administration, troubleshooting, User creation, Security (LDAP) and maintenance.

Environment: Informatica7/8(PowerCenter), Oracle 10G, Business Objects 6.0/XIR2, PL/SQL, Visio, TOAD, AIX, DB2, Windows NT, Tidal, Change Management(Remedy).

Confidential, Madison, WI

Informatica / Business Object Developer Lead

Responsibilities:

• Notifications that agencies currently view on the mainframe Agent Tickets (A6) screen. Each of the Core Policy Systems would create and write to a Notification File when they determine the need for a notification. An overnight batch process reads the records on this file and creates MQ message. When all messages have been written from all core system files, the notification data is merged as needed and transferred to a data table used by the ANS application.
• Architecting and developing Technical specifications for the overall ETL/Informatica load process.
• Data Modeled ETL/Informatica Structures to reflect ODS and Warehouse from the Mainframe source system.
• Developed Informatica maps for the above technical specifications.
• Wrote Complex SQL’s.
• Tuning of the Informatica Maps.
• Worked with VSAM Files in Real time using Informatica Power Exchange.
• Developing Informatica Mapplets for logic commonly applicable across the enterprise warehouse.
• Developing Informatica Mappings for Incremental extraction and loading of data.
• Developing Informatica Mappings for TYPE1 and TYPE 2 slow changing Dimensions.
• Documenting all work using MS Visio.
• Maintaining and supporting the schedule sharing Jobs.
• Wrote shell scripts for File manipulation using extensively SED and AWK utilities.
• Writing Shell Scripts to schedule Informatica sessions through Job Scheduler.
• Writing Shell Scripts to truncate the data in staging tables.
• Universe Design based on Transactional system.
• Dealing with complex Business Objects variables in the universe and report level.
• Business Objects Graphics experience including drills on graphs.
• Excellent organizational skills to develop the best plan for Business Objects report conversion.
• Expert in Business Objects derived variables, worked with @ functions in the Business Objects universe.
• Skilled with Business Objects multiple data providers.
• Business Objects multiple hierarchies with same top point.

Environment: Informatica7/ 8(PowerCenter), Power Exchange 5.1, DB2UDB, Oracle 10G, Business Objects 6.0/XIR2, Visio, TOAD, AIX, DB2, Windows NT

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Establishing and enforcing internal Informatica governance and technical standards for ETL/Informatica developers
• Provide administration and first line support for the deployed Informatica processes.
• Monitors and tunes Informatica repository and system for performance improvements
• Identifies, researches, and resolves Informatica root cause of production issues or system problems
• Participate in code-reviews to make sure that the ETL/Informatica developers are following the best practices.
• Install/Maintain Informatica PowerCenter 6.x/7.x/8.x instances on UNIX Linux servers.
• Interact with UNIX and Database Administrators to create and maintain each Informatica PowerCenter instance.
• Configure Database and ODBC connectivity to various Informatica source/target databases.
• Create and manage users, groups and folders and ensure appropriate privileges are assigned to the different users in the Informatica Repository...
• Interact with end users to resolve issues with Informatica PowerCenter
• Performance tuning covering the areas of session, source, target Informatica mappings.
• Perform Informatica project code deployment between environments.
• Help new Informatica projects get started.
• Manage the production Informatica Server environment and production Informatica repositories.
• Documenting all Informatica work using MS Visio.
• Maintaining and supporting the schedule sharing Jobs.
• Writing Shell Scripts to schedule Informatica sessions through Control - M.
• Writing Shell Scripts to truncate the data in staging tables.
• Demonstrating to the End Users the Business Objects Report Creation and Universe Design.

Environment: Informatica 7.2 / 6.2 (PowerCenter / PowerMart), Power Analyzer 3.5, Business Objects 6.1, DB2 UDB, Oracle8i, Control - M, Visio, TOAD, UNIX-Linux, Windows NT.