11/06/2023 updated

JP
100 % available

Data Engineer, ETL Developer, Datascience

India
Only remote
BTech
India
Only remote
BTech

Profile attachments

CV - Jhansi Pushadapu

C (Programming Language)Agile MethodologyAmazon Web ServicesIBM System IAtlassian ConfluenceAtlassian JiraUnit TestingMicrosoft AzureBash ShellBug ManagementUnixCloud ComputingCloud DatabaseCode ReviewDatabasesCustomer Data ManagementData CleansingInformation EngineeringExtract Transform Load (ETL)Data ManagementData MigrationData ProfilingIBM DB2IBM InfoSphere DataStageDebuggingFile SystemsApache HadoopApache HiveTivoli Management FrameworkIBM Websphere Application ServerSAP IDocJSONJob SchedulingPython (Programming Language)Unix ShellMachine LearningMicrosoft SQL ServersMySQLNode.jsOracle ApplicationsParsingPerformance TuningPuTTYMicrosoft Power BISAP ABAPSAP ApplicationsScalaMicrosoft SharePointSoftware EngineeringPL-SQLSQL DatabasesData StreamingSalesforce TableauTeradata SQLWorkbooks CRMAutomated Data Processing (ADP)File Transfer Protocol (FTP)Azure Data FactorySAP FinanceLarge Language ModelsSnowflakeApache SparkSwift (Programming Language)SAP BAPIGitData LakeOperational SystemsReporting ToolsCloud MigrationSoftware Version ControlJenkinsAlteryxAmazon RedshiftControl M
ABAP, Agile, Alteryx, Redshift, AWS, Hadoop, Hive, spark, ADP, Azure Data Factory, Bash, C, Cloud, Cloud Technologies, Cloud Database, Cloud migration, code review, Confluence, Control M, Customer Data, data cleansing, Data lake, Big Data Tools, Data Migration, data profiling, Data Flow, Databases, database, ETL, ETL Tools, Sequential Files, FTP, GIT, DB2, Datastage, AS400, IBM's, IBM WebSphere, Idoc, Data Engineer, Jira, Json, Jenkins, Job scheduling, LLMs, Machine Learning, ML, Azure, Microsoft Azure, SQL Server, SharePoint, MS Windows, MySQL, node, Operating Systems, Oracle, PL/SQL, Parser, Performance tuning, Power BI, Putty, Python, SAP, BAPI, SQL Scripting, SQL, SAP Finance, Scala, Snowflake, Bug fixing, debugging, debug, Application Development, Version management, Swift, Tableau, Teradata, Tivoli, Reporting Tools, Unit Testing, UNIX, UNIX Shell Scripting, UNIX Shell, workbooks

Experience

Professional experience5 - 10 years
Freelancer since2018

Languages

EnglishFluentTeluguFluent

Project history

Data Engineer

Collabera Technologies

Global Payroll Interface Handler

GPIH
It is IBM Internal Application which acts as interface handler among various interfaces like (Dauche
bank, ADP,Swift bank, IBM,ODM etc.,) and is a back bone for all of the Awards/Recognition data, that
flows in from the global recognition vendor to the various payroll systems of IBM.
.
Roles and Responsibilities:

* Extracted the data from database tables and Flat File data sources, Transformed and Loaded
into Target through FTP/SFTP
* Responsible for interacting with the Business clients and taking part in review of
requirements document discussions.
* Did the data profiling and prepared source to target documents based on profiling results.
* Preparing the low-level design documentation according to client's specification.
* Key designer for ETL jobs and responsible for code review of ETL deliverables.
* Designing of the ETL Processes using different parallel job stages such as Join, Merge,Lookup,
Filter, Dataset, Transformer, sort, and Aggregator
* Responsible for Code check-in, Version management and all the implementation activities
* Provided the support for testing team in SIT phase.
* Provided the Support for UAT on data load.
* Involved in implementation work and successfully implemented in stage and production
environments and supported.
* Working as L3 support also for any urgent critical issues in prod.
* Key designer for ETL jobs and responsible for code review of ETL deliverables.
* Responsible for driving the status calls and technical calls within team and other dependent
teams

