Arun H. - PowerBI Lead

Arun H.

PowerBI Lead

India | Asia/Kolkata (USD)

$14/hr
Part-time:10-30 hrs/week
0, Followers

ABOUT ME

 Having 10+ years of IT Consulting experience in Banking, Insurance, Retail and CPG Domain in requirement gathering, analysis, design, development, testing and support of Web based and Business Intelligence applications using Microsoft .Net with SQL Server Business Intelligence & Oracle based technologies
 Worked extensively on International Assignments in Business Intelligence Reporting for Bank Muscat for Retail Banking Performance Management System Implementation and Development of Core Banking Solution Implementation through web-based Branch application - TCS BANCSLink for National Bank of Kuwait and Bangladesh Bank
 Undertook Domestic Assignments in Core Banking Solution & BI Implementation for Rock Building Society, Australia, Abu Dhabi Commercial Bank and worked on Vital Analytix BI Solution for Retail Client INC.5 Shoes for Sales Analysis
 Extensively worked in Client Delivery & Implementation in the capacity of Business Intelligence Consultant
 Worked in both onsite and offshore models of software development across geographies
 Excellent Organizing, Planning and Management skills with demonstrated abilities in leading motivated teams towards achieving organizational goals
 Specialties: Business Intelligence & Analytics
 Having 8+ years of experience on developing cubes using SQL Server Analysis Services (SSAS)
using Tabular & Multi-Dimensional modelling.
 Having 8+ years of experience in design and deployment of Tabular, Parameterized, Drill Down, Matrix and Sub Reports in SQL Server Reporting Services (SSRS) with PDF, XLS and CSV Formats.
 Having 8+ years’ experience on designing ETL Architecture, DTS, Control Flow and Data Flows in SQL Server Integration Services (SSIS).
 Experience in importing data from different data source like MS-Excel, Oracle, SQL Server and CSV file.
 Experience in creating Jobs, Alerts using SQL Server Agent & Scheduling SSIS packages.
 Experienced in TSQL programming tasks – Creating Tables, Views, Stored Procedures and Functions using SQL Server 2012/2016
Technical Skills

Database Languages Oracle 10g PL/SQL, MS SQL Server 2008 R2/2012/2014/2016/2017, Amazon Redshift/PostGreSQL, Snowflake
Progra mming Languages Python 2.7, Powershell 4.0
Software Tools MS Visual Studio 2013/2015, TOAD,SQL Workbench, MS Excel,MS PPT,MS Word,PGAdmin, BIML Express
BI Tools MSBI -SSIS,SSRS,SSAS 2012/14/16,Power BI Desktop 2.76,Power BI Service,Pentaho Kettle Spoon,Pentaho Report Designer, Pentaho Schema Workbench, TIBCO JasperSoft 6.3.1,Talend Open Studio 6.5.1, Amazon Quicksight,SQL Server Agent
QA Tool Mercury Test Director,Quality Centre, BugZilla, JIRA
Version Control Tortoise SVN, GITLab
Software Products Vital Analytix (BI Application), TCS FS BANCSLink (Core Banking), Masar PxCube (BI Application), IvyDMS (OLTP and OLAP system), IvyCPG (OLTP and OLAP system)



Professional Certifications

 70-778: Analyzing and Visulaizing data with Microsoft PowerBI (Jan ’20)
 Completed 9 month Certificate Professional Program in Fintech from SP Jain School of Global Management (Nov’ 18)
 Completed 6 month Certificate Program in Data Science with UPX Academy certified by Tech Mahindra
 Certified Scrum Master CSM® (Jun’17)
 70-466: Implementing Data Models and Reports with Microsoft SQL Server (Apr’15)
 70-462: Administering Microsoft SQL Server 2012 Databases (Mar’15)
 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012(Feb’15)
 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012(Nov’14)
 70-461: Querying Microsoft SQL Server 2012(Sep’14)
 ‘IZ0-051: Oracle Database 11g: SQL Fundamentals I’(May’12)
 70-528,70-536: MCTS (Microsoft Certified Technology Specialist) for DotNet 2.0 Web Application Development (Mar’09)
 Lean Six Sigma Yellow Belt Certification (Oct’12)

SKILLS