Data Sales

BANDLA SRILAKSHMI

Ph: 715-***-**** **********.******@*****.***

Professional Summary:

. Over 8 Years of experience in Analysis, Design and Development of

software applications and Business Intelligence projects under

different environments.

. Proven track record of successful implementation of all project life

cycle stages from requirements gathering through implementation and

enhancements.

. Technical hands-on expertise in using Business Objects 4/5.x/6.x/XI

r1/r2/r3 (Supervisor, Designer, Reporter, CMC, CMS, CCM, Web

Intelligence, Desktop Intelligence).

. Installed Business Objects XI r1/r2 using Tomcat and Apache as

Application and Web Servers.

. Extensive experience in designing Business Objects universes and

reports. Created reports using functionalities like queries, slice and

dice, drill down, functions, filters & formulae.

. Experience in building Universes, Stored Procedures, Free Hand SQL

methods and creating Complex and Ad-Hoc Reports using Business

Objects.

. Excellent understanding of Star Schema modeling, Snowflake modeling.

Fact, Lookup and Dimensions Tables.

. Experience working with Oracle 8i/9i database, including analysis,

design, coding, testing and maintenance of the database. Experience in

data conversion activities.

. Expertise in writing SQL queries, PL/SQL scripting, Triggers,

Procedures & functions on the Windows platform.

. Proficient in Visual Basic 6.0, SQL Server, HTML and C++.

. Worked on various development platforms Windows NT 4.0/2000/98/95

. Managed and delivered large and complex assignments within time/cost

and service level parameters.

. Strong technical, communication, time management and interpersonal

skills.

. Confident, independent, leadership skills, good decision-making

abilities.

Technical Skills:

Business Intelligence Tools : Business Objects XI r3/r2/6i/5i, Web

Intelligence 6.5, Cognos, Impromptu 6.0, and

Crystal Reports 10/9.

Databases : Oracle 7.x/8i/9i, MS SQL Server 6.5/7.0/2000/2005,

MS Access 2000, Teradata V2R6, Oracle Essbase.

Data Modeling Tools : Erwin 4.1, Microsoft Visio.

Web Servers : Web Logic 5.1/6.1, IIS 4.0, Apache 1.3, JSDK 2.1.

Languages : Java, C++, C, COBOL, PL/SQL, HTML, Visual Basic

Operating Systems : Windows 95/98/NT 4.0/2000, XP.

Professional Experience:

People's United Bank Bridgeport, CT

Nov 2009 to Present

Business Objects Consultant

People's United bank is a financial services company with over $22

billion in assets provides consumer and commercial banking services with

approximately 300 branches in Connecticut, Vermont, New Hampshire,

Massachusetts, Maine and New York. At People's we developed reports from 2

different data source systems (BIC and FIS). This BI implementation helped

the regional operations unit located throughout the US to monitor their

transactions and their performance. I was involved in requirement

gathering, writing requirement specifications and designing the reports

(Analyst and Developer).

Responsibilities:

. Gathered information from the user to design Web intelligent reports.

. Referred to the existing crystal reports and designed new reports.

. Modified the existing reports based on the changes done by user

requirements.

. Documented the reports and SCR's if changes are made in common share

point.

. Captured all the data provider, variables and universe level

information pertaining to the PC reports and documented the same.

. Created user variables and functions on the report side.

. Used multiple universes and linked them by merging the objects.

. Improved the performance of the reports by using filters and reducing

the functions.

. Documented the web intelligence XIR2 reports for any further

modification purpose.

. Closely working with ETL team to get the data in the required format.

. Did Data Cleansing on the report such as standardizing addresses.

. Used filters, breaks, sections, drill downs, sorts and calculations.

. Used merge and extended merge concepts.

. Used prompts for the users to generate specific reports.

. Formatted the reports, for the convenience of the users.

. Used basic universe and used a lot of functions in reporting side.

. Reports are stored in BO folder or as PDF or Spread Sheet.

. Identified issues with some of the reports with ambiguous data and

resolved the issues.

. Scheduled Reports using scheduler based on the frequency of the

reports.

. Performed data validation by writing SQL queries and creating ad hoc

reports using Web intelligence.

Environment: Business Objects XI R2, Business Objects Enterprise XI R2, BO

Designer, Infoview, Oracle 10G, Sybase, Windows XP/2003.

Sprint Wireless Herndon, VA Sep 2008 to Sep

2009

Business Objects Consultant

