Yashaswini Sunilkumar
Senior Software Engineer
Collierville,United States
Summary
Experienced, result-oriented, resourceful and problem solving Senior Software Engineer over 6 years of experience with leadership skills. Involved in complete Software Development life-cycle (SDLC) of various projects; translated business requirements into technical solutions and compiling, transforming and analyzing complex information through software. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
7
7
years of professional experience
3
3
years of post-secondary education
3
3
Certifications
Work History
Senior Software Engineer
First Horizon National Corp.
Memphis, TN
10.2019 - Current
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
- Extensively worked on View, Stored procedures and SQL queries for loading the data(staging) to enhance and maintain the existing functionality.
- Responsible for up gradation process of IBM DataStage from version 11.5 to 11.7.
- Designed the job to hit the API with a request upon JSON response, converted the JSON file to a readable CSV format using Python script.
- Applied ETL rules and notification activities for the jobs for any failure or error accessing API's, Databases.
- Developed some basic routines (Before-After, Transform function) used across the project to remove special characters.
- Involved in integration planning, tracking and business process for new mergers and acquisitions bank involved.
- Designed Data masking techniques to mask sensitive information's.
- Trained and mentored junior developers and engineers, teaching skills in DataStage, SQL query and working to improve overall team performance.
- Participate in AGILE DATA DELIVERY MEETING where we discuss the progress of the project and take necessary steps for the project to be completed successfully.
- Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
- Implementing proofs of concept for data migration from On-premise to cloud using Snowflake.
Software Engineer
SLK Software Services
Bengalore, Karnataka
10.2015 - 10.2019
- Analyzed business requirement document from the client and developing the jobs in IBM DataStage.
- Collaborated with other teams in High Level design documents for extract, transform and document for mapping the files from source to target and implementing business logic and load ETL process, Cobol Metadata descriptions, file layouts and flow diagrams.
- Improved and tuned the performance of jobs and SQL quires used in extracts.
- Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
- Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs and enhancements.
- Implemented multi-node declaration using configuration files (APT_Config_file) for performance enhancement.
- Implemented UNIX shell scripts for processing files to mailbox, mainframe and Automate Datastage jobs.
- Involved in .net code rewrite into ETL.
Software Intern
Excel Soft Services, Private
Mysore, Karnataka
02.2014 - 07.2014
- Collaborated effectively with members of software development team and personnel in other departments.
- Prepared and submitted reports and other documentation to assist development team members.
- Assisted in developing applications for Education Data Analytics using ASP.NET, C Sharp.
Education
Master of Science - Computer Applications
Maharaja Institute of Technology
Mysore 06.2011 - 10.2014
Skills
IBM Infosphere DataStage, Pentaho, Rivery
Perl, Shell, Bash and Python
Oracle, SQL Server, MySql, Db2, Teradata
Snowflake, SnowSql
Jira, qTest, HP Alm
Zena Scheduler
Accomplishments
Best Individual Contributor (09/2021)
SLK America Inc
Budding Star (02/2016)
SLK India Pvt Ltd.
Certification
Certified Data Warehouse- Hands on Essentials - Snowflake
Timeline
Certified Data Warehouse- Hands on Essentials - Snowflake
04-2022
Digital Skills: Web Analytics - Accenture
04-2022
Web-facing workloads with AWS security services - Amazon
04-2022
Senior Software Engineer
First Horizon National Corp.
10.2019 - Current
Software Engineer
SLK Software Services
10.2015 - 10.2019
Software Intern
Excel Soft Services, Private
02.2014 - 07.2014
Master of Science - Computer Applications
Maharaja Institute of Technology
06.2011 - 10.2014