Deepthi Madhavaram

ab8xu6@r.postjobfree.com 937-***-****

SUMMARY:

Around eight years of progressively responsible experience in all phases of Data Warehouse

lifecycle development & production support applications using Internet, Web and Client

Server Technologies in N-Tier Architecture

About 5 years of experience in Web Focus Developer Studio and Maintain,Infoassist and

4 years of experience Business Objects suite like Reporter, Designer, Broadcast Agent

Server, Info view, Central Management Console, Central Configuration Manager,

Desktop Intelligence and Web Intelligence.

Worked closely with IBI in troubleshooting various coding issues in developer studio and

maintain and also provided solutions on the IBI forums.

Strong experience in RDBMS using Netezza,DB2, Oracle 8i/9i/10g/11i, Exadata, Teradata

V2.R6, SQL Server 2000, MS Access.

Creating clusters or master files of metadata and tables used by joining them in the

synonym editor and created MQV’s and sql queries to retrieve data efficiently from

databases and also created views on the database having logic for certain complex reports

to improve efficiency and performance.

Designing and building simple, complex, adhoc and compound reports in all possible formats

(HTML, AHTML, EXCEL and PDF) using Webfocus, Business Objects.

Analyzing business requirements and working closely with the various application teams and

business teams. Documented user requirements, translated requirements into system

solutions & developed project plan. Worked with DA's and DBA's taking the role of a tech

lead as required to manage any requirement changes coming up.

Developing HTML pages or Forms for publishing the reports on the web using Java, Java

script and HTML and Created Data collection screens for Business using Webfocus Maintain,

VB script and Java.

Created summarized pdf/excel reports and provided color coding sorting and grading

functionality on the metrics.

Providing quick reporting solutions across the team and writing UT test cases for testing team

Designing and implementing standard and multi-dimensional reports using Crystal Reports/

Crystal Enterprise 8/9/10/XIR2/R3 (Business Object Enterprise), Design and Development

of Relational database management system using MSSQL Server, Oracle, DB2, Teradata

and MS Access.

Experience in building Universes, retrieving data using Universes, Personal data files,

Stored procedures, Free hand SQL methods and creating complex reports, ad-hoc

Reports using the Business Objects and Web Intelligence Tools.

Have good knowledge of ETL tools IWAY suite,Datastage 7.5.1 and Informatica 8.6.0 .

Strong skills in development and deployment of reports for Sales and Marketing, Finance

and human resource department in manufacturing, insurance and software companies.

Extensive experience in the support and operational role with the skill set required for

providing technical maintenance, monitoring, problem diagnostics and troubleshooting with

analytical mentality for the existing applications.

Well experienced in Full Life Cycle of reporting including Report Authoring, Report

management and Scheduling, Report Delivery and Publishing, and Report Security.

Create different type of reports including: Cross-tab, Conditional, Drill-down, Summary,

Form/Mailing label, OLAP CUBE and Sub reports,Financial(FML) and formatting,

Mapping, Grouping, Sorting, Alerting, Field highlighting, Drill-down, Static and

Dynamic/Cascading parameter prompts.

Possess sound knowledge on various phases of software development cycle including

analysis, document, design, development, testing, Implementation .

Experienced in using Microsoft Office: MS Word, Excel Spreadsheet, PowerPoint and

Outlook.

Page 1 of 9

Excellent Communication, Interpersonal, Presentation, Documentation skills and

understanding of Business Procedures strong ability to work as an individual and as a Team

player.

Trained users on WebFocus, Infoassist,BO and Crystal reports and worked on their

migrations by working closely on the admin side .

Skills Set:

Operating Systems : Windows 2000/NT, Windows 2003 Server, Windows 95/98/XP, UNIX.

Business Intelligence : WebFocus 7.7.02/7.6.11/7.6.10/7.6.8/7.6.4, Maintain,Infoassist, BO

XIR3/XIR2/XIR/6.5/5.5, Web Intelligence 2.7.1/6.0, Broadcast Agent 5.5, Info

view, Crystal Reports XI-R2/XI/10.0/9.0,SSRS.

