SUMMARY:

• Around 8 years of IT experience in Business Intelligence project development using MicroStrategy product suite including developer, web, mobile, administrator, object manager, enterprise manager, integrity manager, command manager and operations manager, building reports, interactive dashboards and visualization techniques.
• Expertise in building projects and creating reports using MicroStrategy product suites including MicroStrategy Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, and MicroStrategy Intelligence Server.
• Proficient in creating Schema Objects such as Attributes, Facts, Hierarchies and Transformations. Extensive experience in creation of public Objects Namely Metrics, Filters, Prompts, Custom Groups, Consolidations, Drill Maps, Search Objects, Reports and Documents.
• Expertise in MicroStrategy Reporting techniques such as Interactive Dashboards and Visualization techniques.
• Full life cycle implementation encompassing Business requirements definition, Data analysis, Data Warehousing, Logical and Physical Data Modeling, reporting, validations.
• Adequate knowledge of fundamental data warehousing concepts such as dimensional modeling, star and snow flake schemas, modeling data marts. Worked on all phases of the data warehouse development Lifecycle, from gathering requirements to design, development, testing, deployment and support.
• Very strong in MicroStrategy connectivity with various databases such as Oracle, Teradata, MS Access, SQL Server. Extensive knowledge on SQL.
• Microstrategy Certified Project Designer, Microstrategy Certified Report Developer and MySQL certified developer.
• Have strong Technical and Non - Technical communication skills, including verbal, written, analytical and interpersonal skills.

TECHNICAL SKILLS:

BI Tools: MicroStrategy Desktop/Web, Intelligence Server, Administrator, Report Services, Command Manager, Object Manager, Narrowcast Server, Tableau, Crystal Reports, Qlik

Languages:: C, C++, Python, HTML, XML

Databases:: SQL Server 2008/2012

Query Tools: SQL server management studio, SQL Developer, Netezza

Data Modeling Tools: Erwin, Toad

Microsoft Apps:: MS Word, MS Excel, MS Power Point, MS Access, MS Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Portsmouth, NH

Microstrategy Architect/Consultant

Responsibilities:

• Worked with Business Analyst/Users to understand the Business Processes and Project Design. Designed Architect Data Model using MSTR Architect.
• Involved in meetings with Business units to understand the requirements, translated them into Microstrategy design documents.
• Performed installing, configuring, and administering Microstrategy Intelligence Server, Web Server, and Mobile Server.
• Designed Dashboards summarizing key business indicators (KPI’s) by presenting them in visually intuitive, easy-to-read, interactive documents.
• Deployment of DEV, UAT and PROD environment including Microstrategy Installation & upgrade.
• Experience with ETL/data integration methodologies and patterns.
• Created and deployed Mobile/I Pad Dashboards.
• Created Interactive and Dynamic Dashboards in Flash modes for Business Users using Widgets, Panels, Panel Stacks, Selector Controls and trained Business User to best utilize the advanced features in MicroStrategy for Dashboards.
• Used advanced properties of report services like creating hyperlinks, drilling, using datasets, advanced metric calculation and so on.
• Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents Using high volume datasets. Using I-cubes improved performance of the RS documents significantly.
• Provided strategic ideas for SDLC processes from designing, development and tactical implementation of Reporting/ Data Visualization needs to capture Business insights for stakeholders.
• Used Business objects for creating crystal reports and dashboards.
• Worked on Transaction services and free form SQL editor for complex report creation.
• Used SQL Developer extensively to test and debug MicroStrategy reports as a key step in data validation.

Environment: Microstrategy 10.X,9.X (Administrator, Desktop, Architect, Web, Narrowcast Server, Object Manager, Enterprise Manager, Office, Report Services), Teradata, Windows 10 professional, SQL.

Confidential, Atlanta, GA

MicroStrategy Consultant

Responsibilities:

• Involved in generating Microstrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using Microstrategy Desktop and Architect. .
• Analyzed and gathered supply chain best practices and developed strategies Conducts day-to-day business analysis supporting the supply chain managers.
• Developed customized and Ad-hoc reports using Templates, Metrics, Filters, Prompts, Custom Groups, and Transformations.
• Developed the company performance Dashboard. Extensively worked on Report Services to create performance dashboard reporting.
• Created the Metadata & Statistic tables for MicroStrategy projects.
• Worked as a MicroStrategy developer for the users to support various reporting needs for the business. Client coordination and offshore issue resolution.
• Involved in gathering business requirements and documenting specifications.
• Performance Optimization was done to existing reports and report response time was brought down remarkably.
• Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model. Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
• Optimized query performance by updating VLDB (very large database) properties and by modifying cache behavior.
• Implemented the user defined MicroStrategy objects like custom groups and consolidations according to the requirement.
• Involved in complete Data Warehouse life cycle. Analyzed the business requirements and created system requirement specification (SRS) document to support the business needs.
• Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.

