SUMMARY:

• US Citizen with 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

Crystal Reports, 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.

Environment: Crystal Reports 2016, 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

Environnent: 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 - 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

Crystal Reports Consultant

Confidential

Responsibilities:

• Optimizing existing Crystal Reports to make them run faster. Changed formulas and added WHERE clauses to SQL to significantly improve run times. Created views in the DB2 database. The backend database is IBM DB2. Ported the reports from Crystal Reports 9.0 to Crystal Reports XI. Deploying the reports to Crystal Enterprise. This work was done for Kaiser Permanente.
• Modifying Crystal Reports for the MTA (Metropolitan Transit Authority) of Los Angeles.
• Modifying Crystal reports for Sony Pictures Entertainment. Modifying existing SQL queries. Coming up with innovative solutions to handle new requirements like international timezones, fixing high priority defects in the reports and making changes to the reports according to specifications. Data is stored in an SQL Server database. Modifying SQL queries. Learning WebIntelligence Reports.
• Creating Crystal Reports for DELL Computer and its OEMs. This was a telecommuting job done for Application Objects. Data was in Oracle and Foxpro databases. The reports were created using Crystal Reports XI and deployed using Crystal Enterprise XI. Writing SQL queries to access the data in the database.
• Created reports for the accounting and operations departments of Trader Joes using Crystal Reports. These reports access data in an Oracle database and were used for auditing, merchandise valuation, inventory, stock synchronization etc The reports were deployed using a custom web application. Worked on the Store Order Guide report using Java and JasperReports. Created a scheduler using Oracle PL/SQL to automatically run reports at predefined intervals and keep a history of report data. Modified the Visual Basic front end for reports to upgrade it from Crystal Reports 8.5 to Crystal Reports 9.0. Modifying existing SQL queries to extract data from the Oracle database.
• Modified existing reports to enable the export to Excel to work properly. Ran daily reports and put them on the internal website. Added new features and columns to existing reports. Reports ran off of a Microsoft Access database. This database was populated with data regarding the calls coming into the call center. This work was done for the TXU call center run by CAP Gemini
• Created reports using Crystal Reports (version 10) for the Warehouse Management System. The reports calculated remake time, backlog, days above standard, cases to be processed and other statistics. Some of the reports also displayed information concerning the flow of products through receiving, processing, shipping etc Wrote complex formulas and did custom programming in Crystal Syntax language.Some of the reports also used subreports. The backend database was Oracle. Wrote SQL queries to extract data. This work was done for Neiman Marcus Inc.
• Created reports using Crystal Reports (version 8.5 and 9.0) for the Leasing, Rents and Prospect Management parts of the RealPage software product. The RealPage product is for multi-family communities (apartment complexes). The reports were web based and deployed using Crystal Enterprise 8.0.
• Created new reports and modified existing reports. The backend database is SQL Server. The data is extracted from the database using stored procedures.
• Created and modified ASP pages that collect report parameters and pass them to the scheduler. Wrote T-SQL queries to get data from the database.
• Created SQL Server stored procedures and optimized existing stored procedures.
• This work was done for RealPage Inc.
• Created reports using Crystal Reports (version 8.5) for the Salion Knowledge Manager and Salion Revenue Process Manager. Fixed high priority (Priority 1 and Priority 2) bugs in existing reports)
• Created custom reports for customers of Salion including Delphi and Dura.
• The backend database was Oracle 8i. Reports were deployed using Crystal Enterprise 8.0. Used custom Java and XML to collect report parameters. This work was done for Salion Inc.
• Created reports using Crystal Reports (version 8.5) for the Recruiting Center, Hiring Center, and Reporting Center and HireAnalytics products.
• The data was stored in a MS SQLServer database. Wrote SQL queries to get the data from the database.
• Created custom alerts, drill-down, Subreports and graphical reports.
• Created custom reports for clients of Confidential .com including Qwest, H&R Block and Harris. Wrote T-SQL queries to get data from the SQL Server database.
• Also worked on an Oracle database. This work was done for Confidential .com

Environment: Crystal Reports XI, Crystal Reports 10, Crystal Reports 9.0, Crystal Reports 8.5, Crystal Reports 8.0, Crystal Enterprise XI, Microsoft SQL Server, Oracle, IBM DB2, Foxpro, JasperReports, Java, UNIX, ASP