Data Developer

Professional Summary

* ***** ** ** ********** in Design, Development and Implementation of large scale and medium scale Data warehousing Applications using ETL tool Datastage.

* **** ** ********** in Build petabytes scale optimized and highly stable ingestion pipelines from various sources to dataflatform and perform complex transformations using Google Cloud Platfrom(Biguery,Dataflow,DataProc)

IBM Certified Solution Developer - InfoSphere DataStage v8.0

Strong knowledge in Data Extraction Cleansing Transformation Integration and Loading (ETL methodology) processes in corporate-wide Data warehouse using IBM Info Sphere Datastage/Quality Stage, Information Analyzer and UNIX Shell Scripting.

Extensive experience in integration of various Relational Database systems like Oracle, DB2,Sybase and other Data Sources like XML,CSV,Files and Flat Files into Staging Area/Data warehouse/Data marts using several stages in IBM InfoSphere Datastage.

Exceptional experience in Debugging, Troubleshooting, Monitoring, Performance Tuning of

ETL processes using IBM Info Sphere DataStage.

Profound knowledge on Data warehouse concepts like Data warehouse architecture, Star schema, Snowflake schema, Data Marts, Operational Data Store, Dimension and Fact tables.

Experienced in preparing and documenting of S-t-T (Source to Target Mapping document), Unite Test cases

Good ability to define and capture Meta data and Business rules associated with the ETL processes

Good exposure to IBM DB2, Oracle databases.

Ability to rapidly learn new concepts together with excellent interpersonal skills.

Good team player with outstanding analytical and problem-solving skills.

Proficient in the Design and Development of process required to Extract, Transform and Load (ETL) data into an integrated Data warehouse.

Good ability to define and capture Meta data and Business rules associated with the ETL processes.

Extensively worked on DataStage Tools: Designer, Director and Information Server Manager.

Having good hands-on experience in production support.

Having onsite experience worked with direct client location.

Experience Summary

Working as a Technology Lead in INFOSYS, Hyderabad from Feb 2018 to till date.

Worked as a Project Lead in HCL Technologies, Hyderabad from Aug 2012 to Feb 2018.

Education

Master of Computer Applications (MCA - 2009) from JNTU University, Anantapuram.

Bachelor of Science in Electronics (2006) from SK University, Anatapuram.

Technical Skills

ETL tool: IBM Information Server 8.0.1, 8.1, 8.5 and 11.5

Languages: SQL

Data Visualization Tableau 10.3

Database Management: IBM DB2 9.5, 9.7, 10.5, Oracle DB 11g, Sybase

Operating system: UNIX, HP-Linux, All versions of Windows.

Scripting Language: Shell Script

Defect Tracking Tool: JIRA

Big data HDFS 2.0

Scheduling Tools Autosys, CONTROL-M

Google Cloud Platform Big Query, BigTable,CloudStorage,CloudSql,DataProc,DataFlow,pubsub,

Stack driver

Project#1

Client Name: HSBC

Project Name: Name Screening

Role: ETL Developer and GCP Data Engineer

Environment: Data Stage 11.3/11.5, Oracle, LINUX, Windows XP, JIRA,, Shell Script, GCP(Big Query, Dataflow, DataProc, Cloud storage

Duration: Feb 2018 to till date

Team Size: 15

Description:

The HSBC global standard program is designed to drive and oversee initiatives that define and implement internal standards in support of strengthening HSBC's response to the on-going threat of financial crime and strengthening the policies and process that govern how HSBC do business with whom. The scope of the programme is to put in place a system, processes and procedures that can reassure a regulator that HSBC customers are not using the bank for money laundering purpose.

Responsibilities:

Understanding the business functionality & Analysis of business requirements by using DRS documents.

Designed the parallel and sequence jobs based on the business requirements by using multiple stages like Sequential File, Transformer, Aggregator, Join, Lookup, Sort,oracle connector and Filter during ETL development.

Used Data Stage Director to run and monitor the Data Stage jobs.

Responsible for creating the code test documents.

Involved into status meeting with business people.

Working under Agile model, so responsible to attend the daily status calls and to be self-driven team player.

Project # 2

Client Name: GTECH

Project Name: IGT INTELLIGEN SYSTEMS

Role: ETL Developer and ETL Lead

Environment: Data Stage 8.0.1/8.1/8.5/11.5, DB2 9.5/9.7/10.5v, LINUX, Windows XP, PVCS, JIRA, PMax, Shell Script,

Duration: August 2012 to Feb 2018

Team Size: 15

Deliveries: 27 (Baseline, Sweden, US (4 states), Italy (11 concessionaries), Argentina, Canada (5 states), Greece, Switzerland)

Brief Description about Project:

The core solution of ABI is to extract, transform and load data from central systems of video lottery systems to data warehouse systems and providing different kinds of reports, analytics and dash boards to different users of lottery around the globe.

Roles Played:

ETL (Data Stage) Developer

ETL Team Lead

QA Support

Production LIVE Support

Release Management

Baseline Code Management (BL 3.3,3.4,4.2,5.0,6.0)

Responsibilities:

Analyzing client requirements and clearly understanding the actual needs of parallel job and creating templates of it.

Installation of Datastage clients (8.0.1, 8.1, 8.5 and 11.5) and Server Fix Packs.

Involved in Designing of Parallel and Sequence jobs for the requirements.

Administration of the IBM Information Server through Web Console and in Linux level

Involved in Tuning the Parallel jobs in Design and the SQL queries for improving the performance.

Involved in Monitoring and Scheduling of Job Sequences through Data stage director for Daily as well as Hourly runs. Creation of Scripts for retrieving the log of the aborted Data stage Parallel jobs after the completion of the Master Sequence on schedules.

Involved in creation of Audit or Balance Report in BO which provides information about the count of data in the Dimension and Fact tables and scheduled it to run after the Master Sequence completes.

Involved in preparing LLD, HLD, SSD, UTC, UTP documents.

Data Stage server management

Handling deployment of ETL solution to QA, CAT/UAT and PROD environments.

Guiding, mentoring and knowledge transfer to new joiners on Data stage and Lottery domain concepts.

Extensively Work with IBM support to resolve any datastage related tickets/issues on ETL failures, Installation failures

Handling certain DBA activities such as Backup of Database, Restore of Database, Purging of DB logs, Import and Export using External files in DB level.

Involved in troubleshooting reports data issues and supported the reports team with necessary data correction/reloads

Involved in creating a new project starting from setting up of initial configuration for a particular project and Server configuration with respect to datastage

Involved in Data Migration activities for SEJQ Market.

Created Automated ETL code deployment and Build Script for code delivery and purge script to clear db2logs automatically

Provided 24X7 support to the Customers to complete the task ON TIME.

Handled Conversion Activities in CAT and PROD system for the following markets :

Pennsylvania Lottery

oOREGON STATE Lottery

oALBERTA GAMING Lottery

oATLANTIC Lottery

oMANITOBA Lottery

oWESTERN CANADIAN Lottery

oQUEBEC Lottery

Contact this candidate