SUMMARY

• 12 years of total IT experience in Business Requirement Analysis, Application Design, Data Modeling, Dimensional Data Modeling, Development, Implementation & Testing of Data Warehousing, Data Migration and Database business systems for banking, Financial and Telecom domain. Worked in all phases of SDLC and have a clear understanding of all the SDLC methodologies. Highly organized with ability to manage the Tasks/Projects and meet deadlines with a high degree of customer satisfaction. Excellent communication, analytical, verbal, writing and presentation skills.
• Experience in the Requirement Gathering/Analysis, Data Analysis, Application Design, Application Development, Implementations and Testing of Applications in Data warehouse, and Client/Server Projects
• Experience in Informatica Power Center 9.x and 8.x. Extensively worked with Informatica components such as Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Administration Console.
• Proficient in Designing, Creating, Executing, Testing & Debugging the Mappings, Mapplets, Reusable Transformations, Sessions, Batches, Workflows, and Workflow Scheduling.
• Expertise in performance tuning by identifying the bottlenecks Confidential source, target, mapping, session, and system level.
• Strong knowledge of Dimensional Data Modeling concepts, Star/Snowflake Schema Modeling, Entity - Relationship Modeling, FACT & Dimension table’s Physical & logical designs, etc.
• Proficient in Data Extraction, Transformation, Data Cleansing, Data Profiling, Data Quality and Loading techniques to build scalable, end-to-end Data Warehouse and Data Marts.
• Proficiency in overall ETL design (from staging to presentation layer), using market leading ETL tool Informatica.
• Good hands on experience on creating Informatica Mapping, Transformations, Sessions and Workflows.
• Extensive knowledge of various kinds of Informatica Transformations (like Aggregator Expression, Filter, Joiner, Lookup, Normalizer, Rank, Router, Sequence Generator, Sorter, Source Qualifier, SQL, Stored Procedure, Union, Update Strategy)
• Experience in Reusable components which include Reusable Transformations, Mapplets, Reusable Tasks and Worklets.
• Excellent experience in ETL Tools like Informatica and on implementing Slowly Changing Dimensions (SCD).
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Very strong experience in Oracle Development (Functions, Procedure, Packages, Views, Materialized views, Triggers using cursors (static/dynamic) and exceptional handling etc.
• Experience in PL/SQL object orientation like Records, PL/SQL Table by using bulk command etc. and LOBS (BLOB/CLOB/NLOB).
• Expertise in Performance Tuning using various tools like STATPACK, TRKPROF and monitoring database activities with the power of TOAD and PL/SQL developer etc.
• Database Management activities like Performance Tuning, Backup and Recoveries, Schema Analyses, setting alerts, Troubleshooting etc.
• Hands on experience in Teradata SQL Assistant, Teradata Load utilities like, BTEQ, Fast export, Fast Load, Multi Load and TPump.
• Extensive experience in TWS Administration like shutting down the master and agent services, resetting production Plan, access management for conman and composer program and password management etc.
• Strong in Linux/Unix shell scripting.
• Experience in Connect Direct Administration and SSH key configuration for SFTP
• Excellent communication and interpersonal skills, Proactive, Dedicated and Enjoy learning new Technologies and Tools.
• Experience in OBIEE Administration, and Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Provide the Dashboard access to the Users through the EBS and setting up the security levels.
• Migration of catalog items between Development, Test and Production server.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.0.1/9.5.1/8.6.1 , Informatica Developer, Power Exchange, TWS, B2B Data Transformations.

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling using ER Studio.

Job Function: Developer, Administrator, Maintenance, Analysis, Programming, Testing, Documentation, CM (Configuration Manager)

Databases: Teradata 14/13/12/V2R5,Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2008/ 2000/7.0/6.0

Scheduler: TWS (Tivoli workload Scheduler)

Programming GUI: Teradata SQL, SQL, PL/SQL, SQL Plus, Transact SQL, Java/J2EE, XML, Web Services, HTML, C, Unix Shell Scripting, SQL*Plus, TOAD.

Web Development: HTML/DHTML/ASP, Scripting(VB&JAVA)

Web Application Server: Tomcat, Web logic 8.2

Environment: Win 95/98, Win NT, Red Hat Linux, Unix, Win 2000, Win XP and Windows 7.

Transfer Method: FTP, SFTP,SCP and Connect Direct

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr. Informatica Developer

Responsibilities:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Extracted data from relational databases DB2, Oracle and Flat Files.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and convert into DPP System.
• Developed data Mappings, Transformations between source systems.
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.
• Used debugger to test the mapping and fixed the bugs.
• Created sessions, sequential and concurrent batches for proper execution of mappings using server manager.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data).
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Responsible for managing Data Modeling, physical and logical databases using ER Studio.
• Check in Logical Database in ER Studio and Physical in Star Team to manage compatibility.

