SUMMARY:

• 7+ Years of experience in Business Intelligence, System Analysis, Design and Development in the fields of Data Warehousing and Business Analytics. Understanding Business logic and creating Attractive dashboards in Cognos 8 and 10, 10.1, 10.2, Tableau 8, Tableau 8.1, 8.2, 9.1, 9.2, SAP Business Object 4.2 sp4, BO Design Studio, SAP Lumira and Business Object WEB Intelligence
• 5+ experience in Tableau Business Intelligence Report Design, Admin & Development.
• 3+ experience in Exposure with of SAP Business Object BI - Tool Developer and Administrator.
• 5+ experience in Cognos BI tool building attractive dashboards.
• Worked on ETL tool ODI, MySQL, Oracle& DB2 Databases.
• 4+ more experience in giving training of Tableau Desktop and Tableau Server
• Hands on experience in across Software development lifecycle, design, testing and maintenance.
• Exposure to Banking & Financial Domain.
• Exposure of building Confidential for education Domain.
• Exposure of critical level analysis in health care domain

TECHNICAL EXPERTISE:

BI Tool: Tableau 10.x, 9.x, Cognos 10, SAP Business Object 4.2, 4.1

ETL: ODI

Concepts: Data Warehouse, Big Data & Cloud Computing.

Language: SQL/PLSQL

Scripting: JavaScript, CSS, ‘R’

Markup Language: HTML, XML

Database: Oracle, MS SQL Server, DB2 & MySQL

Specialize Tools: SAP BO Information design Tool, IBM Cognos Framework Manager, IBM Cognos Active Reports, PL/SQL Developer, TOAD. SAP Web intelligence, Power BI, SAP Lumira.

PROFESSIONAL EXPERIENCE:

Confidential, VA

Tableau Consultant

Responsibilities:

• End to end implementation of presentation layer and dashboards.
• Meeting with SME to understand the business logic
• WRT BRD complete implementation of advance level statistics
• Configure Complete Disaster Recovery for tableau server
• Tableau server metadata Reporting (WHO access WHAT)
• Wrote .bat files for few dashboards that have refresh rate less than 10 mints
• KPI feasibility Document.
• Build Interactive dashboard.
• Through data blending build multi sourcing reports and Dashboards
• Implement Row level, Site, user, report, workbook level security

Technologies: Business intelligence & ETL

Tools: Tableau 9.x/10.x Desktop /server, Snowflake

Confidential

Tableau and SAP BO Consultant

Responsibilities:

• Implementations of dashboards and reports for different department.
• Meeting with SME and understand new source systems data flow.
• Involved in Requirement Gathering & Analysis
• Complete Documentation for Smooth Execution of transformation project
• Technical Design and flow of transformation of complete reports and dashboards.
• Performance enhancements - by suggesting appropriate solution for multi sourcing dashboard.

Technologies: Business intelligence & ETL

Tools: Tableau Desktop/Server, SAP Web Intelligence, SAP Lumira, Information Design Tool

Confidential

SAP (Business Object) BO Administrator

Responsibilities:

• Implementation of Report/Folder/Applications/Universes /OLAP Connections and Server level security based upon business requirement.
• Define different access levels based upon business user request.
• Take care of execution of all report (WEBI, Lumira and DS reports).
• Implementation of SSO with Active Directory Authentication.
• Configuration of SIA.
• Build Audit Schema in Information Design Tool (IDT) and build Server Activity tracing Dashboard’s like (server activities, Sessions, Peak Hour Traffic, Report level Users Access, user growth, server processes status etc.).
• Responsible for promotion from QA server to Production Server of departmental reports, Data Connections, Universes, Access Levels etc.
• Perform configuration and test to all business objects.
• Promotion of Hana data packages from HANA QA to HANA PROD.
• Build schemas in Information Design Tool and Test data connections, universes etc.
• Configuration of data services and web servers from HTTP to HTTPS
• Configuration of SSL Certificate.
• Monitoring all the related CMS, Audit and Reporting Database services
• Verifying Web applications (CMC, Info view, Custom Applications) availability
• Monitoring day to day scheduled report jobs from Instance Manager
• Supporting issues for Business users
• Taking. BIAR backup for selective Contents in CMC.
• Managing Business Object full content cold backup including (CMS, Audit Tables, FRS Etc.)

Technologies: SAP Business Object (BO)

Tools: SAP Central Management Console (CMC), Lumira, Web Intelligence

Confidential

Business Intelligence (BI) LEAD

Responsibilities:

• Complete understanding of business knowledge meeting with SME.
• Translate stakeholder requirements into report deliverables
• Tableau server task monitoring and server optimization
• Configure complete tableau Disaster recovery
• Responsible for complete end to end solution from presentation layer to dashboard implementation.
• Preparing Information Sourcing Documents like source system specification document, kip feasibility report etc
• Building tableau server task monitoring dashboards by accessing tableau server metadata data
• Writing batch files through tabcmd commands for scheduling tableau extracts
• Complete control on development testing and production environment.
• Developing LDM (Logical Data Model) and (PDM) Physical Data Model
• Tableau Web Base Portal for extra navigational Functionalities using Tableau APi’s
• Interactive dashboards, visualizations, row level security, monitoring server task, monitoring performance issues

Technologies: Tableau Desktop, Tableau Server, ODI, Oracle DB

Confidential

Tableau Consultant

Responsibilities:

• Implementing BI solution for Supply Chain Management (SCM) department
• Engaged with their business user for requirement gathering
• KPI’s feasibility report
• Building of presentation layer in Oracle..
• Implementing Tableau Desktop and Tableau Server.
• Build business layer on Oracle ERP for quick data fetch
• By using tableau implement Interactive dashboards, visualizations, row level security.

Technologies: Oracle ERP, Oracle DB, Tableau Desktop/Server

Confidential, Buffalo, NY

Cognos Report Developer and Data Modeler

Responsibilities:

• Migrated the Report sets and Reports based on the Information pulled from the Audit Database.
• Experienced in creating security setup in Cognos 10 BI environment.
• Created complex reports based on business user requirements.
• Performed the UAT on migrated reports before promoted to QA Server.
• Created reports by using data from various data marts created by Data Stage jobs...
• Created Active reports and Dashboards in Cognos10BI.
• Created Frame Work Manager Models using PL/SQL and use stored procedure
• Working with OLAP queries and DMR Models in report studio and create complex reports in Analysis studio.
• Creating Cubes in Cognos Transformer and working with cubes in Analysis Studio and report studio.
• Building attractive and complex Dashboard reports in report studio. Advance dashboard reports using Cognos Business Inside and Advance Business Inside.

Technologies: SQL Server, Cognos, Cognos Transformer, Framework manager, Report Studio

Confidential

Cognos Report Developer

Responsibilities:

• Involved in providing both business and technical expertise in the requirements gathering, report design, report development, and support of all client/server layers and components of the data warehouse.
• Designed and developed Framework model to better suit complex report development using Oracle as backend.
• Used Cognos 8 Data Manager supports high performance analysis of relational data by creating aggregate tables at multiple levels within and across hierarchies in the dimension tables
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports. Worked on Dashboard reports.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Resolved complex problems by performing root cause analysis.
• Built reports with focus on optimization: used indexes on tables and made recommendations for summary tables where needed.
• Responsible for writing various documentations like technical specifications document, report specifications document and user manual.
• Tuned FM using Governor Settings.
• Used Framework Manager to create models, packages, using session variables Macros, etc. to the Cognos 8 and Cognos10 Server.

Technologies: Oracle, Cognos Transformer, Framework manager, Report Studio