CAREER OBJECTIVE / SUMMARY

· Excellent knowledge in OLAP design & architecture, ETL, data conversions and data mapping.

· Extensive experience with object and distributed technologies, web based applications and applications using multi-tiered architecture.

· Widespread knowledge of software development life cycle and support of a wide range of business applications.

TECHNICAL SKILLS

Data warehousing / BI / Reporting Tools

Ø MSOLAP - SSAS / SSIS

Ø Multi Dimensional expressions (MDX)

Ø Proclarity / Performance Point, MS Reporting Services, Crystal Reports

Ø Cognos Impromptu / PowerPlay

Ø SAP BW, Bex Analyzer

Ø SAS EG 4

Ø Actuate

Databases

Ø Oracle 8i /9i /10i [5 years]

Ø Sybase Adaptive Server [4 years]

Ø Access 2000 [2 years]

Ø MS SQL Server 2005/2000 [10 years]

Technologies

Ø Data Warehousing, OLAP Modeling, Cube design

Ø Data Modeling

Ø Object Oriented Programming / Analysis

Ø COM

Ø UML

Ø ASP.NET [3 years]

Ø ADO.NET [3 years]

Ø HTML

Ø XML

Ø MSMQ

Ø MTS

Languages / RAD Tools

Ø VB.NET [4 years]

Ø Powerbuilder 8.02 & below [6 years]

Ø VB Script [3 years]

Ø Transact SQL [10 years]

Ø C# [1 year]

Ø Visual Basic 6.0 [2 years]

Ø Java Script [1 year]

Ø PL-SQL [5 years]

Operating Systems

Ø Windows XP / 2000 / NT

Ø Unix / MS-DOS

BUSINESS SKILLS

Application Domains

Ø Financial & Brokerage

Ø Utilities

Ø Pharmaceutical

Ø Entertainment

Ø Engineering

Ø Life & Disability Insurance

Ø Decision Support

Ø Manufacturing

Functions Performed

Ø Managed small development teams

Ø Coworker Mentoring

Ø Technical User Training & Support

Ø Software development lifecycle

CONSULTING WORK EXPERIENCE

Dec 2006 – Present CFM Corp (A subsidiary of Teachers’ Private Equity) – Data warehouse Specialist

Technical Environment: MSOLAP (SSAS), ETL (SSIS), BI Reporting: Proclarity / Performance Point / SSRS, SQL Server 2005, Oracle, SSA(Baan LN, Baan 4C), JD Edwards, Demand Works for Forecasting and Demand / Supply Planning

¨ Provided dimensional modeling and designed MS OLAP cubes, standard cube calculations for Sales and Margin Analytics.

¨ Managed and maintained different aspects of the warehouse i.e. ETL processes development (loaded data from multiple structured and unstructured sources), cubes and job schedules, ad-hoc reporting, administration of all SQL databases.

¨ Created SQL application for annual budgeting & planning of SKUs.

¨ Analytic reporting to monitor sales activity, warranty & sales budgeting.

¨ Administered and supported Proclarity Analytics Server and Demand Works (a forecasting & supply planning tool).

July 2006 – Nov 2006 CIBC (Retail Risk Management) – Sr. Database / Data warehouse Analyst

Technical Environment: MSOLAP (SSAS), Pivot Tables, SAS EG4, SQL Server 2000/2005, Windows XP, MS Visio 2000

¨ Designed and created MS OLAP cubes for the purpose of OSFI Data Call / Management Reporting.

¨ Used SAS EG4 / Pivot tables for creating datasets from OLAP cubes for reporting.

¨ Trained and mentored co-workers.

¨ Prepared Documentation of Cube Architecture.

¨ Developed cube automated monthly processing using DTS / Decision Support Objects.

May 2005 – June 2006 Vasogen Inc. – Sr. Data Analyst

