$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Data Analyst with expert Excel
Asadullah Choudhury
,
London, United Kingdom
Experience
Other titles
Skills
I'm offering
An extremely talented Data Analyst with sound knowledge of mathematical applications including calculus, statistical testing including regression analysis, factor analysis and ANOVA for data analysis. Currently employed as a Data Analyst maintaining and analysing membership data for a trade union with over 145,000 members. Creative problem solver, with the ability to demonstrate exceptional analytical skills, tasked with producing reports and insights directing company strategic decisions.
Markets
United Kingdom
Language
English
Fluently
Ready for
Available
My experience
2018 - ?
job
Data Officer
unknown.
Responsibilities:
MS Excel with VBA - Looking after Prospect's membership system (Sodalitas) which contains over 145,000 members
(Expert) - Pivot - After merger, bringing Bectu trade union's membership data up to Prospect's standards
tables, charts, data - Preparing merging the data for both Prospect and Bectu by comparing, analysing, interrogating both
validation, sets of data
conditional - Managing Data Extracts module in Sodalitas by creating and maintaining reports, and report access
formatting, - Running ad hoc SQL queries via Oracle Server and MS Access where we required more specialised
formulas, and reports
functions, read and - Maintaining and improving the Month End Statistics Reports which are provided to key Heads of write macros Department and SMT
VBA Programming - Logging improvements and issues on Sodalitas, testing and finally completing these changes
(Advanced) - Achievements:
Variables, condition - Moved all BECTU's MS Access based queries on to Sodalitas Data Extract module by gaining access
statements, strings, to the relevant data tables and views available to replicate reports
loops, arrays, - Created approximately 20 monthly data validation check reports to keep membership data healthy
functions - Streamlined BECTU's current subscriptions rates which had a poor structure and duplicates to be
clearer and more concise
SQL (Intermediate) - - Using MS Teams, created a ticket management system for Data & Reporting specifically so we can
SQL queries using prioritise tasks and projects which was previously managed in a shared mailbox
joins, grouping,
MS Excel with VBA - Looking after Prospect's membership system (Sodalitas) which contains over 145,000 members
(Expert) - Pivot - After merger, bringing Bectu trade union's membership data up to Prospect's standards
tables, charts, data - Preparing merging the data for both Prospect and Bectu by comparing, analysing, interrogating both
validation, sets of data
conditional - Managing Data Extracts module in Sodalitas by creating and maintaining reports, and report access
formatting, - Running ad hoc SQL queries via Oracle Server and MS Access where we required more specialised
formulas, and reports
functions, read and - Maintaining and improving the Month End Statistics Reports which are provided to key Heads of write macros Department and SMT
VBA Programming - Logging improvements and issues on Sodalitas, testing and finally completing these changes
(Advanced) - Achievements:
Variables, condition - Moved all BECTU's MS Access based queries on to Sodalitas Data Extract module by gaining access
statements, strings, to the relevant data tables and views available to replicate reports
loops, arrays, - Created approximately 20 monthly data validation check reports to keep membership data healthy
functions - Streamlined BECTU's current subscriptions rates which had a poor structure and duplicates to be
clearer and more concise
SQL (Intermediate) - - Using MS Teams, created a ticket management system for Data & Reporting specifically so we can
SQL queries using prioritise tasks and projects which was previously managed in a shared mailbox
joins, grouping,
Excel, Sql, Oracle, VBA, Management, Statistics, Access, Testing, Server, UP
2018 - 2018
job
Junior Data Analyst
LexisNexis.
nested sub queries, Responsibilities:
stored procedures, - Looking after the Data & Analytics inbox dealing with ad hoc usage requests, assigning all incoming
creating and tasks to a relevant member of the team, logging all requests on the JIRA ticket system
editing tables and - Running weekly, monthly, and quarterly reports within the required deadlines while writing and views updating procedures for these reports
- Rebuilding current regular reports from the ground up to automate running reports so they can be
Tableau completed and sent out in a few clicks using SQL, Excel, Outlook, and VBA
(Intermediate) - - Rebuilding reports on Tableau/ Oracle BI so customers can self-service data as and when required
Filters, sorting, - Working on projects for various departments designing reports for customers based on their exact
calculated fields, requirements
actions filters, sets, - Extracting extremely large sets of data using SQL, (200k-300k) rows of data depending on request with groups, varying number fields and manipulating data as required
parameters, - Ensuring all data supplied within reports and dashboards, comply to GDPR requirements
dashboards, data Achievements:
security - Transformed the Paywall Dashboard which was based in Excel to a self-service dashboard in Tableau
using Tableau built in feature to bring in data using SQL
Oracle BI
- Reworked a Monthly Usage Report for a University in Excel using VBA to fully automate the refresh for
(Intermediate) -
the report
Filters, calculated
- Rewriting existing SQL code using nested subqueries and WITH function to reduce time to extract
fields, graphs and usage data
charts, tables, self-
- Developed SQL querying to an intermediate level within Teradata, SQL Server and Oracle Server
service dashboard
making me more efficient at pulling data for reports
- Completed Tableau basic and intermediate training allowing me to build reports and dashboards
within Tableau
- Completed GDPR training to ensure data supplied is within compliance
IT Skills Employment History
stored procedures, - Looking after the Data & Analytics inbox dealing with ad hoc usage requests, assigning all incoming
creating and tasks to a relevant member of the team, logging all requests on the JIRA ticket system
editing tables and - Running weekly, monthly, and quarterly reports within the required deadlines while writing and views updating procedures for these reports
- Rebuilding current regular reports from the ground up to automate running reports so they can be
Tableau completed and sent out in a few clicks using SQL, Excel, Outlook, and VBA
(Intermediate) - - Rebuilding reports on Tableau/ Oracle BI so customers can self-service data as and when required
Filters, sorting, - Working on projects for various departments designing reports for customers based on their exact
calculated fields, requirements
actions filters, sets, - Extracting extremely large sets of data using SQL, (200k-300k) rows of data depending on request with groups, varying number fields and manipulating data as required
parameters, - Ensuring all data supplied within reports and dashboards, comply to GDPR requirements
dashboards, data Achievements:
security - Transformed the Paywall Dashboard which was based in Excel to a self-service dashboard in Tableau
using Tableau built in feature to bring in data using SQL
Oracle BI
- Reworked a Monthly Usage Report for a University in Excel using VBA to fully automate the refresh for
(Intermediate) -
the report
Filters, calculated
- Rewriting existing SQL code using nested subqueries and WITH function to reduce time to extract
fields, graphs and usage data
charts, tables, self-
- Developed SQL querying to an intermediate level within Teradata, SQL Server and Oracle Server
service dashboard
making me more efficient at pulling data for reports
- Completed Tableau basic and intermediate training allowing me to build reports and dashboards
within Tableau
- Completed GDPR training to ensure data supplied is within compliance
IT Skills Employment History
Security, Basic, UP, ME, BEE, Server, Feature, Analyst, Teradata, It, Compliance, Service, Excel, Analytics, Stored procedures, GDpr, Tableau, VBA, Training, SQL Server, Oracle, Jira, Writing, Sql
2017 - 2018
job
Business Intelligence & Data Analyst, HCA Healthcare UK - London
Oracle BI.
(Intermediate) - Responsibilities:
Filters, calculated - Produce reports from internal and external workforce data to enable stakeholders to monitor and fields, graphs and measure performance
charts, tables, self- - Perform data analysis, interpretation and comparison of data produced to identify trends and service dashboards provide judgement/ narrative that enabled stakeholders to make informed decisions, supplied via
PowerPoint presentations
Workday
- Produce and maintain reports, mapping tables and standard operating procedures
(Intermediate) -
- Continually evaluating processes used to ensure best use of software and eliminations of manual
HCM
intervention where possible
fundamentals,
- Extract large amounts of workforce data based on relevant queries using a mixture of specialist
Report Writer
workforce management systems including Workday, TalentLink and MAPS
module
- Initially responsible for running and maintaining 6 regular periodic tailored reports which I then built up
SAP Business to a portfolio of 15 regular periodic tailored reports which are run weekly, monthly, and quarterly
Objects - Provide advice on best practice on data management and analytics
(Intermediate) - - Apply sound knowledge of data protection and confidentiality principles
Creating and Achievements:
editing reports, - Revamped the current process for running our Monthly HR Operations report (which took 3 days)
variables, and which went out to Chief Nursing Officers for each facility resulting in reducing the time to produce the formulas reports to about half a day
- Using VBA programming to reduce running times for all tailored reports by over 50%
SPSS (Intermediate) - Produced procedures for all regular tailored reports from scratch allowing another member of the
- Linear regression, team (with less knowledge of reporting) in effect to run the reports if ever need be
factor analysis, - Built strong working relationships quickly which ensured proficiency to gather requirements for new
cluster analysis, report requests
population - Completed Workday HCM Fundamental and Report Writer modules to effectively create and supply
distributions, means tailored reports to relevant departments of over 8000+ workers within the company
and bivariate - Recognised by my manager and colleagues from other departments to be able to efficiently supply
correlation accurate workforce data and reports so key strategic decisions can be made
Filters, calculated - Produce reports from internal and external workforce data to enable stakeholders to monitor and fields, graphs and measure performance
charts, tables, self- - Perform data analysis, interpretation and comparison of data produced to identify trends and service dashboards provide judgement/ narrative that enabled stakeholders to make informed decisions, supplied via
PowerPoint presentations
Workday
- Produce and maintain reports, mapping tables and standard operating procedures
(Intermediate) -
- Continually evaluating processes used to ensure best use of software and eliminations of manual
HCM
intervention where possible
fundamentals,
- Extract large amounts of workforce data based on relevant queries using a mixture of specialist
Report Writer
workforce management systems including Workday, TalentLink and MAPS
module
- Initially responsible for running and maintaining 6 regular periodic tailored reports which I then built up
SAP Business to a portfolio of 15 regular periodic tailored reports which are run weekly, monthly, and quarterly
Objects - Provide advice on best practice on data management and analytics
(Intermediate) - - Apply sound knowledge of data protection and confidentiality principles
Creating and Achievements:
editing reports, - Revamped the current process for running our Monthly HR Operations report (which took 3 days)
variables, and which went out to Chief Nursing Officers for each facility resulting in reducing the time to produce the formulas reports to about half a day
- Using VBA programming to reduce running times for all tailored reports by over 50%
SPSS (Intermediate) - Produced procedures for all regular tailored reports from scratch allowing another member of the
- Linear regression, team (with less knowledge of reporting) in effect to run the reports if ever need be
factor analysis, - Built strong working relationships quickly which ensured proficiency to gather requirements for new
cluster analysis, report requests
population - Completed Workday HCM Fundamental and Report Writer modules to effectively create and supply
distributions, means tailored reports to relevant departments of over 8000+ workers within the company
and bivariate - Recognised by my manager and colleagues from other departments to be able to efficiently supply
correlation accurate workforce data and reports so key strategic decisions can be made
Analytics, Cluster Analysis, Manager, UP, Processes, Software, HR Operations, Analyst, Workday, Less, Service, Data Analysis, Data protection, Spss, Management, VBA, Data management, SAP, Operations, Powerpoint, Business Intelligence
2012 - 2017
job
Data Officer
East Thames Ltd.
Decomposition Responsibilities:
models, time series - Supply and calculate rents for a portfolio of 13,500+ properties based on variables including property
regression, fit and value, size, location, local rents, and additional property attributes
validate models, - Analyse and project rents considering anomalies that could affect trend, used in aiding the board of forecasting directors to make key strategic decisions
Familiar with - Budget and reforecast rent for 13,500+ properties considering assumptions and variances for Finance
software and to plan long term and short term business objectives
coding languages - Responsible for loading, modifying, extracting, and validation of 17,000+ asset data with accuracy
such as Python, and minimal errors from the in-house database
JAVA, HTML, PHP, - Maintaining multiple rent databases calculating rent increases to provide ad-hoc reports and analysis
CSS, Javascript, - Data manipulation, cleansing and processing in Excel from in-house database extracts
JQuery, MATLAB, - Supply qualitative and quantitative data to internal departments and collaborating organisations
Win QSB - Find, testing and resolve problems with the new self-service process for sending out rent letters
- Provide training to new team members on current processes and newly implemented systems
models, time series - Supply and calculate rents for a portfolio of 13,500+ properties based on variables including property
regression, fit and value, size, location, local rents, and additional property attributes
validate models, - Analyse and project rents considering anomalies that could affect trend, used in aiding the board of forecasting directors to make key strategic decisions
Familiar with - Budget and reforecast rent for 13,500+ properties considering assumptions and variances for Finance
software and to plan long term and short term business objectives
coding languages - Responsible for loading, modifying, extracting, and validation of 17,000+ asset data with accuracy
such as Python, and minimal errors from the in-house database
JAVA, HTML, PHP, - Maintaining multiple rent databases calculating rent increases to provide ad-hoc reports and analysis
CSS, Javascript, - Data manipulation, cleansing and processing in Excel from in-house database extracts
JQuery, MATLAB, - Supply qualitative and quantitative data to internal departments and collaborating organisations
Win QSB - Find, testing and resolve problems with the new self-service process for sending out rent letters
- Provide training to new team members on current processes and newly implemented systems
Forecasting, Processes, Processing, Software, Testing, Service, Finance, Database, Matlab, Training, Javascript, Budget, HTML/CSS/Javascript, Java, Jquery, Python, Excel, Php, Css, Html
My education
New City College
N/a, N/a
N/a, N/a
Asadullah's reviews
Asadullah has not received any reviews on Worksome.
Contact Asadullah Choudhury
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Asadullah directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark