Resume

Sign in

Senior Consultant

Location:
Vasant Nagar, Karnataka, India
Posted:
June 07, 2019

Contact this candidate

Resume:

Mahantesh Hiremath ac9jw4@r.postjobfree.com

Education

Qualifications

BACHELORE OF ENGINEERING in ELECTRONICS AND COMMUNICATIONS

Dr. M. S. Sheshgiri College of Engineering and Technology/VTU, India, 2012

Languages

English

Fluent

Kannada

Fluent

Hindi

Fluent

Marathi

Good

Telugu

Good

Professional experience

Profile

•6+ years of IT industry experience encompassing a wide range of skill set, roles, and industry verticals. (Expertise in Banking and Finance, Insurance domain)

•Extensive experience with analysis, design, development, customization, and implementation of Data warehousing projects.

•Proficient in analyzing and translating business requirements into technical requirements and architecture.

•Strong database skills, Programming, and development knowledge.

•Experience in leading and managing teams. Handled multiple roles – Developer and System Analyst, Team lead.

•Good communication skills, interpersonal skills, self-motivated, quick learner, team player, Out of the box thinker.

Key Skills

Tools: Business Object 4.0/4.1/4.2,Informatica

Business Objects Dashboard 4.0, Universe Designer, Information design tool

Crystal Reporting 2008/2012, SSRS, QlikView, TABLEAU, Lumira, SSIS, SAP design studio, Android Studio (Android app Development), SAP BODS 4.2, SAP HANA 2.0, SAP S4HANA

Database: Oracle, Microsoft SQL, HANA, MICROSOFT AZURE DB,GOOGLE ANALYTICS

Programming Languages: C, JAVA, VBA, SQL, Python, R, Completed HANA100/300/301 courses.

Certifications

1)Enterprise Design Thinking Practitioner: https://goo.gl/c7JF8b

2)Oracle Certified Associate: https://goo.gl/DNRRwE

3)Oracle Certified Professional: https://goo.gl/MkRNZv

4)IBM Blockchain Essentials: https://goo.gl/7JRoCv

5)Banking Industry Foundations: https://goo.gl/97KFZz

6)IBM Blockchain Consulting: https://goo.gl/7hVSr4

7)DATA SCIENTIST TOOLBOX: https://goo.gl/Vph2nd

8)Microsoft certified professional: https://goo.gl/415of7

9)Artificial Intelligence (Columbia University through edX): https://goo.gl/aehyNc

10)Build Your Own Chatbot - Level 1:https://goo.gl/X8SPEV

11)IBM Recognized Teacher/ Educator:https://goo.gl/YiC7LU

12)HDE 100 - HADOOP ESSENTIALS: https://goo.gl/ad73Ma

13)SAP Certified Application Associate - SAP HANA 2.0:http://bit.ly/2HKg1WU

Career History

02/2017 - To date

IBM Malaysia Sdn Bhd, Malaysia

SAP BODS/DATA WAREHOUSE CONSULTANT

Roles: Packaged Application Specialist-SAP.BODS. Worked in different complex BODS jobs involving CSV/XML files. I have provided end to end solution for Banking client. I directly involved in many discussions to convert direct requirement, technical then to a working model. We have completed backend form 10+ subject areas in a banking business.

Achievements:

I have worked on 20+ performance tuning in ETL/SSIS/ORACLE.

I got the manager’s choice award and many blue thanks.

Got appreciations from client for giving complete training/ performance tuning on SAP BODS 4.2.

07/2016 - 02/2017

IBM INDIA PRIVATE LIMITED, India

SAP BODS/DATA WAREHOUSE CONSULTANT

Roles: Packaged Application Specialist-SAP.BODS. Worked in different complex BODS jobs involving CSV/XML files. I have provided end to end solution for Banking client. I directly involved in many discussions to convert direct requirement, technical then to a working model. We have completed backend form 10+ subject areas in a banking business.

Achievements:

1) Our team Won 10/10 customer satisfaction award and received appreciations from management

2) I got the manager’s choice award and many blue thanks.

06/2015 - 06/2016

Freelancer

Trainer

Roles: Trainer

I was worked as freelancer giving training on SAP BO 4.0/4.1,

CRYSTAL REPORTS 2008, BODS, Universe Designing, Data warehouse

concepts online as well as offline.

I completed OCA, OCP certification

10/2012 - 05/2015

TATA CONSULTANCY SERVICES, India

SYSTEM ENGINEER

ROLES: Transforming raw data into Client required format using BODS, Developing and generating Reports using Business Objects

Reporting tools like Crystal reports, WEBI, SAP Dashboard

4.0(Xcelsius 2008),

Worked on BODS 3.2,4.0,4.2. I have complete knowledge on

installing BODS 4.X, Created users, repositories, worked on

DEV-UAT-PROD environment, scheduling batch jobs, debugging

jobs.

Implemented SCD 1,2,3. Implemented incremental/full load

and handled many modules individually.

I have Banking/insurance domain knowledge.

Used all most all transformations i.e. Query, SQL, Table Comparison, Map Operation, Case, validation, History Preservation, Date generation, Effective date, hierarchy transformation.

Worked with 45+ team members and handles 2-3 members team.

#PROJECT 1# SENIOUR MANAGEMENT DASHBOARD

I have completed 9-10 SAP DASHBOARDS(For Senior

Management i.e. TMF MD) Developments using BEX query, Universe as a source and have deep knowledge of different connection to dashboard(QAAWS, Web Services, Live Office, XML, External, Flash Variable )

I have completed 6 end to end SAP Dashboard for iPad(Mobile reporting).

I have basic knowledge of BEX Query designer, SAP GUI, Loading of flat file in DSO, Info cube, Info provider.

Created innovating sound enabled Dashboard.

#PROJECT 2# LOAN ORIGINATING SYSTEM

We used ER model(Inmonn) for this project. Which included 32+ table, many materialized views etc.

I created 15-16 crystal reports/ WEBI reports for this project which was included many complex TAT (Turn Around Time calculation.)

Loading of tables done by SAP BODS batch jobs. I created 6-7 BODS jobs for this project (END to END).

#PROJECT 3# RISK

We used Dimensional model (Kimball) for this project. Which included 15+ dimensions 3-4 fact table, many materialized views, views...etc.

I have knowledge on Universe Designing, Business View Manager and Information design tool (IDT, which is a New feature in BO 4.0). Worked on conversion from. unv to.unx.

I have used almost all features of WEBI reports like breaks, sections, hyperlink, merging dimensions, used index awareness

Created 6-7 universe end to end. Used almost all features of Universe like index awareness, derived table, full outer join, @functions…etc.

I created 10-11 crystal reports/ WEBI reports, Dashboard for this project.

Loading of tables done by SAP BODS batch jobs. I created 5-6 BODS jobs for this project (END to END).

#PROJECT 4# ONLINE LOAN ORIGINATING SYSTEM

We used ER model (Inmonn) for this project. Which included 32+ table, many materialized views, views...etc. (Part of LOS). Online LOS tables are refreshed with materialized views logs.

We created a procedure which executes in a regular interval and refreshes the data in tables.

I created 15-16 crystal reports/WEBI reports for this project which was included many complex TAT (Turn Around Time calculation.), Cross tab reports and sub reports.

Loading of tables done by SAP BODS batch jobs. I created 6-7 BODS jobs for this project (END to END)

Assignment History

07/2016 -To date

Malaysian Bank - Confidential

PHASE-2 IMPLEM ENTATION

Project Description: Working on dimensional modeling to give end to end solution for load

data from legacy system to the different type of DataMart. (Client: Bank)

This was a development phase supporting from India.

Position: SAP BODS CONSULTANT

Contribution: •Used Data Integrator and Platform Transforms extensively.

•Worked on Change Data Capture on both Source and Target level for SCD (Slowly Changing Dimension) Type 1, Type 2 and Type3.

•Moved the projects from DEV to ST, ST to UAT and UAT to Production.

•Scheduled the jobs, managed users, and repositories in Management Console.

•Drill down the Analytics to the detail level data.

•Participated in detailed report design and created design specifications documents at the report level.

•Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.

•Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation and Generation of Load ready data files in LSMW format.

05/2018 - To date

PETRONAS

MOBILE APP WITH AZURE CLOUD

Project Description: Working on backend for mobile app which is to be used by 10000+ users. We are using SSIS to create jobs and azure data factory to schedule jobs and push data to cosmos DB.

Position: Developer in data team

Contribution: •Created different types of trigger function, SSIS jobs for 6+ modules.

Other relevant information

Other job-related activities

I have published technical posts in sap portal.

https://blogs.sap.com/author/mahantesh.hiremath/

http://learnbiwithmonty.blogspot.in/



Contact this candidate