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 / SSRS

Ø Multi Dimensional (MDX) queries

Ø Proclarity / Performance Point, 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]

Ø SQL Server 2008 & below

[10 years]

Technologies

Ø Data Warehousing, OLAP Modeling, Cube design

Ø Data Modeling

Ø ASP.NET [3 years]

Ø ADO.NET [3 years]

Ø Object Oriented Programming / Analysis

Languages / RAD Tools

Ø VB.NET [4 years]

Ø VB Script [3 years]

Ø Transact SQL [10 years]

Ø Powerbuilder 8.02 & below [6 years]

Ø PL-SQL [5 years]

Ø C# [1 year]

Ø Visual Basic 6.0 [2 years]

Ø Java Script [1 year]

Operating Systems

Ø Windows 7 /Vista /XP

Ø 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

Nov 2008 – Present Shea Consulting (Microsoft partner offering BI services)

Technical Environment: MSOLAP (SSAS), ETL (SSIS), Analytical Reporting: Proclarity / Performance Point / SSRS, SQL Server 2005 / 2008, MDX Queries, Performance Point Planning, SharePoint (MOSS)

¨ Provided consulting services to various of Shea’s clients such as:

o Architect and design data warehouse, process of extraction from various source systems.

o Designing cubes such as Sales, Finance, Operations, Inventory Management, Policy Tracking & Medical requirements.

o Deliver visual reporting techniques i.e. Performance Point scorecards and graphical analytical OLAP custom reporting.

o Forecasting and Planning solutions.

Dec 2006 – Oct 2008 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 & analytical reporting 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.

¨ 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

Aug 1994 – Dec 1998 Various Companies

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

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.

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.

Midland Walwyn (Merrill Lynch)

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

BICC Phillips Limited

¨ Analysis / development of the Inventory Management System / Cost Revision System used by the Finance group for monthly pricing of parts and products as well as reporting for management of inventory

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 United Cigar Stores / 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 / Microsoft.Net Development with C#

¨ Oracle 9i / PL-SQL Program Units

REFERENCES

Available on request