SUMMARY:

• Over 14+ years of IT Experience with well acquainted in performing as Microstrategy Developer/Architect using Microstrategy tool Suite with Strong Domain Knowledge of Financial, Insurance, Power sector and Telecom.
• MicroStrategy CPD Certified.
• Over 8 year’s professional experience in Full life cycle development gathering requirements, documentation, participating in design, development, testing and deploying BI solutions using MicroStrategy.
• Comprehensive working Knowledge with Microstrategy Developer, Microstrategy Architect, Microstrategy Web, Microstrategy Enterprise Manager and OLAP Services.
• In - depth understanding of fundamental Data-Warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Datamarts, FACT and Dimensional tables, Logical and Physical data modeling.
• Experience in creating Schema Objects (Facts, Attributes, Hierarchies, and Transformations) to develop User Objects.
• Experience in Developing Application Objects (Filters, Prompts, Advanced Metrics, Custom Groups, Consolidations, Drill Maps and Templates) to develop Reports and Documents.
• Experience in creating Documents, Dashboards (Widgets) and Visual insights.
• Created Transformation reports using year-to-date, Month- to-date, Quarter-to-date etc
• Experience in developing reports by using Freeform SQL Queries and Logical Views in MicroStrategy Desktop/Developer .
• Experience in using the Object Manager to move the objects from Development to Production Environment in MicroStrategy
• Extensively worked on delivering reports and business intelligence solutions on the web using Microstrategy Distribution Services.
• Experience in handling various Relational Databases like Oracle, Teradata and SQL Server.
• Strong SQL Skills related to information retrieval and analysis, ability to understand and write SQL using Stored Procedures, Joins, Views, Triggers and Indexing strategies
• Knowledge in Optimization of Data Migration, ETL Processes.
• Actively involved with end users and stake holders in gathering business requirements.
• Trained Business users on MicroStrategy self service Reporting
• Experience in MSTR Interactive Dashboards (which can be a powerful tool for reporting, analysis and even forecasting) and mobiles. The MicroStrategy platform for mobile apps enables organizations to build a wide variety of essential mobile apps that deliver business intelligence, transactions, and multimedia content.
• Expert in Smoke, Functional, Regression and user acceptance Testing.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Excellent Communication, Interpersonal, Analytical skills and Strong ability to perform as Part of the team.

TECHNICAL SKILLS:

BI Reporting Tools: MicroStrategy 8.x/9.x (MicroStrategy Desktop, MicroStrategy Web, Intelligence Server, Distribution Services, OLAP Services, Command Manager)

Databases: Oracle 11g, 10g, Teradata, MS Access, SQL Server.

Client server Tools: SQL, PL/SQL, MS Word, MS Excel

Programming Languages: Java

Operating System: WINDOWS 98/NT/2000, Windows XP, Windows 7, Solaris

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey, CITI

MicroStrategy Architect/Lead

Responsibilities:

• Interacted with Business Users in gathering Requirements.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverable s (reports, dashboards, alerts, visualizations).
• Responsible for gathering requirements and designing the semantic layer for MicroStrategy Reporting.
• Worked on Designing Dashboards for Adjustments, General Financial reports like General Ledger, Balance Sheet, reconciliation trend report, Price verification of different financial products received from Product Processors.
• Extensively worked with MicroStrategy desktop in creating attributes, facts, metrics, hierarchies, transformations, hierarchies, custom groups, prompts to be used in generating reports according to the needs of business.
• Involved in creating Intelligent Cubes for the project.
• Used Enterprise Manager to generate reports for Objects Analysis,Usage Analysis etc.
• Provided Command Manager Scripts as a part of MSTR Package Deployment for Cube Refresh and other activities as required after Package Deployment as a part of the Release.
• Involved in Migrations of MicroStartegy Objects Using Object Manager.
• Designed Critical Dashboards for MicroStartegy Mobile.
• Created several Custom tables, Views, and Aggregations for developing reports used in MicroStrategy environment.
• Involved in Creating PL/SQL procedures for data preparation for reports.
• Mentoring and managing team of developers on site and Offshore .

Environment: MicroStrategy Developer 9.4.1, Intelligence server, Microstrategy Web, Object Manager, Enterprise Manager,Oracle 11g

Confidential, Syracuse, New York

BI Architect/Lead

Responsibilities:

• Interacted with Business Users in gathering Requirements.
• Extensively involved in data modeling to create attribute relationships.
• Studied and modified the attributes, facts and hierarchies based on the requirements.
• Designed and customized the reports in development and production to supply the business with improved flexibility and functionality.
• Created complex metrics with different level dimensionality, condition and transformations for user and business specific reporting needs.
• Used Administrator tools like object Manager to move the objects from one environment to another environment.
• Worked with Microstrategy Enterprise Manager Tool for generation list of regular and Adhoc reports, Users etc.
• Created Report Services Documents, Dashboards and Visual insights out of existing datasets.
• Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drilldown to claim (lowest) level.
• Created Dynamic Dashboards showing Company's performance using various graphs and widgets
• Supported various testing phases like Performance Testing and UAT
• Created Ad-hoc reports by gathering specific requirements from the different users and enabled end-users to generate their own reports.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties.
• Migration of Reports from Business Objects to Microstrategy.

Environment: MicroStrategy Desktop 9.3.1/9.4.1, Intelligence server, Microstrategy Web, Narrowcast Server, Object Manager, Oracle 10g

Confidential, LasVegas, Naveda

Microstrategy Lead

Responsibilities:

• Review of the deliverables for project N V Energy which is a part of the Energy Group.
• Business and technical consulting i.e., support for queries on MicroStrategy and BI application
• Lead a Team of 12 Developers by giving them Technical inputs/expertise for various sub-projects in NV-Energy Group.
• Requirements based solutions designing of MicroStrategy reports related to Phase 2 and developing the same.
• Understanding business requirements and converting them into technical specification and design document.
• Support for power user reporting as required by business.
• System integration i.e., support in completing activities which includes EWAM BI related changes.
• Coordination with business units for requirements,solutions, testing and training.
• Contribution towards solution and technical design.
• Setting up of system according to the MicroStrategy Architecture.
• Design the Schema Layer and Schema Objects for MicroStrategy.
• Responsible for Delivery of Public Object (Prompts, Filters, RSD's, Reports).
• Performance Tuning of MSTR Reports.

Environment: MicroStrategy9.2.1 (Administrator, Architect, Desktop, Intelligence server, Object Manager, Web) Windows 7, Oracle 10g and Solaris 11.

Confidential, Bothell, Washington

BI Lead

Responsibilities:

• Worked at the client site at AT&T Seattle center to perform customer requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations.
• Extensively created filters, facts, Consolidations, Transformations and Custom Groups using MicroStrategy Desktop to generate reports for the Business analysis.
• Used pass-through functions (applysimple and applycomp) in attributes and filters definitions.
• Created MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.
• Extensively worked in creating and integrating MicroStrategy Reports and objects (Attributes, Filters, Metrics, Facts, Prompts and Consolidation & Custom Groups) with the data warehouse.
• Extensively worked with MicroStrategy Desktop including MicroStrategy Architect and MicroStrategy Web. Attended to Troubleshooting of MicroStrategy prompt, Filter & Template objects in an enterprise data warehouse team environment.
• Developed Flash Dashboards using Widgets and Selectors for summary level reporting.
• Involved in Development of PL/SQL packages & objects in System X OLTP Database to push the data to System X Reporting Staging Environment.
• Query tuning and Database Health check Reports for System X and X datawarehouse for primary analysis.
• Responsible for providing Data to X Datawarehouse for Reporting purposes.
• Preparation of Release wise Development and Test Databases for X Datawarehouse.
• Involved in Schema and Table Design.
• Implementation and Post production support of System X Reporting project.

Environment: MicroStrategy 8.0.2/9.0.1 (Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) Oracle10g, Informatica.

Confidential

Oracle PL/SQL lead developer

Responsibilities:

• Lead a team of 3 developers and provided estimate for the tasks.
• Designed and developed PL/SQL scripts for broadband and various other application modules.
• Troubleshooted, fixed, and implemented bug fixes and enhancements.
• Design, Develop, debug and unit test PL/SQL Scripts as per the requirements.
• Developed Advanced PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.

Environment: PL/SQL, Oracle 8i/9i, Designer 2000, Unix Env, B.O 5.x

Confidential

Sr Oracle Developer

Responsibilities:

• Involved in design and development of route factoring modules using PL/SQL.
• Unit Testing for PL/SQL scripts.
• Performance tuning of PL/SQL scripts and database used by the application.
• Created the transformations for Abinitio graphs.

Environment: PL/SQL, Oracle 8i/9i, Unix Env, Abinitio

Confidential

• Understand the Business Requirements.
• Analysing and Functionality Tuning wherever required.
• Preparing User Acceptance Test Cases covering the requirements.
• Deployment of Product at Corporate office and Plants of NTPC.
• Modifying various existing D2K Reports.
• Fine tuning ofD2K Reports
• Leading a group of Trainee Software Engineers who were given the task of basically designing the Forms.

Environment: Oracle 8i, PL/SQL Programming, D2K Forms & Reports