SUMMARY:

• Excellent working and conceptual knowledge of Oracle, SQL Server, PL/SQL, TSQL, Developer forms and reports, C/C++, C#, Visual Basic, Java, UNIX Shell scripting, HTML, SAP R/3 and ABAP.
• Proficient in writing packages, stored procedures, functions, views and database triggers using SQL and PL/SQL in Oracle. Wrote UNIX Shell scripting to wrap SQL and PL/SQL code, scheduled archive process, report generation and generating interfaces files for third party systems.
• Extensive experience in performance tuning and optimization of SQL statements using explain plan, hints, SQL trace, DBMS SQLTRACE and TKProf. Worked with DBA’s to re - configure and fine tune the development and test databases, also provided guidance and inputs for configuring production database and DBA’s related activities.
• Primarily involved and responsible in data mapping, data migration and conversion utilizing Oracle and SQL Server utilities such as Oracle SQL* Loader, Export/Import, SQL DTS and Oracle Data Pump.
• Responsible for the whole software development life cycle activities of the system like debugging, testing, and deploying the applications, reviews of gap analyses, functional requirement documents, creation of technical documents, flow diagrams and related test case documents.
• Debugged, analyzed and fixed the issues found when upgrading from Oracle 9i to Oracle 10g and played a key role in production support by performing tests, trouble shooting, bug fixing and scheduling jobs to automate application execution in integrated systems environment.
• Designed, developed and enhanced developer forms and reports as per business functional requirements.
• Understanding and applying of managerial concepts and techniques in areas such as work planning, project management, delegating, coaching, mentoring and evaluating.

TECHNICAL SKILLS:

Operating systems: Windows 98/XP/NT/2000, UNIX, Linux, and Sun Solaris 7.

Programming Language: PL/SQL, Oracle SQL PLUS, COBOL, C/C++, C#, Visual Basic 6.0, JavaABAP /4 and HTML.

ERP: SAP R/3 4.6C

Databases: ORACLE 8, 8i, 9i, 10g, MS-Access, SQL Server.

SQL Utilities: SQL* Loader, TKPROF.

GUI Tool: Oracle Forms and Reports 6i.

Other Tools: MS-Office, MS-Visio, SQL Navigator, TOAD, Rational Rose, Livelink Migrate Util, Clear Case, MS-Visual Source Safe, Crystal Reports, Mercury Test Director, Autosys, UWCC and MS-Share Point Server.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Oracle PL/SQL Technical Lead

Responsibilities:

• Created functional and technical specification to pull equipment keys and attributes from different sources
• Implemented packages, procedures and batch jobs to backfill Canada AFE, AFE cost and AFE activity into operational data mart (ODM) and change data capture (CDC) system
• Extensively used dynamic SQL to build the SQL on the fly to pull well, completion and production data from different sources
• Performed testing of daily loads and batch job to ensure they were not impacted by the upgrade of Oracle RAC server hardware
• Performed research and analysis to identify bugs and propose optimal solutions to resolve those
• Participated in code reviews to ensure that the application meets requirements and is error free
• Worked with BA's on testing daily loads and batch jobs and with DBA's for code migration to implement new changes into production system
• Performed extraction of all objects from oracle database and formatting of scripts to create a baseline for version control
• Implemented multi-processing utilizing adTempus and logically dividing the data to achieve parallelism for processing large volume of data
• Fine-tuned various SQLs to improve performance on long running processes utilizing oracle hints, explain plan, AWR reports and query rewrite
• Created MV's to perform fast/complete refresh on primary key/rowid to replicate data from different sources into ODM
• Actively participated in PROCOUNT system version upgrade by modifying existing MV's, views and procedures for source changes
• Used adTempus to Automate scheduling of batch jobs
• Created rumme scripts to automate the migration activity
• Monitored and maintained batch jobs, and resolve and fix production issues

Environment: Oracle RAC 11g R2, Toad for Oracle 11, adTempus 3.2, Putty 0.63, WS FTP Pro 12.3, Microsoft Team foundation Server, Visual Source Safe

Sr. Oracle PL/SQL and RMS (Retail Management System) Developer

Responsibilities:

• Worked with various functional and technical teams to gather the requirement during initial system design/process
• Created and review high level design and data level design for store level price change management system (PCMS)
• Reverse engineer procedure, function and Pro*C programs to determine the existing functionality and determine the changes needed for store level pricing
• Created and modified forms for PCMS and Base price change to implement store level pricing
• Implemented LOV's, visual attributes, alerts, data blocks, record groups and program units on the PCMS forms
• Created, executed and reviewed the test cases to validate the existing and new functionality of the forms
• Involved in writing Autosys Jill scripts and monitoring production batch jobs

