SUMMARY

• Have over 12 years of experience in IT with specialization in development, systems analysis, technical support and overall management of mission critical Oracle based applications.
• Experience and knowledge of Equity, Fixed Income, Insurance and financial data applications/domains.
• Extensively worked on PL/SQL Stored Procedures, Functions, Packages, Cursors and Dynamic PL/SQL.
• Designed and customized reports and forms as per the business requirements using Oracle Reports and Oracle Forms 6i.
• Involved in Oracle database migration from versions 9i to 11g and Oracle 11g to Oracle 12c
• Involved in the development, Enhancement and Maintenance of applications in Oracle 9i/10g/11g using SQL, PL/SQL in windows and UNIX environments.
• Extensive experience in version control tools CVS,PVCS and SVN
• Well versed in Data Warehousing Dimensional Modelling (Star and Snowflake schema) concepts.
• Possess good knowledge on Data Warehouse ETL tools Informatica and DataStage
• Design and develop ETL processes in PL/SQL to pull data from multiple sources into a single database source for end user reporting purposes
• Extensive experience in onsite offshore model, client facing and co - ordination.
• Worked on Oracle performance tuning techniques Explain Plan and Hints
• Expertise in writing Database Stored Procedures, Functions, Packages, Triggers, Cursors, Exception Handlers, Dynamic Cursor programs, Native Dynamic SQL and Data Collections using SQL & Oracle PL/SQL
• Possess good documentation skills, created documents like design document, data flow diagram, implementation/release notes and operations support document/run books.
• Managed full life cycle of a project starting with defining scope, technical design, coding, testing and production implementation.
• Worked closely with various end users for Business, Data and Technical related issues.
• Worked directly with clients to get the business requirements and scope.
• Worked directly with users during User Acceptance testing.
• Worked as a coordinator between offshore development team and client team.
• Proficient in all phases of Software Development Life Cycle, specializing in High and Low level, development, Testing (Unit, Component and System) and implementation.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Experience in Production Support on Oracle based Applications, root cause analysis and resolution of issues, bug fix and enhancement.
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.
• Possesses good communication skills with analytical and troubleshooting ability.
• Demonstrated ability to work as part of a team with aggressive time schedules.
• Extensively worked on Oracle tools SQL Developer, PL/SQL Developer, and TOAD
• Good working experience with the usage of Collections, Bulk Insert, Global temp table, Nested tables, External tables, Materialized Views, Inline Views, Analytical functions and REF cursors.
• Capable of meeting tight deadlines with excellent overall project life cycle experience and team spirit.
• Expertise in Interacting Customer, understanding needs, focusing on issues and translating them into technical actions.
• Excellent Leadership, Technical, Communication, Analytical and Problem Solving skills and ability to get on well with people including cross-cultural backgrounds.
• Cloud Computing AWS - EC2, RDS, S3, Glacier, SQS, SNS, CloudFormation, VPC, Route53, EBS, DynamoDB, Redshift, Lambda, Kinesis and EMR.

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT/XP, UNIX

Primary Skills: Oracle 11g, Oracle 12c, SQL, PL/SQL

Secondary Skills: Informatica PowerCenter 8.5, DataStage, Developer 2000 (Forms6i, Reports6i)

Development Tools: TOAD, PL/SQL Developer, SQL Developer

Functional Areas: Securities, Insurance, Finance

Version Control Tools: CVS, PVCS SVN

Defect Tracking Tools: Quality Center, Rational ClearQuest JIRA

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Developer

Responsibilities:

• Developed new database objects like procedures, functions and packages.
• Involved in development of several major enhancements.
• Performance tuning of database objects
• Accountable for one of the critical module
• Work closely with the business team to investigate issues and resolve any data discrepancies.
• Involved in Root Cause analysis with Client for on-going issues challenges and changes.
• Analyze and understand the downstream impact on other components
• Provide on call production support for GTR application.
• Write complex SQL queries with sub-queries, analytical functions, and inline views
• Identify changes, analyze the impact of change and provide detailed assessments
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Participated in User Acceptance Testing (UAT) and help them to understand the data architecture and resolve issues.
• Client meetings to ensure various timelines are met on schedule.
• Communication with client for critical issues and bug clarifications.
• Use Collections like variable arrays, PL/SQL tables
• Use Dynamic SQL to perform DDL in PL/SQL blocks and procedures
• Performance tune and optimize SQLs using explain tables, TKPROF utility, optimizer hints.
• Make sure that all offshore development follows the quality guidelines
• Conduct code reviews with offshore team to ensure development is performed in accordance with development standards
• Create PL/SQL packages, stand alone procedures, and stand alone functions.

Environment: Oracle 11g, UNIX, Java and DataStage

Confidential, Weehawken, New Jersey

Sr. Oracle Developer

Responsibilities:

• Developed several database objects for Data Extraction and Load process.
• Involved in POC to migrate data extraction and load process from Oracle to ETL Tool
• Discussed with Business Users/SME’s for requirements understanding.
• Involved in performance tuning of several database objects/packages.
• Preparation of Unit Test Cases and Unit testing of FOL reports.
• Code Drop Management - Code drop for each release for FOL, and reviewing with the team on day to day basis for any code drops being required in SCM.
• Analyze System Requirements to create a Technical Design with the assistance of other Sr. Developers/Architects/Tech. Leads.
• Code Review - Following the process of reviewing Team member’s code changes.
• Knowledge Transfer - Arranging and contributing to KT Sessions to newly joined team members, and dependent teams who are defined to work closely with FOL on a day to day basis.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document
• Optimized PL/SQL code and SQL queries (Using Explain Plan, Analyze, Indexes and Hints).
• Effort Estimation - Providing Development effort estimation to onsite coordinator.
• Testing Team Support- Reviewing test cases on release to release basis for Regression suite, providing support to testing team by reviewing issues rose during regression testing.
• Scheduling meetings with required team members at onsite regarding any clarifications required.
• Responsible for Defect Triaging and Defect management, effectively organizing defect fixes, triaging issues across to other consumer application teams.
• Reporting timely on the defect status across the group to senior management.
• Provide timely Production Support by quickly analyzing the root cause and by providing work around to resolve issues.
• Involved in development of major enhancements, fixes and support for the FOL applications.

Environment: Oracle 9i/11g, UNIX, Actuate and Java

Confidential

Sr. Oracle Developer

Responsibilities:

• Discussed with BA’s/SME’s for requirements understanding.
• Customized and Implemented OneShield HO for several states successfully.
• Customized/Created several database objects to implement HO Rating.
• Coordinated with offshore team for deliverables.
• Involved in Unit Testing and provide support during UAT.

Environment: OneShield Dragon designer, Oracle 9i and Java

Confidential

Oracle Developer

Responsibilities:

• Discussed with BA’s for requirements understanding.
• Customized/Created several database objects for CEV
• Created Unit Test cases and provided support during code deployments
• Involved in different phases of CEV
• Loaded data from flat files into Oracle database 9i

Environment: Oracle 9i, Cognos and Java