Vikram Tiwari

Senior MicroStrategy Developer

Email: acrhff@r.postjobfree.com Cell: 540-***-****

PROFESSIONAL SUMMARY

Over 4 years of IT experience in Business Intelligence (BI) Project Development and Implementation using, MicroStrategy 930 above. Product Suites including MicroStrategy Desktop, Web, mobile & Intelligence Server.

Experience in Software Development Life Cycle (SDLC) in Agile and Waterfall methodologies that include duties like providing documentation on design, testing and migration from development to production.

Strong knowledge in creating Success criteria and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.

Involved in migration of Business Objects Documents to Microstrategy Documents.

In handling various Relational Databases like Teradata, SQL Server.

Highly motivated team player and excellent communication, interpersonal & analytical skills.

PROFESSIONAL EXPERIENCE

BrookSource, Inc., Dayton (Ohio)

MicroStrategy Developer

Project – CareSource Dec 2014 - Present

Developed, enhanced, and modified MicroStrategy reports and dashboards and supporting schema and application objects running on a Teradata data warehouse with a SQL Server metadata repository.

Designed Prompts and Filters to generate reports in grid and graph mode.

Created Report Services Documents out of existing reports and customized them to reflect the Company's logos and color palette.

Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.

Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.

Performed Data Profiling in the existing data source and collected the statistics and information about that data.

Performed the Unit testing and created the implementation plan for the RFC deployment.

Datastrong, Inc., Fairfax, VA Sept 2013- Sept 2014

MicroStrategy Reporting Consultant

Client – Accenture (USPS project) April 2014- Aug 2014

Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies.

Captured users and SMEs requirements and design specifications.

Documented reporting and data modeling requirements using Datastrong’s SIMON software.

Provided MicroStrategy report and dashboard development and resource coverage for primary resources.

Worked in the Business Objects Universe and report development and Created Objects like Object Prompts, Documents & Reports.

Developed Reports that provide insight into customer identification of revenue and potential sales lead.

Created reports and dashboards on Transaction Services.

Client -- Tarraservices

MicroStrategy Dashboard Developer Jan 2014- April 2014

In charge of the design and development of highly visible executive dashboards and workflows that provide insight into the root causes of performance failures and their impact in the network.

Conduct requirements gathering sessions with network operations managers and subject matter experts.

Created Proof-Of-Concept (POC) dashboards on MicroStrategy Mobile.

Delivered MicroStrategy training sessions to targeted users at the national, area and facility levels.

Responsible for the support and maintenance of all MicroStrategy applications pertaining to the Network Operations subject area of the Enterprise Data Warehouse.

WellPoint – Amerigroup, VA Beach, VA June 2013 – Sept 2013

MicroStrategy Analyst

Amerigroup is one of the largest health care providers for public programs. I worked at the National Support Center (II) office as a BI Analyst. As a BI developer, I was responsible for Analysis, design, development, testing and implementation of new set of reports and to create dashboards on MicroStrategy tool based on the reports for the project. The project is dealing with interactive dashboards where the user can get the data upon their request in flash mode. Project was mainly worked on the Claims intake, Routing and EDI processing dashboards.

Extensively worked with Metrics, Facts, Transformations, and Custom Groups & Report Services.

Performed detail requirements gathering, analysis, design, configuration, and process and data flow diagramming for processes of high complexity.

Gathered requirements from management users for generation of reports in Web and Desktop.

Everyday Stand up meeting with Stake holders, BA, ETL, DA, and manager based on Agile Methodology.

Once ETL is done and data gets loaded to Data warehouse, Defined and created MicroStrategy objects including Attributes, Filters, Cubes, Nested Filters, Hierarchies, Templates, Prompts & Nested Prompts.

Improved report performance using VLDB properties, and Caching.

CCPace System, Fairfax, VA Aug 2011 – Feb 2013

MicroStrategy Consultant

CCPACE is a business and technology expert in software development using Agile Methodology.

Project (CUDAS): NEA’s College and University Data Analysis System (CUDAS) is basically a search and retrieval engine built around the US Department of ED’s IPEDS (integrated postsecondary education data system) data.

Developed new reports and converted existing reports for the business line to satisfy the specifications using Microstrategy Desktop.

Performed User Acceptance testing (UAT), Worked with the Quality Assurance Team (QAT) to ensure that the testing issues are resolved for the existing CUDAS reports and dashboards.

Conditional formatting on metric thresholds, limiting report data access using security filters.

Worked on the different phases of the Software Development Lifecycle (SDLC) for the project.

Worked on Performance tuning of Reports along with weekly status review with clients.

Enhanced end users' understanding of the report systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.

TECHNICAL SKILLS

Software

MicroStrategy 931/941 (MicroStrategy Report Services, Visual insight, Dashboards, Transaction Services), Microsoft Project, SQL Server 2008.

Databases/Languages

SQL Server, Oracle 11g (Toad), and MS Office.

EDUCATION

Virginia Tech, B.S., Applied Computational Mathematics (ACM)

CERTIFICATION

DataTutors: MicroStrategy Certified Engineering (Project Designer, Document Developer, Report Developer, MicroStrategy Certified Developer, Project Administrator, Engine Specialist, Mobile Specialist, Visual Insight Essentials, Transaction Services Specialist)

Contact this candidate