SUMMARY

• Oracle Developer and Engineer with 6 Years of experience in Oracle 11G/10G, PL/SQL, Logical/Physical Data Design, Application Support, Oracle Performance Tuning and Optimization.
• Experience in writing complex SQL, PL/SQL Functions, Stored Procedures, Packages, Triggers, Collections, Ref cursors, SQL & PL/SQL scripts, Ad - hoc queries etc.
• Over 5 years of Experience in strong Data Warehousing usingInformaticaPower Center (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer),InformaticaPower Mart, Power Center.
• Experience in usingInformatica(Power Center) for implementation ofETLmethodology in Data Extraction, Transformation and Loading.
• Created several jobs in Tidal to scheduleInformaticaworkflows as per business requirement.
• Excellent understanding of Software Development Life Cycle (SDLC), requirement analysis, design document, implementation, review specification, testing and maintenance of applications.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources usingETLprocesses and providing data mining features for DWH.
• Involved in Full Life Cycle Development of building a Data Warehouse and Business Intelligence concepts with emphasis onETLusingInformaticaPower Center (Repository Manager, Designer, Workflow Manager for scheduled workflows and Workflow Monitor).
• Extensive experience in writing UNIX shell scripts and automation of theETLprocesses using UNIX shell scripting.
• OracleADFconsulting in-depth experience in designing, implementing, documenting, and maintaining highly complex and scalable software applications.
• Reputation for delivering robust and reliable software products within very demanding deadlines.
• Considerable experience in Health care, Banking, Finance and Airline industry.
• Extensive experience in design, ADFapplication development deployed usingWeb logic application server, good experience in database programming using Oracle 10g/11g, and server.
• Involved in Design, development, implementation, testing, support and documentation of custom business applications using Oracle technologies.
• Involved in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production.
• Facilitate and manage new projects utilizing SDLC standards. Work with business users to document and re-engineer business processes.
• Strong analytical and conceptual skills in database design and development in client/server applications.
• Excellent customer relationship, facilitation, organization and problem solving skills.
• Experience in designing and developing forms, reports and automated workflows.
• Communicate with the business users and/or functional team to identify, analyze, and translate business needs into functional specifications.
• Migrated large data between different data sources to Oracle databases.
• Designed the database along with the team and UI design as per design documents.
• Implemented solutions in Data Warehouse (OLAP), OLTP and Hybrid environments.
• Strong troubleshooting and organizational skill.
• Designed PL/SQL procedures and packages to connect to JAVA for front-end and very good knowledge about Object Oriented Programming (OOP).
• Hands on experienced in Tuning SQL Statements using Execution Plan, HINTS, TKPROF.
• Proficiency in solving issues after an application release in production.
• Strong knowledge on information systems, automation tools & automated workflows.
• Capable in leading a team by providing them direction, knowledge transfer and assistance in work.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Involved in all phases of the Software development Life Cycle (SDLC) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Create team specific agile process flow in JIRA to move tasks from one activity to another.
• Providing continuous support and resolving queries raised by the end users in all locations.
• Excellent communication, interpersonal, analytical skills, Problem solving skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 11g/10g, My SQL, MS SQL Server 2008, MS Access, DB2 400, SQL, PL/SQL, UML, RDBMS Concepts

REPORTING Tools: Oracle reports 11g/10g/9i, Crystal Reports

Tools: Oracle SQL Developer, PLSQL Developer, SQL*Plus, SQL* Loader, Oracle reports 11g/10g/9i, TOAD, Oracle Enterprise Manager, Cognos, Discoverer, HP PPM.

Scripting: UNIX shell scripting, Java Script

Operating Systems: Windows NT/2003/2008R2/2012/2014, Linux, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Oracle Developer/Analyst

Responsibilities:

• Requirements gathering from Business Analysts and end users.
• Responsible for developing database objects - Functions, Stored Procedures, Packages, Cursors, Triggers, Tables, Views etc.
• Maintain 10gADFapplication by fixing the defects and enhancements.
• Migrating 10g application to 11g and deployed in latest web logic servers.
• Participating daily scrum team meetings, and direct interaction with the users to discuss business requirements.
• Preparing the High-level design document for each modules.
• ETL/ Data Warehouse experience, preferably with SQL Server/TSQL.
• Excellent knowledge onInformaticaPower Center development.
• Designed theETLspecification documents to gather existing workflows information from differentETLteams and shared with Integration and production maintenance team.
• Designed theETLruns performance tracking sheet in different phases of the project and shared with Production team.
• Worked along with theInformaticaprofessional to resolvedInformaticaupgrade issue.
• Design and developed user interface components usingADFRich Faces.
• Developed UI fragments, templates and bounded task flows using JDeveloper 11g.
• Worked on tickets to fix the application issues reported by the end users.
• Highly worked on level-2&3 escalated/elevated tickets to clear the issue on time.
• Optimizing the performance using PL/SQL table types, record types and Hints.
• Worked on table partitioning and index creation for the performance improvement.
• Developed SQL& PL/SQL scripts for Extraction, transformation and Loading of Data and designed source Entities for Oracle.
• Provide support for the application and infrastructure including troubleshooting, performance tuning.
• Created UNIX Shell scripts to automate workflows, Batch Jobs and Loading Process.
• Created physical and logical data model by using Microsoft Visio.
• Modified existing data model according to the requirements provided by Business Analyst.
• Performed data analysis and data clean ups and prepared weekly, biweekly & monthly reports.
• Created some Custom reports and Forms for the end users to check the details and errors.
• Involved in writing Test Cases and Unit Analysis and Testing (UAT) to test each and every issue reported before the fix deployment.
• Extensively wrote the SQL queries to develop test data for use during test execution.
• Involved in the preparation of Technical Specification Documentation.
• Analyzing the performance of the SQL queries and created the scripts for indexes.
• Used Explain Plan, SQL Trace, TKPROF, Indexes, and Hints etc to improve the Performance of the code.
• Used Document Imaging Software to manage files in electronic format.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Create team specific agile process flow in JIRA to move tasks from one activity to another.
• Coordinated with Business Analysts in meetings to analyze the requirements and explore potential solutions.
• Involved in daily status meetings with the development team and project managers to resolve technical and application issues.

