SUMMARY:

• Ten plus Years (12+) of Total IT experience in Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server and Web applications on Windows and Unix platforms in various verticals such as Confidential .
• Nine plus Years (10+) of Data warehousing & ETL experience using Informatica Power Center 8.6.1/8.1/7.1/6.2/5.1/4.7, Informatica Power Mart 6.2/5.1/4.7, (Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor), Informatica PowerConnect, Informatica Power Analyzer, ETL, OLAP, and OLTP.
• Two Years (2) of Dimensional Data Modeling using Star & Snow Flake schema. Extensive Experience with Ralph Kimball and Bill Inmon Methodologies. Designed Data models using Erwin 6/7.
• Experienced in ERD and dimensional modeling.
• Two years (2) of Business Intelligence experience in generating various complex reports using Business Intelligence Tools Business Objects 6.5/6.0/5.0, Cognos Series 7.0/6.0 (Impromptu & PowerPlay).
• Strong hands on experience usingTeradata utilities (SQL, B - TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, and Query man), Teradata parallel support and Unix Shell scripting.
• Extensively 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 infacmd and pmrep operations).
• Creation and maintenance of Informatica users and privileges.
• Upgraded to Informatica PowerCenter 9.6 from version 9.1.
• Installed Hot fixes, utilities, and patches released from Informatica Corporation
• Good exposure to Data cleansing tools like Informatica Data quality tool (IDQ) to handle teh data anomalies and also standardizing data.
• Created new retirement projects and archived teh applications successfully by using ILM tool.
• Experience working in Multi - Terabyte environments. Solid Experience in coding using SQL, SQL * plus, PL/SQL Stored procedures/functions, triggers and packages. Extensive Working experience applying Relational Database concepts, Entity Relation diagrams, Data Flow diagrams, Oracle Designer 2000 and Normalization concepts. Expertise in utilizing Oracle Utility tools viz., SQL*Loader, Import and Export. Expert in UNIX Shell Scripting.
• Experience working on Databases like Oracle 11i/10g/9i/8i, SQL Server 2005/2008/7.0/6.5, IBM UDB DB2 8.x/7.0, Teradata V2R5/V2R4, MS Access.

TECHNICAL SKILLS:

DWH: Informatica Power Center 9.1/8.6/8.1/7.1/6.2, Informatica Power Mart 6.2/5.1/4.7, (Repository Manager, Designer, Server Manager, Workflow Manager, Workflow Monitor), Informatica PowerConnect, Informatica ILM, IDQ,Power Exchange, ETL, OLAP, OLTP

Data Modeling: Erwin 4.1/7/8.2

BI Tools: Business Objects 6.5/6.0/5.0, Cognos Series 7.0/6.0 (Impromptu & PowerPlay).

Programming: SQL, PL/SQL, Transact SQL, ANSI SQL, Unix Shell Scripting (Korn Shell), Toad 7.x, Visual source safe 4,SQL*,Loader, Quality center (QC)

Databases: Oracle 11i/10g/9i/8i, Oracle essbase SQL Server 2000/7.0/6.5, IBM DB2 8.x/7.0, Teradata V2R4 / V2R3 (Fast Load, Multi Load, BTeq, TPump), NETEZZA 4.xO/S Sun Solaris, AIX, HP-UX, Linux, Windows NT/9x/2000, AS/400, MS-DOS and OS/390

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr Informatica Developer/Analyst

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, Production and support for production environment.
• Developed mappings/sessions/workflows usingInformaticaPower Center 10.2.0 for data loading. Developed mapping to load teh data in slowly changing dimension (SCD).
• Also, involved in tuning teh mappings in teh transformations by tracking teh reader, writer, transformation threads in teh session logs and used tracing level to verbose during development & only with very small data sets.
• Expertise with connected and unconnected transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Created tasks and workflows in teh Workflow Manager and monitored teh sessions in teh Workflow Monitor.
• Designing ETL loads for loading Health care data from different source system to final FDS warehouse.
• Developed ETL codes inInformaticaandInformaticaIICS.
• Informatica Cloudmigration task for migrating teh PowerCenter mapping
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema, Snowflake Schema.
• UsedInformaticaparameter files to filter teh daily data from teh source system.
• Responsible to provide resolutions for production incidents/failures, user requests and problem tasks.
• Used CA Harvest workbench to create and deploy deployment group.
• Used Service-now to track sprint stories, screen demands and create change request.
• Worked with Workflow Manager for maintaining Sessions by performing tasks such as monitoring, editing, scheduling, copying, aborting, and deleting.