ETL Tool : IWAY Data Integrator,Informatica 8.6, Datastage 7.5

Databases : Netezza,Oracle7.3/8.1/9i/10g/11i, DB2 8.0, MS-Access 97/2000

and SQL Server 2000

Languages : FOCUS, PL/SQL, Shell Script, Java Script, C/C++, HTML, XML, CORE

JAVA.

Data Model Tools : Erwin, Designer 2000.

Fidelity Investments, Durham, NC Oct ’12- Present

Project : Catapult Active Reporting

Senior WebFocus Consultant

This project is to build a robust web based platform that is accessible internally or externally to the users as per

their entitlements. Also to enhance resource effectiveness and drive incremental revenue by providing users with

increased data transparency through a single flexible tool that enables on-demand access and manipulation in

order to meet a variety of needs.

Responsibilities:

• Installed and configured the web Focus 7.6.11. Client.

• Interacting with the Business Users to analyze the business process, gathered the user

requirements and made necessary design document of the requirements to fulfill their reporting

and business needs.

• Gathering requirements for active reporting functionality for existing reports.

Nationwide Direct(NSS), Columbus, OH May ’11-Aug ‘12

Project : NSS Lead Admin tool(CCM/LMT)

Senior WebFocus Consultant

Nationwide has identified a need to improve the process and tools used by Nationwide Sales Solutions (NSS) to

manage leads and campaigns for sales and retention efforts. The Capacity and Campaign Management (CCM)

initiative was created to improve the process by which ad hoc leads and campaigns are planned, prioritized,

assigned and tracked.

Responsibilities:

• Installed and configured the web Focus 7.6.11. Client.

• Interacted with the Business Users to analyze the business process, gathered the user

requirements and made necessary design document of the requirements to fulfill their reporting

and business needs.

• Provided users training on using webFOCUS Dashboards and also in using the adhoc tool

Infoassist.

• Created reporting objects for the business users to create their Ad hoc reports using Infoassist

• Worked on designing different database views which are to be used directly in the reports by

creating their synonyms.

• Created compound reports involving complex logic and reports also included graphs containing

multiple across fields and displayed by day and by hour.

• Created html forms and dashboards and enabled show/hide functionalities on different

dropdowns and toggle around reports and switch between links.

Page 2 of 9

• Worked on creating drill down reports and reports with promptable date ranges .

• Worked on troubleshooting and improving the efficiencies of sql queries as a part of

performance tuning.

• Responsible for migrating all the reports from development environment/ after the unit testing to

the test environment for the system testing and UAT prior moving to production.

• Worked closely with the admin team on migrations, server issues, issues on info assist

performance in production.

• Worked on writing up a POC on integrating webfocus and java web pages without enabling

webservices on webfocus servers and also prepared POC’s for various business needs as Single

Sign On showing webFocus capabilities.

• Worked on testing the reports, providing analysis of the data and troubleshooting/fixing the

defects created in test and provided production support.

• Support business/clients continuously on their requirements and on reports using Infoassist.

WendysArbysGroup, Dublin, OH Mar ’10-Apr ‘11

Project 1: Enterprise Management Reporting Dashboard

Web Focus Developer

EMRD enables the management teams to access operational metrics including sales, labor cost, food

cost, speed of service, cash control, customer service and many other key business indicators

consolidated at every level of hierarchy. This user friendly application helps management in making

improved decisions in a timely manner, leading to improved operational performance throughout the

system. This application currently supports over 400 users and around 200 District Managers

continuing with additional users.

Responsibilities:

• Installed and configured the web Focus 7.6.8. Client.

• Interacted with the Business Users to analyze the business process, gathered the user

requirements and made necessary design document of the requirements to fulfill their reporting

and business needs.

• Developed adhoc reports in web Focus by using the Adhoc functionality of the tool and also

provided calendar controls.

• Used MQV’s and wrote efficient SQL queries as a source of retrieving data from the database for

various reports.

• Created different tabs for period/weekly/daily reports on the dashboard and provided users

different views of the reports by creating compound reports .

