SUMMARY

• Versatile IT consultant with over 7 years of experience as a MicroStrategy Developer/Architect in gaming, retail, logistics, finance and banking sectors. A self - starter who enjoys working in a team environment, and who also works very well independently. Well reputed among superiors, colleagues, and associates for analytical, project management, problem solving, team building and leadership skills, as well as for commitment and work ethic.
• Over 7 years of strong experience using MicroStrategy 10.1/9.4.1/9.3/9.2/9.0.2/8.2 (Desktop, Intelligence Server, Architect, Object Manager, Integrity Manager, Web, Mobile and Narrowcast Server)
• Highly experienced in gathering and documenting business requirements, creating business and functional documents.
• Extensively worked in creating MicroStrategy Reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Expert UI designer specialized in developing visually stunning MicroStrategy Dashboards using Report Service
• Developed MicroStrategy mobile applications using mobile platform
• Highly experienced in fine tuning reports by applying MicroStrategy analytical and database optimizations.
• Expert in building Intelligent Cubes for supporting reports and dashboards as well as developing ad-hoc reports
• Good understanding in setting up Narrowcast Server concepts
• Strong SQL skills.
• Proficient in working with Star Schema and Snow Flake schema.
• Good experience in building Tableau workbooks, Data Sources, Views and Dashboard
• Excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS

BI Tools: MicroStrategy 10.1, 9.4.1, 9.3, 9.2, 9.0/8.x (Administrator, Desktop, Intelligence Server, ArchitectWeb, Visual Insight, Object Manager, Integrity Manager, Narrowcast ServerEnterprise Manager, Distribution Services, MicroStrategy Office), Tableau, Cognos Reporting Suite.

Database Tools: SQL Server, Oracle, Netezza, Teradata, DB2, Vertica.

Languages: C, C++, SQL, Java

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Verona, NY

MicroStrategy Developer/Architect

Responsibilities:

• Migration of reports from Cognos to MicroStrategy
• Worked on advanced MicroStrategy Reports concepts by creating attributes, facts, metrics, filters, Custom groups and templates using MicroStrategy Desktop
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
• Analyzed and developed the new objects in Dev environment. Migrated them to QA environment after unit testing
• Created complex Logical Views in MicroStrategy
• Worked with Pass through Functions like Apply Simple, Apply Comparison & Customized attribute Qualification Filters
• Designed and built schema objects using MicroStrategy Architect
• Hands on knowledge on upgrading Microstrategy from 9.4.1 to 10.1
• Performed as a lead in educating the end users of Supply Chain, Retail, Finance and Gaming departments making them understand the importance and usage of Documents and Dashboards as its their first time using Microstrategy
• Working with Business Users to fix reports which required minor changes.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Built Documents and visually stunning dashboards as per the requirement of end users.
• Worked on developing Expression and Table based Transformation.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Created Schedules for the reports and documents suggested by the End Users.
• Involved in migration of projects from Dev to UAT and UAT to PROD.

Environment: MicroStrategy 10.1/9.4.1 (MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy OLAP Services, MicroStrategy Object Manager, MicroStrategy Intelligence Server), DB2, AS/400, Windows 7.

Confidential, Columbus, OH

MicroStrategy Developer

Responsibilities:

• Worked with business users and analysts and gathered all the reporting needs and worked on a week to week basis to meet the expectation in terms of reporting needs and timelines
• Involved in the Analysis, Design, Development and Implementation of Business Intelligence and maintaining applications using MicroStrategy Tool suite
• Extensively worked on advanced MicroStrategy Reports concepts by creating attributes, hierarchies, facts, metrics, filters, Custom groups and templates using MicroStrategy Desktop and Web.
• Used the Object Manager to move the objects from one Environment to other in MicroStrategy. And duplicated the project to various other environments when required.
• Involved in Testing and Data validation of Reports.
• Developed Reports enabling Data Drilling across multiple Dimensions using MicroStrategy Desktop and MicroStrategy Web.
• Worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server.
• Extensively used report services for creating Different Dashboards summary level documents with grids & graph combinations.
• Worked extensively with the End Users to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Involved in creation of logical views and Freeform SQL Report.
• Worked with Pass through Functions like Apply Simple, Apply Comparison & Customized attribute Qualification Filters
• Educated the business users on creating their own reports. Provided Ad-hoc reporting for the users.
• Performed testing of all reports for the final deployment.

Environment: MicroStrategy 9.4(MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Web, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Oracle 10g, Teradata V2R6.0.2, Windows XP.

Confidential, Louisville KY

MicroStrategy Architect/Developer

Responsibilities:

• Participated in agile meetings to develop business requirement documents for operational report project
• Captured user requirements and design specifications
• Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies
• Optimized MicroStrategy reports to run efficiently by using MicroStrategy Intelligent cubes, aggregates, VLDB settings and database optimizations
• Developed reports and dashboards that provide insight into customer identification of revenue and potential sales lead.
• Used various narrowcast services and distribution services to deliver the files to users via e-mails as well as to the file locations.
• Created prompted as well as non-prompted freeform reports when the requirements could not be satisfied by regular reports
• Designed and built schema objects using MicroStrategy Architect
• Created weekly status reports to communicate project status, activities, accomplishments, risks and next steps
• Developed reports and dashboards on Transaction Services.

Environment: MicroStrategy 9.4.1/9.3(MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager), Teradata.

Confidential - Addison, Texas

MicroStrategy Architect/Developer

Responsibilities:

• Responsible for gathering and refining business requirements from the Business users.
• Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.
• Created facts, dimensions, and attributes using MicroStrategy Architect.
• Created metrics, filters, and templates for the reports.
• Designed Dashboards using radio buttons, check boxes, panels, slider and button bar etc. summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Implemented Nested Prompts, Conditional Metrics, Transformation Metrics and Level Metrics for creating complex reports.
• Analyzed and developed the new objects in Dev environment. Migrated them to QA environment after unit testing.
• Performed Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Used Command Manager to write scripts for the auto deletion and auto creation of users
• Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.

Environment: MicroStrategy 9.4.1/9.3(MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager), Netezza

Confidential 

Sr. MicroStrategy Developer

Responsibilities:

• Worked with business analysts to baseline the reporting requirements.
• Hands on the dimension model with Data Modelling team to close out the gaps in the model to best use the underlying tables needed for BI layer.
• Worked with data architects on data needed for testing the reports and dashboards.
• Extensively worked with Microstrategy architect to develop schema objects such as, attribute, facts, hierarchies and transformations etc.
• Profusely used Microstrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups and consolidations.
• Createddrill mapsfor end users to drill down and recover data.
• Worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
• Tuned and improved the performance of the dashboards using VLDB properties, database tuning and using cubes.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Took part in design and development of Data marts and integrating them with Data warehouse.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Designed and DevelopedMicrostrategy Dashboards using customized Widgets.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Worked extensively with Business Analyst to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.

Environment: MicroStrategy 9.2(Desktop, Intelligence Server, Web, Administrator, OLAP Services, MicroStrategy Project Manager, Narrowcast Server), DB2 9.5, Windows 2003 Server, Windows XP, Oracle