SUMMARY

• AWS Cloud Solution Architect Associate (current) with MSTR certs (expired)
• 10+ years of experience in MicroStrategy Suite (Desktop/Architect, Web/SDK/Narrowcast, & System/Integrity/Enterprise/Object/Operations Manager)
• Good experience with other tools like Tableau and Power BI
• Experience in working with the full project life cycle development process, involving analysis, design, development, implementation and testing phases
• Experience in migrating objects between Development, Testing and Production environments.
• Work closely with ETL/DBA teams to troubleshoot data issues and enhance database performance.
• Design, developing, deploying, maintaining and integrating complex Microstrategy reports, dashboards, scorecards, freeform SQL reports, objects (Attributes, Logical Views, Filters, Metrics, Transformations, Hierarchies, Drill maps, Facts and Prompts).
• Extensive experience in designing and developing interactive Dynamic Dashboards using Report Service Objects like Panels, Selectors, Grouping and Grid/Graph combinations.
• Good experience with Microstrategy Visual Insight reports.
• Experienced in using Project Merge, Object Manager and Enterprise Manager.
• Proficient in designing reports through Microstrategy Desktop with optimal usage of key features like Advanced filters, Filters, Prompts, Transformations, Custom Groups, Consolidations.
• Good experience in Microstrategy Report Service Documents and Dashboards.
• Good experience in Narrowcast Server and Distribution Services.
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the Cube Services.
• Used VLDB Properties such as Joins, Query Optimization, Metrics (Null check and Zero check), Select/Insert and Tables.
• Worked with large databases like Teradata, Oracle.
• Capable of translating complex business needs into technical solutions (i.e. ability to understand the users’ requirements).
• Created Analytic based selectors’ grid/graphs that control other grid/graphs through a panel stack, inserting as many panels as needed within a panel stack.
• Ability to work in multiple projects simultaneously and independently as well as in a team environment.
• Good knowledge and understanding on data warehouse concepts.
• Front End Development (JS/CSS/HTML) with D3.js visualizations package experience

TECHNICAL SKILLS

Reporting Tools: MicroStrategy 8.x/9.x/10.x/11/2019, Tableau 10.x, Power BI 2.x

Operating Systems: Windows & Linux Servers

Data warehouse: Teradata, Oracle, SQL Server, MySQL

Data Modelling Tools: Erwin

Cloud: AWS, Azure, Google

Dev Ops: Docker, Serverless + API Gateway

Front End: HTML, CSS, JS, Bootstrap, React/Redux

Web Server Scripting: Unix, PHP, Python

PROFESSIONAL EXPERIENCE

Confidential, San Mateo, CA

MicroStrategy Developer

Responsibilities:

• Attend meetings to monitor progress of development team upgrade tasks and help drive the process by developing testing requirements
• Research and test new features of the version 2019 platform and compare the environment from previous sandbox upgrade to v 11.0
• Conduct regression testing of features from previous versions and assess the new features in upgrade version in view of business requirements fulfillment
• Assess alternative solutions to business requirements with scope risk

Environment: Windows Server 2016, MicroStrategy 10.x/11/2019, Hadoop & DB2

Confidential, Folsom, CA

MicroStrategy Developer

Responsibilities:

• Perform administrative tasks including implementation (install software, setup new project) and maintenance (manage database instances, cubes, caching and security privileges for new users)
• Architect solutions (build schema objects and devise creative solutions for join scenarios to remove cross joins and provide correct data)
• Work with stakeholders to define reports and dashboards, build dashboards and reports with documents dashboards and visual insight uploads/cubes
• Majorly involved in understanding the data model from scratch required to generate the reports.
• Analyzing the existing Excel based reports and transforming them to Microstrategy reports.
• Created Dashboards with interactive views, trends, ad - hoc reporting and drill-downs.
• Extensively designed, developed and tested reports and dashboards using best practices for Microstrategy Report Development.
• Involved in writing complete SQLs required for reporting based on requirement.
• Hands on writing complex calculations and using the same logic in different ways.
• Developed dashboards that provide clear visualizations of various industry specific KPIs.
• End to end experience in designing and deploying the dashboards in Microstrategy.
• Closely working with stakeholders in gathring project requirements.
• Closely working with existing devlopers and project lead to understand the application functionality.
• Generated context filters and used performance actions while handling huge volumes of data.
• Experience in modifying existing reports and dashboards and analyzing it to develop better visualizations with more detail.
• Ability to work quickly and under tight delivery deadlines with focus on detail.
• Working under Agile methodology to deliver the changes to business

Environment: Windows Server 2012, MicroStrategy 10.x, Oracle 9i, SQL Server 2014

Confidential, Universal City, CA

MicroStrategy Developer

Responsibilities:

• MicroStrategy developer and architect - develop solutions to fulfill Order-to-Cash requirements for Salable Materials order processing and finance operations
• Build reports, dashboards, presentations, and ad-hoc studies for various internal and external technical and business teams
• Refactor material sales mobile dashboard to improve performance, change look and feel of user interface
• Assist in handling production support tickets for Narrowcast Services (edit users of dynamic subscription lists, edit schedules)
• Involved in identifying the business requirements and translating them into logical design
• Presented the logical data model to the business and incorporated their suggestions
• Created a physical data model based on logical design
• Developed macros in Teradata to load the data from base tables to Businesslayer tables
• Worked under Agile methodology to deliver the changes to business

Environment: Windows Server 2012, MicroStrategy 9.x/10.x, Teradata 13, Oracle 9i

Confidential, Phoenix, AZ

MicroStrategy Developer

Responsibilities:

