Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Abhishek Kumar

Senior Software Engineer
London

Summary

Experience of 8+ years on Database (SQL SERVER, MYSQL, MongoDB, ORACLE ),AZURE DEVOPS, SSIS, Microsoft SQL Technology, SSRS, PYTHON, POWER BI, Tableau and SQL Query Optimization and Administration, Azure Cloud Architecture presently working in Maveric Systems Ltd.

Overview

8
8
years of professional experience
7
7
years of post-secondary education
2
2
Certifications

Work History

Senior Software Engineer

Maveric NXT LTD
London
10.2019 - Current
  • It is a UK based bank handing millions of customers with different types of products like Mortgages, Debit & credit cards, Loans, Accounts etc
  • Responsibilities:
  • Work very closely with Business as bridge between Business and Data by extracting data and providing it to business in Visualized form
  • Create pipelines and repos and deployments are also a part of my work as all deployment processes follow automated Azure cloud deployment so
  • Handle daily billions of records and various USP, VIEWS, JOBS, ETL developments and deployments
  • Closely work with Business and decide the requirements and architecture for the development and execute it
  • As a bank, It has different sources for data like cloud sources, databases, text files, Excel files etc
  • And are getting integrated with SSIS with no filtration and validation
  • I transformed it to remove duplication and proper validation for all types of data for tables.
  • Checked client code for bugs and weaknesses using approved troubleshooting methods.
  • Provided technical support using knowledge of complex technology to solve problems and support new projects.
  • Collaborated with clients to define solution requirements.

Senior Software Developer

Data Ratings Intelligence
Bangalore
05.2019 - 10.2019
  • Data Ratings Intelligence: It's a completely different platform to remittance with the help of authorized agent and dealer with fully automated API verification from GST, Pan Card, Aadhar, Bank Account ,Live exchange rates,Pay through payment gateway,Seamless documentation, Upload KYCs Online remittance confirmations,Initiate your remittances through a few clicks,As its startup having number of companies under it, It is in foreign exchange, Investment, Remittance, Educational Fields etc
  • Doing daily new additions and changes for companies
  • Building all new and changing stored procedures required
  • As few companies is in starting phase so doing architects and modelling for databases and new change implementation
  • Doing architect for reports, ssis packages, ssas packages and building it
  • As it is always live so all changes required for production environment are done
  • Mentoring and helping resources to get job done within deadline
  • Did Data Analytics of data coming from Dealers, agents, customers, rates, DMCs etc
  • Tableau/SSRS/Power BI for data Visualization
  • Project: Accenture: ASW News page (Accenture under taken company)
  • Developed databases, programs and processes for integration and implementation across enterprise.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.

Software Analyst

