SUMMARY

• More than Twenty years of experience in full software life cycle playing various key roles in IT projects like Project Manager, Data Architect, Solution & BI Architect, and DBA
• Extensive experience as Data Modeler (8 years) building various type of data model (multidimensional & normalized) for Data Warehouse & Business Intelligence (DWBI) applications in the domain of Insurance, Finance, Manufacturing, Healthcare and Retail
• Experienced in building Data Integration solution (10 years) using wide ranges of ETL tools (Informatica, Datastage, ODI) and implementation of Business Intelligence Applications using OLAP/Analytical tools (Cognos, Business Object, OBIEE)
• Experienced as Oracle DBA (3 years) on UNIX platform performing dB set up databases, ORAC Server, Multi - master Replication. Architected and supported application on Teradata RDBMS platform (4 years)
• Worked for presales group providing RFP response, estimation, tools evaluation, infrastructure planning, prototyping and solution design
• Experienced in managing global delivery model (on-site, near-shore, off-shore) and familiar with agile methodology

TECHNICAL SKILLS

Modeling: ERWIN 7.x, Oracle Designer 6i

ETL Tools: Informatica Power Centre 8.1, 7.2, Oracle Data Integrator (ODI) 11g, IBM DataStage 10.x, SAS EG 4.3

BI Tools: IBM Cognos 8.0, SAP Business Object XI r2, OBIEE 10g

O/S: UNIX Shell/awk scripting experience - AIX, Solaris, HP-UX, Linux

Languages: Strong Oracle PL/SQL, Pro*C/C++, Teradata BTEQ, PostgreSQL, T-SQL

RDBMS: Oracle 11g r2/10g/9i/8i, Teradata v2 r5, Greenplum Appliance, Sybase 10.x, MS Access 2003, SQL Server 2008

PROFESSIONAL EXPERIENCE

Confidential

Solution Architect / Project Manager

Responsibilities:

• Worked as Project Manager and Solution Architect
• Devised framework and executed process to transition the production support of 250+ reporting applications (Mutual Fund & Life Insurance) from existing vendor and enabled off-shore team with smooth takeover with no business impact
• Guided the team to create system architecture, process/data flow diagram, job dependency diagrams, retirement process doc, run book, environment configuration doc, etc.
• Involved in creating to-be architecture and lead the team to prepare data model, high level and low level ETL design to migrate in to new data platform (Netezza) using Datastage
• Created pilot using Business Object Webi tool to demo capability of new reports

Confidential

Data Architect & Data Modeler

Responsibilities:

• Worked as Data Architect/Data modeler, and involved in creating model to build Interaction, Alignment, and Targeting & Segmentation subject areas for Healthcare CRM & Sales system
• Leveraged Erwin 7.3 tool to build logical and physical data model
• Involved in strategic design / data integration from cloud based system - SFDC/Veeva (CRM), MDM apps - Liaison/Sagedim (Customer), Global Prod Master, etc. to build central Repository and enable all CRM reporting and downstream BI application
• Maintaining data model in Erwin and supporting multi-stream parallel development activity. CRM system implemented at various European country in multiple releases and data in stored in a central repository

Confidential

DW&BI Solution Architect

Responsibilities:

• Played pivotal role in Confidential Insurance projects as Solution architect & Data Modeler
• Devised a comprehensive data warehouse solution architecture with multi-layer approach (ODS/Enterprise Data Warehouse/Data Mart)
• Build conceptual, logical and physical model for enterprise data warehouse encompassing all necessary subject areas like Policy, Claim, Finance, CRM, Insured Objects, etc.
• Prepared methodology to build operational/tactical/strategic dashboard application and laid out foundation to build Balanced Scorecards for CEO/CXO.
• Involved in implementation of data warehouse solutions build - data modeling, database design, ETL architecture, BI Report & Dashboards framework, etc.
• Playing important role in project on collaboration and communication with stakeholders, project estimation, road map creation, risk identification, mitigation plan, methodology and framework building.
• Involved in setting up PROD and UAT environment having complex hardware set up. Configured the tools to run the application system in High Available mode with load balancing
• Oracle RDBMS 11g r2 with ORAC configuration
• ODI 11g with web logic 11
• OBIEE 10g with web logic 11 (Cluster)

Confidential

Data Architect/Modeler

Responsibilities:

• Worked in a data integration project, performing data lineage analysis and data modeling for a solution to Integrate
• Involved in defining Business Object (BO) Universe and design of report application using BO XI r2
• Involved in re-architecture of cost forecast tool (CFT) design
• Provided guideline for tuning of production job with ETL code developed using Informatica 8.1 on Oracle 10g RDBMS

