Senior PLSQL & ETL Lead Developer

Erman Sezer

Lead PLSQL Developer

**********@*****.*** 551-***-****

SUMMARY

Over 17+ years of experience in ETL, Data Migration, Data Quality and Data Governance experience on various projects on various sectors. Certified Trainer on IBM Datastage. Professional experience of working on different SDLC methodologies such as Agile (Scrum), Waterfall. Experienced on Unix and Windows platforms.

Strong skills in IBM Datastage, SQL, PL/SQL, IBM Information Server Components.

Strong skills in data warehouse, data profiling, data extraction, data validation, data quality.

Expertise in creating, configuring and fine tuning ETL workflows designed between homogenous and heterogeneous systems using IBM Datastage, ODI, Talend, Informatica.

Expertise in building complex SQL Queries to perform data mining, data analytics, and data extractions across databases.

Experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering ERWIN diagrams, analyzing data sources and creating interface documents.

Experience in data quality projects using IBM Information Analyzer, IBM QualityStage.

Experience in creating ETL Sequences using IBM Datastage.

Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re-usable transformations, PL/SQL stored procedures.

Experience in Data warehousing, Data Architecture & Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center.

Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on MySQL database.

Strong team player with great verbal, written communication, and interpersonal skills. Proven ability to prioritize and complete multiple tasks. Proven capacity to approach problems effectively and creatively.

Quick learner and hard worker willing to take responsibilities.

TECHNICAL SKILLS

Programming

SQL, PL/SQL, .NET, Python, Spark, GCP, Azure

BI

Erwin, IBM Cognos, IBM Data Architect

Databases

Netezza, DB2, Oracle, MS SQL Server, T-SQL, MySQL, Mongo DB, Microsoft Access, Teradata, Big Data Technologies

Project Management

Jira, MS Project, Trello,

ETL

IBM Datastage, ODI, SQL, PL/SQL, Talend, Informatica

Cloud

Snowflake, Azure, Google Cloud Platform

PROFESSIONAL EXPERIENCE

Walmart – Arkansas (Remote) – (Sep 2021 - )

Lead PLSQL Developer

Homeoffice Team – Located in AR

Walmart is the World’s largest retail company and ETL is very critical on most of the times, so performance tuning, time estimation, using best-practises are almost critical.

Working in Event Driven Fulfillment team as a Senior ETL Develoer

Creating ETL Jobs using PLSQL and Unix.

Scheduling PLSQL and Kafka jobs using Ctrl- M and CA7 (Mainframe)

Performance Tuning on high volume data loading jobs

Writing complex SQL queries for checking the counts and for validating the data at field level.

Requirement gathering, status update, development delivery, project estimation and Project releases.

Haven Life - New York, NY - (Sep 2020 – Sep 2021)

Lead PLSQL/ETL Developer – Technical Lead

Analyzing all SAP Data Services work flows and decide the architecture on IBM Datastage

Creating ETL Jobs using IBM Datastage and Unix.

Participated in Project Management Activities like requirement gathering, status update, development delivery, project estimation and Project releases.

Designed a complete end to end application flow and develop the response program to communicate with Customized screen

Deciding ETL Architecture like parameter sets, configuration files, data sets, scheduling mechanism etc.

Co-ordinated with business users to understand functional requirements. This included creating ETL Specification Document, participating in review meetings.

Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin

Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.

Writing complex SQL queries for checking the counts and for validating the data at field level.

Prepared sample test data by inserting data into staging tables.

Tested the format of the reports according to the specifications provided and compared the data in the reports with the backend Datamart through SQL and using excel for data comparison.

Worked with data standardization, Merge and data pattern matching.

Turkish Airlines, Istanbul (Mar 2020- Sep 2020)

Lead ETL/PLSQL Developer – Technical Lead

Turkish Airlines are one of the world’s largest Airline company.

IBM Datastage Migration Project

Performance Tuning on IBM Datastage

Designing and developing new datasets, ETL processes, BI reports in order to meet business demands.

Cataloging and managing all BI assets within current environments, creating business glossary for business/data management teams

Creating entity and attribute level data lineage mappings from source systems to business layer in order to provide consistent/trustworthy dependency analysis

Data Migration Projects using IBM Datastage, Netezza, Teradata, Oracle Exadata, ODI

Gathered and translated Business requirements into detailed production-level technical specifications.

Gathered Requirements and interacted with Subject Matter Experts to identify, understand and document business needs for data.

Responsible for understanding design and structure of different databases. Also involved in writing ad-hoc queries for data mining.

Create logical and physical models using best practices to ensure high quality and reduced redundancy.

Created and managed schema objects such as Tables, Views, Indexes, and referential integrity depending on user requirements.

Used DDL and DML commands for writing triggers, stored procedures, and data manipulation.

Involved in tuning system stored procedures for better performance.

Working with .Net Team closely for code review and requirements and tests.

IETT (Istanbul Public Transportation Company), Istanbul (Jul 2019- Mar 2020)

Senior ETL Developer

IETT is World’s largest Public Transportation Company. They have large volume data.

IBM Datastage Development

Responsible for IBM Information Analyzer, IBM Business Governance Catalog

Responsible for the management of the database performance, backup, replication, capacity and security.

Developed a Conceptual model using Erwin based on business requirements.

Built conceptual, logical, and physical models using Erwin.

Involved in Analysis, profiling and cleansing of source data and understanding the business process.

Analyzed and created business intelligence reports in both SSRS and MicroStrategy according to business requirements.

