SUMMARY

• Over 7 years of IT experience with extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modelling, Development, Maintenance, Testing and Documentation.
• Excellence in the implementation of Data Warehouse and Business Intelligence using ETL tools like Informatica PowerCenter (versions 9.x/8.x) PowerMart, PowerExchange (version 9), and PowerAnalyzer.
• Highly motivated and goal - oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Netezza, Teradata, Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Hands on experience on Teradata V2R6, 12.0, 13.0, Teradata SQL Assistant.
• Extensive experience in developing Stored Procedures, Functions, Views, Triggers, Complex SQL queries using SQL Server, TSQL, Teradata and Oracle PL/SQL.
• Extensively used Teradata Utilities like Tpump, Fast-Load, MultiLoad, BTEQ and Fast-Export, TPT (Teradata Parallel Transporter).
• Experienced introubleshootingTeradata scripts, fixing bugs and addressingproduction issues andperformance tuning.
• Experience in developing XML/XSD/XSLT as a part of Source XML files for Informatica and also Input XML for Web service Call.
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
• Maintaining and Supporting during Assembly/Integration Test, QA, UAT, and Production for Issues/Bug fixes/Defects.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables and developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modelling.
• Good in SQL tuning and Informatica performance tuning. Tuned performance of Informatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Projects, Models using Cognos Framework Manager andpublished packagesto Cognos Server for reporting authoring.
• Good in OLAP Data modelling, for both Star Schemas and Snowflake Schemas. Solid understanding of Data Warehousing life cycle and strong working experience on Data Warehousing applications.
• Good experience in Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using CONTROL-M and WLM scheduling tools.
• Experience with coordinating and leading onsite-offshore development.
• Excellent team player with very good communication skills and leadership qualities.

TECHNICAL SKILLS

Operating System: Windows/XP/7/UNIX/Ubuntu

Database and utilities: Oracle 9i/10g/11g, MS SQLServer, Teradata V2R6, 12.0, 13.0 Teradata SQL Assistant, BTEQ, Sybase, Erwin 3.5/4.0, IBM DB2, Business Objects.

Informatica Tools: Informatica PowerCenter 9.6/9.5/8.6/8.1/7.1, Informatica B2BDT, Informatica Power exchange, Informatica Data Analyser.

Database Tools: SQL developer, TOAD

Programming Languages: C, Java, SQL, PL/SQL, HTML, UNIX Shell ScriptOther Tools: WLM, Autosys, Control-M, Crystal Reports, OBIEE, Cognos, Rational Clear Case, Rational Clear Quest, Tivoli.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, Virginia

Informatica /Teradata Developer

Responsibilities:

• Analyzing business processes, functions, existing transactional database schemas and designing star schema models to support the users reporting needs and requirements
• Communicating with business users to resolve their issues, follow-up with users and team to resolve the issues.
• Developed ETL procedures to ensure conformity, compliance with Confidential standards.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Developed New Mappings based on existing business logic from the Main frame (DB2) system to work with Teradata databases as source systems.
• Generated Delimited Flat files which were sent to Main frame system using FTP In Post Session Command task.
• Developed the transformation logic; identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Created volatile tables, global temporary tables, indexes, macros, and stored procedures, Teradata analytical functions for Data quality, fallbacks and table joins, access methods against tables.
• Teradata Macro, Fastload, CustomizedBusiness Viewsdevelopment. Hands on experience leading all stages of system development efforts, including requirement definition, design, architecture, testing, support and administration.Re-conciliationofdata&Error handling.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Analyzed all the critical andHigh priority defectsand fully responsible for fixing it.
• Involved in various transformations like Source Qualifier, Look up, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Created Informatica server administration automation scripts, Shell scripts for data manipulation and process automation using UNIX Shell scripting.
• Generated BTEQ scripts for data manipulation, validation and provided DDL scripts for creation of database objects such as tables, indexes, views, sequences, object types, collection types and Materialized Views.
• Created, Scheduled and Monitored Batches and Sessions using Power Center Server Manager/WLM .

Environment: Informatica PowerCenter 9.6.1, Teradata, BTEQ Scripts, DB2 IBM Clear Case, Citrix WLM, Unix Shell, Teradata Utilities, Flat files (fixed width/delimited).

Confidential, CT

