We provide IT Staff Augmentation Services!

Senior Pl/sql Analyst And Developer Resume

5.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY

  • 7.5 Years of experience in Oracle11g(PL/SQL) and Unix for Retail Banking and Asset management domain i.e planning, analysis, design, development, testing & implementation & employed the best practices in application development and business requirements acquiring techniques.
  • Extensive experience in Design and Development of PL/SQL Programs.
  • Domain Experience: Retail Banking, Asset management & Payroll system.
  • Extensive experience in interacting with Clients/End Users for requirement gathering.
  • Experienced at Oracle 9i/10g/Exadata (PL/SQL) and SQL - Server (T-SQL) configuring client-server connectivity, Query Optimization, Stored Procedures and Triggers and strong knowledge of relational databases.
  • Strong knowledge in Application Development, Data Modeling, Data Cleansing and Migration.
  • Leaded as Senior technical consultant for core banking solution (Flexcube) in Nigeria from Apr 2010 till Jun 2011 for 5 largest banks.
  • Was awarded with I-appreciate oracle award for financial year 2010-2011.
  • Team builder with strong leadership qualities. Demonstrated initiative, drive, and ability to manage multiple priorities throughout academic and professional term
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Involved in Flexcube(Retail Banking Product) application development, implementation and production support for YES Bank, KVB Bank, Syndicate Bank & 5 Banks in Nigeria.
  • Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design development, testing and maintenance with timely delivery against aggressive deadlines
  • Strong skills in creating complex objects like Functions, Procedures, Packages and Triggers using Oracle SQL & PL/SQL.
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution PlansandIndexes.
  • Experience withPerformance Tuningfor Oracle RDBMS using Explain PlanandHINTS.
  • CreatedShell Scriptsfor invoking SQL scripts and scheduled them using crontab.
  • Excellent analytical skills, ability to take leadership, go in core of the problem, capacity of work-meeting deadlines and excellent interpersonal/communication skills.
  • Oracle Certified Professional - Application Developer.

TECHNICAL SKILLS

Operating systems: Windows 98/2000/2003/ XP/Win 7,8 & Unix.

Languages: C, Core Java, SQL, PL/SQL, Visual Basic, Shell Scripting.

Tools: SQL*PLUS,PL/SQL Developer,Toad, SQL*Loader.

Applications: Oracle - Flexcube, PACE-PARE, Payroll.

Databases: ORACLE 9i,10g,11g, SQL SERVER,MYSQL

Web Packages: HTML, XML.

Version Control tools: Microsoft-VSS & PVCS.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior PL/SQL Analyst and Developer

Responsibilities:

  • Interacted with business users to gather business/report requirements.
  • Responsible for all the reporting application tools for asset/holding/transaction of the clients.
  • Developing reports for Business users to check Risk, Performance gain and loss against different market indices for their respective portfolios.
  • Reconciliation between upstream and downstream systems for all the trades w.r.t day, month, quarter and year.
  • Designed the Database Architecture - Table structures, Triggers, Complex stored procedures, Cursors, Primary Key/ Foreign Key Relationships, Table valued and Scalar Value Functions.
  • Analysis, design, development, testing, integration and implementation of new functionalities and functionality changes according to business requirements.
  • Performance improvement of several time taking procedures which was causing a delay in the subsequent processes as well.
  • This could some time create inconvenience to the users due to information which was not timely updated.
  • Participate in definition, design, and review of software architecture, design, frameworks and interfaces.
  • Implemented many Batch Scripting Tasks, Schedules packages and jobs.
  • Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements.
  • Developed advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
  • Generated server side PL/SQL scripts for data manipulationand validation and materialized views for remote instances.
  • Involved in the continuous enhancements and fixing of production problems.
  • Designed, implemented and tunedinterfaces and batch jobs using PL/SQL.
  • Involved in data replication and high availability design scenarios withOracle Streams. Developed UNIX Shell scriptsto automate repetitive database processes

