SUMMARY

• Over Eight years of focused experience in Information Technology with a strong background in Database development and Data warehousing and five year of ETL process. Worked in Healthcare Insurance, Retail, Telecommunication, Manufacturing and Financial/Mutual Funds Sectors.
• Extensive experience in handling all phases of the project..requirement gathering, design(decoding the functional design documents to Low level and high level design docs), development, unit testing, QA(identifying test case and implementing same), production (migration and support), Warranty support and Scheduling.
• Experienced in administration of the Informatica server jobs and health check of the repositories.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL/Informatica Power Center 9.0/8.6.1/7.1.3/6.2.1 (Designer, Workflow Manager, Workflow Monitor), and PowerConnect.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Emphasized on Performance of Mapping Optimizations in Informatica
• Expertise in developing SQL and PL/SQL codes through various procedures, functions, triggers to implement the business logics of database in Oracle and SQL Server 2000.
• Used various sources like Oracle, SQL Server, DB2, Flat files, and XML in creating reports.
• Experienced in using the Oracle SQL* Loader feature for loading the data from Flat Files to Data Base tables for Bulk Loading
• Automation and scheduling of Informatica jobs using UNIX shell scripting (CRONTAB) and AutoSys. Experienced in creating the generic scipts and reusable code to achieve same
• Understanding in writing Test plans, Test cases, Unit testing, System testing, Integration testing and Functional testing.
• Technical abilities are complemented by sound communication and good user interaction abilities, well versed with the quality processes

TECHNICAL SKILLS

ETL: Informatica Power Center 9.0/8.6.1/7.1.3/6.2.1/6.2/ (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager),Informatica PowerMart 6.2/6.1/5.1. x/4.7, Power Connect, Power Analyzer, Datamart, ETL, OLAP, ROLAP, MOLAP, OLTP, Star Schema, Snowflake Schema.

BI & Reporting: Business Objects 6.5, Cognos Series 8.0/7.0

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow - Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, ERwin 4.0/3.5.2/2.1.

Data Analysis: Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis

Databases: Oracle 10g/9i, Oracle 8i, Oracle 11i, 8.0/7.3, MS SQL Server 2008/2005, IBM DB2 UDB 8.0/7.0.

Programming: Unix Shell Scripting, SQL, PL/SQL, ISQL, ANSI SQL, SQL*Plus, HTML, DHTML, XML, Cobol.

Environment: UNIX (Sun Solaris, HP-UX, AIX), Windows 2003/2000/XP/98

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, California

Informatica /Developer

Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Worked on Informatica PowerCenter 8.1.1 - Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer to map the sources to the target, Mapplets and Transformation Developer.
• Extensively used flat files to load source data into Oracle target.
• Fine-tuned existing Informatica mappings for Performance Optimization.
• Involved in writing ETL process specifications and standards. Involve in writing best practice documents. Analyzing the data model and identification of heterogeneous data sources.
• Used Workflow manager to create, schedule, monitor, and send the messages in case of process failures. Developed several reusable transformations and Mapplets.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator. Worked with large volumes of data.
• Worked with the DBA to improve Informatica session performance and query performance by collecting statistics and defining relevant indexes on target tables.
• Designed, developed, and maintained PL/SQL packages, procedures, functions, and triggers to meet business requirements and enforce business rules.
• Developed complex PL/SQL packages and procedures to populate the data into Dimensions and Fact tables.
• Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data
• Created and maintained materialized views for better performance.
• Assisted in data modeling, planned and implemented indexing and partitioning.
• Involved in troubleshooting tuning the data warehouse and supported engineering and QA teams in problems diagnosis.
• Created and modified Oracle Schema objects including table, views, indexes, database links, sequences, and snapshots
• Implemented Unit Testing and involved in all phases of testing including Regression Testing, Integration Testing, System Testing and User Acceptance Testing.
• Written Unix Shell script to run scripts and perform other maintenance jobs.
• Tuned SQL queries using Explain plan and other Oracle features, diagnosed performance bottlenecks, and gave necessary Optimizer hints.

Environment: Oracle 10g. (10.1.0), Informatica PowerCenter 8.6.1, SQL, SQL, PL/SQL, SQL*Plus, ERwin, TOAD, Sql*Loader, Windows, UNIX, Rapid SQL, UDB7/8, SQL Server, PL/SQL, Flat files, SQL*Loader, HP - UNIX

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

