Data Developer

Location:

Novi, MI

Posted:

September 18, 2020

Contact this candidate

Resume:

Venkata Sriram Kadimisetty

Hadoop/Qlikview/Alteryx L3 Analyst

******.***********@*****.***

+1-814-***-****

Professional Summary:

10+ years of professional experience in IT industry, have in-depth knowledge and exposure to different types of applications and architectures which include web-based client server application development projects in the domains of Automotive, Energy, Finance, Transportation and Parts.

More than four years of experience in Hadoop Development/Administration built on eight years of Production Support -- Managing production deployments in terms of software deliveries and overnight activates.

Good knowledge of Hadoop ecosystem, HDFS, Big Data, RDBMS.

Experienced on working with Big Data and Hadoop File System (HDFS).

Hands on Experience in working with ecosystems like Hive, Pig, Sqoop, Map Reduce, Alteryx, oozie.

Strong Knowledge of Hadoop and Hive and Hive's analytical functions.

Strong Knowledge on Alteryx tool.

Good Knowledge on Spark and Python.

Capturing data from existing databases that provide SQL interfaces using Sqoop.

Efficient in building hive, pig and map Reduce scripts.

Implemented Proofs of Concept on Hadoop stack and different big data analytic tools, migration from different databases (i.e Teradata, Oracle,MYSQL ) to Hadoop.

Successfully loaded files to Hive and HDFS from JSON, Oracle, HBase

Loaded the dataset into Hive for ETL Operation.

Good knowledge on Hadoop Cluster architecture and monitoring the cluster.

Experience in using Zoo keeper and cloudera Manager.

Hands on experience in IDE tools like Eclipse, Visual Studio.

Experience in database design using Stored Procedure, Functions, Triggers and strong experience in writing complex queries for DB2, SQL Server.

Excellent problem solving skills, high analytical skills, good communication and interpersonal skills.

Professional Experience:

Dechen Consulting Group Inc, USA May’17 – Till Date

Sr Software Developer:

Client: Ford Motor Company

Ford Motor Company’s FEDEBOM Reporting is the cornerstone of the BOM metrics reports. Supports evaluation of the status of a program in the context of the BOM Maturity Process, including completeness and the quality (audits) of a specific slice of program data contributing to a BOM in the context of a specific program milestone. Each Global Product Development System (GPDS) milestone requires a completeness of certain BOM attributes to meet various BOM consumer's needs and the

FEDEBOM Reporting provides up to date information about the health of given vehicle program's BOM.

Responsibilities:

oReplaced MS access database system for Hive with MySQL system.

oExecuted queries using Hive and developed Map-Reduce jobs to analyze data.

oDeveloped Pig Latin scripts to extract the data from the web server output files to load into HDFS.

oDeveloped Apache Hbase tables to read Non-Relational data.

oDeveloped scripts to create, drop, update Hbase tables.

oDeveloped scripts to read Data from different sources of NON-Relational database and inserted to Hbase tables.

oDeveloped scripts using Sqoop to extract data from DB2 tables.

oUsed Apache Spark to generate large json files, excel files for downstream systems.

oDeveloped the Pig UDF's to preprocess the data for analysis.

oDeveloped Hive queries for the analysts.

oUtilized Apache Hadoop environment by Hortonworks.

oUtilized Alteryx tool to generate reports.

oInvolved in loading data from LINUX and UNIX file system to HDFS.

oSupported in setting up QA environment and updating configurations for implementing scripts with Pig.

oUsed Alteryx to cleanse data which has mismatches of values between two data sources, null values, letters or unwanted zeros in the columns.

oUsed Alteryx to optimise the time spent manually editing data in Excel and it can transform it into better level of analysis

Database & System Analysis:

oAnalysis of current system & databases

oMaintain documentation of the entire data state flow, process flow, programs, & infrastructure

oIdentify & benchmark performance hot-spots/bottlenecks

Benchmarking shall include data metrics, graphs, reporting & documentation

oDevelop options for eliminating and/or reducing performance bottlenecks

oImplement appropriate solutions for performance bottlenecks

oDeployments across all environments (DEV, STAGING QA, PROD)

oTesting across environments (DEV, STAGING, QA, PROD)

oDocumentation of benchmark data, code & database changes as appropriate (change control)

Data Analysis:

oUnderstand data dependencies & relationships

