SUMMARY:

• ORACEL SQL, PL/SQL, TOAD, DbVisulizer
• SYBASE T - SQL
• MS SQL
• DB2 SQL and DB2 Control Center
• Script Language - PERL, JavaScript
• Actuate Report developer - 7 years experience in Release 4,5,6,7 and 8
• Actuate Server Administrator - 3 years experience in Release 4,5 Windows NT environment
• Other business reporting tool - Crystal Report, BIRT
• DB2 Relational Database Administrator and Operations Support
• DB2 Relational Database Application Developer
• Application Lifecycle/Change Management - Start Team, Perforce 4, Microsoft Visual SourceSafe
• Groupware - IBM Lotus Notes Administrator, Lotus SameTime
• Programming Languages - FORTRAN, COBOL, Assembly, PASCAL, RPG, C, C++, JSP, Basic, Visual Basic, Actuate Basic
• Operating Systems - Windows NT, UNIX, IBM iSeries, IBM AIX

PROFESSIONAL EXPERIENCE:

Confidential, California

Data Analyst

Responsibilities:

• Review and analyze existing reports in Sybase InfoMaker. Identify required report functionalities and make recommendations for procuring report tools that would integrate with new applications and align with other accessible IT services.
• Install Eclipse-based open source reporting system BIRT. Established JDBC connections to Sybase databases. Experiment with BIRT functionalities.
• Use DbVisualizer and Sybase Central to maintain database tables in Sybase Adaptive Enterprise 15.0.2 server and Oracle 8i server. Review/revise existing SQL indexes, T-SQL and PL/SQL stored procedures, develop new procedures and functions to improve SQL performance.
• Extract, transform and Import/export data for internal users and external clients.
• Develop a stored procedure to produce a listing of primary keys, foreign keys, column’s system data type/user defined data types and other attributes for the entire business application in Sybase database to examine data integrity and enhance data quality.
• Author implementation details and program source codes for SQL stored procedures in internal Wiki.

Confidential, California

Actuate Report Contract Developer

Responsibilities:

• Working with Business Analysts and users to determine business requirements and technical specifications. Design, develop and test Actuate Reports and Actuate Information Objects using the Actuate Developer Workbench version 7, Oracle SQL, PL/SQL and TOAD technologies in Oracle and TrueComp sales compensation databases.
• Provide documentation, support and on-going maintenance.

Confidential, Los Angeles, California

Actuate Report Contract Developer

Responsibilities:

• Upgrade report design from Actuate Release 6 to Release 8. The assignment is to modify objects in customized foundation class and recompile all Actuate Report Design to eliminate new bugs and incompatibilities. Identify and coordinate testing and installation tasks and resource scheduling.

Confidential

Actuate Report Contract Developer

Responsibilities:

• Design and revise stored procedures in Unix/Sybase SQL environment. Maintain PERL scripts for report productions. In Actuate report design, prepare stored procedure execution statement; define input parameters, output parameters. Work extensively in overriding BindDataRow and Fetch methods for single and multiple returned result sets.
• Implement Actuate Single Input Filter and Actuate Memory Buffer for multiple report sections with different sorting criteria. Develop Actuate Multiple Input Filter to merge data sources reside in multiple database servers. Override Start, Fetch and Finish methods for data screening and selections. Implement AcMemoryDataSorter and override Compare Method for specific sorting requirements.
• Maintain libraries that contain commonly used components (.rod) and functions (.bas) across applications. Develop and publish reusable objects in a library (.rol) with enhanced functionalities and flexibilities.
• Monitor the Return Status of stored procedures and provide error handling and message logging to ease report development, testing and job stream control in production. Experience in step-into debugging to monitor executions of Actuate Foundation Class.
• Design the overrides in Start, Fetch and Finish methods in retrieving data from flat files that serve as journal entry receiver for audit trail reporting.
• Work experience in converting Actuate .roi files into ASCII text file for archiving and report distribution.

Confidential, Los Angeles, California

Actuate Report Developer

Responsibilities:

• Use Actuate Web Agent to publish reports in Intranet environment.
• Design and troubleshoot defects in Crystal report production. Conduct performance, and user acceptance testing for Actuate report and software changes.
• Interact with end users to analyze business requirements to provide reporting for daily business procedure and seasonal statistics reports. Assist users in developing MS Access ad hoc reports.
• Set up user access privileges in Actuate Encyclopedia to eliminate Actuate End User Desktop software entirely in the company.
• With DB2 Relational Database knowledge, revise and optimize Actuate SQL procedures to achieve a cost reduction in Actuate Server licensing - from four to two.