Data Analyst Resume Laurel, MD - Hire IT People

SUMMARY

Data Analyst with a background in Business systems analysis, and a Bachelor's Degree in Computer Science.
me specialized in data warehouse and business intelligence field.
me am proficient in Python, SQL, data modeling and VBA (Excel/PowerPivot).
Also, me has a passion for data conversion, integration, quality, lineage, and mining.

TECHNICAL SKILLS

Databases: MS - SQL Server ( ), Oracle 10G, MySQL, PostgreSQL, Mongo DB.

Languages: Python, SQL, NoSQL.

Web Development: HTML, CSS, JavaScript.

Data Manipulation & Visualization: pandas, matplotlib, power BI, Tableau.

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Laurel, MD

Responsibilities:

Performed data quality checking using simple MAX, MIN, and AVG analysis to detect data anomalies.
Delivered ad hoc reports using Crystal Reports and Tableau BI tool and standard SQL queries.
CreatedTableauDashboard with Action and parameter for user interaction.
Implemented DynamicSQLfor user customizable queries to be answered by theSQLServer.
DevelopedTableauData extract with multiple complexTableau calculation and LOD Expression.
Performed numerous INNER and OUTER JOINs on related tables, using primary indices and refreshed statistics on joined columns to improve query performance.
Validated data loads to destination withSQLscripts and SSIS packages.
Tested SSIS packages and fixSQLcode issues from test execution usingSQLServer Data Tools.

Business System Analyst

Confidential

Responsibilities:

Liaised with end-users and 3rd party suppliers.
Interfaced with business users to prepare and update Business Process Requirements.
Ensured all artifacts complied with corporate SDLC Policies and guidelines.
Analyzed raw data, drawing conclusions and developing recommendations.
Wrote SQL, PL/SQL scripts to manipulate data for data loads and extracts.
Developed data analytical databases from complex financial source data.