Ajay Sharma

Screened technical consultants and reviewed their IT technical skills. Processed, cleansed and analyzed large datasets using Excel. Created audit reports using SQL. Created dashboards and data processing routines in Power-bi to help augment the audit teams’ procedures. Perform IT Audit work end to end independently. This includes audit reviews, reporting and communicating results to onshore audit team. Perform data analysis on our core systems to identify potential and emerging risks and/or control deficiencies and produce trending analysis reports. Plans the scope of the audit, prepares the audit program, and determines the appropriate auditing procedures and examination techniques to be applied. Coordinated communication between teams in India and the United states and provided leadership for development teams comprised of both off shore and neurodiverse team members.

Developed data pipeline for spend cube to generate reports in Microstrategy for spend management. Conducted RFQ’s for packaging supplies. Managed ordering and inventory of 2500+ SKU’s nation-wide including promotions and everyday items. Coordinated with vendors and logistics teams to ensure on-time delivery of products. Generated custom analytical reporting for seasonal programs using SQL. Created SQL Joins, sub-queries and other SQL code to implement business rules. Working on SQL Server Integration Services (SSIS) coding, debugging, and implementing. Implemented code in python to retrieve and manipulate data. Wrote Python code to simplify lists in Python with list comprehension and Python OOP. Profiled Python code for optimization and memory management. Wrote Python OO Design code for manufacturing quality, monitoring, logging, and debugging code optimization. Working with, modifying, and cleaning large amounts of data using (Groupby, pivot tables, examining tables for inconsistencies).