SUMMARY

• Diverse skill set: MicroStrategy, statistical data analysis using R
• Over 10 years of professional experience wirh 6 years as a Data analyst, including 4 years of experience in Analysis, Design and Implementation of BI applications using MicroStrategy.
• Involved in teh entire life cycle of implementation (SDLC) from business analysis to final deployment and testing.
• Experienced in Agile Methodologies using Scrum framework.
• Strong experience in creating and integrating MicroStrategy reports and objects (attributes, filters, metrics, facts, prompts and hierarchies) with Data warehouse.
• Worked extensively on designing projects using MicroStrategy and developed many dashboards in teh past 3 years.
• Extensive noledge in creating datasets and working with complex metrics and filters.
• Good noledge and working experience with Object manager and Integrity manager.
• System analysis and design of business applications, logical and physical data modeling and Implementation into production using Oracle.
• Created and reviewed end - to-end process designs, process flows, functional specifications, test scripts, training material and other related documentation.
• Experience in providing technical support and preparing technical documents for teh end user.
• Adept at working with diverse technical groups and end users to develop technical solutions that meet or exceed expectations along with good analytical, and problem-solving skills.
• Self-starter, multitasking, attention to detail, ability to work independently; manage time and tasks efficiently.

TECHNICAL SKILLS

Reporting: MicroStrategy 10.6 (Includes MSTR Desktop, MSTR Architect, MSTR Intelligence Server, MSTR Web, MSTR Narrowcast Server, MicroStrategy Administrator (Object ManagerCommand Manager), MicroStrategy Enterprise Manager, MicroStrategy Office, MicroStrategy Report Services, Visual Insight

Tools: Sharepoint, ERwin, Toad, Aginity

Programming: SQL, PL/SQL, Python, R programming and R studio, Linux Shell scripting, Batch programming, C

Database: Netezza, SQL server

Operating Systems: Linux/Unix, Windows 95/98/2000/NT, MS-DOS

Cloud computing: AWS EC2 and S3, RESTful service

Testing tools: Quick Test Pro, Win Runner, Load Runner

PROFESSIONAL EXPERIENCE

MicroStrategy Consultant

Confidential, Windsor Mill, Maryland

Responsibilities:

• Involved in creating complex reports which are used by various users for making critical decisions regarding teh call center at various times and for trend & sales analysis.
• Developed logical models, attributes and facts, extracting tables from warehouse.
• Created and implemented MicroStrategy reports by creating attributes, metrics, filters, hierarchies, custom groups, cubes, projects and templates.
• Created various types of reports like group by, ranking on some condition, fact comparison with past year, prompted report and consolidation reports.
• Designed custom drill maps using drill map editor as required in teh reports for drill through functionality.
• Created various pass through functions like apply simple, apply comparison and case statements to support various business requirements.
• Created various monthly dynamic dashboards and documents for decision makers with multiple panel stacks, selectors and customized widgets.
• Worked on intelligent Cubes to provide performance for dashboards and reports.
• Extensively worked on creating report services documents using multiple grids and graphs.
• Applied OLAP and statistical functions to calculate metrics.
• Worked on a transaction services dashboard to help users enter member insurance.
• Created different transformations to get teh last year actual transactions, week-to-day, week-toperiod, week-to-quarter, and week-to-year.
• Involved in creating user groups and assigning user privileges according to teh types of reports that they can generate or view in MicroStrategy web.
• Performed a complete production support for teh end users using MicroStrategy web & MicroStrategy desktop.

MicroStrategy Consultant

Confidential, Somerset, NJ

Responsibilities:

• Performed requirement analysis, participated in end-user meetings and review sessions to gather functional and technical design specifications.
• Worked extensively with teh database administrator, developers, system administrator and end users to interpret business requirements and develop concise solutions.
• Identified teh source tables and columns required to create teh MicroStrategy Project, thereby achieving a Logical Data Modeling of teh physical data warehouse in teh Metadata Repository.
• Created dashboards for running and maintaining member repository for all members enrolled in Medicare Health Plan.
• Coordinated with offshore developers and oversaw teh technical work to provide best solutions Designed and developed complex reports to facilitate teh business analysis.
• Extensively created filters, prompts, custom groups, consolidations and transformations to generate reports for Business analysis.
• Created security roles, users and user groups.
• Assigned privileges to users and groups through security roles and assigned predefined grouping and custom grouping of permissions to objects using Access Control List (ACL).
• Implemented Security filters at teh user level for data level security.
• Used Command Manager to automate teh whole MicroStrategy administrative tasks including, purge cache, user management, and trigger reports according to event load.
• Performed unit testing to validate each independent program component individually.

Data Analyst

Confidential, Andover, MA

Responsibilities:

• Involved in requirement gathering, analysis & document business requirements.
• Validated design and technical specifications are complete, consistent, concise, and achievable
• Support and coordinate Systems Integration Testing (SIT), user acceptance testing, and associated activities
• Support and coordinate test plan, test cases and test execution as related to data management and data integration within Wyeth pharma
• Monitor and analyze business performance, providing targeted dashboards and recommendations for operational improvement.
• Work closely and support Product Development and IT groups by providing relevant requirements from teh visualization and data stand-point
• Analyze and interpret information from multiple data sources
• Develop meaningful insights for regular campaign performance reports associated with client goals
• Created user documentation on custom processes and applications.