Mahantesh Hiremath Digital Badges :http://bit.ly/*VlDBj0
BACHELORE OF ENGINEERING in ELECTRONICS AND COMMUNICATIONS
Dr. M. S. Sheshgiri College of Engineering and Technology/VTU, India, 2012
•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.
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
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
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.
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,
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
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
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)
I have published technical posts in sap portal.