Hemanth Kumar Mutha
Summary
- 14+ years of experience in designing, developing, testing and leading enterprise data warehousing, data integration, ETL/Reporting solutions,
- Expertise in SQL queries and dimensional data modeling techniques; conceptual, logical, and physical data model design of staging and target systems like Star and Snowflake Schemas for optimal reporting needs using Erwin.
- Proven track record of successfully planning, leading, and building End to End Enterprise Data Warehouses through Requirements Gathering for both ETL and Reports, Data analysis, Data discovery, Data Profiling, Data modeling, Source to Target Data mapping, staging, and transportation, Data validations (QA), warranty support for Retail, Banking, and Insurance domains.
- Excellent problem solving, analytical, and critical-thinking skills with a demonstrated history of collaborating with technical and business teams at all levels to evaluate, identify, and implement ETL solutions.
- Special passion to create automated solutions for accelerated development and testing to deliver projects with utmost quality
- Highly flexible to fit in for any role and responsibility and vast exposure in all of these - be it a core developer / core tester or team lead / QA lead or architect or assist management activities like project/effort estimations and metrics gathering / sprint planning etc
Overview
18
18
years of professional experience
1
1
Certification
Work History
Senior ETL/Report Developer/Lead
UCare
07.2018 - Current
- Requirements gathering, design and development of Macess ETL jobs using PDI Spoon which help create folders and upload documents to Macess once ETL jobs extract the require data from the given source systems and generate the XMLs in the desired format
- Logical and physical design of star schema / dimensional model for the OLAP data marts and creation of source to target data mapping documents
- Migration of Pentaho jobs from one environment to another using Pentaho Import and Export utility
- Creation of web based reports and dashboards using Pentaho Report Designer
- Requirements gathering, design and enhancement of Delegate Eligibility jobs to accommodate the files to be sent to new providers
- Requirements sessions and Impact analysis and Development and enhancement of data integration jobs during migration from an existing vendor to a new PBM (Pharmacy Broker Manager) at Organization level
- Performance enhancement of existing long running PDI jobs
- Defining/scheduling/submitting Automatic (UC4) jobs per the requirements of the given data integration flows
- Creating several work items (user stories and tasks) for RHC (Rural Health Care) Encounters project using Azure Devops and providing better visibility to several Encounters projects with the help of the same
- In-depth data analysis and data profiling of several data systems like Health Rules and DataEcosystem to help deliver the projects with better data quality
- Understanding of Encounters and Crosswalk process to help reuse and enhance the Encounters engine specific to the RHC requirement needs
- Transition knowledge to support team and warranty support for the jobs deployed to production.
Senior ETL Developer / Report Developer
Best Buy
07.2013 - 06.2018
- Architected the integration technical blueprint per the given business and ETL (Extract Transform Load) requirements
- Performed Data profiling of the impacted systems and its data components using complex SQL queries to arrive at the low level ETL technical design
- Design and development of ETL jobs using Pentaho Data Integration (PDI) which includes configuring Table input, Table output, Text file output, CSV file input, Insert/Update, Filter, Value Mapper, Stream lookup, Merge Join, Sort rows, Database Lookup etc
- Reports requirements gathering and and developing complex custom reports using Pentaho Report Designer which includes developing Business Views, Drill-through, Cascading pick-lists, Hyperlinks, sub-reports
- Provided recommendations for performance-oriented solutions for integration challenges so the solution performed better including during peak data seasons
- Attended and contributed to the Integration Project intake Request discussions and meetings
- Coordinated with consultants and business users to understand the technical and functional specifications of the given project
- Conducted effort estimations and performed resource allocation planning
- Created high Level technical and functional design of the integration interfaces and reviewed with the integration technical board and program teams
- Delivered the project within the stipulated timelines through regular review meetings with the program team, business users, middleware, support, and offshore delivery teams
- Performed regression impact analysis and testing to ensure the new request did not impact the existing functionality if any
ETL Developer/ Data Modeler/ Reports Developer
ExelDirect
02.2010 - 06.2013
- Analyzed functional, business, and reporting requirements to identify the important entities from the source system and to understand the important attributes and measures for business users
- Reviewed the source OLTP data model to find out any data modeling discrepancies
- Designed Billing Dimensional (logical and physical) Data model using Erwin
- Prepared and documented the Data model diagram, data dictionary, source to target traceability, data model naming conventions, DB scripts, and set up client reviews/walk-through on all of these for the approval of the data model
- Prepared ETL design document which constitutes the PL/SQL design for source to staging, and mappings design for staging to target, and CDC logic, Error handling etc
- Performed ETL build and unit testing using Informatica Power Center; repository and reports development in OBIEE, and UAT and Warranty Support
- Conducted performance tuning and enhancements post deployment.
Web Developer
Development Bank of Singapore (DBS Bank)
10.2006 - 01.2010
- Customized the Finacle product to suit the user interface requirements for the Collateral Module in DBS Lending which involved the participation in all the life cycles of the project.
- Front end development involving HTML, CSS, Javascript involving containers, tables, styles, variables etc
- ETL jobs using SSIS
Education
Bachelor of Technology - Computer Science & Engineering
JNTU University
07.2006
Skills
- ETL Tools: Pentaho Data Integration (PDI), Informatica 10x, IICS, SSIS, Oracle Warehouse Builder
- Reporting Tools: Pentaho Report Designer, Oracle Business Intelligence Enterprise Edition (OBIEE), Business Objects
- Databases: SQL Server, Oracle 9i SQL and PL/SQL, Teradata, Netezza, Snowflake
- Languages: C, C, Java, HTML, CSS, Python
- Others: Erwin Data modeler, Unix Shell Scripting, Azure DevOps, UC4 scheduler, VB Scripts
Certification
- Certified Informatica 9.xDI PowerCenter, Data Integration Developer Associate
- Oracle9i Database Administrator Certified Associate (OCA)
Languages
English
Full Professional
Hindi
Professional Working
Telugu
Native or Bilingual
Timeline
Senior ETL/Report Developer/Lead
UCare
07.2018 - Current
Senior ETL Developer / Report Developer
Best Buy
07.2013 - 06.2018
ETL Developer/ Data Modeler/ Reports Developer
ExelDirect
02.2010 - 06.2013
Web Developer
Development Bank of Singapore (DBS Bank)
10.2006 - 01.2010
Bachelor of Technology - Computer Science & Engineering
JNTU University
Similar Profiles
NANETTE PEGORSNANETTE PEGORS
Exchange and Individual Sales Specialist at UCareExchange and Individual Sales Specialist at UCare
Rick DeemRick Deem
FUSE Product Owner at UCareFUSE Product Owner at UCare
Melanie HelmstetterMelanie Helmstetter
Broker Sales Assistant at UCareBroker Sales Assistant at UCare
Marie (Hulslander) BlomgrenMarie (Hulslander) Blomgren
Appeals and Grievances Federal Specialist at UCareAppeals and Grievances Federal Specialist at UCare
Vikas GuptaVikas Gupta
Test Lead (BI Report/ETL Tester) at IBM IndiaTest Lead (BI Report/ETL Tester) at IBM India