Mrinalini Roy
Summary
12 + years of software development experience in Microsoft Business Intelligence (MSBI).
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior SQL Developer
MUFG Global Services
- Current
- Working as a Senior SQL Developer in the Customer HUB Application team which is part of GCIB
- CHUB application is used by RMs as a central platform to assess the data
- Working on data issues, data loads using SSIS, new enhancements coming in from the business.
Technology Lead
Ameriprise Financial
05.2019 - 04.2023
- Worked primarily on property business
- Creation, deployment, maintenance of SSRS Reports
- This role also includes creation of database objects and fine tuning them
- Creation and deployment of SSIS packages is also part of this project.
Senior Software Engineer
L&T Infotech Ltd
03.2017 - 04.2019
- Technologies Used: SSIS, SQL Server 2012
- Client: Northbridge Financial Corporation
- Responsibilities: Created SSIS packages according to business requirements
- Involved in database deployment activities
- Created/modified SQL stored procedures and functions for using in SSIS load
- Worked on performance tuning and database query optimization tasks.
Senior Software Engineer
CitiusTech HealthCare Solutions Pvt Ltd
07.2016 - 03.2017
- Technologies Used: SSRS, SQL Server 2012
- Client: DaVita-Health Care Partners
- Created/modified database objects according to requirements
- Created/Modified SSRS Reports as per requirement for projecting healthcare quality metrics and patient data
- Involved in database deployment and testing activities
- Worked on performance enhancement and database query optimization tasks.
Software Engineering Analyst
Accenture Services Private Limited
- Technologies Used: SSIS, SQL Server 2012, Microsoft Dynamics CRM 2013
- Client: Express Scripts Inc
- Responsibilities: Worked in a 3 member team which was involved in writing ETL packages for migrating data from Legacy System to Dynamics CRM
- Created SSIS packages with error handling
- Experience in writing complex SQL queries involving multiple tables inner and outer joins
- Used DQS component for data cleansing to format data to CRM acceptable format
- Helped client in validating and rectifying issues in case of data mismatch.
Senior Software Engineering Analyst
Accenture Services Private Limited
- Technologies Used: SQL Server 2012
- Project: HPDP Tools
- Description: This project is involved in creating an application which will be used by Project Leads and Managers for viewing project metrics at one place
- Responsibilities: Writing complex SQL queries involving multiple tables inner and outer joins
- Rectifying issues in case of data mismatch using queries in T-SQL
Senior Systems Engineer
Infosys Technologies Limited
- Technologies Used: SSIS, SQL Server 2008
- Client: Microsoft
- Description: This project involved maintenance of CSS Data Acquisition Platform (DAP), DAP is a single source of data provider for all CSS projects
- Designed advanced SSIS packages & procedures
- Implemented T-SQL features in SQL Server 2008 like Partitioning
- Led the estimation and after reviewing the estimates communicated to all the stakeholders to participate efficiently in the Development and Testing phases
- Performed incremental load of data based on date time and id columns in tables
Education
B.Tech (IT) -
West Bengal University of Technology
Kolkata05-2011
12th -
Jawahar Viya Mandir
Ranchi05-2007
10th -
Bishops School
Ranchi01.2005
Skills
- SQL Server, SSIS, SSRS
- Microsoft Visual Studio, GIT,TFS
- Data Warehousing (Development and Maintenance)
- Sound experience in designing, developing, building and testing BI and DW applications Strong analytical and communication skills
Certification
- 70-448, Microsoft SQL Server 2008 Business Intelligence Development and Maintenance
- 70-433, Microsoft SQL Server2008 Database Development
- 70-461, Microsoft Querying SQL Server 2012
- 70-463, Administering Microsoft SQL Server 2012 Databases
Timeline
Technology Lead
Ameriprise Financial
05.2019 - 04.2023
Senior Software Engineer
L&T Infotech Ltd
03.2017 - 04.2019
Senior Software Engineer
CitiusTech HealthCare Solutions Pvt Ltd
07.2016 - 03.2017
Senior SQL Developer
MUFG Global Services
- Current
Software Engineering Analyst
Accenture Services Private Limited
Senior Software Engineering Analyst
Accenture Services Private Limited
Senior Systems Engineer
Infosys Technologies Limited
B.Tech (IT) -
West Bengal University of Technology
12th -
Jawahar Viya Mandir
10th -
Bishops School
Similar Profiles
Manoj LomidiManoj Lomidi
Assistant Vice President at MUFG Global ServicesAssistant Vice President at MUFG Global Services
Palak BarbhayaPalak Barbhaya
Senior Credit Risk Analyst at MUFG Global Services Private LimitedSenior Credit Risk Analyst at MUFG Global Services Private Limited
Shankar GShankar G
Team Lead, Middle Office Department at MUFG Global Services Private Ltd.Team Lead, Middle Office Department at MUFG Global Services Private Ltd.