Clovis Assi

I am an experienced data/business analyst with about eight years of experience in the health and retail industries respectively. I am competent in database designing (Relational & Dimensional), requirement gathering, data visualization with a deep knowledge in conceptual and logical modeling. Expertise in providing database development services, with expertise for full-life cycle application development including data access and management, dynamic querying, reporting and maintenance functions and provide SQL Server skills to manage and analyze data and creating data extracts and reporting tables.

Solid understanding of database management systems and working knowledge on SQL server 2008, Microsoft Access databases, and Excel Spreadsheet. Performing various functions such as processing data, creating reports, analyzing metrics, implementing verification procedures, and fulfilling client requests for information using MS Excel, Word, Access, and Power Point. Demonstrated ability to prioritize tasks and meet datelines for projects.

Reporting Analyst/Data Analyst - MedStar Washington hospital center - Washington DC

(2017-04)

• Gathers and integrate data from disparate sources
• Execute ad-hoc queries against relational databases to extract data
• Performs quality checks and write sql codes to perform fixes
• Prepares monthly and quarterly reports in excel using complex excel formulas
• Develops interactive dashboards in excel and present to higher level managements, making recommendations where necessary
• Collaborate with management and internal teams to implement and evaluate improvements
• Supports ETL projects by performing data profiling

Sr. Data Reporting Analyst - Customized Data Analytics, @ Costco Wholesale - Baton Rouge, Louisiana

(2012-08 - 2017-03)

• Fulfilled ad-hoc requirements by executing complex SQL queries to extract data from multiple tables
• Performed data quality checks/profiling and perform fixes/cleansing (duplicates, nulls, spelling errors and datatype issues) at both the database level and excel level
• Developed dashboards on Tableau based on requirements
• Presenting data using live connection and blending data on tableau sever
• Utilized SQL to analyze and create reports in Excel to report to management
• Optimized database performance by creating indexes and views
• Acted as a mediator between the technical and the non-technical staff

Reporting Analyst /Data Analyst - Customized Data Analytics, @ Sears Department store - Chicago, Illinois

(2011-01 - 2012-05)

• Gathered requirements for a database modification project
• Extracted data using complex SQL for further analysis
• Involved in executing and testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively
• Based on existing Key performance indicators(KPI) I developed metrics and thresholds to monitor performance
• Developed weekly and quarterly reports using complex excel functionalities
• Supported the design of conceptual and logical models for a target database structure
• Researched multiple tools that could support additional data processing

Bachelor of Science - University of Louisiana at Lafayette (2016-12)

MSC - Data Analytics - University of Maryland University College