Post Job Free

Resume

Sign in

Developer Data

Location:
Ashburn, VA
Posted:
February 01, 2019

Contact this candidate

Resume:

SUMMARY

* ***** ** ** ********** as an Oracle Developer.

Strong Knowledge in complete Software Development Lifecycle (SDLC) using Oracle 12c/11g on Windows and UNIX platforms in the phases of Analysis, Designing, Development, Production support and Testing.

Experience in gathering the requirements, writing Technical design documents and developing unit test documents and analyzing the System Requirements.

Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database 12c,11g.

Extensively worked in creating, debugging and testing Procedures,Functions, Materialized Views, indexes, Compound Triggers and Packages and Table Partitioning using advanced PL/SQL and SQL *PLUS.

Expertise in working with built-in packages like DBMS_SCHEDULER, UTL_FILE.

Worked with data transformations and loading using SQL* Loader and also created external tables to manage data which is stored at the operating system

Extensively worked with collections to reduce the overhead and improve the performance using bulkcollect and bulkbind.

Used Global temporary tables to maintain session data and improved the performance of data retrieval by creating views, indexes, and triggers on them.

Experience in Oracle performance related features, such as Query Optimizer, Execution Plans, Indexes and Pipelined table functions for faster execution.

Good understanding of database administration tasks such as implementing relationships, handling security issues, granting and revoking privileges on database objects, importing and exporting data files into oracle.

Familiarity with Oracle data warehousing features such materialized views, bitmap indexes, Index Organized Tables, external tables etc

TECHNICAL SKILLS

Operating System: Windows,Unix.

Languages: C, SQL,PL/SQL.

Databases: Oracle 10g/11g/12c

Database Utilities: Data Pump, Export/Import, SQL Loader,utl_file

Performance Tuning : DBMS_STATS, DBMS_XPLAN,

TKPROF, SQL Trace, Explain Plan, Partitioning,

Materialized Views/Snapshots

Database Tools: SQL Developer, Toad,Oracle Apex

Code Maintenance Tools : IBM Clear case, TIVOLI, Tortoise SVN.

Data Modeling : Erwin 4.3,7.1,7.3,Toad

Other Tools : ALM, Version One

CERTIFICATIONS

ITIL CERTIFIED

EDUCATIONAL QUALIFICATIONS

MCA, Computer Information Systems, Osmania University, Hyderabad, AP, INDIA Aug/04.

BSc Computer Science, Osmania University, Hyderabad,AP, INDIA Apr/01.

CLEARANCE

Public Trust, 11/14, Active

VISA STATUS :

US CITIZEN

PROFESSIONAL EXPERIENCE

Company :-Salientcrgt, Chantilly,VA Nov’2014– TILL DATE

Client :-USPS

Technologies :- Oracle 12c, Unix, Toad,SQL Developer,Oracle Apex

Role: Oracle Developer

Working as a developer in eAccess. eAccess is a portal for requesting applications and resources in the Postal Service. Key functions that were implemented are:

•AD Integration

•Unix Integration

•LMS Integration

•PCI eAccess Implementation

Worked as a developer in Postal One Reporting team, which is a subsystem of USPS. Team maintains PO! Mailing reports that can detail out statements that were finalized at a given finance unit, and daily based financial reporting to internal BMUE user. Also maintains additional postage due reports for QBRM, seamless and full service mail entry errors. Mailers have access to verify verification assessment results and pay/dispute the additional postage assessments.

Oracle Developer Responsibilities:

Developed Materialized view according to reports Requirement. We used DBMS_MVIEW Package to refresh the data.(Full/Fast).

Developed programs using Collection for better performance (Associatve arrays,varrays,nested tables).

Developed programs using Bulk Binding .

Developed programs using Global Temporary Table (GTT).

Developed programs to transfer query result set from plsql program to screen using Cursor Variables(Ref_cursor).

Used External table Feature to transfer data from files to target databas.

Developed Procedure and package using Dynamic sql.

Wrote quries using Analystical functions.

Developed new tables, views, stored procedures, triggers, indexes, roles.

Database integrity testing by executing SQL statements.

Tunning SQL using Explain plan,SQL Trace and TKPROF.

Adding new Partition,Merging and droping partitions according data retention Polacy.

Gathering Statistics using DBMS_STATS Package.

Developed Programs to archive or purge the old data according data retention Policy.

Developed programs to send mails about the archival process status using UTL_SMTP Package.

Used DBMS_RANDOM Package to generate test data to test performance of queries.

Generating scripts for all the changes using Erwin. Preparing the Data Dictionary.

Incorporating all the changes in Data Model Using Erwin Tools.

Creating Subject Areas according to Business Areas.

Creating Logical Model and Physical Model of the Business.

Reverse engineer the Exisitng Schemas and createing subject area according business requirements

Generating comparison report between Prod Model and other Environment.

Reviewing the scirpts.

Developed programs to Automate archive process according to Retention period.

Developed programs to generate automated script for adding Partitions.

Developing program to automate export the Backup tables and partition using DBMS_DATAPUMP package.

Developed programs to do the online redefinition of tables using DBMS_REDEF Package.

Used DBMS_PROFILER Package to tune plsql programs .

Company :-CNSI Apr’2013– Oct’2014

Client :- Department of Social and Health Services

Technologies :- Oracle 12c, Unix, Toad,SQL Developer,SQL,PLSQL

Role: Oracle Developer

CNSI is a IT consulting and development company had been awarded the MMIS projects for Maryland State. The Medicaid Enterprise Restructuring Project (MERP) is a complex Major Information Technology Development Project (MITDP). It will include the design, development and implementation of a replacement Medicaid Management Information System (MMIS) Operations to modernize existing systems and significantly enhance the existing business goals of the MMIS, ensuring that eligible individuals.

The new system will replace the current system developed more than 30 years ago. Once implemented, the new system will be owned and operated by the state of Maryland.

The new system will enable the state to better manage Medicaid operations and will serve over 102,000 Medicaid recipients in the state of Maryland..

Oracle Developer Responsibilities:

Developed tables, views, stored procedures, triggers, indexes, rules, defaults, and user-Defined data types.

Developed Master-Detail relationships and joined tables using primary and foreign Key relationships.

Database integrity testing by executing SQL statements.

Evaluate and monitor the database to resolve performance issues.

Created database objects such as tables, views, synonyms, indexes, sequences and Database links as well as custom packages tailored to business requirements.

Responsible for creating indexes, synonyms, database triggers, primary keys, foreign Keys and constraints.

REFERENCES: Available Upon request .

ANITHA BATHINA

Mail Id :ac8c7k@r.postjobfree.com

Phone No: 571-***-****



Contact this candidate