Environment: Informatica Power Center 9.5, Power Exchange, Oracle 11i, SQL, PL/SQL, TOAD, ER Studio, SQL SERVER 2005/2008, XML, T-SQL, Shell Scripts, SQL Navigator, SQL Developer & DB Visualizer.

Confidential, Richardson, TX

Sr. Informatica Lead/Developer/ Admin

Responsibilities:

• Interacted with business user in the analysis and development phase and was involved in requirement gathering, prepared various documents like Technical design documents, Integration test plan, unit test plan and resolved business related issues.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Creating Users, Groups, Folders, assigned permissions using Repository Manager and Informatica Administration console.
• As an Administrator, monitoring Informatica repository health through Informatica admin console.
• Involved in day to day deploy objects from lower environments to higher environments. worked on DR Exercises and tested failover of the major ETL business batch jobs
• Involved in the process of informatica upgrade from version 9.0.1 to 9.5.1.
• Supported the Infrastructure planned maintenance and outages.
• Installed the third party Ssh keys into Informatica based on requests.
• Submitted the Firewall request to network Admins based on the project requests and tested the connectivity from Informatica environment, if opens the firewall.
• Worked on refreshing TEST/Dev/Prod environments on regular basis as per the project needs.
• Expertise in taking backups, recovery of workflows, sessions and mappings from repositories.
• Scheduled batch jobs using Informatica job scheduling and TWS.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Scheduled the jobs to run in Informatica environment using the Crontab scheduler.
• Written the shell scripts to take a repository backup and domain backup on daily basis.
• Providing Tools support on various tools like Informatica, TWS, Teradata, Vertica etc.
• Managing TWS workstation and agents services, providing access and resetting production plan.
• Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
• Worked extensively on transformations like Lookups, Aggregator, Update Strategy, Stored Procedure, Sequence generator, Joiner transformations
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Configured SFTP (password less) and connect Direct (NDM) installation and setup.

Environment: Informatica Power Center 8.6.1/9.0.1/9.5.1 , Oracle 11g/10g, PL/SQL, TOAD, SQL Server 2008, TWS Scheduler, Control-M, Crontab, Clear Case, Red Hat Linux, Unix Shell scripting, Teradata V13, Teradata utilities(TPT &TTU)

Confidential, Denver CO

Sr. Informatica/Lead Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Automated the Informatica jobs using UNIX shell scripting.
• Wrote PMCMD and PMREP commands and Korn Shell scripts to automate various administrative tasks
• Interaction with the offshore team on a daily basis on the development activities.

Environment: UNIX, Informatica Power Center 9.0.1 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, SQL, PL/SQL Developer, Delimited Flat files

Confidential, Bothell WA

Sr. Informatica Developer

Responsibilities:

• Designed and developed the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling, system testing, performance tuning.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Implemented effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Source data analysis/profiling where necessary.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Created post-session and pre-session shell scripts and mail-notifications
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Created Several Stored Procedures to update several tables and insert audit tables as part of the process.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• Written Unix Shell Scripts for getting data from various source systems to Data Warehouse.

Environment: Informatica Power Center 8.6.1, SQL Server 2008, Shell Scripts, Oracle 10g, SQL, PL/SQL, UNIX,, Toad, SQL Developer, Teradata

Confidential, Atlanta GA

Informatica Developer

Responsibilities:

• Responsible for design and development of Data Warehouse project leveraging Informatica Power Center ETL tool
• Primarily responsible for ETL design, coding and testing strategy
• Responsible for Impact Analysis, upstream/downstream impacts.
• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer, Maple, and Transformation Developer.
• Extracted data from DB2, XML, Flat files, Sequential files, IMS and loaded in Enterprise Datawarehouse on Oracle
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Developed Unit test cases and Unit test plans to check if the data is correctly loading.
• Data quality checking and interacting with the business analysts
• Developing control files, Stored Procedures to manipulate and load the data into Oracle database
• Created shell script for archiving files and trigger files
• Responsible for Unit Testing, Day2 testing and helped with User Acceptance Testing.
• Scheduling Informatica jobs and implementing dependencies if necessary
• Managed post production issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 8.6.1/8.1, SQL Server 2005, DB2, Shell Scripts, Oracle 9i, SQL, PL/SQL, Ultra Edit, Quality Center.

Confidential

Oracle Developer

Responsibilities:

• Developed complex SQL queries Integrated in the Analytics Reports Engine based on the client’s specifications and customization.
• Developed project by creating schema object such as functions, procedures, packages, view, matviews etc by using cursors, dynamic sql and exceptional handling etc as per the model designed.
• Performance Tuning from both development and DBA point of view.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Developed Re-org (Table space move, index rebuilding and table analyze) script to gain the performance improvement of DB and scheduled them as per volume of data by writing unix script.
• Created DB jobs and scheduled them accordingly to automate the process by writing unix script.
• Monitoring alerts and rectifying the alerts.
• Increased the size of table spaces (main/temp) if needed.
• Tuned already running queies and monitor high I/O generated SQL’s.
• Database activities like schema creation, index maintenance and table space size monitoring.
• Created materialized views if needed and refresh accordingly.
• Database backup and recoveries.
• Gathered Performance report and scheduling proactive maintenance activities.
• Worked on existence reports and bug fixing.
• Developed various reports by writing SQL queries.
• Provide technical assistance to other Developers as needed.
• Analyze and troubleshoot system issues in a timely manner.

Environment: Oracle 9i/10g using PL/SQL Developer, TOAD, SQL developer, UNIX

Confidential

Informatica/Oracle Developer

Responsibilities:

• Extensively used all Informatica Client tools and various transformations such as Lookup, Filter, Expression (reusable), Router, Rank, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator and Normalizer.
• Designed Informatica mapplets and worklets to utilize the reusability feature of Informatica.
• Used the update strategy to effectively load data from source to target.
• Tuned INFORMATICA mappings, sessions and SQL queries. Unit testing of mappings and sessions
• Worked extensively with dynamic cache with the connected lookup Transformations.
• Designed and optimized the Mapping to load the data in slowly changing dimensions.
• Focused on fixed and de-limited flat files, also worked with direct and indirect flat files.
• Perform design and development by creating schema object such as functions, procedures, packages, veiw, matriealized view etc by using cursors, dynamic sql and exceptional handling etc as per the model designed.
• Design, code, and maintain the Oracle systems based on established standards.
• Understand project requirements and develop design specifications.
• Perform initial design reviews and recommend improvements.
• Write clear codes and prepare coding documentations.
• Provide technical assistance to other Developers as needed.
• Analyze and troubleshoot system issues in a timely manner.
• Modify existing codes to optimize Oracle applications.
• Create DB jobs and scheduled them for automation.
• Gathered Performance report (using explain plan, TKProof and stat pack) and scheduling proactive maintenance activities.
• Migrate ETL data load from one system to DW system by passing and filtering in different Layers like Staging, ODS and Data Mining.
• Perform all business checks like cleaning, triming, creating new dimensions and partitions etc.
• Developed monthly report as per business requirements and schedule them in crystal report.
• Perform DBA activities like increase the size of particular tables pace (Add datafiles) if running out of space and take back create partition tables before performing any major activities.
• Create Re-org script and perform as per data load.
• Assist in system integration and acceptance testing and perform bug fixes less experienced staffs on programming guidelines.
• Develop database schemas, tables, procedures and permissions.
• Develop shell scripts and data management scripts.
• Determine capacity analysis and perform database tuning to improve efficiency.
• Enforce best practices for optimal performance.

Environment: Informatica, Oracle 8i/9i using PL/SQL Developer, TOAD, SQL developer, Crystal Report.