SUMMARY:

• SQL, backend Oracle PL/SQL development, Database design, Teradata, ETL, Informatica, data warehousing/SQL reporting, Data profiling, data mapping and data analysis.
• I have actively participated in all phases of system development life cycle, including user requirement gathering, business analysis and design, database logical design, programming specification, application programming, testing, implementation and post implementation production support.
• I have worked in industries of finance, trading, energy, retail, communications, telecom, accounting, pharmaceutical, HR benefit, point of sale, insurance, healthcare, high tech consulting, government reporting.

TECHNICAL SKILLS:

Database Management Systems: ORACLE 11g, 10g (PL/SQL, SQL*Plus, SQL*Loader), Teradata, Informatica, Unix on SUN Solaris

Tools: PL/SQL Developer, TOAD, Erwin, Visio, SQL Plus, Tableau, SQL Tools, SQL Navigator, PVCS, CVS, Autosys, Crystal Report

Languages: SQL, PL/SQL, Korn shell

PROFESSIONAL EXPERIENCE:

Confidential,San Ramon,CA

Sr. System Analyst Programmer

Skills used: SQL, PL/SQL, ORACLE11g, Teradata, Informatica, Tableau, PVCS

• As a backend database developer in Risk Data Control system development team, major responsibilities include database design, data analysis, data profiling and data mapping, data cleansing to ensure data integrity, developing complex PL/SQL stored procedures, packages, triggers, functions, views, constraints on ORACLE11g/10g, Informatica mappings, Teradata stored procedures, views and queries, in a financial environment, working closely with front end Java and .NET developers, business object reporting developers, business analysts, project leads, DBAs, Quality Assurance engineers and some business users; designing and creating database objects such as tables, indices, partitions, synonyms, grant privileges etc.; performance tuning, helping with analyzing and designing system process and testing, implementing and wrapping up project with proper documentation. Maintaining ER diagrams, process flow charts, etc.Served as user administrator on Tableau server, in charge of creating/maintaining users, projects and user groups on Tableau server. Created pre - published data sources for Tableau users.
• Worked on a Tableau reporting project by modifying a dashboard. Helped business users create customized Tableau reports.
• Created queries on source database systems on Microsoft SQL Server.
• Worked closely with various business and IT directors and managers, writing the Service Level Agreement (SLA) for the Energy Procurement department.

Confidential,San Francisco,CA

Sr. Database Engineer (Consultant)

Skills used: PL/SQL, ORACLE10g, Unix, Korn shell scripts, Clear Case

• As a pure backend Oracle database developer in YOM collection system development team, major responsibilities include developing complex PL/SQL stored procedures, packages, triggers, functions, views, constraints on ORACLE10g in a large scale financial/banking environment, working closely with front end PowerBuilder/Java developers, business analysts and project leads, DBAs,
• Quality Assurance engineers and some business users; designing and creating database objects such as tables, indices, partitions, synonyms, grant privileges etc.; performance tuning, helping with analyzing and designing system process and testing, implementing and wrapping up project with proper documentation.

Confidential,San Francisco,CA

Sr. IT Staff

Skills used: PL/SQL, ORACLE10g, Unix, Korn shell scripts, CVS

• Worked in Schwab Bond Source system support group, developed various SQL financial reports, developed/maintained PL/SQL packages and stored procedures, and sqlloader scripts for outside data loading.
• Did production support and analyzed and resolved various data/order issues traders face everyday. Attained bond trading and general financial knowledge within Schwab Fixed Income Group. Also wrote technical design document.

Confidential,San Francisco,CA

Sr. Database Developer (Consultant)

Skills used: PL/SQL, ORACLE9i, Unix, Korn shell scripts, Batch Processing, autosys, cvs

• Worked in My Customer View system support group, mainly served as a backend Oracle developer writing packages, stored procedures, triggers, functions, views and constraints, developed/maintained SQL reports, tables and other database objects design scripts and shell scripts, did some sqlloading also.
• Developed test plans and performed unit and system testing. Also wrote technical design document

