Nabina Roy

Plainsboro, New Jersey • +1-947-***-**** • ad2ygp@r.postjobfree.com

Exceptionally well organized, resourceful and highly motivated with the ability to handle multiple projects and produce timely, high-quality work.

Strong analytical and human relations skills; especially effective in helping customers and associates resolve issues and concerns.

8+ years’ experience in Data Analysis and Modelling using BI Tools

6+ years’ experience in Data cleaning, processing and ETL using SQL and PL/SQL.

Involved in all phases of SDLC from analysis, Design, Development, Testing, Implementation and maintenance with timely delivery against aggressive deadlines.

Experience with Data flow diagrams, Data Dictionary, Normalization, ERD modelling and design techniques.

Strong hands-on experience implementing dashboards, data visualizations and analytics using Tableau desktop, Tableau Prep.

Experience in scheduling and managing extracts using Tableau cloud and Tableau Bridge.

Expertise in building KPI dashboards for performance enhancements.

Expertise configuring Repository and creating Physical, Business and Presentation Layer.

PROFESSIONAL EXPERIENCE

Freezpak Logistics Mar’23-Current

Data & Reporting Analyst

Work with CEO and Warehouse director to identify KPIs and build dashboards.

Work with Finance team (AP/AR) to identify KPIs and build dashboards.

Build data relationship diagrams, documents.

Need to do a lot of data analysis using Microsoft SQL server studio for building queries to be used for reports as requested on warehouse operations, inventory etc.

Created Executive dashboard, Warehouse Operations KPI dashboard and Labor tracking Dashboards all using tableau 2023.1.0 and Tableau Prep 2023.1.0 as of now.

Work on existing Reporting system to support existing reports.

Providing User Support and setting up user access based on role.

Work on WMS software ABECAS to understand existing business.

Every alternate day meeting with CEO and other stakeholders for the status update.

British Telecom, TCS July’18-Oct ‘22

Lead Data Analyst

Analyzed all UK Wholesale Service Providers data to identify monthly active users and churned customers and churned pattern to guide on strategies to control churning rate. Enablement of which increased customer retention for few of the Wholesale accounts by 20-30%.

Designed reports for Revenue Prediction using Tableau.

Monthly analysis of reconciliation data of different data feeds from various sources.

Daily/Monthly generation of Usage Reports Using Tableau and analysis of usage difference.

Analyzing new product survey data to strategize on products (Broadband/SMS/Voice etc.).

Analyzing usage history data of customer to identify on upcoming Data/Voice/SMS plans.

Maintaining all reporting repository and responding to reporting anomalies.

Regular Business SME connects on new requirement and analysis of requirements.

Creating and presenting stories for business trend analysis to Business using Tableau.

Tracking delivery sprints right from design to delivery in each step and provided regular updates to business owner.

Created more than 10 visually appealing dashboards with different actions using filters, parameters, URLs etc.

Used Drill down Bar and Donut charts, Pie, Gantt, Bullets, Heat Map etc. along with other mostly used charts to create dashboards.

Used dynamic sheet swapping technique for

Created high end User manuals for each of the Dashboards being created providing details of the visualizations present.

Used MS Excel, Word, PowerPoint to analyze, prepare and present data to the management team.

Actively tracking schedule, clear and crisp communication with key stakeholders to keep everyone on the same page.

British Telecom, TCS Jan’14 – Jun’18

Data Designer

Gathered Business requirements, Interacted with End Users, SMEs, Architects to understand the business process.

Worked with DBAs to design Physical and Business data Model and workflows to match with the requirements.

Created Technical Specification documents detailing the data models and different KPIs to be captured in dashboards.

Extracted Call Detail Record (CDR) from landing directory using Node chain process.

Transforming and processing CDR data for calculations and loading into Database tables for aggregations.

Designed robust data models as backbone of impactful Reports using Tableau and SQL.

Maintenance and Monthly backup of database tables.

AEGON Insurance, TCS Oct’08 – Dec’13

SQL Developer & Analyst

Analyzed questions from lead analysts in team using SQL queries.

Designing Database Tables, Views, Materialized Views.

Developed Stored Procedures, Scripts, Packages for Data Modelling using PL/SQL for integration with other applications.

Analyzed existing SQL queries for performance tuning.

Extensive testing of Database objects.

Provided customer support for user issues.

PROFESSIONAL CERTIFICATION

Tableau Desktop Specialist

Professional Scrum Master 1

Oracle Certified Associate

Oracle Certified Professional

EDUCATION

Bachelor of Technology (Computer Science) 2008

West Bengal University of Technology, India

SKILLS & OTHER

Data Cleaning

Data Preparation

Data Visualization and Reporting (Tableau)

Business Solution Design

Data Modelling

Database – Oracle - 12c, 11g,10g, MS SQL Server management studio 19

Language – SQL, PL-SQL

Applications – Google BigQuery, Oracle APEX, MS Word, MS Excel, Outlook, PowerPoint.

Contact this candidate