Data Specialist Resume

SUMMARY

Data Specialist focused on ETL Datastage and Database development having 3 years of progressive experience with Confidential proving data solutions. Strong attention to detail and analytical thinking with a “never give up” attitude that enables solutions to critical problems. Adaptable to fast changing environments with conflicting priorities. Passionate about working with data, learning new technologies.

PROFESSIONAL EXPERIENCE

Data Specialist

Confidential

Responsibilities:

Collaborated effectively with teams from North America, Brazil and China to identify potential risks and issues as well as strategize the extraction and cleaning required
Extracted data from multiple sources, applied transformation logic to it and developed the Data Pipeline by ETL Datastage and SQL scripts
Developed the Database followed by the business requirements and RDBMS principles in order to establish the proper relationship between tables
Loaded the cleaned and transformed data to Databases and Data Warehouse to ensure the availability of the updated data to the end users
Monitored batch jobs on a regular basis to ensure Data Quality and Data Consistency and proposed changes in order to improve the performance time
Participated in weekly Agile Showcase calls to present the report and status of the development to the Clients and Product Owner
Successfully developed a transition plan for the project to make sure that two different business objects can co - exist

ETL Developer

Confidential

Responsibilities:

Developed ETL Datastage parallel and sequence jobs followed by the business requirements provided by the clients in a timely manner
Monitored ETL batch jobs every day and made sure every single jobs are successfully executed in order to make sure that the end users are getting updated data
Resolved over 100 database issues raised by customers ensuring the Database Quality and reflecting the correct data in the customer portal
Implemented GDPR (General Data Protection Regulation) principles which was to remove or mask any personal information from the portal for the entire application
Presented reports based on the Database as well as from the raw data provided by the clients in front of the Product Owner with the help of COGNOS and EXCEL
Performed testing before moving the datastage jobs into production environment.
Performed ‘Root Cause Analysis’ several times when I was assigned to an issue and presented that to the Technical Lead
Evaluated the nature of bug tickets, assigning story points into it and escalating the tickets to the appropriate team in a timely manner

ETL Developer

Confidential

Responsibilities:

Developed SQL scripts to extract data from various databases
Maintained data transformations and data mappings documents throughout the course of the development process
Implemented complex Data Transformations by ETL Datastage to ensure all business requirements are properly reflected
Successfully migrated legacy source system data into target SAP system
Automated the Data Flow by implementing ETL Sequence jobs