JESNEY JOSEPH

Jancy cottage, TC NO: **/***,

Vettucadu Church Line,

TVM-21, Kerala

628-***-****

adeqo6@r.postjobfree.com

adeqo6@r.postjobfree.com

SUMMARY

1.5 years of experience in Software Industry

Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, MS Excel, SharePoint Etc.

Experience in creating visual reports, dashboards and KPI scorecards using advanced DAX.

Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server.

Experience in Robotic Process Automation

Have knowledge in creating business apps using Microsoft power Apps

Good team player and has an ability to work in team and individual environment and Self-Motivated Professional with good communication skills.

Willingness to learn new technologies.

Skills & Abilities

Programing Languages

Python

Node Js

HTML,CSS

Database

MySQL, Oracle 11g, MS SQL Server.

Power Platform

Power BI, Power Apps, Power Automate.

Tools and Software’s

RPA: UIPath

SQL Server Management Studio

Visual Studio Code, TFS

Jupyter, Spyder

Visualization Tools: Power BI desktop, Tableau (beginner).

Other Skills:

SQL Server Integration services(SSIS),Azure Data Factory(ADF)

Data visualization using Python

Knowledge in python packages like –Numpy, Pandas, Matplotlib, seaborn, Sckit, ggplot, NLTK

Knowledge in ML.

Experience

IT Consultant (Power BI developer)

Ernst and Young,Trivandrum (Jan 2019 – April 2019)

Project : Taxation

Description: This project combine all tax data’s from EY geographic areas (Asia Pacific, EMEIA, Americas) and stage it in a format that can be easily understood. The BI solution gives a consolidated view of previous and current year changes in financial growth, revenue growth, Branding by each geo areas as well as by each country.

Responsibilities:

Requirement analysis and team interaction for requirement clarifications

Importing data from SQL Server DB, Azure SQL DB to power BI to generate reports

Creating appropriate DAX queries.

Created Azure Blob Storage for Import/Export data to/from .CSV File.

Published Power BI Reports in the required originations and Made Power BI Dashboards.

Published reports and dashboards using Power BI

Environment: Power BI, SSIS, SQL server management studio (SSMS), Azure DB.

Project : Sentry

Description: An Trusted AI platform that provides developers, owners, operators and regulators functionality to evaluate the impact and trustworthiness of AI system and their datasets. The application contains many modules for calculating the impact and the risk scores.

Visualization, Reporting, Scoring and Analysis are part of it. This modules are developed in Power BI. I worked as a BI developer in this project.

Responsibilities :

Requirement analysis and team interaction for requirement clarifications

Importing data from SQL Server DB, Azure SQL DB to power BI to generate reports

Creating Database objects: tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.

Involved in writing SQL queries and stored procedures and optimizing the existing queries and stored procedures

Creating appropriate DAX queries to generate computed columns in Power BI.

Created reports and dashboards as per the requirement’s.

Published Power BI Reports in the required originations using Power BI desktop.

Environment : Power BI,SQL server management studio(SSMS),

Associate software developer

UST Global, Trivandrum (May 2019 – Present)

Project : SmartOps (Internal work)

Description : The Project focused to find automation possibilities in the internal products or UST’s Client products. And Develop RPA automation by using UiPath.

Technology : UIPath

Responsibilities

Analyze Business Requirements

Implemented End to End Robotic Process Automation (RPA) using UiPath.

Developed the objects and workflows as per client requirement.

Performed tool evaluation and feasibility to help in selecting suitable Automation tool for RPA implementation.

Analyze the feasibility of existing process suitable for automation.

Participated in online meetings to demonstrate the capabilities of RPA for on-going projects and potential clients.

Automated Several Processes and Business activities for various business systems.

Perform Unit Test on the Automation

Support the production run.

Education

Post graduation in MCA- Govt, College Of Engineering, Kerala University,Trivandrum, (2015-2018oct)- 72%

Graduation in Bsc Computer Science-University institute Of Technology, Kerala University, Trivandrum (2012-2015) - 73%

Secondary level schooling- Nirmala Bhavan Higher Secondary School, Tvm - 82%

SSLC -Holy Angels Convent Higher Secondary School- 94%

Additional information

Operating system :Windows 7 & 10,Linux

Microsoft office – PowerPoint, word, Excel, Visio

CERTIFICATION

Udemy : Microsoft SQL A to Z

LinkedIn : Microsoft power Apps essential training

Great learning : Data visualization using python

Coursera /University of Michigan : Introduction to data Science in python

UiPath Academy : RPA starter Training

UiPath Academy : Level 1- Foundation Training

UiPath Academy : Level 2-Orchestrator Training

Place : Trivandrum Jesney Joseph

Contact this candidate