Professional Summary

• IT Professional with8 years of experience in various business areas like identification of business needs and determining solutions tobusiness problems, developing new systems, operations, processes and strategies, improving existing processes, presenting and implementing proposed solutions.
• Experience in Design, Development and Implementation of DW applications, with proficiency in Making Reports, Scorecards, Dashboards using MicroStrategy 9/8i/7i/7.0
• Modules and Objects Development, Enhancement and Customization in Oracle AppsEBusinessSCM SuiteR12 andOracle Sales Cloud Release 8
• Experience in many industrial sectors like Banking, Health Care, Telecom,Education and Retail.
• Experience in Implementation plan, best practices, document for achievements
• Pro - active involvement in continuous performance improvements for existing OLAP systems.
• Extensive knowledge of Logical and Physical modeling.
• Experience working with Business analysts/users to gather and documentbusiness requirements.
• Experience with all the modules ofMicroStrategy Product Suite namely Micro Strategy Intelligence Server, Micro Strategy Web, Micro Strategy, Dashboardand MicroStrategy Desktop.
• Extensively worked in Micro Strategy Reporting - Templates, Filters, Metrics, consolidations, Prompts, custom group and Data mart Reports.
• Generated reports by developing various Schema and Application objects in Micro Strategy platform.
• Developed complex Dashboard reports for the Key Performance Indicators for the top management.
• Worked on Testing domain along with certificate Tester by ISTQB License
• High-end database experience using Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008/2005, DB2, SQL, PL/SQL, SQL Plus, SQL Loader.

Software Skills

• BI Tools: Micro Strategy 9.3/9.2.1/8.1.1/8.1.0/8.0.2/7.5/7i/7x Micro Strategy Desktop, Micro Strategy Web, Micro Strategy architect, Micro Strategy administrator, Micro Strategy Intelligence Server, OBIEE 11g
• ETL Tools: Informatica 9.x/8.x
• Languages: C, C, HTML, SQL, PL/SQL, Oracle SQL Plus
• Data modeling Tools: Microsoft Visio, UML
• Databases: SQL Server 2000/2005/2008/2012, DB2, Oracle 11g/10g/9i/8i
• Products/Applications: Oracle Applications E-Business SCM Suite R12, Oracle Sales Cloud Release8

Professional Experience

Sr. BI Consultant

Project1: ECaR

confidential offers various kinds of Loans, like Home Loans, Education Loans, Credit Cards etc. TheApplication ECaR Enterprise Collection and Recovery a Datawarehouse Application keeps record of allLoans and its details for all LOB's. The Collection and the recovery agents to keep track on use itCustomer's loans, which help them in collecting and recovering the loans issued by Citi Group.

Project 2:

Confidential offers credit cards processing and distribution services for Confidential . TheApplication is for conducting the daily and weekly basis Text, Email, Letter, Dialer and Auto agent campaigns

For collections from various delinquent customers and also for loading the data into the data warehouse tables for reporting purpose

Responsibilities:

• Worked as Business Analyst, Functional consultant, Database Analyst, Technical trainer and Client side Coordinator.
• Responsible for gathering the business requirements from the Business users and documented the Specifications.
• Performance Tuning of Reports before deployment into production at various levels
• Designed and developed complex metricstypes - for very multiple reports.
• Involved indesigning the various reports' components before development for capsulated visualization for better business analysis
• Worked closely with architects in creating schema objects facts, hierarchies for better reporting
• Intensive working on SQL queries for performance optimization or complex report generation
• Developed extensible components on top of MicroStrategy in line with business priorities, e.g. standard reusable object creation templates, filters, prompts
• Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets both in flash and Interactive modes.
• Performed extensive QA on data and MicroStrategy reports. Create test plans for end to end functional testing, data validation and UI testing
• Actively leading and participating in full SDLC for BI projects in hand
• Training internal teams and client as per project needs

Environment:Micro Strategy Desktop 9.3, Micro Strategy Intelligence Server, Micro Strategy Web, Oracle R12, 11g,Oracle Sales Cloud Release 8

Confidential

Micro StrategyConsultant

Responsibilities:

• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater to their reporting needs.
• Worked with ETL-Informatica team to extract data from source systems to Target system
• Designed and developed MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Reports, Filters, Advanced Metrics and Templates
• Designed and developed Consolidations and Custom groups for the customer contact type and competitive pricing and also on different product groups customized by the business.
• Created security roles and Security Filters and assigned them to groups and users to meet the corporate requirements.
• Created Advanced Reports/Dashboards in grid/graph,flash, interactive mode
• Created Intelligent Cubes and OLAP services for better performance at reporting level
• Involved in Functional Testing and Performance Tuning of the Complex business Reports.
• Involved in Query optimizations using VLDB properties and diluting multi-pass queries
• Generated Sales, Leads, and Opportunities Reports for Banking Sales Rep Project on Oracle sales cloud to develop MicroStrategy reports
• These reports are used by the sales reps and the analysts for calculating the compensation of sales rep.
• Environment:MicroStrategy 9.2x/9/8.1.2 Desktop, Administrator, Intelligence Server, Web, SQL Server, Oracle, Informatica 9.x, Oracle Sales Cloud Release 7

Confidential

Micro Strategy Developer

Responsibilities:

• Responsible for requirement gatherings and make necessary changes to the design documents
• Created public objects Reports, Filters, Drill Maps, Metrics, Templates
• Created schema objects Attributes, Facts, Tables, Hierarchies
• Generated Grid and Graph reports
• Created compound metrics and worked with level dimensionality.
• Worked on performance tuning of reports at database and application level
• Creating report as per the dashboard requirement and placing these reports on the dashboards with necessary formatting and filters on the dashboard.
• Worked with SQL queries in creating the Logical Tables to fetch data from database.
• Involved in testing project during upgrade from MSTR 8.1.2 to MSTR 9.0.1
• Thoroughly tested the reports in V9 and also involved in bug fixes in V9.
• Compared the reports through integrity manager for the data consistency and the layouts
• Train business users on using MSTR reports.
• After completion of reports worked on validating the data as a part of unit testing.

Environment: Micro strategy 9.0.1/8.1.2 Desktop, Web, Architect, Oracle 10g/9i, SQL, Windows

Confidential

Micro Strategy BI Analyst

Responsibilities:

• Interacted with the Business Analysts and Enterprise users for solving Defects gathering requirements for existing Envision project.
• Worked with management and key users in Pepperidge Farm to help refine requirements.
• Created Tables, Table Alias, Attributes, Facts, Hierarchies Custom Subtotal Functions at the initial stage of Project.
• Created Transformations for using in comparative reports like sales this year to sales last year YTD, QTD, PTD, WTD .
• Involved in changing the existing Sales Organization Hierarchy, which is required to be modified as underlying data was reorganized.
• Developed Various Simple Metrics, Compound Metrics, Filters, Drill maps, Templates, Custom Groups, and Consolidations.
• Developed various Prompts supporting end users to interactively choose different filtering criteria.
• Assisted the team in identifying the errors in the underlying data in existing reports
• Personally created 20 reports for Pepperidge Farm around 33 Reports for Campbell's USA Canada which are assigned to various roles like Corporate, Account Manager, VP sales, President PF, DSM, Plant Financial Personal, and Procurement etc.
• Developed and Modified Existing 130 reports for Sales, Product report, Stale, Service frequency, Plant Financial. Procurement as a team.
• Created Advanced Reports in grid mode and graph mode using MicroStrategy Desktop various base metrics YTD, QTD, PTD, WTD, derived metrics for sales, make to ship, billing etc.
• All the reports metrics have been formatted as per users request like displaying attribute display forms, subtotals, sorting, etc.

Environment:Micro Strategy 8.1.1 Desktop, Web, Intelligence Server, SDK, Oracle EBS, Oracle 11

Confidential

Application Engineer

Responsibilities:

• Coordinating with clients' across the world using Oracle's E-business Supply Chain Management Package.
• Interfacing with other departments' like Purchase, Sales, Shipping and Payments, etc. for resolving the technical issues of clients'.
• Troubleshooting clients' issues and handling irate clients' provide clarification regarding various issues.
• Working closely with the Order Management Team which handles functional and technical issues related to registering a new product, report delivery, back-orders, credit check availability, insert order, modify order, etc.
• Handling challenges related to Payments, Credits, Inventory, Financials, and Investment Management.
• Exposure to Key clients: All the top companies who purchased the Order Management SCM Package from Oracle
• Enhancing the existing packages in Blanket Sales and Credit Card Payments and re-launching them in order to reduce the bug inflow and time spent by engineers to analyze the bug of the clients and instead asking them to just install the launched package with resolved issues. These strategies of mine helped in improving the business.

Environment: Oracle E-Business Suite Supply Chain Management, Oracle 11g, 10g, 9i, Windows XP,SQL, Oracle Apps BI reporting

Confidential

Oracle Developer

Responsibilities:

• Coordinating with Business Analyst of Royal Bank of Scotland for gaining business knowledge in their mortgages and securitization project for the banking services using SQL, PL/SQL, Oracle, Mainframes.
• Developing application with the technical team which provided user-friendly view of the information about the mortgages, produced reports about assets for the mortgages, and produced reports regarding financial movements with in-built totals and calculations .
• Testing the application on the local server and then further gathering of business requirements from company's person on-site
• Identifying and creating Oracle database objects Tables, Views, Synonyms, Indexes, Constraints, Procedures, Functions, Database Triggers
• Involved in back end development of Oracle PL/SQL objects for report creation.
• Worked in writing SQL Queries Sub queries and Join conditions, correlated sub queries
• Provided post production support to end-users.
• Making rigorous unit testing and keeping track of throughputs of the securisation and mortgages module

Environment: Oracle 10g, 9i, Windows XP,SQL,DB2, Mainframes