Chowdary_PLSQL

Chowdary Nekkalapudi
nekkalapudichowdary369@gmail.com
201 371 3259
PROFESSIONAL SUMMARY:
 Around 8 years of experience as Oracle PL/SQL developer in Business Analysis,
Designand 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 in Oracle Apps (Manufacturing, HRMS, Financials […] (modules
Fixed Assets, Order Management)) and complete project life cycle. Systems Integration,
Interfaces and Conversions between Oracle Financials and legacy systems,
Customizations of Oracle Financials modules and Development of
Custom Oracle Financials modules. Production Support and Performance tuning.
 Valuable knowledge of OBIEE 11g and also having hands on experience in OBIEE 10g
in integration with BI publisher Extraction, Load and Transformation (ELT)
using Oracle Data Integrator (ODI) 11g, Informatica 9.x/8.x/7.x and SQL, PL/SQL.
 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
 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 ,ODI 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
Operating System Windows XP/7/8, UNIX
Reporting Tools Tableau, iReport
Office Tools MS Word/Excel/PowerPoint/Outlook
Other Tools HP Quality Centre/ 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
GWIM AND CSBB COMPLIANCE

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.
 GG Downstream Data Integration with Business Intelligence and Data warehouse
system
 Prepared Test plans covering a range of Test cases, and performed unit & integration
testing.
 Involved in the Unit testing, Integration & User Testing.
 Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading
and running ODI jobs as per schedule.
 Created ODI Procedure, ODI Package, ODI Variables, ODI Scenarios,ODI Functions, O
DI Mappings, ODI Load Plans
 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.
 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: ODI […] ODI12c, Web Logic Server 11.x,Oracle 10g/11g, PL/SQL, SQL Plus,
Informatica ETL, SQL Loader, SQL developer, Toad.

Aetna, Hartford, CT Jan 2014 - Mar 2015
Enterprise Data warehouse
Project Description: The Enterprise Data warehouse (EDW) is system we all the insurance data will be
maintained of the customers. The Cigna 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 include installing and configuring the Oracle Data Integrator (ODI) software tool
in a three-tier environment and performing periodic upgrades, performing source-to-
target mappings.
 Upgrading from ODI 10G to ODI 11G environment.
 Experience in configuring ODI Agent on UNIX server and creating new agents and test
them in ODI11G.
 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 Developerand 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 I Report 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.
 Involved in the Unit testing, Integration & User Testing.
Environment: Oracle Data Integrator, Oracle 11g, SQL * Plus, TOAD, SQL Developer,
SQL*Loader, UNIX, 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
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, 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, Toad, Windows XP, Sun Solaris

Chowdary_PLSQL

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Viewers also liked

Viewers also liked (20)

Similar to Chowdary_PLSQL

Similar to Chowdary_PLSQL (20)

Chowdary_PLSQL