Sangeeta Mallick
Waukegan,IL
Summary
Experienced Microsoft Business Intelligence Developer and Technical Lead with a strong background in data warehousing projects. Proficient in SSIS, SSRS, SQL Server, and Power BI. Possess over 14 years of experience in the IT industry, demonstrating a deep understanding of RDBMS concepts and constructs. Skilled in creating tables, indexes, stored procedures, views, user-defined functions, CTEs, cursors, and triggers. Successfully developed Power BI reports and dashboards from multiple sources, implementing row level security based on access requirements. Designed various types of SSRS reports, including tabular, matrix, drill down, drill through, and charts. Proficient in ETL solutions using SSIS, working with stored procedures, flat files, Excel, and CSV files as data sources. Demonstrated expertise in data cleansing, tagging, de-duplication, SCD handling, static loads, and incremental loads. Strong problem-solving and critical thinking skills to overcome complex technical challenges. Excellent communication and interpersonal skills for effective collaboration with team members. Possesses strong mentoring capabilities and provided guidance to junior team members in multiple projects. Currently serving as a technical lead in the team and familiar with Azure Data Factory pipelines and methodology.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Data Analyst
Accenture
12.2022 - 01.2025
- Company Overview: Client – DTE Energy
- Requirement analysis, estimation and co-ordination with stakeholders/ clients
- Collaborated with team members to gather requirements and design effective visualization
- Created and modeled dataset from SQL Server, CSV, Excel, JSON and other sources
- Developed visual reports, dashboards and KPI using Power BI Desktop
- Build calculated columns and measures using DAX
- Develop, publish and scheduled reports and dashboards to meet business requirements
- Implemented row level security in Power BI workspaces depending on the type of access required
- Worked on Azure SQL Server
- Experience in Azure Data Factory Pipeline
- Worked on KT planning phase where we are planning on the KT topics, understanding document template, technology stack, scheduled sessions with the SMEs of 14+ application area
- Participated on the KT sessions clarifying queries with vendor/client team; helping and guiding team member on documenting the details
- Reviewed system understanding document, MoM, tracking access request
- Participated on job shadow, helping and guiding team members on job shadow phase where team is getting change to do hands on the daily activity for each specific application
- Client – DTE Energy
Senior ETL Developer
Cognizant Technology Solutions
08.2016 - 10.2022
- Company Overview: Client - Chubb Insurance
- Worked as a principal focal point from database side
- Requirement analysis, estimation and co-ordination with stakeholders/ clients
- Leading a team of 5 developers and planning work for the team
- Created new database, SSIS package and data-loading script to load the raw data to landing table
- Build dimension, fact and multi row tables
- Created Stored Procedures to implement the logics
- Created Mapping document, SQL job and data validation script to simplify the process
- Worked on SSIS packages that will minimize manual interference for data load
- Also, worked on the optimization part for the existing report which has improved the performance and complexity of the reports
- Extensively worked on Stored Procedures, Tables, Indexes, Views, User Defined Functions, Cursors and Triggers in SQL Server Management Studio
- Reviewing the deliverables of the team and owning their deliverables
- Coordination with the system testing team
- Preparing release notes for production deployment
- Involved in review and understanding functional requirement specifications document by direct interaction with the client
- Reviewed and tested packages developed by peer
- Providing technical/functional support to Team Members
- Working closely with onsite counterpart to understand their requirements and delivering to their satisfaction
- Client - Chubb Insurance
Senior ETL Developer
Cognizant Technology Solutions
02.2015 - 02.2016
- Company Overview: Client - Chubb Insurance
- Developing SSIS packages
- Extracted data from various sources like SQL Server 2008/2012, .CSV, Excel and Text file from Client servers
- Deploying SSIS packages with SQL Agent and creating/scheduling jobs
- Analyzed the data to implement incremental load
- Implemented Configuration, Logging & Error Handling
- Designed and developed the Staging Database and loaded from source to staging and from staging to the Enterprise Data Warehouse tables applying different transformations
- Developed and deployed the most complex SSIS packages which included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, and Data Conversion
- Client - Chubb Insurance
Senior SQL Developer
Cognizant Technology Solutions
02.2014 - 01.2015
- Company Overview: Client - Staples
- Analyzing the Requirement documents and data mapping documents
- Extensively worked on Stored Procedures, Tables, Indexes, Views, User Defined Functions, Cursors and Triggers in SQL Server Management Studio
- Comparing performance between old and new code and performance tuning of new code
- Implemented fine-tuned queries to improve performance
- Implemented Configuration, Logging & Error Handling
- Performed unit testing /functional testing/ integration testing/regression testing
- Leading the onshore-offshore coordination meetings
- Working closely with onsite counterpart to understand their requirements and delivering to their satisfaction
- Preparation of technical design document and unit test case documents for the project
- To interact with the client to understand the business and data mapping requirements
- Coordinating with onsite team and offshore team
- Understanding the existing code, preparing Source to target mapping documents, Coding, Unit Testing and deployment to SIT/UAT/PROD
- Providing technical/functional support to Team Members
SSRS Report Developer
Cognizant Technology Solutions
10.2010 - 01.2013
- Company Overview: Client - RFG
- Involved in requirement gathering from the business
- Prepared the low-level design documents
- Prepared source-target mapping documents
- Designed Multiple SSRS reports including tabular, drill down, drill through, charts as well
- Developed SSIS packages from flat file, SQL DB, Excel and CSV sources
- Coding and Unit testing
- Preparing unit test cases
- Client - RFG
Education
Master’s in engineering (ME) - Software Engineering
Jadavpur University
West Bengal, India01.2010
Batchelor of Technology - Information Technology
Jalpaiguri Government Engineering College
West Bengal, India01.2007
Skills
- SQL Server 2008
- SQL Server 2012
- SQL Server 2018
- SSIS 2008R2
- SSIS 2012
- SSIS 2019
- SSRS 2008
- SSRS 2012
- Visual Studio 2019
- Power BI Desktop
- Data visualization and presentations
- Data analysis
- Azure Data Factory
Certification
- Microsoft Power Platform Fundamentals (PL-900), 01/23
- Microsoft Azure Data Fundamentals (DP-900), 12/22
- Microsoft Security, Compliance, and Identity Fundamentals (SC-900), 11/22
- Microsoft Azure Administrator (AZ-104), 11/21
- Microsoft Azure Fundamentals (AZ – 900), 10/20
Timeline
Data Analyst
Accenture
12.2022 - 01.2025
Senior ETL Developer
Cognizant Technology Solutions
08.2016 - 10.2022
Senior ETL Developer
Cognizant Technology Solutions
02.2015 - 02.2016
Senior SQL Developer
Cognizant Technology Solutions
02.2014 - 01.2015
SSRS Report Developer
Cognizant Technology Solutions
10.2010 - 01.2013
Master’s in engineering (ME) - Software Engineering
Jadavpur University
Batchelor of Technology - Information Technology
Jalpaiguri Government Engineering College
Similar Profiles
Harshit PandeyHarshit Pandey
DevOps Engineer/Cloud Migration Engineer at AccentureDevOps Engineer/Cloud Migration Engineer at Accenture
JAGRATI REWADIKARJAGRATI REWADIKAR
Service Delivery Ops Analyst at AccentureService Delivery Ops Analyst at Accenture
Jasika SukhejaJasika Sukheja
Software Developer at AccentureSoftware Developer at Accenture
Umair KhanUmair Khan
Content Reviewer at AccentureContent Reviewer at Accenture
Monica GutierrezMonica Gutierrez
Associate at Amazon FulfillmentAssociate at Amazon Fulfillment