SUMMARY

• 15 years of IT experience in Analysis, Design, Development, Testing and Implementation of Data warehouses/Data mart, Business Intelligence, Client/Server and web based software applications.
• Over 12 years of extensive experience in Informatica ETL design and development using tools like Informatica Designer, Repository Manager, Repository Administrator, Workflow Manager, Workflow Monitor, Server Manager
• Established and maintained database management systems, standards, guidelines, and quality assurance for database deliverables including conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy.
• Extensively used ETL to load data from Oracle 8i/9i/10g, DB2, Teradata, MS SQL Server 2005 and Flat Files
• Experience in Creating Repository, Target Databases and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism - using Informatica Powercentre
• Design and develop sustainable database ETL processes using Informatica Power Center and Power Exchange
• Good understanding of dimensional modeling and ETL designs for loading in Star-Schemas and Snowflake Schema of data warehouses.
• Knowledge of structured query language (SQL) and a general understanding of relational database management systems (RDBMS) and their construction
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica job scheduling,
• Experience working with Job scheduling tools like Autosys and Control-M
• Working Knowledge of ETL Performance tuning techniques to troubleshoot and fine-tune existing ETL solutions and React to and correct day-to-day operational errors.
• Experience in Folder and Session migration and Repository Administration
• Knowledge of Partitioning of data and session partitions
• Developed Combined Queries, Slice and Dice, Drill Down, List, Cross Tab, Master Detail reports using Business Objects, Cognos Query studio and report studio
• Experience in PL/SQL Programming (Stored Procedures, Functions and Triggers)
• Writing UNIX Shell Scripts for processing Incoming text files
• Writing Oracle Stored Procedures, SQL scripts and calling them from Shell scripts at pre and post session
• Strong SQL skills with the ability to tune and optimize complex queries.
• Perform data quality reviews and data gap analysis, data querying, and data validation functions.
• Knowledge ofData Warehouse methodology and best practices.
• Experience in Interacting with Business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable
• Ability to manage projects from inception to completion in cross-functional environment.

TECHNICAL SKILLS

ETL Tools: Informatica 9.6/8.x/7.x/6.x/5.x PowerCenter / PowerMart / PowerExchange 9.6.1, WorkFlow Manager, WorkFlow Monitor, DesignerServer Manager and Repository Manager

OLAP Tools: Business Objects 6.1, Crystal Reports, Cognos 10.2.2, ReportNet 1.1

Databases: Oracle 9i/10g, MS-SQL Server 2005/7.0, MS Access 97/2000, TeradataDB2

Languages: C, C++, SQL, Transact-SQL, PL/SQL

GUI and Other: Developer 2000, Visual Basic 6.0, Erwin, PLSQLDeveloper5.1TOAD 7.x/6.x, SQL*Loader, PVCS VM, PVCS Tracker

Microsoft Tools: MS Office, MS Project, MS Visio

Operating Systems: Sun Solaris, HP-UX, Linux, Windows NT/98/2000/XP

PROFESSIONAL EXPERIENCE

Confidential

Senior Datawarehouse Developer

Responsibilities:

• Responsible for the design, implementation, testing of data integration projects which involved various operational systems, Enterprise data warehouse and unstructured data.
• Involved in analysis of several source systems data with client stakeholders and source system owners to determine the capacity to meet reporting needs and specific transformation rules that need to be applied.
• Worked on source target mapping documentation in support of report and warehouse technical designs
• Worked on data manipulation and analysis using PL/SQL and SQL.
• Performed ETL coding and database design utilizing Informatica in Oracle and sql server environments
• Worked in collaboration with business analysts, data architects, technical leads and DBA's to craft solution for data integration to implement the business and technical requirements.
• Created documentation for all developed ETL processes, including process flow and data mapping
• Developed audit reporting and quality improvement processes to ensure accurate and consistent delivery of data
• Worked onbuilding and enhancing full and incremental load mappings;
• Experienceinsystem analysis and identify solutions to technical problems, leverage the capabilities of Informatica applications and provide strategic vision
• Proactively worked on identifying any impacts to ETL data flows and data to maximize the value of information across the organization.
• Involved in maintaining logical data maps identifying information linkages between critical operational systems and Enterprise Data Warehouse
• Coordinated support efforts in updating ETL jobs, performance tuning, optimization,
• Ability to prioritize time and tasks with little direction in order to complete work on schedule; and identifying efficiencies and needed controls to fine-tune ETL operation
• Defined, scheduled and monitored Informatica jobs using Autosys
• Proficient with creation and modification of UNIX scripts
• Performed optimization and tuning for informatica batch jobs
• Leverage enterprise tools like Autosys to schedule jobs, automate and monitor ETL processes.
• Worked with software developers, business analysts and report developers to insure compliance with database practices

