PROFESSIONAL SUMMARY

Information Technology professional with more than 12 years experience in Reporting, Business Analyst and Application Development with a strong Finance background.

TECHNICAL SUMMARY

• Reporting– Crystal Report/Enterprise 11, Web Intelligence, MS Access
• Databases – Oracle, SQL Server, PeopleSoft, Hyperion, Essbase
• Office Tools – MS Office (Access, Excel, PowerPoint, Word)
• Applications – Query Analyzer, Business Objects XI, Universe, Microsoft Visual Studio2005 version8, Toad, Safesource, Peregrine, SAP R/3, CDO,.
• Industries: Finance, Accounting, Sales, Marketing, Inventory, Desktop Support, Production Services, and Accounts Payable.
• Key Terms\\experience- Strong Data Warehouse and relational database concept, Stored Procedure, MS Sql Server T-SQL, Requirements gathering, Crystal Reports, MS Excel, Data queries, Report design, Testing, and User training, Access database, Webi, Universe.

PROFESSIONAL EXPERIENCE

Business Objects\\Report Developer (Contract) 03/2010– 06/2010
Confidential,Irvine CA.

• Responsible for gathering requirements, creating specs, testing and writing reports.
• Maintained universe for creating Ad Hoc reports.
• Created advanced Crystal reports, Webi using Universe,
• Created SQL queries using Add command.
• Created reports using Query Analyzer.

Report Developer (Contract) 09/2007– 03/2009
Confidential,CA.

• Responsible for gathering requirements from users, creating specs, testing and writing Crystal Reports (version 11).
• Responsible for reporting environment including testing, QA and fixing Crystal reports supporting the London Data Warehouse.
• Created advanced crystal reports using sub-reports, formulas, conditional formatting, graphs and grouping.
• Responsible for reporting on Collateralized Debt Obligation and other Asset Backed Securities.
• Developed and implemented the usage of stored procedures used by the reports.
• Responsible for translating complex Indentures to create Crystal reports of their requirements.
• Responsible for maintenance of over 1000 Crystal reports.

Business Analyst\\Crystal\\ SQL Developer (Contract) 05/2007 – 08/2007
Confidential,CA.

• Responsible for gathering requirements, creating specs, testing and writing reports.
• As being part of IT worked with the development teams and Data Warehouse to provide data analysis and reporting.
• Created stored procedures using SQL Server Management Studio 2005.
• All Crystal reports and sub reports created off of stored procedures.
• Used Microsoft Visual Studio 2005 version 8 to keep track of tasks, open risks, bugs, changes andchecking-in and checking- out queries, reports and documents.

Business Analyst\\Crystal Report Developer (Contract)04/2005 – 03/2007
Confidential,Irvine, CA
Projects – Marketing and Production Services:

• Responsible for gathering requirements, creating specs, testing and writing reports (version 10).
• Responsible for working with users for gathering requirements.
• Developed complex reports for executives and functional departments.
• As part of development teams worked directly with data Warehouse group to provide data analysis and reporting.
• Created Crystal report off SQL server and Oracle databases.
• Created reports directly off SQL queries and added (nolock) in to the statement.
• Created SQL queries using Add command.
• Created Stored Procedures using Query Analyzer, toad and Safesource.
• Created advanced reports using sub reports, parameters, selection criteria, formulas, conditional formatting, SQL query, running totals, and On-demand grouping.
• Created complex reports using advanced formulas to calculate time differences while excluding weekends.
• Created Audit reports to compare present to history.
• Responsible for Installing Crystal Report 11 and creating ODBC connection to SQL Server.
• Responsible for updating Oracle tnsnames Ora file.
• Converted reports from oracle database to sql database.

Senior Crystal & Financial Report Developer (Contract)
Confidential,Torrance, CA 08/2002 – 02/2005
USA, Torrance

• Responsible for gathering requirements, creating specs, testing and writing reports.
• Created Crystal report off of Essbase, Peregrine, Excel, MS office and SQL Server using ODBC connectivity. In order to automate the Financial reports, converted all financial reports (budgeting, forecasting) from excel to Crystal reports.
• Created advanced reports using sub reports, parameters, selection criteria, formulas, conditional formatting, SQL query, running totals, graphs and grouping.
• Created financial reports for high-level Management.
• Created PeopleSoft queries.
• Created and Maintain Access databases and reports off these databases.
• Responsible for setting up Info Desktop 7 to ensure accuracy and timely distribution of reports.
• Responsible for administrating and scheduling reports using Crystal Enterprise 9 and 10.
• Responsible for distributing reports Via Crystal web.

Confidential,El Segundo, CA 09/1994 – 10/2000
Merisel was a Fortune 500 North American distributor of technology products, use to generating sales of $5.2 billion in 1999.

Confidential,1999-2000
Programmer II (Full Time)

• Responsible for application development and reporting environment administration tasks supporting the North American Data Warehouse. Technical environment includes Oracle/Unix data warehouse/ data marts sourced from SAP R/3 application environments. MicroStrategy OLAP and Seagate Crystal Info/Reports are deployed as the decision support and end user access reporting solutions, including web-based data analysis and reporting for over 300 users.
• Seagate Crystal Reporting and Info Administration:
• Created advanced reports using subreports, parameters, selection criteria, formulas, conditional formatting, running totals, graphs and grouping.
• Worked with the development teams, product management teams, executive level, to provide data analysis and reporting.
• Developed over 25 Infoviews providing a standard ‘semantic layer’ to support end-user data warehouse report development
• Provided technical leadership for Seagate Crystal Reporting and Info environment for report development and system administration.
• Provided quick response and resolution to production issues.
• Resolved power user’s issues with Crystal report development.
• Provided training and support for over 35 report developers in the functional departments.
• Developed complex reports for executives and functional departments.
• Participated as Application Development lead for Crystal 7 upgrade.
• Responsible for Crystal Info administration.
• Assisted lead DBA with database script development and maintenance.
• Developed validation scripts to ensure referential integrity of data loads.
• Prepared production change control documentation.
• Developed structure and data to support application development.
• Utilized Oracle’s export and import utilities to extract and load sample data.
• Utilized Oracle’s sqlloader to load into development and test environments.
• Created control files to be used by sqlloader utility.
• Developed pl/sql scripts to manage growth of historical data
• Created UNIX control files.

Confidential,Sr. Analyst 1994-1999 (Full Time)

• Responsible for development, enhancement, and maintenance of Inventory accounting system to facilitate Forecasting, Inventory Accounting, Reporting of daily Inventory, and various aging reports. Participated in gathering of application requirement, design, development, as well as testing, documentation, and implementation.
• Designed and developed Automatic daily process of creating reports for the remote user.
• Designed and maintained various forms for accounting department.
• Designed and developed a new database to age our Inventory level of 400 million dollars at sku level.
• Assisted management with reporting and variance analysis.
• Designed and maintained various forms for accounting department.
• Tool Utilizes: Crystal, MS Access, Paradox, Excel, MicroStrategy, Object Pal Language (OPL), SAP, Cambar.

B.S. in Computer Science - Confidential,University, Columbus Ohio.