SUMMARY

An IT Program Manager and DW-BI Lead with 6 years of experience providing program Management, Business Analysis, Solution delivery, Data Architecture, Data Modeling and Application Development. Results oriented and Client-focused, leveraging leadership, in-depth technical knowledge, organizational and business development skills. Strong interpersonal, communication, team building and motivational skills combined with an in-depth understanding of technology, solutions and the marketplace.



SPECIALITIES

· Project Management
· Rational Unified Process
· Data Warehousing-Business Intelligence (BI)
· Requirement Analysis and Business UAT
· Data Architecture
· Data Modeling
· Application Development and Solution Delivery
· Proposal Making and Negotiations
· Contract Management and Client Relations
· Business Process Improvements
· Sales and Business Development


SKILLS

Process Methodologies – CMM, RUP, SDLC
PM Software – MS Project, MS Visio, MS Excel, MS Power Point, MS Word
Data Modeling – Conceptual and Logical Data Modeling, E-R and dimensional; ERWIN,
Power Designer
Databases - Oracle 9i/8i, Microsoft SQL Server 2000, MS Access
ETL - Informatica (x), SAS, AbInitio, Autosys
OLAP - Business Objects 6/5(x)
Operating Systems – Unix, Windows (x)
Languages - PL/SQL, SQL, Unix Shell Scripts
Others - Java, XML, JavaScript, XHTML, HTML, C++, VBScript
Web/Application Servers – Apache Tomcat 4.0, IBM Websphere 4.0.1


EXPERIENCE

ACCENTURE CONSULTING 05/02 – Till Date

Client : Partner ReInsurance, USA/Zurich (07/04 – Till Date)
(Peak Team Size: 25 Approx Value: 4 MN)
A Re-Insurance company in the process of building up a Information Management System which can re-structure and organize certain Business initiatives like Operational Information, EIS, BU-Management Information, Solution Architecture etc. Having a successful track record of 10 years in providing BI Solutions. The IM-OI initiative has been outsourced to Accenture.

- Responsible for Managing the Operational Information Initiative. Provided a Business solution for structuring/maintaining Operational Data from Transactional systems.
- Structured an Onsite-Offshore cost-effective model for Solution Delivery, by evaluating Clients IT operations in the years ahead.
- With right process methodologies in place, ensured proper planning for all phases of the project and their respective Iterations. Managed all phases of the Project lifecycle till Deployment.
- Handle Work Estimation, Resource staffing and Accounting for the entire team of 25. This includes both the onsite-offshore components.
- Ensure that all the LOE’s have been rightly defined for the different iterations in all phases of the project.
- Attend Client meetings for current status on the project and discuss future scope and upcoming events. Propose Business Process Improvements and develop Client Relations.
- Assure that all deliverable deadlines have been met with 100% quality rating as per the required standards.
- Have weekly status meeting with the Team, including all the technical leads, developers and the Infrastructure team.
- Determine individuals’ strengths and areas of improvement. Work with them in improvising their thought process, for right approaches and face high level challenges.
- Involved in Business UAT across phases, ensured that all challenges have been met and users are satisfied and comfortable with the product delivered.
Technology: PM Software, RUP, Erwin (Data modeling), Informatica, Business Objects, MS SQL Server, SICS/nt Transactional systems, Oracle, Unix.

Client: GE Consumer Finance, USA (04/03 - 07/04)
(Peak Team Size: 150 Approx Value: 25 MN)

A large financial firm had outsourced its Data Management activities to achieve significant savings in operating costs and to improve organizational productivity. The key purposes were to drive cost reduction, and to improve one time project delivery by one sigma. At the core of the Data Warehousing environment is a very complex ETL framework consisting of Tool Based ETL streams as well as custom developed scripts.

I was managing initiatives of the two major projects of the engagement (A 150 member team), one was the enhancement and maintenance of the existing data management system and the other was integrating the different warehouses of Consumer related data into a Consumer Data Customer Insight (CDCI) portal. Performed varied roles across a time span of more than a year and half.

- Assessed, planned and lead several key initiatives with onshore-offshore components costing Approximately 4-5 MN Dollars.
- Resource staffing and Accounting for the related Verticals that have been led by.
- Attend client meetings to discuss weekly SLAs’ and status of Build deliverables.
- Designed and implemented ETL approaches for processing large feed files from different sources.
- Analyze different consumer related warehouses and layout an appropriate architecture for designing a Customer insight portal of the consumer data (CDCI).
- Involved in architecture and design of building up an enterprise data warehouse of the Consumer data.
- Enhance the end user reporting architecture and maintain the complex existing reporting environment.
- Managed the Consumer vertical (50 TB), with a run team of 25 people with 24/7 production support across all major data warehouses and a solutions task force team of 20.
- Had put in place process improvement methodologies for effective functioning of the complex production system. Defined metrics for tabulating all daily processes.
- Managed the exclusive digital cockpit (Reporting system) of the client, which bought in around 40% of the market in its finance business.
- Involved in system testing and performance tuning across various modules of the project.

