SUMMARY:

• Over 6+ years of experience in Development of Client/Server applications using Oracle 12c/11g/10g/9i databases/Oracle application tools, Oracle Developer 2000/6.0/6i and RDBMS concepts.
• Expertise in design, development and deployment of end user screens and reports using Oracle tools, Oracle Forms 11g/10g/9i/6i, Reports 11g/10g/9i/6i.
• Strong experience in SQL, SQL*PLUS, PL/SQL, back end programming using Packages, Functions, Stored Procedures, Exception handlers, Views, RefCursors, Record Types, UTL FILE and other built in packages for Oracle 10g/9i/8i and SQL queries/reports and scripts.
• Strong knowledge in RDBMS concepts and extensive experience in creation and maintenance of Tables, Views, Materialized Views, Stored Procedures, Packages, Synonyms, Indexes, Triggers, Bulk Load and PL/SQL programming.
• Expertise in developing complex code units, Database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables).
• Worked on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Analysis, System Analysis & Design, Coding, Unit Testing, Quality Assurance, Project Planning and Documentation.
• Experience in database design, data analysis, data modeling, development, Query Optimization, SQL Tuning, and Trouble Shooting
• Good experience in working with Autonomous Transactions in PL/SQL.
• Experience in working with SQL *Loader, external tables, import and export utilities, extracting and loading large volumes of data.
• Experience in using SQL TRACE tools for Explain Plan, collection of statistics and creation of indexes for database access and indexing the required columns.
• Involved in the issue resolution and Root Cause Analysis.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Well Experienced in doing Error Handling using various log files.
• Strong programming, debugging and problem - solving skills and ability to translate user requirements into specific technical solutions by utilizing business insights.
• Involved in Full Life Cycle Development (Agile) of building a Data Warehouse on Windows and Unix Platforms.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre-& post session operations.
• UNIX shell scripts for automating batch programs, DBMS SCHEDULER and DBMS JOB.
• Experience in using Oracle supplied packages like DBMS JOB to schedule PL/SQL procedures that needs to be performed at periodic intervals; DBMS TRACE to stop and start the PL/SQL tracing, DBMS SQL is dynamic SQL to access the database.
• Experience in customizing standard reports as well as developing custom reports in Oracle Applications using Oracle Reports Builder.
• Broad experience working with Eclipse.
• Designed UML Diagrams, E-R Diagrams using ERWIN and Designer 2000.
• Extensive experience in DDL scripting and WinCVS client.
• Experience in E-R modeling, understanding in developing Database Schemas.
• Extensively involved in release of the complete integrated product in to production and in post-production support which is still on.
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.
• Strong skills in writing technical and functional documents defined by the business requirements

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, Shell Programming, C, C++, Java

Databases: Oracle 12c,11g, 10g, 9i. SQL Server Management Studio 2008-2014.

GUI/ Tools/Utilities: SQL*Loader, TOAD, PL/SQL Developer, DataPump (Import/Export), SQL* PLUS, ERWIN 3.5/4.0, SQL Navigator, MS VISIO, VI Editor, FTP, SFTP, Explain Plan, TKPROF, Microsoft Excel, Microsoft PowerPoint

Operating Systems: Linux, Unix, Windows 7/XP/ NT 4.0/ 2000

Technologies: HTML, XML and Informatica- Power Center

Scripting: Unix Shell Scripting

Reporting Tool: Crystal Reports 9.0, Cognos Reports, Report 6i and 9i, Oracle Reports, Oracle Forms

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Oracle Pl/SQL Developer

Responsibilities:

• Experienced in interacting with Business Users, Business Analyst, Project Managers, and developers to gather requirements and translating requirements to technical design specifications and source to target mappings.
• Designed and Developed database objects like tables, views, indexes, procedure, functions and packages .
• Involved in Performance Tuning , which included creating Indexes, Providing Hints, Modifying Tables, Analyze Tables and Estimate Stats using Explain plan utility, also in changing the existing static report generating Procedures and Packages to Dynamic Procedures to support from multiple schemas.
• Created/modified Oracle procedures, packages and functions to move the change data across multiple environments using Database links .
• Interacted with front end developer and worked accordingly to facilitate report requirements.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse .
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions (SCD) type 2 and type 1.
• Used Debugger to test the mappings and fixed the bugs.
• Used various transformations like Filter, Expression, Sequence Generator, Source Qualifier, Lookup, Router, Rank, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer.
• Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database.
• Developed various mapping by using reusable transformations in Data marts.
• Involved in full life cycle development including Design, ETL strategy , troubleshooting Reporting, and Identifying facts and dimensions.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width and Delimited) to staging database and from staging to the target Warehouse database.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. If the session fails debug the Mapping.
• Involved in testing Unit and integration Testing of Informatica Sessions , Batches , fixing invalid Mappings
• Defined the program specifications for the data migration programs , as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Built the Informatica workflows to load table as part of data load.
• Wrote Queries, Procedures and functions that are used as part of different application modules.

