SUMMARY:

Highly accomplished and motivated professional with over 10 years of contribution in individual and leadership roles involving Enterprise software and consulting services, catering to a variety of different areas across many industry verticals, including business intelligence/data warehousing, data integration, master data management.

• 11+ years of experience in Data Warehousing (Dimensional Modelling, Database design and ETL) and Business Intelligence (Report, KPI, Scorecards, Dashboards)
• SME on building Enterprise DataWarehouse or Datawarehouse appliances from Scratch using both Kimball and Inmon Approach.
• Data Architecture (Conceptual, Logical, Physical) experience involves building 2.5 Normal form & Star Schema {Dimension (Slowly Changing, Snowflake, Conformed Dimensions), Fact, Metrics, and KPI} using Erwin .
• ETL Architecute experience involves defining different layers (landing/staging, recovery point layers,) complete ETL schedule and flow to fit SLA, mapping design, Error handling and Workflow Design on Informatica Power Center 5x, 6x, 7x, 8x. hands on mainly on Informatica, guided team on SSIS and Datastage.,. Worked on Databases like Oracle 9i, Oracle 10g, SQL Server 2005, SQL Server 2008 DB2 9.5 (IBM Smart Analytics System)
• Strong expertise as solution architect designing and delivering solution deployment architecture, Infrastructure sizing, performance and scalability options, benchmarking & tuning (application, database and hardware) for test, development and production environment
• Worked with high performance teams developing and implementing state-of-art data warehouse applications. Ability to understand (or get the customer to articulate) the business needs in terms of business value
• Managed and mentored 20+ team technically to deliver solutions , both partner and company
• Designed DataWarehouse with 36+ TB of Compressed Data and ETL layer loading 400 mn records for one adapter with multiple batch size.

TECHNICAL SKILLS:

Data warehousing s: Dimensional Modeling - Star, Snowflake, Fact Table, Dimension Table, Slowly Changing Dimension, Metrics, KPIs, OLAP ( Worked on Both Kimball and Inmon Approach)
Domain Expertise: Supply Chain Management (Demand Analysis, Distribution Analysis, Financial Analysis, Fulfillment Analysis, Inventory Analysis, Procurement Analysis, Allocation Analysis, and Resource Analysis, Transportation Analytics, Retail Analytics)
Telecommunication- Revenue & Usage Analysis, Customer Aquistion and Behavour Analysis, Product Profitability. Custom churn Analysis, Customer Segmentation.
Languages: C++,VC++, SQL, T-SQL, PL/SQL, XML, XSLT
ETL Tools: Informatica Power Center 5x 6x 7x, 8x, 9x , SQL Server Integration Services(SSIS), Infosphere 8.1 suite(Datastage)
Data Modeling Tool: Erwin , Infosphere Data Architect
Source Control Tool: Visual Source Safe, Rational Clearcase, Clearquest.
Databases: Oracle 8.x/9.x/10g, SQL Server 2000, 2005, 2008, DB29.5 (ISAS)
Application Server: Weblogic 6.0, 6.1 SP3, 8.1 SP1, Websphere
Project Management: MS Office Suite, MS Project, MS Visio 2003
Reporting and Analytical Tool: Tableau 6.1, Cognos 8, Business Objects XI Business Objects Web intelligence SDK, Informatica Power Analyzer 3.5.2, 4.1.1,5.1.2 SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS),
Master Data Management Products: i2 ABPP

EXPERIENCE:

10/11 to Till Date Confidential – Plano, TX
Principal Consultant/BI Architect
Involved in growing Enterprise Manufacturing Intelligence and Business Process Management Product/solution across Customers

• Created integrated storyboard of pre-sales demo for customer Husky Energy using Tableau 6.1 for Dashboard and Skelta for User Interface updating SAP BAPI.
• Involved in Pre-sale of EMI solution at American Sugar .Created PoC story board on their data and 5 different Dashboards containing 20+ reports in 2 weeks time.

Key Technologies: Wonderware Intelligence, (In house product), Tableau 6.1, Sql Server 2008

06/10 to 10/11 Confidential
Solution & Data Architect
The project was implement best of class IBM Smart Analytics System 7600 comprising of Cognos 8 BI Suite, DB2 9.5 (Parallel 24 nodes) ,iMiner & SPSS for mining & scoring ,

• Requirement Analysis & Workshops with business stakeholders
• Reporting (Cubes/Queries/Drill troughs) solution definition
• Designed TDW implementation Logical and Physical data model
• ETL architecture- Integration with downstream (Kenan, Interconnect, CRM, SDP, Mediation and IN)and upstream feeds ( Campaign, CRM, Analytical Models)
• Developed/Delivered workshop/trainings on TDW components , IBM Smart Analytics System
• Audit KPI Solution and Formulation
• Infrastructure sizing
• Mentored team in development of ETL, Model and Analytical Components
• Collaborate with different team with in Projects and different groups in IBM (Software Groups, Labs, and Distinguish Engineers) in validation/resolution of ongoing issues.

Key Technologies: IBM Smart Analytics System 7600 ( DB2 9.5, Cognos 8 BI suite, iMiner), InfoSphere Information Server 8.1(DataStage). InfoSphere Data Architect

06/09 to 06/10 Confidential
BI SME & Delivery Manager

• Managed and Mentored Leads to deliver multiple projects (PIE, Fraud Reporting, Master Usage, Segmentation) on time
• Analyzed Issues with ongoing projects, recommended action and implemented the same to streamline the delivery process and improve the quality of deliverable. Managed to deliver critical projects on time.
• Prepared EDW/BI transformation roadmap (with recommended EDW landscape) and later collaborated with local lead in proposal/follow up and engaged customer to start preparatory work for BI Re-engineering.
• Negotiated successfully with Customer on effort of a key project resulting in increase of more than 30% over the efforts proposed earlier by local team.