Technical Environment: VB.Net, ADO.Net, C#, ASP.Net, MS SQL Server 2000, SQL Reporting Services, SQL Analysis Services, Cognos Impromptu / Powerplay, Crystal Reports 9.0, Share Point Portal Services, Windows XP, MS Visio 2000, IIS, XML

¨ Preparation and design of extensive extractions for data loads using Microsoft Data Transformation Services.

¨ Designed OLAP cubes for reporting.

¨ Created User Requirements and Design documents.

¨ Database modeling and design for storage of treatment records as well as extensive analytical reporting.

¨ Web application design and development for reconciliation of treatment records for clinical trials.

¨ Created Validation Plans and Protocols to comply with FDA regulations.

July 2004 – May 2005 Envision IT – Sr. Data Analyst

Technical Environment: VB.Net, ADO.Net, C#, ASP.Net, SAP BW, MS SQL Server 2000, SQL Reporting Services, SQL Analysis Services, Cognos Impromptu / Powerplay, Crystal Reports 9.0, SharePoint Portal Services, Windows XP, MS Visio 2000, IIS, XML

¨ Extensive SQL Report development / data migration for an entertainment company.

¨ Analysis, design and implementation of OLAP cubes and reports using Cognos Impromptu / SQL Analysis for various clients.

¨ Web application design and development for managing inventories across multiple locations for a manufacturing company

¨ Data extraction, cleansing and migration for the manufacturing company using DTS and SQL Scripts

¨ Created Transfer / Update structures & developed reports in Bex Analyzer / Explorer using calculated & restricted key figures, variables, currency conversions.

April 2003 – June 2004 Sanofi-Aventis – Project Manager / Sr. Analyst

July 2004 – Present Sanofi-Aventis – Part time (12 hours /week)

Technical Environment: VB.Net, ADO.Net, C#, ASP.Net, MS SQL Server 2000, SQL Reporting Services, SQL Analysis Services, Cognos 7.02, Crystal Reports 9.0, Windows XP, MS Visio 2000, IIS, XML

¨ Created functional specs/ analysis document on enhancements – phase 2.

¨ Managed timelines and coordinated development effort.

¨ Created catalogs in Impromptu for the Clinical Database

¨ Analysis & design on OLAP cubes using SQL Analytics.

¨ Research on BI tools and requirements analysis on reports needed by users.

¨ Complete responsibility for testing & deployment.

¨ Analysis on user requirements for application interface and reporting.

¨ Application design and development for monitoring Clinical Trials used by Research and Development Department to track clinical studies, patient payments, investigators and their specialties, using both Win Forms and Web Forms.

¨ Developed common classes that are reused within the application.

¨ Designed / Modeled the database using Visio and developed all complex queries as stored procedures.

¨ Data Migration was done using DTS packages and migration scripts. Optimized slow queries used for complex analytical reporting.

¨ Statistical Reporting for Resource Planning was done using database access layer classes.

¨ Developed different levels of security for different levels of users.

¨ Created a maintenance plan for regular database backups as well as a process for weekly data transfer between Oracle and SQL Server databases.

Technical Environment: VB.Net, ADO.Net, C#, VB, MS SQL Server 2000, Oracle 9i, Access 2000, MSDE, Crystal Reports 9.0, Windows XP, MS Visio 2000, ASP.Net, IIS, XML, SQL Reporting Services

August 2000 – Feb 2003 ABB Canada – Sr. Analyst / Developer

January 1999 – Dec 1999

¨ Analysis / Development on the Retail Order Entry, Tracking / Scheduling system. Major enhancements to Shipping / Warehouse / Product / Tracking modules.

¨ Database development & creation of data extraction / migration scripts on the Decision Support System

¨ Enhancements of Framework libraries including the messaging service using MSMQ & interfacing of COM Components with different systems.

¨ Preliminary development / investigation for conversion of common services / components to the Windows .NET platform

¨ Designed and developed reporting screens in ASP.Net (2002)

¨ Created summarized reporting on replicated database using Actuate / Crystal

