SUMMARY:

• Over 8+ years of IT Experience as an Oracle PL/SQL Developer in Analysis, Design, Development using Oracle Relational Database Management System.
• Involved in all phases of Software Development Life Cycle (SDLC).
• Great experience with Financial and Education domains.
• Exposure to Capital Markets domain and Equities Trade Life Cycle.
• Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Stored Procedures, UDFs and Triggers using Oracle.
• Good understanding of Normalization/De - normalization and database design methodology.
• Good experience in UNIX Shell programming.
• Supporting UNIX servers running services within the business.
• Proficient in advance features of Oracle for PL/SQL programming like using cursors, variables, Ref. cursors, nested tables, associative array, dynamic SQL and nested loops.
• Ensure all Database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Involved in migration of Crystal Reports to Argos Reports.
• Developed Customized Reports using Argos, based on the client requirement.
• Experience in Oracle Reports 6i/10g and Oracle Forms.
• Developed Front End UI screens using Oracle Apex.
• Experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Marts using Informatica powercenter components (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Developed Informatica Mappings and Workflows to load the data from different sources flat files, SQL server database to Oracle database.
• Proficient in developing complex logic mappings by using different transformations like Source Qualifier, Expression, Filter, Joiner, Router, Union, Unconnected / Connected Lookups, Aggregator, Sorter and Re-usable transformations.
• Good Understanding about ODI Architecture.
• Good knowledge about Topology, Designer, Operator in Oracle Data Integrator.
• Develop and modify Perl programs to query database configuration compliance.
• Having experience in designing and developing orchestrations/integrations using IBM Cast Iron.
• Knowledge on GLOSS (Global Settlement System), it is a transaction processing engine which automates the trade processing lifecycle.
• Specialized in the Higher Education environment. Extensive development work with Banner Student, Admissions and Financial Aid modules.
• Experience in Banner Implementation of Student Module.
• Familiar working in fast paced AGILE environment & attended daily scrum meeting.
• Developing and documenting Change Management processes in support for the ITIL team.
• A team player and have the ability to work effectively with senior management in accomplishing objectives and able to deliver results and meet deadlines.
• Experience working with Production 24/7 and Development Environments and providing On-Call support.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, SQL Server 2008, 2012

Languages: PL/SQL, MS SQL, C, Unix bash scripting, Perl, HTML,XML

ETL Tool: Informatica Power Center 8.x (Designer, Repository Manager, Workflow Manager, Workflow monitor), ODI

Tools: PL/SQL Developer, SQL Server Management Studio, Oracle Forms 6i/10g, Oracle Reports, Oracle Apex, TOAD, SQL Developer, Jenkins

Integration Tool: IBM Web Sphere Cast Iron

Reporting Tools: Argos Reports, Crystal Reports

Version Control: Sub-Version

WORK EXPERIENCE:

Confidential, NY

Sr. Oracle Database Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the procedures and packages.
• Involved in Understanding the various Asian and European Capital Markets.
• Wrote User Guide and did demo to Capital Markets Team (End Users).
• Analyse and Normalize Data of the relevant business processes.
• Responsible for ensuring that the application, Data dictionaries and Database schemas are met with the requirements.
• Developed programs in PL/SQL, i.e. writing Stored Procedures, Packages, and Queries.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible in tuning complex queries.
• Identifying and testing background servers for various trade flows.
• Compiling C source code and make their binaries.
• Developed Unix scripts for converting one file format to another format.
• Developed Unix scripts to move the files between different servers.
• Validating connections between APR Gloss and external systems.
• Review and Implement improvements to support process.
• Responsible for creating change request (ITIL) for production release.
• Configured Jenkins Jobs for new Linux Servers.
• Successfully supported UAT for the migration.
• As part of Devop Sessions, gained knowledge on Oracle Data Integrator (ODI).
• Knowledge on Configuring ODI connections between source and target systems in topology.
• Automating the code to be copied from SVN to different environments through Jenkins Jobs.

Environment: PL/SQL Developer, SQL Developer, TOAD, Putty, UNIX, Linux, SNV, Scrum, Jenkins, Capital Markets, Agile, ITIL

Database Developer

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specification.
• Collaborate with data architects for data model management.
• Involved in Implementing Banner Student module.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Preparation of design documents.
• Development of complex SQL code including Queries, Triggers, Stored Procedures, Tables, Views, Constraints, and Functions.
• Building semantic views as per business standards and as per reporting needs.
• Created custom API’s to Push Data from UI Application to Banner.
• Generated Reports to check the number of Admissions made each day.
• Implemented and maintained backup and maintenance procedures to ensure reliability.
• Provided proactive support to application issues across production and non-production environments.
• Experience in Performance Tuning, Troubleshooting, backup and restore procedures.
• Review and Implement improvements to support process.

Environment: PL/SQL Developer, SQL Developer, TOAD, Banner 8.x, Putty, Unix, Data Model - Erwin, SVN, Secure VPN, Argos, Banner Implementation

Database Developer

Responsibilities:

• Involved in gathering requirements, analysis and development of Reports to be developed using Oracle Report Builder.
• INB are forms created using Oracle Forms Builder. These Forms are customized to the requirements of the University.
• Involved in writing triggers for the actions performed on the forms.
• Involved in designing various forms.
• Involved in Unit testing and deployment of these forms.
• Developed Front End UI report screens using Oracle Apex.
• Involved in writing queries for generating reports.
• Created complex stored procedures, User defined functions, cursors.
• Attending daily SCRUM calls assign and update on stories to team members
• Creating develop tickets for moving code from QA to production using JIRA.

Environment: Oracle 10g/11g, PL/SQL Developer, Oracle Forms 10g, Oracle reports, Oracle Apex, Banner 8.x, SVN, Secure VPN

Database Developer

Responsibilities:

• Preparation of design documents.
• Developed packages and procedures for functionalities.
• Involved in Code Review and verification of coding standards.
• Developed complex programs in PL/SQL, writing Stored Procedures, Packages, Triggers and Queries with best execution plan and experience with testing.
• Experience with tuning complex queries.
• Resolution of critical issues on push to Banner.
• Maintenance of environment stability.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Installed, upgraded, configured, compiled, support of various Modules for Prod, QA, staging and development.
• Responsible for Database Migration and Upgrading to setup local environment.
• Assisted other teams in stress-testing Mobile App, locating bottlenecks, and recommending possible solutions.
• Troubleshoot day-to-day issues associated with SQL.
• Used TOAD database development tool to interact with database.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL Developer, TOAD, Banner 8.x, Putty, Unix, SVN, Cisco VPN

Database Developer

Responsibilities:

• Involved in writing functional and technical documents.
• Discussed and analyzed business functionality with the client and the developers.
• Created and maintained PL/SQL scripts for deploying to Prod.
• Coded many generic routines (as functions), which could be called from other procedures.
• Used Oracle forms to check if the data was pushed to Banner correctly.
• Developed various Reports for the end users as per their requirements and created many reports to suit pre-printed format of the company.
• Writing stored procedures, Functions and Database triggers using PL/SQL.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Developed Informatica Mappings and Workflows to load the data from different sources flat files, SQL server to Oracle database
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Timer and Scheduling of the workflow.
• Used various complex Power Center Transformations like Lookup, Joiner, Expression, Router, Update strategy, Source Qualifier, Aggregator, SQL filter, Sequence Generator to accomplish the mapping design.
• Identifying bugs in existing mappings by analyzing the data flow, evaluating transformations by Debugging Mappings.
• Extensively created Master Child workflows to avoid the code redundancy.
• Created Re-usable Mapplets for Data Profiling and calculating the formulae.
• Monitored workflows and collected performance data to maximize the session performance.
• Performed tuning of Informatica Mappings for optimum performance of data loads and extracts and SQL overrides in place of homogeneous sources. Designed and coded rejected row handling process.
• Used TOAD database development tool to interact with database.
• Participated in 24Hr Production support for our environments.
• Provided proactive support to application issues across production and non-production environments.

Environment: Oracle 10g/11g, PL/SQL Developer, SVN, Secure VPN, TOAD, Oracle Forms, Banner 8.x, Infor matica Power Center 8.1, (Mapping Designer, Workflow Manager, Workflow monitor, Repository Manager),Cast Iron