Summary:

• Over 10 years of experience in assessment, design, development, integration and deployment of Business Intelligence solutions, data architecture, data integration, data quality, metadata management, data standards, master data management, data mining, decision support systems, capacity planning and business analysis.
• 10 years of experience in data modeling, dimensional modeling data architecture.
• 10 years of experience in Business Intelligence solution design and Implementation using Ralph Kimball, Bill Inmon my own hybrid Methodology.
• 10 years of requirement gathering business analysis in various business domains.
• Proven project and team management skills. Ability to successfully work in multi-tasking environment.
• Experienced in designing scorecards, dashboards and reporting requirements with underline data warehouse/data marts with mixture of strong technical business knowledge
• Expertise in managing physical data models its database schema in large scale projects.
• Experienced in ETL design using the strength of Informatica PowerCenter, IBM DataStage, Ab Initio Oracle Warehouse Builders.
• Experienced in designing dashboards, scorecards, interactive enterprise reporting, OLAP solutions, statistical data analysis and data mining with Cognos, Business Objects, MicroStrategy SAS
• Designed and successfully implemented Software Development Life Cycle for Data Warehousing projects.
• Experience in Unix Shell Scripting application development experience in C , C , VB.Net.
• Strong communication presentation skills in technical executive forums.
• Ability to bridge gap between IT and business world by translating business needs into Business Intelligence solutions.
• B.S. M.S. in Computer Science with concentration in Data Warehousing.

Technical Skills:

RDBMS: Oracle 10g RAC, 9i, 8i, 8.0, 7.x, DB2, SQL Server 2008-2005-2000, Sybase 10.x, TeraData, MS Access, MySql

ETL: IBM DataStage, Informatica Power Center, Ab Initio, Oracle Warehouse Builder BI Tools: Cognos, Business Object, MicroStrategy, SAS, WebFocus

Language: C/C , C , VB.Net, Java, SQL, PL/SQL, UML, JSP, ASP, ASP.Net, Perl, XML

Script: UNIX Shell Script, HTML, Java Script

Tools Packages: Erwin, ER Studio, Power Designer, Visual Studio.Net, Rational Rose, MS Office, Informatica Data Profiler, PeopleSoft, SAP

OS: Solaris, Red Hat Linux, Windows 95 to 2000, NT, XP

Areas of Interest: Business Process Management, Data Architecture Pattern, OLAP, Service Oriented Architecture, Capability Maturity Model CMM , Data Mining, Microsoft Business Intelligence

Experience History:

Confidential

Role: Enterprise Data Architect

• Designed the Enterprise data warehouse framework and presented to business IT senior leadership
• Collected business requirements for building data warehouse from various business owners
• Analyzed and refined business requirements to produce data requirements
• Led the data modeling team to build data extracts from various source systems
• Designed and modeled data warehouse data model which includes: Customer, Sales Activity, Sales Requisition, Recruiting Activity, Employee, Product Hierarchy, Internal Organization, Candidate, Submittal, Requisition Position, Vendor, etc.
• Data is being sourced from PeopleSoft HR, Finance , Siebel, RWS Recruiter Workstation System and online job portals.
• Designed ETL process flow to load data from stage into DW while maintaining history in DW.
• Designed modeled Recruiting Activity Data Mart
• Designed modeled Submittal Data Mart
• Created source to target mapping documents for ETL developments

Environment: SQL Server 2008, Oracle, Erwin, Visio, WebFocus, PeopleSoft, Siebel

Confidential

Role: Senior Business Intelligence Architect

• Technical project manager of onsite and offshore resources for all Business Intelligence efforts for IMF Human Capital Management program.
• Working as IT liaison between IT and HR for HCM projects diversity scorecard.

• Managing development of Diversity Scorecard project, responsible for creating project plan organizing weekly status meetings, gathering requirements from diversity office, designing tables for reporting, data preparation, ETL design and coordinating ETL development with offshore resources managing scorecard development through Cognos Report Studio. Worked with business stakeholders for UAT sign off and deployed solution successfully.
• Responsible for the development of data warehouse for Human Capital Management.
• Responsible for developing and implementing enterprise metadata strategy.
• Provided professional leadership to exercise consistent data management practices across TGS.

Environment: Erwin, Cognos Framework Manager 8.4, Oracle, DataStage, Kalido, MS SharePoint, PeopleSoft HR, Taleo

Confidential

Role: Senior Data Architect

Enterprise Dimensional Model:

• Designed overall architecture framework for CareFirst reporting and business intelligence services.
• A complete integrated conformed dimensional model was built with over 90 dimensions and 20 facts. Participated in project from beginning lead various business analysis sessions to identify scope of the project.
• Primary contact person from data architecture team to work with data stewards for data conformance and data quality issues.
• Multiple business presentations were conducted for various stakeholders about new enterprise architecture and future state of enterprise reporting.
• Staging area receives XML files from multiple sources and loads into staging tables.
• Data into EDM is coming from the canonical layer and represents the integrated conformed CareFirst standardized enterprise view single version of truth.

• Created record level and field level ETL mapping documents. Lead the team of 10 data architects for coordinating DDL generation from different subject areas into dev, test and prod. Synchronized DDL in different layers of database through Erwin's Complete Compare process.
• Responsible for capacity planning for Data Informatics group.

Environment: Erwin Data Modeler 7.3.1, Visio, Oracle 10g RAC, XML, Informatica Power Center

Confidential

Role: Enterprise Data Architect

