SUMMARY:

• 17 years of professional experience as a Senior Data Architect, Administrator, Designer & Developer in implementation of End to End Enterprise Data warehouse projects using BI Tools like Business Objects, Tableau, and Power BI, along with Informatica PowerCenter (8.6/7.2), SSIS, DataStage with 19 Years of Overall IT Experience in Healthcare, Energy, Financial Services, and Telecom Domains.
• 17 years of very strong experience in implementing Full Life cycle of Data Warehouse Projects using star schema and snowflake models by adopting Kimball & Inmon methodologies using Agile/SCRUM Software Development Process using Jira.
• 7 plus years of experience in Healthcare Domain and working with different stakeholders in delivering the projects.
• 12 years of very strong experience as Technically savvy Project coordinator working with multiple Enterprise teams to setup environments which includes sizing, scaling, performance tuning etc. and also as a project manager in work allocation, scoping, monitoring, risks and mitigation and delivery of the projects.
• As a Principal Informatist/ Solution Architect executed multiple projects as a single point of contact working with multiple business teams on Business Intelligence and Analytical issues and aligning the environments to support the needs of the business.
• Very strong experience in building Center of Excellence for Business Objects, and Tableau by establishing Enterprise standards, templates, production checklist documents, migration documents, training materials, socialization, guiding project teams to use best BI tools, resolving issues with BI tools.
• Experience in working with Data Governance team in building the Data Quality rules with the help of Data profiling.
• 14 years of very strong experience in working with vendors/ third party vendors in resolving issues with the tools and understanding the roadmap and aligning the environments in support of the same.
• Understanding and implementation of new DW technologies like ELT, and Data Vault (Anchor, Detail & Relationship).
• 16 Years of Strong SQL Experience in Oracle, SQL Server, IBM DB2, Teradata DB, and Netezza
• Very Strong experience in scripting T - SQL queries, stored procedures, user defined functions (UDF), Database triggers, and Packages.
• 10 years of strong experience in developing ETL Program using DTS, SSIS and Informatica for supporting Data Extraction, transformations and loading and used Control-M to schedule the mappings.
• Strong working experience in the Development, Implementation and Testing of Data Warehousing applications
• 14 years of strong experience in designing and developing real time BI architecture that involved Installation, Configuration, Upgrades, Performance tuning, Load balancing and Capacity planning for the Enterprise Architecture in Business Objects, and Tableau.
• Setting up and configuring different third-party tools for Visualizations, Scheduling tools like Visualization BI, IWS, Control-M.
• 9 Years of strong experience in Design and development of simple to complex rich Graphic visualizations using Tableau 10.4/ 9.2 sourcing from various sources like Databases (Oracle, SQL Server, Teradata, Netezza, DB2 etc.), SFDC, Hadoop, Text/ Excel files.
• 9 Years of strong experience in Design and Development of Tableau Data Visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Stacked Bars, Bullet charts, Pie Charts and Bar Charts and Density Chart, Filled Maps and Symbol Maps according to deliverable specifications.
• 9 Years of strong experience in Design and Development of Dashboards, Story Points at Enterprise level using Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations, implemented complex features in charts like creating bar charts in tooltip and used features like Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's, Trending and Forecasting for Predictive Analytics.
• 6 Years of experience in Installing Configuring and Administration of Tableau Server 10.4/ 9.2
• 16 Years of very strong Business Objects Experience in Design, Development, Administration, and Migration using SAP BI 4.2/4.1, BOXI R3.1/ R2 Suites which includes CMC, CCM, CMS, Upgrade Management Tool, Import Wizard, Universe Design Tool (UDT), Information Design Tool (IDT), Lumira (formerly called SAP Visual Intelligence), Explorer, LCM, web Intelligence, BI Launch Pad (Java Infoview), Desktop Intelligence, Crystal Reports, Voyager, Live Office, LCM, Program objects, Dash Board Builder, Performance Manager, Xcelsius, Design Studio etc.
• 16 Years of Very Strong Experience in Design and Development of “Complex Universes” sourced from multiple databases, Hadoop HIVE, SAP BW developed in UDT, IDT
• 16 Years of Very Strong Experience in Design and Development of Simple to Complex webI Reports, Crystal Reports, Dashboards sourced from multiple databases, Hadoop HIVE, SAP BEx Queries with multiple Data Providers using Freehand SQL and Stored Procedures, using BO features like Drill Through, Slice and Dice, Cross Tab, Master Detail and Report level variables for the preparation and analysis of reports.
• 11 Years of very strong BO Administration experience using SAP BI 4.2/4.1, BOXI R3.1/ R2 CMC with the integration of Windows AD Security Model, Siteminder Integration, implementing SSO (Single Sign-On), integration of IIS and Tomcat Versions, working with the different BO Services, implementing Row Level Security, Column/Object Level Security, Managing Users, Managing Folders, Content Level security and Data level security and also scheduling the BO objects on Windows 2003/ Windows 2008 Servers on VMware Environment.
• 2 Years of very strong experience in Design and development of rich data Visualizations for data analytics using Power BI from various sources like Databases, Salesforce, and Excel.
• 6 years of strong experience in creating Disaster Recovery environment and performing disaster recovery as part of Testing as well implementing during the issues.
• 4 years of very strong experience in Business Objects migration from BOXI R2 > R3 > BI 4.1 > BI 4.2
• Providing UAT support and comparing the data between Business objects reports, Tableau Dashboards and MS office Excel report by creating advanced Excel functions like formulas, pivot tables, VLOOKUP
• 14 plus years of strong experience in Training Users to create Ad-Hoc Reports using Business Objects Web intelligence