oUnderstand & resolve data problems, conflicts, or errors in database ensuring normal operation

oEnsure data integrity is maintained for all transactions

oTrack, trend, & report any on-going data issues

oIdentify root causes for data issues & recommend process or system changes

oData cleanup including data purging, data archival & user/schema cleanup

oDefine policy & procedures for regular data archival

oMinor to medium database enhancements / bug fixes.

Environment:

No.

Tools / Technology

Version

Purpose

Hadoop

3.1.5

Data transformation & integration tool

Java 2 Enterprise Edition

Java coding

UNIX-Linux O/S

Operating System Commands & Scripting

Alteryx

2018.3

Data transformation & integration tool

Qlikview

11.20

Dashboard and Reporting tool.

Jenkins

2.2

Deployment tool

Accurev

7.3

Code Management

Dechen Consulting Group Inc, USA Mar’15 – Dec’17

Sr Software Developer:

Client: Ford Motor Company

Ford Motor Company’s Global Commodity Hub (GCH) team requirement to provide Product Development with a tool to facilitate the commodity business planning teams and other key business stake holders need to have access to up to date information for commodity parts, available in different formats, both in the structured & unstructured data sources along with the data inter relationships for quick decision support. Flexibility, speed, reliability and scalability of the solution for information access and data navigability are the key elements required in the tool.

Responsibilities:

oIdentify client needs and develop customized solutions; this involves understanding primary objectives and implementing solutions to established budgets

oProvide remote support and on-site technical training.

oResponsible for troubleshooting and diagnosing hardware and software faults.

oDemonstrate strong interpersonal skills, including the ability to liaise effectively with fellow team members to anticipate technical limitations and glitches and effect smooth system deployments

Database & System Analysis:

oAnalysis of current system & databases

oMaintain documentation of the entire data state flow, process flow, programs, & infrastructure

oIdentify & benchmark performance hot-spots/bottlenecks

Benchmarking shall include data metrics, graphs, reporting & documentation

oDevelop options for eliminating and/or reducing performance bottlenecks

oImplement appropriate solutions for performance bottlenecks

oDeployments across all environments (DEV, STAGING QA, PROD)

oTesting across environments (DEV, STAGING, QA, PROD)

oDocumentation of benchmark data, code & database changes as appropriate (change control)

Data Analysis:

oUnderstand data dependencies & relationships

oUnderstand & resolve data problems, conflicts, or errors in database ensuring normal operation

oEnsure data integrity is maintained for all transactions

oTrack, trend, & report any on-going data issues

oIdentify root causes for data issues & recommend process or system changes

oData cleanup including data purging, data archival & user/schema cleanup

oDefine policy & procedures for regular data archival

oMinor to medium database enhancements / bug fixes (PL-SQL Procedures & Packages)

Environment:

No.

Tools / Technology

Version

Purpose

Hadoop

2.6.5

Data transformation & integration tool

Java 2 Enterprise Edition

Java coding

UNIX-Linux O/S

Operating System Commands & Scripting

Alteryx

2018.3

Data transformation & integration tool

Qlikview

11.20

Dashboard and Reporting tool.

Jenkins

2.2

Deployment tool

Accurev

7.3

Code Management

Tech Mahindra, USA Mar’14 – Mar’15

Project Lead:

Client: GE Transportation, Erie, PA

GE Transportation’s Remote Monitoring & Diagnostics (RM&D) team monitors locomotives 24 hours per day, 7 days per week, and 365 days per year. A suite of customized software tools, programs, and applications to support RM&D’s activities is called Expert on Alert (EOA). The EOA application has been developed internally to meet GE Transportation’s functional requirements.

The EOA system supports critical business processes comprised of complex business functions, programs, databases and infrastructure that have been developed over many years. The complex architecture and components require highly skilled technical resources to maintain business functionality, system up time, performance, & data integrity. GE Transportation will consider project proposals for technical resources to maintain successful operations of the EOA system.

Responsibilities:

Database & System Analysis:

oAnalysis of current system & databases

oMaintain documentation of the entire data state flow, process flow, programs, & infrastructure

oIdentify & benchmark performance hot-spots/bottlenecks

Benchmarking shall include data metrics, graphs, reporting & documentation

oDevelop options for eliminating and/or reducing performance bottlenecks

oImplement appropriate solutions for performance bottlenecks

