Sivaram Prasad Vasireddi

Sr Microstrategy Architect

Dallas,TX

Summary

Experienced engineer with over 7+ years of experience in business intelligence and data warehousing. Accomplished in tuning and optimization queries, reports and server performance. Excellent communication, project management and problem-solving abilities. Ready to work closely with both teams and customers to identify most efficient and beneficial solutions for process improvement.

Overview

years of professional experience

Work History

Sr MicroStrategy Architect

Hyundai Autoever America

6 2016 - Current

Effectively participated in Agile SDLC methodologies. Successfully demonstrated multitasking capabilities by involving in multiple projects and support initiatives.
Importing tables using Warehouse catalog and Creating Logical Tables.
Created Attributes, Facts, Transformations and Hierarchies using MicroStrategy Architect
Designed Interactive Dashboards in MicroStrategy Web to assess company's performance and monitored overall goals of business.
Led successful roll out of reporting needs to several business units with more than 30K+ users.
Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets
Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
Upgraded Development, Test and Production MicroStrategy servers from 10.11 to 2020.
Automate routine processes using Command Manager Scripting.
Controlling user access to various parts of MicroStrategy system, granting permissions to read, write, create or view reports.
Meet Business users on regular basis and build mockups for dashboards

MicroStrategy Developer

J.D. Power And Associates

01.2014 - 06.2016

MicroStrategy SDK development for Interface & report customizations.
Building Reports and Dashboards using MicroStrategy Enterprise Manager.
Performing quality assurance, system, regression and performance testing.
MicroStrategy Administrator for User Management & Object Manager deployments using package.
Integrity Manager – Performed Regression testing using integrity manager between UAT and Prod
Re-architected existing reports to utilize in-memory data cubes for fast data access.
Performing quality assurance, system, regression and performance testing.

MicroStrategy Consultant

Informatica Corp.

05.2013 - 12.2013

Setup ad-hoc reporting, report builder style reporting and canned reporting for 5 different business units based on their requirements.
Interacted with business group in requirement gathering, analysis aiding in implementing better optimization techniques to achieve improved performance.
Generated and implemented MicroStrategy reporting concepts by creating Attributes, Facts, Attribute Relationships, Conditional, transformational, dimensional and compound metrics, filters, filter prompts, object prompts and icubes.
Created complex reports for analysis with custom groups, consolidations and complex filters & prompts.
Used object manager to deploy packages from development to production

Education

Master of Science - Computer Science

Silicon Valley University

San Jose, CA

01.2013

Bachelors - Multimedia

Swinburne University

Melbourne , Australia

01.2011

Skills

Visualization : MicroStrategy , Tableau

Databases: Oracle , Teradata, MS SQL Server

ETL: Informatica

Programming Languages: SQL

Operating Systems: Linux, Microsoft Windows, Mac OS

Other Tools: Microsoft office tools, Adobe Illustrator , Control M

Timeline