PRANATHI

Email: acxplr@r.postjobfree.com

Phone: 972-***-****

SUMMARY:

Goal oriented professional with 4 years of experience in Information Technology.

Hands-on experience in writing Packages, Stored procedures, Functions, and Database Triggers using SQL and PL/SQL.

Proficient in all phases of System Development Life Cycle (SDLC) including Design, Analysis, Development, Testing and Implementation using Oracle 11g/10g/9i/8i.

Good knowledge in front end development using Oracle forms / reports 6i/9i/10g.

Experience in deploying forms and reports on the web.

Experience in developing forms based on views, tables and procedures in tabular and form layouts.

Experience in creating master detail forms and adding alerts.

Work in a team environment to analyze, program, implement and support computer-based solutions for existing business functions. Oracle Application Server Administrator doing upgrade and maintenance of the server/software.

Proficient with designing XML schemas, packages and GUI development using Oracle Forms and Reports Developer/2000

Expert in handling initiatives related to business intelligence software, data warehousing, master data management (MDM), business activity monitoring, application migration and consolidation, and service-oriented architecture (SOA).

Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).

Developed Web applications, using Oracle application/database architecture, PL/SQL, Mod- PL/SQL, Oracle Application Express (APEX 3.0), Oracle report server 10G, Oracle Web Services and Oracle BPEL

Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors.

Worked with advanced features of 9i such as external tables and merge statements.

Expertise in export and import of data, SQL*Loader, UTL File package.

Creating and managing user tables- namespaces, data types, and data dictionaries.

Designed Conversion and Interface Programs using PL/SQL procedures and packages.

Extensive experience and knowledge in Oracle Forms and Reports, SQL*PLUS, SQL*Loader, SQL Developer, PL/SQL Developer and TOAD Tools.

Analyze data quality and report the anomalies to business users using TOAD.

Extensive experience in all phases of Software Development Life Cycle (SDLC) involving requirement analysis, design, development of client/server, web based and n-tier application.

Experience in Error handling and debugging coding issues and troubleshoot production problems.

SQL Server 2012/2008/2005/2000 RDBMS database development including T-SQL programming.

ETL implementation using SQL Server Integration Services (SSIS)

Possess excellent communication and problem solving skills.

Effective in working independently and collaboratively in teams.

TECHNICAL SKILLS:

RDBMS

Oracle 10g/9i/8i, MS SQL Server 7.0, MySQL

Oracle Tools

Oracle Forms 9i/6i, Oracle reports 9i/6i, SQL *PLUS,

SQL Loader Developer 2000

Programming Languages

C, C++, JavaScript, C#.net, VB.net, ASP.net, SQL, PL/SQL

Scripting Technologies

Java Script

Operating Systems

UNIX, Windows 2000, Windows XP, Windows7

Web Technologies

HTML, JavaScript, ASP.NET, XML, Schemas and Web services

Reporting Tools

Crystal Reports, SSRS

SQL Server Tools

Enterprise Manager, Profiler, SSIS, SSRS

PROFESSIONAL EXPERIENCE:

PL/SQL Developer Mar’16 - Present

ADT Security, Irving-TX

Responsibilities:

Interacted with the Business Analysts understanding the business requirements for the project.

Developed various backend application programs, such as Views, Functions, Triggers, Procedures and packages using SQL and PL/SQL language.

Experience with service architecture and support of information integration applications like informatica.

Worked with development team to support and enhance our Oracle environment consisting of Forms/ADF/Discoverer and other supporting products.

Supported database application support management of large, complex Oracle database running on Oracle 10g 11gon exadata with 11gR2 features for data compression, partitioning.

Designed and developed various custom packages triggers and forms.

Get the latest version of data base objects, Reports and Forms from VSS (Visual Source Safe) and did the required modifications on the top of it.

Worked on Forms6i and Reports 6i and Cygwin environments

Customized AR module as per the customer's requirement using Forms 6i.

Used Ref cursors and collections for accessing complex data resulted from joining of large number of tables.

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

Used ETL for transformations in the source or the target systems. Used ODI Designer tool to design data integrity checks and to build transformations.

Used Oracle 10g developer suite ( Oracle Forms and Oracle reports)

Performed reverse engineering of databases using ODI designer tool.

Responsible for creating and developing highly complex applications using Oracle as back-end

Expertise in design and development of Oracle PL/SQL Packages and Procedures.

Experience in working tools such as Ant, Rational Clear Case, Clear Quest.

Extracted Data from Source systems in Flat files sent via SFTP to our server and then create Data Stores (Staging tables) and Load them in Target tables via Interfaces created in ODI.

Load Dimension and Fact Tables data from source files.

Used ETL for transformations in the source or the target systems. Used ODI Designer tool to design data integrity checks and to build transformations.

