PROFESSIONAL SUMMARY:

• Self motivated professional possessing more than fourteen 14 years of full life - cycle implementation experience at corporate enterprise levels, out of which a total of eleven 11 years of core experience has been fully dedicated to deployment of Business Intelligence Applications in Enterprise Data Warehouse environments, typically in Oracle, Teradata, DB2 and MS SQL Server relational database management systems.
• Possesses a proven ability to accept challenges and deliver results in multi-tasked work environments.
• Works collaboratively with diverse implementation partners in an Enterprise-level project environment
• Wealth of experience in building Data Warehouse solutions utilizing methodologies like Star, Snowflake, & dimensional data modeling.
• Experience in Business Requirements definition, Data Analysis, Logical and Physical Data Modeling, Confidential Analysis, Data Conversion, Validation, Testing Methodologies (unit, integration, and bug tracking and fixing), Designing and Developing ETL modules, Building Operational Data Stores (ODS), Documentation, Production Migration, Post Implementation Support for various Business Intelligence Applications
• Over 3 years of experience in client/server projects in Oracle, VB, and ASP.
• Experience in domains like retail, insurance & finance.
• Expertise in Cognos Data Manager and all of its components Fact & Dimension builds, Hierarchies, Derivations, Reference Structures, Job Streams.
• Expertise in MicroStrategy and all of its components Architect, Report Services Documents, Object & Command Manager, Desktop, Web, Intelligence Server and Administration.
• Extensively used Cognos Data Manager as an ETL, MicroStrategy as reporting.
• 8 years hands-on experience working with MicroStrategy suite (Schema & Application Object development, Desktop, OLAP services, Reporting services, Dashboards, Score cards and Administration).
• Extensively worked on building complex reports and dashboards using advanced metrics, relationship filters, prompts, templates, and custom groups.
• Strong exposure to MicroStrategy Administrator & Architecture responsibilities.
• Thorough understanding and experience working with an Enterprise Data Warehouse and ETL technologies.
• Involved in gathering business requirements to build large enterprise warehouse.
• Worked with very large databases like DB2, Oracle, Teradata, SQL Server and MicroStrategy Suite.
• Solid experience in leading development team on delivering data warehouse & business intelligence solutions.
• Effective problem solver with demonstrated verbal and written communication skills.
• Industrious, extremely aggressive and efficient to adapt the new environment and had always justified in playing key role in any given team.
• Able to work with minimum supervision and have the ability to grasp technical concepts quickly.
• Experience in working with Operating Systems like Windows, Linux, and UNIX.

TECHNICAL SKILLS:

Databases: Oracle 10g/9i/8i/7x, Teradata, DB2 UDB, MS SQL Server 2005/2000

Tools: MicroStrategy 9/8.x/7.x, Data Manager 8.3 / Decision Stream 7, Informatica 5

Operating Systems: Windows 2003/2000, Unix, Linux, MS: DOS

GUI/Modules/Tools: ER: Studio, ERWin, VB 6.0, SQL Navigator, TOAD 6.x, SQL * Loader

Web Technologies: ASP / ASP.Net, IIS 4.0, JSP, Java Application Server.

Scripting Languages: VB Script, Java Script, HTML, XSL, XML, CSS

WORK EXPERIENCE:

Confidential, San Jose, CA

MicroStrategy Consultant

Tools: MicroStrategy 9.3.0, Teradata

Responsibilities:

• Responsible for interacting with the Business Users to get the requirements.
• Create MicroStrategy schema objects and public objects like attributes, facts, hierarchies, transformations, metrics, filters, prompts, custom groups, Intelligent Cubes, reports and dashboards according to the business needs.
• Dashboards developed for Confidential & Confidential management groups.
• Created distribution services to deliver reports to end user thru email.
• Migrated projects from Dev to UAT and then to the Production environment.
• Used Object Manager to deploy MicroStrategy Objects from Dev to UAT and then to the Prod.
• Written Command Manager Scripts to delete caches and refresh cubes.
• Created System Manager Workflow and added email delivery notification on success/failure of workflow.

Confidential, Foster City, CA

ETL & Reporting Consultant

Tools: Cognos Data Manager, MicroStrategy 9.2.1M, Oracle

