Data Analyst Resume Baltimore, MD - Hire IT People

SUMMARY:

I am an IT professional with 12+ years of SQL Server and Microsoft Business Intelligence Experience.
Currently, I am working as a Data Analyst with a focus on Enterprise Reporting using Microsoft Excel as well as various Visualization tools such as Tableau, Power BI, Pivot Table, and Python - Matplot & Seaborn.
Additionally, I am an aspiring Data Scientist as I have successfully completed a Career Track Intensive Data Science Course (Six Months).
During this time, I gained competencies in Data Science concepts such as Data Wrangling, (XML, Pandas, and JSON), Database design and development, Data Stories, Inferential Statistics, Machine Learning, Statistical modeling Regression and Correlation.
I have also completed 2 Machine Learning projects where I was able to create predictive models to provide some insight to Business Owners.

SKILL:

Data Analysis, Visualization and Predictive modeling: Python, Pandas, Numpy, Scikit-Learn, Matplotlib, Seaborn, Tableau, Power-BI, Pivot Table.

Machine Learning Algorithms: Linear Regression, Logistic Regression, K nearest Neighbors, Clustering

SQL SERVER: T-SQL, PL-SQL, Microsoft Business Intelligence, SSIS, SSRS, SSAS

EMPLOYMENT:

Confidential, Baltimore, MD

Data Analyst

Responsibilities:

Responsible for creating, analyzing and cleaning data for analytical reports using Microsoft BI tools.
Obtained vast knowledge on Medicare & Medicaid business rules which assisted me in creating several SSIS packages.
Managed the scheduled upload of the reports output to client FTP server. Scheduled these packages either for daily, weekly or monthly run.
Responsible for monitoring, tracking, and fixing as they were detected.
Created required KPIs in the Cube

Confidential, Baltimore, MD

Senior SQL Developer

Responsibilities:

Created complicated Stored Procedure & Function in SQL.
Defined advanced attribute and dimensions properties. Created dimensions and defining hierarchies. Changed the properties of the dimension attributes, formatting as required.
Create Attributes & Facts using MicroStrategy 10.1 Developer tool.
Partitioned the cube appropriately and also setup proper storage for performance improvement.

Confidential, Richmond, VA

Senior SQL Developer

Responsibilities:

Create Stored Procedures and Tabular functions in TSQL for the reports. Tabular functions so that we can use multi select parameters for the reports in Stored Procedure.
Created SSIS package to load data from source to target and also logging source and target table’s details.
Created Snowflake schema of the dimension and the fact tables.
Performed regression and functional testing.

Confidential, Baltimore, MD

SQL Developer

Responsibilities:

Wrote TSQL/PLSQL queries for complicated reports based on the client requirements.
Created Charts and matrix reports in SSRS on top of the above queries.
Shown users the features of drill down and drill through reports and other advanced features of SSRS so that their old reports can be organized better and exporting into excel will definitely improve the report analysis ability.