Sql Developer Oracle Pl
Resume:
Objective:
Looking for a challenging position in industry where my technical knowledge, logical and analytical skills will greatly enhance the industry success and my growth.
Summary:
Around 7 years of programming experience as an Oracle PL/SQL developer and Forms/Reports Developer.
Excellent knowledge in Analysis, Design and implementation of Business Applications using Oracle Relational Database Management System (Oracle RDBMS).
Have good experience in writing PL/SQL scripts for the database objects like tables, views, procedures, functions, packages, database triggers, indexes and sequences, Flashbacks.
Good experience in generating forms using PL/SQL for data validation, processing Oracle Forms 9i/10g and also generating reports in Oracle Reports 9i/10g.
Written Perl routines to handle daily requests and processes from users
Expertise in using Oracle 8i/9i and 10g databases and knowledge about PL/SQL programming to develop stored procedures and packages.
Expertise in using advanced features of Oracle 9i for PL/SQL programming like Varrays, Dynamic SQL, Query Optimizer, Nested Loops, External Tables, Nested Tables, LOBS.
Used Hints for better performance of the queries and any procedures.
Very Good Knowledge about the Oracle tools like SQL, PL/SQL, SQL*PLUS, Oracle Enterprise Manager, SQL*Loader, and data pump utilities like Export/Import.
Experience in application fine-tuning and database fine-tuning using Explain Plan and TKProf.
Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
Good knowledge of using Flashbacks to recover the data from recycle bin.
Expertise in all phases of the Software Development Life Cycle (SDLC) including analysis, Physical and Logical design, Resource Planning, code development, testing, implementing and maintenance
Good knowledge of Investments Management and Asset Management.
Expert in creating special Grouped reports, Cross Tab / Matrix Reports, Sub reports in main reports, Drill Down reports, mailing reports using Crystal reports.
Experience working on Health-Care Project development.
Good knowledge of creating database links and materialized views.
Experience in editing and publishing a solution using ATG Knowledge.
Good knowledge in using the ATG dynamo console.
Good knowledge in design, coding and testing.
In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.
Certifications:
Oracle Certified PLSQL Developer.
Brain bench certified RDBMS concepts.
Brain bench certified PLSQL Fundamentals.
ATG Education Services certified for Foundations of ATG Application Development.
Technical Skills:
Languages
SQL, PL/SQL, Shell Programming (Bourne, Korn), C, C++, JAVA.
Databases
Oracle 8.0, 8i, 9i, 10g, MS Access, SQL SERVER 2000.
Reporting Tools
Crystal Reports 9.5, oracle reports 10g, 9i, forms 10g,9i.
Tools
ERWIN 4.0, Oracle Enterprise Manager, TOAD 8.5, Oracle SQL, Developer, Database Configuration Assistant, Net Configuration Assistant, F-Secure 5.3, MS-OFFICE (2007).
DB Utilities
SQL Loader, Export / Import, Data pump, TKPROF, Stats pack.
Operating Systems
UNIX, LINUX, Sun Solaris 5.6/5.8/5.9, Windows NT, Windows 95/98/2000, Windows XP, Windows Server 2003.
Web Technologies
HTML, Macromedia Dreamweaver MX, MS-FrontPage, JavaScript, Macromedia, Fireworks MX, XML, ATG.
Education:
Bachelor’s (B-Tech) in Computer Science and Information Technology from JNTU Hyderabad, Andhra Pradesh, India
Master of Computer Science from New York Institute of Technology, NY.
Professional Experience:
Ardent Credit Union Sep 2018– Present
Philadelphia,PA
Role: Programmer Analyst
Ardent Credit Union, formerly known as Sb1 Federal Credit Union, is a bold, savvy, sophisticated, and hardworking credit union striving to make finances easier and more accessible for its members. With their innovative and unique offerings, they look to benefit members and lead them to long-term success. As a member-owned financial cooperative originally founded in 1977 by the employees of the SmithKline Corporation, Ardent Credit Union has more than $600 million in total member assets. Ardent Credit Union is headquartered in Philadelphia, PA and serves Philadelphia, Montgomery, Delaware, Bucks and Chester counties.
Centralize all data assets
Provide views of this data to the organization
Document lifecycle of data to help others understand the system of record
Design databases, tables, and data warehouse
Apply formal software development lifecycle
Assist with other technical projects
Recommend tools to provide modern solutions for programming and data administration
Analyze and determine the feasibility and strategic alignment of all user service requests
Gather requirements, uses cases and perform testing and documentation
Provide scheduled automation of data lifecycle
Maintain documentation on all systems and programming service requests
Assist with system integrations
Provide technical support for internal departments
Perform other duties as assigned
Environment:
DB2, SQL, SSDT, Excel, Crystal Reports, Windows 10, HTML 5, IIS, Apache, PowerBI, PowerShell
NCS Technologies Nov 2008– May 2013
Piscataway, NJ
Role: Tech Lead/Sr.Developer
NCS Technologies is a full-service provider of high value customer touch point solutions, enabling clients to improve customer relationships and experiences. It is specialized in providing comprehensive answers to business challenges in the areas of Data Warehousing, Business Intelligence, Process Engineering and Enterprise Security.
Responsibilities:
Involved in migrating Oracle database from 9i to 10g
Involved in migrating Oracle Reports from 6i to 10g.
Analysis of Business and Technical Requirements.
Created reports as part of supporting maintenance tickets for ATT Knowledge using Oracle Joins.
Used Crystal reports 10 to create reports for BU team.
Involved in loading the data into the database as part of the support for new and existing devices.
Responsible for writing design and business documents about the process.
Did analysis on the data flow to understand the application.
Involved in Complex SQL query optimizations.
Created packages,procedures,functions,cursors to meet the Business requirements.
Involved in creating new tables using the normalization process when the application was converted from 2-tier to 3-tier.
Worked on SQL Tuning using Explain Plan. Tuned SQL Queries and plsql objects.
Used Analytic function Over partition by order by clauses for calculations along with RANK.
Involved in approving SDLC aritifacts.(SIT plan,DESIGN,Requirements,SOL REVIEW)
Worked with AVG, ROWNUM, TRIM, LPAD,RPAD and some other Aggregate functions for performance and data matching .
Involved in supporting secure applications using HTTPS and SSL Certificates changes using cryptographic key.
Work as part of the Development team for creating the source code of the application on the specifications provided in the design documents.
Experienced working IT application development projects for the public sector (Health care).
Involved in resizing the images using the GIF tool.
Created Views and Synonyms for the database objects.
Attended review meetings and walkthroughs to discuss the status of the project and for change requests
Involved in editing and publishing the solutions using ATG knowledge.
Involved in making changes to the existing JSP scripts as per the requirement.
Designed HTML pages for intranet site.(local to NCS)
Involved in executing the Build scripts during the deployment of the updated code on the server.
Involved in developing an ESB module to transport the data between the external vendors.
Applied OOAD and OOSD approach for analyzing and designing an existing Framework to append new modules.
Used Smart/Tortoise SVN to maintain the versions of the application and history while developing the application.
Involved in Agile Scrum meetings for developing the requirements.
Involved in loading the data to MS Access database using forms.
Created reports and modified the existing forms as per the request using MS Access.
Integrating and testing the developed applications.
Used Microsoft TFS and Visual Studio for Check out/check and to debug/develop the scripts.
Worked on a project which deals with the data related to Asset classes for the fund management (Asset Management).
Created Oracle Reports to find the stats for the performance of the fund being invested.
Attending review meetings and walkthroughs to discuss the status of the project and for change requests.
Achieved quarterly award for Excellence for the first quarter in 2011.
Environment:
Oracle 9i/10/11g, MS Access, Windows XP, SQL developer 1.2, Win SCP, Java 4, ATG 9.1, Smart SVN,Crystal reports 10, Microsoft Visual Studio 2010,TFS.
Yale University May 2008 – OCT 2008
New Haven, CT
Role: Oracle PLSQL Developer/ Forms Developer/ Reports Developer
Yale University comprises three major academic components: Yale College (the undergraduate program), the Graduate School of Arts and Sciences, and the professional schools. In addition, Yale encompasses a wide array of centers and programs, libraries, museums, and administrative support offices. Approximately 11,250 students attend Yale.
Information Technology Services (ITS) provides computing and communications infrastructure, services, support, and innovation for Yale's instructional, research, public service, and administrative programs. ITS works closely with many other units on campus to provide a wide range of services for students, faculty, staff, alumni, and others.
Responsibilities:
Created the Application Design Document.
Wrote stored Packages, procedures, cursors,functions, sequences, indexes, triggers.
Developed a Paper layout Oracle report for generating the overpayments of the students using the database tables and views.
Involved in Complex SQL query optimizations.
Used the Template editor in Oracle Reports to insert the text for displaying headings.
Implemented CAS (Central Authentication Service) Functionality using Oracle Forms.
Created the procedure for validating the already generated URL ticket number.
Used the SYS_GUID function to randomly generate a child ticket number and SYS_CONTEXT function to obtain the session information.
Used dbms_application_info package to record names of executing modules each time a user enters that module.
Used Post-logon trigger in oracle forms to ensure whether user has entered through CAS (Central Authentication Service).
Involved in OOAD and OOSD concepts for analyzing and designing an application to append new modules.
Created Materialized View for extracting the data from remote database.
Enhanced the performance of the procedures by creating suitable global and local indexes.
Assisted in scheduling the every day activity of data purging using CRON jobs.
Migrated forms from one server to another using the version control tool VSS (Microsoft Visual Source Safe).
Worked with COBOL team to support Visual COBOL applications such as file processing, sorting and relational database.
Created UNIX scripts for all the database objects and migrated those using RCS.
Maintained the data integrity and security using integrity constraints and database triggers.
Manipulated numeric and character values that contained Null values by extensively using the NVL function.
Extensively used Cursors for manipulating the large amount of data and reducing the coding and error margin.
Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
Made use of DB LINKS for accessing data across different databases.
Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
Performed debugging of the PL/SQL codes using the DBMS_OUTPUT.
Performed debugging in Oracle Forms using MESSAGE.
Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation of the code.
Assisted the QA team in performing Load Testing and Performance Testing.
Environment:
Oracle 10g, Windows XP, UNIX, PL/SQL, TOAD 8.6, Oracle Forms9i and Reports10g.
Life Insurance Corporation of India Feb 2004– Dec 2005
Role: Oracle PL/SQL Developer
Hyderabad India.
The main function of the system is to process the insurance claims. The system gets the data from various modules like provider module, policy module, insurance module etc and finalizes the claim processing.
Responsibilities:
Extensively written PL/SQL code for stored Procedures, Functions, Packages, Libraries and other database triggers etc. Written interfaces to transfer/interact data with various external systems.
Solving performance issues with the long running SQL, PL-SQL code.
Coordinating with clients, Requirements gathering and designing.
Coordinating with clients, Requirements gathering and designing.
Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
Created and standardized object libraries and coding standards. Implemented various code-review procedures for achieving consistent look and feel across the application.
Documenting the procedures to be followed in the event of a database crash and recovering the database in the event of crash.
Actively involved in creating some of the java classes and methods along with the java developers.
Environment:
Oracle 8.0/8.1.5/8.1.7 PL/SQL, Developer 2000, WindowsNT/98, Perl, SQL, java 4.
Raji Pasumarti
Email ID: ***********@*****.***
Cell: 516-***-****
Contact this candidate