Project Manager Sql Server

Sandeep Potla

Business Objects Developer

Email (Personal): *******.*******@*****.***

Contact: 203-***-**** (Office):

*******.*****@**********.**************.***

Professional Experience Summary:

. Over 7 years of experience in requirement gathering, System Study,

Design, Reporting, Development and Implementation of Business

Intelligence Solutions.

. Expertise in all phases of Software Development Life Cycle (SDLC).

. Expertise in different versions of Business Objects namely BO 5.1, 5.1.6,

and XI R2/R3.

. Experienced in upgrading/migrating versions of Business Objects to the

higher versions.

. Expertise in handling migration issues from earlier versions of BO to XI.

. Extensive experience in Business Objects reports/Desktop Intelligence,

Web Intelligence, Infoview, Designer, Supervisor, Broadcast Agent, BCA

Publisher & Administration modules.

. Involved in creating user roles, security access, server administration,

password management using the Central Management Console (CMC).

. Experienced in Crystal Enterprise 8.0, Crystal Info, Crystal Reports and

Oracle Reports for Reports Development with Version 7.0, 8.0, 8.5 of

Crystal Reports.

. Hands on Experience in implementing and development of Complex Database

Queries, Constraints, Indexes, Views, User-Defined Functions, Stored

Procedures, Cursors, Functions, Triggers and DTS packages.

. Experience in Handling and the creation of Data Flows and Workflows the

core components in extracting and transforming Data in Business Objects

Data Integrator.

. Strong understanding in creating dashboards using Xcelsius utilized to

generate reports.

. Strong understanding of Business Intelligence concepts like Data

Reporting, Analysis, Mining, Design, Development, Data Migration,

Implementation and Testing of Database/ Data Warehousing/Client/ Server/

Legacy applications.

. Good working knowledge of Database Design, Relational Data Modeling and

development, clustering or cluster analysis.

. Good Understanding of Oracle ERP's Modules (G.L, A.P, A.R & F.A) and

underlying tables.

. Experience in educating and supporting end-user reporting needs using

Business Objects.

. Extensively worked with Oracle, Access, Spread Sheet, SQL Server

databases.

. Strong Analytical, Interpersonal, Communication and Leadership skills.

Experience:

Conoco Phillips (Bartlesville, OK)

June 2010 - Till Date

Conoco Phillips one of the Fortune 500 Companies is the third-largest

integrated energy company in the United States based on market

capitalization, oil and natural gas reserves and is the fourth-largest

refiner and the sixth-largest reserves holder of nongovernment-controlled

companies.

Main Aspect of the Project is to Develop and Support Web Intelligence

Documents for an upgrade from Business Object 5.1.7 to Business Objects XI

which included Migration and Conversion of Desktop Intelligence reports to

Web Intelligence.

Role: BO Technical Developer

Responsibilities:

. Responsible developing and supporting the Reports for migration from

517 to XI.

. Responsible for Converting reports from DeskI to WebI using the Report

Conversion Tool (RCT) which have not been Converted or having issues

with the Conversion.

. Responsible for development of Web Intelligence Documents from

scratch.

. Responsible for Recreating Web intelligence Documents which do not

support the DeskI Functionality.

. Imported reports from Source to destination Platform in both DeskI and

WebI using the Import Wizard.

. Involved in Backing Up the Repository Using Import Wizard.

. Responsible for solving the Complex and Major issues in Web

Intelligence.

. Worked closely with the Admin team in designing the Security

structure.

. Responsible for creating server groups for the reports which were

using Oracle Database.

. Responsible for monitoring the services In CMC and reporting the Admin

Team.

. Responsible for testing the Corporate/User reports which were

recreated before the post-deployment/Signoff verification procedures

making use of the Source Documents.

. Responsible for testing the Corporate/User Reports once moved from

Test - Production.

. Interact with system users and stakeholders around specific work

efforts / Issues for the deliverable.

. Responsible for testing the Browser Version from IE6 to IE8.

. Responsible for documenting the changes made to the complex formulas.

. Involved in meetings on deciding strategies and planning the

Workarounds for the Reports.

. Good experience in working with Ranks, Filters, Prompts, Folds,

Functions, Formulas in reports for the Workarounds.

. Reported on weekly basis to Business Objects Project Team lead and

Company's Project Manager on the Issues and met the time Limits

Successfully.

