Research and Data Analytics

Customization of Administrator modules of Nopcommerce website for B2B Applications, Implemented & Supported Inbound & Outbound EDI Transactions for 3PL-Supply Chain Integration, Automated Tasks for EDI Inbound and Outbound Transactions to process in our system, Configuration of Trading Partners. Monitored SQL Maintenance Plans to check jobs were executed successfully.-Report Maintenance\changes to display the layout format on web page and changes to add additional fields or data based on client needs-Configured, Implemented and Supported EDI Transactions - 888,940,856,944,945,947,997 for Inbound and Outbound for Trading Partners : General Mills, Hormel, Archer-Daniels-Midland Co, Caterpillar-Automated tasks & scheduled to process EDI transactions for Inbound, Outbound and to provide alerts in case of late acknowledgments.-Developed SQL queries to check performance based on daily transactions for Orders received or reprocessed count with pickup date and dispatch date-Configuration of new clients as Trading Partner in system using Cleo Integration Cloud.

Development/Support for Conflict Minerals for SEC Reporting, Implementation of Rolling up Direct Material Cost for Products, Support for Direct Material Cost ReportingResponsibilities: ➢ Developed SQL scripts to upload flat files (.csv, .txt) into oracle database based on customer requirements➢ Validated the flat files to ensure the data format was right➢ Automated loading process in Tidal to improve the efficiency➢ Performed root cause analysis and improved process by creating the logs and backups➢ Responsible for loading the data into indirect and direct and maintained audit logs to ensure data was loaded successfully➢ Responsible for sending supplier and parts conflict minerals reporting data to iPoint for filing SEC reporting➢ Provided support for fixing data issues, file transfer issues and automated jobs failure by coordinating with MFT, Tidal, iPoint and DBA groups➢ Documented all the standard process for loading the data for direct supplier or indirect supplier

➢ Analysis of web application using visual fox pro application database to setup website in server ➢ Implemented new functionality like email confirmation for Automated Password Recovery/Reset, Order Acknowledgement, Shipping Information/Tracking and new catalogs for client accounts➢ Monitoring the EDI transaction and fixing the bugs if needed ➢ Implemented new safety cross web application to monitor safety in warehouse for all locations ➢ Development of new reports and changes on existing reports based on customer requirements➢ Created a web architect diagrams for all web applications

Masters in Computers Science

Responsibilities: The project involves analysis of database and development of reports for zebra products using PHP, MySQL and HTML.Responsibilities: This project involves development of parsing the data from .xml file and populate the required fields into the KMLData table using PL/SQL.

• Well versed with Software Development Life Cycle from Requirement, Analysis to Maintenance • Extensively worked on Oracle Applications (CRM), Design, Implementation and Support, PHP, MySQL, HTML, Shell Programming, SQL, PL/SQL, Stored Procedures, Functions, Stored packages, Database Triggers, Forms 6i and Reports 6i• Provided 24 x 7 Production support• Expertise in Application Object Library (AOL) and System Administration (SYS ADMIN) functional modules in Oracle Applications (CRM)• Exposed to interaction with client and vendor for application related issues• Mentored New Team Members, Visited Client locations to resolve Performance issues• Possess strong problem analysis skills with ability to follow project standards.• Effective team player with good communication skills