Environment: Informatica Power Center 9.6.1/9.1, PowerExchange 9.6.1,Oracle 10g, TOAD, SQL Server 2000/2005, SQL Plus, PL/SQL Developer, Netezza, MS Access, Windows NT, Shell Scripting, Autosys

Confidential, Dallas, Tx

Datawarehouse Consultant

Responsibilities:

• Senior Data integration expert with intensive hands on Informaticaexperience to support multiple projects.
• Handled the tasks creating innovative and logical solutions to solve complex problems, as an SME assisted ETL Architect in developing source to target mapping, detailing integration and transformation logic, using all applicable standards
• Worked closely with developers and end users to ensure user satisfaction and technical compatibility
• Responsible for drawing specific proposals for modified or replacement systems
• Handled the tasks of analyzing clients' existing systems
• Liaise extensively with internal and external clients
• Worked on the normalized EDW models and star schema based Datamart implementations.
• Worked with Mainframe(VSAM) files and 4+ yrs experience with Oracle/DB2/SQL, Strong PL/SQL experience
• Excellent oral and written communications skills
• Handled the tasks of generating users manual and provided training to users for new systems
• Ensured that budgets are adhered to and deadlines are met
• Work with functional teams for ETL requirements and business rules, and provided assistance in Data Quality research and UAT
• In collaboration with others, interpret data and developed recommendations based on findings
• Developed graphs, reports, and presentations of project results
• Performed basic statistical analyses for projects and reports
• Created quality dashboards and generated routine and ad hoc reports
• Create and execute unit test plans based on system and validation requirements.
• Coordinated and lead the end-to-end system testing effort - includes setting up the environment, code migration, running the test cycles and resolving the issues.
• Extensively involved in problem-solving, troubleshooting, and root cause analysis by optimization of existing processes.
• Performed project and support bug fixing by diagnosing, isolating, planning for, and implementing the change. And also provided assistance with performing change impact analysis on code changes in order to assist with estimating level of effort required for code changes and testing.

Environment: Informatica Power Center 9.1/8.1.1, Oracle 10g, TOAD, SQL Server 2000/2005, SQL Plus, PL/SQL Developer, MS Access, Windows NT, Shell Scripting, Clear Quest, COBOL

Confidential, Plano, Tx

Datawarehouse Consultant

Responsibilities:

• Studied the existing environment and accumulating the requirements by querying theClients on various aspects.
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Analyzed current system and programs and prepared gap analysis documents and Prepared Conceptual Solutions and Approach documents and gave Ballpark estimates.
• Design and develop code and review ETL code components. Builds and maintains templates, rules, workflows, data extractions and imports, interfaces, and object models.
• Works with solution designers to perform functionality gap analysis and provide subject matter expertise to maintain enhance and provide solutions for ETL design.
• Acquired and abstracted primary or secondary data from existing internal or external data sources
• In collaboration with others, developed and implemented data collection systems and other strategies that optimize statistical efficiency and data quality
• Perform data entry, either manually or using scanning technology, when needed or required Data Reporting
• Support QA activities as required. Troubleshoot and provided root cause analysis and resolve production problems and data issues as necessary
• Provided assistance in the development and definition of test plans and scripts for performance, regression and user acceptance test plans;
• Analyze the solution and determine the feasibility of implementation of the solution in the current environment/system.
• Created documentation using data flow diagrams, rule-sets/thresholds, and ETL mappings
• Ensure ETL quality through inspections and knowledge sharing

