SUMMARY

• Over 11 years of IT experience in software development, designing and implementing Web based and standalone software applications with major focus on Business Intelligence, Data Warehousing and Database Applications.
• Over 10 years of cumulative experience with Business Intelligence tools like MicroStrategy, Power BI, Tableau, SQL Server Reporting Services (SSRS), Cognos, OTBI, Spotfire, Qlikview and SAP BO and worked in several business areas such as Telecom, Retail and Health Care
• Extensive experience on MicroStrategy BI suite. Expertise in building projects and creating reports using MicroStrategy 8.X/9.X/10.X/11.X product suites including MicroStrategy Developer, MicroStrategy Architect, MicroStrategy Web, Visual Insights and MicroStrategy Mobile.
• Experience in Creating MicroStrategy Reports and implementing MicroStrategy projects over an entire cycle and worked in environments implementing both Star and Snowflake schemas.
• Experience working with Power BI Query Editor to prepare the data and use the Modeling and DAX module to create the relationships on the fly before creating impressive Power BI visualizations.
• Strong knowledge and understanding of SQL and ability to write SQL queries.
• Experience with developing Training materials and training users in using BI tools like MicroStrategy.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Extensive experience on Enterprise Reporting, Cube Analysis (MOLAP), Ad hoc query (ROLAP) & Statistical Analysis using MicroStrategy, Tableau and Power BI in various scenarios.
• Extensively worked on creating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidations and Custom Groups).
• Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security.
• Experience with Ad hoc reporting and Enterprise level reporting environments.
• Proficient in Analysis, Design and Development of applications using Microsoft SQL Server, Oracle, Teradata, and other Big Data sources like Microsoft Azure as backend.
• Extensive experience in developing multi - layered and multi-panel dynamic Enterprise level dashboards.
• Well-Organized, quick learner, self-motivated team player and experience in all phases of the System's Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.

TECHNICAL SKILLS

Business Intelligence/OLAP: MicroStrategy 11.2/11/1/10.3/9.4.1/9.3.1/9.0.2/8.1.1/8.0.1/7. x, Microsoft SSRS, Business Objects, Tableau 10.5, Power BI & Qlikview

Databases: SQL Server 2000/2005/2008 , MYSQL, MS Access 2000/97/7.0, DB2, Teradata V2R5.1/V2R6, Oracle 7.x/8.0/9.x/10g, Netezza, Big Data sources

Cloud Tech: AWS, Azure data sources

BI Tools: MicroStrategy, Tableau, Power BI, Cognos, SAP BO, SAS, SSRS, OTBI, Alteryx

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Intelligence Architect

Responsibilities:

