SUMMARY

• Alteryx Core Certified, Tableau Certified Specialist, Microstrategy Certified Analytics Architect (ANA) and Microstrategy Certified Architect (MCA) with extensive experience in managing Business Intelligence and Enterprise Data Warehouse implementations
• Involved in managing Informatica to IBM DataStage/Information Server ETL Conversion, SAP Business Objects to Microstrategy Conversion, Microstrategy and Oracle upgrades
• Designed complex and user interactive dashboards in Microstrategy
• Designed workflows in Alteryx to supplement data for visualizations in Tableau
• Worked extensively on customizing and optimizing the query performance of reports for various users with MicroStrategy features like VLDB property, I Server settings and changing database properties like adding indexes, creating aggregate tables and partition strategies
• Optimized ETL Load to cut down time for loading around 200 Million records from 90 hours to 31 Hours
• Involved in MicroStrategy Intelligence Server performance monitoring, creating log files and managing cache expiry times
• Experienced in migrating Microstrategy objects between various environments using Object Manager
• Experienced in managing Microstrategy upgrades between various versions
• Currently working on a POC to move some of the reports from Microstrategy to Tableau
• Well versed in Strategic Planning, Scope, Management & Rollout, Process Improvements, Dynamic Team Building & Leadership, Scheduling Tasks and Milestones, Resource, Capacity and Budget Management, SDLC Expertise, Extensive Systems Analysis & Design, Quality Assurance (CMMI/ISO) & Risk Planning, Vendor Management
• Knowledge of Big Data implementation using Hadoop technology which includes HDFS and tools like Hive, HBase, Sqoop, Flume. Currently, working towards a POC for a Confidential agency to demonstrate the working of Cloudera Big Data solution with the Microstrategy BI tool
• Completed trainings in Big Data space involving Hadoop and Talend. Currently undergoing training on Spark, Scala and Splunk

TECHNICAL SKILLS

Project Management Tools: MS Project

Portal: SharePoint MOSS 2007, WSS 3.0

Business Intelligence: MicroStrategy, Tableau, SAP Business Objects, MS Analysis Services (SSAS), ProClarity, MS Reporting Services (SSRS), Qlikview

Data Model: ERWIN, Visio, E/R Studio

Database: SQL Server, Oracle, Informix, DB2

Big Data: Cloudera Hadoop, Apache Spark, Scala, Apache Flume, Apache Kafka, Apache Ni - Fi, Apache Kudu, Apache Sqoop, Apache Hive, Apache HBase, Cloudera Impala, Hue

ETL: Alteryx, IBM Data Stage, Informatica, SQL Server Integration Services (SSIS), SQL Server DTS, Ab Initio, Alteryx

Language: Visual Basic .Net, ASP .Net, C #, JAVA, Python, VBA, PHP, Perl, C, Shell Script, Oracle PRO*C

SQL: T-SQL, Oracle PL/SQL, Oracle SQL PLUS, Oracle PRO C

Web: HTML, XML

Version Control: Visual Source Safe, UNIX SCCS, IBM ClearQuest

Quality Assurance: SOX, CMM Level 1-5, ISO 9000, A123, and C&A

Others: Crystal Reports, Oracle SQL Loader, IBM Rational Suite, Tivoli, Autosys, My Eureka Metadata Manager, TOAD

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence SME

Responsibilities:

• Currently working for an On-Demand Reporting System (ODR) which consists of enrollment and claims data for the organization.
• Support migration of legacy Claims and Enrollment application data from Mainframe to Big Data Hadoop environment.
• Use Hive and Cloudera Impala queries to troubleshoot data issues on the Reports and Dashboards.
• Review and tune performance of EDW BI components for optimal performance.
• Design data models and physical tables for optimal data storage and faster query performance by Microstrategy.
• Incorporate Big Data DW best practices for the EDW/BI solution.
• Working to migrate existing Microstrategy reports to Tableau for plan providers.
• Development of BI Reports and Dashboards in Tableau and Microstrategy.
• Used extensively complex calculations in Tableau, and VLookUp, Index, Pivot tables in Excel.
• Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and extracts in Tableau.
• Created Tableau Dashboard projects for Enrollment and Claims Processing.
• Worked on data wrangling, data visualization and complex LOD calculations within Enterprise Information Services team.
• Led efforts in creating Tableau dashboards for plan providers for claims processing and enrollment services.
• Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and extracts in Tableau.
• Experience in creating visualizations using Bars, Lines, Pie Chart, Maps, Scatter Plots etc and creating Hierarchies, Joins, Blending, Filters, Calculated Measures, Table Calculations and Level of Details etc.
• Created macros and workflows in Alteryx to minimize manual efforts towards benefit calculations.
• Successfully deployed Field Services Dashboards on MicroStrategy Mobile using Cube technology.
• Participate in business requirements with clients and end users to translate them into System Design.
• Support Design and Architecture of Microstrategy Schema objects.
• Support Admins with Object Manager to do migration between environments.
• Support Integrity Manager for testing difference between environments during software upgrades.
• Customized Microstrategy Transaction services reports to update Technical Debt data in the back end.
• Support UAT, Unit and System testing various releases involving enhancements to the system.
• Support Microstrategy migration activities across the environments.
• Review and Approve Design for the Data Model, Big Data, Tableau and Microstrategy.

