Shubhadeep Chakraborty
Drayton Valley
Summary
Experienced product manager with a successful track record in leading teams throughout the software development life cycle (SDLC). Proficient in Agile and Waterfall methodologies, adept at adapting to project requirements. Skilled in utilizing SQL stored procedures and data tables to create tailored business intelligence (BI) reporting solutions. Expertise includes developing automated and optimized processes to create business value for stakeholders. With over 11 years of experience, excels in creating data models, designing entity relationship diagrams, and maintaining data dictionaries. Committed to ensuring data capture efficiency by eliminating redundancies.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Senior Business Analyst
Acturis Private Ltd.
03.2020 - Current
- Managed stakeholder expectations through transparent communication and timely status updates, ensuring alignment between project deliverables and business objectives.
- Leading a team of three members to design and implement new insurance products for both personal and commercial insurance, managing 5 separate product design projects in concurrence
- Implementation lead for major updates to broker products for multiple large broker implementations
- Led the implementation of more than fifty product changes, improving quoting and electronic trading capability by 26%
- Coordinated User Acceptance testing with brokers, ensuring defect resolution within 4 days on average
- Organized product implementation, and supported broker go-live for 35 broker offices and 678 brokers at one go
- Contributed to the development of client relationships that led to growth of broker clients using Acturis platform from 75 users to 4500 users over 4 years
- Engaged with prospective clients for future product collaborations, providing product demonstrations and work with clients to scope out the implementation work involved
- Product lead for implementing electronically traded home insurance policies with three large insurers (SGI, Wawanesa and Definity)
- Developed strategic roadmap and led technology implementation of APIs for direct insurer integration
- Led process mapping initiatives, resulting in optimized workflows such as designing and implementing solution to quote, bind and perform term adjustments electronically in real time on policies, which reduced redundancies across departments.
- Reduced lead time in binding a home insurance policy from 24 hours to 15 minutes
- Implemented a solution to have electronically traded commercial package insurance policies that can be bound in real time
- This has led to a 122% increase in policies being bound by the insurers
- Worked with clients to create a new API integration, supporting real time exchange of information through XMLs to provide insurers with requisite client information and allowing for the real time issuance of insurance policies
- Worked with a team of 20 developers and software architects to establish a completely new instance of database infrastructure for Acturis’ Canadian clients, allowing for compartmentalization of data, and greater data security as per Canadian data privacy standards
- Mentored junior analysts on best practices for business analysis techniques, fostering professional growth within the team.
Independent Contractor
Utilities Industry
01.2019 - 10.2019
- Created automated services using UIPath bots to automate report generation for the client Tax Services to help the team to reduce work effort by 1500 hours per year
- Worked with business users to understand requirements, and developed technical specifications, designed and developed technical solution, worked with business users to test the final product and finalize transition to users with required documentation and support manuals
- Created and managed project plans, timelines and budgets.
Lead Onsite Consultant
Deloitte Consulting LLP
07.2011 - 10.2017
- Guided a team of developers to develop applications to help automate accounting system data management, with automated report creations, and new applications to help provide additional data to portfolio managers for their trading analysis using UIPath tool
- Led a team to migrate source data for an accounting system from Oracle to Microsoft SQL database, creating new data models for database tables, planning data loads through Informatica and Business Intelligence reports utilizing PowerBI and SSRS
- Created and maintained over 300 different ETL processes for handling data transformation including using Stored Procedures, Java, Webservices and Rest API calls to handle data warehousing and business intelligence reporting requirements
- Integrated parsing of data from websites and email reports to collate information into data warehouse, managing up to 200 attributes of data in single workflows, as well ensuring storage of data on a cloud architecture
- Created data dictionaries, worked with solution architects to create handbooks for business users, creating technical specifications and mapping documents for developers, and assisted in system and user-acceptance testing and defect resolution
- Created new ETL solutions to integrate a trading application with automated trade placement system, using SSIS, SQL and Oracle databases and automated scheduling through Tivoli
- Enhanced capabilities of existing trading system SSIS applications to perform automated trade reporting to accounting systems reconciliation platforms, ensuring lesser errors
- Recommended technical solutions to improve efficiency and reduce errors while performing reconciliation activities between trading platforms, accounting systems and recording ledgers
- Helped develop complex Informatica workflows to implement quantitative trading strategies for organization, ensuring that all required technical risk parameters are met
- Increased productivity with strategic assessment and planning.
Education
Bachelors in Technology -
Indian Institute of Technology
06.2011
Skills
- Technology - XML, SQL proficiency, Oracle DB, PowerBI, Microsoft Visio, ETL tools - Informatica, SSIS SAP - BPC, SAC, Tivoli Workload Scheduler, Service Now, JIRA, Bamboo, Bitbucket, Confluence, Tableau, Alteryx, UI Path - RPA, Qlikview
- Industry Skills - Insurance Products, Assets Management, Market risk Analysis, Derivatives, Financial Modelling, Forecasting, Business process mapping, Agile and Waterfall - SDLC Model,
- Business process improvement
- Data analysis expertise
- KPI tracking
- Cost-benefit analysis
- Business intelligence tools
- IIBA methodologies
- Data mining
Accomplishments
- Achieved Acturis Canada platform growth from 75 users to 4500 users in 5 years through effective product development, seamless platform enhancements, and strong customer support. This expansion was driven by a focus on customer needs, creating a user-friendly experience, and fostering long-term partnerships with key stakeholders.
- Implemented product enhancement which led to the ability to quote and bind a commercial or personal line of insurance within 15 minutes, compared to the previous 24 to 48 hours, greatly improving operational efficiency.
Certification
- UIPath certified for Robotic Process Automation Implementation and Business Analyst
- Automation Anywhere certified RPA Analyst
- Subject Matter Expert – Financial Service Industry – Deloitte Consulting Ltd. 2013
Timeline
Senior Business Analyst
Acturis Private Ltd.
03.2020 - Current
Independent Contractor
Utilities Industry
01.2019 - 10.2019
Lead Onsite Consultant
Deloitte Consulting LLP
07.2011 - 10.2017
Bachelors in Technology -
Indian Institute of Technology
Similar Profiles
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
Andrea BrownAndrea Brown
Elderly Caregiver at Private Caregiver i a private homeElderly Caregiver at Private Caregiver i a private home
NITIN GUPTANITIN GUPTA
Senior Area Sales Officer at Indiannica Learning Private Limited (Formerly Known As Encyclopaedia Britannica India Private Ltd)Senior Area Sales Officer at Indiannica Learning Private Limited (Formerly Known As Encyclopaedia Britannica India Private Ltd)