Post Job Free

Resume

Sign in

Data Engineer

Location:
Cottage Grove, WI
Posted:
February 26, 2021

Contact this candidate

Resume:

SHASHANK KUMAR

adkhxv@r.postjobfree.com +1-608-***-**** 3231 W Main ST, Apt 205, Sun Prairie, WI, 53590 www.linkedin.com/in/shashank-kumar-20082723 SUMMARY OF PROFESSIONAL EXPERIENCE

* ***** ** ******ence in all phases of the Software Development Lifecycle (SDLC) and Agile Quality Assurance with emphasis on Data analysis, Business intelligence, Data Migration and Report testing. Adept at creating Technical Data Mappings, test cases, test plans, test reports, writing Complex SQL queries, perform Data Profiling, prepare ad-hoc report for business decision making and performing Data Migration activities. EDUCATION

IEC College of Engineering & Technology, Greater Noida Jul 2007 – Jun 2011 Bachelor of Technology, Information Technology Percentage: 68.16 Courses – OOP, Data Structures, Design and Analysis of Algorithm, Operating Systems, Computer Architecture, Software Engineering, Data Mining, Datawarehousing, Database

TECHNICAL SKILL SET AND QUALIFICATIONS

ETL Tools: Abinito, Talend, SSIS, BODS

Operating Systems: Windows XP, Windows 7, Windows 8, Windows 2003/2008 server, Linux Cloud Platforms: AWS, Azure

Databases: Oracle, MySQL, SQL Server

Defect Tracking: JIRA, HP Quality Center

Data Visualization: Tableau

PROFESSIONAL HISTORY

Analyst, Data Architecture Fiserv INC. Jul 2019 – Present Responsibilities and Achievements:

• Performing the role of a QA and Data Lead heading a team of six members located at onshore and offshore and overseeing all the testing and Data Analysis activities for a US based 3rd party benefits administrator who want to migrate 20K+ clients and their 1M+ customers from multiple legacy systems into AWS based benefits account platform.

• Extensive data analysis & profiling, and discuss rules with Business SMEs, Design technical data mappings, procedures/views using MySQL.

• Execute Data Migration activities during UAT & Go-Live phase, Migration testing by writing SQL queries to test the integrity of the data, Data reconciliation by validation report testing.

• Investigating issues occurred while system testing, regression testing and UAT, Providing Production data support - Analysis and fixes.

• Prepared regression suite to test the common areas of migration through regression suite, which in turn resulted in quick identification of bugs and 50% increase in the productivity.

• Gained a deep knowledge of HSA, HRA and FSA plans.

• Logging and keeping track of defects and bugs using JIRA tracking tool. Senior Quality Analyst Fiserv India Private Limited Feb 2015 – Jun 2019

Responsibilities and Achievements:

• Led a team of four and identified areas for business improvement and developed flowcharts of current and future business processes.

• Expertise on technical documentation as project plan, development strategy, user manual, test and implementation strategy.

• Consulted with functional unit management and on-site Client to identify, define and document business requirements and objectives, implementing test plans using agile methodology, test cases in accordance with the flow of the data.

• Writing complex SQL queries to verify that the data is transformed correctly according to the business requirement and data mapping.

• Conducted test plan reviews with the cross functional teams and carried out estimation planning of resources in the team based on the scope of work which resulted in a 30% decrease in the overall bug count. System Engineer, Tata Consultancy Services Jan 2012 – Jan 2015 Responsibilities and Achievements:

• Successfully served as a Software Test Engineer/BI Tester in Enterprise Data warehouse migration projects.

• Achieved proficiency in all stages of the SDLC, STLC and Bug Life Cycle.

• Prepare test cases, test data and write SQL queries to validate the source to target Extract Transform and load of data.

• Gained expertise in tracking Bug reports using Bug Tracking and test management Tool- HP Quality Center.

• Involved in defect triage, test case and test-results sign-off meetings with stakeholders. CERTIFICATIONS/TRAINING

• AWS Certified Cloud Practitioner

• Microsoft Certified: Azure Fundamentals

• Basic of Financial Market by NSE India.



Contact this candidate