Software Engineer, Edi Developer Resume
5.00/5 (Submit Your Rating)
San Leandro, CA
SUMMARY:
- More than four years of programming experience in dataflow (ETL process), with strong analytical skills and a broad range of computer expertise.
- An excellent problem - solver, able to quickly grasp complex systems and optimizing process and identify resolution of critical issues.
CORE COMPETENCE:
Technical: Data Analysis, ETL process, SQL script develop, Object Oriented Design.
Software: MS SQL Server, Java/ C#, PL/SQL, Notebook, C++.
WORK EXPERIENCE:
Software Engineer, EDI Developer
Confidential, San Leandro, CA
Responsibilities:
- Maintain reporting dashboard including troubleshooting and development. Interact with internal department to develop new report specifications.
- Develop analytical frameworks for future strategic initiatives and provide recommendations to senior management to drive business decisions.
- Work with business users and stakeholders to gather and analyze and troubleshoot incidents related to batch, ETL processes, and programs.
- Monitoring and tuning queries and data loads, concerning data integrity, monitoring performance and communicating functional and technical issues.
- Developed electronic data interchanges application of HIPAA systems by using C#, Java and T-SQL.
- Develop, analyze, and modify existing ETL, programs or batch processes such as triggers, functions, stored procedures, views.
- Interact with business users and Business Analysts to understand the requirements and create design documents.
MIS Engineer
Confidential, Fremont, CA
Responsibilities:
- Developed company EDI system for any inbound and outbound EDI transactions for communication with customer.
- Debugged for any EDI mapping and generation error, and escalated to the program manager or customer for the error and suggested solution.
- Implemented, tested, and released new features and interfaces per specification updates including database design, SQL stored procedures, background applications, and user interfaces.
- Reported Automation for PO Status, Input, Pack out, Rework, OCT (Order Cycle Time). Troubleshoot for any data discrepancy.
ShopFloor Engineer
Confidential, Fremont, CA
Responsibilities:
- Developed, improved and updated applications to a rich, intuitive user experience in C#.Net environment.
- Designed and implemented front-end business applications while working closely with developers to help generate requirements for backend SAP System and SQL Server.
- Develop store procedure which will summarize EDI amount and store data into data base .
- Develop scripts to read and import log file to database.
- Develop store procedure to pass user-friendly records to dashboard.
- Update dashboard layout by request.
- Customized EDI output file for providers .
Confidential
Responsibilities:
- Stayed in communication with all sectors of the company that would be affected by the EDI program to ensure their support and buy-in.
- Improved EDI System could follow new TMS shipping logic.
- Analyzed shipping related data and created new mapping rule for new TMS shipping logic.
- Enhanced efficiency for custom interfaces action.
- Customized EDI output file for carrier company’s’ IT team’s requirement.
- Created Web service through IIS Server to send request file and read response file.