SUMMARY

• Over 14 years of extensive experience in design, development, testing and implementation of application software and control systems
• Experience in development of Oracle database applications on diverse Unix Shell Scripting and Windows platforms
• Extensive experience in Oracle Development in table design, writing stored procedure, Database Triggers, Functions and PL/SQL packages. Strong knowledge in Oracle Cursor management and Exception Handling.
• Extensive experience in Oracle Technologies in back - end oracle database design, development, testing, performance tuning, production migration and production support
• Used SQL*Loader to load into Oracle database tables
• Experience on Data Modeling (Star Schema, Snow Flake Schema) at Logical, & Physical levels using Erwin.
• Extensively involved in designing, capturing updating the module using Oracle designer and developing various web-based reports in HTML, JavaScript and Oracle (PL/SQL Procedures with HTTP utility)
• Strong working knowledge of developing complex reports and graphics using Crystal Reports 9.
• Developed and maintained various applications using JSP and Oracle technologies on UNIX platform
• Extensive experiences in shell scripting particularly with Shell Scripting including scheduling CRON jobs
• Ensure timely proactive identification of performance issues, escalating issues as warranted
• Participate in the review of failures and provide feedback to prevent future occurrences.
• Ability to work under pressure and in high stress situation with a calm demeanor.
• Excellent team work
• Strong analytical and programming skills with good communication and interpersonal skills.
• Lead and participated in peer reviews and walk-through of the BRD (Business Requirements Document) and FRD (Functional Requirements Document)
• Experience with developing and implementing efficient development processes and best practices in both waterfall and agile scrum development methodologies.
• Design and implemented the backend layer using Hibernate.

TECHNICAL SKILLS

Languages: JAVA, C, Pro*C, FORTRAN, SQL, PL/SQL, HTML, XML, JavaScript and UNIX Shell Scripting

Database: Oracle 12c/11g/10g (RAC)/9i, 8.x, 7.x and MS Access 2000

Defect tracking tools: Daisy, JIRA 2.1/6.2, Bugzilla, BMC Remedy, Agile Scrum Rally Software

Other Tools: Developer/2000 (Oracle Forms 6.0, Reports 6.0), Crystal Reports 9.0/8.0/7.0/ 6.0 , Designer/2000, Visual Basic 6.0/5.0, PL/SQL Web Toolkit, Toad 9.2/8.5, Quarryman4.2, Boomi 3.1, Erwin 3.5, Informatica 8.1/5.1, Business Objects 5.1, ASG-Zena 2.4,Nimbus 3.7, Tortoise SVN 1.6, WinSCP 4.1

Operating Systems: SCO UNIX, SUN Solaris, Windows NT, Windows 98/95/2000/XP, Windows 3.11,MS-DOS

Hardware: IBM PC compatibles, HCL Magnum, Compaq Presario, and Sun Sparc

Networking: Novell NetWare and Windows NT.

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

Tech Lead/Sr Oracle PL/SQL Developer

Responsibilities:

• Design and propose additions to data model.
• Best practice champion for version control, commenting, documentation and readable code.
• Involved in Solution design, Technical Documentation, Database Development, Unit test, Integration Test and writing Test plan.
• Interacted with Business and the End users for the Functional requirements and Design specifications
• Database and Application Performance Tuning
• Prepare Test strategy and Test Plan for each Release cycle.
• Enhance the existing background check processes (for firearms permits, ownership, etc) to perform a single background check on an individual for each transaction; regardless of how many firearms are included in the transaction
• Enhance the existing CFIS Oracle 11g database with new/updated fields, procedures, packages, views, etc. to satisfy legislatively mandated functionality and changes to business processes
• Improve users’ ability to track, schedule, and throttle the number of transactions processed. improving role based access and access to historical information
• CFIG Application Data Dictionary
• Fixed JIRA bugs
• Enhance the existing CURES Oracle 12c database with procedures, packages, views, etc. to satisfy legislatively mandated functionality and changes to business processes
• Experience with source code maintenance systems, such as SVN Subversion
• Migrate Consolidated Firearms Information System (CFIS) database from Oracle 11g database to Oracle 12c
• Documented CFIG and CFIS system entity relationship diagrams, and other system related documentation.
• Developed and executed CFIG and CFIS reusable unit and integration test scripts to ensure critical functionality through the Software Development Life Cycle (SDLC)
• Involved in comparing, clearing unused database objects like tables, functions etc..
• Migrated all the environments (Disposition, Batch process, Folder control, Subsequent Arrest, Hybrid process and Xcount System)
• Worked with Java developers to migrate application server from Jetty to JBoss EAP 6.3 version.
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Involved in comparing, cleaning unused database objects like tables, procedures etc. from Oracle 11g to 12c migration.
• Monitored the flow starting from parser to archived of the files.
• Mentor State Staff on all enhancement and development work.
• Handled the responsibilities of managing technical risks throughout the project.
• Responsible for updating project manager regarding status of development efforts.

