SUMMARY

• Having 10+ years of experience in Architecture, Analysis, Design, Development, Support and Documentation of Software using various platforms such as Informatica, DB2, J.D. Edwards OneWorld, Sybase, Oracle, C, C++ and several design and development tools.
• Including 8+ years of extensive experience in Data Warehouse applications using Informatica, Oracle, DB2 on Windows, Confidential and UNIX platforms.
• Experienced in working in ERP Financials such AR/AP/GL/FA, Retail Sales Analytics and Financial Analytics Domains.
• Experienced in full Software Development Life Cycle (SDLC) process in both OLTP and OLAP projects.
• Solid understanding of the philosophies of Mr. William Inmon, 'Father of Data Warehousing' and Mr. Ralph Kimball, 'Father of Business Intelligence' with the ability of practical application of their approaches, structures and content.
• Thorough understanding of Informatica PowerCenter Integration Service Architecture with the capability of its practical application in all stages of ETL processes.
• Excellent understanding of Informatica PowerCenter Data Transformation Manager functionality in order to leverage in the ETL process development.
• Experienced in extracting data from multiple sources such as various relational database operational data sources and flat files from the landing server and resolving the surrounding issues.
• Well versed in the Four Step Dimensional Design Process of Selecting the Business Process, Declaring the Grain, Identifying the Dimensions, Identifying the Facts regardless of the domain of the project.
• Experienced in identifying and formulating Fact Tables such as Additive, Semi - Additive, Non-Additive, Nulls, Conformed, Transaction Facts, Periodic vs. Accumulating Snapshot Facts, Factless, Aggregated, and Consolidated based on the domain and the business requirements.
• Experienced in identifying and formulating Dimension Tables based on the behaviour of the Dimensions, Designing and Implementing Slowly Changing Dimensions of the three common types and Dealing with Dimension Hierarchies such as Fixed Depth vs. Variable Depth (Slightly Ragged vs. Ragged).
• Good knowledge in data warehousing techniques for Data Cleansing, Surrogate Key Assignment and Change Data Capture
• Experienced in doing High Level and Low level Designing, and creating Source to Target Mapping documents, setting up performance guidelines.
• Expert in working with Informatica PowerCenter tools - Repository Manager, Designer, workflow Manager and Workflow Monitor.
• Extensively worked in Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet & Mapping Designer.
• Experienced in Designing and Developing complex mappings using various transformations such as Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy as per business requirements, keeping it performance oriented.
• Experienced in developing Sessions/Tasks, Worklets and Workflows using Workflow Manager tools -Task Developer, Workflow & Worklet Designer.
• Experienced in Performance Tuning by identifying and eliminating the bottlenecks at targets, sources, mappings, transformations, and session in that order and improving overall performance for large volume data sets.
• Experienced in debugging mappings, identifying bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Good experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experienced in Oracle and Sybase environments using Triggers, functions, Stored Procedures, SQL, T-SQL and PL/SQL.
• Expertise in scheduling Informatica jobs using Informatica workflow scheduler, command line utilities with Unix shell scripts.
• Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.
• Self-motivated and enjoy working independently as well as being part of a team.
• Quick learner and adaptive to new and challenging technological environments.
• Able to develop effective working relationships with client team.
• Excellent interpersonal skills and communication skills, technically competent and result- oriented.
• Able to effortlessly remain calm, centred and neutral in any stressful situation.
• Understanding the primary value chain of business processes and the process flows, understanding the data standards, setup, daily operational flows, daily data modifications and their volumes, the various milestones in a given business process flow, understanding and identifying all possible sources of data, the format and the frequency.
• Arriving at an understanding of the Key Performance Indicators of the business, the current availability and visibility of these to the decision making authorities, identifying the gap between what is and what is desired from the business analysts, listing business processes, measures and the supporting who/what/where/why and how. Identifying the facts, dimensions, the grains of the facts and dimensions an d correlating them.
• Dimensional data modeling focused on details such as dimensions, facts, their detail attributes, types and number of facts tables needed, the conformed dimensions between different facts, handling the slowly changing dimension attributes by combining various update strategies, understanding the dimension hierarchies and identifying the strategies to implement them, evaluating the need for mini dimensions and outriggers (leading to snow flakes) and balancing them with business needs, identifying and properly labeling the role playing dimensions within and across multiple star schemas, evaluating the pros and cons of having a super-type or core fact table plus several sub-type fact tables vs creating multiple fact tables for heterogeneous lines of business within the organization and making the decision in alignment with the vision of the project, evaluating the pros and cons of creating classic accumulating snapshot fact tables vs. Timespan Accumulating snapshot fact tables, identifying the multi-valued dimension attributes and drafting the bridge tables for them, identifying and grouping the attributes for junk dimension, Formulating the audit dimensions to track the data lineage, Designing the Error/ Reject Data process flow.
• Experienced in data analysis, data transformation, and conceptual data modeling.

