SUMMARY:

• 20 years of software development experience in System Requirement Analysis, Designing, Developing, Deploying and maintaining software.
• 12 years of Strong experience as a reports developer using Crystal Reports ( 8.5,9,10,XI,2008,2011,2013, 2016,CRE) and SAP Business Objects Developer Suite 4.1,XI - R3/XI-R2 (CMS, CMC, Universe Designer, InfoView, Web Intelligence, IDT.
• 5+ Years of experience in SAP Business Objects Administration and Crystal Enterprise Administration, building Universes, retrieving data using Universes, creating Ad-Hoc reports using Web Intelligence, with all kinds of Business objects ( XI-R3.1,XI-R3.2, 4.0,4.1,4.2) versions
• 10 years of ANSI SQL, Oracle PL/SQL and Microsoft SQL Server T/SQL experience, using Oracle 11g/10g/9.i/8i, MS SQL Server, MS Access.
• Upgraded reports from Business Objects XI 3.1 to 3.2
• Administering Business Objects Enterprise
• Upgraded reports from Crystal 9 to Crystal 2011
• Converted Desktop Intelligence ( Deski ) reports to WebIntelligence ( Webi ).
• Implemented Business Objects security to do User/Group management, Folders, Universes and Reports management, job scheduling.
• Worked with Import wizard to move the objects between DEV and QA systems.
• Hands on experience in realization of complete software life cycle using OO techniques, design and development of Client-Server and Web based applications, strong troubleshooting and problem-solving skills.
• Worked on different platforms which include Windows 95/98/2000/NT/XP/Windows7 and UNIX.
• Worked in an Agile environment
• Worked with different database management systems which include Oracle, SQL SERVER, IBM DB2, Teradata and Access.
• Hands on exposure to Customizing Infoview and BI LaunchPad.
• Installed BMC Remedy Analytics Business Objects Reports for Remedy 7.0 and 7.6
• Passed the Business Objects Certified Professional - Crystal Reports XI - Exam 1

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

Oracle and SAP Business Objects Developer

Responsibilities:

• Creating and modifying Crystal Reports.
• Deploying the reports in SAP Business Objects
• This is for the MSOW Physician Credentialing System
• Creating and modifying Oracle SQL queries. Writing PL/SQL DML ( Data Manipulation Language ) to clean and standardize the data in the Oracle database.
• Upgrading reports, users and groups from SAP BO 3.1 to SAP BO 4.2 using the Upgrade Management Tool.
• This is a remote telecommuting job. Am working from home

Environment: Crystal Reports 2013, Oracle PL/SQL, HealthStream MSOW, SAP Business Objects

Confidential, Los Angeles, CA

Crystal Reports Developer

Responsibilities:

• Creating and modifying Crystal Reports.
• Creating sub reports and complex formulas.
• Deploying the reports in SAP Business Objects
• This is for the MSOW Physician Credentialing System
• Creating and modifying Oracle SQL queries.

Environment: Crystal Reports 2013, Oracle PL/SQL, Morrissey MSOW, SAP Business Objects

Confidential, Denver, CO

Crystal Reports Developer

Responsibilities:

• Creating and modifying Crystal Reports.
• Doing some Crystal Server Administration
• Creating and modifying Oracle SQL queries and stored procedures

Environment: Crystal Reports 2013, Oracle PL/SQL

Confidential, Riverside, CA

Application Developer

Responsibilities:

• Creating and modifying Crystal Reports.
• Creating and modifying Microsoft SQL Server Stored Procedures

Environment: Crystal Reports 2013, Microsoft SQL Server

Confidential, Los Angeles, CA

Business Objects Developer

Responsibilities:

• Creating Webi ( WebIntelligence ) Reports.
• Modifying Universes with the IDT ( Information Design Tool )

Environment: SAP Business Objects 4.2, IDT, Webi, Universe, Microsoft SQL Server

Confidential, Burbank, CA

Senior BI Developer

Responsibilities:

• Creating Crystal and Webi ( WebIntelligence ) reports.
• Created Universes with the IDT ( Information Design Tool )
• Deploying report to the BI LaunchPad
• Mentoring and Training other team members

Environment: SAP Crystal Reports 2013, IBM DB2, SAP Business Objects 4.1, IDT, Webi, Universe

Confidential, Los Angeles, CA

SAP Crystal Reports Developer

Responsibilities:

• Creating new Crystal Reports and modifying existing ones for Medical Staff Services
• Writing Oracle PL/SQL Queries.
• Creating reports from the Morrissey MSOW Credentialing and Privileging system

Environment: SAP Crystal Reports XI, Oracle

Confidential, Irvine, CA

SAP Crystal Reports Developer

Responsibilities:

• Converting Actuate reports to SAP Crystal Reports
• Modifying Sybase Stored Procedures that provide the data
• Creating complex Crystal Reports that call more than 10 stored procedures in one report.
• Creating sub-reports, complex formulas, shared variables etc…

Confidential, Torrance, CA

Business Objects Developer

Responsibilities:

• Collecting report requirements from the Business
• Designing and developing the Sales Reports using Webi ( WebIntelligence )
• Advising on Installation, ETL, Universe Changes, Report Development, Architecture, Tools and Capabilities of SAP Business Objects

Environment: SAP Business Objects 4.0 SP01, Oracle 11g, Webi, Universe

Confidential, Sacramento, CA

SAP Business Objects Developer

Responsibilities:

• Modifying Universes
• Creating Webi Reports
• Writing SQL to Debug Report Queries

Environment: SAP Business Objects 4.1 SP05, IBM DB2, Webi, Universe’s, IDT

Confidential, Washington, DC

Sr Business Objects Developer

Responsibilities:

• Working on Webi Audit Reports that use the Audit Universe
• Testing Mobile reports to find issues in how they display on iPad devices
• Administering the Business Objects server using the CMC
• Creating reports using Crystal Reports for Enterprise
• Writing a Modernization document that recommends options for modernizing the Business Intelligence Infrastructure.

Environment: SAP Business Objects 4.1 SP05, Oracle 11g, Webi, Universe’s, Mobile, Crystal Reports for Enterprise

Confidential, Arlington, VA

SAP Business Objects Administrator and Developer

Responsibilities:

• Installed Business Objects 4.1 SP2 on Linux with Oracle 11g
• Installed Business Objects 4.1 SP3 on Windows Server 2012
• Business Objects 4.1 Administration using CMC and shell scripts.
• Setting up users, giving permissions and management of servers.
• Writing ETL scripts using DSS ( Data Synchronization Studio )
• Writing ETL scripts using Oracle PL/SQL Stored Procedures
• Writing a document on Mobile Strategy for Confidential that explores use of mobile devices like Smartphones and Tablets using Business Objects and Tableau
• Learning SAP Dashboard Design
• Making changes to Universes
• Worked in a Agile environment

Environment: SAP Business Objects 4.1 SP02, Oracle 11g, DSS, CMC, BI Launchpad, Crystal Reports 2013

Confidential

Responsibilities:

• Creating SAP Crystal Reports from Oracle ERP systems
• For Samson Controls developing new Crystal Reports for the Sales group from their Oracle IFS maufacturing database.
• For Airlite Plastics creating Crystal Reports for the Payroll ( check printing ) and Sales groups.

Environment: SAP Crystal Reports 2011, Oracle, ERP

Confidential, Rockville, MD

Reporting Specialist

Responsibilities:

• Creating new Crystal Reports and fixing issues with existing Crystal Reports that go against the ServiceNow SQL Server database.
• Creating Crystal Reports that go against an Oracle database

Environment: Crystal Reports 2011, SQL Server, Business Objects 4.0, ServiceNow, Oracle

Confidential, Teaneck, NJ

Business Objects Developer

Responsibilities:

• Creating new Crystal Reports and fixing issues with existing Crystal Reports.
• Analyzing Oracle EBS Fixed Asset and Accounts Receivable stored procedures and their corresponding Crystal Reports and created an Excel document that matches fields in the reports to their Oracle formulas.
• Learned Tableau

Environment: Crystal Reports 2008, Oracle EBS, Business Objects 3.1

Confidential, Arlington, VA

Business Objects Developer

Responsibilities:

• Creating new Crystal Reports and fixing issues with existing Crystal Reports.
• Downloading Business Objects Release 4 Server and BO R4 Client Tools. Installing the client tools.
• Working with BI Launchpad and adding Crystal Reports to the CMC and configuring then so they can be run through the BI Launchpad.
• Writing Oracle PL/SQL queries and creating Oracle views in the database.

Environment: SAP Business Objects 4.0, Crystal Reports 2011, BI Launchpad 4.0, CMC, Oracle

Confidential, Boston, MA

Software Engineer

Responsibilities:

• Writing, debugging and running Windows batch files and SQL Scripts
• These scripts converted healthcare data in Epic, Cerner and other formats to the proprietary database format used by Confidential .

Environment: Windows, Oracle, Batch files, SQL Scripts

Confidential, Lebanon, NJ

Reports Developer

Responsibilities:

• Writing complex Oracle PL/SQL queries with multiple sub-queries, multiple joins etc
• Creating new Crystal Reports for the SII project and for Long Term Care policy analysis.
• Helping junior developers with their SQL, Crystal Reports, Web Intelligence and Business Objects Universe issues.
• Participating in design sessions to come up with solutions for new Remedy ITSM report requests and finding out the best ways to implement them. Creating new Crystal and Webi Reports for the BMC Remedy Incident and Work Order Management system from the ITSM Universe.
• Using the Report Conversion Tool to convert Deski reports to Webi and also manually converting the reports.
• Creating time estimates to approximate how many hours’ new reports will take to create

Environment: Oracle, SAP Business Objects XI R2/R3, Crystal Reports 2008, Webi, BO Universes, Deski

Confidential, Arlington, VA

Business Objects Consultant

Responsibilities:

• Downloaded and installed Business Objects Dashboard Design (formerly Xcelsius).
• Created sample Flash reports using Dashboard Design that run in a web browser.
• Learnt Java J2EE technologies (Servlets, JSP, EJB etc).
• Downloaded and installed Java Eclipse and JBoss.

Environment: SAP Business Objects Dashboard Design (formerly Xcelsius), J2EE Web Development

Confidential, Annapolis

Business Objects Consultant

Responsibilities:

• Evaluating new feature requests, determining how they are to be implemented and providing time estimates for their implementation.
• Successfully fixed Production issues like Webi running out of memory, users unable to log in etc
• Designed a new security model that is scalable as new universes are added and also allows users the flexibility to share their ad-hoc reports within their groups.
• Modified existing Universes by adding new objects.
• Created a Webi report from the Activity Audit Universe that shows which users have not logged in for 45 days. Installing Business Objects Lifecycle Manager.
• Installing Service Pack 4. Helping users create Ad-Hoc Webi reports.
• Backed database is Teradata containing State of MD tax information

Environment: Business Objects, XI 3.1 SP4, Web Intelligence, Teradata, Business Objects Universe Design, WebIntelligence Reports, Lifecycle Manager, Activity Audit Universe, Query Builder,Teradata