Key Technologies: Informatica 8i, Business Objects XI R2, Oracle 10g ,Erwin 7x.

08/08 to 02/09 Confidentiall -Austin, TX for Confidential
Solution Architect
This project involved development of analytics for S&OP Process using business intelligence tools from different vendors.

• Analysis of Existing Reports, Conducting workshop with Users from Different department
• Definition of Metrics around Sales and Operation Planning Process and validation of the same with end users
• Defining Strategy and architecture comprising of different tools for each layer and presenting to different stakeholders.
• Defining cubes in Sql server Analysis servcies
• Guiding the team with development of Informatica Mappings
• Defining Universe, Reports layout, logic and helping team in India build the same.
• Creating Universe and reports.

Key Technologies: Sql Server 2005,, Informatica Power Center 8.5, Business Objects XI R2. Erwin 7x.

10/06 to 08/08 Confidential-Pittsburgh, PA for Confidential
Solution Architect for Middleware (ABPP) and Performance Manager (BI DW Appliance)

This project involved implementation of ERP solution using Oracle and i2 products.
As Solution Architect analyzed, designed and guided customer and team members to implement i2 ABPP, middleware & BPM tool and Performance Manager(BIDW Application) across i2 and Oracle products ( Demand Management, Master Planning, Factory Planning, Demand Fulfillment, Material Allocation , Scenario Management and Master Data Management) and Oracle Fusion( Middleware tool). My responsibilities were planning, managing, delivery of i2 solutions using ABPP middleware tool and architecture of reporting solution using i2 Performance Manager.

• Templatize documents for i2 solutions on Accenture Methodology
• Interacted with Users from different departments for Requirement.
• Worked with large team comprising of 200 consultants. Interacted with 50 of consultants on weekly basis.
• Defined Architecture of ABPP, ABBP Fusion integration, ETL Architecture for Performance Manager.
• Created WebService Proof of concepts (POC) involving Oracle fusion and i2 ABPP
• Manage and mentored team of 20 customer resource in development of different modules in ABPP
• Guided partner resource in development of Datamodel, Reports and ETL adapter for performance Management

Key Technologies: AIX, WebSphere, Oracle 10g, XML, Pl/Sql, shell scripting, Perl, Informatica PowerCenter 7.1.2, Informatica poweranalyzer 4, Java scripting, WSDL, SOA.

10/05 to 10/06 Confidential -, Mexico City for Confidential
Solution Architect
This project involved implementation of i2 Performance Manager Solution for Manufacturing (demand forecasting, master planning) and Transportation Analytics. It also involved operational reporting for production scheduling. .

• Interacted with the users to gather requirements
• Carried out the complete analysis about Order, Demand, Inventory, Production , shipment data
• Created Technical Architecture Document, ETL Mapping Document
• Mentored Customer technical resources to develop the solution.
• Solved critical problem of Planning vs Actual reporting with regard to supply chain plan and later recommended the same to R&D Team to incorporate in the product.

Key Technologies: DB2 8 Informatica PowerAnalyzer 4, Informatica PowerCenter 7, AIX

06/04 to 10/05 Confidential
Technical Architect

i2 Technologies now JDA software was global leader in supply chain softwares.
part of the team who build i2 Performance Manager, a product which provided analytics and decision support framework for all of the i2 planning engines, from Build Phase 1 The data warehouse which was serving as a backend of the product was built on the principles of Dimensional Modeling. Informatica was used as an ETL tool to populate the Data warehouse. The front end Analytics and Reporting was done on Informatica Power Analyzer. The entire solution was built in phases which encompassed building several Analytical solutions :
Manufacturing ( Demand, Fulfillment, Procurement, Inventory and Profit Optimization analysis), Transportation Analysis and Retail Analysis.

• Led, designed, developed supported this product to grow from 2 to 25 customers
• As Team lead delivered 6.2.1, 6.2 and 6.1.5 releases on a very constrained timeline.
• Designed data model, Meta model, reports, Dashboards, KPIs and complex ETL adapters
• Guided team members in development, test, bug fixing.
• As team member for releases 6.1,1, to 6.1.4, designed and coded complex ETL adapter, metamodel creation and report , Dashboard, KPI, development for SCM, Retail and Transportation Analytics.
• Reporting Requirement Validation @Alcatel Paris
• Implementation of PM 613 @Philips SemiConducotr

Key Technologies: Informatica PowerAnalyzer 4 , Informatica PowerCenter 7.1.2, AIX, DB2 , HP-UX, Oracle, Solaris, Windows, Oracle 9i , Informatica PowerCenter 6.1.2, pl/sql, Clearcase:

08/03 to 06/04 Confidential,- for Confidential
Consultant
Billing and Claim Data Mart

• Redesigned & built GPDW ( global procurement datawarehouse)
• Helped Reporting team create reports in Busienss Objects.

Key Technologies: Shell scripting, Pl/sql, Oracle 8i

07/01 to 08/03 Confidential
Software Engineer

• Developed , Tested and fixed bugs for oneview Datawarehouse in Informatica PowerCenter 5
• Designed, coded GUI application using VC++.

EDUCATION :
Bachelor of Technology in Electrical Engineering

• Received Technical Excellence award across entire AAIM BU for work at US Steel.
• Received team member award for Motorola and Hitachi project in Patni.

Confidential