SUMMARY:

• Over eleven years professional experience in information technology expertise in Business Objects XI Release 3.1, Crystal Reports 2008, Crystal Enterprise XI, PL/SQL, T- SQL, Oracle, MS SQL Server and Delphi
• Expertise in Business Intelligence and Reporting
• Full life cycle experience including requirement analysis, design, development, testing, implementation and customizing on a variety of platforms
• Excellent communication, team and interpersonal skills

OS

Windows XP/2000/NT, UNIX

Business
Intelligence
Tools

Business Objects Enterprise XI Release 3.1/ 2, Crystal Reports 2008/ XI/10.0/9.0/8.5, Crystal Reports Server XI, Crystal Enterprise 10.0/9.0/8.5, Xcelsius, Quick Reports, Report Builder, Oracle Reports

RDBMS

Oracle 10g/9i/8i, MS SQL Server 7.0/2000/2008

Languages

PL/SQL, T-SQL, Pascal

Web
Technologies

Crystal Server Pages, HTML, ASP, JavaScript, VBScript

GUI

Delphi 6.0/5.0, Developer 2000, Visual Basic 6.0/5.0

Warehouse Mgmt System

Exceed 3.6, Cadence, ConnectShip, Loftware

ERP

SAP 4.6 C

Other Tools

Rational Clear Case, Rational Clear Quest, Visio 2003, Visual Source Safe, Test Director, TOAD, PL/SQL Developer, PVCS Merant Tracker, PVCS Version Manager, Autosys, Project Server 2003,MS Office

Confidential,

Business Objects Consultant

Description:
Impairments Reports Project
This project involves generatinganalytical & operational reports forthe FAS115 and EITF99-20 accounting groups.

• EITF 99-20 is an accounting standard that deals with the treatment for impairing securitized financial assets in the month of acquisition. The EITF99-20 system analyzes securities acquired into portfolio based on an extensive rules engine. The reports are designed to provide analytical support, reconciliation and adhoc querying to the accounting group
• FAS115 is an accounting standard that deals with impairment of securities held in portfolio. The FAS115 system evaluates the credit risk and interest risk for the assets in portfolio. It has a rules engine that computes impairments and accretion basis

Guaranty Fee Accounting System (GFAS) Reports Project
Guaranty Fee Accounting System maintains all loan level cost basisvalues andrecords accounting transactions to the general ledger.

FAS91 Amortization Reports Project
FAS91 AM Engine provides amortization service for Fannie Mae Securities, Loans and G-Fee work streams. Each work stream has control and operational reports.

Responsibilities:

• Developed canned reports using Crystal Reports 2008/XI.
• Wrote complex SQL queries and used them in command objects.
• Created and stored reusable/sharable objects in the repository.
• Created cross tab, on demand sub reports, bar and pie chart reports with drill down feature.
• Designed reports to display summarized group data with parameters, running totals and formulas.
• Developed WEBI reports with charts and drill down feature.
• Created WEBI reports with predefined, custom filters and parameters.
• Maintained and modified universes that included loan data.
• Involved in reports release and resolution of post deployment issues.
• Involved in the migration of reports from Business Objects XI Release 2 to Release 3.
• Worked with the QA team on validation of the reports.
• Created the mapping and technical documents for the reports.

Environment: Business Objects Enterprise XI Release 3.1/Release 2, Crystal Reports 2008/XI, MS SQL Server 2005/2008, Oracle 10g/9i, PL/SQL, AB Initio, Rational ClearCase, Rational ClearQuest, Autosys, Windows XP.

Confidential,

Business Intelligence Consultant

Description: Telecom Expense Management System
Avotus Corporation develops Telecom expense management (TEM) solutions. Avotus solutions with the combination of technology, automation and business intelligence helps clients to realize significant spend reduction and process improvement.

Responsibilities:

• Created WEBI Reports using both JAVA and HTML report panels in Business Objects XI.
• Developed WEBI reports with multiple hierarchies for drill analysis.
• Designed Universes for different business domains and sub domains.
• Used contexts in Universes to solve loops.
• Used derived tables in Universes to create objects.
• Created dashboards using Xcelsius.
• Converted existing Jasper reports to Crystal Reports XI.
• Used dynamic and cascading prompts in the reports.
• Created report templates and report design standards.
• Created users, user groups, roles and rights for different customers in the Business Objects Enterprise server.
• Created scripts to build tables in data warehouse environment.

Environment: Business Objects Enterprise XI Release2, Crystal Reports XI, Xcelsius, Oracle 10g Datawarehouse/9i/8i, PL/SQL, J2EE, Jasper Reports, Toad, Windows XP

Confidential,

Crystal Reports Consultant

Description: Business Management Group (BMG)
The Business Management Group tracks all the projects handled by PricewaterhouseCoopers. The Project expenses, milestones, resource utilization and hours on each project are displayed in the form of reports for the executives. The reports were scheduled to run on a daily/weekly basis.

Responsibilities:

• Trained and mentored the developers.
• Created reports using Crystal Reports 10.
• Created unlinked sub reports and linked on demand sub reports.
• Developed bar charts, pie Charts and line charts with conditional formatting.
• Created stored procedures and views using T-SQL for the reports.

Environment: Crystal Reports 10, Crystal Enterprise 10, MS SQL Server 2000, Project Server 2003, Windows 2000

Confidential,

Senior Programmer/Analyst

Description: Warehouse Management System (WMS)
UPS Supply Chain Solutions, a unit of UPS, provides logistics and distribution, transportation and freight, and international trade management. The WMS implementation by UPS helps clients to maximize efficiency and contain costs by outsourcing a variety of supply chain functions.

