Madhavi Vejandla

636-***-****

acocnh@r.postjobfree.com

US CITIZEN

SUMMARY

. Nine years of IT experience that includes six years of Crystal reports

(2011,2008, XI, 10/9/8) Business Objects (4.0/XI R1/ R2 and XI 3.1), and

Xcellsius 2008 experience.

. Experience in designing and implementing reports using Crystal

Reports,Crystal Enterprise,

MS Access Reports.

. Experience in designing, developing and maintaining the Universe,

developing canned/ad-hoc

Reports, Scheduling and processes of the reports using broadcast

Agent server.

. Experience in data retrieval methods using Universes, Personal

Data files, Stored Procedures,

and free hand SQL.

. Strong exposure to Software Project Development full life cycle.

. Knowledge in Planning, Designing, Developing and Deploying Data

warehouses / Data

Marts with experience of both relational & multidimensional

database design using Data Modeling

tool Erwin (Physical and Logical data models).

. Strong Exposure to SQL, PL/SQL, and RDBMS: Oracle 7.1/8.0/8i/9i,

and MS SQL Server 7.0.

. Diversified experience in implementation Business objects report

management with in

Finance, Pharmaceutical and Insurance sectors

. Experience in Translating Business needs into end-user Reports

using Crystal Reports.

. Expert in developing complex reports, creating reusable formulas.

. Possess Excellent Communication and Interpersonal skills.

Technically sound, Result-Oriented with strong Problem Solving

skills. Innovative & efficient. Capable of working as a Team

Member or Individually with minimum supervision.

. Flexible and versatile to adapt to any new environment with a

strong desire to keep pace with

latest technologies.

SKILLS

Reporting Tools Business Objects 4.0/XI/6.x/5.x (Supervisor, Designer, and

Reporter),

Web Intelligence 6.x/2.x, BCA 6.x/2.x, ZABO, Application

Foundation, Crystal Reports

11.0/10.0/9.0/8.0/7.0,Discoverer 4i.

ETL Tools Informatica Power Center 7.x/6.x.

Database Oracle 9.x/8.x/7.x, SQL Server2000, DB2, MS-Access

Data Modeling Erwin 4.1/3.5

Languages SQL, PL/SQL, C, C++, Java

OS/Platform Windows XP/2000/NT, UNIX

Oracle Tools SQL* Plus, SQL* Loader, TOAD

Testing Tools Win Runner 7.5/7.0/6.5, Load Runner

5.0/6.5/7.6,

Quick Test Pro 6.5, Test Director 8.0/7.6/7.2/6.0,

Silk Test

PROFESSIONAL EXPERIENCE

Mercy Health System, St. Louis, MO

May'2011-Sep'2014

(EPIC Certified on Inpatient and Ambulatory)

. Co-ordinate Business Analyst's interaction with Customers and Users

to gather report functional requirements.

. Convert functional specifications to Technical Specifications.

. Used Life Cycle Manager and imported Universes, reports and

dashboards across different dev environments

. Used Business Objects Business Explorer and some Auditor universes

to make sure how the tables/fields/objects were implemented in our

earlier versions of universes and reports.

. Created and modified Reports & Dashbaords by using different

datamarts in our Power Insight EDW database.

. Involved in Source to Target mapping documentation creation process

of Power Insight EDW.

. Worked closely with Power Insight EDW Architects as a Business

Objects universe, Reports and Dashboards Subject Matter expert.

. Created complex stored procedures and data base views in SQL Server

2008.

. Design and develop Business Objects Universe in Designer 3.1

. Migrated the universe 3.1 to 4.0

. Create complex Web Intelligence Reports against multiple data

providers.

. Modified the Existing universe and webi Reports

. Created Merging dimensions using webi.

. Design and Develop Crystal Reports using Oracle Views and Stored

Procedures as sources.

. Gathered, Analyzed & Documented business requirements, functional

requirements and data specifications for Crystal Reports.

. Created, maintained and enhanced Crystal Reports for an Enterprise

reporting system.

. Developed parameter, cross-tab and sub reports.

. Involved in testing reports in crystal, to compare the row count,

response time and report output.

. Developed Stored Procedures, Views, Cursors, Functions and SQL

queries and tuned them to improve reports performance.

. Design and Develop Custom WebI Reports using Multiple Data providers

such as Universes and Free-Hand SQL.

. Design, Develop delimited extract files using Sql Queries, Views and

format the delimited files using Oracle functions for Interfaces

used by Legacy Systems.

. Unit test the developed Reports to ensure reporting standards and

