SUMMARY:

• Seasoned Executive, Technology Consultant & BI Leader with diverse Global experience
• Experienced Leader, Architect, Trainer, Technical writer and Process Management consultant with expertise in managing Large Business Intelligence engagements
• High level proficiency and experience in Business Intelligence Life cycle management - Vision workshops, Proof of concept, analysis, Data Architecture, Data Integration and cleansing, data modeling, deployment and change management, maintenance, testing, Quality Control
• Strong Data Warehousing experience in Data Visualization tools like Tableau, QlikView, and relational reporting tools like IBM Cognos BI Series, Business Objects Lifecycle, Microsoft BI, Microstrategy suite and Data Integration tools (Informatica, SSIS, IBM Data Stage ) and high performance databases like Vertica and HANA
• Highly Entrepreneurial, Self-motivated Thought Leader with a high level of analytic and numeric literacy in multiple verticals viz. Healthcare, Finance, Energy, Consumer Goods, Communications & Banking
• Certified Technology Consultant in IBM Cognos, Oracle, Teradata, Microsoft BI Technologies(SSIS,SSRS)
• Currently focused on High-Performance Analytics and Big Data Analysis technologies

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Principal Consultant

• Areas of work include BI Leadership, Solutions Consulting, Client Management, BI Solution Delivery, BI Architecture, Strategy and BI Assessments, Statements of Work, PoCs and proposals and Governance
• Leader of the BI Analytics consulting practice under the Information Delivery Competency - Focused on promoting Cognos/Tableau/Qlikview competency, hiring and engagements within the practice
• Conducted classes and workshops for Tableau/MSTR/BusinessObjects, Cognos during every annual HP WW PS Summit
• Mentored entry level and intermediate technology consultants including the HP/Kensington program
• Worked with Tableau and Cognos partner extranet managers and developed a Tableau/Cognos training module for Confidential BIS consultants

Confidential, Madison, WI

• Technical oversight of the entire Tableau Server infrastructure, Architecture from user setup to Deployment and performance tuning
• Responsible for installing, upgrading and configuring Tableau Server for high-availability(Primary and secondary server setup)
• Responsible for Database Maintenance which involves backing up Tableau Data, restoring extracts and workbooks from Tableau Backup
• Responsible for setting up security model which involves creation and deletion of sites/users group, granting permissions for user / user group setup like granting user roles and assign security to the folders created in the tableau environment
• Involves in setting up schedule to sync all AD groups on a site via a schedule
• Involved in using Tableau to facilitate Fact-Based Team Collaboration and automating server for automatic refresh for Tableau Extracts with Tableau’s Command Line Tools
• Responsible for Tableau Server Management (like Clustering, Load Balancing, User Management etc)
• Working in coordination with Clients/ Business Analysts for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations
• Deftly designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports, bar charts, water fall charts, score cards, Gantt charts, Bubble charts, Word maps, Geospatial visualizations, network charts etc.
• Advanced knowledge of Tableau report performance optimization using data modelling strategies
• Involved in writing Java API’S to integrate Tableau views in to the share point
• Developing custom SQL and data blends as per requirement.
• Working with Business Analysts to streamline any data issues, which involve Unit Testing of all the worksheets.
• Handling change requests and providing support/maintenance for deployed projects.

Confidential, Perrysburg,OH

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Reported directly to ESP Integration leadership. Walked in the midst of daily firefights and controlled, re-designed the entire system in record time
• Implemented best practices around Audit, Balance and Control to ensure that the end-product was mostly automated and could be maintained easily. At the end of the engagement, the 6 business critical interfaces were handed over to just 2 Primary Developers - down from over 20 Developers who were initially engaged

Confidential, Bloomington, IL

Analytical Enterprise Claims Reporting

• Involved in end to end implementation and enhancements on Mobile App data starting from requirement gathering and dashboards development in Tableau Desktop.
• Writing SQL Scripts to load the relevant data in QlikView Applications.
• Designing Data Modeling and Loading data from Multiple Data sources.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView
• Created multiple complex calculation like Lookup and many conditional statements
• Created numerous dashboards in Tableau Desktop based on the data collected by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Created Crosstab’s to display underlying data based on various graphs and charts created for further data analysis.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Confidential, Franklin, TN

Disease Management

• Responsible for RFP (Requests for Proposals) data visualization creation in Tableau Desktop
• Built and structured a transition team and governance structure for transitioning from Infosys to HP. Transition with reverse knowledge transfer was completed within an 8 week timeframe
• Reported directly to ETP Program Management and Client BI Managers
• Manage a highly distributed team of 15, comprised of Project Managers, Business Analysts, ETL Architects, ETL Developers and Reporting Specialists working out of Franklin, Bangalore and Manila
• Improved the team dynamic and ongoing interaction between on-shore and off-shore resources
• Managed all aspects of BI delivery and serve as the BI Architect, Leader and Engagement Manager
• Currently performing a BI Roadmap assessment and Master plan for long term scalability
• Advisor to the ETP “Architecture and Governance” and “Long Term Scalability” track
• Proposed and led the effort to migrate all Analytics data to Vertica for accelerated performance and scalability. Constantly worked towards creating momentum for positive change
• Re-architected the entire Data Warehouse in line with Industry Best Practices in order to build Tableau reports on top of the Vertica Server
• Technical oversight of the entire Tableau Server infrastructure from user setup to performance tuning
• Performance tuning of workbooks, data sources, and providing best practices for user community
• Work in a highly collaborative environment with minimal supervision
• Ability to work on multiple priorities and/or projects simultaneously.
• Problem-solving abilities and ability to meet reasonable deadlines.

Confidential, Chicago, IL

Business analysis, Metadata design, Dashboard and Proposal development

• Metadata Development (Designing Semantic layer for the Report Development) using Micro strategy Architect tool
• Worked with SQL Server 2008 Integration Services(SSIS) to load the data into SQL Server Database
• Responsible to generate SSRS reports for adhoc Purposes.
• Generated and Implemented Micro strategy Schema Objects and Application Objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates
• Gathered functional requirements for CMA Portal and translate them into system solutions
• Worked with large volumes of Claims data and developed interfaces using MicroStrategy Desktop, MicroStrategy Web under best practices
• Involved in Project Administration (Project Merging, Deploying the projects between environments)
• Worked on creating Application objects like Metrics, Compound Metrics, Filters, Custom Groups
• Developed Flash Dashboards in Micro strategy 9.0.1 using Widgets and Selectors for summary level Reporting
• Worked in creating a Microstrategy POC
• Worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds and Report Optimization
• Created high level design document template for reports

Confidential, New York, NY

Business requirement analysis

• Performed Customer requirement Gathering, Requirement Analysis from User to design the Framework Model, Dashboards, Cubes and complex Reports
• Involved in the Cognos Administration like Migrating reports from one environment to another Environment, Object level security using Access Manger, Scheduling the Cognos Reports
• Collecting and sharing best practices and tips in Framework Manager Modeling, Security setup, Report Authoring and Performance Tuning
• Create Score Cards, Dashboards and Key performance Indicators (KPI’s) for decision support using Metric Studio
• Worked closely with the Data Architect to maintain referential integrity and ETL consistency
• Wrote SQL extracts and updates using Oracle Analytic functions to extract complex sets of data
• Involved in developing Informatica Mappings by coordinating with ETL Team in defining the ETL Logic for reporting tables and in setting up the timely schema refreshes for the Reporting Schemas
• Mentored the 10 member QA team to adhere to best practice processes including carrying out hybrid testing approaches around functional requirements