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