Sql Server Sales
Resume:
Ravi C Yaralgadda
Sr. Business Objects Enterprise Consultant
****.****@*****.***
SUMMARY:
. IT professional with Eight years of experience in data warehousing
application development and well versed with the software development
life cycle.
. Expertise Reporting and Data Warehouse tools including Business Objects
XI 3.1/3.0/R2/6.x/5.x, Crystal Reports XI/10 and SAP BW 3.5
. Trained and certified professional in Business Objects Enterprise XI
. Designed/Built/Managed Universes, scheduled reports using Broadcast Agent
and also involved in the administration part as a CMC/Supervisor in
Business Objects.
. Created Reports in BO and WebI using Universe, Personal Data files, Free
Hand SQL and Stored Procedures.
. Having thorough knowledge of Crystal and Business Objects Architecture
with all modules in BO XIR2 and also experienced with a project in XiR2
(CMC, CMS, CCM, Infoview, Desktop Intelligence, Web Intelligence, Import
Wizard, and Report Conversion Tool)
. Installation and Configuration experience with Business Objects
Enterprise, Crystal Reports BI tools on Windows and UNIX platforms
. Extensively experienced in Creating repositories, folders, groups, users,
and assigning security to objects in BOE XI. Also have experience of
Administrator or general supervisor different environments.
. Experience in Migrating to BO XI R2/3.1 from previous versions (6.x and
5.x)
. Good knowledge in designing, creating, maintaining and analyzing Info-
Cubes, ODS objects, Remote Cubes, Multi Providers, Info-Sources, Extract
Structures, Update rules and Transfer rules.
. Complete knowledge of Business Objects reports XI for creating highly
formatted canned reports.
. Experience with different report delivery mechanisms like BOE tools and
Third party tools like Infoburst.
. Experience in coding and managing reports with VB Macros for Full Client
reports.
. Extensively used PL/SQL in writing Stored Procedures, Functions and
Triggers
. Knowledge in databases like SQL Server 2000, SQL Server 2005, DB2, Oracle
9i, and MS Access have helped me work with different sectors in the
industry.
. Well versed in universe designing, report writing, and maintenance of
various reports using Business Objects 5.x, 6.x, XI/XI R2/XI 3.1 and
Crystal reports XI.
. Capable of improving the Business Process, have shown signs of
Entrepreneurship, & Strategic project management. Exceptional technical,
liaison, and interpersonal skills have helped me taste success through
out my career.
TECHNICAL SKILLS:
OLAP/Reporting Tools: Business Objects 5.x/6.x, XI/XIR2, XI 3.1, Crystal
XI, Xcelsius 2008 4.5, SAP BW 3.5 and 7.x
Web Technologies: HTML, XML, ASP, JSP, VBScript, NetWeaver
ETL Tools: Business Objects Data Integrator, SAP BW.
Data Modeling: ERwin, MS Visio
RDBMS/Databases: SQL Server 2005/2000, Oracle 7.x/8.x/9.x,10g, DB2
Languages: PL/SQL, SQL, Java, J2EE, C, C# and Visual
Basic
Operating Systems: Windows 98/2000/NT/XP, UNIX (Sun Solaris)
Interfaces: ODBC, JDBC.
PROFESSIONAL EXPERIENCE:
Motorola, San Diego CA
May 08 - Till Date
Sr. BI/Admin Consultant
Motorola is a global communications leader powered by a passion to invent
and an unceasing commitment to advancing the way the world connects. This
application is being developed to centralize the contract management
process. The Gencord DSS gets information from three different data sources
PIMS (Product Information Management System), CIMS (Customer Information
Management System) CCAS (Customer Contract Administrative System). This
Application provides data of the various products sales in US, and Reports
were generated on the various product groups, market share of Competitors
product in the product group.
Responsibilities:
. Interacted with Business Users to gather analyze and record requirement
specifications.
. Estimated the time and effort required to complete developmental tasks.
. Tested documents for design and data integrity with sample data before
user testing.
. Checked integrity of universes and resolving connections loops and traps.
. Resolved join problem in universe using contexts and aliases.
. Produced new Classes and user Objects in designing the Universes.
. Redesigned the Universe build with optimized classes and objects.
. Managed reports environment of 2000 canned reports that were scheduled
every month end.
. As part of the reporting team I was involved in managing and maintaining
these report deliveries every month.
. Ensured that the reports that were scheduled in the report delivery tool
called Infoburst are delivered timely.
. Closely worked with the client contacts in the company to define, develop
and implement complex Business Objects reports in Webi and Deski.
. As a team player provided periodical metrics about the performance and
work queue to the manager.
. Undertook exhaustive analysis to troubleshoot the complex production
problems that occurred after the BO XI migration from previous version.
. Coordinate report development projects internal users and Partners to
gather requirements and report specifications, design and formatting,
testing/validation, technical and procedural documentation.
. Troubleshoot problems, provide options, make recommendations and
facilitate resolution of issues with respect to reporting
projects/issues, whether data- or tool-oriented.
. Provide Support with modifications/enhancements to Universes to develop
efficient and accurate reporting.
. Create specialized reports and modify existing reports in Business
Objects Webi and Deski environments.
. Prepare ad-hoc reports and analyses using Webi for external users.
. Migrated the Users, Groups, Universes, Personal Folders, Connections,
Reports (Deski & Webi), Excel, Pdf and Instances to Production,
Development and Test Environments using Import Wizard from BO XI R2 to BO
XI 3.1 Environments.
. Set up the new security levels after migrating from XI R2 to XI 3.1 at
Group level, Folder level and also set up the security at object and row
level.
. Performed administrative tasks including creating folder and moving
reports and providing security to folders
. Monitored the scheduled jobs in InfoBurst and process and rescheduled
failed jobs and rectified issues when failed.
. Performed testing and prepared test cases for migrated reports from BO XI
R2 to BO XI 3.1
. Prepared comprehensive documentation during the report development
lifecycle.
Environment: Business Objects XI 3.1/XI R2, SQL Server 2005, Oracle 10g,
Business Objects Data Integrator, Windows
Cigna, Bloomfield, CT Mar 07 - Apr
08
Business Objects Admin/Developer
CIGNA Corporation is an investor-owned health service organization in the
United States. The Company's subsidiaries are providers of healthcare and
related benefits, the majority of which are offered through the workplace,
including healthcare products and service. . The key objective of the
project is to migrate and schedule reports and generate reports as per
business requirements. Trained end users with these models are generating
their own reports. Migration of universes and explaining the trained end
users to use these new models to develop reports was also a part of the
project.
Responsibilities:
. Worked on BOXI R2 for the Procedural, functional and enhanced features of
BOXI R2 & dealt with BOXI R2: CMC, Designer, Desktop Intelligence, and
WEBI.
. Setting security for folders and categories
. Designed and developed application security model and implemented
security
. Migrated Universes and Reports from BO 6.5 to BOXI R2.
. Converted Full Client reports to Web Intelligence Reports, using
Conversion Tool and run them successfully upon refreshing.
. Validated all reports converted to BOXI R2 for Consistency of Data and
Discrepancies, and enhanced them as per the User Requirements.
. Handled Exceptional Errors and Interacted with Business Objects Tech
Support in various Occasions and resolved issues over Web Intelligence.
. Created the Audits for Failed and Partly Converted Reports during the
Conversion to Web Intelligence Reports.
. Created BOXI R2 Universes and Reports based on requirements gathered from
the end user and working closely with the database architect.
. Extensively used BO & Webi reporting functionality such as Slice and
Dice, Sorting, Hierarchies, Drill Down, Drill up, Filter, Calculation,
Report Layout, Prompts, Tabular, Cross-Tabular, Bar-Chart reports,
Aggregates, formatting.
. Exported Business Objects reports to Webi to be published on the
Intranet. Created thin client reports through Info View.
. Wrote PL/SQL, Stored Procedures, and Database Triggers for enforcing
business rules and integrity constraints.
. Created various standard reports and queries based on the existing
classes/objects. Exported reports to Excel based on the user
requirements.
. I was involved in Full lifecycle of BOBJ migration from end to end
.
Environment: Business Objects XI R2, 6.5, Windows 2003 server, UNIX - SUN
Solaris
Nextel Wireless, Reston, VA
Dec 05 - Feb 07
Business Objects Consultant
The Company owns and operates the third largest wireless telecommunication
network in United States, with 48 million customers. It is one of the
leading service providers that deliver the communication capabilities to
the clients and customers. . The company chose Business Objects and Web
Intelligence along with Oracle's OPM, to gain control of their procurement
processes. Business Objects solutions provide users with powerful and easy-
to-use reporting functionalities, with the added benefit of being highly
scalable.
Responsibilities:
. Developed universes and reports in Business Objects 5.1.7 environment
. Involved on testing migrated reports in Business Objects Deski and Webi
reports from BO 5.1.7 to XI R2.
. Created and updated universes using Designer in Business Objects XIR2
based on the reporting requirements
. Developed different types of standard reports with drilling capabilities
in tables, cross-tab and charts with complex calculation, and multiple
data provider's in both Full Client and Web Intelligence environments
. Created Schedule task and distributed to end users for period-end and
special request reports.
. Developed reports with VB Macros to pass parameters while the report is
scheduled and automatically email to end users as agnostic document.
. Perform Audit function for user activity statistics and monitoring the
environment
. Applied and corrected variable context corrections for reports in Deski.
. Worked on changes to existing Webi reports according to XI R2 in
compatibility to existing reporting environment.
. Applied changes to existing Webi reports by performing formatting and
other changes.
. Trained end users in using application and report development.
. Created Technical and Design Documents, Test Consideration Documents, Run
documents for new Reports and universes.
. Performed report data integrity check through running the query against
SQL Server using SQL Server Management Studio.
. Performed extensive Report Testing includes UAT and Regression testing.
. Prepared test cases for migrated and tested reports.
Environment: Business Objects XI R2, 5.1.7, Crystal Reports XI, SQL Server
2005, VB Macros, MS Office, Windows
State Farm Insurance, Bloomington, IL
Jul'04-Nov'05
Business Objects Analyst/ Developer
Leading Financial Institution offering competitive Auto Insurance and
related Financial services through agents, financial institutions and
broker dealers.
Responsibilities:
. Involved in creation of Universes, Classes, Objects and Hierarchies for
multi dimensional analysis of database using Business Objects 5.1 for
technical and sales departments
. Created master detail reports using drill up and drill down
functionalities
. Monitored BCA and Web Intelligence servers
. Built Powerful Queries by creating and applying complex conditions and
sorts, User Objects, LOV's, Combined Queries, Free Hand SQL and
Semantically dynamic calculations using context method
. Worked extensively with @functions including @aggregate aware, select,
prompts and @where to overcome database integration issues.
. Organized data in the reports by using Filters, Sorting, Ranking and
highlighted data with Alerter. Extensively used Supervisor Module for
Managing user groups and users
. Scheduled reports on daily/weekly/monthly basis using Broadcast agent
. Used SQL against the database to check retrieved data integrity
. Exported universes to the repository for making resources available to
users
. Was actively involved in planning, documentation and administrative tasks
. Developed 12 reports over a 3 week deadline.
. Setup Application Foundation operational metrics and analytics for
marketing decision analysts
. Installed and configured Business Objects 6.5 as a POC project.
Environment: BO 5.1, 6.5, SQL Server 2000, MS Access Windows 2000.
Walt Disney, NY
Jan 03- Jun 04
Business Objects Developer
Walt Disney World merchandising is one of the largest merchandising
industries in the world. The objective of this project is developing
reports based on Single Integrated Merchandising Business Application
(SIMBA) which has been integrated with RMS (oracle retail management
system) and WMS. The reports were developed for store operations finance
inventory control forecasting.
Responsibilities:
. Designed developed and managed Universes in the Designer for report
generation.
. Analyzed and defined requirement analysis for Business Objects Reporting.
. Defined Aliases and Contexts to resolve the join problem in the Universe.
. Defined multiple contexts to resolve Chasm Traps.
. Created New classes & User Objects in designing the Universes,
Importing/Exporting the Universe from/to repository to make it accessible
to end users
. Created User conditions, Filters to improve report generation &
readability of report and displayed the summary of data by creating
Charts.
. Created Hierarchies and predefined conditions using Business Objects.
. Extensively used Calculations, Variables, Break points, and Sorted
inputs, Drill down, Slice and Dice, Alerts for creating Business Objects
reports.
. Involved in creating Various Reports by extracting data from Data Marts
like Sales of Power Supplies, Marketing Details, Production Details,
Incoming Product Details and Rejections.
. Generated Reports based on time like Year, Quarter, Month, Week based on
Geographic and Comparative reports.
. Used Broadcast Agent Publisher, which enables distribution of information
via email using an easy-to-use, subscription-based mechanism.
. Customized the Info View using WebI SDK, published reports using Info
view, and trained users for ad hoc reporting.
. Created reports using Oracle database and personal data file providers.
. Planned coordinated and executed Business Objects 5.x deployment for End-
users and documented the entire project.
. Involved in installing BO, Creating Repository, Users, and User Groups
and prioritizing Security Levels for Users and User Groups.
. The data consisted of various dimensions like customer, vendor, billing,
different (BOM'S) Bill of Materials, operational planning, sales, and
production.
Environment: Business Objects 5.x, Oracle 7.x/8.x, SQL Server 2000, Windows
2000/NT
Canvas InfoTech LTD, India Jun 02 -
Dec 02
Programmer
This Application deals with various functions of the Manufacturing
Organization, which produces Material Handling equipment's such as Screw
Conveyors, Elevators, Rotary Airlocks, which are used to transfer the
materials from one place to another.
Responsibilities:
. I was involved in development of the System and testing and
implementation of the system.
. Was also involved in the preparation of user interface.
. Involved in writing Procedures, Functions and Triggers at form level and
block level.
. Responsible for Stock Module, which maintains the stocks, issues and
returns of the materials used in the projects.
Environment: Oracle, SQL Server 2000, Windows NT
EDUCATION
. Bachelors Degree in Engineering
Contact this candidate