SUMMARY:

• Certified Oracle Professional with 8+ years experience in PL/SQL, Oracle Designer, Portal, Form, Report and SQL*Plus in Unix and NT environments.
• Extensive experience in analysis, design, development, and maintenance of Oracle based applications in Unix and window environments
• 8+ years of experience in creating SQL, PL/SQL Stored procedures, Functions and Packages
• Experienced in design, development, and support of Oracle Forms and Oracle Reports for various UNIX - Based applications
• Installed and configured oracle software, migrated/upgraded oracle database instances in multiple OS environments, including patch installations - Testing GOLDD Oracle database 9i migration, code change and bug fix
• Export/Import data from different database, Backup and restore database
• SQL*loader to load data from external file to oracle database
• Created and Maintained Oracle/SQL Server tables, indexes, views…database objects, security, backup and recover database
• Developed oracle Portal with HTML, JavaScript and PL/SQL in Oracle9i AS Developer Kit API.
• Good knowledge in Data Warehouse
• Application tuning, managed disk space for application, troubleshooting network issues
• Experienced writing UNIX Scripts for automating the process of data loading
• Analyzing business requirements and troubleshooting data issues
• Reliable, self-motivated, and dedicated with good analytical thinking skills

SKILLS:

Ancillary Skills: Oracle 8i/9i/10g/11g, SQL*Plus, SQL*Net, SQL server, WebDB/Portal, Designer, Form, Report, MS Excel, MS Access, MS GP, CRM, Cold Fusion, TOAD, ErWin, OEM, VB6, Veritas, SQL developer, Crystal Reports, SQL server 2005, TortoiseSVN 1.5.3, Web Sphere, ERWin, Data Warehouse

Languages: SQL, PL/SQL, T-SQL, JAVA, HTML, Cold Fusion, JavaScript, VBscript, XML, ASP, ASP.NET, C++, Visual Basic, Unix shell script, Perl, PHP, REXX, FORTRAN, JCL, Microsoft office

Operating System: MS-DOS, Windows2000, 2003, 2007, NT, Sun Solaris 8, 9, DG/UX, Legato, SuSe 9

EXPERIENCE:

Confidential, Lansing, MI

Oracle Programmer Analyst

Responsibilities:

• Developed and maintained Database objects such as tables, views, stored procedures, packages, and triggers for Oracle 11g database.
• Performed Business analysis, Designed procedures, and Developed PL/SQL programs and SQL scripts.
• Coded batch processing scripts in UNIX shell and implemented to the systems according to business requirements
• Coded Oracle Packages for front-end JAVA processes
• Coded and configured data transfer procedures with FTP and EMAIL process.
• Performed support and Maintained scripts in TortoiseSVN
• Provided problem root cause analysis developed resolution for existing application

Confidential, Southfield, MI

Oracle Specialty Developer

Responsibilities:

• Responsible for CRIS2 application data migration coding, tuning, testing, debug
• Developing and Maintaining Unix shell script for migration to support migration processes
• Extract data from other sources, Transform to staging area process and Load data to destination DB
• Loading external data with SQL*loader
• Handling Data Conversion issue
• Supporting Oracle Applications and monitoring SQL and PL/SQL based processes
• Created EPA reports with Oracle Report
• Creation Oracle Objects, Stored procedures, packages, and triggers
• Created and maintained Access reports
• Analyzing business requirements and developing solutions
• Performance tuning and troubleshooting database queries and other oracle objects.

Confidential, Ann Arbor, MI

Oracle Development DBA

Responsibilities:

• Initialize and create a new database for Royalty Payments andAccruals
• Develop SQL and PL/SQL to select appropriate data for the specificpayment cycle
• Generate royalty statement with oracle report
• Oracle/SQL Database Security monitor and maintenance and support
• Loading data from different database, Backup and restore database
• Created and maintained the Crystal Reports
• Managed and maintained Access Database
• Created Royalty payments table with Excel PivotTable for the data analysis
• Coded and maintained Excel worksheet with Excel Macros and Security
• Coded Access Forms and Reports
• Application tuning, managed disk space for application, troubleshooting network issues
• Test and modify application code at oracle 10g test environment.
• Managed and Controled SQL server securities with MS Dynamic GP and CRM.
• Responsible for the accounting/financial database support and troubleshooting.

Confidential, Ann Arbor, MI

System Analyst

Responsibilities:

• AnalyzedInventory Control, Order Processing, Purchasing and Back Order systems
• Developed new functionality with Oracle Form to support Inventory Analysis
• Created various Oracle Reports for the above applications.
• Fine-tuned the SQL queries for maximum efficiency and performance.
• Created and Maintained oracle process using REXX, JCL
• Created new customer reports with Visual Basic.
• Troubleshoot and resolve issues as they arise.

Confidential, Southfield, MI

Oracle Specialty Developer

Responsibilities:

• Gathered the requirement, got the information from PVCS, translated user requirements into data flows, detail technical specifications and database requirement.
• Use of the Design Editor to reverse engineer an existing oracle database and generate the ERD, PRD and Data modeling
• Based on the business function diagram, analyzed and created the FHD, and DFD.
• Coded, Maintained and documented Visual Basic 6 codes, and Oracle PL/SQL
• Used Confidential ’s SDM methodology and created the application documents
• Created Stored Procedures, Functions and Packages to be called by Visual Basic modules.
• Created and Maintained Visual Basic codes
• Created and maintained table’s row-level security with FGAC
• Created oracle reports for the customer requirements.
• Written SQL Loader Scripts for data extraction and transformation.
• Testing GOLDD Oracle database 9i migration, code change and bug fix. Export/Import data
• Troubleshooting for the production problem

Confidential, Troy, MI

Oracle Development DBA

Responsibilities:

• Prepared application software based on the functional and technical specifications.
• Designed User interface Units in Oracle Form.
• Created oracle reports based on the business requirements.
• Developed oracle Portal with Oracle9i AS Developer Kit API.
• Built the database objects, database triggers, packages and procedures
• Created portal entities, built portal page and components including report, form, dynamic pages
• Completed coding and testing on oracle9i portal with SQL, PL/SQL, HTML, JavaScript, implemented with SQL and running on UNIX
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Wrote Shell scripts for automating the process of data loading.
• Prepared user manual and technical support manual.
• Installed and configured oracle software, migrated/upgraded oracle database instances in multiple OS environments, including patch installations
• Performed exp/imp backup and recovery, reorganized tables, upgraded database
• Loaded data into a database with SQL*Loader, partitioned database objects
• Development of SQL statements and scripts, create trigger/stored procedures
• Wrote scripts to build my own DBA utilities to monitor database
• Performed database tuning using Explain Plan, hints, utlbstat/utlestat, STATSPACK, Toad, and Enterprise Manager.
• Developed SQL server database with T-SQL, monitored and maintained with DBCC
• Installed system, format Unix disk partitions, configured kernel, tested network interface
• Responsible for performance monitoring and tuning activities
• Migrated and maintained the metadata with oracle Designer and ERWin
• Maintained Access databases
• Developed and maintained automated maintenance shell scripts.
• Troubleshooting for the production problem