DBA/Report Analyst SQL Server Resume Glenrock, PA - Hire IT People

SUMMARY

Having more than 12+ years of experience in working as a Report writer and Business Analyst on multiple platforms.
Experience in large relational databases, Data warehousing and strong understanding of design, development, data mining, Data Modeling and structured schema.
Experience creating reports which combine data from multiple data sources and knowledge of standard business concepts and practices.
Proficient in SQL Server 2008 R2, Tableau, Qlik View, SSRS, SSIS, oracle reports, Discoverer desktop, Discoverer Administrator reports, Crystal Report Write.
Experience designing creating, implementing, modifying, maintaining and supporting existing reports.
Ability to successfully collaborate with subject matter experts to help define new reporting requirements.
Experience reviewing and optimizing current reporting solutions and developing T - SQL procedures, packages and functions to cater the end user requirements.
Has experience in SQL development using Management Studio and Proficient in complex queries, stored Procedures, Functions, ETL Package, Oracle Package.
Having certification in Epic Clarity and Ambulatory Data Model track.
Sole responsible for developing, maintaining and delivering Meaningful Use Reports before Epic.
Communicate with clinical/non-clinical staff to further understand needs and relay status updates related to their request.
Ability to communicate effectively (both orally and written) with other report writer analysts, epic team analysts end users and managers.

TECHNICAL SKILLS

Oracle
PL/SQL
Qlik View- Data Modeling
Design Dashboard
Development
Tableau - Design & Development
Data Modeling
SQL Server 2008- SSRS SSIS
SSAS
Crystal Report Writer- V-13

PROFESSIONAL EXPERIENCE

Confidential, Glenrock, PA

DBA/Report Analyst SQL Server

Responsibilities:

Performed system analysis and application support for Great planes database.
Responded to and resolved database access and performance issues.
Defined the current reporting activities for the development of existing and future reporting procedures and models by charting existing process.
Researched, reviewed and analyzed the effectiveness and efficiency of existing report procedures and developed strategies for enhancing and further leveraging of processes.
Development of SSIS Package for moving all reports from production server to the data warehouse server which included moving all tables, procedures, functions and views that reports are based on and pointing all reports to run from data warehouse server and designed a process flow to nightly refresh data for last thirty days in all tables.
Implemented a daily table update in data warehouse through SSIS Package to ensure that the reports were running off of the current data with the time lag of one day.

Confidential, Baltimore, MD

Business Analyst/Report Writer

Responsibilities:

Primarily responsible for ad hoc report writing based on Claims and Recovery analysis.
Familiarity with the Process Flow and basic knowledge of oracle apps.
Supported needs of our internal/external clients.
Supported utilization medical claim management and claims payment accuracy.
Acquired a good understanding of healthcare database systems and an in depth knowledge of medical claims and recovery data.
Created and generated daily and weekly ad hoc specialized reports as requested.
Provided analysis to determine if the reports were meeting the company’s current and future requirements.
Delivered in house business analysis on claims data and ad hoc query support to internal users.
Provided support to user community is answering questions and resolutions of problems related to the claims adjudication system and internal process.
Reviewed, evaluated, designed, and implemented process to ensure data integrity is maintained.
Assessed reporting results through data investigation, analysis and evaluation.
Analyzed data and trends and created documentation supporting all of the reports.
Ensured that reports support the overall scope of company’s business strategies.
Maintained data integrity and ongoing quality control of delivered reports
Worked closely with all levels of end users, including executive level of staff, to quickly develop reports, which were used to make strategic business decisions.
Created detailed documentation outlining report criteria and provided recommendations to the requestor based on the results of the report.
Gained knowledge of claims processing procedures and claims payment.

We provide IT Staff Augmentation Services!

Dba/report Analyst Sql Server Resume

Glenrock, PA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship