John Johnson

979-***-****

Sr. Application Analyst

adlei2@r.postjobfree.com

PROFESSIONAL SUMMARY

* ***** ** ** ********** with over 5 years of experience in Legacy platform involving in Development, Administration, deployment, Configuration of Partner portal, Customer portal and classic to migration to cloud, integration with multiple complex system, data hub and Mart.

Participated in all Phases of Software Development Life Cycle (SDLC) and Agile methodologies with expertise in Requirement Gathering, Analysis, Designing, Development and Testing.

Worked with various Legacy applications like mainframe, AS400 and technology like COBOL, VSAM, JCL, DB2, REXX, CLIST, DYL280, SAS, IMS-DB/DC as developer, system analyst, Designer.

Experience in designing and developing Legacy system using changeman.

Strong Legacy development experience with multiple auto finance industry for Loan and Lease, Asset Based Security Loan, General Ledger Reporting, End-of-Term Processing, Inventory Tracking System, Collection, Dealer Finance, Policy Administration System.

Created various while paper and tool to strengthen the industry work.

Developed and configured various Dashboards, Custom Reports and Report Folders for different user profiles based on the need in the organization.

Having good knowledge on Financial processing system.

Experience in working with Informatica IDQ, IBM Doors, IBM Rational System, JIRA, AWS, Visio, SNOW, Stellent, sharepoint.

Good at administrative tasks such as setting up audit trail, Big Object, field history tracking, creating email templates and list views.

Automated business process by creating workflow rules, configuring immediate and time dependent workflow rule actions, configuring approval process, assignment rules for Leads and Cases in AWS.

Strong hands on on development, unit testing, system testing, implementation and post implementation processing.

Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.

Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions.

Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements

Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts.

Strong oral and exceptional written business communication skills

Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Business Process Management (BPM) tool.

Hard working, positive thinking, self-starter with a strong goal orientation

Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.

Excellent meetings facilitator with excellent inter-personal and conflict resolving skills.

Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.

TECHNICAL SKILLS:

Technology Technologies

COBOL, JCL, REXX, CLIST, DYL280, SAS, CICS, IMS-DC/DB

Legacy Tools

TSO/ISPF, DFSORT, ICETOOL, EXPEDITORS, FILE-AID, CHANGEMAN, SPUFI, EXPRESS, SAR, IBM FILE MANAGER, Rumba

Programming Languages

COBOL, AS/400

Databases

DB2, IMS-DB, ORACLE, PL/SQL, MongoDB, QMF, TOAD, Athena

Operating Systems

IBM 3090, MS Windows

Other Language/tool

Informatica IDQ, SSRS Reporting Services, IBM Doors, IBM Rational system Architect, JIRA, AWS, SharePoint, Visio, SNOW, Stellent, Snowflake, Postman

PROFESSIONAL EXPERIENCE:

Toyota Financial Services, TX August 2018 – Present

Legacy Analyst

Description:

TFS has constructed a global network that covers approximately 90% of the markets in which Toyota sells its vehicles. Mainly concentrated on auto loans, leases, and Toyota dealer floorplan requirements, TFS provides auto sales financing to approximately 5.4 million customers. This Project includes the Inventory Management of Vehicle's, supporting the service requests, maintaining the Auction updates and so on

Responsibilities:

Involving in all phases of Software Development Life Cycle (SDLC) starting from Requirements Gathering and Design.

Design and developed Legacy system to allow business/user to meeting daily business need with TFS to begin with application process.

Designed Custom reports to support accounting and operation for daily cash reconciliation.

Responsible for understanding the current process and developing potential workflows for distribution of New Issues

Responsible for identifying various business needs and requirements and presenting them to the user.

Developed the process for implementation of these requirements.

To develop test scripts and test cases for various releases of the project.

Created Business Rules Document and Requirement Traceability Matrix to track the requirements.

Assessed and evaluated potential applications that meet the desired functionalities of an optimal Management system to meet the needs of change deployment

Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training classes.

Closely involved in defining project scope and identifying discrete enhancement efforts as individual tasks or sub-projects and prioritizing them.

Involved in Joint Application Development sessions with SMEs and development teams and documented functional business requirements as product backlogs using JIRA

Prepare and facilitate workshops to determine performance metrics, user reporting requirements, data definitions, data quality, and data warehouse access and security

Collected Requirement directly from clients to implement the remedy Legacy product on Board

Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Business Process Management (BPM) tool.

Responsible for Query optimization and performance tuning using tools like SQL Server Profiler, Database Engine Tuning Advisor for SQL queries and Stored Procedures.

Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.

Implemented Agile Scrum methodology guidelines to build artifacts in different sprints and phases of the application development process.

Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite for the documentation tool.

Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training classes.

Creating user stories and maintaining and tracking them using JIRA.

Used Visio to develop Use Case diagrams, Activity Diagrams and Sequence Diagrams.

Worked with the quality assurance team so as to test different releases and to develop test plans and test cases.

Created the SQL scripts for demonstrating the prototypes and for verifying the result sets

Responsible for the collection of functional requirements, non functional requirements, data mapping, and light data modeling.

Gathered business requirements as well as putting together a project plan, strategy, scope, best practices, and all other documentation for numerous Projects.

Designed and implemented basic SQL queries for testing and report/data validation

Involved in Regression and Load testing

Develop, standardize, implement and continuously improve a best-in-class strategic procurement process

Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.

Apply appropriate development methodologies (agile, waterfall) and best practices (e.g.: mid-development client reviews, embedded QA procedures, unit testing) to ensure successful and timely completion.

