Hemanth Kumar Email & Phone Number

Fort Lauderdale, Fl, Us

• Led enterprise level ETL architecture design initiatives & Developed Informatica mappings, sessions, and workflows to load transformed data into EDW from various source systems such as SQL Server, and Flat Files. • Extracted data from heterogeneous sources and performed complex business logic on data using Informatica transformations (e.g. Router, Normalizer, Lookup, Rank, Aggregator, Union, etc.) and\or SQL Scripts (e.g. BTEQ, and T SQL). • Designed Batch Audit Process in batch\shell script to monitor each ETL job along with reporting status which includes table name, start and finish time, number of rows loaded, status, etc and Developed a general-purpose Change Data Capture (CDC) process based on audit table for a standard incremental ETL process. • Collaborated with business intelligence and functional teams to gather information regarding the source and target mappings. • Data Profiling included the understanding of Data Lineage of Data flow from various feeds to various in stream tables and the columns. • Resolved high and critical defect fixes in the development of ETL processes generated by System Test & business rules change • Created new Mappings and modified existing Mapping /Workflows (Target - XML and DB), processed defect fixes, tested, validated data. Documented and implemented all the objects being used in ETL development into upper environments. • Developed scripts to load data to hive from HDFS and involved in ingesting data into Data Warehouse using various data loading techniques. • Developing data processing tasks using PySpark such as reading data from external sources, merge data, perform data enrichment and load in to target data destinations. • Designed, developed, and implemented complex SSIS packages, asynchronous ETL processing, Ad hoc reporting, and SSRS report server, and data mining in SSAS.

Long Beach, California, Us

• Built a mechanism for automatically moving the existing proprietary binary format data files to HDFS using a service called Ingestion service. • Performed Data transformations in HIVE and used partitions, buckets for performance improvements. • Ingestion of data into Hadoop using Sqoop and apply data transformations and using Pig and HIVE. • Used Git, GitHub, and used extracted data for analysis and carried out various mathematical operations for calculation purpose using python library - NumPy, SciPy. • Developed various Python scripts to find vulnerabilities with SQL Queries by doing SQL injection, permission checks and performance analysis • Performed troubleshooting, fixed and deployed many Python bug fixes of the two main applications that were a main source of data for both customers and internal customer service team. • Develop framework for converting existing PowerCenter mappings and to PySpark (Python and Spark) Jobs. • Developed and executed complex SQL queries to pull data from data sources like SQL server database, and Oracle. • Executed Data Analysis and Data Visualization on survey data using Tableau Desktop as well as Compared respondent's demographics data with Univariate Analysis using Python (Pandas, NumPy, Seaborn, Sklearn, and Matplotlib). • Reviewed basic SQL queries and edited inner, left, & right joins in Tableau Desktop by connecting live/dynamic and static datasets. • Developed and/or optimized over 500 Stored Procedures, TSQL Queries, Indexes, Views, Functions, Triggers, scripts, DTS and SSIS Packages. • Designed complex SSIS Packages for Extract, Transform and Load (ETL) with data from different sources. • Reported and created dashboards for Global Services & Technical Services using SSRS, Oracle BI, and Excel. Deployed Excel VLOOKUP, PivotTable, and Access Query functionalities to research data issues. • Cleaned, reformatted and documented user's satisfaction survey data. Developed data gathering application.

Bentonville, Arkansas, Us

• Implemented reporting Data Warehouse with online transaction system data. • Managed user account, groups and workspace creation for different users in Powercenter. • Worked with PL/SQL procedures and used them in Stored Procedure Transformations. • Extensively worked on oracle and SQL server. Wrote complex SQL queries to query ERP system for data analysis purpose • Worked on most critical Finance project and had been the go-to person for any data related issues for team members. • Migrated ETL code from Talend to Informatica. Involved in development, testing and post-production for the entire migration project. • Tuned ETL jobs in the new environment after fully understanding the existing code. • Maintained Talend admin console and provided quick assistance on production jobs. • Built ad hoc reports using stand-alone tables. • Involved in creating and modifying new and existing Web Intelligence reports. • Wrote Custom SQL for some complex reports. • Analyzed Stored Procedures to convert business logic into Hadoop jobs • Worked with business partners internal and external during requirement gathering. • Worked closely with Business Analyst and report developers in writing the source to target specifications for Data warehouse tables based on the business requirement needs. • Exported data into excel for business meetings which made the discussions easier while looking at the data. • Performed analysis after requirements gathering and walked team through major impacts. • Provided and debugged crucial reports for finance teams during month end period. • Addressed issue reported by Business Users in standard reports by identifying the root cause. • Get the reporting issues resolved by identifying whether it is report related issue or source related issue. • Creating Ad hoc reports as per user's needs and Developed Unix Shell Scripts for loading data into the database using SQL* Loader.

Atlanta, Ga, Us

• Designing and developing of mappings, mapplets, sessions and workflow to load the data for Ultimatix projects from source to target database using Informatica PowerCenter. • Designing of Informatica jobs in SCD Type 1, 2 and 3 jobs. Moving the mappings and workflows from Dev to QA and QA to Production environment and unit testing the process. • Involved in the smooth transition from Informatica 9.0 to Informatica 9.6 to migrate the mappings, sessions, workflows, repositories into the new environment. • Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router. • Created shell scripts to fine tune the ETL flow of the Informatica workflows. • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse. • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer. • Developed PL/ SQL stored procedures and Performed Push Down Optimization tuning to reduce execution times by 30%. • Designed materialized views, scheduled jobs, ETL workflows and reporting which enabled dataflow across 8 ERP systems. • Worked with Corporate finance team and provided financial reports that helped in tracking profitability and improving business development of an organization. • Automated Billing module and credit note using PL/ SQL and Oracle Apps reducing the processing time from 4 hrs to 45 mins. • Wrote complex SQL queries and optimized to generate and provide reports such as file loading stats, member data matching, operational data views for BA team. • Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Hyderabad, Telangana, In

• Involved in designing physical and logical data model using ERwin Data modeling tool.• Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables fordata marts.• Extensively used ERwin data modeler to design Logical/Physical Data Models, relational database design.• Created Stored Procedures, Database Triggers, Functions and Packages to manipulate the database and to apply the business logic according to the user's specifications.• Created Triggers, Views, Synonyms and Roles to maintain integrity plan and database security.• Creation of database links to connect to the other server and Access the required info.• Integrity constraints, database triggers and indexes were planned and created to maintain data integrity and to facilitate better performance.• Used Advanced Querying for exchanging messages and communicating between different modules.• System analysis and design for enhancements Testing Forms, Reports and User Interaction.

Bachelor'S Degree, Electrical, Electronics And Communications Engineering

Education record