SUMMARY

• 7 +years of progressive IT experience implementing Business Intelligence Solutions, leveraging expertise in Data warehousing, Data modeling, using MicroStrategy Platform.
• 6 years of strong experience using MicroStrategy Suite (Intelligence Server, Desktop, Narrowcast server, Web).
• Extensively worked in creating and integrating MicroStrategy reports and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidations, and Custom Groups).
• Extensively worked in creating MicroStrategy Schema Objects.
• Proficient in designing reports through MicroStrategy Desktop, with optimal usage of key features like Advanced Filters, Prompts, Custom Groups, and Consolidations and extensively worked on Parent - Child relation for attributes.
• Worked with Stored Procedures and Functions in SQL and also constructed complex SQL queries to troubleshoot the queries.
• Participated in the Full life Cycle Development (FLCD) of the data warehousing project; project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users.
• Extensive experience in modeling and developing logical/physical data models using entity-relationship modeling tools like ERwin. Strong understanding of basic concepts of data warehousing such as dimensional modeling, star, snowflake and Starflake schemas, Datamarts, fact and dimension tables identification.
• Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, security and scalability issues suited for SQL Server, Oracle, Teradata and DB2.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Self-motivated and enjoy working in a technically Challenging environment. Quick learner and excellent team player with ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS

Business Intelligence/OLAP/DSS Tools: MicroStrategy 9.x/8.x (MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, Microsoft SQL Server Analysis Services, Microsoft Excel.

RDBMS: MS SQL Server 2008/2005/2000 , Oracle 11g R2/10g/9i, Teradata V2 R5/V2 R4, IBM DB2 UDB, Netezza

ETL Tools: MS SQL Server Integration Services, Informatica 9.x/8.x

Data Modeling: ERwin 4.0, System Architect, Microsoft Visio 2002

Programming: C, C#, VC++, Visual Basic 6.0/5.0, SQL, T/SQL, PL/SQL, PHP, ASP, JAVA, Unix Shell Scripting

Operating Systems: Windows XP/2000/NT4.0, Windows 2000 Advanced Server, Sun Solaris 2.8/2.7/2.6, UNIX

Scheduling Tools: Control-M (BMC)

PROFESSIONAL EXPERIENCE

Confidential, Verona, NY

MicroStrategy Developer

Responsibilities:

• Implemented MicroStrategy Reporting concepts by creating attributes, facts, Attribute Relationships and Hierarchies.
• Developed Metrics, filters, prompts to achieve the functionality of consistent reports for the Web.
• Extensively worked on creating Report Service documents using multiple Grids and Graphs.
• Extensively worked on creation of Dynamic Dashboards.
• Created Dashboards with Multiple Panels, Panel Selectors and Tabs.
• Worked on Cubes and created cube based reports/dashboards.
• Involved in troubleshooting MicroStrategy reports
• Tuned the VLDB properties to enhance the performance of the reports Confidential project level and report level.

Environment: MSTR 9.4.1, Desktop, Web, oracle11g

Confidential, Middletown, NJ

SR. MicroStrategy Developer

Responsibilities:

• Coordinated directly with business users to gather the new requirements and to solve the existing issues
• Implemented MicroStrategy Reporting concepts by creating attributes, facts, Attribute Relationships and Hierarchies.
• Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
• Created various reports, Data sets and then used those for building Dash Boards and enabled flash mode as per user’s request.
• Created Subscription sets, documents, publications and services in process of configuring the Narrowcast application.
• Tuned the VLDB properties to enhance the performance of the reports Confidential report level.
• Created Dashboards in Flash mode and also created Visual Insights.
• Worked on Cubes and created cube based reports/dashboards.
• Configured Enterprise manager to collect statistical data related to different projects.
• Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.
• Used MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Created metrics, filters, prompts and templates for the reports.
• Worked on the performance tuning of the MicroStrategy reports
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties.

Environment: MSTR 9.3.1, Desktop, Web, Oracle 11g

Confidential, Milford, CT

MicroStrategy Consultant

Responsibilities:

• Created reports with various object prompts to generate various ad hoc reports.
• Created Dashboards using Flash and DHTML widgets like Time Slider, Graphs, Bubble Graph, Heat Map and so forth.
• Involved in troubleshooting MicroStrategy reports, and optimizing the SQL using the VLDB properties.
• Used MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Proactively created Report services documents and reports and delivered personalized email messages with the documents / reports from the Data warehouse through MicroStrategy Narrowcast Server.
• Implemented Narrowcast Server Services by sending Reports to users through e-mail delivery or saved the Dashboard reports as File in the secured network folders.
• Worked on setting up of Static Subscription set with email users and successfully setup various personalizations to them.
• Created transformations (table based), Attributes, metrics, facts for some new report requirement.
• Set up report level security in MicroStrategy for users.
• Created Cubes and scheduled them to run weekly bases.
• Created Visual Insights reports from Cubes.

Environment: MicroStrategy 9.2.1/9.3.1 (Desktop, Web, Mobile, visual insight, Intelligence Server), Oracle 11g, DB2.

Confidential, Pittsburgh, PA

MicroStrategy Developer/Architect

Responsibilities:

• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
• Documented all the baseline projects based on Company Standards. Created baseline standard documents which directly helped organizations baseline group to improve their quality of service and It also helped to resolve the tickets faster and efficient way.
• Worked with MicroStrategy Architect to build Attributes, Facts and Dimensions and developed perfect logical models for reporting environment.
• Extensively worked in developing Public objects including Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Created Consolidations, Custom Groups and Prompts for the reports.
• Designed report components, Templates and Filters to generate reports in grid and graph mode. Auto prompt filter to give end-user a choice of different filtering criteria each time they run the report.
• Created Security Filters to be assigned to restrict the access of the Users.
• Designed Dashboards in summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Worked on Dashboard design using different types of Datasets.
• Extensively worked on creating Report Service documents using multiple Grids and Graphs.
• Extensively worked on creation of Dynamic Dashboards.
• Created Dashboards with Multiple Panels, Panel Selectors and Tabs.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
• Co-ordinated test plans and provided feature/functionality/usage scenarios for the Managers.
• Tested report layouts, validated the SQL query, prompt orderings, export/print functionality and drilling options.

Environment: MicroStrategy 9.2.1, 9.3 Desktop, Web. Teradata

Confidential, Concord, CA

MicroStrategy Developer/Architect

Responsibilities:

• Conducted a Gap Analysis and interacted with business users extensively in gathering the requirements, and analyzed the needs of the end users.
• Analyzed business processes to identify challenges and created solutions through the use of database and communication software
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements.
• Designed Components, Templates, Filters to generate Reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Implemented Drill Down/up functionality in various reports.
• Extensively used filters, facts, Consolidations, Transformations and Custom Groups to generate reports for Business analysis.
• Created MicroStrategy Objects Metrics, Filters, Prompts, Templates, Consolidations, Transformations, and Custom Groups using MicroStrategy Desktop
• Tuned the VLDB properties to enhance the performance of the reports Confidential project level and report level.
• Responsible for Writing SQL queries and designed Freeform SQL reports in MicroStrategy.
• Created different Project Sources for different environments like production, testing and development.
• Handle the queries regarding XML and troubleshoot the complex technical XML problems.
• Involved in documenting the business process by identifying the requirements and also involved in finding the system requirements.
• Strong Knowledge in creating Reports scalable to large volumes of data and pass the stress and performance testing.
• Actively Involved in testing the MicroStrategy Objects and Reports in Different MicroStrategy Environments 9.0

Environment: MicroStrategy 9.2.1, Teradata.

Confidential, San Francisco, CA

MicroStrategy Developer

Responsibilities:

• Developed MicroStrategy Schema objects, Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including security filters, Reports (complex, Ad hoc, Parameter-driven, Personalized, indicator, Set analysis, What-if analysis, Data-mining, Data mart reports.etc.).
• Created very complex reports eg: Market-Basket Analysis involving interactive web and Window’s interface.
• Created User requirement document for realizing MicroStrategy objects to be integrated in the report.
• Created logical data models, recognize source tables and columns, to build, Attributes, Facts, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created new Facts, Attributes and attribute form expressions, Hierarchies as needed in the project.
• Create the design document; personalize the reports as per user requirements, which included customizing and formatting.
• Configure reports, Scorecards and Dashboards for end users in Desktop and MicroStrategy Web.
• Created Transformations (table based, formula based) for using in comparative reports like claims this year to last year (year to date and month to date).
• Extensively created and used Custom groups and Consolidations.
• Partnering with our business clients to understand the business analysis to be performed and subsequent required reports

Environment: MicroStrategy Desktop 9.0.1, Oracle 10g

Confidential

MicroStrategy/SQL Developer

Responsibilities:

• Analyzed the business requirements identifying the requirements reviewing and communicating with business and getting sign offs from business.
• Created the Metadata & Statistic tables for MicroStrategy projects on a SQL Server database.
• Involved in conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
• Involved in normalizing the data from source systems by identifying columns in the table, which came in as fully De-normalized flat file.
• Created system delivery specification documents Technical Specification document and test plans.
• Configured reports for end users in Desktop MicroStrategy Web and Narrowcast Server.
• Generated and implemented advanced MicroStrategy Reports concepts by creating projects attributes hierarchies facts metrics filters and templates using MicroStrategy Architect.
• Extensively used filters facts consolidations transformations and custom groups to generate reports for Business analysis.
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Involved in troubleshooting MicroStrategy prompts filters templates consolidations and custom group objects in an enterprise data warehouse team environment.
• Created Transformations (table based formula based) for using in comparative reports like sales this year to sales last year.
• Narrowcast Server has been used extensively in the various phases of Report generation namely Self-Subscription Profile Management Proactive Information Delivery and alerting Content Management and Personalization.
• Created Scoreboard Reports.
• The Projects in Project Sources were connected to the Data warehouse and Metadata Repository through a 3-Tier Architecture involving MicroStrategy Intelligence Server.

Environment: MicroStrategy 9.0.1, Oracle 10g.

Confidential

PLSQL Developer

Responsibilities:

• Studied and analyzed the business requirements.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequence, grants and synonyms.
• Wrote Stored Procedures to encapsulate Business processes
• Wrote procedures, Database Triggers, functions and package using PL/SQL,
• Formatted the reports with different fonts dynamically using SRW Package.
• Optimized the SQL queries for improved performance.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Prepared test plans for various modules.
• Design and implementation of Reports.
• Added the triggers in form level, block level and Item level.
• Prepared user manual and technical support manuals.

Environment: Oracle 8i, SQL*Loader, PL/SQL, Windows 2000