SUMMARY:

• Total 13 years of experience in the field of IT.
• Over 11 years and 7 months of experience in Tableau (10.1/ 8.1), SAP Business Objects Enterprise (4.2/ 4.1/ 4.0/ 3.1/ XIr2), SAP Lumira, Design Studio, Cognos, DOMO.
• Worked extensively in the field of Reporting and data analysis.
• Extensive knowledge on tableau visualization and administration.
• Extensively used different tableau products like tableau server, tableau desktop and tableau public.
• Extensive knowledge on DOMO visualization and administration.
• Working on the project planning and estimation.
• Managing team and resource planning.
• Experience on different types of Data modeling, DWH and full cycle BI project implementation.
• Hands on working experience on Oracle, MYSQL and AMAZON Redshift.
• Meeting with top business stake holders and gathering requirement for new projects.
• Working on AMS projects and actioned on top priority issues.
• Implementing best practices and documenting project plans, architectural design documents, policies etc.
• Expertise in OLTP, OLAP, and Data Warehousing concepts.
• Strong knowledge on ETL tool Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Mappings, Mapplets, and Transformations.
• Strong expertise in Data Warehousing, Business Intelligence, Performance management, Requirement gathering, Data integration, Requirement analysis and Data Modeling
• Strong experience on building webi reports and Universe using IDT and UDT.
• Experience on building BEX queries and developing reports on top of BEX queries.
• Good Experience in Development, Support and Migration projects.
• Experience in developing Strategies for Extraction, Transformation and Loading mechanisms using Informatica
• Worked in Business Objects Administration involved in resolving Customers’ Production support issues according to the Service Level Agreements.
• Experience SAP BI 7.0 and SAP HANA
• Build and enhance BW objects such as InfoObjects, InfoCubes, InfoSources/Data Sources, Master Data, Transformations, Update Rules, DSO, Extractors, Infosets, Aggregates, Process Chains, DTPs, User Exits, BADI.
• Knowledge on Agile project management methodologies.
• Working with Presales team and PMO team as a subject matter expert.

TECHNICAL SKILLS:

Reporting Tools: Tableau (10.5 / 10.1 / 8.1 ); SAP Business Objects (4.2/ 4.1/ 4.0/ 3.1/ XIr2); SAP BO FIM; SAP BO Cloud; SAP Lumira; Design Studio; Cognos; Power BI; DOMO

ETL Tools: Informatica Power Center

Database: Teradata, Oracle, Sybase, SQL Server, Amazon Redshift, MYSQL

Bigdata Tools: Hadoop

Cloud Applications: AWS

OS: Windows 2003/2000/XP, Solaris, Linux

Programming Languages: C, HTML

Web Application Servers: Apache Tomcat

SAP TOOLs: SAP BW, SAP BEX Tools, SAP Basis, SAP HANA

PROFESSIONAL EXPERIENCE:

Confidential - Oakland, CA

Lead BI Consultant

Responsibilities:

• Understanding and gathering business requirement from different business stakeholders.
• Preparing technical specification document.
• Understanding functionality of source applications like Metavance, IDS, etc.
• Working with different BI tools like Tableau, SAP BO.
• Taking lead on the project to complete project cycle within specified timeline.
• Working on data analysis.
• Building universes, reports, dashboards.
• Validating reports against DB data.
• Troubleshooting any top priority issues.
• Working on troubleshooting, debugging, Performance Analysis, query tuning.
• Working together with different teams like ETL, DBA, testing and PMO teams.
• Refreshing and scheduling reports as per business request.
• Preparing training document and giving training to the end userd.

Environment: Tableau 10.5, SAP BI 4.2, CMC, BI Launchpad, Web I, Web I Rich Client, Crystal Reports 2016, Information Design Tool (IDT), Universe Designer Tool (UDT), Oracle 11g, SQL Server 2017/2016

Confidential - Madison, WI

Lead BI Consultant

Responsibilities:

• Understanding business requirement.
• Working using different BI tools like Tableau, DOMO, Power BI, SAP BO as per business need.
• Building ETL mapping to extract source data.
• Developing complete transformation and loading data to DOMO cloud.
• Develop calculated fields.
• Developing visualizations using Tableau application and DOMO application.
• Building tableau dashboard using different tableau features.
• Proposing different visualizations and time series chart.
• Data Validation and Dashboard validation.
• Building reports using Cognos and connecting with DOMO.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Documenting complete solution.
• Helping team on critical SAP BO issues as an expert.
• Helped on some universe change.
• Designed and Prepared a Training Material for the Users.

