Alex Pakandathil Zachariah is seeking a role as a data analyst, agile developer, or reporting analyst. He has over 11 years of experience in business intelligence, analytics, and application support. His experience includes roles at United Utilities, PepsiCo, AIMIA Inc, and CVS Pharmacy. He has strong skills in Tableau, Alteryx, SQL, and data warehousing. He aims to contribute to an organization's growth through his analytical and technical skills.
Alex Pakandathil Zachariah is seeking a role as a data analyst, agile developer, or reporting analyst. He has over 11 years of experience in business intelligence, analytics, and application support. His experience includes roles at United Utilities, PepsiCo, AIMIA Inc, and CVS Pharmacy. He has strong skills in Tableau, Alteryx, SQL, and data warehousing. He aims to contribute to an organization's growth through his analytical and technical skills.
Alex Pakandathil Zachariah is seeking a role as a data analyst, agile developer, or reporting analyst. He has over 11 years of experience in business intelligence, analytics, and application support. His experience includes roles at United Utilities, PepsiCo, AIMIA Inc, and CVS Pharmacy. He has strong skills in Tableau, Alteryx, SQL, and data warehousing. He aims to contribute to an organization's growth through his analytical and technical skills.
Alex Pakandathil Zachariah is seeking a role as a data analyst, agile developer, or reporting analyst. He has over 11 years of experience in business intelligence, analytics, and application support. His experience includes roles at United Utilities, PepsiCo, AIMIA Inc, and CVS Pharmacy. He has strong skills in Tableau, Alteryx, SQL, and data warehousing. He aims to contribute to an organization's growth through his analytical and technical skills.
Alex Pakandathil Zachariah alex.zachariah@gmail.com
linkedin.com/in/alex-zachariah Certified Tableau Reporting and ETL Developer public.tableau.com/profile/alex.zachariah#!/ 07466024777 Professional Profile A self-motivated Analyst with more than 11 years’ experience in Analytic insights with Business Intelligence and application support, Seeking the role for Data Analyst, Agile developer or Reporting analyst, to contribute to company’s growth and in turn personal growth within the organization with respect to development, quality or enhancement. Maintains an inherently analytical approach to identifying critical areas and providing targeted solutions. Experience in Retail, financial , Pharmacy and workforce domain. With proven team player skills, communication skills and positive relationships with both client and colleagues - I am looking to join a data driven organization which will make use of my existing skills and provide me with an opportunity to both the company and self.
Core Competencies
KEY SKILLS: PMO| Business Analysis | ITIL | Data warehouse modelling| Stakeholder Management | Scoping | Technical Documentation | Communication | Excel Reporting | Training | Risk Management | Database management | Change Management| Development| Visualisation | BI Reporting | Project Lifecycle | Dashboard Reporting SPECIALIST PROFICIENCIES: ETL Workflow Development |Report Development| User and System Interface Design | Data Migration | Root Cause Analysis | Data, Gap & SWOT Analysis | System Integration Testing | User Acceptance Testing | SDLC | Data Quality Analysis| Agile| Application Support TECHNOLOGICAL SKILLS: Alteryx | Tableau | JIRA| Microsoft Visio, Project and Office 365 | EXASOL| Kognitio| SQL|Crystal Report| Skybot scheduler
Career Summary
Workforce Optimisation Lead Analyst Jan 2020 – Present
United Utilities, Warrington, UK
KEY ACHIEVEMENTS AND RESPONSIBILITIES
• Working with the Forecast and planning team to provide all essential Agent performance metrics to aid tactical and strategic decisions for resource planning and provide their KPI. • Providing scheduled time vs forecasting variation, any difference in the work allocated and isolate discrepancies in the Agent planning data • revamping the Information Centre Tableau report using Alteryx workflows to analyse information at a granular level and highlighting any risks and opportunities to drive forward the Contact Centre and improve customer experience • Providing a single point of Truth having all details related to the Agent's work, Call Quality metrics and even the cash collected. This report does week on week, and monthly and daily comparison of Agent Performance. • Providing tableau reports containing analytical data in a concise and tailored approach to give clear facts to aid management decisions. These reports are focused with Managers in mind giving them precise strategy where to focus Agent improvement. • Providing integration support for the new AWS call centre cloud-based solution to mitigate the COVID-19 impact on BAU service. • Liaison with outsourcing vendor on strict timeline to reduce impact on delivery timelines and minimize deviation from project plan.
TECHONOLOGY WORKED: Alteryx |Tableau| Exasol |Alteryx server |Excel reporting Data Quality Analyst 2019 – 2020 PepsiCo, Reading, UK (Contracted through Infosys Ltd)
KEY ACHIEVEMENTS AND RESPONSIBILITIES
• Liaison with all the local supply chain team, Topline leads, OPEX teams, external Vendors and Business Management Teams to ensure all the requirement are captured and processed. • Developed a single platform planning tool having multiple source including data base and number excel files. Integration of the data was done through Alteryx to TM1 planning tool and then to a single cockpit in Tableau. Hence Providing a one stop solution for corporate decisions. • Developed a blueprint for valuable service delivery improvements, collaborating with developers and architects. • Implemented quality rules for data produced to filter any corrupt and duplicate data into the dataset. • Provided error codes and log files for self-diagnosis and self-rectify the data before processing. • Enabled backup of processed data for disaster recovery and back dated processing in case of unforeseen disasters.
DWH Developer, Consultant and Support Analyst 2012 – 2018
AIMIA Inc, London, UK (Contracted through Infosys Ltd)
KEY ACHIEVEMENTS AND RESPONSIBILITIES
• Created the enterprise data warehouse for customer loyalty data for the Sainsburys’ NECTAR program for UK and other business across the globe. • Provide analytics support and enabling business to make fast and efficient decisions on the basis of Customer behaviour, trends and historic transaction. • Provided support for their Offer engine track generating personalized campaigns through email, Mobile and periodic vouchers for yearly festivals targeting potential customers and enabling new subscription offers. • 50% incident and ticket reduction by using trend analysis and forecasting bottlenecks and anticipating possible failure scenario. • Increased customer engagement level feedback using streamlined approach and well formatted communication templated and frequent updates. • Reduced production bugs by implemented process of scrutinised code testing and ensuring quality data. • Provided global delivery support model and ensured all the support agents are provided with sufficient information to complete the request for shortest turnaround time. • Provided weekend and on-call support and following strict SLA for incident closure. • Provided extra attention to ensure customer satisfaction and adhere to project timeline. • Reduced new starters training period by providing documents for repeat request and documenting recurring scenarios and possible solutions to enable independent learning and proactive approach. • Provided warranty support and smooth transition to customer as BAU activities.
• Provided enhancement featured to existing workflows to enable financial audit decisions. • Optimized the processing of workflow and enabled quicker availability of data for reporting • Gathered business requirements via stakeholder engagement and providing optimal solution for business stakeholders. • Reduced data redundancy in Pharmacy retailing and Caremark business by applying data warehousing concepts to normalise the huge dataset. Hence optimising date query performance. • Assisted with user acceptance and penetration testing to ensure Benefits Realisation Plan was satisfied against Requirements catalogue and Traceability Matrix. • Provided faster New patient subscription and optimized utilization of medicines and reduced prescription turnaround time. • Reduce performance of web-based application by 70% using SQL query optimisation.
Bachelor of Technology in Information Technology, Kerala University, India 2008
A level, CBSE, India 2002 GCSC, CBSE, India 2000
CERTIFICATES AND ACCREDITATIONS:
• Certified Tableau specialist from Tableau 2019
Additions interest: • Part of the yearly cultural program organization in Infosys • Member of the People for Animals club providing a helping hand for animal adoption drive and shelter maintenance • Active member of ‘Catch Them Young’ – inspiring school students on the importance of IT and professional career • Travel and exploring places of interest and experiencing the culture and food of different places.