data validation.

. Performances tune the Crystal Reports and Views.

. Promote Reports from Development to Test, Test to Production.

. Document the development, Testing and promotion procedures.

. Provide Production Support.

Environment: Business Objects 4.0/3.1, Business Objects Enterprise

4.0/3.1,Business Object XI 3.1 SP2, CMS, Designer, Web Intelligence XI 3.1,

LCM, BO Explorer, Crystal Reports 2011 & 2008, Crystal Xcelsius,,

Infoview, SQL Server 2005/2008, Oracle 10g, Toad.

US Bank, St.Louis,

MO

Nov 08 to Apr 11

(Home Mortgage)

Responsibilities

. Created scorecards and dashboards using Live Office, QAAWS and Crystal

reports with Oracle EDW and existing universe & reports.

. Analyzed business requirements, functional requirements and data

specifications for Crystal Reports

. Responsible for developing Crystal reports, Maintenance, Enhancements and

supporting applications

. Performed day-to-day administration tasks for the Crystal Reports

environment

. Synthesized the requirements and reporting capabilities into functional

and technical specifications

. Worked closely with EDW Architects as a Business Objects universe,

Reports and Dashboards Subject Matter expert..

. Developed and prepared logic tests, unit tested the final product. The

solution includes ad-hoc query, drill-down, slice and dice capabilities,

static reporting, and managed queries

. Resolved technical problems and Help Desk tickets

. Reviewed and updated existing reports to comply with Business

Intelligence & Crystal Reporting standards

. Collaborated with the ETL development team to ensure reporting requests

can be supported by the underlying data source

. Performed analysis to investigate and troubleshoot data inconsistencies

and data integrity issues

. Worked extensively with Crystal Reports, SQL Queries, and converting

Crystal Reports into Excel files.

. Designed, developed and maintained ad hoc/custom Crystal Reports

accessing backend SQL Server & MySQL databases

. Involved in Requirement gathering and user testing for new report and

application development

. Extensively designed, developed, testing and implementing new PL/SQL

packages, functions and stored procedures.

. Developed reports using Crystal Reports Various Report Formats developed

include parameterialized Reports, Sub Reports, Cross Tab Reports,

Standard Reports, OLAP Reports, and also developed reports in MS Access

and Excel.

. Designed Complex reports using sub reports, manual cross tabs using

Crystal syntax with extensive usage of Local, Global, and Shared

variables at report formulas.

. Scheduled various reports on Daily, Weekly, Monthly and Yearly basis.

. Created the Reports for various financial groups using the Universe as a

main data provider.

. Created custom reports like Gross Margin, Account Query, Aging, Balance

Sheet, Income Statement, Bad Debt and Payment Reports in response to user

needs. Some of these reports are extremely complicated and retrieve data

from multiple data sources.

. Created Charts to display summary data using universe as main data

provider.

. Extensively used Calculations, Variables, Drill Down and Slice and Dice

for creating Crystal Reports reports.

. Examined and transformed the business logic behind the existing Crystal

Reports into Business Objects environment.

Environment: Business Object XI R1/R2, Designer, Web Intelligence

XI/6.5,Desktop Intelligence, WebI Rich Client, MS Access, MS Excel, Oracle

10g, Crystal Reports XI/2008, SQL, PL/SQL,, BO Auditor, Toad, Data stage,

Windows XP Professional

US Bank,

St. Louis,

MO

July 6 to Nov 08

US Bank Home Mortgage originates loans in various business

channels .Worked in Mortgage Road Map team testing NetOxygen LOS

application .This application helps loans to pass different phases like

Lead Management, POS, Processing, Underwriting, Closing, Funding and Post

Closing.

Responsibilities

. Analyzed Business requirements and write test cases.

. Used Quality Center extensively for Test case writing.

. Extensively involved in test execution in Quality Center for LOS

Application.

. Performed Smoke Testing for weekly new build.

. Extensively used TOAD for conducting back end testing, comparing the

application data with the output of the SQL query.

. Performed End to End testing of the loan application from Loan

Origination to Closing.

. Performed Functional regression of application prior to release.

. Used Clear Quest for defect writing and retest.

. Generated reports for all the tracked defects and updated the team on

weekly basis.

. Involved in daily defect call meeting consisting of team of

Developers, BAs and QA team, discussing issues regarding application

and workflow issues.

Environment: Visual Studio(C#, ASP, VB Script), Business Objects 11.0,

Java, Quality Center 9.0,TOAD,Clear Quest, Windows NT/2000.

Contact this candidate