We provide IT Staff Augmentation Services!

Technical Consultant Resume

MO

PROFILE SUMMARY:

  • 9+ years of consulting, system integrations and programming experience in Retail Products.
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery.
  • Experience in Client - Server application development using Oracle 11g/10g, PLSQL, SQL *PLUS, SQLDEVELOPER and SQL*LOADER.
  • Effectively made use of Table Functions, Indexes, Collections, Analytical functions, Materialized Views and Query Re-Write.
  • Good knowledge on logical and physical Data modeling.
  • Created Tables, Views, Constraints and Indexes.
  • Created Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PLSQL.
  • Good knowledge in Data warehouse concepts, ETL.
  • Experience in Oracle supplied packages, Dynamic SQL, Records, DBMS SQL and PLSQL tables.
  • Loaded Data into Oracle Tables using SQL Loader.
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Worked extensively on Ref Cursor, External Tables and Collections.
  • Good Knowledge of key Oracle performance related features such as Execution Plans and Indexes.
  • Good Knowledge with performance tuning for Oracle RDBMS using Explain Plan and HINTS.
  • Created Unix Shell Scripts for invoking SQL scripts and scheduled them using crontab, Appworx, Automic and UC4.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
  • On premise support for implementation and post go-live maintenance.
  • Conducted gap analysis sessions, product demonstrations and solution design.
  • Adept in solution consulting, designing functional and technical documents and software estimation.
  • Implemented/Customized Oracle Retail for retailers across Fashion, Sporting goods, Bookstore operator, Jewelry and Confidential Decor.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g (SQL, PL/SQL), Stored Procedures, Triggers) and Snowflake.

Languages/Utilities: Oracle SQL, PLSQL, Unix Shell scripts, Core JAVA, XML, JSON and Dell Boomi (Middleware).

Job Scheduler: Crontab, Appworx, Automic and UC4.

PROFESSIONAL EXPERIENCE:

Technical Consultant

Confidential, MO

Responsibilities:

  • Coordinated with end users and business area experts to understand the business problem and the intended use of the system.
  • Responsible for writing requirements & technical designs for custom Price and Item Upload for Oracle Retail suite to facilitate development team in code development.
  • Finalize the technology or tool to be used to develop the custom integrations. Design and document batch dependencies and schedules.
  • Executed the Item Reclass for 14K Items in production environment.
  • Created Item Reclass validation script for Item reclass validation before creating reclass.
  • Created PLSQL scripts for data manipulation and Validation for the items that are being reclassed.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages .
  • Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Document or review unit test cases for the new custom integrations pertaining to Oracle Retail Applications. Co-ordinate with teams for deployment.

Environment: Oracle 10g, SQL * PLUS, SQL DEVELOPER, Shell Scripts, SQL LOADER, UNIX, Windows 10

Test Lead

Confidential, NC

Responsibilities:

  • Led E2E and UAT testing, and managed offshore teams on the testing efforts.
  • Validate the test results with business counterpart to identify high level gaps between product functionalities and business process.
  • Facilitate the change request with the offshore team to fix the identified gaps in Robling Data Warehouse concepts.
  • Created ETL scripts for the change request.
  • Created SQL validation scripts for data validation in the Python validation framework.
  • Manage effort, timeline and delivery of E2E and UAT testing.

Environment: Robling Data Warehouse, Snowflake, UNIX, Python 3.8

Integration Consultant

Confidential, TX

