Mayank Kumar

Project: Keurig Dr Pepper

• Involved in requirement gathering and planning sessions for new data ingestion requests
• Worked as individual contributor to perform base level activities before starting actual development work
• Developed data ingestion pipelines, showcasing versatility in handling multi-type source-based systems and files like both structured and semi-structured (CSV/TSV/JSON etc.)
• Creating Facts/Dimensions tables for Retail data
• Engineered robust ingestion processes utilizing various protocols, including SFTP (Secure File Transfer Protocol) and Azure Data Lake Storage (ADLS) Blob in bulk data load, demonstrating adaptability in addressing unique data transfer requirements
• Streamlined data workflows by incorporating efficient mechanisms for extracting, transforming, and loading (ETL) data from a variety of sources, contributing to improved data accuracy and timeliness
• Created snowflake objects/based for complete flow of source to target tables data load, scheduling Tidal Enterprise Scheduler job groups along with defined calendar and frequency to comply with business requirements
• Involved in the standardized process of gathering requirements, file level details, frequency, file type, file format, file pattern, file compression, required load type etc
• Based on the requirements, PO Tech Spec review, followed by Peer Review, then Model Review and Code Review with the whole team to make it ready before moving to QA
• Expertly managed numerous production deployments for the ingestion of diverse data formats, including structured and semi-structured files, showcasing adaptability and proficiency in handling complex data structures
• Collaborated seamlessly with cross-functional teams to design and implement innovative solutions, contributing to overall success of data engineering projects
• Collaborated with stakeholders to understand specific source system intricacies, tailoring ingestion processes to accommodate different file formats and structures, ensuring a seamless and standardized integration into Snowflake

Project: Staples Inc

• Data Validation of both Teradata and Snowflake databases
• Created python scripts for verification and validation of snowflake data warehouse objects during migration
• Assessed Teradata to snowflake data migration issues and compiled findings along with required solutions
• Established company python automation methodology, frameworks and tools
• Updated and maintained project issues/defects/processes documentation for detailed recordkeeping
• Trained team members in python automation programs and framework
• Debugged python automation scripts and located root causes of problems by reviewing configuration files and logs
• E2E python scripts into all layers of applications to find data related issues from database level to schema based on all tables/views
• Project: Staples Inc

Project: PPCM (Planning Platform Configuration Management)

• Prepared Test Strategy and Test Plan for projects, and activities such as Requirements Review, Design Review, Test Strategy Review and Test Case Review
• Implementation of Automation Framework using Selenium for UI modules
• Automation testing using Selenium Web Driver with Python using Digital Test Framework
• Implemented best practices for enhancing performance of team both in terms of automation testing, manual testing and data validation testing
• Agile methodology-based project work based on every 2 weeks Sprints and User stories
• Successfully completed 8 Quarterly Product releases till now
• Project: PPCM (Planning Platform Configuration Management)

Project: LTCG (Long Term Care Group)

• Extensively interacted with developers, business & management teams to understand business requirements and design document specifications
• Developed Test Plans, Test Cases and executed Test Scripts for LTCG Project
• Developed SQL test scripts based on technical specifications/Data design documents and Source to Target mappings
• Defects identified in testing environment are communicated to developers using incident management tool HPSM
• Prepared Daily Status Reports with details of total, executed, pass, and fail test cases and respective defect status
• Extensively tested several SSRS Reports
• Manual/Automation Testing of Reports/feeds generated by SQL for different carriers
• Individual contributor role
• Project: LTCG (Long Term Care Group)

Project: JNLI (Jackson National Life Insurance)

• Managed offshore QA resources for ensuring timely project completion; developed quality standards through participating in initial software development stages; validated and enhanced existing QA plan and strategy
• Designed Test Strategy and Test Plan for all modules; review activities such as Requirements Review, Design Review, Test Strategy Review and Test Case Review
• Automation testing of web based applications using Selenium Web Driver with Java using Data Driver framework
• Created comprehensive software testing RFPs that included resource requirements, schedule assumptions, and scope based on inputs from Development, Sales, and System Test Management
• Defect logging and defect retesting in Test Management tool
• Providing Knowledge Transfer for different applications to whole team
• Created Daily & Weekly Status Reports for Stakeholders
• Quality Metrics & Quality Audit Lead
• Provide timely deliveries -Deliver assignments on schedule and within estimate with high quality
• Involved in hiring of qualified software testing resources for project and follow-up/feedback on selection
• Project: JNLI (Jackson National Life Insurance)

Project: DuPont (E I Du Pont de Nemours and Company)

• Analyze JCL, COBOL Codes for requirement gathering of different applications
• Manual testing of Applications running in Mainframe and Linux server
• Validating data for Online Transactions (CICS) and Batch (Jobs) results
• Defect logging and defect retesting
• Creating JCL's for Testing Environment
• Established engagement with Onshore Team for testing and data validation part
• Lead Mentor and support junior associates within team
• Plan knowledge sharing sessions, trainings sessions, review deliverables of Junior associates and support junior associate's deliverables
• Conduct formal training and KT sessions
• Project: DuPont (E
• I
• Du Pont de Nemours and Company)

Project: CPR (Canadian Pacific Railway)

• Worked on CPR business applications residing on mainframes system
• Manual testing in Mainframe environment and Linux server
• Validating data for Online (CICS) and Batch (Jobs) results
• Backend Testing (DB2) to verify data for multiple batch/online applications
• Defect logging and defect retesting
• Creating JCL's for Testing Environment
• Module lead for Batch applications
• Career Level Achievements: Promotion: 1 Testing Engineering Analyst to Testing Engineering Senior Analyst (Test Lead) position on 3rd Nov 2014
• On The Spot Awards: 5
• Client appreciation for quality work in less time
• Project: CPR (Canadian Pacific Railway)

Project: ANA (All Nippon Airways)

• Worked on ANA MASCOT, all three systems have been integrated as per client requirements
• Now ANA can track their inventory, service history of each part (engine and non-engine) and also supply chain for each part using one centralized system
• Experience on Retail MASCOT system which was purely for Boeing 787 Dreamliner airplane
• Implement software solutions as per FSDs (Coding)
• Validating software solutions as per design (Bug fixing)
• Unit testing & Functional testing
• Created SQL Queries using SQL Developer for Database Testing
• Project: ANA (All Nippon Airways)