Confidential,CA

Sr. Database Developer (Consultant)

Skills used: PL/SQL, ORACLE9i, Unix, Korn shell scripts, cvs

• Worked on a new development project: Pharmacy Replenishment System, designed database tables, developed PL/SQL procedures/packages and shell scripts, developed test plans and performed system testing.
• Wrote technical documentation for the development.

Confidential,CA

Sr. Database Engineer

Skills used: PL/SQL, ORACLE9i, Sqlplus, Sql*loader, Korn Shell Scripts, Perl, cvs, Sql Station, NT, PL/SQL Developer

• As a pure backend Oracle database developer in Engineering Content Team, major responsibilities include developing complex PL/SQL stored procedures, packages, triggers, functions, views, constraints on ORACLE9i in a large scale internet retail environment, working closely with front end Java developers, project managers, datawarehousing developers, internal data Tool developers, DBAs, Quality Assurance engineers and outside vendors such as AOL and MSN; developing scripts to load large amount of data using SQLLoader; developing Unix shell and Perl scripts and setting up production cron jobs; helping data integration engineers develop complex queries and sql reports; designing and creating database objects such as tables, indices, partitions, synonyms, grant privileges etc.; performance tuning, writing project specifications, analyzing and designing system process and testing, implementing and wrapping up project with proper documentation. Rotating on-call support for production problems. Main support and lead developer for the very important Shipping area,
• AQ, Datafeed manager (dynamic sql and file writing), book filter (context index search), catalog paths (category mapping), gifting, item cross sell, reflector url, item retirement and Replenishment Tools Suite (forecasting, suggested orders and liability inventory).

Confidential,Alameda,CA

Oracle Developer (Consultant)

Skills used: PL/SQL, ORACLE8i, Sqlplus scripts, Korn Shell Scripts, Perl, Unix on Sun Solaris, Windows NT, Developer/2000, Designer/2000, Oracle Enterprise Manager, Actuate Developer Workbench 4.0, Visio

• As a backend Oracle developer as well as an application DBA, responsible for the database development and analysis in the Monitioring area.
• Responsibilities include taking ownership of a couple of critical tables, (solving any issues related to the tables, such as tablespace, rollback segments, indexes, performance and data integrity), exporting and importing data for coalescing free space, designing, creating and populating new tables to store new field data, creating partitioned tables, analyzing data, designing and developing critical reports of great complexity for upper management, creating automated cron-jobs to generate daily and weekly reports, keeping ER diagrams up to date. Developed scripts for table creation, tablespace alteration, creation and datafile addition, indexes, synonyms and dblinks creation, triggers, stored procedures, functions, views and constraints.
• Support and answering all database related questions in the Monitoring area.

Confidential,Schaumburg, IL

Oracle Developer (Consultant)

Skills used: PL/SQL, ORACLE8.0, Oracle WebServer, Sqlplus, Sql*loader, Korn Shell Scripts, Perl, AIX Unix, Brio, Oracle Applications R11(AR/AP),

• As a backend Oracle developer and an application DBA, I am currently responsible for designing and developing the interface for Account Status between Oracle AR and the Oracle8.0 database for Confidential Online.
• Wrote the high/detail level design for Account Status, including database logical and physical design, data mapping and process flow.
• Developed the scripts for table creation, indexes, triggers, stored procedures, views and constraints. Developed the loading process loading data from flat files into Oracle database using SQL*Loader, Perl script, ftp and cron job. Developed all the sql queries for Account Status front end ASP programs.
• As an Oracle developer and an application DBA in Financial Shared Services department, major responsibilities included developing PL/SQL stored procedures, packages, triggers, views and constraints on ORACLE8.0; designing and creating tables and indexes; developing database interactive web pages using Oracle WebServer packages and HTML; developing Unix shell scripts for backend processing; developing views and queries for Brio; developing batch sqlplus reports; helping with analyzing and designing system process and system testing. Also on the side, writing new procedures for Oracle Financials (AP).