SUMMARY

• Sixteen years of extensive experience in Information Technology with special emphasis on Architecture, design & development of Database, Data Warehousing, Informatica Architecture, Administration and Development, Client - Server and e-commerce applications.
• Ten years of experience in gathering requirements for data warehouse projects, perform gap analysis and create Physical/Logical Models using dimensional data modeling techniques.
• Nine years of extensive experience in Architecture, installation, configuration, maintenance, upgrade and administration of Informatica Powercenter 5.1/6.1/7.1.3/ 8.6/9.1/9.5/9.6/10.1, Informatica Dataquality 8.6/9.1/9.5/9.6/10.1 and Data Integration Hub 1.0/9.6 on Windows/Unix and Linux Platforms.
• Good understanding of SOA (Data Integration) architecture. Defining the best practices to improve the Data Integration and quality of data in organization.
• Extensive working experience in all the phases of the Data warehouse life cycle involving Architecture, design, development and deployment of Data warehouses using ETL, Data Modeling, and Online Analytical processing tools.
• Mastery over the ‘ETL process’ with many years of experience in extraction of the data from various source systems ranging from Oracle, Mainframe DB2,Sybase, Informix, SQL Server, Flat files to RDBMS like Oracle, Teradata and Greenplum.
• Mastery over the ‘Data Quality process’ with many years of experience in extraction of the data from various source systems ranging from Oracle, Mainframe DB2,Sybase, Flat files, IBM MQ to RDBMS like Oracle and Greenplum.
• Experience in Designing and Configuring LDAP Security for Informatica Dataquality, Informatica Powercenter, Informatica Data Integration HUB and Informatica Metadata Manager.
• Practical understanding of the Data modeling concepts like Star-Schema Modeling, Snowflakes Modeling, hands on experience in developing logical & physical models using ERWIN 3.5/4.0 and Power Designer 12
• Extensively used ETL methodology in Data Extraction, Transformations and Loading process, in a corporate-wide-ETL Solution using INFORMATICA (Power Mart/ Center 5.1/6.1/7.1.3/ 8.6/9.1/9.5/9.6 - Repository Manager, Designer, Server Manager/Workflow manager, Server Administration Console).
• Extensive working experience in doing Data Profiling and Data quality operation using Informatica Data Quality 8.6/9.1/9.5/9.6 or Informatica Data Analyst 9.1
• Extensive working experience in doing Publications and Subscription using Informatica Data Integration HUB Operational Console 1.0/9.6
• Extensive experience in using Informatica Power Exchange in doing data processing from/to Mainframe DB2/Green Plum.
• Experience in Installing and Configured Informatica Proactive Monitoring Rtam 3.1 and Rulepoint 5.2 for process monitoring and alerting.
• Experience in Installing and Configuring ILM 6.2 for Metadata Archiving.
• Strong experience in LINUX/UNIX working environment in writing shell scripts for job execution, scheduling and server maintenance.
• Extensive Work experience using scheduling tools Autosys and Control-M.
• Good Knowledge about Online Analytical Processing tool (OLAP) such as Business Objects, Cognos, IBI Webfocus, SSRS, SSAS and Business Intelligence Web Application.
• Extensive work experience in SQL, PL/SQL, Functions, Stored procedures development, Triggers, Packages and Performance Tuning.
• Experience in Relational Databases - Oracle 8.0/8i/9i,10G,11G,SQL Server 2000, Informix, Teradata and Greenplum.
• Extensive Work experience using ERWIN 3.5/4.0 and Power Designer as data modeling tool.
• Evaluation of new data integration tools like Informatica Cloud.
• Ability to handle multiple tasks and work independently as well as in a team.
• Have Strong analytical skills with ability to follow project standards and decision-making capability.
• Exceptional ability to quickly master new concepts and applications.
• Self-motivated and have excellent Communication and interpersonal skills.
• Always keeps up to date with current trends in BI and Data warehousing space.
• Knowledge of Hadoop, HDFS, HIVE, PIG and HBASE.

TECHNICAL SKILLS

Databases: Oracle 8.0/8i/9i,10G,11G, SQL Server 2000, Informix, DB2, Teradata, Greenplumand MS Access 2000

ETL Tools: Informatica Power Mart / Power Center - 5.1/6.1/7.1.3/ 8.6/9.1/9.5/9.6 (Repository Manager, Designer, Server Manager/ Workflow Manager/Server Administration Console), Informatica Power Exchange, Informatica Data Profiling, Informatica Data Quality 9.1/9.5/9.6, Informatica Data integration HUB 1.0/9.6, Informatica Metadata Manager 9.6.1, Informatica Proactive Monitoring Rtam 3.1 and Rulepoint 5.2, Informatica ILM 6.2, and Informatica Cloud.

