SUMMARY

• 4 years of IT experience as application developer, Database design, Data warehouse using Oracle 12c/11g, SQL, PL/ SQL, Oracle Data Integration. extensive experience wif eBusiness Suite/ Applications - Performing functional and technical work mainly wifin the Inventory (INV), Purchase Order (PO), Order Management (OM) and Account Payables (AP), Account Receivables(AR) of Oracle Applications 11i and R12.
• Experience in PLSQL - Functions, Stored Procedures, Cursors, Triggers and Packages.
• Experience in all phases of SDLC including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Experience in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Proficient in advance features of PLSQL programming like Records and Collections, Bulk load, Bind variables, Ref Cursors and Dynamic SQL
• Good Knowledge on Client-Server application development using Oracle PL/ SQL, SQL *PLUS, TOAD and SQL*LOADER
• Experience in designing, modelling, performance tuning and analysis, implementing process using ETL tool data Integration tool for data extraction, transformation and loading process.
• Good experience in UNIX and Perl scripts to create reports and logs based on the business prerequisites
• me have performed data visualization wif the help of Tableau.
• Tableau is an interactive tool helped me in designing dashboards which helped me in increasing expressions in the presentation.
• Experienced in Troubleshooting and Maintenance of Database Objects
• Good experience in Test Case Preparation, Test Case Execution, Bug Reporting and Bug Fixing
• Extensive experience of working in different environments like Unix and Windows
• Worked extensively on PARTITIONS to enhance query performance.
• Worked in Agile Methodology.
• Worked on version control tools such as GitHub, Tortoise SVN and used JIRA bug tracking tool.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Experience in Back ends Testing of the applications by executing complex SQL commands.
• Experience in requirements gathering, functional gap analysis, application design, configuration, and module setup, test script generation, writing training guides, training end users, and production support.
• Good experience in working Onsite - Offshore Model.
• Self-motivated, flexible, proactive, responsive, goal oriented and rapid learner.
• Good team player wif excellent Communication, Presentation and Interpersonal skills.
• Experience in using Automation Scheduling tools like Tidal, Autosys and Control-M.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Excellent communication, interpersonal skills, enthusiastic, quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS

Languages/Tools: Toad, PL/ SQL Developer, SQL*Plus, SQL*Loader, SQL Developer

ERP: Oracle Applications 11i/R12

GUI/Reporting Tools: Tableau Forms 6i/10g/11g, Reports 6i/10g/11g

Databases: Oracle 12c/11g/10g/9i/8i, Sql Server

Operating Systems: Windows

Web Tools: JCI, UNIX Shell Script, Perl

PROFESSIONAL EXPERIENCE

Pl/SQL & ETL Developer

Responsibilities:

• Interacted wif Business users and Business System Analyst to understand reporting requirements and prepared Functional Requirement document.
• Involved wif Users for resolving Production issues related to the application.
• Involved in Production support for database and User Interface issues wifin dat application.
• Analyzing the code to understand the transformation and business logic applied.
• Worked for CRDB (Credit Risk Database).
• Involved in analysis of the requirements wif business users in Coordinating and maintenance of source system owners.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Involved in understanding of Data models and SRS/mappings documents.
• Created database views and Procedures based on requirements.
• Designing and executing the test scripts and test scenarios.
• Involved in developing detailed test plan, test cases and test scripts using PL/ SQL.
• Experience in handling Checkpoints, Logging, Error handling by using Event Handler and
• Custom Logging for integrator Packages.
• Experience in creating SSIS packages to automate the Import and Export data from SQL Server using SSIS tools like Import and Export wizard, Package Installation.
• Assisted in production of OLAP cubes in SSAS by writing queries in SQL to produce reports
• Using SSRS.
• Created various dashboards and reports using SSRS and Power BI for Data visualization.
• Performed data validation to check all business rules and requirements are met.
• Created unit test case scripts for easy testing and tracking. Created test scripts documentation for all the procedures.
• Worked on solving the behavioral difference issues between 10g and 11g forms debugging the errors.
• Worked on extending partitions for Production Database.
• Supported L2 team in case of batch issues or long running jobs.
• Had War Rooms wif business users after deploying the changes to UAT.
• Tested the data in UAT and used to check wif Business for Signoff.
• Responsible for creating the Change requests and prepare all the documentation required to move the code changes to production.
• Involved wif QA team while testing the data and helped them incase if they need any help.
• Participated in weekly status meetings to update the status of work.
• Used to understand the business from application level to work on the incidents.
• Worked as L3 lead for supporting the application and used to involve in meetings wif User's.
• Performance tuning of existing Oracle forms as well as newly created Oracle forms using different built - in as well as User-defined functions and procedures.