• Provided drilldown and breadcrumbs functionality to the users to enable them navigate

through the drilled regions and help them return back to the levels they drill from.

• Created preferences tab on the dashboard where in any user can set their preferences of areas

accordingly and enabled entitlements for users specific to the regions they are assigned.

• Created links for standard and detail views of the reports, trended views where in the reports are

supposed to show up 2 yrs worth of data.

• Provided links to various sub reports from the main reports.

• Worked on switch to functionality to enable the users toggle between different reports within a

tab.

• Worked on providing the users functionality to export the reports to PDF/Excel and also worked

on printing all reports at a time to different formats.

• Worked on the upgrade of web focus 7.6.8 to 7.7.1, documented and fixed all the formatting

and html issues on the upgrade.

• Provided users the functionality of sorting and ranking among the metrics on the reports.

• Enabled users with a bulk or a compound view of hierarchies and to view all districts/areas/stores

in a particular region.

• Developed Stoplight functionality on the reports which show color coded display on the metrics

as graphs or as backgrounds based on different ranges of operational goals .

• Worked on converting the period tab to different views based on the categories of sales and profit

to accommodate more number of reports on single html form .

Page 3 of 9

• Created summary reports based on financial reporting[FML] to fulfill the client requirements

on showing the metrics as titles (cross tab).

• Scheduled periodic reports using report caster and emailed them to the enterprise reporting

user group.

• Created html forms and enabled show/hide functionalities on different dropdowns and toggle

around reports and switch between links.

Project 2: Arby’s The MOOD

This project was to create a MOOD Dashboard/Brand Delivery Scorecard to give operators a

snapshot view of operational measurements. The scorecard displays the performance with a number

and color code. Green will represent restaurants that are operating at a high-level, Yellow will show

restaurants performing at a moderate level and Red will show restaurants that are failing to meet

Arby’s Standards. The MOOD Dashboard/scorecard enables the high level authorities to make

decisions on their business in all respects.

• Worked as a lead Developer and created a dashboard based on the scorecard requirements.

• Developed reports mostly according to the standards of Wendy’s and provided common

functionalities to the Arby’s scorecard users.

• Provided additional features like calendar controls which allows the users to pick their date

ranges according to the options provided with 90day, date pickers and fiscal calendar ranges .

• Created reports with hyperlinks which show the summarized views of the color coded

restaurants on the overall scorecard which give the users a clear picture of grading of restaurants.

• Enabled sorting on the metrics and also show/hide functionality on the metrics according to the

standard and detail views.

• Created html forms for setting the preferences on default views for a user based on security.

• Provided training to the users and helped in demonstrating the client the functionalities to be

provided.

• Created reports with drill down and full page functionality that enables the user to be in specific

reports they need.

• Enabled color coding, grading and ranking on metrics by creating tables and updating the

ranges for the metrics to be graded.

• Worked on troubleshooting and improving the efficiencies of sql queries as a part of

performance tuning.

Environment: WebFocus7.6.4/7.6.8/7.7.01,Windows XP/Pro, Oracle 11i/10g/9i

Nationwide Insurance, Columbus, OH Apr ’08- Feb’10

Project 1: Sales Management System

Web Focus and Business Objects Developer

SMS is the sales management system which helps the business users to analyse and monitor the

sales progress through the various reports developed and the screens where in they can grant access

only to the secured business users to drive through the dashboard. The indicator pages on the

dashboards indicate the total sales per yearly, quaterly, monthly, weekly and daily basis and give the

business a quick overview on what is going on with the sales.

Wholesaler (internal & external) and their management use a web based application to aid

in the affective management of firms and producers within their territory. SMS allows

wholesalers to see transactional, statistical (contract counts), activity counts and goal

information for their territory(s). In addition, SMS aligns with the sales process and

allows for the identification of what producers are in the Top 200, Top 50 and Non-Top

200 and the producers associated segment score. The intent for SMS is to allow

wholesalers to access one site to obtain any territory information they could possibly need

to help them identify the correct producers they should target either for increased premium

or an opportunity to decrease surrenders.

