Experiences

BFSI Digital Sales Transformation for a leading UK Insurance Company
Tata Consultancy Services, Kolkata
Oct’19 – Sep’20
Business Analyst
Primary objective is to transform legacy system to digital system for Banking, Financial and Insurance services.
Functional Stack: TCS BaNcs
Requirement Gathering & User Story Management
• Creating a detailed business analysis, Outlining problems, opportunities and solutions for a business
• Defining business requirements and reporting them back to stakeholders
• User story creation
Credit Risk Analytics for a leading Credit card provider
Tata Consultancy Services, Kolkata | Apr’19 – Sep’19
Data Analyst
The primary objective is to identify the right customers using predictive models. Using history data, need to determine the factors affecting credit risk, create strategies to mitigate the acquisition risk and assess the financial benefit of the company
Technology Stack: R, dplyr, tidyr, ggplot, caret, randomForest, e1071, MASS
Data Analysis and Recommendation:
• Steering rapid model creation in R by deploying dplyr, tidyr, ggplot, caret, random forest, e1071 and MASS
• Deploying Random forest model on balanced data to optimize evaluation statistics
• Designing Application Scorecard to predict customer’s behavior and provide financial benefit assessment
Key Achievements
• Led , Trained and mentored a team of 4 Data Analysts
• Minimized the net credit Loss based on Based on Profit and Loss perspective
• Application scorecard is used for determining desired tradeoff between risk level and approval rate
• With suggested cut-off score of 359, more than 80% of applicants would be approved
Project Revenue and Performance Analytical Dashboard for a Telecom company of United Kingdom
Tata Consultancy Services, Kolkata
Oct ’16 – Mar’18
Solution Designer
Objective to design and develop analytical reports and dashboards to highlight project revenue and performance for the financial year
Technology Stack: OBIEE, Oracle 11i, SQL, Power BI
Solution designing, Stake-holder management and Data Visualization:
• Interacted closely with 4 business users and transformed functional journey to technical design
• Provided technical expertise on data storage structures, data mining, and data cleansing
• Managed and designed the reporting environment, including data sources, security, and metadata
• Led the multi-vendor development team and delivered various analytical reports and dashboards
Key Achievements
• Received appreciation certificate for best performer from client
• Increased 6% of project revenue after production deployment
Self- Service HR Analytics tool for a renowned Bank of Canada
Tata Consultancy Services, Toronto
Nov ’15 – Sep’16
Onsite Technical Lead
Objective is to build a self-service HR Analytics product
Functional Stack: HP ALM, JIRA
Technology Stack: OBIEE, Oracle 11i, Tableau, SQL
Stakeholder Management, Solution Designing and Project Management & Delivery
• Interacted closely with Business team and transformed functional requirements to technical design documents
• Helped the development team and acted as the SPOC for SIT and UAT phase from project side
Team Leadership & Training
• Performed as Lead Onsite coordinator for complete project and maintained onsite-offshore relationship successfully
Key Achievements
• Provided user trainings to Business team consist of 25 members and improved customer relationship for future prospect.
Strategic Analytics Product Build
Tata Consultancy Services, Kolkata
Feb’13 – Oct’15
Solution Designer
The Main objective is to build product providing comprehensive overview of Procurement and Service management business function. The Flexibility to show a number of reports with in the same screen to allow a quick view on critical information and also to provide more options to the report in terms of Drill-down functions with different displays and Multiple layouts in one View
Technology Stack: OBIEE, Oracle 11i, Tableau, MS SQL Server, SQL
Product Management and Delivery
• Captured business requirements from Sales team and transformed to technical design with strategic decisions
• Completed the product development within allotted budgets and timelines
• Built project deliverables functional journey, project plan, effort estimation, design documents and use manual
• Involved in test cases implementation as well as in demo presentation
Sales & Procurement
• Built Procurement analytics in OBIEE and Tableau
• Performed different type of roles during product development journey
• Was part of Pre-Sales team and ensured that final products meet customer requirements
Cap Gemini Pvt Ltd, Kolkata | Sep’11 – Sep’12  Business Intelligence Lead
Closely work with team and captured functional requirements and prepared technical design document. Involved in development team as well as leading the team. Effectively Coordinated with SIT testing team as well as UAT team for final closure
IBM India Pvt Ltd, Kolkata | Jan’10 – Aug’11   Business Intelligence Lead
•    Worked for different BI/DW projects in Retail, Pharma domains
•    Received multiple times customer appreciations 
Tata Consultancy Services, Bangalore | Apr’06 – Dec’09    Technical Lead
•    Worked as BI Developer , BI Technical Lead for different BI/DW projects in Telecom, Pharma domains
•    Received multiple times customer appreciations 
Infosys Technologies Ltd, Bangalore | Dec’03 – Mar’06Software Developer 
•    Started career as Software Developer and worked different projects in transport domain
•    Awarded Right Stuff certificate by the client of Infosys Technologies Ltd

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s