Technical Environment: VB.Net, ASP.Net, ADO.Net, C#, Powerbuilder 8.02 and below, PFC, MS SQL Server 7.0 / 2000 (MCP), COM, Oracle 8i, SQL*Loader, Visual Basic 6.0 , Crystal Reports & Actuate 6.0, Windows NT 4.0, Windows 2000, Visual Interdev & ASP, VBScript, Erwin, Working knowledge of XML (DTD’s and schemas)

April 2000 – July 2000 MD Robotics – Sr. Analyst / Developer

¨ Development on the Document Management System used by NASA for tracking and maintaining engineering documents. Performed framework enhancements and tuning on slow queries.

¨ Conversion of 2 modules in ASP.

Technical Environment: Powerbuilder 6.5, 7.0, PFC, MS SQL Server 7.0 (MCP), Sybase 12, ASP

Nov 1997 – Dec 1998 Swiss Re Life and Health

¨ Analysis / Design on the Claimant Information System that allows users to track details of Disability, Life and Medical claims across several locations in N.America.

¨ Data Mapping & Migration. Coordination of conversion errors.

¨ Managed and coordinated development / testing of a team of 2 developers.

¨ Trained and provided technical support and on-going assistance to users

Technical Environment: S-Designor, Powerbuilder 6.0 and below, PFC, Sybase Adaptive Server 11, Oracle 7, Visual Basic, Windows NT 4.0

Oct 1996 – Oct 1997 Consumers Gas

¨ Analysis / Design on the Customer Information System (CIS) to support the requirements of most business units within Consumers Gas. The application was primarily for the use of over 500 authorized dealers & 1400 administrative staff.

Technical Environment: Erwin, VB, Powerbuilder 5.0, Sybase 11, Windows NT, Unix, DB2, COBOL CICS

Apr 1996 - Oct 1996 Midland Walwyn (Merrill Lynch)

¨ Analysis / development of the Investment Analysis system used for tracking daily sales / purchase of securities by different brokerage firms.

¨ Designed / Modeled the database, extracted data feed coming in through the TSE & migrated it to data-warehouse tables for reporting.

¨ Completed scripting for data migration.

¨ Managed ad-hoc and custom reporting requirements on the trade floor.

Technical Environment: Erwin, Powerbuilder 4.0 & 5.0, Sybase System 10 & 11, Oracle 7, Windows NT, Sun

Solaris UNIX, Sybase SQL Anywhere

Apr 1995 – Mar 1996 BICC Phillips Limited

¨ Coordinated efforts of a team of 3 developers on the reporting system.

¨ Analysis / development of the Inventory Management System / Cost Revision System.

¨ Implemented use of Stored Procedures / Views & proposed use of coding standards.

Sep 1994 - Mar 1995 Spar Aerospace

¨ Designed an Executive Information System used by the Managers at NASA for Project Management i.e. tracking of employee hours on different projects.

Nov 1987 - Aug 1994 Applications Programmer - United Cigar Stores

Programmer/ Analyst - Seaton Engineers

¨ Conversion of a manufacturing system developed in Reflex to Powerbuilder 3.0

¨ Designed and developed workflow applications using Delrina Forms flow (Forms Designer & Routing Package.)

EDUCATION / CERTIFICATIONS / PROFESSIONAL COURSES

Bangalore University, India (Major - Economics)

Microsoft Certified Professional (MCP): Designing and Implementing Databases with SQL Server 7.0

Professional Certification in Web Design & Development (Univ. Of Toronto)

Professional Courses Taken

¨ SAP BW Academy – Data warehousing, Reporting & Analysis, Data Staging & Extraction

¨ Cognos – Series 7 Transformer OLAP Modeling, Impromptu & Powerplay

¨ Programming with Microsoft.Net Framework

¨ Oracle 9i / PL-SQL Program Units

¨ Microsoft.Net Development with C#

REFERENCES

Available on request