Informatica & PL/SQL Developer

Confidential, PA

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Participated in Design & Development of database objects which includes creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Worked wif multiple business / reporting team and developed dynamic SQL, complex SQL queries using joins, sub - queries and inline views to address reporting requirement.
• Created materialized views using different clauses like FAST, COMPLETE, and FORCE, ON COMMIT
• Used Pentaho Data Integration/Kettle to design the ETL process to extract data from various sources including live system and external files, cleanse and tan load data into target data warehouse.
• Created jobs and transformations using Table input, Table output, Text file output, CSV file input, Insert/Update, Filter, Value Mapper, Stream lookup, Database lookup, Merge, Sort and Set Environment variables.
• Wrote UNIX and Perl scripts for file validations, jobs, generate logs and reports.
• Execute static code analysis, generate reports and remediate the security threats on the source code using Check Marx tool
• Configure monitoring using Zabbix and Grafana to monitor the application and create alerts.
• Perform production support and identify potential applications and systems which are at risk to plan and implement necessary contingency and mitigation plan.
• Worked in a scrum Team and followed agile framework to develop applications. Agile methodologies like Sprint planning, sprint retrospective, daily stand up were part of work.
• Provide solution to the adhoc and routine issues from the business users.

Informatica Developer

Confidential

Responsibilities:

• Coordinated wif the front - end design team to provide them wif the necessary stored procedures and packages and the necessary insight into the data.
• Generated server-side PL/ SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/ SQL triggers and master tables for automatic creation of primary keys.
• Created PL/ SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/ SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Created PL/ SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/ SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/ SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
• Extensively used the advanced features of PL/ SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application

Informatica Developer

Responsibilities:

• Involved in the analysis, design, development and testing phases of Software Development Life Cycle (SDLC)
• Gatheird the business requirements from the data analysts and architects and performed technical analysis to provide viable solution.
• Translated user requirements into data flows, detail technical specifications and database requirements.
• Created and managed primary database objects such as Tables, Views, Indexes, Sequences and Synonyms.
• Designed and developed PLSQL Functions, Procedures, Cursors, Triggers and Packages.
• Created Records, Tables, Objects, Collections and Exceptions extensively in coding.
• Tuned SQL for the maximum efficiency in various schemas across databases using Oracle Hints, plans and Trace sessions for Cost based and Rule based Optimization.
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data wif the PL/ SQL procedures.
• Created dbms scheduler jobs to run the hourly, daily loads for each application.
• Worked wif DBA support to monitor the performance and configure alerts using Oracle Enterprise Manager (OEM).
• Involved in Unit test, Integration test and writing test plan.
• Created and modified several UNIX and Perl scripts according to the changing needs of the project and client requirements.
• Worked extensively in UNIX shell scripting to load the data into the staging tables through SQL* Loader handling multiple files.
• Extensively worked on Autosys, Control - M and Batch scheduling tools to handle ETL jobs.
• Worked wif version control tool such as Tortoise SVN, GitHub and used JIRA bug tracking tool.
• Responsible for Troubleshooting back end UAT and Production issues.
• 24/7 production support and involved in implementation of coding standards and database change requests
• Involved in Project Planning and scheduling, System Design, Functional Specification, Design Specification, preparation of impact analysis, Coding, System Test Plan, Testing, code review, coordinating user testing and user training, Project demonstration and Implementation.

Environment: Windows, Oracle 11g, SQL, PLSQL, PLSQL Developer, TOAD, Putty.