PROFESSIONAL SUMMARY:

• Developed highly complex reports for Fortune 500 corporations and the Federal Government; utilizing Business Objects 4.x, XIR3.1, XIR2, 6.x and Crystal Reports 2008, Crystal Reports XI; as well as BOBJ Analysis for OLAP and Excel
• Data source Development/Evaluation: Performed Data Analysis in MS SQL Server 2008 and SAP BW 3.5 and 7.3; created documentation highlighting GAP analysis; also performed Integration and Unit test in SAP BW; developed and tested multiple BEx queries.
• System/Report Migration: Performed migration of system and reports for Fortune 500 companies; and, for the Federal Government between Windows 2003 and Windows 2008 with SAP Business Objects XIR3.1 and 4.1.
• Security Integration: Setup security for User accessing .Net interface in SAP Business Objects XI 4.1. Completed setup for Administrative Office of US Courts of 94 Dynamic Data Connections. Also, setup users and groups security ps, using the Central Management Console in Business Objects XIR3.

TECHNICAL SKILLS:

Business Intelligence Technologies: Business Objects XIR3, XIR2, 6.x, 5.x Suite (Desktop and Enterprise Server products suite), Crystal Reports XI, 10.0, 9.0, Web Intelligence (2.x, 6.x, XI)

RDBMS & Data Warehouse Technologies: MS SQL Server 2008, Oracle 9i and 10g, Sybase, Sybase IQ, Informix, SQL Server, Teradata, MS Access, Peoplesoft.

Applications: Embarcadero Rapid SQL, TOAD, MS Office, Erwin, MS ProjectOperating Systems: Windows XP/2003/2000/NT/XP/9.x, Macintosh, Citrix

Languages: C, C++, JSP, VB(6.0 & .Net), PL/SQL, HTML, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BI Engineer

Responsibilities:

• Developed and created SAP Crystal Reports based complex client requirements.
• Installed and setup SAP Business Objects XIR 3.1 on Windows 2003 and Windows 2008
• Configured security setup for Universe, SAP Business Objects Web Intelligence reports.
• Developed documentation detailing migration of SAP Business Objects XIR2 to 3.1 SAP Business Objecgs 4.1 on Windows 2003 and Windows 2008 environments.

Confidential

Sr. Consultant

Responsibilities:

• Performed analysis on existing SAP Business Objects environment on Windows 2003 environment
• Installed and setup SAP Business Objects XIR 3.1 on Windows 2003 and Windows 2008
• Configured security setup for Universe, SAP Business Objects Web Intelligence reports.
• Gathered Client requirements for SAP Business Objects Web Intelligence reports and security configuration
• Developed documentation detailing installation of SAP Business Objects XIR 3.1/4.1 on Windows 2003 and Windows 2008
• Continue to develop SAP Business Objects Web Intelligence reports and Analysis for OLAP documents.
• Troubleshot and resolved issues with installation of Tomcat and JAVA with SAP Business Objects XIR 3.1 and 4.1.

Confidential - Houston, TX

Sr. Consultant/Technical Designer

Responsibilities:

• Performed analysis on existing SAP BW 3.5 data objects and tables to determine feasibility with data conversion from Legacy Confidential to new merger business of OneSubsea
• Created Integration and Unit test scripts to verify feasibility analysis of Data Objects/Fields in BW 3.5
• Additionally tested and verified existing Business Objects 4.0 Webi reports for compatibility with new OneSubsea data objects
• Created documentation on executing and troubleshooting Business Objects reports
• Also created BOBJ report test scripts verifying data object compatibility with OneSubsea data

Confidential - Irving, TX

SAP Business Objects Report Developer / SAP BW Analyst

Responsibilities:

• Developed over 50 Webi Reports utilizing Launchpad and Webi Rich Client tools in BOBJ
• Additionally developed over 25 BOBJ Analysis for OLAP and Analysis for Excel reports
• Analyzed BW tables for the correct data mappings to fields utilized by BOBJ reports
• Also developed and modified BEx queries based on analyzed User requirements for BOBJ reports
• Trained End Users on development of Webi reports and Analysis for OLAP documents
• Helped create UPerform scripts for Super and End User documents
• Also created Test Scripts for Webi reports

Confidential - Monroeville, PA

SAP Business Objects Report / Business Explorer (BEx) Developer

Responsibilities:

• Developed over 23 complex SAP Business Objects XIR3 Web Intelligence (Webi) reports
• Utilized Universe Designer to convert created BEx queries for use with Webi reports
• Analyzed User requirements for development of BEx queries and WEBI reports
• Created multiple BEx’s to utilize with Webi reports

