SUMMARY:

• Over 15 years of technical experience with strong Database Development & Analyst Skills particularly on Oracle Platform.

TECHNICAL SKILLS:

Skills: Oracle 7.x 8.x, 9.x 10.x 11.x Oracle performance tuning 7.x 8.x 9.x 10.x 1.x Oracle Rac, SQL, PLSQL, EBS, Oracle Form, Oracle Report, Oracle APEX,OBIEE, UNIX Shell scripting, Perl scripting, Python scripting, C/C++, Java/J2EE, Erwin, Informatica, XML, AIX, Sun Solaris, HPUX, Linux, Windows, SAS, MATLAB, MATHEMATICA, WEKA, R.

PROFESSIONAL EXPERIENCE:

PL/SQL Developer Analyst

Confidential

Responsibilities:

• Design, Create, Maintain, troubleshoot, optimize database objects such as packages &procedures for Medicare Data Analytic framework.
• Design &Create R code for Medicare Data Analysis using unsupervised data mining technique for finding potential faulters.
• Design & create report using Java Scripts, PL/SQL & APEX
• DBA of Oracle Development and test instances.
• Tune slow business process and SQL with Materialized View.
• Create PL/SQL procedure for Sibel Workflow data cleansing & transformation.

Confidential

PL/SQL Developer Analyst

Responsibilities:

• Design, Create, Maintain, troubleshoot, optimize database objects such as packages, procedures and triggers for order, inventory control and fulfillment system.
• Design, Create and modify ETL workflows using PL/SQL.
• Design & create report using Java Scripts, PL/SQL & APEX
• Design and Create Java server face using primeface framework.
• DBA of Oracle Development and test instances.
• Tune slow business process and SQL
• Code - review and provide technical guideline for offshore developers.

Confidential, San Diego

PL/SQL Developer Analyst

Responsibilities:

• Write or update code documentation, implementation instructions and integration tests for EBS Forms and Screens. Write technical documentation in accordance with SDLC guidelines.
• Design and Create ETL process using Informatica and PL/SQL.
• Maintain, troubleshoot, optimize existing database applications and database objects such as packages, procedures & triggers.
• Design and create report and scheduling job using PL/SQL and Java.
• Optimize the existing jobs using SQL/PLSQL tuning methodologies.
• Code-review and provide technical guideline for offshore developers.

Confidential

PL/SQL Developer Analyst

Responsibilities:

• Create PL/SQL stored procedures and db objects for data extraction, transformation and processing.
• Design and Create ETL process on PL/SQL.
• Create various sales and marketing report.
• Create and tune various DB objects such as materialized views, aggregate tables, indexes and etc for reporting.
• Create various unix& Perl scripts in server environment.
• Work with BSA of various business requirements and specifications.

Confidential

PL/SQL Developer Analyst

Responsibilities:

• Create various ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation off EBS using Informatica and PL/SQL
• Create reports/dashboards Analytic views (Pivot Tables, Charts, Column & View Selector) in EBS.
• Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.
• Create and modify various EBS Form and Report screens

Confidential, Los Angeles, CA

PL/SQL Developer Analyst

Responsibilities:

• Create various PL/SQL packages for EBS ETL processes
• Create and tune various problematic business processes and SQL applications.
• Create and tune various EBS Form and Reports.
• Work with BSA of various business requirements and specifications
• Create various Shell & Perl scripts in server environment.
• Create various PL/SQL packages for Data mining workflows.
• Create model for campaign response prediction.

Confidential, San Diego, CA

PL/SQL Developer Analyst

Responsibilities:

• Create and enhance Oracle Form/Report Applications
• Created logical and physical database model for a data mart project
• Create and tune SQL Query, create indexes and materialized views for reporting for the data mart project.
• Create and tune various slow running and problematic SQL applications
• Work with BSA to identify and fine tune business processes.
• Create various Shell & Perl scripts in server environment.

Confidential, Walnut Creek, CA

PL/SQL Developer Analyst

Responsibilities:

• Create various Database schema objects using Oracle SQL/PL-SQL in the backend game server database.
• Create Database Stored Procedures and Packages using Oracle PL/SQL in the backend game server database.
• Create various game feature using C++ and Java
• Create backend SHELL and PERL scripts
• Work with other game developers to fine tune game engine processes.

Confidential, Novato, CA

PL/SQL Developer Analyst

Responsibilities:

• Create various database EDI in PL/SQL PERL& Java.
• Create a Loan trading Java Web service EDI.
• Create physical and logical database layout design
• Create various Oracle Form/Report Screen.
• Create various Perl and Unix script in server back - front
• Tune problematic business process and SQL.

Confidential, Moorpark, CA

PL/SQL Developer Analyst

Responsibilities:

• Design/Create Data Warehouse for online merchant transaction
• Design/Create merchant transaction report using Oracle Tools
• Create ETL workflowL for processing and integrating merchant data.
• Create PL/SQL packages for data extraction, transforming, and loading of Sibel CRM application .

Confidential, Redwood Shores, CA

PL/SQL Developer Analyst

Responsibilities:

• Member of Advanced Server Technology Consulting group, Technical Lead, Technical Consultant with various important vendors, partners and high profile customers.
• Create physical and logical layout of the Databases, capacity planning, schema design and review, backup/recovery, performance monitoring and tuning in various high profile partner and customer sites.
• Create, modify, and tune application code and add new code modules using PL/SQL, Java, Java scripts, C/C++, UNIX shell scripts and Perl scripts in various high profile partner and customer sites.
• Create performance regression databases tool suites in OLTP and DW/BI environments for Oracle EBS &SAP.
• Create modify and tune various mission critical OracleEBS, in various high profile partner and customer sites.