Database Tools: TOAD, SQL Navigator

LDAP: Microsoft Active Directory

OLAP & Reporting Tools: Business Objects 5.0/6.1 (Supervisor, Designer, Business Object)

Data Modeling Tools: Erwin 3.5/4.0, Power Designer 12

Data Warehouse: Dimensional Modeling (Star Schema, Snowflake Schema).

Languages: C, Java (JDK1.2), Shell Programming, SQL, PL/SQL

Operating Systems: Windows 95/98/NT/2000/XP, MS-DOS, UNIX, LINUX.

Front End Tools: Visual Basic 6.0

Web Server: Java Web Server 2.0, IIS, Tomcat.

Web Programming: HTML, Java Script, VB Script, ASP

Web Tools: Visual Interdev, Front Page, Dream Waver

PROFESSIONAL EXPERIENCE

Confidential, TX

Lead Informatica Architect

Responsibilities:

• Distribute work, provide guidance and Knowledge Transfer to Informatica Platform Support Team in Onboarding New Application to Informatica Platform, Informatica Issues Trouble Shooting and Fixing, Informatica Version Upgrade, Handling Outages and Maintenances.
• Review Silo Platforms that are being On boarded to Informatica ETLCOE, Identify the gaps, Coordinate, Plan and Implement.
• Plan and execute Informatica Upgrade to 951,961 and 10.1
• Work with off shore teams in Informatica Build and Upgrade Projects.
• Informatica Installation and Configuration on Unix, Linux and Windows.
• Informatica code migration and prepared standards for code migration.
• Informatica code upgrade from various lower versions to higher versions.
• Informatica Administration and Support.
• Informatica Data Quality Services configuration.
• Performance and outage issue resolution in Informatica Power Center and Informatica Data Quality.
• Co-ordinated and Participated in Disaster Recovery of Informatica Environments.
• Installation and Configuration of Informatica Power Exchange
• Worked on Informatica Power Exchange for Oracle CDC, HDFS and Hive.
• Prepared standards document for Informatica Build.
• Prepared Informatica Naming Conventions and Coding Standards document.
• Debugged informatica performance issues related various relational and non-relational sources.
• Did POC on various informatica connectors and provide Coding Standards to application teams.
• Trained off shore and onsite associates in Informatica Development and Administration.
• Written shell scripts for Informatica Server Administration and Support.
• Configured geneos to monitor informatica environment.
• Written wrapper scripts for scheduling jobs in Autosys.
• Written and Used Unix Shell Scripts to run Workflows using pmcmd command
• Informatica Migration Automation using Jenkins.
• Gathered performance statistics for the mappings, identified the bottlenecks and resolved them to improve the performance of the mapping.

Environment: Exadata, Oracle 10 G, Oracle 11G,Oracle 9i, SQL SERVER 2000, Teradata, Vertica, Mainframe DB2, IBM MQ, Sybase, Informatica Powercenter 10.1,9.6.1, 9.5/ 9.1/8.6/7.1.3 (Repository Manager, Designer, Server Manager, Server Administration Console), Informatica Data Quality / Analyst, Informatica Power Exchange 9.1/9.6.1, PWC HDFS and Hive Connector, Informatica Big Data Edition 9.6.1 HF2, Informatica Data Integration HUB 96, SQL, PL/SQL, Linux, Shell Scripts, Sun Solaris, Win NT, TOAD, Autosys, Techtia, Geneos, Putty.

Confidential, TX

Informatica Architect and Administrator

Responsibilities:

• Architected Informatica Data quality and Informatica Data Integration HUB environments.
• Provide estimates to project manager to build Informatica Data quality and Informatica Data Integration HUB environments.
• Installed and Configured Informatica Data Quality and Data Integration HUB on Linux Environment.
• Configured Informatica Metadata Manger, Created Custom Models, Created, Loaded and Scheduled Resources. Browsed the catalogs to review the lineage.
• Designed and configured security for Informatica Dataquality, Data Integration HUB and Metadata Manager.
• Configured LDAP security by syncing Groups and Users from Microsoft Active Directory.
• Installed and Configured Informatica Proactive Monitoring Rtam 3.1 and Rulepoint 5.2 for Dataquality process monitoring and alerting.
• Installed and Configured ILM 6.2 for Data Integration HUB Metadata Archiving.
• Informatica Data quality code migration from Lower Environment to Higher Environments and prepared standards for code migration.
• Informatica code upgrade from various lower versions to higher versions.
• Informatica Data Quality and Data Integration HUB Administration and Support.
• Performance and outage issue resolution in Informatica Data Quality and Informatica Data Integration HUB.
• Co-ordinated and Participated in Disaster Recovery of Data Quality and Informatica Data Integration HUB
• Installation and Configuration of Informatica Power Exchange for Mainframe DB2, Oracle CDC, Green Plum, HDFS and Hive
• Prepared standards document for Informatica Build.
• Prepared Informatica Data quality Naming Conventions and Coding Standards document.
• Trained off shore and onsite associates in Informatica Data quality Administration and Data Integration HUB Administration.
• Written shell scripts for Informatica Data quality and Data integration HUB Server Administration and Support.
• Configured eG to monitor informatica environment.
• Scheduling admin jobs in Autosys
• Written and Used Unix Shell Scripts to run Workflows using infcmd command
• Configured HP Open View monitoring to scrape the logs and send alerts using alarmpoint.
• Provided guidance and reviewed automation of data quality and data integration hub code migration.

Environment: Exadata, Oracle 10 G, Oracle 11G,Oracle 9i, SQL SERVER 2000, Teradata, Informatica Powercenter 9.6/9.5.1/ 9.5/ 9.1/8.6/7.1.3 (Repository Manager, Designer, Server Manager, Server Administration Console), Informatica Data Quality 9.6/9.5.1 Analyst, Informatica Power Exchange 9.1, PWC HDFS and Hive Connector, Informatica Data Integration HUB 1.0/9.6,SQL, PL/SQL, Informatica Metadata Manager 9.6.1,Shell Scripts, Microsoft Active Directory, Linux,Sun Solaris, Win NT, TOAD, Autosys, Techtia, eG Monitoring, Data Stage and Alarmpoint.

Confidential, NC

Informatica Architect and Administrator

Responsibilities:

• Providing estimates to the project managers for the Informatica Build Projects.
• Architect Informatica Platform Build
• Plan and execute Informatica Upgrade
• Work with off shore teams in Informatica Build and Upgrade Projects.
• Informatica Installation and Configuration on Unix, Linux and Windows.
• Informatica code migration and prepared standards for code migration.
• Informatica code upgrade from various lower versions to higher versions.
• Informatica Administration and Support.
• Informatica Data Quality Services configuration.
• Performance and outage issue resolution in Informatica Power Center and Informatica Data Quality.
• Abinitio support
• Co-ordinated and Participated in Disaster Recovery of Informatica and Abinitio Environments.
• Installation and Configuration of Informatica Power Exchange
• Worked on Informatica Power Exchange for Oracle CDC, HDFS and Hive.
• Prepared standards document for Informatica Build.
• Prepared Informatica Naming Conventions and Coding Standards document.
• Debugged informatica performance issues related various relational and non-relational sources.
• Did POC on various informatica connectors and provide Coding Standards to application teams.
• Trained off shore and onsite associates in Informatica Development and Administration.
• Written shell scripts for Informatica Server Administration and Support.
• Created shell scripts to integrate informatica with VCS Monitoring.
• Configured geneos to monitor informatica environment.
• Written wrapper scripts for scheduling jobs in Autosys, complete job schedule are maintained in the Custom oracle tables, which enabled restart ability and better performance.
• Written and Used Unix Shell Scripts to run Workflows using pmcmd command
• Used deployment group for migrating Informatica Objects between environments.
• Gathered performance statistics for the mappings, identified the bottlenecks and resolved them to improve the performance of the mapping.

Environment: Exadata, Oracle 10 G, Oracle 11G,Oracle 9i, SQL SERVER 2000, Teradata, Informatica Powercenter 9.5/ 9.1/8.6/7.1.3 (Repository Manager, Designer, Server Manager, Server Administration Console), Informatica Data Quality / Analyst, Informatica Power Exchange 9.1, PWC HDFS and Hive Connector, SQL, PL/SQL, Linux, Shell Scripts, Sun Solaris, Win NT, TOAD, Autosys, Techtia, Geneos, Abinitio.

Confidential, KY

Informatica and Data warehouse Architect

Responsibilities:

• Providing estimates to the project managers for the Infrastructure and Integration Projects.
• Gathered requirements for multiple data integration projects and documented the requirements.
• Performed gap analysis and created data models using the Dimensional Modeling (Star Schema) techniques.
• Performed data profiling and identified data quality issues and set standards to fix the issues across the systems that are integrated with data warehouse.
• Generated database creation scripts from physical models.
• Evaluated Informatica Cloud and Informatica Power Exchange CDC for Oracle and provided recommendations for implementation.
• Worked with DBA’s in sizing the database, creation of table spaces, creating roles/privileges and maintenance of Data warehouse databases.
• Defined informatica environment architecture.
• Developed reports using IBI Webfocus
• Analyzed the IBI Webfocus reports that are used by users and formed the business requirements.
• Installation, configuration and administration of Informatica Powercenter 7.1.3/8.6/9.1 On LINUX and Unix operating systems.
• Upgrade of Informatica Powercenter 7.1.3 (Linux 32 bit) to Informatica Powercenter 8.6 (64 bit) on UNIX and Upgrade of Informatica Powercenter 8.6 (64 bit) to Informatica Powercenter 9.1 (64 bit)
• Created Naming conventions and coding standards documents.
• Created specification and mapping design documents based on the data models, data availability in source systems.
• Lead offshore development team in Infrastructure and Integration Projects.
• Conduct code reviews to make sure the development is done with good standards.
• Developing Mappings as per the Design Document with proper naming Conventions for Transformations and Mapping Variables.
• Created Mappings Using various transformations like Expressions, Aggregators, Joiners, Ranking, Stored Procedures, Look Up and Update Strategy transformation using Informatica Tools.
• Used reusable transformations, mappings and sessions, which enable ease of maintenance and lesscoding.
• Used external procedure transformation for calculating the check sum for the values in a row.
• Created sessions and workflows to run the various mappings for loading the data using workflowmanager in Informatica.
• Written wrapper scripts for scheduling jobs in cron, complete job schedule are maintained in the customoracle tables, which enabled restart ability and better performance.
• Written shell scripts for Informatica Server Administration and Support.
• Used parameter files extensively to pass values to Mapping variables.
• Written and Used Unix Shell Scripts to run Workflows using pmcmd command
• Used server variables while specifying the session log, workflow log and cache file paths.
• Used deployment group for migrating Informatica Objects between environments.
• Gathered performance statistics for the mappings, identified the bottlenecks and resolved them to improve the performance of the mapping.
• Used SQL over rides to improve the performance of the sessions.
• Used new features of SQL in Oracle 10 G, 11G in ranking and year to date summarizations.
• Maintained detailed documentation of all the activities.
• Trained off shore and onsite resources in Informatica Administration, development and Data warehouse development.

Environment: Oracle 10 G, Oracle 11G,Oracle 9i, SQL SERVER 2000, Informix, Flat files, Informatica Powercenter 9.1/8.6/7.1.3 (Repository Manager, Designer, Server Manager, Server Administration Console), Informatica Data Quality / Analyst, SQL, PL/SQL, Erwin 4.0, Power Designer 12.0,IBI Webfocus, Shell Scripts, Linux, Sun Solaris, Win NT, SQL Navigator.

Confidential, CA

Sr. Data warehouse Developer

Responsibilities:

• Analyzing and Understanding Sources of IBM Mainframes COBOL Copybooks, FaltFiles, Oracle, DB2 Tables and Target with Sql Server.
• Involved in developing Logical and Physical Data Models based on functional design using Erwin Data Modeler.
• Worked closely with Business Analysts and Data Modelers on Mapping Document Design Process for various Sources and Targets.
• Extensively worked in extraction, transformation and loading of data from the different sources like COBOL Copybooks, FaltFiles, DB2 Tables Using Informatica.
• Worked intensively on the Informatica tools - Source Analyzer, Warehouse Designer, Mapping designer, Mapplet designer and Transformation Developer.
• Complex mappings/mapplets were developed using Expressions, Aggregators, Joiners, Ranking, Stored Procedures, Normalizer and Update Strategy transformations.
• Extensively used Mapping Parameters/Variables in order to best fit the business logic.
• Involved in troubleshooting the Mappings and performance enhancements.
• Extensively used Unix Shell scripts and pmcmd commands.
• Developing Tasks/Sessions and Workflows as required with Session variables using Workflow Manager In Informatica.
• Performing Unit Test, Volume Test for Mappings and documenting the test plans.
• Designed, Built and maintained Reports in SSRS and SSAS.
• Map reporting requirements to build report.
• Design and tune reports and SQL queries