Accenture Pvt. Ltd.
Bangalore
08.2016 - 05.2019
  • It is a UK based bank handing millions of customers with different types of products like Mortgages, Debit & credit cards, Loans, Accounts etc
  • Responsibilities:
  • Work very closely with Business as bridge between Business and Data by extracting data and providing it to business in Visualized form
  • Create pipelines and repos and deployments are also a part of my work as all deployment processes follow automated Azure cloud deployment so
  • Handle daily billions of records and various USP, VIEWS, JOBS, ETL developments and deployments
  • Closely work with Business and decide the requirements and architecture for the development and execute it
  • As bank systems have different sources for data like databases, text file, Excel files etc
  • And are getting integrated with SSIS with no filtration and validation
  • I transformed it to remove duplication and proper validation for all type of data for tables
  • The Family Office(TFO), Bahrain : It's a platform to Provide a conventional asset management services including wealth, fund and portfolio management
  • As company, established in 2004, was using Jitter bit for API management and MS SQL Server and MS SSIS for database and Integration service respectively
  • Responsibilities:
  • As only database developer, I analyzed whole existing database and APIs to transform API platform from Jitter Bit to Micro-service with completely new db design along with optimization
  • Whole database which was developed in 16 years, I transformed with new design and new tables and stored procedures suitable for Micro-service input in 2 months
  • As there were different sources for data like database, text file, Excel files etc
  • And were getting integrated with SSIS with no filtration and validation
  • I transformed it to remove duplication and proper validation for all type of data for tables
  • As Database was AWS cloud so I helped client for load balancing and high availability to provide stability
  • I helped QA team to perform different types of testing including automation testing for existing data as they are related to money
  • Client: Tennabo
  • It's a complete platform to bring sellers, organizers and people together to connect through organizing parties, events, concerts, marriages
  • Responsibilities:
  • Project was from scratch so I was responsible to architect and design whole database after analyzing complete requirements (taking directly requirements from client itself) and APIs
  • MONGODB has been used in project so it was new experience and learning process to be part of this project
  • Now project is up and running
  • Work closely with new Micro-service team to design their APIs and QA team to test
  • Client: Advith
  • It is a multi-tenant platform where there is one parent company providing CA firms and companies a platform with separate databases to bring their clients to do different Services
  • Responsibilities:
  • Completely new experience to architect and design multi-tenant platform which should be automatic to onboard each tenant and do smooth process
  • It is tax and audit related company where data should be handled carefully as directly related to money, I have designed it accordingly
  • Solely created design, tables and stored procedures and modifying according to APIs and still working on sprint wise
  • As it is project from scratch, taking requirements, design and modifying accordingly
  • Also Working on different types of reports creation which will help clients to generate invoices automatically
  • Have written Python code for analyzing bank statements for PDF, Excel, Image forms., Details
  • Project ASW (Accenture Software’s)-
  • It develops/maintains retail applications
  • It provides solution for Business workflow
  • It provides solution for reporting according to client requirement
  • It provides best solution to vendor and distributor
  • Role in Project
  • Extensive experience with databases SQL Server 2008 as well as developing SQL code through various procedures, functions, views and triggers to implement the business rules
  • Automate various manual tasks using SSIS
  • Designed and developed Packages and Data flows in SQL Server SSIS
  • Creating SSRS reports based on client requirement and deploying RDL files on production
  • Migration of packages between environments as well as Production Support
  • Migration of Data Bridge Tasks to SQL Jobs
  • Automation of packages using SQL Server Jobs
  • Monitoring jobs through Log providers
  • Also creating the log files through batch files
  • Developing T-SQL stored procedures, functions, triggers, views
  • Debugging through SQL profiler to study the behaviour of the query
  • Optimizing SQL Server performance
  • Optimizing procedure to reduce the overall time of execution either in SSIS or Application
  • Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system
  • SSAS Analysis on various fields to make business and client's business profitable
  • Tableau/SSRS/Power BI for data Visualization
  • Python & Azure
  • Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
  • Analyzed work to generate logic for new systems, procedures and tests.

Associate Software Engineer

Accenture Pvt. Ltd
Bangalore
03.2015 - 11.2016
  • Details
  • Project Roche
  • It develops/maintains healthcare applications
  • It provides solution for Business and healthcare workflow
  • It provides solution for reporting according to client requirement
  • The world's third-largest independent biotech
  • Role in Project
  • Application development and application upgrades
  • Implementing change requests for existing/new functionality
  • SQL development activities like creating, modifying and altering database objects like functions, procedures, views and tables
  • Data extraction, transformation and loading from Legacy and ERP systems
  • Database Backup, restoration and migration
  • Implementing win batch script for file handling
  • Providing end to end support to clients during UAT
  • Unit testing, regression testing UAT and Prod
  • Deployment of the package and complete support post deployment
  • Environment:
  • MS SQL Server, SQL Server Integration Services (SSIS), Visual Studio 2019, Oracle 12c
  • Teamed with business analysts to deliver high-availability solutions for mission-critical applications.

Education

B. Tech - Electrical and Instrumentation Engineering

IIT
Kharagpur
05.2010 - 04.2014

Higher Secondary, CBSE -

DAV Public School
04.2007 - 03.2009

CBSE -

DAV Public School
Gaya
04.2006 - 03.2007

Skills

Technical Proficienciesundefined

Certification

Microsoft Certified: Azure Enterprise Data Analyst Associate

Timeline

Senior Software Engineer

Maveric NXT LTD
10.2019 - Current

Senior Software Developer

Data Ratings Intelligence
05.2019 - 10.2019

Software Analyst

Accenture Pvt. Ltd.
08.2016 - 05.2019

Associate Software Engineer

Accenture Pvt. Ltd
03.2015 - 11.2016

B. Tech - Electrical and Instrumentation Engineering

IIT
05.2010 - 04.2014

Higher Secondary, CBSE -

DAV Public School
04.2007 - 03.2009

CBSE -

DAV Public School
04.2006 - 03.2007

Similar Profiles

CREATE PROFILE
Abhishek KumarSenior Software Engineer