Environment: Business Objects XI (Info view, DeskI, Universe Designer, RCT,

and Import Wizard), BO 517, Crystal Reports XI, Oracle 11g, DB2, Sybase,

Windows XP, and Citrix.

World Fuel Services Corp (Miami, FL)

April 2009 - May

2010

World Fuel Services is the global leader in the downstream marketing and

financing of aviation, marine and ground transportation fuel products and

related services.

Integrated Information Management Systems (IIMS) department at World Fuel

Services has a homegrown data warehouse which has been operational since 7

years. Crystal reports (mainly financial reports) used for Accounting

purposes were in place from a long time, and were distributed through

crystal enterprise 9. Main task here was to re-direct legacy crystal

reports to using universes with the required security features loaded

through BO user variable.

Role: Sr. Business Objects Developer

Responsibilities:

. Responsible for re-pointing of crystal reports to use BO universes.

. Designed and optimized universes for better report performance.

. Created report templates and established templates for documentation

of reports providing new insights into the reports and helping them

understand have a record which was absent till now.

. Exported the Universes to the Repository to make resources available

to the users for ad-hoc report needs.

. Created and modified reports based upon the business use.

. Worked with Import wizard to move the objects between DEV, QA and

Production systems, to create users in bulk.

. Worked on row level user security, helping to create BO user variable

loading security from the Windows AD group.

. Modified complex reports based on discussions with user groups and

created various objects using built-in @functions (like @prompt,

@select, @where, and @aggregate), complex SQL queries and joins.

. Interacted with the end-users understanding the business needs to

suggest better reporting practices and decide the strategy on training

the end-users.

. Introduced the management to advanced features of BO and provided

suggestions towards adding ad-hoc reporting capabilities.

. Involved in meetings on deciding strategies to loading data into the

data warehouse.

. Interacted with the training department to help them understand the

features of BO and advised them on preparation of training documents.

. Involved in production support services and project development and

implementations relative to Business Objects application.

. Developed universe user documentation guide for the end users

reference.

. Optimized existing Universes and Reports to ensure accuracy and

relevance to the existing Business use.

. Responsible for orientation and training of new consultants.

Environment: Business Objects XI (Infoview, Universe Designer),

Crystal Reports XI, Golden32, Oracle 11g, Oracle 9i, SQL server

2005 and Windows XP.

Bell Micro (San Jose, CA)

Jan 2008 - Mar 2009

Bell Microproducts Inc. is an international, value-added distributor of a

wide range of high-tech products, services and solutions, including

storage systems, servers, software, computer components and peripherals,

as well as maintenance and professional services.

The project involved creation and maintenance of universes which were

related to different databases. Customization and integration of reports

with different applications was one of the major tasks involved, as

different users have different business needs. The project also involved

preparation of documents for training end users to access information.

Role: Senior Business Objects Analyst/Developer

Responsibilities:

. Involved in all stages of business analysis from requirement planning

and management to solution assessment and validation.

. Responsible for Installation & Configuring Business Objects Enterprise

XI R2 Premium Edition.

. Customized the universe by creating user/pre-defined objects so as to

match the requirements.

. Created and maintained around 30 Business Objects reports.

. Created Sub-Reports and Cross-Tab Reports effectively to present data

in an efficient manner.

. Created Charts, Drill-Down reports, Formulae, hyperlinks, percentage

reports, Prompts using Crystal Reports.

. Created dashboards to help conduct what-if analysis.

. Created reports using Free-Hand SQL & Stored Procedures.

. Performed data validation by creating ad-hoc reports.

. Involved in preparation of users guide and fine-tuning the

specification.

. Complex reports were developed using Web intelligence (WEBI XI) and

complex full client Business Objects Reports were developed and

published in corporate documents under various categories.

. Worked with top management and helped them fine tune the reporting

requirements/specification so as to ensure comprehensive reporting

solutions.

. Enhanced the reports by providing event-handling features.

. Optimized the usage of user objects, conditions and universe level

filters.

. Extensively used multiple data providers for building reports.

. Involved in documenting the changes to the universe and reports

functionality.

. Created/Administered users/user groups/Security in Supervisor/CMC.

. Involved in creation and maintenance of repositories.

. Provided and resolved issues affecting reporting solutions for simple

to complex scenarios.

. Involved with the Production Support team to handle issues with the

reports and the universe.

