Data Analyst Quality Engineer

ASHISH KAYASTHA

Georgetown, TX ***** 443-***-**** advqr0@r.postjobfree.com www.linkedin.com/in/ashish-kayastha/

Professional Summary:

●Senior IT Consultant and Military Veteran with proven experience in Business Intelligence, System and Data Analyst, conducting data profiling analysis, process curation, and data quality in an information technology space.

●Possess a comprehensive background in written and oral communication, data mapping, prototyping and wireframe, RDBMS, Manual-Automation Testing, and continuous process improvement.

●Proven performance in linking corporate vision with the delivery of desired results through empowerment, development, and utilization of people, processes, and technology.

●Career supported by a Master of Science in Information Systems Technology.

Skills:

●Project Management

●Quality Assurance

●Data Analytics Design

●Data Science

●Strategy Development

●Master Data Management

●Data Governance/Data Quality

●Business Intelligence Reporting

●Data Modeling

Advance Excel

Technical Skills:

Software: MS Office Suite, SharePoint/ Visio/Project, Ralley, Requisite Pro, Team Foundation Server.

Testing Tools: ALM/Quality Center, SoapUi, Fitnesse, Postman

Programming Language: SQL, Basic Java, XML, HTML, Python, Fitnesse Script

Database: MS Access, Oracle, SQL Server, DB2 (SQurriel SQL, Teradata, Data Studio), MySQL.

Methodologies: Unified Modeling Language, Agile-Scrum, Waterfall, BPMN

Business Intelligence Tools: Business Objects, Crystal Report, SSRS, Tableau, QlikView, iRise, Power BI, Juypter, Visual Studio.

Education:

Master of Science Information System Technology Concentration in Internet/Web Design

Wilmington University, May 2015

Bachelor of Science Pre-Actuarial Mathematics the University of Nebraska at Omaha, Dec 2010

Professional Experience:

United States Army Reserves – Austin, TX Aug 2015 – Present

CBRN Specialist

●Fulfilled ordnance, maintenance, decontamination, and disposal responsibilities in support of domestic and global Chemical, Biological, Radiological, and Nuclear (CBRN) operations.

●Provided gas chamber training and awareness to military personnel, ensuring the proper use of the M50 protective mask

●Established and confirmed the protection of personnel from CBRN contamination; decontaminated personnel and equipment in a timely manner

●Advised, managed, and performed environmental protection programs, coordinating the relevant laws and regulations accordingly

●Gathered and analyzed information, identified areas for improvement, drafted findings and recommendations, and prepared reports in accordance with executive guidance and professional standards

General Motor- Austin, TX Oct 2021 - Sep 2022

Business/Data Analyst

●Worked with 5-10 GM EPP (Error Proofing Platform) team member and Torque Strategy configuration to help in the improvement of the vehicle manufacturing validation process.

●Created EPIC, Features, User Stories, and use case scenarios for the EPP system.

●Worked on Entity Relation, workflow diagram, and mockup for ease of understanding of the business process.

●Gathered business and functional requirements working with business SMEs, and technical engineers.

●Validated and logged defects/bugs in the TFS Azure server.

●Analysis Business reports/ data set in jupyter-python importing from excel/ multiple data source.

Ford Motor Company – Dearborn, MI Oct 2019 – Jun 2020

Data Scientist/ Profiling Analyst

●Profiled technical and business metadata, context curation, lineage and relationship, data quality, and profiling usages.

●Partnered with SME, Data Steward Lead with 8-15 project team member analyzing and documenting requirements.

●Implemented plans for extracting and loading HIVE metadata in a metadata repository within the Big data- Hadoop ecosystem.

●Facilitated Extract/Transform/Load (ETL) process validation to ensure data completeness, correctness, and transformation with organizational requirements.

●Created business process documentation and diagrams for users – to populate data assets in the Enterprise Data Catalog (EDC) environment.

●Curate Data profiling, Created PowerBI dashboard, Business terms/ Data domain, and association with metadata through Machine Learning process.

●Participated in the training and development of business and technology partners; led various exercises on quality processes and best practices.

Xylem Inc. – Rye Brook, NY July 2019- Oct 2019

Business Analyst

●Mastered customer and vendor information in Informatica Master Data Management (MDM). Cleansed data, ensured data standardization, stored golden records, and constructed MDM metric reports in the Tableau reporting tool.

●Initiated meetings with business users, small and mid-size enterprises (SMEs), and IT team members to discuss organizational requirements; held daily meetings with onshore and offshore teams to provide status updates

●Identified and obtained requirements critical to the business process flow, creating MDM metric reports as needed; prepared and utilized a data mapping document through Report SQL.

●Participated in the Extract/Transform/Load (ETL) process by configuring various sources to target databases; supported the Secure Shell File Transfer Protocol (SFTP)/Amazon (AWS)-S3 process for transferring report files to the Tableau SQL Server

●Developed, updated, and maintained report designs and interactive dashboards with the Tableau vendor.

Ford Motor Company – Dearborn, MI January 2018 – June 2019

Quality Engineer/ Analyst

●Served as the Quality Engineer for a project involving consumer mastering of Service Component Architecture (SCA-C) data, refactoring Global MDM Framework (GMF) business processes, and standardizing quality stage interfaces.

●Prepared and updated Use Case documents in order to enhance existing services and Proof of Concept (POC) solutions for new services

●Reviewed and refactored Java code as required; imported the associated Java file from AccuRev/Github to a Rational Application Developer (RAD)/Eclipse workspace

●Conducted daily SCRUM meetings to capture and address concerns from the IT, product management, and business teams

●Performed Gap Analysis to identify the root cause of issues; tracked data defects in an issue log using a defect management tool (ALM/Quality Center) and updated tasks in Rally as deemed appropriate

●Developed unit and functional test cases in SoupUI, Fitnesse, and Postman for manual or automation testing; executed Extensible Markup Language (XML) request and response validation, collaborating with customers as needed to complete User Acceptance Testing (UAT).

●Designed and implemented SQL queries for reports and data validations in DB2.

Department of Health and Environmental Control – Columbia, SC March 2015 – November 2015

Technical Business Analyst

●Implemented a Data Governance-Master Data Management (IBM MDM) project to design one master record from different systems including Healthcare, Medicare/Medicaid, and finance operations.

●Communicated with data stewards and users to better understand needs and areas for improvement, providing solutions utilizing a structured Software Development Life Cycle (SDLC) approach; verified and validated associated Medicare/Medicaid eligibility requirements.

●Developed a Master Data Management (MDM) system metric, document survivorship process, data mapping, logical data modeling, and sharing documents

●Developed business process diagrams and Entity-Relationship (ER) diagrams, creating Pseudo code and SQL queries to filter data within the Oracle/SQL database

●Established and maintained a traceability matrix (RTM) to ensure the completeness of requirements during various SDLC stages.

Cotton Valley Distribution, LLC - Edison, NJ March 2014 – February 2015

UI Designer/Business Analyst

●Upgraded legacy system to New Customer-based platform. Restructured and modified client User Interface website creating a more user-friendly and effective Customer web browsing experience.

●Worked closely with SME users defining features and interaction, leading to high-fidelity mockups of use case scenarios for the design and product teams.

●Defined User stories using Case Scenarios and narratives. Wrote Test Cases and Test Scenarios. Tracked UAT issues/bugs and prepared reports.

●Produced sketches, wireframes, and clickable prototypes for testing and illustration purposes.

●Effectively communicated UAT results between Users and the Development team, and provided recommendations for Change Control Requests (CCR).

Pima County- Tucson, SC October 2011- March 2013

Business Systems Analyst

●Developed CRM application and Reporting with a focus on translating business needs into solutions.

●Translated business requirements into Technical Design specifications and Mockups for implementation of the “Overtime Reporting” system for the Finance and HR group.

●Facilitated Joint Application Development (JAD) sessions, and workshops with the development team, business stakeholders, and end-users.

●Extracted data from Database/ Data Warehouse for data mapping and mart, FMS to AMS.

●Planned Test cases, Test scenarios, and implemented them on the interfaces in the test environment.

●Executed System Test and worked with the customer on a manual workflow for UAT ensuring reports confirm the specifications of business requirements and performance criteria.

Contact this candidate