Senior Data Engineer

Optum

Senior Data Engineer

PROJECT #3

Project Name : Life Sciences BYOD
Client : Optum
Environment or Tools : Spark, Python, SQL, Palantir Foundry, Machine Learning models
Duration : May 2022 to Dec 2022
Role : Senior Data Engineer

Description:
Life Sciences BYOD Team works on implemented Life Sciences Palantir Foundry. The Source system is
Optum Patients data, it tries to reduce the cost and time in drug prediction, drug comparisons to
the patients with respect to the complaints raised by the patients during consultation either
directly or through supporting system.

Roles and Responsibilities:

* Supporting the issues comes up in the builds on foundry, by debugging the code
* Debugging starts after building own workbooks in sandbox using the available datasets from the
source system on py spark / python
* Once the debug work book works then push them to prod environment through GIT
* Also work on changes as per business analyst suggestions on the pipeline by observing the
lineage graph /code book developed and push them to prod after a success run

Developer

System Engineer

PROJECT #4

Project Name : Intrepid
Client : Advance Auto Parts
Environment or Tools : Datastage, DB2, Oracle, UC4, AS400,
Duration : March 2021 to Nov 2021
Role : System Engineer

Description:

Intrepid is a one-time Data Migration project which is migrating AAP Customer Data including
invoices barcodes Locations etc., from RMS Oracle server to Blue Yanders PMM Cloud area with
cleansing and conversions including which is resulting in quality data with required enhancement
for analyzing customer data for better analyzation of business.

Roles and Responsibilities:

* Source Data analyzation which is residing on various systems like oracle, AS400 DB2, Sequential
Files, MDM Data etc.,
* Implemented Rinse and Repeat Cycles in loading data on target system each and every week for
better success rate.
* Involved in the requirement analysis phase, status calls, rinse and repeat phase in cleansing
the data daily bases and corrected the failure records.
* Extracted data from Oracle, AS400 Source system and completed successful migration of release
1 data with implementing data cleansing, Conversions and other data quality checks required as
per Target System needs
* Scheduled DS Jobs using UC4
* Developed Data stage Jobs with implementing good performance techniques and 0 warnings to make
sure, migration happens at 100% with no failures
* Followed Standard formats in the jobs, annotations, debugging, performance checks, node
configurations and took advantage of DataStage parallelism to increase the speed of job run as
having huge data.
* Since Data cleansing issues been not addressed till last minutes, addressed them with agreed
workarounds to not to disturb deployment timelines but with corrected and expected data.
* Worked on many data issues occurred on address or barcode column s as per business need.

System Engineer

TEK SYSTEMS

Datastage Developer

PROJECT #5

Project Name : IERP
Client : IBM
Datastage : Datastage 11.5 ,9.1, 8.5
Duration : September 2017 to March2021
Role : Datastage Developer

