SUMMARY

• Over 20 Years of experience in IT including PL/SQL Procedure,Functions,
• Packages, materialized views,
• Oracle Forms and Reports, full lifecycle development, design and support, Oracle 8.x/9i/10g/11g/12c,
• DB2 database administration,
• SQL Tuning,
• Data Analysis/Modeling/ Design,
• ETL scripting,
• Java Scripting and JSP design,
• Unix bash shell scripting, Job Scheduling.

TECHNICAL SKILLS

Languages: Oracle 8x - 12c, Forms and Reports, SQL, PL/SQL, Java, Pro *C, MS-SQL,FoxBase, COBOL, Pascal, Fortran, Unix bash shell.

Operating Systems/Hardware: RAC 11gr2, LINUX, AIX-UNIX, HP-UNIX, VMS, Windows 10, MS-DOS, Digital Alpha Severs & HP Servers

Databases: Oracle 8i/9i/10g/11g/12c, DB2, SQL Server 2014.

Scripting Languages: PL/SQL, HTML, XML, J2EE, Aix/HP Unix Shell Script, KORN Shell

Tools: Oracle Enterprise Manager, PL/SQL Developer, Developer/2000 (Oracle Forms 4.5-11g and Reports 2.5-11g), SQL*Loader, PL/SQL Developer, SOA, TOAD, Service Now, JIRA, SVN, Footprints, Eclipse, NetBeans IDE, JavaFx, JIDea, Java Server Pages (JSP),, Argos Reporting, Visio 32, OEM.

ERP: Ellucian Banner - web-tailor, Confidential RDM/RMS, DataStream 7i - 10i, Oracle EBS R12 (Financials).

Data Modeling/Case Tools/Code Generator/ Development Methodologies:

Oracle Designer 6.0/6i, SDLC, Waterfall, Agile development methodology and SCRUM meetings.

Internet Protocol Tools: TCP/IP, FTP, WinScp, Putty.

Database/Versioning Tools: Win CVS, PVCS, Clear-case, Tortoise-SVN, GIT, SQL Developer, FTP PRO

PROFESSIONAL EXPERIENCE

Senior Consultant,

Confidential, NY, USA

Responsibilities:

• Used complex PL/SQL packaged procedures and functions to code BRE rules for validation of Loan pool data to create a robust system which was 100% error free and achieved a high level of stakeholder satisfaction.
• Enhanced various Forms used by BNY clients to obtain pool loans and the disbursement of these loans in portions. Applied business logic through PL/SQL Packages, Procedures and functions to query key elements of the forms, Bulk Load them into table of records and display them on the User Interface forms selectively using cursors.

Technical Environment: Oracle 11g and 12c, PL/SQL, SQL Developer, JIRA, SVN, TOAD, SOA, Java, Linux, Unix, Windows 10

Senior Consultant/Contract,

Confidential, Ohio, USA

Responsibilities:

• Used PL/SQL Developer tool to create fresh business logic for new requirements by creating packages, procedure, functions, pl/sql blocks, tables, pl/sql tables, varrays, views and materialized views, sequences, indexes, database triggers.
• Created XML data types in tables and updated these wif embedded XML tags to conditionally provide dynamic formatting for Java reports.
• Granted roles and privileges to users and based on their roles gave them access to menu items. Grouped emails of users based on their roles creating a ready distribution list for send-mail feature of UNIX.

Technical Environment: Oracle 11g and 12c, PL/SQL, SQL Developer, JIRA, GIT, TOAD, Java, Linux, Unix, Windows 10

Senior Consultant/Contract,

Confidential, Rhode Island, USA.

Responsibilities:

• Used dynamic SQL to create generic PL/SQL scripts and data blocks to fix audit column data issues in a large number of tables doing bulk reads, updates and inserts using the merge statements, cursors, dynamic SQL, while loops and if then else conditions, constraint queries, List-agg function, Rank, Dense Rank and Row number concepts to implement business rules while creating backup tables for security reasons before doing the update/insert audit column information update in the main tables.
• Analysed several data defect issues related to various healthcare benefits being processed by the company for individuals applying for these benefits. Created single account as well as bulk fixes from large number of cases using PL/SQL cursors and loops to implement the correct business rules.