Environnent: DOMO; Tableau, SAP BO, MS SQL Server Analysis Services (SSAS), Amazon Redshift, MySQL

Confidential - Warsaw, IN

Lead BI Consultant

Responsibilities:

• Responsible to complete the version upgrade activity of Tableau application.
• Planning for Tableau upgrade.
• Sharing plan with internal teams and coordinating with server support team.
• Upgrade Impact analysis and backup plan.
• Pre-and post-upgrade validation
• Loading data to SAP HANA landing tables and validating data.
• Dashboard validation.
• Documenting upgrade process and validations.

Environnent: Tableau 10.1; SAP BW 7.1; SAP HANA 1.0; Informatica

Confidential - Teaneck, NJ

Lead BI Consultant

Responsibilities:

• Understanding functional specification and technical requirement.
• Designing and developing new reports and dashboards using Tableau, Power BI and SAP BO.
• Connecting to different source systems and building dashboards using Tableau visualization.
• Created critical dashboards using Tableau for senior management use.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Used action filters and LOD calculations in Dashboards.
• Responsible of Tableau administration. Administer user, user groups, and scheduled instances for reports in Tableau.
• Developed many highly useful dashboards and dashboard mobile application in tableau.
• Developed dashboards for LMD, Servicenow and Markview applications.
• Created live and extract connections to use in different dashboards as per requirement.
• Enhanced the existing BO universe and financial Webi reports implementing new hierarchical structure.
• Working to enhance the existing Webi reports and dashboards as per business need.
• Stress testing and performance tuning.
• Experience in Tableau and BO server administration.
• Completed BO and tableau upgrade and DR system implementation.
• Establish close partnership with business users and other IT application teams to provide complete solution.
• Responsible for documenting project documents like requirement document, design document, test document, technical document and functional document.
• Responsible for daily and weekly status update.
• Responsible for providing production support to business user.
• Complete understanding of landscape (Source to EDW and EDW to Reporting).
• Able to simplify, translate and explain complex processes, write SQL queries and formulae.
• Requirement gathering and understanding user requirements for new development and enhancements.
• Able to work independently and drive work to completion.
• Testing and reviewing BO reports and Tableau dashboards.
• Handling the team as offshore onshore model.

Environnent: Tableau 10.1/8.1 Power BI, SAP BO 4.2 / 4.1 / 3.1; Teradata Oracle Informatica SAP BW SAP HANA Sales force

Confidential

Senior Consultant

Responsibilities:

• Requirement gathering and understanding user requirements.
• Building financial reports on top of SAP BW on HANA.
• Designed BEX queries and implemented.
• Report development using BO.
• Dashboard design using design studio.
• Prototyping
• SAP BO FIM implementation.
• Server Sizing and architecture plan.
• Preparing requirement and design documentation.
• Managing existing Cognos reports and environment.

Environnent: SAP BO 4.1, SAP BW, SAP HANA, SAP BEX Tools, SAP Design Studio, SAP BO Analysis Edition for OLAP with MS Office, COGNOS

Confidential

Senior Consultant

Responsibilities:

• Migrating reports from 3.1 to 4.1.
• New reports designed on top of SAP BW on HANA.
• Testing of migrated reports.
• SIT and UAT completion.
• Report development.
• Performance tuning
• Mentoring to team members.

Environment: SAP BO 3.1, SAP BO 4.1, SAP BW, Oracle, SAP HANA

Confidential

Senior SAP BO & Tableau Consultant

Responsibilities:

• Requirement gathering and understanding user requirements.
• Involved in data load monitoring.
• Scheduling informatica jobs.
• Running ETTL jobs in SAP BW system.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Created Test cases for the mappings developed and then created integration Testing Document
• Creating connections with various source systems.
• Universe creation.
• Report development.
• Building reports on top of SAP HANA views.
• Creating Universe connection.
• Universe Integration.
• Customization of Universe and reports.
• Report and Universe tuning.
• Report promotion from Dev to prod.
• Scheduling reports.
• Performance tuning.
• Administrating Tableau server.
• User creation and role authorization.
• SSO configuration for Tableau server.
• Load balancing on tableau server.
• Tableau Server monitoring and troubleshooting.
• Scheduling dashboards.
• Validating data.
• Building Dashboards.
• Building connection strings.
• Restarting server.
• Data backup and coordinating with win center team for related issues.
• Helping Presales team in proposals being a technology expert.
• Facilitated training for many batches with different competencies for SAP BO.

Environment: SAP BO 4.1, Informatica, Hadoop, SAP BW, SAP HANA, SQL Server