SUMMARY:

• Oracle certified associate with MS in Information Systems with 5 years of progressive experience in software development for Database solutions in various geographical locations. Proven hands - on experience as technical consultant for front end and back end solution development using various Oracle tools for ERP implementation, client server application development and ETL projects using Oracle tools and Microsoft visual studio. High proficiency in writing PLSQL codes, tuning SQL queries and writing Unix scripts along with designing front end using Oracle Forms and Reports and BI publisher tool.
• I am in search of a full time position as Oracle developer to utilize my knowledge and experience effectively and efficiently.

TECHNICAL SKILLS:

Programming languages: C, C++, JAVA, UNIX Shell Scripting, SQL, PLSQL, SQL Advanced analytical functionsT-SQL, HQL

Tools: /Utilities/IDE:ORACLE - Oracle Forms and Reports builder 10g, 11g, Oracle BI Publisher/XML Publisher, ODI, OBIEE, Oracle EBS 11i ORACLE Utilities - EXPLAIN PLAN, ASH, AWR reports, SQL tuning, Dynamic SQL, EXPDP, IMPDP, Materialized view, SQL Loader, UTL file, Partitioning, GTT MICROSOFT - MS SSMS, SSIS, SSRS, Microsoft Visual Studio, MS Office, MS ProjectMS VISIO DB IDE - TOAD, SQL*Plus, SQL Developer, MySQL Workbench OTHERS - TIDAL, CRONTAB, JIRA, IBM WATSON, ERWIN, ECLIPSE, Crystal Reports

Databases: Oracle 10g, 11g, 12c, MS SQL server, MySQL, MS Access, Mongo DB

SDLC methodologies: Waterfall, AGILE scrum, XP, KANBAN, Spiral

PROFESSIONAL EXPERIENCE:

Program Analyst

Confidential

Responsibilities:

• Spiral methodology for software development was implemented in the project.
• Gathered requirements from the department for LIMS (lab information management system).
• Improved whole process for information management and saved 12000 hours in delivery of results per year.
• Designed and implemented all phases SDLC for the development of LIMS.
• Designed the database for LIMS for department of Agronomy with related 83 tables.
• Developed LIMS system on the server using Oracle Forms and Reports 10g with usage of complex procedures, functions, triggers and packages with Oracle Database 10g as backend.
• LIMS contains 280+ forms, 64 reports, role based menus and secure role based login.
• Installed Oracle 10g, Oracle Forms and Reports 10g, SQL Developer on Microsoft server 2012 and configured all applications to interact with each other and run smoothly on client systems.
• Created adhoc analytical reports using advanced analytical functions in Oracle to see trends and patterns in the result data for the researchers.
• Designed the database schema, RDBMS design, data model with all required joins, naming conventions and performed data normalization and SQL tuning using Indexes.
• Extensively used Forms module, Menu module, PLSQL Libraries for passing calculated values of fertilizer recommendation to different forms, Object libraries and built-ins to maintain consistency in design of tool.
• Designed MDI application with multiple interfaces, role based security login, dynamic LOV, Alerts menu, security roles, complex result report and bill reports for client in both excel and pdf format.
• Used various navigational and transactional triggers for implementing business rules and bill generations.
• Used Dynamic SQL (EXECUTE IMMEDIATE) with List box to generate all recommendation reports from 1 forms and thus reducing time to navigate to different forms for different reports.
• Worked with various canvases, reusable object from libraries and parameter passing in Forms development.
• Developed a batch loading module for LIMS to load the data directly into database and update the tables with recommendation values using cursors to reduce the data entry efforts substantially.
• Prepared documents and trained the client to use the tool.
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging of stored procedure for business logic modification.
• Used various best practices for better performance of the tool at database server side and Forms and Reports development modules.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions throughout the project.
• ETL project for College of Business and Admissions office to load legacy data into Oracle DB, cleaning it to integrate with Tableau.
• Created reports for visual representation on admissions data with SQL which was used in Tableau.

Software Developer

Confidential

Responsibilities:

• Spiral methodology was used for periodic processes. Cycle time for 1 iteration was 1 month.
• Performed requirement gathering, prepared URD and SRS for development.
• Served as SPOC for the ETL project for 1 year and led the offshore ETL team.
• Worked closely with clients and BA to resolve conflict of interests by suggesting alternatives.
• Designed the database schema, RDBMS design, data model with all required joins naming conventions and performed data normalization and SQL tuning.
• Implemented Backoffice operations on database using Cransoft ETL tool and prepared dashboard for implementing data cleansing and validation as per the business rules.
• Developed SQL Loader control programs, interfaces and PL/SQL validation scripts to transfer CSV and XML file data into oracle database and Oracle Applications base tables.
• Expertise in Client-Server application development using Oracle11g/10g/9i/8i, PL/SQL, advance analytical functions (Dense rank, Lag, Lead, Percent rank, aggregate functions), SQL *PLUS, TOADand SQL*LOADER.
• Performed SQL tuning using ASH, AWR reports by rewriting the queries and using Indexes, materialized view, partitions etc.
• Scheduled UNIX scripts using Crontab and TIDAL to run load scripts with dynamic infiles, PLSQL packages to clean the data and monitored the log files.
• SCRUM methodology was used for iterative incremental development.
• Experience in Design, Development, Implementation and support as Oracle Developer in Production, Development and Test Environments using Oracle Tools.
• Extensively used Forms module, Menu module, PLSQL Libraries, Object libraries and built-ins to maintain consistency in design of tool, dynamic LOV, Alerts menu, security roles, complex result report for client in both excel and pdf format.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions throughout the project.
• Worked with REF CURSOR, BULK COLLECT, BULK BIND, collections, INDEX BY TABLE, database triggers.
• Developed PL/SQL procedures with cursors to effectively clean the data, update and delete triggers with PRAGMA AUTONOMOUS TRANSACTION to check any inconsistencies in loading data.
• Used Dynamic SQL with fixed number of expressions and bind variables using EXECUTE IMMEDIATE and DBMS SQL.
• Analyzed the system to prepare business rules on the database and generated status reports.
• Performed SQL tuning using ASH reports, EXPLAIN PLAN and best practices for writing code.
• Involved in implementing ERP system using Oracle EBS and Oracle Forms and Reports 11g. Used BI publisher extensively to design interactive reports and Invoices.
• Involved in implementingOrder to Cash(O2C) cycle andP2Pcycle.
• Developed various reports ‘Customer Statement of Account’, ‘Core Debit memo’andAR Invoice Report.
• Involved in Forms personalization, updatingprocedures, functions, triggers,andpackagesfor validation and loading of data into target table based on the current requirement.
• Designed and developed various custom packages triggers and forms.