SUMMARY

• 7 years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing.
• Expert in all phases of Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Expertise in data warehousing, ETL architecture, Data Profiling.
• Experience in working with various versions of Informatica Powercenter 8.6/8.5/8.1/7.1/6.2 - Client and Server tools.
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2 Mainframes.
• Strong experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, T-SQL, DTS.
• Expert in troubleshooting/debugging and improving performance Confidential different stages like database, workflows, mapping.
• Thorough Knowledge of different OLAP’s like DOLAP, MOLAP, ROLAP, HOLAP.
• Intense Knowledge in designing Fact & Dimension Tables, Physical & Logical data models using ERWIN 4.0 and Erwin methodologies like Forward & Reverse Engineering.
• Involved in writing Unit test cases for complex scenarios.
• Experience in creating UNIX shell scripts and Perl scripts.
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and knowledge in microstrategy.
• Knowledge in Installation and configuration of Informatica server with sql server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.
• Experience includes thorough domain knowledge of Business Financial system, Banking, healthcare information technology, Insurance & Reinsure, Pharmacy claims systems, Telecom Industry.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

Data warehousing: Informatica PowerCenter 8.6/8.5/8.1/7.1/6.2/5.1 , PowerExchange for DB2, Metadata Reporter Data Profiling, Data cleansing, OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling, Data Stage 7.x, Erwin 4.0

BI Tools: Business Objects XIR 2/6.0/5.1/5.0 , Microstrategy 8,Cognos 8

Databases: SQL Server 2005/2000/7.0/6.5 , Oracle 10g/9i/8i/8/7.3, Sybase, TeraData 6,My SQL, MS-Access, DB2 8.0/7.0

Languages: C, C++, XML, SQL, T-SQL, PL/SQL, UNIX Shell Scripting

Operating System: HP-UX11/10/9,IBM-AIX4.0/3.1, Sun Solaris 9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows XP Professional/2000/NT/98/95

Other Tools: MS Visual Source Safe, PVCS, Autosys, Control M, Remedy, Mercury Quality center, Star Team.

DB Tools: SQL*Plus, SQL*Loader, Export/Import, TOAD, SQL Navigator, SQL Trace

PROFESSIONAL EXPERIENCE

Confidential- Irvine CA

Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files and load into DataMart using the PowerCenter.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to DataMart.
• Developed Slowly Changing Dimension for Type 1, 2 & 3.
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Written procedures, Queries to retrieve data from DWH and implemented in DM.
• Data extraction and data Transfer from and to SQL Server Database using utilities / tools like BCP, and BULK INSERT.
• Written shell scripts in UNIX to execute the workflow
• Written shell scripts to run the workflows and automated them through maestro job scheduler.
• Responsible for submitting DBA requests, following up with data base DBA’s and Informatica administrators, creating remedy ticket, handling all the singoff’s for the production, updating all changes with new versions using START team, creating test cases using Quality Center.
• Written SQL Queries, Triggers, PL/SQL Procedures to apply and maintain the Business Rules.
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Written Indexes, primary keys and checked other performance tuning Confidential data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Involved in generating reports from Data Mart using Cognos.
• Defects were tracked, reviewed and analysed.
• 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.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.

Environment: Informatica PowerCenter 8.6/8.5, SQL Server 2005/2000, Oracle 10g, Teradata 6, SQL, PL/SQL,IBM AIX, UNIX Shell Scripts, Cognos, Erwin, STAR team, Remedy, Maestro job scheduler, Mercury Quality Center

Confidential - Oklahoma City - OK

ETL Developer

Responsibilities:

• Responsible for development of ETL processes to extract data from legacy systems and to load it to Datawarehouse.
• Participated in discussions with business analysts along with Technical lead and to clarify business requirements.
• Implemented project in onsite offshore model and coordinated development work with offshore resources on day to Day basis.
• Designed ETL mappings using various transformations like Router, Update strategy, Filter, Joiner to cater business requirements.
• Held discussions with ETL Architect to make sure ETL design is as per industry standards and best practices are followed.
• Developed PLSQL procedures to the requirement in complex business scenarios and thus reduce the effort on ETL Side.
• Performed unit testing to validate new code and documented test cases for multiple scenarios and revisited the code in case of any failures.
• Maintained version based documents for reference using Team room.
• Performed Integration testing by coordinating with multiple teams and updated business users about the status on weekly basis.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in writing UNIX shell scripts for Informatica ETL tool to automate sessions.
• Monitored sessions using the workflow monitor which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Involved in extensive performance tuning by determining bottlenecks Confidential various points like targets, sources, mappings and sessions.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Developed Mapplets using corresponding Source and Transformations.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and worked on workflow manager.

Environment: Oracle 10g, Informatica Power Center 8.6.1/9.0, UNIX, Control M, Toad 9.0, SQL, PL/SQL, Flat files, Unix Shell Scripting and Business objects, Windows XP.

Confidential, Cambridge

ETL Developer

Responsibilities:

• Designed technical layout considering Standardization, Reusability, and Scope to improve if need be.
• Documented the purpose of Data Warehouse (including transformations, mapplets, mappings, sessions, and batches) so as to facilitate the personnel to understand the process and in corporate the changes as when necessary.
• Developed complex mappings to extract source data from heterogeneous databases Tera Data, SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and pl/sql code in Autosys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Conducted UAT (User Acceptance Testing) with user community
• Developed K-shell scripts to run from Informatica pre-session, post session commands. Set up on Success and on Failure emails to send reports to the team.

Environment: Informatica PowerCenter 7.1, Oracle9i, SQL Server 2000, Erwin, XML, TOAD, HP - Unix 11.11, Dendrite Webforce, Cognos Report Net.

Confidential

ETL Developer

Responsibilities:

• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Created new mappings according to business rules to extract data from different sources, transform and load target databases.
• Debugged the failed mappings and fixed them.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Modified the mappings according to the new changes and implemented the persistent cache in several mappings for better performance.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs in pre and post sessions to modify parameter files, prepare data sources.
• Identified the issues in sources, targets, mappings and sessions and tuned them to improve performance.
• Created and used reusable mapplets and worklets to reduce the redundancy.
• Developed robust Informatica mappings and fine-tuned them to process lot of input records.

Environment: Informatica power center, Oracle9i, SQL, PL/SQL, Solaris, MS Vision, Ms-Access

Confidential

Data Warehouse Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Extracted data from source systems to a staging database running on DB2.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, and Transformations Developer.
• Developed mappings with transformations and mapplets confirming to the business rules.
• Processed session data using threads and various tasks (session, command etc.), scheduled workflows and managed DSN connections.
• Created shared folders, local and global shortcuts to reuse metadata.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Used Informatica repository manager to backup and migrate metadata in development, test systems.

Environment: Informatica Power Center 7.1, SQL Server 2000, Flat Files, SQL, TOAD 8.0, Oracle 9i, DB2, Windows 98/2000.