• Involved in requirement gathering from the business users and converted them into mapping documentation.
• Worked with Business Analyst to gather business requirements and Involved in weekly team meetings
• Reviewed the business requirements and created internal and external design for informatica jobs.
• Involved in transfer of data to Connect3’s Promotion Manager.
• Worked with Connect3 support team to maintain the Informatica jobs.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, SQL Server, DB2 and loading to Oracle target database.
• Extensively used various types of transformations such as Expression, Normalizer, Joiner, Update strategy, Lookup (Connected and Unconnected) to load the data
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Devised extensive PL/SQL Stored Procedures and Triggers to populate the base tables on daily basis and implementing business rules and transformations
• Performed Mapping Optimizations to ensure maximum Efficiency
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session and Scheduled Workflows using AutoSys.
• Implemented complex mapping such as Slowly Changing Dimensions (Type II) using Flag.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.
• Worked on Changing or resetting passwords of database, repository server and repository in one settings
• Importing and exporting objects to different servers

Environment: Informatica Power Center 7.1.1(Informatica Server, Informatica Repository Server, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), ERwin 4.0/3.5, Oracle 10g/9i, SQL Server, DB2, PL/SQL, Flat files, SQL*Loader, TOAD, UNIX

Confidential, Blue Bell, PA

Informatica Developer

Responsibilities:

• Technical Communications with the client which includes the understanding the requirement of the client in the architecture TrueComp 3.7 & TrueComp5.1.2 system, environment setup and ETL process in the Development and Testing Environment.
• Worked on TrueComp 3.7 transactions which must be converted into the new transaction format through pre-pipeline process to properly manage retroactivity.
• Analyzed and documented the clients requirement process logic for Data Conversion
• Updated TrueComp 3.7 system using Informatica/ETL Partial Conversion approach
• Customized several delivered ETL mappings per requirements.
• Configuration and Administration of Informatica Servers.
• Created Source and Target Definitions in the repository using Informatica Source Analyzer and Warehouse Designer.
• Identified source systems, connectivity, tables, and fields, ensure data suitability for mapping.
• Creation of Sessions and executing them to load the data from the source system using Informatica Server Manager.
• Designed and developed complex join, look up transformation rules (business rules) to generate consolidated data.
• Error checking and testing of the ETL procedures and programs using Informatica session log.
• Validated mappings and generated custom SQL override for some of the mappings
• Worked on DB2 control center for populating and handling the TrueComp (DB2) data using complex SQL Queries
• Involved in onsite team for onsite-offshore coordination
• Written SQL, PL/SQL scripts code for extracting data to system
• Developed UNIX scripts for scheduling the jobs
• Conducted Unit testing and Integration testing.

Environment: Informatica Power Center 7.1.1/ Informatica Power Mart 6.1 Erwin 4.0/3.5, Oracle 10g/9i, SQL Server, DB2, PL/SQL, Flat files, SQL*Loader, TOAD, UNIX

Confidential, Philedelphia, PA

Oracle/PL-SQL Developer

Responsibilities:

• Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
• Involved in database modeling and database design.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Created database Tables, Indexes, Views, Materialized Views, Sequences in Development and Production environment using PL/SQL, SQL*Plus and Toad.
• Imported data from the legacy system into staging tables using SQL Loader, validating the data using PL/SQL procedure, inserting data into tables
• Created Records, Tables, Objects, Collections (Nested Tables) and Error Handling.
• Created number of database Triggers using PL/SQL.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.
• Participated in Performance Tuning

Environment: Oracle 8i, SQL, PL/SQL, SQL*Plus, TOAD, SQL*Loader, Windows

Confidential

Database Developer

Responsibilities:

• Supported Helpdesk DBA functions such as creating user account permissions.
• Normalizing the database and checking the consistency.
• Wrote stored procedure, triggers and function to implement business rules.
• Implemented various validation rules on the data by applying various integrity constraints as well as data validation rules.
• Managing the data dictionary.
• Understanding the change in business requirement and logics incorporating that change inside the database.
• Reducing the bottlenecks helping the query to execute by dropping or creating the indexes as per required.
• Extensively involved in tuning of the stored procedures, functions and triggers.

Environment: Oracle 7.3, MS SQL2000, XML, ERWin