+1-614-***-****

Columbus, OH

adud32@r.postjobfree.com

Abdouramane Sanane

Data Analyst / Data Modeler

Professional Profile

Dynamic and resilient professional with 5+ years of IT experience in the Healthcare,Retail, Financial, and Banking domain. Very passionate about projects and savvy with business requirements; translate them into clear and concise specifications; as well as extract and manipulate data from RDBMS to make cutting-edge and prudent decisions to improve the outlook of the organization. Always ready to unleash the skills and knowledge acquired over the years for the development and progress of the organization. Skill Highlights

• Data Analysis

• Data Architecture

• Data Warehouse

• ERWIN

• Data Quality

• Data Models

• Business Process

• Data Governance

Technical Experience

Business Intelligence

tools

Tableau, MicroStrategy, Excel and PowerPivot, Power BI, SSRS Querying language SQL, PL/SQL, TSQL, PYTHON, SAS

Querying tools SQL Management Studio 2008/2012, SQL Plus, SQL Developer, PL/SQL ETL/Other Tools SSIS, Informatica Power Center 8.6.1/9 SAS Base 9. x, SAS Enterprise Guide, SSIS

(Visual Studio), Erwin Data Modeler, ER Assistant

Databases MS SQL Server 2005/2008/2012, Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2

Operating Systems Win XP, Vista 7, Windows Server 2003, 2008(X32, X64), Unix Cloud Computing Tools Snowflake, AWS, Azure

SDLC Agile (Jira) and Waterfall, Confluence, Smartsheet, PowerPoint

+1-970-***-****

adud32@r.postjobfree.com

Professional https://linkedin.Experience com/mattheweliot Shady Grove Hospital Sept 2020 - Present

Rockville, MD

Data Analyst/Data Modeler

• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.

• Translate Business Requirements to Conceptual and Logical Data Models.

• Designed the data marts in dimensional data modeling using star and snowflake schemas.

• Involved in logical and physical designs and transforms logical models into physical implementations.

• Converted, cleaned, analyzed, organized, and documented large data files

• Designing the Reports as per business requirements and creating the reports using Excel file, SQL Server, and Oracle databases.

• Developed comprehensive and user-friendly databases using SQL queries.

• Provided analytic support to patient quality improvement teams working in different clinical

• Completed ad-hoc projects relating to data investigations, follow-ups on analysis results, or other client requests. Documented tasks in a timely and accurate basis including delineation of tasks, and estimation of effort.

• Cleansed and validated data prior to importing into databases.

• Calculate and analyze claims data for provider incentive and supplemental benefit analysis using Microsoft Excel and SQL.

• Designs and formats data reports (simple to complex) utilizing SQL

• Conducted queries via Partners EHR/EMR system and output in SQL Server database for a Readmission Project.

Dollar General June 2018 - Oct 2020

Atlanta, GA

Data Analyst / Modeler

• Expertise and Vast knowledge of Enterprise Data Warehousing including Data Modeling, Data Architecture, Data Integration (ETL/ELT) and Business Intelligence

• Experienced in Dimensional Data Modeling experience using Data modeling, Relational Data modeling, Erwin, and Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logical data modeling.

• Hands on experience with modeling using ERWIN in both forward and reverse engineering cases.

• Strong exposure in writing simple and complex SQL queries.

• Gathered business requirements, working closely with business users, project leaders, and developers.

• Involved in Data flow analysis, Data modeling, Physical database design, forms design and development, data conversion, performance analysis and tuning.

• Performed data analysis and data profiling using complex SQL on various sources systems and answered complex business questions by providing data to business users.

• Generated ad-hoc SQL queries using joins, database connections, and transformation rules to fetch data from legacy Database and SQL Server database systems.

• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP and OLAP.

• Conduct Design reviews with the business analysts and the developers to create a proof of concept for the reports.

+1-970-***-****

adud32@r.postjobfree.com

Professional https://linkedin.Experience com/mattheweliot Capital One Bank Jan 2017 - May 2018

Maclean, VA

Data Analyst/Data Modeler

• Developed a OLTP system by designing Logical and eventually Physical Data Model from the Conceptual Data Model.

• Extensively used the Agile methodology as the Organization Standard to implement the Data Models.

• Created the best fit Physical Data Model based on discussions with DBAs and ETL developers.

• Created conceptual, logical, and physical data models, data dictionaries, DDL and DML to deploy and load database table structures in support of system requirements.

• Identified required dimensions and Facts using Erwin tool for the Dimensional Model.

• Validated business data objects to ensure the accuracy and completeness of the database.

• Developed and maintained the data dictionaries, Naming Conventions, Standards, and Class Words Standards Document.

• Participated in the requirements gathering process to create solid business and technical requirements focused on data and data transport use cases.

• Designed of data transformation processes and tools that normalize, cleanse, augment, and attribute incoming and outgoing data from multiple sources.

• Updated data model as per the requirement and generate DDL and deploy it using SQL developer.

• Identified the key facts and dimensions necessary to support the business requirements. Education

ESL Credit Classes for master’s degree

College Diploma: 2012 – 2016

Basic English Certificate: 2018 - 2020

Contact this candidate