Crystal Reports Data
Resume:
Madhavi Vejandla
********@*****.***
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