We provide IT Staff Augmentation Services!

Computer Programmer Resume

5.00/5 (Submit Your Rating)

NY

SUMMARY

  • 11 years of experience in developing, enhancing and maintaining applications in Oracle 9i/10g/11g.
  • Expertise in Performance tuning of PL/SQL code, SQL query optimization and troubleshooting Oracle applications.
  • Strong experience in RDBMS Concepts. Expertise in cron job scheduling in the UNIX environment.
  • Experience in writing UNIX shell scripts to automate repetitive database processes and import / export of data from various databases.
  • Partially worked on JAVA Script / Servlets / Struts for debugging purpose.
  • In - depth understanding of Software Development Life Cycle, Agile methodology and industry best practices.
  • Strong verbal and written communication.
  • Excellent team player and proven track record working in various team sizes performing cross-functional roles.
  • Involved in designing various Applications and Reports by interacting directly with End Users and Business Analysts.
  • Worked as a Module lead in multiple assignments and successfully tracking them to closure.
  • Strong knowledge of RDBMS concepts.
  • Worked on Oracle supplied Packages and utilities like Explain Plan and TKPROF.
  • Extensively worked on Oracle SQL query optimization, Performance Tuning, Partitioning, Cursors and Ref Cursors.
  • Experience in ETL tools like SQL* Loader.
  • Good knowledge of UNIX shell scripting and cron job scheduling.
  • Familiar with UML Diagrams including ER Diagrams, Use Case diagrams and Data Flow diagrams.
  • Extensive hands-on experience with TOAD, SQL developer and PL/SQL developer as a development tool.
  • Strong experience on VSS, SVN and Serena as a Version Control Tool.
  • Rich experience in applications development in all phases of the software development life cycle (SDLC) including design, development and integration and testing.
  • Active participation in gathering Requirements, Impact analysis, Coding, Preparing test cases, Unit testing, preparing the release documents and Deploying the application through various promotion models like QA (Quality Analysis, System Test), UAT (User Acceptance Testing) finally deploying into Production.
  • Strong experience in working in support activities; starting from responding to the tickets raised by Users, providing the temporary fix and then finding the root cause of the issue to fix the issue permanently.
  • Strong experience in monitoring the batch and checking out logs in order to troubleshoot the issues occurred in production batch using UNIX commands.
  • Batch monitoring experience using control-M scheduling tool.
  • Good domain knowledge in Banking / Finance and insurance (Life insurance and Property & Casualty Insurance) and hands on experience in supply chain management domain.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g

Programming: SQL, PL/SQL, Shell Scripting, Pro*C

Tools: /Utilities: TOAD, SQL developer, PL/SQL developer, SQL*Plus, SQL*Loader, vi editor, Putty, MAGIC

Scheduler: Control-M (BMC)

ETL Tools: SQL* Loader

Version control Tools: VSS, SVN and Serena

Bug trackers: HP Quality Center, Service-now, JIRA

Operating systems: UNIX, Windows XP/7, DOS

Front End (For code debug): JAVA Script / Servlets / Struts

PROFESSIONAL EXPERIENCE

Confidential, NY

Computer Programmer

Responsibilities:

  • Interacting with the business users to understand the functionality and their requirements.
  • Designed and developed custom packages, procedures, Triggers using PL/SQL.
  • Loaded data into Oracle using PL/SQL, Dynamic SQL UTL FILE, SQL* Loader and extensive use of External Tables
  • Extensively worked on Oracle Packages, procedures and functions using PL/SQL, SQL, SQL Navigator and PL/SQL Developer.
  • Used PIVOT, UNPIVOT, LISTAGG and many functions in Oracle 11G to transform complex source data as per mappings
  • Performed unit test on the developed code to ensure that its bug free.
  • Handled Production and UAT issues and manage the same in issue log.
  • Interacted with Business Analysts and Users in requirement gathering, built complex queries
  • Using SQL and wrote stored procedures using PL/SQL.
  • Involved in the database design for better understanding the relations, associations and dependencies within the database.
  • Designed Technical design document based on the business requirements.
  • Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
  • Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
  • Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
  • Wrote complex SQL queries to extract data from various source tables of data warehouse.
  • Created various Function Based Indexes to significantly improve performance.
  • Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
  • Experience in Partitioning Framework. Created List, Range partitions to store Transaction and Historical Data.
  • Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.
  • Extensively used Bulk Collections to insert and update huge amount of data into target databases.
  • Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and VARRAY) and Dynamic SQL.
  • Optimized SQL to improve query performance using SQL Navigator and PL/SQL Developer.
  • Understanding the requirements and preparing the business requirement and functional specification document.
  • Analyzing the reports requirement and designing the Dimensional model.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, Control-M

Confidential, Springfield, NJ

Functional Lead

