OBJECTIVE: Seeking a senior Oracle/Cognos developer position which allows me to utilize my years of experience, knowledge and skills in Oracle and Cognos BI tool for financial industry application development.

QUALIFICATIONS:

• 7 years of experience in enhancement, maintenance for Oracle dimensional model data warehouse and Oracle/Cognos reporting system participated in database design, implementation and performance tuning on queries, procedures that are used for the new Cognos reporting system, joined architected Cognos serve with connections to Oracle, SQL server and Sybase servers.
• 10 years of experience in using Oracle PL/SQL to create/maintain stored procedures, functions and packages for daily EOD data loading batch processes and collect accurate data for reports at Oracle DWH.
• 15 years of experience in developing applications for financial industry to be able to work directly with business users to collect and analyze business requirement have solid finance industry knowledge in portfolio management including Equity, Fixed Income and Derivative products.
• 20 years of experience in designing and implementing reports for financial industry by using various technologies: Oracle 7.3 11g, Toad/Navigator, Cognos 8.2-10.1.1, SQL Server, Sybase, UNIX K shell, AWK and SED, Microsoft Windows, Excel, Words, TFS, etc.

EXPERIENCE:

Confidential

Sr. Oracle/Cognos Developer

Worked as a lead person for any Oracle/Cognos related projects, supported Oracle data warehouse DWH . Responsibilities included monitoring and solving any issues on daily EOD data loading batch processes and generating new daily data file at Oracle DWH, the data file shall be used for building new daily Cognos cube. Making sure daily Cognos reports auto-delivered to individual traders, managers at finance and compliance groups. Developing and maintaining enhancement within the data processing engine at Oracle DWH if any new changes on data requested by finance, compliance, billing and trading support groups. Managing creation of ad-hoc reports and delivery, project prioritization, and project management coordination. Developing and maintaining Cognos production, development, QA and DR environments with UNIX SA and database DBA groups.

Major projects included:

• Designed and created new Oracle packages to load external data flow in and combined it with existing transactions at Oracle DWH for compliance.
• Completed data migration from new merged company Millennium to existing Oracle DWH.
• Re-designed and implemented Oracle/Cognos reporting system for daily accurate data refreshment to all individual traders, heads of traders and manager term at the company.
• Migrated trading commission calculation engine named C-Calc from SQL Server to Oracle DWH.
• Created many new Oracle procedures for various Cognos reports, requested from finance, compliance, billing and trading support groups.
• Completed many ad-hoc reports or collected historical data for urgent requirements from FINRA auditing, Cognos reports, and data files to third parties.
• Hands-on experience in Cognos Framework modeling built connections between Cognos server and Oracle, SQL server and Sybase, created many Cognos packages for reports to various internal and external users.
• Hands-on experience in Cognos event and report studios created various Cognos reports and scheduled them delivering on time based on requirements from finance, compliance, trading support, traded record allocation and billing groups.
• Managed the effort of building new Cognos monitoring screens for Oracle DWH EOD batch processes.
• Designed and implemented new view at Oracle DWH for daily incremental trading data which is used to build new daily Cognos TM1 cube.
• Designed and implemented more than 150 daily Cognos reports with data from different data sources like Oracle, SQL server, and Sybase databases.

Hands-on development projects include:

• Designed and implemented a new Oracle package named as grs trader revenue as data source for T 1 daily trader revenue reports to 39 individual traders, head traders and managers at finance and marketing groups. It reduced running time from original 6 7 hours to about 2 hours by using new aggregated tables, selected right indexes and made query optimizations. Utilized Oracle SQL, PL/SQL and bursting function within Cognos service.
• Designed and implemented new Oracle package named 'grs trading profitability for T 1 daily year-to-day revenue summary report to management term based on all traded information within last 2 years up to prior business day. The report with couple pages in displaying numeric details and graph had become a very important daily guild report at company level and it was shared by many mangers within different groups like finance, marketing, sales and trading support. Utilized Oracle PL/SQL for packages and Cognos report, event studios.
• Used dimensional model data structure when migrated data from merged company Millennium to Oracle DWH. Utilized general normalization steps, Oracle SQL, PL/SQL to create new tables, indexes, stored procedures, functions and packages.
• Converted SQL Server stored procedures to Oracle packages for migration C-Clac engine at Oracle DWH. The engine is used to calculate commission for each traded records as part of daily batch processes at DWH. Utilized Oracle PL/SQL language to create procedures, functions based on understood business concept at existing SQL Server procedures. We did not have document for those business rules when need the migration.
• Designed and implemented new Oracle package 'grs DWH batch monitoring' package as data source for new monitoring tool at Cognos service which is used by nightly processing support group.
• Designed and implemented ad-hoc reports at Cognos event studio to notify clients whenever real-time allocation data is not available at SQL server database but scheduled daily real-time data reports are ready to go at Cognos production service. The modification will auto-disable the scheduled reports but emailing notifice to users. Utilized Cognos event, report studios and SQL server stored procedures.
• Designed and implemented new Oracle package grs bloomberg monthly rpt for auto delivery of daily and monthly data files to Bloomberg. Utilized Cognos report, event studios and Oracle PL/SQL fro packages.
• Created and modified many Cognos packages that categorized with correspondence on different departments such as compliance, finance, billing and data allocation groups. Utilized Cognos Framework management tool.
• Coordinated for migration from Cognos version 8.2 to 10.1.1 by verified all Cognos reports and events.

Confidential

Oracle Developer

Responsible for support, develop daily/monthly data updating processes in backend EIS Executive Information System data warehouse. Participated design, and coding by using PL/SQL to complete general/complex and ad-hoc mailing or campaign requests from customer services. Responsible monthly financial reports to CEO or members of leader group.

Hands-on development projects include:

• Created new monthly processes for profitability calculation at account and customer levels based on internal financial business rules. Utilized Oracle procedures.
• Designed and built new monthly processes to identify HVC Highest Valuable Customers records of the company and created auto system reports of them to customer services based on data from those processes. Utilized Oracle procedures.
• Created a framework with UNIX K shells and SQL queries to speed up completion of general/complex or ad-hoc mailing or campaign requests from customer services. Utilized Oracle procedures and UNIX K-shell scripts.
• Designed and built annual process to update RMD Requested Minimum Distribution Information at each IRA account for internal intranet users. Utilized Oracle procedures.
• Tested and implemented some auditing reports for new Business Objects Enterprise system. Utilized Business Object software.

Confidential

Sybase Developer

Responsible for support and development daily pricing and overnight data transactions for the company's pricing system which runs for deals issuing from CMO Collateralized Mortgage Obligation , MBS Mortgage-Backed Securities and ABS Asset-Backed Securities in fixed income business field.

Hands-on development projects include:

• Finished implementation of calculating historical prepayment speeds for CMO whole load deals issuing from MBS of fixed Income. Utilized Sybase stored procedures.
• Created new pricing process for tranches of airline and railroad issuing from ABS Asset-Backed Securities of fixed Income. Utilized Sybase stored procedures.
• Modified some UNIX K shells for data delivery to clients.
• Created or modified graphic screens for internal users to view data directly from the pricing system. Utilized internal Jam7 software applications.

Confidential

Reverse Engineer Finance Analyst

Responsible for loading daily data into the company's price model system called Precision for Collateralized Mortgage Obligations business. Checking and make sure daily cash flow data in the model which will match records in its correspondent public prospectus for each issue by using VAX machine and Pascal language.

Hands-on development projects include:

• Reverse engineered more than 900 CMO agency and whole loan deals for the company price system. Utilized Pascal software at VAX/VMS system.