ARUNABH KALITA

adoxa4@r.postjobfree.com LinkedIn Cell: 902-***-****

PROFILE

An experienced business and data analyst with a passion for solving challenging analytics and data-centered problems. Applying my strong data management and visualization skills while working effectively with multiple teams and stakeholders to create data-driven solutions is what I love doing. Building strong stakeholder relationships through effective communication and being able to translate and simplify the data and technology lingo to business stakeholders are some of my key strengths. Being a technology enthusiast, I enjoy researching new tools and process improvements to keep myself motivated and inspired to grow and progress in my career. TECHNICAL SKILLS

Programming skills: SQL, Python, R Programming, Visual Studio, Hive Software Tools: Microsoft Excel, Tableau, Alteryx Designer, Visio, Datameer, Hadoop, Redshift, JIRA, Confluence, Microsoft SQL Server, SSMS, R Studio, Visual Studio, Collibra, IBM Information Analyzer, DataStage, GitHub

Certifications: Tableau Desktop Specialist

EMPLOYMENT HISTORY

Senior Analyst (FRDMO), RBC April 2021-Current

• Currently in charge of the Design and Architecture of all BI, visualization and data analysis projects at FRDMO (Finance and Risk Data Management Office).

• A people manager with two analysts in my team reporting directly to me to develop and deliver analytics solutions and dashboards for various internal teams and external stakeholders.

• Creating process flow and architecture diagrams, SLAs, OLAs as well as engagement models between different teams and stakeholders are also part of my responsibilities.

• Maintaining multiple Tableau Server sites and GitHub repositories for Tableau workbooks and SQL code packages for data warehouses and Hadoop Data Lakes.

• Managing multiple projects using JIRA boards using Agile Methodologies for the team and leading monthly Sprint Planning meetings.

• Working with counterparty data from multiple source systems to design data governance and data lineage standards involving key regulatory reports.

• Currently working on the development of an in-house centralized repository tool for storing and analyzing Data Quality rules in Hadoop Data Lake across enterprise-level at RBC.

• Successfully led multiple ETL teams in the migration of 11.7 DB2 server systems from 11.5 SQL server systems.

• In charge of managing unit testing, writing test cases and overseeing monthly Production Deployments.

Data Quality Reporting Analyst (USDO), RBC April 2019-April 2021

• Worked as the Lead Data Quality Reporting Analyst for the US Data Office at RBC under the Group Risk Management and Capital Markets portfolio.

• Lead the Reporting Services team from day one of the regional US Data Office team to provide analytical and reporting solutions to the internal teams and US regulatory bodies.

• Gathering requirements from multiple stakeholders, preparing design documentation for review and approval before developing the reports were part of my daily responsibilities along with preparing the technical and process documentation after the stakeholder signoffs.

• Designed and developed metrics-driven KPI dashboards for Data Quality, Data Completeness, Data Accuracy and Data Timeliness aspects of Regulatory Reporting by discovering the data trends and patterns of the respective data.

• Collaborated with the Data Controls and Data Architecture teams to develop the capabilities for the Collibra tool for metadata management and data governance.

• Worked with data from multiple key US Regulatory Reports for the FRB program involving loans, mortgages, counterparty and so on.

• Creating the complete SDLC documentation, Procedure documentation, Target Operating Models and RCSAs (Risk and Control documents) for the Reporting Services Team for the Internal Audit review was one of my key achievements for which I earned a quarterly award nomination.

• Was also responsible for mapping out data and system lineages and performing gap analysis for multiple data sets for various stakeholders.

• Used advanced SQL queries in SSMS to retrieve data files from source systems and analyzed the data and their relationships before storing them as tables and views on Database servers.

• Was responsible for maintaining and managing the data connectivity for the Hadoop Data Lake using Hive for analysis and reporting.

Business Intelligence Analyst, J.D. Irving July 2018-December 2018

• Worked as a business intelligence analyst for the Transportation and Logistics Division of J.D. Irving with the Railways and Trucking businesses.

• Used advanced analytics solutions to provide data insights to stakeholders while increasing their revenue and improving business processes.

• Was involved in multiple projects with the senior leadership for process improvements and change management for the existing processes.

• Worked on supply chain projects which have directly improved the process efficiencies while increasing the revenue based on the predictive models developed using Alteryx and Tableau.

• Was in charge of data integrity and data testing along with data blending from different data sources – the results of which were presented to the higher management in weekly meetings.

• Built predictive and forecasting data models to show expected revenue based on historical data using R, Python and Alteryx Designer.

• Used Alteryx Designer to build predictive workflows and Tableau dashboards to visualize the solutions for stakeholders and higher management.

• Worked with SQL and RDMS systems such as TMW, Intelex, HCM and SQL Server. Junior Data Analyst (Contract), Ubisoft Halifax January 2018-June 2018

• Worked on the telemetry and user data for the game ‘Tom Clancy’s ShadowBreak’ (Both IOS and Android).

• Developed reports and KPI analysis of the player game data using Redshift SQL and Tableau.

• Built predictive models in Python and R to predict player game behaviors and revenue increase which were presented and explained to the different teams in monthly meetings.

• Created and maintained Tableau dashboards for the Business Intelligence Team in Paris

(Ubisoft Mobile Headquarters).

• Worked with developers and testers for bug fixes verification and livestream play generation for the new updates.

• Part of the BI team for consumer and Market Analysis to provide business solutions to the Game Producers and Directors.

Predictive Analyst, SimpleBI July 2017-January 2018

• Worked with the CEO of the company on a predictive project using IBM Cognos Analytics, Power BI, Python and Docker containers to integrate the prediction model for the fashion apparel industry.

• Verified and validated the predicted data against the actual data using Microsoft SQL Server and presenting a detailed report about future fashion trends to the client. EDUCATION

Master of Science in Computing and Data Analytics

Saint Mary’s University, Halifax, NS 2016-2018

Bachelor of Technology, Software Engineering

SRM University, Chennai, India 2012-2016

ADDITIONAL EXPERIENCE

• Currently working on a Lean Six Sigma Project for process improvement.

• Currently undergoing advanced Collibra and DataStage trainings for data governance and data quality ETL processes.

• Presented new Tableau functionalities at two RBC’s Quarterly Tableau Developer’s Forum.

• Based on my research and recommendations, discussions have led the team to start using Tableau Prep and Alteryx Designer for data preparations.

• Preparing training documents and leading trainings for new joiners in the team at RBC.

• Recognized Tableau champion for RBC TUG and Tableau Doctor for the RBC Atlantic region.

• Developed automation tools for different teams using Python programming for BAU activities

Contact this candidate