Profile

• 8+ years of total IT experience
• 7 years of Data Modeling
• 6 years of Informatica experience
• 6 years of Data Analysis

Summary

• IT: 8 years of IT experience in on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Travel, Financial, Insurance, Pharmaceutical, Health Care, Bio-Technology and Telecom industries.
• Data Modeling: 7Yearsof experience in using Data modeling tools like Erwin 7.3,7.1/4.5/4.0/3.5/3.x, Power Designer 12.5/12.0, Visio and Oracle Designer. Knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake Schema and Star Schema and Kimball and Immon methodologies while implementing Decision Support Systems. Experience in FACT & Dimensions tables, Conceptual, logical & Physical data modeling
• Data Warehousing: 5 years of development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 8.1.1/8.0/7.1/7.0/6.2/6.1/5.1.2/5.1.1/4.7 (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart 6.2/6.1/5.1.2/5.1.1/4.7, PowerConnect for SAP/PeopleSoft/Siebel/DB2, Power Plug, Power Analyzer, Power Exchange, PowerGlue, IMS Data (Rx Data, Plantrak, Xponent Plantrak), Syncsort for UNIX/Windows, Datamart, ETL, OLAP, ROLAP, MOLAP, OLTP, Autosys, Control M, Maestro.
• ECTL: 4 years of strong Data Cleansing experience using First logic 4.2/3.6, Trillium 7.6/6.0 (Converter, Parser, Geocoder, Matcher), SQL coding and UNIX shell scripting for address cleansing, profiling and segmentation of customer data.
• Business Intelligence: 4 years Business Intelligence experience using Business Objects XI/6.5/6.0/5.1/5.0, Business Objects SDK, SAP Xelsius, Web Intelligence 2.5/2.6, Crystal Enterprise, Cognos Impromptu 7.0/6.6/6.x, Power play, Transformer, Impromptu Web Reports (IWR), Power Play Enterprise Server and MicroStrategy.
• Database: 7 Years of database experience using Oracle 10g,9i/8i/7.x, MS SQL Server 2007/2005/2000/7.0/6.5,MS Access7.0/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader and SQL Developer 2008/2005/2000. Hands on Working knowledge in Oracle and PL/SQL Writing Stored Procedures, Packages, Functions and Triggers. Adept at working with Distributed Data Bases, SQL * Loader.

Education & Certifications

• Master of Sciences
• UWA Certified
• Certified in DWH Project Planning, Analysis, Design
• Certified in Data Warehouse: Project Implementation

Technical Summary

Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Schema, Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling, Erwin 7.3, 7.1, 4.5/4.x/3.0, Power Designer, Oracle Designer

Data Warehousing

Informatica PowerCenter 8.1.1/8.0/7.1.2/7.1/7.0/6.2/5.1.2/1.7/1.5 (Designer, Repository Manager, Repository Server Administration Console, Workflow Manager, Workflow Monitor, Informatica Server), Informatica PowerMart 6.2/5.1.2/4.7/4.5/3.5 (Designer, Repository Manager, Server Manager, Informatica Server), Informatica Powerconnect for Peoplesoft/Siebel/DB2/SAP, IMS Data (Rx Data, Plantrak, Xponent Plantrak), Syncsort, Trillium 7.6/6.0/5.0 (Converter, Parser, Geocoder, Matcher), Firstlogic, Autosys, Control M

BI

Business Objects 6.0/5.1/5.0 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), Cognos Series 7.0/6.0/5.x, Cognos Impromptu, Cognos IWR (Impromptu Web Reports), Cognos PowerPlay Transformer, SAS, Developer 2000, Crystal Reports 8.0/7.0/6.0/5.0

Others

Unix Shell Scripting, SQL, Java, HTML, PL/SQL, SQL Plus, C, PERL,ColdFusion

Databases

Oracle 10G/9i/8i/8.0/7.x,APEX,DB2 8.0/7.0, SAP ABI, Teradata V2R6/V2R5/V2R4, IBM DB2 UDB, MS SQL Server 6.5/7.0/2000/2005/2007, MS Access 7.0/'97

Environment

Sun Solaris, Sun OS, HP-UX, Novell 3.11, MS-DOS 6.22, Windows 95/98/2000, Windows NT 4.0, IBM-Compatibles, Sun Classic, Sun Ultra, Sun Sparc,HP9000,SOA

Professional Summary

