Summary:

• Experienced Business Objects Administrator/Developer with over 7 years experience in the IT environment working on large-scale enterprise projects involving complex business case functions, web integration, and data management.
• Extensive experiences in developing Reports in Crystal Reports 8.5/9/10/XI/2008, Xcelsius, Desktop Intelligence, Web Intelligence and Business Objects Enterprise XI/XIR3.
• Extensive experience in creating Dashboard in Xcelsius.
• Experience in designing, optimizing and maintaining Universes in Business Objects XI/XIR3.
• Extensive experience in managing and giving access rights to users to reports in the Business Objects Environment.
• Developed reports based on events.
• Experience in creating web services in JEE for Xcelsius Dashboards.
• Proven track record of innovating solutions to development problems, production glitches, and data management conundrums.
• Highly regarded for a proactive attitude and an ability to think laterally, providing ideas and solutions.
• Extensive experiences in developing Stored Procedures, Views, Triggers, XML and Complex Queries on SQL Server 7.0/2000 and Oracle 8i/9i/10g
• Excellent experience in XML and architecting XML projects
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Sever Debugger.
• Excellent experience in Crystal Reports Optimization, with large scale data and complex customized reports.
• Extensive experience in writing Scripts, Batches and Data Migration using DTS.
• Extensive experience in Data Transformation, Data Transferring, and Stored Procedures Optimization in working with VLDB(s).
• Involved in all phases of software development life cycle from design, implementation and testing.
• Dedicated work ethic demonstrated through high productivity levels.

Education:
BS in Computing and Information Technology

Software/Hardware:
Business Objects/Crystal Reports 8.5/9/10/ XI/XI3/2008, Oracle 8i/9i/10g, MS SQL Server 6.5/7/2000/2005, TOAD, T-SQL, PL/SQL, ODBC, ADO, RDO, DTS, ActiveX, JEE JSF, Servlets, JSP, MS Access-97/2000, MS Visio, ERWin Platinum, XML, ER-Designer, Source Control Management (SCM), Windows 2003.

Experience

3/2007 – Present Confidential, New York, NY

Main Responsibilities

• Served as a Business Objects Administrator and a Crystal Enterprise Reports Developer.
• Install and configure Business Objects XI/XIR3 in the Windows 2003 environment.
• Maintain users, reports, and objects in the Business Objects environment.
• Developed, design and maintain universes in Business Objects.
• Developed web services that were accessible by XCelsius dashboards.
• Give access rights to users in Business Objects
• Developed Web and Desktop Intelligence Reports.
• Optimize and maintain various schemas in the universe.
• Deployed and maintain reports on the Business Objects Server
• Optimized The Performance of Reports
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Designed, developed, and tested stored procedures, views and complex queries for Crystal Reports distribution.
• Publish reports in Crystal Server’s QA Environment.
• Developed database triggers and stored procedures using PL/SQL cursors and tables.
• Developed and maintained complex PL/SQL packages.
• Managed all indexing, debugging, optimization and performance tuning, Profiler and SQL Server Agent.
• Designed and developed Data Transformation Process using BCP utility.
• Used advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner.
• Build and perform user acceptance testing on new and modified reports.
• Wrote Stored procedures as per needed.

Environment:
Business Objects/Crystal Reports XI, Crystal Reports 10, Crystal Enterprise XI, SQL Server 2000/2005, DTS, BCP, T-SQL, Oracle 9i/10g, PL/SQL, TOAD, XML , XSL/XSLT, X-path, DOM, COM/DCOM, SOAP, T-SQL, Visual Source Safe, JavaScript, Windows2000/2003

Experience:
01/07 – 02/07 Confidential, TX

Main Responsibilities

• Served as a Crystal Enterprise Reports Developer/Administrator and SQL Server Developer in support of Service Management System.
• Managed a small team to develop New Crystal Reports.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Designed, developed, and tested stored procedures, views and complex queries for Crystal Reports distribution.
• Developed database triggers and stored procedures using PL/SQL cursors and tables.
• Managed all indexing, debugging, optimization and performance tuning, Profiler and SQL Server Agent.
• Designed and developed Data Transformation Process using BCP utility.
• Used advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner.
• Build and perform user acceptance testing on new and modified reports.

Environment:
Crystal Reports 10, SQL Server 2000, DTS, BCP, T-SQL, Oracle 9i/10g, PL/SQL, TOAD, XML, XSL/XSLT, X-path, DOM, COM/DCOM, SOAP, VB Script, SQL Server 2000, T-SQL, Visual Source Safe, JavaScript and Windows2000


Confidential, Aug 2002 - Dec 2006
Programmer/Analyst

Main Responsibilities:

• Developed the Post and Prepaid billing System using Java and Oracle.
• Designed and developed complex user interface, and multi threading.
• Managed migration process of Crystal Reports 10 reports to Crystal Reports XI.
• Used advance features of packages, cursors, extended interface methods, and advance object types to write powerful PL/SQL programs.
• Developed stored procedures, views and complex queries for Crystal Reports distribution.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Scheduled, maintained, and supported the distribution and access to reports through the use of several implemented web-based reporting tools, published generated reports on Crystal Enterprise.
• Implemented PL/SQL scripts in accordance with the necessary business rules and procedures.
• Involved in Database design and created tables, keys, stored procedures, User functions and triggers in the database.
• Managed design and implementation of Portfolio Snapshot module for on-going releases of system. Managed backup, restore and maintenance of databases.
• Managed all reviews and interpretation of business functional requirements and developing, troubleshooting of stored procedures, views, triggers, distributed queries and XML.
• Managed all developing and deployment of enhancement scripts, DTS, Log Shipping.
• Managed all indexing, debugging, optimization and performance tuning, Profiler and SQL Server Agent.
• Provided innovative research on SQL Server procedure change that resulted in complete redesign of entire system.
• Involved in customizing the Windows Forms Data grid.
• Developed custom controls for Windows Forms and generating reports.
• Involved in the development of SOAP based XML Web Services, like financial account management and Purchase Orders which forms the business logic components of the system.
• Used ADO.NET extensively to access the database.
• Involved in Database design and created tables, keys, procedures and triggers in the database