SUMMARY:

• Installed and configured Power Center 9.1.0 and 9.6.1 on UNIX and Windows platform.
• Installed and configured Informatica Power Exchange CDC 9.1.0 and 9.6.1 for Sql Server on UNIX/Windows platform.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Performed Informatica upgrade from 9.1.0 to 9.6.1.
• Installed and configured the IDQ 9.6 components on AIX UNIX/Windows Servers.
• Configured OS Profiles and LDAP Authentication.
• Monitor and troubleshoot the Informatica domain, Creating and maintaining Grids and Nodes
• Installed and configured Informatica Support Console 1.5 to proactively monitor the environment.
• Designed and documented ETL standards document.

TECHNICAL SKILLS:

Primary skills: Informatica Power Center 8.6.1, 9.0.1, 9.1.0, 9.5.0, 9.6.1, IDQ 9.1.0, PWX 9.1.0 and PWX 9.6.1

Modeling Tool: Power Designer 12.5, Oracle Sql Developer Data Modeler

Domain skills: Finance, Manufacturing, Elections

Languages known: SQL, PL/SQL, T - SQL, Unix Shell, C/C++, Java, VB 6.0, VB.net, ASP.net, C#, VBA.

Scheduling Tools: Autosys, Control-M, ESP

Migration Tool: Kintana

Data Warehousing: Oracle Warehouse Builder, Oracle Data Integrator, SQL Server Integration Services (SSIS), SypherLInk, Informatica Power Center 9.6.1 / Power Mart 8.6, 9.1, Pervasive, Informatica Data Quality, Meta Data Management (MDM)

Operating System: MS DOS 6.22, Win 3.x/95/98, Win NT 4.0, 2003/2000/XP, Sun Solaris, Linux and AIX.

Other tools: TOAD 9.5, Query Analyzer, Remedy BMC Software, Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, Dallas TX

Middleware Informatica Administrator

Responsibilities:

• Installed and configured Power Center 9.1.0 and 9.6.1 on UNIX and Windows platform.
• Installed and configured Informatica Power Exchange CDC 9.1.0 and 9.6.1 for Sql Server on UNIX/Windows platform.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Performed Informatica upgrade from 9.1.0 to 9.6.1.
• Installed and configured the IDQ 9.6 components on AIX UNIX/Windows Servers.
• Configured OS Profiles and LDAP Authentication.
• Monitor and troubleshoot the Informatica domain, Creating and maintaining Grids and Nodes
• Installed and configured Informatica Support Console 1.5 to proactively monitor the environment.
• Designed and documented ETL standards document.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments. Created Groups, roles, privileges and assigned them to each user group. worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities
• Implemented Power Exchange configuration for Sql Server CDC following customized Security protocols
• Responsible for creating the DATA MAPS and CDC registrations for Mainframe and Sql Server Sources
• MFT (managed file transfer) was used for the transmission of the extracted/source files to and from the vendor
• Identify root cause and implement resolution for production processing issues
• Ensure that all support requests are properly approved, documented, and communicated using the VMware Service Manager tool. Documenting common issues and resolution procedures

Environment: Informatica Power Center, 9.1.0 HF6, 9.6.1 HF4, PWX 9.1.0, PWX 9.6.1, Informatica Data Quality 9.1.0, Sql Server 2008, MFT server (Managed File Transfer) and Autosys.

Sr. Informatica Consultant/Database Developer

Responsibilities:

• As a part of BI team at DTNA, mainly responsible for working on multiple projects which include Development, Enhancements and Production support of Enterprise Data warehouse.
• Worked with Informatica Power Center 8.6.1 tools i.e. Designer, Workflow Manager, Repository Manager, Source Analyzer, Warehouse designer, Mapping & Mapplet designer and Transformation Developer.
• Designed complex mappings using Source Qualifier, Joiners, Lookups (Connected & Unconnected), Expression, Filters, Router, Aggregator, Sorter, Update Strategy, Stored procedure and Normalizer transformations.
• Worked with Relational Databases, DB2 UDB 9.6/9.7, Oracle 11g, SQL Server 2005..
• Worked with Informatica Power Exchange (Power Connect) for extracting the data from SAP, familiar working with the generated ABAP’S, deploying the ABAP code using Tears tool across MPF, QPF and PPF. Good Knowledge of SAP Application modules, SD and MM.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions, implement best practices to maintain optimal performance. Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes
• Worked with Oracle Designer in creating Physical and Logical Models, Dimensions and Fact Tables.
• Worked in data Extraction, Transformation and Loading from DB2 Server to target system using BTEQ, Fast Load and Multi Load
• Created ODI (Sunopsis) interfaces for loading the data from Sybase to CDW and from CDW to different Marts
• Implemented Informatica loading techniques like Incremental Loading and Slowly Changing Dimensions SCD TYPE I and SCD TYPE II.
• Worked with mapping variables, mapping parameters, parameter files, designed the ETL mappings which updates the parameter files.
• Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, TO CHAR, Decode, Substr, Instr, ReplaceStr and IIF functions in Expression Transformation.
• Worked with Informatica advanced techniques like MD5 Processing, Dynamic creation of flat files
• Worked with Informatica Deployment Groups in migrating the ETL code across environments.
• Responsible for Optimization of Informatica mappings, sessions, SQL queries.
• Written and fixed various Oracle and DB2 Stored procedures.
• Responsible for scheduling the jobs using CA ESP and Informatica scheduler
• Responsible for supporting a project which was designed using SSIS, work includes changing the SSIS packages, resolving production Break fixes.
• Worked with Business System Analysts in understanding the requirements and with Reporting team in fixing the data issues related to the reports.

