SUMMARY

• 8+ years of software development experience in analysis, design, development, and testing
• 8+ years of experience in Oracle, PL/SQL programming
• Data analysis, writing SQL queries, using oracle analytical functions and report generations
• PL/SQL programming, creation of DB objects - Tables, constraints, indexes, views, materialized views, triggers, functions, procedures, packages, user-defined types, exception handling, partitioning, etc.
• Advanced PL/SQL programming using collections, bulk operations, in-built oracle objects/functions
• Perform data loads using SQL*Loader, Export/Import data to/from Excel
• Understand SQL plan, performance tuning, partitioning, and query hints
• Experience in preparing JIL Scripts, Autosys job scheduling, and monitoring
• Oracle Confidential, audit logs through triggers, debug logs
• Experience in creating DB designs using ER-WIN, forward/reverse engineering
• Knowledge of ETL, Informatica Power Center Designer, Workflow manager, Workflow monitor, Informatica server and Repository Manager
• Experience in Insurance, Financial domains. Knowledgeable in data. Experience in generating regulatory/compliance reports on periodic basis
• Familiar with 3-tier architecture, web development, Java/JDBC, Application Server Connection pools
• Software development methodologies and processes - Waterfall, RUP and Agile (Sprint)
• Onsite/offshore team coordination and track project status in every day scrum as a lead
• Ability to working independently, to work on multiple projects simultaneously, to handle ad-hoc requests
• Enthusiastic to learn new technologies and apply new skills acquired in project development
• Strong analytical and problem-solving skills
• Perform unit tests, system integration test and UAT

TECHNICAL SKILLS

Databases Oracle 10g, Oracle 11g, Oracle 12C, MySQL, MS-Access

ETL Tools Informatica Power Center 9.1, SQL*Loader

Operating Systems UNIX, Windows

Programming SQL, PL/SQL, UNIX Shell script, XML, Visual Basic

Tools ER-WIN, TOAD, Quality Center, CVS, MS Office, Pine, Autosys

PROFESSIONAL EXPERIENCE

State of New Jersey

Responsibilities:

• Interacting with teh business analyst and architect to gather requirements for future requests.
• Coordinating product design reviews to verify that design meets quality standards and functional/technical requirements.
• Providing accurate estimates for design and programming efforts for system changes and enhancements.
• Designed database as per teh business requirements and to integrate with teh existing application.
• Implemented Oracle PL/SQL packages to meet business functionality and to perform data validations.
• Provided support to troubleshoot various production issues and provided solutions for repetitive issues thus by reducing teh overall support activity
• Involved in all phases of development in teh life cycle (SDLC) and contributed to SIT and UAT.
• Performed release and configuration management using GIT, JIRA Tools.
• Implemented development operations and release management process.
• Prepared build scripts to package and deploy artifacts into various environments.
• Generated reports for business users as requested on monthly basis.

Confidential,

Responsibilities:

• Implemented Oracle PL/SQL packages to perform data validations, and to handle DML operations
• Developed application frame work model using UNIX Scripts and PL/SQL for snapshot data load.
• Provided support to troubleshoot various production issues and provided solutions for repetitive issues thus by reducing teh overall support activity
• Involved in all phases of development in teh life cycle (SDLC) and contributed to SIT and UAT.
• Created JIL scripts to handle files from teh landing zone to manage teh data load process.
• Performed release and configuration management using SVN, HERMES build and release tool.
• Implemented development operations and release management process.
• Prepared build scripts to package and deploy artifacts into various environments.
• Generated reports for business users as requested on monthly basis.

Confidential,

Responsibilities:

• Developed PL/SQL packages that are used to perform post process activity upon ETL loads
• Involved in troubleshooting various production issues
• Create views to enhance data flow and processes.
• Analyze and optimize ETL process oracle queries.
• Written JIL scripts to setup Autosys Jobs, and monitored teh logs
• Involved in all phases of development in teh life cycle (SDLC) and contributed to SIT and UAT

Confidential,

Responsibilities:

• QCCR: Implemented business rules in PL/SQL packages, procedures as per regulatory compliance on rating endorsements, performed validations in triggers
• Ratings: Implemented functional requirements to support new rating type BICRA, to extend Preliminary short term rating support for Issuer Credit Ratings.
• Entity Analyst History: Implemented functionality to capture analyst changes on companies/securities through triggers
• Management meetings: Created tables and procedures to maintain Management meetings on organizations and programs - meeting dates, meeting attendees and history
• Data bulks: Performed historical rating data updates for endorsements, generated entity analysts history from audit tables (Confidential), uploaded BICRA ratings, updated data for unsolicited ratings, updated Creditwatch/Outlook on ratings
• Reports: Generated Analyst rotation reports for business users - wrote PL/SQL procedures, created views, materialized views, temporary tables
• Analyzed business requirements, written technical analysis documents
• Performed business rules validations in triggers, gained strong experience in before/after, row/statement level triggers, mutation prevention
• Wrote stored procedures/functions, packages with exception handling, user-defined exceptions
• Performed data bulks by writing PL/SQL procedures/packages, created temporary tables to keep teh data to be bulked, and to track status
• Created DBMS jobs to perform data bulks in automated process
• Got familiarity and experience in Oracle Confidential, auditing
• Implemented debug logging through autonomous transactions and used across DB source code, purging strategy via partitions
• Worked on creating ER-WIN designs, physical tables, constraints, indexes, views, triggers, partitions
• Created user defined data types, performed bulk operations wherever necessary to improve performance
• Coordinated with business, QA, and DBA teams
• Took accountability and ownership, was responsible in delivering project deliverables on time with a great quality. Handled more TEMPthan 1 assignment in parallel.
• Performed performance tuning by query rewrites, analyzing indexes, SQL Plan
• Wrote test cases, created pl/sql scripts to perform unit testing

Environment: Oracle, Triggers, DBMS Jobs, Materialized Views, Confidential, SQL, PL/SQL, TOAD, ER-WIN

Confidential,

Responsibilities:

• Understood existing homegrown T&T process, implemented new enhancements, involved in tuning teh process, and maintenance
• Created Triggers on teh source Databases (CORE) to load data into Shadow (SDW) tables
• Created Triggers on SDW tables to load Trigger queue table
• Setup Oracle job to read Trigger queue and SDW tables, and tan load into Message (MSG) tables
• Created Triggers on MSG tables to load into Message queue table
• Message queue table and MSG tables are Shareplex replicated to Destination database FGR
• Setup Oracle job to read Message queue table and MSG tables, to implement business rules using PL/SQL stored procedures, and to store data into destination tables
• Performed post T&T operations like Sector Mapping, Entitlement mask generation, Load Rating Search tables
• Created debug table, and procedure to log debug messages using PRAGMA AUTONOMOUS TRANSACTION so that main transaction is not effected
• Created materialized views to improve process performance wherever necessary
• Performed unit testing, end-to-end testing from source to destination

Environment: Oracle, Triggers, DBMS Jobs, Materialized Views, Shareplex, SQL, PL/SQL, TOAD, ER-WIN