data analyst Archives

Experience in month end Reconciliations and reviewing various transactions accruals, bank statement etc.
Strong understanding of core financial processes and able to conceptualize and build new processes based on business requirements.
Maintenance of financial records (including analysis of revenue & expenses) in compliance with accepted firm policies & procedures.
Participated in preparing data lineage documents, mapping sheet, design documents on basis of FRS.

Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, etc).
Follow and apply quality assurance procedures to survey instrument development for the Personal Safety Survey. Set up processing systems using Dress Rehearsal data.
Train staff on basic data cleaning and manipulating procedures using the statistical software package SAS and develop training resources that can be used for Final data processing.
Finding the match clients(subsidiaries) by using sql queries for the appropriate firm.

Identify a single master ACP for key client firms, based on Aon Global Client Network, Global Account Management System clients other AGCN multinational firms
Identify the primary industry of the key client firm – this is the primary business in which the firm engages, from the Aon point of view.
Sticking on to the data-governance policies.
For each firm, identify and link all related client accounts to the master ACP, to ensure key client families are accurately represented.
For each GAMS Parent, rationalization will cover mapping local client accounts to a master ACP. It will not cover creating a mapping relationship between GAMS subsidiaries and local client accounts. AGCN is responsible for creating mapping between GAMS subsidiaries and local client accounts.
Perform maintenance GDS research from external resources like d&b, GRS to identify newly added/divested subsidiaries – to get an updated view of the corporate family.
Find the proper exhibit to find the subsidiaries of the parent firm.

Collaborate with other staff to assist in the development and implementation of goals, objectives, and priorities in disseminating the Personal Safety Survey which has included publishing analytical articles on the ABS website and optimizing the awareness of the prevalence of violence in Australia through social media.
Conduct research on appropriate social media to be used for disseminating survey statistics.
Conduct quality assurance tests on social data in the Personal Safety Survey by analyzing, interpreting and manipulating data to ensure it is fit for purpose.
Whilst acting APS5, develop and enhance the Sensitivity and Awareness training package to ensure it illustrates how to conduct field interviews in both Computer Assisted Personal Interview (CAPI) and Computer Assisted Self Interview (CASI).
Identify risks and develop risk mitigation strategies for all stakeholders involved in the successful completion of this project.
Develop, review and produce the final training module by ensuring project milestones are met and delivered to high standard.
Supervise staff by recognizing strengths and delegating aspects of this project.

Utilized python and qGIS to optimize workflow
Thoroughly enhanced the user experience and interface by producing an overall cleaner, smoother configuration
Improved collaborative skills by working within an Agile team to quickly, accurately and successfully reach goals
Strong knowledge of and experience with databases (SQL etc).

Analysis Of Financial data of the clients, lenders.
Maintaining Charge details in Excel and analyzing them.
Analysis of Financial charge documents issued by lenders or financial institutions.
Uploading and downloading of financial data from Terminal .

Lead the Professional Services team responsible for researching, collecting, preparing, modeling and analyzing data.
Collaborated with client to understand project/business requirements with respect to US Healthcare and Insurance.
Designed specifications and techniques to perform feature engineering on the data present in EDI and HL7 format.
Identified and collected external/reference data to support and understand the internal/client data.
Developed algorithms to measure the quality of the data and generate reports based on the results.
Was awarded Start Analyst of the Quarter.

Built a dashboard using Tableau. Other Technology used are Google analytics,MYSql(Sources of data like Traffic from different sites,Requirement of customers etc) and R programming for scheduling the task.
Ad Hoc Analysis include campaign performance,cost per lead for different cities using Google analytics and MYSQL queries.
Building a customer segmentation using k- means clustering (R programming and Python vice-versa) to understand the need to customer and targeting the high priority customers.
Performance analysis of Recommendation system which works Light FM technique and giving insight how to improve it .

Statistic and machine learning to Analyze the data
SQL Query for data manipulation and data cleaning
Collecting and interpreting data
Defining new data collection and analysis processes