Confidential, Carlsbad, CA OCT-Present
Dimensional Data Modeler/DB Support,
Life Technologies is a global biotechnology tools company providing premier systems, consumables, and services for scientific researchers around the world. Life Technologies customers conduct their research across the biological spectrum, working to advance personalized medicine, regenerative science, molecular diagnostics, agricultural and environmental research, and 21st-century forensics.
Role
Actively Participated in the analysis, design and implementation of the business solution.

• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Involved in gathering user requirements along with Business Analyst.
• Responsible for translating business data requirements into conceptual, logical, and physical data models using Erwin Data Modeler
• Extensively worked on Point of sales & Marketing, manufacturing subject areas.
• Responsible for dimensional modeling techniques according to Kimball Methodology
• Extensively Participated in Production Support Service Requests
• Worked on Dimensional Data Modeling creating New Models and updates of existing models
• Updated Naming Standard documents and Data dictionary accordingly
• Involved in RFC (Request for Change) on different projects, simultaneously updating Data Models and Data Bases in Dev and QA environments.
• Extensively used Erwin r7.3 in this project for Data Model Changes and updates
• Created Tables, Storage Spaces, Indexes, Views, and Procedures and Partions
• Involved in Analysis by querying to tweak performance of code and output
• Involved in creating Documentation of reports from Cognos.
• Generated the DDL after Physical DM
• Used Toad for Query and Analysis for Oracle 10g
• Participated in Requests for ETL changes.
• Successful in Day3 Project Live with out Issues
• Involved in APAC (Asia Pacific), Operation Expenses, SKU,MFG and E1 Projects for Different Design Enhancements and RFC
• Analyze and profile data based on known relationships and data characteristics
• Defined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities
• Analyzed the queries and involved in performance tuning for different queries
• Created Metadata reports in Erwin 7.3
• Created Different Subject Areas in ERWIN
• Involved in JAD sessions
• Worked On ColdFusion for website Enhacements
• Designed the logical and physical data model for Oracle Demand Planning, Oracle E Business in warehouse to store OLAP data.
• Participated in BI Monthly Team meetings
• Actively participated in Technical Seminars from Cognos, Informatica, Erwin

Environments: Erwin r7.3, OBIEE 10.1.3.x,Oracle10g, SAP ABI, Cognos 8.2, Toad, IBM DB2, MS Excel, Siebel, JRD, Visio, Office Communicator, Adobe Cold Fusion 9, MS Office, Win XP

Confidential, WI Feb09-Oct 09
Data Modeler/DA
HIPAA Certified

Confidential, is a health Care Client. The objective in this project was to build a data Mart consisting of data about Metrics as well as new DWH with MDM Hub. The Metrics data were to be extracted from the existing databases.

Role

• Part of the team responsible for the analysis, design and implementation of the business solution.
• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Implemented Agile Scrum methodologies in Project plan
• Extensively worked on Customer and HR subject areas
• Designed Automated Clearing House Transactions CustomerCentric Model in DWH
• Extensively used both Star Schema and Snow flake schema methodologies in building
• and designing the logical data model in both Type1 and Type2 Dimensional Models.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Provided architecture/development for initial load programs to migrate production databases from data marts to Teradata data warehouse. Prepared business case for the data mart and then developed and deployed it.
• Designed according to 3NF.
• Used Erwin to transform data requirements into data models.
• Used forward engineering for creating databases for OLAP Metadata Catalog tables.
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models.
• Performed Reverse Engineering of the current application using Erwin, and developed Logical and Physical data models for Central Model consolidation.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Defined and processed the facts, dimensions.
• Designed Health care KPI's Performance Garante Model
• Creating databases for OLAP Metadata Catalog tables
• Gathered requirement for Data Conversion Process.
• Designed Mapping Documents for Data Conversions.
• Participated to design BO Universe
• Collected requirements and designed Model for MDM (master data management)
• Extensively Worked on SAP Xcelsius for Performance Guaranteed Reports.
• Enhanced cosmetics changes and look and feel according to user Requirement
• Created a corporate Metadata Repository
• Involved in the critical design review of the finalized database model.
• Generated the DDL after Physical DM
• Worked extensively in data analysis by quering in SQL SQL Server

Environments: Erwin 7.3,Teradata V2R5, SAS, SQL Server 2008, Visio, Oracle Dev 6.0, DB2,ETL Informatica, SAP Xelcius, BO, Xplanner, Oracle 11i, APEX 2.0,Crystal Reports.

