Akash Kumar

Business Development Manager

Pune, Maharashtra, India4 yrs 4 mos experience
Most Likely To Switch

Key Highlights

  • 3+ years of experience in Data Analysis and Business Intelligence.
  • Expert in SQL, Python, and Data Visualization tools.
  • Strong problem-solving and leadership skills.
Stackforce AI infers this person is a Data Analyst with expertise in Business Intelligence and Fintech industries.

Contact

Skills

Core Skills

Data AnalysisBusiness IntelligenceData VisualizationBusiness ConsultingSalesforce Administration

Other Skills

AbinitioAmazon Web Services (AWS)AnalysisAnalytical SkillsAzureAzure Data FactoryAzure DatabricksAzure/ADF/DataBricks/ETLBigData HadoopCascading Style Sheets (CSS)Cloud ComputingConfluenceData CleaningData ModelingData Modelling

About

Client-Focused, Strong Problem-Solving skills, Productive with excellent leadership skills. I carry a total of 3+ years of experience in IT & worked as Data/Business Analyst Engineer & Business Intelligence & Technical Consultant at Barclays, RadarRadar(Tradesparent), Summit Interconnect(RCS PVT LTD) and collaborated with the Clients & teams to transform business needs into actionable SQL queries by extracting, cleaning, performing analysis, normalizing data through ETL tool & load data into widgets and build dashboards to providing valuable insights to various stakeholders to improve data accuracy, quality, efficiency to boost performance and maintain strong client relationships. Provided Technical Support & created documentation for business requirements. I have developed a strong understanding & great common over database management, data cleaning, excel, SQL, python, shell scripting, Tableau/PowerBI to analyze & create dynamic dashboards to find meaningful insights and drive decision-making. As a team player & quick learner, I have excellent work ethics & communication skills and problem-solving abilities. Languages : · Python · Java · SQL · HTML/CSS · JavaScript Cloud : · AZURE · Azure Data Factory · Databricks · AWS · Salesforce · light component Frameworks : · NumPy-Pandas · Matplotlib · seaborn Analytic Skills : · Data Cleaning · Analysis · Visualization · Business Analysis · Data Science & Engineering · Data Interpretation · Data Modelling · Data Reporting · SQL & Stored Procedure · Statistics · Microsoft Excel · Pivot · VLOOKUP · Excel functions · Machine Learning Analytic Tools : · Microsoft SQL SERVER · Postgres · MySQ · Teradata · Abinitio · Azure/ADF/DataBrickks · ETL · Microsoft Excel · PowerBI/PowerBI-Embed · GIT/GitHub · JIRA/Confluence · Playwright & Cypress Testing · Unix/Linux · Scripting · PowerShell · Putty · Hadoop · Outlook · PowerPoint · Word SOFT SKILLS · Reporting · Data Interpretation · Good Communication · Storytelling · Presentation · Ownership · Leadership · Team Management · Adaptable · Team Work, collaborative

Experience

Summit interconnect

Business Intelligence Analyst & Data Engineer

Jan 2024Present · 2 yrs 2 mos

  • Partnered with technical & business teams in PCB industry to analyze, develop data-driven insights & create efficient dashboards/reporting solutions
  • Designed & integrated Power BI reports with WebApp with live dashboards & Developed SQL queries in UAT/Prod env. Utilized ETL tools to transform, manipulate, aggregate, normalize, joins to improve data accuracy & quality.
  • Worked on AZURE Data Factory DataBricks with teams to perform ETL, Created Pipelines, jobs/clusters & Wrote queries, ML codes, data flows on datasets & utilized Active Directory, Key Vault to get access-embed tokens
  • SKILLS : Data Cleaning, Analysis, Visualization · SQL Server · Python/Numpy-Pandas · Machine Learning · Azure/ADF/DataBricks/ETL · PowerBI/PowerBI-Embed · Microsoft Excel · GIT · JIRA/Confluence · Playwright & Cypress Testing
  • SOFT SKILLS
  • · Reporting · Data Interpretation · Good Communication · Storytelling · Presentation · Ownership · Leadership · Team Management · Adaptable · Team Work, collaborative
