SUMMARY

• Software Professional with more than 9+ years of hands on experience in Oracle Database Development in medium to large scale projects using standard IT software development quality processes and best practices.
• Hands on experience of Oracle SQL, PL/SQL programming, database development, data modeling and database architecture in OLTP and OLAP systems
• Good working experience on Actimize architecture - AIS & RCM, building and maintaining customized models for Trade Compliance
• Well practiced in end to end Oracle database coding and development by creating packages, procedures, functions, triggers, views, materialized view, triggers etc.
• Worked effeciently on application tuning with use of Advance PL/SQL best coding practices, Indexes, collections, optimizer hints, partitioned tables, explain plan, materialized views, etc.
• Knowledge of various domains including Capital market, Risk & Compliance, Cards & Payments, Telecomm, Healthcare, ERP Product development along with customized application software development.
• Good experience in Oracle Forms & Reports 6i/10G for software product development
• Well familiar with object oriented programming and Core java coding
• Good experience on RDBMS concepts, flow charts, ERD’s and technical design documents
• Working experience of SDLC and Agile methods and hands on best coding practices
• Good exposure with UNIX environment, shell scripting, and Autosys schedulers.
• Have conceptual knowledge of ETL tool Informatica and have helped data warehousing teams.

TECHNICAL SKILLS

Programming Languages: PL/SQL, Java, C, C++, VB6

Databases & Development Tools: Oracle 9i,10g,11g, Oracle Forms & Reports 6i/10g, Toad, PLSQL developer,SQL developer, Autosys

Special Development tools: NICE Actimize Modeler AIS 4.9 and Risk Case Manager RCM 5.7

Version control: Tortoise SVN, CVS, VSS

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Oracle + Actimize Trade Surveillance Developer

Tools: TOAD, Actimize AIS & RCM, Tortoise SVN, UNIX

Responsibilities:

• Develop and maintain customize Actimize models for Trade Compliance and Surveillance
• Develop PL/SQL stored programs, package, stored functions/procedures, cursors
• PL/SQL Coding, Unit Testing and Code Integration and coordination between Dev and QA
• Prepare technical design documents, flow charts, ERD’s for changes & enhancements
• Perform defect analysis of the real time issues in the production environment.
• Report project stake holders about the progress; identify any risk involved and prepare mitigation plan

Confidential, Oregon, Florida

Oracle PL/SQL Database Developer

Tools: TOAD, SQL Developer, XML, Tortoise CVS, MS-Visio, UNIX

Responsibilities:

• Develop and maintain PL/SQL stored programs using package, stored functions/procedures, triggers, synonyms, sequences etc.
• SQL query optimization and implement advance PL/SQL coding like bulk sql, collections.
• Interact with Database architects, Business analysts and provide technical solutions
• Prepare technical design documents, flow charts, ERD’s for database changes & enhancements
• Review of code changes, Code integration, test procedure, test plans and other deliverables.
• Work with DBA for supporting database changes and fixes into Production database.
• Perform defect analysis of the real time issues in the production environment.
• Coordinate onsite-offshore teams about the development activities and resolve conflicts.
• Assist peers for testing / technical issues and reviews.

Confidential

Oracle Database Developer

Tools: Oracle Forms & Reports 6i / 10G, TOAD, SQL Developer, XML, Tortoise SVN, UNIX, Notepad++

Responsibilities:

• Coding, unit testing and code integration in Oracle PL/SQL programming, Forms & Reports.
• Hands on experience in oracle packages, stored Procedures, functions, triggers, views etc
• Develop Merchant management, a sub-module to manage merchant and outlets, manage different kind of transactions and routs them to responsible institution.
• Prepare technical specifications on common configurations in database tables.
• Coordinate between Dev and SQA team to accomplish timelines and build flaw less system

Confidential

Oracle Database Developer

Tools: Oracle Forms & Reports 6i / 10G, TOAD, SQL Developer, Tortoise SVN, Notepad++

Responsibilities:

• Work on various ERP modules like Payroll, Manufacturing, and Purchase etc.
• Coding Oracle PL/SQL stored procedures, functions, triggers, packages, cursors.
• Design and programming forms, reports using Oracle 6i/10G Forms/Reports
• Analyze and prepare reports for senior management based on required data.
• Experience of various master/transaction forms of Payroll module like Employee Master, Loan/AdvanceApplication, Incomes/Deductions and Salary Generation etc.
• Post production defect analysis and system support.
• Creating user manual / documentation for the Payroll & Manufacturing module of ERP Software

Confidential

Software Developer

Tools: MS-Access, Crystal reports, Oracle 9i, Windows

Responsibilities:

• Develop customized application software’s for Hospitals, Restaurants, Travel agency, etc.
• Analyze user requirements, prepare system design document and design database
• Design& develop user interface / reports using Visual Basic 6, Crystal reports.
• Perform unit testing, Code integration, deployment and provide support.
• Review of code changes, test procedure, test plans and other deliverables.
• Resolve defects / change requests and work on enhancements in existing system.