Vikram Tiwari

Experience

• 

  Math Emporium

  Mar 2005 - Aug 2012

  Teacher Assistant

  Taught Math!

• 

  CCPACE

  Apr 2012 - Apr 2013

  Data Analyst

  Operation and Maintenance of the existing Database and Application. Performed QA testing to assist the SDLC process. Gathering and analyzing business requirements to map them to technical Meta data.

• 

  Amerigroup

  May 2013 - Sept 2013

  Business Analyst

  Part of the production support team.Defined the scope of the project.Understood and Gathered the business requirements.Actively led JAD sessions to understand current business functionality and elicit the changes/new features required

• 

  Datastrong

  Sept 2013 - Oct 2014

  Business Intelligence Consultant

  MicroStrategy 9.3.1 and 9.4.1, SSIS, SQL Server 2008, Oracle 11g (Toad). MS Offices.

• 

  Brooksource/CareSource

  Dec 2014 - Dec 2015

  Microstrategy Developer

  * 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. * Worked closely with MicroStrategy Architect to implement MicroStrategy solutions. * Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment. * Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level. * Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.* Performed unit and integration testing for production support. Show less

• 

  Attain

  Jan 2015 - Jun 2016

  Microstrategy Consultant

  Federal Services – Worked with the Enterprise Solutions team as a MSTR Analyst, using Agile Methodology. Client: Security and Exchange Commission (SEC)Completed Projects: Chicago Regional Offices (CHRO), Assets Facility Management. OIT and Financial Services (OFS). Worked on MSTR 941(HF7) environment.Responsibilities:*Involved in design/development life cycle including gathering requirements, user interaction and report design and development.*Worked on the Architecture the schema and public objects for the dynamic dashboards. *Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.*Developed MSTR Dynamic Dashboards in the Express Mode using several controls and worked extensively on widgets.*Performed Unit test and Regression testing for Datasets reports and Dashboard Validation. In Progress Projects: Visual Analytics and Dashboard Reporting (VADR) for Investments advisors monitored by the Office of Compliance Inspection and Examinations (OCIE) containing TRENDS and FINRA data. Show less

• 

  SS&C Primatics

  Aug 2016 - now

  Business Intelligence Lead

  Senior MicroStrategy SME