Responsibilities:

  • Understanding client requirement functionally and creating technical specifications.
  • Providing estimation/time break-down to the client and assigning tasks to the team members.
  • Coordination with client, users and offshore team.
  • Coding of required enhancement or maintenance assignments using Oracle 11g objects.
  • Documenting the implemented code and keeping the document up-to-date in case of any changes requested by the business users.
  • Support AMS front-end application by resolving user queries and intraday issues.
  • Take care of entire production batch and data flow in the system.
  • Tune Oracle code to make the process’s execution faster and efficient.
  • Performing the UNIT testing and helping the QA team to generate the test cases for different possible scenarios.
  • Provide in UAT support if any clarification asked by business users.

Environment: Oracle 10g/11g, SQL, PL/SQL, UNIX

Confidential, Cincinnati, OH

Module Lead

Responsibilities:

  • Analysis of tickets raised by user based on the priorities.
  • Debugging Oracle objects as well as JAVA struts/servlet files to provide suitable resolution.
  • Creation of checklist in order to provide the permanent solution. Checklist includes the simulation steps and other information to re-generate and resolve the defect/error.
  • Work on that defect assignment with its entire SDLC to fix it permanently.
  • Tune Oracle code to make the process’s execution faster and efficient.
  • Study of requirement documents sent by client and provides the ball park estimate to the client.
  • Creation of technical specification (post analysis) and work flow diagram to explain the implementation of new functionality.
  • Provide the detailed estimate and dates of the deployment in different environments.
  • Coding of required enhancement or maintenance assignments using Oracle 11g objects.
  • Documenting the implemented code and keeping the document up-to-date in case of any changes requested by the business users.
  • Performing the UNIT testing and helping the QA team to generate the test cases for different possible scenarios.
  • Provide in UAT support if any clarification asked by business users.

Environment: Oracle 10g/11g, SQL, PL/SQL, UNIX, JAVA Script, JAVA Struts, JAVA Servlet, Pro*C

Confidential, Cincinnati, OH

Technology Analyst

Responsibilities:

  • For premium related transactions, finding out the discrepancy of amounts in interface files sent to downstream systems using SQL queries.
  • Dig out the reason of data inconsistency in the system and fix it by data patch.
  • Analysis of the source programs to find root cause of the defect which caused the discrepancy.
  • Coding the changes / enhancements to the source programs in Oracle 11g (procedures, functions, packages etc.) in order to resolve the defect in the system.
  • Batch monitoring and issue troubleshoot using UNIX commands.
  • Ensure better performance of Oracle objects using advanced performance tuning techniques of Oracle 11g.
  • Documenting the changes as well as test cases; perform unit testing for the changes done in the system.

Environment: Oracle 10g/11g, SQL, PL/SQL, UNIX, Pro*C

Confidential, Schaumburg, IL

Senior PL/SQL developer

Responsibilities:

  • Interacting with Business users in gathering requirements and prepare technical specifications to develop and handle various phases of application development.
  • Designed and developed oracle package to interact with UI.
  • Performance tuning of queries for effective retrieval of data on UI.
  • Used materialized views for efficient data storage and usage of DBMS MVIEW package.
  • Wrote SQL queries with analytical functions, aggregate functions, groups and rollups.
  • Used EXPLAIN PLAN to understand the query misfits and fine-tuned them.
  • Used bind variables for dynamic queries to reduce the repetitive parsing of queries and improve the performance.
  • Generating Dynamic SQLs to generate the reports based on inputs given by End user.
  • Deploying the code in different environments viz. DEV à QA à PROD.
  • Maintaining different versions of code in VSS and labeling them properly to mark which versions are deployed in PROD on what dates.
  • Debugging the code and fixing the issues in case of any user concerns.
  • Single point of contact and close interaction with business users.

Environment: Oracle 9i, SQL, PL/SQL, Java Scripting, UNIX, VSS, SDLC Methodology

Confidential, Bethlehem, PA

Oracle PL/SQL developer

Responsibilities:

  • Analysis of the requests and source programs and investigate the impact on existing objects.
  • Writing/Modifying technical specification and provide the best suitable time estimates.
  • Coding the changes / enhancements to the source programs / functions / procedures etc in Oracle 9i / 10g.
  • Coding of generic UNIX scripts and SQL Loader for data updation / insertion in oracle tables.
  • Coding the changes / enhancements to the source programs of Magic.
  • Analyzing the root cause of issues occurs in Production batch and providing the best permanent fix.
  • Testing and Debugging of programs.
  • Generating reports using Oracle supplied Packages like UTL FILE.
  • Documenting the changes / enhancements made as well as test cases.
  • Quality related activities like Software Configuration Management, Defect Prevention and SDLC documentation.

Environment: Oracle 9i/10g/11g RAC, SQL, PL/SQL, SQL* Loader, UNIX, Magic

We'd love your feedback!