Pricing Network Solution: This multi terabyte solution is helping Geico in offering better auto insurance rates to its customers by performing data mining on claims and its related policy information.

• Conducted JAD sessions analyzed sources systems for data quality and data integration issues.
• Presented overall solution architecture and was responsible for creating logical/physical data model for data mining via SAS MicroStrategy, acted as liaison between business IT and delivered ETL specification for more than 800 attributes.
• Designed BI reports and mapped them to underlying data mart.

Underwriting Research Data Mart: This data mart was delivered to underwriting research group for their analysis of new business, renewals and reissues of auto insurance policies.

• Understood complicated statistical financial models of underwriting group and converted into SQL to implement within ETL.
• Work performed includes: leading JAD sessions, gathered business and data requirements, solution architecture, source systems analysis and data profiling using SQL, relational dimensional modeling, metadata publishing, generated ETL specifications for field level and record level using Erwin. Identified and resolved data integration issues.
• Work closely with business team to come up with report design.

Policy Data Mart:

• Enhanced the functionality of existing Policy Data Mart to perform specialty market analysis for auto insurance.
• Main tasks performed were requirement gathering data analysis, star schema design, source to target mapping document and data profiling.
• Worked on IBM Data Stage as an ETL tool for replacing Ab Initio.

Environment: Erwin Data Modeler R7, DB2, Ab Initio, MicroStrategy, SAS, Oracle, SQL Server, DataStage

Confidential

Role: Lead Business Analyst/Lead Data Architect

This data mart consolidated Order, Usage and Inventory information from Legacy Order Management System WCSS and online order entry application winXS . Customers have the ability to run following reports: Backordered Items, Inventory Status, Low Stock Report, Items on Order, Trend Usage Analysis, Value of Stock Remaining, Combination Production Order Analysis, Shipment Summary, Open Production Orders Slow Moving Items. Master Data Management was implemented for customer subject area as an enhancement for this project. Worked extensively on Kalido Master Data Management.

Responsibilities:

• Designed 3 Tier Architecture for Enterprise Data Warehousing. Tier 1 for Staging data, Tier 2 for Enterprise Data Warehouse for reusability and data integration. Tier 3 for Data Marts.
• Lead JAD session to define scope and gather requirements.
• Source system data analysis and loading XML data into staging tables.
• Designed metadata and data movement strategy among three tiers.
• Design logical and physical models for all three tiers.
• Created Data Mart development methodology to reduce cost and faster project delivery.

Environment: Erwin Data Modeler 4.1.4, Visio, Oracle 10g RAC, DB2,XML, UNIX Shell Scripting, Informatica Power Center, Informatica Data Profiler, Rational Unified Process

Confidential

Role: Business Analyst/Lead Data Architect/Project Manager

This data mart facilitates management to see Overage Inventory in RRD warehouses. Business can save millions of dollars by effective management of warehouses and Unpaid Overage Inventory.

Responsibilities:

• Created project plan, managed resources and delivered project on time business.
• Lead requirements gathering efforts
• Designed logical and physical data models for all three tiers of data warehouse.
• Developed ETL source to target mapping document.
• Designed reports with Business Users and Business Object team.

Confidential

Role: Business Analyst/Lead BI Architect

• This data mart integrates data from PeopleSoft Resource data , Primavera Project, Project Activity, Project Milestone, Status Reports, Time tracking , HP Service Desk Work Order, RFC, Incident, Service Call, SLA PMO data SDLC Compliance, New Project Request, RFC, Break Fix . Data marts helps IT management in resource management/planning allocation, service delivery, streamline business processes, project performance monitoring, project scheduling recruitment.
• Worked with PMO office and HR for scope of project defining reporting requirement
• Analyzed profiled Primavera, HP Service desk PMO internal databases for data integration
• Built integrated dimensional data model for Business Objects reporting
• Worked closely with project owners to define the layout functionality of reports
• Mentoring of ETL BI teams on design and development of this project
• Created and executed test plans for data quality assurance

Confidential

Role: Lead Data Modeler/Data Architect

Manufacturing Operational Data Store ODS is to fulfill data integration needs for transactional applications as well as to provide Data Warehousing infrastructure for manufacturing applications.

Responsibilities:

• Identified business process flow diagram.
• Presented architecture design of ODS considering ODS feeding future data warehouse and data Marts.
• Source systems analysis for data quality and data integration.
• Solved data integration issues and provided source to target mappings to ETL.

Metadata management and generation of DDL of these models through Erwin 4.1

Environment: Cognos, SQL Server, Erwin, Erwin Model Validator, Visio, Oracle 9i, ER Studio, PeopleSoft, SAP

Confidential

Role: Lead Data Modeler

This warehouse gets the data from different operational inventory systems operated by different distributors. With the help of this system, management can see the available parts with different distributors and their price comparisons.

Responsibilities:

• Responsible for dimensional data modeling using star schema.
• Resolved data integration issues and managed published metadata from Erwin.
• Provided training to various teams on Object Oriented Analysis Design and its modeling like Use Cases, Class, State Activity, Sequence, Deployment Diagrams etc.

Environment: Erwin, Oracle 8i, Teradata, Sybase 10, SQL Server, SQL, PL/SQL, Solaris, RUP

Confidential

Role: Data Modeler

Developed logical and physical data models for Electronic Resource Management System ERMS , CPOS Order Management System. Maintained data dictionary and business requirement artifacts.

Environment: Erwin, Oracle 8, SQL Server, Visual Basic, Rational Rose