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 domain
• 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, Word, PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Programmer Analyst

Responsibilities:

• Understand end-to-end Data flow and data integration rules for implementation
• Responsible for data analysis/reconciling gap for missing data elements between CDB and RDR
• Modified DB objects like procedure and table to make it fit as per Legal Entity Allocation process
• Created new DB objects like procedure, function and packages as per need basis
• Modified CDB Expense Code table and all areas where expense code data is displayed or entered (e.g., Statement Templates screens, Chargeback screens, Reports), as well as any internal CDB batch processes/updates
• Modified/migrated entire Merrill Lynch code from old legacy system to new e-ledger Central DB
• Analyzes source data files to layout to develop data conversion requirements
• Ensures all required data elements are being received after conversion
• Develop DB report as per client requirement and help to integrate them with UI
• Regularly working on Various Data analysis requests and producing reports
• Automated the Batch loading reports using tools like Autosys to create .jil file
• Prepares initial Data Conversion File request and schedule for receiving data files using Autosys
• Improve the process without impacting existing applications by tuning
• Have to coordinate with UI team to understand the PL/SQL requirements and develop objects
• Partners with data conversion/platform configuration team to identify specific scenarios in order to ensure quality
• Participates in internal testing and review of data/configuration
• Defines data edits that should be run to validate accuracy of data received
• Providing the production support post releases

Confidential, NJ

Lead PL/SQL Developer

Responsibilities:

• 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 and requirement
• 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
• Responsible for continuous Build and continuous install in all production and non-production environments like IT/ST/JST/STM/PM/DEV/UAT/LSP
• Build & Install on all environments and fixes any issue if arises on daily and weekly basis as per management direction
• Builds and deploys Web Applications in a clustered and load balanced N-Tier infrastructure
• Manage Release Schedule & Related Processes/Approval to ensure project team adhere

Confidential, MI

Lead PL/SQL Developer

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 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, USA

Lead PL/SQL Developer

Responsibilities:

• Understand end-to-end Data flow and data integration rules
• As an Onsite Coordinator, have worked on many FRs and passed to RDC teamas 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 (Solaris) to automate above manual process and schedule it in Crontab
• Collaborate 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

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

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

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 analyze 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