We provide IT Staff Augmentation Services!

Manufacturing Domin, Project Lead Resume

Phoenix, AZ

SUMMARY:

  • Dynamic professional with 9+ years of extensive experience as an Oracle, PL/SQL Developer with Unix Shell Script & ETL experience.
  • Expertise in Software Development Life Cycle(SDLC) of client implementations including requirements gathering, business analysis, system configuration, design, development, testing, technical documentation and support.
  • Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 12c/11g/10g/9i database.
  • Strong experience in providing technical documentation and status reports of the applications as per the requirement.
  • Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
  • Strong technical background with approximately 5 years of production support experience in SQL, PL/SQL, Oracle 9i, UNIX, and Shell Scripting.
  • Proficient in loading data from flat files into database tables using SQL*Loader scripts.
  • Involved in Oracle Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, SQLTrace and TKPROF.
  • Worked with Tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL Plus, Eclipse, Windows SQL Server & SQL Agent and Visual Studio SQL Server Integration Services (SSIS) & SQL Server Report Services (SSRS).
  • Extensive experience as a software developer for clients in the Manufacturing, Payroll, Banking and ERP.
  • Working experience in Data Extraction, Transmission and Loading (ETL).
  • Has some basic knowledge in JSP & Servlet, Java Script and JQuery.
  • Good experience in End to End to project implementation.
  • Good experience in Oracle Utilities (SQL Loader and Import / Export).
  • Good understanding of data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
  • Proven ability to work efficiently in both independent and team work environments.
  • Excellent communications and analytical skills.
  • Highly organized and efficient to prioritize and manage multiple tasks.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g,12c, MS SQL 2016, MS Access

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Java, Servlets, JSP

Tools: PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, UNIX/LINUX Utilities, Eclipse, Windows SQL Server & SQL Agent and Visual Studio SQL Server Integration Services (SSIS) & SQL Server Report Services (SSRS).

Web Technologies: HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, JavaScript, CSS, DHTML, XML, JQuery, Ajax, ASP

Operating Systems: Windows Family, MS-DOS, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Manufacturing Domin, Project Lead

Responsibilities:

  • Development, Enhancement & maintenance of Supply Chain Planning related applications.
  • Created PL/SQL Packages, Procedures and Functions that suits business requirements for loading the data into the database tables.
  • Created Dynamic SQL, Composite data types & Global Temporary Tables.
  • Worked on Materialized Views and partitioning tables for performance reasons.
  • Used SQL Loader to retrieve the data into the database tables from flat files and comma separated files (CSV).
  • Created Tables, Constraints, Views, and Indexes in coordination with the application development team.
  • Used PL/SQL Developer tool for faster application design and make the development environment flexible.
  • Developed database objects including Indexes, views, sequences, packages, triggers, functions and procedures to troubleshoot any of the database problems.
  • Expertise in solving complex queries and improves the performance of application by performance tuning.
  • Worked on requirement analysis for change requests and fixed the defects raised by the user community and other stakeholders.
  • Ensure that issues are resolved in a timely fashion as well as ensure client needs are met in an accordance with the SLA.
  • Understanding the client requirements by studying functional document.
  • Interact with clients, business analysts as well as end users to gather the requirements and help in resolving customer queries.
  • Designed and developed the logic of handling several business rules for verification and validation of data from Users.
  • Involved in clarifying the requirements to the offshore team.
  • Involved in the preparation of functional Spec, Test Case, Test data & Implementation Plan.
  • Migrating or deploying the code changes during the production release for the artifacts developed by the support team.
  • Coordinating between BAs & offshore team and ensuring quality deliverables and meeting service level goals.
  • Involvement in multiple proposals for technical solution.
  • Mentoring team on technical challenges.
  • Interacting with Clients to update the status of the System process of migration testing.
  • Identified test requirement and checked if the test cases were complete to test the business functionality.
  • Involved in code level performance tuning.
  • Interacting with clients and resolving the ITAT, UAT & BAT related issues.
  • Involved in End to End testing from all the application using New DB.
  • Involved in Production release and post implementation support.
  • Working with interface teams, DBA, UNIX and Business owners during crisis situations and bring the system back online with minimal impact.
  • Preparation of resource plan for team and sharing with clients weekly.

Environment: Oracle 12c, 11g, SQL Developer, MS Excel, UNIX Shell.

Confidential

Manufacturing Domin, Project Lead

Responsibilities:

  • Created numerous stored procedures and used procedural parameters to work with packages & exception handling.
  • Designed and developed Oracle database Tables, Views, Indexes, Sequences and Synonyms.
  • Experience in working with scalar and composite data types.
  • Extensively used PL/SQL Packages, Stored procedures, Triggers and tuned them for performance considerations
  • Used SQL Loaders to load data from flat files into database tables.
  • Dedicated to optimize the code written by various developers and worked on performance tuning with optimization techniques in PL/SQL.
  • Wrote feed handlers using Perl and DBI to update an Oracle 10g/11g database
  • Involved in performance testing of the overall application and tune the SQL Queries and database where needed using Explain plan.
  • Expertise in solving complex queries and improves the performance of application by performance tuning.
  • Understanding and Troubleshooting complex customer issues on production environment. Responsible for identifying any bugs occurring in the applications as well as fixing them.
  • All the UNIX scripts were modified to work with Cron Jobs for the Oracle Apps scheduling tool retirement.
  • Designed and developed the logic of handling several business rules for verification and validation of data from Users & various systems.
  • Interacted with all the Up-Stream & downstream systems to change their server settings to point our new DB instead of old DB.
  • Worked with the client and gathering the requirement.
  • Involved in the preparation of functional Spec, Test Case, Test data & Implementation Plan.
  • Interacted with Clients to update the status of the server migration testing.
  • Worked with juniors to reduce their backlogs.
  • Worked with the onsite people and resolving the offshore issues.
  • Worked with UNIX Admin team to get resolved the new server issues.
  • Involved in code level performance tuning.
  • Involved in comparing the access between Old Server and New Server.
  • Involved in comparing the DB Objects between Old Server DB and New Server DB.
  • Involved in development and enhancement of Production Support
  • Involved in the code reviews, bug tracking and defects solving
  • Involved in End to End testing from all the application using New DB.
  • Interacted with clients and resolving the ITAT, UAT & BAT related issues.
  • Involved in integration with multiple systems like SAP, mainframes, Oracle and Data Warehousing.
  • Involved in Pre-Production release.
  • Involved in Production release.
  • Involved in post implementation support.
  • Involved in the support, maintenance/enhancement of the application.
  • Involvement in multiple proposals for technical solutioning.
  • Mentoring team on both technical & functional challenges.
  • Reporting to the onsite coordinator about the status of the test activities on a daily basis.

Environment: Oracle 10g, 11g, SQL Loader, SQL Developer, Windows 7, UNIX Shell Scripts, Perl programming, ETL, MS Excel, VI Editor, Java, JSP, Servlets, JQuery, Ajax, HTML, JavaScript, CSS, Eclipse, Windows SQL Server & SQL Agent and Visual Studio SQL Server Integration Services (SSIS) & SQL Server Report Services (SSRS).

Confidential

Banking Domain, Senior PL/SQL Developer

Responsibilities:

  • Understanding the client requirements by studying functional document.
  • Interacted with the client and gathering the requirement.
  • Involved in clarifying the requirements to the team.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database.
  • Actively involved in system analysis and data modeling to create tables, views, indexes, synonyms, triggers, functions, procedures, packages and cursors.
  • Worked on advanced concepts of PL/SQL such as Records, Collections and Dynamic SQL.
  • Created Database triggers for quickly retrieving a row and performed validations.
  • Expertise in solving complex queries and improves the performance of application by performance tuning.
  • Expertise on performance tuning on SQL using Auto Trace, Explain Plan utilities.
  • Created various stored procedures, functions, packages and triggers using TOAD environment.
  • Interacted with team to reduce their backlogs.
  • Identified test requirement and checked if the test cases were complete to test the business functionality.
  • Involved in the preparation of functional Spec, Test Case, Test data & Implementation Plan.
  • Reported to the onsite coordinator about the status of the test activities on a daily basis.
  • Interacted with the onsite people and resolving the offshore issues.
  • Interacted with clients and resolving the UAT related issues.
  • Supported with team lead, to release Production.
  • Involved in Pre-Production release.

Environment: Oracle 11g, TOAD, UNIX Shell Scripts, Oracle PL/SQL Developer, VI editor.

Confidential

Manufacturing Domin, Software Engineer

Responsibilities:

  • Created numerous stored procedures and used procedural parameters to work with packages & exception handling.
  • Designed and Developed Oracle database Tables, Views, Indexes, Sequences and Synonyms.
  • Extensively used PL/SQL Packages, Stored procedures, Triggers and tuned them for performance considerations
  • Widely used PL/SQL tables and Bulk Collect for processing the load on tables and retrieving into oracle.
  • Worked with the client and gathering the requirement.
  • Involved in the preparation of functional Spec, Test Case, Test data & Implementation Plan.
  • Worked with the onsite people and resolving the offshore issues.
  • Involved in code level performance tuning.
  • Involved in development and enhancement of Production Support
  • Involved in the code reviews, bug tracking and defects solving
  • Interacted with clients and resolving the ITAT, UAT & BAT related issues.
  • Involved in integration with multiple systems like SAP, mainframes, Oracle and Data Warehousing.
  • Involved in Production release & post implementation support.
  • Involved in the support, maintenance/enhancement of the application.

Environment: Oracle 10g, SQL Loader, SQL Developer, Windows 7, UNIX Shell Scripts, Perl programming, ETL, MS Excel, VI Editor, Java, JSP, Servlets, Ajax, HTML, JavaScript, CSS, Eclipse.

Confidential

Oracle Developer

Responsibilities:

  • Created well defined stored procedures, functions, packages, collections, triggers & object types.
  • Improved Data optimization and manipulation of staged data using PL/SQL packages.
  • Proficient in SQL DDL, DML, DCL, TCL & SELECT statements.
  • Involved in database migration and identified various scenarios during the upgrade for oracle 10g.
  • Worked on complex SQL and PL/SQL queries. Implemented cursors, ref cursors, sub queries, correlated sub queries.
  • Developed Test Cases in Unit Testing and System Integration Testing.
  • Effectively used Oracle predefined functions such as Single row and multiple rows.
  • Designed and developed the logic of handling several business rules for verification and validation of data from various systems.
  • Involved in the support, maintenance & enhancement of the application.

Environment: Oracle Database 10g, Windows XP, TOAD, SQL Loader, JavaScript, ASP.

Hire Now