We provide IT Staff Augmentation Services!

Senior Application Developer Resume

TX

SUMMARY:

  • 13 years of extensive experience in maintaining, delivering and managing complex IT solutions using Oracle SQL, PL/SQL(8i/9i/10g/11g/12c), Unix, Oracle Forms and Reports.
  • Experience in all phases of the SDLC (Software Development Life Cycle) of waterfall and agile methodologies from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Experience in data modeling includes Conceptual,Physical, Logical and Dimension data modeling using Erwin, Visio, Toad.
  • Worked closely with domain experts, business analysts to ensure Conceptual, logical physical, Dimension database models are in compliance with enterprise standards and documented.
  • Worked on Forward and Reverse Engineering to analyze Object dependencies and prepared, executed DDL scripts for all schemas.
  • Reviewed existing Logical, Physical database design and suggested modifications to improve efficiency and performance.
  • Expertise in creating new DB Objects and maintaining existing DB objects like Tables,Views,Indexes,Types,
  • Sequences,Synonyms,Constraints, DB Links,PL/SQL procedures,functions,Packages,Triggers.
  • Extensively used constraints and database triggers(Before/After/Compound triggers) to enforce data integrity.
  • Expertise in identifying performance bottlenecks and improving the application performance dramatically by using various performance technics including views,Explain plan,TKPROF,Indexing,Hints,table Partitioning.
  • Developed and Modified complex PL/SQL packages, functions,Procedures as per client requirements to make new enhancements or to resolve problems.
  • Experience in loading high volume of data using PL/SQL packages.
  • Identified several SQL and PL/SQL bottlenecks using DBMS PROFILER, explain plan, auto trace.
  • Proficient in advance features of Oracle for PL/SQL programming like using Cursor variables, Ref. cursors, Varrays, Nested tables and Dynamic SQL.
  • Experience in writing UNIX shell scripting for sftp,batch processing and automation of various Oracle Database jobs.
  • Extensively worked on Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
  • Experience in working as Individual contributor.
  • Experience in Working on multiple concurrent projects, prioritization the tasks and met the tough project deadlines.
  • Experience in leading team and mentoring them.
  • Participated in meeting with Business users to gather the requirements
  • Involved in code reviews and suggested changes to ensure code meets client business standards.
  • Maintained Object scripts versions using version controls CVS,PVCS,Clearcase,VSS and created label to them for production deployment.
  • Involved 24/7 Production Support
  • Involved in code deployment activities and sanity check in UAT and Production environment
  • Domain experience in Financial, Supply Chain Management, Logistics, Insurance.

TECHNICAL SKILLS:

Programming Languages: Oracle(9i/10g/11g/12c) SQL, PL/SQL

DB IDE Tools: SQL Plus, Toad, PL/SQL Developer, SQL Navigator

UI: Oracle Forms6i

Reporting Tools: Oracle Reports6i

Scripting Languages: UNIX Shell Scripting

Data Modeling Tools: Erwin, Toad,Visio

Version Controls: CVS,PVCS,Clearcase,VSS

PROFESSIONAL EXPERIENCE:

Confidential, TX

Technology/Tools: Oracle (12c) SQL, PL/SQL,Toad,PL/SQL Developer,SQL Developer,Erwin

Senior Application Developer

Responsibilities:

  • Involved in Logical, Physical, Dimension data modeling design of Online Customer Service Center(OLCSC) for BOS (Back office systems).
  • Prepared DDL, DML scripts and executed them
  • Prepared functional design documents, requirement document and technical design documents .
  • Implemented ETL process using Oracle PL/SQL packages, procedures and functions to capture large millions of legacy data and loaded it into the new BOS system.
  • Extensively used analytical functions and Materialized Views for reporting purposes.
  • Implemented multi - threaded framework to schedule migration jobs with optimum threads.
  • SQL Query Optimization issues fixed using Explain Plans, Hints,Parallel process and PL/SQL performance issues fixed using Bulk collect, forall.
  • Created SQL queries to validate and reconcile data in tables.
  • Involved in DB environment set up for QA testing.
  • Created test plans and executed during development phase to ensure the code meet business requirements.
  • Interacted with testers to resolve any issues or defects during testing and verification.
  • Worked on Integration testing and User Acceptance Testing (UAT).
  • Involved in root cause analysis of defects and fixing those defects.
  • Checked-in DB Objects latest versions in ClearCase.
  • Involved in code deployment activities and sanity check in UAT and Production environment.
  • Involved in 24/7 production support

Confidential, NY

Technology/Tools: Oracle(11g) SQL, PL/SQL, Unix,SQL Navigator,Erwin

Team Lead(PL/SQL)

