Experience

• 

  Accenture

  Jul 2014 - Mar 2017

  Application development analyst

  - To Analyze and Develop Understanding of Informatica MDM Hub Architecture:o Analyze Informatica MDM Hub architecture for processing master data across domains (e.g.,customer, product).o Analyze ETL processes for integrating external data sources with MDM hubs (via InformaticaPowerCenter, Cloud, etc.).o Identify and document staging tables, base object tables, and other critical MDM tables, and analyzethe relationships among them.- To Perform Data Integration, Validation, and ETL:o Execute and assess workflows, data mappings, and transformations to clean, transform, and load datainto MDM systems.o Ensure data integrity and consistency during integration, using validation, cleansing, and enrichmenttechniques.o Implement SQL window functions, partitioning, aggregation, and set operations for data validationand for detecting duplicates and erroneous data.- To Execute MDM Match and Merge:o Configure match rules and merge strategies in MDM to detect and resolve duplicate records.o Utilize consolidation indicators in match/merge operations in the hub console.o Ensure proper merging and de-duplication of master data to achieve golden records.o Implement survivorship rules in the MDM hub console.o Define and manage hierarchies representing relationships between different records.- To Perform Configuration for Data Stewardship:o Configure and monitor data quality rules in IDD (Informatica Data Director) to resolve data issues suchas duplicates, missing values, and inconsistencies.o Create and customize reports and dashboards in IDD to track data quality, governance progress, andstewardship activities.- To Collaborate and Document:o Analyze data models for master data entities (e.g., customers, products) based on businessrequirements and best practices.o Document architectural diagrams, data models, match/merge rules, data governance frameworks,and workflow configurations. Show less

• 

  Adp

  Apr 2017 - Jan 2019

  Etl developer

  Database Migration : - Snapshot and Staging schema creation from Legacy system DB dump.- Migration Tool Configuration for a client.- SQL scripts execution using Migration Tool.- DATA Migration process which involves data extract, transformation and loading followed by Unit testing.- Migrate Data to Target systems.- Data triage for data issues and mismatches.- Writing the queries for schema/count/data validation and end to end testing, comparing the results.

• 

  Eeziserv solutions

  Apr 2019 - Jan 2022

  Analytics developer

  Tools Used: MS Power BI, MS SQL Server, MS Excel•Key Performance Indicators (KPIs): - Tracked essential metrics, including downloads, active users, and revenue.•Data Extraction and Integration: - Extracted data from diverse sources, including game servers, user databases, and third-party analytics tools. - Integrated data to create a comprehensive dataset for analysis.•Data Transformation: - Conducted data cleaning, transformation, and normalization to establish a standardized dataset.•Dashboard and Report Development: - Developed a range of visualizations, including KPIs, line charts, bar graphs, and pie charts, to present key insights. - Delivered insights on player retention, session duration, and in-game activities. - Utilized Gauge Visuals to aggregate and analyze user reviews and feedback.This comprehensive approach to data analysis using MS Power BI, MS SQL Server, andMS Excel allowed for a detailed exploration of Android game performance, facilitatingstrategic decision-making and enhancing user experience. Show less

• 

  Tata consultancy services

  Jan 2022 - Feb 2023

  Senior etl developer

  • Conducted comprehensive requirement analysis, identifying transformative solutions to address specific issues.• Development: - Implemented various Informatica transformations like Filter, Expression, Lookup, Aggregator, Update Strategy, Joiner, Router, Sorter, and Union. - Developed mappings, corresponding tasks and generated the workflows. - Employed the debugger extensively to identify and rectify bugs in existing mappings, analyzing data flow, evaluating transformations, and optimizing data length issues. - Utilized Informatica parameter files effectively to define mapping variables, workflow variables, and relational connections. - Implemented pre and post-session assignment variables to facilitate the passing of variables between sessions.•Performed Unit Testing•Deployment: - Deployed workflows to the TST environment, utilizing Defect management tool - JIRA•Documentation: - Actively participated in weekly and daily status meetings, engaging in peer reviews and contributing to formal walkthroughs among various teams; meticulouslydocumented proceedings.•Production Deployment and weekend support: - Monitored workflows and sessions using the workflow monitor.•Additional Expertise: - Knowledge of ETL concepts like star schema and snowflake schema. Show less

• 

  Workzy solutions

  Mar 2023 - Apr 2024

  Senior data analyst

  Currently engaged in a Microsoft Power BI project focusing on various construction-related aspects, such as estimation, actual costs, bidding expenses, and project progress. Responsibilities entail developing the data model, crafting reports, and leveraging various Power BI visuals to enhance data presentation.• Technologies Used: - Microsoft Power BI with Data Source MS Excel/ CSV and SQL Server DB Tables.•Key Performance Indicators (KPIs): - Monitored crucial KPIs, including Total Revenue, Total Signed Contracts, Total Cancelled Contracts, Cost Variance, Bid Success Rates, Accuracy of Cost Estimates, and Bid-to-Win Ratios.•Data Gathering and Import: - Led a team of three developers in executing data import and ETL operations. - Imported data from various MS Excel/CSV files and SQL Server DB tables relevant to construction estimation, encompassing historical project costs, material prices, and labor rates.•Data Modeling: - Executed decisions on Import/DirectQuery/DUAL mode for storage. - Developed a comprehensive data model, taking into account factors such as project size, scope, and historical data.•Custom Measures using DAX: - Applied hands-on experience with the DAX language for data analysis, encompassing calculated columns, calculated tables, data aggregation, time intelligence, and iterator functions.•Reports and Dashboards: - Demonstrated an expert understanding of Filter context and row-level context. - Developed over 30 reports and dashboards featuring visuals like line charts, bar graphs, pie charts, slicers, and matrices, resulting in a remarkable 20% increase in operational efficiencies. Show less

• 

  Transimpact

  Apr 2024 - now

  Senior analytics developer