Job Search Status
Open to workDesired start date: Immediately
Open To Work
Supriyo Banerjee
Senior Data Engineer and Data Architect
Springboro,OH
Work Preference
Summary
Experienced business intelligence analyst skilled in transforming data into strategic insights. Leveraged AI solutions to enhance applications related to 7-11 store construction invoicing and billing processes. Created over 100 Tableau dashboards, leading to significant cost savings and increased operational efficiency. Acknowledged for innovative approaches in various industries, including healthcare and retail.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Sr. Software engineer
7-11
Enon, OH
02.2025 - Current
- Utilized AI tool Windsurf to debug issues and re-engineer applications, enhancing overall application performance.
- Debugged functional and database-related issues, implementing permanent resolutions to improve reliability.
- Reengineered tables, views, and stored procedures to optimize database performance and efficiency.
- Addressed and resolved more than 350 user issues in last year.
- Conducted DB and application-level audit reports to meet compliance goals.
- Took over the management of construction and invoice-related applications from third-party vendors.
Data Architect
Kaleida Health
Buffalo, NY
01.2018 - 12.2024
- Developed analytical models, data marts, and dashboards that enhanced decision-making and improved service efficiency for over 10K patients daily.
- Managed architecture, clustering, and resizing of Tableau Server to optimize performance and streamline operations.
- Implemented solutions to oversee Tableau Server operations, reducing the need for additional software purchases.
- Delivered in-house Tableau training for over 100 executives and analysts, reducing reliance on external training resources.
- Analyzing different business processes to design decision support systems. Integrated Financial, Surgical, Clinical, Billing, Revenue Cycle, Staff monitoring and Payroll systems in one Enterprise and Data Management Platform saving more than 500k per annum spent on third party contractors.
Tableau Admin and Production Support Lead
LEXIS NEXIS
Dayton, OH
04.2016 - 11.2018
- Managed Tableau architecture and upgrades, optimizing reporting capabilities across the organization.
- Configured Tableau server processes to tune server performance.
- Developed over 100 Tableau reports and dashboards, improving visibility into key business processes.
- Created reports in Power BI and Tableau to build KPIs and reports to stop fraudulent transactions saving more than 50k annually.
- Maintained and monitored production environment, resolving issues to ensure uninterrupted service.
- Worked with a team of developers to design, develop, and implement a BI solution for Sales, Product, and Customer KPIs.
- Converted existing BO reports to Tableau dashboards.
- Developed solutions to trigger ETL batch jobs from Tableau dashboards and reports.
- Conducted in-house training on BO and Tableau for more than 70 designers and analysts.
Business Intelligence (BI) Technical Lead
ANTHEM BLUECROSS AND BLUESHIELD
Mason, OH
01.2014 - 03.2016
- Designed a complex reporting solution over the Oracle Revenue Management Billing System.
- Converted BO reports into Tableau dashboards to enhance data visualization and accessibility.
- Managed Tableau Server tasks, including installation, upgrades, and backup procedures.
- Analyzed key business functionalities and collaborated with system analysts to gather and clarify requirements.
- Supported testing efforts and fine-tuned solutions to ensure alignment with business needs.
Business Objects Lead
EXPRESS SCRIPTS
St. Louis, MO
02.2012 - 01.2014
- Designed and developed intricate reports using SAP BO 4.0, showcasing expertise in data modeling.
- Analyzed supporting database schema, identifying optimization opportunities to enhance performance.
- Monitored daily business processes, utilizing KPI analysis and dashboard design to provide actionable insights.
- Contributed to software development lifecycle, ensuring alignment with project goals and timely delivery.
Business Objects Lead
ANTHEM BLUECROSS AND BLUESHIELD
Hamden, CT
01.2010 - 02.2012
- Analyzed key business functionalities and collaborated with teams including billing, claims adjustment, revenue cycle, and HR to gather requirements and drive project alignment.
- Designed a complex reporting solution and developed more than 60 reports and KPIs.
- Participated in testing efforts and refined solutions to ensure accuracy and effectiveness.
- Administered Tableau Server tasks, managing access, alerts, upgrades, and backups to ensure optimal performance and security.
Business Objects Lead
HEALTHNET
Kolkata, India
01.2009 - 01.2010
- Developed Claim Sphere, a new reporting solution for analytical and operational reporting.
- Evaluated business processes and KPIs to inform design of analytical dashboards.
- Facilitated user acceptance testing for offshore teams to ensure solution alignment with requirements.
- Developed comprehensive test cases for system, regression, and integration testing to validate functionality.
Business Objects Developer
FIRST DATA CORPORATION
Kolkata, India
10.2008 - 01.2009
- Migrated reporting schema, repository, reports, metadata, groups, and users to new environment, ensuring data integrity.
- Evaluated reporting frameworks and identified areas for enhancement.
- Coordinated testing processes and updated SDLC documentation to reflect changes.
SQL Developer
AVIS
Parsippany, NJ
05.2008 - 10.2008
- Optimized query performance to enhance system efficiency and reduce response times.
- Analyzed queries and resolved problems, improving data accuracy and system reliability.
- Developed complex functions and stored procedures to support application requirements.
- Conducted UAT and regression testing to ensure software quality and user satisfaction.
Informatica Developer
AZTRA ZENECA
Wilmington, DE
09.2007 - 05.2008
- Designed data warehouse and developed more than 40 ETL processes to clean and load data from different sources like operations, billing, HR, budget, lab tests etc. to warehouse.
- Collaborated with cross-functional teams to gather requirements for data mart setup, ensuring alignment with business needs.
- Conducted user acceptance testing to validate system functionality, confirming it met specified user requirements.
C/C++ Programmer
WYNDHAM
Kolkata, India
02.2007 - 09.2007
- Developed functional modules for air ticket reservation system, enabling seamless booking across 80+ countries.
- Developed software applications to enhance operational efficiency at hospitality venues.
- Maintained and updated existing codebase to ensure system reliability and performance.
- Conducted user acceptance testing and prepared software development lifecycle documentation to ensure project alignment with requirements.
- Collaborated with cross-functional teams to design user-friendly digital solutions.
Education
Master of Science - Computer Applications
Visvesvaraya Technological University
Belgaum, IndiaBelgaum, India
Bachelor of Science - Chemistry
Calcutta University
Kolkata, IndiaKolkata, India
Skills
Tableau management and administration
AI-driven analytics solutions
Data analysis techniques
SQL development and scripting
Power BI expertise
Performance tuning for queries
Training in Tableau software
Dimensional data modeling
Business technology translation
Reporting on environment migrations
Effective interpersonal communication
Informatica proficiency
PostgreSQL database management
Business intelligence applications
Certification
- Tableau Desktop Qualified Associate
- Tableau Specialist
Timeline
Sr. Software engineer
7-11
02.2025 - Current
Data Architect
Kaleida Health
01.2018 - 12.2024
Tableau Admin and Production Support Lead
LEXIS NEXIS
04.2016 - 11.2018
Business Intelligence (BI) Technical Lead
ANTHEM BLUECROSS AND BLUESHIELD
01.2014 - 03.2016
Business Objects Lead
EXPRESS SCRIPTS
02.2012 - 01.2014
Business Objects Lead
ANTHEM BLUECROSS AND BLUESHIELD
01.2010 - 02.2012
Business Objects Lead
HEALTHNET
01.2009 - 01.2010
Business Objects Developer
FIRST DATA CORPORATION
10.2008 - 01.2009
SQL Developer
AVIS
05.2008 - 10.2008
Informatica Developer
AZTRA ZENECA
09.2007 - 05.2008
C/C++ Programmer
WYNDHAM
02.2007 - 09.2007
Master of Science - Computer Applications
Visvesvaraya Technological University
Bachelor of Science - Chemistry
Calcutta University