Sprint is the wireless CDMA Carrier in the United States, with more than 40

million subscribers who use the nation's largest digital voice network. The

company's data come from different operational sources and is stored in a

data mart and then data is transformed and loaded into a centralized data

warehouse for various Strategic Business Reports. I was involved in

requirements gathering from the business users and building the Reporting

Applications.

These Reports give the marketing representatives and agent's information

about the product offering and revenue generated from different product

lines.

Responsibilities:

. Created slides for data flow and process flows using PowerPoint and

Microsoft Visio for better understanding of the business.

. Created Web Intelligence XIR3 reports, graphs and charts facilitating

drill down.

. Involved in requirements gathering from the business users to build

various strategic Business Reports.

. Created Categories and published Business Objects reports.

. Maintained and modified the existing reports depending on the user

requirements.

. Captured all the data provider, variables and universe level

information pertaining to the PC reports and documented the same.

. Resolved the loops using Contexts and Aliases.

. Pointed some of the reports to the new universe, tested and deployed

them into production.

. Improved the performance of the reports by identifying the issues and

recommending aggregate tables and creating indexes.

. Documented the web intelligence XIR3 reports from Management Reports

folder.

. Involved in data maintenance process using Oracle9i, PL/SQL

procedures, functions, triggers on Windows NT platform.

. Got the data from multiple data sources like Oracle 9i,Essbase cubes.

. Identified issues with some of the reports with ambiguous data and

resolved the issues.

. Scheduled Reports using Scheduler.

1. Created Visualizations using Crystal Xcelcius.

2. Created multiple Dashboards using Crystal Xcelcius with consolidated

data for better analysis.

. Hands on experience using Dashboard manager and Performance Manager.

. Created Hierarchies to facilitate drill down.

. Well versed with creating Derived tables in Universe.

. Performed data validation by writing SQL queries and creating ad hoc

reports using Desktop intelligence and Web intelligence.

Environment: Business Objects 3.1, Designer, Webi rich client, Deski,

Xcelcius 2008, live office, Oracle 9i, Windows 2003.

Bank Of America, Houston TX Jan 07 - July 08

Business Objects Analyst

Worked as a Business Objects Analyst cum Developer in Bank of America

Project. Analyzed the existing reports and Developed new Reports as per

the user requirements.

Responsibilities

3. Analyzed the MsAccess reports in the old system. Created new Reports

for their system and it requires both understanding of the business

concept and in-depth skills of the Business Objects, Data warehousing

concepts, Datamodelling techniques, Star schema and SQL language to

implement the Universes and reports.

4. Analyzed the data models and did minor changes as per the requirement

using Erwin.

5. Used techniques like @Aggregate Aware objects, Aggregate Navigation,

Contexts, and Aliases.

6. Created and modified the existing Targeted Query Universe as per the

user requirements.

7. Created new queries using Oracle 10G and Teradata as backend, pulling

data from the DSS Data warehouse and compared with the existing

MsAccess reports.

8. Created the reports using universes as main data providers and using

the Powerful business objects functionality's like @functions,

Variables, user response and formulae.

9. Created Derived Tables at the universe level and created reports using

this as the data provider.

10. Created reports using Crystal Reports XI R2.

11. Created reports in crystal reports using universe as the data source.

12. Created sub reports in crystal reports.

13. Created reports like summary reports, cross tab reports, charts in

crystal reports XI R2.

14. Used the functionalities like Alerts, Parameters, Running Totals, and

Formulas in crystal reports.

15. Created the Groups and users in XI R2 using CMC.

16. Converted the existing Desktop Intelligence Reports to WEBI reports

using the Conversion Tool.

17. Created a few static Xcelsius reports on top of Excel.

18. Documented the system objects and screenshots of the reports in

Project Work Book.

19. Involved in Unit Testing and resolving the defects.

20. Worked on Test Cases and documented the results in Test results

template.

21. Created SQL scripts to test the report results with the database

results.

22. Involved in user requirement gathering meetings and resolved the

report issues by interacting with the end users.

Environment: Business Objects Designer XI R2, Desktop Intelligence, Web

Intelligence XI R2, Business Objects 6.1,Central Management Console (CMC),

Crystal Reports XI R2,Crystal Xcelcius 2008 Oracle 10G, Teradata, Erwin

Allfusion Data Modeler 4.1, Windows XP Professional, Microsoft Office

2003,SQL Developer1.0, Sun Solaris UNIX.

Northern Natural Gas, NE