oDeployments across all environments (DEV, STAGING QA, PROD)

oTesting across environments (DEV, STAGING, QA, PROD)

oDocumentation of benchmark data, code & database changes as appropriate (change control)

Data Analysis:

oUnderstand data dependencies & relationships

oUnderstand & resolve data problems, conflicts, or errors in database ensuring normal operation

oEnsure data integrity is maintained for all transactions

oTrack, trend, & report any on-going data issues

oIdentify root causes for data issues & recommend process or system changes

oData cleanup including data purging, data archival & user/schema cleanup

oDefine policy & procedures for regular data archival

oMinor to medium database enhancements / bug fixes (PL-SQL Procedures & Packages)

Database Structure:

oEvaluation of current database structure and recommend improvements including but not limited to indexing, table relationships, unused tables, combining tables or data

oImplement approved improvements as necessary

Environment:

No.

Tools / Technology

Version

Purpose

Oracle Database 11g Enterprise Edition – 64 bit

11.2.x

Oracle database management system

Oracle PL/SQL

11.2.x

Oracle PL/SQL

Oracle SQL Developer

3.1

Oracle Query tool; PL-SQL

AppWorx

Scheduler used for batch or other scheduled processes

IBM MQ

Messaging Queue

Java 2 Enterprise Edition

Java coding

UNIX-Linux O/S

Operating System Commands & Scripting

Support Central

IT Helpdesk Tool

Tech Mahindra, USA Sep’12 – Jan’15

Project Lead:

Client: GE Transportation, Erie, PA

Responsibilities:

Performed analysis of critical issues and provide expertise and follow-ups towards resolution.

As a production support we have received the application issues request from TSG server now as SR and INC based on the prioritized issues.

Identified and make recommendations on streamlining and efficiency improvements for applications and related processes.

Participated in testing’s in order to understand data flow.

Ability to interact directly with the business users, debug and derive the technical issue related to a customer query.

Handling tasks well within the SLA limits and maintaining the KPIs.

Team work and ability to learn and adapt to new technologies.

Understanding of SDLC and Programming models.

Have created Minor Enhancements to improve the availability of application.

Database management and JDBC connectivity.

Testing - unit testing & integration testing.

Played an active role in the development for Informatica Integration with other applications.

Worked in subsystems (Email) and batch programs required for the application.

Written queries in SQL to generate the automated reports and emails from time to time.

Played an active role in checking the Performance of the queries through I3 tool and to tune the report queries where required.

Mentor and lead junior developers.

Environment:

No.

Tools / Technology

Version

Purpose

Oracle Database 11g Enterprise Edition – 64 bit

11.2.x

Oracle database management system

Oracle PL/SQL

11.2.x

Oracle PL/SQL

Oracle SQL Developer

3.1

Oracle Query tool; PL-SQL

AppWorx

Scheduler used for batch or other scheduled processes

Messaging Queue

Java 2 Enterprise Edition

Java coding

UNIX-Linux O/S

Operating System Commands & Scripting

Support Central

IT Helpdesk Tool

Mahindra Satyam, INDIA Nov’11 – Sep’12

Title: Team Lead

Client: GE Transportation, PA

Responsibilities:

Performed analysis of critical issues and provide expertise and follow-ups towards resolution.

As a production support we have received the application issues request from TSG server now as SR and INC based on the prioritized issues.

Identified and make recommendations on streamlining and efficiency improvements for applications and related processes.

Participated in testing’s in order to understand data flow.

Ability to interact directly with the business users, debug and derive the technical issue related to a customer query.

Handling tasks well within the SLA limits and maintaining the KPIs.

Team work and ability to learn and adapt to new technologies.

Understanding of SDLC and Programming models.

Have created Minor Enhancements to improve the availability of application.

Database management and JDBC connectivity.

Testing - unit testing & integration testing.

Played an active role in the development for Informatica Integration with other applications.

Worked in subsystems (Email) and batch programs required for the application.

Written queries in SQL to generate the automated reports and emails from time to time.

Played an active role in checking the Performance of the queries through I3 tool and to tune the report queries where required.

Mentor and lead junior developers;

Environment:

No.

Tools / Technology

Version

Purpose

Oracle Database 11g Enterprise Edition – 64 bit

11.2.x

Oracle database management system

Oracle PL/SQL

11.2.x

Oracle PL/SQL