PROFESSIONAL EXPERIENCE:

Confidential, Albuquerque, NM

Senior Tableau Architect

• Working with multiple Enterprise teams to setup environments (Dev, QA, UAT and Prod) which include sizing (Horizontal/ Vertical), scaling (Current and Future needs), performance tuning etc.
• Working with Citrix Team to build dedicated/ shared environments for offshore teams.
• Implementation of SVN as a version controlling at Enterprise level
• Implementation of LDAP authentication for Netezza to implement row-level security.
• Built the Tableau Center of Excellence and serving as an Enterprise Dashboard tool and establishing Enterprise standards, templates, production checklist documents, migration documents, training materials, socialization.
• Working with Data governance team in building/ modifying Data quality rules with the help of data profiling.
• Working with ETL Team to standardize the coding standards, best practices and review of DataStage ELT/ ETL mappings to make sure the implementation of business logic to meet the business needs.
• Working with different BI teams to design and maintenance of Business Objects and Tableau environments to support Enterprise BI Reporting tools.
• Working with SAP and Tableau to build the road map for any upgrades to minimize the Business impact and also sizing of the environment for future Business needs.
• Complete testing of complex reports/ visualizations as part of migration efforts.
• Defining Enterprise standards for Reports, Visualizations to have same look and feel for Business Users.
• Building Metrics to understand and analyze the system performances.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's.
• Design and Development of Complex Universes using BI 4.1 Universe Design Tool (UDT), Information Design Tool (IDT)
• Fine tuning the Universes and resolving any issues that identified with the help of Integrity Check
• Used @aggregate aware, @select, @prompt, @where functions, Database Delegation in Universe to improve performance
• Created Complex WebI Reports (Used multiple data providers, Union, Intersection, Minus, Master/Detail, cross tab, Charts, and Input Controls)
• Developed Web Intelligence reports by linking multiple data providers in a single report and made all possible incompatible objects as compatible by merging the common objects (used Merge Dimensions) and also used Force synchronization.
• Worked extensively with the major functionality of Business Objects Web Intelligence like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Providing UAT support and comparing the data between Tableau Visualizations and MS office Excel report by creating advanced Excel functions like formulas, pivot tables, VLOOKUP.

Confidential, Plano, TX

Senior Tableau Consultant:

• Design and Development of different dashboards for every channel with Key metrics to identify the planned vs actual growth for different subject areas using Tableau.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's.
• Providing UAT support and comparing the data between Tableau Visualizations and MS office Excel report by creating advanced Excel functions like formulas, pivot tables, VLOOKUP.

Confidential, Dallas, TX

Senior Tableau Consultant

• Working with different Subject Area SMEs to understand the Requirements to convert them into Technical Specifications.
• Understanding the Source, Data Mart data to build Tableau Visualizations, dashboards and Story points.
• Converted the business requirements into TDR (Technical Design Review), and Testing Documents
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Utilized Tableau server to publish and share the reports with the business users.
• Involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group, providing Add/Edit Sites and corresponding administration rights (System vs. Content)
• Monitor server activity/usage statistics to identify possible performance issues/enhancements.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Design and development of rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Providing UAT support and comparing the data between Tableau Visualizations and MS office Excel report by creating advanced Excel functions like formulas, pivot tables, VLOOKUP.
• Mentoring and lead Junior engineers as required by providing Technical / Training on Tableau.

Confidential, Dallas, TX

Senior BI Architect

