SUMMARY:

• Over 14 years of IT Consulting experience across various domains including Finance, Retail/Professional Services, Pharmaceuticals, Specialty Materials, Manufacturing
• 10+ years in architect, design, develop, implement and manage Business Intelligence and Data Warehousing Solutions
• Expertise in Microsoft SQL Server and Oracle BI Technologies, and hands - on in various other leading BI tools like Cognos, Microstrategy, Business Objects, SAS
• Expert in architecting BI solutions for Dashboards, Scorecards, Complex ad-hoc reports, analytical cubes and Web-based solutions
• Experienced in designing Extract, Transform & Load (ETL) and data modeling solutions
• Worked on submitting proposals and reviewing proposal responses (RFP), evaluating and selecting BI tools, pre-sales activities
• Active team player with excellent inter personal skills, management skills, highly motivated and focused in meeting deadlines

TECHNICAL SKILLS:

BI / OLAP: Microsoft BI 2000/2005/2008 (SQL Server Reporting Services, SQL Server Analysis Services, MDX), Microsoft SharePoint 2007, OBIEE 10g / Discoverer, Oracle Web Logic Server / Portal 10g, Cognos 8 BI Reports, Microstrategy 8, Business Objects 6.0/XI, Crystal Reports 4.5, Dundas Charts 1.1, Office Writer 3.8, JReports, Data Reports, SAS 9.2

ETL: Microsoft BI 2000/2005 (SQL Server Integration Services, DTS), SQL * Loader, Oracle Warehouse Builder 10g, Ab Initio 2.15

Databases: Oracle 7.3/8/8i/9i/10g, SQL Server 6.5/2000/2005, Teradata 13, MySQL 4.0, MS Access, SAS 9.2

Languages: SQL, PL/SQL, Visual Basic 5/6, VBA, UNIX Shell Scripts

Web Technologies: ASP.net, VB.net, C#, XML, XHTML, Java Script, JQuery, VB Script, Web Services, COM+, IIS, MTS

Other Tools: Erwin, Visio, Toad, MS Project, SAS Enterprise Guide

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

BI Architect / Tech Lead

Responsibilities:

• Responsible for Architect, Design, Implement and Manage BI Solution for Credit Risk Management Applications
• Coordinated in selection of commercial-off-the-self (COTS) product for Mortgage Loan Loss Forecasting (LLF) Application to save more than $1.9M/yr, reviewed proposal (RFP) response from vendors, and evaluated for enterprise standards with technical groups
• Lead the implementation of BI solution for LLF Application with Ermas Risk Framework / Model Manager in UNIX, SAS and Web Logic Portal environment
• Configured and administered Web Logic Portal
• Lead the development and implementation of data integration & ETL for Crew Activity Response System (CARS) & Counterparty Credit Risk Management (CPCRM) applications with Mortgage Data Warehouse (MDW)
• Worked with Data Distribution Environment (DDE) team to build comprehensive ETL process using AbInitio for data transfer
• Coordinated on registering Configuration Items (CI) and Ab Initio Enterprise Meta Environment (EME) projects
• Designed solution in getting data from CARS database into BI Innovation Space to build analytics and reports using Business Objects Universe & Reports
• Involved in Lean Six Sigma activities for improving Hierarchy Request Management process in Hyperion DRM

Environment: HP-UNIX/Superdome, SAS 9.2, SAS/SHARE, SAS Enterprise Guide 4.5, Teradata 13, Linux, Oracle WebLogic Server 11g, Oracle WebLogic Portal 11g, Oracle 10g, OBIEE, SQL Server 2005/2008, Ab Initio 2.15, Business Objects XI R2, Hyperion DRM

Confidential

BI Data Analyst

Responsibilities:

• Responsible for requirement Analysis on xBand and xPass Management Systems for Next Gen Experience System
• Performed analysis on data model, ETL and BI reporting requirements
• Prepared Joint Interface Agreement (JIA) documents for ETL and BI development teams
• Designed data models using Embarcadero modeling tool

Environment: Oracle 9i, Teradata 11, Informatica Power Center 8.1, Business Objects XI

Confidential, NJ

BI Application Architect

Responsibilities:

• Responsible for designing and developing BI application (Vital Signs PLUS) to deliver vital reports and information to field users from IMS Database and other sales DW
• Performed GAP analysis on existing application and current business needs
• Coordination with business end users and development team to compile necessary sales related information to help field users

Environment: Oracle 9i, Cognos 8 BI, HTA, XML, CSS, Java Script, JQuery, VBA Macros

Confidential, Philadelphia, PA

BI/DW Consultant

Responsibilities:

• Responsible to architect, design and develop Business Reporting BI Framework - Unified Financial Reporting (UFR) to deliver consolidated financial reports for various function groups across the organization using Microsoft SQL Server BI environment
• Coordinated Joint Application Development (JAD) sessions and analyze requirements
• Designed and developed complex financial reports using SQL Server Reporting Reports (SSRS) 2000/2005, Dundas Charts, Office Writer, Web Services, XML, Java Script, Oracle, PL/SQL, and integrated for delivery in Microsoft Sharepoint portal
• Designed logical & physical dimensional data models, analytical cubes with MDX and ETL programs for Finance and Payroll Datamarts within Enterprise Data Warehouse (EDW)
• Performance Tuning of PL/SQL Procedures & Stabilization of System
• Designed and implemented Single Sign On gateway using Authentication Process between Aramark and third party servers with ASP.net and XMLHTTP Component
• Involved in impact and GAP analysis on financial consolidation reporting needs
• Performed Data Integration, Data Cleansing on legacy systems integration into UFR
• Designed and implemented for electronic Signoff solution on Payroll registers which is focussed on “Go Green” initiative
• Developed Taxonomy search application using Ektron.net framework for Content Management System
• Participated in future BI tool selection process and evaluated various BI tools like Cognos 8 BI, Microstrategy 8, OBIEE 10g to suit organizational needs and standards
• Designed various prototype reports using Cognos 8 BI for future migration process
• Assisted in submitting proposals and pre-sales activities

Environment: Microsoft SQL Server BI 2000/2005 (SSRS, SSAS, SSIS), Dundas Charts 1.1, Office Writer 3.8, Microsoft Sharepoint 2007, Oracle BI (Oracle Warehous Builder 10g, Discoverer 10g), Web Services, XHTML, XML, CSS, Java Script, C#, Oracle 9i, PL/SQL

Confidential

BI Consultant / Team Lead

Responsibilities:

• Responsible to architect, design and develop a complete set of report management tools to deploy Sales Finance reports to the end-user community using a consolidated data repository
• Participated in JAD sessions and interacted with source system business owners to design integrated BI solution to deliver reports across multiple source systems like Vision, Maestro, Action, Credit Decision Management, Dealer Administration System, etc
• Designed complex financial reports using Business Objects, JReports and Excel Cubes
• Designed ODS data store, analytical cubes and ETL programs using Oracle, PL/SQL
• Performance Tuning of PL/SQL Scripts & Stabilization of the system
• Database Administration and dataload monitoring
• Project and Team Management Activities - Managing project plans, Task allocation and monitoring progress, preparing weekly/quarterly status reports

Environment: Oracle 9i, PL/SQL, SQL * Loader, Unix Shell Script, Cron job, Business Objects 6.0, JReports 4.0

Confidential

Sr. Software Engineer / Team Lead

Responsibilities:

• Responsibilities include analysis, design and develop Data Warehousing and Business Intelligence solutions for data from Oracle HR, Oracle iProcurement and Supplier Corrective Action Notice (eSCAN) System
• Designed and Developed OLAP cubes and Web based reporting system for Headcount Reports using Busienss Objects Universe/Reports, Oracle, PL/SQL, ASP, XML
• Developed various interfaces between applications for data transfer using Unix Shell Scripts, PL/SQL and Cron Jobs
• Designed and developed PL/SQL Packages and functions for ETL Process
• Undergone Six Sigma Green Belt and prepared process related documentation as per GE requirements
• Involved in pre-sales activities and providing estimates for development
• Project and Team Management Activities
• Responsibilities include requirement analysis, design and development of middle level custom ERP Product for Manufacturing and Processing Industries in Client/Server environment using Oracle, SQL Server, Visual Basic
• Involved in development of various modules like Inventory, Bill of Materials, Purchase, Sales, Receiving, Financial Accounting and Costing
• Customization and Implementation of ERP solution to various clients - IFB Industries, Johnson Lifts Limited, Asian Peroxide Limited
• Handling Client feedbacks and recommendation for product improvement and fixes

Environment: Oracle 8i, SQLServer 7.0, Microsoft DTS, PL/SQL, COM+, Visual Basic 6.0, Crystal Reports 4.5

Confidential, Austin, TX 

Project Lead 

Responsibilities:

• Responsibilities include requirement analysis, design and development of User Authentication Process and Payment Gateway for Business-to-Business (B2B) and digital piracy using web technologies
• Involved in JAD sessions and designing BI / eCommerce solution
• Designed solution for implementing Authentication plugin to interact with third party systems using Java Applets, VC++

Environment: SQL Server 7.0, Microsoft DTS, IIS, COM+, Visual Basic, VC++, ASP, XML, VBScript, JavaScript, Crstal Reports 4.5