Environment: Informatica Power Center 8.6.1/8.1.1 , Power Exchange Navigator 8.6.1/8.1.1 , Oracle 10g, TOAD, SQL Server 2000/2005, SQL Plus, PL/SQL Developer, Windows NT, Shell Scripting, Clear Quest.

Confidential, Detroit, MI

Datawarehouse Consultant

Responsibilities:

• Worked in different subject areas - Medical, Pharmacy, Dental, Vision, Medicare, PPO, HMO, Facets, iFacets, Master Medical and Care Management.
• Prepared Business Requirement Documents, Software Requirement Analysis and Design Documents (SRD) and Requirement Traceability Matrix for each project workflow based on the information gathered from Solution Business Proposal document.
• Responsible in obliging through many industry standards like HIPAA, PHI, ANSI837 and guidelines in developing and migrating the code from one environment to another.
• Identify problematic areas and conduct research to determine the best course of action to correct the data
• Analyzed and resolved issues with current and planned systems as they relate to the integration and management of Confidential t data (for example, review for accuracy in record merge, unmerge processes)
• Worked on Inbound, Outbound and Carve-out Data Feeds and developed mappings, workflows, scripts for the same.
• Coordinated and worked closely with legal, clients, third-party vendors, architects, DBA’s, operations and business units to build and deploy.
• Worked closely with management team to achieve business goals
• Analyzed reports of data duplicates or other errors to provide ongoing appropriate interdepartmental communication and monthly or daily data reports (for example, related to the EMPI)
• Handled the tasks of monitoring and supervising the proper implementation of new systems
• Responsible for translating the requirements of the clients into highly technical specifications to load data into various tables in Data Marts.
• Developed complexT-SQL queries and designedSSISpackages to load the data into warehouse
• DesigningSSISPackages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Prepared Test Strategy and Test Plans for Unit, SIT, UAT and Performance testing.
• Coordinated and lead the end-to-end system testing effort - includes setting up the environment, code migration, running the test cycles and resolving the issues.
• Extensively worked on tuning Informatica mappings to increase performance.

Environment: Informatica Power Center 8.6.1/8.1.1 , Data Transformation (IDQ) 5.0, Oracle 10g, TOAD, SQL Server 2000/2005, SQL Plus, PL/SQL Developer, MS Access, Windows NT, Shell Scripting, Clear Quest, COBOL, JCL.

Confidential, Bartlesville, OK

Sr. Informatica Consultant

Responsibilities:

• Gathering, researching, and analyzing Data and Business processes to evaluate data credibility in the development of efficient and reliable Data-Management systems
• Developed and maintained various Mappings, Mapplets and Reusable Transformations for the data marts, to implement the validation logic and the ETL (extract transform load) mechanism to populate data for different interfaces
• Worked to identify different source systems and performed data analysis to determine the best approach of procuring source data using Informatica Power Center 8.6, Power connect for SAP
• Worked with Flat files and XML files
• Created Partitions to concurrently load the data into targets
• Performed Unit Testing and verified the data
• Tuned mappings and sessions for better performance of the data loads
• Analyzed dependencies and developed transformation logic for various enhancements and integrating various submarts.
• Written Unix shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder
• Involved in Production support for session failure and recovery, and monitoring informatica ETL jobs.
• Involved in Full Life Cycle Development of the Project
• Insure that all enterprise procedures are followed such as system testing, change management, project prioritization promotion to production and time entry, etc.

Environment: Informatica Power Center 8.6, DB Visualizer, PVCS, Oracle8i/9i, SQL Server2000, DB2, UNIX, Windows NT and control-m

Confidential, Bloomington, MN

Informatica Lead

Responsibilities:

