Ravi J. - Data Scientist / Sharepoint / BI/ Developer

Ravi J.

Data Scientist / Sharepoint / BI/ Developer

India | Asia/Kolkata (USD)

$18/hr
Full-time : 30+ hrs/week
1, Followers

ABOUT ME

I have 9+ years of IT experience focusing on Business Intelligence (Power BI, Pentaho, Tableau, Talend, Kettle), ETL process, Data warehousing, Data modeling, Data integration, Data Migration. Big data and analytics, Machine learning, Data warehousing and mining, Business Intelligence, Software Engineering Programming languages: Python, R, • Databases: MongoDB, Cassandra, H-base, and SQL • Big Data Tech: MapReduce, Spark, Kafka, MLlib, Hive, Pig • Miscellaneous: Numpy, Scikit-learn, AWS, Keras, NLTK, Flask,Selenium,Pandas,bs4 Sharepoint 2010/2013/2016/2019/Online, .Net Framework. MVC, C#, Angular JS Business Intelligence Skills:- PowerBI Pentaho BI Suite Tableau Jasper Soft Crystal Reports SSAS ETL Skills:- Talend Open Studio Pentaho Kettle (PDI) SSIS Databases:- Oracle 10g/9i MS SQL Server 2005/2012 HP vertica MongoDB Postgres SQL infiniDB Amazon RedShift Spark Ignite MS Access SQL PL/SQL SQL*Plus SQL*Loader PSP TOAD I have excellent knowledge on spark and have 4+ years of working experience on spark and can write in JAVA/PYTHON and SCALA. I have strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), ER Diagrams, Entities, Attributes, Cardinality, Data analysis,implementations of Data warehousing using Windows and UNIX. I have developed as well as provided consultation solution for more than 20 clients belongs from Retail,Telecom,E commerce,Health Care domains. Some of the key areas I have mastered are Cloudera Hadoop, ETL Framework setup, Scripting,Error Logging,Email Notifications,Exception Handling,SCDs,Clustering PDI,Paratitioning the ELT Jobs,Performance tuning of Jobs. • Proficiency in designing, developing and deploying end to end Big Data solutions using entire Hadoop Eco System. • Hands on experience in Hadoop Administration, Hadoop Cluster Design/Setup, HDFS and Map-Reduce Programming using Java. • Hands on experience in developing a spark application using Scala. • Amazon EC2 administration. • Experience in developing the Analytics and Business Intelligence solutions using Pentaho, JasperSoft, JSP and Servlets. • Experience in shell script development and linux commands. • Hands on experience of maven, SBT and Jenkins. I have completed more than 180+ hours online work with 97% job success. It includes 15+ satisfied clients and 8 SharePoint projects. I focus on Microsoft technologies which include SharePoint, Office 365, Power BI, Migration, Intranet, website design and development. - I have completed more than 5 projects with office 365. - Using Power BI, I have Created interactive dashboard and charts for 4 different projects. - I have completed 3 complex projects for document and content management. - I have completed 8 Intranet portals. - 2 Migration projects which include all lower version to higher version and on premises to office 365 migration. - 1 project for project management in SharePoint. - 1 project in project server online. Machine Learning Projects:- Built a backend for the product • Automated scripts for data extraction and cleaning saving time. • Implementd VGC16 model and deployed it on linux for image comparison for the rental fraud detection. • Universal Sentence Encoder for Text comparison. • VADER Sentiment analysis model to extract sentiment of the users improved the accuracy till 80%. • Used plotly and matplotlib for real time data analysis.

SKILLS

EMPLOYMENT HISTORY OUTSIDE OF TOOGIT

Senior Engineer

Confidential - Mar, 2008 to Jan, 2013, Rajkot

Entrepreneur

Confidential - Jan, 2017 to present, Ahmedabad

EDUCATION HISTORY

Bachelor of Engineering, Electronics and Tele communication

(2001 - 2004) A.V.Parekh Technical Institute
Employee Utilization Dashboard:Dashboard defines the employee utilization for organization and their cost v/s project billable hours of each resource and more importantly defines organizations growth and utilizations.cost v/s project billable hours of each resourceorganizations growth and utilizations.
Our team has delivered 30+ Intranet Projects which consists different types of Page Layout and different widgets such as Weather, calendar, Slider, News, Discussion Board, Events, Quick Links etc. Our expertise also extends to custom widgets such as employee directory, Survey, etc. We have also implemented SPFx and Modern design Intranets.
We have expertise working on Power Automate projects.• We have done PowerApps andSharePoint Integration where we havecreated various applications as well asCustomized forms in PowerApps forSharePoint list• Developed PowerApps with source asthe Excel sheet in PowerApps• Created Applications which are Capableof sending an Email within thePowerApps• Created Custom Connector in PowerApps to save the PenInput and cameracontrol Images in SharePoint as Itemattachment, Document, or EmailAttachment• Send an Email from the PowerApps, Senda Meeting Invite. Also Integrated thePower Apps with Microsoft Flow toperform the Approval Process,Notifications etc.
Marketing Project This is the dashboard for Marketing project. In this Project we have filters and 3D Pie charts, bar charts timeline and data table. In Backend we have used Excel as a Source.
This Dashboard is Developed using Tableau Desktop for Email sent per day. Also has the filter for the Week, Month along with sent, delivered, opened, Clicked etc. The source used in this report is SAP.