Summary

• Certified Microstrategy Professional with extensive experience in managing Business Intelligence and Enterprise Data Warehouse implementations.
• Involved in managing Informatica to DataStage ETL Conversion, Microstrategy upgrade from 8.1.1. To 9.1M and Oracle upgrade from 10g to 11g Grid.
• Designed complex and user interactive dashboards in Microstrategy.
• Worked extensively on customizing and optimizing the query performance of reports for various users with MicroStrategy features like VLDB property, I Server settings and changing database properties like adding indexes, creating aggregate tables and partition strategies.
• Optimized ETL Load to cut down time for loading 105 Million records from 90 hours to 31 Hours.
• Involved in MicroStrategy Intelligence Server performance monitoring, creating log files and managing cache expiry times.
• Experienced in migrating Microstrategy objects between various environments using Object Manager.
• Well versed in Strategic Planning, Scope, Management Rollout, Process Improvements, Dynamic Team Building Leadership, Scheduling Tasks and Milestones, Resource, Capacity and Budget Management, SDLC Expertise, Extensive Systems Analysis Design, Quality Assurance CMMI/ISO Risk Planning, Vendor Management.
• Knowledge of Big Data implementation using Hadoop technology which includes HDFS and tools like Hive, HBase, Sqoop, Flume

Confidential

• SharePoint Administration
• SharePoint Introduction, Learning Tree

Confidential

• Developing Enterprise Wide ASP .Net Applications, Learning Tree
• Business Objects Reporting Workshop, Business Objects
• SQL Server and Analysis Services Hand On, Microsoft
• Project Management Professional PMP , PMI

Confidential

Affiliations

• Project Management Institute PMI
• Project Management Institute Washington DC Chapter PMIWDC

Technical Skills

• Project Management Tools: MS Project
• Portal: SharePoint MOSS 2007, WSS 3.0
• Business Intelligence: MicroStrategy, Business Objects, MS Analysis Services SSAS , ProClarity, MS Reporting Services SSRS , Crystal Reports
• Data Model: ERWIN, Visio, E/R Studio
• Database: Hadoop, SQL Server, Oracle, Informix
• ETL: IBM Data Stage, Informatica, SQL Server Integration Services SSIS , SQL Server DTS
• Language: Visual Basic .Net, ASP .Net, C , JAVA, VBA,PHP, Perl, C, Shell Script, Oracle PRO C
• SQL: T-SQL, Oracle PL/SQL, Oracle SQL PLUS, Oracle PRO C
• Web: HTML, XML
• Version Control: Visual Source Safe, UNIX SCCS, IBM ClearQuest
• Quality Assurance: SOX, CMM Level 1-5, ISO 9000, A123, and C A
• Others: Crystal Reports, Oracle SQL Loader, IBM Rational Suite, Tivoli, Autosys, My Eureka Metadata Manager, TOAD

Professional Experience

Confidential

• Manage Microstrategy reports and dashboards for Disaster Recovery Grants Reporting System DRGR . The objective of this data mart is to report on various grants given by the agency to various authorities to assist with the housing and disaster rehabilitation schemes.
• Design complex flash based interactive dashboards and documents in Microstrategy.
• Design Oracle ETL jobs to extract data into OLAP system for reporting.
• Design data model for the OLAP reporting database.
• Customized various VLDB properties and I Server settings.
• Gathered and analyzed business requirements from clients and end users.
• Currently, working towards migrating the Microstrategy projects to version 9.3
• Also, currently working towards proof of concept for Microstrategy Mobile.
• Troubleshoot Microstrategy schema issues related to data model and relationships.
• Designed schema objects like attributes, facts, hierarchies etc.
• Made use of metrics, filters, prompts, consolidations and custom groups to generate user defined and ad hoc reports.
• Support testing of the Microstrategy objects and the ETL jobs.
• Participated in UAT testing.

Environment: MS Project, MS Visio, Microstrategy 9.0.2 Suite, Oracle 11g, Informatica, UNIX/LINUX Shell Script, Toad, MS Office

Confidential

Microstrategy SME

