AKWIN DHAS. L

+91-958*******

Sr. Tech Lead

ad453c@r.postjobfree.com

https://www.linkedin.com/in/akwin-lopez-a9194711a/

SUMMARY

10+ years' experience in IT, SDLC

10+ years of experience in RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures, User Defined Functions using SQL Server, T-SQL.

8 years of experience in creating reports using SSRS (BI)

8 years of experience in Visual Studio to analyse the data between source systems and target system (BMC Remedy).

5 Years of experience in Data Warehousing using Star schema

5 years of experience in Migrating from MS SQL Server to Azure SQL DB using Data Migration Assistance (DMA), MS SQL Server to PostgreSQL, DB2 to MS SQL Server and SAP BO to SSRS Reports

5 Years of experience in DB Deployment

5 years of experience in Project Management tools like JIRA, Teams Planner, Wrike

4 years of experience in version control tools like Git Hub, Bit Bucket

3 years of experience in creating PostgreSQL DB objects using DBeaver tool, and PostgreSQL Compare tool

3 years of experience in net Entity framework & Metro framework

Functional and technical experience in analyzing/designing schemas and data objects and considerable knowledge on Logistics, Insurance and ERP domain as well.

Have worked on various domains such as Health care, Retail, Mortgage and involved in projects right from requirement gathering to implementation into production and support activities

Participated Innovation Challenge and Awarded multiple times by Fannie Mae for presenting the best Automation Testing Tool and for Zero Defect Production releases

Received the best Team Leader award from current company

Contribute to the work of the Product Manager to define a product differentiation strategy

Overseeing and ensuring delivery of all aspects of data analysis, mapping and transfer

Create the product vision and roadmap, which accomplishes the goal of the vision.

Manage multiple projects at one time & monitoring the work of junior staff.

QUALIFICATION

B.E. (ECE) from DMI Engineering College in 2009-2013 with 78%

PROJECTS HANDLED

AUB – Working as Senior Tech Lead with D4 Insite from Feb’23 to Feb’24

To integrate the data from the Libya entity into the enterprise data warehouse (EDW) and perform reconciliation and FP activities. The project also involves generating reports using the Risk reporting (CMIS) to provide insights and analysis on the performance of the Libya entity

Migrated the CITI Bank data with Ahli United Bank data using SAS & SSIS

With over 2M customers over 8 countries, supporting everything from each branch

Data Load & Data Visualization done by using SAS, SSIS, SSRS & Power BI

Roles & Responsibilities:

I lead a team of 7 members and help them to understand the picture of the requirement and assist them to reach their goals by delegating tasks to them.

Also ensure proper data load into target tables which should satisfy all the filtration and business logics through SQL Scripts and in case of any exception then analysis the same.

Validate all the data by column-to-column comparison and provide the Quality code to the Production.

Prepare the Task and Module estimation documents.

PHS – Working as Tech Lead with Hexaware from Oct’ 21 to Feb’23

Performance Health Systems specializes in delivering advanced technology solutions through its health and wellness equipment. phs Group are the leading hygiene services provider in the UK, Spain and Ireland.

With over 120,000 customers over 300,000 locations, supporting everything from restaurants to offices, and from hospitals to schools, we meet the needs of up to 100 million people.

Healthcare, washroom and floor care hygiene are our business, and alongside our hygiene experts we have specialist businesses meeting the needs of specific businesses.

Roles & Responsibilities:

I lead a team of 11 developers and help them to understand the big picture of the requirement and assist them to reach the goals by delegating tasks to them.

Involved in creating the Table, Procedure and executed the same and validated the results in reported emails.

Migrated the reports from SAP BO to SSRS.

Also ensure proper data load into target tables which should satisfy all the filtration and business logics through SQL Scripts and in case of any exception then analysis the same.

Validate all the data by column-to-column comparison and provide the Quality code to the Production.

Prepare the estimation documents.

Validate all the data by column-to-column comparison and provide the Quality code to the Production.

Give Sprint demos to the Product Owner at end of every 2-week Sprint with all the tested scenario and test case results.

URP - Worked as Sr. Database Developer with SRM Technologies from Jan’19 – Oct’ 21

The Objective of the project is to develop an end-to-end admission process in SRM University and track a student's details and admission process online, which helps in managing the students’ application, Counselling and Enrollment activities.

Roles & Responsibilities:

Requirement gathering, preparing functional and technical specifications, designs, develop solutions, perform unit testing and debugging, implementation and support.

Write Stored Procedures, Functions and Triggers as per the requirements.

Performing DB Maintenance, DB Backup, Recovery & Security.

Schedule Jobs, DB Monitoring, Db Clean-up

Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to PostgreSQL database.

Responsible for understanding and writing SQL Queries for extracting reports.

FMS – Worked as Sr. Database Developer with GWC Logistics from Sept’16 – Dec’18

FMS is a real-time GPS tracking platform for fleet management to track any type of vehicle with FMS and optimize operation costs, increase efficiency and save time

With FMS, you can check vehicle location and trip history, set routes, send messages to drivers, manage vehicle and driver groups, and analyze vehicle and trip. Manage drivers working, driving and resting times and remotely download tachograph unit data with tachograph solution

SSMS - Worked as Database Developer with gbc Technologies from Aug’13 – Aug’16

Smart School is a window-based application management, which provides the ability to continuously monitor the student performance and report the periodic assessments of the teachers and parents.

Roles & Responsibilities:

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines

Coordinated with the offshore development team to provide them with the necessary requirements with the stored procedures and packages and the necessary insight into the data.

Performed Database Administration of all database objects including tables, indexes, views and procedures.

Ensure each story has the correct acceptance criteria.

Gather, manage and prioritize the product backlog.

Ensure close collaboration with the development team.

Work closely with engineering and quality assurance to ensure the right customer problem is solved.

Work with cross-functional teams in planning product releases.

Prepare the technical documents.

PERSONAL DETAILS

Father Name : G. Lopez

Date of Birth : 11-11-1992

Passport Number : R4727037

Languages : English, Tamil

Gender : Male

For details of projects undertaken, please refer the attached Annexure

DECLARATION

I hereby declare that the above-furnished information is true to the best of my knowledge and belief.

Date:

Place: Chennai. AKWIN DHAS. L

Contact this candidate