Data CleaningAnalysisVisualizationSQL ServerPython/Numpy-PandasMachine Learning+8

Radarradar

Technical Business Consultant

Jul 2023Dec 2023 · 5 mos · Rotterdam–The Hague metropolitan area, South Holland, Netherlands

  • Collaborated with clients to identify commodity trading risk & analyze key opportunities & build data-driven strategies to boost our client's business & improve risk and maintain strong client relationships, trust, satisfaction.
  • Worked closely with technical & business consultants on real-world commodity markets to understand analytical needs to analyze data requirements & transform business needs into actionable SQL queries & conduct data normalization from multiple sources to improve data accuracy, quality, integrity, efficiency & report generation and performed data validation to enhance data quality.
  • Collaborated with the teams on ad-hoc projects to understand end-to-end data flow process for positions, prices, yields file types.
  • Wrote, developed SQL queries and stored procedures for "WIDGETS" & "IMPORT" scripts on Microsoft SQL Server to extract and process client's commodity raw data from a variety of sources into RadarRadar model & transform using ETL tool, data manipulation, data aggregation, joins & load data into widgets to analyze commodity trading data.
  • Provided Technical Support to the teams & clients with SQL best practices to identify, troubleshoot, diagnose SQL database-related issues, and resolve complex SQL queries to ensure optimal SQL performance leading to a 15% increase in query efficiency, and implemented documentation for support tickets and business requirements according to client specifications.
  • Created custom reports and interactive dashboards & visualizations to provide real-time insights for trading & risk decisions in a clear and concise manner to stakeholders for data-driven decision-making processes
  • Skills: Data Analysis · Data Visualization · Microsoft SQL Server · SQL · TSQL · Azure · Python · PowerBI · Microsoft Excel · Data Validation · Microsoft PowerPoint
  • SOFT SKILLS
  • · Reporting · Data Interpretation · Good Communication · Storytelling · Presentation · Ownership
  • · Leadership · Team Management · Adaptable
Data AnalysisData VisualizationMicrosoft SQL ServerSQLTSQLAzure+6

Barclays corporate & investment bank

Senior Data Analyst BA3

Feb 2022May 2023 · 1 yr 3 mos · Pune, Maharashtra, India

  • I have worked as data analyst, I was responsible for cleaning, perform analysis and validating reports & building dashboards & providing valuable insights to various stakeholders.
  • During these experiences, I have developed a strong understanding of database management, data cleaning, SQL, Tableau to analyze & create dynamic dashboard to find meaningful insights and drive decision-making.
  • Worked & Collaborated with business team to identifying, understand requirements & provide strategies to improved business & kept a track of key metrics
  • Received, filter, cleaned, prepped data, developed & executed SQL data queries to conduct pivot analyses & validating data using excel vlookup
  • Identified procedural areas of improvement through customer data to help improve profitability & maintain data quality check on customers financial data to ensure accuracy
  • Worked on ad-hoc queries to address business problems, examine them using SQL & presented findings in Tableau Dashboard
  • Proficiency in SQL Querying, Database Development and Debugging.
  • Built, Created, Developed, published interactive & dyanmic Tableau dashboards to visualize 30+ core
  • business KPIs related to distinctive areas of interest to
  • Created interactive filters, parameters, calculations, background images, trend lines for dashboards and worksheets in Tableau
  • Follow Tableau best practices, Evaluated patterns and provided meaningful insights from data to understand customer behavior & maximize the impact
  • Skills : Data Analysis · Data Visualization · Data Cleaning · Data Validation · Data Modelling · Microsoft SQL Server · SQL · Stored Procedure · Teradata · PowerBI · Tableau · Microsoft Excel · Pivot · Vlookup · excel functions · PowerPoint · Word · Outlook · JIRA · Confluence · GIT · Unix/Linux Scripting · Powershell · Putty · ETL · Abinitio · BigData Hadoop · Python · Numpy/pandas · Hive/impala · spark
Data AnalysisData VisualizationData CleaningData ValidationData ModellingMicrosoft SQL Server+26

_vois

Salesforce Administrator

Aug 2021Mar 2022 · 7 mos · Pune, Maharashtra, India

  • Part of SCM deployment team,responsible for managing & performing pre-prod. & production end-to-end ”CL” deployement lifecycle, picking & moving up all ”changes & CL” from one to another sandbox, test them & deploy till prod. as per bussiness req.
  • Worked on salesforce cloud with tasks including, create custom objects fields, relationships, Workflow Rules, Sharing, Validation Rules
  • Skills : Salesforce · light componnet · custom objects fields · relationships · Workflow Rules · Validation Rules
Salesforcelight componentcustom objects fieldsrelationshipsWorkflow RulesValidation Rules+1

Medulance

Data Analyst Internship

Apr 2020Jun 2020 · 2 mos · Hyderabad, Telangana, India

  • Worked with developments teams to ensure accurate integration of ML models into firm
  • Compared increased efficiency & performance of each models with others & evaluated their best accuracy score which led to successful completion of internship
  • Improved & optimized the Model by Hyper Parametric Tuning different parameters in the model which led to increased in accuracy from 87%to 90%
  • Received hands-on training project management & provided suggestion on how further analysis and accuracy can be improved & optimized
  • Accomplished the project by studying & analyzing various data features & developed ML models which led to successful completion of internship
  • It has been my privilege to have a team of project guide who have assisted me on ongoing project from the commencement of this project
  • Learned how to clean & analyze the data, which comes under exploratory data analysis & finally visualize using libraries & various others tools & got to enhance my practical as well as theoretical skills

Amazon web services (aws)

Amazon AWS Technical Essentials & Architecture Internship

Mar 2020May 2020 · 2 mos · Hyderabad, Telangana

  • AWS Technical Essentials & Architecture Internship
  • Tasks that I completed during the course of this internship:
  • Work directly on AWS Cloud environment
  • Hands-on AWS cloud Qwik labs & where I have performed :
  • Hands-on 2 mini-projects
  • AWS Techincal Essentials Topics include :
  • Understand the different AWS compute, storage, network, database services i.e., EC2 (virtual server, connect cloud to O.S.), S3, EBS, EFS, Glacier, VPC, CloudFront, RDS, DynamoDB
  • Examine IAM service i.e., users, groups, and roles, policies
  • Architecting on AWS Topics include :
  • Identify the design and architectural patterns
  • Compared structured query language (SQL) with NoSQL databases
  • Select compute, storage, database, and networking resources to improve performance
  • Best practices to eliminate suboptimal resources
  • VERIFY LINK : https://ethnus.com/certverify

Takenmind organization

Data Analyst Internship

Feb 2020Apr 2020 · 2 mos

  • Learned how to clean & analyse the data, which comes under exploratory data analysis & finally visualize using libraries & various others tools.
  • Cover all domain, such as data gathering(can be structed & un-structed)ML,DL(training & testing models & their accuracy ),Maths(calculas,stats,ALA,diff eqn),deployment,visualization & most important part , story-telling - how you present your prediction/review to satisfy clients demands.

Jpmorgan chase & co.

Software Engineering Virtual Internship

Jan 2020Feb 2020 · 1 mo

  • I learned how to use perspective to generate a live graph that displays the data feed in a clear and visually appealing way for traders to monitor this trading strategy.
  • And also completed practical task modules in Establishing Financial Data Feed, Frontend Web Development, and Data Visualization and learned how the real-time data streams, an alternative way to visualizes and share price data for its traders.

Education

Vellore Institute of Technology

Bachelor of Technology — Computer Science

Jan 2017Jan 2021

FIITJEE JUNIOR COLLEGE, SA

Senior Secondary School — Science/Mathematics

Jan 2015Jan 2017

Army Public School,Bolarum,Secunderabad

High School

Jan 2009Jan 2015

Stackforce found 100+ more professionals with Data Analysis & Business Intelligence

Explore similar profiles based on matching skills and experience