An energetic, focused and result driven Data and BI Professional with 17+ years of experience in delivering complex data, reporting and migration projects through all the phases of software development cycle.
Proficient in data visualisation and stakeholder communication, coupled with strong analytical thinking.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work history
Technical Business Data Analyst
AXA XL - Contract
London, City of London
2022.01 - Current
Migration of Legacy Reporting from Cognos to Power BI , which requires deep understanding of the existing legacy Landscape and the new architecture.
Delivered complex reporting transformation and data migration projects .
Partnered with users to understand and define system requirements.
Practitioner of Agile methodologies using the scrum ceremonies to track progress, resolve impediments and tale collection decision.
Hands-on expertise in programming languages such as SQL in IBM Netezza, SQL Server for analysis of large data set to arrive at insights/views to prepare techno-functional documents for enhancing the data warehouse.
Co-ordination with the architects /BI Developers/Testers for successful delivery of the reports to business users.
Responsible to work closely with Product Owner to define Product Backlog and subsequent prioritization and refinement of backlog.
Demonstrated clear and effective verbal and written communication skills with both business and technical users.
Technical Business Analyst
AXA XL -Contract
London, City of London
2021.03 - 2021.12
Worked with the project team to understand the gap between the source and the target reporting systems , providing solutions to the data requirements and preparing mapping documents .
Worked with the business users to get the UAT scenarios and co-ordinate User Acceptance Testing .
Successfully delivered on tasks within tight deadlines.
QA Test Lead
AXA XL - Contract
London, City of London
2020.10 - 2021.03
Liaising with the project team to understand the functional requirements for the migration project.
Prepare Test Strategy and the Test Scenarios for testing the BI reports.
Prepare test estimates for the project.
Review the Test cases and Test results of the team and .
Coordinate with the Business users to validate the UAT scenarios.
Defect triage for UAT and SIT and Defect management through JIRA- follow up for defect closure.
Managed a team of 5 testers to manage their work, review the test results internally before passing it on to the business users.
QA Senior Test Analyst
Cognizant Technology Solutions for various clients
London, City of London
2016.09 - 2020.09
Liaise with the Business Analysts to understand the functional requirements and create Test Plans and Test Scenarios.
Liaise with the business owners to understand the user acceptance test requirements and agree on the UAT test scenarios.
Attend project stand up and provide daily status to the project team and highlight issues and risks proactively.
Plan and facilitate User acceptance testing and follow up the business stakeholders for business sign-off.
Defect management through JIRA- follow up for defect closure.
Prepare Test Summary Report.
Consistently met project goals by ensuring testing was prioritized for completion within each sprint.
QA Test Analyst
Cognizant Technology Solutions- Various Clients
London, City of London
2012.06 - 2016.08
Created Test Plans and Test Cases
Implemented Agile development methodologies.
Performed ETL testing: functional, E2E and Regression testing.
Defect triage and tracking.
Created detailed reports to communicate test results effectively.
Education
Bachelor of Engineering - Electronics & Communication
Calicut University
2002.09 - 2006.06
Skills
Programming Languages -SQL, Python
Database - IBM Netezza, MS SQL Server , Teradata , DB2, Oracle
BI Tools- Power BI , IBM Cognos, SAP Business Objects, QlikView, Vermillion, SAS Reports
ETL Tools - Informatica, BODS
Agile Practitioner ,
Test Management Tools - JIRA, HP ALM
Automation using Python
Database Tools - Coginiti Pro Aginiti Workbench , Microsoft SQL Server Management Studio, SQL Developer, Teradata SQL Assistant, Navicat for Postgres SQL
<ul><li>Roles and Responsibilities</li><li>Hiring and team building</li><li>Managing team’s career progression and performance reviews</li><li>Managing Performance improvement plan and firing</li><li>Mentoring</li><li>Product roadmap planning and execution</li><li>Accountability of the entire delivery execution including the risk mitigation planning.</li><li>Stakeholder management</li><li>Adhering to Apple Privacy and Security Guidelines for platform</li><li>Design and implementation of new architectures and solutions to manage all online services for AdXchange in Apple Ads.</li><li>Design and implementation of new architectures and solutions deliver Budget experimentation in Apple Ads</li><li>Design and implementation of new architectures and solutions to manage data for Ad Platform.</li><li>Creating and maintaining all the data and analytics and revenue pipelines for Ad Platforms</li><li>Driving the solution for data ingestions and data processing across Ad platform</li><li>Defining the Strategy for data governance and data access</li><li>Collaboration with business to deliver relevant data and insight for our strategy and decisions.</li><li>Managing storage, processing, copy/synchronization etc. appropriate to scale</li><li>Enabling machine learning and algorithm groups by proving them right frameworks and data</li><li>Advancing team’s design methodology and quality programming practices and evangelize those techniques across Ad platform.</li><li>Deliveries</li><li>Setup 8+ member team to design and deliver Budget Allocation and Budget experimentation.</li><li>Leading Ad Delivery services team, responsible for delivering various capabilities like query understanding, targeting, fraud etc.</li><li>Delivered and Lead Design for observability for budget, and data platform in Ad platform.</li><li>Setup 11+ members high performing team to handle various business needs such as analytics and micro services for Display Advertising as well as Data Platform</li><li>Instrumental in driving Data Platform throughout the SDLC from inception, design, development, testing and deployment.</li><li>Instilled a strong team culture of high-quality delivery by constructive feedback, cross collaboration, focus and motivation.</li><li>Delivered Realtime and Batch Platform with various integrations</li><li>Delivered new DIP design for Data Platform</li><li>Delivered design of all the components of Data processing platform</li><li>Transitioned Display data work to India seamlessly and delivered many critical business impacting features and organizational security initiatives.</li><li>Closely worked with various stakeholders to understand the requirements which resulted into efficient remote work culture.</li><li>Seamless Display execution and set up best practices for 24X7 production on-call.</li><li>Tools and Technologies</li><li>AWS, S3, Kafka, Spark, Hadoop, EMR, Hive, Scoop, Flume, Cassandra, Airflow, Oozie, Gobblin, Schema Store, Icloud, Grafana, Kubernetes, Vertica, Alation, snowflake, druid, Iceberg, Java, Scala, IntelliJ, Oracle, MySql, Git, RIO, Spinnaker, Elastic cache, Grpc, Agile.</li></ul> at Apple - Adplatform<ul><li>Roles and Responsibilities</li><li>Hiring and team building</li><li>Managing team’s career progression and performance reviews</li><li>Managing Performance improvement plan and firing</li><li>Mentoring</li><li>Product roadmap planning and execution</li><li>Accountability of the entire delivery execution including the risk mitigation planning.</li><li>Stakeholder management</li><li>Adhering to Apple Privacy and Security Guidelines for platform</li><li>Design and implementation of new architectures and solutions to manage all online services for AdXchange in Apple Ads.</li><li>Design and implementation of new architectures and solutions deliver Budget experimentation in Apple Ads</li><li>Design and implementation of new architectures and solutions to manage data for Ad Platform.</li><li>Creating and maintaining all the data and analytics and revenue pipelines for Ad Platforms</li><li>Driving the solution for data ingestions and data processing across Ad platform</li><li>Defining the Strategy for data governance and data access</li><li>Collaboration with business to deliver relevant data and insight for our strategy and decisions.</li><li>Managing storage, processing, copy/synchronization etc. appropriate to scale</li><li>Enabling machine learning and algorithm groups by proving them right frameworks and data</li><li>Advancing team’s design methodology and quality programming practices and evangelize those techniques across Ad platform.</li><li>Deliveries</li><li>Setup 8+ member team to design and deliver Budget Allocation and Budget experimentation.</li><li>Leading Ad Delivery services team, responsible for delivering various capabilities like query understanding, targeting, fraud etc.</li><li>Delivered and Lead Design for observability for budget, and data platform in Ad platform.</li><li>Setup 11+ members high performing team to handle various business needs such as analytics and micro services for Display Advertising as well as Data Platform</li><li>Instrumental in driving Data Platform throughout the SDLC from inception, design, development, testing and deployment.</li><li>Instilled a strong team culture of high-quality delivery by constructive feedback, cross collaboration, focus and motivation.</li><li>Delivered Realtime and Batch Platform with various integrations</li><li>Delivered new DIP design for Data Platform</li><li>Delivered design of all the components of Data processing platform</li><li>Transitioned Display data work to India seamlessly and delivered many critical business impacting features and organizational security initiatives.</li><li>Closely worked with various stakeholders to understand the requirements which resulted into efficient remote work culture.</li><li>Seamless Display execution and set up best practices for 24X7 production on-call.</li><li>Tools and Technologies</li><li>AWS, S3, Kafka, Spark, Hadoop, EMR, Hive, Scoop, Flume, Cassandra, Airflow, Oozie, Gobblin, Schema Store, Icloud, Grafana, Kubernetes, Vertica, Alation, snowflake, druid, Iceberg, Java, Scala, IntelliJ, Oracle, MySql, Git, RIO, Spinnaker, Elastic cache, Grpc, Agile.</li></ul> at Apple - Adplatform