Internal Nationwide Financial management use SMS to see a consolidated picture of all

product lines doing business within NF. The intent is to make is easy to use and provided

Page 4 of 9

the closest alignment with the general ledger on a daily basis. In addition, to providing

reporting based on statutory reporting, internal management like wholesalers can see the

progress of all selling organization (sales organizations) within NF.

Responsibilities:

• Installed and configured the web Focus 7.6.4. Client.

• Interacted with the Business Users to analyze the business process, gathered the user

requirements and made necessary design document of the requirements to fulfill their reporting

and business needs.

• Decommissioned the preexisting actuate reports and converted the reports to webFocus by

using the terms and codes of webFocus.

• Analyzed the existing database and designed the clusters by joining the required tables and

synonyms, incorporating all the Business requirements.

• Defined the required fields of the reports and developed the reports with required formats using

Focus language.

• Developed compound reports in Excel format, AHTML, PDF and HTML formats different tabs on

various fields for SMS users in order to access the reports..

• Created HTML forms containing the parameter selection boxes for the reports.

• Created number of reports using the developer studio, including graphs using advanced graph

assistant and drill downs on the fields.

• Created batch reports and alert procedures and scheduled reports using report caster.

• Worked on various enhancements of SMS like user security dashboards, firm goals

enhancements and formatting.

• Developed different types of data collect screens using Maintain for the business users to

insert, update and delete all the required data.

• Trained users on using the maintain screens on the way they can assign the users by using

the secured screens.

• Used Grid reporting, HTML tables and drill downs to different screens on the reports.

• Embedded different java scripts in maintain forms in order to show pop up messages for inserts,

updates and deletes and success or error messages.

• Migrated all the reports from development environment after the unit testing to the test

environment for the system testing and UAT prior moving to production.

• Responsible for testing all the developed reports and the impacts once webfocus7.6.4 was

upgraded to 7.6.8.

• Worked on different enhancements on the developed reports as per the new requirements from

the business.

• Developed different types of reports and charts based on the user requirements for business

managers like monthly, quaterly and yearly comparitive analysis on sales using dashboards.

• Provided production support for the applications and enhancements developed.

Project 2: Data Quality

This project supports the Nationwide Financials (NF) strategic business goals by enhancing

the detection and reporting of the NFIDS Business Intelligence (BI) data and flow quality

issues. This work product specifies the design of the dashboard for reporting of the

anomalies. There are 3 reports Transaction Data summary report, and drill down report on

Home tab, and Transaction Error Detail report on Transaction Error Detail tab where in the

user can continuosly access the dashboard and monitor the batch reports and take care of the

abbends and also monitor the performance.

• Performed the role of a tech lead and Gathered requirements and created design documents by

providing the webFocus component model and the mock ups of the reports to be displayed on the

dashboard.

• Used the logic for search criteria on the forms, which allows the business users to search for

their producers, firms or any other fields as per the requiremnts so that they can directly generate

the report for that particular producer or firm.

Page 5 of 9

• Used the logic of creating hold files in the reports to increase the perdormance of the reports.

Project 3: FMR and Pensions eDelivery

• Performed the role of a tech lead and Developed monthly reports and scheduled them using

report caster and delivered the reports in excel format as email using webFocus.

• Created stored procedures for pension reports and also used FTP for the eDelivery reports

where in the processes were created and updated according to the schedule.

• Used date conversions for different timestamps in order to display the format needed by the

business.

• Worked on ETL using informatica, created mappings and loaded data for reporting as a part of

the project.

• Extracted Data from multiple databases in order to meet the reporting needs.

• Built some of the reports using business objects where in there were new metrics added for the

reporting.

Project 4: Datacollect screens

The purpose of this project is to re-write four of the Data Collect Screens, Firm, Firm Alliance, Firm

Grouping and GA Assignments. In the Firm Goal Bundle project, one the deliverables was to allow

the business customer to remove firm alliances that no longer exist and also add edits to eliminate

duplicate firm alliances. Another deliverable was allow the business customer the ability to remove