Confidential

Sr. Business Objects Developer

Responsibilities:

• Develop over 8 complex canned Business Objects XIR3 Web Intelligence reports using Infoview.
• In addition developed over 15 ad hoc Business Objects XIR3 Web Intelligence reports.
• Utilized merge dimensions and combined query tools to refine and maximize report queries.
• Created several new filters and objects using SQL in Business Objects Universe Designer.
• Administered Business Objects servers and services;
• Monitored and utilized the CMC to control services and User accounts.
• Created new user accounts and set parameters for accounts in the Central Management Console (CMC).
• Research existing requirement documents against available data to develop reports using MS SQL Server 2008.
• Provide feedback to Business Analysis team on recommended modifications to requirements to meet criteria for Administration Office of US Courts.
• Created and updated Metadata for over 1200 Universe Objects, Filters, and Folders.

Confidential - IL

Business Objects Report Developer

Responsibilities:

• Develop complex Business Objects XIR3 Web Intelligence reports using Infoview or Web Intelligence Rich Client.
• Research existing requirement documents against available data to develop reports using TOAD (based on Oracle 10g database).
• Provide feedback to Business Analysis team on recommended modifications to requirements to meet criteria for TSA.
• Assist Universe developers with SQL changes required to meet reporting and TSA requirements.

Confidential

Engineer II

Responsibilities:

• Requirements Gathering and Business Analysis. Interviewed users to collect Requirements, Analyzed them and transformed them into Technical specifications. Generated various reports as per the client's requirements.
• Migration of Universe and documents between environments (BO 6.5 and BOXIR2).
• Documented the Universe design and Reports development. the users in ad-hoc report development.
• Develop complex Business Objects XIR2 Web Intelligence reports.
• Update and maintain existing Business Objects XI and Business Objects 6.5 Universes.
• Also developed new Business Objects XIR2 Universes, involving Contexts and Derived tables.
• Provided production support for existing Business Objects 6.5 and Business Objects XI reports; as well as existing MS Office documents;
• In addition, provide consulting services such as LOE and development for requested Business Object XI Web Intelligence reports and Universes.
• Develop Level of Effort (LOE) for each request in regards to Business Objects reports/MS Office documents (MS Word, MS Excel, etc.)
• Additionally develop Adobe PDF forms, using Adobe Live Cycle Designer, as per client requests.

Confidential

Business Intelligence Consultant

Responsibilities:

• This project involved the Amtrak Engineering division’s conversion to Primavera Enterprise Reporting Database and Business Objects Enterprise.
• As a part of this project I was involved in creating highly complex Crystal Reports. These Crystal Reports were designed to highlight existing financial data regarding ongoing projects within the division.
• Created the report specifications based on user requirements and client feedback. Also these reports were built using a Universe created from Business Objects Designer.
• In total created four reports within the allotted eight week time period, and the following is a list of tasks as well as responsibilities performed by me on this project.
• Created Crystal Reports using Universe connection to obtain necessary report fields.
• Also created report specifications for Reconciliation PM, Reconciliation Proj ID, SpendPlan PM, and SpendPlan Proj ID.
• Gathered client information regarding creating the above mentioned report specifications.
• Modified Crystal Reports, based on client feedback, for drill down configuration for reports.
• Also modified Crystal Reports to reflect requested aesthetics of the reports.
• In addition was in the process of mapping existing database fields to the conversion to Primavera Enterprise Reporting Database (ERD).
• Performed query searches via TOAD v8.6.1.

Confidential

Dassault Systemes, Crystal Reports Developer

Responsibilities:

• This project required building financial reports, using the Accounts Receivable module, to edit and populate two reports. Both reports involved getting detailed financial information, dealing with the DSAC arm of Dassault Systemes, for their General Ledger and STC reports. The infrastructure system for reporting was built using Crystal Reports Designer via Businessviews.
• Created 2 Crystal Reports using Businessviews to obtain necessary fields.
• Performed query searches via TOAD
• Obtained TNS entries to obtain the required data for the reports
• In addition queried the Peoplesoft database, regarding fields required to complete the data for the reports
• Also obtained or consulted in creating Businessviews necessary to complete the reports.

Confidential

Business Objects Consultant

Responsibilities:

• This project required building reports tracking “Clients” also known as Criminals during various stages of the trial and pre-trial process within the U.S. court system.
• Constructed 3 dynamic Crystal Reports.
• Also converted existing Universe to Business views for Crystal Reports reporting purposes.
• Crystal Reports created involved multiple embedded sub-reports (more than 15 sub-reports in one case).
• Created 15 Web Intelligence reports in BO XIr2
• Setup Universe Overloads to enable Dynamic Data Connections for Users in all 94 districts.
• Established security on Central Management Console for different districts and role based groups.
• Worked on developing security criteria at all levels
• Created 94 Dynamic Data Connections
• Migrated Development environment from Windows to Linux.
• Continue work with importing (using Import Wizard tool) current development environment on a Windows based server to the Linux server
• Also assisted with creating helpdesk case (for Business Objects) for Crystal Reports Dynamic Data Connection error
• Managing the report deliverables and the project timeline

Confidential - IL

Business Objects Report Developer

Responsibilities:

• Gathering the functional specifications for the financial reports needed for the business
• Gathering the technical specifications needed for Business Objects Reporting as well as Universe creation
• Created the mappings to go from the Report specifications to Universe design
• Designing the Business Objects Universe to enable reporting
• Created a multi-faceted Crystal Reports using created Business views to show a carrier’s “Bill of Lading”
• In addition the “Bill of Lading” Crystal Report involved inserting complex sub-reports (created via said Business views) and formatting report to resemble a “Bill of Lading”
• Created the Motor Carrier Compliance Application Universe for Web Intelligence reports
• Created Web Intelligence reports by Section/Breaks and Calculating measures at different levels.
• Updated the prompt at the Universe level instead of hard coding the List of Values (LOV)
• Helped Functional Analysts in validating Web Intelligence report formatting
• Designed summary tables for MTD, YTD, QTD aggregations on Web Intelligence reports.
• Linked drill reports to provide seamless integration of expedited, non-expedited, TTC, and Non-TTC comparisons.
• Developed complex Web Intelligence report to resemble a Bill of Lading form, and still provide the data viewing capabilities not necessarily a Web Intelligence strong suite.
• Managing the report deliverables and the project timeline

Confidential

Business Objects / Crystal Reports Migration Expert

Responsibilities:

• This project required building financial reporting for the accounting and finance department. The current mainframe system finance reports needed to be built using Business Objects XI Web Intelligence reporting tool. The mainframe system data was moved from Crystal Reports 9, Business Objects 6.x, and Business Objects Data Integrator was used to build the data mart for Business Objects reporting. The reports were built in Business Objects XIr2 needed to be validated against the mainframe system Business Objects 6.x reports and the Crystal Reports 9 reports. Report Migration tool was used to migrate these mainframe reports and also for initial validation of the Business Objects report.
• Gathering the functional specifications for the financial reports needed for the business
• Gathering the technical specifications needed for Business Objects Reporting
• Designing the Business Objects Universe to enable reporting
• Created Universes, Webi reports, User groups, and assigned privileges at different Security levels using XI Administration Console (CMC).
• Created Web Intelligence financial reports by Section/Breaks and Calculating measures at different levels.
• Updated the prompt at the Universe level instead of hard coding the List of Values (LOV)
• Helped Analysts in validating financial reporting
• Designed summary tables for MTD, YTD, QTD aggregations on Webi reports.
• Linked financial reports to provide seamless integration of Year-over-Year, Month-over-Month, and Quarter-over-Quarter comparisons.
• Developed advanced financial reports such as Balance Sheets, Outstanding AP, AR Aging Report etc.,
• Developed Business Objects reports with multiple currency conversions to enable global deployment of the reports

Confidential

PepsiCo, Business Objects Reporting Consultant

Responsibilities:

• This project required building an executive level and a regional sales level reports. The executive level reports contained rows of data comprising of the key performance indicators.
• BI requirements gathering based on the business needs
• Designing the executive and regional sales level reports
• Developed Webi and Crystal Reports; provided methods to drill through to reports from dashboards
• Provided feedback to business users on report’s design and recommended changes to make reports intuitive, flexible with increased performance
• Assessed possibilities to transform the canned reports into dashboards using application foundation
• Moving the Web Intelligence objects and dashboard from development environment to QA environment and to Production environment for final deployment.
• Developed three level information dashboard metrics and analytics from top-level dashboard view to the final drill down reports
• Creating dimension slicing and securing the dimension slices to restrict access based on regions

Confidential

Customer Service Specialist II

Responsibilities:

• Assisted customer with inbound calls regarding their bank products.
• Sold additional bank products or services to existing and new customers.
• Trained fellow employees on sale techniques.

Confidential

Mortgage Counselor

Responsibilities:

• Assisted customer with finding the right mortgage product to meet their financial needs.

Confidential

Responsibilities:

• Provided additional insurance coverage to existing Confidential customers on bank products.
• Also provided upgraded insurance on products bought through Confidential with partner retailers.