Technical Environment: Oracle 11g and 12c, PL/SQL, SQL Developer, JIRA, SVN, TOAD, Java, Linux, Unix, Windows 10

Programmer Analyst - II,

Confidential,

Responsibilities:

• Analysed issues reported or enhancements required in ELLUCIAN BANNER Forms and Reports which were reported by various departments of the university and debugged the issues or enhanced the functionality of the Forms and Reports. Created new reports for office of continuing and registration including analytical matrix reports wif summary of rows and columns.
• Created PL/SQL script to extract data from the university residence SQL- server 2014 based database into comma delimited flat files and uploaded into the main oracle database Banner system using SQLLOADER.
• Analysed report requirement data by created stored procedures, functions and packages using PL/SQL Developer and TOAD. Created new tables and storage structures when required and presented data into Oracle Forms and Oracle Reports as well as Pro C reports and excel sheet extraction of data as required by business rules.
• Modified Pro C based reports to produce delimited output using Unix shell to concatenate CLOB columns into a single comma delimited cell which could be loaded into an excel sheet and manipulated at will by various departments in the University.
• Closely interacted wif the project manager and end users to refine the business requirements of various users of the Ellucian-Banner product as per user needs, and create desired reports for the Mount Royal university staff.
• Used web-tailor tool of Ellucian-Banner to customise the GUI interface and visible help information for end users.
• Did Performance tuning on oracle database 11g.

Technical Environment: Oracle 11g, PL/SQL, SQL Developer, Oracle Forms and Reports, Pro C, Java, Argos Reporting Tool, PL/SQL Developer, Linux, Unix, Putty, Windows 7, Win-SCP, GIT, Foot-Prints.

Senior Consultant,

Confidential,

Responsibilities:

• Lead developer specializing in PL/SQL development and advised and help tune response time of queries wherever bottlenecks were reported by the end users.
• Followed agile development methodology to enhance the NOMAD utility system using Java wif Eclipse and PL/SQL. Coded analytical scripts for the purpose of Quality Analysis (QA). Tuned job-history complex query which was taking over 3 minutes to respond wif results in .22 second which was a huge improvement of over several 100 percent. This was accomplished by making part of the original query into a materialized view. Created a PL/SQL database package (pk process spv) to implement the desired business rules involved in the extract-transform- load of the Site Profile Value data.
• Created database objects like table, database triggers, primary, foreign key, check as well as not null constraints, indexes, sequence etc. to successfully transform data as per business rules and store it. Used XML to exchange data wif vendors of Direct Energy.
• Backup and Recovery of tables being affected by change scripts. Performance and tuning of database objects as well as scripts. Problem Determination and resolution. Database support for the NOMAD system.
• Used service now to prepare change requests to move database related changes into production through execution of database scripts, and to migrate and install new or changed database objects into database environment.
• Created Unix shell scripts to help transform data by removing special characters like CTR-M and extra spaces/blank lines if any before loading the data using SQL LOADER and process each record and transforming it via the newly created package before this data is loaded. Also created a control file in UNIX to tell SQLLOADER about the columns in the table created to store the data.
• Tested the package wif various tests like checking for mandatory fields, foreign keys, invalid values, etc. before loading the data.
• Separated repeating code from the package into logical procedures accepting and returning multiple values and designed functions returning single values. This process eliminated redundancy
• Added parameters to reports to make these changeable from the front end by users.

Technical Environment: Oracle 11g/10g, PL/SQL, SQL, Java, XML, Hudson, Eclipse, Toad, PL/SQL Developer, Unix, Putty, SFTP, Windows 7, Win-SCP, Win-CVS, Service-Now.

Senior Consultant,

Confidential,

Responsibilities:

• Installed the latest version of Forms 11g, Reports 11g and the compatible Web-Logic server along wif Java runtime environment for the migration of the existing 10g Forms and Reports.
• Analyzed the system flow of the existing CMT application and moved each object related to ticketing of oil flow at time of custody transfer, to a newly created application called CTTS and database called TKTG.
• Created database links and public synonyms in case any object in the TKTG database referred to an external database.
• Upgraded the 10g Forms and Reports to the 11g platform by compiling them on this platform and fixing all errors related to unsupported features or due to the changes in the database caused by the separation of the ticketing process.
• Solid understanding of integration of Oracle Applications modules, Multi Org, Reporting Currencies Setups, Chart of Accounts, FSG, Budgets and Flex fields.

Technical Environment: Oracle 11g/10g, PL/SQL, SQL, Forms 11g/10g, Reports 11g/10g, Eclipse, Java, WebLogic Server, Hudson, Eclipse, Toad, PL/SQL Developer, Unix, Putty, SFTP, Windows 7/XP, Win-SCP, Sub-Version (SVN).

Confidential,

Responsibilities:

• Analysis and Testing of Electricity and Water Treatment Billing Applications for (EPCOR Utilities). Rewrote report leading to 60% performance enhancement from the original report along wif an 80% reduction in code.
• Advised on database performance tuning and measurement and implemented physical database support.
• Analysis, redesign, ETL script writing (DB2 Oracle PL/SQL) and Data Stage, RMAN backup and recovery of database (Oracle DB2) for Govt. of BC - Development, Test and Production Databases for (ISM) client.
• Was senior RMAN Backup resource for ISM. Applied noledge of Data Migration, provided High availability solutions like mirroring clustering and log, performed backup and recovery operations, worked on RAC 11gr2,
• Supported oracle OEM / OLAP/ RAC/ and Partitioned tables. Performed oracle problem determination and resolution.
• Performed installation, customization and performance tuning of Oracle on UNIX and Windows platforms.
• Agriculture and AGRI-Food Canada (AAFC) - Create hybrid oracle/Java forms and Reports (CGI) for the grazing Land Management System (LMS), a federal government project.
• Government of Saskatchewan (Timber Information System) - Analysis, Design and Develop PL/SQL packages, Provide Oracle DBA support to developers and clients. (CGI).
• VITERRA Confidential (Cash Receipt Batch Process Rewrite) - Sybase to Oracle Procedure Conversion.
• Ministry Of Environment, Alberta (Environment Management System) Oracle Financials Forms Enhancement.
• Tuned reports to reduce the report response time by 50%. Analyzed and developed the ‘batch process rewrite package’ to close the open receipts based on business rules. Used object oriented oracle structures, PL/SQL tables, bulk collect, bulk insert/update and sort procedures to create a highly efficient receipt processing system.
• Achieved an enhanced system quality and high customer satisfaction by using testing techniques like load testing, integration and regression testing, acceptance testing.
• Created highly efficient and user friendly Forms for the Environment Management System, Environment Department - Government of Alberta. Contributed by enhancements to forms and added stacked, tabbed and content canvases to various forms and called them according to business rules and user requirements.
• Did problem and change management, has excellent English written and verbal communication skills, has ability to interface wif customer and tech support teams, created and modified operating procedures, created reports and spreadsheets.
• Has good organizational skills along wif teamwork, problem solving abilities and leadership skills.

Technical Environment: Oracle 10g/11g/9i/8.1.7, RAC 11gr2, PL/SQL, SQL, Forms 11g, Reports 11g, ADF, RUP, DB2 UDB 7.x/8.x, Oracle RMAN, Oracle Enterprise Manager, Toad, Unix, Windows XP/NT, Lotus Notes, Visio, Sub-Version (SVN), Natural, AIX-UNIX, HP-UNIX Reflections, Win-Sphere Win-SCP, Clear-case, PL/SQL Developer.

Confidential,

Responsibilities:

• Enhancement/maintenance of the R5 ERP product of the client using UML. - INFOR Global Solutions.
• Collection System Conversion of software from 3rd party to in-house, for the client “Kinetic Concepts”, TX, USA
• Loan Operations System upgrade for client Harley Davidson Financial Services, NV, USA.

