SUNIL GUDURU Phone: 954-***-****

Email: ablyxn@r.postjobfree.com

Experience Summary:

* ** ***** ** ************ IT experience in Business Intelligence, Data

Warehousing, Business decision making methodologies, Database administration, OLAP

and ETL environments.

2 5 years of Business Objects XCelsius, Web Intelligence, Universe Development

and Crystal Reports – Development and Support

3 10 years of Actuate Reporting System 9.0/8.0/7.x/6.0/5.0/4.0 experience

4 10 years of strong experience in Oracle 11g/10g/9i/8.x/7.x, MS-SQLServer,

Informix, SQL, PL/SQL.

5 Extensive understanding of .NET framework, MS-Reporting Services, BizTalk

Server

6 8 years of related UNIX Experience in various flavors

7 3 years of Experience in Project Planning and Management

8 Experienced in Scrum and Waterfall Project Management methodologies

9 Worked in High Volume Databases and developed Reports with performance.

10 Skilled in writing complex queries and stored procedures

11 Highly skilled in writing technical specifications, transforming user requirements

to reporting solutions with better user experience

12 Experienced in architecting the framework in Business Intelligence platform

13 Experienced in Dimensional Modeling, Data warehouse Structures

14 Provided leadership as to the most appropriate technologies and methodologies

to best evolve product solutions

15 Acted as an interface between the User and the Product

16 Strong understanding of ETL implementations as related to Data Warehouse

solutions

17 Possesses significant web development skills

18 Evaluated BI Platforms both branded and open source Business Intelligence

platforms such as SQL Server Integration Services(SSIS), SQL Server Reporting

Services(SSRS), Business Objects, Actuate, Pentaho Product Suites, Jasper Reports, etc

and suggested best Reporting platforms to suit the company requirements and budget

availability

19 Excellent communication, organization and presentation skills.

20 Adaptive in Onsite / offshore model and coordinating with remote team members.

21 Proficient with Service Oriented Architecture and designing BI Architecture as

SOA compliant.

22 Experienced in Consuming WCF Services in Data Integration projects and

exposing Data Integration modules as WCF / Web Services

Education:

B.S in Technology from REC, Warangal, India

M.S in Engineering from Osmania University, Hyderabad, India

Technical Skills:

Languages: C#, Visual Basic.NET, SQL, PL/SQL, T-SQL, Actuate Basic,

Java, JSP, JavaScript, XML

RDBMS: MS-SQL Server 6.5/7.0/2000/2005/2008, Oracle

11g/10g/9i/8.x/7.x, Teradata, Informix 9.4, Sybase SQL Server

11.x/12.x, MySQL, MS-Access 97

App/Web Servers: Business Objects XIR2/XIR3 Server, Actuate iServer 7.x,

Actuate eReporting Server, Actuate Active Portal for .NET / JSP

WebSphere, IIS 5.0/6.0/7.0, IPlanet, Biz Talk Server 2006

OS: Windows 95/98, Windows XP/NT/2000/2003/2008, Solaris8/2.X,

HP-UX 11.0, Linux RedHat 4.0/5.0, MS-DOS

Tools: SQL Server Integration Services, SQL Server Reporting

Services, Business Objects XIR2, R3 Web Intelligence, Desktop

Intelligence, XCelsius, Crystal Reports, Actuate

9.0/8.0/7.2/6.0/5.0/4.x, Business Objects XI, Crystal Reports

Work Experience (Reporting System):

EBay Inc

Business Intelligence / Staff Software Engineer, Austin TX

Nov 2008 to Present

PayPal’s Tech Strategy & Business Intelligence team supports the data needs of PayPal’s

product development organizations through the management of Enterprise Resource Planning

tool and various other tools. To that end this team supports the data and functionality used by

resource managers, project managers, and executives. Additionally, Central Planning partners

with other teams in the organization to support critical business processes.

As a Business Intelligence Professional, I have researched and architected and managed a

Business Intelligence environment that suites the User Project and Portfolio Management. The

existing Actuate BI Platform is migrated to Business Objects BI Platform. Main reporting resource

of the Strategy & Planning group.

Role and Responsibility:

• Analyzed the System and Architected a new Business Intelligence Platform based on the

company’s requirements