Understanding client business and requirements and act as an intermediate between client and development team.
Involved in coding to automate the existing workflow and to identify the best possible approach to clean, process, model the data and drawing insight for best business practices suitable to the client.
Connect with Database Administrators to design the client database and coordinate with Developers to build the client system software UI.
Explain the functional specifications to Developers and Database Development team, work with them on the tool building by connecting through daily calls/Emails/meetings.
Also involved in creating training material and imparting training/guidance to associate peers/developers on various tools/technologies/business processes using various use cases.

Account Management Office is a key web-based tool designed to help engagement leaders to track and manage all day to day account management activities for ADM engagements.
Ensure that the environment and work area is kept clean and tidy.
Recommend discipline in keeping with the Disciplinary Policy/Procedure.
Conduct performance review and appraisal with direct reports.

Responsible for a process development project resulting in the growth of the mass production yield by 15% over 3 years
Designed experiments and implemented in production lines to identify root cause to quality or production problems
Proposed optimized product designs or process settings by analyzing DOE data and mass production data in SAS & JMP
Generated failure analysis reports by aggregating the results from data analysis and engineering equipments
Co-ordinated with production departments and IT department, ensuring all the required data is available for the complete and accurate data collection

Identify new sources of data and methods to improve data collection, analysis, and reporting.
Determine data collection methods to be employed in research projects or surveys.
Compile and analyze data collected based on information to determine process or equipment operating efficiency or to diagnose malfunctions.
Analyze data to determine validity, quality, and scientific significance of the data

Analyze data from various sources, surface actionable insights and opportunities from complex data; leverage quantitative and qualitative data to understand ecosystems, user behaviors, and long-term trends.
Liaise with Commercial Services, Finance, Information Technology Divisions, and Metering departments to translate business issues into testable hypotheses with defined KPIs.
Communicate analyzed data for effective decision making.
Prepare visualization of data analyzed in the format of a report
Well managed data sources under the confines of the Data Management Section
Mentor and Coach staff within the Data Management Section and recommend areas to embrach and enhance continuous improvement.
Recommend training and development for direct reports.

Experience in creating indexed views, complex stored procedures, and useful functions.
ETL implementation using SQL Server Integration Services (SSIS).
Loaded data from different sources (text-based files, Excel spreadsheets, transaction records) in legacy system to SQL Server databases using SQL Server Integration Services (SSIS).
Worked and deployed SSIS package to improve already running packages.
Hands on experience developing different types of reports – Drill Down, Drill Through, Sub Reports and Parameterized Reports.

Remote internship with office based in Philippines.
Acudeen is an online platform for peer-to-peer (B2B and B2C) for invoice discounting.
Provided actionable insights and key learnings in the dataset.
Presented the visual dashboard to Acudeen’s users, staff and investors based on my findings from the data provided.

Perform data entry and research in various systems and tracking tools.
Apply knowledge of processes and related systems to assist in identifying, assessing and resolving issues/problems.
Assess and resolve non-standard and standard issues or problems.
Seek advice and escalate issues when faced with tasks/problems outside the scope of work.

Helped in creating Data model
Creating ETL’s to transfer data from one database to another
Automating Daily Reports and showing them on BI tool (Tableau)
Creating Insights using Store Data

Google shopping (Merlot)
Develop and participate in quality analyst work according to the business requirement and ensure the highest level of quality is achieved within assignments at all times.
Mentoring and also provide training to new resources in order to improve the knowledge and skills within the team.
Optimize existing process and provide ongoing feedback on tools and process

Worked as a Production Support Analyst taking care of Informatica workflows running in production.
Used autosys tool for scheduling objects and running through UNIX commands.
Worked on UNIX shell scripting and scripted pm cmd start the workflow and email setup using scripts and use those in autosys scheduler.
Worked on mappings , workflows using Informatica Powercenter standards and all the documentation needed for the ETL code.
Involved in Daily, Weekly and Monthly loads along with Adhoc request from users.
Performed data validations using Unix and Oracle and helping in ticket analysis to get incidents resolved within SLA.
Monitored and helped in completion of 24/7 batches in Informatica.

