SUMMARY

• Over 10 years’ experience in Business Intelligence (BI) Project Development and Implementation Using MicroStrategy Product Suites including MicroStrategy Developing, Administration and Visualizations.
• Involved in projects like Full Life Cycle Development of Data Warehousing project planning, business requirement analysis, data analysis, and logical data modeling, setting up physical schema, data marts, OLAP services, reporting and security.
• Proven ability to anticipate the customer needs and ensure those needs are delivered.
• Work with AMEX business solution team more than 6 years to gather requirements, generate requirement solution, high - level specification documents and analyze the EGDW application to fit Business Requirements.
• Identify and develop detail requirements based on high level business needs and develop process flows and use cases for business requirements.
• Work with DBA’s and business people and data architect in Data Model changes for best visual reports implementation in MicroStrategy and Tableau.
• Extensively worked in creating and integrating MicroStrategy Reports and objects like Attributes, Facts, Metrics, Filters, Consolidations, Custom Groups, Prompts, Transformations, Drill Maps, and Templates to develop Documents and Dashboard.
• Expertise in creating Hyper Links in Documents, Drill Reports and Intelligent Cubes.
• Expertise in developing reports by using Freeform SQLs and Logical Views in MicroStrategy desktop.
• Expertise in deploying and developing the Custom Visualizations Dashboards using widgets in windows environment of MicroStrategy.
• Expertise in various MicroStrategy Version upgradation and project database connections migration.
• Strong knowledge in Reporting and Analyzing data with Intelligent Cubes & Dynamic Sourcing I Cubes.
• Fine tuning of the MicroStrategy reports using Data mart Reports, Partition Mappings and Aggregate tables, VLDB SQL Query Optimization Techniques.
• Used different types of widgets like micro charts, Gauge, Heat maps, Water fall and used different type of graphs like line, bar, pie, combination graphs for both Mobile and web dashboards.
• Good experience in using RDBMS Such as Oracle SQL, DB2, Netezza.
• Strong SQL skills related to information retrieval and analysis. Exposure to client interaction, user requirement analysis and support.
• Having good knowledge and hands of experience on reporting tool Tableau & Webfocus.
• Expertise in monitoring and purging the tasks like Jobs, User Connections, Database Connections and Caches (Element, Report, Document and Intelligent Cubes).
• Good Knowledge in Developing the Enterprise Manager Reports.

TECHNICAL SKILLS

Reporting Skills: MicroStrategy 10.x, 9.x (Desktop/Web, Intelligence Server, Mobile, Narrowcast Server), Tableau, Webfocus

ETL skills: IBM DataStage

Database Skills: DB2, Oracle, Netezza.

Data Modeling: ERWIN

SDLC Methodologies: Agile, Waterfall Modal

Operating System: Windows Xp, 2007, Windows server 2003

PROFESSIONAL EXPERIENCE

Confidential

MicroStrategy Architect

Responsibilities:

• Identify and develop detail requirements based on high level business needs and develop process flows and use cases for business requirements.
• Design and development MicroStrategy reports & dashboard and provide architectural solutions
• Work with DBA’s and business people and data architect in DATA Model changes for best visual reports implementation in MicroStrategy and Tableau.
• Creation of visual insight dashboards and converting them to report service dashboards in MicroStrategy & Tableau.
• Creation of complex stored procedure reports and document. Coordinate with warranty support team and provide necessary knowledge transfer to support team for better deliverance.
• Involved in Creating the Schema Objects, Complex reports and Dashboards.
• Worked on Dynamic Dashboards using Panel Selectors,Widgets, Graphs Etc.
• Created Free-Form SQL reports to support ad-hoc requests and built dashboards using the datasets.
• Extensively worked on Performance tuning and cube optimizations using VLDB settings.
• Wrote complex SQL's for testing and validation of data in Reports to ensure that functionality did not change after implementation.
• Worked on MicroStrategy Administration creating new users, security roles, privileges, shared folders and ACL's.
• Implemented reports Subscription to deliver the reports to business users.
• Doing migration from Dev to QA and QA to Prod using packages.
• Extensively used Enterprise manager reports for user analysis, Cube analysis and Report usage trends.

Confidential

Micro Strategy Developer

Responsibilities:

• Work with MARC business and technical team to identify, create and modify all the existing developed MicroStrategy objects in DB2 Modules to Netezza compatible.
• Created and Modified Attributes, Facts, Hierarchies, Filters and Metrics to implement security requirements.
• Worked on changing the Schema and public objects expressions based on Netezza database.
• Designed and developed intelligent cubes and built reports and dashboards from it.
• Worked on in report performance tuning. Modified VLDB settings accordingly Netezza reports.
• Worked in SIT phase to resolve the defects which we come across due to migration.
• Validating the Report SQLs across DB2 environment and Netezza Environment

Confidential

MicroStrategy Developer

Responsibilities:

• Work with Hospital Corporation of America ( Confidential ) team and gathering and analyzed existing data to build objects.
• Involved in Clinical MSTR Maintenance and Support project involves in Maintenance, Support and Enhancement of MicroStrategy reports and Dashboards related to Surgical, Clinical Excellence, TrackED, ICU and Sepsis areas.
• Review and understand the business requirements and technical specifications.
• Analyzing, writing, reviewing and rewriting programs, and ensuring the delivery and codes according to the Confidential Code standards.
• Creating the reports and Dashboards as per business requirements.
• Work on fixing the issues reported by the users by coordinating with various specialized Confidential teams.
• Involved in MicroStrategy version migration from 9.4.1 to 10 x.
• Worked on MSTR reports and documents at desktop and web level for the Confidential requirements .
• Worked in SIT phase to resolve the defects which come across due to reports implementation.
• Communicating the daily stand up calls and retrospective meetings, Technical reviews and Show and Tell.