Amol Patil

Phone No.: +1-319-***-****

E-mail: ablfk5@r.postjobfree.com

Summary:

. Around 7 years of strong professional IT experience with SAP

Crystal Reports 2011, SAP Business Objects Interactive Analysis

/ WEBI 4.0/3.1, SAP Business objects Designer UDT IDT, Import

Wizard, BVM,CMC, SQL Server 2008, PL/SQL scripts, Oracle 11g,

OBIEE and BI Publisher.

. I have played roles like BI Report Developer, BI Production Support

Engineer, Business Analyst and Database administrator.

. Strong Documentation skills experience on IBM - Rational

Requisite Pro, MS sharepoint, requirement gathering and convert

into Technical and functional Specifications.

. Implemented Data warehousing schemas like Star-Schema, Snow-

Flake Schema.

. Experience in Designing/Developing Universes, designing Business

View Manager, Developing Canned/Ad-hoc Reports, Scheduling and

processing of reports and implemented setups for report

bursting.

. Experience in creating dashboards using Xcelsius 2008.

. Strong work experience in PL-SQL stored procedures writing, SQL

statements also expertise in Data validation and root cause

analysis, test case documentation and best practices

implementation in reporting.

. Responsible for creating the Crystal Reports and Webi reports

(On demand, Audit Reports, Ad-hoc Reports, Summary Reports, Sub

Reports, dynamic grouping, Cross-Tab, graphical, etc).

. Implemented LEAN Ideas to improve business processes and also

worked on cost reduction in report development and dollar saving

on code maintenance.

.

Educational Qualifications:

. Bachelor of Engineering in Electronics (Duration 4 Years).

. Diploma in Advance Computing - Specialization -Computer Programming.

. Distance Learning-Post Graduation Diploma in Business Administration

:(Duration 2 Years)

Technical Proficiency:

Business Crystal Reports 2011/2008/XI, Business

Intelligence Tools Objects3.1/4.0, SAP Business objects Designer UDT IDT

tools, BI launch Pad 4.0, Central Management Console

4.0, Business View Manager, Import Wizard, Life Cycle

Manager,

Oracle Business Intelligence Enterprise Edition

reports (OBIEE), Oracle BI Publisher Reports and Open

Document, Xcelsius 2008, QAAWS.

RDBMS / DBMS SQL, MS-SQL server 2008, TOAD,ORACLE 11g, DB2, Sybase

IQ, MS -Access 2007.

Programming PL-SQL

Languages

Job Function Technical Lead, Requirement Gathering and Analysis,

Design, Technical Design Doc, Report Development,

Testing.

Documentation / IBM - Rational RequisitePro, IBM Clear Quest, Aqua

Data Validation Data Studio, Beyond Compare.

/Defect tracking

tool

Testing Skills Unit Testing, Data Validation, End to End validation

Crystal Reports Conducted organization level SAP Crystal reports

Trainer training's.

Training Undergone Tableau, Qlikview, Jasper Reports, Informatica

Domain Knowledge Healthcare Provider / Payer, Logistics, Insurance,

Banking and Finance, Supply Chain Management.

1

BI Project Experience:

Client : Transamerica, Cedar Rapids, IOWA. Apr-

2014 to Till Date

Project : Insurance Hedging

Role : Technical Lead for Business Objects / Crystal Reports

Tools : Crystal reports 2011, SAP Business objects Designer UDT IDT,

SAP Business Objects WEBI 4.0, IBM - Rational RequisitePro, Beyond

Compare, SQL server 2008, IBM DB2, Aqua Data Studio.

Project Description:

Prepare requirement document with the help of Actuaries. Design and

Develop universe and WEBI reports on top of Product additions Hartford, Vangaurd Oshare.

Responsibilities:

. Interacted with Business Users and Managers in gathering business

requirements.

. Worked as Onsite coordinator and Prepared business Requirement

Specification document by using IBM - Rational RequisitePro tool and

managed track on requirement changes.

. Involved in the designing and Building of Universes.

. Set up Universe level conditions to restrict data based on report

requirements.

. Developed and created classes with Dimension, Detail & Measure

objects.

. Strong work experience in Data validation by developing complex

queries and PL-SQL.

. Created stored procedures to validate Derived tables data loads also

worked on DB2 database to validate end to end data validation.

. Prepared test cases to validate the changes in System by using complex

