SUMMARY

• A software professional having rich 8 years of experience in Oracle PL - SQL, Axiom and Ab-Initio Development.
• Strong Skills with Oracle SQL- PL/SQL Development.
• Experience in creating Stored Procedures, Functions, Triggers, PL/SQL Packages and other DB objects.
• Knowledge in Oracle Cursor Management, Exception Handling and Performance Optimisation.
• Experienced in Database modelling, Data warehouse concepts, Converting Relational DB to a DWH.
• Experienced in Axiom Development. Worked on various components like Data Source, Data Models, Aggregation, Portfolio, Mapped Reports.
• Experienced in Ab Initio development. Developed and worked on various Ab Initio components like Normalize, Gather, Merge, Join with DB, Transform etc.
• Certified and have knowledge of IBM IGC Level 1 Data Governance, Business Catalog and Data Lineage tool.
• Certified in Collibra Data Governance tool: Collibra Expert Level 1 Certification.
• Working Knowledge of UNIX and Job Scheduling tools like Control-M and Autosys.
• Good working knowledge of AGILE Methodology of Software Development.
• Working knowledge of Code versioning tools like Tortoise SVN.
• Worked on Data Quality tools like HP ALM (Quality Center) and Code migration tools like Service Now - IRMA and HP PPM.
• Experience and knowledge of Banking & Finance domain.
• Experienced in requirement analysis, coding, deploying and validating various process of deployment.
• Excellent team player and proven track record working in various team sizes performing cross-functional roles.
• Worked as Team lead, and led a team in multiple assignments and successfully deployed clients before given deadline.
• Experience in giving knowledge transfer to team members.
• Proven skills in managing team members to work in sync with the corporate set parameters & motivating them for achieving business and individual goals.
• Certified in IBM DB2 Family Fundamentals.

TECHNICAL SKILLS

Languages: SQL, PL/SQL

Databases: Oracle 11g, DB2

Operating Systems: Windows XP/2007/10, UNIX

Applications: SQL Developer, PL-SQL Developer, SQL* Plus, Toad

Data Governance Tools: Collibra, IBM IGC, Confidential PLM (Post Settlement Life Cycle Management)

Other Tools: Axiom, Ab Initio

Scheduler: Control-M, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Morrisville, North Carolina

Oracle PL-SQL Lead

Responsibilities:

• Worked on different Oracle objects like Packages, Procedures, Functions, Cursors, Dynamic Queries, Exception Handling, Performance Optimisation etc.
• Worked as Team Lead and led the team in various successful module deliveries.
• Was responsible for Requirement Gathering, Analysing the requirements, Preparation of High and Low Level Technical Documents.
• Was involved in each phase of Product Development right from Coding, Unit Testing, Integration Testing, Quality Assurance Support and User Testing Support.
• Was responsible for migration of code across the environments and Production deployment and support as well.
• Worked on versioning tools like SVN, Quality Control tools like HP Quality Center (HP ALM), Code deployment tools like IRMA, HPPPM.
• Adopted Agile way of delivering the product in tight timelines and ever changing requirements.
• Received various recognitions from client like APAC IT Star Award from Client Global Head, Instant Karma Award, Best People Leadership Award from the Client and Wipro.

Confidential

AXIOM Developer

Responsibilities:

• Worked on different modules of the project like FinRep, CoRep, Asset Encumbrance, Funding Plan etc.
• Responsible for Requirements Gathering from Clients; Analysing their challenges and propose and develop a solution that fit in their needs.
• Developed different projects using the Axiom components like Data Source, Data Models, Aggregations, Portfolio, Hypercubes, Mapped Reports, Free Form Reports etc.
• Assisted Business Users in various successful submissions of financial reports to EBA.
• Worked on UNIX and job scheduling tool like Autosys.
• Worked extensively on Oracle PL-SQL for analysing data, creating different DB objects.
• Performed Unit Testing of different project modules.

Confidential

Ab-Initio Developer, Oracle SQL-PL/SQL Developer

Responsibilities:

• Responsible for Requirements Gathering from Client, Analysing and Proposing the desired solution which satisfy their requirements.
• Proposing the design of new Data Model in DWH out of a Relational DB Model which would store historical data as well.
• Developed Ab Initio ETL project using different ab initio components like Transform, Gather, Merge, Join with DB, Normalize, Input File, Output File etc.
• Developing Oracle PL/SQL stored procedures, Functions and SQL scripts to perform the Quality check and Purity of data in the Data warehouse.
• Developed different modules independently and delivered the project on time with nearly zero defects.
• Performed Unit Testing for different modules and written various test cases.
• Prepared High Level and Low Level Design Documents for the project.
• Worked as Module Lead and led a team of 5-6 members.
• Trained junior resources on project flow, various modules of project.
• Trained team members on various topics of SQL, PL/SQL.

Confidential

Oracle SQL-PL/SQL Developer

Responsibilities:

• Responsible for requirements gathering from Clients, analysing and creating SQL-PLSQL scripts to deploy different Investment Managers in PLM Application.
• Developing Oracle PL/SQL stored procedures, Functions, SQL scripts to facilitate the IM use the various modules of application.
• Handled client queries effectively and suggested simpler and effective solutions on several occasions.
• Worked as Deployment Lead managing a team varying from 4 to 6 members for different client conversions.
• Trained junior resources on project flow, various modules of project.
• Trained team members on various topics of SQL, PL/SQL.
• Received Prestigious APAC IT Star Award from Client’s Global Head.
• Also received several Instant karma Awards and Best People Leadership Award from the Client.
• Received appreciation from client on accurate and timely delivery of deliverables on numerous occasions.