Environment: Incident Management Tool, Control-M, C++, Unix.

Confidential

Senior PL/SQL Analyst and Developer

Responsibilities:

  • Enhancement of new functionality in Flexcube that keeps the track of money laundering system (Pl/sql code and VB).
  • Development of cheque truncation system that allows RBI for faster clearing of cheques, It is basically an online image-based cheque clearing system where cheque images and Magnetic Ink Character Recognition (MICR) data are captured at the collecting bank branch and transmitted electronically
  • Design and development of offline functionality in Flexcube, and making it work on Windows 7 without admin rights on client machine.
  • The project assignment includes upgrading the Database to 9i from 8i and ensuring smooth running of FLEXCUBE application by resolving the application issues across the modules like CASA, Loan and TD, Online Transaction, Settlements and Clearing, Reports, ATM etc.
  • This project includes handling site specific enhancements, online and offline issues after release of the same.
  • Implemented Centralized batch setup in Flexcube with registry logic, was involved in first round testing to validate the OLTP transactions and maintenance works properly.
  • Involved in configuration of Flexcube Installation at banks.
  • SOA (Service Oriented Architecture), which ensures its easy integration to other systems.
  • Designed archival scripts of Flexcube tables for increasing the performance of different modules.
  • Requirements gathering, impact analysis and devising the best possible solutions.
  • Exhaustive unit testing of all the modules built.
  • Guiding and helping the team in completing tasks. Meeting with users for requirements collection.
  • Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
  • Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
  • CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
  • Experience inDatabase Application Development, Query Optimization, Performance Tuningand DBAsolutions and implementation experience incomplete System Development LifeCycle.
  • Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
  • Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links

Environment: TOAD, SQLPlus, Visual Studio, SQL*Loader.

Confidential

PL/SQL Analyst and Developer

Responsibilities:

  • I was involved in the development of Inventory Management system application(Oracle database).The application tracks every goods that has received or sent to clients from warehouse. The manager gets complete online report for goods received, material transported from one location to another and challan that they have placed from their side. It was entirely online solution, so as to move towards a paper free office.
  • I was involved in the development of Leave and Attendance Management system(Oracle database). The application automates several tasks performed by employees of the Aptech, so as to move towards a paper free office .It enables user to apply leave online and get it approved by respective approver and encashment of leaves provision is also provided, also it enables user to view his current status of leaves and attendance, through leave applications and attendance. Approval workflow in place for online approval. Leave report, Attendance report, Year-End process for employees is also provided.
  • I was also involved in the development of Warehouse Management System(Sql Server,MySql Developer) The warehouse management solution was part of an Integrated ERP System, wherein the database would be stored centrally and warehouse users will log on to the web application through its dedicated network. The key features of this module are SKU/Product/Item Setup, Product Pricing, Opening Stock, Charge tax, Customer Pricing.(Sql Server)
  • Automated the manual scripts in Payroll system. The is the ultimate payroll delivery package, where user can able to view payslip, also it enables User to declare investment online, tax calculations and can submit tax sensitive investment declarations too for the payroll department to take into consideration. Osource is handling online payroll system for 22 companies.
  • Involved in the coding of PL/SQL programs based on the Requirements Document and Mapping Document for Complex Mapping rules to automate the test design.
  • Identifying test data which are meeting the mapping requirements by writing complex SQL queries.
  • Coordinating with development teams to test the data in the database.
  • CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
  • Involved in testing of application by Unit Testing, Integration Testing, User Acceptance Testing (UAT) and End User Support.
  • Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
  • PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
  • Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
  • Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
  • Wrote sequences for automatic generation of unique keys to supportprimary and foreign key constraints in data conversions.
  • WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
  • Creatingindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Environment: TOAD, SQLPlus, SQL*Loader, Oracle 10g

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Involved in the coding of PL/SQL programs based on the Requirements Document.
  • Coordinating with development teams to test the data in the database.
  • Implemented Batch scripts using unix scripts.

Environment: TOAD, Oracle 9i

We'd love your feedback!