Umesh Nair

Data Analyst

Cisco Systems•  November 2019 - August 2022

Analyzed registration and attendance data of company’s past events to understand attendee interests and behavior, perform audience segmentation based on attendee’s common interests, creating dashboards in Domo to visualize results and present insights to business, to help market relevant and curated content to customers for future events and plan the release of on-demand demo sessions. Key Activities Performed: • Regular interactions with business to understand their analytics requirements and data problems. • Built multiple cards and dashboards in Domo and Tableau so that business can seamlessly navigate between charts, garner insights, or review past performance, and then formulate their marketing strategies. • Used Python packages to develop ETL pipelines which could efficiently extract, store, clean and transform the data from multiple diverse data sources like Oracle, Snowflake databases and CSV files into a single data warehouse. • Implemented various unsupervised learning(clustering) algorithms like MiniBatch KMeans, Agglomerative clustering and DBSCAN using scikit learn(sklearn) package in Python to find groups of attendees with similar interests and behavior. • Performed audience segmentation of the cleaned events attendance data using machine learning techniques like clustering, after correlating the event attendees to the account segments, to answer questions like: 1. what proportion of the existing client customers, belonging to different segments, attends the event? 2. how many more potential customers are available for marketing of future events? 3. how event topics/content drives attendee participation, and what content appeals to different market segments? • Present the findings and dashboards to business, along with providing support and maintenance. Technology/Skills/Tools Used: • Tools: Jupyter Notebook, Domo, Tableau • Technologies: Python, Snowflake db • Workflow management: Kanban • Skills: Analytics, Machine learning, Data visualization

Software Test Analyst

Mastek Ltd.•  July 2012 - July 2017

The project I was part of dealt with providing Data warehousing and BI solutions to Morrisons PLC, one of the leading supermarket chains in the UK. Domain: Retail Technologies/Tools Used:- SQL, PL/SQL, Oracle Data Integrator(ODI), OBIEE, SQL Developer, HP Quality Center, HP Service Manager, WinSCP, AppWorx Responsibilities:- ▪ Analyzed large data sources to uncover trends or scenarios that are rare occurrences and can cause the data transformation and loading(ETL) to fail. ▪ Coordinate with Business analysts to understand the client requirements, interpret the data, and design test cases and define test acceptance criteria. • Designed and developed test cases to verify the integrity of 40 data models feeding inventory data mart. • Developed and Tested 80+ ETL ODI pipelines, load plans and OLAP cubes to ensure the functional validity of data migration life cycle. • Created test data for ETL mapping’s and BI reports to test and validate their functionality. ▪ Tested and analyzed various static and ad-hoc reports and dashboards in OBIEE. • Implemented and automated SQL queries to analyze high volumes of data in production database, aiding regression testing and enabling 100 % test coverage. • Communications with client regarding scope, requirements, test strategy, and planning exit criteria for multiple development releases. • Collaborated with development and support teams to analyze and resolve 100+ Live defects in an Agile setup. ▪ Trained new team members to make them understand the retail domain and project requirements, and guiding them as and when necessary.