• Worked on creating, debugging, and modifying dashboards especially the ones related to Clinical Operations Dashboard, HEDIS Dashboard and Authorization Dashboard .
• Performed regular dashboard enhancements, based on new HRA(s), new requirements to the existing dashboards like Population Profile Report which need a lot of datasets to be updated precisely.
• Performed constant updates to the Executive Summary Dashboard, Financial Dashboard, Outcomes Dashboard, Participation Dashboard and Utilization Dashboard which are the most visible and actively used dashboards on a weekly basis.
• Enhanced the performance of the above dashboards which were inherited from other users and bring down some of the dashboards run time down from over one minute to less than forty seconds, using advanced VLDB Settings within the MicroStrategy tool and using database tuning techniques such as indexing.
• Involved in the MicroStrategy upgrade cycle from version 11.1.0 (2019) to 11.2.0 (2020), which needed extensive testing on each report and needed comprehensive maintenance of documentation based on versions before and after the upgrade.
• Underwent Tableau online training and had to work on some report conversion of MicroStrategy to Tableau reports, to check out the advantages and disadvantages of one over the other.
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments in Tableau
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Developed some visualizations using Tableau and SAS while working on some proof of concepts.
• Developed similar visualizations in Tableau using worksheets and dashboards as developed in MicroStrategy using dossiers .
• Used data from various data sources when working with Power BI and Tableau, data was already staged and prepared before consumption and hence had clean data to work with.
• Also developed similar visualizations using the Power BI suite and used all the most recent features the tool had to offer, the modeling and DAX part of the tool were most impressive.
• Developed a few Power BI data visualizations in the process and found it extremely easier than the proprietary tool, which was MicroStrategy that was currently being used.
• Worked on Data Blending concept in both MicroStrategy Dossiers and Tableau .
• Worked on multiple dashboard projects and maintained a high level of accuracy in terms of quality of deliverables within the estimated time while successfully meeting and delivering the business users' expectations.
• Developed a dashboard for the Mobile platform, revived my knowledge from my past projects and implemented the same here.
• Security filters that we implemented at the row level was of great significance, since the Medicare and Medicaid data was extremely sensitive and considered PHI data,
• Used R-integration to create some R script-based clustering metrics and used in our environment.
• Worked with the administrators on setting up security model and then setting up the security filters and ACLs accordingly.
• Worked on rebranding the entire project space which has over 4000 reports based on the new color palette assigned by the branding team.
• Generated reports using Custom groups, Consolidations, Prompts, Filters in Grid/Graph mode .
• Some of the solutions that needed to be implemented, needed Custom URL’s and I was able to successfully implement them, in dashboard selectors and prompts.
• Worked on rebuilding datasets for dashboards and rebuilding the entire schema.
• Used several new age widgets in implementation of the enterprise level MicroStrategy dashboards in order to report on Patient Eligibility data.
• Involved in some C# work towards the end of the project.
• Underwent AWS and Python coursework during this project work and did some learning course certifications in the process.

Environment: MicroStrategy 11.2/11.1, SQL Server, Tableau, Power BI, Talend

Confidential

Sr. BI Architect

Responsibilities:

• Created training material and posted on the company website and also held training sessions for business users to use various features in MicroStrategy.
• Worked on debugging and modifying the existing behavioral health dashboards.
• Worked on creating a new dashboard for the team termed Clinical dashboard and the HEDIS dashboard, with multi state and product filters and using the most up to date widgets at the time.
• One and half year later, worked on creating an updated version of the existing Clinical dashboard, termed as Clinical Operations Dashboard V2.0 (COD 2.0), based on entirely new qualifications and filters since the business wanted to see a different perspective of the existing data.
• Worked on creating Mobile dashboards and converting some existing dashboards into Mobile versions .
• Power BI was being considered as a new technology to adopt since it was readily available for use with the suite of products.
• Generated quick dashboard visualizations using Power BI and the upper management was hugely impressed by its capabilities
• Ways to integrate maps was a much easier process than having to use the same feature in MicroStrategy.
• Generated reports using Custom groups, Consolidations, Prompts, advanced qualification Filters in Graph/ Grid mode.
• Used the new concept of Predictive metrics with some linear regression concepts that helped us get a better insight into the future based on past patterns.
• Created a storyboard and some dashboards based on a problem statement that was being addressed using Tableau .
• Map widgets were a lot easier to implement in Tableau than in MicroStrategy or Power BI .
• Worked on converting an entire project of over 80 Cognos reports to MicroStrategy, got some major exposure to Cognos universe in the process.
• Worked on multiple dashboard projects and maintained a high level of accuracy in terms of quality of deliverables within the estimated time periods while successfully meeting and over delivering the business users' expectations.
• Adapted to using all the development components of Power BI for a few months in between, where preparing the data and creating relationships and visualizations was all my responsibility.
• Worked on rebuilding datasets for dashboards and rebuilding the entire schema.
• Developed three major dashboards which had a great amount of visibility to the company’s upper management.
• Worked on cleaning up the environment by carefully deleting the older unused project objects created by several earlier implementation partner consultants.
• Worked with the administrators on setting up security filters.
• Developed Ad-hoc reports using templates, metrics and filters for business analysis using MicroStrategy Developer with drilling options .
• Worked on implementing some solutions using Visual Insights.
• Worked through multiple UAT phases throughout the project life cycle.
• While creating the dimensional model, we implemented Multi-dimensional modeling concepts as ad hoc reporting was one of the main requirements for the HEDIS and VISTAR subject areas.
• Worked with business users and created builder reports based on their requirements.

