Data Analyst Sql Server

*+ years of Data Analyst experience.

Experience using MS Excel, SQL and/or other applications to perform various types of analysis.

Skilled in Microsoft Access, PowerPoint, SQL Server and various RDBMS.

Installation, testing, configuration, maintenance, and troubleshooting of all SQL Server components.

Experience with BI tools such as Tableau and PowerBI.

Proficient in Data Analysis, System Analysis, Business Requirement Gathering and Data Warehousing concept.

Skilled in writing Business Requirement Documents (BRD), Use Cases, Functional Specifications; well versed with Use Case Diagrams, User stories, Process flow charts and UML modeling tools such as MS Visio.

Expert in Agile Methodology of SDLC for implementing Business projects.

Experience with collaborative tools such as Rational Requisite Pro, Rational Team Concert (RTC), SharePoint, Clarity and JIRA.

Knowledge on Power BI and Tableau to import and analyze data from various sources such as SQL Server.

Create various filters and parameters for reports using Tableau desktop.

Skilled in Microsoft Excel (e.g., formulas, pivot tables, graphing).

Experience in data migration tasks using PL/SQL, SQL Loader.

Experienced in Data Migration, Data Transformation, Data Conversion, and Data loading.

Applications

T-SQL, PL-SQL, Excel, access, Tableau, PowerBI, MicroStrategy, JIRA

Professional Experience

Data Analyst

Kaiser Permanente,

Gaithersburg, Maryland, United States. Nov 2022 to Present

Create and run queries as necessary for project deliverables using SQL

Work closely with the Risk, Team Leads, and stakeholder to come up with a plan to effectively find the

correlation of at-risk enrollment behaviors.

Evaluate data pulled for accuracy and relation to data requests

Support leadership team in explaining and disseminating information to appropriate stakeholders

Develop statistical methods to evaluate and analyze numerical data using computer software, including MS Access, MS Excel, Oracle, SQL and/or other applications, for assigned projects

Develop innovative analytical approaches and predictive modeling techniques for reactive or proactive data analysis, sampling, and study design

Develop trend reports to identify potential program or systematic vulnerabilities

Provide expertise and guidance to unit and corporate staff as required.

Represents and participates in group or committee discussions.

Involve in designing and creating Tables, Views, complex Stored Procedures and Indexes using

T-SQL.

Improve query performance.

Data Profiling for accurate and better reporting and analysis.

Data Analyst

Apple Federal Credit Union,

Tysons Corner, Virginia, United Sates July2017 to Oct 2022

Built SQL queries and dashboards to track loan performance metrics such as delinquency rates, default probability, and repayment timelines. Delivered insights that supported lending strategy, improved risk assessment models, and enhanced decision-making for portfolio management.

Extracted, compiled and tracked data, and analyzed data to generate reports

Participated with troubleshooting, and problem resolution efforts

Performed daily data manipulation using SQL and prepared reports on weekly, monthly, and quarterly basis.

Used Excel functions to generate spreadsheets and pivot tables

Identified, analyze, and interpret trends or patterns in complex data sets

Cleansing and Blending multiple data sources to allow for different views on application data in a single dashboard

Aided team in data collection to be used for Tableau visuals

Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool

Perform data manipulation operations like import/export data from various external file formats using SQL

Generated variety of business reports from SQL server using excel with pivot table and pivot chart

Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality

Checked for invalid/out of range data

Perform data manipulation operations like import/export data from various external file formats using SSIS

Develop, update, and maintain current SQL programs

Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality

Acquire data from primary or secondary data sources and maintain databases/ data systems

Education

Bachelor’s degree in petroleum and Gas processing Engineering

Petroleum Training Institute.

2010

Associate Degree in Chemical Engineering

Federal Polytechnic Bida

2005

Contact this candidate