Curriculum Vitae

Name: SWAPNIL YEWALE

Address: Maharashtra, India

Mobile: +91-808**-*****

Email: adt0sv@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/swapnil-yewale-6b311169/

Skype: swapnily9033

Sex: Male Date of Birth: 09/04/1987 Please Provide Nationality: Indian

Agile Scrum Master Application Development Requirement Analysis Peer Reviews Team Leader

PERSONAL STATEMENT

Self-determined, enthusiastic and technically competent IT professional with over 9 years of extensive and rich IT experience including application development via SQL, PL/SQL, ODI 12c, Oracle 12c, SQL server, bitbucket, Tectia, and, Jira

Hands-on experience in impact/requirement analysis, designing HLD/LLD, implementing and validating with client, peer reviews

Proficient at mapping requirement, custom design solutions for complex and applications along with holds ability of leading team and achieving quality products

Skilled in automating flows using Krish Tool and experienced in automations to resolve issues with Zero touch and reducing manual task, and saving time

A proven team player and leader with excellent communication, relationship/team management/client management, analytical and problem solving and decision-making skills

EDUCATION

Masters of Computer Science (M.Sc.) from Pune University, India, 2011

Bachelor of Computer Science (B.Sc.) from Pune University, India, 2009

Certifications & Trainings:

Agile Scrum Master

1Z0-071 Oracle Database SQL

Oracle certification of Oracle Autonomous Database Cloud 2019 Specialist

Certified course of Hadoop Development

FUNCTIONAL EXPERTISE

Application Development Requirement/Impact Analysis Client Servicing Issue Management Time Management Agile Project Management Product Development Stakeholder Management Unit Testing Software Designing Performance Analysis DB Development System Analysis Data Modelling Reporting & Documentation Shell Scripting Ticket Handling Query Management

TECHNICAL EXPERTISE

Programming Languages:

SQL, PL/SQL, ODI12c, Oracle12c

Database:

DBMS

Environment:

UNIX

EMPLOYMENT CONTOUR

Sep 2021- Present

Senior Consultant Calsoft

Client: Jio Role: Lead Database Engineer

Working on Jio Project as a Senior PL/SQL Developer and leading the team

Actively engaging with product creation team and technically managing teams applications and droving requirements to successful solutions

Mapping and modelling the data in different tables in the system based on the relationship between the entities

Responsible for researching, specifying, and designing complex software systems

Monitoring, analysing and troubleshooting production issues list for daily running processes

Identifying bottlenecks and working on enhancements to reduce resource costs and increase organizational efficiency

Handling solely multiple projects including those involved with managing independent consultants and offshore teams

Supervising, tracking and reporting on project status to the senior management as part of resource planning on various assignments

Building highly sophisticated analytical queries with various grouping sets and analytical functions and enhancing the performance by using Oracle 10g performance features like partitioning, parallelism, materialized views, temporary tables and optimizer hints

Creating and managing DBMS scheduler jobs to enqueue and dequeue messages between systems

Utilising JOB chains and Chain rules to make use of DBMS scheduler effectively

Environment: Oracle 12c Bitbucket, Tectia, platform to develop PL/SQL, UNIX shell scripts

Role: Scrum Master

Working as a Scrum Master and leading the team

Defining project scope and scheduling while focusing on regular and timely project delivery

Assisting in team development while holding teams accountable for their commitments and leveraging organisational resources to improve capacity for project work increasing the average time to deliver new features by 15%

Supporting the product owner in managing customer expectations for project deliverables and managed Internal stakeholder communications resulting in a 21% increase in customer engagement with new features

Defining and managing a well-defined project management process and championing ongoing process improvement initiatives to implement best practices for agile project management

Jan 2021- Jun 2021

Senior Consultant Technology Virtusa

Client: CITI Role: Lead Database Engineer

Worked on Citibank project as a Senior PL/SQL Developer and led the entire team

Performed requirement analysis, design, DB development and Unit Testing

Mapped and modelled the data in different tables in the system based on the relationship among the entities

Researched, specified and designed complex software systems

Monitored, analysed and troubleshoot production issues list for daily running processes

Identified bottlenecks and worked enhancements to reduce resource costs and increase organizational efficiency

Handled solely multiple projects including those involved with managing independent consultants and offshore teams

Supervised, tracked and reported Project status to the senior management as part of resource planning on various assignments

Build highly-sophisticated analytical queries with various grouping sets and analytical functions and enhanced the performance using Oracle 10g performance features like partitioning, parallelism, materialized views, temporary tables and optimizer hints

Created and managed DBMS scheduler jobs to enqueue and dequeue messages between systems. Used JOB chains and Chain rules to make use of DBMS scheduler effectively

Environment: Oracle 12c Bitbucket, Tectia, platform to develop PL/SQL, UNIX shell scripts

Role: Scrum Master

Worked on Citi bank project as a scrum master and leading the team

Defined project scope and schedule while focusing on regular and timely delivery of project

Assisted in team development while holding teams accountable for their commitments and leveraging organisational resources to improve capacity for project work increasing the average time to deliver New features by 15%

Supported the product owner in managing customer expectations for project deliverables and managed internal stakeholder communications resulting in a 21% increase in customer engagement with new features

Defined and managed a well-defined project management process and championed ongoing process

Implemented Improvement initiatives to implement best practices for agile project management

PRECEDING EMPLOYMENT

Organisation

Designation

Role

Duration

TCS (IPS Group)

Senior PL SQL Developer

Lead Database Engineer

Dec 2018- May 2019

Amdocs

Senior Subject Matter Expert

Technical and Business analyst

Jun 2014- Nov 2018

IBM (on WDC/ Expertise IT payroll)

Software Developer

Software Developer

Jun 2012- Nov 2013

ACHIEVEMENTS

Received special bonus as a token of appreciation for proactively handling the releases

Received appreciation from business and site counterparts for handling post-release issues and customer concerns

Awarded R&R for the team contribution

Prepared process documents for easy reference for most re-occurring issues, the document also includes SQL queries and table description used in daily ticket handling

Recognized by the client with a certificate for an outstanding effort

Trained lot of employees and organized knowledge sharing session

Contact this candidate