PROFESSIONAL SUMMARY:

• SDLC: Proven ability to lead and manage complete project life cycles (SDLC), from initial planning/requirements gathering to final testing and deployment of Data Warehouse Pharma, Health, Finance and Tele communication.
• Data Warehousing: 7+ years of strong experience in Data Warehousing and ETL using Informatica Power Center 9.5/9.1/ 8.6.1/8.5/8.1.2/7. x/6.2/5.1, Data Migration, Informatica Power Mart 6.2/5.1/4.7, (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor), Production Support activities, Power Connect, Power Plug, Power Analyzer, ETL, Data mart, OLAP, OLTP, Cobol, Siebel 7.0/2000/5.5 , Siebel Warehouse 6.3, Siebel EIM, Transact SQL, SQL, PL/SQL, Complex Stored Procedures, Triggers. Upgraded Informatica from 8.0 to 8.1 and then 8.1 to 8.6.
• Data Modeling: 3 years of Data modeling experience in ERWin 4.5/4.0/3.5, Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Data analysis and reporting
• Business Intelligence: 5+ years of experience working on Business Intelligence tools like Informatica Power Analyzer, Designer, and Developer Suite & Set Analyzer ), Crystal Reports, Business objects and Cognos.
• 2+ Years of experience in data migration from Oracle to Teradata RDBMS.
• Experienced in loader utilities including SQL Loader.
• Data Bases: Having experience using Oracle 10G/9i/8i/8.x/7.x, DB2 8.0/7.0, Teradata V2R5/V2R4/, MS SQL Server 2005/2000/7.0/6.5 , Sybase 12.x/11.x, IBM Informix 7.2, MS Access 7.0/2000, XML, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x. Experienced in PL/SQL scripts and shell scripting. Strong Experience to databases SQL, PL/SQL, SQL*PLUS, SQL*Loader, DBMS Packages, TOAD & ODBC interfaces to Oracle.
• Testing: Worked on issues with migration from development to testing. Strong experience in Analyzing Business Spec, Designing Test Plans, Test Case. Strong skills in Manual Testing. Proficient in Functional Testing, DB Testing, and Performance Testing. Performed Unit testing, Functional testing and prepared test cases. Experience in performance tuning at server level and at Informatica Sources, Targets, Mappings, and Transformations & Sessions
• Strong UNIX shell scripting experience (HP-UX, AIX, Solaris) along with excellent programming experience in Transact SQL, SQL, PL/SQL, XML, MS Office tool suite, Complex Stored Procedures, Triggers, and C. Knowledge of VB6 and VB.Net.

TECHNICAL SKILLS:

ETL Tools: InformaticaPowerCenter 9.5/9.1/ 8.6.1/8.5/8.1.2/7. x/6.2/5.1,, Informatica Power Mart 6.2/5.1/4.7, (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Data mart,OLAP, OLTP, SQL* Plus, SQL*Loader

OLAP: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.0/3.0, Oracle Designer

Business Intelligence: Cognos and Crystal Reports

Data Bases: Oracle 11g/10G/9i/8i/8.x/7.x, DB2 8.0/7.0, MS SQL Server 2005/2000/7.0/6.5 , Sybase 12.x/11.x, MS Access 7.0/2000, IBM Informix 7.2, XML, XSL.

Languages: Oracle Financials 11i

Internet Technologies: Unix Shell Scripting, Autosys, TWS/WebAdmin 2.0 (MAESTRO), SQL, PL/SQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, ASP, HTML, DHTML, XML, C, Java

Operating Systems: Win 3.x/95/98, Win NT 4.0, Unix, Sun Solaris 2.6/2.7, Linux, MS-DOS.

Testing tools: Quality Center, Test Director, Test Plans, Test Case, DB Testing and Performance Testing.

Other tools: TOAD 9.X, SQL *Plus, RUP,UML, WinSCP (SFTP), APPWORX 7.x,,PL-SQL Developer,

PROFESSIONAL EXPERIENCE:

Confidential, SAN FRANCISCO, CA

Senior Informatica Developer

Responsibilities:

• Involved in requirement gatherings from end users and translated into technical specifications
• Logical and Physical Database Layout Design. Created Informatica mappings for initial load and daily updates.
• Created different interfaces to bring data to LARS mart from different sources (Oracle, SQL Server and flat files)
• Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer
• Designed and developed re-usable mapplets, Sessions, Worklets, transformations.
• Involved in running loads to the data warehouse and data mart involving different environments.
• Created mappings and mapplets using various transformations of Lookup, Aggregator, Expression, Stored procedure, Sequence Generator, Router, Filter, and Update Strategy
• Created multiple Type 2 mappings in the Customer mart for both Dimension as well as Fact tables, implementing both date based and flag based versioning logic.
• Developed various Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Power Center Designer.
• Monitoring and resolving ETL Production issues.
• Monitor troubleshoots batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Created database partitions and Materialized Views and improved the performance
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Created numerous Unix Scripts and Autosys JIL and automated ETL processes.
• Produced a Unit test Document , which captures the test conditions and scripts, expected/actual results
• Analyzed/de-bug production issues and provided quick turnaround .
• Interacted with end users to identify key dimensions and abstracted quantitative metrics feasible in deciding business solutions.
• Interacted with Offshore team everyday based on the Tickets/issues
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerts.

Environment: Informatica Power Center 9.1, Windows 7, Oracle 11g, Autosys r11.3, SQL Server, UNIX, Oracle SQL Developer 4.0

Confidential, PLEASANTON, CA

Senior Informatica Developer

Responsibilities:

• Requirement gathering, Business Analysis and documentation Functional, Technical, Integration Documents, low level and high level design documents
• Analyzed the Functional Specs provided by the Architect
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data.
• Worked on Informatica Power Center client tools - Mapping designer, Workflow manager, Workflow monitor, Mapplet designer and Transformations.
• Designed several mappings to extract the data from the Flat file sources and Relational Sources
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections
• Facilitated the Production move up of ETL components from Acceptance to Production environment.
• Developed UNIX shell scripts to move source files to archive directory.
• Deploy the mappings and scripts between various environments like the Development, QA and production
• Support all Informatica daily admin tasks
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Monitoring and resolving ETL Production issues.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations
• Involved in enhancements and maintenance activities.

Environment: Informatica Power Center 9.5, Oracle 11g, Windows 7, SQL server2008, UNIX, Oracle SQL Developer, Putty, IBM RTC.

Confidential, SAN FRANCISCO, CA

Senior Informatica Developer

Responsibilities:

• Involved in requirement gatherings from end users and translated into technical specifications
• Analyzed/Profiled source data, performed gap analysis and implemented rules to cleanse data
• Worked in a team environment in designing entire data warehousing life cycle
• Designed/developed loading strategies (Full/ Delta) using Informatica
• Created different interfaces to bring data to LARS mart from different sources (Oracle, SQL Server and flat files)
• Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer
• Converted complex PL/SQL code into Informatica mappings and reduced overhead
• Involved in running loads to the data warehouse and data mart involving different environments.
• Created mappings and mapplets using various transformations of Lookup, Aggregator, Expression, Stored procedure, Sequence Generator, Router, Filter, and Update Strategy
• Created multiple Type 2 mappings in the Customer mart for both Dimension as well as Fact tables, implementing both date based and flag based versioning logic.
• Developed various Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Power Center Designer.
• Monitoring and resolving ETL Production issues.
• Monitor troubleshoots batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Created database partitions and Materialized Views and improved the performance
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Created numerous Unix Scripts and Autosys JIL and automated ETL processes.
• Produced a Unit test Document , which captures the test conditions and scripts, expected/actual results
• Analyzed/de-bug production issues and provided quick turnaround .
• Interacted with end users to identify key dimensions and abstracted quantitative metrics feasible in deciding business solutions.
• Interacted with Offshore team everyday based on the Tickets/issues
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerts.

Environment: Informatica Power Center 9.1, Windows 7, Oracle 11g, Autosys r11.3, SQL Server, UNIX, Oracle SQL Developer 3.2

Confidential, PLEASANTON, CA

Informatica Developer

Responsibilities:

• Extensively Involved in gathering the new enhancement requirement and performed initial analysis on the same
• Worked on Informatica Power Center 8.6.1 client tools - Mapping designer, Workflow
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Involved in Migration of mappings, sessions, worklets and workflows from Informatica 7.1 to Informatica 8.6
• Migrate the Informatica jobs from older version to new version Using Version Control. 
• Worked with logical, physical, conceptual, star, snow flake schema data models
• Worked with business and Data analysts for requirement gathering, development, and testing.
• Used to extract and developed factual tables using Informatica manager, Workflow monitor, Mapplet designer and Transformations.
• Developed complex mappings with transformations like lookup, Union, router, aggregator, expression, update strategy and joiner confirming to the business rules and documented.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
• Developed several Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using the Informatica PowerCenter.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performance related issues.
• Performance tuning of mappings, transformations and sessions to optimize session performance
• Analyzed existing Marketability Data Mart is satisfying the Business rules or not.
• Designed and developed the Informatica Workflows for Daily, Weekly, Monthly and Initial Loads.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Involved in Unit, Integration, system, and performance testing levels.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Used Debugger to test the mappings and fixed the bugs.

Environment: Informatica Power Center 8.6.1, Oracle11g, UNIX, Windows XP, Oracle SQL Developer, SQL, Putty and MS-Office tool

Confidential, Portland, OR

Informatica Developer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Documentation for business data flow from source to Data Mart.
• Creating Entity and attribute definitions and created physical data model using Erwin.
• Involved in full SDLC right form gathering requirements, designing, analyzing, modeling, developing, testing and implementation needed for loading and updating the warehouse.
• Identify source systems, connectivity, and captured data using CDC techniques, tables, and fields, ensure data suitability for mapping.
• Worked with Informatica Server and Client tools, experience in the Data Analysis, Design, Development, Implementation, Testing, Production Support of Database/Data warehousing /Legacy applications for various industries using Data Modeling, Data Extraction, Data Transformation and Data Loading.
• Developed complex mappings with transformations like lookup, Union, router, aggregator, expression, update strategy and joiner confirming to the business rules and documented.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Used Debugger to test the mappings and fixed the bugs.        
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Designed and developed the Informatica Workflows for Daily, Weekly, Monthly and Initial Loads
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process using Control M auto scheduling tool.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow
• Created various data marts from data warehouse and generated reports using Cognos.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
• Created Query prompts, Calculations, Conditions, Filters, Multilingual Reports Using Report Studio.
• Good knowledge in Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio.

Environment: Informatica Power Center 8.6, Oracle10g, Informatica Master Data Management SQL Server 2008, PL/SQL, SQL Loader, TOAD 9.5, Star Schema, Windows XP, and MS-Office tools.

Confidential, Pittsburgh, PA

Informatica Developer 

Responsibilities:

• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto data warehouse
• Developed and documented data Mappings/Transformations and Informatica sessions.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Used the Informatica Designer, Source Analyzer, Warehouse Designer and Mapping Designer.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 8.X.
• Implemented Type 1 and Type 2 slowly changing dimensions
• Used the update strategy to effectively migrate data from source to target.
• Was involved in testing the Data warehouse model. Extracting, cleansing, aggregating, transforming and validating the data to ensure accuracy and consistency.
• Involved in resolving issues in the ETL load process.
• Involved in Performance tuning in Data base design and Informatica environment
• Wrote SQL Scripts for the reporting requirements and to meet the Unit Test Requirements.
• Created various data marts from data warehouse and generated reports using Cognos.
• Use of Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Created data maps for Mainframes sources and Targets using Power Exchange.
• Presentation of the advanced features of Cognos to users and developers to enable them to develop queries and reports easily

Environment: Informatica Power Center 8.1.2/7.x, Cognos 7.1, Oracle9i, SQL Server, MS Office 2003 PL/SQL, Windows NT, Teradata5.0, ERWIN, PowerCenter, Power Exchange, UNIX Shell Scripts, UML, FTP, AS/400, TOAD, and SQL Navigator.

Confidential, Harris burg, PA

Informatica/ Cognos Developer

Responsibilities:

• Primarily responsible to convert business requirements into system design.
• Further implemented system model in Informatica, comprehensively using the functionality of the tool.
• Used ETL to standardize data from various sources and load into stage area, which is in Oracle.
• Used ETL methodology for complete processing of Data Extraction, transformations and loading steps, in a corporate-wide-ETL Solution using Informatica
• Tuned Informatica mappings for better performance using different techniques to provide maximum efficiency and complete performance.
• Extensively used ETL to load data from wide range of source such as flat files, XML to Oracle
• Extensively used PL/SQL Procedures/Functions to build business rules.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables

Environment: Informatica- Power Center 7.1, SQL, PL/SQL, Oracle, Teradata, UNIX, Power xchange.

Confidential, Detroit, MI

Data Warehouse Developer

Responsibilities:

• Loaded data into Star Schema database
• Utilized Informatica (Power Mart 4.7) for ETL process and Process of mapping.
• Utilized active and passive transformations
• Created model definition utilizing Transformer and Mapplets and reusable Transformations
• Organized the query data in the reports and creating Time Dimension and relative time
• Utilized of Multiple queries in reports and measures and calculated measures
• Protected Power cubes, enabling user class for a model
• Testing and improving Report Performance upon report completion for validation of calculations & data
• Created drill downs on the report for year and time dimensions.
• Created multiple cubes and cube groups
• Optimized of cube creation time and Creating templates for standard reports
• Created users and changing their profile
• Modified data maps for Mainframes sources and Targets using Power Exchange
• Created of standard filters, calculations, prompts and conditions in catalog
• Formulated of joins strategy and Catalog creation and modification
• Added columns in catalog after they are added in already existing tables
• Developed Impromptu Web Reports (IWR) and Power Play web reports (PWR) and published using Upfront
• Presented complex data summary report and Exception highlighting, Created Cross tab Reports and list prompts
• Created drill through, Drill Down reports charts and formatting the reports
• Created summary and detailed filters on the reports.

Environment: Informatica Power Center, Windows NT/2000, Web intelligence, Cognos Impromptu 6.0, Power Play 6.5/6.6, IWR, Transformer 6.6, Upfront, Informatica Power Mart 4.7, Java, Terra Data, SQL, PL/SQL.

Confidential, Dallas, TX

Data Warehouse Developer

Responsibilities:

• Requirement gathering from Business/Analysts
• Effort Estimation for test case development and execution and Identification of test scenarios and test cases.
• Test Strategy involving resource allocation and distribution.
• Test Plan preparation and Functional and Technical Specification reviews
• Organization of brainstorming sessions for group reviews
• Mapping Data Items from Source Systems to the Target System.
• Analyzed the sources, transformed the data, mapped the data and loading the data into Targets using Power Center Designer.
• Worked on Informatica Utilities - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensive redesigning of existing mappings and workflows for better performance including rewriting the SQL queries.
• Organization of brainstorming sessions for group reviews

Environment: Informatica PowerMart 5.1, Oracle 8.0, SQL, PL/SQL, Windows NT 4.0, UNIX Shell Scripts, Erwin, XML, DB2, MS SQL Server 2000, HP-UX