Responsibilities:

• Responsible for interacting with the Business Users.
• Installation of the Cognos Data Manager.
• Created Fact & Dimension builds, Hierarchies, Derivations, Reference Structures.
• Implemented SCD Type 2 dimensions.
• Transformed Data Using Lookups.
• Created indexes on fact and dimension tables.
• Customize functionality with User-Defined functions and variables.
• Implemented job control using Job Streams.
• Implement the audit control methodology in order to track the success/failure of the ETL interfaces & provide exact point of failures & job restart to minimize the time for re-run.
• Export Data Manager metadata to XML to integrate with Cognos BI.
• Responsible for MicroStrategy Admin activities like User Administration (Creating / Modifying User Accounts, Security Roles, Privileges, etc..), Configuring Intelligence Server & Cache/Schedule Administration.
• Migrated microstrategy projects from Dev to UAT and then to the Production environment.
• Written microstrategy Command Manager Scripts to purge and create caches.

Confidential, Redwood Shores, CA

MicroStrategy Consultant

Tools: MicroStrategy 9.x, Oracle, Windows 2008

Responsibilities:

• Responsible for interacting with the Business Users for ad-hoc requests.
• Created Transactional service report for end users to load plan data into tables using MicroStrategy. Then created the reports/dashboards to compare the actuals vs planned.
• Created required schema objects and public objects for the enhancements.
• Create Freeform SQL reports, Intelligent Cubes and complex filters.
• Created users, security filters, provided access.
• Created distribution services & narrowcast services to deliver reports to end user thru email.
• Migrated objects to different environments using object manager.
• Perform unit testing and sanity check on the reports.

Confidential, Pleasanton, CA

MicroStrategy Consultant

Tools: MicroStrategy 9.x, DB2, Unix

Responsibilities:

• Responsible for interacting with the Business Users regarding information about the Project Deliverables, and on finalize Reporting Requirements.
• Created the Metadata & Statistic tables for the MicroStrategy projects.
• Responsible for Administration activities including User Administration (Creating/Modifying User Accounts, Security Roles, Privileges, Access controls, Managing User Sessions), Configuring Intelligence Server & Cache/Schedule Administration.
• Used MicroStrategy Object Manager to deploy the MicroStrategy Objects from the development stage to UAT and then to the Production environment.
• Handled user licenses for projects and Managed backup of Metadata.
• Used Narrowcast Server to distribute the reports to end users.
• Created static subscriptions for Delivery of reports using Narrowcast.
• Created the services, Subscriptions and Schedules and Mapping with the Reports as business required.
• Created MicroStrategy schema objects and public objects.
• Created Freeform SQL reports, Intelligent Cubes and complex filters to define conditionality in compound metrics to accommodate joins at reporting level.
• Work with widgets like Gauge, Micro Charts, and Interactive Bubble Graph.
• Build Templates for future reporting needs.
• Perform unit testing and sanity check on the reports before moving environments.
• Migration of reports and dashboards into QA, Pre Prod and Prod environments.

Confidential, San Bruno, CA

MicroStrategy Consultant

Tools: MicroStrategy 9.x, Teradata

Responsibilities:

• Developed & Implemented Confidential using MicroStrategy.
• Gathered requirements from business to build the dashboards and detail reports.
• Prepared functional and technical documents.
• Implemented MicroStrategy new concept called Multi Tab functionality to display the time slices required for the project, (ex: MTD, QTD, YTD).
• Generated various canned, ad-hoc reports and report service documents.
• Designed dashboards to present critical company data in a single report.
• Implemented the object prompts to pass attributes dynamically through the dashboards.
• Created advanced level metrics, prompts and transformations for the project.
• Created links to open up new detailed reports and passed the same prompts when clicked on it.
• Used apply functions to execute the database specific function in the metrics and filters.
• Effectively used the VLDB settings for Join types, Max rows, Query optimization etc.
• Migrated objects from Dev to QA by creating packages through object manager.

Confidential, Atlanta, GA

MicroStrategy Consultant

Tools: MicroStrategy 9.x, SQL Server, Teradata

Responsibilities:

