Oracle PL/SQL, SQL, Shell Scripting and informatics developer Resume

SUMMARY

Over all 10 Years Strong Experience in development, support activities in PL/SQL, SQL and Informatica (ETL Workflow and processing)
Strong in Linux and Shell Scripting
Excellent proficient in Query Optimization.
Excellent Domain Experience in ERP (Retail, Manufacturing, Insurance), Repair services, supply chain management(Servigistics)
Worked in Agile and AIM methodology.
Proficient in Oracle Apps Technical (AOL, Concurrent Program, Reports)
Worked on Oracle Cash Management, Receivables, Payables and General Ledger Modules
Experience in Tidal Scheduler Monitoring, CRON.
Attended trainings on C, SQL, PL/SQL, Oracle DBA, COGNOS, INFORMATICA, Order Management, and Functional Training on GL, FA, and CM Modules, SSIS packages
Strong experience in Application Development with knowledge of full software development life cycle
Excellent verbal written communication and problem - solving skills
Expertise in using configuration management tool like SVN,QC and Git for version controlling.
Quick learner & self-directed; consistent updating self with the emerging trends in the industry.
A team player with strong interpersonal skills and possess a flexible and detail-oriented attitude.
Possess strong management, communication & interpersonal skills with appetite for constant improvement.

TECHNICAL SKILLS

Core Expertise: PL/SQL, SQL, Oracle Reports(6i,11g), Oracle Applications, Shell Scripting, Informatica, XML publisher

Database: Oracle 11g,12 C, SQL Server 2012

Domains Expertise: Retail, Manufacturing, Insurance, Parts & Supply chain management, Banking, Health Insurance

Operating System: Windows, Linux

Tools: SQL* Plus, Reports 6i GUI, Toad, SQL Developer, Informatica Power Center, JIRA

Application Server: Oracle Application 11.5.10

Version Control: SVN Tortoise, HP Control Center, GIT

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL, SQL, Shell Scripting and informatics developer

Environment: Unix, Informatica Power Center, TOAD, HP Quality Center and GIT

Responsibilities:

Worked as PL/SQL, Informatica and shell scripting developer.
Analyzing the requirements - designing and developing the maps for extraction, transformation and loading of data into warehouse.
Involved in estimation, analysis, design and coding of the Informatica components.
Leading the offshore team
Performing business validations on the data using PL/SQL procedures.
Responsible of delivery of ETL code
Worked in Performance query tuning.

Confidential, Camp Hill PA

Oracle PL/SQL Developer

Environment: TOAD, JIRA, SVN.

Responsibilities:

Analyzing the reports with DBA's and SQL tuning to maximize performance.
Reviewing requirements in the JIRA for production issues and provides time estimates for task completion.
Develops data-driven solutions to fight fraud, waste, and abuse in Medicare and Medicaid using Complex SQL queries.
Worked on a project team to identify Medicare and Medicaid records that had been mistakenly modified and restore them to their proper state. Re-submitted them to Client/Customer for approval once the records were fixed.
Worked on project team to write PL/SQL procedures to identify Medicaid and
Medicare patients, based on their records, to notify them of important information such as a new drug is available
Created database reports to get open enrollment and enrolled list reports weekly, monthly and yearly
Fine-tuned SQL queries using functional indexes, hints for maximum efficiency and performance.
Supporting all aspects of production, QA, and development Databases on Linux
Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Confidential

Oracle PL/SQL, SQL, Shell Scripting and Informatica developer

Environment: Oracle SQL, Shell Scripting, Informatica Development and HP Tools

Responsibilities:

Confidential

Oracle PL/SQL Developer

Environment: Oracle SQL/PLSQL, Shell Scripting Development

Responsibilities: