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