Flervous Nzateh

SQL/ETL Developer

Location: Dallas, TX Email: adz6it@r.postjobfree.com Phone: 937-***-**** SUMMARY

5+ years of Strong Experience in developing applications using SQL Server Integration Services and Reporting Services with Experienced in whole cycle of DTS/SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers.

Worked on automating the SSRS work flows.

Strong knowledge in creating Indexes, Views, Triggers, Common Table Expressions(CTE), effective functions, and appropriate Stored Procedures to facilitate data manipulation and data consistency.

Conversant with various phases of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation

Experience in creating master and child packages, package configurations and logging Using SSIS.

Expert in using tools like SASS, SSRS, SSMS and Power BI for monitoring & tuning SQL server performance.

Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, MySQL, SQL Server, MS Access and flat file.

Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs with Excellent Verbal & Written Communication skills and strong in Documentation. SKILLS

ETL Tools: Informatica, Informatica PowerCenter, SSIS and DTS Database: Oracle, MySQL, MS SQL Server and MS Access DB Tools: SQL*Plus, TOAD and SQL Loader

Environment: Windows, Linux and MacOS

Languages: SQL, PL/SQL and UNIX

Tools: SASS, SSRS, SSMS, Tableau, Power BI, MS Visio, AutoCAD and MS office suite Others: Machine Learning, Azure Cloud, Data Analysis, Exploratory Data Analysis, Statistically Data Analysis, Data Modelling, Data Profiling, Data Warehousing, Data Cleaning and Data Migration EXPERIENCE

Clairvoyant, Remote, USA Nov 2020 – Present

ETL Developer

Created analysis of source systems, business requirements and identification of business rules.

Responsible for developing, support & maintenance for ETL (Extract, Transform and Load) processes using PowerCenter

Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.

Extensively used ETL to transfer & extract data from source files (Flat files and DB2) and load data into target database.

Documented Mapping and Transformation details, user requirements, implementation plan and schedule.

Extensively used Autosys for Scheduling and monitoring

Designed and developed efficient Error Handling methods and implemented throughout the mappings. Responsible for Data quality analysis to determine cleansing requirements.

Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.

Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads

Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance. Understand the business needs and implement the same into a functional database design

Prepared Unit/ Systems Test Plan and the test cases for the developed mappings. LatentView, Remote, USA Apr 2018 – Sep 2020

Junior ETL/SQL Developer

Extract, Transform and Load using SSIS and T-SQL Stored Procedures.

Extracted data from Oracle (Claims DB) and migrated into SQL Server 2005 using SSIS.

Captured table join blind spots effects from existing reports and databases.

Used dimensional conformance strategies for efficient loss ratio reports.

Performance tuning of Queries and Stored Procedures.

Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Developed Data Warehouse is using Microsoft SQL Server Integration Services (SSIS).

Implemented checkpoint mechanism, SSIS Package Optimizations, Error handling and logging as part of fast development.

Implemented various levels of Transaction Support and Dynamism.

Wrote complex SQL against data store for validating the report accuracy and in helping the QA team with testing strategy.

Deployed & managed SSIS packages for Package deployment, Import/Export, Configuration modifications & Backup.

Developed & tested fact table partition strategy to min performance impact due to additional history data in fact tables.

Design, development & testing of all Oracle PL and SQL stored procedures to improve performance Designed the deployment plan to rollout the data warehouse to production.

Created the migration documents and migrated the code to the production environment. EDUCATION

Bachelor Degree in Computer Science Dec 2017

University of Buea, Cameroon

Contact this candidate