Gathered customer requirements and assisted in design and development of solutions for Product Lifecycle Management (PLM) and Environmental Compliance software.

Involved in UAT, Batch testing, test plans, documentation of test reports etc.

Worked with JCL for testing the Mainframe application

Involved in the system workflow analysis and contributed to the overall workflow diagram for the upstream and downstream application.

Environment:

OS/390, Z/OS, Windows XP, Share point, Email Services, Scrum methodology, MS Word, MS Excel, MS Visio, Outlook, Jira, Rumba, AS/400, Snowflake.

KIA Motors America, CA May 2015 – July 2018

Mainframe Technical Analyst

Description:

Kia Motors America, Inc. (KMA) is American sales, marketing, and distribution arm of Kia Motors Corporation. As a brand, KMA has continued to improve over the years as well and began investing heavily in the quality, design, manufacturing, and long-term research of its vehicles. They continue to invest heavily in its American operations as its cars grow in popularity.

Responsibilities:

Gathered and documented business requirements for existing and future business systems.

Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.

Ensured that project requirements are properly tracked and documented.

Applying customizations using Workflow, Alerts, APIs and AME

Managed several large technology enhancements including new UI design and workflow, API integrations, and client online product catalog and account portal.

Interact with Development Teams and Managers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.

Developed Software Requirements Specification (SRS) and documented product design utilizing UML.

Create and update User Stories in Rally and JIRA corresponding to gathered requirements and identifiable features

Manage the backlog of user stories and work with business to prioritize stories for upcoming iterations

Facilitate estimation and grooming sessions with on-shore and off-shore developers and testers to obtain estimations for stories and arrive at commitment for iterations

Used MS-Visio for flow-charting, process model and architectural design of the application.

Conducted JAD sessions. Involved in preparing project plans and identifying major milestones for each stage as per the SDLC model (RUP Methodology).

Core of PLM creation and central management of a product data and the technology used to access all information and knowledge.

Gathered requirements from JAD/JAR sections with developers and business clients.

Used MS-Project for status reporting and planning.

Supported onsite deployment activities for Legacy system MHS Genesis including gathering site-specific information, end user training, change management/user adoption, and post deployment support

Translated high level requirements into functional and technical user stories in JIRA.

Created acceptance criteria for functional and technical user stories in JIRA.

Ensured all bugs, requirements, mockups and test cases are logged with adequate information into JIRA to assist developers and the team in developing a sound product based on customer standards.

Requirements Gathering/Documentation – Designed and documented detailed business requirements, functional requirements utilizing PMO & Governance approved templates.

Conducted JOINT APPLICATIONS DEVELOPMENT (JAD) sessions with the participation of the users and the stakeholders to gather requirements.

Implemented good practices recommended visual models to draft business requirements by using Use Cases.

Chageman was used to manage all the changes and change requests in the projects. Worked with QA team with the aid of ClearQuest for the bug tracking.

Monitored test scripts developed by QA team to check the integrity of the test plans.

Involved in end to end testing from Quick Quote to the policy activation in both frond end application and in the mainframe.

Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.

Drafted business Use Cases such that any future changes could be easily managed.

Environment:

OS/390, Z/OS, Windows XP, Share point, Email Services, Scrum methodology, MS Word, MS Excel, MS Visio, Outlook, Jira, Rumba, AS/400, Toad, JCL.

Computer solutions & software international, India Sep 2013 to Nov 2014

Mainframe Developer

Description: CSSI specializes in meeting the needs of small businesses to large enterprises. Whether these

needs include web-based software, website development, search engine optimization, hosting services or web

related consulting. We architect, build, and manage web-based systems that manage companies, Domain

Registration, Co.in Domains, Web Hosting’s, Web Designing, Online Soft wares, Resellers Hustings, Window

Hosting’s and Linux Hosting’s, Payments Gateways & Software development.

Gathered user requirements followed by analysis and design. Evaluated various technologies for the

client.

Developed COBOL program for multiple business requirement.

Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).

Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.

Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.

Involved in end to end development and deployment of the code.

IDEA Cellular, INDIA March 2012 to August 2013

Application Developer

Description:

IDEA Cellular is a leading GSM mobile services operator in India with over 72 million subscribers, under brand IDEA. It is a pan India integrated GSM operator covering the entire telephony landscape of the country. With a vision of delighting its customers while meeting their individual communication needs anytime, anywhere. IDEA Cellular has the distinction of offering the most customer friendly and competitive Pre-Paid offerings, for the first time in India, in an increasingly segmented market. This Project has Account, Contacts, Order, CAF and Service Request Modules.

Responsibilities:

Involved in Requirements gathering, analysis and design and documentation as the application was started from scratch.

Developed the business logic and implementation details of the modified and new component.

Involved in designing, developing and testing of COBOL and JCL and associated components.

Developed tools for quick sort, comparex and COBOL code review.

Worked on Scheduling the new JCL jobs through changeman in SAR

Involved in developing multiple SAR reports.

Responsible for Developing unit Test plan, test Case to Unit Test result.

Responsible for developing system testing and integrated testing.

Involved in the implementation of all developed code.

Environment:

OS/390, Z/OS, Windows XP, Share point, Email Services, Scrum methodology, MS Word, MS Excel, MS Visio, Outlook, Jira, Rumba, AS/400, Toad, JCL, chageman.

Education:

Master’s in computer application (MCA) - Anna University, India.

Contact this candidate