SreeDeepika Madigubba
Ph.: 847-***-****
*********@*****.***
Professional Summary
. Over 8.2 years of experience in Business Intelligence Reporting.
. Over 7 years of experience in Business Objects Development using
various Business Objects (BOBJ) Product Suite including Webi, Deski,
xCelsius Dashboards and Universe Development.
. 2.6 years of Experience in BOBJ Development through versions Business
Objects XI 4.0
. 2 years of Experience in developing BOBJ 4.0 mobi version.
. Experience in Business Objects XI 3.1(R3.1) / XIR2/R1 and Dashboard
Designer, xCelsius 2008 / 4.5.
. Around 3 years in building dashboards using Xcelsius 2008/4.5 using
QaaWS and SAP BW Net weaver connections.
. Major responsibilities include gathering requirements from the end
user and developing Desktop Intelligence Reports, Webi and Mobi
Reports.
. Extensive database architecture and design skills working on high
performance solutions in large corporate environments.
. Expertise in developing Business Objects webi reports, Dashboard
Designer, Hyperion reports /Dashboards.
. Expertise in gathering, analyzing and documenting business
requirements, functional requirements, and data specifications for
Business Objects Universes and Reports.
. Certified in Business Objects.
. Good understanding of all the architectural differences between all
versions of Business Objects.
. Strong experience to work in Windows and UNIX environments.
. Well versed with SQL/PL SQL queries.
. Good experience in Retail, Life Insurance and Banking Domain.
. Working experience in Waterfall SDLC methodologies.
. Worked on Quality center to create Test cases and capture Report bugs.
. Hands on experience on Rational Testing Tools like Clear Quest.
. Strong trouble shooting and problem solving skills.
. Ability to work independently or as a team Member.
. Managed teams of 6-8.
. Excellent Communication and Management skills.
Certifications
* Business Objects Certified Professional
* Informatica Exam N: PowerCenter 7 Mapping Design
* Informatica Exam P: PowerCenter 7 Advanced Mapping Design
Technical Summary
Reporting Tools Hyperion Intelligence Designer 8.3,
Hyperion Performance Suite, Business
Objects XI R2/3.1/4.0, Central
Management Console, Central
Configuration Manager, Designer, Desktop
Intelligence, Web intelligence, Webi
Rich client.
Dashboard Tools Crystal Xcelsius Designer 2008/4.5,
Hyperion Intelligence Designer 8.3,
QAAWS
ETL Tools Informatica
Databases Oracle, SQL Loader
Languages Java, C, C++, Visual Basics, PL/SQL
Operating Systems MS Windows 98/NT/2000/XP, MS-DOS, UNIX
Defect Tracking/Test Mgmt Quality Center, Rational Clear Quest
Tools
Version Control Tools Serena PVCS, Visual Source Safe
Professional Experience
Present Employer:
1. Infosys Technologies Ltd, India
Technology Lead,
Nov 2005- Present
Projects/Clients:
Kraft Foods, North Field, IL Jan'13 - Present
BO Development Team Lead
Environment: Business Objects XIR4.0 (Designer, WEBI, Web Rich Client),
SAP BW, Microsoft Excel, iPhone, iPAD.
Buzz Project:
This project is to develop BO reports for different Business Units for
Sales analysis.
The objectives of this engagement include
1. Gather user requirements and provide solutions.
2. To deliver managerial webi and mobi reports.
Responsibilities:
* Gathered the requirements using Blue printing sessions, provided the
related Mock-ups for the particular Reporting Scenarios for
different Business Units and Wal-Mart Client.
* Documented user requirements, translated Functional requirements into
Technical Requirements and develop implementation plan and schedule.
* Designed, developed and deployed Webi reports using Interactive
Analysis designer on different data sources (Excel, BeX queries) and
using different features of webi/mobi capabilities.
* Designed, developed and deployed Mobi reports on iPhone and iPad
successfully.
* Users set up and deployment.
* Deployed webi and mobi reports specific to CIO of KRAFT.
* Review/test the developed webi reports.
Kraft Foods, IL Nov'11 - Dec'12
Onsite Team Lead
Environment: Business Objects XIR4.0 (Designer, WEBI, Web Rich Client),
SAP BW Neat Weaver.
Food Services project:
This project is to develop BO reports to leverage existing BI reports to
represent SAP CRM data for food services.
The objectives of this engagement include
3. Gather user requirements and provide solutions.
4. To deliver webi reports on top of BeX queries.
Responsibilities:
* Gathered the requirements using Blue printing sessions, provided the
related Mock-ups for the particular Reporting Scenarios and
documented them properly for future references.
* Involved in designing Functional / Technical Specification documents.
* Documented user requirements, translated Functional requirements into
Technical Requirements and develop implementation plan and schedule.
* Designed, developed and deployed Webi reports using Interactive
Analysis designer.
* Used relative path URL to embed Webi reports in CRM portal.
* Compared the BI reports with webi reports to match the data.
* Work delegation and lead the offshore team.
* Review/test the developed webi reports.
Projects/Clients:
Telstra, India Mar'11 - Nov'11
Offshore Team Lead
Environment: Business Objects XI R3.1 (Designer, WEBI, Web Rich Client),
BMC Analytics, Toad.
Telstra SMEC project:
This project is to develop BO reports on top of BMC Analytics. Remedy
analytics data is being integrated with BO and reports were developed
catering function-specific business needs.
The objectives of this engagement include
5. Installation of BO in different environments.
6. Develop webi reports on BMC Analytics.
Responsibilities:
* Analyzed the Business requirements.
* Work delegation and lead the offshore team.
* Installed and Configured Business Objects on Both Client and Server
Installations.
* Designed, developed and deployed Universes and Webi reports.
* Created Webi Reports using all the BO functions like Drill Down, Prompts,
Dimensional and Measure variables to show accurate Results.
* Published the reports and dashboards in Info view.
* Reviews of dashboards and reports.
* Troubleshooting and rectifying Universe, Webi & Live Office errors.
. Involved in weekly status meetings to discuss the status of the work
and project as a whole.
PEPSICO, India May'08 - Mar '11
Technical Specialist/ Team Lead Offshore
Environment: Business Objects XI R2 (Designer, WEBI, Web Rich Client),
Crystal Xcelsius Designer 4.5, QAAWS, Informatica v8.1, TOAD, MS Excel,
Mercury Quality Center, Star Team, e-ROOM and Visual Source Safe.
PEPSI QTG project:
Pepsi-QTG Canada is a subsidiary of PepsiCo, Inc. Pepsi-QTG Canada,
through its subsidiaries, markets and distributes hot and ready-to-eat
cereals, and snack options. It offers soft drinks, bottled water, new age
healthy refreshment beverages, cold bottled coffee, sports drinks, juices
and juice drinks, hot and ready-to-eat cereals, nutrition bars, and
snacks.
This project deals with developing a data warehouse and implementing an
ETL tool are the cornerstone for providing superior analytic and business
intelligence capabilities. Reports and dashboards were developed catering
function-specific business needs.
The objectives of this engagement include
1. Loading data into data marts.
2. Developing dashboards and webi reports.
Responsibilities:
* Interacted with the Client IT team and Business users.
* Analyzed the Business requirements.
* Work delegation and lead the offshore team.
* Created Universes, Deski and Webi reports.
* Developed Xcelsius 4.5/2008 Dashboards on top of QaaWS.
* Published the reports and dashboards in Infoview.
* Used dynamic visibility and Excel functions to control and manipulate
the data.
* Implemented Open Doc to drill down to detail webI report from Xcelsius
Dashboard.
* Exported Xcelsius to repository to make it available for users through
info view.
* Created dashboards with multiple hyperlinks to various reports using
Open Document Syntax.
* Internal reviews of dashboards and reports.
* Extensively used SQL queries via TOAD to verify the population and
validation of the data
in the backend.
* Used Mercury Quality Center to store requirements, documentation and Test
cases, and used
Star Team for Defect Tracking and reporting.
* Version controlling of the dashboards and reports is taken care of.
* Involved in weekly status meetings to discuss the status of the work and
project as a whole.
National Bank of Australia, Melbourne Oct'07 -
May'08
Business Analyst/ Onsite Lead
Environment: Business Objects XI R2(Designer, Deski, Webi), UNIX,
SQL Loader, ERWIN, Quality Center, and TOAD
and VSS.
Card Swipe Project:
National Australia Bank (or NAB) is one of the largest financial
institutions and banks in Australia in terms of market capitalization and
customers.
To perform a study and to implement newly requested business
functionality into the electronic renovated application. To recommend a
solution to increase teller capabilities to enhance the customer
experience.
The objectives of this engagement include
1. Setting up the environment
2. Design for loading the data into supermarts.
3. Developing webi reports.
Responsibilities:
* Gathered the requirements using Blue printing sessions, provided the
related Mock-ups for the particular Reporting Scenarios and
documented them properly for future references.
* Involved in designing Functional / Technical Specification documents.
* Involved in complete development life cycle.
* Data model creation in ERWIN.
* Developed UNIX Shell scripts and SQL scripts for loading data into super
marts.
* Designed, developed and deployed Universe and Webi reports.
* Extensively used SQL queries via TOAD to verify the population and
validation of the data
in the backend.
* Used Mercury Quality Center to store requirements, documentation and Test
cases.
* Version Control of all the files and scheduling the jobs are taken care
of.
* Organized / Conducted internal training sessions to ensure betterment of
the individual resources and the Team as an entity.
* Created Knowledge Transfer Documentation and provided hands on training
for new employees and Interns.
FIDELITY, India
Sep'06 -Oct'07
Investments Company
Senior Software Developer/ Module lead offshore
Environment: Hyperion Intelligence Designer 8.3, Hyperion Performance
Suite, Oracle SQL, Rational Requisite Pro, Clear Quest, Quality Center,
Serena PVCS, TOAD, Informatica v8.1 and UNIX
FILI Reports and Dashboards Project:
Fidelity Investments is a privately owned investment manager Fidelity
Investments provides a large family of mutual funds, distributors and
investment advisors, as well as providing discount brokerage services,
retirement services, wealth management, securities execution and
clearance, life insurance and a number of other services.
To perform a study of the existing Business Intelligence (BI) and Data
warehouse environments and re-commend a suitable roadmap in-line with its
organizational goals.
The objectives of this engagement include
1. Setting up the Hyperion Portal 8.32
2. Design for security model, SSO, folder structures, Track the
environments.
3. Development of Hyperion reports and dashboards.
4. Test the reports and dashboards and fix the bugs.
Responsibilities:
* Involved in complete development cycle and coordinated with testing
team.
* Interface with client IT team and Business users
* Lead a development module and coordinated with other development
and testing modules.
* Analyzed business requirements.
* Created user requirements in Rational Requisite Pro.
* Created data models.
* Designed reports and dashboards.
* Publishing of reports and dashboards in Hyperion Performance Suite.
* Scheduling of jobs in Hyperion Performance Suite.
* Worked on automation of jobs in UNIX.
* Version controlling of the reports and dashboards are taken care
of.
* Involved in the Integration & system testing.
* Extensively used SQL queries via TOAD to verify the population and
validation of the data.
* Used Mercury Quality Center to store requirements, documentation and Test
cases.
* Tracked the defects in Clear Quest and fixed them.
* Involved in weekly status meeting with clients.
* Worked on UAT feedback
* Conducted training sessions to impart the domain knowledge and
tools used in the project.
* Created Knowledge Transfer Documentation and provided hands on training
for new employees and Interns.
FIDELITY, India
Nov'21 - Sep'06
Investments Company
Software Developer offshore
Environment: Hyperion Intelligence Designer 8.3, Hyperion Performance
Suite, Oracle SQL, Serena PVCS, TOAD and UNIX
XTRAC Reporting Project
Fidelity Investments is a privately owned investment manager Fidelity
Investments provides a large family of mutual funds, distributors and
investment advisors, as well as providing discount brokerage services,
retirement services, wealth management, securities execution and
clearance, life insurance and a number of other services.
To analyze the existing Business Intelligence (BI) and Data warehouse
environments and provide suitable solution in in-line with its
organizational goals.
The objectives of this engagement include
1. Development of Hyperion reports.
2. Design for security model, SSO, folder structures, Track the
environments.
3. Test the reports
Responsibilities :
* Involved in complete development cycle.
* Interface with client IT team and Business users
* Analyzed business requirements.
* Created user requirements in Rational Requisite Pro.
* Created data models.
* Designed reports.
* Publishing of reports in Hyperion Performance Suite.
* Scheduling of jobs in Hyperion Performance Suite.
* Version controlling of the reports and dashboards are taken care
of.
* Involved in the Integration & system testing.
* Extensively used SQL queries via TOAD to verify the population and
validation of the data
* Used Mercury Quality Center to store requirements, documentation
and Test cases.
* Tracked the defects in Clear Quest and fixed them.
* Involved in daily status meeting with clients.
* Worked on UAT feedback.
* Involved in weekly status meetings with the clients.
Education
BR College of Engineering (Affiliated to JNTU), AP, India
Bachelor of Technology, Electronics and Instrumentation
Score: 80.8%