We provide IT Staff Augmentation Services!

Lead Pl/sql Developer Resume

NY

PROFESSIONAL SUMMARY:

  • Oracle Certified Professional (OCP) having 11 years of experience on medium to large - scale global projects as a Lead/Sr. PL/SQL Developer in the financial and Telecom sector
  • Core work experience in programming on Oracle SQL, PL/SQL, Unix Shell Scripting, Scheduling, Monitoring, Batch Processing, Release Management
  • Extensive Experience in Leading a team of Onshore-Offshore Model as an Onsite Coordinator
  • Proficient in analyzing and translating business requirements to functional or technical requirements into solution blueprint
  • To identify project requirements and develop/deliver high-quality solutions to clients in response to varying business needs under Agile methodology
  • Proficient in entire SDLC from Business Requirement, FRs, SRs, POC, ADD, Development to implementation with emphasis on programming in Oracle SQL, PL/SQL for schema, table and other DB objects creations like Package, Procedure, Functions, Trigger, Cursor etc.
  • Expertise in using Oracle 9i/10g/11g enterprise edition
  • Extensive experience in Oracle PL/SQL and Shell Scripting as a Lead Developer
  • Proficient in related tools like Toad, PL/SQL Developer
  • Proficient in query optimization and troubleshooting
  • Experienced in basic BO server administration on Windows/Unix platform e.g. user management, access management, release management etc.
  • Implementing ETL codes and process flows with various PL/SQL blocks and shell scripts to trigger ETL automatically and scheduling in Crotab, Autosys
  • Well versed in Unix Shell scripting
  • Experience working in Agile environment
  • Extensive experience of working closely with Clients from various client locations of USA and Liaison between RDC offshore team and onsite team
  • Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and written communication skills
  • Measuring various SLA (Service Level Agreement) metrics for Environment and Configuration team and taking corrective action plan during LAM (Look Ahead Meetings)
  • Extensive experience with analysis, design, development, customizations, Build, Deployment and implementation of software applications using different methodologies
  • Effective in meeting with BU, stakeholders and subject matter experts for eliciting needs and translating those needs into concise functional and non-functional requirements
  • Strong database skills, Object Oriented Programming and development experiences
  • Coordinate between development team and testing teams to ensure quality gates and right method followed by project team

TECHNICAL SKILLS:

Operating Systems: Windows Vista/XP/2000, Sun Solaris

Scripting Languages: SQL, PL/SQL, Unix Shell Scripting

Tools: TOAD, Oracle Sql developer, Visio, PuTTy, Net Term Tivoli Maestro, CONMAN, COMPOSER 7.0, CM Synergy, Change Synergy, SM7, RTC3.0, RSA9.0, SVN, SCME

Database: Oracle 11g-10g-9i

Packages: MS Office- Excel, Powerpoint

PROFESSIONAL EXPERIENCE:

Confidential, NY

Lead PL/SQL Developer

Roles & Responsibilities:

  • Enables firm to effectively manage both straight-through and complex trade transactions
  • Understand Business Requirement and prepare FRs, SRs, POC, ADD (HLD & LLD), Development to implementation with emphasis on programming in Oracle SQL, PL/SQL and Unix Shell Scripting
  • Used to create schema, table and other DB objects like Package, Procedure, Functions, Trigger, Cursor etc. based on its suitability
  • Have to understand End-to-end Data flow and data integration rules to implement logic
  • Daily activities include, PL/SQL anonymous blocks & Objects creation, integrating them with shell script, Generating Reports using SQL queries
  • Have to build the Package to implement business logic, the entire transformation and load is happening through PL/SQL packages as per inbound feed receives
  • Have to coordinate with Java team to understand the PL/SQL requirements
  • Writing various packages for each activity of DML (Insert/Update/Delete/Search etc), to be performed from Front-end
  • Write code to maintain Data integration and dependency rules in above cases e.g.: If user delete some information from a main table, corresponding all depended table entries should be deleted through program
  • Understand various search criteria available on the front end and coming up with very highly tuned SQL queries and performance improvement
  • Creating highly tuned, complicated SQL queries for various reporting requirements which runs daily, weekly, monthly, Quarterly, semi-annually and annually
  • Have designed upgrade/modifications of existing schemas as per business requirements
  • Coordinate between development team and testing teams to ensure quality gates and right method followed
  • Reviewing Low level design, code, unit test documents produced by team members
  • Responsible for identifying the need for different data setup required for the testing phase and set up the same by working closely with DBA team
  • In addition to these, creating various batch Jobs to automate report generation and transferring flat files (Reports) to various other locations through FTP/ SFTP /SCP etc.
  • Scheduling above mentioned jobs in Unix crontab Scheduler and monitoring periodically

Confidential, MI

Lead PL/SQL Developer

