PROFESSIONAL SUMMARY:

• 6+ years of IT experience as applicationdeveloper, Database design, Data ware house using Oracle 12c/11g,SQL, PL/SQL, Oracle Data Integration.
• Specialised in Functional Areas of General Ledger (GL), Account Payables (AP) and Account Receiver (AR).
• Good Knowledge on Client - Server application development using Oracle PL/SQL,SQL*PLUS, TOAD andSQL*LOADER,.
• Solid experience in writing complexSQLqueries andPL/SQLprocedures to extract data from various source tables.
• Experience in UNIX Shell Scripts using Korn shell for executingPL/SQLcode and performing other activities in UNIX.
• Experience in creating SSIS packages to automate the Import and Export data fromSQLServer using SSIS tools like Import and Export wizard, Package Installation.
• Experience in PLSQL - Functions, Stored Procedures, Cursors, Triggers and Packages.
• 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 DynamicSQL
• 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
• 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 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 complexSQLcommands.
• Experience in requirements gathering, functional gap analysis, application design, configuration, and module setup, test script generation, writing guides, end users, and production support.
• Self-motivated, flexible, proactive, responsive, goal oriented and rapid learner.
• Experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Support. Worked on Agile and Waterfall Methodology.

EXPERIENCE:

Confidential: New York City, NY

Database Developer- Oracle PL/ SQL

Responsibilities:

• UsedSQL*Loader, PL/SQLprocedures to facilitate data import to staging tables, interface tables and then to base tables.
• Scheduled the execution of PL/SQLProcedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Implemented corporate database backup management policy by automating various kinds of backups using UNIX shell scripts.
• Extensively used the advanced features of PL/SQLlike Records, Tables, Object types and DynamicSQL.
• Gathered data into PL/SQLtables for validating and loaded into Oracle tables using BULK loader utility. Used Materialized Views to simplify data-warehouse summary management and speed query processing at the same time.
• Developed program units for debugging, test the PL/SQLcode and clearing the reports those with validation and settling the reports from day to day basis.
• Used Materialized views in places where the data does not change very frequently. Used Materialized Views to simplify data-warehouse summary management and speed query processing at the same time.
• Extensively used Oracle ETL process for address data cleansing.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector usingOracleBI Presentation Service.
• Usedoracleforms and created various reports usingOracleReports Builder for day to day validations.
• Developed complexSQLqueries to perform the back-end testing of the Oracle database usingSQLand UNIX shell commands.
• Interacted with Business users and Business System Analyst to understand reporting requirements and prepared Functional Requirement document.

Confidential: Jersey City, NJ

Oracle Developer

Responsibilities:

• Involved in understanding of Data models and SRS/mappings documents. Created database views and Procedures based on requirements.
• 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.
• 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.
• Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
• Involved in database migration fromOracle9i to 10g database and generatedoracleforms and reports.
• CreatedPL/SQLStored Procedures, Functions, Packages and Triggers, extensively used cursors, ref cursors, User defined object types, Records inPL/SQLProgramming.
• Involved in Production support for database and User Interface issues within that application.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
• Involved in analysis of the requirements with business users in Coordinating and maintenance of source system owners
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designing and executing the test scripts and test scenarios.
• Involved in developing detailed test plan, test cases and test scripts using PL/SQL.
• Assisted in production of OLAP cubes in SSAS by writing queries inSQLto produce reports Using SSRS.
• Created unit test case scripts for easy testing and tracking. Created test scripts documentation for all the procedures
• Worked on solving the behavioural difference issues between 10g and 11g forms debugging the errors.
• Worked on extending partitions for Production Database. Tested the data in UAT and used to check with Business for Signoff.

Confidential

Oracle Developer

Responsibilities:

• Created Tables, Views, Constraints, Index. Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers usingSQLand PL/SQL.
• Understanding and Mapping Requirements to prepare the Technical design Documents.
• Preparing deliverable documents such as, Technical Design, Unit Test cases and Test results
• Tested and debugged Oracle PL/SQLpackages.
• Created materialized views to enhance the performance with help of DBA.
• Extensively used bulk collection in PL/SQLobjects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction.
• Maintained Subversion code in accordance with company policy.
• Responsible for gathering Business Requirements, creation of Technical design documents and user Documents.
• Involved in production release and support ofPL/SQL, Oracle Forms and Reports.