We provide IT Staff Augmentation Services!

Tech-functional Support Lead Resume

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.

Hire Now