Mamadou Balde

Phone: 973-***-****

E-mail: adhybv@r.postjobfree.com

BACKGROUND SUMMARY

•Over 9 years of real time experience in Data Modeling, Data Mart development & maintenance of Data Warehouse which includes ETL, OLAP Cubes, applying Data Mining algorithms, writing Transact SQL, and designing SSRS Reports.

•Hands on experience in creating end to end ETL strategies that will include data profiling as well as Extracting, transforming, Conforming and Loading data warehouse/data marts for reporting purpose.

•Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate, Script, and Derived Column Transformation.

•Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Event Handlers, Breakpoints, and loggings (SSIS or Custom loggings) and Securing Packages.

•Expertise in developing and maintaining Relational and Multidimensional Database Schemas.

•Worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflakes Schema

•Good SQL Server Administration skills including Backup, Recovery, Database Maintenance, User Authorizations database, tables, and indexes creation.

•Experience in performing Integrity Checks, troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace Statistics and Index Tuning Wizard.

•Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

•Very good experience on RDBMS Concepts, writing Stored Procedures, Views, Triggers, Functions and extensive usage of SQL commands.

•Expertise in Front and Back End Web Development.

•Good understanding of Object-Oriented Programming Concepts, Client/Server Architecture, Online and offline processors.

•Strong technical and intra-personnel skills.

•Real time experience working directly with the clients from requirement gathering to implementation of custom data warehouse suite.

•Very good experience in Analyzing Business & System Requirement specifications and involved in designing, and developing the core components of DW Application

•Self-learner team & result oriented and able to work independently as well as in team.

•Proactive in interacting and collaborating with Business Analysts, Technical Analysts, and other team members to identify and understand the appropriate business requirements and providing solutions.

•Accommodate 100% of travel if needed.

EDUCATION AND PROFESSIONAL TRAINING

05/2007

Master of Science in Computer Science

Pace University New York, New York

05/2005

B.S., Computer Science

SUNY Fredonia Fredonia, New York

05/2005

B.S., Business Administration

SUNY Fredonia Fredonia, New York

05/2005

12/2012

12/2012

12/2012

10/2012

B.A., Economics

SUNY Fredonia Fredonia, New York

BOW320 – Web Intelligence: Advance Report Design

BOU310 – Universe Design XI 3.0/3.1: Universe

BOU320 – Universe Design XI 3.0/3.1: Advance

SPSS – Intro to IBM SPSS Modular and Data Mining

TECHNICAL SUMMARY

System Software and Applications:

ETL: SQL Server Integration Service (SSIS), Embarcadero

Data Mining: SQL Serve Analysis Services (SSAS), IBM SPSS Modeler

Reporting: SQL Server Reporting Service (SSRS), Business Object (BO)

Data Visualization: Power BI

Operating System: Windows 98/2000/ XP/Vista/7/8/10, Window server 2003/2008/2012 Linux, UNIX.

Others: Visual Studio, MS Office

Programming Languages: C, C++, C#, Java, VB, VBA, Perl, and PHP

Database Management: Microsoft SQL Server 2014/2012/2008/ 2005 /2000, Oracle 8i/9i/10i, MySQL, MS Access, T-SQL/PLSQL.

Web Programming: Bootstrap, JavaScript, VBScript, ASP, JSP, HTML, DHTML, CSS, and XML.

Internet Tools: Share Point, Office MS-Front Page, Macromedia 6(Flash, Fireworks, Dreamweaver), Internet Information Server (IIS), CSS, FTP, TCP/IP, LAN, VPN, Remote Desktop Access, NetMeeting, MS-Outlook.

EXPERIENCE

Kaiser Permanente Oakland, CA

PkGlobal Senior Consultant Data Engineer Feb 2020-March2020

Enterprise Data and Application Integration Projects

Responsibilities included:

•Provide senior technical consulting with deep expertise in Data Architecture and Integration through the delivery of Data Integration related solutions.

