Mahantesh Hiremath Digital Badges :http://bit.ly/*VlDBj0

ada3mw@r.postjobfree.com

Mobile: +91-861*******

Education

Qualifications

BACHELORE OF ENGINEERING in ELECTRONICS AND COMMUNICATIONS

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

Professional experience

Profile

•7+ 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.

•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, Information Steward, SAP BODS 4.2, SAP HANA 2.0(Hana studio-Native Hana modeling), SAP GUI

Databases: Oracle, Microsoft SQL, HANA, MICROSOFT AZURE DB, GOOGLE ANALYTICS, Data migration using LSMW,BAPI,IDOC,USED ABAP Dataflow, BW as source and target and extraction of data from ECC

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

Certifications

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

2)SAP Certified Application Associate - SAP BO WEBI 4.2:http://bit.ly/2ZytyN2

3)SAP Certified Application Associate - SAP BODS 4.2:http://bit.ly/2nrq4tk

4)SAP Product Knowledge 2019 - SAP Analytics Cloud: http://bit.ly/2osJKO7

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

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

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)Introduction to Data Science Specialization (4 courses): http://bit.ly/2o2cnRS

11)Python for Data Science and AI: http://bit.ly/35Ro6UI

12)Data Analysis with Python: http://bit.ly/2VZSZBL

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

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

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

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

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

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

19)Development and Management Essentials Course WinAutomation:http://bit.ly/2lDsFiW

20)Navigation Course WinAutomation:http://bit.ly/2lCHsdO

21)Foundation Course WinAutomation:http://bit.ly/2kooyao

22)Development and management advanced Winautomation:http://bit.ly/2lkllsG

Career History

02/2017 - Till date

IBM Malaysia Sdn Bhd, Malaysia

SAP BODS/DATA WAREHOUSE CONSULTANT (Development/UAT/Production phase)

Roles: Packaged Application Specialist-SAP.BODS. Worked in different complex BODS jobs involving CSV/XML files (Different scenarios), RDBMS source, Legacy systems. 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 10+ subject areas/Modules in a banking (Central bank) where completely removed old system of Bank and given end to end Integrated system to analyses the data.

Achievements:

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

Used Bulk loading to the target, DOP, Data transfer transform, Database side performance tuning, auto-correct option, join rank, lookup and lookup_ext functions have cache options, collected stats, optimized jobs to do maximum pushdown

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.

Successfully completed SAP BODS 4.2(C_DS_42) certification.

Self-studied HANA IMPLEMENATION and cleared HANA 2.0((C_HANAIMP_14) certification.

Converted 3 legacy SSAS cubes to Calculation view (with cube/star) in HANA and presented to client how to utilize in excel and show cased performance compared to normal RDBMS.

PETRONAS (3 Months)

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

07/2016 - 02/2017

IBM INDIA PRIVATE LIMITED, India

SAP BODS/DATA WAREHOUSE CONSULTANT (Development Phase)

Contributions: Involved in Data profiling/Data cleansing using Information steward and BODS. This development phase was almost 1 year which involved 50+ team members (BODS 7-8). 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

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

Participated in detailed report design and created design specifications documents at the report level. Designed ETL jobs in BODS, modified or created new Data Services jobs to meet project requirements. Code review of juniors and helping other team members. I have involved in BODS admin activities like BODS standalone installation, Repository creation, job server creation, central repository creation,

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

Roles: Trainer/worked as individual developer

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

CRYSTAL REPORTS 2008, BODS, Universe Designing, Data warehouse

concepts online as well as offline. Travelled outside of India to give trainings.

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.

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

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)

Other information

Other activities

I have published technical posts in sap portal.

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

http://learnbiwithmonty.blogspot.in/

Languages

English

Fluent

Kannada

Fluent

Hindi

Fluent

Marathi

Good

Telugu

Good

Contact this candidate