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(Hadoop) technologies

TECHNICAL SKILLS:

Business Intelligence Tools: Tableau 9.2/8, Qlikview 10/11, SAP BI 4.0, BusinessObjects XI 3.1, Cognos 8/10, Microstrategy

Databases: Oracle 11g, Vertica, SAP HANA, SQL Server, Toad

Productivity: Office Suite, Adobe Suite, Mind map, MS Project, Workbench

PROFESSIONAL EXPERIENCE:

Confidential - Indianapolis, IN

Sr. BI Consultant - Tableau

Responsibilities:

• Lead discussions with business partners to identify functional requirements and resulting in development of system specifications andTableau applications
• Responsible to develop and document technical architecture, system designs, and other technical aspects of implementations
• Define and/or offer guidance on best practices during implementation and integration of the Tableau platform
• Involved in creating data integration of different data source (Teradata, Vertica& web source) and load them into Cloudera Hadoop Environment.
• Includes handling JIRA tickets, user inquiries and Adhoc change requests in Agile environment
• Develop and maintain Tableau Extract in effort of integrating two or more data sources.
• Administer all aspects of aTableaudevelopment and production environments including security and performance tuning (involves indexing and partitioning of database)
• Responsible for all data analytics, data visualization and development utilizing Tableau
• Involves in integrating Tableau views to third party web application using Tableau SDK(Java)
• Created a ‘Table of Contents’ Tableau Dashboard to integrate all the SharePoint.
• Involved in validation of the dashboards by helping QA team with Test plans to move the dashboards to production

Confidential - Norristown, PA

Division - Information Technology

Responsibilities:

• Develop and document technical architecture, system designs, performance test results, and other technical aspects of implementations
• Define and/or offer guidance on best practices during implementation and integration of the Tableau platform
• Server installation, upgrades,Cluster set-up and load balancing for Gateway server and troubleshooting system issues in distributed environment
• Involved in hardware sizing and installing Tableau Failover Strategy in Production (Primary and Back-Up Server)
• Responsible for design and setup security model (authentication, network, data security) and configuration including sites, user / Security group setup, permissions, security roles, configuration of trusted ticket authentication (SSL, Kerberos) through Active Directory Synchronization for SSO purpose.
• Handled Tableau admin activities migrations, extracts maintenance and monitoring of Production
• Created custom dashboards to monitor proactively apart from the Admin views (Traffic by views, data source, user activities)
• Wrote windows shell scripts in windows server in order to monitor the server status and performance
• Closely work with the statisticians and data managers in data analysis to plan future development, analyze the source data and handled efficiently by modifying the data types.
• Involved in the designing data modelling strategies to get best visualizations, writing custom SQL queries in order to optimize the dashboard run time
• Involved in guiding developers and business analysts in designing dashboards using advanced analytical techniques (data blending, sets) and table calculations, interactive dashboard design, and visual best practices to convey the story within the datausing various Tableau Views
• Designed the strategy for Tableau extract(.tde) refresh schedule, subscriptions for optimal performance
• Involved in writing REST API’S to integrate Tableau views in to the third-party customized UX web application and design Data extracts API’s thru Tableau SDK and thru Alteryx to publish the extract into Tableau server
• Involved in integrating Big Data systems (Hadoop, AWS) to extract data using Tableau SDK (Java, Python) extract API’s and integrate with User Interface Applications.

Confidential - Chicago, IL

Sr. Principal Consultant - BI Leader & Architect

Responsibilities:

• 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 module for Confidential BIS consultants

Confidential - Madison, WI

Division - MCIS Reporting

Responsibilities:

• 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
• Involved in designing customized UX design for user to login and integrated the Tableau server dashboards using SDK
• 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

Division - Corporate

Responsibilities:

• 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

Division - Analytical Enterprise Claims Reporting

Responsibilities:

• 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

Division - EMBRACE transformation project (ETP)

Responsibilities:

• 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

Division - Care Management Application (CMA)

Responsibilities:

• 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

Division - Finance

Responsibilities:

• 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

Confidential - Parsippany, NJ

Sr. Business Intelligence Architect, BI Line of Business

Responsibilities:

• Gathered requirements, specifications, designed schematic solutions in various Reporting vendors (Cognos, Business Objects)
• Involved in developing fact dimensional and relational modeling and in all phases of modeling (Logical and Physical)
• Created Models packages and published packages from frame work manager from various data sources such as Oracle, SQL Server and Teradata.
• Created Universes, Classes and Objects for management systems using designer functionalities (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects
• Involved in proposing the best Teradata Loading Utility (BTEQ, MLOAD, FEXPORT etc) for the load based on the business requirement and turnaround time
• Created Metric Studio Packages for Metric Studio Applications using Metric designer and implemented Event Studio Application for the maintenance of some important Thresholds
• Developed the cubes and scheduled them for daily and weekly refresh and created UNIX shell scripts for Automization of cube refresh using the corn tab on the Cognos AIX server
• Managed Off-Site and Off-Shore technical delivery teams based in Cincinnati, OH and Hyderabad, India with support, requirements, sub-level project plans, documentation and resource allocation
• Guided the off-site delivery team to size up appropriate alternatives for real-time reporting, report and universe development to conform to design and delivery expectations
• Monitored SLAs every day to carry out performance tuning for the Information Management group for administrators and data analysts on data transformation and quality routines, scheduling and data integrity checks
• Responsible for working with Business and Data Analysts on customizing the Databases for Reporting Purpose
• Generated various kinds of Audit reports (daily, monthly etc) in cognos8 Using Genware capability

Confidential

Sr. Business Intelligence Architect, BI Line of Business

Responsibilities:

• Gathered requirements, specifications, designed and built additional reports for Oil and Gas sector
• Trained power users to support, maintain and create reports and metadata for future reporting needs
• Upgraded existing Report Net 1.1 to Cognos 8. Upgrade included migration of 250 Packages, 1000 reports and 50 IWR Reports.
• Created Reports – List, Cross-Tab, Conditional Formatting, Drill-Trough, Master-Detail and Summary Reports
• Developed various complex and customized reports using prompts like value, Tree Prompts, Date prompt, Type in, Cascading Prompt, Select & Search Prompt and using conditional Formatting as well
• Created several WebI reports, DeskI reports using multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts and Dashboards for graphical presentation
• Involved in Server Administration, Content Administration, Schedule Management as a part of Cognos Administration
• Migrating Impromptu catalogs to cognos8 Models using impcat2xml utility.
• Migrating Impromptu Reports to cognos8 Reports using migratetocrn and deploytocrn utilities
• Carried out joint development sessions with power and business users for development and testing
• Monitored SLAs every day to carry out performance tuning for the Information Management group
• Gathered functional requirements for Reports and technical specifications to the reporting team
• Migrated reports to production, Performed support, maintenance and change requests
• Facilitated creation of a “BI Knowledge portal” to enable users to get a feel of BW reports and dashboards
• Refreshed the BO Reports as soon as the Informatica mappings are refreshed