We provide IT Staff Augmentation Services!

Sr. System Analyst / Edi Analyst Resume

CA

SUMMARY:

  • Over twelve years of professional experience in Information Technology with extensive experience in performing Manual and Automated Testing and EDI Analyst/System Analyst.
  • Strong knowledge of Software Development Life Cycle (SDLC), QA Methodologies and actively participated with the business analysts and software engineers throughout the project lifecycle to understand business applications and to build quality processes into the design of applications
  • Reviewed and analyzed the data design and data flow between various interfaces from Visio documents and Design documents.
  • Expertise in performing different types of Testing: Black box, Integration, Functional, Regression, Stress, Volume, Smoke, System, User Acceptance and Performance Testing.
  • Expertise in Manual and Automated testing tools (Mercury and Rational Suite of Tools, AB INITIO, Selenium).
  • Good understanding of Relational Database Management Systems. Proficient in SQL and PL/SQL Programming for testing database integrity.
  • Extensive working knowledge in UNIX, Perl Scripting and Windows platforms.
  • Extensive experience in reviewing and analyzing FRS (Functional requirement specifications and SRS, and writing detailed Test Plans, Test Cases, and Test Scripts

TECHNICAL SKILLS:

ETL: Selenium, Ab Initio, Informatica, Visual Source safe, Silk test, QTP

Databases: Microsoft SQL Server 2005 & 2008, MS SSIS, MS SSRS, MS AccessAQT DB SQL Interface, UDB/DB2, Oracle 7.x/8i/9i,/10g

Management Tools: Quality Center 9.2, Rational Suite (Requisite Pro, Clear Quest, and Clear Case)Mercury Test Director, JIRA, Confluence

Operating Systems: UNIX / LINUX, WINDOWS XP /10

Languages: C, C++, V.B. 6.0, PL /SQL, SQL, TSQL, UNIX (Linux/Sun Solaris), UNIX Shell Scripting, TSL, HTML, XML, VB.Net, ASP, Java Script, Java Servlets, JSP, FrontPage, Web Logic, Web sphere, Mainframes and IIS

GUI/Tools: Developer 2000 (Forms 4.5, 5.0, 6i, 10g and Reports 2.5, 3.0, 6i, 10g)V.B. 6.0, HTML, XML, IBM Web Sphere, JAVA, J2EE, SwingASP, MS SharePoint, MS Office

Testing Tools: EDI Source, Retail Link(GEM), XML Spy, Avocado, SCMT, BedrockWinSCP, Confluence, Postman, Sales force

Web Server: Personal Web Server, Internet information Server (IIS)

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. System Analyst / EDI Analyst

Responsibilities:

  • Role in this project involves testing and implementing all required Order processing from Wal - Mart to multiple DSVs
  • Enhance and maintain existing back end and help support production environment.
  • Managing onboarding projects for various partners such as suppliers, carriers, Distribution Centers (DCs), Ship from store (SFS) etc.
  • Provide 24x7 operational support to all production issues and processes.
  • Work with partner integration business manager to facilitate kick-off meetings with prospective DSV businesses.
  • Collaborated with cross-functional teams in the company such as OMS, transportation, engineering, catalog management, item set-up and inventory management of MP and DSV sellers.
  • Execute test script for EDI standard messages that will be used for order processing (850, 855, 856, 810, 824, 997 and Packing Slip, Shipping labels and ASN Labels)
  • Managing Product and Sprint backlogs, user stories, epics, tasks & defects to align with the milestones
  • Production code and patch deployments following a change plan
  • Conceptualized and created dashboards and visualizations for monitoring order trends, on-Boarding status and item set up.
  • Analyzed multifarious seller metrics/KPIs in order to create categories and ranking for seller Performance
  • Handling critical code and security patches as needed
  • Tested and validated Purchase Orders and Items inventory on Sterling Commerce Suite.
  • Tested on Sterling Commerce Suite for order management (OMS) that includes Inventory, Order Tracking and Shipping for EDI messages like 850,855,856 and 810.
  • Optimizing the GO live plan and updating the priorities in collaboration with various teams and market place and DSV sellers based on insights gained by inspecting process after each iteration.
  • Involved in EDI Product Oder, Design, Implementation and Documentation.
  • Wrote UNIX shell scripts and SQL Queries to conduct database validations and database integrity testing.
  • Monitored automation results and re-executed the failed tests to confirm the bugs
  • Conducted End-End testing and tested using Workflow related set of tools

Environment: Retail Link/GEM, PLSQL Developer, Unix Sun Solaris 5.x, Remedy, MS Office and in-house tools Bedrock Dashboard, SCMT Tool, Platform Mgmt., Avocado, JIRA, WinSCP, XML, Postman, ConfluenceTextpad, Surface, Sales force.

Confidential

Sr. Quality Analyst

Responsibilities:

  • Analyze technical, system and business requirements.
  • Prepare Test Plans, Test Strategy, test cases and Test finding document
  • Perform Functional testing, Integration testing and System testing. Perform both black-box and white-box testing.
  • Testing Application with MS SSIS ETL.
  • Verification of Data loads, Aggregate loads and summary roll.
  • Verification of De-Dup, Referential Integrity, enrichment of sequence of data load.
  • Write Complex SQL queries to validate the results.
  • Generate reports, set up different Card Program/Company/System rules in Intellilink UI application.
  • Execute various AbInitio Graphs and load the merchant data of subscribed banks in the system. Verify different enrichment rules and validate data in IBM DB2 and Oracle, SQL Server database.
  • Worked in agile environment on testing iteratively against newly developed code until quality is achieved from an end customer's perspective.
  • Incident management using ticketing system
  • Developed freehand scripts in Java for Selenium
  • Provide 24x7 operational support to all production issues and processes.
  • Analyze root cause and assist in efficient resolution of all production processes.
  • Conducted automation testing of web application using Selenium RC and JUNIT using Modular Framework model
  • Production code and patch deployments following a change plan
  • Handling critical code and security patches as needed
  • ETL load monitoring and performance tuning
  • Designed and implemented the automation testing framework for use in validating new and existing component releases for Selenium RC.
  • Handling datacenter migration activities from vendor site to in-house
  • Wrote UNIX shell scripts and SQL Queries to conduct database validations and database integrity testing.
  • Monitored automation results and re-executed the failed tests to confirm the bugs
  • Developed ANT build files for maintaining test automation builds

Software Used: ETL, SQL Server, MS SSIS, MS SSRS, UNIX 6.1, Java 1.4,XML, IBMWebsphere TEXTPAD, Rational Clear case/Clear quest, HP ALM 11.0,MS SharePoint, Windows XP,MS Office, WinSCP

Confidential, CA

Sr EDI Analyst

Responsibilities:

  • Interacting with drop ship vendors for gathering requirements, rating and assigning priorities to business perspectives
  • Setting up Vendor Configuration in Order Management Systems using tools like Bedrock, SCMT, Avocado
  • Setting up Items for Vendor through Inventory feed flat files and XML
  • Uploading the shipping zones and configuring the Carrier methods in SCMT
  • Setting up EDI message communication and AS2 secure connection between Vendor and Client using EDI version 4010 for the files 850,855,856,860,997,824
  • Developing Test Strategy, Test Plan, Test Case design, Traceability Matrix and Run schedules
  • Prepare and document Unit testing and system integration Reports
  • Creating and Validating XML files using XML Spy
  • Analyze and validate EDI files generated through XML using 1EDI Source tool.
  • Communicate with the drop ship vendors to fix the defects
  • Participating in daily planning meetings with clients and provide updates to management on daily basis
  • Provide support to the existing client base and the business users in production environment, supporting users in Web and windows based client requirements

Environment: Retail Link/GEM, Unix Sun Solaris 5.x, Remedy, Visio, MS Office and in-house tools Bedrock DashboardTool, Platform Mgmt, Avocado

Confidential, Foster City, CA

Quality Analyst

Responsibilities:

  • Review Business Requirements and System Design Document to create test cases in Rational Test Director
  • Execute Test Case scenario through CCDRI Application engines, Ab Initio Software, Database Validation, and/or Physical review of output files.
  • Troubleshoot/Resolve Test Environment (DB or Code issues) for Test Case Failure
  • Review and Report Test Execution success/failure to Lead and upper management
  • Primary Tester for Batch processing of Confidential VTAM Tool for Member Interface
  • Primary Tester For Project Reporting Service
  • Primary Tester For System Notification
  • Data Validation of Confidential Member Specific Data Needs - Merchant Category code, Company/Member bank relationships, Transaction Types etc

Software Used: AB INITIO, AQT (DB SQL Interface), EDITPLUS/TEXTPAD, Rational Clear case/Clear quest, Mercury Test Director

Platform: UDB/DB2, SOLARIS UNIX, J2EE Web Interface on Solaris Unix

Confidential, Boston

Oracle Developer

Responsibilities:

  • Responsible for migrating data in ASCII flat files to Oracle9i using Import/Export utility.
  • Responsible for analyzing, designing and coding of Photo Line up, Schedule, Disciplinary of the inmates modules.
  • Designed and integrated the Common Area Search(Auto) with the existing system which had the modules like Schedule Cell Search (auto), Schedule Common Area, Bed management etc.
  • Responsible for writing stored procedures, packages, functions and triggers.
  • Writing necessary test scripts in SQL and PL/SQL.
  • Used Software Configuration Management (SCM) for managing containers and data storage, version control, work areas, Impact analysis etc.

Environment: Oracle 9iAS, Oracle Forms 10g, Oracle Reports 10g, SQL, PL/SQL, Unix, Pro C.

Hire Now