Manager Data
Resume:
JAGRUTHI MOTHUKURI
Email id: *************@*****.***
Phone No. : 248-***-**** Ext 5035
PROFESSIONAL SUMMARY
. About 7 years of IT experience in Business Objects XI R3/R2/6.5 with
experience in CMC, Infoview, Desktop Intelligence, Import Wizard,
Designer, Reporter, Web Intelligence
. Experienced the features of Business Objects XI R2, Crystal reports XI
R2/8.0, Crystal Xcelsius.
. Experience in building Universes, retrieving data using Universes,
Personal data files (MS Access, Excel) and creating complex ad-hoc
Reports using the Business Objects Web Intelligence (WebI) modules.
. Experience in Installation, Administration, Design Universe, Reporting
(Desktop Intelligence & Web Intelligence) and Migration of Business
Objects XI R3/R2 /6.5.
. Extensive knowledge in Business Objects Full client & thin client
environment.
. Worked on Web Intelligence (WebI) to develop and publish thin client
reports.
. Experienced in setting up of Repository, creating, managing users and
user groups
. Experience in migration from previous versions of Business Objects to
its higher version
. Extensively worked in designing, implementing, distributing and
maintaining Universes.
. Experience in creating Crystal Reports using Crystal Reports XI/2008
with expertise in developing various standard, graphical, formula
based, well-formatted, drill-down, Summary and Parameters based
reports and profound experience in developing complex reports using
Sub-Reports (Linked and Unlinked), Cross-Tab, Stored procedures and
Views.
. Strong knowledge in building queries on different types of Data
Providers Universes, Personal data files, Stored Procedures, Free-hand
SQL, and Web connect.
. Experienced in setting up of Repository, creating, managing users and
user groups.
. Have experience working with databases like Oracle, SQL Server and MS-
Access.
. Experienced in web publishing and scheduling documents using Broadcast
Agent or Publishing wizard.
. Strong background in Data warehouse concepts - ETL, Data modeling, and
Reporting
. Proficient in working with error handling and performance tuning to
enhance database performance.
. Extensively worked with end-user requirements, business data
requirements, analysis and study.
. Unique ability to understand long-term project development issues at
all levels
. Strong Business Intelligence implementation knowledge of strategic
planning, development and production in various core sectors
. Demonstrated excellent interpersonal skills and communication skills
during identification of user requirements.
. Capable of working in a team or individually, self-motivated with good
problem solving skills.
TECHINAL SKILLS
Reporting Tools : Business Objects
XIR1/R2/R3,6.5/6.0/5.x,Crystal Reports
2008/XI/10/9, Crystal Xcelsius, Central
Management Console (CMC), Central Configuration
Manager (CCM), Import Wizard, Performance
Management, Desktop Intelligence, Web
intelligence
Application Servers : Apache 1.3.27, IIS 5.0 and Tomcat 4.0.6
Business : MS Visio and MS Front Page
Microsoft Tools : Microsoft Office Suite (Word, Excel, Access,
PowerPoint, and Outlook)
UML Diagram Tools : Microsoft Visio
Database : SQL Server 2000/2003/2005, Oracle9i/10g, MS Access
2000/XP/2007, Toad
Languages : SQL, PL / SQL
Web Technologies : HTML, DHTML
Operating Systems : Win XP SP2/SP3, Win 2000, Win NT 4.0 and UNIX
EDUCATION
. Bachelors of Technology in Electronics and Communication Engineering.
PROFESSIONAL EXPERIENCE
WellPoint Inc, Richmond, VA
Jun 2009 -
Present
Sr. Business Objects Developer
WellPoint is the nation's leading health benefits company serving the needs
of approximately 35 million medical members nationwide. WellPoint companies
offer a choice of quality branded health benefits and related financial
services designed to meet the changing expectations of customers. Developed
a Reporting System which would help their Sales/Marketing teams to view and
forecast the sales of their surgical product, and analyze the revenue of
the company which would give the clear picture of business to the top level
management to take decisions. The company has served its customers by
offering access to quality health care at a competitive price and has
served the people of Virginia through support of community organizations,
programs and events that promote good health.
Responsibilities
. Performed an initial study of the current reporting application, to
finalize the data elements required for reporting.
. Installed and configured BO Software on client machines and created User
groups and users of PROD, DEV, TEST environments.
. Created Repository for BO development, created Universes and Complex
Reports.
. Involved in working with different database environments and moving of
the universes and reports between PROD, DEV, and TEST.
. Added users, user groups and managed the access privileges of the user
community using the CMC module
. Applied security features of Business Objects like row level, report
level & object level security in the universe so as to make the
sensitive data secure.
. Maintained universes and Object Oriented Universe Design Techniques,
working knowledge of Linked Universes.
. Designed Metadata Universe by creating the Business Objects Semantic
Layer selecting/joining Tables, set cardinalities and creating
objects and classified them into Dimensions, Details and Measures and
give Business Name and group them into classes and sub classes
. Involved in creating the Aggregate tables at different levels.
. Multilevel hierarchies are set up enabling the drill down functionality.
. Defined Report Level Ranking, Database Ranking and Alerts in Reports
based on the specifications.
. Synchronized queries from multiple data providers by linking the
common dimensions using merge dimensions option in WebI.
. Created Report Level Variables, Objects and Formula to create new
columns based on the result set.
. Resolved issues like Chasm traps, Fan Traps in the universe build by
creating contexts and aliases as required.
. Resolved loops by creating aliases, contexts and short cut joins by
resolving loops, cardinalities and integrity checks of the Universe
before exporting.
. As a part of report development, created the reports using universe as a
main data provider and using the Powerful business objects
functionalities, and formulae. Involved in trouble shooting of various
reporting errors.
. Created the complex WebI reports such as Cross Tab and Master Detail
Reports using the Java Report Panel.
. Created a set of Ad hoc reports with Business Objects and finally
deploying them in Web Intelligence
. Worked closely with the end users and user decision makers to develop the
transformation logic to be used in Reports.
. Worked on Import and Export of the Universes, with the changes in
Database Objects by using Import wizard and Designer module.
. Developed crystal reports, which include the following features -
parameter fields, formulas, conditional formatting, multiple grouping
and running totals
. Developed crystal reports using various Charts and Graphs like Bar
Chart (Side by Side, Stacked), Line graphs, Pie Charts.
. Troubleshoots system errors and bugs and rectifies them.
. Involved in Training the Users in using this robust system.
Environment
Business Objects XI R3/R2, Designer XI R3/R2, Desktop Intelligence, Web
Logic 6.0, Crystal Reports 2008, Xcelsius 4.5/2008, Oracle 10g, SQL, PL/SQ.
Bank of the West, Denver, CO
Apr 2008- May 2009
Business Objects Developer
Bank of the West, headquartered in Sanfransico, California is a financially
strong, well-capitalized and prudently managed FDIC- insured bank. Their
business includes Commercial, Personal services, Insurance, Loans,
Wealth/Cash management, Capital Marketing. Created Universes and used
optimising techniques. Involved in supporting the Business Objects
applications that are in production environment, administered the BO
activities, and granting the necessary db access rights and privileges for
the BO users.
Responsibilities
. Responsible for system study & Business Requirements Analysis &
Documentation (Technical).
. Applied command restrictions to various existing groups and users
restricting different functionalities in Business Objects suite.
. Created user profiles in CMC module with varying security profiles for
each user.
. Implemented Row Level Securities and Object level security universe to
incorporate security for sensitive information.
. Documented the Tables required from the Underlying database to build
the universes
. Designed Metadata Universe by creating the Business Objects Semantic
Layer selecting/joining Tables, set cardinalities and creating
objects and classified them into Dimensions, Details and Measures and
give Business Name and group them into classes and sub classes
. Created local objects in the Universes with complex SQL functions to
manipulate the data based on the report requirements
. Created Derived Tables to reduce the complexity of the Metadata
Universes. Defined @Aggregate Awareness, @Prompt, @Select, @Where
functions in universe level.
. Created Cascading Prompts in the universe to filter the list of
Account names based on the Business Units.
. Created reports using Business Objects functionalities like queries,
Slice & Dice, Drill Down, Cross Tab, Master/Detail and used Complex
Formulas in the report variables.
. Resolved issues like Chasm traps, Fan Traps in the universe build by
creating contexts and aliases as required
. Created Report Level Variables, Objects and Formula to create new
columns based on the result set.
. Resolved Migration issues both in Designer, Reporter and created test
cases to check the Migrated Reports
. Created Universes specific to dashboard development with various
measures defined.
. Synchronized queries from multiple data providers by linking the
common dimensions using merge dimensions option in WebI.
. Defined Report Level Ranking, Database Ranking and Alerts in Reports
based on the specifications.
. Defined User Response function in Report Level to display the data
selected by the users in the Report Headers
. Enabled/Disabled different servers in Central Configuration Manager
and Central Management Console
. Involved in the creating the reports using the Web XI R2. Created the
Reports (Master/Detail, Brake, Cross Tab, Chart, Templates) in
Business Objects using the Universe as the main Data Provides and
writing the Complex queries including Sub-Queries.
. Enhanced the Reports with the functionalities like Ranking and
synchronizing the data using the merge dimensions option
. Actively working with Database design team to add new business rules
and logic for the universe design.
. Resolved loops by creating aliases, contexts and short cut joins by
resolving loops, cardinalities and integrity checks of the Universe
before exporting.
. Created and customized application dashboards using Performance
Manager to meet the requirements Upper Level Management.
. Worked with performance tuning tools to improve the performance.
. Developed dashboards and scoreboards for detailed analysis.
. Scheduled reports through Web I Scheduler for distribution and
printing.
. Created Crystal Reports using both universes and business views based
on business requirements
Environment: Business Objects XI R2/R3 (CMC, Designer, Desk I, Web I), SQL
Server 2005, Oracle 10g/9i, Tomcat, Apache server, PL/SQL, Window XP.
Cigna, New Haven, CT
Feb 2007 - Mar 2008
Business Objects Developer/Admin
CIGNA had initiated a Corporate Social Responsibility program to improve
health, well-being, Claims processing and security for all its customers.
CIGNA's business practices demand strong financial controls, detailed plans
and rigorous reviews. The CSR Program CIGNA establishes meaningful links
between its own employees, individuals and families and well being of
communities across globe. As a part of this CSR program, several reports
and measurements are needed based on the standard operating procedures at
CIGNA which include regular and appropriate reporting of internal audit
functions.
Responsibilities
. Worked with HR directors, Business Analysts, DBA's and end-users to
gather universe design and reporting requirements to implement
business logic for successful implementation of report systems.
. Created complex reports using multiple data providers for processing
insurance claims for customers.
. Created universes, universe objects, classes, applied filters, pre-
defined and complex conditions.
. Worked extensively on modules CMC, Designer, Web Intelligence,
Auditor, Publisher and Info view.
. Created a fully functional Full client and thin client reports by
making use of Business Objects functionalities.
. Used Personal data files, free-hand SQL, stored procedures and also
functionalities like Combine Queries, aggregate awareness in universe.
. Created reports using Business Objects functionalities like Slice and
Dice, Drill Down, Cross Tab, Alerter and Formulae etc
. Created Dashboards using Dashboard Manager and Dashboard universes
with metrics.
. Implemented object level security in universe to incorporate security
for sensitive information.
. Implemented various levels of user profile rules, such as Folder
level, scheduling reports or view only access.
. Used Infoview or WebI to create, analyze and publish reports to
various groups or users.
. Designed Data model for Data Warehouse using snowflake schema, star
schema.
. Generated reports with 2D, 3D and pie charts for business query
results.
. Generated complex reports involving numerous prompts, open document
functions and taking data through multiple data providers.
. Generated various reports with "prompt" functionalities both at
universe and report level to enhance end-user interactivity.
. Extensively used extended syntax's and complex formulas.
. Formatted Reports as per the User requirements using extensively the
functionalities in Business Objects, which allows the users to analyze
the data.
. Edited Joins, resolved loops using aliases and contexts in the
universe and exported to repository.
. Created Crystal reports when needed and exported to enterprise
repository in order to make Crystal reports accessible through
Infoview.
. Used T-SQL Aggregating, group by, Indexes, stored procedures.
. Responsible to support the issues with reports on the Business Objects
Enterprise environments (Development, UAT, Test and Production).
. Used ETL tool Informatica when needed for loading data into another
Database DB2.
. Involved in writing detail level documentation for reports, migration
of reports as well as universes to production.
Environment: DB2 UDB, Business Objects XI R2, Crystal Reports XI R2, SQL,
Windows XP, Web Intelligence, Informatica 7.0, UNIX Shell Scripting.
Nationwide Insurance, Gaithersburg, MD
Nov 2005-Jan 2007
Business Objects Developer
Nationwide Insurance is one of the largest and diversified insurance
companies in US. The company provides a full range of personalized
Insurance and financial services including Auto Insurance, Homeowners
Insurance, Life Insurance, Farm Insurance and commercial Insurance.
Responsibilities
. Interacted with functional / end users to gather requirements of core
reporting system to understand exceptional feature users expecting
with reporting system and to implement business logic.
. Analyze the reporting requirements with the business users and come up
with the technical specifications for the BO Reports
. Worked on Business Objects DeskI and WebI Reports of BO XIR2
Environment.
. Worked on User Management, Server Management and Content Management.
. 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 6.5 to
BO XIR2.
. Creating the reports using Business Objects functionalities like
Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross
Tab and Master Detail.
. Added users, user groups and managed the access privileges of the user
community using the CMC module of Business Objects.
. Created complex variables, breaks, sorts, filter and conditions for
various reports.
. Linked multiple universes and reports using stored procedures, visual
basic procedures, flat files and excel files.
. Responsible in publishing and scheduling business intelligence
documents to large number of end users.
. Implemented row level restrictions according to different business
group requirements.
. Involved in migrating and deploying -- universes and reports across
multiple domains.
. Solved many Universe problems. (Loops, Fan and Chasm Traps)
. Used various @Functions like @Prompt (for user defined queries),
@Where (For creating conditional filters), and @Select.
. Creating, maintaining and modifying the universes using Business
Objects designer
. Creating reports using Crystal Reports XI when needed.
. Aided in the multi-dimensional analysis using slice & dice, drill (up,
down, through and across) by setting up different hierarchies and
defining the scope of analysis.
. Implemented Data modeling using ERWIN tool when necessary
. Created jobs to Extract, Transform and Load data into data warehouse
using Datastage7.0
. Responsible in maintaining Development, Test and Production
repositories and providing round the clock support during the
production stage.
. Involved in scheduling the documents for monthly, weekly and daily.
Environment: Business Objects XI R2, Infoview, PL/SQL, Oracle 10g/9i, ERWIN
4.0, Crystal reports XI, Data Stage 7.0
Wells Fargo, Phoenix, AZ
Sep 2004 - Oct 2005
Business Objects Developer
The project involved in the maintenance of Decision Support System for
Wells Fargo by means of integrating data from disparate feed systems,
situated across different locations, into a repository of meaningful
business information. The Banking Data Warehouse (BDW) system for Wells
Fargo is designed to handle the increasing data volumes generated by the
bank's growing, active client base while improving customer service levels.
Responsibilities
. Gathered user-requirements/feedback, implement in reporting
applications.
. Designed and developed Business Objects universe and report templates.
. Implemented subject-oriented contexts in designer.
. Created Cascading Prompts in the universe to filter the list of
Account names based on the Business Units.
. Created reports using Business Objects functionalities like queries,
Slice & Dice, Drill Down, Cross Tab, Master/Detail and used Complex
Formulas in the report variables.
. Created Universes for report generation using Designer module in
Business Objects.
. Defined Customized Sorts in Universes and Reports Level.
. Added users, user groups and managed the access privileges of user
community using the CMC Module of Business Objects of XI R2 and
Business Objects 6.5.
. Designed Metadata Universe by creating the Business Objects Semantic
Layer selecting/joining Tables, set cardinalities and creating
objects and classified them into Dimensions, Details and Measures and
give Business Name and group them into classes and sub classes
. Resolved universe development issues involving loops and chasm traps.
. Check the Integrity of the Universes.
. Customized list of values and efficient prompts for intuitive
reporting and analysis.
. Exported the universes to the Repository to making resources available
to the users.
. Track data issues and direct technical resolution; interact with other
teams on technical interface issues.
. Impact analysis - update and prepare team for new data, data change
Met users to discuss new reports, reporting issues, data
issues/changes relevant to users.
. Tested, QA-ed and delivered reporting applications, resolve all
reporting/data issue.
. Increased reliability of reports through elimination of errors and
efficient resolution of issues - user base grew by 200%, steady issues
resolution rate 98%+ catered to reporting needs of departments ranging
from contracts operations to higher management levels.
. Published and scheduled Business Objects Reports to users using
Scheduler.
Environment: Business Objects XI /6.5, Designer, Web Intelligence 6.5,
Oracle 8i/9i, Windows 2003 Server.
Wizden Solutions, Hyderabad, India.
Jul 2003 - Aug 2004
SQL Programmer
The project is making the GUI application to maintain the money
transactions. The company invites deposits, fixed deposits from customers
and offers loans to qualified customers. This assignment consist the
automation of all company transaction.
Responsibilities
. Design and development of software related to materials management and
finance.
. Documented database procedures in PL/SQL to control deletion of
material code and developed front end using Visual Basic.
. Documented database triggers, which would not allow change without
proper authorizations in transactions viz. material return from plant
goods issue, goods purchased through proper channels in purchasing
department and goods receipt physical inventory once saved in Oracle.
. Developed reports for purchase orders, sales orders, and goods issued
and goods receipt. Coded database procedure to calculate average
purchase price of material for current financial year for costing
purpose.
. Conducted detailed study of the existing manual system. Also analyzed
and designed the system along with senior members Participated in unit
testing and system testing Interacted with users in implementation.
Environment: VB 6.0, Oracle 7.x, SQL Loader, PL/SQL, Reports 3.0 and
Windows NT/2000.
Contact this candidate