SUMMARY

• Ten years of experience on large Data Integration and Business Intelligence Projects. I have experience with application design, database design, data modeling, data conversions, data integrations, data warehousing and business Intelligence. I have extensive experience with relational databases.
• Experience working with various clients ranging from Health Care, Utility / Energy, Financial, Insurance and Pharmaceutical industries.
• Experience in all phases of the Data Warehouse Lifecycle including Requirements Gathering, System Analysis, Design, Development, and Validation of Data Marts and Data warehouses using ETL, Data Modeling and Reporting tools.
• 9+ years of extensive experience in Data Integration using SQL and ETL tool Informatica PowerCenter 8.1.1/8.6.1/9.1.0/9.5.1
• Experience in creating and developing batch related process and providing 24/7 On Call support on Batches/Jobs.
• Experience in designing and developing ETL Solutions, Informatica Workflows to support operational management of data solutions and adhering the industry best practices.
• Experience in providing production support of data solutions, including troubleshooting production failures, status notifications and on - going support of development activities.
• Extensive experience in Ralph Kimball’s Data Warehouse Methodologies and other Data Warehouses using Oracle.
• Experience in MDM and Dimensional Data Modeling to build Data Marts and Data Warehouses.
• Extensive experience in designing, developing, and implementing Extraction, Transformation, and Load (ETL) techniques on multiple database platforms and operating system environments.
• Experience in creating and maintaining Conceptual, Logical and Physical Data Models using ERWIN.
• Demonstrated experience with Agile and Waterfall Software Development methodologies.
• Experience in preparing RTM and developing Source to Target Mappings (STM).
• Experience in Risk Analysis, analyzing preliminary business needs, Requirements Gathering, gap analysis, business intelligence, project management, software design, development and validation of software applications.
• Experience Managing the Functional Releases, creating Scope document, Requirement Specification document, Project Timelines, writing Test Case Scenarios to test data and performing Reports Validation during UAT cycle.
• Experience working with Data Partners such as Verizon (VZB), National Government Services (NGS), Northrop Grumman (NG), General Dynamics (GDIT), High Point Global (HPG) when working on Data Source Files and on Trouble Tickets related to Data Quality issues and MicroStrategy Reporting issues.
• Experience in data validation and MicroStrategy Report validations to meet the end user requirements.
• Experience in creating customized MicroStrategy Reports using the MSTR objects and Metrics based on user requirements.
• Experience in Reporting tools using MicroStrategy, Hyperion, Business Objects and COGNOS. Created various Grid reports, master/detail reports, cross tab reports and charts.
• Experience in Data Analysis and Adhoc Analysis as needed to support project goals.
• Experience writing Requirements for CMS Projects.
• Extensive experience in Troubleshooting and performing RCA on tickets related to ETL Production issues and MicroStrategy Reporting issues.
• Strong mathematical and analytical skills for solving and troubleshooting technical problems.
• Excellent communication skills with Customer facing and with multiple levels of the organization and strong Work ethics.

TECHNICAL SKILLS

Data Integration: Informatica Power Center 8.1.1/8.6.1/9.1.0/9.5.1 , Informatica Power Exchange 8.1.1, SSIS.Reporting Tools MicroStrategy Web 8.01/9.2.1/9.4.1 , Hyperion 9.0 Interactive Reporting, Business Objects 6.x/XIR2, COGNOS 8

Operating Systems: UNIX (Solaris, HP-UX, AIX), Linux, MS Windows NT/2K/2003/XP

Databases: Oracle 9i/10g/11g, Sybase, Teradata, DB2, MS SQL Server, IBM DB2, Netezza

Data Modeling Tool: ER-win 4.1.4/4.1

Utilities: Toad, SQL Developer, SQL plus, Rapid SQL, Teradata SQL Assistant,NZSQL, SQL*Loader

Testing Tools: HP ALM Quality Center 8.2/11.00 Enterprise Edition, QTP 8.2, Test Director

