SUMMARY:

• 10 years of experience in Data Warehousing & Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 8.6/8.5/8.0/7. x/6.x/5.x/4.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager and Informatica server), Informatica PowerMart 6.2/6.1/5.1/4.7, Power Analyzer, Power Connect, OLTP, OLAP, Autosys, Control M, Crontab, IMS Rx Data (Xponent, Xponent Plantrak, PlanTrak, Rx Data)Data Modeling experience using Dimensional Data modeling, Relational Data modeling, Star Join Schema modeling, Snow - Flake modeling, FACT and Dimensions tables, Physical and logical data modeling, Erwin 4.5/4.0/3.5/3.0, Oracle Designer, MS Visio
• Designing experience on Data Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis
• Data Cleansing experience using Firstlogic and Trillium 7.6/6.0 (Converter, Parser, Geocoder, Matcher), SQL coding and UNIX shell scripting for address cleansing, profiling and segmentation of customer data.
• Experience in Business Intelligence tools like Business Objects 6.5/6.0/5.1, Web Intelligence 2.5, Business Objects Designer, Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), Business Object Universe Developer, Business Objects Set Analyzer 2.0, Business Objects Reporting, Cognos Impromptu 7.0/6.0, Cognos Power Play.
• Experience using Oracle 10g/9i/8i/7.x, SQL, PL/SQL, SQL Plus, SQL Loader, IBM DB2 8.0/7.0, MS SQL Server 6.5/7.0.2000, SQL Navigator, Teradata V 13/ V2R5/V2R4/V2R3, MS Access 2000, Developer 2000, Windows 95/98/2000/XP, Win NT 4.0 and Sun Solaris. Well versed in all the RDBMS concepts

TECHNICAL SKILLS:

ETL Tools: Informatica Power center 8.6, 9.1, 9.5, 9.7

Scripting Languages: UNIX Shell scripting

Databases: Oracle 8i/9i/10g/11g, Teradata, SQL server

Database Tools: TOAD

Loaders: SQL loader, Fastload, TPT, Multiload

Methodologies: Star schema, Snowflake schema

Testing tools: QTP, HP Quality center

Scheduling tools: Autosys, Maestro

Operating systems: UNIX, Windows

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Sr. ETL Developer/Production Support

Responsibilities:

• Duties included coordination, attending meetings, and the review of requirements, infrastructure setup, task assignments and code reviews.
• Designed ETL specifications based on the functional requirements and DA specifications.
• Responsible for the analysis of data in data warehouse and maintain the Data integrity.
• Extensively worked on creating Informatica mappings, workflows, mapplets, worklets, sessions
• Extensively used all the transformations like Stored procedures, Lookups, Update Strategy, Normalizer, Expression, Router, Filter, Union etc
• Extensive knowledge on using Informatica debugger for trouble shooting purposes
• Extensive knowledge in scheduling the workflows using various scheduling tools
• Tuned sources, targets, transformations, mappings and SQL queries & PL/SQL procedures for better performance.
• Developed UNIX shell scripts to invoke Teradata load utilities, to transfer files using FTP, SFTP and connect direct and to automate ET jobs and load jobs.
• Developed MLOAD scripts to load data to Teradata warehouse.
• Developed Complex Teradata SQL in BTEQ scripts to transform the data in Teradata staging tables before loading into data mart.
• Developed BTEQ scripts to extract data from warehouse for downstream applications.
• Setup Maestro scheduler in system test environment to mimic the production environment. Scheduled jobs for batch processing using Maestro Scheduler.
• Involved in the deployment of code from Development to System Test environments; System Test to Production.
• Worked closely with production support team to resolve production failures and meeting the SLA.

Environment: Informatica Power Center 8.6/8.5/8.0(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor, Worklet Designer, Metadata Manager), Oracle, Teradata, BTEQ, Unix Script, Flat Files, SQL Server, PL/SQL, Erwin 4.0, Maestro.

Confidential, Stamford, CT

Informatica Consultant

Responsibilities:

• Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Analyzed source data and gathered requirements from the business users.
• Worked on understanding and creating ETL Design documents and specifications.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Created Logical and Physical models for the Datamart using Erwin 4.5
• Created Autosys jobs and scheduled Informatica jobs through Autosys.
• Developed mappings with transformations and mapplets confirming to the business rules.
• Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformation, Expressions, Aggregator, Sequence Generator.
• Processed session data using threads and various tasks (session, command etc.) and managed database connections and scheduled workflows.
• Informatica and tested with high volume of data.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extensively used stored procedures and also worked with parallel processing.
• Created shared folders, local and global shortcuts to reuse metadata.
• Maintain warehouse metadata, naming standards and warehouse standards for future application development.
• Worked on issues with migration from development to testing to production.

Environment: Informatica Power Center 8.5/8.0(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor, Worklet Designer, Metadata Manager), Unix Script, Flat Files, Oracle, PL/SQL, Erwin 4.0, Autosys.

Confidential, St. Louis, MO

Informatica Designer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Worked on Informatica (Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, and Repository Manager & Informatica Server Manager).
• Identified various source systems for data feeds.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Created mappings to extract data from Staging area to enterprise data warehouse with applying various business rules.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner).
• Created Connected and unconnected transformations to look up the data from the source and target tables.
• Performance tuning of ETL transformations, workflows and PL/SQL procedures.
• Was involved in troubleshooting and problems resolutions.
• Tuned Source, Targets, Mappings, Transformations and sessions for better performance.
• Used Crontab for scheduling jobs.
• Migrated reports from the Informatica environment to Business Objects XI.
• Responsible for Universe Designing, Hierarchy Building for Data Analysis and applying conditions in Business Objects.
• Used BTEQ, MLOAD, Fastload for loading into the Data Warehouse
• Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD.
• Developed highly complex reports using reporter and used various techniques like
• Master-Detail, Sectioning, Filters, Slice and Dice, Rankings.
• Created reports and generated graphs for multi-dimensional analysis using Slice & Dice, Drill Up/Down functionality.
• Documentation for Analysis, Design, Development, Testing and Production.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Was responsible for identifying and resolving any production issues and bugs.

Environment: Informatica Power Center 8.0/7.1, Teradata V2R5, Business Objects 6.5, Flat files, PowerMart 6.2, Work Flow Manager, Work Flow Monitor, Crontab, TOAD 8.6, Oracle 10g, SQL, PL/SQL, Windows NT/2000, HP-Unix

Confidential, Kingsville

Database developer

Responsibilities:

• Creating oracle database tables, Indexes, Primary keys.
• To Develop Packages to interface with Portal.
• Develop Reports using Report builder 6i and Discoverer.
• Develop test scripts to test various scenarios.