Experienced with managing high-stakes projects and ensuring client satisfaction. Utilizes analytical skills and strategic thinking to drive successful outcomes. Track record of effective teamwork and adaptability in dynamic environments.
Overview
12
12
years of professional experience
Work History
Senior Associate II
PwC AC
10.2019 - Current
Project I Trimble(Enterprise Domain)
Data Pipeline Orchestration: Implemented a SnapLogic data integration pipeline for ETL processes, facilitating seamless data migration to Salesforce and utilizing SnapLogic's low-code platform to design and execute complex data workflows.
Data Processing and Analytics: Used Databricks for large-scale data processing and analytics by writing complex SQL queries for data transformation and Python scripts for advanced data manipulation. Utilized Databricks' distributed computing capabilities to handle big data efficiently.
Data Quality and Deduplication: Implemented data quality checks and deduplication processes on Salesforce master objects (e.g., Account, Contact, Contact Point Address) using techniques like fuzzy matching and record linkage.
Data Validation and Scalability: Implemented appropriate data models for Salesforce objects, including Quote and Quote Line Items, while enforcing rule validations and ensuring proper relationships and constraints are maintained during the migration process. Performed reconciliation checks on contract data to verify accuracy and consistency between source systems and Salesforce, particularly focusing on pricing structures and contractual terms.
Backend Development and Testing: Developed and tested backend programs, mappings, and update processes. Managed and monitored batch jobs and sessions using Manager/Dashboard Server.
Project II Innovaccer(Healthcare Domain)
Data Extraction and Migration: Extracted data from various sources using Azure Data Factory, then loaded it into Snowflake data warehouse using efficient pipelines and staging areas. Implemented data validation and reconciliation processes to ensure accuracy.
Report and Dashboard Development: Created DAX measures and time intelligence functions in Power BI. Designed a variety of visualizations with drill-through capabilities and composed interactive dashboards with logical layouts, cross-filtering, and consistent theming.
Optimization and Governance: Ensured performance through query folding and Power BI's optimization features. Implemented security measures like row-level security, set up collaborative workspaces, and configured appropriate sharing and distribution settings for end-users.
Implemented a centralized Datamart using DBT to transform raw data into clean, analytics-ready datasets, enabling automated and reliable Tableau reporting. Streamlined data pipelines, improved data accuracy, and reduced reporting latency for key business stakeholders.
Lead Assistant Manager
EXL Services
07.2020 - 10.2021
Dashboard Design: Created and built interactive dashboards in Tableau to track various metrics and performance indicators.
Technical Documentation: Wrote documents explaining database content and mapped out different databases used in the organization.
Data Architecture: Developed and designed data storage solutions, including complex data mappings and reusable transformations for different loading schedules (one-time, daily, monthly, and yearly).
Data Visualizations: Created workbooks and dashboards with custom metrics to fit different needs. Used various Tableau technologies to create and test advanced data visualizations.
Senior Data Analyst
Healthkart
11.2019 - 06.2020
Dashboard Development: Created dashboards for executives, board members, and county commissioners to track and report key performance indicators, improving how performance was monitored.
Tableau Data Analysis: Used Tableau to analyze data, create graphs and charts, and resolve any issues with claims data in reports and dashboards.
Accreditation Support: Assisted with gathering requirements, designing, testing, and validating processes to achieve Council on Quality Leadership (CQL) accreditation.
Excel and Tableau Reporting: Developed advanced Excel spreadsheets for caseworkers to collect data. Created charts and graphs in Tableau for reporting and analyzed data for a study published in a medical journal.
Senior Software Engineer
Collabera (Client- Z S Associate Health Care)
05.2019 - 10.2019
Business Intelligence Solutions: Created and maintained business intelligence solutions to make data easier to access and use, aiding the organization in making better decisions.
Data Query and Reporting: Developed and ran queries to retrieve the needed data, and created reports and visualizations to present findings clearly.
Tableau Management: Utilized and managed Tableau to gather and analyze data, enhancing the organization's data-driven decision-making processes.
Client Interaction and Design: Collaborated with clients to understand their needs and helped design solutions that fit their goals.
Software Engineer
LNT Infotech
11.2013 - 05.2019
Teradata Load Utilities: Used Teradata MLoad, FastLoad, BTEQ, Multiload, and TPump for efficient ETL processes.
DataStage Development: Designed and developed parallel jobs in DataStage using various stages like Join, Merge, Lookup, Sort, and Transformer to process and summarize key performance data.
UNIX Shell Scripting: Created UNIX shell scripts for file validation and scheduling DataStage jobs to ensure data accuracy and timely execution.
Tableau Strategy and Development: Helped shape the Tableau design and development practices. Managed and optimized Tableau Server, including server administration, configuration, maintenance, and security.
Education
Bachelor of Technology - CSE
West Bengal University
Siliguri, WB
09.2013
undefined
St. Xavier’s Jr./Sr. School
Muzaffarpur, Bihar
06.2008
undefined
D.A.V Public School
Muzaffarpur, Bihar
06.2006
Skills
Languages and DataBases: Python, PySpark, SQL, MySQL, NoSQL Teradata 140, Snowflake, Postgre SQL, Azure Databricks
Visualization Tools: Tableau, Power BI, Qlik Sense, Web Intelligence (SAP BO)
ETL Tools: Azure Data Factory(ADF), Informatica, Snaplogic
Other Skills: Advanced Excel, Business Analysis, Data Analysis, Customer Acquisition, Problem Solving, Time Management