Responsibilities:

  • Responsible for writing requirements & technical designs for integrations in the integration layer to facilitate development team in code development.
  • Conducted mapping sessions for the Integrations, which involves Demandware (Sales Force) and MAO.
  • The integrations involve key areas of retail functional areas such as foundation data, items, purchase orders and Inventory life cycle.
  • Coordinated with business area experts to understand the business requirements and the intended use of the system. Understand the interaction between business activities and data to design integration.
  • Design and document batch dependencies and schedules.
  • Responsible for implementation of the integration design & solution of Manhattan Active Omni Cloud with Oracle Retail Cloud and Sales Force cloud suite.
  • Review the code developed for syntactical checking, static analysis, adherence to coding standards and performance tuning.
  • Responsible for Implementation of the solution and support during post implementation phases.
  • Created DDL scripts to create Tables, Views, Constraints and Index for the Integrations.
  • Designed Integration process flow for all the Integrations in the Integration layer.
  • Created multiple XML schemas based on the targeted system requirement (JSON).
  • Created SQL and PLSQL scripts for the integrations in the Dell Boomi (Middleware).
  • Document or review unit test cases for the new conversions and integrations pertaining to legacy system applications.
  • Perform performance and load testing in terms of CPU usage and cost of queries and profiling the application code. Documenting new code components and performance impact analysis for production deployment.
  • Co-ordinate with teams for deployment and application roll-out strategy.

Environment: Oracle 11g, SQL, PLSQL, UNIX, XML, JSON and Dell Boomi.

Lead Consultant

Confidential, OH

Responsibilities:

  • Communicated and collaborated with clients to understand the requirements.
  • Created SQL, PLSQL scripts to provide reconciliation reports on various functionalities.
  • Developed custom pricing integration using complex database objects like Stored Procedures, Functions and Packages using SQL and PL/SQL to integrate with client legacy system.
  • Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
  • Extensively worked on the Oracle Confidential queue issues and provided the solution in the production environment.
  • Partnered closely with the business users to provide functional and system testing support during SIT and UAT.
  • Performed impact analysis on the Sales process which involves Understanding the different applications like Confidential POS, ReSA, RMS integrations and applications configuration setup. This helped streamlining the ReSA batches, Sales Audit Business processes which supports real time sales processing.
  • Involved in the continuous enhancements and fixing of production problems. Designed, Implemented and tuned interfaces and batch jobs using PLSQL.
  • Conducted Quarterly Business Review meeting with Confidential IT team.
  • Received principle consultant for the exceptional work.

Environment: Oracle 11g, SQL, PLSQL, UNIX Shell Script, Oracle Forms and Pro * C.

Technical Consultant

Confidential, Tilton, NH

Responsibilities:

  • Gather requirements, analyze, and develop the solution for small enhancements in ReSA.
  • Developed SQL and PLSQL scripts to create Totals in ReSA.
  • Created test scripts using SQL to support the testing of Totals in SIT and UAT.
  • Responsible to develop and functionally test the ReSA totals for the different tender types.
  • Manage effort, timeline and delivery of the project.

Environment: Oracle 11g, SQL, PLSQL, Oracle Forms and Pro * C

Business Analyst

Confidential, Baskin Ridge, NJ

Responsibilities:

  • Led the client in identifying gaps in current strategy, documented current business scenarios and made recommendation in related to the “To-Be” process.
  • Performed impact analysis on specific Oracle Retail modules and applications configuration set up.
  • Guided the customer in identifying test scenarios, design functional test cases, captures result and create defect report.
  • Partnered closely with the business users to provide functional and testing support during system integration and UAT.
  • Analyze the functional and data requirements specific to the business problem. Propose various solutions to solve the business problem mentioning the pros and cons of each approach.
  • Applied Oracle Retail products knowledge and retail industry to help clients with functional analysis, design and build their Retail systems.
  • Used my functional knowledge on ReIM, RPM and SIM to drive business decisions. Business user, implementation & support for EDI and ReIM.
  • Designed reconciliation reports to validate the process/data between different Oracle Retail Applications and Legacy systems. SQL, PL/SQL, SQL LOADER and shell scripts were used to develop validation scripts.
  • Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from legacy system during project go-live.
  • Wrote Shell Scripts for Data loading and DDL and Validation Scripts .
  • Provided user and production support.
  • Worked in Production Support Environment as well as QA/TEST environments for projects, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Used SQL*Loader as an ETL tool to load data into the staging tables.
  • Trained and mentored team members on retail products knowledge, industry best practice, quality assurance, software development processes as well as career guidance, competencies, strengths and area of development.

Environment: Oracle 11g, SQL, PLSQL, Oracle Forms, UNIX Shell Script, Pro * C, SQL Loader, UC4 and Oracle JAVA

