JESNEY JOSEPH
Vettucadu Church Line,
TVM-21, Kerala
*********@*****.***
***********@*****.***
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