SQL queries and SQL automated validation test queries.

. Created WEBI reports & Crystal reports and deployed them through BI

Launch Pad.

Client : CitiGroup Oct-13 to

Apr-2014

Project : Conversion of Reports from Oracle BI Publisher to WEBI

Role : Technical Lead for Business Objects / Crystal Reports

Tools : Crystal reports 2011, Designer 3.1 R2, WEBI 3.1 R2, SQL server

2008, Oracle BI Publisher

Responsibilities:

. Work experience to create unique reports like User runtime Column

selection in reports.

. Analyzed BI Publisher reports and prepared analysis document of 103

existing reports.

. Designed universe by using STORED procedure on common reports sharing

same SP's.

. Prepared feasibility checks for all reports by creating sample

reports.

. Created WEBI reports and Crystal reports on Universe by passing

parameters.

. Created bursting queries and designed BI Publisher report bursting

universe and test the results.

. Scheduled reports and checked the reports bursting output of reports.

Client : CitiGroup Aug-13 to Oct-

13

Project : Reports Conversion from OBIEE to Crystal reports and

WEBI

Role : Technical Lead for Business Objects / Crystal Reports

Tools : Crystal reports 2008, OBIEE 10, Universe Designer 3.1 R2,

WEBI 3.1 R2, SQL server 2008

Responsibilities:

. Work experience in Banking and Finance domain.

. Analyzed OBIEE reports and prepared analysis document of 70 existing

reports.

. Designed and built universe on top SQL server Database and Performed

Testing of reports.

. Involved in Building universe, Inserting tables, Detecting joins,

Detecting cardinalities and checked the integrity.

. Resolved loops and Traps using Contexts and Aliases while designing

Universes.

. Checked and compared the output format with OBIEE report output.

. Developed WEBI reports and Crystal reports on top of universe and test

the results.

. Worked on Pixel Perfect formatting of reports to insure each report

match with existing OBIEE reports.

. Created Open Documents reports as per Business requirement.

Client : Trizetto- Healthcare solution Provider / Payer products

in USA Feb-12 to Aug-13

Project : CVS MBEST WEBI Report development

Role : Technical Lead for Business Objects / Crystal Reports

Tools : Crystal Reports 2008, SAP Business Objects BI Launch Pad 4.0,

Central Management Console 4.0

Project Description:

Based on business requirement document shared by CVS, Design and develop

Universe and WEBI reports on top of FACETS HPXR data model.

Responsibilities:

. Analyzed Business requirement document provided by CVS and Prepared

Technical and functional document for CVS Caremark.

. Define methods and techniques for complex reports.

. Providing support during the QA phase and validating the functionality

of the reports.

. Design, Develop and Customize reports using the Business Objects

products including Web Intelligence and Universe designer on top of

HPXR data model.

. Involved in BO Administration activities like setting up user group,

maintaining server as well as utilizing the CMC for the error

evaluation and resolution.

. Database connectivity, Installation, Maintenance, Migration debugging

and fixing the issues.

. Scheduling reports in Business Objects, Infoview, assigning rights to

different users, and migrations of the reports.

. Assign work to team and ensure timely delivery with quality.

. Prepare estimate of tasks and share these estimates to Client.

. Managed weekly deliverables list and project status in WSR.

Client : Trizetto- Healthcare solution Provider products in USA

Sep -11 to Feb -12

Project : EyeMed Webi Report Development

Role : Business Objects / Crystal Reports Developer

Tools : Crystal Reports 2011, SAP Business Objects WEBI 3.1,

Designer XI, InfoView, Xcelsius 2008, QAAWS.

Project Description:

Prepare functional and technical document based on FACET's HPXR document

and develop reports by using WEB intelligence as per sample shared by

EyeMed.

Responsibilities:

. Developed Web Intelligence Reports based on Universe on top of HPXR

Data Model.

. Scheduling reports in Business Objects, Infoview, Assigning rights to

different users and Reports Migration.

. Created Dashboards using Xcelsius 2008 and QAAWS.

. Prepared Technical and functional document for Finance, Provider,

Claims.

. Prepared Unit Tests cases for developed reports also analyzed root

cause at universe side for data retrieval failed reports.

. Worked on Universe Object creation and Universe Object update.

Client : Allstate Insurance Jun-11

to Aug -11 Project : Encompass Reports rewriting,