TECHNICAL SKILLS

Operating Systems: UNIX (SUN-Solaris, HP-UX), Windows 95/98, Windows NT/2000/XP

Programming Languages: COBOL, C, SQL, PL/SQL, T-SQL

Scripting Languages: UNIX Shell Scripting, UNIX Shell Commands

Databases: Oracle 10g/9i/8i, SQL Server, Sybase

ETL Tools: Informatica PowerCenter 9.x/ 8.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager)

ERP Tools: JDE OneWorld Financials

Data Modelling: Dimensional Data Modelling, Star Schema, Snow-Flake, FACT and Dimensions Tables, Physical and Logical Data Modelling, Erwin 7.2/7.0, Toad, Oracle Designer, PL/SQL Developer 5.1.4, Dimensional Hierarchies

Office Tools: MS - Office, MS - Project

Scheduling Tools: Informatica Scheduler, Unix Scheduler

Methodologies: Ralph Kimball Lifecycle Methodology, Agile Software Development Methodology

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Junior Architect/ Senior Informatica ETL Developer

Responsibilities:

• Experiencedinidentifying architectural issues and propose alternative solutions
• Experiencedinapplication design and implementation, distributed architecture and concepts, data manipulation and analysis using PL/SQL and SQL, and Object Oriented concepts and design.
• Experienced inETL coding and database design utilizing Informatica in DB2 and Oracle environments.
• Experienced inanalyzing data requirements and creating the design needed to implement solutions; developing technical requirements definition, mapping and gap analysis following development standards.
• Experiencedinhands-on development, integration, and infrastructure experience; develop code, test plans, expected results, and test data at a program level.
• Experiencedinbuilding and enhancing full and incremental load mappings/workflows in Informatica; performance tuning of reports.
• Experiencedinsystem analysis and identify solutions to technical problems, leverage the capabilities of Informatica applications and provide strategic vision.
• ExperiencedinData Warehouse methodology and best practices.
• Involved in gathering and analyzing the business requirements and preparing business processes.
• Actively involved in the data model design.
• Involved in setting the standards for developing the mappings.
• Developing mappings/sessions/worklets.
• Developing unit testing documents, Unit testing and documenting the results.
• Performed administration tasks such as adding new users/groups, setting permissions, folder migrations and backups.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex business logic.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Performance Tuning of mappings in Informatica.

Environment: Informatica 9.x, UNIX, SQL, Erwin and Shell Scripts in UNIX, Dimensional Data Modelling, Star Schema, Snow-Flake, FACT and Dimensions Tables, Physical and Logical Data Modelling, Erwin 7.2/7.0, Toad, Oracle Designer, PL/SQL Developer 5.1.4, Dimensional Hierarchies, Ralph Kimball Lifecycle Methodology, Agile Software Development Methodology.

Confidential - Columbus, OH

Senior Informatica ETL Developer

Responsibilities:

• Interacted with business users to convert the business requirements into Technical Design Documentation.
• Prepared Source-Target Mappings technical documents to provide the logic for Informatica mappings development.
• Developed mappings to extract data from flat files and Staging tables and load them into Oracle Data Warehouse Database and flat files.
• Used various Informatica transformations including Source Qualifier, Joiner, Filter, Router, Expression, Aggregator, Lookup, and Update Strategy etc..
• Created Informatica Workflows with built-in dependencies for session execution with a view to minimize run-time.
• Created Test Strategy, Test Plans and Test Execution Reports coordinating with the QA team.
• Debugging the Informatica sessions by utilizing the logs of the sessions.
• Creating UNIX shell script for the start and stop procedures of the sessions.
• Performing unit testing at various levels of the ETL.
• Experience in identifying the bottlenecks and fine-tuned the mappings.
• Optimizing performance tuning at source, target, mapping and session level.

Environment: Informatica 8.1.1, UNIX, SQL, Erwin and Shell Scripts in UNIX, Ralph Kimball Lifecycle Methodology, Agile Software Development Methodology, Informatica Scheduler, Rapid SQL for DB2, Quest Toad for Oracle, SQL Developer

Confidential, Richmond, Virginia

Junior Architect/ Senior Informatica ETL Developer

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities like Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Router, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.

Environment: Informatica 8.1.1 - Designer, Workflow Manager, Workflow Monitor, Repository Manager, UNIX, and Sybase T-SQL, Erwin and Shell Scripts in UNIX, SQL Developer

Confidential, San Francisco, CA

Senior Informatica ETL Developer