•Creation and implementation of conceptual and physical database models, applying best practice design principles for modeling both relational and dimensional databases, along with supporting staging structures using DDL statements and database modeling tools.

•Creation and implementation of ETL architecture, data flow diagrams, source to target mappings, and solution designs applying best practices for populating relational and dimensional data structures.

•Implementation of ETL designs, using ETL tools and native database programming in stored procedures.

•Capture of client requirements and creation of these requirements into data architecture and data integration solution design, plans, and statements of work.

•Managing and meeting delivery milestones

•Providing expert technical advice and guidance to project team members, client stakeholders, and staff.

Beam Living Revantage Corporate Service New York, New York

Collabera Senior Consultant MS SQL/SSIS Developer Oct 2018-July 2019

Enterprise Data and Application Integration Projects

Responsibilities included:

•Development, maintenance and support of vendor integrations including but not limited to Property Management (MRI), Financial (Workday), CRM (Dynamics 365) and Enterprise Data Warehouse (EDW) systems.

•Technical Issue resolution

•Adherence to industry standards and best practices for ETL Development, Data Quality and Data Governance

•Incremental load with use of SSIS, Temporal Table and Redgate Compare

•Used T-SQL to create : Stored procedures, Triggers, Views, Functions

•Development, Execution and recording of Unit testing and rest results

•Adherence to the RCS CHEF methodology

South Carolina Department of Revenue, Columbia, South Carolina

Revenue Premier Data Warehouse

Msys Senior Consultant Data\Information Architect Sep 2015- Oct 2017

Department of Revenue Employee Senior Applications Analyst Jun 2012-June 2014

Revenue Solution, Inc Consultant Senior Applications Analyst Sep 2010-May 2012

The South Carolina Department of Revenue (SCDOR) has implemented a Data Warehouse and related software components for purposes of tax revenue compliance and analysis. The Data Warehouse also serves as a primary data source for other business intelligence activities. This work involves proprietary software from Revenue Solutions Inc. (RSI), particularly their Portfolio Warehouse (PW) product.

Responsibilities included:

•Gathering Business Requirements directly from business users

•Analyzing and documenting different system flows, process flows and work flow

•Participate and/or facilitate production assurance testing and end user acceptance testing

•Assist in implementation and production support activities

•Architect complex solutions manage development and collaborate with testing teams

•Support technology to enable integrated reporting of the Risk landscape

•Persuade and influence stakeholders in other areas and occasional external parties through developed communication and negotiation skills

•Provide in-depth and sophisticated analysis with interpretive thinking to define problems and develop innovative solutions.

•Building ETLs using SSIS packages to load data from various data sources including data from internal and external sources.

•Converting all Embarcadero legacy ETLs to SSIS packages. Historically, the Data Warehouse team has used the proprietary ETL tool Embarcadero DT/Studio tool.

•Used various Package Configurations available for SSIS Packages like XML files and SQL Server Tables.

•Implemented the Master Child Package Technique to manage Big ETL (SSIS) Project efficiently.

•Automated the ETL process by scheduling SSIS package job execution.

•Developed multiple SSIS C sharp shared functions that I deployed in the global assembly Cache (GAC) to be executed by any SSIS script task transformer. For example: convert signed money, name parse...etc.

•Created SSAS cubes to facilitate the reporting of the business based on historical and current data.

•Created cubes based on the reporting and application requirement of the business users.

•Creating deployment methodology concepts including design, build, testing, and deployment.

•Full development life cycle around real-time integration with SSIS, SSAS, SSRS and SQL Server.

•Changed daily Refresh Java code to execute and check the status of SSIS packages (instead of embarcadero).

•Create and Document Logical Data Integration (ETL) Strategies for Data Flows between disparate Source/ Target Systems and the Enterprise Data Warehouse.

•Created Parameter-drive Reports using parameters tab in the SSRS GUI procedures by setting up the report-level parameters, along with Building parameter-driven queries and stored and placing them in the data field

•Created ad-hoc reports using power pivot and performance point extracting data from heterogeneous sources.

•Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports, identifying and adding the report parameters.

•Experience weighing the tradeoffs between bulk inserts and single updates in database and ETL processes for speed optimization.

•Performed a variety of Data Analysis, Data Modeling and Data Administration tasks with limited supervision.

•Interacted with business users to plan, develop, improve, and maintain complex components of the Logical/ Physical Enterprise Data Warehouse and related Models.

•Maintained and Administered Meta-Data Repository.

•Conducted quality assurance for loaded data.

•Created and executed Views, Triggers, Stored procedures, functions as required.

•Established, Maintained and Adhered to Enterprise Data Modeling and Data Integration Standards.

•Worked closely with users to understand and help develop functional specifications.

•Setting up and running the proprietary Portfolio Warehouse Associate and Grow (A&G) offline process. This includes configuring the A&G match keys with consultation from the business users and SCDOR Data Warehouse team.

•Developed and presented training materials as needed to clarify model meaning and usage.

•Provided functional advice or training and served as a mentor to less experienced Data Warehouse Analysts.

Georgia Department of Revenue, Atlanta, GA Jun 2008-Sep 2010

Discover Tax Data Warehouse

Revenue Solution, Inc Consultant Application Analyst

Revenue Solutions, Inc. (RSI) helps government agencies meet their business objectives of streamlining operations, improving customer service, maximizing collections and increasing tax compliance using enabling information technologies. The Discover Tax project at the Georgia DOR involves an implementation of a data warehouse foundation to support Business Intelligence initiatives across operations, policy, and enforcement and management functions, thereby increasing tax compliance and reducing the "tax gap." This process also involves an application of statistical techniques against taxpayer-based data, which, in turn, derive probabilities and allow agencies to make better decisions.

Responsibilities included:

•Developed, tested, migrated, and implemented various Extract Transform and Load of data tasks processes using SSIS

•Optimizes packages by avoiding use of non-blocking transformation, executing tasks in parallel and optimizing code at source

•Responsible for data analysis, data designing, data mapping, data quality business and Minimum Data requirement (MDR) gathering, Technical Specification writing.

•Redesigned and developed data warehouse refresh process.

•Developed a comprehensive unit and system testing plans for data in the warehouse.

•Reviewed and tested the work products produced by either clients or RSI team members and provided feedback/comments on any data quality issues.

•Analyzed complex problems and, either independently or working with others, developed elegant and practical solutions. Made sound decisions and used good judgment.

•Be open to new concepts and incorporate these ideas to improve the solution.

•Effectively identified and used best practices.

•Identified potential issues and brought them to management's attention appropriately and followed through with issue tracking and resolution.

•Analyzed development and installation of IT systems including documenting system requirements, preparing technical program specifications, and writing user manuals.

•Completed the compliance program, including the Functional Design Specifications, Test Results, and implemented Production Solution deliverables.

Bank of New York, New York, NY Mars 2008-April 2008

Customer Account Project

Asset Financial Staffing Consultant SQL developer

The Bank of New York Mellon is a leading asset management and securities services company, uniquely focused to help clients manage and move their financial assets and succeed in the rapidly changing global marketplace.

Responsibilities included:

•Create ER diagram and performed normalization on them to ensure faster querying

•Developed ad hoc reports for tax consultants.

•Used DTS to extract and transform and load data coming from excel and the mainframe to the SQL server database.

•Scheduled dashboard to run after loading tax exposed account.

•Optimized database by using SQL profiler and the SQL indexing wizard

•Wrote Views that helped see transactions in a filtered way

•Developed Stored procedures that calculated total cash depending on tax and interest rate

•Developed database objects such as Stored Procedures, User Defined Functions, Tables, Triggers, and Indexes using Transact- SQL, SQL Analyzer and Enterprise Manager.

•Used SQL profiler trace to determine tuning performance of Stored Procedures, Triggers and Views and User Defined Functions.

• Used SQL wizard index to determine the best way to index a table for fast query performance.

Contact this candidate