Roles & Responsibilities:

  • Worked on entire SDLC from Business Requirement, FRs, SRs, POC, ADD, Development to implementation with emphasis on programming in Oracle SQL, PL/SQL for schema, table and other DB objects creations like Package, Procedure, Functions, Trigger, Cursor etc.
  • Worked on Hyperion DRM (Data Relationship Management) to develop the programs
  • Perform impact analysis, configuration design and development of business flow change requests, addition of new business processes based on client requirements
  • Propose implementation strategies for new business requirements
  • Understand changes to business functionality and developing test plans
  • Write change control plans to implement application changes by creating procedure, functions and packages
  • Coordinate with infrastructure support teams during Staging and Production deployment of software
  • Maintain the compliant state of the applications by following approved Standard Operation Procedures (SOP)
  • Analyze reported defects and fix system bugs using Shell scripting and TOAD
  • Provide training and support to team members in understanding the critical business processes
  • Review and ensure that deliverables are prepared to satisfy the project requirements and ensure that deliverables satisfy the project cost and schedule
  • Maintain the Oracle Database and MDM application server's objects
  • Extended support and guidance to client for publishing submission using TFS and nexus
  • Good understanding of Batch loading processes and tools like Autosys to create .jil file
  • Improve the process without impacting existing applications by tuning
  • Trouble shoots application problems and provides temporary as well as permanent solution to mitigate the risks and take corrective action
  • Work on onsite - offshore model and coordinate among team members

Confidential

Lead PL/SQL Developer

Roles & Responsibilities:

  • Understanding end-to-end Data flow and data integration rules
  • As an Onsite Coordinator, have worked on many FRs and passed to RDC team as per business requirement
  • Designed upgrade/modifications of existing schemas as per Business requirement
  • Had to capture requirements from Business and provide solutions
  • Providing High level Design and getting it signed off with client
  • Had to coordinate requirement walkthrough for offshore development & Testing team
  • Had to review Low level design, code, unit test documents produced by team members
  • As a Sr. PL/SQL developer, automated COS (Commissions) payroll process and cloning process effectively so client provided accolade for this effort as an individual contributor
  • Used Unix shell script to automate above manual process and schedule it in Crontab in Unix (Solaris)
  • Collaborating and leading the deliveries within Onshore-Offshore model
  • Involved in monitoring the performance in production and accordingly proposing upgrades/modifies in existing design like adding/deleting indexes in tables, partitioning tables, replacing traditional extract logic with implementation of materialized views etc.
  • Regularly working on Various Data analysis requests and producing reports
  • Providing various weekly and monthly reports - creating PL/SQl blocks for each report to execute periodically
  • Proficient in using TOAD, Oracle SQL Developer, MS Visio
  • As a Lead PL/SQL developer, involved in all phases of SDLC to ensure requirement
  • Understand the End-to-end Architecture of existing Business and each application and data correlation across systems
  • Identifying relevant Databases and Entities and providing the end-to-end solution
  • Had to coordinate design Walkthroughs for offshore development & Testing team
  • Had to review Low level design, code, unit test documents produced by team members
  • Used Visio, Oracle SQL Developer and TOAD
  • Monitored Production Environment and maintaining Application Health throughout 24*7
  • Staging the code before it goes to production deployment

Confidential

Sr. PL/SQL Developer

Roles & Responsibilities:

  • Monitored GRS US and Canada batch schedules having job runs Daily/ Weekly/ Monthly/ Quarterly/ Semi-annually/ Recurring
  • Investigated and fixed problems related to batches/services failure
  • To find out the reason of abend, do analysis and further step had taken for resolution including database related issues
  • Modification in database object using TOAD, PL/SQL Developer, Oracle SQL Develop
  • Converted oracle report into SQL* Report
  • Produced corresponding low level design which included design of Entities, attributes, constraints, Primary keys, Foreign Keys, Index etc.
  • Developed various anonymous PL/SQL blocks and procedure, functions to be called in process flow
  • Global Royalty business logic understanding for US and Canada and providing end to end business rule implementation
  • Created UNIX scripts to automatically schedule the job in Maestro job scheduler
  • Set dependency on job by using conman
  • Developed various PL/SQL blocks to accommodate changes in existing business logic

Confidential

PL/SQL Developer

Roles & Responsibilities:

  • Involved in the Creation and modification of Procedure, Function, Trigger, Cursor as per business need
  • Created and maintained connections to all the Source Databases
  • Interacted with system specialists to analyze the requirement changes and implemented the solution
  • Basic User Administration like User creation, Group Creation, granting proper access etc.
  • Continuous drive for improved customer experience
  • Captured requirements from client and communicating same to team
  • Used Toad and Visio to accomplish above assignments

Confidential

PL/SQL Developer

Roles & Responsibilities:

  • Developed data-entry forms for master tables
  • Module level testing and writing PL/SQL code for triggers and stored procedures and Report generation at various stages are also a part of my responsibility
  • Table created with appropriate constraints/validation specified
  • Involved in the designing different forms
  • Generated report at various stages with different styles for best presentation
  • Established standard SQL queries for various Data analysis rules across DBs
  • Creating PL/SQL blocks to update data across systems
  • Interacted with system specialists to analyse the root-cause for mismatched data and deriving solution for brining those in sync
  • Provided daily/weekly reports to client to highlight stock gaps etc.
  • Capturing requirements from client and documenting same for the team

Hire Now