Role : Business Objects/ Crystal Reports Developer

Tools : Crystal Reports 2008, SAP Business Objects Web Intelligence

XI, Oracle 11g

Project Description:

Insurance domain: Convert WEBI reports to Crystal reports to improve report

bursting time period (solution delivered with amazing results like report

bursting period reduced by 10 times).

Responsibilities:

. Report rewriting from WEBI to Crystal reports 2008 and Report Bursting

(Domain Insurance).

. Worked on Analysis of existing WEBI reports and Query generation for

command SQL in crystal reports.

. Worked on data analysis to ensure accuracy in report.

. Created the reports using Business Objects functionalities merged

Dimension.

. Created Standard Reports utilizing all the features on Web

Intelligence in BOE XI 3.1 like Optional Prompts, conditional

formatting, Alerters etc.

. Designed and developed crystal reports by using SQL referring existing

WEBI report.

. Completed conversion and testing of report bursting by using Command

SQL within defined timeframe.

. Worked on Central Management Console administration for User creation

and report bursting.

Client : Allstate Insurance FEB-11

to Jun-11

Project : Insurance reports development

Role : Business Objects/ Crystal Reports Developer

Tools : Crystal Reports 2008, Oracle 11g, Designer 3.1

Project Description:

Insurance domain: As per Functional and technical specification report

needs to be developed by using Command Level SQL.

Responsibilities:

. Implemented the Object-Level Security and Row-level security in

Universe. Implementing the Table Mapping in Universe to restrict

certain data in a table to only one group of users.

. Designed and developed reports by using crystal reports 2008.

. Worked on Data Security of users in reports and implementation report

data access as per organization hierarchy.

Client : CIMS - Healthcare Provider

Apr-10 to Feb-11

Project : HMS Implementation and MIS Module delivery

Role : Sr. Implementation Engineer, DBA, Report Developer

Tools : Crystal Reports XI, SQL Server 2005

Project Description:

Hospital Information System-MIS Reports development and Implementation:

Design and develop Reports as per client requirement at client location.

Responsibilities:

. Involved in full project life cycle implementation of reports

(requirements gathering to production phase).

. Understanding the business requirements and development of Crystal

reports.

. Exporting reports to different formats such as Excel, PDF, etc and

delivered to Business Users.

. Fixing bugs after testing reports.

. Efficient in Optimizing, Debugging and testing SQL queries, views and

stored procedures SQL Server.

. Involved in Requirement Gathering and Change request Documentation.

. Played role of Database Administrator and report developer at onsite.

. For Business Intelligence I have used PL -SQL to implement business

logic in form of Stored Procedure and designed reports by using

Crystal reports XI.

Client : Sun Logistics, Mumbai, India

Nov-09 to Jan-10

Project : Supply Chain Management Business Reports Development

Role : Implementation Engineer

Tools : Crystal Reports XI, SQL Server 2005

Project Description:

Supply Chain Management Business reports development and Implementation.

Responsibilities:

. Understanding the business requirements and development of Crystal

reports at onsite.

. Design pre-printed format of reports and ensure pixel perfect report

alignment.

. Created stored procedures and Functions to support report development

and enhance report performance.

. Worked on Data Validation of Reports.

Client : UHDE INDIA, Essar. Mar-08

to Nov-09

Project : Cyber intelligence Report development and implementation

Role : Report Developer

Tools : Crystal Reports, SQL Server 2005

Project Description:

Design, Develop reports and dashboards in Cyber-Intelligence module as per

requirement provided by client

Responsibilities:

. Designed and implemented complex Organization role level Dashboards.

. Worked on cross-tab and detail reports and represented the same as

line charts/ bar charts / pie charts of the same by using crystal

reports reporting tool.

. Worked on View, stored procedures, Functions, Queries creation,

implementation and Query optimization.

. Provided support to the development process to ensure the delivery of

documented requirements against agreed design.

. Worked on Business Process Excellence for Logistics operation by using

implementation of shipment alerts, Reports, Dashboards and Report

schedulers.

. Co-ordination with Clients PWC Auditor Team for financial year 08-09

Auditing.

. Involved in Change Management Process for enhancements of Post

Production Requests from business.

Personal Details:

Current Location (City, State): Cedar Rapids, IOWA, USA.

Skype ID: amol.patil189

Visa Type: H1B

Contact this candidate