AVINASH

· A competent professional with nearly 5 years of experience in evaluating end-user requirements and troubleshooting for complex problems, analysing bug patterns and providing insights and practicing to the development team for prevention of high priority/ severity bugs

PROFILE SUMMARY

·        Insightful experience in analysing business & technical process, procedures to identify opportunities for automation as well as designing solutions to meet functional and technical requirements

·        Proficient in facilitating technical teams with investigating, analysing, defining, tailoring, and implementing technology solutions to create greater alignment between technology and business goals

·        Experience with data manipulation, analysis, reporting and data visualization; hands-on experience on Tableau & Power BI

·        Expertise in working closely with business and IT stakeholders to define problems and design large-scale, enterprise class solutions

·        Capabilities in identifying, communicating and mitigating risks, assumptions, issues & decisions throughout the lifecycle

·        Formulated visual reports, dashboards and scorecards using Power BI desktop

·        Possess knowledge of complex SQL Queries, Stored Procedures; worked on Toad, MYSQL, REDSHIFT, PL/SQL Developer, View, Join, Sub-query; hands-on experience in performing smoke and regression testing

Strong analytical and technical problem-solving skills

ORGANISATIONAL EXPERIENCE

Since Jan’16 with SIQES India Pvt. Ltd., Noida as Software Engineer (EDI/QA Analyst)

Project:                               eVGM, BK, TnT, Web BL, Bill Of Lading

Client:                                  INTTRA

EDI File Format:               EDIFACT, ANSI X12, XML

Environment:                   QA, STRESS, CVT, PRODUCTION

Role:                                     T2PS/ January 2016 to till date

Description:                       INTTRA provides a platform to scale transportation cargo by introducing electronically  verified gross mass (eVGM), BK, SI, TNT, Web BL, Bill of lading. This provides detailed invoice to help manual efforts from the invoice processing to achieve maximum volume for optimal ROI.

Key Result Areas:

·        Participating in the development & review of business & system requirements to obtain a thorough understanding of business needs in order to deliver accurate solutions

·        Understanding & gathering the requirements in production with involvement in error handling; supporting internal Electronic Data Interchange (EDI) objectives and tasks

·        Generating reports using SQL in toad, REDSHIFT and Microsoft SQL Server

·        Analysing the data and producing results as per client requirements, executing tests and analysing results as per client requirements, logging defects using QC

·        Monitoring of EDI Systems production activities ; resolving incidents reported by application users

·        Interacting with business users for requirement clarification and resolution of problems reported

·        Testing the maps with production data and comparing the output files

·        Managing and resolving tickets based on the priority and informing the issues to the customer with in stipulated SLAs & finding root cause of problems

·        Delivering post live support; monitoring, investigating and resolving EDI production problems; reviewing daily EDI error/exception reports; analysing process and recommending improvements

·        Imparting training and KT via WebEx, Goto meeting

·        Developing high quality applications in accordance with established company standards and development guidelines

·        Performing code reviews, unit testing, and system testing as needed

·        Reviewing and analysing the effectiveness & efficiency of existing systems and developing strategies for improving or further leveraging these systems