• Involved in planning, analyzing and defining high-level software etl strategies and solutions
• Worked with functional team members to translate business requirements into technical specifications
• Assisted in the design of an efficient reliable ETL mechanism for updating the data warehouse, datamarts and downstream systems
• Performed ad-hoc data investigation and analysis to address inquiries and monitor data quality.
• Performed code reviews of Jaros customized ETLs and followed project methodologies to achieve the project timelines
• Involved in troubleshooting of Informatica Mappings, Mapplets and Workflows to support Confidential customizations
• Called stored procedures to perform database operations on post-session and pre session commands
• Created Parameter file for session parameters and called in the sessions
• Performed unit testing on all solutions, to ensure product and integrations tests are complete
• Documented the tests scripts, to ensure technical, functional and user interface requirements are met.
• Supervised the configuration of application changes, to meet business process requirements
• Assisted in utilizing efficient and effective processes and standards in order to continuously improve the quality of processes, products and services

Environment: Informatica Power Center Designer8.1/7.1, Erwin4.1, TOAD7.6, Oracle10g, SQL Server2000, PL/SQL, Business Objects XI 3.1, Sun Solaris8.0, HP-UX, WindowsXP/2000.

Confidential, Chicago, IL

Lead ETL Analyst

Responsibilities:

• Worked as an onsite lead person to coordinate ETL activities across several projects with offshore team through full life cycle development
• Assist in the design of an efficient reliable ETL mechanism for updating the data warehouse, datamarts and downstream systems
• Coordinated the development and testing work of Offshore team
• Performed ad-hoc data investigation and analysis to address inquiries and monitor data quality.
• Developed and maintained various Mappings, Mapplets and Reusable Transformations for the data marts, to implement the validation logic and the ETL (extract transform load) mechanism to populate database for different business units.
• Developed various slowly changing Type1, Type2 and slowly growing dimensional mappings according to the data mart schemas.
• Created Connected and Unconnected Stored Procedure Transformations for pre & post load sessions.
• Used parameters and variables at mapping and session levels to tune the mapping performance
• Performed system integration testing and supported user acceptance testing
• Designed and documented validation rules and error handling strategy for the etls
• Involved in Production Support on-call,
• Leverage enterprise tools like Control-M to schedule jobs, automate and monitor ETL processes.

Environment: Informatica PowerCenter 7.1.3, Power Exchange 5.1,Workflow Manager, Workflow Monitor, Designer, Erwin4.1, Cognos ReportNet 1.1, Oracle 10g, SQL Server 2005, DB2, PL/SQL, Sun Solaris8.0, HP-UX, WindowsXP/2000.

Confidential, Plymouth, MN

ETL Analyst

Responsibilities:

• Interpret functional requirements, understanding background business processes and the users’ need for data.
• Designed and developed technical solutions to meet functional requirements.
• Worked in collaboration with the Project Managers, business users and stakeholders to gather, analyze and document the functional requirements
• Participated in various stages of requirements and data analysis of ERP project.
• Worked to effectively facilitate and communicate both technical and non-technical audiences and produced project documentation.
• Documentation included used cases, requirement documents, process flow diagrams, business rules and user interface specifications
• Worked with other Business/Functional Analysts in the identification of business and system changes and performed data mapping
• Experience using a analysis techniques like Use Cases, ER Diagrams, Context Models, to adjust the required deliverables to meet the project need
• Communicated effectively to business and technical staff complex ideas both verbally and in written form
• Participated in Design Reviews, job migrations between test and production environment
• Ensured that all enterprise procedures are followed such as system testing, change management, project prioritization promotion to production and time entry, etc
• Knowledge of SQL and relational database concepts with moderate understanding of the product development lifecycle.
• Experience with Cognos Reportnet, Adhoc reports development.
• Knowledge of Dimensional data modeling techniques - Star schema and Snowflake schema modelling

Environment:, Designer, Erwin4.1, TOAD7.6, Informatica Powercenter 7.1.x, Oracle10g, SQL Server2000, PL/SQL, Sun Solaris8.0, HP-UX, WindowsXP/2000.

Confidential, Cleveland, OH

