Alisha George
Auckland,AUK
Summary
Proactive, talented, and self-motivated professional desiring the role of a Data Analyst where profound analytical skills can be applied to aid the company accomplish its goals in line with its vision, mission, and corporate values.
Experienced and dedicated Data analyst with 5+ years of IT experience in Application Support, Enhancement and Maintenance projects in retail and finance sectors by identifying efficiencies and problem areas within data streams, while communicating needs for project. Adept at receiving and monitoring data from multiple data streams including Excel and SQL data source. Bringing forth the ability to synthesize quantitative information and interact effectively with colleagues and clients. Proven track record of gathering summary documents for senior management for weekly, monthly and quarterly audit and compliance reporting. Good knowledge of RDBMS concepts and experience in SQL Language and Microsoft SQL Server Management Studio. Highly proficient in writing and interpreting complex SQL queries including Stored Procedures. Broad Knowledge of ETL Processes such as source, mapping, transformation, staging areas and created various ETL documents such as ETL Mapping documents, Data Mapping documents. Expert knowledge of analytical programming languages – Python. Strong analytical and problem solving skills as well as strong attention to detail. Highly proficient in Business Analytics Tool - Microsoft Power BI and MS Excel-for greater insights into data. Worked extensively in testing and supporting the delivery of large and small applications. Involved in resolving various application related issue tickets.
Results-oriented Analyst skillful in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Proven Track record of transforming specific business goals related to growth and efficiency improvements into new system designs.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Insights Analyst
ASB Bank
07.2022 - Current
- Validated results and performed quality assurance to assess accuracy of data.
- Performed budget analysis to control expenditures and predict future budget needs.
- Enhanced team collaboration by providing clear communication of complex findings through visualizations and reports.
- Collected, arranged, and input information into database system.
- Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
- Analyzed transactions to build logical business intelligence model for real-time reporting needs.
- Collaborated with business-unit leaders to identify and prioritize problems.
- Designed and developed data pipelines to acquire, clean and process data.
- Generated standard and custom reports to provide insights into business performance.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Collaborated with stakeholders to identify business needs and data sources.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Created dashboards to monitor and track key performance indicators.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Utilized data visualization tools to effectively communicate business insights.
- Learned and adapted quickly to new technology and software applications.
- Adaptable and proficient in learning new concepts quickly and efficiently.
Data-Reporting BI Analyst
Debitsuccess by Xplor
07.2021 - 06.2022
- Build and analyse dashboards and data models to empower operational and explanatory analysis
- Tell stories in relation to data and drive decisions to wider BI team and stakeholders
- Promote Data Visualization, providing greater insight into business data
- Documentation of code and SQL to maintain good development practices
- Perform data analysis tasks as required using variety of tools like Power BI, Excel, SSMS
- Developing and creating Power BI dashboards.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Developed and implemented data governance policies and procedures.
Data Analyst
CEVA Logistics
11.2020 - 07.2021
- Analysing data, manipulating with required changes in the database to ensure data integrity and build reports for daily, weekly and monthly statistics
- Maintaining PostgreSQL database containing billing data
- Provide support to data stakeholders by creating insights in useful formats(reports and dashboards)
- Developing codes using SQL, Python or VBA to incorporate new data sources into database based on business requirements
- Involved in automation of various reports like KPI, Customer SLA Reports and Labour Scheduling Tool.
Associate System Engineer
IBM
08.2016 - 03.2019
- Extracting raw data from Jira, transforming it into Excel data source and creating reports and models using SQL and Excel
- Creating weekly reports of individual performance of team and publishing on Jira Dashboard
- Using SQL queries to pull accurate data from high volume
- Auto classification of incidents by querying specific data in SQL
- Reviewed data and classified the tables/measures functions by using multiple queries, views and procedures
- Extracted data from SQL Server database tables into flat data files and Excel sheets using table export
- Generated variety of business reports from SQL server using excel with pivot table and pivot chart
- Efficient use of pivot tables, VLOOKUP’s for pulling data to prepare monthly metrics and execute dashboards using Power BI
- Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations and SQL stored procedures, user defined functions (UDFs) for data analysis
- Prepare and share weekly Status reports to all stake holders
- Manage tickets and meeting their SLA period
- Manage to minimize the production issues by developing numerous health checks using SQL
- Worked on Analysing and Reporting common trends on incidents/REQ/TASK in Jira
- Worked with clients understanding and providing them technical hardware and software support
- Run complex SQL queries and Python codes to debug and solve customer issues
- Manage Payroll processing batch jobs in Workforce Time Keeper
- Facilitate Code promotion like raising change requests and presenting to Change management, Production migration and verification team
- Prepare and present the Weekly Status Report for the Stack holders
- Designed efficient Dashboards using Power BI tool involving multiple data sets
- Involved in mobile app testing to fix issues - Honda link and Acura link applications
- Gather application knowledge from team mates within minimal time frame
- Show quick responsiveness to client towards the resolution of the dockets by interacting directly
- Provide technical Advice/Guidance to new team members.
Education
Bachelor of Technology - Electronics and Communication Engineering
LBS College of Engineering, Kasaragod, Kerala
01.2016
Skills
- Business Operations Analysis
- Information Gathering
- Data Analysis
- Business Intelligence
- Tableau Software
- SQL and Databases
- Excel proficiency
- Data Research and Validation
- Documentation And Reporting
- MS Excel
- Teamwork and Collaboration
- Attention to Detail
Technical Skills And Knowledge
C++, SQL, Python, MS SQL, PostgreSQL, MySQL, Microsoft Power BI, Tableau, Advanced Excel, Windows, Linux, Control-M, ICD Maximo-Ticketing Tool, MS Excel, MS Word, MS Power Point, Internet Explorer, Chrome, Firefox, Safari, Jira, ICD Maximo-Ticketing Tool, GIT Version Control, Microsoft Azure
Personal Information
Title: Data Analyst
References
Available upon request.
Certification
- [Area of certification], [Company Name] - [Timeframe]
Timeline
Data Insights Analyst
ASB Bank
07.2022 - Current
Data-Reporting BI Analyst
Debitsuccess by Xplor
07.2021 - 06.2022
Data Analyst
CEVA Logistics
11.2020 - 07.2021
Associate System Engineer
IBM
08.2016 - 03.2019
Bachelor of Technology - Electronics and Communication Engineering
LBS College of Engineering, Kasaragod, Kerala
Similar Profiles
Theresa SmithTheresa Smith
Home Ownership Manager at ASB BankHome Ownership Manager at ASB Bank
STEPHANIE EVERITTSTEPHANIE EVERITT
Marketing Capability Manager at ASB BankMarketing Capability Manager at ASB Bank
Junli MaJunli Ma
Customer Specialist at ASB BankCustomer Specialist at ASB Bank
Jass BhallaJass Bhalla
Senior Customer Specialist at ASB BankSenior Customer Specialist at ASB Bank
Kaufusi KioaKaufusi Kioa
Warehouse Forklift Operator at Allproof IndustriesWarehouse Forklift Operator at Allproof Industries