Developer Sales
Resume:
Ravindar Pittala
Sr. Business Objects Developer
EXPERIENCE SUMMARY
• 7 years of IT experience in designing and developing SAP Business Objects Reporting Applications
(Info view, Designer, Web Intelligence, Import-Export Wizard, Upgrade Manager Tool,
Scheduling, and Publication), BO Admin and Crystal Reports XI.
• Implemented full life cycle implementations for different modules in Data ware house which
involves Requirement gathering, analysis, Technical document design, Reporting, Testing, End user
documentation, Production support
• Designing, developing and deploying using Universe designer, web intelligence, desktop
intelligence, info view and CMC
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal
Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub
reports.
• Created different type of interactive reports including Cross tab, Conditional, Drill down, Top N,
Summary and Sub reports with interactive Bar charts, pie chart and line chart.
• Expertise in dimensional data modeling, Star Schema Modeling, fact and dimensional table design,
physical and logical data modeling.
• Experienced with OLAP functionalities like Scope of Analysis and Drill Analysis.
• Working experience in using SQL Server 2005/2008, Oracle 9i/10g, SQL Plus and PL/SQL.
• Experience in Working @ client location and interacting with client/business users
• Involved in requirement gathering, Tech spec document design, Report development, Testing,
writing the test log documents
• Extraction, Reporting knowledge in Health care, Finance Modules
• Experience in working with ‘Facets’ data model – Health care provider.
• Leading offshore resources and working as onsite coordinator
• Defined BO classes, Objects, cardinalities, contexts, joins in universe and resolved loops in
universes using table aliases and contexts
• Involved in Tech spec document design
EDUCATIONAL QUALIFICATION
• Bachelor of Technology in Electronics & Communication Engineering from Jawaharlal Nehru
Technological University, INDIA 2005
TECHNICAL SKILLS
Business Intelligence SAP Business Objects XI R2/R3/4.0, Designer, Info view, Web intelligence, Desktop
intelligence, CMC, Crystal reports XI R2, Data Modeling
Oracle 9i/10g, MS SQL Server, Sybase
Database
Platforms Windows 2K/XP
DB GUI Client TOAD, SQL Developer, Interactive SQL
PROFESSIONAL EXPERIENCE
Project 6:
Eye Med EDW & TOPAZ BI Reporting May 2011 to till date
Employer: SYNTEL Consulting Inc, USA
Work Unit: Eye Med Vision Care, Mason, OH
The Trizetto Group, Denver, CO
Role: Senior SAP BOBJ Developer, BO Admin, Team Lead
Description: Eye Med has earned its place among the top vision benefits providers in the nation. Eye Med
delivers vision wellness with professional passion and convenient accessibility to care.
Topaz Shared Services, LLC, is a Delaware limited liability company; Blue Cross and Blue Shield of North
Carolina and Blue Cross and Blue Shield of Kansas City are its charter members. Topaz will provide key
business systems and processes for health insurance plans, including functions related to medical claims
processing, member enrollment and billing services.
Responsibilities:
Gathering requirements from Business Users to prepare functional specification and develop
•
technical Specification documents.
• Involving in full life cycle implementation, right from requirement gathering, blue printing,
development, testing, go live and post go live support.
• Held meetings with business users in order to gather business requirements and prepared business
blue print based on those requirements.
• Requirement gathering and developing the reports.
• Leading the offshore team and creating reports for various portfolios.
• Maintaining developed universes and developing reports as per client requirement.
• Creating different groups in CMC and defined access levels as per the requirement.
• Defining joins in universe and creating new objects.
• Implementing security on Universe by creating row level restrictions and assign with the appropriate
Groups
• Environment backups and migrating universes and reports from development to Production
Extensively using Business Objects reporting functionalities such as Master Detailed, Drilling
•
concepts, Breaks, Filters, Ranking, Sections and Graphs.
Granting permissions and authorizations to the reports users using Business Objects
•
Enterprise Server.
Resolved ‘Chasm Trap’ and ‘Fan Trap’ path Problems and loops by creating Context and
•
Aliases.
Designing and developed Universes by defining Joins, Cardinalities between tables
•
Developing cross tab reports for summarizing huge amounts of monthly and yearly data.
•
Involving in unit testing and data validation of reports using TOAD for Oracle.
•
Designing and developed Test Scenarios, Test procedures, Test Cases, and Test Data according
•
to business requirements
• Scheduling reports using Info view
• Migrated Reports and Universes from BO 3.1 to 4.0 using Upgrade Manager Tool
• Creating Facets Membership, Claims, Provider and Finance Reports in webi and Crystal
• Writing SQL queries and using in command objects to design crystal reports for TOPAZ
Environment: SAP Business Objects XI R3/4.0, Crystal Reports XI, web intelligence, Designer, CMC,
Oracle 10g, TOAD
Project 5:
Advance Insurance Company of Kansas September 2010 to April 2011
Employer: SYNTEL LTD
Work Unit: SYNTEL LTD, PUNE, INDIA
Role: Team Lead Crystal reports
Description: Advance Insurance Company of Kansas (AICK) underwrites individual life, group life and
disability plans sold through Blue Cross and Blue Shield of Kansas (BCBSKS) sales representatives and
select brokers
Responsibilities:
• Requirement gathering from onsite and developing the reports
• Understanding client requirements and developing Crystal reports.
• Involved in supporting developed crystal reports. Modifying the old reports according to the new
requirement spec docs.
• Developed reports by creating command prompts
• Involved in supporting developed crystal reports. Modifying the old reports according to the new
requirement spec docs.
Developed cross tab reports for summarizing huge amounts of monthly and yearly data.
•
Extensively used multiple sub reports to present data in different formats.
•
• Created Parameterized reports to meet Business needs
Extensively used static and dynamic parameters to suit reporting needs to meet business
•
requirements.
• Implemented Formulas, Cross tab Reports etc using Crystal Reports
• Developed reports by creating command prompts
Environment: Crystal reports XI R2, MS SQL Server 2005
Project 4:
Love Lace Health Plan May 2010 to August 2010
Employer: SYNTEL LTD
Work Unit: SYNTEL LTD, PUNE, INDIA
Role: SAP BOBJ Developer
Responsibilities:
• Involved in Reporting
• Used universes as main source to developing reports
• Developed web intelligence reports for various subjects like membership, eligibility,
• Medicare, network mgt, provider, Claims
• Developed 75 webi reports
• Testing the reports across the query provided by onsite team.
Environment: SAP Business Objects XI R2, web intelligence, Sybase
Project 3:
MAGMA BI Implementation December 2009 to May 2010
Employer: Mind Source Consulting, Wipro InfoTech, INDIA
Work Unit: Magma Finance Corporation, Kolkata, INDIA
Role: Business Objects Developer, BO Admin
Description: MAGMA Finance Corporation is a Finance and Insurance company having head quartered at
Kolkata, India. Magma is having its branches allover India. Their main business is insurance with heavy
vehicles. The Enterprise Data warehouse is built based on various departments to support organization in
decision making on their business analysis. Reports are based Collection and Sales
Responsibilities:
• Involved in Reporting.
• Worked @ client location and interacting with client/business users time to time.
• Maintained developed universes and using them as source for developing reports.
• Implemented manages restrictions in the universe level as well as Managing users and user groups in
the CMC.
• Created reports for various portfolios using the Universes as the main data provider
• Effectively used BO functions like cross tab, master detail, sorts, alerter, drill methodology, Breaks,
etc.
• Frequently meeting the client to understand the requirements.
• Validating the Reports across the file outs given by the Client.
• Involving in Development, Testing, Maintenance as well as resolving problems during
implementation
• Involving in supporting the developed reports.
• Involved in writing the test log documents.
Environment: SAP Business Objects XI R3, Designer, Web Intelligence, CMC, Oracle 10g, TOAD
Project 2:
PSE (Property Solutions Enterprise) April 2008 to June 2009
Employer: DB Xento Systems
Work Unit: DB Xento Systems, PUNE, INDIA
Role: Business Objects developer
Description: Property Solutions International is our sister organization. Property Solutions is the largest
provider of apartment community web sites, property management tools to management companies in all
states in US and acts as a mediator for accommodation solutions i.e., plots buying, selling, lease, rent.
Data warehouse is built based on various departments to support organization in decision making on their
clients and business analysis. Various analysis reports are developed using BO tools like monthly reports,
weekly reports, and quarterly reports on their business needs.
Responsibilities:
• Involved in Universe design and Reporting.
• Worked towards optimal development of universes by removing loops through the use of aliases and
contexts
• Created Universe with number of Classes, many objects using inner/outer and equiv. joins as per
requirement.
• Used all the methodologies in the Universe designer like aliases, contexts, aggregate awareness,
derived tables
• Implemented manage restrictions in the universe level.
• Created reports for various portfolios.
• Effectively used BO functions like cross tab, master detail, sorts, alerter, drill methodology, breaks,
etc.,
• Involved in unit testing Reports
Environment: SAP Business Objects XI R2, Designer, Web Intelligence, Desktop intelligence, Oracle 9i,
TOAD
Project 1:
Pathmark Warehousing January 2007 to February 2008
Employer: DB Xento Systems
Work Unit: DB Xento Systems, PUNE, INDIA
Role: Business Objects developer
Description:
Pathmark is a leading seller for a variety of consumer goods with several Branches in US. The project is
implemented with the aim of analyzing & estimating the sales, trends over the time. The project includes
OLAP
Reports were generated for decision support to various departments of the company i.e., Finance, Sales and
Marketing departments.
Responsibilities:
• Produced various reports as per the requirement of client.
• Involved in supporting the developed reports
• Created the reports using universes as main data providers and using the Powerful business objects
functionality’s like @ functions, user response and formulae’s
• Created different types of reports like Master/Detail, Cross Tab and Chart
• Used Analyzer and Explorer to view reports from different prospect by using Slice and Dice and
Drill down
Environment: SAP Business Objects XI R2, BO Designer, Web Intelligence, Oracle 9i
Personal Details:
Name: Ravindar Pittala
Mobile: 318-***-****
Email Id: ******@*****.***
Location: Denver, CO
Visa Type: H1
References:
Can provide upon request
Contact this candidate