• Managed Microstrategy reports and dashboards for Customer Data Mart CDM development project for United States Postal Service USPS . The objective of this data mart is to capture customer related information from various sources in USPS and monitor customer relationship. This includes prospects, revenue, discrepancy between systems on customer id etc. The goal is to use this data to focus on initiatives that involve customer marketing, sales and service, and to track their activity across multiple service channels.
• Design complex SQL queries to fix data quality issues with the customer data. This is needed to ensure that the materialized view for the customer has an integrated view of all customers being fed to CDM on daily basis.
• Proposed solution to implement in memory OLAP cubes concepts in the data mart using Microstrategy.
• Support Project Management with SDLC, EVM, WBS, Risk, Schedule and Time Management for the contract. Also, review and support draft of various deliverables which include requirements, design, system testing, training, O M manual, configuration documents.
• Design data mart architecture to make to scalable to address growing volume of customers and revenue. This requires support of a scalable system to address user's reporting needs.
• Gathered and analyzed business requirements from clients and end users.
• Worked closely with data modeling and ETL teams to develop the logical and physical data model, which has both Type 1 and Type 2 dimensions.
• Designed data quality Database to monitor the ETL load time, track ETL job status and data quality issues which includes data volume processed, rejection of data and source file statistics. Microstrategy reports were developed on top of this to provide analytics for the data quality.
• Apply Oracle analytical functions to optimize complex calculations.
• Conduct weekly status meetings which discusses accomplishments, issues, risks, load status, help desk tickets, enterprise change requests and upcoming tasks.
• Developed Microstrategy reports, scorecards and dashboards. This includes customer portfolio and data quality dashboard.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Created transformations for time-series analyses and prompts in customer tuned reports.
• Created transformations for using in comparative reports like customer portfolio this year to last year.
• Worked extensively on customizing and optimizing the query performance of reports for various users with MicroStrategy features like VLDB property, I server settings and changing database properties like adding indexes, creating aggregate tables and partition strategies.
• Unit testing the Microstrategy objects and participate in test cases design and system testing.
• Executed full SDLC for the data mart project.
• Participated in unit, system and UAT testing.

Environment: MS Project, MS Visio, Microstrategy 9.0.2 Suite, Oracle 11g, Informatica, UNIX/LINUX Shell Script, Toad, MS Office

Confidential

Microstrategy SME

• Involved in managing BI/EDW components for an Aid Data Mart ADM development project for U.S. Department of Education ED office of Federal Student Aid FSA .
• Reviewed Microstrategy, DataStage ETL and Oracle Architecture SQL as well for tuning and optimal performance.
• Developed Microstrategy Reports, Microstrategy office Reports, Scorecards, Dashboards, Intelligent Cubes, Distribution Services jobs, Data Stage ETL Jobs, Oracle Objects, and AIX/LINUX UNIX Shell Scripts.
• Gathered and analyzed business requirements from clients and end users.
• Worked closely with data modeling and ETL teams to develop the data model using E/R Studio, which has both Type 1 and Type 2 dimensions.
• Developed the logical and physical data models, created data definition language statements and worked with database administrators to transition these models to database administrators for successful physical implementation.
• Created Projects from scratch and administered all the projects.
• Implemented security at the project level and report level.
• Manage user's security with in Desktop.
• Train stakeholders on Microstrategy which includes administrative tasks, architecture, desktop designer skills and web.
• Designed Audit Database to monitor the ETL load time, track ETL job status, Microstrategy Report Usage and data quality issues which includes data volume processed, rejection of data and source file statistics. MSTR reports were developed on top of this to provide analytics for the Data quality.
• Monitor report Usage using Enterprise Manager Reports.
• Execute custom Microstrategy scripts in Command Manager and sue Object Manager for migrating Microstrategy objects.
• Draft Monthly Metrics Report for the FSA which includes performance metrics for the Data Mart.
• Conduct weekly status meetings which discusses accomplishments, issues, risks, load status, help desk tickets, enterprise change requests and upcoming tasks.
• Participate in capacity planning, disaster recovery, data center and infrastructure meeting to represent ADM.
• Developed Student Loan Portfolio dashboard, Audit dashboard and Borrower/Student analysis reports.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Designed OLAP Cubes to optimize the reports and reduce time to generate reports.
• Applied OLAP and statistical functions for analyzing the differences in the revenue generated by a particular segment of customers.
• Created Transformations for time-series analyses and Prompts in customer tuned reports.
• Provided technical support and training for user groups.
• Created Transformations for using in comparative reports like loan portfolio this year to last year.
• Used MicroStrategy report services to create reports.
• Worked extensively on customizing and optimizing the query performance of reports for various users with MicroStrategy features like VLDB property, I Server settings and changing database properties like adding indexes, creating aggregate tables and partition strategies.
• Optimized ETL Load to cut down time for loading 105 Million records from 90 hours to 31 Hours.
• Unit testing the Microstrategy objects and participate in test cases design and system testing.
• Reviewed and approved Design for the Data Model, Oracle, DataStage and Microstrategy.
• Conduct Weekly Status Meetings with the client.
• Interacted with the executive team to provide briefing on the project status.
• Managed Informatica to DataStage ETL Conversion, Microstrategy upgrade from 8.1.1. To 9.1M and Oracle upgrade from 10g to 11g Grid.