Environment: Microstrategy 9.X (Administrator, Architect, Desktop, Narrowcast Server) MicroStrategy Narrowcast server, Windows XP, MicroStrategy Dashboard

Confidential, NYC

Microstrategy Developer

Responsibilities:

• Responsibilities include designing and developing robust, user friendly applications, reports and dashboards using BI tools like Microstrategy.
• Conducting research utilizing available systems, databases, and the internet, consistent with the resolution of investigations.
• Worked closely with business to access requirements and translate them into technical requirements.
• Involved in data validation, analysis, testing and debugging.
• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Designed MicroStrategy Schema objects and Application objects using MicroStrategy Desktop.
• Extensively worked on building all the Scorecards and Dashboards using MicroStrategy Report Services.
• Closely worked with DBAs on designing the data base and in fixing performance bottlenecks.
• Resolved performance issues in existing dashboards.
• Assisted the business and IT teams in troubleshooting technical issues and provide guidance and support in the design and implementation of enhancements to the reports and dashboards.
• Visual Insight - Created analysis and added visualizations using the data from existing reports and Intelligent Cubes (I-cube).
• Microstrategy Mobile - Created Dashboards for Business Leaders, Business Managers to access on Iphone and Ipad.

Environment: Microstrategy 9X, Microstrategy Desktop, Microstrategy Report Services, Microstrategy Web, Microstrategy Intelligence Server, Microstrategy Narrowcast Server, Informatica, Oracle 9i, Oracle SQL Developer, Windows XP/2008/2000

EMD Serono Inc, Rockland, MA

Microstrategy Developer

Responsibilities:

• Designed and developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports. Designed Reports and Templates (Standard and Ad Hoc) using Complex Filters, Prompts and Compound Metrics.
• Worked with Business Analyst/Users to understand the Business Processes and Project Design. Designed Architect Data Model using MSTR Architect.
• Performed installing, configuring, and administering Microstrategy Intelligence Server, Web Server, and Mobile Server.
• Involved in Creation of Advanced Metrics like Conditional, Level, Non-Aggregation, Rank and Transformation Metrics.
• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions.
• Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary.
• Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like Apply Simple, Apply Comparison to overcome complex logic in creating objects.
• Created dashboard design using flash on different widget. Extensively used Pass-through (Apply Functions) expressions to pass special functions.
• Used Business objects for creating crystal reports and dashboards.
• Used the Microsoft windows performance monitors to supplement Administration monitors in MicroStrategy intelligence server.
• Used SQL Developer extensively to test and debug MicroStrategy reports as a key step in data validation.
• Used free form SQL editor for complex report creation.

Environment: MicroStrategy Admin/Desktop/Web 9.X, Visual Insight, Teradata, DataStage, MS Office, Tableau.

Confidential

BI Developer

Responsibilities:

• Performed installing, configuring, and administering Microstrategy Intelligence Server, Web Server, and Mobile Server
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Designed and created dashboards with different Panel Stack, Panel, Selector (Panel/Metric/Attribute), and various Dataset.
• Used advanced properties of report services like creating hyperlinks, drilling, using datasets, advanced metric calculation and so on.
• Maintain close relationship with business users and provide liaison between user and development communities
• Drive initial business needs analysis, and formulate approaches that achieve desired business objectives, including defining systems scope and objectives and assisting with software selection and business case justification.
• Worked with the DBA on issues of database performance and security.

Environment: MicroStrategy Admin/Desktop/Web 9.X, SQL Server, Netezza, DataStage, MS Office, Tableau, Erwin, Windows XP

Confidential

Analyst, BI Reporting

Responsibilities:

• Responsible for gathering and interpreting data on incident trends.
• Analyze agent population metrics such as attrition, performance and behaviors, as well as resolution of incidents and complaints including client performance
• Was responsible for developing reports, dashboards, scorecards, and other data products using Excel and Microstrategy.
• Developed SQL queries as needed against development and production databases for quick-action ad hoc reporting and data quality analysis.
• Performed testing of all reports for the final deployment.
• Designed the Micro Strategy Architectural Documents for the Projects
• Created Reports using complex Filters, Compound Metrics and Prompts.
• Used Micro Strategy Narrowcast Server to provide self-subscription capabilities and to deliver personalized content to the subscribers. Involved in installation and configuration of the Narrowcast Server and perform various tasks to have the subscription and other features to work.

Environment: Microstrategy 8/7.1.2 Product Suite, Oracle 9i, Informatica, Toad, Windows XP, SQL