firms on the Firm Screen that no longer have GA Assignments tied to them and add edits to eliminate

duplicate firms using Web Focus Maintain screens.

• Built screens in Maintain, which allow the business user to search, add, delete and update

records to the database the firms attached to users according to the business .

• Used java sripts for showing the pop up messages whenever a job is a success or fail.

• Built user security on the screens and provided calendar icons on the screens for the users

to select their time period and make the changes as they wish .

Environment: Netezza performance Server,WebFocus7.6.4/7.6.8,Windows XP/Pro, Oracle

11i/10g/9i, DB2, Business Objects Enterprise XI R2/R3, Crystal Enterprise 9/10.0/XI, SQL Server

2000,Merant Version Control.

City of Omaha Public Schools,NE Aug ’06 –

Mar ‘08

CRT

WebFOCUS and Business objects Developer

CRT is the data driven decision making for the student acheivments at OPS.This would help OPS

improve the overall cirriculum as well as determine how to address each child’s needs so they can be

more successful in their learning.CRT helps in the better understanding of the performance of an

entire grade.By entering CRT information online teachers can generate reports from the database

directly whenever needed.

Responsibilities:

• Installed and configured the web Focus 7.6.1. Client.

• Interacted with the Business Users to analyze the business process, gathered the user

requirements and made necessary design document of the requirements to fulfill their reporting

and business needs.

• Analyzed the existing database and designed the clusters by joining the required tables and

synonyms, incorporating all the Business requirements.

• Combined a wide variety of both mainframe legacy data and modern data underlying

client/server information systems such as SQL Server by managing complex joins among them.

• Defined the columns of the reports and developed the reports with required formats using Focus

language.

• Worked with the webFOCUS admin team to install the new versions and to provide solutions on

the server side.

Page 6 of 9

• Created online reporting system using WebFOCUS Maintain and developer studio using the

FOCUS language code by integrating SQL statements.

• Developed maintain screen which allows any entrys to district CRT and displays list of students

in a class which helps OPS analyze the data.

• Provided authorization to a set of users by creating user security.

• Developed reports and assisted the QA team with the queries generated from the report by

letting the traces ON.

• Worked intensively with IBI in troubleshooting the coding issues of the application requirements

• Worked on business objects migration from Business Objects 6.5.1 to XI R2.

• Created hundreds of adhoc reports for users.

• Created number of reports for each Campaign, based on sales.

• Assisted the QA Team in testing the reports for data validation and formatting by providing

access through Infoview.

Environment: WebFocus7.6.1,Windows XP/Pro, Oracle 10g/9i, DB2, Business Objects

Enterprise 6.5/XI R2, Crystal Enterprise 9/10.0/XI, Microsoft SQL Server 2000

Chrysler Corporation, MI Jun ’05 -- Nov ’06

Campaign Management System

Business Objects Developer

CMS is the up-gradation of the legacy Campaign Support System to enable the straight through

processing to realize the benefits of a particular campaign through Business Objects reports.CMS

provides day to day benefits of campaigns throughout the campaign period. CMS is helpful to the

Business Users like Directors and Campaign Managers to take the top level decisions and to target

customers who are into the market for new cars or trucks. For CMS, data comes from various

systems like Mainframes, files (from Government, Marketing companies) etc and are loaded into DB2

database which was of 2 Terabytes.

Responsibilities:

• Installed and configured the Business Objects 6.5.1.

• Interacted with the Business Users to analyze the business process, gathered the requirements

and made necessary changes to schema objects to fulfill their reporting and business needs.

• Analyzed the existing database and designed the Universe, incorporating all the Business

requirements.

• Defined Business Objects Classes and Objects, created complex Universes and Reports.

• Resolved loops in Universes using aliases to remove cyclic dependencies.

• Checked the Universes for Integrity and exported them to the Repository to make resources

available to the users and groups.

• Migrated and developed Business Objects 6.0 to 6.5 and also to XI according to the

requirements

• Migrated the Repository Objects from one environment to another using the Import Wizard.

• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down,

Functions, Cross Tab, Master Detail etc.