Oracle SQL Developer

3.1

Oracle Query tool; PL-SQL

AppWorx

Scheduler used for batch or other scheduled processes

Messaging Queue

Java 2 Enterprise Edition

Java coding

UNIX-Linux O/S

Operating System Commands & Scripting

Support Central

IT Helpdesk Tool

Mahindra Satyam,INDIA May’10 - Nov’11

Title: Team Lead

Client: GE Energy, GA

The Personal Income Tax (PIT) STBT solution is to be developed in conjunction with GE corporate. The Wing to Wing solution will provide data consolidation & reconciliation, determine taxable amounts, tax filings, reporting to P&L’s, and true-up standard to actual cost. The standard solution will help drive tax compliance by improving accuracy, completeness, & timeliness of tax filings, increase cost savings by avoiding penalties as a result of non-compliance and ensure ledgers are properly stated via the true-up.

Responsibilities:

Performed analysis of critical issues and provide expertise and follow-ups towards resolution.

As a production support we have received the application issues request from TSG server now as SR and INC based on the prioritized issues.

Identified and make recommendations on streamlining and efficiency improvements for applications and related processes.

Participated in testing’s in order to understand data flow.

Ability to interact directly with the business users, debug and derive the technical issue related to a customer query.

Handling tasks well within the SLA limits and maintaining the KPIs.

Team work and ability to learn and adapt to new technologies.

Understanding of SDLC and Programming models.

Have created Minor Enhancements to improve the availability of application.

Database management and JDBC connectivity.

Testing - unit testing & integration testing.

Played an active role in the development for Informatica Integration with other applications.

Worked in subsystems (Email) and batch programs required for the application.

Written queries in SQL to generate the automated reports and emails from time to time.

Played an active role in checking the Performance of the queries through I3 tool and to tune the report queries where required.

Environment:

No.

Tools / Technology

Version

Purpose

Oracle Database 11g Enterprise Edition – 64 bit

11.2.x

Oracle database management system

Oracle PL/SQL

11.2.x

Oracle PL/SQL

Oracle SQL Developer

3.1

Oracle Query tool; PL-SQL

Java 2 Enterprise Edition

Java coding

UNIX-Linux O/S

Operating System Commands & Scripting

Support Central

IT Helpdesk Tool

Satyam Computers Services Ltd, INDIA Aug’07—May’10

Title: Software Engineer

Client: GE Energy, GA

Partsedge and eSPL is one of the big and best CASPER framework applications in GE Energy. There are 11k users worldwide for this application in energy sector. It will provide the access to user based on their business terms with General Electric Company. The application will allows users to search GE energy parts and place a Quote and Orders for those parts. Even it allows users to place Quotes and Orders for undefined parts in system. Will send the Quotes and Order to ERP and receive those, once they are processed in ERP with all ERP business functionality through Web Methods Integrations.

Responsibilities:

Performed analysis of critical issues and provide expertise and follow-ups towards resolution.

As a production support we have received the application issues request from TSG server now as SR and INC based on the prioritized issues.

Identified and make recommendations on streamlining and efficiency improvements for applications and related processes.

Participated in testing’s in order to understand data flow.

Ability to interact directly with the business users, debug and derive the technical issue related to a customer query.

Handling tasks well within the SLA limits and maintaining the KPIs.

Team work and ability to learn and adapt to new technologies.

Understanding of SDLC and Programming models.

Have created Minor Enhancements to improve the availability of application.

Database management and JDBC connectivity.

Testing - unit testing & integration testing.

Played an active role in the development for Informatica Integration with other applications.

Worked in subsystems (Email) and batch programs required for the application.

Written queries in SQL to generate the automated reports and emails from time to time.

Played an active role in checking the Performance of the queries through I3 tool and to tune the report queries where required.

Environment:

No.

Tools / Technology

Version

Purpose

Oracle Database 11g Enterprise Edition – 64 bit

11.2.x

Oracle database management system

Oracle PL/SQL

11.2.x

Oracle PL/SQL

Oracle SQL Developer

3.1

Oracle Query tool; PL-SQL

Java 2 Enterprise Edition

Java coding

UNIX-Linux O/S

Operating System Commands & Scripting

Support Central

IT Helpdesk Tool

Education:

Bachelor of Science in Computer Science

Master’s in Business administration (Finance)

Contact this candidate