Informatica IDQ /Teradata Developer

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rule and responsible for developing, support and maintenance for the ETL process using Informatica.
• Designed, developed, implemented and maintainedInformaticaPowerCenter and IDQ 8.6.1 application for matching and merging process.
• Architected and developedFast LoadandMLoadscripts in control file,developedBTEQ scriptsto process the data in staging server.
• Developed complex mappings using Informatica PowerCenter Designer to transform and load the data from various source systems like Oracle, Teradata, and Sybase into the Oracle target database.
• Build a re-usable staging area in Oracle for loading data from multiple source systems using template tables for profiling and cleansing in IDQ or QualityStage.
• Extensively Worked in Processing Structured and Unstructured data .
• Through explain plan, analyzed and modified indexes and modified queries with derived or temporary tables to improve the performance. Also utilized Teradata viewpoint.
• Used BTEQ andSQL Assistant(Query man) front-endtools to issue SQL commands matching the business requirements to TeradataRDBMS.
• Designed anddeveloped physical models with appropriatePrimary,Secondary, PPIandJoin Indextaking into consideration of both planned access of data and even distribution of dataacross all the available AMPs.
• Maintaining the Quality matrices, Knowledge management and Defect prevention & analysis.
• Used breakpoints and various test conditions with Debugger tool to test the logic and the validity of the data moving through the mappings.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Using Source Qualifier & Lookup SQL overrides, Persistent caches, Incremental Aggregation, Partitions, and Parameter Files for better performance.
• Used session logs, workflow logs and debugger to debug the session and analyse the problem associated with the mappings and generic scripts
• Developed models inFramework Managerand deployed packages to theCognos Connection.
• Published different packages fromFramework ManagertoCognos Connection.
• Set securityfor individual reports inCognos Connection.
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica Workflow Manager.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.

Environment: Informatica PowerCenter 9.5, Informatica IDQ 8.6.1, Teradata R13, TOAD, Oracle 10g, Korn Shell, XSD, Cognos, Erwin.

Confidential, MCLEAN, VA

Informatica Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts
• Developed ETL mappings, Transformations and Loading using Informatica Power Center
• Used Active as well as Passive advanced external procedure transformations involving high complexity.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i.
• Developed and tested all Informatica mappings involving Advanced External Procedure, complex lookups and update strategies.
• Wrote Shell scripts to create file list for different kinds of flat files that included both delimited and fixed width files.
• Support production team on data quality issues, load failures and providing them break fixes and ways to load large data into Teradata tables usingMLOAD, FLOADand worked on performance tuning in Teradata.
• Involved in partitioning of the sessions and performance tuning of database and Informatica
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner and normalizer.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Extensively used PL/SQL, TOAD for creating views, stored procedure, and indexes on the tables.
• Tiwoli Workflow scheduler (TWS) was used as a part of scheduling and performed unit testing and integration testing in the mappings.

Environment: Informatica PowerCenter 9.1, Erwin 4.2, Teradata 13.0Teradata Fast Load, Multi Load, TPUMP, BTEQ, Oracle 9i, TOAD, PL/SQL, Toad 7.6.0.1.1, SOAP UI,UNIX, TWS.

Confidential, Houston- Texas

Informatica Developer

Responsibilities:

• Responsible for business analysis and requirements collection and involved in designing technical specification.
• Performed database health checks and tuned the databases using TOAD.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Extensively involved in writing Oracle PL/SQL Stored Procedures and to create the necessary indexes and work tables for performing the ETL process
• Developed data Mappings, Transformations between source systems and warehouse.
• Developed mapping parameters and variables to support SQL override.
• Created sessions, sequential and concurrent sessions for proper execution of mappings in workflow manager.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Used Power Center Data Masking Options (Random Masking, Blurring, SSN and Credit Card) in mappings.
• Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
• Managed writing test cases, test scenarios from requirement for newly added features and executing test scripts.
• Recording, tracking and closing of defects/bugs in a systematic manner into a Defect Tracking System and preparation of bug report with bug severity and bug priority.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Rational Clear case is used to Controlling versions of all files & Folders.
• Prepare implementation/deployment plan in production on code migration like Informatica objects and UNIX scripts.
• Defect Tracking and reports are done by Rational Clear Quest.
• Prepared Test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.

Environment: Informatica PowerCenter 8.6.1, Oracle10g, TOAD, Access, Flat files, UNIX shell scripting, Windows 7, Rational Clear Case, Rational Clear Quest.

Confidential

Oracle/ETL Developer

Responsibilities:

• Involved in designing and developing the database for the business division of Creative Eye at Focus for effectively managing manufacturing processes.
• Designed and developed database views and stored procedures.
• Maintained user roles and privileges at the database level.
• Involved in enrolling users, maintaining the system security.
• Involved in controlling and monitoring user access.
• Used SQL to extract the data from the database.
• Worked with Development Life Cycle teams.
• Wrote Stored procedures, Stored functions, Packages and used in many Forms and Reports
• Wrote database triggers for automatic updating the tables and views.
• Designed and developed forms and reports.
• Involved in the creation of jobs using Informatica workflow manager to validate schedule run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.

Environment: Informatica PowerCenter 7.1, Oracle, Reports 2.5, SQL, PL/SQL, Windows XP, SQL Navigator, Erwin3.5, UNIX