• Lead on and offshore MSTR and other BI tool consultant resources (10 Reporting, ETL, and QA)
• Develop produce reports, dashboards, presentations, and ad-hoc studies for various internal and external technical and business teams
• Build MSTR metadata model to enable enhanced reporting of relational database structure for marketing campaign effectiveness analytics
• Develop dashboard for gauging real-time effectiveness of click-through rates and other metrics associated to social media advertising
• Manage reporting architecture through a transition from a single marketing channel interface to a multiple marketing channel interface as well as from DB2 to Netezza database platforms
• Develop reporting capabilities to include new dimensionality associated to the enhanced MSTR metadata model
• Debug existing reporting applications to meet business requirements and technical specifications
• Develop architecture documentation surrounding the build plan and associated steps
• Provide sizing & scope estimates for the projects associated to metadata architectures for enhanced marketing campaign level effectiveness analytics
• Assist developers in troubleshooting Tableau reports
• Involved in identifying the gaps and and business reporting requirements and translating them into database requirements.
• Set up new folder structures, User groups and security filters
• Developed schema objects needed for report development needs
• Ensured Row Level Security at database level to access single Timezone data at any point of time
• Ensured there shouldn’t be data duplication because of various Timezones
• Worked under Agile methodology to deliver the changes to business

Environment: Windows Server 2008/2012, MicroStrategy 9.x, Tableau 9.x, Netezza, DB2, Oracle 9i

Confidential, Walnut Creek, CA

Tech Lead (.NET Build Manager)

Responsibilities:

• Manage SDLC Build & Release to QA environment of VB.NET code for OPUS (mortgage originations & tracking) proprietary software application
• Debug configuration runtime as well as compile time errors related to XML, IIS and VB.NET codes
• QA business functionality of the application (smoketests) related to HP Quality Center defects
• Track and develop communications around related application functionality and status of defects
• Provide guidance to offshore developers related to business functionality and code fixes; participate in code review and design process

Environment: Windows Server 2012, Visual Basic.NET TFS, SQL Server 2012

Confidential, Moffett Field, CA

MicroStrategy Developer

Responsibilities:

• Data Modeling for the Supercomputing facility (NAS) simulations regarding space flight and other physics related theoretical and practical batteries / tests / simulations
• Work with Business Intelligence executives to coordinate ad-hoc studies and produce presentations
• Prototyping a Data Warehouse design for MSTR reporting to facilitate inclusion of different aspects of NAS simulations
• Consulting the research center regarding solution architecture in the Business Intelligence space
• Involved in identifying new business reporting requirements and translating them into database requirements
• Identified the existing reporting needs and ensure that they all delivered in the new business layer
• Discussed the new model with various business users and ensured that all their requirements are met in the new model
• Created a new project in MicroStrategy as per the new business layer
• Created new folder structures, User groups and security filters
• Developed schema objects needed for report development needs
• Ensured all reporting standards are met
• Developed Intelligent Cubes as part of optimizing the load on Data warehouse and support faster data retrieval
• Worked under Agile methodology to deliver the changes to business

Environment: RHEL 7, MicroStrategy 9.x, Oracle 9i

Confidential, San Francisco, CA

MicroStrategy Developer

Responsibilities:

• Consult the Bank on its MicroStrategy Architecture - Translate semantic and physical layers into logical models for integration into MSTR Reporting (Teradata)
• Worked with the end users to gather requirements, generate design documents, develop, and support BI applications developed using MicroStrategy.
• Created / updated MicroStrategy schema, dashboards, and reports per requirements
• Install, configure and upgrade MicroStrategy servers (Intelligence Server, Narrowcast, Web, Mobile, etc)
• Played key role in understaing the reports in Business Objects and identifying the business logic
• Mapped business objects understandings in Microstrategy requirements
• Developed a reporting schema based on the understanding
• Developed and proposed the data model for new business layer
• Set up new project for this purpose and developed new schema from scratch
• Designed and deployed security access in MicroStrategy
• Ensured all reporting standards are met
• Developed RSD’s as per the user requirements

Environment: Windows Server 2008, MicroStrategy 9.x, Teradata 13

Confidential, Dublin, CA

MicroStrategy Developer

Responsibilities:

• Lead a team of 4 MSTR reporting consultants
• Implement Summary Mart Project as Administrator and upgrade server environment from 9.0.2 to 9.2.1
• Worked with the end users to gather requirements, generate design documents, develop, and support BI applications developed using MicroStrategy.
• Created / updated MicroStrategy schema, dashboards, and reports per requirements
• Install, configure and upgrade MicroStrategy servers (Intelligence Server, Narrowcast, Web, Mobile, etc)

Environment: Windows Server 2008, MicroStrategy 9.x, Oracle 9i

Confidential, San Francisco, CA

MicroStrategy Developer

Responsibilities:

• Implemented MicroStrategy BI platform, MicroStrategy Enterprise Manager, and MicroStrategy Narrowcast Server applications. Assist IT personnel with troubleshooting, development, and knowledge transfer regarding the MicroStrategy toolset.
• Managed full development lifecycle implementation involving many different levels of user groups. Management functions include facilitating crossfunctional teams of developers, analysts, and users to create fully-functional MicroStrategy projects. Other functions included managing user expectations, user scope, and project deliverables to ensure project success.
• Served as an administrator in a production environment that included ensuring availability, performance, and change control to provide seamless usage for the users.
• Worked with the end users to gather requirements, generate design documents, develop, and support BI applications developed using MicroStrategy.
• Created / updated MicroStrategy schema, dashboards, and reports per requirements
• Install, configure and upgrade MicroStrategy servers (Intelligence Server, Narrowcast, Web, Mobile, etc)
• Develop Narrowcast Services and automate delivery of jobs through Command Manager scripts (Unix)

Environment: Windows Server 2008, MicroStrategy 9.x, Oracle 9i, SQL Server 2008