Environment: Oracle 9i, Oracle Developer Forms 10g, RETEK/Oracle RMS 7, Windows 7, Toad for Oracle 10.6.1.3, Serena PVCS Version Manager 8.4.0.0, Putty 0.60, Microsoft Visio 2007, WS FTP Pro 9.0 .

Sr. Oracle PL/SQL and RMS (Retail Management System) Developer

Responsibilities:

• Integrated Red Prairie WMS system ship confirmations with RMS using Oracle PL/SQL and RMS base API’s.
• Designed and developed custom process for store refusals and write-offs using oracle PL/SQL.
• Established effective working relationships with client to develop requirements and process designs.
• Worked with program managers to give work estimates and advised on design.
• Conducted technical design and code reviews to meet requirements, maintain standards and earlier detection of issues.
• Designed, developed, tested and deployed data conversions using PL/SQL packages, stored procedures, triggers and shell scripts.
• Translated functional requirements into technical specification.
• Implemented table driven architecture for archiving and purging of various tables for reusability, maintainability and supportability.
• Created and altered database objects such as tables, indexes, constraints, triggers, views, stored procedures and packages to meet customer requirement to new and existing solutions.
• Developed and modified UNIX scripts to wrap PL/SQL code and automate batch processing
• Created and scheduled jobs in CA workload to automated scripts.
• Designed, developed and modified Oracle forms as per functional requirements for store refusals and write-offs
• Created production support documentation for support and error recovery.

Environment: Oracle 10g, Oracle Retail Merchandising System 12, Oracle form builder 32 bit 10.1.2.0.2, Windows 7, Toad for Oracle 10.6.1.3, Winscp 5.1.2, Tortoise SVN 1.7.4, Putty 0.60, UltraEdit pro 18.20 .

Technical Lead and Sr. Oracle PL/SQL Developer/Programmer

Responsibilities:

• Collaborated with management, business and technical team for designing, developing and implementing an end to end enterprise architectural and/or infrastructure components.
• Responsible for the whole development life cycle activities of the system.
• Assisted Manager in tracking progress, prioritizing work, developing time estimates and work plans and
• Mentored less experienced team members.
• Gathered business requirements to program a system in an effort to maintain a consistent yet flexible architecture.
• Led and conducted design sessions for architecting the ODSR application.
• Developed technical system documentation
• Participated in code reviews, ensuring application meets requirements and is error free.
• Enhanced application design for reusability, maintainability and supportability.
• Planned, led and oversaw all release activities from defining design strategies, data policy, transformation rules and coding standards.
• Coordinated and facilitated discussions between Business Analyst and Technical Team to remove road-blocks where necessary.
• Implemented multi-processing utilizing Oracle scheduler and custom queuing to achieve parallelism for processing large volume of data.
• Implemented table driven architecture for flexible design and making changes on the fly
• Extensively used dynamic SQL in building ODSR engine to build the SQL on the fly and query the data.
• Performed research and analysis to identify bugs and propose optimal solutions.
• Performed day-to-day operations on Oracle database by analyzing, monitoring and fine tuning indexes, partitions, tables and SQL statements to improve the performance and enhance parallel processing.
• Responsible for migrating and releasing scripts into different environments along with maintaining and managing the version controlling in Tortoise SVN.
• Translation of business requirements into technical design specifications, creation and alteration of database objects: tables, indexes, constraints, triggers, materialized views, views, stored procedures and packages as per customer requirement to new and existing solutions.
• Involved in various activities like technical analysis, database design, performance tuning, batch monitoring, batch redesign, code standardization and documentation.

Environment: Oracle 11g, Windows XP, Toad for Oracle 10.6, F-Secure client, Tortoise SVN 1.7.1, Ascential DataStage 7.5.1, Sybase Power Designer 15, MS Visio 2007 .

Project Lead, Technical Lead, Sr. Oracle PL/SQL Developer/Programmer and Batch Coordinator

Responsibilities:

• Plan, lead and oversee all release activities from defining design strategies, data policy, transformation rules and coding standards.
• Designing data flow between applications and enable consistency across multiple projects implementations.
• Lead COE initiatives and oversee all development efforts by Technical team.
• Coordinated and facilitated BSA’s and Technical Team discussions to remove road-blocks where necessary.
• Collaborated with management, business units and technical team for gap analysis and gather business requirements to program a system in an effort to maintain a consistent yet flexible architecture.
• Performed product design, bug verification, release testing and projects support which required research and analysis.
• Primarily involved and responsible in data mapping, data migration and conversion utilizing Oracle and SQL Server utilities such as Oracle SQL* Loader, Export/Import, SQL DTS and Oracle Data Pump.
• Organized and lead various discussions with business to gather and define conversion rules.
• Design, developed and automated data conversion process by extracting, transforming and loading data into Oracle database.
• Analyzed the existing design; re-architect, reverse engineered and re-design data model from existing solution written in Oracle 7 into Oracle 10g that increased efficiency and stability to accelerated production support.
• Responsible for the whole development life cycle activities of the system like client discussions for purposed solution, user acceptance testing, preparation of technical documentation, data flow diagram, business process diagram, chain flow diagrams and flowcharts.
• Debugged, analyzed and fixed the issue found when upgrading from Oracle 9i to Oracle 10g and assisted in production support on an on-going/as-needed basis.
• Analyzed the existing Access system and re-designed it in Oracle 10g by developing data validation and load processes using PL/SQL, stored procedures, functions and triggers to enhance and improve functionality requested by business for reducing their manual processing time.
• Involved in technical analysis of specifications, identification and normalization of data, database setup, optimization and performance tuning to ensure faster response time of data.
• Analyzed, monitoring and modified day-to-day operations on Oracle and SQL Server database and client side code by fine tuning indexes, partitions, tables and SQL statements to improve the performance and enhance parallel processing.
• Responsible for migrating and releasing scripts into different environments along with maintaining and managing the version controlling in Microsoft visual source safe.
• Translation of business requirements into technical design specifications, creation and alteration of database objects: tables, indexes, constraints, triggers, materialized views, views, stored procedures and packages as per customer requirement to new and existing solutions.
• Primarily responsible to monitor and maintain batch jobs, and resolve and fix production issues.
• Tested user interface screen-by-screen, Organized and developed training materials and conducted workshops to deliver training to the business users.
• Developed and modified UNIX scripts to wrap PL/SQL code, FTP files, send emails, automate batch processing and upload data.
• Involved in various activities like technical analysis, database design, performance tuning, batch monitoring, batch redesign, code standardization and documentation.
• Created control files, external tables and used SQL* Loader to upload bulk data into Oracle tables.

Environment: Oracle 9i, 10g, SQL Server, Informatica, Teredata, Pro*C, Windows 2000/XP, SQL Navigator 5, F-Secure client 5.3 build 25, MS-Visual Source Safe, Clear Case, Migrate Util, e*Gate, SQL* Loader, UNIX, Shell Scripting, MS-Share Point Server, Livelink, Mercury Test Director and Autosys.

Forensic Examiner

Responsibilities:

• Performed forensic examination using Encase and Autopsy, investigated online for potential illegal websites. Worked on Net analysis which is a Linux based forensic tool.
• Recovered deleted data from floppy and hard drives using forensic procedures, created Encase boot disk, performed acquisition of different media and prepared legal documentation of the case for the victim to be presented in court.
• Performed experiment with different operating systems to find out how many files are created, loaded, changed and modified whenever a system is rebooted.

Web Developer

Responsibilities:

• Developed an Online Student Registration System.
• Created different screens for course search, add and drop classes, grades, academic history, and personal preferences.
• Maintained and troubleshoot Oracle database for data integrity.

Programmer/Developer

Responsibilities:

• Responsible for coding, testing and maintaining Oracle PL/SQL code. Involved in database design, performance tuning, code standardization, and day-to-day activities on Oracle database for better performance in processing time of SQL and PL/SQL statements.
• Used Crystal Reports to create various business reports.
• Developed Master/Detail forms and reports as per business specification requirement.
• Created MDI and business applications by developing parent child menus, ActiveX controls, data controls, OLE objects and data access objects.
• Queried the Oracle database through packages to fetch database records into VB applications and also enhanced the report performance by optimizing queries of the backend PL/SQL code.

Environment: Oracle 8i, Oracle Forms and Reports 6i, Access, Windows NT, Visual Basic 6, Crystal Reports.

Computer Technician

Responsibilities:

• Assembling standalone computers and installed various operating systems and application software’s.
• Upgraded old systems with newer components and operating system.
• Acquiring data from different media, data backups and run antivirus software to remove viruses.
• Troubleshoot computers for faster performance and fixed problems leading to enhance performance.