SUMMARY

• 12+ years in Information Technology Industry with a broad range of experience in - Analysis, Design, Development, Testing and Production support.
• Experience in the design, development and deployment of Enterprise Data warehouse and Business Intelligence Reporting solutions using SAP Business Objects 4.1, Power BI & Tableau 10.2
• Tableau expert with 5 years of professional experience. Created sales performance, Sales & Inventory, supply chain and Finance reports & dashboards using Tableau Desktop with SQL Server 2012/2008 R2, Teradata 13.1 & Oracle 11i as a data source.
• Strong experience in Business Objects Universe design using SAP Information Design Tool. Expertise in creating complex WEB Intelligence reports from multiple data sources, implementing various functionalities like drill, alerts, charts, master detail and linking reports.
• 3+ years of experience in Testing using ETL (Informatica) and database tools.
• 2+ years of experience in developing visualizations using Power BI Desktop.
• 6+ years of experience on SAP BO Administration in BOXI3.1 & BO 4.1.
• Prepared documentation such as Technical Specs, Analysis documents and test cases for SIT/UAT.
• Experienced in working with various databases like Oracle 10g/11i, SQL Server 2012/2008 R2 & Teradata 13.1. Created Replications, Stored Procedures, Views and developed SQL queries to cater reporting needs.
• Good Knowledge on Data Warehousing Concepts and writing SQL and oracle queries.
• A quick learner with passion to learn new technologies.

TECHNICAL SKILLS

Business Intelligence Tools: SAP BO 4.1, SAP BO Web Intelligence, SAP BO IDT/UDT/Designer, SAP BO Explorer, Business Objects XI 3.1/XI R2/XI/6.x, Desktop Intelligence and InfoView/Launchpad, Microsoft Power BI Pro & Tableau 10.2

Other Tools: Informatica 8.5.1, MS Access 2016, SAP Crystal Reports, QQube 7

RDBMS: Oracle9i, 10g,11i, Teradata 13.1, SQL Server 2012/2008

Operating Systems: Windows 2010/2008

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL Developer

Environment: SAP BusinessObjects4.1, BI Launch pad 4.1, SAP BO Explorer, Tableau Desktop10.2, Power BI Pro, Web Reports, MS Access 2016/2012, SQL Server 2012/2008 R2, Quick Books Enterprise 17, CLEARIFY QQube 7/5.5, Manage Engine Service Desk & Windows 2008/2010.

Responsibilities:

• Being a full-time employee, worked on complete life cycle of BI projects across organization.
• Gathered reporting requirements from Business users and translated them into Technical specification documents.
• Created Sales, Inventory and Logistics data visualizations using Tableau Desktop and Power BI by blending data from multiple data sources such as SQL Server 2012/2008, QQube 7 & Excel.
• Created key metrics and objects in Business Objects Universe using Information Design Tool in SAP BO4.1. Created Linked universes to cater adhoc reporting needs.
• Miscellaneous sale was a missing piece in SAP reporting for many years in the organization. Successfully re-designed BO universe and SQL queries to add this missing Miscellaneous sales component in all complex BO reports and Dashboards.
• Managed BO servers, BO user profiles & security using CMC.
• Created General Ledger and Profit and Loss reports and dashboards using Power BI and Tableau. Effectively used CLEARIFY QQube 7 to integrate Quickbooks data from various company files across organization.
• Administered MS Access and web reports’ users and their access privileges using SQL Server Management Studio and Windows AD.
• Created SQL server stored procedures and Views for MS Access 2016 and Web reporting users.
• Created Transactional replications in SQL Server Management Studio to integrate data from Source to reporting databases.
• Provided production support to all Business Intelligence applications such as SAP BO, Power BI,Tableau, Web Reports & QQube.
• Troubleshooting of reporting issues & updating tickets in the ticket management system “ManageEngineServiceDesk”.

Confidential

SQL Developer

Environment: Tableau 8.1, SAP Business Objects 4.1, BO Dashboards 4.1, Oracle 11i, Windows 2008.

Responsibilities:

• Requirements gathering & analysis from BAs. Assisting management with Effort estimation for solution development.
• Coordinating tasks with offshore team and managing deliverables.
• Creating management dashboards using SAP BO Dashboards 4.1 & Tableau Desktop 8.1
• Walkthrough Sessions on Tableau reports with Business Users.
• Creating dashboards using Tableau Desktop 8.1 with dynamic visibility, drop down selection feature with hierarchy, Charts and Alerts.
• Building and maintaining complex interactive data visualizations, online dashboards using Tableau 8.1 with Oracle 11i as data source.
• Testing of complex Tableau dashboard/visualization workbook files. Troubleshooting of reporting issues.
• Design & Implementation of Business Objects Universe using Information Design Tool in SAP BO4.1.
• Creating complex WEBI reports using BI Launch pad (BO 4.1).
• Managing CRs using IT Support System tool.
• Handling Deployment activities using Promotion management tool in BO4.1.
• Providing L1/L2 support on production issues.
• Branding & Theming of BO URL & BI Launch pad with Confidential content.

Confidential

Environment: SAP Business Objects 4.0 & XI 3.1, Tableau 7.0.2, Informatica 8.5.1, Teradata 13.1, Windows 2003 and Quality Center

Responsibilities:

• Gathering Reporting requirements from SMEs.
• Analyzing requirements & providing BI effort estimation to the project plan.
• Helping with resource management and building BI team.
• Design & Implementation of Business Object Universes.
• Modifying existing universes as per reporting requirements.
• Resolving loops in BO universe using Alias & Context methods.
• Creating BO Pre-Canned and adhoc reports using WebI XI3.1 and BI Launchpad (BO 4.0).
• Migrating BI content such as Reports & Universes from BOXI3.1 to BO 4.0.
• Creating complex reports such as Master/Detail, Cross tabs and Charts with multiple data sources.
• Impact analysis of existing reports due to source system(Oracle ERP) migration.
• Performing data validations from source system(Oracle ERP) to DWH(Teradata 13.1) and DWH to BO reports.
• Interacting with customers for understanding Tableau reporting requirements.
• Preparation of Tableau Design Documents and mock-up reports using Tableau Desktop 7
• Analyzing the existing reporting framework to build equivalent Tableau 7 dashboard Reports.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Fix/Address defects raised during BAT and updating the same in QC.

Confidential

Environment: Business Objects XI 3.1, Informatica 8.5.1, SAP Crystal Reports XI 4.0, PL/SQL, Oracle 9i, PVCS, Serena Business Mashup(Ticketing system)

Responsibilities:

• Managing user accounts and their access privileges using CMC.
• Gathering reporting requirements from SMEs & BAs.
• Translating business requirements into Technical Specification documents.
• Design & Implementation of Universe using BO Universe Designer.
• Creating BO Pre Canned and adhoc reports using WebI XI3.1.
• Design/update reports through Crystal Report Designer.
• Performance tuning of BO Reports & Universe.
• Creating BIAR files to move the BO content between different environments.
• Providing user sessions on BO tools & reports.
• Developing test cases and queries using PL/SQL by understanding Informatica mappings.
• Data Validation using Pl/SQL from Source to Target.
• Release management using “Serena Business Mashup” and “PVCS”.

Confidential

Environment: Business Objects XI R3/XIR2/6.5.1, Digital Fuel Service flow 5.2, MapInfo 7.5, Amdocs CRM, Oracle 8i/9i/10g.

Responsibilities:

• Managing user accounts and their access privileges in BO Supervisor.
• Assisting BI development team by resolving universe related issues.
• Implementing best practices in BO universes.
• Troubleshooting BO reporting issues and updating cases in Amdocs case management tool.
• Housekeeping of Broadcast Agent jobs. Analyzing and resolving issues related to BO reports scheduling.
• Raising and Implementing CCRs for Business Objects releases.
• Providing support for the Migration of Business Objects from version 6.5.1 to XI 3.1.