Confidential, BELLEVUE, WA
Principal Data Modeler/BA, MAY'08-Feb09

Confidential, is parent company to some of the world's leading travel companies, providing travel products and services to leisure and corporate travelers in the US and around the world. Founded within Microsoft in 1995, Expedia made its debut on the Web in 1996. Within three years, Expedia expanded its sites globally to include Canada, the U.K. and Germany, and first went public in 1999.

Responsibilities:

• Gathered requirements from business users and analysis based on the requirements.
• Worked with PGM on various projects dealing with Business.
• Reported to VP on project status and Future moves.
• Extensively worked on HR and Customer Data subject areas
• Took part in JAD sessions
• Took part in preparing Functional Specification and Technical documentation.
• Designed and built Data Models for Data Integration to bring it in to Landing Zone.
• Created Data acquisition and Interface System Design Document.
• Took part in the process of modeling the different data marts using star schema
• Created SRC-TGT Mappings for Phase1 release1 & 2, Phase2 Release1 & 2.
• Created and Updated Data Dictionary for Global use of Expedia.
• Analyzed and created Volumetric for all the Phases
• Worked on Data Integration from Landing zone to EDW
• Created Analysis Reports after Data Analysis for Integration Process.
• Created Bus Matrix for Confirmed dimension
• Took part with SSIS (SQL server Integration) team in ETL process for QL2 Project.
• Created constellation Maps in Visio to determine Dimensions and facts.
• Reverse engineered the HCOM(SQL Server) Data Model and made changes to existing tables and views by creating, replacing and completely removing some of the things to bring it to Landing Zone(DB2)
• Created Conceptual Models in Visio
• Created Physical Model in POWER DESIGNER for EDW.
• Created different data models for Business and for ETL (DTS/Data Stage) according to requirements
• Creation of Documents like Reusability Summary Document, Standard Domains Document, Unit Test Template Doc.
• Pulled Data from Data sources IBM AS/400,I-series, DB2, SAP, and SQL Server
• Used FTP (File Transfer Protocol) for transferring Data from Different sources
• Worked on BTEQ scripts to load data from Teradata Staging area to Teradata data mart.
• Extensively used loader utilities in Teradata
• Worked with QA in creating test cases and testing Environment
• Worked with ETL team in handling the SRC-TGT Extraction and Transformations.
• Documented Data Mappings/Transformations, and Informatica sessions as per the business requirement
• Used Microsoft Access to Collect information through forms in e-mail and import data from external applications.
• Took part and Assisted team in creating reports from BO in various Projects.
• Used Toad to issue SQL commands matching the business requirements for loading and creating and analyzing tables, indexes, keys.
• Extensively worked on creating VB scripts for Data Model Conversions
• Extensively worked on Oracle Forms and reports.
• Generated DDL
• Worked on Ascent Capture business processes by collecting paper documents, forms and e-documents, transforming.
• Worked with Java Development on SQL's to retrieve the Data for Travel Package services.
• Worked with SOA team extensively

Environment: Sybase Power Designer 12.0, Visio, Query Analyzer, Toad for DB2, IBM DB2, I-series V5R3,AS/400,SAP,FTP SQL Server, Oracle 10G, PL/SQL, Tera Data V2R6, Oracle Developer 6.0, UNIX, DQXI, Report net MR2, Trillium, Codex, SVN,VSS, .NET, Java, Frame work manager, VB 9.0, Win XP.

Confidential
Deerfield, IL Feb'08-May08
Physical Data Modeler/BA

Takeda Pharmaceuticals North America, Inc. is a new kind of pharmaceutical company. Dedicated to serving patients by providing innovative products that improve their lives with better healthcare. With a foundation built on the tremendous success of ACTOS® (pioglitazone HCl) as well as a robust, early-stage pipeline, TPNA is poised to realize its vision of becoming a world class pharmaceutical company.
Responsibilities:

• Gathered requirements from business users and analysis based on the requirements.
• Extensively worked on Sales and Marketing subject areas
• Created standard Data dictionary.
• Designed and built Data marts by using Star Schema's.
• Created Data acquisition and Interface System Design Document.
• Took part in the process of modeling the different data marts using ERWIN
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs
• Created Claims Data Model for Health Care , Japan
• Created Bus Matrix for Confirmed dimension
• Extensively worked in Data staging, ETL procedures & process.
• Created constellation Maps in Visio to determine Dimensions and facts.
• Reverse engineered the MM Report data model and made changes to existing tables and views by creating, replacing and completely removing some of the things
• Created Conceptual Model in Visio as per Business requirement
• Created logical and Physical Model in ERWIN for CDW.
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs
• Designed the physical data model for Oracle E Business in warehouse to store OLAP data.
• Identified, manage and leverage enterprise-wide information assets using CA Repository.
• Created Volumetric analysis reports after analysis from IMS DB.
• Creation of Documents like Reusability Summary Document, Standard Domains Document, Unit Test Template Doc.
• Documented Data Mappings/Transformations, and Informatica sessions as per the business requirement
• Create and edit detailed reports that display sorted, filtered, and grouped by Microsoft Access
• Used FTP (File Transfer Protocol) for transferring Data from Different sources
• Used Toad to issue SQL commands matching the business requirements for loading and creating and analyzing tables, indexes, keys.
• Took part in testing the Cognos Upgrade to 8.0

Environment: Erwin 8.0,Visio,OBIEE 10.1,Abnitio 2.13, Datastage, Toad 8.0, Oracle 10G, , PL/SQL, UNIX, Cognos 8.2, Report net MR2, Trillium, Oracle Dev 6.0, Codex, SVN,VSS, .NET, Java, FTP, Frame work manager, Win XP.

Confidential, Rochester NY Jun'07-Jan'08
Senior Data Arch/Data Modeler
Xerox Corporation is the world\'s leading document management technology and services enterprise, Xerox provides the document industry\'s broadest portfolio of offerings. Digital systems include color and black-and-white printing and publishing systems, digital presses and "book factories," multifunction devices, laser and solid ink network printers, copiers and fax machines.
Responsibilities:

• Gathered requirements from business users and analysis based on the requirements.
• Created Technical specification documents USCR (UnitedStatesCustomerResponse) and CI(Customer Information) Project.
• Analyzed and Reviewed the Business Specification Documents.
• Handled data modeling and created Conceptual, logical, physical data models for USCR, C.I and XGARD projects using Erwin.
• Reverse engineered the Customer Information (C.I) Data Model and Abnitio data model and made changes to existing tables and views by creating, replacing and completely removing some of the things.
• Understood and leveraged enterprise-wide information assets using CA Repository
• Created different data models for Business and for ETL (Abnitio) according to requirements.
• Created Conceptual, logical & physical data models for USCR.
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs
• Documented Data Mappings/Transformations, and Abnitio sessions as per the business requirement.
• Extensively worked in the performance tuning of programs, ETL procedures & processes.
• Extensively worked on Views, procedures and functions.
• Extensively used loader utilities to load flat files.
• Used SQL Developer tool to issue SQL commands matching the business requirements for loading and creating and analyzing tables.
• Gathered requirements for the Field Performance Reports.
• Developed reports, based on business requirements.
• Worked on Web Focus Developer Studio for Styling reports.
• Worked on developing VB Script for Data Modeling Changes

Environment: Erwin 7.1,Visio,Abnitio 2.13, Toad 8.0, Oracle 10G,Oracle APEX 3.0.1, PL/SQL, UNIX, Cognos 8.2,Oracle Developer 6.0, Report net MR2, Trillium, Codex, SVN,VSS, .NET,VB 9.0 Java, Frame work manager, Win XP.

Confidential, CT Jan'05 - May'07
Senior DW Data Modeler/ SAS Analyst

Boehringer Ingelheim is global group of companies embracing many cultures and diverse societies. Boehringer Ingelheim group of companies is privately-held and consistently dedicated to the long term interests of the corporation\'s Pharmaceuticals, stakeholders, including its customers, employees and the communities within which it operates.
Responsibilities:

• Gathered requirements from business users and analysis based on the requirements.
• Extensively worked on Customer, sales and Marketing areas
• Designed and built Data marts by using Star Schema's.
• Created Data acquisition and Interface System Design Document.
• Took part in the process of modeling the different data marts using ER Studio.
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs
• Created Pharmacy patient Models.
• Designed Claims Data Models for Boehringer Healthcare, UK
• Worked extensively with offshore team of 8(UK)
• Configured & Administered Informatica Servers.
• Using Source Analyzer & Warehouse Designer, created Source/Target Definitions.
• Identified source systems/connectivity/tables and fields, to ensure data suitability.
• Used Master Data Management (MDM) to align with key business process and for central global Metadata repository.
• Developed, maintained, and upgrading MS Access front ends and back ends for users.
• Responsible for querying Informatica Metadata and managing the Metadata.
• Designed & developed complex Informatica mappings using expressions, aggregators, filters, lookup & stored procedures to ensure data movement between applications.
• Created Sessions and executing them to load the data from the source system using Workflow Manager.
• Identified, manage and leverage enterprise-wide information assets using CA Repository
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Extensively worked in the performance tuning of programs, ETL procedures & processes.
• Error checking and testing of the ETL procedures and programs using Informatica session log.
• Created Mappings like Overview_Dis_A, Overview_Geo_A, Overview_Reg_A, and Overview_Zone_A to build Dashboards.
• Developed Unix Shell scripts and Perl Scripts to extract and convert data from different legacy systems in databases.
• Worked Extensively on SAS for Analysis.
• Gathered requirements for data cleansing and data transformations
• Extensively used loader utilities to load flat files into Teradata RDBMS.
• Created Test cases for QA.
• Performed high volume maintenance on large Teradata tables using MultiLoad loader utility.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart.
• Gathered requirements for the Field Performance Reports.
• Develop reports, based on business requirements, using Business Objects 6.5.
• Extensively worked on DB2 COBOL flat files. Used Powerconnet to connect to Mainframes DB2 databases.

Environment:ER Studio7.1, Informatica Power Center 8.1.1/8.0/7.1.2, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Toad 8.0, Oracle 10G, Teradata V2R5 (Multiload, Fast load, Tpump, BTEQ), IMS Data, Siebel, Kalido, PL/SQL, UNIX, Windows NT,SAS, Visula Studio,MS SQL Server 2000/2005,MS Access, Business Objects 6.5, Autosys, Unix, Win XP.

Confidential, INDIA
First National Bank Midwest, IA Dec'03-Dec'04
DW Data Modeler

Banking Transaction System & Financial Services: First Midwest is engaged in commercial and retail banking and offers a comprehensive selection of financial products and services including, lending, depository, trust, investment management, insurance services and other related financial services tailored to the needs of its individual, business, institutional and governmental customers.

Responsibilities:

• Created Technical specifications documents by going through into Perl code.
• Analyzed Business requirements and put them into technical specifications
• Used IBM Rational Architect for Designing Models
• Created Banking Data Models using IBM model as a blue print.
• Created Asset Weekly mappings like Asset Extract, Asset Load and Asset Load Metrics. In this Extract means extracting data from flat files, Load means Loading data into intermediate tables, Load Metrics is to load data into important view LR.LR_SCC_METRIC_DATA view, other Asset mappings are Asset Finished Goods, Asset Finished Goods FED, Asset Span, Asset Overdue
• Other mappings are Entitlement, Qtr2Date, Financial Targets and Paris Extract, Load and Load Metrics and Sourcing Extract, Load and Load Metrics.
• Designed XML Schemas
• Updated MS Access application design.
• Extensively used almost all of the transformations of Informatica including Source Qualifier, Expressions, Lookups, Joiner, Update Strategy and others.
• Designed Property data Models.
• Developed UNIX scripts to load the data from relational tables into flat file for which the source is oracle 7.0, which is not supported by Informatica 7.0.
• Responsible for a part of Linux administration.
• Worked on Informatica PowerCenter 7.0/6.2 tool - Source Analyzer, Warehouse designer, Mapping Designer & Mapplets, and Transformations.
• Using Workflow Manager for running the Batches and Sessions and scheduling them to run at specified time.
• Identified, manage and leverage enterprise-wide information assets using CA Repository
• Designed and Customized data models for Data warehouse supporting data from multiple sources on real time.
• Extensively worked with Informatica to load data from flat files, Oracle, MS SQL server to target database.
• Used Control-M to schedule the Informatica workflows.
• Used Business Objects for report creation
• Developed stored procedures, triggers, functions and packages used for the system.

Environment: Erwin 4.0/3.5.x,IBM Rational Architect, Informatica PowerCenter 7.1, XML Spy, Workflow Manager, Workflow Monitor, Designer, Repository Manager, Repository Server Administration Console, Business Objects 5.1, Control-M, PL/SQL Developer, Oracle 8i, PL/SQL, Unix AIX4.3, Win XP/200, MVS 3.8, VSM.

