Project Manager Developer
Resume:
Vasudha Yerravally 248-***-****
Summary
Over 7 years of experience in analysis, design, development, implementation and
administration/support of Data Warehousing, Reporting and Client/Server applications.
Over 5 years of experience in Business Objects XI R2,6.x/5.x/4.x products.
Areas of expertise include BO Reporter, Explorer, Designer, Supervisor, Web Intelligence
(WebI), InfoView, BCA (Broadcast Agent), Publisher, BCA Console, and ZABO (Zero Admin
Business Objects).
Extensive experience in report creation, scheduling, distribution (export/import) and
promotion/migration (development/test/production environments) using Business Objects
user module.
BO Designer experience includes Universe creation and distribution (export/import),
promotion/migration (development/test/production environments), classes/objects creation,
joins, resolving loops using aliases/contexts, resolving fan and chasm traps,
personal/shared/secured connections, linking universes, aggregate awareness, and
customizing universe parameters.
Other areas of technical expertise include customizing thick client and thin client
environments using VBA (Visual Basic for Applications), WebFocus,Dashboards,BO SDK
(Software Deployment Kit), ASP, VBScript, JavaScript, Web based Reporting and WebI
SDK.Knowledge of working with Crystal Reports.
Over 3 years Oracle database experience includes querying, database objects
creation/maintenance, stored procedures, embedded PL/SQL using SQL, PL/SQL, dynamic
SQL, and SQL Loader.
Over 4 years of experience as a Business Analyst.
Over 3 years of experience in UNIX with expertise in Unix Shell Scripts.
Obtained Training in Web Logic Server 9.2
Excellent communication and interpersonal skills.
Education
Bachelors in Computers
Post Graduate Diploma in Computer Applications, NIIT, Hyderabad.
Skills
BI Tools/ Datawarehousing: Business Objects 4.x/5.x/6.x,XI R2,Reporter/Explorer,Supervisor,Web Intelligence/WebI,InfoView,Broadcast Agent,BO SDK,WEBi-
SDK,ZABO,OLAP,Dimensional Modeling,Star Schema,Snowflake
Schema
Languages: C/C++,Visual Basic 5.0/6.0,VBA,MS IIS Server,HTML/DHTML,ASP,JSP,VB Script,JavaScript,SQL,PL/SQL,Stored Procedures,Triggers,Packages,SQL*Plus,SQL*Loader,HP-UX 11,Windows NT
4.0,Windows 2000,Windows 95/98,MS DOS
RDBMS: Oracle 8i/9i, Oracle 8.x/7.x, SQL Server 2000, Sybase, MS Access
2000, DB2, Teradata, PL/SQL, SQL, Stored Procedures/Triggers
Experience
Comerica Mar 10 – Sep 10
Senior Business Objects Developer
Responsibilities:
Created a new Universe.
Designed and developed Business Objects Reports with minimal supervision.
Creating reports with numerous numbers of formulas, case statements, breaks, master
detail sections.
Created reports with multiple tabs with multiple data providers, conditions, formulas,
complex Global and Table filters, sorts
Created ad-hoc reports for the customers and users.
Gathered reporting requirements from the users.
Scheduling reports using BCA Console to the Users Inbox and Infoview on weekly and
monthly basis.
Managing the access and security related issues of the Users for the Reports and
Universe.
Providing BOXI R2 training to the team members as this was a new product in the
project.
Providing Infoview and Report navigation training to the Users.
Demonstrating the BOXI tool to the team and the Users.
Solely responsible for creating all the reports for different modules and Universes in the
current project.
Documentaion of the Reports and Universe changes and updates as per requirements.
Technical environment includes Business Objects XI R2, BO Designer XI R2,Web
Intelligence,Infoview XI R2, Oracle 11, and Windows XP,Exposure with WebFocus and
Dashboards.
Ford Motor Company Apr 07 – Feb 10
Business Objects Developer
Responsibilities:
Worked with the ESPS Group (Extended Service Plan System) as a Business Objects
Developer.
Extended Service Plan coverage offers protection against high repair bills after a vehicle is
out of its manufacturer warranty. Different levels of coverage are available: PremiumCARE
covers 500+ parts; ExtraCARE covers 113 parts; BaseCARE - 84; PowertrainCARE -
29.Most coverage provides Roadside Assistance and a towing and rental allowance too.
Coverage can be purchased on Ford and non-Ford products, new and previously owned
vehicles.
Reports are made for the customers, mostly about the dealers, insurance, contracts details.
Reports contain highly sophisticated information regarding the premiums, cancel amounts,
claim amount for all types’ contracts. And based on this information dealer’s bonus,
payments, refund amounts are decided.
Created a master- detail report.
Managed Universes, Business Objects products, Stored Procedures, Repository, and
Document domains.
Created reports with multiple tabs with multiple data providers, conditions, formulas, complex
Global and Table filters, sorts, breaks, and master-detail sections reporters.
Responsible for modification and formatting to the existing Business Objects reports and
Universes.
Created ad-hoc reports for the customers and users.
Scheduled reports using BCA Console.
Exported Universes and Published reports to the Production Environment.
Gathered requirements for the specific Universe and the report change.
Documented requirements given by the customer.
Involved in the implementation of Web Focus.
Obtained the training for Web Focus.
Created reports out of Web Focus Environment
Technical environment includes Business Objects 6.5, BO Designer 6.5,Web Intelligence 6.5,
Teradata SQL Assistant 6.2, and Windows XP, WebFocus 5.3.
Ford Motor Company Oct 05 – Jan 07
Business Objects Developer/Analyst
Responsibilities:
Worked for the Service Center Integrated Reporting (SCIR), which is an application that uses
Business Objects 5.1.8 and Teradata. This application generates daily and monthly reports
about the Dealers, Accounts, Account Maintenance, Branch and Company Losses, Phone
Time with Customers, Agents, Delinquencies, employees and their performance, and
company trends throughout North America.
Designed, developed, tested and maintained Business Objects Reports and Universes.
Responsible for modification and formatting to the existing Business Objects reports and
Universes.
Created reports with multiple tabs with multiple data providers, conditions, formulas, complex
Global and Table filters, sorts, breaks, and master-detail sections reporters.
Worked with the customers and end users for requirements gathering, business analysis,
testing, metrics, and project coordination.
Managed Universes, Business Objects products, Stored Procedures, Repository, and
Document domains.
Created Dimensions, Measure and Detail objects in the Universe.
Created reports using simple to complex reporting tool functionalities.
Created ad-hoc reports for the customers and users.
Defined aggregate SQL functions on measures to improve performance.
Worked on database connections, views, parsing of objects and hierarchies.
Defined aggregate SQL functions on measures to improve performance.
Used the formatting options like cross tab representation, section breaks, data sort options,
calculations, font according to the applications reporting standards.
Used BO functionalities in order to improve the report performance for efficiency and faster
run.
Created SPUFI’s, modified the tables, added and deleted rows from the tables in Teradata in
order to improvise the required data from the database.
Presented features related to Business Objects to the end users and customers.
Scheduled reports on a weekly, monthly and specific time period reports on a regular basis
using Broadcast Agent (BCA).
Provided production 24/7 and on call support for the daily jobs which required immediate
attention and solved the issues promptly.
Technical environment included Business Objects 5.1.8,BO Designer 5.1.8,Web Intelligence
5.1.8,Teradata SQL Assistant 6.2, and Windows XP.
National Grid Feb 04 – Aug 05
Business Objects Developer/Analyst
National Grid is a power and utilities company in the New England and New York regions. This
application has been developed using Business Objects 6.1a and DB2 7.0. This application
captures all the safety related data like injuries, lost time & restriction time due to injuries. Safety
reports were created in Business Objects and built in order to capture the incidents.
Responsibilities:
Designed, developed, tested and deployed Safety Reports Universe.
Interacted with users/customers for getting inputs for the Business Objects reports.
Developed around 100 reports which contains which contains master-detail, cross tab reports
with multiple data providers (files, RDBMS), complex/union queries, prompts, complicated
layouts, breaks and sub-totals, ranking, custom sorts, drill up/drill down,slice & dice.
Used the slice & dice, drill down features of Business Objects for formatting the reports.
Created Business Objects reports customizing for the user browser environment and
scheduled documents using Infoview.
Defined the Universe and BO Report deployment across multiple universe domains and
multiple document domains.
Schedule the reports and send it to the users via email. As soon as the report is generated an
alerter will be triggered letting the user know that a report has been generated. This was
done using the BCA and Publisher.
Created Master-Detail, cross tab reports using data from DB2.
Extensively used Filters in reports.
Created Standard Templates for future reporting needs.
Promoted reports from one environment to another environment.
Created Complex SQL Queries in DB2 7.0.
Implemented Security among the BO Tools using Supervisor.
Worked with classes and objects creation, linking Universes and customizing Universe
parameters.
Generated PDF report file automatically at schedule intervals of time using Broadcast Agent
and Publisher.
Trained the developers in creating reports, universe and its deployment and also to business
users in using Designer, Broadcast Agent (BCA), WebI and Supervisor.
Interacted with Project Manager and other resources in understanding the requirements and
writing Universe, report specifications
Defined and created classes, objects, conditions, and user and measure objects to capture
complex formula.
Created variables, formulae and detail objects at report level.
Resolved the performance issues in report generation.
Tuned the universe for better performance – recommended database views to capture
effective date logic in PeopleSoft tables.
Built Universe hierarchies and facilitated drill down in the BO reports.
Extensively used multiple data providers for building reports.
Technical environment included Business Objects 6.1a, BO Designer 6.1, Web Intelligence
6.1a, DB2 7.0, Windows XP, and Mainframe (MVS/OS 390).
Kraft Foods Jan 02 – Jan 04
Business Objects Developer
Responsibilities:
Involved in designing Supply Chain Management System at Kraft Foods in Chicago in existing
Data Warehouse, for all types of users using Business Objects as front end including Supply
Chain and Transportation Analysts.
These BO reports include information such as products supplied to various Kraft Customers at
Detail and Consolidation level used for Analysis and Forecast using Fact Dimensions and
Aggregate Tables. Some of the reports also give information related to Transportation such as
Carrier, Load, Origin and Destination Information.
Exported the Universes to the Repository to making resources available to the users.
Created BO Reports for various Portfolios using the Universes as the main Data Providers.
Created BO Reports with add-ins/macros to enhance product features.
Created complex SQL Queries, joins, resolving loops using aliases/contexts, resolving fan and
chasm traps.
Interacted with the users extensively for modifying the reports when needed.
Scheduled reports using Broadcast Agent, which involves time, based event scheduling.
Gathered requirements from the user and created reports accordingly used Business Objects.
Customized thick client and thin client environments using VBA Macros.
Created web based reports using Web Intelligence (WebI 2.6.2).
Published reports into different environments using Publisher.
Designed and developed Drilled Reports in Full Client Web Intelligence.
Created Contexts and Aliases for resolving Loops in the Universes.
Involved in production support and gave training to the users.
Wrote Stored Procedures and Triggers in SQL Server 2000.
Promoted Reports using Broadcast Agent Server (BCA) for scheduling.
Also involved in Production Support for existing reports and Universes and security of Business
Objects using Supervisor Module such as adding users, giving access to Universes and Reports.
Publish to the corporate documents repository as a PDF using BCA and Publisher.
Use of BO Reporter, Designer 5.1.2 Query Panel and Data Provider.
Used Filters and Conditions, Slice and Dice extensively.
Customized reports using drill up/drill down features.
Created and monitored user groups from Supervisor.
Have deployed desktop/server products on different Operating Systems for Test Purposes.
Working on Universes, Query Panel, Prompts and Report Layout and re-formatting
Created SQL test scripts for the reports testing and analysis.
Helping in maintenance work related to reports.
Use of Designer Module to implement Universe, Linkages between Tables, create prompts and
queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies
Used Visual Basic Macros to interact with Tabs within reports.
Helping in maintenance work related to reports.
End User Training and System Documentation.
Technical environment included Business Objects 5.1.2, Web Intelligence 2.6.2, Designer 5.1.2,
Teradata and SQL Server 2000.
Contact this candidate