. Created Data Flows and Workflows for the core components in extracting

and transforming Data in Business Objects Data Integrator.

Environment: Business Objects XI (Infoview, Universe Designer), Crystal

Reports XI, Oracle 11g, Oracle 9i, SQL server 2005 and Windows XP.

Pitney Bowes (Stamford, CT)

Oct 2006- Dec 2007

Functioning as Strategic Partner, Pitney Bowes offers business solutions

for Organizations who want to outsource all or part of their marketing

Initiatives. Reports like Daily Ranking Report, Long term Rank and

percentiles (Net), daily report and category customer report were

developed.

Role: Business Objects Developer/Reports Administrator

Responsibilities:

. Involved in Installing the Business Objects, creating Repository,

creating Users and User Groups using supervisor models.

. Responsible for requirements gathering and writing specifications.

. Involved in designing, developing & testing the universe for report

generation.

. Created & tested reports using Business Objects functionality like

Queries, Slice and Dice, Drill down, @Functions, Formulae etc.

. Created graphical representation of reports such as Bar charts, Pie

charts etc as per the end-user requirements.

. Exported the reports to Broadcast Agent Server, which was used to

Schedule and Monitor the reports.

. Implemented various functionalities like Ranking, Filters, and Alert's to

restrict the unwanted data and highlight the required data.

. Developed and modified various database objects like Views and utilized

command options in crystal reports to improve performance of reports.

. Developed PL/SQL stored procedures to process and store the information

in the oracle database.

. Testing of Universe and Reports, which includes database connectivity.

. Tested resolved loops and contexts to ensure the correct results from the

query.

. Created and utilized Dashboards which were exported into flash files,

used for presentation of real time data.

. Deployment of Crystal Reports via various methodologies Central

Management Console (CMC), Publishing Wizard, Infoview, Import Wizard.

. Involved in creating user roles, security access, server administration,

password management using the Central Management Console (CMC).

. Tested the aggregate awareness to ensure the query is pulling correct

level of aggregation.

. Optimized existing risk models to ensure accuracy and relevance to the

existing market conditions.

. Involved in advising business analysts during the preparation of use case

diagrams and views.

. Trained end-users in basic and advanced reporting.

. Responsible for driving the user group meetings and finalizing the

specifications.

Environment: Business Objects 5.1.2/5.1.6/6.1a/XI R2, Designer, Web

Intelligence, Desk I, Info view, Crystal Xcelsius, Crystal

Reports 9.0/10.0, Business Objects Data Integrator, SQL Server

2005, Oracle 9.0/10g, PL/SQL, Windows NT, HTML.

Liberty Property Trust (Malvern, Pennsylvania)

May 2005-

Sep 2006

Liberty Property Trust is a $6.5 billion real estate investment trust (as

of September 30, 2009) which owns 77 million square feet of office and

industrial space in over 20 markets throughout the United States and the

United Kingdom.

Different types of reports like Payment Summary, Balance summary were

generated which were utilized to help in the analysis of credit history of

the customers with House Hold bank. The reports generated were also

utilized to validate the risk algorithms used to predict the market

situation.

Role: Business Objects Developer

Responsibilities:

. Managed resources, granted permissions to both BO Reporters and WEBI

users, and managed the connections, Universes and repository domains.

. Upgraded BO 5.1.8 reports to BO 6.1.

. Gathered the functional requirements for users in order to plan and

develop universe design.

. Collaborated with ETL designers to stream-line universe design and

optimize query performance.

. Implemented equijoins, outer joins, shortcut joins on tables in

schema.

. Trained clients, Created repository and user groups using Business

Objects Supervisor.

. Created contexts and aliases to resolve loops, chasm traps, and fan

traps.

. Created predefined conditions for users allowing them to construct

complex reports using the predefined conditions.

. Set up aggregate awareness for objects.

. Linked universes using both Kernel and Master approaches.

. Generated reports using Web Intelligence through Infoview.

. Created dashboards and scorecards integrating reports using Business

Objects dashboard manager.

. Involved in risk modeling to analyze market conditions.

Environment: Business Objects 5.1.8/XI, Web intelligence 2.7, Infoview,

Application Foundation, Windows NT, SQL Server 2005, SQL Tools -

Toad, PL/SQL, Oracle 9i, MS Access 2000.

Trans America (Dallas, TX)

Mar2004-

Apr 2005