• Lead development of data strategy and associated policies driving data integrity and

accuracy

• Build Universe off of the Oracle and Teradata transactional databases based on ERP

data model

• Closely working with the BizTalk team to integrate Orchestrations and Mappings in the BI

Architecture.

• Consuming the exposed WCF services in Data Integration Service modules.

• Exposing the Data Integration modules as WCF Services.

• Project Planning and Management, Resource Management using Scrum methodologies

• Build Data warehouse based on Industry standard data warehousing principles off of

Transactional as a datasource to Reports

• Plan, design, develop, document and test ETL processes, strategies for data acquisition,

validate, cleansing mapping and de-duplication

• Build Web Intelligence Objects for the Business requirements

• Build powerful, interactive and intuitive Dashboards using XCelsius

• Analyze, Design, Develop and Test Crystal Reports

• Convert all Actuate eRD Pro reports to Crystal Reports

• Architect and Build reports and develop new functionality within and on top of the current

system

• Offer creative solutions to organizational-wide issues

• Work with external teams in a fast-paced, high demand environment.

• Work closely with users to design reporting solutions

• Act as an interface between the Product and the Users

• Translate user requirements into specific reporting solutions

• Develop supplementary application functionality

• Support technical solutions which would include interactions with database and hardware

teams

• Won a prestigious Technology Award for providing highest customer satisfaction

Environment: Clarity ERP Reporting System, Actuate, Business Objects Web Intelligence

XIR2/R3, Universe, XCelsius, Crystal Reports XIR2, Oracle 11g/10g/9i, Teradata12, ETL

processes, Clarity Datamart, RedHat Linux 4.0, Sun Solaris 9, Windows XP.

NetTraffic Inc, Sunrise, FL / Trendium Inc, Sunrise, FL

BI / Reporting Architect, GUI

Jan 2005 – Oct 2008

NETraffic

Client: Cisco Systems

The key functionality of NETraffic is monitoring of, and reporting on, the traffic on networks. This

product collects different metrics on various network related metrics such as Hosts, Applications,

Conversations, VLANs, DSCPs etc and provides the network administrator a visibility into his

network, its performance, bottlenecks and troubleshooting.

ServicePATH

Client: AT&T

ServicePATH is a sophisticated, plug-and-play service intelligence system that can collect and

synthesize data from networks, applications or business processes. This synthesized data model

is then used to assess and assure service delivery in real-time. The system identifies anomalies

as they occur, pinpointing their cause and analyzing their effects on services and the business.

Furthermore, ServicePATH can automatically initiate corrective actions to ensure optimum service

delivery and customer satisfaction.

Role and Responsibility:

• Main Reporting Resource of the Company, in-charge of GUI Platform

• Project and Resource Management using Waterfall and Scrum methodologies

• Interacting with the Customer to define, analyze the requirements

• Transforming the requirements into Functional and System Specifications

• Preparation of Reporting Framework, preparing a project plan, allocation of Reporting

Resources, Estimation of tasks, Managing the team, code reviews, testing and deliver to

System test.

• Involved in requirement analysis, design, development and testing of the Reports

Dashboard, ReportsExplorer and around 100 Report Templates

• Analyze, Design, Develop and Test the Actuate Reports for NETraffic and ServicePATH

Products using Actuate 7 and Actuate 8

• Migration path to Business Objects XIR2

• Analyze, Design, and Develop Crystal Reports, Web Intelligence Objects and

Dashboards

• Analyze, Fix and Test trouble tickets

• Develop Component Libraries and published reusable components in them so that other

developers can use them.

• Developed Functional and Technical Design Documents based on the requirements.

• Conducted in Design and Code review meetings

• Worked on CMC to move Repositories and custom Report template installations.

• Involved in various Business Objects Server Administration tasks

• Involved in various Actuate Server Administrative tasks

• Modified various configuration files on Actuate iServer.

• Extensively used IDAPI calls for the integration of ReportsExplorer GUI with Actuate

iServer

• Developed reports for the high volume database. The data coming into the database was

huge with 700, 000 records coming in every 5 minutes.

• Analyze, Design and Develop Universe to meet the Web Intelligence Object needs.

• Develop, manage and administer the Data warehouse for Netraffic.

• Developed reports for Data warehouse and datamart environments.