Confidential

Data Architect & ETL Architect

Responsibilities:

• Worked in spend analytics project performing data analysis, data modeling and solution building sourcing data from Oracle Apps 11i Accounts Payable, Purchase and GL modules
• Involved in ETL architecture design and tuning of code developed in Informatica 8.0
• Participated in design of dashboards for spend analysis using Hyperion Brio 11.0
• Participated in proposal writing in response to RFP
• Prepared case study, best practices and architecture docs

Confidential

Solution Designer & Pre-Sales Support

Responsibilities:

• Part of the CoE team for BI&DW practice. Responsible to build BI solution prototype for manufacturing and Hi-tech industry
• Articulation of cost effective solution in response to various client RFP/RFI
• Estimation of software project effort in response to RFP bids
• Prepared “ETL platform migration framework” for migration of data integration system
• Played key role in enabling micro site for knowledge repository

Confidential

Project Manager

Responsibilities:

• Managed a team of 30 members (peak size) having three tracks
• Project planning (task identification, resource loading, dependency tracking, etc.), risk mitigation planning, tracking of progress and client reporting
• Conduct WSR meeting with client PM, milestone review meeting with steering committee, etc.
• Project issue tracking, issue remediation and escalation
• In depth review of database design, help to prepare design/development standards & guideline, testing strategy, etc.
• Capture defect data, evaluation of various metric data and carry out root cause analysis
• Update project dashboard, cost sheet and review with internal QAG/Delivery Manager

Confidential

System Architect & PMO

Responsibilities:

• Responsible to prepare project plans and coordinate with the participating groups to roll out various releases in to production and deploy release upgrades in to different environments.
• Create system audit reports like CPU usage, IO usage, allocated disk space usage, etc.
• Prepare capacity planning of the system
• Monitor performance of the application and perform tuning
• Designed job repository to maintain all TWS maestro Scheduler jobs which helps to analyze the dependency and process flow
• Analysis of additional/out of scope tasks, estimation of effort, prepare CR to obtain approval, etc

Confidential

Data Architect

Responsibilities:

• Involved in data analysis and modeling of dimensional data warehouse (star schemas) in the business areas of Finance, Sales Order Management and Supply Chain Management.
• Identify key performance (KPI) matrix required by the user groups and model fact tables
• Modeled various Dimensions with complex hierarchies.
• Devised strategy to extract data (CDC approach) from Oracle Apps 11i using Informatica
• Designed and scheduled Informatica batches on Unix server using Cronacle Scheduler
• Worked as solution architect to analyze various data mining needs and model data marts
• Participated in the design of BI application using Cognos Cube based solution

Confidential

Oracle DBA

Responsibilities:

• Involved in requirement analysis and logical/physical design for DSS/EIS system (ODS).
• As Repository Manager responsible to maintain and deploy database schema objects and patches to all locations during various releases.
• Involved in the design and implementation of Advanced Multi-Master Replication
• Performed tuning of Application/SQL.
• Responsible to maintain multiple Oracle databases running on Sun E10K/E500 (Solaris 2.8) creating user profiles and handling security.
• Performed tuning of database parameters using Oracle supplied utilities and tools.
• Involved in migration of existing database and applications from Oracle database 8.05 to 8.1.7 and 8.1.7 to 9.1.
• Provided support to the development and test databases on 7x24 basis
• Responsible to set up the primary production database
• Implemented backup and recovery process using generic backup script (UNIX)

Confidential

Data warehouse designer

Responsibilities:

• Project leader (eight months) managing a team of six members during implementation of integrated Mine Management System (ERP) for Confidential Australia Ltd. Oracle 7 & Solaris.
• Worked as onsite coordinator ( Confidential, Chicago, USA). Responsible for analysis and design of the data warehouse system
• Worked with the core development team carrying out analysis, design and development of Order Entry, Purchase, A/R, Inventory, MRP, Inventory modules for the Confidential ERP package at onsite (Tucson, AZ, USA) using Sybase APT & Sybase RDBMS (Sun OS).
• Involved in implementation of Confidential ERP system for Confidential Confidential Ltd. at Confidential, Confidential, Oracle 7 (UNIX) platform
• Worked on Shop floor Management System for Confidential at Cincinnati, OH, USA
• Design and development of Mutual Fund scheme issue and maintenance for Unit Trust of India (UTI)
• System Support of VAX/VMS 7500