Ramesh S. Arkas

DW BI Developer

Mobile No:- +91-937*******

E-Mail:- adkbu1@r.postjobfree.com

OBJECTIVE:

Looking for a challenging role in a reputable organization to utilize my technical and management skills for the growth of the organization as well as to enhance my knowledge about new emerging trends in the IT sector.

PROFESSIONAL SUMMARY:

Having 4+ Years Experience in DWH and BI.

Experience in full DWH and BI Development Lifecycle from gathering requirements and designing solutions, to testing and release/deployment.

Developed, maintained and enhanced various Informatica Mappings and Workflow to perform ETL of data from multiple sources to data warehouse.

Good knowledge of various transformation like Filter, Source Qualifier, Joiner, Router, Aggregator, Update Strategy, Lookup etc.

Implemented SCD1 and SCD2 mappings.

Building, publishing customize interactive reports and dashboards in Tableau and Power BI.

Experience of different visualizations like Bar, Line, Pie, Heat Map, Tree Map, Matrix, Doughnut, Pareto etc. in Tableau and Power BI.

Expertise in various reporting objects like Filters, Calculated Field, Set, Group, Parameter and Action Filter in Tableau.

Developed Tableau workbooks to perform Calculate Year over Year Growth, and YTD, MTD, QTD type of analysis.

Experience using DAX functions which include Aggregation, Count, Calculate, Related and Date Functions in Power BI.

Involved in creating Filters, Quick Filters, Table Calculations, Calculated Measures and Parameters in Power BI

Worked on Performance Tuning to improve Performance of dashboard.

Good knowledge of SQL and PLSQL

Good knowledge of data warehousing concepts like Schema, Fact, Dimension

WORK EXPERIENCE:

Worked as Sr. Software Engineer with Parkar Consulting and Labs, Pune from Aug – 2019 to Mar-2020.

Worked as Sr. Software Engineer with ZS Associates, Pune from Dec - 2018 to May-2019.

Worked as Software Engineer with Tech Mahindra, Pune from Dec-2014 to Oct-2018

EDUCATIONAL QUALIFICATION:

B.E. (Computer Science) from University of Pune with first class.

SKILLS SUMMARY:

BI Tools

: Tableau, Power BI

ETL

: Informatica PowerCenter

Database

: Oracle,SQL Server

Other Tools

: JIRA, Putty, Excel, Word

PROJECT SUMMARY:

Project #3:

Client

: BMS

Role

: DWH BI Developer

Environment

: Informatica Powercenter, Tableau, Oracle, Excel.

Description:

Bristol Myers Squibb (BMS) is USA based one of largest pharmaceutical company, BMS Sales Analysis project is to develop of Data mart of sales system and create tableau report to help the senior management of the organization to improve the sales and get the knowledge of the new business opportunities

Responsibilities:

Responsible for creating informatica mapping using various transformation like Filter, Router, Joiner, Aggregator, Source Qualifier, Update Stratergy, Lookup etc.

Implemented SCD1 and SCD2 and CDC mappings.

Created and monitored informatica running session.

Worked with mapping parameter and variable and session parameter to pass value dynamically.

Designed, developed and implemented Tableau Business Intelligence reports according to the client

requirement.

Created the Visualizations using Bar Chart, Doughnut chart, Pie Chart, Tree Maps, Line Chart, Text Table and Reference Lines.

Merge multiple data sources by joining multiple tables and using Cross Join.

Developed effective and interactive Dashboards using Filters, Sets, Groups, Parameters and Actions.

Developed Tableau workbooks to perform year over year, YTD, QTD and MTD type of analysis

Publish and Schedule refreshes sheets and dashboards on Tableau server.

Project #2:

Client

: CDPHP

Role

: Power BI Developer

Environment

: Power BI,Oracle,Excel.

Description:

The objective of the project is to develop reports for analysis of patient and diversity calculation, patient satisfaction, different medical and surgical intervention. Also monitor overall healthcare facility to improve effective healthcare delivery, optimizing resource utilization, reduced wastage time

Responsibilities:

Responsible for interaction with business user, gathering requirements and managing the delivery.

Connected different data source and create data model of datasource.

Created calculated column and measure using DAX functions.

Use Page level filter and datasource filter to handle large amount of data.

Developed customized and interactive dashboard using Filter, DAX Functions, Parameters.

Represent data using Cross Tab, Map, Pie Chart, Bar Chart.

Build advanced chart and visualization such as Scatter Plot, Pareto Chart, Doughnut Chart.

Responsible for dashboard design and its layout.

Published dashboard and defined user access and privileges for dashboard.

Project #1:

Title

: DNB

Role

: DWH BI Developer

Environment

: Informatica, Tableau, Oracle, Excel

Description:

This DNB is creating global copy of deal repository, as a part of this, Trade repository project was initiated to provide reporting service for a wide range of over the counter financial instruments. We have difference product data like OTC, SECFIN, DRD, MOVEMENTS,Loans, Money Market, Notes, Bonds, Cash Security etc. The new trade repository will serve all financial products as well as non-financial operations and will deliver flexible participations level that adopt to the diverse profiles and needs of all stakeholders and actors in the OTC derivatives market and we are preparing PNL, Trail Balance and Balance Sheet.

Responsibilities:

Worked with ETL production support team to monitor running workflow and sessions.

Created informatica mapping using various transformation like Filter, Router, Joiner, Aggregator,

Source Qualifier Transformation, Update Stratergy, Lookup transformation etc.

Designed, developed and implemented Tableau Business Intelligence reports according to the client and user requirement.

Use Actions, Bins, Hierarchies, Sorts, Groups, Sets, Filters, YTD, MTD calculation, functions to create focused and effective visualizations.

Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.

Used advanced chart types and visualizations such as donut chart, Dual axis chart.

Use Parameters and input controls to give users control over certain value.

DECLARATION:

I hereby certify that all the information provided above is true to the best of my knowledge

Date : Ramesh S. Arkas

Contact this candidate