Environment: MS Project, MS Visio, ERWIN, Microstrategy, Tableau, Alteryx, Cloudera Big Data Hadoop, Hive, Cloudera Impala, Hue, MS Office.

Confidential

Microstrategy SME

Responsibilities:

• Design and Manage Microstrategy reports and dashboards for Disaster Recovery & Grants Reporting System (DRGR). The objective of this data mart is to report on various grants given by the agency to various authorities to assist with the housing and disaster rehabilitation schemes.
• Design and Manage reports and dashboards for TA’s and Grantees.
• Design complex flash based interactive dashboards, visualizations and documents in Microstrategy.
• Design Oracle ETL jobs to extract data into OLAP system for reporting.
• Design data model for the OLAP reporting database.
• Supported Administrators in managing the Microstrategy projects and version upgrades.
• Customized various VLDB properties and I Server settings.
• Gathered and analyzed business requirements from clients and end users.
• Currently, working towards migrating Microstrategy projects to the latest version.
• Also, currently working towards proof of concept for Microstrategy Mobile.
• Troubleshoot Microstrategy schema issues related to data model and relationships.
• Designed schema objects like attributes, facts, hierarchies etc.
• Made use of metrics, filters, prompts, consolidations and custom groups to generate user defined and ad hoc reports.
• Support Admins with Object manager to do migration between different environments for release deployments.
• Support Integrity manager for testing differences between environments during MicroStrategy upgrades.
• Support testing of the Microstrategy objects and the ETL jobs.
• Manage Microstrategy migration activities across different HUD environments.
• Participated in UAT testing.

Environment: MS Project, MS Visio, Microstrategy, Oracle, UNIX/LINUX Shell Script, Toad, MS Office

Confidential, VA

Data Architect

Responsibilities:

• Manage Qlikview and SSRS reports and dashboards for the college’s Budget Office Enterprise Data Warehouse. The objective of this data warehouse is to report on Finance, HR and Student Information System.
• Manage reports and dashboards for staff and faculty.
• Design complex flash based interactive dashboards and reports in Qlikview.
• Design SSIS ETL jobs to extract data into data Warehouse system for reporting.
• Design data model for the Data Warehouse reporting database.
• Gathered and analyzed business requirements from clients and end users.
• Support testing of the reports and the SSIS ETL jobs.
• Participated in UAT testing.

Environment: MS Project, MS Visio, Qlikview, SSRS, SQL Server, SSIS, MS Office

Confidential

Microstrategy SME

Responsibilities:

• Managed Microstrategy reports and dashboards for Customer Data Mart (CDM) development project for Confidential (USPS). The objective of this data mart is to capture customer related information from various sources in USPS and monitor customer relationship. This includes prospects, revenue, discrepancy between systems on customer id etc. The goal is to use this data to focus on initiatives that involve customer marketing, sales and service, and to track their activity across multiple service channels.
• Design complex SQL queries to fix data quality issues with the customer data. This is needed to ensure that the materialized view for the customer has an integrated view of all customers being fed to CDM on daily basis.
• Proposed solution to implement in memory OLAP cubes concepts in the data mart using Microstrategy.
• Support Project Management with SDLC, EVM, WBS, Risk, Schedule and Time Management for the contract. Also, review and support draft of various deliverables which include requirements, design, system testing, training, O&M manual, configuration documents.
• Design data mart architecture to make to scalable to address growing volume of customers and revenue. This requires support of a scalable system to address user’s reporting needs.
• Gathered and analyzed business requirements from clients and end users.
• Worked closely with data modeling and ETL teams to develop the logical and physical data model, which has both Type 1 and Type 2 dimensions.
• Designed data quality Database to monitor the ETL load time, track ETL job status and data quality issues which includes data volume processed, rejection of data and source file statistics. Microstrategy reports were developed on top of this to provide analytics for the data quality.
• Apply Oracle analytical functions to optimize complex calculations.
• Conduct weekly status meetings which discusses accomplishments, issues, risks, load status, help desk tickets, enterprise change requests and upcoming tasks.
• Developed Microstrategy reports, scorecards and dashboards. This includes customer portfolio and data quality dashboard.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Created transformations for time-series analyses and prompts in customer tuned reports.
• Created transformations for using in comparative reports like customer portfolio this year to last year.
• Worked extensively on customizing and optimizing the query performance of reports for various users with MicroStrategy features like VLDB property, I server settings and changing database properties like adding indexes, creating aggregate tables and partition strategies.
• Unit testing the Microstrategy objects and participate in test cases design and system testing.
• Executed full SDLC for the data mart project.
• Participated in unit, system and UAT testing.

Environment: MS Project, MS Visio, Microstrategy 9.0.2 Suite, Oracle 11g, Informatica, UNIX/LINUX Shell Script, Toad, MS Office