Environment:SDLC, Agile/Scrum, SCD-SCD1, SCD3, Informatica Power Center10.2.0, DB2, UNIX, Maestro, Windows 10, Flat files, SQL, Developer& Toad, shell scripting, CA Harvest, ETL, Service-now, TWS Scheduler, InformaticaIICS andInformaticaBDM

Confidential, Richardson, TX

Sr Informatica developer/Architect

Responsibilities:

• Working as an ETL Sr. Consultant / Architect to design/develop/test/install/migrate/troubleshoot various ETL deliverables using Informatica, Netezza, Teradata, Vertica and UNIX shell scripts.
• Understand and convey business requirements into Erwindatamodels (Conceptual, Logical, and Physical)
• Analyzed various Schemas for Implementation and Modeled teh Data Warehousing Data marts using Star Schema.
• Automated building a normalizer table dynamically with all column names for teh table coming from user XL spreadsheet.
• Automate teh scores table addition of new columns and building summary around them.
• Worked on Teradata utilities - BTEQ, Multi-Load to load data into teh Teradata Target database.
• Worked on Fast Export utility of Teradata to run teh Extracts (Extracting teh data from tables and writing to flat files).
• Performed unit testing, code reviews and code migration to prod.
• Developed bunch of UNIX shell scripts/pearl scripts and automated their runs per schedule using CRONTAB.
• Developed complex mappings & Mapplets in Informatica to load teh data using different transformations.
• Engaged with project teams such as SMEs, developers to gather and analyze business requirements regarding to anydatamodeling related artifacts including Conceptual, Logical and PhysicalDataModels.
• DevelopedDataArchitecture standards, principles, processes and governance.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Used Java transformation to split a record into multiple records.
• Generated completion messages and status reports using Workflow manager.
• Created workflows and worklets for designed mappings.
• Developed mappings and loaded data on to teh relational database. Worked on Dimension as well as Fact tables.

Environment: ETL-Informatica 9.6.1- Teradata, SQL Assistant, Teradata Utilities(BTEQ, FastLoad,FastExport, Multiload),Erwin 7.2/8.2, Oracle10g, DB2, Flat files, SQL, PL/SQL

Confidential, Addison, TX

Sr Informatica developer

Responsibilities:

• Coordinated with Business Users to understand business needs and implement teh same into a functional
• Translated requirements and high-level design into detailed functional design specifications.
• Extracted data from various centers with teh data in different systems like Oracle Database and SQL Server and loaded teh data into Teradata staging using Informatica PowerCenter 9.5.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Was responsible for database design and modeling (conceptual, logical, and physical) fordatawarehouse,data
• Hands on with ERWIN tool (datamodeling)
• Experienced in writing SQL scripts.
• hands on working withdata, designing dimensional databases in Oracle
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Wrote complex SQL Queries involving multiple tables with joins and also generated queries to check for consistency of teh data in teh tables and to update teh tables as per teh Business requirements.
• Extensively used SQL tools like TOAD, Rapid SQL and Query Analyzer, to run SQL queries to validate teh data.
• Involved in debugging Informaticamappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Used ERStudio to analyze and optimize database and data warehouse structure.
• Used Autosys scheduler to schedule and run teh Informatica workflows on a daily/weekly/monthly basis.
• Developed Oracle PL/SQL Package, procedure, function and trigger.
• Supported teh BI team by extracting operational data from multiple sources, merging and transforming teh data to facilitate enterprise-wide reporting and analysis and delivering teh transformed data to coordinated data marts.

Environment: Informatica PowerCenter 9.5/9.1, Informatica PowerExchange 9.5, Oracle 11g, UNIX,PL/SQL, SQL, Oracle 11g, Unix Shell Scripts, Embarcadero ERStudio Data Architect, TOAD 10.1.1, Autosys, Putty, Erwin 8.0, QlickView 8.5, SQL *Loader, SQL, PL/SQL.

