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.
-