Cell: 301-***-****

adxqvy@r.postjobfree.com

PROFESSIONAL PROFILE

Dynamic technology professional with more than five (5) years of extensive technical background in DB applications, Data Analysis, ETL Development, Data modeling and warehousing and Systems Administration. Strong knowledge of Oracle/SQL Server Architecture, schemas, and Transaction management. Knowledgeable in the domain of relational databases and Business Intelligence models.

SKILLS AND ACCOMPLISHMENTS

Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.

Experience in Data Analysis and ETL techniques for loading enormous amounts of data.

Experience with DATA MINING.

Troubleshooting Complex queries from several data sources.

Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).

Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.

Strong ability to write SQL queries using PROC SQL.

Excellent knowledge and usage of reporting tools such as Tableau, Power BI.

Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).

Possess a strong ability to adapt and learn new technologies and new business lines rapidly.

Good knowledge of portfolio analysis, management, and customer segmentation.

Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.

Exceptional organizational and time management skills and the ability to work independently.

Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

Knowledgeable on the usage of Multidimensional Expressions (MDX) querying language to define KPIs for reporting requirements in Power BI

Strong Technical Knowledge of Power BI Reporting Platform

Working knowledge of A/B Testing experiment design

TECHNICAL SKILLS

Databases

MS SQL Server 2005/2008/2012, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g

ETL/Other Tools

SSIS (Visual Studio), Erwin Data Modeler

Querying Tools

SQL Management Studio 2008/2012, SQL Plus, SQL Developer

Querying language

SQL, PL/SQL, TSQL

Business Intelligence Tools

Tableau, SSIS, Excel and Power Pivot, SSRS, OBIEE, Power BI

WORK EXPERINCE

Business Support Consultant

Bank of America (Consultant: SwiftLearn IT Solutions, Inc.) June 2020 - Current

Laurel, MD

Data Analyst/Reports Developer

Responsibilities:

Used MDX querying language to define KPIs for Power BI Reporting

Developed Key Business Intelligence Reporting in Power BI

Wrote queries to fetch data from different tables by using JOINs, Sub-queries, Correlated sub-queries and derived tables from SQL Server Management Studio (SSMS).

Work with ETL Process via SSIS to create data pipeline.

Wrote SQL scripts for database manipulation as needed (queries, views, tables, procedures).

Wrote SQL scripts for staging and testing of data views.

Use advanced SQL concepts Group By and aggregate functions

Use complex SQL queries to fetch data from other data sources.

Designed early reporting dashboard using Tableau Reporting Business Intelligence Software

Designed and implemented A/B Testing experiments for User Experience (UX) impact

Laurel Health Center Inc. (Consultant: SwiftLearn IT Solutions, Inc.), May 2018 – June 2020

Laurel, MD

Data Analyst / Power BI Developer

Responsibilities:

Created Power BI scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, and Gantt charts to display Key-Performance-Indicators (KPIs) for business decision making.

Hands on experience to extract, manipulate and built complex formulas in Tableau for various business calculations.

Utilized data visualization suites to provide a user-friendly experience and drive data-driven business directives through analysis of key themes within customer data

Designing reporting as per client request, and subsequent creation of reporting via Excel file, SQL Server, and Oracle databases.

Created complex reports like Detail Level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries.

Preparation of high-level analysis reports with Excel

Utilized Excel, and other software, to provide ad hoc reporting, tables and listings and graphs for clinical trials data, regulatory submissions, Risk Based Monitoring, and publications

Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SQL.

Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.

Involved in resolving reporting issues and design issues throughout the reporting life cycle.

Designed and implemented A/B Testing experiments for User Experience (UX) impact

MC Auto parts Co. (Consultant: SwiftLearn IT Solutions, Inc.), February 2017 – May 2018

Baltimore MD.

Senior BI/ Data Analyst

Responsibilities:

Developed dashboards in Tableau Desktop and published them in Tableau Server

Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated sub-queries and derived tables on SQL Server platform.

Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables. · Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).

Created numerous permanent tables, Volatile tables and Global Temporary tables.

Used Excel Pivot tables to create Ad-hoc reporting using requiring drill-down capabilities on data tables.

Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2014 Reports Services (SSRS) Educational Experience Smith

Fulfilled numerous data requests for financial profiling.

-

Contact this candidate