Profile

• 9 years of total IT experience
• 6 years of Data Modeling
• 6 years of Informatica experience
• 6 years of Data Analysis

Summary

• IT: 9 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 Financial, Insurance, Pharmaceutical, Health Care and Telecom industries.
• Data Modeling: 5 of experience in using Data modeling tools like Erwin 7.1/4.5/4.0/3.5/3.x, Power Designer 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 while implementing Decision Support Systems. Experience in FACT & Dimensions tables, Physical & logical 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, 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 R12/9i/8i/7.x, MS SQL Server 2000/7.0/6.5,MS Access7.0/2000, SQL, IBM DB2, PL/SQL, SQL*Plus, SQL*Loader and Developer 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
• Certified in DWH Project Management

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 Designer12.5, Oracle Designer,ER Studio

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, SAP Xcelcius

Others

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

Databases

Oracle 11i/10G/9i/8i/8.0/7.x, DB2 8.0/7.0, Teradata V2R6/V2R5/V2R4, IBM DB2 UDB, MS SQL Server 6.5/7.0/2000, 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

Professional Summary

Confidential, WI Aug-Current
Data Arch/ Data Modeler
HIPPA Certified

APS 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 methodologies in Project plan
• 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, DB2,ETL Informatica, SAP Xelcius, BO, Xplanner, Oracle 11i, Crystal Reports.

Confidential, April 09 to Jul 09
Camp hill, PA
Back Fill Data Modeler/Data Arch
BCBS is a health Insurance Client. The objective in this project was to build a data warehouse consisting of data about old customers as well as new customers and Facets. The old customer's data were to be extracted from the existing database. In addition, new customers were added by promotional schemes which were being offered as part of the company's policy to expand business. The new database helped in evaluating critical business performance parameters.

Role

• Part of the team responsible for the analysis, design and implementation of the business solution.
• 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 Oracle data marts to Teradata data warehouse, as well as ETL framework to supply continuous updates to the data warehouse.
• Prepared business case for the data mart and then developed and deployed it.
• 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.
• Designed Transaction Data Model for ACH
• Write and enforce Oracle programming standards (SQL, PL/SQL, embedded SQL).
• Performed Reverse Engineering of the current application using ER Studio, 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.
• Worked on IMS Health Data
• Loaded Reference Data for MDM process
• Participated to bring the Master Data and manage the data according to requirements
• Defined and processed the facts, dimensions.
• Designed Health care Facets Model
• Creating databases for OLAP Metadata Catalog tables
• Participated to design OLAP cubes
• Participated in Data Conversion Project design
• 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 quarrying in SQL and PlSql
• Performed root cause Analysis on Raised Tickets
• Provisions were made for ad hoc querying and reporting using Crystal Reports 9, T-SQL.

Environments: Linux, ER Studio 7.5/7.1, SQL Server 2008 Oracle9I, IMS, DB2, Oracle R12, Teradata V2R5, Siebel Analytics , SAS.

Confidential, BELLEVUE, WA
Principal Data Modeler/Data Analyst
MAY'08-Apr09

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. We own and operate a diversified portfolio of well-recognized brands — including Expedia.com, Hotels.com, Hotwire.com, Trip Advisor, Egencia, Classic Vacations®, and a range of other US-based and international businesses. Together, these popular brands and innovative businesses make Expedia, Inc. the largest online travel agency in the world, the third largest travel company in the US, and the fourth largest travel company in the world. And we are on a mission to become the largest and most profitable seller of travel in the world, by helping everyone everywhere plan and purchase everything in travel.
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.
• Worked with Agile methododlogy
• 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.
• Initiated and collected requirements for MDM and Data Governance projects
• 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.
• 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.

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

Confidential, Deerfield, IL Feb'08-May08
Takeda Health Care, Japan
Senior Physical Data Modeler/DA
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.
Takeda unique culture sets them apart. TPNA is committed to patients, employees and the community. They have an innovative, entrepreneurial spirit combined with the rich history of 225-year-old parent company.
Headquartered in Deerfield, Illinois, a northern suburb of Chicago, TPNA is a wholly owned U.S. subsidiary of Takeda Pharmaceutical Company Limited, Japan's largest pharmaceutical company. With more than seven years of service in the U.S., we have grown rapidly and each step of that growth remains true to the company's integrity, heritage and people.

Responsibilities:

• Gathered requirements from business users and analysis based on the requirements.
• 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
• Created TeraData Data Marts
• Used fast export(TeraData) to export 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
• Worked on IMS Health data
• 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, Abnitio 2.13, Dataastage, Toad 8.0, Oracle 10G, Teradata V2R5, PL/SQL, UNIX, Cognos 8.2, Report net MR2, Trillium, Codex, SVN,VSS, .NET, Java, FTP,DB2, Frame work manager, Win XP.

Confidential, Rochester NY Jun'07-Jan'08
Senior Data Modeler
Confidential, 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. Xerox\'s services expertise is unmatched and includes helping businesses develop online document archives, analyzing how employees can most efficiently share documents and knowledge in the office, operating in-house print shops or mailrooms, and building Web-based processes for personalizing direct mail, invoices, brochures and more. Xerox also offers associated software, support and supplies such as toner, paper and ink.

The company\'s operations are guided by customer-focused and employee centered core values such as social responsibility, diversity and quality augmented by a passion for innovation, speed and adaptability.

The Customer Information program is an initiative that provides Xerox with the capability to obtain and consolidate global, establishment level customer data. Data collected will be made available to Xerox users. USCR is another program concentrated on North America for customer reports.
Responsibilities:

• Gathered requirements from business users and analysis based on the requirements.
• Created Technical specification documents USCR and CI.
• 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.

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

Confidential, CT
Boehringer Ingelheim Consumer Health Care (UK) Jun'05 - May'07
Senior DW Data Modeler/ Data Analyst

Confidential, 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.
The Consumer Health Care business is a core part of the global Boehringer Ingelheim Corporation. In the UK our consumer health care products are available to members of the public \'over the counter\' (OTC) which means that they can be obtained from pharmacies and other major retailers without a prescription. Our product portfolio includes many leading natural health and gastro intestinal brands
Responsibilities:

• Gathered requirements from business users and analysis based on the requirements.
• 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 IMS health care Models.
• Designed Claims Data Models for Boehringer Healthcare, UK
• Worked extensively with offshore team of 8(UK)
• Principal Modeler for Health care claims section.
• 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.
• Gathered requirements for data cleansing and data transformations
• Extensively used loader utilities to load flat files into Teradata RDBMS.
• Used Data Flux for data Integration process.
• 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, Visula Studio,MS SQL Server 2000/2005,MS Access, Business Objects 6.5, Data Flux, Autosys, Unix, Win XP.

Confidential, Seattle, WA Jan'03-dec '04
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, Erwin, HP-UX 11.0, SQL*Loader, Windows NT, SQL Plus, and TOAD.

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, 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.

Confidential, India Aug'98 - May 01
BA
The main objective of this project is to provide the senior and the middle level management of the organization with Instructions to teach software oriented courses to kids below 15 and bring new projects and set guide lines.
Responsibilities:

• Gathering Requirements for software and process
• Managing the company by counseling and marketing
• Bringing up new projects and setting guide lines
• Game testing and Analysis
• Data Base Administration and Conducting and participating demo work sessions

Environment: oracle, MS Office, SAS, MS access,Mercury