profile-pic
Vetted Talent

Sushma Kumari

Vetted Talent
A problem-solver passionate, highly adaptable, and self-motivated experienced database developer with years of Progressive experience as SQL Developer with proven track record of high client satisfaction. Adept at adapting work pace to evolving client deadlines. Able to play key role in analyzing the problem and come up with creative solutions as well as producing methodologies and files for effective data management.
  • Role

    Senior Software Engineer

  • Years of Experience

    14.8 years

Skillsets

  • Reporting
  • Collaboration

Vetted For

4Skills
  • Roles & Skills
  • Results
  • Details
  • icon-skill_image
    Senior SQL DeveloperAI Screening
  • 39%
    icon-arrow-down
  • Skills assessed :TSQL, Data Analysis, Problem Solving Attitude, SQL
  • Score: 35/90

Professional Summary

14.8Years
  • Aug, 2017 - Present8 yr 11 months

    Senior Software Engineer

    Infor
  • May, 2016 - Jun, 20171 yr 1 month

    Data Analyst

    Datascribe Technologies Inc
  • Mar, 2014 - Apr, 20162 yr 1 month

    Senior Business Analyst

    eClinicalWorks
  • Feb, 2011 - Feb, 20143 yr

    Senior Asset Engineer

    Wipro

Applications & Tools Known

  • icon-tool

    MS SQL Server

  • icon-tool

    PostgreSQL

  • icon-tool

    My SQL

  • icon-tool

    SSIS

  • icon-tool

    SVN

  • icon-tool

    Agile Methodologies

  • icon-tool

    Azure

  • icon-tool

    Tableau

  • icon-tool

    Python

  • icon-tool

    R

  • icon-tool

    Java

  • icon-tool

    C#

  • icon-tool

    Pentaho

  • icon-tool

    AWS

  • icon-tool

    Spark

  • icon-tool

    Hive

  • icon-tool

    Map Reduce

Work History

14.8Years

Senior Software Engineer

Infor
Aug, 2017 - Present8 yr 11 months
    Designed and developed custom IDOs, Forms, and scripting enhancements for Syteline ERP. Integrated third-party applications using APIs, web services, and Infor ION workflows. Optimized SQL queries and database performance for faster transaction processing. Automated business processes, reducing manual efforts and improving efficiency. Managed system upgrades and migrations, ensuring compatibility with custom scripts and integrations.

Data Analyst

Datascribe Technologies Inc
May, 2016 - Jun, 20171 yr 1 month
    Utilized hands-on experience to inspect and cleanse EMR data, identifying correlations, discovering patterns, and visualizing data to interpret and present findings of data analysis. Executed data transformation from MS SQL Server database to PostgreSQL using Pentaho. Leveraged statistical tools and techniques to generate reports, charts, and comprehensive documentation for problem-solving.

Senior Business Analyst

eClinicalWorks
Mar, 2014 - Apr, 20162 yr 1 month
    Conducted thorough analysis and reporting of EMR data to devise solutions for business challenges. Enhanced query performance and populated test data to optimize database operations. Developed advanced SQL queries and implemented Dynamic SQL (Procedures, Functions, and Packages) to automate reporting processes. Executed data transformation (ETL) from diverse sources to create insightful dashboards.

Senior Asset Engineer

Wipro
Feb, 2011 - Feb, 20143 yr
    Managed an accurate inventory of IT assets, encompassing computers, servers, mobile devices, software licenses, and other resources. Developed SQL queries to extract data from multiple tables, converting them into CSV format for distribution to business stakeholders and users. Employed Joins and sub-queries to streamline intricate queries across multiple tables, while optimizing procedures and triggers for production use.

Achievements

  • Employee of the month from Infor Pvt Ltd. years long Service Recognition Award from eClinicalWorks, for Best Service and Excellence.
  • Best Employee of quarter award from Wipro Technologies.

Major Projects

7Projects

Syteline ERP Customization & Enhancement

    Designed and developed custom IDOs, Forms, and scripting enhancements.

Real-time Inventory Management System

    Developed a real-time inventory synchronization solution between Syteline ERP and third-party warehouse management systems.

ERP Performance Optimization & SQL Tuning

    Conducted database performance analysis and identified bottlenecks in slow-running queries. Rewrote complex SQL queries and optimized indexing strategies, reducing query execution time.

Amazon Aurora Migration

    Analyzed code incompatibilities within BabelKish Compass to facilitate smooth migration of MS SQL code to PostgreSQL. Corrected code for seamless functionality across both PostgreSQL and SQL Server environments.

HMS Report Development

    Developed complex queries, views, stored functions, procedures, and packages in SQL Server. Conducted performance tuning of SQL queries and objects to optimize query performance.

EM Analytics Report

    Designed tables, established relationships, and formulated schemas. Crafted SQL queries within the framework for Query Optimization and performance.

Syteline ERP Customization and Enhancement

    Designed and developed custom IDOs, Forms, and scripting enhancements for Syteline ERP. Integrated third-party applications using APIs, web services, and Infor ION workflows.

Education

  • MBA in Data Analytics

    London School of Business & Finance (2024)

  • B.Sc in Information and Technology

    Kuvempu University (2010)

Certifications

  • Data Analytics - Mining and Analysis of Big Data Machine Learning in Python Environment Data, Databases and Mining