Bishoptheodore Dogo

Justin, TX. 424-***-**** ad1wkv@r.postjobfree.com

EXPERIENCE:

Envolve Pharmacy

January 2020 – Present: SENIOR APPLICATION SOFTWARE ENGINEER (INFORMATICA DEVELOPER - ETL), FRESNO, CA

• Develops PowerCenter Workflows and Sessions and sets up Power Exchange connections to database and mainframe files.

• Develops logical and physical data flow models for ETL applications.

• Provide System and Application Administration for Informatica PowerCenter and Power Exchange

• Designs, develops, automates, and supports complex applications to extract, transform, and load data.

• Identifies and manages interfaces, service levels, standards, and configurations.

• Demonstrates working knowledge of Informatica PWC & PWX 8.6.1 or 9.x, 10.2.0, 10.4.1, SQL Server2005/2008 or equivalent databases, SQL, RDBMS(Teradata).

• Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.4.1

• Using Informatica Power Centre tools developed workflows using task developer, worklets designer, and workflow designer in workflow manager and monitored the results using workflow monitor.

• Performance tuning through TPT configuration.

• Good understanding of Control-M

• Create, schedule, and monitor Control-M job

• Working on optimizing and tuning the Teradata views and SQLs to improve performance of batch and response time of data for users.

• Involving in analyzing/ building Teradata EDW using Teradata ETL utilities

• Copy, transfer, and transfer files and create file transfer processes using Unix.

• Use Unix scripts to call the files from landing zone and process the files.

• Experience in writing BTQ scripts to run DML and DDL statements, create Macros, and Stored Procedures.

• Experience in using Jira to track projects.

Mastech Digital-Mphasis-Progressive Insurance

January 2019-January 2020: ETL/DATA WAREHOUSE DEVELOPER, MAYFIELD HEIGHTS, OH

• Designing and implementing data integration architecture for an end-to-end Big Data Analytical solution that integrates unstructured and structured data sources such as XML/XSLT and/or JSON and web logs into Analytical data store.

• Integrating Big data/Analytical data solutions using Hadoop and SQL/Parallel Data Warehouse (PDW), (Microsoft APS), SQL Server 2016 and PolyBase.

• ETL/ELT approach-based data integration and transfer using Syncsort DMX-h, Cygwin, WinSCP.

• Contributing to Data Modeling refinements

• Experience in DW technology such as Hadoop, PDW, HQL, SQL Server.

• Write test cases and perform quality analysis on completed codes.

• Write store procedures for history loads.

• Develop, implement, and optimize stored procedures and functions using T-SQL.

• Other tools used include Hive, Ambari and Hue.

• Create staging tables in Hadoop.

• Create PolyBase tables

FOCUS INFOTEK-Ameriprise Financial

January 2018 –November 2018: BUSINESS INTELLIGENCE DEVELOPER(ETL), TRACY, CA

• Designing and delivering Azure Data Analytics solutions.

• Experience in automation solutions using Azure Resource Manager, PowerShell

• Proficiency in Windows and Azure Active Directory technologies.

• Design and develop SQL procedures, views, functions, and triggers to fetch data from different tables by using joins.

• Experience with Azure apps / services development and deployments.

• Contributing to ETL/ELT approach-based data integration using Syncsort DMX-h, SSIS and C#

• Programming Languages SQL, PL/SQL, Shell Scripting

• Build automated ETL processes in SQL Server Integration Services (SSIS) using Visual Studio 2017, test and implement for applications.

• Perform ETL tasks and load data from various data sources like SQL Server, Excel, XML, Microsoft Access sources etc.

• Developed automated packages to fetch data files from FTP servers and load them into tables.

• Create recursive jobs in SQL Server Agent to run multiple SSIS packages, SQL procedures and scripts.

• Create reports using Power BI.

• Created Data driven Tabular, Drill-down, Charts, Parameterized, Linked, Aggregate reports using SSRS Report Builder.

• Designed and generated OLAP cubes. Built reports, dashboards, and scorecards on OLAP cubes.

• Modified and maintained cube Dimensions, Hierarchies and adding Aggregations to Cube.

• Used Power BI in creating visualized analysis as needed.

• Analyze existing SQL queries for performance improvements.

FOCUS INFOTEK-St. Jude children's research Hospital

July 2016 to December 2017: BUSINESS INTELLIGENCE DEVELOPER(ETL), MEMPHIS, TN

• Develop, implement, and optimize stored procedures and functions using T-SQL.

• Generated OLAP Cubes for analytical purposes using SSAS.

• Build Data Models in Power Designer

• Responsible for Data Modeling based on the client requirements, daily maintenance, and performance tuning.

• Designed and Developed OLAP Cubes and dimensional models using SSAS.

• Analyze existing SQL queries for performance improvements.

• Production support, ad hoc queries meeting requirements from other development teams in a test-driven agile development environment.

• Worked with Azure Cloud Databases

• Created Diagrams in Power Designer

• Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter.

• Explored data in a variety of ways and across multiple visualizations using Power BI.

• Design and implementation of SSIS/ETL process for the system.

• Secured Tableau Server by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.

• Experience in creating extracts in Tableau from various source files including flat files, excel sheets, access files and different databases.

• Extracted the data tables using custom generated queries from Excel files, Access/ SQL database and providing extracted data as an input to Tableau.

• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.

• Create reports using Power Bi.

• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles. Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

• Using Informatica Power Center for extraction, transformation, and load (ETL) of data in the data warehouse.

• Using Informatica Power Centre tools developed workflows using task developer, worklets designer, and workflow designer in workflow manager and monitored the results using workflow monitor.

• Copy, transfer, and transfer files and create file transfer processes using Unix.

• ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 9.x

• Designed and developed different types of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, drill down reports using SSRS.

• Responsible for Deployment of the report-to-report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.

• Optimized stored procedure results which contains the complex code of JOINS, various kinds of user defined functions, VIEWS, SYNONYMS, Sub-queries etc.,

• Create extensive visualized analysis using Power BI.

• Developed data mapping documents based on STTM conversion rules for data migration.

FOCUS INFOTEK-United Health Group

April 2013 to July 2016: BUSINESS INTELLIGENCE DEVELOPER, NY, NY.

• Developed Power BI reports and dashboards from multiple data sources using data blending.

• Worked on the Power BI reports and dashboards with SQL Server /Tableau SSAS sources.

• SQL Development, ability to write and troubleshoot SQL code and design stored procedures, functions, tables, and views using SQL Server.

• Experience on Power BI (Desktop and Service) along with SSAS Tabular Model and DAX

• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using SSRS.

• Design star schemas.

• Generated Parameterized Reports and cascaded Parameterized Reports.

• In-Depth knowledge of SDLC, understanding of various phases like Requirements, Analysis, Design, Development, Testing.

EDUCATION: DEVRY UNIVERSITY BACHELOR’S DEGREE IN ENGINEERING

Contact this candidate