Created grid reports, graph reports, drill down and drill through reports.

Developed normalized Logical and Physical database models to design OLTP system for finance applications. Created dimensional model for reporting system by identifying required dimensions and facts using Erwin r8.0.

Identified facts and dimensions based on KPI and identified the source tables.

Involved in documentation of Data Mapping and ETL specifications for development from source to target.

Created Indexes and Partitions to optimize the performance.

Implemented the change Data Capture (CDC) while integrating the enterprise data sources.

Boyner Department Store, Istanbul (Jul 2018- Jul 2019)

Senior ETL Developer

Working on DWH Project

ETL Development (IBM Datastage, ODI, PLSQL)

Leading technical teams on R&D projects.

Working as Technical Leader on DWH & BI Projects

Designed, built, and maintained all components of data warehouse which includes numerous numbers of ETL processes, stored procedures, reporting environments, dashboards, scorecards, ad hoc requests on regular basis- monthly, quarterly, and daily utilizing SQL as a language to communicate.

Developed huge number of ETL processes for error handling, data manipulation, data preparation using IBM Datastage.

Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.

Hands-on technical lead with thorough knowledge of ETL, Data modelling scripting and SQL

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Migros, Istanbul (Jul 2017- Jul 2018)

Senior ETL Developer

Hands-on development on ETL Projects (IBM Datastage)

Training, coaching and overseeing junior consultancy recruits within the team

Working as a Data Architect on Data Related Projects

Analyze data model, write business algorithms using stored procedures and queries, and perform proof of concepts for new data architecture.

Created databases, tables, views & schemas.

Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detailed analysis and design.

Collected, reviewed, and analyzed quarterly and annual financial asset data.

Evaluated data profiling, quality, cleansing, integration, and extraction tool.

Analyze and study the source system data models to understand concept tie-outs such that the integration process into existing data warehouse is seamless and data redundancy is eliminated.

Performed data analysis on the target tables to make sure the data as per the business expectations.

Groupama Insurance, Istanbul (Aug 2015- Jul 2017)

Senior ETL Developer

Worked with IBM Information Server product family including DataStage, QualityStage, Information Governance Catalog, Information Analyzer, Change Data Capture and support,development and consultancy about Information Management.

Worked in projects with Netezza, Teradata and Big Data.

Analyzed data from multiple sources, developing reports, providing valuable insights.

Extracted data using OLTP and OLAP connections.

Monitored workflow process to enter, create, or change the data.

Conducted or performed data modelling exercises in support of subject areas and/or specific client needs for data, reports, or analyses, with a concern towards reuse of existing data elements, alignment with existing data assets and target enterprise data architecture.

Developed conceptual, logical, and physical Enterprise Data Model based on industry standards.

Worked with SQL, Stored Procedures, Triggers, Advanced T-SQL queries

Developed complex SQL queries, and performed execution validation for remediation and Analysis.

Worked with cross-functional teams to build out data queries that highlight potential issues and changes to check erroneous data.

ING Bank, Istanbul (Sep 2014- Aug 2015)

Senior PLSQL Developer

Responsible for IBM Datastage jobs and PL/SQL Development

Responsible for Data Quality and Data Profiling using IBM Quality Stage and IBM Information Analyzer

Monitored DWH jobs

Analyze and study the source system data models to understand concept tie-outs such that the integration process into existing data warehouse is seamless and data redundancy is eliminated.

Performed data analysis on the target tables to make sure the data as per the business expectations.

Ziraat Bank, Istanbul (Oct 2013- Sep 2014)

Senior PLSQL Developer

Responsible for IBM Datastage jobs and PL/SQL Development

Developed complex SQL queries, and performed execution validation for remediation and Analysis.

Evaluated data profiling, quality, cleansing, integration, and extraction tool.

Analyze and study the source system data models to understand concept tie-outs such that the integration process into existing data warehouse is seamless and data redundancy is eliminated.

BNP Paribas, Istanbul (Oct 2012 - Oct 2013)

PL/SQL Developer

Responsible for IBM Datastage jobs and PL/SQL Development

Developed complex SQL queries, and performed execution validation for remediation and Analysis.

Analyze and study the source system data models to understand concept tie-outs such that the integration process into existing data warehouse is seamless and data redundancy is eliminated.

Hal bankz, Istanbul (Oct 2010 - Oct 2012)

ETL Developer

Responsible for IBM Datastage jobs and PL/SQL Development

Worked with IBM Information Server product family including DataStage, QualityStage, Information Governance Catalog, Information Analyzer, Change Data Capture and support, development and consultancy about Information Management.

Hands-on development on ETL Projects (IBM Datastage)

Isbank, Istanbul (Oct 2008 - Oct 2010)

ETL Developer

Responsible for IBM Datastage jobs and PL/SQL Development

Worked with IBM Information Server product family including DataStage, QualityStage, Information Governance Catalog, Information Analyzer, Change Data Capture and support, development and consultancy about Information Management.

Hands-on development on ETL Projects (IBM Datastage)

Sabri Ozel Textile (Oct 2006 – Oct 2008)

SQL Developer

Responsible for SQL Development for campaigns

Responsible for ERP SQL Development

EDUCATION

MBA (Management of Information Systems) Bahcesehir University, Istanbul, Turkey

BSC (Computer Engineering) Istanbul University, Istanbul, Turkey

CERTIFICATION

IBM Datastage

IBM CDC

IBM Netezza

Advanced SQL

PL/SQL

Contact this candidate