SUMMARY

• 7 years of professional IT experience in Business Objects XI/XIR2/ 3.1, 4.0 (Information Design Tool, BI Launchpad, Universe Designer, Web Intelligence Infoview, Crystal Reports, Webi Rich Client, Dashboard Designer, Xcelsius 2008 and SAP BW 7.0)
• Analysis, Design, Development, Testing and Implementation of BO Enterprise XI R2/ 3.1/4.0, Crystal Enterprise XI R2, SAP BO CMC, BO Info view XI R2/ 3.1
• Good Experience in working with RDBMS including Oracle 9i/10g/11g, SQL Server 2005/2008, DB2 and MS Access
• Worked for various domains like Investments, Financial, Retail, Telecom and Banking
• Used Universes, Stored Procedures as source for Business Objects Querying, analysis and reporting
• Expertise in assisting, managing design, prototyping, development, testing, and production support of multiple Universes
• Good knowledge of various schemas like Star and Snowflake
• Analyzed the existing database and designed the Universes using Business Objects Designer Module for generating reports
• Used Designer Module to design Universes, create prompts and queries and apply Contexts and Aliases to remove loops, Fan Traps and Chasm Traps
• Worked on developing reports using Crystal Reports XI using Business Views and Universes as data providers
• Created Ad - hoc reports using Business Objects functionalities like Queries, Drill Down, @Functions, Cross Tab, Master Detail and Formulas etc.
• Exported the universes to the Repository to making resources available to the users
• Expertise in Business Objects which includes building Universes (Business view of the database), Linked universes, retrieving data using Universes, Personal data files, Stored procedures and Freehand SQL methods and creating complex Ad hoc Reports using Business Objects Desktop Intelligence and Web Intelligence Tools
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab and Formulae etc.,
• Worked extensively on creating Xcelsius dashboards using Live Office and QaaWS
• Good at using shared and global variables across crystal reports
• Good experience in creating functions like WhilePrintingRecords, WhileReadingRecords etc. and in Migrating Crystal Reports from older versions to newer versions
• Expert in creating Complex Crystal Reports (Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports)
• Deployed reports on the web using Crystal publishing wizard and scheduled reports using e-Portfolio and Crystal management console
• Extensive knowledge in pre-defined functions like string, date, numeric, conversion and null functions of Crystal like isnull, inrepeatedgroupheader, monthtodate, lastfullmonth, lastfullweek etc.,
• Expert in writing complex formulae at the summary level and group level to implement the business logic
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals
• Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the Software Development Life cycle
• Excellent communication skills, both written and verbal and ability to work in both individual and team environments
• Worked for various departments like PAIR-FI, Web Sales, Tele sales, Customer Care etc

TECHNICAL SKILLS

