PROFESSIONAL SUMMARY:

Senior Developer with 10 years of IT experience with high level proficiency in Oracle PL/SQL, Data warehousing and Unix programming. Expertise in data modelling and performance tuning. Possesses good analytical skills, strong interpersonal skills, and ability to lead the team. Good knowledge of SDLC process and Agile methodology of application development.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Solaris

Languages: SQL, PL/SQL, Unix Shell scripting, PERL

Database: Oracle 9i, 10g, 11g, 12c, Teradata, MDM, Data Modeling for OLTP DB

Tools: TOAD, Wherescape RED, OWB, SQL Developer, Control M, Visio, Erwin

Configuration Management Tools: Rational Clear case

Domains worked: Retail with experience in CPG

Supply Chain Management: Energy

PROFESSIONAL EXPERIENCE:

Senior Oracle Developer

Confidential, Detroit, Michigan

Responsibilities:

• Developing Oracle PL/SQL packages, stored procedures, functions, triggers etc.
• Debugging Oracle PL/SQL procedures and packages within definite time limits.
• Supporting the PL/SQL production codes enabling bug fixes/checks at real time.
• Performing minor code changes and testing.
• Analyzing the user issues at DB end (packages) and fixing them
• Productionizing the packages and the respective jobs
• Direct interaction with client business to understand requirements.
• Creating and storing Unix shell scripts to invoke the packages.
• Understanding the process models and supporting them
• Supporting the production batch jobs in real time for Apparel and Equipment supply planning
• Resolving batch issues and bug fixes in real time
• Addressing user queries related to Demand reports and the Buy planning process
• Training and leading the offshore team
• Conducting Trainings and Working Session on the batch processes

Sr. Oracle developer

Confidential

Responsibilities:

• Participate in requirements analysis sessions with business analysts and business team to understand requirements and create high level and detailed design documents
• Develop SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of Oracle database.
• Develop and support Unix batch jobs used for daily and weekly batch processes
• Performance tuning of PL/SQL code and Unix batch jobs.
• Develop database ETL jobs with the data from different sources
• Lead and mentor junior developers in team
• Performing code review to ensure quality
• Help production support team on issues and resolution fixes.
• Resolving batch issues and bug fixes in real time
• Conducting trainings and workshop sessions to team

Sr Oracle Developer

Confidential, Portland, Oregon

Responsibilities:

• Conduct requirement analysis sessions with client business team to capture and clarify requirements.
• Create high level design documents for offshore development team
• Develop Oracle PL/SQL packages, stored procedures, functions, triggers etc.
• Work with Architects to develop and refine data models for efficient data storage and performance
• Conduct review sessions with technical architects and perform code reviews to ensure code quality
• Performance tuning of Oracle PL/SQL procedures and packages
• Support production codes and batch jobs enabling bug fixes/checks at real time for Apparel and equipment supply planning
• Analyze the user issues at DB end (packages) and fix them
• Productionize the packages and batch jobs
• Resolve batch jobs issues and bug fixes in real time
• Train and lead offshore development team

Sr Oracle Developer

Confidential, Seattle, WA

Responsibilities:

• Direct interaction with client business to understand and derive requirements
• Creation of high level design documents for offshore development team
• Preparation of Functional Specs and design documents to derive detailed level design
• Creation of Data Models using WHERESCAPE RED
• Build and Testing of database objects in Teradata database
• Design, develop and support applications in Teradata using utilities like BTEQ scripts, Fast Load, Multi Load and Fast Export.
• Co - ordination and Integration with reporting tools to produce sales and Demand forecast reports for Users
• Implementation and support in production environment
• Training and leading offshore team

Sr Oracle Developer

Confidential

Responsibilities:

• Single Point of Contact for this project & was involved in all stages of the project from requirement analysis to production implementation to deliver quality code with minimum defects.
• Mentored new team members into the BeSecure Credit Project
• Created generic reusable code that was used across multiple systems/data sources for tokenization process.
• Unix shell scripting was used extensively in developing the core components for the project
• Preparation of Design Documents and Technical Specifications
• Development and build of reusable code in Unix and Oracle
• Performed various levels of testing like, Integration, Performance and System Testing
• Implementation and support of fully developed code in production
• Training and preparation of user documents and batch flow diagrams

Oracle Developer

Confidential

Responsibilities:

• Analyzing requirements and deriving detailed level design
• Analyzing complex logic and preference rules for marketing preferences
• Preparation of Design documents and Functional Specifications
• Development and Testing of code in Oracle and Unix
• System Test support for batch jobs.
• Implementation and support of batch jobs in production
• Training and preparation of User documentation

Confidential

Responsibilities:

• Requirement analysis for change requests in Confidential
• Creation of design documents and technical specifications
• Development of code in Oracle and UNIX
• Training and preparation of User documentation
• Proactive monitoring of batch jobs in production and real time bug fixing
• Addressing user queries on the logic involved in the data retention
• Status reporting to customer at periodic intervals
• Training and preparation of User documentation