Environment: Oracle 11g, WINDOWS 7, UNIX, SQL, PL/SQL, PL/SQL Developer, SQL*Plus, Forms/Reports 11g, Crystal reports, Oracle SQL Developer, JIRA, HP PPM.

Confidential, Concord, CA

Oracle Developer

Responsibilities:

• Created packages and stored procedures to load data from staging tables into transaction tables.
• Created triggers to auto generate the load date and time when the data got loaded into the staging table.
• Created views, materialized views, tables, functions to meet business requirement.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Extracted data from transaction tables as well as loaded data onto the transaction tables from excel sheets, files.
• Worked in development, QA as well as production environment.
• Developed and modified a number ofFormsand Reports for various modules.
• Worked on data validation and data cleansing between different sites and the back end.
• Tuned and optimized SQL queries as and when required to improve the performance of the tool.
• Used various join conditions in SQL query to create views, tables, and materialized views in an efficient manner.
• Participated in the migration of the tool from development to production and supported the issues which occurred due to migration.
• Handled large sets of data which contained more than 3,000,000 rows
• Performed unit testing on various modules involved in the application.
• Added various files to the Mercurial version Control by using UNIX Shell Script and created a directory in UNIX to store the version control files.
• Created back up files in mercurial version control by using UNIX shell script.
• Worked on Oracle Discoverer to perform automation scheduling and created scheduling reports.
• Involved in data analysis and data clean ups and prepared monthly reports.
• Created customized job intervals using DBMS JOBS to start and stop at specified intervals
• Worked on enhancing and tuning SQL Queries.
• Prepared technical design/specifications for Data Extraction, Data Transformation, Data Cleansing and Data Loading.
• Involved in meetings with Business Analysts and end users on application issues for gathering the requirements and communicating the same to development teams.
• Implemented agile development practices according to the application requirements.
• Actively involved in team meetings both on and offshore.
• Create team specific agile process flow in JIRA to move tasks from one activity to another.
• Wrote scripts to merge data from one system to another system.
• Communicated with Business Analysts to gather the requirements and essential enhancements, and ensure alignment with development teams.
• Coordinated with the team in the daily status meetings to check the status and report the same to the project manager.

Environment: Oracle 11g, SQL Developer, SQL*PLUS, PL/SQL, Oracle Forms/Reports 11g, Crystal reports, JIRA, Mercurial Version Control, Oracle Discoverer, UNIX, Windows.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Coordinated with DBA in creating and managing table, indexes, table spaces, triggers, database links and privileges.
• Implemented physical database models with Oracle 10g and developed stored procedures, packages and created functions, triggers using Oracle PL/SQL.
• Identified and documented attributes for entities and defined domain for all attributes.
• Develop and review deliverables including requirement, design and test documents Collaborate with functional and technical teams to resolve technical database related issues.
• Prepared and documented the Technical Design according to the business requirements.
• Prepared technical design/specifications for Data Extraction, Data Transformation, Data Cleansing and Data Loading.
• Worked in “Software As A Service” (SAAS) architecture, to design and develop the applications business logic in the Oracle 10g/11g databases
• Review of the performance testing results and providing input to the testers or Production support team.
• Supported the testing team with Defect Management, Requirement Analysis and SQL development for back-end and regression testing.
• Directly involved in process improvement plans and implementing business change
• Extracted data from various sources performed Data transformations and loaded the data from the various sources into the target Oracle database using SQL*LOADER.
• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers with extensive use of cursors, complex joins, date functions and string handling functions to implement business rules into the application.
• Created complex PL/SQL packages for business operations using various PL/SQL records and collections.
• Wrote complex SQL & PL/SQL scripts for database object management and space management (to rebuild indexes/tables) and reporting packages.
• Testing of production fixes in the test environments to ensure they have resolved given issue as well as ensure production fixes do not cause other application issues.
• Participated in designing and development of software using agile development practices.
• Create team specific agile process flow in JIRA to move tasks from one activity to another.
• Actively involved in preparing training document for application development and QA, UAT teams.
• Was part of daily stand up meetings and weekly project progress meetings with the project manager and the development team

Environment: Oracle 10g/11g, SQL Developer, SQL*PLUS, PL/SQL, Oracle Forms/Reports 10g, Crystal reports, JIRA, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Analyzing the requirement specifications.
• Created PL/SQL scripts at the database level for the new objects.
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Developed several Oracle Stored Procedures.
• Developed PL /SQL code for updating payment terms.
• Generation of Reports to suit the functionality.
• Created reports driven by stored procedures.
• Was part of daily status meetings and project progress meetings
• Proficient in debugging PL/SQL packages, procedures, functions, triggers, cursors, materialized views to troubleshoot application issues.

Environment: Oracle 9.0/9i, Developer 2000(Forms 4.5, Reports 3.0), SQL*loader, Oracle Forms/Reports 9i, TFS.