LAVTE PAWAN

PROFESSIONAL SUMMARY

**+ Years of experience in the field of Information Technology with an

emphasis on Business Intelligence concepts like Data Reporting, Data

Analysis, Design, Development, Data Migration, Implementation and Testing

of Database/ Data Warehousing applications using Data Modeling, ETL and

Reporting tools.

. Expertise in SAP Business Objects Enterprise products (Universe Designer,

InfoView, Web Intelligence, Desktop Intelligence, Supervisor, Broadcast

Agent, Central Management Console, Central Management Server, Crystal

Reports and ZABO installation)

. Worked on various development platforms Windows NT 4.0/2000/98/95 and

RDBMS like Oracle 10g/9i/8.x/7.x, SQL Server 2005/2008.

. Managed and delivered large and complex assignments within time/cost and

service level parameters.

. Experience in building Business Objects Universes, Free Hand SQL methods

and creating complex canned and ad-hoc reports using SAP Business Objects

reporting application like Web Intelligence / Desktop Intelligence

. Strong expertise in creating reports using the Business objects

functionalities like Prompts, Hierarchies, Slice and Dice, Drill Mode,

Filtering. Have working experience with Static, Dynamic and Cascading

prompts accompanied with a good grasp on sub-reports, Cross Tab Reports

and Reports with Charts.

. Experience designing universes (SAP Business Objects XI R2/R3/3.1) using

Designer

. Working experience of Oracle/SQL Server/MS-Access and strong SQL skills.

. Used CMC (Central Management Console) for user management, content

management, and server management tasks and CCM (Central Configuration

Manager) to manage local and remote servers.

. Proficient in translating report requirements into detailed report

specifications, confirm report design with business users and creating

reports using SAP Business Objects XI R2/R3, 6.5.1

. Experience in migration of Business objects 6.5. To XI R2 using Import

Wizard and worked with business groups in migrating Universes, Deski/Webi

reports.

. Good knowledge of Xcelsius Dashboard concepts using 2008/4.5 / SAP

Business Objects XI 3.0 / 3.1

. Good understanding of Star Schema, Snowflake modeling for Business

Objects Universe from Dimensional data mart / data warehouse.

. Good working experience with SQL Server 2005/2008, SSIS (SQL Server

Integration Services), SSRS (SQL Server Reporting Services)

. Possess SharePoint knowledge, up-down loading and maintaining documents

on shared site.

. Prioritizing delivery of multiple reporting requests to internal and

external requestors

. Extensive experience interacting with Functional & Business Analyst,

Department Managers and different levels of users and developers.

Involved in Business and functional requirement gatherings with the

business for various projects.

. Excellent communication interpersonal and analytical skills to bridge

Client Interaction and Team Management. Has a strong ability to perform

as part of a team.

TECHNICAL SKILLS & STRENGTHS

BI Tools: SAP Business Objects XI 4.0, BOXI 3.1, BO 6.5.1 (CMC, CCM,

Designer, Reporter, Desktop Intelligence, Supervisor,

Web Intelligence, Broadcast Agent, Info View),

Crystal Reports XI, Cognos 8.4 (Query Studio, Report Studio),

Xcelsius 2008/4.5 Dashboard

Databases: Oracle 11g/10g/9i/8i/8.0, SQL Server 2005/2008, MS Access

98/2000/2003.

Applications & IDE: Business Intelligence Development Studio, MS Office

Languages: Visual Basic 5.0/6.0, SQL, PL/SQL, SQL Loader, T-SQL, Toad

9.1

ETL Tools: BODS (Business Objects Data Services, DTS, Informatica

Power Centre, MS- SSIS

Data Modeling Tools: ERWin 4.0

Platforms: MS Windows 2000/NT/98/XP, Windows 2000/2003/2007 Server,

UNIX.

ACADEMIC QUALIFICATIONS

. M.S. in Information Technology/Project Management (2006, Spring).

Colorado Technical University, Denver, Colorado. G.P.A.: 4.00

. B.S. (MPC) (Year - 1998). Osmania University, Hyderabad, India.

G.P.A.: 3.26

WORK EXPERIENCE

Banco Popular North America, Rosemont, IL

July 2013 - Till Date

Sr. Business Objects Developer

Banco Popular is a financial services conglomerate that has been operating

in Puerto Rico for almost 120 years and in the United States for over 52

years. It is one of the top banks by both Assets and Deposits in Puerto

Rico and ranks 33rd by assets among U.S. banks. It was first established in

U.S. in 1961 and provides full-service financial services to its customers

in about 90 branches in five states. It is a rapidly growing bank which

continues to grow its core banking services across U.S.

Work Description:

. Provide support to end users in creating new Webi based reports. Used

functionalities like drill down, breaks, sorting, filtering, alerters

and sections. Reports were based off multiple data providers

. Support users with enhancements/improvements to the existing fleet of

Webi reports

. Created reports containing several blocks and graphs in the same tab

in either tabular or cross-tab layouts

. Worked with ETL team to develop/enhance the new/existing mappings to

develop processes based on user needs.

. Tuned reports to optimize the run-time by adding indexes to the table

structures or by breaking the standard data provider into multiple

sets.

. Interacted with Business Users in gathering requirements for new

reports and enhancements

. Documented the requirements and published it into the TPM portal

. Interact with business users to analyze and resolve data and

application issues

. Modified existing reports developed in Crystal Reports XI as per the

user requirement and migrated to Crystal Reports Enterprise.

. Enhanced existing reports with parameters, sub-reports by using

Crystal Reports XI.

. Installed Crystal Enterprise and Published reports on Crystal

Enterprise Server and got involved in Crystal Enterprise

administration.

. Experience in Scheduling the Reports using Crystal Enterprise

solution.

. Published Reports in Crystal Enterprise via Crystal Publishing Wizard

and Crystal Management Console.

Environment: Windows 7, Oracle 11g, SAP Business Objects XI 4.0 (CMC, UDT,

Webi Rich Client, InfoView), Business Objects Data Services, Crystal

Reports XI.

WMS Gaming Inc., Waukegan, IL

Nov 2012 - June 2013

Sr. Business Objects Developer

WMS Gaming Inc., is a manufacturer of slot machines, video lottery

terminals and software (theme based) to help casinos manage their gaming

operations. Based in Waukegan, IL, the company has been a leader in

interactive entertainment since its journey into the casino gaming

industry. Through its online interactive business, the company is also

developing products, services and end-to-end solutions that address global

online wagering, casual, social and mobile gaming opportunities. It is now

a leading supplier of gaming products and enabling technologies to casinos

worldwide.

Work Description:

. Built 2 universes as per business specifications by leveraging the DW

tables for canned and ad hoc reporting needs for the Sales/Order

Management and Cost Management team.

. Defined Cardinalities and created Aliases and Contexts for resolving

Loops in the universe. Used BO functions like @Prompt, @Select,

@Variable and @Where using IDT tool. Performed Check Integrity checks

before migrating universes.

. Created Web Intelligence reports using Webi Rich Client. Used

functionalities like slice and dice, drill down, breaks, sorting,

filtering, alerters, and sections.

. Created complex reports containing several blocks in the same document

with multiple tabs, and graphs. Reports were displayed in either

tabular or cross-tab layouts.

. Created Webi reports with multiple data providers.

. Supported the existing fleet of Deski/Webi reports for enhancements

and improvements.

. Interacted extensively with the ETL team to develop/modify processes

based on the reporting needs of the users.

. Tuned reports to optimize the run-time by adding indexes to the table

structures or by breaking the standard data provider into multiple

sets.

. Interacted with Business Users in gathering requirements for new

reports and enhancements

. Documented the requirements and created functional design documents

. Interact with business users to analyze and resolve data and

application issues

. Worked with the Oracle apps team in understanding the underlying data

that acts as a source to the Data warehouse

Environment: Windows 7, Oracle 11g, SAP Business Objects XI 4.0 (CMC, UDT,

IDT, Webi Rich Client, InfoView), Xcelsius 2008, Toad, Business Objects

Data Services.

Abbott Laboratories, Waukegan, IL

March 2011 - August 2012

Sr. Business Objects Developer/Business Systems Analyst

Finance & OEC Systems group, a part of PPD IM&T department, supports the

business needs of the financial compliance group by reporting the PPD

HCP/HCO Spend to the Corporate Finance. The Spend is housed into StateSpend

Datamart which is a repository of PPD's spend on Healthcare Professionals

(HCPs) and Healthcare Organizations (HCOs). Data is collected from various

external/third-party vendors (TPV) as well as internal applications in

order to accurately reflect PPD's total spend on HCPs and HCOs. The

collected data gets passed from PPD to Complete Spend (corporate aggregate

spend).

Work Description:

. Built universes as per business specifications by leveraging the

Datamart tables for canned and ad hoc reporting needs for the

financial compliance team (FCT) stakeholders and users.

. Created Aliases and Contexts for resolving Loops and defined

Cardinalities in the universe and have embedded several BO functions

like Prompt, @Aggregate Aware, @Select, and @Where using Designer

tool. Performed Check Integrity on new and existing universes before

migration.

. Created Web Intelligence reports using Webi Rich Client. Used

functionalities like slice and dice, drill down, breaks, sorting,

filtering, alerters, and sections.

. Created complex reports containing statistical TPV data with multiple

tabs, and graphs. Reports were displayed in either chart, tabular or

cross-tab layouts.

. Created Webi reports with multiple data providers.

. Supported the existing fleet of Deski/Webi reports for enhancements

and improvements.

. Created Dynamic & customizable data visualization dashboards as POC

using Xcelsius 2008. Used QaaWS as data source and embedded Webi

reports into the Dashboards.

. Interacted extensively with the ETL team to develop/modify the

existing Datamart structure for reporting needs and to improve run-

time of the reports by adding indexes and hints.

. Interacted with Business Users and BSAs in gathering requirements for

new reports and extracts

. Worked directly with functional analysts and business users in

understanding their needs of the business in developing BI

functionalities or tools to meet their objectives/requirements

. Lead a team of developers and testers in supporting the day-to-day

enhancements and new developments

. Worked as SME to roll out the finished product (i.e.,

reports/applications) to the business users as part of new

initiatives, projects and product launches

. Interact with business users to analyze and resolve data and

application issues

. Worked with third party vendors (TPV) in resolving the data relate

issues.

. Support the business users with their operational needs - providing

data extracts, trouble shooting reporting issues and providing access

to the Datamart

. Support existing data warehouse reporting platform (SAP Business

Objects XI and IBM Cognos 8.4) and applications to ensure operational

availability and scalability

Environment: Windows XP, Windows 7, Oracle 11g, SAP Business Objects XI R3

(CMC, CMS, Designer, Desktop Intelligence, Web Intelligence), SQL Toad,

Informatica PowerCenter, SQL Loader, SQL Server 2008, SQL Server

Integration Services, UNIX Scripting, Cognos 8.4 (Query Studio, Report

Studio and Analytical Studio).

Abbott Laboratories, Waukegan, IL

January 2008 - February 2011

Sr. Business Objects Developer/Sr.Systems Analyst

MAT team, a part of the PPD IM&T department, supports the business

intelligence and analytic needs of the commercial sales operations by

providing them weekly, monthly and cumulative reports on product sales call

activity and call planning. These reports are crucial to the in-house and

field sales personnel to track on their sales, call activity and call

planning activities. MAT also supports in-house and field personnel with a

wide spectrum of other BI and analytical needs to meet their Adhoc

requirements.

Work Description:

. Built universes as per user requirements by identifying the required

tables from Data warehouse and by defining universe connections.

. Created Aliases and Contexts for resolving Loops and defined

Cardinalities on the tables from the database. Checked Integrity of

the universe using the Check Integrity function of the universe.

. Handled embedded functions like @Prompt, @Aggregate Aware, @Select,

@Where, and @Variable in the Designer to handle business requests for

canned and ad hoc reporting.

. Used Custom LOV's functionality in the Universe for performance

improvement on the Prompt values.

. Created Deski and Webi reports using Business Objects functionalities

like slice and dice, drill down, breaks, sorting, ranking, filtering,

alerters, and sections. Have also created complex reports for multiple

sales forces and franchises with various tabs, and graphs using

complex formulae's and VBA add-in. Reports were displayed in either

chart, tabular or cross-tab layouts.

. Designed reports with complex variables, multiple breaks, and sorts to

meet the user requirements. Created ad hoc reports per business

specifications.

. Created Dynamic & customizable data visualization dashboards using

Xcelsius 2008. Used QaaWS, Live Office and Designer (Universe) tools

to provide data as source to the dashboards.

. Sourced the Webi reports using Live office and QaaWS in Microsoft

excel and used Excel formulae to calculate/trim the data to feed into

the Xcelsius Dashboards.

. Deployed the universes, Webi reports and the dashboards from the local

machine to the development environment by recreating the Webi reports

and updating the connections in the dashboard.

. Used the Broadcast Agent console for auto scheduling of Business

Objects Documents.

. Involved in migrating Business Objects Universes and reports from

Version 6.5.1 to Version XI R2 using the Import Wizard and migrated

full-client reports to Web Intelligence reports using the Report

Conversion Utility.

. Interacted with the data warehouse team and suggested ideas to improve

the model of the database in order to fine-tune the SQL queries and

improve the performance of the reports at run-time.

. Interacted with Business Users and Business Systems Analysts in

gathering the requirements for new reports and extracts

. Lead a team of developers and testers in supporting the day-to-day

enhancements and new developments. Worked as SME (BO subject matter

expert) on various projects.

. Developed POC on Microsoft Business Intelligence stack for business

users to support their Ad-hoc needs.

Environment: Windows XP, Oracle 10g, SAP Business Objects XI R2 (CMC, CMS,

Designer, Desktop Intelligence, BO 6.5 (Reporter, Designer, Supervisor,

BCA), Web Intelligence, Xcelsius 2008, SQL Toad, Informatica PowerCenter,

SQL Loader, MS SQL Server 2005/2008, MS SQL Server Integration Services, MS

SQL Server Reporting Services, EQM Noad (version control tool).

KIP Technologies Inc., Chicago IL

June 06 - December 2007

B O Developer - Abbott Laboratories Waukegan, IL

KIP Technologies Inc. is an IT solution provider and provides IT based

services to external clients. It supports the IT needs to a large pool of

clients from across various industries that include Telecom,

Pharmaceuticals, insurance, aviation and other industries

Work Description:

. Interacted with the Users and Business Analysts to gather the

requirements.

. Involved in Installation and Configuration of all Components of

Business Objects.

. Designed new Universes and modified the existing Universes based on

the report requirements.

. Uses Designer Module to implement Universe, Joining the Tables, Create

Prompts and queries, parsing the Objects, apply Contexts and Alias to

remove cyclic dependencies.

. Assisted in synchronizing databases and in creating new schemas.

. Created, modified, and maintained complex Reports using Business

Objects Reports module that comprised multiple data providers. It also

involved creating complex queries and sub-queries within the same

report

. Tuned the queries to improve the Performance of the existing Reports

for various functional areas.

. Extensively used calculations, variables, filters, conditions, breaks,

sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts

and alerts for creating Business Objects Reports.

. Applied security features of Business Objects like report level &

object level security in the universe so as to make the sensitive data

secure.

. Involved in resolving the loops, fan traps, chasm traps using contexts

and aliases, checked the cardinalities, Integrity of the Universes.

Environment: Windows XP, Oracle 10g, BO 6.5 (Reporter, Designer,

Supervisor, BCA), SQL Toad, Informatica PowerCenter, SQL Loader, SQL

Server 2005, SQL Server Integration Services, SQL Server Reporting

Services, EQM Noad (version control tool).

Net Connect - Associate of HDFC Bank Ltd., Hyderabad, India

August 2002 till April 2004

Application Programmer/Analyst

HDFC Bank Ltd. is one of the largest private limited banks in India.

Designed the Banking Loan application using Visual Basic 5 (VB as front-

end, Oracle9i database and Windows 2003 OS). The system comprised of 12

Data Entry Screens with saving accounts and recurring modules. This

included intricate modules giving user to upload or download customer

information, explored data access using DAO Designed and generated reports

using Crystal Reports 6.0. Extensively used error-handling routines

. Development of automated banking management system for HDFC.

. Developed a well-defined graphical user interface for the client to

enter loan transactions using visual basic as front end with oracle 9i

database as backend.

. Developed many crystal reports to retrieve loan transaction data with

oracle 9i database as backend.

. Designed and created tables with Integrity constraints. Also created

packages, indexes, sequence, views, Export/Import Scripts

. Create custom design Views on user demand.

. Developed some of the complex SQL Loader Control Scripts to upload

data from MS-Excel sheets into oracle database.

HDFC Bank Ltd. - Consumer Loans Division, Hyderabad, India.

January 2002 to July 2002

Processing/Finance Executive

HDFC Bank Ltd. is one of the largest private limited banks in India. Worked

as Processing/Finance Executive which involved initiation, delegation,

processing and disbursements of the application. Consumer Loan

applications filled in by the consumers for availing different kinds of

loans is basically scrutinized by using market standards tools. The credit

history of each application is checked against various market agencies in

determining the financial capability of the prospective customer. The

strenuous and manual process involved in this scrutiny of applications

greatly demands attention, alertness, and proper co-ordination with

different vendors. Upon sanction, loan is disbursed to the customer and

proper documentation is maintained, which could be used for future loans.

. Consistent in sales goals each month at 90% (highest within the loans

division)

. Managed five-member sales team to serve large customers & dealers

. Consistently earn highest rating in customer service quality surveys

. Coordinated and responded to complex customer requests, resulting in

increased sales and customer satisfaction

. Closed the largest deal with a limited company for 101 vehicles (was

awarded top incentives with an increase in pay)

. Managing and satisfying the dealers with their requirements and others

needs like incentives, disbursements etc.

. Managing the day-to-day processing and disbursement of the customer

loans for clearance

Apex Advanced Technology Pvt. Ltd., Hyderabad, India.

January 2000 to September 2001

Data Analyst

Apex Advanced Technology (AAT) is an ITES facility of Apex Covantage (USA),

a prominent player in the ITES / BPO sector with over 25 years of

consistent growth and excellence. AAT, based at Hyderabad (India)

specializes in e-publishing, handling of document conversion in varied

formats (including XML, SGML), and Knowledge Process Outsourcing. Handled

responsibilities which involved analyzing and synthesizing data and content

pertaining to premier US companies. Carried out a lot of Web research to

write, review, edit and create online content, abstracts and briefs for our

clients.

. Handled the conversion process (textual to electronic) of

journals/magazines.

. Verifying the analyzed data as per the requirements of the clients

using Linux and other software

. Processing the verified data to check for errors/flaws and uploading

it into the client's storage devices

. Coordinated relationships with other teams, which helped standardize

procedures across all operating groups

. Lead a team of 5-7 data entry operators, who would feed the abstracts

and summary into the content management system

. Coordinated with business clients in understanding their requirements

and fulfilling the same by getting involved in the development process

. Was amongst the top 3 throughout the project operations on different

projects

Contact this candidate