Confidential, TX

SR. INFORMATICA DEVELOPER

Responsibilities:

• Created Technical Design Specifications, Unit test document based on functional design specifications provided by Business Analyst
• Designed and developed ETL Processes based on business rules, job control mechanism using Power Center.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, Lookup, update strategy, stored procedure transformations, etc.
• Used workflow monitor to monitor teh jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Involved in loading of data into Teradata from legacy systems and flat files using complex MLOAD scripts and Fast Load.
• Extracted data from Oracle database transformed and loaded into Teradata database according to teh specifications.
• Involved writing BTEQ scripts for validation & testing of teh sessions, data integrity between source and target databases and for report generation.
• Involved in writing Teradata SQL bulk programs and in Performance tuning activities for Teradata SQL statements using Teradata EXPLAIN.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata database.
• Validated source data through Informatica data validation option tool (DVO) and Data Quality (IDQ).
• Utilized of Informatica IDQ 8.6.1 to complete initial dataprofiling and matching/removing duplicate data
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jar Distance and Mixed Field matcher, It enables teh creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Executed, scheduled workflows using Informatica Cloud tool to load data from Source to Target
• Supported Informatica upgrade process from 8.6 to 9.1. by validating regression testing results and providing all application details for upgrade consultant to perform application upgrade in Informatica.
• Worked on ILM to create and assign rules for data masking and generating teh workflows.
• Worked with business and IT to gather requirements and define teh ETL Rules and Data Archive solutions for application Design, retirement, live data archiving, data masking etc.
• Delivered end-to-end Data Archive and Data Subset solutions using Informatica Power Center and ILM.
• Performed unit testing, system integration testing, and supported user acceptance testing.
• Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data loading to meet defined SLA
• Collaborated with Project Manager, Tech Lead, Developers, QA teams and Business SMEs to ensure delivered solutions optimally support teh achievement of business outcomes.
• Supported Informatica code migration between environments (DEV/QA/PRD)
• Developed PL/SQL procedures for processing business logic in teh database and use them as a Stored Procedure Transformation.
• Used Address Validator transformation to validate source data with teh reference data for standardized addresses.
• Experience with Address Doctor MD files, AD license key, and AD50 file

Environment: Informatica Power Center 8.6.1/9.1,IDQ Oracle11i/10g/9i, Informatica Power Connect / Informatica Cloud, Informatica ILM, Teradata V2R5,MS Access, Web services, TOAD, XML,PL/SQL, SQL server 2008, Windows, UNIX

Confidential, FL

SR. INFORMATICA DEVELOPER

Responsibilities:

• Worked closely with Business Analyst and teh end users in writing teh functional specifications based on teh business requirement needs.
• Involved in Dimensional modeling (Star Schema) of teh Data warehouse and used Erwin 4.5 to design teh business process, dimensions and measured facts.
• Responsible for developing, support and maintenance for teh ETL (Extract, Transform and Load) processes using Informatica powercenter 8.6.1/9.1.
• Involved in data cleansing prior to data staging.
• Design, Develop ETL process and create UNIX shell scripts to executeTeradataSQL, BTEQ, jobs.
• Assisted DBA to Create tables and views inTeradata, Oracle database.
• Dealt with Incremental data as well Migration data to load into theTeradata.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager
• Worked on power exchange to access teh data from different sources and to avoid manual coding
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Experience with high volume datasets from various sources like Oracle, Text Files, and Relational Tables and xml targets.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Created E-mail notifications tasks using post-session scripts.
• Implemented Type1 and Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and teh target Data.
• Tuning teh complex mappings based on source target and mapping, session level.
• Involved in performance and tuning teh ETL processes.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Developed PL/SQL and UNIX Shell Scripts for scheduling teh sessions in Informatica.

Environment: Informatica Power Center 8.6.1/9.1, TeradataV2R5,TeradataSQLAssistant,TeradataManager Oracle11i/10g/9i, Microsoft Dynamics CRM2013, MS Access, Web services, TOAD, XML,PL/SQL, SQL server 2008, Windows, UNIX

Confidential, FL

SR. INFORMATICA DEVELOPER

Responsibilities:

• Designed and developed Informatica Mappings based on teh business requirements.
• Involved in writing complex queries for generating different reports as per client needs.
• Worked with all phases of teh Software Development Life Cycle (SDLC).
• Extracted teh data from Flat files and loaded teh data into Data ware house using Informatica Power center.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Created shortcuts for source and target and also created Reusable Transformations in Shared folder.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Informatica Administration - adding users, user privileges, creating roles, creating different folders, adding repositories, backup and restoring repositories.
• Various kinds of teh transformations were used to implement simple and complex business logic. Transformations used are: Procedure, connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, etc.
• Involved in designing and implementing Change Data Capture techniques like Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2, Type3) simple pass through mapping.
• Created and Configured Workflows, Worklets and Sessions to transport teh data to target tables in warehouse using Informatica Workflow Manager.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Developed application support documentation accepted by systems changes into production.
• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Designed/Created teh plan for teh Master workflows that are to be scheduled to run on daily and monthly basis.

Environment: Informatica PowerCenter 8.6, DB2, Oracle Enterprise BI 10.1.3, UNIX, Control-M, Sql, Pl/Sql

Confidential, FL

SR. DW ETL INFORMATICA DEVELOPER

Responsibilities:

• Designed teh ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files and Excel files to target Oracle Data Warehouse database
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy and etc.
• Created Mappings for Dimensions and Facts.
• Created sessions and workflow for designed mappings.
• Redesigned some of teh existing mappings in teh system to meet new functionality.
• Analyzed requirements designed and implemented customization to OOTB (Out of teh box) business intelligence solutions using teh Siebel / Oracle Business Intelligence (OBI) Analytics platform and custom data modeling for Sales and Marketing Analytics.
• Created and used different tasks like Decision and email tasks.
• Created ODS to load data for reporting purpose from different sources
• Designed and developed a number of complex INFA PowerCenter mappings using various transformations like Source qualifier, VSAM, Lookup, Expressions, Update Strategy, Router, Filter, Sequence Generator, Aggregator, Joiner, Union, App Multi-Group Source Qualifier, Application Source qualifier, Xml source qualifier.
• Created EDW dimension table load programs as Slowly Changing Dimensions (SCD) with Type II logic.
• Used IDQ for data cleansing and for removing redundant data
• Implemented code re-usability by creating re-usable transformations.
• Implemented teh Change Data Capture extensively to send only teh delta records to teh target systems.
• 24x7 On-call production support.

Environment: Informatica PowerCenter 8.6.1, IDQ, Oracle 10g, Oracle Enterprise BI 10.1.3.4, Teradata V2R12, UNIX, Control-M, Sql, Pl/Sql, Cognos

Confidential, Miami, FL

Sr. DW ETL Informatica developer

Responsibilities:

• Gatheird requirements from Business users.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Source qualifier, Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mappings.
• Performance tuning of teh Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Extracted data from different sources such as SQL Server, Oracle, Netezza, Fixed width and Delimited Flat files to load into Netezza database
• Loaded data from flat files to Netezza using Nzload utility.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Performed migration of mappings and workflows from Development to Testto perform teh integration and system testing and to Production Servers.
• Participated in unit and system test process. Performed troubleshooting and providing resolutions to ETL issues.
• Created complex queries, views and Mviews in Netezza.
• Created stored procedures in Netezza using NZSQL.
• NZmigrate to migrate data from one server to another.
• NZload to load data from flat files to NZ tables. Maintenance of Clustered and non-Clustered Indexes.
• Created jobs and monitor job history for maximum availability of data and to ensure consistency of teh databases.
• Wrote post-session shell scripts to check status (failure/success) after completion of all batches.
• Provided data for Reporting people in a timely manner
• Prepared documentation for migration of objects from development to test and test to production

Environment: Informatica Power Center 8.1.1/8.6.1, Informatica Power Exchange 8.6, Informatica metadata manager, SSIS 2005, Kimball Methodology, ORACLE 10g, Netezza 4.X, MS SQL Server 2005,Tsql, Web log, Erwin 7.0, Windows XP, PL/SQL, WinSQL, MS excel.