Chowdary Nekkalapudi acuqk4@r.postjobfree.com

201-***-****

PROFESSIONAL SUMMARY:

Around 8 years of experience as Oracle PL/SQL developer in Business Analysis, Design and Implementation of Financial Business Applications using Oracle Relational Database Management System (RDBMS).

I have Over 7+ year’s development experience in an Oracle 11i Database.

I Have Good experience with SQL (advance queries, tuning) and PL/SQL and Oracle ERP/EBS

In-depth understanding of Software Development Life Cycle (SDLC) and industry best practices.

Excellent technical skills with proficiency in PL/SQL, SQL, Workflow 2.x, Forms and Reports 6i

Strong understanding of relational databases (including tables, views, indexes, table spaces etc.)

Excellent understanding of Entity Relationship Diagrams (ERDs) and the translation of business requirements into them

Worked as a developer, mainly on C, C++, multithreading, data structures, STL, Windows and UNIX

Involved in designing various Applications and Reports by interacting directly with End Users and Business Analysts.

Involved in all phases of the SDLC (Software Development life Cycle) from Analysis, Design, Development, Testing, Implementation and maintenance with timely delivery against aggressive timelines.

Experience in building and maintenance of Banking Application Database and Reporting.

Gathers and documents reporting requirements from business owners and/or business analysts, prepares functional and technical design documents.

Conduct JAD sessions with end users to gather functional and technical requirements, perform GAP analysis, and documenting business processes and flows.

Works closely with end-users to gather report requirements and ensure proper testing/validation.

Supports user acceptance testing on production data loading and new features

Expert in data analysis using various tools and writing SQL queries against various databases including Oracle

Scope new projects, interpret business needs, translate technical issues, identify and model data requirements, identifying business rules requirements, and test requirements.

Expertise in Client-Server Application Development using Oracle 11g/10g/9i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Created various schema objects like Tables, Views, Constraints, and Indexes.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Experience in PL/SQL performance Tuning.

Exceptional Communications and team building skills with proficiency at grasping news functions and technical concepts and ability to communicate at all levels

Strong verbal and written communication skills. Excellent team player and proven track record working in various team sizes performing cross-functional roles.

TECHNICAL SKILLS:

Modeling Methods

Waterfall, Iterative & Agile

Databases

Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers),

SQL Developer, MYSQL 5.6

Languages/Utilities

SQL, PL/SQL/UNIX Shell Script, Java Script, XML, HTML, C,C++

Operating System

Windows XP/7/8,Linux, UNIX

Reporting Tools

Tableau, iReport

Office Tools

MS Word/Excel/PowerPoint/Outlook

Other Tools

ETL-Informatica, Autosys, TOAD, SVN, CVS

EDUCATION:

Bachelors in Mechanical Engineering from Jawaharlal Nehru Technological University, India.

PROFESSIONAL EXPERIENCE:

Bank of America, NC Apr 2015- Till Date

Role: PL/SQL Developer

RAILS

Responsibilities:

Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.

Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing.

Created relevant staging tables to load the CSV files, identified the business validation rules. Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.

Experience in creating the tables and sequences for the experimental data load capture. Loaded the data into the tables using TOAD and SQL*Plus. Created metadata validation lookup tables and pre populated them using SQL Loader generator application.

Experience in relational databases (including tables, views, indexes, table spaces etc.)

Designed competent PL/SQL programs using PL/SQL collections, Records types, and Object types.

Developed and automated the interfaces by using the PL/SQL. Developed user defined stages and common templates.

Design the data structures used by Proteus applet GUI to communicate C++ back end.

Write methods of parsing the MQ Series message to call C++ functions.

Tuned several Oracle SQL statements using Explain plan, Auto Trace utilities.

Involved in implementing table partitions using Range, Hash, Composite techniques.

Worked on external hints during the SQL optimization to fast up the SQL process.

Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.

Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.

Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.

Environment: Oracle 10g/11g, PL/SQL, SQL Plus, Informatica ETL, SQL Loader, SQL developer, C, C++, Autosys, Toad.

Aetna, Hartford, CT Jan 2014 - Mar 2015

Role: PL/SQL Developer

Enterprise Data warehouse

Project Description: The Enterprise Data warehouse (EDW) is system we all the insurance data will be maintained of the customers. The Aetna is offering different types of Insurance for their customers like Health, Auto, Property, Rental etc. To maintain all these transactions history a centralized application is built that’s called EDW.

Responsibilities:

Creating the design document from Master Requirement Document, customizing existing functionality available in Finacle to cater the Banks requirement, creating new Menus (Finacle terms) to include the functionality that is not available in Finacle base product.

Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Data Validations and testing with Business Users, fixing data issues