• Developed & Implemented Enterprise Wide reporting solution using MicroStrategy.
• Created dashboards and related reports for the enterprise level application “My Numbers” called Project One.
• Gathered requirements from business to build the metrics and dashboards for the Project One application.
• Implemented ACL’S for the dashboards to restrict 23 roles within the application to control the dashboards.
• Implemented adaptive metrics concept to control the time transformation inside the metrics which can dynamically run through all the time slices required for the project, (ex: WTD, MTD, HTD, QTD, YTD).
• Implemented the MicroStrategy 9 new feature called multi-sourcing.
• Created base formulas & templates as a best practice.
• Created and used relationship filters, report as filters.
• Generated various canned, ad-hoc reports and report service documents.
• Designed dashboards & scorecards to present critical company data in a single report.
• Created complex metrics and reports to get the required result as per the business requirements.
• Created complex time filters for the trend graphs to with desired time period.
• Implemented object prompts to pass attributes dynamically through the dashboards depending on the level of the user.
• Used sections in the report services documents to create related reports and printer-friendly documents.
• Created advanced level metrics, prompts and transformations for the project.
• Created links on metrics to open up a new detailed reports when clicked on it.
• Used panels within the dashboards to show different graphs using Radio buttons.
• Used apply functions to execute the database specific function in the metrics and filters.
• Effectively used the VLDB settings for Join types, Max rows, Query optimization etc.
• Migrated objects from Dev to QA by creating packages through object manager.

Confidential, TN

ETL Lead

Tools: Cognos Data Manager, SQL Server, Teradata, DB2 UDB, ER-Studio

Responsibilities:

• Analyze & submit data feeds to Confidential for Interim Build.
• Centralize data feeds process which involved receiving brand data feeds (TMX & AHS) and manages the process for brand TG... generate the data build files, audit the files & manage the process.
• Co-ordinate between the SVM brand teams & Confidential in order to facilitate the file audits & data validations process & draw further resolutions for any issues if present;
• Build Customer centric data mart and reporting solution… relate the existing brand customer information to the CIS data by providing the brand customer roll up to the service type & Business Unit (division/region/branch) level.
• Analyze the requirements gathered from the business users.
• Design the data model to support the reporting requirements.
• Design the change data capture process for the delta file generation for TG & TMX files.
• Perform the capacity planning & provide storage specifications to the BSC DBA / Server engineering team…

Confidential, TN

ETL Architect

Tools: Cognos Data Manager 8.3, Teradata, SQL Server, DB2 UDB

Responsibilities:

• Fine tuning the existing interfaces for performance, optimize for the best time run, restructure the process flows in order to avoid any overheads of the networks, db & server bottlenecks & db performances etc. This involve closely working with the DBA & architecture team to provide the best interface design to support & improve the database & server architecture...
• Installation of the Cognos data manager on windows. Upgraded the Cognos Decision Stream 7.1 to Data Manager 8.3 & design & provide seamless migrations.
• Modification of the ETL interfaces to support the database / data migrations & production deployments. Redesign some of the ETL interfaces to overcome the limitations of the Cognos application of 32 bit memory.
• Implement the audit control methodology in order to track the success/failure of the ETL interfaces & provide exact point of failures & job restart to minimize the time for re-run.
• Work with the information / data architect to design the data partitioning strategy to improve the performance of the data mart & provide data archiving to standby server.

Confidential, TN

ETL Architect

Tools: Cognos Data Manager 8.3, Teradata, SQL Server, DB2 UDB

Responsibilities:

• Responsible for interacting with the Business Users.
• Installation of the Cognos Data Manager.
• Created Fact & Dimension builds, Hierarchies, Derivations, Reference Structures.
• Implemented SCD Type 2 dimensions.
• Transformed Data Using Lookups.
• Created indexes on fact and dimension tables.
• Customize functionality with User-Defined functions and variables.
• Implemented job control using Job Streams.
• Implement the audit control methodology in order to track the success/failure of the ETL interfaces & provide exact point of failures & job restart to minimize the time for re-run.

Confidential, CA

Architect, Report & Dashboard Developer, & Administrator

Tools: MicroStrategy 8.0.2, XML, XSL, CSS, JSP, Oracle 9i

Confidential, IL

Architect, Report & Dashboard Developer

Tools: MicroStrategy 8.0.2, Oracle 9i