Environment: MicroStrategy 10.3, SQL Server & MicroStrategy 9.4.1, Teradata, Power BI, Talend

Confidential, St. Louis, MO

Sr. MicroStrategy Architect

Responsibilities:

• Experience in understanding of their Star schema data model and data modeling concepts, specifically those relevant to MicroStrategy.
• Involved in a MicroStrategy upgrade cycle and testing and comparing various dashboards and datasheets.
• Involved in meetings with business trying to modify reporting requirements.
• Worked on debugging and modifying dashboards.
• Worked on creating mobile dashboards .
• Generated reports using Custom groups, Consolidations, Prompts, Filters in Graph/ Grid mode.
• Worked on multiple dashboard projects and maintained a high level of accuracy in terms of quality of deliverables within the estimated time periods while successfully meeting and over delivering the business users' expectations.
• Worked on setting up standards and refining the process and documentation of the processes needed.
• Worked on rebuilding datasets for dashboards and rebuilding the entire schema.
• Worked on cleaning up the environment by carefully deleting the unused project objects.
• Worked with the administrators on setting up security filters.
• Developed Ad-hoc reports using templates, metrics and filters for business analysis using MicroStrategy Developer with drilling options .
• Worked with the administrators on phase by phase migration between environments.
• Worked through multiple UAT phases throughout the project life cycle.
• While creating the dimensional model, we implemented Multi-dimensional modeling concepts as ad hoc reporting was one of the main requirements.
• Worked with business users and created a lot of builder/ad-hoc reports based on their requirements.
• Performed regular dashboard enhancements based on user feedback and changes being made to new requirements by various states.
• Worked on giving constant inputs to Data architects based on the report outputs as needed by the business to achieve the required outputs.
• Worked on converting several Business Objects reports to MicroStrategy reports.

Environment: MicroStrategy 9.3.1, MicroStrategy 9.4.1, Teradata, SAP Business Objects

Confidential - Richmond, VA

Sr. MicroStrategy Developer/Architect

Responsibilities:

• Worked in a highly motivated team and generated and implemented MicroStrategy Application objects by creating reports, filters, metrics and templates using MicroStrategy Desktop.
• Worked on the project from the Requirements gathering phase to the UAT phase and created all objects exhaustively for the business users as they requested for all the objects, present in the various files sent over by them to be available for reporting.
• Generated reports using Custom groups, Consolidations, Prompts, Filters in Graph/ Grid mode.
• Created essential dynamic date filters to extract data for different time periods for their Current vs Historical reporting scenarios,
• Created custom built Ad hoc reports templates in reference to the various subject areas for end-users.
• Identified source tables and columns from the data warehouse to create MicroStrategy Objects & Reports.
• Constant interaction with functional analyst to translate business requirements into configurable components & designs.
• Worked with back end database administration to provide necessary tables as per requirements.
• Participated in performance and quality assurance reviews of reports and environments.
• Worked with back end DBA’s to create indexes for faster performing queries to load long listed prompts in the Ad hoc templates.
• Worked with type 2 dimensions and had the model created appropriately in order to report on Current vs Historical reporting needs.
• Worked with the administrator to work out a solution to implement security at the MicroStrategy report level using user level security to group users from having access to view PHI data.
• Involved in the analysis of the source system data and played a key role in User Acceptance Testing of the reports.
• Participated in working sessions with business users to display the functionality and ability of MicroStrategy reports and developed some proof of concepts on the fly.
• Participated in the early discussions of the data model in order to accommodate type 2-dimensional modeling reporting requirements and kept giving inputs all throughout the data architecture build.
• Hands on experience with Distribution services in order to provide Web Deliveries.
• Worked on converting reports that were developed in SSRS into MicroStrategy.
• Implemented MicroStrategy Integrity Manager to monitor the metadata object changes across all the development environments after various migrations.
• Assisted the users in troubleshooting report issues for the business users during UAT phase.

Environment: MicroStrategy 9.3.1, SQL Server 2008.