Worked on SQL*Loader to load data from flat files obtained from various facilities.

Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Creation of database objects like tables, views, procedures and packages using oracle tools like Toad,PL/SQL Developer and SQL* plus

Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.

Co-ordinate with DBA for changes in database and data partitioning.

Involved in data report customization using iReport tool.

Worked in Production Support Environment as well as QA/TEST environments for projects, maintenance requests, bug fixes, enhancements, data changes, etc.

Developed PL/SQL triggers and views.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Developed Frontend HTML screens using in-house tool.

Involved in liquidity reporting with the reporting team.

Actively involved in system production support to resolve the issue on daily basis.

Analysis of Issues in Production Runs and Implementing Production Fixes.

Reviewed the code written by other team members.

Performed Unit Testing for the developed codes.

Preparation of daily and weekly status reports

Created Java Scripts to validate the input Data.

Environment: Oracle 11g, SQL * Plus, Informatica, TOAD, SQL Developer, SQL*Loader, UNIX, Autosys, Linux, Windows XP.

VM Ware, Palo Alto, CA Jan 2013 - Dec 2013

Role: Oracle PL/SQL Developer

Responsibilities:

Worked with the Business analysts and the DBA for gathering, business analysis, testing, and implementation.

Involved in logical modeling and physical modeling of database application and Developed Stored Procedures, Functions, Packages using PL/SQL.

Involved in creation of Conceptual Modeling covering all the business requirements.

Loaded the data into database tables using SQL*loader from flat files.

Developed SQL scripts, cursors, tables, views, materialized views as per the business requirements.

Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, Tk-prof and Auto trace.

Developed Procedures for efficient error handling process by capturing errors into user managed tables.

Part of a development team for creation and maintenance of custom apps/reports.

Evaluating new techniques for enhanced functionality.

Developed Perl scripts for data sources for data migration.

Experienced with bulk collections and for all operations on tables to improve the performance of manipulation language statements.

Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.

Developed UNIX Shell scripts to automate table creation, execute procedures using dynamic SQL statements.

Worked on Data schema modeling and designed Database Schema using ERWIN tools and implemented Normalization on relational modeling.

Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.

Experience in BI reporting and visualization tools such as: Business Objects, Micro strategy, MSBI (SSAS, SSRS and Performance Point), Cognos, Tableau, Crystal Reports, etc.

Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.

Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.

Extensively used Database Query tuning and performance tuning of reports.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g, Perl, UNIX, Windows XP/2000.owb 10g.

ICICI, India Sep 2011 - Dec 2012

Role: PL/SQL Developer

Project Details:

ICICI Bank is a rapidly growing Banking and credit card company in INDIA. The company was interested in developing several Data Marts, Operational Data Store and Enterprise Data Warehouse from the historical, transactional and financial data for analysis by different business units within the Bank.

Responsibilities:

Worked on Technical Design Documents/Build of PO Receipts Inbound Interface.

Created PL/SQL package for different validations, for processing data in order to create Valid PO Receipts and for populating the PO interface tables from staging tables and called the Seeded import programs to populate the data in base tables.

Created Unit Test Protocols, Installation Documents/Scripts for developed objects and Involved in unit and integration testing of the components and prepared documentation for the same.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Involved in analysis and tuning of SQL queries by using EXPLAIN PLAN and TKProf for faster and better performance of the SQL queries.

Responsible for writing high quality and well documented code according to standards and documentation of various processes.

Worked with migration team for maintaining migration activities.

Ensure jobs and audits are in line with project requirements, service level agreements and security policies

Environment: Oracle 9i, SQL, PL/SQL, Toad, Windows 7, Tortoise SVN, Linux, WinCVS.

Union Bank, India Nov 2008 – Aug 2011

Role: Oracle PL/SQL Developer

Responsibilities:

Involved in SDLC gathering requirements from end users.

Worked in Agile methodology for software development process.

Developed views to facilitate easy interface implementation and enforce security on critical customer information.

Preparing unit test cases and reviewing the test cases prepared by teammates.

Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.

Developed stored procedures and triggers to facilitate consistent data entry into the database.

Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Developed Database Triggers for audit and validation purpose.

Migrated data from external sources using SQL*Loader.

Application setup, Test the application with the data provided from client.

Done User Acceptance testing along with client team.

Writing validation packages using PL/SQL and tuning them for performance.

Created and manipulated stored procedures, functions, packages and triggers using TOAD.

Analysis of Issues in Production Runs and Implementing Production Fixes

Environment: Oracle 9i, SQL, PL/SQL, C,C++,Toad, Windows XP, Sun Solaris

Contact this candidate