• Developed ETL processes with SSIS packages for data transfers, data mapping and data

loading of reporting databases used by the reporting system

Environment: Business Objects XIR2 – Web Intelligence, Desktop Intelligence, Universe,

Crystal Reports, Actuate 8SP1/Actuate 9SP3, eReporting Designer Professional, Actuate iServer,

Oracle 11g/10g/9i, RedHat Linux 4.0, Sun Solaris 9, Windows XP, .NET framework

College of American Pathologists, Northfield, IL

Business Intelligence Technical Consultant

Feb 2004 – Jan 2005

The College of American Pathologists (www.cap.org), the principal organization of board-certified

pathologists, serves and represents the interest of patients, pathologists, and the public by

fostering excellence in the practice of pathology and laboratory medicine. Working on the

IEVPSR project that will provide authorized customers and CAP staff, web-enabled-access to the

individual evaluations & participant summary reports and score card reports with navigational

ability. The Evaluation Reports, the Scorecard Reports and the mailing address page that were

being produced by the current SCORES COBOL system will be produced using actuate 7.0 from

the 2005 program year. Team consists of 17 including 5 actuate developers.

Role and Responsibility:

• Worked on massive and very complex reports such as All Analyte Score Card report,

KIT EVALUATION REPORTS (Quant Plot, Intended Response, Good and Acceptable

and Composite formatters), PT EXCEPTION REPORTS, Frequency Distribution Charts

and Mailing Page Reports. These reports are having complex functionality, dynamic

behavior and complex SQLs.

• Developed the framework for the object design and library components for these

reports

• Overridden almost all the frequently used methods such as OnRead, OnRow,

ObtainSelectStatment, SuggestRoiName, AdjustSize, OnEmptyGroup, SetLinkTo,

Finish, Start, etc

• Developed complex charts in Quant Plot report formatter by overriding the methods

available in Chart Builder. Coded the complex behavior charts based on the number of

specimens.

• To improve the performance, Temporary Tables were used in Kit Evaluation Report

and PT Exception Report

• Written the functional, technical and test scripts for the above formatters and used

MS Visio in the above documents to depict/explain the logic behind these reports

• Coded the customized logic, Page Break Rule in every formatter in Kit Evaluation

Report to break based on a group (such as a band or a specimen group)

• Developing the documentation on all these formatters

• Created hyperlinks from PT Exception Report to Kit Evaluation Reports

• Overridden SuggestRoiName method to burst the reports in a designated folder

structure

• Overridden Finish method to insert and update the records in the Informix database

if reports generated successfully

• Overridden SetLinkTo method to create new dynamic .roi file from the current .roi

• Used functions such as to AcReqGenerateReport g enerates or fire a report (.roi) file

from a report executable (.rox) file

• Participated in Blackbox testing to find out bugs in the Actuate Reports

• Supported the User Acceptance Test to fix bugs and to implement enhancements in

the Actuate Reports

• Wrote complex SQLs to get the required data as input to the Actuate Reports

• Gone through whole Software Development Life Cycle(SDLC) in the IEVPSR project

Environment: Informix 9.4, Actuate 7.2, eReport Designer Pro 7.2, Actuate Active Portal for JSPs,

Sun Solaris 8, Windows 2000 Server, Weblogic 8.1

Pioneer Financial Services, Kansas City, MO

BI Technical Consultant

Jan 2003 – Jan 2004

Pioneer is Kansas City based financial services company founded in 1932, serving the

financial needs of US Military people around the world.

Role and Responsibility:

• Developed a system for their reporting needs using Actuate Reporting System 6.0/5.0

• Responsible for Development, Scheduling and Distribution of the reports.

• Developed several reports using Stored Procedures.

• Developed Component Libraries and published reusable components in them so that

other developers can use them.

• Created several reports using Dynamic controls and also exported the output of many

reports to EXCEL Spread Sheets and PDF.

• Created hyperlinks to navigate between Summary and Detail reports and also set Search

Aliases so that users can search for specific values like branches etc.

• Worked with end users to gather requirements for their reporting needs.

• Developed Functional and Technical Design Documents based on the requirements.

• Extensively used Microsoft Visio for the report layout designs.

• Worked on Component Libraries, Multiple Input Filters.