Environment: MS Project, MS Visio, E/R Studio, Microstrategy 9.2.1 Suite, Oracle 11g, IBM Data Stage 8.7, DB2, Informatica, UNIX/LINUX Shell Script, Toad, Rational Suite, MS Office, Tivoli, Autosys

Confidential

BI Lead

• Involved in managing Portal and BI Dashboard solutions for Analytics and Marketing Services in the company. The project included developing and maintaining CRM Portal BI solution for HP Resellers and supporting Partner Capacity and Campaign Planning for Microsoft Corporation.
• Managed design of Portal Business Intelligence solutions and Data Warehouse for HP and Microsoft to drive Marketing Campaign.
• Organized and scheduled meeting with SME to capture Business Process information and reflect them in Business Process Model and Use Cases.
• Facilitated and Led Multiple JAD sessions.
• Managed team of DBA, Data Modeler, Requirements Analysts, Developers, and Testers.
• Used agile process methodologies to perform requirements gathering and documentation to ensure a positive experience for all clients.
• Provide technical and analytical guidance to project team.
• Developed SSRS and ProClarity Reports, SSAS Cubes, SSIS ETL Jobs/Packages and SQL Server Objects.
• Designed and managed SharePoint Portals, ProClarity reports and Business Intelligence Dashboards.
• Optimized, tuned and administered Data Warehouse including SSRS Reports, SSAS Cubes, SSIS ETL and SQL Server Database.
• Coordinate with teams working remotely from various locations on tracking project and deliverables.
• Manage migration of SharePoint WSS to MOSS.
• Version Control and Code Migration was achieved using SharePoint.

Environment: MS Project, MS Visio, ProClarity, SharePoint MOSS 2007, WSS 3, SQL Server 2005/2008, MS Integration Services SSIS , MS Analysis Services SSAS , MS Reporting Services SSRS , MDX, T-SQL, Visual Basic .NET, XML, HTML, MS Office

Confidential

BI/EDW Lead

• Designed ETL and reports to extract Human Resources data into Data Warehouse. Reports were designed to display information related to Employee Salary, Bonus, Stocks, Benefits, Hires, Departures, Transfers and Attrition.
• Implemented comprehensive reporting system for Microstrategy University, which provides accurate information on latest Invoicing, Classes taken, Customer Contract balance and Class Schedule
• Lead offshore teams working remotely from Poland and China on completing deliverables within schedule.
• Conducted requirement gathering JAD sessions with users.
• Architected and designed the Data Warehouse and Data Stage ETL from ground up to store Enterprise Data.
• Designed Data Model using ERWIN, Data Stage ETL Jobs and Microstrategy Schema objects.
• Optimization and Fine Tuning of Microstrategy, Data Stage and SQL Server objects.
• Resolved Attribute and Metric setup issues that resulted in cross joins, ignored filters, joining to wrong tables and subsequently, wrong results coming from database.
• Developed Microstrategy Reports, Dashboards, Scorecards and Narrowcast jobs.
• Architected the design of User Security model for accessing reports in Microstrategy.
• Built Logical Views in MicroStrategy to combine warehouse tables at runtime during report execution.
• Migrated existing projects from version 7.2.1 to 8.0 and conducted extensive recursion tests.
• Created transformations table based, formula based for use in comparative reports such as store brand sales this year to last year year to date and month to date to monitor trends. Created advanced filters, advanced prompts, advanced report designs and drill maps.
• Used Toad extensively to test and debug MicroStrategy reports as well as the accuracy and consistency of Informatica jobs.
• Re-structured the existing reports by creating new and modifying existing Metrics with new set of filters.
• Actively involved in performing Metadata backups, Job scheduling, applying Project specific and server specific VLDB settings, Cache management, Managing User a/c, Licensing, Creating and applying Security roles, and running large Datamart reports.
• Creating the MSTR Schema objects, application objects and configuration objects.
• Monitored Microstrategy report usage by Enterprise Manager.
• Migrated Microstrategy objects between various environments using Object Manager.
• Conducted weekly status meetings to update stakeholders on the project status and plan for future enhancements.
• Executed various scripts using Command Manager for maintenance of users and their roles, updating object descriptions and other adhoc tasks.
• Modify the existing Attribute forms, Fact definitions to better support the changing business needs.
• Re-structured the existing reports by creating new and modifying existing Metrics with new set of filters.
• Embed hand-crafted SQL statements directly into the MicroStrategy BI platform using The Freeform SQL editor
• Define reusable run-time prompts as report input parameters to control scope of reporting analysis.
• Used Project documentation feature, Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference.
• Involved in MicroStrategy Intelligence Server performance monitoring, creating log files and managing cache expiry times
• Scheduled reports through the MicroStrategy Narrowcast server and created services to deliver a wide range of personalized information to users through email.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts.

