data analyst Archives

Quality Assurance On all types of client Projects.
Advanced Excel
Requirement Understanding & Done all types of sample work. Also, gained new projects from samplings (UK, US, AUS, SA, Singapore, Asia, NZ)
Company & Management profiling for a better generation in customer engagement.
Corporate information capturing – customers, clients, and partners to broaden the window for further sales & account management processes within the organization.
Market Research on web development, Business development, Accurate Data Reserch, Product Reserch.
Report Generation for USA Vendor(Extracting reports for different vendor through the different process on the different portal)

Executing calculations such as averages, percentages, profit – Loss ratios, turnaround time and other related statistical logics.
Event listing: venue research, Creation, venue facility creation, package creation. Gallery creation, database creation.
Email Campaign
Sales Lead Generation.

Generated tables, listing and graphs in statistical analysis of data.
Generated daily, weekly and monthly reports using Proc Report, Excel and SQL.
Communicating with supporting teams and branches for data collection, report updations and other clarifications.
Preparing power point presentations to clients as and when preferred.

Review records or reports pertaining to activities such as payroll PF related and Pension Process
Provide support to reports and Tableau applications carrier.
Expert on Tableau Report Performance Optimization.
Develop clean well executed design concepts, and coordinate with team on design and prototype of new interfaces/dashboards/ visualizations.

Creating Data Modeling and provide feasible ouput to the Application Maintainence Organization, to gain perspective on Vendor Performance.
Analysis of performance using Tableau and PowerBI. Automating and standardizing the weekly evaluation metrics.
Prepared Data Mapping Documents for the reporting documents generated by the system.
Automation and optimization of existing processes with VBA.

Responsible for acquiring data from primary or secondary data sources and maintaining databases.
Using that, gathered Data sources from which we can get printer & consumables dealers in EUROPE & other countries.
With the help of the Data sources obtained, providing Reseller (RS) & Enduser (EU) in them. RS – if the company sells printers or printer consumables, EU – other case.
Recursion of companies will be avoided using the sage, which was created using the data provided.
Explored for more details about the company which are neither segmented as RS nor EU & segment it as RS/EU depends on the nature of the business done by the company.

Business Risk Factors Analysis
Market Intelligence Reports
Competitor Analysis Reports
Standard Industrial Classification of Companies

Accordingly the data is spooled from Front end or taken from the IT Help desk .
Checking the correctness of the data .
Arranging the data according to the format
Reports should be send as per the TAT.
Based on the requirement Masters at the back end need to be changed so that output is correct.
Various reports for Management.
Analyzing the data with various factors.

Familiar with MIS.
Day-to-Day Analysis of MIS Reports, follow up and coordination with cross functional teams to ensure timely flow of MIS.
Proficient with Data Management and Data Analytics.
Developed VBA code to send automatic confirmation email client by MS Outlook.
Daily, Weekly, Monthly MIS Reports, Dashboards generation and automation using VBA Excel.
A working knowledge of advanced Excel functions and ability to read, write, and debug advanced Excel formulas.
Using Excel Functions, Table, PivotTable, Data Tools, Charts, Lookup, Sort and Filter, workbooks & worksheets data through VBA code. Analyzing data and creating final Report.

Identified potential fraud trends and performed appropriate analysis .
Evaluate medical records for inaccurate or missing documentation.
Measures such as no. of inpatient with length of stay greater than 10 days to track Inpatient for the clients.
Checking for emergency room stay breach and over-payments.
Designed dashboard of top 10 diagnoses for both emergent, non-emergent and chronic conditions.

Develop data system through bulk processing of raw data into refined usable information
Communicated with the clients and update the information in SuiteCRM.
Managed and followed up on digital marketing campaigns.
Assisted in identifying potential business opportunities.

Used google analytics to analyze the web traffic on the website to know about the visitor’s demands and interests and profiling the people to help make design decisions concerning the services provided.
Also helped in optimizing the most visited categories for the website.
Researched for alternatives of web architecture and development to improve the design and working of the website.
Submit project deliverables, ensuring adherence to data quality standards.

Analyzed the Business Modules and their impact on the current system.
Responsible for starting RUP and UML processes for creation of documentation to use by IT Team.
Created Requirement Specification Documents based on interviews with End Users, JAD Sessions and analysis of their existent systems.
Created Use Cases, Use Case Models, Work Flows, and System Specification Document using RUP Methodology.
Analyzed end-user requirements, their strategies, and their objectives to create Requirement Specification Documents and Use Cases.
Assisted with building HL7 EDI claims processing flow from the Trading Partners to the translator to the Mainframe and back to the Trading Partner.
Understand rules and regulations of HIPAA as imposed during Electronic Data Interchange (EDI).

.Preparing general job status report, refresh and republish existing report weekly. for the AIROD management team.
Reviewing raw data to make sure data reported correctly, and to look for missing, hidden or problematic data.
Regularly re-analyze and scrutinize data source and raw data in Microsoft Excel and SQL to find hidden insights and to find if any error.
Monitor and analyze information and data systems and evaluate their performance to discover ways of enhancing them.
Support information requirement of stakeholders from various departments, other teams or stakeholders for data driven decision making.
Liaising with clients and vendors/contractors regarding job status and progress.