Technology: PM Software, Erwin, Business Objects, AbInitio, SAS, Oracle, Unix, Autosys, Shell Scripting and Perl Scripts.

Client: Chase, USA (10/02 – 04/03)
(Peak Team Size: 20 Approx Value: 3MN)

A large Credit card provider had outsourced its Data Management activities to Accenture to achieve significant savings in operating costs and to implement process improvement measures. The purposes of the initiative was to Drive cost reduction and process improvement measures and to attain a better time to market turn around time.


- Managed the data warehousing Initiative of enhancing ETL processing capabilities of the system.
- Provided a business solution of employing state of the art change data capture technique and eliminate manual data integration and reconciliation activities.
- Implemented a data quality framework, which reduced the data duplicity errors significantly thereby increasing the data confidence level.
- Improved the business level EIS dashboard and decision support system capabilities.
- Proposed Business Process Improvements which would reduce the time to market factor by 30% thereby reducing the opportunity cost.
- Ensure quality as per standards for all the phases that have been implemented.
Technology: PM Software, Informatica, Oracle, and Unix.


Client: GE Structures and Supplies, USA (05/02 – 10/02)
(Peak Team Size: 15 Approx Value: 2.5MN)

A Structured Services firm has outsourced its data integration, data processing and data cleansing part of different business unit data coming in form of feed files from multiple mainframe systems. These feed files from the various business units of the company were to be processed, integrated and stored in a EDW which has information about the Organization, Customer, Supplier, Inventory etc.

- Provided a business solution of integrating feeds from various business units and store data in an EDW.
- Conducted workshops and JAD sessions during requirement gathering and analysis of the various subject areas across different business units.
- Worked with subject matter experts to sketch out a conceptual enterprise data model, and adopted an iterative development methodology using subject areas
- Data Architecture for the multiple feed files coming in from various source systems.
- Reviewed the Design and development of ETL logic for all feed files coming in from multiple source systems.
- Involved in unit and end-to-end testing of the code that has been developed.
- Prepared project status reports and presentations to key stakeholders and vendors.
Technology: PM Software, Erwin, Informatica, Oracle, and Unix.







PM TECHNOLOGY SOLUTIONS 09/99 – 04/02

Client: Prudential Corporation of Asia (11/01 – 04/02)
(Peak Team Size: 20 Approx Value: 1.5 MN)

The challenge was to set up an Advisory tracking system for a Big Insurance Company in Asia. This Tracking system would track and record licensing, continuing education and E&O (Error and omissions Information).

- Responsible for setting up the Advisory Tracking system for the Client as per the requirements. Designed a modular approach for Solution Delivery by identifying subject areas like Advisory migration, Advisory Statistics (such as commission, policy premiums, policy fares) etc.
- Managed a team of developers, technical leads and writers all through the engagement.
- Provided sign offs’ for freezing requirements for the respective modules.
- Check for required standards on the quality of the code that’s delivered to the client before Sign off.
- Implementation support and Version Control. Ensure timely deployment for all modules of the project.
- Timely status meetings with the Client to discuss current delivery and future objectives/challenges.
Technology: Java, J2EE Technologies, Oracle, Web/Application Servers and Windows.


Client: Guardian Life Insurance, USA (06/01 –11/01)
(Peak Team Size: 15 Approx Value: 1 MN)


- This is a Pending Case Management Project, which would help track agents’ new business from the date they submit the application to the date they deliver the case.
- Understand user requirement and system specifications to achieve key objectives of all modules
- Deliver a product, which could track Life, LTC, and Annuities etc. Store unlimited policy specific notes, view processing pending cases, see underwriting requirements on case Managers’ calendar and document case history.
- Architectured and lead the team to deliver the product in the right timeline for all modules.
- Attend Client meetings to discuss the progress of Application development. And advice for Process Improvements where necessary.
Technology: Java, J2EE Technologies, Oracle, Web/Application Servers and Windows




Client: Ifcon Net Services, India (01/01 – 06/01)
(Peak Team Size: 10 Approx Value: 600K)

- This is Report development and Operations maintanence project for a Financial Services firm.
- The report system was particularly designed to help Portfolio Managers provide clients with highest total ROR consistent with their performance goals.
- Defined progressive modules for report development and UAT test cases in the defined subject areas.
- Involved in finalizing the requirements and design across all modules of report development.
- Account management for Billable hours and expenses for the entire team.
- Trained the team for adequate knowledge, functionally and technically.
Technology: Oracle, Business Objects and Windows



Program Lead/Client Services Co-ordinator (09/99 –01/01)

- Responsible for coordinating various reporting and Database application projects. Lead a small team of Developers across projects and ensured that the right steps have been taken in the Software Development Life cycle Process.
- Member of the Client services team responsible for marketing business solutions for the company.



ACTIVITIES/TRAININGS

- Lead member of the DW-BI Capability team (Accenture) involved in Client Presentations and marketing of BI solution delivery for the company.
- Accenture Project Management Training – Hartford, CT



EDUCATION

Bachelor Of Engineering (Computer Science), India.