Writing SQL reports and scheduling these reports from UNIX scripts.

Performed reverse engineering of databases using ODI Designer tool.

Used oracle APEX for development, code documentation & unit testing.

Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, replication & failover.

Used ODI Security manager for managing users and permissions.

Used ODI Designer in order to generate documentation for the application.

Used various web service standards such as WSDL and XML.

Environment: Oracle 11g,10g, Oracle Data Integrator (ODI),oracle Apex4.2, Rapid SQL 7.6.4, SQL Server Management Studio 2010, PL/SQL, SQL, SQL * Loader, TOAD, Tortoise SVN, UNIX shell scripting, MS Excel.

PL/SQL Developer Jun’15 – Feb’16

Fannie Mae, Herndon, VA

Responsibilities:

Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.

Used ODI Designer tool to design data integrity checks and to built transformations

Responsible for technical design documents.

Designed and developed packages, triggers using PL/SQL in Star Schema.

Developed new and modified existed Oracle scripts.

Database performance tuning using Explain Plan and TKPROF.

Created indexes, Views, constraints.

Involved in developing packages for User Interfaces.

Code optimization using Explain Plan and Process time reduction and analysis.

Worked on objects types and PL/SQL tables.

Extensively worked on PL/SQL Error/Exception handling, Control Structures in PL/SQL.

Support production DBA in daily or emergency procedures to resolve issues.

Worked on SDLC (Software Development Life Cycle) during the period of application development.

Executed Korn Shell Scripts in Production.

Developed data entry forms, complex and template forms in Forms 6i.Creation of Pop-up Menus and maintaining Master Detail relation-ship.

Created and developed Korn shell scripts for calling procedures through UNIX.

Created cron jobs in UNIX and also installed and migrated the jobs to autosys in UNIX.

Created DBLINKS in oracle to connect to the old databases based on Oracle 10g.

Performed daily jobs and procedures and logging the Materialized views for cataloguing and refreshing new data to merge with the old data.

Environment: Oracle 11g, Oracle Data Integrator (ODI),oracle Apex4.2, Tortoise SVN, Rapid SQL 7.6.4, SQL Server Management Studio 2008, PL/SQL, SQL * Loader, TOAD, SQL Developer, SQL, UNIX shell, Perl scripting, MS Excel

PL/SQL Developer Sep’12 – Dec’14

Client: Humana Health Insurance

Sapplica, India

Responsibilities:

Generated Scenarios for Packages to generate the data into flat files (.txt file) and execute the scenarios.

Worked in different areas like Development, UAT and Production.

Co-wrote Test Plan and Created Test Scenarios.

Used ODI to work with Oracle's own database, application server, SOA suite and business activity monitoring software.

Extracted Data from Source systems in Flat files sent via SFTP to our server and then create Data Stores (Staging tables) and Load them in Target tables via Interfaces created in ODI.

Load Dimension and Fact Tables data from source files.

Experience in working tools such as Ant, Rational Clear Case, Clear Quest.

Used ELT for transformations in the source or the target systems. Used ODI Designer tool to design data integrity checks and to build transformations.

Performed reverse engineering of databases using ODI Designer tool.

Involved in Graphical development and maintenance of transformation using ODI designer.

Wrote SQL Queries and developed PL/SQL Packages for data Loading (ETL) purposes.

Worked in different areas like Development, UAT and Production.

Co-wrote Test Plan and Created Test Scenarios.

Used ODI to work with Oracle's own database, application server, SOA suite and business activity monitoring software.

Extracted Data from Source systems in Flat files sent via SFTP to our server and then create Data Stores (Staging tables) and Load them in Target tables via Interfaces created in ODI.

Load Dimension and Fact Tables data from source files.

Experience in working tools such as Ant, Rational Clear Case, Clear Quest.

Used ELT for transformations in the source or the target systems. Used ODI Designer tool to design data integrity checks and to build transformations.

Performed reverse engineering of databases using ODI Designer tool.

Involved in Graphical development and maintenance of transformation using ODI designer.

Wrote SQL Queries and developed PL/SQL Packages for data Loading (ETL) purposes.

Wrote SQL code to create JOINS, VIEWS on various tables.

Worked on migrating some part of the application database from oracle 10g to oracle 11g.

Worked on External Tables and Global Temporary Tables.

Environment: Oracle 9i/10g, Oracle Data Integrator (ODI), Rapid SQL 7.6.4, SQL Server Management Studio 2008, PL/SQL, SQL * Loader, TOAD, SQL Developer, SQL, UNIX shell scripting, MS Excel, Tidal Service.

Education:

Bachelor’s degree in EEE from JNTU University, Hyderabad- India

Contact this candidate