Abhay Bindu Sreekumar

SQL Consultant | DBA | Data Analyst | BI Developer

Alpha Data

البلد: الإمارات العربية المتحدة - أبو ظبي
التعليم: ماجستير, Data Science and Engineering
الخبرات: 11 years, 11 أشهر

الخبرة العملية

مجموع سنوات الخبرة :11 years, 11 أشهر

SQL Consultant | DBA | Data Analyst | BI Developer في Alpha Data

الإمارات العربية المتحدة - أبو ظبي
أشغل هذه الوظيفة منذ مايو 2020

 Database Administration and monitoring of Production Databases of multiple clients
 Installation and Configuring of SqlServer Database
 Implementing High Availability options: Always On, Failover Clustering, Mirroring, Log Shipping
 Performance Tuning of SQL Queries
 Created Dynamic SQL Queries and other objects based on requirement
 Building Utilities to monitor database in an efficient way
 Model and design the database
 Analyze data to identify issues, queries raised by business
 Designing dashboards using Power BI, Tableau as per customer requests
 Worked as Data Analyst with one of the clients and developed ETL jobs
 Develop Data Model for applications and create databases
 Develop Stored Procedures, Functions for Application Team
 Develop Data Model for applications and create databases
 Develop Stored Procedures, Functions for Application Team
 SQL Server Database Consulting

Database Designer |Data Analyst | DBA في SecondStep

الإمارات العربية المتحدة - أبو ظبي
يونيو 2018 إلى أبريل 2020

 Database Administration and monitoring of Production Database for issues
 Created queries and reports as per ad-hoc client requests
 Created Stored Procedure/Functions as per client requirements mainly for the purpose of re-usability
 Identified Low performance queries and enhancing them
 Worked on Production Support Tickets
 Worked on Database Change Requests
 Created Views for BI Development
 Worked on Data Migration Projects which involved migrating data from multiple systems along with Data Analysis of existing system to identify the source of data

Database Designer |Data Analyst | DBA في ZCare Technologies LLC

الإمارات العربية المتحدة - أبو ظبي
يوليو 2015 إلى مايو 2018

 Database Administration and monitoring of Production Database for issues
 Understanding the application and designed the database to meet the requirement
 Analyzed data to create mapping between source and target data for migration
 Created queries to extract/transform data from existing system to new system as part of Data Migration
 Worked with developers to review SQL queries which are embedded in Java Code
 Worked on scripts to automate the Database Backups
 Maintained Database Coding Standards and documentation of artifacts

ETL Informatica Developer في Tata Consultancy Services (TCS)

الهند
مارس 2015 إلى يونيو 2015

 Translation of Business Requirements to Technical Requirements
 Extracted data from multiple sources
 Developed Informatica Mappings and wrote SQL Queries to implement the Technical Design
 Worked with Business in implementing and validation of the design

Data Warehouse ETL Informatica/Teradata Developer في UST Global

الهند
ديسمبر 2011 إلى يوليو 2014

 Designed Informatica mappings between sources and targets using Mapping designer and
also tuned them for better performance
 Fixed Production tickets by writing Teradata SQL Scripts
 Monitored the Jobs using WLM job scheduling tool.
 Effectively designed the best cost and time saving design for High Volume Data Load
 Acted as Module Lead managing and mentoring juniors in project related tasks
 Delegating work to the team members, and resolving their work issues, reviewing the code and
get those migrated to higher environments.
 Interacting with onsite team for clarification and tracking the work with them to closure