Environment: MS Project, ERWIN, MicroStrategy 8.1.2, SQL Server 2005, IBM Data Stage, T-SQL, XML, HTML, MS Office, JDE Financials

Confidential

BI Consultant/Lead Analyst

• Executed all phases of SDLC for designing Enterprise Data Warehouse for the company. Designed Sales Labor Data warehouse from ground up.
• Developed understanding of data flow in PeopleSoft Finance/HR and Micros POS to extract data into the Data Warehouse.
• Prepared and maintained project schedules and monitors progress to achieve on time deliverables, and submitted status reports.
• Worked closely with clients in various part of country through live meetings and teleconference calls to get requirements and support business.
• Involved in proof of concept and selecting BI tool vendor for the company.
• Established and maintained communications with the stakeholders on project issues and concerns.
• Maintained communications with in-house staff regarding from project inception to project go-live and through the transition to customer support.
• Worked with business leaders to assure project goals and execution are in alignment with business goals.
• Contributed to product definition, release planning, system, data and application architecture decisions.
• Defined milestones and deliverables and communicated project progress and issues to project sponsors.
• Proposed and designed New Weekly Profit and Loss Forecast application to automate the process which required huge manual effort for 5-6 days.
• Worked as Lead Analyst performing Business Process Analysis and created Use Cases.
• Lead JAD sessions with Business Stake holders.
• Managed implementation of Business Objects Architecture in the company.
• Designed Data Warehouse, Data Model, MS SSAS Data Cubes, MS DTS tasks, Unix Shell Scripts, BO Reports/Universe, Broadcast agent Jobs.
• Administration and Optimization of Data Warehouse including BO/SSAS Cube Reports, MS DTS ETL and SQL Server Database.
• Used WBS to manage the project schedule and periodically assess the Risks.
• Responsible for client-specific training and general functionality of software system.

Environment: MS Project, MS Visio, Business Objects, Crystal Reports, SQL Server 2000, MS DTS, MS Analysis Services, MDX, T-SQL, Oracle, TOAD, Perl, Informix, UNIX Shell Scripting, Visual Basic .NET, HTML, MS Office, PeopleSoft Financials and HR, Micros POS

Confidential

Consultant

• Developed web pages in PHP to generate reports from Data Warehouse on web.
• Developed stored procedures and maintained metadata file for Warehouse using My Eureka Metadata Manager.

Environment: PHP, Informix, SQL, My Eureka Metadata Manager, MS Office

Confidential

Consultant

• Managed the whole project including getting Requirements, Designing and Implementing the interface to automate the process of conducting surveys over phone by bureau users.
• Conducted Milestone Meetings to brief Executives on the progress of the project.
• Designed interface in Visual Basic and reports in Crystal Reports

Environment: MS Project, MS Visio, Visual Basic 6.0, SQL Server 2000, Crystal Reports, T-SQL, MS Office

Confidential

System Architect

Environment: MS Project, MS Visio, Oracle Financials, Oracle Designer, PL/SQL, SQL, SQL PLUS, Oracle, UNIX Shell Scripting, Visual Basic, Pro C, MS Office, Crystal Reports, Visual Source Safe, UNIX SCCS

Confidential

Pacific Gas Electric

Microstrategy SME

• Involved in converting Microstrategy reports in version 8.1.2 and 7.5 to Business Objects Crystal Reports to support campaign by SAP to convert multiple BI reports in an organization to Business Objects and saving licensing costs for the organization.
• Reviewed and approved design for the Business Objects Universe/Reports.
• Drafted requirements document to convert Microstrategy specification into document for conversion.
• Acted as SME for translating requirements from Microstrategy reports for BO conversion.
• Worked with the Design team to review and facilitate Optimization, Tuning and Administration strategy for the BO reports.
• Worked with BO developers to test out the converted reports and ensure functionality of the new reports with the existing version.
• Conducted Daily Status Meetings with the PG E executive team.
• Mentored and managed 6 employees including Report Developers.
• Provided technical guidance to project team.

Environment: MS Project, Microstrategy 8.1.2/7.5, Business Objects XI, MS SQL Server, Toad, MS Office