Technical Environment - Visual Basic, MS Access, Oracle 8x,9i/10g, Forms 6i/9i/10g, Reports 6i/9i/10g, SQL Developer, TOAD,SQL, AIX-UNIX, PL/SQL, MS SQL, SQL Server, UML.

Confidential, Salinas, CA, USA

Responsibilities:

• Grower Accounting ERP conversion from COBOL to Oracle 9i using Designer.

Technical Environment: Digital Alpha Server for Oracle Database and Pentium-4 PCS for terminals, Oracle 9i/10g, COBOL, UML, Clear-case. TOAD, VISIO.

Confidential, Albany, NY, USA

Responsibilities:

• Lead a team of 3 Developers to analyse all the tables in the database and examined the table usage in forms and reports to suggest primary and foreign key relations between tables wherever they were missing.
• Software GUI conversion from COBOL based entry to Oracle Forms6i and COBOL reports to oracle Reports6i for the Employee Relationship System, Capital Assets System, Business Operations System, Equipment management system and Equipment Inventory system.
• New development of the Health Insurance Portability and Accountability Act of 1996. (HIPAA) module in the Developmental Disabilities Processing system.

Technical Environment: O racle 8x/9i, COBOL, Clear-case, TOAD, VISIO, J2EE, Java script, Home-site, notepad, Windows 98/2000, AIX UNIX. Digital Alpha Server for Oracle Database and Pentium-4 PCS for terminals

Confidential, OH, USA

Responsibilities:

• Worked on the Confidential RMS product and create forms & reports for the GUI, character based & Web forms using the Web Server Generator feature of designer.
• Using the new features of developer 6 like popup-calendar, adding tool tip to an item, setting the visual attributes of an item, creating the traffic lights status display, creating a progress bar, creating the spinning wheel animation, etc to design graphically explicit forms.
• Incorporated online help into the forms in the form of balloon help on menu items, pop-up messages on navigating to individual form fields, form-usage help screen on pressing CTR+K key while in a form. Used calendar pop-up to help user select date wherever a date field entry was required.
• Assisted in of staff in usage & functionality of the above forms.
• Created Data model (Logical & Physical) and created schema objects on Designer 6.
• Coding of database triggers to fire for tables in which rows are inserted or data is being updated. Select columns and key-index fields from these tables were to be stored into new tables in which the old values & new values of these columns were to be inserted.
• Created database roles and granted them to users according to their work requirement. Subsequently allotted these roles to various forms according to the functionality of the forms. Used application specific security to populate application context attributes.
• Written PL/SQL stored procedures & functions, incorporating the new Oracle 8 feature of Bulk Select to transfer data.
• Update the Audit table using Database Triggers created using Designer 6.
• Tuning of PL/SQL and Queries for increased performance.
• Created a Test database to use in the overall project test environment
• Created a new menu to call all the forms & reports which were a part of the Activity History Log.
• Created a database of all the forms & procedures in which particular critical tables are being updated / inserted. Reports were created to analyse this data.
• Writing Database triggers, stored procedures, & shell scripts(KORN)
• Resolving problems which occur in the customized version of the Confidential distribution system for the customers.

Technical Environment: Forms6i /4.5, Reports6i /3.0, Oracle8i Enterprise Edition Production Wif the Partitioning and Java options, Designer 6i, PL/SQL,PVCS version manager Ver 6.5.00, TOAD Ver 6.4.0.0.

Confidential,

Responsibilities:

• Development and support for the following projects:
• Asset Management System.
• Enterprise Wide Hardware - Software Management System.
• Tool & Die Shop System

Technical Environment: Compaq Alpha-Server 8400, Digital Alpha server 4100/2100, Windows 95,Windows NT, Pentium-II PC, T1010 Windows based Terminal, CITRIX Server, and Windows CE OS, Developer 2k, Designer 2k, Oracle 8.1.7 Forms4.5/6.0 & Reports 2.5/6.0, Pro*C,HP-Unix.