Vivek Srinivasan

Ø Retail/CPG project – Master data management(MDM) & Analytics

• Developed robust social media advertising data platform on GCP for major CPG client.
• Performed data ingestion and normalization across various business units.
• Created data mappings for efficient extraction and loading into target tables.
• Executed data analysis tasks using SQL, including cleansing, transformations, and profiling.
• Wrote SQL queries to validate data integrity between source and target tables.
• Established data quality monitoring framework to minimize anomalies with Anamalo rules.
• Visualized data through Looker Studio; prepared and published reports periodically.
• Collaborated with stakeholders to gather and document comprehensive business requirements.

Ø Banking Analytics project:

• Designed and developed cloud-based analytical solution for extracting insights from payment transactions.
• Established customer segmentation framework to classify clients by transaction frequency.
• Automated data extraction and processing from various sources using SQL and Python scripts.
• Spearheaded visualization solution with PowerBI, utilizing KPIs and DAX queries to display trends.
• Collaborated with data science team to build linear regression models for transaction value forecasting.
• Oversaw project implementation and delivered demonstrations to senior management and clients.

Ø Tech Consulting Advisory:

• Created PowerBI dashboards for multiple tools, including data migrator and finops tools.
• Developed presentations detailing cloud data architecture for clients in retail, FMCG, and banking.
• Prepared capability decks and pitch documents in PowerPoint to support new business acquisition.

• Developed ETL validator application to ensure data accuracy and completeness post-migration.
• Extracted large-scale historical data from legacy systems, applying necessary transformations.
• Created validation reports and dashboards to visualize testing outcomes effectively.
• Designed data mappings for efficient extraction from source systems.
• Wrote complex SQL queries to verify data integrity between source and target databases.
• Collaborated with stakeholders to document and gather comprehensive business requirements.
• Executed end-to-end processes from requirements gathering to deployment and client demos.
• Trained junior developers through knowledge transfer sessions, enhancing team capability.

• Hands-on training on technologies like SQL, Python.
• Developed web applications using technologies like SQL & Python.
• Skills: SQL, Python.