Environment: Oracle 12c/11g, SQL/PLSQL, Toad 11.0, Tortoise SVN 1.6, JIRA 6.2, FileZilla 3.1, Enterprise Architect 12.0, PUTTY, PL/SQL Developer, Notepad ++, UNIX and Windows

Confidential, Sacramento, CA

Tech Lead - Senior Software Consultant

Responsibilities:

• Assist the organization in performing data compiling, mining and analysis required to evaluate the given data
• Prepare analysis reports and be responsible to answer any queries, complaints or suggestion in this regard
• ETL Implementation with Oracle PL/SQL and SQL including external tables, materialized views, scheduler (jobs, chains, programs)
• Implementation of ETL to create extracts for Federal compliance.
• Design and propose additions to data model.
• Best practice champion for version control, commenting, documentation and readable code.
• Worked with appropriate development and technical support teams to triage, assess and solution.
• Involved in Solution design, Technical Documentation, Database Development, Unit test, Integration Test and writing Test plan.
• Interacted with Business and the End users for the Functional requirements and Design specifications
• Custom ETL Development (Test Data, Legacy Data Sources) Using Shell and PL/SQL
• Have converted old data from Flat files to Oracle database Using External Tables.
• Database and Application Performance Tuning
• Proper Log files and log tables where created to monitor the whole ETL process
• Prepare Test strategy and Test Plan for each Release cycle.
• Developed Shell Scripts for process automation
• Enter and maintain defect information in Defect Tracking System in Rally
• Experience with source code maintenance systems, such as SVN Subversion
• Coordinate with offshore team on daily operations.

Environment: Oracle Enterprise Manager Cloud Control 12c (OEM), Oracle 11g, SQL, SQL/PLSQL, External Tables, Toad 11.0, HTML, XML, Tortoise SVN 1.6, Unix and Windows, Webex, Agile Scrum Rally, File Zilla 3.7, WinSCP 4.1, Microsoft Office Communicator 2007 R2, Truven Operations workbench 2.6

Confidential, Milpitas, CA

Senior Software Engineer

Responsibilities:

• Knowledge of project management to plan and coordinate resources, time and staff
• Worked with various functional experts to implement their functional knowledge into working procedures.
• Worked with appropriate development and technical support teams to triage, assess and solution.
• Involved in Solution design, Technical Documentation, Database Development, Unit test, Integration Test and writing Test plan.
• Responsible for data analysis, engineering, programming, implementation and Support for the product.
• Worked closely with different functional team including Development, QA and Business.
• Interacted with Business and the End users for the Functional requirements and Design specifications
• Hands on experience in using the Erwin tool to create design artifacts like ER diagrams etc.
• Custom ETL Development (Test Data, Legacy Data Sources) Using Shell and PL/SQL
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility
• Have converted old data from Flat files to Oracle database Using SQL * Loader
• Database and Application Performance Tuning
• XML patient Data Transformation to measure determinants using PL/SQL
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate
• Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability
• Reverse engineering ad redesign of RRM products
• Proper Log files and log tables where created to monitor the whole ETL process
• Prepare Test strategy and Test Plan for each Release cycle.
• Developed Shell Scripts for process automation
• Provided support and data analysis for the System Acceptance Testing of the new release of the Confidential application.
• Enter and maintain defect information in Defect Tracking System, JIRA, BMC Remedy, Bugzilla, Rally
• Defect tracking trouble shooting and resolution of Vendor Applications issues
• Experience with source code maintenance systems, such as SVN Subversion
• Coordinate with offshore teams on projects
• Working in Agile environment. Attending daily standup meetings, sprint plan meetings to review the user stories.
• Designed and developed validation framework for validating supply and demand side entities using hibernate validation.
• Well versed in database applications using Oracle and MYSQL
• Hands on experience in MySQL and MS SQL Server databases.
• Support for MySQL databases in production and staging environments.
• Design and implemented the backend layer using Hibernate.

Environment: Oracle 11g/10g (RAC), SQL, SQL/PLSQL, SQL*Loader, TOAD 9.7, MySQL, Java, Spring, Hibernate, HTML,XML, Tortoise SVN 1.6, WinSCP 4.1, Informatica Power Center8.1,AraxisMerge 6.5,BMC Remedy Action System 7.5, Sales force, Web logic 10, JIRA, Unix and Windows 2003 server, Bugzilla, Agile Scrum Rally

Confidential, San Francisco, CA

Senior Software Consultant

Responsibilities:

• Prepared Technical documents for all the modules
• Prepared and executed Game Plan for the conversion
• Actively participated in the meeting with management and the team members.
• Actively involved in ongoing day to day production support activities / issues and providing problem resolving solutions to tickets.
• Developed SQL scripts as well shell scripts to handle exceptions while conversion
• Extensively performed the tuning of transactional SQL and PL/SQL by analyzing Explain Plans and trace outputs and experimenting with various query access paths
• All conversion related scripts (source scripts) checked in ClearCase

Environment: Oracle 10g, SQL, SQL/PLSQL, SQL*Loader, Toad 9.6, Unix, ClearCase 7.1, Secure CRT 5.5, Secure FX 2.2, Eclipse 3.4, Autosys and Windows NT

Confidential, Palm Desert, CA

Senior Software Engineer

Responsibilities:

• Prepared Technical documents for all the modules developed by our team
• Actively participated in the meeting with management and the team members.
• Actively involved in ongoing day to day production support activities / issues and providing problem resolving solutions to tickets.
• Imported data from various environment using SQL*Loader
• Developed ETL mapping and created SQL scripts for incremental data load.
• Worked on Full Life Cycle of software development (SDLC).
• Used TOAD for pre-development activities including code design and validation
• Extensively used SQL, PL/SQL in writing database packages and procedures, functions and triggers.

Environment: Oracle 11g/10g (RAC), SQL, SQL/PLSQL, SQL*Loader, TOAD 9.6, HTML, Tortoise, SVN 1.6, WinSCP 4.1, Informatica Power Center 8.1, Unix and Windows NT

Confidential, Sacramento, CA

Senior Oracle Developer

Responsibilities:

• Prepared Technical documents for all the modules developed by our team
• Actively participated in the meeting with management and the team members.
• Preparing flowchart of various business processes and participated in various knowledge transfer sessions with team members
• Documented all existing process/business flow information with a vision to have common customer data for the company.
• Involved in the Oracle 10g upgrade process by executing effective and efficient work plans and test cases.
• Actively involved in ongoing day to day production support activities / issues and providing problem resolving solutions to tickets.
• Involved in data Quality Assurance, created validation routines, unit test cases and test plan
• Conducted and finalized design document walk trough’s with the end users. Prepared Technical Specifications for all the utilities, as per the company’s standards.
• Extensively used Erwin to design Logical/Physical data modules, relational database design, Forward/Reverse engineering.
• Providing periodic batch support by scheduling and monitoring batch jobs using Zena
• Creating RELAY problem tickets and working with DBA team towards resolution of various production issues
• Worked with several different IT application teams as well as business unit to document use of data, definition of data and analytical needs.
• Created Materialized views to analyze complex queries.
• Used Refcursor, implicit/explicit cursor in PL/.SQL module extensively
• Designed the table sizing and partitioning parameters.
• Used Exception Handling extensively for the ease of debugging and displaying the error message in the application
• Imported data from various environment using SQL*Loader
• Developed ETL mapping and created SQL scripts for incremental data load.
• Used package like UTL FILE for read and write to operating system files, delete or rename a file
• Developed a DCS (Decision Support System) application that generates the reports using shell scripts that were scheduled to run periodically and results were emailed to business users.
• Reduced the elapsed time of ETL jobs using a combination of different approaches such as parallel query, direct path loads and reduced redo generation.
• Extensively performed the tuning of transactional SQL and PL/SQL by analyzing Explain Plans and trace outputs and experimenting with various query access paths.
• Tested various indexing mechanism such as, BTREE, bitmap and function-based and also various index scans.
• Fixed application queries to reduce hard parses thereby maximizing the use of shared pool.
• Used advanced PL/SQL concepts like BULK COLLECT, PL/SQL tables and Dynamic SQL for DML operations for better performance
• Developed/Customized reports based on users requirements.

Environment: Oracle 10g (RAC)/9i, SQL, SQL/PLSQL, SQL*Loader, TOAD 8.5/9.2, HTML, Boomi 3.1, ASG-Zena 2.4, Nimbus 3.7, Daisy, JIRA 2.1, Tortoise SVN 1.6, WinSCP 4.1, Quarryman 4.2, Unix and Windows NT

Confidential, Memphis, TN

Senior Oracle Consultant

Responsibilities:

• Worked on Full Life Cycle of software development (SDLC).
• Monitored and optimized database performance.
• Designed the database entities and relationships using Erwin.
• Used TOAD for pre-development activities including code design and validation
• Developed complex Reports using Crystal Reports and SQL.
• Created sequences for automatic generation of voucher numbers.
• Created Views to hide Tables and Queries.
• Solved performance tuning and maintenance issues
• Extensively used SQL Queries (Sub queries, correlated sub queries and join conditions)
• Extensively used SQL, PL/SQL in writing database packages and procedures, functions and triggers.

Environment: Oracle 9i, SQL, SQL/PLSQL, TOAD 7.4, Windows NT/2000, Crystal Reports 8.5

Confidential, Washington DC

Senior Oracle Developer

Responsibilities:

• Loading data from flat files into database tables using SQL*Loader
• Used SQL*PLUS to update and maintain data integrity
• Used TOAD to execute queries, create and modify database objects and develop application code
• Developed ER diagrams and data flow diagrams.
• Wrote various Stored Procedures, Functions, Triggers, Packages, Cursors, Ref Cursors, Bulk Collect, Collections in PL/SQL.
• Created Unix shell scripts to streamline the build process
• Performance tuning by analyzing queries and tuning.
• Scheduled jobs using CRON
• Automation of process for data maintenance and e-mail notification using Unix Korn Shell
• Version control PCVS check-in/check-out
• Transfer of data using Oracle’s export/import utilities and database links.
• Involved in the creation of server side objects such as tables, indexes and sequences
• Used database triggers, stored procedures, functions and packages in PL/SQL
• Designed and developed Operation Set up system using Oracle (PL/SQL)
• Created calibration files for QA using Oracle and shell scripts and report generation using HTTP utility and shell scripts
• Operation set up and production support of all DADS operations using Oracle (SQL, PL/SQL Procedures)
• Developed MTAIP Southbound QA Interactive Set up System using Shell scripts and Oracle PL/SQL
• Designed and developed DADS Feature Network control system using Oracle PL/SQL
• Developed various web-based reports in HTML and Oracle (PL/SQL Procedures with HTTP utility)
• Designed and developed DIE/DIRT System using Unix Korn Shell scripts and Oracle PL/SQL
• Testing various applications from Unit level to Integration testing using tools and scripts

Environment: Oracle 9i, SQL, SQL/PLSQL, TOAD, Erwin 3.5, Informatica 5.1, Business Objects 5.1, HTML, JavaScript, SQL*Loader, Sun Solaris and Windows NT