• The Web Reporting was customized by customizing the relevant JSPs, JSs, Struts and

Configuration files

• Worked on Actuate eReporting Server to create Users, Groups and Roles.

• Developed several Master Detail reports and also developed several reports using

Composite Data Streams.

• Installed Actuate Report Server, Actuate Report Cast Server on Windows 2000 Server.

• Used Single Input Filters and Multiple Input Filters to develop very complex reports.

Environment: Oracle 8.1, Actuate Reporting System 6.0/5.0, Sun Solaris 8, Windows 2000

Server, Weblogic 6.1

eScout.com, L.L.C, Kansas City, MO

BI Technical Consultant

Jan 2002 – Dec 2002

eScout.com is a Web based e-commerce and e-business network for independent businesses

and banks. This company is promoted by United Missouri Bank and is located in Kansas City,

MO.

Role and Responsibility:

• Involved in Customization of Actuate Reports to meet the client requirements.

• Responsible for Development, Scheduling and Distribution of the reports

• Worked on Actuate eReporting Server to create Users, Groups and Roles.

• Designed several report templates for reusability and extendibility.

• Customized component palette for default settings.

1Converted SQR Reports into Actuate Reports with enhanced functionality and additional

actuate features.

• Actuate Report Server Administration including creating users, folders, assigning

privileges to users, copying report files to report encyclopedia and scheduling reports.

• Used Single Input Filters and Multiple Input Filters to develop very complex reports.

• Installed Actuate Advanced eReporting Server, Actuate Report Cast Server on Windows

2000 Server.

• Extensively worked on Component Libraries, Multiple Input Filters.

• Developed several Master Detail reports and also developed several reports using

Composite Data Streams.

Environment: Oracle 8.1/7.x, Actuate Reporting System 5.0/6.0, Crystal Reports 8.0, HP- UX

11.0, Sun Solaris 2.8, Weblogic 6.0, Windows 2000 Server

GE Power Systems, Atlanta, GA

BI Technical Consultant

Apr 2001- Dec 2001

Role and Responsibility:

Worked with end users to gather requirements for their reporting needs.

1

Generated reports for NOCC & OSSC users Groups

2

Developed Functional and Technical Design Documents based on the

3

requirements.

Extensively used Microsoft Visio for the report layout designs.

4

Responsible for Development, Scheduling and Distribution of the reports.

5

Worked on Component Libraries, Multiple Input Filters.

6

Worked on Actuate eReporting Server to create Users, Groups and Roles.

7

Developed several Master Detail reports and also developed several reports

8

using Composite Data Streams.

Installed Actuate Report Server, Actuate Report Cast Server on Windows 2000

9

Server.

Used Single Input Filters and Multiple Input Filters to develop very complex

10

reports.

Converted several reports from Crystal Reports to Actuate Reports.

11

Environment: Actuate 5.0, Actuate Developers Workbench, Actuate e Report Designer Pro,

Actuate Administrator Desktop, Weblogic 6.0, MS-SQL 6.5, Solaris 8

WorldCom, Ashburn, VA

Reporting Consultant

Aug 2000 – Mar 2001

Developed the Major Web Reporting Application StatusPro For the Group ECOMS.

StatusPro is an Intranet Web Reporting Application and The Data is accesed from various

Sub Systems with different databases Oracle, Sql Server, and Sybase. Actuate Reports are

Created on various sub systems and deployed on to StatusPro Web Application.

Role and Responsibility:

• Play the role of guiding the 4 Actuate programmers.

• Requirement gathering and Writing Functional and Technical Specifications, and MockUp

Reports.

• Writing PL/SQL Stored Procedures, Functions to access the data from different

Source systems and Tables.

• Creating Custom Libraries to meet the Business requirement.

• Designing the Complex Reports, Summary and Drill Down Detail Reports.

• Validating the User input data using Javascript and Browser scripting Controls.

• Worked with Scheduler, and provided option to the users to run reports on demand and

Scheduling option from the Browser/Application.

• Provided Page Level Security to The Users by RSSE.

• Created Export to Excel Functionality from the Browser with Single click Button and with

no Button by calling Excel API.

• Provided the Facility to user to convert Actuate ROI into PDF format.

• All Reports are designed with the ability of Error / Exceptional handling.

