SUMMARY:

• Over 11 years of experience as Techno - Functional Lead in the IT industry, specializing in Supply Chain Management and Reference Warehousing.
• Over 3 years of experience in a Techno-Functional role in Data Warehousing at an American multinational technology company.
• Have good experience in Software Development Life Cycle SDLC and Production Support Model.
• Worked closely with the Testing team and involved in STLC.
• Strong backend debugging skills using SQL.
• Have good experience in STLC and its phases like Functional, Regression, System, Integration, Performance, End-to-End and User Acceptance Testing.
• Very good understanding of Business Requirements gathering, Gap analysis, solution design, configuring, setups, Test Plan Preparation, Unit Testing, System Integration testing, Business Acceptance testing and production support.
• Performed End-to-End testing manually and closely worked with Cross Functional Teams in conducting System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Extensive experience in preparing Training material and End User Guide using PowerPoint presentations, Webinars, etc.
• Working experience in Project Management & Coordination with Developers and Quality Analysts both onsite and offshore teams.
• Able to work under self-direction with minimal supervision and guidance, prioritizing own work and coordinating with other team members and business users.
• Excellent interpersonal skills, ability to interact with people at all levels, good communication and presentation skills.

TECHNICAL SKILLS

Domain: Supply Chain JDA Demand Forecasting and Demand Planning & Data Warehousing.

Databases: Oracle 9i/10g/11g/12c

Languages: SQL, PL/SQL, Unix Scripting, Linux scripting, exposure to awk and Perl scripting

Debugging Tools: TOAD, SQL Developer

BI Tools: Confidential Reporting Tool, Datastage Designer/Director

Defect Tracking Tools: Central Station, Espresso, HP Service Manager, HP Quality Centre, Remedy, Tivoli Service Centre, exposure to JIRA & Rally.

Job Schedulers: Autosys, Control M

Operating Systems: MS Windows, UNIX, LINUX, MAC

PROFESSIONAL EXPERIENCE

Confidential

Techno-Functional Lead

Responsibilities:

• Lead the Requirement Analysis activity to establish a common understanding between the customer, business and other stakeholders.
• Interacting with Business Users/Clients for daily Production Issues and Enhancement requests.
• Lead the Design, Development and Testing activities of all the enhancements.
• Have carried out Functional, System, Integration, Regression, Performance, End-to-End and User Acceptance Testing for the enhancements.
• Establish an agreed upon baselines for the size, schedule and cost for the project.
• Create automated jobs using shell script and oracle procedures/functions to enable data transfer to downstream applications.
• Design application modules including interfacing mechanisms to publish data to downstream systems.
• Prepared and executed Integration testing for the data published to downstream systems.
• Work on setting up an event-based model for outbound data flow, where a triggering mechanism is activated whenever new data arrives into the system..
• Involved in writing Test Plans based on Business Specifications, Developed Test Cases in accordance with the provided use cases.
• Coordinate with different teams for the procurement of new Linux machines and setting up of ACLs to/from the new host.
• Work with the offshore team for the conversion of all KSH scripts into Linux compatible scripts and remove any dependencies on Oracle UTL File Operations.
• Interface with various IT teams like security team, Database Admin, Performance and Operations teams to ensure smooth functioning of all applications.
• Perform the regression tests for the application. Fix defects raised as part for User Acceptance Testing by the application stakeholders.
• Undertake the deployment, Go-Live and implementation activities.
• Respond to any issues, conduct analysis, suggest and implement workarounds, communicate to all the stakeholders and close issues as per the agreed timelines.
• Provide primary and secondary warranty for the application during and after production releases respectively.
• Help prepare system appreciation documents and support the transition process.

Techno-Functional

Confidential

Responsibilities:

• Involved from Blueprinting stage to carry out SDLC stages effectively.
• Involved in New Instance set up for New company from scratch
• Lead the Forecasting Module Integration with other business units.
• Handle Security (User/Role/Resource) of JDA Application for the new company.
• Implemented scripts to monitor Server Health, Disk Space on Unix server.
• Implemented scripts to monitor Table Stats, JDA Processes Thresholds, alarming changes which hinder JDA processes on Unix Server.
• Involved in preparing Unit Test Plans and Integration Test Plans.
• Carried out multiple rounds of System Testing, Unit Testing and Integration Testing to ensure defect free End to End business flow for the new company.
• Provide support to the Users for the intermittent Network issues.
• Coordinated with the Offshore team to provide 24/7 support.
• Involved in Functional and Technical knowledge transfer to new comers.
• Prepared extensive documentation throughout the project; Functional Specifications, Technical Specifications, Unit Test Plans, Integration Test Plans.
• Maintained an Issue Log to resolve and track every issue occurred.
• Prepared weekly and Monthly status reports to help track the progress and identify risks.

Techno-Functional Lead

Confidential

Responsibilities:

• Lead the Technical Integration of newly acquired confectionery business into the existing Finished Goods Demand Planning system.
• Designed the integration of various interfaces; Item, Location, Shipments, Orders, etc.
• Performed Data Massaging to integrate the acquired systems data into the existing business.
• Handled the System wide changes to integrate the acquired system
• Involved in extensive documentation of Functional Specifications, Technical Specifications, Unit Test Plan and Integration Test Plans.
• Involved in multiple rounds of Integration Testing to have an error free End to End Business flow.
• Reviewing the code to make sure Infosys standards are followed.
• Functional and Technical knowledge transfer to Production Support.
• Prepared Weekly and Monthly status reports to help track the progress and identify risks.

Technology Analyst

Confidential

Responsibilities:

• Requirements Gathering and Designing of the S&OP Confidential reports.
• Built 4 S&OP Confidential reports using custom SQL using
• Materialized View Option - For better performance
• Updated the Confidential Model in Confidential Framework to include the Table level changes.
• Documented Unit Test plans and carried out Unit Testing.
• Involved in User Acceptance Testing with the Business Users and End Users.
• Prepared detailed Functional and Technical Specification Documents to handover to the Production Support Team.
• Trained newcomers in Confidential Reporting Tool.
• Prepared weekly and Monthly status reports to help track the progress and identify risks.

Software Engineer

Confidential

Responsibilities:

• Maintenance of Functional, Technical and Transition to Support Documents for the functionalities.
• Involved in reviewing the historical trends and managing the disaggregation of forecasts by week, month, and year for the National level hierarchy functionally and technically.
• Provided functional assistance in determining the forecast model based on the product and seasonality and sets forecast variance tolerances by sku/dfu.
• Involved in adjusting the Forecast generated to obtain an appropriate Operational Forecast by Overrides, Promotional Event.
• Actively participate in the weekly Support meeting to track the status of the issues and to prioritize.
• Identify issue trends and provide recommendations for the areas of improvement.
• Daily Offshore/Onsite call to ensure proper handshake happens and to provide 24/7 support.
• Functional and Technical knowledge transfer to new comers.
• Ensuring the company standards are followed as requested by the client.