Profileimage by Ravi Jogi ETL/Database/BI/MongoDB/Pentaho/TableaAU/Talend/PowerApps, Power BI/AWS/ from Ahmedabad

Ravi Jogi

available

Last update: 11.11.2020

ETL/Database/BI/MongoDB/Pentaho/TableaAU/Talend/PowerApps, Power BI/AWS/

Company: Epicbliss Solutions LLp
Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Native or Bilingual) | Hindi (Native or Bilingual)

Attachments

cv_ravi-jogi_bi.doc
Epicbliss - Services Brochure.pdf
Epicbliss Microsoft Technologies Brochure.pdf
Epicbliss Microsoft PowerApps_Brochure.pdf
Epicbliss Power BI_Brochure.pdf
Epicbliss Tableau Brochure.pdf

Skills

I have 8+ years of IT experience focusing on Business Intelligence (Power BI, Pentaho, Tableau, Talend, Kettle), ETL process, Data warehousing, Data modeling, Data integration, Data Migration.  

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.


 

Project history

Worked as Business Analyst using Pentaho /ETL in German retail analyst company

Client NameLeading Seo Company
TitleBI Implementation
DescriptionThe goal of project is to design several reports for seo purpose. For analyzing sales,orders  and search reports for client.
Period6 months
RoleAnalyst/Developer.
Responsibility
  • Working with business users and business analyst for requirements gathering and business analysis.
  • Converted business requirement into high level and low level design.
  • Implementation of Multitenancy,Single Sign On,LDAP server, integration with pentaho EE and Multi theming.
  • Developing Technical Design Documents, Test-Cases.
  • Developed Various ETL JOBS for collecting data for Webservices.
  • Developed SEO reports and dashboasrds.

TechnologyPentaho EE,Amazon RedShift,Schema Work Bench,Metadata Editor.

Local Availability

Only available in these countries: India
Offshore.  Off-site
Profileimage by Ravi Jogi ETL/Database/BI/MongoDB/Pentaho/TableaAU/Talend/PowerApps, Power BI/AWS/ from Ahmedabad ETL/Database/BI/MongoDB/Pentaho/TableaAU/Talend/PowerApps, Power BI/AWS/
Register