SUMMARY

• Senior Consultant/Lead with over 12 years of IT experience in Retail, Insurance, HealthCare, Utility business domains - analyzing requirements, application design, development, testing and production support of database applications.
• Worked with Michaels, Confidential, Confidential, Confidential, Confidential, Renner, Abercrombie Fitch, S&P, HCL, EDS, PVAK Soft and Cirus Infotech.
• Extensive experience in Retail domain and gained RETEK Business Knowledge.
• Extensive experience in RMS, ReSa, RPM, Stock Ledger, Allocation, Inventory, ReIM, and Inventory.
• Extensive experience in Data modeling and Designing.
• Extensive experience in writing SQL Queries, PL/SQL Stored Procedures, Packages, Functions, and Database Triggers, fine tuning SQL Queries using Explain Plan, SQL Trace, and TK-Prof.
• Extensive experience in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TOAD
• Expertise using Oracle 12c/10g/9i/8i/8.0, Oracle Forms Fusion Middleware 11g/10g/6i/6.0 and Report10g/6i/6.0, SQL, PL/SQL, SQL*Loader, Stored Procedures, DBMS.
• Extensive experience Oracle ADF 11g Architecture, JDeveloper, Oracle ADF Development (ADF, ADF Faces, ADF Task Flows and Business Components) with Web Services.
• Extensive experience in decision support system (DSS), Dimensional modeling, data warehouse requirement analysis and Implementation.
• Expertise in C, Pro*C using Pointer, Structures, Macros, Functions
• Expertise in creating new C, Pro*C Batch Programs with embedded SQL’s, Pl/Sql Procedure calls, Arrays and Dynamic SQL..
• Excellent knowledge in JAVA, Oracle ADF and OOPS concept
• Four years of strong experience in Python 3.x
• Five years of strong Data Warehousing experience using SQL scripts and Informatica Power Center Designer: Source analyzer, Warehouse designer, Mapping designer,Target analyzer. Workflow Manager: Task Developer, Worklet, Workflow Monitor, Repository Manager, Star Schema Modeling, OLTP, OLAP
• Result oriented with good interpersonal and excellent analytical and problem solving skills

TECHNICAL SKILLS

Operating Systems: HP-UX 11i, Solaris 2.x/8, AIX 5.3, OpenVMS, Windows XP/NT/2000.

Languages: C/C++, Pro*C, Java, COBOL, PL/SQL,XML, HTML, UNIX shell Scripting, Perl

Office Applications: MS Office 2003/XP/2000

Databases: Oracle 12c/10g/9i/8i, SQL Server, MS Access 2003/2000

ETL Tool: Informatica Power Center,Data stage

Other Tools: SQL*Loader, TOAD, SQL Developer, SQL Navigator, Teradata

Web applications: JAVA, JSP, PHP

Retek RMS Versions: RMS 6, 10, 12.x and 13.x

PROFESSIONAL EXPERIENCE

Confidential

Tech-Functional Support Lead

Responsibilities:

• As a tech-functional lead, schedule meetings with business and client IT team to discuss upcoming activities and prepare plan accordingly and co-ordinate with offshore team to execute.
• Working with business to Identify and prioritize tickets and co-ordinate with offshore team to resolve the tickets based on priority.
• Worked closely with business team to build a knowledge base with system run books, system landscape documents, process.
• Perform root cause analysis and remediation.
• Understand business process, advice improvements and enhancements to reduce the incident tickets.
• Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
• Developed custom batch programs in Pro*C and developed custom Functions, Procedures and Packages Scripts for different modules Helping the business to train/understand the application when users having challenges while using the application.
• Design and develop Batch programs in Pro*C and shell scripts for problem tickets (Projects).
• Designed and developed complex screens for transactions with required validations and writing procedures for common functionality using Oracle Forms 11g.
• Customized and developed Oracle Forms .
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions, Triggers)
• Optimized SQL and PL/SQL performance using Oracle utilities like hints, Explain Plan
• Actively involved in project requirement discussions and provide impact analysis from support angle.
• Designed and developed ADF pages for existing custom application.
• Designed and Developed py (Python) scripts to generate data reports from external sources such as XML, data files.
• Designed and developed custom Java batch programs for data integration using JDBC.
• Designed and developed new application and added functionality to existing applications using Java/J2EE technologies
• Designed and developed dictionaries in Jupyter Notebook.
• Available on call to support the application and team.

Environment: SQL, PL/SQL, C/C++, Pro*C, Oracle 11g, Oracle Forms Fusion Middleware 12C/ 11g, Forms 6i, ADF 11 g, Jdeveloper 11.1.1.7 UNIX/LINUX Shell, Eclipse, Python 3.2/3.7.

Confidential

Oracle Retek Tech/Functional Consultant

Responsibilities:

• Actively involving in the implementation of IO integration.
• Actively involved in business meetings with business users and gathered requirements.
• Created functional and technical design documents for new business requirements.
• Designed and developed Allocations and PO integration to JE.
• Developed custom batch programs in Pro*C, Package Functions, Procedures and Triggers for PO, Allocations and Transfers Integration.
• Doing the new ADF pages and enhancements for existing pages.
• Designed and developed new ADF pages, EO, VO and enhancement for existing project.
• Retrofit Oracle forms functionality in ADF pages as part of ADF migration project.

Environment: SQL, PL/SQL, C/C++, Pro*C, Oracle 11g, Oracle Forms Fusion Middleware 11g / 10, ADF 11 g, Jdeveloper 11.1.1.7 UNIX/LINUX Shell, SVN Version Control.

Confidential

El Salvador

Responsibilities:

• Actively involved in the implementation of ReSa, Stock Ledger
• Actively involved in business meetings with business users and gathered requirements.
• Created functional and technical design documents for new business requirements.
• Design and developed TOTALS definitions and GL Mapping for financials accounts for ReSA.
• Developed automated PO generation process for RMS.
• Design and developed custom forms.
• Designed RTLOG mapping for POS and ReSA integration.
• Organized TOTAL definition, GL mapping training for business user.
• Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
• Developed custom batch programs in Pro*C and developed custom Functions, Procedures and Packages Scripts for different modules in RETEK -13 implementation.
• Designed and developed complex screens for transactions with required validations and writing procedures for common functionality using Oracle Forms 11g.
• Customized and developed Oracle Forms .
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions, Triggers) using Pl/Sql for RETEK-13.
• Preparing unit test cases and performing unit testing
• Applied Oracle Retail 13.2.8 patch on top of Oracle Retail 13.2.2
• Developed ADF Business Components, Task Flows and ADF Faces for custom applications
• Involved in production support for resolving end-users issues.

Environment: SQL, PL/SQL, C/C++, Pro*C, Oracle 11g, Oracle Forms Fusion Middleware 11g / 10, ADF 11 g, Jdeveloper 11.1.1.7 UNIX/LINUX Shell, SVN Version Control.

Confidential

Jacksonville, FL

Responsibilities:

• Have involved actively in the implementation of ReSa, Stock Ledger, ReIM
• Created functional/technical design documents for new custom Batch programs according to business needs for development team.
• Have involved in data modeling and designing of RMS, ReSa, custom tables.
• Designed and developed RMS, ReSA, ReIM financials integration to third party financials applications (JDE).
• Customized base Fixed deals functionality as per Confidential business rules.
• Designed RTLOG mapping for POS and ReSA integration.
• Customized Oracle Retail Allocation . Added new functionality for planned Receipts
• Using Packages, Functions, Pro*C Developed custom batch programs for EDI according to Retek standards.
• Coding and reviewing of enhancements done in the Interface side during implementation.
• Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
• Developed custom batch programs in Pro*C and developed custom Functions, Procedures and Packages Scripts for different modules in RETEK -13 implementation.
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions, Triggers) using Pl/Sql for RETEK-13.
• Developed C/C++, Pro*C Batch programs using Multithreading Programming for handling large volumes of data for parallel processing/load.
• Developed Triggers to trace the performance of batch programs
• Designed and developed complex screens for transactions with required validations and writing procedures for common functionality using Oracle Forms 10g
• Preparing unit test cases and performing unit testing
• Followed the SDLC lifecycle methodology during the implementing stage of the project.
• Involved in production support for resolving end-users issues
• Created test cases to Unit test for SQL scripts before UAT release

Environment: IBM AIX 5.3, C/C++, Pro*C, Oracle 10g, SQL, PL/SQL, SQL Navigator, UNIX/LINUX Shell, SVN Version Control, Windows XP, Mercury Quality Center.

Confidential

Oracle/Pro*C /Senior Consultant

Responsibilities:

• Actively involved in business meeting and gathered requirements to developed the functional and technical design doc and to-be process map, taking into account best practices.
• Developed design documents for new TUXEDO service according to business needs for development.
• Coding and reviewing of enhancements done in the Interface side during upgrade.
• Have developed new TUXEDO services using .gen, .pv, Pro*C, .arr files.
• Developed Server side programs in Pro*C.
• Wrote custom support modules for upgrade implementation using Pl/Sql, Unix Shell Scripts ,Pro*C, and C++.
• Have involved in data modeling and designing of custom tables.
• Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions, Triggers) using Pl/Sql.
• Developed C, Pro*C Batch programs using Multithreading Programming for handling large volumes of data for parallel processing/load.
• Preparing unit test cases and performing unit testing.
• Followed the SDLC lifecycle methodology during the implementing stage of the project.
• Performed optimization of SQL queries (Used SQL Trace, Analyze, Explain Plan Utilities, TK-prof and Hints to tune SQL Queries.).
• Involved in production support for resolving end-users issues.
• Created test cases to Unit test for SQL scripts before UAT release.

Environment: IBM AIX 5.3, Pro*C, Oracle 10g, SQL, PL/SQL, BEA TUXEDO 8.0, SQL Navigator, UNIX/LINUX Shell, Perl, RCS, PCL Print Language, Windows XP, Mercury Quality Center.