• Working with different Subject Area Functional Users to understand the Business Requirements and understanding of the Architecture of different Subject Areas
• Built the Business Objects and Tableau Center of Excellence and serving as an Enterprise Dashboard tools and establishing Enterprise standards, templates, production checklist documents, migration documents, training materials, socialization.
• Working with different BI teams to design and maintenance of Business Objects and Tableau environments to support Enterprise BI Reporting tools.
• Working with SAP and Tableau to build the road map for any upgrades to minimize the Business impact and also sizing of the environment for future Business needs.
• Complete testing of complex reports/ visualizations as part of migration efforts.
• Defining Enterprise standards for Reports, Visualizations to have same look and feel for Business Users.
• Building Metrics to understand and analyze the system performances.
• Understanding the Source, Data Mart data to build Tableau visualizations and Dashboards and few Business Objects reports.
• Converted the business requirements into TDR (Technical Design Review), and Testing Documents.
• Converting TDR into TDD (Technical Design Documents) which lists the technical mapping between Universe Objects, Data Mart DB Columns to Source data.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Stacked Bars, Bullet charts, Pie Charts and Bar Charts and Density Chart, Filled Maps and Symbol Maps according to deliverable specifications.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Design and development of rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Converted existing few BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Created simple to complex Dashboards using Visualizations to Business Users about the cost of Energy Delivery of Energy by state by month.
• Created Enterprise level Dashboards to show the performance of various Energy generation using Nuclear, Hydro etc.
• Utilized Tableau server to publish and share the reports with the business users.
• Involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Administering BI 4.1 SP2/ BO XI R3.1 Enterprise Suite, Crystal Reports 2008 in Windows 2008 R2 Server environment on VMware environment
• Installation and configuration of BOXI R3.1, Crystal Reports 2008 on a Multi-Node on Windows 2008R2 Server on VM Ware.
• Installation, and Configuration of Business Objects in Sandbox, Dev, QA and Production environments and Fine tuning the environments by Vertical and Horizontal sizing and by understanding of Business Objects Architecture.
• Installation and Integration of Tomcat and configuring and customizing the webapps for SSO of InfoView, OpenDocument and other apps to meet the Enterprise requirements.
• Deploying webApps, customizing and configuring the webapps for SSO of InfoView, OpenDocument and other apps to meet the Enterprise requirements in WebSphere 6.1 and 8.1 environments on Linux environment
• Installation and maintenance of server applications including web servers by understanding the Business Objects Architecture
• Applying patches and monitoring the environment to make sure it is up and running
• Planning, Designing and Deploying Business Objects (BOBJ) on Cluster Environment
• Integration of Windows AD Security Model, implementing SSO (Single Sign-On), working with the different BO Services, implementing Row Level Security, Column/Object Level Security, Managing Users, Content Level security and Data level security and also scheduling the BO objects in Windows 2008R2 Server Platform on VMware Environment
• Supported 6500 Plus Users community in resolving the issues with Enterprise Business Objects (BOBJ) Environment, User’s Migration Requests, providing the Best Practice while Design and Developing the reports.
• Design and Development of Universes using the IDT tool to meet the requirements from different sources.
• Created Complex WebI Reports (Used multiple data providers, Union, Intersection, Minus, Master/Detail, cross tab, Charts, and Input Controls)
• Developed Web Intelligence reports by linking multiple data providers in a single report and made all possible incompatible objects as compatible by merging the common objects (used Merge Dimensions) and also used Force synchronization
• Worked extensively with the major functionality of Business Objects Web Intelligence like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Providing UAT support and comparing the data between Tableau Visualizations/ Business Objects Reports and MS office Excel report by creating advanced Excel functions like formulas, pivot tables, VLOOKUP.
• Preparing Training materials for Users and providing training and conducting User community sessions
• Resolving User’s issues by working with them, Project migrations between different environments and working on the Users Requests
• Providing Metrics and Project Planning updates for the long-running upgrades and changes by leveraging PM Skills

Confidential, Richmond, VA

Senior BI Consultant