Extract and transform data from different sources to create weekly reports of compliance issues reported in servers.
Create Power BI and Pivot Tables metrics visualizations for management and risk and control team, to show the current state of identified compliance issues.
Ansible playbooks development for daily processes automation.
Create and maintenance of Splunk dashboards for management and operations teams, getting data from Ansible automation logs.
Create and maintenance of Microsoft Access database to automate and generate different reports.
Provide justification and updates to management and risk and control team about not resolved compliance issues based on operations team feedback.
Create ServiceNow reports for servers’ tracking.

Optimized stored procedures to extract, transform and load (ETL) data to ensure reporting infrastructure was maintained according to current service level agreements.
Participated in production implementation verification. Handle tickets/issues affecting production and staging data on the web site.
Participated in requirements meetings and data mapping sessions to understand business needs. Extensively investigated different data issues and communicated with clients to resolve the issues. Provide ad hoc reporting on request
Synthesized data from several data sources to produce consolidated views of project performance. Daily use of complex Excel formulas and pivot tables to manipulate large datasets
Wrote and executed various MYSQL database queries from python pandas. Used Python scripts to update content in the database and manipulate files. Run sas scripts.

Assisted in Designing Web Pages for Conducting Surveys using HTML, Java Script and CSS.
Tested and Deploying this Web Pages into Online Servers.
Grabbed the data from Servers and analyzed it using SQL Queries.
Performed Data Cleaning on the online survey data.
Generated reports for the survey data using the IBM SPSS tool.

Skilled at maintaining cordial relationships with clients while ensuring quality and service norms to achieve customer satisfaction and business retention
Excellent communication & Interpersonal skills with abilities in resolving complex issues
Being a self-motivated quick learner always ready to explore new tools and technologies.
Communicating with clients, determining their specific needs and write content in adherence with client goals.

Using Data Mining techniques to extract the data to render insights and generated different marketing reports on daily , weekly and monthly basis.
Tracking the Customer Acquisition Rate, retention rate and Cost per Acquisition from organic and inorganic traffic.
Creating dashboards and reports using the data of Google Ad-words, Facebook Ad Manager and Apps Flyer.
Performed RFM and LTV analysis to suggest some useful segment of customers for generating good revenue.
Identifying multi-channel funnel to measure effectiveness and ROI through different sources.
Played a key role in generating 10 Million revenue by providing good segment of customers to target through Emails and SMS.

Reports development in Tableau.
Providing trainings on business applications at various levels from sales executives, customer executive to distributors and the data operators for PepsiCo India Holding Pvt. Ltd.
Removing issues whatever comes in the data while working on applications and communicating them to the concerned team to make it work properly.
Providing knowledge transfer sessions to spread the business knowledge among the team.
Visiting various client sites for deployment of applications, providing trainings and giving hands-on help to the new users.
Providing data Related Solutions and Responsible for IT Assets.

Analysed procedures and making recommendations for improvements by creating quality assurance audits.
Created weekly reports correspondence from procedures to improve the process.
Have worked on UiPath to automate the UI testing of the Dashboard
Have worked on command manager and excel to provide the customized metric comparison tool which compares the metric of the same project across the different environment and provide the summary of the changes to the end user. Also,

Design,Develop and maintain analytics dashboards and reports.
Building infrastructure required for optimal extraction, transformation and loading of data from wide variety of sources using SQL.
Assemble,gather and cleanse data sets that meet business requirements.
Perform payroll auditing pre and post processing to ensure accuracy, compliance, overall balancing and reconciliation.

Conducted required data mining and transformation steps to get actionable information using SQL database.
Created visually impactful dashboards in Microsoft Excel for data reporting by using pivot tables & VLOOKUP.
Scored datasets & presented Business intelligence analysis that helped reduce loan default consumers by 12%
Balancing multiple tasks within time-sensitive environment while providing top-level quality service.

Processing of financial information from company annual reports.
Analysing and classifying financial information.
Working on ad hoc tasks involving use of excel/ databases relating to financial information.
Updating trackers via google sheet from time to time.