Power BI, SQL, Data Analytics, Data Warehousing

AMITH WODEYAR

Mob: +91-914*******

Email: ****************@*****.***

PROFESSIONAL SUMMARY:

oA result driven software professional with 6+ years of progressively responsible experience in Data Analysis, Design, Implementation and Support of Business Intelligence, OLTP,

OLAP, ETL, Data warehousing and Data Modeling using Power BI, Cognos BI and MS SQL Server

oAbility to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.

oProficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.

oProficient in writing complex T-SQL (DDL, DML

oExpertise in Power BI Desktop, Service, Power BI Pro, Power BI Mobile.

oDeveloping compelling and interactive analysis reports and dashboards using advanced DAX.

oDesign scalable Data model in power BI desktop with best practices and performance techniques to enhance the performance.

oCreated Workspace and content packs for business users to view the developed reports.

oScheduled Automatic refresh and scheduling refresh in power bi service.

oExperience in designing dashboards, reports using all connection modes, Live connection, Direct Query and Import mode.

oIntegrated custom visuals based on business requirement using power BI desktop.

oConverting all operational excel report into Power BI Reports.

oGood exposer to SSIS multidimensional model (SSAS).

oExpertise in Cognos Analytics, Cognos Report Studio, Dashboard, Framework Manager model.

oDeveloped OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.

oExperience in Ad-hoc reporting using Power BI and Cognos BI.

oExperience in developing Dashboard, Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week using Power BI and Cognos BI.

oExpert in creating and developing Power BI Dashboards and reports with rich UI.

TECHNICAL SKILLS:

Reporting Tools: Power BI, Cognos BI

Databases: MS SQL server (20012/2014/2016), Oracle 10g

ETL Tools: SSIS (SQL Server Integration Services)

Other Skills: Python, Pandas, NumPy, matplotlib

Systems: Windows XP, Windows 7, Windows 10

Professional Experience:

•Currently Working as Software Engineer II at Blue Yonder (JDA Software) (From Mar’2018)

•Worked as Software Engineer for Anvizent Analytics (From Feb’2016 to Mar’2018)

•Worked as Cognos Developer for Aequor Information Technologies (Apr’2014 to Aug’2015)

Client/Project

Walmart Inc./ JDA Warehouse Management System (WMS)

Platform

SQL Server 2016/ Power BI Desktop, Service

Role

Power BI Developer

Duration

Feb 2018– Till Date

Responsibilities:

Customer interaction to understand the core WMS and requirement gathering.

Design and develop Power BI data model on warehouse management system.

Designed and documented the entire Architecture of Power bI POC.

Expertise in writing complex DAX functions in Power BI and Power Pivot.

Used various sources to pull data into Power BI such as SQL Server, SSAS, Excel etc.

Worked on both Import and Live Connection data implementation.

Installed and configured Enterprise gateway and Personal gateway in Power bi service.

Created Workspace and content packs for business users to view the developed reports.

Implemented Incremental data refresh for the model.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.

Weekly presentation to the business users about the reports and their changes as required.

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Worked on all types of transformations that are available in Power bi query editor

Creating Row level security with power bi and integration with power bi service portal.

Project

Pfizer Inc, USA, Sales/Finance

Platform

SQL Server 2014/Power BI

Role

Cognos Developer

Duration

Aug 2017– Mar 2018

Responsibilities:

Interaction with customer for requirement gathering and data analysis

Daily sync up call with the Team members to distribute the load/work.

Extensively worked on import mode data storage and DAX functions.

Dynamic axis implementation based on the business need.

Extensively worked on Power Query for different data transformations.

Created Workspace and content packs for business users to view the developed reports.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.

Weekly presentation to the business users about the reports and their changes as required.

Client

Abbot Diabetes Care, USA

Environment

MS SQL Server 2008, Cognos 10.1

Role

Cognos Developer

Duration

Feb 2016 – Jul 2017

Responsibilities:

Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.

Involved with business and functional people to collect and gather requirements

Implemented Mock report layouts before the actual report implementation.

Creating value prompts, Date & time prompts, Text box prompts, cascading prompts

Hide and Show the objects by using conditional blocks

Involved and performed unit testing (manual testing) for the reports that have been developed.

Creating & publishing the packages according to the business requirements

Involved in the scheduling and deployment of the reports

Involved in the Unit Testing of the reports and preparing the Test cases

Project

KEYSTONE AUTOMOTIVE OPERATIONS INC, Sales

Platform

MS SQL Server 2005, Cognos 8.4 BI

Role

Cognos Developer

Duration

Apr 2014 - Aug 2015

Responsibilities:

Collecting and analyzing the Report requirements.

Daily call with team members to distribute workload.

Creating List, Crosstab and Chart Reports to evaluate the Business Performance based on

various financial indicators

Extensively used different Prompts, Layout Calculations, Conditions, Filters and Variables

in Reports.

Developed Conditional Formatting and Conditional Block Reports Using String and

Boolean variables.

Simplified the process of creating MTD, YTD, QTD, Daily, and Weekly Reports by using Realtime concept.

Testing the Report and the Validating Data it retrieves from the database.

ACADEMIC PROFILE:

Bachelor of Engineering in Computer Science from Visveswaraya Technological University, Belgaum.

Contact this candidate