Summary
Overview
Work History
Education
Skills
Certification
Additional Information
Software
Interests
Timeline
BusinessAnalyst

Anneswan Dutta

Senior Business Analyst
Ahmedabad,GJ

Summary

Dedicated Senior Business Analyst with 9 years of overall experience, known for rapidly and effectively translating historical performance figures into actionable data. Taps into expansive Credit Analytics and Financial Domain knowledge to derive value from broad-ranging data points with database and analytics skillset. Dedicated to maximizing impact of key performance metrics to enhance and expand business operations. Known for leveraging both macro and micro-scale analyses to generate holistic images of ongoing business operations for immediate actionability. Team-oriented individual promoting exemplary presentation, project management and risk oversight skills. Considered expert in prioritizing tasks and optimizing workflows.

Overview

3
3
Languages
4
4
Certifications
16
16
years of post-secondary education
9
9
years of professional experience

Work History

Senior Business Analyst

S&P Global Limited
Ahmedabad, Gujarat
06.2019 - Current
  • Conduct business process analysis and identify critical issues and gaps for an established organized process.
  • Responsible for translating the product vision into clear plans and Serving as a liaison between the Stakeholders and the Scrum team.
  • Gathering business and functional requirements shared by Product Managers/Clients and convert into Epics to Features and followed by User Stories.
  • Responsible to create an understandable vision for dataflow using technologies like MS SQL, Cassandra, data exploration, and manipulation using R.
  • Work with SMEs and managers for Credit Analytics project to develop end-to-end flow for various statistical models.
  • Maintain Inline Projects throughout its Lifecycle starting from its sizing, execution, and till the closure of the projects.
  • Solve a range of straightforward problems in risk analysis reports and analyzes possible solutions using standard procedures.
  • Define priorities on the CPPs along with the planned deliverables and resolving inter-team dependencies in order to deliver the items smoothly.
  • Driving all the scrum ceremonies and representing the team in SoS along with maintaining Proper and Healthy Agile Metrics (Team Utilization, Sprint Velocity, Story Points Earned, Backlog Depth) with healthy Team health.*
  • Define solution architecture through the schematic representation of business and function flow (Tools used - Excel, PowerPoint, and Tableau).
  • Defect review, prioritization, and defining priorities of the defect and resolving impediments with proving solution to fix it.
  • Conduct refinement, elicitation, and Program Increment planning session on a regular basis with the technology (Development and QA Team), Solution Architects, and Product Managers.
  • Responsible for communication with other cross-functional and offshore teams in order to mitigate the roadblocks and dependencies.
  • Manage junior Business Analysts and help them in grooming and onboarding.
  • Provide Product Support with L2/L3 teams to provide solutions for issues faced by customers

Senior Technical Member

ADP Private Limited
Pune, Maharashtra
03.2016 - 05.2019
  • Strategized and implemented methods for using technology to improve results for Continuous development.
  • Maintained system performance and security with regular updates.
  • Worked closely with clients and end-users to define needs and break down problems.
  • Approached and solved work problems with initiative and sound judgment.
  • Performed automation for the stability and performance of various environments like Testing, Staging, Production, Demo, and Training.
  • Performed deployment in the various environments using automated process tools like Bladelogic, Ansible, and Jenkins.
  • Troubleshoot various issues during the day and responsible to create SQL data fixes and applied to resolve the issues.
  • Optimized SQL scripts and automated SQL jobs,
  • Responsible for database backups using automated scripts created by me for daily Full, differential and transactional log backups.
  • Provided solutions for technical and architectural discussion with various stakeholders and implemented through the life cycle of the product.
  • Managed Scrum teams to handle various ceremonies like Scrum calls,Refinement, Sprint planning.
  • Responsible to create documents for version of the software and process mapping.

Database Administrator

Tata Consultancy Services Limted
Gurugram, Haryana
03.2012 - 03.2016
  • Involved in Administration of Windows and Linux servers over 192 sites.
  • Managed database replication, log shipping in order to maintain data integrity.
  • Managed Complex database clustering for Active-active and active-passive cases.
  • Created and handled SQL jobs to handle daily Backups for Full, Differentials and Translational log backups.
  • Created and handled Powershell and SSIS automated scripts to reduce manual activity in servers and provided routine server health check-ups.
  • Migrated Windows server from 2003 to 2012 and SQL server from SQL 2000 to SQL 2008 and then SQL server 2012 R2.
  • Created database login and users to maintain smooth application access.
  • Responsible for SQL optimization for better query outputs using various techniques like indexing.

Education

B.Tech - Electrical Engineering

JIS College Of Engineering
Kolkata
06.2007 - 05.2011

HSE - Science

Hare School
Kolkata
04.2005 - 04.2007

SSC - General

Baranagar Ramkrishna Mission Ashram High School
Kolkata
03.1995 - 03.2005

Skills

    Business Analysis

undefined

Certification

Querying Microsoft SQL Server 2012/2014

Additional Information

  • AWARDS & HONORS , Awarded for Service Excellence in the organigation . Received many MY MOMENTS for resolving issues in time .

Software

Microsoft SQL Server

R

Tableau

MSBI

Python

Linux Shell

Jenkins

Bladelogic

Powershell

Datastax for Cassandra

Interests

Watching Web series

Cooking

Timeline

Certified SAFe® 5 Scrum Master

02-2021

Senior Business Analyst

S&P Global Limited
06.2019 - Current

Intermediate SQL Server by DataCamp

06-2019

Introduction to R by DataCamp

03-2017

Querying Microsoft SQL Server 2012/2014

06-2016

Senior Technical Member

ADP Private Limited
03.2016 - 05.2019

Database Administrator

Tata Consultancy Services Limted
03.2012 - 03.2016

B.Tech - Electrical Engineering

JIS College Of Engineering
06.2007 - 05.2011

HSE - Science

Hare School
04.2005 - 04.2007

SSC - General

Baranagar Ramkrishna Mission Ashram High School
03.1995 - 03.2005

Similar Profiles

CREATE PROFILE
Anneswan DuttaSenior Business Analyst