Responsibilities:

• Development and implementation of Informatica mappings.
• Involved in testing the mappings through Workflow Manager.
• Assist BSC with designing the ETL process.
• Importing Source/Target tables from the respective databases and created reusable transformations and mappings using designer tool.
• Unit testing and component Testing.
• Created and scheduled sessions and workflows through ABC to perform data loading. Preparation of Test Specifications and Design Documents.
• Worked extensively on informatica version control.
• Code review & regression test of Informatica code.
• Development standards (shared objects, naming, coding, code walk-through and checklist etc.)
• Worked on session and mapping parameters and variables and parameter files as part of incremental load.
• Created unit test scripts.
• Create the technical designs for the individual integration scenario components based on the business requirements provided in the Functional Design Specs, Reviewing Change requests, Task estimations, preparation of delivery plans & Client reports.
• Testing and TQA (Technical Quality Assurance) data warehouse solutions as required ensuring that the results are accurate as per business requirements and standards are met as per Business Intelligence QMS (Quality Management System).

Environment: XP, Oracle 10g, Informatica 8.5 - Designer, Workflow Manager, Workflow Monitor, Repository Manager, TOAD, Unix Scheduler, SQL Developer

Confidential, Glendale, CA

Informatica ETL Developer

Responsibilities:

• Actively involved in the analysis and the data model design.
• Involved in setting the standards for developing the mappings.
• Loading certain fact tables through SQL directly.
• Develop Unix scripts to generate the data for the time tables (for example: Calendar vs. Fiscal, Posting vs. Monthly Allocation) then loading and verifying the data.
• Using DB2 Load/Import/Export as appropriate to populate data between the different schemas (separate schemas used for INFA mapping development and MSTR report development).
• Running ad hoc SQL queries to analyze and validate data.
• Running the SQL statements and validating the results before using them in the INFA mappings.
• Analyzing the Sales Conversion Factor data in excel and formulating and generating the intermediate and final markup rate calculations.
• Maintaining the INFA parameter file.
• Developing mappings/sessions/worklets.
• Developing unit testing documents, Unit testing and documenting the results.
• Performed administration tasks such as adding new users/groups, setting permissions, folder migrations and backups.

Environment: Informatica 8.1.1 - Designer, Workflow Manager, Workflow Monitor, Repository Manager, UNIX, and DB2 9.1, Shell Scripts, UNIX Scheduler, SQL Developer

Confidential, Glendale, CA

Architect/ Design

Responsibilities:

• The Licensed Material data was being loaded from INSight into Foundation as a full refresh. Prepared the design document to change the load process into an incremental one while retaining the current solid design framework and leveraging it to save significant time. Design document specifies the data model and load process changes needed to accomplish this.
• Prepared another design document to add Country to the existing segment and character set of properties as a second step. After studying the Sybase input data model and the existing process, technical requirements (fields, table and process changes) were listed to accomplish the addition of country.

Environment: Sybase, DB2, Informatica

Confidential, Glendale, CA

Informatica Production Support

Responsibilities:

• Monitoring the ETL Load schedules.
• Sending out Load Status and Action Plan in case of Load failures.
• Analyzing the Load error messages from the Unix log files and restarting the required as necessary.
• Developing and maintaining data pre-processing Unix shell scripts for cleaning up the flat files received (for example: removing the header lines), error handling scripts for sending out email/page messages, clear table script, etc.
• Scheduling and de-scheduling the INFA workflows.
• Coordinating the scheduling of MSTR reports.
• Transferring files and scheduling the Special data loads (ad hoc).
• Preparing the Design Documents for Change Requests (for example: Effective Dating)
• Coordinating and implementing the Change Requests.

Environment: Informatica 7.*, UNIX, and DB2 9.1

Confidential

Database / ERP Application Developer

Responsibilities:

• Played a key role in all the stages such as Convert, Customize, Implement, Upgrade, Asynchronize, Archive, Support
• Involved in analysis of user requirements and selection of new ERP package.
• Did Design and specifications.
• Customizing the OneWorld A/R module to handle special needs of company’s Accounts Receivable. Customizing the OneWorld A/R module’s limited deduction management capabilities to handle company’s extremely complicated claims resolution and credit collection procedures - creating an entirely new module Customizing and setting up the OneWorld Workflow module to handle the complexity and heavy loads of company’s workflow.
• Worked as Technical lead doing analysis, implementation, maintenance, modifications, enhancements, new development, researching/testing/approving Service-Packs, migration, upgrade.

Environment: JDE OneWorld XE (& B73.3), C++ v.6, ABC FlowCharter, Visio 5.0 on AS/400 OneWorld: Tools, Report Writer, Workflow Management, C++, A/R., DB2