Technical Consultant

Confidential, Baskin Ridge, NJ

Responsibilities:

  • Led the Custom Interface project and delivered the project within the budget and the given timeline.
  • Involved in Design, Development, Testing and Implementation of various custom Integrations.
  • Created and modified Shell Script, SQL and PLSQL scripts for custom enhancements.
  • Developed and modified triggers, packages, functions and stored procedures for integrations and PLSQL procedures to create database objects dynamically.
  • Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
  • Used SQL*Loader as an ETL tool to load data into the integration staging tables.
  • The integrations included changes in key areas of purchase orders, transfers, replenishment and allocations. Such as,
  • EDI Outbound to Vendor
  • Outbound PO integrations to legacy systems
  • Inbound PO request integration from legacy systems
  • Inventory snapshot from SIM to third party legacy systems.
  • Inventory cycle count from SIM to third party legacy systems and vice versa.
  • Involved in the Oracle Retail batch scheduling and creating batch jobs in the UC4.
  • Mentored the team in testing and fixing issues related with custom interfaces.
  • Led the team of 3 to support Pre-Go Live activities such as,
  • RMS Purchase Order
  • RMS transfers and Inventory
  • SIM Store Orders
  • SIM transfers and Inventory
  • RIB Monitoring and Clearing RIB Hospital

Environment: Oracle 11g, SQL, PLSQL, Shell Script, SQL Loader, Pro * C and UC4 (Job Scheduler)

Software Engineer

Confidential, St. Paul, MN

Responsibilities:

  • Developed Oracle Custom Form that will allow the user to create, edit, or view a Credit Memo for a given supplier.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Developed Custom Batches using Shell Script, Pro * C, SQL and PLSQL to support processing credit memos created through the online form.
  • Modified the Oracle Stock Ledger Batches to in corporate the changes for the New Tran code 90.
  • Wrote Shell Scripts for Data loading and DDL Scripts .
  • Worked in QA/TEST environments for SIT and UAT testing.
  • Provided post go-live production support.

Environment: Oracle SQL, PLSQ, Oracle Forms, Shell Script, Pro * C and Appworx

Software Engineer

Confidential, New York, NY

Responsibilities:

  • Led Confidential offshore support team in their day to day Application Support Activities.
  • Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL Plus, SQL developer, and toad.
  • Enforced data integrity using integrity constraint and database triggers.
  • Proficient in advance features of Oracle 11g for PL/SQL programming like using records and collections, ref. Cursors, nested tables, and dynamic SQL.
  • Provided technical expertise and recommendations while assisting fellow team members, either of development or testing.
  • Troubleshoot technical issues and identified modifications needed in existing integration to meet changing user requirements.
  • Participated in Business Requirement discussions, identified system impacts, and designed solutions
  • Used my functional knowledge on ReIM, RPM and SIM to drive business decisions.
  • Created and delivered CCR design documents for the issues encountered in daily business activity.
  • RIB Monitoring and Clearing RIB Hospital.
  • Trained and mentored team members on retail products knowledge, industry best practice, quality assurance, software development processes as well as career guidance, competencies, strengths and area of development.
  • Received Outstanding Team Member of the year for exceptional work.

Environment: Oracle 10g, SQL, PLSQL, Oracle Forms, UNIX Shell Script, Pro * C and Appworx.

Software Engineer

Confidential, Houston, TX

Responsibilities:

  • Monitored Retek v13 batch jobs to ensure proper execution and operation through UC4 9.
  • Proposed temporary fixes for failed jobs and ensure successful re-execution.
  • Responded to Client’s requests for assistance with problems (for business-related solutions) associated with online, user interactive processes and modules.
  • Documented the problems encountered and solutions applied to update the knowledge base to be used by the team in providing production support.
  • Actively involved in issue escalations, client status calls and follow- ups.
  • Provided daily status reports to the client highlighting any issues of concern.
  • Created and delivered design documents for the issues encountered in the nightly batch.

Environment: Oracle SQL, PLSQL, Pro * C and UC4

Hire Now