Rational Tools: Rational Clear Case, Clear Quest, Test Manager, Robot, RUP, Rational Rose, Rational Requisite Pro

Programming: UNIX Shell Scripting, SQL, PL/SQL, C, C++, HTML, XML, ASP.NET.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. Informatica Lead Developer / Production Support / Consultant

Responsibilities:

• Experience in Gathering and Documenting Requirement Specification Document, RSD for the Functional Source Releases.
• Involved in Use Case Review Sessions and Change Control Board,(CCB) meetings for the Functional releases.
• Experience in Creating Test Case Scenarios to be used in testing the data and MicroStrategy reports, monitoring/overseeing the testing of business applications to verify that all client requirements are incorporated into the system design.
• Experience in Research, design, develop and /or modify enterprise - wide systems and/or applications software.
• Experience in writing RTM and developing Source to Target Mappings (STM).
• Experience in design, develop and support of batch related process using Informatica.
• Experience in Reviewing of all offshore deliverable and artifacts such as ETL Code review, Technical Design Review, Unit Test cases and Results.
• Experience Troubleshooting and Root cause the Trouble Tickets pertaining to ETL data issues and MicroStrategy Reporting issues.
• Experience working on Service Requests submitted by External users, developing and delivering Adhoc Reports though SQL or MicroStrategy MSTR Report.
• Experience creating customize MicroStrategy reports using MSTR objects depending on user requirements.
• Extensive Experience in monitoring and providing Production Support for ETL Loads, creating Incident Tickets related to Production Data Loads issues and analyzing the Informatica Workflows and Sessions that took longer time to complete.
• Experience in creating the SQL Delete Scripts. Worked on Production Data Re-loads due Data Quality and Source Files data issues.
• Experience in writing/modifying SQL queries.
• Experience working on Data Source Files pertaining to .CSV and XML files.
• Experience in Data Profiling, Data Standardization, Data Matching and Data consolidation.
• Experience working with Data Partners such as Verizon (VZB), National Government Services (NGS), Northrop Grumman (NG), General Dynamics (GDIT), High Point Global (HPG) and Virtual Customer Service (VCS) while working on Data Source Files and on Trouble Tickets related to Data issues and MicroStrategy Reporting issues.
• Experience in conducting the internal Trouble Ticket meetings using HP ALM Quality Center.
• Experience to Support the planning of System and development deployment, ensure Software compliance, complete testing, and document system enhancements.
• Experience in Providing technical direction and management in the maintenance and development of the MicroStrategy reporting components of the data warehouse and on Informatica development.
• Experience in MicroStrategy Enterprise Manager to support the BI projects.
• Experience in maintaining and understanding of the definitions, analysis and reporting outputs from the data warehouse.
• Experience in Analysis, Design, Development and implementation of new reporting requirements and provide estimates to support timelines and deliverables.
• Experience in Testing and verification of new reporting processes.

Environment: Informatica PowerCenter 9.5.1/9.1.0/8.6.1 , MicroStrategy Web 9.4.1/9.2.1/8.1.2 , Oracle 11.2.0.3g, Share Point 2010, HP ALM Quality Center 8.2/11.00 Enterprise Edition, Remedy BMC 11.0, Citrix Client, UNIX AIX, Microsoft Office Project 2010, Windows 7/XP.

Confidential, NY

Sr. Informatica ETL Developer / Lead / Consultant

Responsibilities:

• Responsible for developing, testing, implementing and supporting applications. Worked closely with ETL Leads/Managers.
• Responsible for the development of Informatica Mappings, workflows, development of UNIX (AIX) scripts and run documentation.
• Created AIX UNIX scripts to run ETL Informatica batches. Worked with Command line utilities.
• Used SQL *Loader in UNIX scripts to load the Stage tables from delimited Flat Files.
• FTPed the files from one server to another.
• Tested and Documented the Financial and Other Applications in development and in Production for AIX 5.3 TL10 OS Upgrade.
• Extensively worked with Financial Data. Did Load refresh for BUDGET/FISCAL Year 2011.
• Updated the Financial Hierarchy as per the Users request in development and in Production.
• Created the Migration document and listed out the objects related to Informatica and Database that needs to be migrated to Production as per Release Management.
• Worked on Request for Service, RFS from Users and created an Extract for TAX AUDIT from Integrated Electric Marketing Data Mart, IEMDM related to Revenue data.
• Loaded data into Delimited Flat File as per the requirement and created MS Access database file.
• Created a Revenue Report for Users from Electric Marketing Data Mart.
• Used DB links in SQLs. Created views from multiple source tables and used them in Informatica Mappings. Created DDLs for the Tables.
• Used BMC Remedy User Tool for creation of Tickets.
• Provided Production Support when required.

Environment: Informatica PowerCenter 7.4.1/8.5.1 , Oracle 10g/9i, SQL *Loader, MicroStrategy 8.1.1, AIX 5.3 TL10, UNIX (AIX) Scripting, Remedy 7.0.1, Text Editor, File Viewer, FileZilla FTP Client, MS Access, Windows XP.

Confidential, Marlborough, MA

ETL/ BI Developer

Responsibilities:

• Designed the Source and Target System for the ETL Process.
• Designed the File Handling from the client BioGen by using UNIX Scripts.
• Did the File Validation and File Rejection techniques on the File System.
• Extensively worked with Fixed Width and Delimited Flat Files.
• Designed and created the Informatica PowerCenter Mappings for Data Process from the File Landing Area to the Informatica Target Directory.
• Created the Parameter Files for Dynamically Handling the Source Files from the client, BioGen.
• Extensively worked with Data Cleansing Data Scrubbing Operations by using Informatica Functions.
• Followed Team Based Development for Informatica ETL Development.
• Designed the File System to send the client files to Knowledge Link (KL), a Merkle’s proprietary software for standard data Hygiene and Match Processing for Customer Name and Address Standardization as per client business need.
• Followed the Merkle Standards for Processing the Merkle Client Files.
• Used Pre / Post Process Shell commands in Informatica and extensively worked with UNIX shell scripts for File transfers.
• Created the Jobs and dependencies in Tidal Enterprise Scheduler for client Files and for Informatica ETL Workflows.
• Created the High Level and Low Level Design Documents for the Informatica Mappings.
• Followed the Standards and Requirement given by UNICA, a Campaign Tool to process the client Files as per UNICA Standards.
• Worked with UNICA tables like Individual, Address, Contact Ps, Email, Phone, Individual Address, Demographics and Individual Attribute Extended for Customer Database.

Environment: Informatica PowerCenter 8.6.1, Sterling, Tidal 5.0 Enterprise Scheduler, UNIX Shell Scripting, UNICA IMOD, UltrEdit-32 Text Editor, File Viewer, FileZilla FTP Client, SQL Server 2008, Windows XP.

Confidential, Oakbrook, IL

ETL/BI Developer

Responsibilities:

• Analyzed business requirements for the Data Mart Enhancement and Performance Improvement.
• Interacted with application teams, business analysts and database administrator to ensure the ETL solution meets business requirements.
• Monitored and modified the long running SQL’s for the Daily and Monthly Production Load.
• Optimized the long running SQL’s in production mappings.
• Built plans and worked on standard plans on Informatica Data Quality.
• Used Data Quality Workbench for Data Profiling, Data Standardization, Data Matching and data consolidation.
• Used Data Quality Report Viewer to create data quality dashboards for Business Users.
• Profiled data across columns, rows (dependency profiling), and tables (redundancy profiling).
• Performed Impact Analysis to identify the impact on downstream and upstream of DWH tables.
• Did Unit Testing, System Testing and Integration Testing before moving the Informatica Mappings and Workflows into UAT.
• Written Test Cases, Test Plans and Test Results for Verification and Approval from Users.
• Created the Hyperion Reports using the Hyperion Interactive Reporting tool.
• Used MS Visual Source Safe to check-in and check-out Informatica Mappings, Workflows and UNIX Scripts.
• Migrated Informatica mappings and workflows from one environment into another as per Release Management using XML.
• Used Repository Manager for the Folder Access and Permissions.
• Used Labels and Deployment group to associate groups of objects and copy them from one repository to another.
• Created the Migration Plan document to migrate the Mappings and work-flows to the Testing and Production environment.