B.I Tools: (Business Objects XIR2/3.1, 4.0 (IDT, UDT, Web Intelligence, Central Management Console, Info View, Xcelsius, Dashboard Designer (Live Office and QaaWS)) and SAP BW 7.0

Reporting & Analysis Tools: (SAP Business Objects 3.1/4.0, BI Launchpad, Xcelsius 2008, Dashboard Designer, Webi - Rich Client, Crystal Reports XI R2/2008, BO Enterprise XI R2/3.1/4.0, and MS Excel)

RDBMS: (Oracle 9i/10g/11g, MS Access, SQL Server 2005/2008, DB2)

Programming Languages: (C, C++, SQL, PL/SQL)

Operating Systems: (WINDOWS XP/NT/00, UNIX)

Others: (Informatica PowerCenter 8.1.1, TOAD, SQL Loader, SQL Navigator 6.4, SQL Developer, Win SQL, Track wise, JIRA, QC)

PROFESSIONAL EXPERIENCE

Confidential, Ft. Lauderdale, FL

Business Objects Consultant

Responsibilities:

• Rendering service for PAIR - FI (Performance Analysis and Investment Risk - Fixed Income) group as a BO Consultant
• Coordinated meetings with business users and development teams to gather System requirements and data requirements
• Responsible for Designing BO Universes on top of Oracle/ SQL Server Databases
• Created Webi-Reports using BEx queries as a Data-source
• Created several Webi reports with different frequencies like Daily, Weekly, Monthly and Quarterly
• Responsible for Designing, Developing, Testing and deploying reports
• Involved in Migration of BO Universes and Webi Reports from BO 3.1 SP5 to BI 4.0
• Created reports on the web using Bi Launchpad, Rich Client and distributed them to different users through Infoview portals
• Conducted several Training sessions with the Business Users which helped them to gain more knowledge on how to use Infoview effectively
• Validated the Reports by writing manual SQL queries in SQL Navigator
• Single point of contact for issues in Production
• Coordinate with Offshore Developers in accomplishing Tasks
• Expert in creating formulae and Custom variables/Objects at report level
• Created different report formats like Horizontal, Vertical, Cross-tab with multiple prompts/ filters
• Based on the users requirement, created parameter driven reports to restrict the volume of data
• Good hands on experience in using important features of Webi like Breaks, Fold/Unfold and Query stripping
• Created several Xcelsius Dashboards using QaaWS and BIWS for Higher Level Management
• Conducted discussions with BA’s (Business Analysts) and end users to create several test scenarios for running the reports
• Worked on existing reports to optimize and troubleshoot problems that occurred due to new business requirements
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users
• Scheduled reports to run on daily/weekly/monthly basis to distribute the output in different formats like Excel, CSV, PDF

Environment: BI 4.0, BO XI 3.1 SP5, Information Designer Tool, Universe Designer, Xcelsisus 2008, Dashboard Designer, BI Launchpad, Web Intelligence Rich Client, SAP BW 7.0, BEx Query Designer, InfoView, Oracle 10g/11g, SQL Server 2005/2008, JIRA, SQL Navigator 6.4, MS Office, PIE (Product Information Exchange), SharePoint, Windows XP/7

Confidential, Columbus, Ohio

Business Objects Developer

Responsibilities:

• Create various complex reports using Business Objects XI R2
• Enhance/modify existing reports by creating new Parameters, Formulae
• Schedule the reports using Infoview to run at specific times in a day/week as desired by the Business Users
• Assist BO administrator in setting up security for various reports on Enterprise
• Responsible for setting up the Database logon info and Parameters on Info View for the users to run the reports
• Interact directly with the business users in gathering requirements
• Optimize various SQL queries to make the reports run faster
• Used SQL extensively in command objects of Crystal reports
• Create and edit alerts on Reports, as per user request
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
• Migrate reports from Dev to Production
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Use prompts, alerts, drill down analysis as per the end user requirements
• Create nested, conditional subgroups and formatting features in reports
• Create Sub reports called from the main report to implement the business logic
• Create various database objects like Tables, Views and Stored Procedures by using Toad
• Responsible for defects raised during testing of the reports
• Work on existing reports to optimize and troubleshoot issues that occurred due to new business requirements
• Move the reports from Dev to QA and inform the users to start UAT
• Assist UAT team in testing the reports using SQL queries in TOAD, SQL developer and Win SQL and advise them with necessary changes
• Responsible to interact with testing team on a regular basis to make sure the reports are working as desired and make changes if required

Environment: Business Objects XI R2, SAP BO Infoview XI R2, SAP BO CMC, Informatica PowerCenter 8.1.1, Oracle 9i/10g, TOAD, SQL Developer, Win SQL, UNIX, Windows XP/NT, JIRA and Quality Center

Confidential, Overland park, KS

Business Objects Developer

Responsibilities:

• Created Business Objects Reports for different teams and groups in the organization to fulfill their business needs.
• Supported SMART website (internal to Confidential ) in many ways by creating, maintaining and scheduling reports as well as maintaining data on Oracle Server.
• Worked extensively on Call Centers data starting from loading daily data into Oracle tables from flat files using SQL Loader, Control files and Batch files.
• Scheduled batch files using Windows Scheduler.
• Created reports for Telesales, Web sales, Online Authorizations teams.
• Worked on Agent Segmentation, Score cards and Performance reports.
• Worked on reports to detect fraud orders for Quality & Analytics team.
• Automated the daily process of summarizing inbound and outbound call data metrics by creating stored procedures, User Defined functions, Views, Oracle Jobs and batch files.
• Scheduled reports to go to users directly, to share drives, etc. using Crystal Management Console and SAP BO CMC.
• Migrated reports from version 10 to version 2008 of Crystal reports.
• Used SQL extensively in command objects of Crystal reports.
• Tested the reports for accuracy using SQL queries in TOAD and SQL Developer.
• Created Custom functions, formulae, cross tabs, graphs and charts.
• Develop an understanding of the business and data requirements to ensure a successful project.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Created reports with drill down option, Parameter fields, formulae, and heavy formatting.
• Created Cross Tab Reports, Pie and Bar Charts, and Parameter Reports, Running totals, Sub Totals and embedded linked and unlinked sub-reports to separate and organize key information and to promote reusability in data reporting.
• Developed stored procedures in PL/SQL using TOAD to be used in the reports.
• Developed various database objects like Tables, Views and Stored Procedures by using Toad, PL/SQL in Oracle.
• Created number of formulae, running totals conditional display of fields for complex calculations and used them in sub reports.
• Created stored procedures to update tables and Jobs to run the procedures automatically.

Environment: Business Objects XI, SAP BO CMC, Oracle 9i/10g, PL/SQL, TOAD, SQL Developer, UNIX, Windows XP, TOES, FAST, Ensemble, P2K and Excel modeling.

Confidential, Greenwich, CT

Business Objects Consultant/ Business Analyst

Responsibilities:

• Worked for Investment Banking Sector for creating Reports as per User requirements.
• Coordinated meetings with business users and development teams to gather System requirements and data requirements.
• Involved in design, development and documentation on various phases of product life cycle.
• Involved in facilitating reporting standards for SAS70, FAS157, Cash Reconciliation and Prime Brokerage.
• Worked with Oracle 10g and created complex stored procedures and views according to the requirement for the reports using DBArtisan from Confidential Technologies, Inc.
• Designed and developed Crystal Reports, the Cross Tab Reports, and Top N Reports for displaying vital data and summary reports with drill-down capabilities.
• Worked on financial management tool MShare - an advanced solution for transfer agency and shareholder record-keeping software needs to deploy the reports and run them according to the fund type.
• Created various financial reports for financial accounting tools like Geneva and Avatar.
• Performed admin tasks related to users, groups, folders, and security using Crystal Management Console (CMC).
• Conducted discussions with Business Analysts (BAs) and end users to create several test scenarios for running the reports.
• Designed reports connecting multiple databases - Oracle 10g and SQL server 2005
• Worked on already existing reports to optimize and troubleshoot problems that occurred due to new business requirements.
• Provided On Call Support and end report testing after reports are deployed to production
• Added the access management by creating users, user groups and folders.
• Applied security settings in Dev, QA, UAT and Production domains by adding row level and object security.
• Performed unit testing, system testing and user acceptance testing (UAT) for reports

Environment: Business Objects XI, Oracle 10g, SAS70, FAS157, SQL Server 2005, Quality Centre and TOAD.

Confidential, Bentonville, AR

Crystal Reports Developer

Responsibilities:

• Worked for Web sales department to create, test, distribute and maintain Crystal Reports.
• Created Sub reports which were called from the main report to implement the business logic.
• Generated Reports using procedures and views for faster execution.
• Developed various charts and graphs like bar chart (side by side, stacked), line graphs, pie -charts etc. by using chart expert of Crystal Reports.
• Based on the users requirement, created parameter driven reports to restrict the volume of data.
• Created and optimized stored procedures to enhance the performance of the reports.
• Modified existing reports according to the user's requirement and exported reports to PDF format.
• Used Crystal Viewer for running the reports and exporting them to various formats.
• Scheduled reports to run on daily/weekly/monthly basis and to distribute the output in different formats to various users.
• Conducted meetings with Business Analyst and users to get the requirement correctly and finished the tasks within the time frame.
• Migrated reports from Crystal 8.5 to Crystal 10.
• Used TrackWise 7.0 for version control of the reports.
• Created nested, conditional groups and formatting features in reports.
• Involved in creating various PL/SQL stored procedures, views, functions and temporary tables for data input to the Crystal Reports.
• Exported reports to various formats like MS Excel, PDF, MS Word, Text, and CSV etc.
• Manage the data structures by ensuring data integrity, adding, deleting, or changing data elements as required by the business.
• Optimized queries to run efficiently.
• Support the Business Analyst with managing the user requests, perform complex analysis, dash boarding, report writing, and ensure the documentation is current.
• Raised report alerts when certain conditions are not met as requested by the user.
• Generated reports on various databases and at times using two different databases in the same Report.
• Tested output of reports using SQL queries in Toad to verify whether the report has met the user requirements or not.

Environment: Crystal Reports 8.5/10, Crystal Enterprise 9/10, Oracle 9i, MS Access, TrackWise 7.0, SQL Server 2000, PL/SQL, and Windows NT.

Confidential, Kansas City, KS

Crystal Reports Developer

Responsibilities:

• Involved in the Design, Development & implementation of Reports in Crystal Reports 10.
• Migrated existing Crystal 8.5 reports to Crystal 10.
• Created nested and conditional subgroups and formatting features in reports.
• Created Sub reports called from the main report to implement the business logic.
• Tuned reports for faster execution using stored procedures, views, column Index’s.
• Created complex formulae at the summary level and group level to implement the business logic.
• Scheduled the report using Schedule Manager in Crystal Management Console to run every day on a periodic basis.
• Developed database connections, SQL joins, loops, views, aggregates.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports 8.5
• Used prompts, alerts, drill down analysis as per the end user requirements.
• Responsible for creating the Complex Crystal Reports(On demand, Ad Hoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-down, Dynamic grouping, Cross-Tab, graphical, aging reports).
• Created complicated formulae and running totals on summarized totals for business measure calculations based upon various end user requirements.
• Used functions like InRepeatedGroupHeaders,WhilePrintingRecords,WhileReadingRecords and EvaluateAfter etc.
• Created Parameter driven reports to running time and restrict volume of data.
• Involved in creating various PL/SQL, stored procedures, views, functions and temporary tables for data input into crystal reports.
• Responsibilities include conducting meetings, gathering requirements and training users.

Environment: Crystal Enterprise 8.5/10, Crystal Reports 10, Oracle 9i and Win NT.

Confidential

Crystal Reports Developer

Responsibilities:

• Responsibilities include understanding the business functionality, direct interaction with users for specifications.
• Developed reports using Crystal Reports.
• Written Stored Procedures and Views on SQL Server 2000 to be used in various Crystal Reports.
• Generated the reports and giving those reports to users for verification.
• Gather user requirements, draft specifications, design and deploy reports using Crystal Reports Designer, Crystal Query.
• Report versions were maintained using TrackWise 6.0.
• Responsible for drafting documentation for end user usage and develop training materials.
• Responsibilities included setup and troubleshooting final product on user’s desktops.
• Developed database connections, SQL joins, loops, views, aggregates.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports 8.5
• Used prompts, alerts, drill down analysis as per the end user requirements.

Environment: Crystal Reports 8.5, SQL Server 2000, Windows NT, TrackWise 6.0, TOAD, and PL/SQL.