Environment: Informatica PowerCenter 8.6.1/9.1 (ETL), Oracle 10g, TeradataV13, SQLServer, ODI, SSIS, Main Frame SQL/PL-SQL, DB2, Quest, Windows NT/2000/XP, ESP, Shell Scripting

Sr Consultant

Responsibilities:

• Created the ETL design documentation and set the standards for development and testing.
• Actively involved in data design, analysis, development, testing and performance tuning.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Actively involved in development, review and testing of the Informatica ETL processes and attain the project deadlines.
• Created the Design solution for Incremental loading, Exception Handling and Process/Error Logging mechanisms.
• Created users and groups, Migrated objects using deployment groups and trouble shoot Deployment issues
• Involved in Design review, code review, Performance analysis and Performance test.
• Extensively worked on Performance Tuning (Both Database and Informatica side) and there by improving the load time.
• Extracted data from sources like DB2, Oracle, XML, fixed width and Delimited Flat files transformed the data according the business requirement and then Loaded into the Oracle Database
• Created ODI design documents from the existing Informatica mappings for implementing analytics for Voter Search. Used these design documents in development of ODI interfaces/packages.
• Involved in development of ETL processes utilizing Oracle Data Integrator.
• Extensively used PL/SQL for creating packages, procedures and functions.
• Written basic Unix Shell Scripts for getting the data from all systems to the data warehousing system. The data was standardized to store various business units in tables.
• Tested all the applications and transported the data to the target Warehouse Oracle tables and used the Test Director tool to report bugs and fix them in order.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Business Objects Universe Design and Development and Web Intelligence reports.

Environment: Informatica PowerCenter 7.1.2/8.6.1 (ETL), Oracle Data Integrator(ODI), Oracle 10g, SQLServer, DAC, SQL/PL-SQL, DB2, Quest, Windows NT/2000/XP, Business Objects Xi, Oracle Data Integrator.

Data Migration / Data Warehouse Developer and Data Analyst

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report for the distribution of news papers to different locations
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Analyze and document the data received from each county and identify the relevant and complexities of the data for Court index, Family court and Bench Warrants files.
• Extract the data from QS/1 application and load the data into Sql Server through Sql Server Integration Services packages using various mapping operator like file and external table operator, Script Component, Bulk Insert and simple T-SQL transformations.
• Generate the analysis reports upon the County Requests.
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions, implement best practices to maintain optimal performance.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
• Interact with the QA and application development team for the better results. and the data needed for planning, evaluating, and program administration
• Helped in creating technical specifications by mapping the interface tables with the base tables
• Developed / modified scripts to create tables, views and executed them using T-SQL
• Developed macro routines using VBA/Excel for formatting Data Exceptions Documents.
• Document and design the simple and complex mapping for loading the data from staging to Target through Sql Server Integration Services packages using various transformations.

Environment: Sql Server Management Studio, Sql Server Integration Services,T-Sql,Unix Shell Scripting,Visual Basic,VB.NET.

Database Developer / Business Objects Consultant

Responsibilities:

• Designed data mart and operational data store, created and maintained a permanent staging area where data from all sources such as districts and precincts is parsed and stored after partial cleaning.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions, implement best practices to maintain optimal performance. Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production. Provide on-call support to production system to resolve any issues.
• Gather requirements and design of data warehouse and data mart entities.
• Liased with Business Objects to jointly go to market with demonstration solution sets.
• Administered the data warehouse, which included tuning, backup & recovery and maintenance.
• Directly coordinating with user to gather the new requirements and working with existing issues.
• Designed & Implemented security architecture for Precinct Rooster Group.
• Involved in Data Modeling and SQL server Database
• Migrated & upgraded Business Objects from 6.5 and Crystal Reports 10 to XI r2 Universe designing and establishing BO environment.
• Designed Universes for Financial Billing system and Order processing
• Created Objects and prepared Reports like financial reports, HR reports, standard and adhoc reports, and universes. Involved in joining the tables by creating aliases to resolve the loop.

Environment: Sql Server Management Studio, BO XI r2,Sql Server Integration Services,T-Sql,Unix Shell Scripting,Visual Basic, Java Script, Erwin.

Sr. Data Migration / Data Warehouse Developer / Data Analyst and VB.net Developer

Responsibilities:

• Analyze and document the data received from each county and identified the relevant data and complexities of the data.
• Interaction with client for information gathering and data verifications.
• On the basis of analysis, load the data in to staging or create external table using OWB using various mapping operator like file and external table operator and simple SQL transformations.
• Document and design the simple and complex mapping for loading the data from staging to Target using various mapping operator and SQL and PLSQL transformations.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Document and Design the process flow packages using Oracle Workflow for loading the data form staging or external tables into target database by designing.
• Responsible for Creating and maintain OWB repositories.
• Interact with the QA and application development team for the better results.

Environment: Oracle 10G, OWB (Oracle Warehouse Builder) 10G, Microsoft Visual Studio.net, SQL, PL/SQL, MS ACCESS, SQL* loader, TOAD.