Responsibilities:

• Developed multiple reports using Crystal Reports XI.
• Designed parameterized Crystal Reports and customized existing reports.
• Developed cross tab, drilldown and OLAP reports.
• Created users, user groups, roles and rights for all different customers in the Crystal Enterprise framework.
• Used dynamic and cascading prompts in the reports.
• Created stored procedures, triggers, functions and views using PL/SQL for the reports.
• Updated the technical documents for the reports.

Environment: Crystal Reports XI/10/8.5, Crystal Reports Server XI, Crystal Enterprise 10, Oracle 9i/8i, PL/SQL, Toad, VB Script, Exceed 3.6(Warehouse Management Suite), ConnectShip, Loftware, PVCS Merant Tracker, PVCS Version Manager, Windows 2000

Confidential,

Senior Programmer/Analyst

Description: Operations Portal Reports
This web portal includes reports that provide detailed statistics on the caller traffic and on the performance of the various Verizon’s customer contact management group applications. Some of the important applications are Retail Market Voice Portal – it is a speech recognition system andit allows customers to speak and request information about Verizon Services. Click to Chat – it’s a web chat application, to provide live assistance to customers

Responsibilities:

• Involved in requirements gathering and design document preparation.
• Installed, configured and administrated Business Objects Enterprise in Windows environment.
• Upgraded Crystal Reports from version 10 to version XI.
• Developed bar charts, pie charts and line charts with drill down option to show values of the daily metrics.
• Designed OLAP reports running on OLAP cubes.
• Designed Universes and created object hierarchies for multi dimensional analysis.
• Designed universes with aliases and contexts to avoid loops.
• Designed WEBI reports using combined queries.
• Developed WEBI reports using ranking and alerter functions.
• Used sections, breaks and sort features in WEBI reports.
• Created new procedures, triggers, packages and functions.
• Validated the exiting reports and improved the performance of existing reports.
• Modified front-end screens using ASP, CSP, VB script and Java script.
• Documented the end user manual.

Environment: Business Objects XI, Crystal Reports XI/10.0/8.5, Crystal Reports Server XI, Crystal Enterprise 10.0/8.5, MS SQL Server 2000,Oracle 9i/8i,Toad, Genesys CTI, ASP, CSP, VB Script, Java Script T-SQL, Visual Source Safe, RoboHelp5.0, Visio 2003,Windows XP.

Confidential,

Senior Programmer/Analyst

Description: Order, Inventory and Warehouse Management System
The system maintains the inventory of items. Numerous reports have been created from the system data which helps in identifying inventory, locations of items, fulfillment status and tracking shipped orders.

Responsibilities:

• Developed reports using multiple grouping, sorting and running totals features.
• Deployed reports and scheduled reports using Crystal Management Console & ePortfolio.
• Installed and set up Crystal Enterprise environment.
• Created new views and modified existing views using T-SQL.

Environment: Crystal Reports 9.0 Crystal Enterprise 9.0, MS SQL Server 2000, T-SQL, Windows NT, Cadence Order/Customer/Warehouse Management system

Confidential,

Programmer/Analyst

Description: Revenue Share Back Office System
The Back Office System presents the data needed for sharing revenue with studios. The system includes calculations, remittance procedures and reports. Remittance to the studios is made on an accounting period basis and multiple reports are generated at the end of the term.

Responsibilities:

• Developed KPI pie charts and forecasting reports.
• Developed user interfaces for the application using Delphi.
• Wrote new stored procedures and modified existing stored procedures using PL/SQL.
• Prepared end user manual and technical documentation.

Environment: Crystal Reports 9.0/8.5, Crystal Enterprise 9.0, Oracle 9i/8i, PL/SQL, Delphi 6.0/4.0, MTS, MS Visual Source Safe, TOAD, PL/SQL Developer, Visio, Windows NT.

Confidential,

Programmer/Analyst

Description: POWERLOG - Control Room Data Log Collection System
PowerLog automates the data log collection procedures in the power generation plant’s control room. The system helps in identifying components that are inoperable and needs attention. Reports for all logs are generated at the end of shift and documented.

Responsibilities:

• Involved in system study, gathering end user requirements, design, development and testing.
• Modified the reports using Quick Reports.
• Upgraded the application from Delphi version 5.0 to version 6.0.
• Involved in creation of stored procedures, views and adhoc queries.

Environment: Delphi 5.0/6.0, Quick Reports, MS SQL Server 7.0, MS Visual Source Safe, Developer Express, Windows 2000.

Confidential,

Programmer/Analyst

Description: LABEL MANAGEMENT SYSTEM (LMS)
The Label Management System combines the use of bar code and data collection with radio frequency to provide a mobile interface to the SAP System. The LMS maintains and stores the details of the labels printed for each part.

Responsibilities:

• Involved in designing, developing and testing of the system.
• Involved in data mapping and data conversion between SQL Server and SAP server using IDOCs.
• Modified and wrote new stored procedures.

Environment: Delphi 5.0, Report Builder, MS SQL Server 7.0, Midas, SAP 4.6 c, Rational Rose, Visio 5.0, Test Director 6.02, Toad, Windows NT
Confidential,

Responsibilities:

• Programmer/Analyst for full life cycle of project developed in Delphi 4.0.
• Wrote stored procedures and database triggers.

Environment: Borland Delphi 4.0, Oracle 8.0, Quick Reports, Windows NT

EDUCATION:

• BS Physics
• Advanced Diploma in System and Application Software