Confidential, INDIA
SAFECO INSURANCE, Seattle, WA Dec'02-Nov'03
Senior DW Data Analyst

SAFECO products include auto, home, life and business insurance; investments such as mutual funds, annuities and stock purchase plans.
Responsibilities

• Identified source systems/connectivity/tables and fields, to ensure data suitability.
• Analyzed and Reviewed the Business Specification Documents.
• Worked with project leaders to identify reporting requirements and develop needed detailed business requirements. Worked as a liaison between the end user and technical development team.
• Using Source Analyzer & Warehouse Designer, created Source/Target Definitions.
• Identified Data Relationships. Designed and built Data marts by using Star Schema's.
• Identified requirements for data cleansing and data transformations
• Created Data acquisition and Interface System Design Document.
• Took part in the process of Claims modeling the different data marts using ERWIN.
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.
• Created Business Insurance Facets Models.
• End-to-end development on Informatica - Source Analyzer, Mapping, Designer & Transformations.
• High proficiency with PowerCenter, Powerconnect, and involved in utilizing Informatica products to move Mainframe DB2 and flat-file data to oracle.
• Create ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Created facts, dimensions & star schema representation for Sales & Marketing datamart.
• Involved in Designing Logical and Physical Database using ERWIN Tool.
• Worked on IBM IFW Models.
• Tested applications & migrated data to target Oracle tables on the server, Schedule and run Extraction and Load process, and monitor sessions by using Workflow monitor.
• Population of the Data Warehouse tables using SQL*Loader and Informatica
• Responsible for querying Informatica Metadata and managing the Metadata.
• Created Repository and User groups Using Repository Manager.
• Created Mappings between Source and Target using Power Center Designer.
• Developed different Transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Expression, Stored Procedure transformation and Sequence generator for loading the data into target Data Mart.
• Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using WorkflowManager.
• Creation of Documents like Reusability Summary Document, Standard Domains Document, Unit Test Template Document, System Test Script Document.
• Ran different sessions and batches in workflow manager and studied log to modify mappings to obtain the correct results from transformation.
• Developed stored procedures, triggers, functions and packages used for the system.
• Extensively created various UNIX scripts using K-shell for event automation.

Environment: Erwin 4.0, Data Analysis, Business Analysis, Requirement Analysis, Gap Analysis, Data Warehousing, Informatica PowerCenter 6.2, Mainframe DB2 Business Objects 6.5, MS SQL server2000, Oracle 9i, PL/SQL,IBM, HP-UX 11.0, SQL*Loader, Windows NT, SQL Plus, and TOAD.

Boston Technologies, INDIA

Confidential, Bellevue, WA Jun'01-Dec'02

Data Warehousing Consultant

Voice Stream is one of the major wireless companies and the foremost in providing G.S.M. phones in U.S. market. The company has huge volumes of data coming from different sources, which were generated from multiple and cross platform applications. The Project involved design and development of data warehouse for the sales department.
Responsibilities:

• Collected and analyzed business requirements with the management and converted them into Functional specifications.
• Extensively participated in the Analysis, Design and Modeling. Worked on Star Schema, Data Modeling, and data Elements. Participated in creating data models for data marts.
• Created Logical and Physical models for Staging and Production Warehouses using ERwin
• Modeled the Data Warehousing Datamarts using Star Schema
• Created reusable Transformations & Mapplets in the development environment to load data from sources to store the data in staging area, and to target tables.
• Developed various slowly changing dimensional mappings according to data mart schemas.
• Developed UNIX scripts for scheduling the jobs.
• Created Universe using Business Objects for pulling the data for analysis and reporting.
• Created and maintained custom reports for the Business users using Business Objects.
• Created and Maintained Universes using Business Objects Designer
• Developed various reports in Business Objects
• Used Business Objects free hand SQL to generate Adhoc reports
• Helped in maintenance work related to reports
• Generated Adhoc reports as requested by the team lead using Business Objects free hand SQL

Environment: Erwin 3.x,SAS,Informatica Power Center 5.1.2, Workflow Manager, Workflow Monitor, Designer, Repository Manager, ERwin 4.1, Autosys, TOAD 7.6, Oracle 9i, Business Objects 5.1, DB2 UDB v7.1, SQL Server 2000, PL/SQL, Unix AIX 4.3, Windows XP/2000.