Business Intelligence Consultant

Responsibilities:

• Developed various Mappings and Mapplets for the data marts
• Developed mappings with performance accuracy and efficiency to achieve operational objectives.
• Develop robust mappings with built in reconciliation and error handling.
• Worked in collaboration with data modelers and datawarehouse architects to refine data models to meet functional requirements.
• Responsible for the Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center 7.1.3 and DTS, administration of Power Center
• Involved in the implementation of Power Exchange component for the mainframe sources tested the component for POC
• Implemented the complex business rules by creating Re-usable Transformations, Mapplets, Mappings and Stored Procedures
• Developed Sessions in Workflow Manager to load data from Sources like relational and flat files to warehouses
• Implemented “Type2” Slowly Changing Dimensions to keep track of historical data.
• Imported XML Source files used in the mappings and loaded into an XML Target File
• Created and Scheduled Sessions based on demand, and monitored sessions using Informatica Workflow Monitor and Shell Scripts
• Created Shortcuts to reuse objects across folders without creating multiple objects in the repository
• Partitioned sources to improve session performance.
• Involved in performance tuning to optimize session performance.
• Used Business Objects to support the new reporting requirements.
• Created the reports using Business Objects functionality like Combined Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail etc

Environment: Informatica PowerCenter 7.1.3, Power Exchange 5.1,Workflow Manager, Workflow Monitor, Designer, Erwin4.1, TOAD7.6, Business Objects6.2, Oracle 9i, SQL Server2000, Mainframes sequential and VSAM files, Teradata, PL/SQL, Sun Solaris8.0, HP-UX, WindowsXP/2000.

Confidential, Orange, CA

ETL Developer

Responsibilities:

• Collected and analyzed business requirements with the management and converted them in to project documentation.
• Created mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimensions.
• Involved in analysis and design of physical and logical data models for Enterprise data warehouse with a pool of various datamarts.
• Defined various reusable Transformations & Mapplets in the distributed development environment to load data from various sources by using Transformations like Source Qualifier, Filter, Router, Joiner, Lookup, Expression, Sorter, Aggregator, Normalizer, Update Strategy, Stored Procedure and Targets to store the data in staging area / target tables and flat files.
• Worked with Memory management for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations and involved in pipeline partitioning
• Worked on ERPs like Peoplesoft sources using PowerConnect to retrieve these sources
• Developed test cases, conducted unit tests, system tests, user acceptance tests and migrated meta data from development to certification and production systems, created

Environment: Informatica PowerCenter 6.1/6.2.2, PowerConnect Workflow Manager, Workflow Monitor, Designer, Erwin4.1, TOAD7.6, Crystal Reports, Business Objects 6.2, Oracle 9i, SQL Server2000, PeopleSoft EPM8.8, PL/SQL, Sun Solaris8.0, HP-UX, WindowsXP/2000.

Confidential, Somerville, NJ

ETL Developer

Responsibilities:

• Involved in development of Informatica Mappings, Mapplets and Workflows for complex business rules
• Imported various Sources, Created Targets, and Transformations using Informatica Power Center 6.2 Designer
• Various transformations like Expressions, Lookups, Filters, Sequence Generator, Joiner, Sorter & Transaction Control were used to handle situations depending upon the requirement
• Called stored procedures to perform database operations on post-session and pre session commands
• Created Parameter file for session parameters and called in the sessions
• Created Partitions to concurrently load the data into targets
• Loaded bad data using Reject loader utility
• Performed Unit Testing and verified the data
• Tuned mappings and sessions for better performance of the data loads
• Performed Error Handling on Sessions
• Written Unix shell Scripts & PMCMD commands for FTP of files from remote server
• Performed Informatica Code Migration from development to testing and testing to production systems
• Involved in Full Life Cycle Development of the Project
• Involved in gathering end-user requirements and documenting the same

Environment: Informatica Power Center 6.2, TOAD6.4, PVCS, Oracle8i/9i, Crystal Reports, UNIX, Windows NT and Trillium