June 2005 to Oct 2006

Business Objects Consultant

Northern Natural Gas (NNG) provides transportation and storage services to

approximately 75 utilities and numerous end-use customers in the upper

Midwest. NNG also operates three natural gas storage facilities and two LNG

peaking units. These storage facilities are fully contracted and are

central to meeting the customers' peak-day system requirements. The project

was to audit their current deployment and performance and to create complex

reports involving charts based on custom database queries.

Responsibilities:

. Involved in analysis, design, implementation, testing, and deployment

phases of the software development projects.

. Used Business Objects report level functions like Alerts, Breaks,

Customized filters to display relevant data.

. Created reports in Business Objects and Web Intelligence to query,

report and analyze data; and schedule, publish and distribute them

using Broadcast Agent

. Created BO reports containing multiple data providers and complex

charts to present the end users with a better graphical representation

of the data.

. Maintained the Data Warehouse for producing accurate results and take

care of performance issues arising due to any inefficiency in the

backend database or OLAP methodology.

. Created and managed users and user groups.

. Used BO Designer to create universes containing complex dimensions,

measures, conditions and prompt objects to be used in BO.

. Created classes, objects, hierarchies, complex objects, prompts, pre

defined conditions as a part of the universe creation.

. Exported the universes to the Repository making resources available to

the users.

. Worked closely with the architect, DBA and business users to deliver

reports on time

Environment: Netezza 3.1.2, Sybase 12.0, Business Objects Enterprise 6.5/

XI R2, BO Designer, Crystal Reports, Windows XP/2003, MS SQL DTS, Infoview,

Web Intelligence.

Marketing Associates, MI

Sep 2004 to May 2005

Business Objects/Data modeling

Marketing Associates LLC provides various kinds of services like

interactive marketing, direct marketing, database marketing, program

support materials, event management, and customer service center. Ford

Motors is one of the major vendors for the company. I was responsible for

installation, upgrades, analysis and development of reports.

Responsibilities:

. Interacted with Business Users, Business Owners to collect identify

the classes and objects.

. Customized the existing Business Objects universe.

. Designed the Data Model using Erwin and integrating E - R models with

the Oracle Database.

. Successfully installed, upgraded the Business Objects version 5.1.6 to

enterprise 6.0 and configured them for better performance.

. Followed Star Schema and snowflake Schema for methodology to organize

the data into database by using ERWIN tool.

. Developed various Reports for financial and marketing departments for

better analysis using Business Objects.

. Used the Broad Cast Agent server for Scheduling and monitoring the

Reports.

. Generated Master/ Detail reports based on user specification(s).

. Generated reports using Web Intelligence (thin client) and full

client.

. Maintained security for the end users by giving privileges with

supervisor module.

. Linked Universes to work with common objects.

. Worked on the Master Kernel and Component approach during the linking

universes.

. Involved in creating packages, procedures, Functions & Triggers and

also embedding dynamic

. SQL features advanced packages in PL/SQL, which generated the Flat

Files.

. Designed and developed universes in Business Objects felicitated the

end-users creating custom

. LOV, Prompts conditions, Dimensions, measures and details.

Environment: Business Objects 5.1/6.x, 5.1.6, 1b (Designer, Supervisor,

Business Objects), Web

Intelligence (Webi) 2.3, Oracle 8i, DB2, SQL*Loader, PL/SQL, Windows NT,

UNIX, Erwin 4.0

The Home Depot Supply, San Diego, CA Jan

2004 to Aug 2004

Finance Reporting Information Analysis (Data Warehousing)

The Home Depot Supply is one of the largest retailers, has upgraded the

Business Objects version to 5.1, and required the consultants to generate

new reports, graphs using the new version. Few reports were also rewritten

from the legacy versions. The role was also to train end users in using the

newly developed systems. I was also responsible for maintenance and

administration of the software.

Responsibilities:

. Planned, coordinated and executed Business Objects 5.1 deployment for

End users. .

Defined categories of documents for different level of groups.

. Responsible for fitting Business Objects into the Information

Architecture of the company as well as supporting business users and

developing new and maintaining existing Universes.

. Customized webi by using WICOM component.

. Scheduled and published full client reports and webi reports,

Implemented report bursting feature using BAS and attached VB macros.

. Maintaining, creating users with Supervisor.

. Designed Universes and implemented Linked Universes technology by

kernel approach

. Designed universes for ad-hoc reporting capabilities and Developed

