Oracle PL SQL Developer Resume

SUMMARY:

Tech Project Lead with experience in building complex scripts and queries in PL/SQL.
8+ years of experience in IT with in - depth understanding of all stages of software development life cycle (SDLC) and AGILE methodologies.
Currently working as an Oracle PL/SQL Developer for Confidential of California group since February 2016.
Trained in Unix shell scripting, Oracle, and Hadoop - Big data.
Experienced in industry domains: Capital Markets, Finance and Health care.
Experience entails improvements to process quality and providing system automation recommendations and strategies to manage solutions and data efficiently.
Ability to liaison with business team and maintain working relationships at all business levels.

TECHNICAL SKILLS:

Languages: Oracle SQL, PL /SQL, UNIX shell scripting, XML

Database: Oracle 9i, 10g, 11g, 12c, SQL server, Sybase

Tools: and Utilities: TOAD, Perseus, SAS DataFlux, Tidal, $U

Version Control Tool: Tortoise SVN

Data Skillset: HBASE, PIG, HIVE, Python, Informatica

Reporting Tools: BIRT, JASPER reports

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL SQL Developer

Responsibilities:

Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management.
Worked on Oracle procedures, Informatica coding and Facets application
Involved in Analysis, Coding, Testing and implementing code changes/enhancements to new & existing processes as per Business

Confidential

Project Lead

Responsibilities:

Worked on Sybase procedures and Temp tables for data analysis and report generation
Involved in Analysis, Coding, Testing and implementing code changes/enhancements to new & existing processes as per Business requirements.
Responsible for delivering project milestones in AGILE model
Worked in JIRA for weekly sprint and created user stories to fulfill quality gaps in report

Confidential

Analyst and Project Lead

Responsibilities:

Supported all production operation activities, with focus on integration and development of new and existing products and services.
Monitoring and resolved daily exceptions through the ETL process stages.
Developed methods for application data quality check.
Served as a first point of contact for user exceptions and saw them through to resolution.
Liaised with project management and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.

Confidential

Oracle Developer

Responsibilities:

Analyzed the logic written in SQL Server for Ittencore to migrate to oracle.
Coordinated with team for translating business requirement to SQL logic.
Migrated the code written in SQL Server 2005 to oracle 10gR2 and made the product compatible with Oracle database.

Confidential

Oracle Developer

Responsibilities:

Developed functions in PL/SQL and written scripts for generating XML to validate against the given XSD and automated the process in UNIX shell scripting.
Developed reports in Jasper report and worked on project estimation for new projects.

Confidential

Oracle and BIRT report developer

Responsibilities:

Co-ordination with onsite to understand the requirement for the product release for BIRT integration.
Preparing the technical document specifying the design and code logic co-related with business.
Developed scripts and packages in PL\SQL for BIRT report to integrate with RRM product.
Developed the report design in BIRT reporting tool to view the report through application.