Inputting large volume orders within online database systems.
Adjusting customer requests & inquiries.
Managed end-to-end process for updating & verifying orders data.
Ensuring data accuracy through the creation & implementation of data integrity queries.
Carrying out audit on data in a bid to tackle customer base business related issues & performing administrative duties.

Collecting and interpreting data.
Working alongside teams within the business or the management team to establish business needs.
Develop records management processes.
Helping develop reports and analysis.

Collect and interpret user requirements
Research and provide advice to other relevant professionals regarding the selection, application and implementation of data
Collaborate within the business or the management team to establish business needs
Analyze data and perform data mining analysis
Defining new data collection and analysis processes

Help in improving data classification and categorizing algorithm of Google shopping project.
Make sure whatever content is being modeled, designed or managed is contributing up to successful search ratio between 90-95% or more.
Interacting with various teams, get their requirements, turn them into SQL queries and fetch data from the database whenever required.
Consolidating all the data from various excel files, database, and Google spreadsheets, perform data cleaning and transformation on it for better understanding
Perform the various analysis on the data i.e. swot analysis, gap analysis, benchmark analysis, root cause analysis, and convey it to content engineers and management.
Performing Secondary research and create data repository in the database.
Provide feedback and recommendations to Content Engineers on improving data mapping accuracy.

Work with management team to create a prioritized list of needs for each business segment.
Use data to create models that depict trends in the customer base and the consumer population as a whole.
Ability to collaborate effectively and work as part of a team.
Responsible for maintaining and updating the back-end system of our client.

Assisted the team in work allocation & management of work progress.
Monitoring the work progress to ensure proper delivery to the customers.
Interacting with the clients to gather their requirements and process them to develop to make it live with the help of developers.
Check to ensure that appropriate changes were made to resolve customers’ problems. Also testing the newly deployed application changes involved in the business.

Coordinate with all India petrol pump team .
Solving the Problems related to Merchants.
Preparing daily, weekly and monthly consignment statements and provide the same through e-mail to the branch offices.
Coordinating with all branch offices located in different states and ensures proper coordination with the merchants
Keeping track of the sales and merchant.
complaints. Checking daily Onboarded data

Interaction with clients
Dashboard setup
Providing application support
Work closely with the Marketing Director and report to the Japanese team (Managing director, Technical director, and Sales Chief)

Built tools like JOSM task configuration and automatic changeset generation allowing Map Technicians to get quickly oriented to map content creation tasks and improve their productivity.
Market research feedback.
Writing feasibility reports during the phase of converting the leads.
Coordinating lead generated through enquiry, where I’ll be following up with 8 branches across India.

Collection and analysis of 100’s of complaints received via our app which are related to garbage on streets,choking of drains,industrial waste dumped in residential zones etc.(collected over 3 years from 600+ localities in India)
Implemented extensive secondary research by making use of journal articles,research reports,magazines,and government publications to identify opportunities and threats in the waste collection and disposal methods
Extracted data,analyzed and summarized it using graphs and tables
Identified and listed around 150 parameters for Rapid Urban Planning analysis through apps.

Client Communication (Verbal and Non-Verbal communication).
Provide competitive analysis on various companies’ market offerings, identify market trends, pricing/business models, sales and methods of operation.
Remain fully informed on market trends, other parties’ researches and implement best practices.
Make recommendations for feasible methods for market penetration.

Collect data on consumers, competitors and market place and consolidate information into actionable items, reports, and presentations.
Generate marketing qualiﬁed leads that are processed as new opportunities and sent to the sales team.
Understand business objectives and design surveys to discover prospective customers’ preferences.
Compile and analyze statistical data using modern and traditional methods to collect it.
Perform valid and reliable market research SWOT analysis.
Interpret data, formulate reports and make recommendations.
Use online market research and catalog ﬁndings to databases.

Producing reports for management
Communicating with Account Managers
Extracting and analysing client company profiles
Maintaining and improving database
Data collection and data entry

Magazines and newspaper articles clipping – Online manually modified and rectified lengthy travel stories and articles into short, simple descriptive articles.
Email Campaign and Sales Lead Generation
Data Mining, Data entry, Data verification, and Web Research.
Reporting & task monitoring so that the team achieves quality targets and serves clients before the deadline.

Was the group leader, managed 3 people under me.
Analyzed data using Rstudio and Python
Completed a project.
Event venue marketplace listings : Venue research, Creation, venue facility creation, package creation, gallery optimization and creation, database creation, etc,.

To verify all the collected data for each project and also to have a quality check
Data Warehousing : Report generation for USA Vendors (Extracting data for different vendor through the different process on the different portal).
Browsed through various US Merchant’s websites and Google searched in US Server to collect coupons and generate new, working & valid coupons codes, merchant’s savvy deals & offers for their customers for online shopping.
Back end entries on various live portals for different projects.

data analyst

data analyst

senior data analyst/ senior process executive

data analyst

data analyst(internship/term project)

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

senior data analyst/ senior process executive

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst

data analyst