Hierarchies to support drill down reports.

. Designed and documented Meta data dictionary.

. Developed several Oracle stored procedures and functions for reports.

. Linked webi reports for different hierarchies.

. Designed and developed metrics reports, dashboard reports and

scorecard formats.

. Designed and Implemented predictive analytics planned analytics and

set analytics.

. Designed universes for implementing application foundation and

dashboard reporting.

. Developed CAN reports with PIE charts, BAR charts.

. Designed VB interfaces and integrated BO Full client reports.

. Developed Budget reports for different level of users.

. Developed Budget vs. Actual reports for different periods in Oracle

reports.

. Set up Aggregate Awareness to enhance the performance of SQL

transactions.

. Tuned the reports for better performance using SQL.

. Provided ongoing 24/7 production support, administration and

Maintenance of development & Production Business Objects 5.1

environments

Environment: SQL Server, Business Objects 4.1.7/5.1, Web Intelligence 2.6,

VBA, Oracle 8.1.1, macros, AIX 5.1

New York Life Investment Management, NJ Mar 2003

to Dec 2003

Crystal Reports

Project #1: New York Life Investment Management LLC (NYLIM) is an

established money management and investment services firm. Based on the

specifications by Retail Markets Division of NYLIM, Reports have to be

designed and developed for Sales, Management and Corporate Views. These

Reports like Big Ticket, Daily Sales, Heavy Hitters, New Producers,

Territory Sales, etc are to be published and managed on Crystal

Reports/enterprise for easy online-access by the Sales Persons. (Sales

Analysis and Reporting System).

Responsibilities:

. To Design, Develop and Enhance Reports derived from Oracle Stored

Procedures using Crystal Reports and publish and manage them on the

Crystal Enterprise.

. Expert skills in designing Crystal Reports using Sub Reports, Cross

Tab, Drill Down, etc.

. To Write and edit the parameterized Oracle Stored Procedures, Packages

and Functions as per the business logic to let the Crystal Reports to

access the data.

. To administer the Crystal Enterprise Servers & migrated from Crystal

Enterprise 8.5 to 9.

. To create or edit the ASP and CSP pages using VB Script, Java Script,

etc to customize the report environment for adding new features or

enhancements such as Cascading/Dynamic parameters.

Environment: Crystal Reports 9.0/8.5, Crystal Enterprise 9.0/8.5, Oracle

8i/8.0, IIS 4.0, ASP 3.0, CSP, VB Script, Java Script, Visual InterDev 6.0

and Windows 2000.

Project #2: The Compass and Compass Plus applications of NYLIM are

developed for maintaining funds, journal log entries, unit value entries,

CUSIP numbers, etc., and calculating average balances, reconciliation of

all the separate entries, etc. Daily and Date-range reports let the system

depend heavily on Crystal Reports.

Responsibilities:

. Designed and developed ICE Accounting System using Visual Basic 6.0

including integrated search screens and flexible reporting methods.

. Supported several Compass Plus components like Separate A/C

Reconciliation, Accounting Maintenance System, Average Balance, Fund

Reports, etc.

. Designed and develop reports using Crystal Reports derived from

complex Stored Procedures written in Oracle and to maintain scheduled

batch reports.

. Inserted graphs and pie charts in reports as required.

. Designed and developed user interface screens and COM components using

Visual Basic 6.0.

. Wrote PL/SQL scripts and parameterized Stored Procedures in Oracle 8.0

and Crystal Reports to generate scheduled reports.

Environment: Visual Basic 6.0, ADO 2.5, Crystal Reports 8.0/7.0, Win32 API,

Oracle 8.0, True Grid 5.0, Windows 2000.

Standard Chartered Bank, Pune, India

Sep 2002 to Feb 2003

Programmer Analyst

Responsibilities:

. Interacting with Client and analyzing the Functional Specification to

understand the business and technical requirements.

. Database Designing and developing all the customer support reports.

. Developing PL/SQL stored Procedure to enhance the performance.

. Writing Unit test cases for the individual Components, as well system

test cases and executing integration testing.

. Making Changes to the existing Customization Wizard and testing the

Customization Wizard.

. Creating the database and table spaces.

. Importing the table dump.

. The data extraction from flat files and loaded according to business

rules of banking system.

. Unix Shell scripts used for automate the whole ETL process.

Environment: Oracle 8.1.7.1.0, Oracle PL SQL, Unix Shell scripts.

[pic]

Contact this candidate