Data Reports

Emmanuel Esombe

*** ******* ***** *****, #**** Mobile: 817-***-****

Arlington, TEXAS Email: ***********@*****.***

Computer Skills

Proficient in Windows, Microsoft Word, Outlook, Fiisview, Mainframe, PowerPoint, Excel (Pivots, V-lookup, Macros)

QUALIFICATIONS

5 years of IT experience in Design, Development and Support of MS SQL Server with Specialization in MS SQL Server 2008R/2012 in Production, Analysis and Presentations

Created list reports, cross tab reports, blank reports and reports with lot of conditional formatting using Report Studio

Developed Detail and Summary reports, Drill through and Drill down reports using SQL Server Reporting Services (SSRS)

Develop queries to retrieve and analyze data from multiple databases. Find tables using Database diagrams in SQL server, establish relationship in multiple tables using Primary and Foreign keys.

Extensively used T-SQL in constructing Stored Procedures, Variables, Tables, User Defined Functions and Views

Created Cross-Tab, Drill-down, and Parameterized Reports using RDL

Deployed and uploaded SSRS reports to SharePoint Server and Report Manager for the end users and involved in enhancements and modifications

PROFESSIONAL EXPERIENCE:

Metroplex nursing /Grand Prairie, TX

Institutional Operations Analyst/ January 2015 to date

Develop queries to retrieve and analyze data from multiple tables in the database. Find tables using Database diagrams in SQL server, establish relationship in multiple tables using Primary and Foreign keys. Perform adhoc analytical request using SQL for internal and external parties. Explain results to QA and Operations managers using templates, graphs, chats, Power points and Pivot charts.

Analyze and interpret data to understand business impact, correlations/discrepancies, explain variance analysis, budget analysis and propose changes and /alternate solutions

Analyze and mine data in the Enterprise Data Warehouse to explain trends that appear on standard reports.

Use tools (Excel and SQL) to analyze, query, sort and manipulate data according to defined business rules and procedures

Compiles data from multiple sources, which may include simple data mining, and enters or imports data into Spreadsheets/ Databases

Variance Analysis: Extract data from multiple sources using SQL, export data to excel using SQL export and import button. Analyze data, explain findings to management. e.g. why a negative variance project should be abandon and a positive variance project should be pursue.

Retrieve and analyze key data elements from data warehouse

Performs analysis of findings and trends using statistical and/or financial analysis, modeling, process documentation, profitability analysis etc.

Work closely with Operations Managers to develop graphs, reports, dashboards and presentations fraud activities, patterns, trends and operational metrics.

Create Weekly, Monthly and quarterly reports for the Operations department.

Collabery School of Data Analytics

Data Analyst/ January 2013 to December 2014

Design, write and maintain SQL queries from multiple data sources to support the business

Interface with LOB and MIS resources to ensure that the reports are accurate and deployed in a timely manner

Identify data process improvements and leverage technology to automate and streamline existing processes.

Produced parameter driven, matrix, sub-reports and integrated report hyperlink functionality to access external applications.

Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports

Implemented multiple grouping into several reports using visibility and toggle options

Administrated and scheduled mailing subscriptions on SSRS reporting server

Analyze data and interpret data to understand business impact, correlations/discrepancies, and to propose changes/alternate solutions

Produced dashboard SSRS Reports under report server projects and publishing SSRS Reports to the reports server.

Created SSRS Data Model projects using Microsoft Visual Studio 2012 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users

Examine and evaluate purpose and content of reports to develop new, or improve existing, format, use and control

Analyze and mine data in the Enterprise Data Warehouse to explain trends that appear on standard reports.

EDUCATION

University of Buea, 2008

Studied Internatioal History

Contact this candidate