A highly resourceful, reliable, and detail-oriented data analyst with a vast experience of business intelligence tools backed by knowledge of SQL, T-SQL, Power BI, Tableau, Python, Basic Data Science concepts such as Exploratory Data Analysis and Machine Learning.
Data scientist contractor with a focus on supporting DHS in data management and analysis solutions
Created data collection templates, maintained databases, and utilized analytical tools
Analyzed acquisition data, formulated conclusions, and produced written deliverables
6 years of experience analyzing and interpreting data, creating reports and dashboards. Attended daily standup meetings to discuss the tasks at hand and weekly meetings to present the status of tasks & reports.
Proficient in design and development of various dashboards, reports on Power BI Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc.
Making use of actions and other local and global filters according to the end user requirement.
Extensive experience in Extract, Transfer and Load (ETL) processes using MS SQL Server Integration Services (SSIS) for Data migration and Data Warehousing projects along with good project management skills.
Expertise in designing and developing filter driven interactive Dashboards, trend based KPIs, summary and detail reports featuring parameters, DAX functions, sorting, expressions, drill down and drill through, etc.
Proficient in main Business Intelligence tools such as Tableau and Power BI for creating dynamic dashboards and reports for various business functions.
Effectively used data blending feature in tableau to connect different databases like Oracle, MS SQL Server.
Creating and modifying Business Intelligence analytical reports using Tableau.
Built complex Tableau dashboards with advanced functions to provide insightful analysis, identify growth opportunities, and maximize profits.
Great leadership qualities and excellent communication skills. Can work independently or within a team, self-motivated, determined, optimistic, and willing to learn new technology.
Ability to stay calm in stressful situations and adapt to new surroundings quickly.
Overview
6
6
years of professional experience
Work History
Data Scientist II
Systems Planning And Analysis, Inc
02.2023 - Current
Enhanced data-driven decision making by implementing machine learning models and algorithms.
Optimized business processes for increased efficiency through detailed data analysis and visualization tools.
Developed custom data analytics solutions, leading to improved operational performance and strategic planning.
Collaborated cross-functionally with stakeholders, ensuring alignment on key initiatives and project goals.
Cleaned transformed, and analyzed large datasets to uncover hidden trends and patterns for actionable insights.
Streamlined data collection methods to improve quality control measures and minimize errors in analysis results.
Presented complex findings in a clear, concise manner using visualizations that informed executive decision-making processes.
Mentored junior team members in best practices for data science methodologies, fostering a culture of continuous improvement.
Assisted in managing Jira dashboards to track tasks and projects with the DART team
Experience using ACE for cost estimating and analysis
Translated business requirements into data-driven solutions, providing value-added insights that directly contributed to the organization''s strategic goals.
Data Analyst
Alliance TEK Solutions
07.2020 - 02.2023
Support product success, marketing, and finance teams by translating data into actionable insights using Power Bi Desktop
Upgraded project dashboard for product success team to understand the funding trends and patterns for successful projects that resulted in increase in the number of new projects
Assist with ETL process by using SQL Server Integration Services (SSIS) and review the Source to Target Mapping (STTM) to ensure accurate pipelines design
Created customer deep dive dashboard to understand the customer behavior and buying patterns to assist marketing and product teams with customer retention and attracting new customers
Used Power BI features to build and configure Hierarchical dimensions, Measure, Calculated Columns, KPI, Filters, and Aggregations
Used Python for Data cleaning and Exploratory Data Analysis (EDA) to help KickStarter to understand trends and patterns of creators, backers, and funders
Attended the project review meetings, daily/weekly status meetings and walkthroughs with project managers and leads
Supported management teams with report generation and analysis using reporting and visualization on Power BI
Used Common Table Expressions (CTE), constraints and complex queries to extract data from different servers
MS Tools such as (Excel, Microsoft Word) and google sheets in order to construct report sheets
Data Analyst
Patreon Project
03.2018 - 06.2020
Built and published customized interactive reports and dashboards for Real-time survey feedback data using Tableau
Built complex Tableau dashboards with advanced functions to provide insightful analysis, identify growth opportunities, and maximize profits
Incorporated advanced Tableau functionalities into dashboards including parameters to change dashboard layouts, level of detail calculations, sets, dual axis charts, and dashboard actions
Designed SSIS Packages to transfer data between servers, load data into database on SQL Server environment and deploy the data
Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server
Designed dashboards, reports and stories in Tableau by using sets, groups, parameters, calculated fields, data blending and more; published to Tableau Online
Designed dashboard for finance department to display sales and profit data to better forecast and understand the financial information
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu options and Parameters using Tableau
Good experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Online and setup schedule refreshes
Used Pandas library to clean, manipulate and analyze data
Assisted with data cleaning in Python by using Pandas Library in Jupiter Hub and Google Collab
Skills
SQL, T-SQL & Basic Python
Windows & MacOS
MySQL, SQL Server, Oracle
SQL Developer, SQL Server Management Studio
Pandas using Google Collab
Excel, Microsoft Word, Access, and Power Point
AWS RDS, Azure
Data Exports
Data Visualization
JIRA
SharePoint
ACE
professional affiliation
Delta Sigma Pi Professional Business Fraternity, Philanthropy Chair, Recruitment Chair, 01/2017, Present, Organized events to raise $50,000+ for the National Breast Cancer Awareness Fund (Fall 2019) and $20,000 for the Harrisonburg Fire Department (Spring 2018)