SAP Business Objects
Resume:
DEEPTHI BOOSA
************@*******.***
Mobile: 845-***-****
SUMMARY:
> Around 7 years of professional experience in Business designing and
development and SAP Business Objects Reporting Applications.
> Expertise in gathering, analyzing and documenting business
requirements, functional requirements, and data specifications for SAP
Business Objects Universes and Reports.
> Experience in designing SAP Business Objects universes, generating
complex reports in Web Intelligence and Desk Intelligence.
> Data Modeling experience in analyzing, designing and modeling data
warehouses and star schema data marts for various business verticals
like Health Care (Pharmacy), and Financial.
> Good at Database Design, conceptual, logical and physical Data
Modeling, Star Schema, Snowflake; FACT and Dimensions tables, slowly
changing dimensions (SCDs).
> Good Knowledge on Business intelligence, OLAP, Dimensional modeling,
Star and Snowflake schema, extraction.
> Worked on migrating Business Objects from earlier versions to Version
XIR2. Extensively used the import wizard in moving reports and
universes from lover version of Bo to higher version like from 6.5 to
XI, XI R2 and XI 3.1.
> Good Experience in CMC, adding Users and Groups, Assigning Password
Security, Assigning Privileges to Documents and Universes.
> Designed, implemented and migrated complex Universes and Business
Objects Reports, Created classes, subclasses, objects, Cardinalities,
Conditions, Contexts, Joins, External Strategies, Prompts and Aliases
for resolving Loops and checked the Integrity of the Universes.
> An enthusiastic, project-oriented team player with leadership skills
and with an ability to develop creative solutions for challenging
client needs.
> Solid Experience in writing SQL queries, PL/SQL records & tables.
> Experience in resolving join path problems like Loops and Traps in the
universes using Aliases,
> Contexts, and Aggregate Awareness in SAP Business Objects Designer.
> Expertise in Development, Maintenance, Testing and Validation of the
data using Business objects Reports.
> Expertise in databases to include TERADATA, NETEZZA, Oracle 10g/9i, MS
SQL 2005/2000. Expertise in Universes for Customized Metrics and Goals
to Create Metric Analytics and Goal Analytics.
> Good Communication and Interpersonal skills. Technically sound, Result-
Oriented with strong Problem solving skills. Innovative & efficient
> Recommended standards of good practices of report development and
maintenance of universes.
> Flexible and versatile to adapt to any new environment with a strong
desire to keep pace with latest technologies.
> Modified the existing universes for performance tuning and maintained
common dimensions across all the universes with unique naming as a
part of clean up activity.
> Expertise in Universes for Customized Metrics and Goals to Create
Metric Analytics and Goal Analytics.
> Proficient in design, development, coding, implementation and Support.
> Excellent Written, Analytical communication and strong interpersonal
skills with ability to interact with end-users, managers and technical
personnel.
TECHNICAL SKILLS:
Business Objects 4.0, IDT, XI 3.1(R3.1)/R2, SIA, Central
OLAP Tools Management Console, Central Configuration Manager, Designer,
Desktop Intelligence, Web intelligence, Webi Rich client,
Report Conversion Tool.
RDBMS TERADATA, NETEZZA, Oracle 10g/9i, SQL Server 2000/2005.
Languages C, C++, PL/SQL, SQL.
Operating MS-DOS, Windows 2003/XP/NT/2000.
System
Microsoft Office tools namely Access, Excel, Outlook,
Software PowerPoint and Word, SAP related to Business Warehouse and
Skills very good knowledge on Business Objects.
PROFESSIONAL EXPERIENCE
Ford Motor Company
Nov
2013 - Jun 2014
Sr. SAP Business Objects Consultant
Ford Motor Company, a global automotive industry leader based in Dearborn,
Mich., manufactures or distributes automobiles across six continents. With
about 172,000 employees and 65 plants worldwide, the company's automotive
brands include Ford and Lincoln. The company provides financial services
through Ford Motor Credit Company.
Responsibilities:
> Analyze User requirements, compare between the old and the new
requirements, document the results, and communicate gaps and possible
issues to the relevant groups.
> Also, interacted with Business Users and Business Analysts to gather
the Business Requirements and translated them into Reporting
Requirements to be used as an Input in Designing Universes and
Reports.
> Maintaining a team of four people and directly interacting with USA
client through WebEx or calls.
> Validate Screen Technical specifications with technical designs
created by IT developers.
> Handled regular deployment issues across Dev, Prod and Test
environments.
> Created new Ad-hoc Reports using Desktop and Web Intelligence.
> Provide technical and analytical support of systems analysis and
design, development, implementation, production support, maintenance,
enhancement and troubleshooting.
> Review all system work before applications are incorporated into
production.
> Create and maintain documentation on Universe and SAP Business Objects
deliverables.
> Implemented Data warehousing schemas like Star-Schema, Snow-Flake
Schema.
> Involved in the designing and Building of Universes, Classes and
objects
> Resolved loops and Traps using Contexts and Aliases while designing
Universes.
> Set up Universe level conditions to restrict data based on report
requirements.
> Developed and created classes with Dimension, Detail & Measure objects
and Developed Custom hierarchies to support drill down reports
> Created Derived tables in the Designer to enhance the capabilities and
performance of the universe
> Customized Universe level Prompts as per Functional Requirements.
> Check the integrity of the Universes, and export the universes to
Repository for making available to users.
> The project involved in the development of reports using Business
Objects Web Intelligence to cater Ad-hoc reporting needs.
> Created reports using Business Objects functionality's like Queries,
Drill Down, Cross Tab, Master Detail and Formulae's.
> Created the reports using Business Objects functionalities like
Combined Queries, Drill down, Cross tab, Master detail and Formulae.
> Created Standard Reports utilizing all the features on Web
Intelligence in BOE XI 3.1 like Optional Prompts, Functions, Alerters
etc.
> Created Breaks, Filters at Different Levels of the reports and applied
ranking in the Webi reports.
> Extensively worked with formatting the reports according to the user
requirements.
> Used Web intelligence to create, edit and set different options for
the corporate documents.
> Worked with multiple data providers and linked these data providers
based on the requirements.
> Involved in creation of hierarchies and linking Universes (Linked).
> Prepare technical specification documentation.
> Involved in performance tuning and optimization on Business objects
reports.
> Created Report Templates for consistency in the look and feel of the
reports.
> Exported Reports to the Repository for making resources available to
the users.
Environment: Business Objects XIR3.1 SP3, Info View, Universe Designer, Web
Intelligence, Desktop Intelligence, CMC, TERADATA and Oracle 10.
CSC
Apr 2012 - Nov 2012
Sr. SAP Business Objects Developer
CSC is a global IT services company. Our people do amazing things to help
businesses, government and communities solve their toughest challenges.
Learn more about the industries we serve, our solutions portfolio, where
we're located and what makes CSC different from other technology companies.
CSC is a global leader of next-generation information technology
(IT) services and solutions. Our mission is to enable superior returns on
clients' technology investments through best-in-class industry solutions,
domain expertise and global scale. CSC's Corporate Responsibility program
fosters our company's growth by promoting and increasing the value of CSC
to our shareholders, clients, communities and employees.
Responsibilities:
> Create, develop and maintain critical Universe from scrap and
analyze User requirements, compare between the old and the new
requirements, document the results, and communicate gaps and
possible issues to the relevant groups.
> Creating Universes with NETEZZA database with background of ORACLE
and DB2 universes, gathering and comparing the information as per
the required.
> Also, interacted with Business Users and Business Analysts to
gather the Business Requirements and translated them into Reporting
Requirements to be used as an Input in Designing.
> Prepare technical specification documentation.
> Validate Screen Technical specifications with technical designs
created by IT developers.
> Handled regular deployment issues across Dev, Prod and Test
environments.
> Created new Ad-hoc Reports using Desktop and Web Intelligence.
> Provide technical and analytical support of systems analysis and
design, development, implementation, production support,
maintenance, enhancement and troubleshooting.
> Created universes, classes, objects, Prompts, Predefined
conditions, by retrieving the data from data sources and defining
the necessary connections.
> Involved in the troubleshooting of universe schema with loops,
chasm and fan traps, and cardinality problems.
> 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 extensive Business Objects reports like
Simple, Complex, Cross Tab using multiple Queries, Prompts,
combination chart and tables.
> Created, maintained and modified the business critical reports
using the Web Intelligence.
> Created Standard Reports utilizing all the features on Web
Intelligence in BOE XI 3.1 like Optional Prompts, Functions,
Alerters etc.
> Created complex reports using Merged Dimension and multiple data
providers and synchronized the data providers by linking the common
objects to create the common report.
> Review all system work before applications are incorporated into
production.
> Create and maintain documentation on Universe and SAP Business
Objects deliverables.
> Worked with multiple data providers and linked these data providers
based on the requirements.
> Involved in performance tuning and optimization on Business objects
reports.
Environment: Business Objects XIR3.0 SP3, Info View, Universe Designer, Web
Intelligence, Desktop Intelligence, CMC, NETEZZA, DB2 and
Oracle 10.
Department Of Workforce Development (State of Wisconsin)
Jan 2011 - Mar 2012
Sr. SAP Business Objects Consultant
Workforce development is an American economic development approach that
attempts to enhance a region's economic stability and prosperity by
focusing on people rather than businesses. It is essentially a human
resources strategy. Workforce development has evolved from a problem-
focused approach, addressing issues such as low-skilled workers or the need
for more employees in a particular industry, to a holistic approach
considering participants' many barriers and the overall needs of the
region. Today workforce development often is seen as a solution to issues
of social equity. One example is New York's Workforce Development Institute
(WDI) which sponsors programs for disadvantaged workers and funds the NYS
Apollo Alliance to bring social activists, businesses, organized labor, and
educator's together to address energy and environmental justice concerns.
Responsibilities:
> Analyze User requirements, compare between the old and the new
requirements, document the results, and communicate gaps and
possible issues to the relevant groups.
> Interacted with Business Users and Business Analysts to gather the
Business Requirements and translated them into Reporting
Requirements to be used as an Input in Designing Universes and
Reports.
> As a part of Universe development, created Classes, different kinds
of objects, cardinalities, Strategies, resolving loops using
Aliases and Contexts.
> Implemented Default & Custom Hierarchies, conditions on Lov,
Derived tables and @functions.
> Troubleshooting support tickets for operational issues
> Building improvements in Monitoring
> Managing security
> Working through a root/cause analysis and following up on action
items
> Applying patches and upgrades as necessary
> Managing Promotions of reports through the Development, Test,
Production process
> Performing as a member on projects where Business Objects
infrastructure expertise is required.
> Created new Universes in XIR3 right from scratch.
> Converting more than 400 reports from Desktop Intelligence to Web
Intelligence in BOXIR3.
> Create new Ad-hoc Reports using Desktop and Web Intelligence.
> Involved in Training and Educating regarding the Business Objects
XIR3 Capabilities, Navigation specific information and importance
of moving to Web Intelligence from Desktop Intelligence.
> Work on hierarchies, Global filters and Universe filters.
> Involved in support for fixing the bugs reported from System and
UAT test.
> Interacted with the users to analyze the changes for improvement
they needed in existing reports, and developed the reports to
satisfy their needs and requirements.
> Involved in performance tuning and optimization on Business objects
reports.
> Created Report Templates for consistency in the look and feel of
the reports.
> Exported Reports to the Repository for making resources available
to the users.
> Publish and schedule Business object Reports to users using
Publication.
> Tuning the queries to improve the performance of the report refresh
time.
> Work closely with DBAs to create aggregate tables to support
Universes and dashboard.
Environment: Business Objects XIR3.1 SP3, Info View, Universe Designer, Web
Intelligence, Desktop Intelligence, CMC, Oracle 10.
ST. Jude Medical
August 2010 - January 2011
Business Analyst and Sr. SAP Business Objects Developer
St. Jude Medical develops medical technology and services that focus on
putting more control into the hands of those who treat cardiac,
neurological and chronic pain patients worldwide. The company is dedicated
to advancing the practice of medicine by reducing risk wherever possible
and contributing to successful outcomes for every patient. The St. Jude
Medical product portfolio includes implantable cardioverter defibrillators
(ICDs), cardiac resynchronization therapy (CRT) devices, pacemakers,
electrophysiology catheters, mapping and visualization systems, vascular
closure devices, heart valve replacement and repair products, spinal cord
stimulation and deep brain stimulation devices.
Responsibilities:
> Analyze User requirements, compare between the old and the new
requirements, document the results, and communicate gaps and
possible issues to the relevant groups.
> Also, interacted with Business Users and Business Analysts to
gather the Business Requirements and translated them into Reporting
Requirements to be used as an Input in Designing Universes and
Reports.
> Prepare technical specification documentation.
> Validate Screen Technical specifications with technical designs
created by IT developers.
> Handled regular deployment issues across Dev, Prod and Test
environments.
> Created new Ad-hoc Reports using Desktop and Web Intelligence.
> Provide technical and analytical support of systems analysis and
design, development, implementation, production support,
maintenance, enhancement and troubleshooting.
> Review all system work before applications are incorporated into
production.
> Create and maintain documentation on Universe and SAP Business
Objects deliverables.
> Worked with multiple data providers and linked these data providers
based on the requirements.
> Developed queries, Stored Procedures Using SQL programming to
improve the performance of the Reports using complex queries.
> Created financial reports, charts using Universes as the main data
provider. Reports such as Quarterly variance, Regional, Actual vs.
Forecast, Balance sheets etc were developed.
> Developed Summary/Detail/Drill Down reports and some of the reports
include Inventory Details, Pending Charges, Storage Charges,
Customer Invoices, Print Tickets and G/L Postings and were
generated daily, weekly and monthly basis.
> Developed Scorecards report and also Deski reports with free hand
sql.
> Involved in performance tuning and optimization on Business objects
reports.
> Created Report Templates for consistency in the look and feel of
the reports.
> Exported Reports to the Repository for making resources available
to the users.
Environment: Business Objects XIR3, Info View, Universe Designer, Web
Intelligence, Desktop Intelligence, CMC, SQL Server 2005, and Xcelsius 2008
SP3.
S V Tech
June 2009 - August 2010
SAP BO Consultant
SV Tech Inc. is a fully integrated technology and operations firm,
ensuring businesses to operate more productively and
Profitably through a full spectrum of IT services, including
specialized staffing, project implementation services and products.
It is a leading developer of innovative software products, custom
solutions, and professional services. Following established standards
and proven quality control methodologies, our staff brings a unique
perspective to each project. Our history of successful engagements
gives us unique insight into telecommunications network management
systems that perform beyond expectations.
Responsibilities:
> Created, designed and developed Business Objects applications
using BOXI.
> Developed User Interface Screens using Data List and Grid view
based on requirements.
> Have known, how to created WSDLs using Query as a Web Service
(Qaaws) from different Data sources.
> Got to know the designing, developing, deploying and maintaining
universes used Business Objects designer.
> Created Universe for Ad-hoc and Canned Reporting purpose based on
DDL.
> Writing specifications and developing SQL Stored Procedures.
> Developing test cases and performing unit and integration
testing.
> Implemented how to do Custom Error handlers, Custom Exceptions,
Custom Error Pages.
> Create and maintain documentation on Universe and SAP Business Objects
deliverables.
> Worked with multiple data providers and linked these data providers
based on the requirements.
> Involved in creation of hierarchies and linking Universes (Linked).
Environment: Business Objects, Info View, Universe Designer, Web
Intelligence, Desktop Intelligence, CMC, Oracle.
ICICI Bank Ltd
May 2006 - April 2008
Business Objects Developer
ICICI Bank was originally promoted in 1994 by ICICI Limited, an Indian
financial institution, and was its wholly-owned subsidiary. ICICI's
shareholding in ICICI Bank was reduced to 46% through a public offering of
shares in India in fiscal 1998, an equity offering in the form of ADRs
listed on the NYSE in fiscal 2000, ICICI Bank's acquisition of Bank of
Madura Limited in an all-stock amalgamation in fiscal 2001, and secondary
market sales by ICICI to institutional investors in fiscal 2001 and fiscal
2002. ICICI was formed in 1955 at the initiative of the World Bank, the
Government of India and representatives of Indian industry. The principal
objective was to create a development financial institution for providing
medium-term and long-term project financing to Indian businesses.
Responsibilities:
> Learned and Created and maintained universes on OLAP (Online
Transaction Analytical Processing) databases.
> As a part of Universe development, created Classes, different kinds of
objects, cardinalities, Strategies, resolving loops using Aliases and
Contexts.
> Implemented Default & Custom Hierarchies, conditions on Lov, Derived
tables and @functions.
> Created Reports using Drill down, Cross tab and Charts (column, line,
pie). Used the drill functionality, ranking, sorting, complex alerter
and variables in full client reports.
> Experience in creating reports by using various templates according to
the needs of users.
> Used Desktop Intelligence, Web Intelligence for Ad hoc reporting.
Customized the Info view to have the start page as the "my documents"
page and set the default option of viewing the reports based on the
user profile.
> Created financial reports, charts using Universes as the main data
provider. Reports such as Quarterly variance, Regional, Actual vs.
Forecast, Balance sheets etc. were developed.
> Developed Summary/Detail/Drill Down reports and some of the reports
include Inventory Details, Pending Charges, Storage Charges, Customer
Invoices, Print Tickets and G/L Postings and were generated daily,
weekly and monthly basis.
> Created reports on with predefined filters and able to select for
particular Regions, Masters (companies), Divisions and Employee.
Environment: Business Objects, Info View, Universe Designer, Desktop
Intelligence, SQL Server.
Contact this candidate