Environment: Informatica PowerCenter 8.6.1, Informatica Metadata Manager, IDQ, Data Quality Workbench, Oracle 10g, Oracle 11g, Hyperion 9.0, XML, Erwin, MS Visual Source Safe, PWS, UNIX Scripting, SQL, PLSQL, JSS, Toad.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Analyzed business requirements to architect, design, develop, and implement highly efficient, highly scalable Informatica ETL processes.
• Designed Informatica ETL solutions.
• Developed logical and physical data models.
• Work closely with application teams, business analysts, data analysts and database administrators to ensure the ETL solution meets business requirements.
• Involved in designing the mappings and end-to-end data flow in a mapping.
• Developed Informatica mappings, sessions and workflows.
• Created mappings and mapplets using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Sequence Generator, Update Strategy and Union Transformations.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Worked with XML Sources and Targets.
• Develop and execute Test Plans to ensure that the ETL process fulfills data requirements.
• Trained and mentored new folks and off shore team.
• Loaded data according to the Hospital Tables for Patient information, Service information, Claim payment information, Insurance company information.
• Involved in tuning Informatica Mappings and Sessions by implementing database partitioning.
• Wrote UNIX shell scripts and used them as Pre/Post Session commands in the Sessions.
• Involved in performance tuning, load strategies / identity dependencies, re-satiability (minimize cleaning process).
• Designed the Migration Plan document to migrate the Mappings and work-flows to the Testing and Production environments.
• Used Deployment group to deploy the Informatica objects from one repository to another.
• Documented the number of source / target rows and analyzed the rejected rows and worked on re-loading the rejected rows.
• Conducted peer-to-peer code review meetings.
• Involved in team meetings, managed requirements into Mercury Quality Center, wrote Test Cases and selected test sets for different types of testing.
• Created Test Plans and worked with QA team for System and Integration Testing.
• Performed Unit Testing, System Testing and User Acceptances Testing (UAT) for Universe, Reports and Security Management.

Environment: Informatica PowerCenter 8.1.1, MS SQL Server 2005, SSIS, SQL server Management Studio, EDI, Business Objects XIR2, Designer, Desktop Intelligence, Web Intelligence, ER-Studio, Mercury QC, FTP, AIX, UNIX Shell Scripting, SQL, PLSQL, XML

Confidential, Chicago, IL

ETL /SQL Developer

Responsibilities:

• Participated in the development and documentation of all ETL related activities, environmental specifications, ETL strategy, recommendations on tool selection, and code migration.
• Helped business units to define requirements and translated them to ETL design.
• Worked with DBA and data modeler on data base architecture design and data model design for data conversion.
• Performed Gap Analysis to determine the components to be built for the development.
• Served as subject matter expert (SME) in assigned area.
• Designed, developed and architected the ETL process using Informatica PowerCenter 8.1.1, Oracle SQL and shell scripting on HP-Unix.
• Developed ETL SQL Scripts to extract source data and loaded in staging tables.
• Involved extensively in creating Informatica Mappings.
• Involved in development and maintenance of Informatica mappings, workflows and tasks, Created reusable objects.
• Created PL/SQL Stored Procedures and Functions and used them for confirming the process which allows users to produce Confirmation Letters.
• Involved in Performance Tuning of the mappings, sessions and determining the performance bottlenecks.
• Did Unit Testing and data validation.
• Used 'Mercury Quality Center' for creating tests and logging defects.
• Involved in solving the defects logged by QA’s in Team Tracker.
• Build the new Universes as per the user requirements by identifying the required tables from Data mart and by defining the Universe connections.
• Created List reports, Crosstab Reports, Master-Detail Reports in DESKI / WEBI.
• Created Conditions at Universe level. Used @variable, @prompt in Reports.
• Developed Universe User Documentation guide for the End Users .

Environment: Informatica PowerCenter 8.1.1/7.1.3 , IDQ, Sybase 12.0, Oracle 9i, Business Objects X1R2, Auto Sys, Unix Shell Scripting, ER-win 4.4.1, Rapid SQL, SQL, PLSQL, TSQL, UML, SQL Developer, Mercury QC 9.2, ASP.NET, Team Track, PVCS Version Manager, FileNet Web Services, Windows XP.

Confidential, Baltimore, MD

Informatica ETL Developer

Responsibilities:

• Involved in requirement gathering and identifying the report set to be produced.
• Involved in design, code, test, and implementation of Data marts for batch and on-line Medicare and beneficiary applications.
• Wrote detail design documents, Interacted with GTL for knowing the Business Rules, implementing Informatica mappings and maintaining Informatica Standards.
• Data Modeling (Modeling of Stage schemas and Data Mart Star Schemas)
• Identified tables/Scripts required for full load, daily delta-load and monthly load and documented ETL process for each load.
• Involved in Teradata SQL Tuning used in complex Informatica mappings.
• Used BTEQ scripts to submit SQL queries and load Teradata tables.
• Involved in Integration of data from legacy and loading into Facets data mart.
• Used Teradata Utilities like Fast Load, Multi Load to load the Teradata tables.
• Used Cognos Report Studio to create and modify reports.
• Ran reports out of Cognos Report Studio and converted into Excel format to analyze the data.
• Worked with other IT departments on integrated support as required.
• Involved in Trouble shooting technical issues with Informatica admin and/or Informatica tech support.
• Provided production support as required during and after normal business hours.

Environment: Informatica PowerCenter 8.1.1, Teradata V2R6.2, COGNOS 8 BI, MicroStrategy 8.1, ER-win 4.1.4, Unix shell scripting, Teradata SQL Assistant 7.1, BTEQ, Windows XP.

Confidential, Chesterfield, MO

Informatica Developer

Responsibilities:

• Involved in Data Warehouse design, ETL specifications.
• Interacted with Business Analysts for mapping specs and business rules.
• Analyzed test cases for automation and created scripts for regression testing using QTP.
• Lead the effort to convert manual test scripts into automated test scripts for functional, regression and sanity testing using QTP.

Environment: Informatica PowerCenter 8.1.1, Power Exchange 8.1.1, Power Exchange Navigator, Oracle 10g, MS SQL Server 2005, BO XIR2, Import Wizard, Conversion Tool, Designer, Unix shell scripting, SQL, PLSQL, HP UX 11.1, Windows XP.

Confidential, Dallas, TX

Software Developer

Responsibilities:

• Attended user design sessions, studied user requirements, completed detail design analysis and wrote design specs.
• Migrated DTS Packages to SSIS Packages and loaded the data from SQL Server 2000 to SQL Server 2005.
• Created and modified SSIS packages to load data from one server to another server as well as from one table to another table within the same server.
• Developed Informatica mappings, sessions and workflows.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Extensive experience in XML sources and targets.

Environment: Informatica PowerCenter 7.1.5/6.2.2 , Oracle 9i, ERWIN 4.1, SQL, PL/SQL, Microsoft SQL Server 2005, XML, Unix Shell Scripting, Sun Solaris 5.8 Windows 2000.

Confidential

Developer

Responsibilities:

• Involved in complete system development life cycle study, analysis and Design for creating a robust MIS Reporting System.
• Involved in initial study, design of Data Warehouse for better Reporting for Inventory and Procurement Systems.
• Attended in-house in Informatica and Dimensional Data Modeling.
• Used Informatica PowerCenter 6.1 to create data mappings.
• Developed Application programs using Oracle PL/SQL.

Environment: Oracle Database 9.2/8.1.7, SQL, PL/SQL, Sun Solaris V5.8, Windows 2000, Toad, Test Director, Informatica PowerCenter 6.2