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 teh 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 teh business prerequisites
• me have performed data visualization wif teh help of Tableau.
• Tableau is an interactive tool helped me in designing dashboards which helped me in increasing expressions in teh 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 teh 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 teh application.
• Involved in Production support for database and User Interface issues wifin that application.
• Analyzing teh code to understand teh transformation and business logic applied.
• Worked for CRDB (Credit Risk Database).
• Involved in analysis of teh 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 teh 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 teh 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 teh procedures.
• Worked on solving teh behavioral difference issues between 10g and 11g forms debugging teh 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 teh changes to UAT.
• Tested teh data in UAT and used to check wif Business for Signoff.
• Responsible for creating teh Change requests and prepare all teh documentation required to move teh code changes to production.
• Involved wif QA team while testing teh data and helped them incase if they need any help.
• Participated in weekly status meetings to update teh status of work.
• Used to understand teh business from application level to work on teh incidents.
• Worked as L3 lead for supporting teh 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 teh ETL process to extract data from various sources including live system and external files, cleanse and then 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 teh security threats on teh source code using Check Marx tool
• Configure monitoring using Zabbix and Grafana to monitor teh 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 teh adhoc and routine issues from teh business users.

Informatica Developer

Confidential

Responsibilities:

• Coordinated wif teh front - end design team to provide them wif teh necessary stored procedures and packages and teh necessary insight into teh 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 teh data from staging area to data mart.
• Created indexes on teh tables for faster retrieval of teh 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 teh data from teh 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 teh fact tables and materialized views to enhance teh performance.
• Extensively used bulk collection in PL/ SQL objects for improving teh 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 teh advanced features of PL/ SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application

Informatica Developer

Responsibilities:

• Involved in teh analysis, design, development and testing phases of Software Development Life Cycle (SDLC)
• Gatheird teh business requirements from teh 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 teh 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 teh data from teh flat files to teh database and validated teh data wif teh PL/ SQL procedures.
• Created dbms scheduler jobs to run teh hourly, daily loads for each application.
• Worked wif DBA support to monitor teh 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 teh changing needs of teh project and client requirements.
• Worked extensively in UNIX shell scripting to load teh data into teh 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.