Responsibilities:

  • Involved in Design of ER Diagrams for new and existing change requests.
  • Prepared Technical Design documents based on functional documents provided by business team.
  • Created PL/SQL Procedures, Functions, Packages,Views, Materialized View,Triggers.
  • Improved the application performance significantly by tuning SQL Queries and PL/SQL program units .
  • Analyzed the application enhancement requests came from client and provided suggestions to the team
  • Involved in code reviews to ensure applications meet coding standards.
  • Created scripts in Unix environment for daily and monthly audit reports of the daily transactions and monetary adjustments.
  • Created Unix scripts for file transfers using sftp.
  • Worked with off-shore team for development and Testing activities.
  • Checked-in DB Objects latest versions in VSS.
  • Involved in code deployment activities and sanity check in UAT and Production environment.
  • Followed ITIL-V3 process for production support activities.
  • Single Point of Contact for all production support activities.

Confidential

Technology/Tools: Oracle(11g) SQL, PL/SQL,PL/SQL Developer,Erwin

Senior Application Developer

Responsibilities:

  • Collected requirements from business users and prepared functional and technical documents.
  • Designing and development of complex PL/SQL packages, procedures, functions and SQL scripts as per business requirements.
  • Debugging the issues and implemented bug fixes and enhancements within tight deadlines.
  • Involved in Unit Testing and Integrated Testing with multiple Components.
  • Used advance features of Oracle for PL/SQL programming like cursor variables, ref. cursors, varrays, nested tables and Dynamic SQL.
  • Checked-in DB Objects latest versions in CVS.
  • Participated in change control reviews for the code changes that go into production.
  • Involved in code deployment activities and sanity check in UAT and Production environment.
  • Provided production support and 24/7 support for resolving the critical production issues.

Confidential

Technology/Tools: Oracle(10g) SQL, PL/SQL, Toad,Viso

Senior Software Engineer

Responsibilities:

  • Involved in requirement analysis,Datamodel, preparing high level, low level technical documents.
  • Created conceptual models using Erwin and conducted several walkthrough meetings with Architects,BAs for approvals and also conducted team meetings for creating logical and physical models from the conceptual model.
  • Reverse Engineered the existing database structure to understand the existing data models so that any changes in corporate would synchronize with current model.
  • Created new DB Objects (tables,views,sequences,synonyms,dblinks etc) and PL/SQL procedures, functions, packages,triggers as per business requirements.
  • Daily status update in scrum meeting.
  • Created indexes on table columns to improve SQL query performances.
  • Identified high resource consumed long running SQL queries and re-wrote them to use less resource consumption with quick query response.
  • Created shell scripts for batch process and automated these scripts using Cron.
  • Defined indexes on various tables to improve the performance of the queries for reporting purpose.
  • Wrote complex packages for batch processes.
  • Checked-in DB Objects latest versions in CVS and labeled scripts for production deployment.
  • Involved in code deployment activities and sanity check in UAT and Production environments.

Confidential, CA

Technology/Tools: Oracle(9i) SQL, PL/SQL, Toad

Senior Software Engineer

Responsibilities:

  • Analyzed the business requirements and converted these into workflow and logical processes.
  • Created Design, Technical, Installation and Requirement specification verification documents for both new and existing projects.
  • Created PL/SQL packages,Procedures,Functions,Triggers, collections, ref-cursors to pass the data between Java application and the Oracle database.
  • Loaded data from flat files into Tables using SQL*Loader utility.
  • Performed Unit testing, integration and System testing to ensure the application meets business requirement.
  • Deployed DB objects into all environments in all phases (DEV, QA and PROD) of project
  • Checked-in DB Objects latest versions in PVCS and labeled scripts for production deployment using Quintana.

Confidential, CA

Technology/Tools: Oracle(10g) SQL, PL/SQL, Toad

Software Engineer

Responsibilities:

  • Involved in requirement analysis, preparing high level, low level technical documents.
  • Created Oracle PL/SQL Procedures, functions, packages.
  • Application tuning by analyzing table, index statistics.
  • Wrote complex packages for business logic using bulk binding and partitioning.
  • Performed Unit testing, integration and System testing to ensure the application meets business requirement.
  • Interacted with subject matter experts and business analysts to resolve any issues related to the requirement.

Confidential

Technology/Tools: Oracle(9i) SQL, PL/SQL,Forms,Reports,Toad

Software Engineer

Responsibilities:

  • Worked closely with functional team to understand business needs and documented the requirement.
  • Developed new oracle forms as per the business requirement.
  • Involved in implementation of new Oracle PL/SQL Procedures,functions,packages.
  • Developed new oracle reports and modified existing reports as per business requirement.
  • Generated reports for management to analyze the business and make decisions.
  • Wrote many adhoc SQL queries for data analysis and debugging, fixing issues.
  • Identifying and debugging issues, fixed, and implemented bug fixes and enhancements within tight deadlines
  • Checked-in DB Objects latest versions in VSS.
  • Involved in production support activities.

Hire Now