Environment: Windows, Oracle 12c, Informatica Power center, Workflow Monitor, TOAD, Erwin, Oracle SQL, PL/SQL, SQL Developer, MS Visio

Oracle Pl/SQL Developer

Responsibilities:

• Completed Training certificate on “Safeguarding and Identifying PII (Personally Identifiable Information) & PHI (Protected Health Information)”.
• Identified duplicate data entries in database using Oracle PL/SQL queries which involved figuring out alphanumeric ranges.
• Developed Oracle SQL queries to update procedure code as per various requirements requested by the Senior Analyst.
• Setup Cron job- shell scripts to trigger mails to team lead and application analyst in developer environment of the server and provided procedure documents for deployment in SIT and PROD.
• Working on Problem Statements which involves CAMMIS (California Medicaid Management Information System) TAR system server to fix the data integrity between Oracle database and data mart to retrieve the missing Business objects reports.
• Created Database change tickets in UNIX server to update or completely delete TAR numbers as per request from client.
• Responsible for supporting code deployment which is done using Jenkins
• Created a report in reference with Treatment authorization request numbers for irregular pattern of processed and returned claims which involved life cycle data analysis on multiple reversals of claims.
• Provided analysis on Table Sizes of various applications of Oracle databases for requesting DB refresh from PROD to SIT or DEV from.
• Report Oracle Database locks upon request by team lead.
• Worked on AUDITS of Oracle Database which involved complex SQL joins queries to acquire data from various tables and schema.
• Submitted report for Consults, to provide data from Oracle database to CA-MMIS (California Medicaid Management Information System).
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Worked with bulk collect to implement the performance of multi row queries.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas Set up E-mail alert notification in SQL Server database using T-SQL script for manager and Mid-range analyst as per request from California DHCS (Department of Health Care and Services).
• Setup Database Mail Profile in SQL Server Management Studio for operations team to get updates on specific tables once updated.
• Turned logging for SSIS (SQL Server Integration Service) package OnError, OnPostExecution, OnTaskFailed using SQL Server Business Intelligence Development Studio.

Environment: Oracle 10g, SQL, PL/SQL, MS Access, UNIX Shell script, TOAD, UNIX, Jenkins, Windows XP/2000, SQL Server Management Studio ‘08,’14.

Oracle PL/SQL Developer

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination
• Worked with Agile/Scrum team to deliver software projects and products.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Helped in maintaining the databases and also worked with production support team to solve tickets and debugging issues. Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Generated various analytical reports using MicrosoftAccess.
• Migrated XML data to Targeted files using ETL tools in Data warehousing.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.

Environment: Oracle 10g/9i, Oracle SQL Developer Data Modeler, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, UNIX, Windows XP/2000

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Developing and handling the PL/SQL Packages, Procedures, Functions and Database Triggers.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24-hour production support.
• Supporting legacy systems with backups of all cases to/from parallel systems.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Developed automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Worked with a team which Upgraded Oracle DB 8i to Oracle 10g.
• Used Various Database administrative tools such as Oracle Enterprise Manager, Erwin, Toad DBA Tools, and Data Migration Tools.
• Created Shell scripts to generate oracle reports and send to e-mail.
• ER diagrams are developed using TOAD Data Modeler.
• Used iExpense EBS to enhance standard Oracle flows for order to cash, procure to pay, inventory, credit card transactions and GL accounting processes for this rapidly growing specialty retailer that handles over 1,000 transactions per day. Implemented automatic bank reconciliation functionality in CM and auto lock box functionality in AR.
• Which in turn helped in improved inflows and outflows, facilitating discounts from vendors for bulk purchases and early payment without tapping a short-term line of credit.
• Involved in creating Cron jobs and Korn Shell scripts for running the daily loads.
• Involved in creating and maintaining Partitioned Tables and Indexes for better performance of application
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
• Involved in handling the changes in compiling scripts according to the database changes.
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

Environment: Oracle 10g, Toad, SQL * Loader, Toad, Oracle Enterprise Manager, Erwin, SQL*PLUS, UNIX Shell Scripting, Oracle Reports, HTML, XML, Informatica.

Confidential

Jr. Oracle Developer

Responsibilities:

• Involved in Database Design and Analysis.
• Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 10g.
• Created Control Files and used SQL* Loader to upload bulk data into database from external files.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages
• Involved in Code Standardization and Documentation.
• Involved in Logical and Physical Database design. Identified the tables and relationship between tables.
• Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
• Involved in database Performance Tuning and monitoring.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Developed complex triggers in reports before/after for validation of user input.
• Coordinated between management, users and technical teams for Requirement Gathering

Environment: ORACLE 11g/10g, Reports 9i, PL/SQL, SQL Loader, SQL*plus.