• Working with different Subject Area Functional Users to understand the Business Requirements and understanding of the Architecture of different Subject Areas
• Converting the Business requirements into Data Model.
• Understanding the Source, Data Mart data to build Business Objects reports
• Converted the business requirements into TDR (Technical Design Review), BOR (Business Objects Report) and Testing Documents
• Converting TDR into TDD (Technical Design Documents) which lists the technical mapping between Universe Objects, Data Mart DB Columns to Source data.
• Developed Tableau data visualization using Cross tabs, Heat maps, Scatter Plots, Stacked Bars, Bullet charts, Pie Charts and Bar Charts and Density Chart, Filled Maps and Symbol Maps according to deliverable specifications.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Utilized Tableau server to publish and share the reports with the business users.
• Administering BO XI R2/ R3.1 Enterprise Suite in Windows 2003, 2008 Server environment on VMware environment
• Installation and Integration of IIS, Tomcat and Websphere environments on Windows 2003, 2008 Server Platforms on VMware Environment
• Planning, Designing and Deploying Business Objects on Cluster Environment
• Integration of Windows AD Security Model, Siteminder Integration, implementing SSO (Single Sign-On), working with the different BO Services, implementing Row Level Security, Column/Object Level Security, Managing Users, Content Level security and Data level security and also scheduling the BO objects in Windows 2003 Server Platform on VMware Environment
• Supported 25000 Plus Users community with 20 Production Servers in resolving the issues with Enterprise Business Objects Environment, User’s Migration Requests, providing the Best Practice while Design and Developing the reports
• Working on Auditor, Scheduler and publisher of BO XI R2/ R3.1 and Fine Tuning and stabilizing the BO environment to meet Business needs
• Improving performance by testing, debugging and implementing the changes
• Installation and Configuration of environments using clustering, sizing of the hardware, maintenance of the BO servers, patching if needed in Windows
• Design and Development of Complex Universes using the techniques like Derived tables, Chasm trap and Fan trap using Alias and context using Designer Module using BO XI R3.1
• Fine tuning the Universes and resolving any issues that identified with the help of Integrity Check
• Used @aggregate aware, @select, @prompt, @where functions, Database Delegation in Universe to improve performance
• Created Complex WebI Reports (Used multiple data providers, Union, Intersection, Minus, Master/Detail, cross tab, Charts, and Input Controls)
• Developed Web Intelligence reports by linking multiple data providers in a single report and made all possible incompatible objects as compatible by merging the common objects (used Merge Dimensions) and also used Force synchronization
• Worked extensively with the major functionality of Business Objects Web Intelligence like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Customized business applications like Client Portal, Billing Portals to talk to Business Objects to retrieve and schedule the reports using Java SDK.
• Developed ad-hoc reports using ODS as data source.
• Promoting best practices and standards in BI reporting techniques for various tools like Web Intelligence, Desktop intelligence and dashboards within the organization
• Mentoring and lead Junior engineers as required by providing Technical / Training on BO
• Communicating and working with Offshore team to ensure quality and timely delivery
• Preparing Training materials for Users and providing training and conducting User community sessions
• Resolving User’s issues by working with them, Project migrations between different environments and working on the Users Requests
• Working on BIAR files, Universe designer, Import wizard, Business Objects and Crystal APIs for deployment automation
• Administration activities like Security setup, User Management, security structures and Content Management
• Design and development of rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Developed Tableau data visualization using Cross tabs, Heat maps, Scatter Plots, Stacked Bars, Pie Charts and Bar Charts and Density Chart according to deliverable specifications
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's.
• Providing UAT support and comparing the data between Business objects reports and MS office Excel report by creating advanced Excel functions like formulas, pivot tables, VLOOKUP
• Administering BO XI R2/ R3.1 Enterprise Suite in Windows 2003, 2008 Server environment on VMware environment
• Planning, Designing and Deploying Business Objects on Cluster Environment
• Integration of Windows AD Security Model, Siteminder Integration, implementing SSO (Single Sign-On), working with the different BO Services, implementing Row Level Security, Column/Object Level Security, Managing Users, Content Level security and Data level security and also scheduling the BO objects in Windows 2003 Server Platform on VMware Environment
• Providing Metrics and Project Planning updates for the long-running upgrades and changes by leveraging PM Skills.

Confidential, Rochester, MN

Senior BO consultant

• Setting up the BO XI Environment and administering the BO XI R1
• Worked with the business community to gather reporting requirements, created technical and functional specifications to achieve the desired end results
• Migrated the BO 6.5 objects into BO XI R1
• Involved in Full life cycle design and development of Business Objects reporting Applications
• Involved in the preparation of TDR (Technical Design Review), BOR (Business Objects Report) and Testing Documents
• Design and Development of “Complex Universes” using the techniques like Chasm trap and Fan trap using Alias and context using Designer Module
• Designing and Developing canned and ad-hoc reports, complex reports with multiple Data Providers using Freehand SQL and Stored Procedures, Master-Detail Reports using Business Objects Module
• Team Management Ex: Coordinating with Team and On-site co-ordinator, Distributing the work and ensuring the quality deliver with zero errors by meeting the Time Lines
• Involved in different Testing Phases like CUT, SIT, RT and UAT
• Provided Training to End Users to use various functionalities of Business Objects and to create Ad-Hoc Reports.

Confidential, Atlanta, GA

Senior Developer

• Worked closely with On-site co-ordinator to get the Report requirements
• Involved in Full life cycle design and development of Business Objects reporting Applications
• Involved in the preparation of Design and Testing Documents
• Design and Development of “Complex Universes” using the techniques like Chasm trap and Fan trap using Alias and context using Designer Module
• Reviewing the documents, Universes and reports
• Involved in different Testing Phases like CUT, SIT, and UAT
• Involved in performance and tuning of the system