• Created Groups and Users folders and granted effective access rights to the reports and other

Business Objects Tools using the CMC.

• Validated the report’s data by querying the Database using Datastage.

• Worked with Business Users to gather requirements and to train users using reporting tool.

• Created adhoc universe only for particular set of business users.

• Created one report for all the campaigns of that year along with graphs.

• Worked closely with data delivery team to provide customers count for particular Zip code, City,

State etc.

• Worked with BO Admin and DBA to create row level security.

• Assisted the QA Team in testing the reports for data validation and formatting by providing

access through Infoview.

• Created Ad-hoc reports using the WebIntelligence XI R/2.

Page 7 of 9

• Developed different types of reports and charts based on the user requirements for business

managers like monthly,quaterly and yearly comparitive analysis on sales using crystal

reportsXI

• Developed reports using complex formulas with running totals based on grouping, dynamic

and cascading parameters and subreports in the crystal reports environment

• Scheduled the reports to the Users in different formats (PDF, Excel) using the Infoview.

Environment: Windows XP/Pro, Oracle 9i, DB2, Business Objects Enterprise XI R/2, Crystal

Enterprise 9/10.0/XI, SQL Server 2000,Merant Version Control.

AP Transco,India Jan ’05 – Jun ’05

FOCUS Developer

This Company is responsible for electricity production and they maintain a state’s record of utility users and their

billing cycles.

Responsibilities:

• Created the System Specifications for the reports as per the Business Requirements

• Involved in creating reports, datamarts and its deployment

• Interacted with Project Manager and other resources in understanding the requirements and

writing universe, report specifications

• Defined and created classes, objects, conditions, user and measure objects to capture

complex formulae

• Involved in upgrading to new versions and developed reports in the upgraded version.

• Used multiple data providers for building reports

• Created variables, formulae and detail objects at report level

• Created reports using slice & dice, drill down, Cross Tabs, and performed complex calculations

to set conditions on data

• Resolved the performance issues in report generation

• Exported the various versions of reports across different Domains.

• Interacted with Business Analysts and end users to develop standard and ad-hoc reports

according to functional specifications. Also carried out analysis and documentation of detailed

requirements.

Environment : Windows 2000, Oracle 9i, PL/SQL, WebFocus,Business Objects 6.1/6.5, Web

intelligence 6.1 .

South Central Railways, India Aug’ 04 - Dec’ 04

Software Programmer

Description: Was involved in the design, development and testing of a fuel management system for

the railway sector. This system mainly deals with the transactions of the Railway Consumer Depots,

stocking yards for fuels like coal and diesel. The fuel management system kept track of all fuel

transactions such as daily receipts of fuel from vendors and supplies to different trains. The system

increases the accuracy in fuel management by maintaining the details of responsible employees for

each transaction, cross checking of actual stock with total issues and receipts etc. It also maintains

the details of trains, which will be attached to fueled locos, routes traveled by trains, types of services

of trains, and types of locos, etc. Dip readings of the storage tanks will be converted into litres as per

calibration chart of that particular tank. It generates various reports according to railways format,

helping higher authorities to take necessary actions and also to monitor the day-to-day activities of

Rail Consumer Depots.

Environment: Windows 95/NT, UNIX, Oracle 8.0, and Visual Basic 6.0, Crystal reports.

Transport Management System, India Mar’ 04 - Jul ’04

Developer

Page 8 of 9

Description: This software package keeps track of supplies of the petroleum products to the

customers from various depots of the suppliers. The supplier bills are re-issued for the customer .It

maintains the inventory of main modules like Master, Transaction, Inventory and reports.

Responsibilities:

• Involved in Designing and Developing of complete reporting application.

• Created PL/SQL Procedures, packages (With Business logic) and Triggers.

• Developed Oracle SQL scripts and PL/SQL functions

• Development, test and deployment on an Oracle 7.3 Database.

• Generated reports using Crystal Reports.

Environment: Visual Basic 4.0, Oracle 7.3, SQL, PL/SQL, Crystal Reports 4.5

Page 9 of 9

Contact this candidate