Amjapat

Professional Summary:

Have Over Ten years of experience working with SAP BO on different versions and over Seven years of experience developing & constructing the numerous dashboards using the tools like Xcelsius (versions 2003/2008 Dashboard Designer ) and about 3 years of experience of developing the Tableau Reports & Dashboards using Tableau Desktop & Tableau Server and around 2 years of experience in building the Dashboards using SAP Design Studio for clients as per the UI requirement. Professionally experienced in all phases of the Software Development Life Cycle (SDLC) of Reporting Solutions which included the requirements on Data Warehousing Business Intelligence Business Analysis Database Applications and System Development and has a ton of experience in using DSS/OLAP (Data warehousing) tools.

Additional hands-on experience includes:
�    Experience in implementing Business Intelligence & Data-warehousing solutions using Business Objects BI 4.2/BI 4.0/BO XI 3.1/XI R2/XI R1/6.x/5.x for RDBMS & OLAP sources.
�    Well versed in SAP BO with Experience in 2 (CMC CMS CCM Info view Desk I Web I Web I Rich Client Import Wizard Publishing Wizard Report Conversion Tool) UDT IDT XCelsius 2008/4.5 QaaWS Live Office Crystal Reports.
�    Experience in Designing/ Documenting SAP BO Universe requirements/ Documenting Reports requirements definition templates Security strategies up gradation and Migration strategies.
�    Deployed the reports on Info Desktop and Scheduled Reports for the use of end users and customers.
�    Experience in Designing/Developing the User-interface (Universe) Canned/Ad-hoc reports scheduling and processing of reports.
�    Extensively used SAP BO reporting functionalities such as Master Detail Slice and Dice Drill down Filters Ranking Sections Graphs Charts Breaks Cross Tabs Scope of Analysis Prompts Contexts Merge Dimensions Sub Queries Sorting Conditions Statements Variables Calculations Formulas.
�    Experience in Coordinating resources prioritize group activities and establish schedules to ensure that plans are consistent with overall company objectives.
�    Involved in creating database objects like tables views procedures triggers and functions using SQL to provide definition structure and to maintain data efficiently.
�    Fine\tuned SQL Queries for maximum efficiency and performance.
�    Tested Cleaned and Standardized Data to meet the business standards using Execute SQL task Conditional Split Data Conversion and Derived column in different environments.
�    Thorough analysis unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server
�    Extensive working experience in using tools like SQL*Loader WinSQL SQL Developer SQL Navigator and TOAD OEM.
�    Experienced in writing Complex Reporting using SQL performance tuning and providing operational support for OLTP and OLAP applications.
�    Expertise in Designing Dimensional & E-R modeling Star & Snow-flake schemas.
�    Experience in Constructing Interactive and Customized Dashboards using Tableau while connecting to multiple sources.
�    Proficient in Designing Developing & Implementing Tableau BI Reports/Dashboards.
�    Proficient in Designing Developing & Implementing XCelsius/Dashboard Designer Dashboards.
�    Experience with Data visualization in Designing Developing & Implementing using SAP Design Studio Dashboards.
�    Trained and have good knowledge on SAP Lumira & Microsoft Power BI.
�    Involved in Installation Trouble Shooting and Resolving issues within BO Enterprise.
�    Extensive working experience in writing SQL queries and Creating Packages Stored Procedures Functions Cursors Database Triggers and Database Constraints.
�    Have rich On-site experience and have an excellent Client facing skills great Team player Team leading skills and Project managing skills.
�    Excellent communication skills self-motivated with a high degree of attention a good Team Player can work independently committed to work and have sound leadership qualities along with good project managing skills.
�    Proficient in Providing 24x7 Production support.

Education
B.S. Computer Science IIT Delhi India.




Technical Skills:

Reporting Tools:    SAP BO BI 4.2/4.0/XI 3.1/XI R2/XI R1/6.x/5.x (Info View BI Launchpad Supervisor UDT IDT Web I Desk I Web I Rich Client Broadcast Agent) Crystal Reports 2016/2008/XI/10 Dashboard Designer XCelsius 2008/2003/4.5 SAP Lumira 1.28/1.25 Tableau 10.5/10.2.1 SAP Design Studio 1.6 Microsoft Power BI.

Programming Languages    C C++ JAVA SQL PL/SQL XML PERL UNIX Shell Scripting.

Internet Technologies        Html DHtml CSS ISQL Plus.

ETL Tools            Pervasive ETL Integrator Informatica 9.1/8.6/8.5/8.1

RDBMS    Oracle 12/11g/10g/9i/8i SAS 9.4/9.2 Sybase 11.9.2 Netezza 4.66 SQL Server 2005/2000 Greenplum 5.0 DB2 TOAD 7.x/9. x.

GUI    Oracle Forms 4.x/5.x/6.x Reports 4.x/5.x/6.x Applet Visual Studio 2005 Xcelsius �03 �08 OEM.

Operating Systems:        Windows Server 2003 Windows XP Windows NT/2000 UNIX Linux Sun Solaris
Mobility            XCode IOS


Professional Experience:

JPMC � Columbus OH                       Nov�18 � Present
Sr. Business Objects Developer
Responsibilities:
�    Gathering the requirements from the Executives Business Analysts and converting them in to Technical Specifications for our Patient Access Project needs.
�    Designed the Universes using IDT & EPIC Caboodle for the support of Patient Access Clinical & Call Center Projects.
�    Coordinating with the ETL team in executing the project throughout life cycle to ensure that the delivery timelines are met.
�    Coordinating with Admin for setting up the Security (User group Folder Level security).
�    Created the Executive Dashboard Reports using Web I at all the levels (Department Sub Specialty/Division & Provider).
�    Extensively Involved in Documentation of Business Requirements Analysis & prepared Technical Specification Documents in Designing the Universes Creating the Reports & Peer sign off approvals.
�    Analyzing Designing Developing Configuring & Maintaining the WEB I reports for Business Users.
�    Created & Modified various simple & complex reports mainly using BO Universes as data providers.
�    Troubleshooting the issues at report level and query level debugging for data Validation.
�    Created the Monthly reports & generate PDF and Published to the Clients.
Environment: SAP BI 4.2 CMC BI Launchpad Web I Web I Rich Client Information Design Tool (IDT) Oracle 12 SQL Server 2017 SQL Developer Windows 10 EPIC Caboodle

Delta Dental Insurance Company � Sanfrancisco CA                   Jun�18 � Nov18
Sr. Business Objects Developer/Tableau Developer
Responsibilities:
�    Gathering the requirements from the Stake Holders Business Users Internally/Externally and converting them in to Technical Specifications for our Reporting needs.
�    Extensively worked in the frontend reporting deployment and support of SAP BO projects like Discount Plan & Medicaid Projects.
�    Coordinating with the team in executing the project throughout its life cycle to ensure that the delivery timelines are met.
�    Interacted with business to gather requirements prioritize work develop enhancements to the existing system coordinate testing and perform change management for Reporting.
�    Perform analysis and design write technical specifications configuring and programming in the SQL Server and Oracle including testing and implementation.
�    Troubleshooting the issues at report level and query level debugging & Data Validation.
�    Worked as a Lead in Validation and Credentialing functional areas of Medicaid projects by getting the requirements from the users and delivering Web I reports/Crystal Reports.
�    Va