• Evaluating the Report performance in terms of run time and tuning the SQLs

• Taking the responsibility of Administration/Upgrades/Migration of Report Server.

• Providing 24/7 support to the Production environment, production releases and QA

cycles.

Environment: Actuate 5.0/4.1, Java, Oracle, SQL Server, Windows NT, Solaris 8, Web Logic 5.1,

JavaScript, and HTML.

Work Experience (Other)

AP Technology Services, Hyderabad, India

Team Lead / Programmer

Document Management System

Aug 1999 to July 2000

AP Technology Services is Software Development wing of Government of Andhra Pradesh.

This system is developed for use in engineering departments of Andhra Pradesh Government

Documents are the backbone of the Department, influencing the total workflow. Documents play

crucial role in deciding the feasibility, selection, implementation and monitoring of various

Engineering Projects. The Documents move up and down the department's ladder starting from

the initiator, middle level decision-makers, and senior level decision-makers to top decision maker

and then back to initiator for implementation. As the Department is vast and the projects

undertaken are varied, there are multiple initiators, middle & senior level managers influencing

upon the final decision to make. This System is being developed to deploy on the Department's

Intranet for tracking down the documents under the above process and get the status of each of

them at 24 * 7 basis.

Role and Responsibility:

• User Interfaces are created in VB 5.0

• Considered all the constraints provided by the Oracle database.

• Software Requirements Analysis, Analysis of Work Flow, Architecture, Design, Project

Scheduling & Monitoring and Testing.

Environment: VB 5.0, Oracle 8.0, Windows NT

AP Technology Services, Hyderabad, India

Programmer

Government Orders Information System

Aug 1998 to July 1999

AP Technology Services is Software Development wing of Government of Andhra Pradesh.

This system is developed for use in engineering departments of Andhra Pradesh Government

This System provides a source safe for Government Orders of the Andhra Pradesh State

Government pertaining to the Engineering Department issued from time to time. Government

Orders consist of rules and guidelines to be followed by the Department for its efficient

functioning. Interface is created in HTML and the index page is provided with the various areas

the Roads and Buildings Department deal with, viz. Roads, Buildings, National Highways, Service

Matters, etc. As per the requirements, users can brows through his area of interest. Every

Government Order carries links or references to various Government Orders issued earlier. The

HyperText Markup Language is used to link and retrieve the earlier references.

Role and Responsibility:

• Architecture, Design and Development and Maintenance of the System.

Environment: HTML 4.0, DHTML, Javascript, Weblogic 5.1, Windows NT

AP Technology Services, Hyderabad, India

Programmer

File Information Automation System

Feb 1997 to July 1998

AP Technology Services is Software Development wing of Government of Andhra Pradesh. This

system is developed for use in engineering departments of Andhra Pradesh Government.File

contains Office Note and Currents or Correspondence received or sent by this Office. Each

Engineer in the lower-tier of the cadre is incharge of many files on various projects going-on all

the over the State under particular Specialization such as Buildings, Roads, Bridges, etc. All the

details about these files have been automated. The system is designed such that at any instance,

it can be known that which Engineer is incharge of which project under the given specialization.

The attributes in this system are: File number, File name, subject, Date of opening, Gist of the

subject dealt by the file, officer incharge, etc.

Role and Responsibility:

• Coding and testing of the system

• Maintenance of the System

Environment: V.B 5.0, MS Access 97 and Windows NT

Yukthi Software Solutions, Hyderabad, India

Programmer

Patient Information and Blood Management System

Aug 1996 to Jan 1997

Global Hospitals is the client and it is one of the biggest Super Specialties Hospital located in

Hyderabad, India.

Role and Responsibility:

Developed a system that keeps track of Patient Information Management and Blood Bank

Management. The Patient Information Management System is an interactive package that

performs information processing and maintains various functions of a hospital. This system

supports various Activities of hospital like Blood Bank, Pharmacy and Billing. Patient

management keeps track of In-Patients and Outpatients information, Operation scheduling, Room

management. Billing keeps the complete bill for the services. As a programmer involved in

design, development, testing and implementation of the Patient Information System.

Environment: Oracle 7.1, Forms 4.5, Reports 2.5, and Windows95

Contact this candidate