Environment: SQL Server 2000, Oracle 9i, DB2, ETL-Informatica 6.1/7.1(Repository Manager, Designer, Workflow Manager), SSRS, SSAS, Erwin 4.0, SQL, Win NT, Sun Solaris, Sql Server Studio, Microsoft Report Builder.

Confidential, CA

Data warehouse Developer

Responsibilities:

• Analyzing and understanding Sources of Fixed width Flat Files, DB2 Tables and Target with Oracle 9i.
• Developing Mappings as per the Design Document with proper naming Conventions for Transformations and Mapping Variables.
• Created Mappings Using Expressions, Aggregators, Joiners, Ranking, Stored Procedures, Look Up and Update Strategy transformation using Informatica.
• Worked with huge tables that consisted of around 256 columns and 100 million records per each table.
• Used complex data transformations with around 25 transformations for each mapping
• Developing Performance Tuning Strategies using Bottle Neck method and in terms of Expression and Aggregator transformations.
• Created sessions and workflows to run the various mappings for loading the data using workflowmanager in Informatica.
• Performing Unit Test and Volume Test for Mappings.
• Written and Used Unix Shell Scripts to run Workflows using pmcmd command
• Writing PL/SQL procedures for processing business logic in the database.
• Tuning of SQL queries for better performance.

Environment: Oracle 9i, DB2, Flat files, ETL-Informatica 6.1 (Repository Manager, Designer, Server Manager)SQL, PL/SQL, Erwin 3.5,Shell Scripts, Sun Solaris, Win NT, Toad.

Confidential

ETL Developer

Responsibilities:

• Analyzing and understanding Sources of Fixed width Flat Files, Oracle tables and target with Oracle 9i.
• Involved in designing the Dimensional Modal Using Erwin Data Modeling tool.
• Identified all the confirmed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Created various data marts by integrating different source systems to data warehouse.
• Created various mappings and mapplets using Mapping Designer in Informatica
• Improved the performance of the mappings by moving the filter transformations early into thetransformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations.
• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created sessions and batches in workflow manger using Informatica to run the various mappings andscheduled them for loading the data.
• Responsible for monitoring all the sessions that are scheduled, running completed and failed.
• Involved in debugging the Mappings that failed.
• Unit testing is done for all the Mappings by loading the test data and documented the process.
• Writing PL/SQL procedures for processing business logic in the database.
• Tuning of SQL queries for better performance.
• Designed, Built and maintained Universes in Business Objects.
• Map reporting requirements to BO universes
• Design and tune BO reports and SQL queries

Environment: Oracle 9i, Flat files, ETL-Informatica 5.1 (Repository Manager, Designer, Server Manager)Business Objects 5.0(Supervisor, Designer, Business Object), Erwin 3.5,SQL, PL/SQL, Shell ScriptsSun Solaris, Win NT, Toad.

Confidential

Module Leader

Responsibilities:

• Involved in Analysis of the project.
• Involved in client discussions.
• Involved in technical documentation.
• Involved in designing the database.
• Involved in Building Data flow diagrams.
• Involved in project planning with Project Leader.
• Created forms Using VB 6.0 Components.
• Created Reports In Excel Using OLE Components In Vb6.0.
• Created stored procedures in database Using PL SQL.
• Created different types of Reports by using SQL queries extensively.

Environment: Visual Basic 6.0, Oracle 9i, Excel, SQL, PL/SQL, Data Reports, Windows NT

Confidential

Module Leader

Responsibilities:

• Involved in Analysis of the project.
• Involved in client discussions.
• Involved in conceptualizing the intranet.
• Involved in technical documentation.
• Involved in designing the database.
• Involved in Building Data flow diagram
• Involved in project planning with Project Leader.
• Configuring IIS Server and Creating root folder for the site.
• Created Web pages Using Html, Asp and Java Script
• Created stored procedures in database Using PL SQL.
• Oracle procedures are scheduled to load data into intranet system

Environment: Html, ASP, Javascript, DereamWaver, Adobe Photoshop, Flash, Oracle 9i, SQL, PL/SQL, Windows NT, IIS

Confidential

Application Developer

Responsibilities:

• Involved in Analysis of the project.
• Involved in client discussions.
• Involved in technical documentation.
• Involved in designing the database.
• Involved in Building Data flow diagrams Using ERWIN.
• Created VB Forms In VB 6.0.
• Created reports Using Data Reports.
• Created stored procedures in database Using PL SQL.
• Created different types of Reports by using SQL queries extensively.

Environment: Vb 6.0, Oracle 8i, Data Reports, SQL, PL/SQL, Erwin 3.5, Windows NT.