Transamerica Reinsurance is a leading supplier of life, annuity and

accident & health reinsurance products and services. As part of the new e-

Suite Tm project initiative, I was involved in the analysis, information

gathering, definition, design, and implementation of various management and

operational reports for Policy and Billing. A large part of the reporting

need was to assess Agent performance and KPI reports. A regular part of the

teams work also involved enhancement and maintenance of internal reports

used by Underwriters, marketing representatives, and managers and external

reports accessed by agents.

Role: Business Objects Reports Developer

Responsibilities:

. Translated business needs into data analysis, business intelligence

data sources and reporting solutions for different types of

information consumers.

. Tasks include defining requirements, design, develop, test, implement

and maintain reports using Crystal Reports.

. Developed several reports with consistent drill-down functionality

including Drilldown Reports, Summary Reports and Master Detail

Reports.

. Developed Custom Functions, Manual Running Totals, and Complex

Formulae for Reports.

. Created variables and defined formula to capture user responses to a

prompt and to display document information for WebI reports.

. Used breaks, calculations, sorts, filters and sections to enhance data

presentation.

. Created reusable report templates to maintain a uniform standard

across all the reports.

. Created User Objects including Dimensions, Details, Measures and

created hierarchies in several classes.

. Set up hierarchies and defined Scope of Analysis in the Universe for

providing drill down/ drill through options in the reporting

environment.

. Created Condition Objects in the Universe to restrict data.

. Improved performance of the reports by using the @Aggregate Aware

function.

. Used various @Functions like @Prompt (for user defined queries),

@Where (For creating conditional filters), and @Select (to simplify

maintenance and ensure consistency of code).

. Created Contexts and Aliases for resolving Loops in the Universes.

. Created List of Values for user Defined Objects (UDO).

. Created simple query filters, prompted filters and complex filters to

restrict data in reports.

. Migration of management reports from version 8, 9, 10 and XI in

Crystal Reports.

. Migration of Business Objects WebI reports from ver 6.5 to XI.

. Developed PL/SQL routines like Packages, Stored Procedures, Cursors

and Functions using dynamic SQL.

. Used Crystal Management Console to perform administrative tasks of

report publishing and folder management.

. Collected business requirements, designed data maps and data models.

Created Internal and External Design Documents and Transaction

Definition Documents.

. Interacted with cross-functional technical project teams, end-users

and management in multiple business functional areas.

Environment: BO 6.x/ XI, Crystal Reports 9.0/10.0/Xi, Crystal Enterprise

9.0/10.0, Web Intelligence, Infoview, Oracle 9i, PL/SQL,

SQL*Plus.

Ramco Group (Chennai)

Feb 2003- Mar 2004

Requirement was to collect and maintain reports pertaining to sales,

service, suppliers, and inventory. This involved collection of real-time

data and generation of reports to incorporate the same functionality.

Role: Reports Developer/ Analyst

Responsibilities:

. Responsible for maintenance of data containing employee information,

inventory, sales, spare parts.

. Developed stored procedures, functions and packages using PL/SQL which

were used to generate reports.

. Trained end users in generating and updating of the data.

. Designed and developed forms and reports using Forms 4.5 and Reports

2.5.

. Created new forms and reports using Forms 4.5 and Reports 2.5.

. Created database objects like tables, views and triggers.

. Prepared program documentation.

. Performed unit and integration testing.

. Involved in designing data marts used to maintain data.

Environment: Oracle 8i, PL/SQL, SQL* Plus, Forms 4.5, Reports 2.5, SQL*

Loader, HP UNIX.

Technical Skills:

Languages SQL, PL/SQL, C, C++.

Databases Oracle 8.x/9.x/10.x, MS SQL Server (2000, 2005 & 2008), MS Access

Operating Windows (98/NT/XP), UNIX (Sun Solaris, AIX), LINUX, MS DOS

Systems

Reporting Business Objects 6.x/ Xi R2/ R3, Crystal Reports

Tools xi/10.0/9.0/8.0/7.0/6.0/5.0, Designer, Desktop Intelligence, Web

Intelligence, Infoview, CMC, Crystal Enterprise 8.5/9.0, Crystal

Xcelsius.

Other Tools Toad, SQL * plus, SQL Loader.

Web HTML/ DHTML, Drupal, Ms Office, Adobe Photoshop

Designing

Contact this candidate