Data Analyst Reporting

Ethel Lache

**** ****** **** ** *********, TX ***11 *****.*****@*****.***. 682-***-****

OBJECTIVE

Seeking a challenging Business and Data Management Analyst role where I can fully utilize my experience and knowledge to contribute towards the overall growth of the organization. PROFESSIONAL SUMMARY

4+ years’ experience in development and support of technologies and platforms with specialization in MS SQL server 2008/2008 R2/2012 in production, analysis and presentation.

Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Experience in Creating Tables, Views, Triggers, Index, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.

Developed Detail and Summary reports, Drill through and Drill down and parameterized reports using SQL Server Reporting Services.

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.

Excellent technical and professional client interaction skills. Interacts with Technical, functional and business audiences across different phases of the project life cycle.

Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to create and deploy new technologies. WORK EXPERIENCE

Cigna Inc.,Plano,TX 2020 -2022

Sr.Data Analyst/Report Developer

Develop and maintain SQL queries from multiple data sources to support the business.

Work closely with the IT Managers to develop graphs, Matrix reports, drilldown, drill through, sub reports, dashboards and presentations for quality activities, patterns or trends and operational metrics.

Modified existing reports in SSRS and Excel using charts, graphs, tables and matrices.

Use SQL to analyze, query, sort and manipulate data according to defined business rules and procedures.

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

Responds to requests for specific, customized reports.

Wrote SQL queries using joins, stored procedures and user defined functions to verify the data from the database based on the business requirement.

Handled ad Hoc request and create parameterized reports using SQL server 2012 reporting Services

Wrote SQL triggers for checking Insert and Update on particular tables.

Utilized SSRS Reports from different source formats and satisfying clients by representing reports and presentations

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

Customized SQL queries to create RDL Datasets and create SQL reports.

Created Tabular and Matrix Reports with all aggregate functions and expressions

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

Frontline Source Group

Reporting Analyst 2018- 2019

Gather Data, Analyze data, develop and build SSRS reports in Support of the Windows, Storage and Backups.

Designed and implemented stored procedures, views and other application database code objects.

Performed quality testing and assurance for SQL servers.

Worked with stakeholders, developers and production teams across units to identify business needs and solution options.

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

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

Contact this candidate