Cyriac Mathew
QA Test Lead
Summary
- 14 years of extensive experience in Business Intelligence and Data Warehousing solutions.
- Skilled in Qlik, Power BI, Tableau, Power Platform, Google Cloud, Hadoop and Big data.
- Strong business development professional with a Master of Science - MS focused in Database Management and Business Intelligence from Boston University.
- Worked on complex data flows and high-end dashboards for senior stakeholders Participating in requirement gathering, clarification, wireframes and analysis and creation of business requirement document
- Well versed with Dimensional Modeling
- Involved in gathering requirements from customer, preparing the design documents, data lineage and architecture Optimized Solution design and User adoption.
Overview
17
17
years of professional experience
3
3
Certifications
Work History
iGATE Global Solutions
Bangalore
Test Lead/Solution Architect
Vodafone, Vodafone Intelligent Services
12.2018 - Current
- Project: Multiple Projects
- Vodafone is a global telecom company having operations across 26 local markets around the world
- Vodafone Intelligent Services is a function with in Vodafone to provide business intelligent and automation services to various local market and Vodafone group
- I am currently working as a QA Test Lead
- In this role, I am architecting visualization solutions using various tools such as Qlik Sense, Tableau and Power BI
- We are providing a stack of tools and based on the customer requirements the tool is being selected
- Responsibilities:
- Be a single point solution to all data and visualization technical needs for a strategic program
- Design complex solution that leverages and extend capabilities provided by the various tools
- Provide technical leadership and consulting on various tools to various stakeholders that include development teams, business leads and analysts, Enterprise architects and Senior management
- Compare various tools and technologies and suggest to the Customer based on the requirements
- Set standards and best practices to be followed to improve efficiency and performance of visualization area for the development team to adhere to
- Take necessary steps to improve the user adoption
- Leading the Visualization COE
- Hosting fortnightly tech sessions
- Providing consulting services to other Vodafone entities,
- Develop POCs and internal dashboards for quick wins
- Environment: QlikView, Qlik Sense, Tableau, Power platform, GCP, PEGA
- Key Projects:
- Current Project: After my Google Cloud Architect Certification, I got a chance to be a part of the ‘Nucleus’ Project which is a powerful integrated data platform with the capability of processing and moving huge volume of data globally from multiple systems into the cloud
- I am working as a Solution architect to design the data management flows as well as the data reporting
- Data movement from on premise to cloud is handled by Dynamo
- Then the data is stored into Google Cloud Storage buckets as a staging layer
- From GCP buckets the data is getting transformed using
- Data Fusion and stored into Big Query tables for analytics and insights generation
- GCP version of the open-source tool Airflow is managing the orchestration and composing of the flows
- The Data lineage and cataloguing is managed by Collibra
- Finally, the reporting and dashboarding activities are carried out using Qlik Sense
- The DevOps activities are performed using the CI/CD tools such as Jenkins, Vault and Nexus
- IView 360 - Qlik Sense
- C2 General iView 360 is the name of the platform where all the visualization solutions are hosted
- This project helps various stakeholders to track the user adoption of various data products
- This tool also helps to understand the metadata associated to various dashboards hosted in various platforms such as AWS, GCP and ONPREM
- A star schema built with a central fact table talks about the measures such as active users, registered users, No of Exports, No of Sessions and Target Users
- The various dimension tables are: Application Master, User
- Master, Export Master and Calendar
- Row level and column level security implemented in such a way that the respective dashboard owners can view the data related to the corresponding dashboard
- Order and Shipment Monitor – Tableau
- Vodafone procurement company is a supply chain organization within Vodafone, wants to track the On Time shipments of the various products to the customers
- A shipment can be
- Early, On Time or Late
- This dashboard also tells the impact of Late shipments on the
- Gross Revenue of some of the top customers
- Enterprise Planning App – Qlik Sense
- This apps helps the Vodafone Kenya local market to get a 360-degree view of the customers
- Data sourcing from Teradata DW, holding more than 330 M records for the last 12 months
- The fact table talks about the measures such as 12 Month Rolling Revenue,
- Data Usage, Voice Usage, Data Roaming, Voice Roaming etc.… These measures can be analyzed in terms of parent customer accounts, the associated child customer accounts,
- Customer Name, Regions, Segment, Plan type and for the various months in last 12 months
BI Specialist
Tata Consultancy Services, EATON Corporation
, Ohio
01.2011 - 11.2018
- Project: Multiple Projects
- Eaton is a multinational power management company operates through various segments such as
- Electrical, Hydraulic and Mechanical applications
- I was working as a BI Specialist with EATON from Tata consultancy services as a consultant
- In this role, I was providing visualization and data solutions using various tools such as QlikView,
- Qlik Sense, Cognos, Tableau, Informatica and data stage
- Responsibilities:
- Provide first line data visualization development and support
- Trouble shoot and test visualization applications
- Design, implement, test and support reports and dashboards within the agreed SLA
- Manage product releases and deployment of applications
- Implement fixes and enhancements to production applications
- Support interactive visualizations end to end from data ingestion, ETL and front-end functionality
- Environment: QlikView, Qlik Sense, Tableau, Cognos, Informatica, Data Stage
- Key Projects:
- Materials Planning Monitor - Qlik View
- C2 General
- Materials Planning Monitor helps the plant managers to get the insights on the on-hand inventory, obsolete items, items with high demand, comparison between the actual volume vs the estimated volume from various demand forecasting systems etc
- Bill of Materials – Cognos
- Bill Material Report is a report built in Cognos which shows the exploded version of the bill of material
- The data was sourcing from an MFG Pro instance
- Realized Cost Index Monitor – Qlik Sense
- Realized Cost Index is calculated by comparing the price for an Item vs the Cost for that
- Item
- This metric helps the plant manages to identify the non-profitable items in the inventory
QlikView Developer
GE HealthCare
Chicago
05.2010 - 01.2011
- Project: Multiple Projects
- GE HealthCare is a multinational healthcare company provides healthcare solutions to hospitals and health systems across the world
- I was working as a QlikView developer with GE HealthCare from iGATE Global Solutions as a consultant
- In this role, I was developing dashboards and reports using the BI tool QlikView
- Responsibilities:
- Involved in requirements gathering, data analysis, UAT, Production stages and the user training of project
- Optimized the application for better performance using QVDs
- Participated in scheduling the workflows, UAT, Bug fixes, which got in UAT
- Experienced in adding security sections, column level security etc.…
- Implemented various business functionalities like market basket analysis, box plots etc.…
- Environment: QlikView, VBA, VBS
Technical Analyst
Palash Consultancy Services
05.2007 - 04.2010
- Project: Multiple Projects
- I was the first employee of Palash Consultancy Services in Bangalore
- I joined as Qlik developer with Palash helping Palash Sales team to get business by designing and developing POC dashboards using QlikView
- I travelled across India and UK to provide consultancy services to various Palash customers
- Lot of innovative solutions created by leveraging the Qlik Engine API capabilities using
- VBA
- Created mashups which contains the embedded Qlik reports in Web pages
- I gave training to corporate customers in QlikView
- I was a part of more than 500 POCs
- Responsibilities:
- C2 General
- Creating POCs
- Corporate Customer trainings
- Involved in requirements gathering, data analysis, UAT, Production stages and the user training of project
- Optimized the application for better performance using QVDs
- Participated in scheduling the workflows, UAT, Bug fixes, which got in UAT
- Experienced in adding security sections, column level security etc.…
- Creating mashups
- Environment: QlikView, VBA, HTML, CSS, JavaScript
Software Engineer
Srishti Software Applications Ltd
05.2005 - 10.2006
- Various Projects
- Responsible in Requirement Analysis, Development, Testing and Maintenance related activities of various projects
- Got good exposure to learn and work in the different phases of SDLC in multiple projects
- Worked on the development and testing of different modules in the Bank Master application for the client - Misys
- Got a chance to work on technologies like s25, COBOL, shell scripts, etc
- Worked on the development and testing of the Web Monitoring system created for the VNU,
- UK
- The technologies used were PHP, Nagios plug-in, MySQL, JS, HTML, CSS, etc
- Worked on different internal systems created for Srishti
- Technologies got used while working for these applications are Java, Struts, HTML/CSS, JavaScript, XML/XSLT, etc
- Received appreciations for scaling up quickly and taking up extra modules after having completed the assigned modules before time
- Environment: Java, Struts, MySQL, JavaScript, Html, CSS, PHP, Shell Scripts, etc.
Education
TOGAF -
The Open
Professional Cloud Architect from - undefined
Google Cloud
Nano degree - Visualization Udacity
Master - Intelligence
Villanova University
Certificate in Business Intelligence - Certified Professional in Business Intelligence (CPBI) - Technology
Villanova University
Master of Science - Computer Information Systems, Database Management and Business
Villanova University, Boston University
12.2013 - 01.2013
undefined
Bachelor of technology - Information Technology
Cochin University of
science and technology
IHRD College of
Engineering Poonjar
Skills
TECHNICAL SKILLSOperating Systems : Windows, LinuxPrimary Skills : Qlik Sense, QlikView, Tableau, Power BI, Power Apps, VizLibCloud Technologies : GCP, Cloud Storage Buckets, Big Query, Data FusionProgramming Languages : JAVA, C#net, VBA, VBS, JavaScript, SQLStatistical Analysis Tools : RDatabase : Oracle, SQL Server, Snow Flake, MongoDB, HBase, MS AccessC2 GeneralBig Data Technologies : Hadoop, Pig, Hive, Flume, Sqoop, Oozie, ZookeeperTools& Utilities : WEKA, Erwin Data Modeler, Remedy, JIRA, ConfluenceDomain Knowledge : Supply Chain, Telecom, Banking, Finance and Risk managementProcess Mining
Certification
Certification Name University Year of Passing
Timeline
Test Lead/Solution Architect
Vodafone, Vodafone Intelligent Services
12.2018 - Current
Master of Science - Computer Information Systems, Database Management and Business
Villanova University, Boston University
12.2013 - 01.2013
BI Specialist
Tata Consultancy Services, EATON Corporation
01.2011 - 11.2018
QlikView Developer
GE HealthCare
05.2010 - 01.2011
Technical Analyst
Palash Consultancy Services
05.2007 - 04.2010
Software Engineer
Srishti Software Applications Ltd
05.2005 - 10.2006
iGATE Global Solutions
TOGAF -
The Open
Professional Cloud Architect from - undefined
Google Cloud
Nano degree - Visualization Udacity
Master - Intelligence
Villanova University
Certificate in Business Intelligence - Certified Professional in Business Intelligence (CPBI) - Technology
Villanova University
undefined
Bachelor of technology - Information Technology
Cochin University of
science and technology
IHRD College of
Engineering Poonjar