Description:
Under the SAP Fulfillment program, integrated Enterprise Resource Planning helps transforming IBM
traditional/ledger systems to modern iERP systems supporting IBMs transition to Digital, Cloud and
Cognitive capabilities. The SAP Fulfillment program supports the deployment of integrated Enterprise
Resource Planning systems across IBM's four major supply chain processes: Hardware (HW), Software
(SW) and Services along with an Integrated SAP Finance Solution. ERP's ambition is to transform IBM
internal business processes of the Enterprise Resource Planning system to an SAP enabled platform.
Going forward, IBM will use the same end-to-end integrated systems for internal key workflows, such
as the so-called quote-to-cash process which covers all sales-related business transactions from
product configuration and quote creation to contract/order management and invoicing. Quote-to-cash
comprises the integration and management of end-to-end business processes on the sales side and
covers sales-related transactions such as a Product or Service Configuration Pricing Quote creation
for a prospect, customer or channel partner Contract life cycle and order management Invoicing
Payment receipt.
Roles and Responsibilities:
* Collection of data from various sources (SAP tables and DB2).
* Transforming and enriching the data collected.
* Identify, analyze and fix the issues in the production system.
* Involved in Datastage Migration from 8.5v to 11.5v.
* Extraction and loading of data from and to SAP tables using ABAP, BAPI and Idoc Stages
* Generate Reports for various applications based on their run statistics. Reports are generated
weekly/monthly or quarterly.
* Track various ETL application run status and assist in activities to meet the daily SLA for
business users.
* Interface with business users to understand reporting requirements and assist in creating new
analytical reports.
* Provided on call support for the client. Activity includes fixing and attesting issues post normal
working hours. Accept incidents and work towards fixing the issues in the mission critical
applications.
* Effectively used debugging stages like row generator to create mock data.
* Support like activities like Handling Incidents and Problem Ticket based on SLAs. Change Requests
and Deployments to production.
* Send Daily Reports and weekly reports to Management and End Users.
* Identify and promote best practices for all activities related to support.

Data Engineer

IBM India Pvt Ltd

Datastage Developer

PROJECT #6

Project Name : IACRR & GPIH -IBM Internal Projects- Hyderabad
Client : IBM
Environment : Datastage 11.3,9.1
Duration : Dec 2015-Dec 2017
Role : Datastage Developer

Description:

IACRR: International Assignee-Cross Reporting Repository
It is IBM Internal Application which used Datastage for its operations. It requests the payroll
details from all the IBM related countries, process the data and send response payroll details to
respective end users.

Datastage developer

PROJECT #7

Project Name : SIC(Standard Insurance Company)
Client : SIC (USA)
Environment : Datastage UNIX, MySQL, BODI
Duration : July 2014-Dec 2015
Role : Datastage developer

Description:

Standard Insurance Company, also branded as the standard, is an American insurance and financial
company which is a subsidiary of StanCorp Financial Group, headquartered in Portland, Oregon. The
Standard deals in Disability insurance (Group long term disability and short-term disability) and is
the market leader in this segment, other products offered are individual disability, Life, Dental
and retirement planning services.
.

Roles and Responsibilities:

* Understanding and Analyzing the Client/Business Requirements by studying and documenting the
functional specifications.
* Analyzing the Source Systems, Data Flow, identifying dependencies and understanding Data
Model.
* Building the DataStage Jobs to pull the data applying the Business transformations using
various processing stages like Join, look up, Sort, Copy, Transformer, Funnel, DB Stages and
converted existed BODI Code
* Implemented many transformation activities in DataStage before loading the data into various
dimensions and fact tables.


* Creating Weekly Status Reports detailing the Project status along with the stakeholder
involvement.
* Conducting Unit Testing and Creating Test Cases for every DataStage Sequence.
* Identifying the Overall Jobs/ Sequence dependencies and creating the Sequence Jobs.
* Parametrizing and using the parameter sets to call for the values during run-time.
Working on daily Production issues and resolving them within the stipulated time frame

Application Developer

PROJECT #8

Project Name : BAT (British American Tobacco)
Client : BAT (UK)
Environment : SQL, UNIX, DataStage, SAP
Duration : April 2013 to June 2014
Role : Application Developer
Description
British American Tobacco is a global Tobacco company headquartered in London, UK. It is the
world's second largest quoted tobacco company by global market share after (Philip Morris
International) with a leading position in more than 50 countries and presence in more than 180
countries.

Roles and Responsibilities:

* It is a one-time Data Migration project to have a single repository from a distributed
repositories which improves the quality and performance of data and helps effectively in
having the best way to lead business
* Designed the whole flow of Data through DataStage.
* Analyzed the Jobs provided in DataStage, Created Jobs, Loaded complete warehouse.
* Tested the jobs in Data stage.
* Classification and reporting the bugs to the Project Lead.
* Implemented best performance tuning techniques Using IA and IDA Tools for column analysis before
loading to Single SAP System to improve data quality.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in