Learn Data Skills
Beta
Rajarshi Shukla

Rajarshi Shukla

N.A

N.A | Ottawa, Ontario, CA

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Workbook

Analyzing Motorcycle Sales

My New Course

Introduction to Python

Unleashing the magic of data, one algorithm at a time.

My Work

Take a look at my latest work.

course

Introduction to Python

DataLab

Analyzing Motorcycle Sales

DataLab

Course Notes: Database Design

course

Introduction to Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to R
Joining Data in SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

EVERSANA | Sep 2018 - Present

Reporting Analyst | Data Engineer

* Writing SQL queries, testing and gathering data for Customized Client Reporting needs while adhering to HIPAA compliance * Collecting and documenting user requirements for multiple healthcare clients for ad-hoc and custom reports and KPI monitoring dashboards * Write stored procedures for implementing business logic and creating Views for reporting purposes of clients * Data profiling, cleansing & analyses of dependencies/sufficiency for various database tables corresponding to CRM Entities using SQL Scripts * Work with RDBMS to analyze data and perform data analysis and data mining * Researching Database using DB management tools and understanding the existing relationship in the data * Loading the vendor and client data to the data tables for new clients on to the databases * Modifying the tables and views for reduced redundancy and better querying and updating and maintaining the data dictionary for cross client applications
Show More

Adecco | Mar 2018 - Sep 2018

Data Support Analyst

* Responsible for weekly and bi-weekly analysis reports, production reports, error reports, and tracking reports for production run and release * Collected, cleansed and provided modeling and analyses of structured and unstructured data from different sources like SQL Server/Oracle database, Excel sheets, Proficy historian and manual lab reports * Designed and developed Python dashboards using visualization libraries like Seaborn * Build and maintain SQL scripts, and complex queries for data analysis and extraction of bulk data * Compiled and validated the data along with compliance team, DBA and developers * Automated the process of extracting data from OLAP cube using MS excel pivot tables and VBA Macros * Automated the ETL and Reporting processes using python

Batesville | May 2017 - Nov 2017

Business Intelligence Developer

* Created mappings, loaders, sessions and workflows for ETL processes using Informatica 10 using PC/Dev/Manager for data migration from Source & Stage to Data-Vault * Created descriptive finance and sales reports and dashboards using IBM Cognos Report Studio (11.6) & Tableau 11 using queries (joins, unions, intersections, filters) for regular monitoring of sales * Migrated large data sets where table sizes exceeded over a million row and 10 Gb in memory size * Performed root cause analysis to fix the existing scheduled runs of the Informatica workflows. This involved- problem identification from session and workflow log files, tracing, fixing and testing for the errors * Provided L3 support for recurring workflow errors such as Mapping issues, SQL logical and syntax errors in Source Qualifier, improper implementation of business rules, Constraints violations, Index on wrong columns, missing data, hash-key mis-matches on the indexes, use of duplicate/incorrect codes for MD5 hashing * Developed Test-cases and was solely responsible for data validation across new data-vault tables by replicating Informatica mapping using SQL scripts using complex joins (Inner, Outer, Left Outer) on the hashed Pks indexes and running SQL check count function for data mis-matches due to data type, formatting errors, blank spaces missing or invalid data from source and stage tables * Performed data reconciliation to purge erroneous/duplicate records after consultation and consent from the corresponding departmental team * Created “Configuration control document” by identifying and documenting alphabetic codes for generating hash-keys in the look-up table called User Defined Codes in the current ongoing project [Sales and Marketing dept] * Collaborated with the Sales team on SharePoint to gather bi-weekly sales data and developed Excel reports using complex queries, VBA macros, IF Else and Vlook-up for analysis of the sales data

Yugantar | Jan 2010 - Dec 2015

Assistant Professor

* Developed database course modules and conducted undergrad classes, which included use of SQL for data analysis and reporting, grouping and merging of data/tables, using joins and union to merge data and working with lead and lag functions * Partnered with Lanco Solar Manufacturing Plant’s IT department to design and impart business and functional analyst training and designed organizational artifacts such as – Data Specification Documents (DSD), Business Requirement Document (BRD), Technical Requirements Document (TEC), Product Backlogs and Project Plan * Led undergrad academic projects for Matlab model simulations and collected simulation data for practical application in data wrangling using Matlab, R and Python. Created complex data sets for computation of Fairness Distribution Matrices and Time-Varying Channel Response properties * Facilitated projects for undergrad student in SAS for reporting and data visualization by plotting, graphing and deducing optimum channel responses and sub-carrier power allocation levels Qualified UGC NET In ES (Electronic-Sciences) [Nationally ranked in top 5%] - Worked On 1. OFDM and Emerging 5G Technologies 2. Sub-Carrier selection through Resource Optimization 3. Sub-Optimal solutions to Kahrush-Kahn-Tucker equations and Greedy Water-Filling Algorithms 4. Analysis of incremental Sub-carrier power allocation in various Water-Filling techniques 5. Convex Optimization techniques Skill-Set : MATLAB, Simulink, System Modelling, Optimization tools, Verilog - VHDL, P Spice

Infosys | Jul 2006 - May 2009

Software Engineer

* Worked as a Software engineer in Business Unit Vertical- Banking and Capital Markets Departments(BCMD). My job entailed working on Eclipse/Net Beans/Oracle platforms in Java/SQL [Skill Set] RDBMS, Programming Fundamentals(C programming), Object Oriented Concepts (introduction to Java concepts), Software Engineering Practices (SDLC, Agile Methodology ) * Lead role in technology migration project for internal department(IS) [Skill Set] JAVA, basic J2EE-core Java, Client Tier using HTML with JavaScript and CSS, Presentation tier using JSF/JSP, Business Tier using POJO, Persistence tier using Oracle and JPA, servlets (introduction), JDBC(introduction) .Developed a 3- tier web application built on JPA framework with front-end in JSF. * Led a team of testers for regression testing. Created System test documents, UAT docs, Defect tracking doc, for green field implementation as well as post go live enhancements * Used SSIS and SSRS and created Stored Procedures to validate the data from the source and update/insert for the records into target tables in MS SQL Server

My Education

Take a look at my formal education

Master’s Degree, Management Information Systems, GeneralUniversity of Cincinnati College of Business | 2017
Bachelor’s Degree, Electrical, Electronics and Communications EngineeringJaypee Institute Of Information Technology | 2006

About Me

Rajarshi Shukla

I am a highly motivated and progress-focused Data Analyst/ Engineer with specialization in Snowflake cloud warehouse. I am confident in my ability to contribute to your team and support your growth as I bring along with me over 7 years of experience

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free