| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
EMAIL AVAILABLE / PHONE NUMBER AVAILABLE
Adept Manager. Impeccable work ethic. Self-motivated. Great attitude. Agilist.EDUCATION
TECHNICAL SKILLS MBA, University of Hartford Business School, Connecticut
Master of Science, Petroleum Engineering, University of Southern California (USC) PowerBI, Tableau, Alteryx, SQL Server Data Architect, SQL Server, AWS Redshift Data warehouse,MS Azure Cloud Data Storage, Adobe Analytics Reporting, Access, Excel, SQL Data Warehouse, Data manipulation, Python, PowerBI Dashboards,Data Governance, Quantitative & Qualitative, KPIs. SQL Data Analysis: SQL using SQL Analyzer Or Coginiti Editor Agile Scrum Methodology: JiraETL Data Prep with Alteryx Edureka Certified Tableau DeskTop Associate
PROFESSIONAL EXPERIENCE09/2023 to 03/2024 : Financial Data Analyst Arrowood Consulting Services
Providing Revenue Projection Reports Visualization Dashboards on PowerBI Expense Budgeting Visualization PowerBI Reports for Per Diem /Hotel Expenses for Consultants Common Tableau Expression SqL queries to encapsulate Business Requirements to capture Revenue Trend Expedited the Process for Data ingestion and interactive Dashboard Reporting , reducing the Report rendering time to Stakeholders by 20% as per business Requirements Using Power Query in PowerBI for Data Fields Transformations to make fields consistent to Business Requirement Prior to Reporting
Profit Forecast based on Regression Analysis with Dependent Variables like Expected Sales Growth, New Consultant Hires and Capital Expenditures on Additional Cloud Hardware Importing Data into Excel for Financial Planning and Reporting on Excel / Power BI SQL query to import financial Data from SAP FICO databases into MySQL for Alteryx Transformation s AWS Redshift Data Warehouse Query for importing Card Transactions Data for AP analysis using MySQL Queries Importing Data from different Data sources and Modeling on Excel Power Query for Dynamic Update of Excel Tables and Conditional Formatting in Excel Using Alteryx Transformation Tools like Find and Replace Tool to Clean Customer Data before importing into Excel for AR Revenue Reports. Data Reports / Dashboards for Stakeholders in Management using Frequency/Trend Charts and KPI in PowerBI MS SQL Database Architecture and Relational Modeling On Site and Data Migration to MS SQL on Azure Cloud06/2022 to 06/2023 Snr Data Analyst Lead - Fleetcor Technologies (North American Fuels Div) Engaging Stakeholders including Directors of Digital Marketing, on the process of Customer Data Journey from Lead Source to Client Conversion to Refining Target Audience for Client Acquisition by combining data from Salesforce Lead generation, CSV files and Access on Power BI Power Query - thereby reducing Marketing Lead Generation time by 25% and increasing sales by about $2million per Quater. Preparing Monthly Campaign Starts Revenue and Quarterly Revenue Vs Goal on PowerBi Stacked Bar Charts/ Excel Pivot Tables Power Query Data Relational Modelling in PowerBI while enforcing data governance for Data Upload Using Alteryx Designer select Tool Transformations /Union Tools to Append and Transform Data from Different Data Sources including SQL Azure , csv files , AWS Redshift Data base Preparing Ageing Account Receivable Trends with interactive dashboards including Line Charts with Trends thereby reducing collection from Ageing Account Receivable by 20% Developing SQL Data Queries for Extraction and Computing Metrics on Digital Campaign Performance on
Data Architect for Sales Prospect Data Warehouse. Perform Entity Relationship Diagram Models for Dimensions and Facts for the Prospects /Leads table and using DAX Calculation on PowerBI to Compare Sales by Fleet Cohorts. Extract , Transform , Load Process Models for different Data Sources using Alteryx into the Staging Database and then Production Data warehouse Data Modeling on Power Query before loading Data to Power BI PowerBI Power Query for Data Transformations and Column Data type Consistency Prior to Loading Data
Alteryx Dynamic Input Tool to Merge Data from Multiple Data Sources Prior to Transformation and loading Datawarehouse Managing KPI from Earned Media on PR based on Organic Social Media using Tableau /Excel Charts Analytic Revenue Reports on Leads Conversion to Accounts using Tableau Using Find and Replace Tool in Alteryx for Data Cleaning and enforcing Data Consistency in Fields like Zip codes match using Fuzzy Match Tool on Alterys Year TO Date and Quarterly Sales Revenue Reports on Tableau from Inbound Digital / Direct Marketing Channels Engaging Data Marketing Team with Data Point Enhancement from Various Data Sources to Enhance Market Target on Digital Inbound Sales Channel Using Python Data frames on Alteryx for File Sorting and Data Transformation Prior to loading to Staging Serve Establish Functional and Physical Business Requirements from Stakeholders Prior to Preparing Data Integrity Guideline Prior to Appended Enriched Data to the Sale Force Database Platform using Alteryx INDB tools Developing Analytic Reports on Starts Revenue Comparing Inbound Revenue Channels with Outbound Sales using Excel Pivot Charts and Tableau05/2021 to 05/22 Senior Data Analytics Consultant -Chik-fil-A /Thompson technologies
Atlanta GA Developing SQL queries representing business requirements gathering for data validity /integration into Data Warehouse and Source for Business Analytics Providing Data Analytics Reports on Tableau for COGS (Cost of Goods Sold)trends for Restaurant Inventory by Suppliers, Distributors and Quarterly Business Review Reports on PowerBI reducing quarterly Cost OF Goods Sold by 20% Using Alteryx Tools for Automated Data Transformations and loading to AWS Redshift Data Ware house Creating Dashboards on PowerBI to measure Performance Metrics for Suppliers/ Distributors and Restaurants as created by DAX Calculations on Power BI Power Query Developing Datawarehouse for Monitoring Traceability Metrics Analytics for supply chain management and Measuring Quantitative Performance with PowerBI Systematic DAX Measurements
Data Archiving and retrieval for History Matching and Forecasting the future enables the Business Improve Quality and Transformation needed in the Supply chain to make a positive Impact on the Profitability of Chik-Fil-A QSR (Quick Service Restaurant) Developing automated Alteryx workflows for ETL process, transformation and eventual load into Data Warehouse Updating Alteryx Transformation and Data Prep tools in workflows to identify nonconformity in Data to Business Process Facilitating meeting with Stakeholders including Business , Technical Stewards and Asset Manager on Data Lineage Control process in Compliance with the Data Governance Requirements of the Organization Translating Business Requirements for Upload , Prepping and Load Master Data Files into AWS Redshift tables using SQL Queries Ensuring Data Governance Policies are enshrined by Technical and Business Stewards by Cataloging Pertinent Datasets in Conformity with Business Rules, Policies, Regulations and Security Developing Strategy for ETL Mater Data File Movement with Python Tool on Alteryx Monitoring Warehouse Inventory Feasibility and Reconciliation with third Party Data Provider by Prepping and Scrubbing Data on Alteryx Tools Performing Analytics on Restaurant Profitability and ROI on Menu Input Items with Ontime Menu Input Performance Impact Monitoring using Tableau11/2019 to 12/2020 Senior Business Analyst Data analytics - 03 Cards
Providing Business Analytics Insights in our client s company operations with goal of identifying areas to reduce OPEX Costs and thereby Improve profitability Providing Analytics Reports on PowerBI for Merchant Utilization of E-platform solution Products to be able to assist on Cash Back Programs and Discounts Using SQL Queries to represent Business Requirements and Performing User Acceptance Testing Creating waterfall Charts for Profit Margins and Sales Map Dashboards on Tableau Using Alteryx for Data Consolidation, Mapping and Transformation and then Load to Stage Database Enhancing Business Process Roadmap by interacting with Stake holders to get Business Requirement Documentation to establish effective Use cases for Asset management Reporting Platform Meeting with Development Team to Establish the Product Backlog for Sprint Release Automating Alteryx workflows on Consumer Cashback Datasets to filter Most and underperforming customers Organizing Stakeholder meetings on Data Asset Protection and Regulations for Customer Personal DataIn conformance with Data Governance Guidelines Data Integration from s3 Buckets into MySQL Tables using AWS Pipelines Connecting Tableau Analytics reporting to Excel Data Sets for Dashboard Reports Developing SQL Queries for Data Extract from SQL Server as Per Business Requirements Data Migrating and on boarding into s3 Buckets in AWS Cloud Architecture for Redshift Datawarehouse Data Consolidation and Cleansing as per Business Requirements using Alteryx10/2018 to 04/2019 Senior Business Systems Analyst - The Judge Group
I managed analytical reports used by senior leadership to drive day-to-day and optimize long-term business decisions. Providing Business Use Cases for Updating the MYHR Report Analytics for Optimization on Human Resource Relationship between Employee and Supervisor by Measuring Metrics Like Staff Retention / Turnover, Vacation Time Utilization using Report Rendering Dashboards on PowerBI with the Ultimate Goal of enabling Senior Management make decisions to improve Employee Performance Facilitating Data Loads, Consolidation and Mapping Using SQL Server SSIS Providing Business Requirement Documentation for User Views and Navigation based on Talent Hierarchy Application for PowerBI Dashboard Reports. Data Integration from s3 Bucket into Redshift Data Warehouse using AWS Pipeline Services Made Systematic Calculations on Power BI Data Analysis Expressions Using In-DB Tools in Alteryx to Consolidate and Validate Data on Workflows from different Data Sources prior to output in Stage Database Ensuring Data Standards are my for-Privacy Requirements on New Hire Interview Process and Credit
Validation Metrix using third Party Tool and PowerBI KPI Score cards on Employee Retention Updating Business Requirement Documents with Clarifications based on input from Developers on the MyTime GP Application and Grooming Backlog Stories in Conformity with Accepted Clarifications by User Providing Business Process Roadmap in Estimating Tableau board Metrics (Calculated Fields) for Measures like Number of Days in Response Time from Supervisors for Employee Request to change Timecard Edits, Meal Break Exceptions e.tc with the Ultimate Goal of Improving behavioral relationship between Employees and Supervisors Establishing Requirements for SQL Queries and Stored Procedures Using Alteryx for Data Load to AWS Platform S3 Buckets and Other Data Formats for Human Resource Report Analytics on Tableaux
Forecasting Models on Tableau for future Resource Hires and Retention Ratio
Providing Trend Reports and Forecast reports for Talent Hire and retention using Tableau Charts 06/2018 to 10/2018 Senior Data Analytics
- Equifax / Robert Half, Atlanta, GA
For Equifax, a credit monitoring/financial agency with multiple data asset channels, I managed reporting and analytics to improve the data governance program with streamlined process and system automation. Monitoring Completed Data Ask Reviews for Enterprise Data Council on archer PMO Platform Data Assets Sales Forecast Dashboard on Power BI Request Processing Tool and Using them in Sprint meetings, Providing Back log Burn Rate and Other Business Trend Metrics using PowerBI Reports Using Alteryx In-DB tool to Migrate Data from different sources to be stored on the PMO Platform Application Ensuring Data Governance by Validating Privacy Requirements are Followed for DATA ASKs by Consulting with SMES Providing Business Workflows for Data Access while ensuring GDPR (General Data Protection Act) with regards to Consumer Data Privacy Ensuring Metadata of Master Database Supporting the ASK Data Project Monitoring Software is Stable and Effective for Data Transfer while ensuring Privacy and Regulatory requirements are met Monitored Completed Data Ask Reviews for Enterprise Data Council using Transformations on Power BI Power Query Performed UI Business process modelling and mapping for New Version AskData application Performed Requirements Gathering from SME (Subject Matter Experts) in Privacy, Compliance and Security ARMS of Enterprise Data Governance , Consolidating from Various Data Formats using Alteryx and Storing Data in SQL Server
Used Power BI to Provide Chart Visualization on Performance Metris Like Data Requests Turnover, Data Asset Revenue e.tc. UML Business Processing for Customer Value on New Data Request App on third Party Applications Provide Report Dash board from Big Data Lakes on AWS Redshift using PowerBI KPI monitoring of Business Units from PowerBI Dashboard Reports using Score Chart Visualizations Consolidation and Power Query Transformation of Measures (Count of Asks, Asset Value) which are then pulled in Power BI Plat form for Rendering as Bar Charts of Number of Data Request by Units e.tc Provided Alignment in User Stories from Customer Requests with Acceptance Criteria to effectively Communicated with SCRUM team and Program Manager by effectively grooming Story Backlogs and committing to releasable product increment with Development team within the Sprint timeframe Participated in backlog remediation sessions during Scrum Sprints to refine user stories Data Consolidation and modeling from Various Data Sources including SQL Server, Excel and Access Database Using Alteryx, indexing SQL queries for better Data Retrieval, Data transfer from SQL, Access and Excel into Central Tableau analytic Reporting Platform Created Indexed Views, Stored Procedures and Functions Facilitated effective development Process for Optimum return on Investment for Customer and Product Sponsor Requests by interacting in Sprint Review with Program Managers and other stakeholders to ensure the goals are attained for each Iteration of Sprint Agile Project Management on Development of Custom Application (AskData) on Archer Application that builds on common USE CASES which require Business Requirements on Requests for Data Assets of Equifax by ensuring they Comply with Privacy, Legal , Security and General Data Governance Regulations
Used JIRA as Project Management Tool to Prioritize User Stories on Scope for Intended Sprint and also Managed the Workflow from ToDo Tasks to Done for a Particular Release in Application Increment for Automation of Data Ask Requests from Users and Approval by Data Advisors 06/2016 to 05/2018 Senior Business Data Analyst -Knights & Associates, Atlanta, GA
For this company that provides concrete embankments for side works and other related construction, I developed reports, gathered requirements and performed in-depth analytics utilizing Tableau and writing & running SQL complex queries. Created Dashboards on Power BI based on SQL Server Data Warehouses having Consolidated Data Created Queries in MS Access based on Business requirements for Reporting on PowerBI Dashboards Designed Data Visualization of Pie Charts of Vendors By Region, Budgeted Expense Vas Real Expense on Bar and Pie Charts on Tableau SQL Datamart for Data Source on Profitability Contribution Charts using Tableau. Performing Left Outer Joins on data sources to provide Sales Water Fall Charts on Tableau Providing Stacked Bar and Pie charts on Regional Sales Compared to Products we Provide Consolidation and Query of Data Sources on Power Query, then Rendering Reports on PowerBI Performed VLOOKUPS, FUNCTIONS, PIVOTABLE and PIVOT QUERY in Excel for Data Analysis, Modelling and Slicing Planned Development team Capacity and Velocity for Projects during Scrum meeting Perform Table Indexing to Archive Old data and Improve Performance Liaison between various Stakeholders of the Business and the Applications Development Team Developed Business Requirement Documentation on SDLC for Inventory Monitoring App Data Consolidation, Cleaning and Loading to Stage Tables from Various Data Sources including Text Files, Access, Excel Files and other SQL Servers using SQL SSIS, Alteryx Ensured ROI on Established Sprint Planned events using the Agile Methodology Communicated and Collaborated Clearly with Peers in both Business Functions and Technical Area to deliver Effective Applications in Line with Corporate Objectives Configured SSRS Reporting Services to Pull Data from Indexed Views Created Use-Case on Business Requirements as it creates value to end user or System |
