Anupam Singh
Montreal,QC
Summary
Accomplished leader with a track record of driving innovation and delivering cutting-edge solutions in Data Products, Advanced Analytics and AI. Proficient in translating complex business requirements into actionable technical strategies. Skilled in leading cross-functional teams throughout the development lifecycle, ensuring alignment with organizational goals, and delivering high-impact products that drive business value. Committed to leveraging advanced analytics and AI to uncover insights, optimize processes, and empower decision-making. Dedicated to fostering a culture of continuous improvement and delivering exceptional results in dynamic environments. Core member of Capgemini’s Analytics COE, actively contributing to IEEE - AI Ethics, and leading the AI Research Lab for WAI Canada's Toronto chapter. Engaged in volunteer activities, including mentorship and standards contributions.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Technical Product Specialist
Fidelity Investments (Employer of Capgemini)
08.2024 - Current
- Collaborated extensively with cross-functional teams to drive seamless integration efforts for end-to-end Data Management team to leverage Data Governance and Data Catalog across Enterprise.
- Championed data-driven decision-making by leveraging analytics tools and tracking relevant metrics.
- Delivered high-quality technical documentation to support sales, training, and client implementations.
- Identified areas for cost reduction in production processes without compromising on quality or functionality standards.
- Promoted a culture of continuous improvement through regular sprint reviews and retrospectives.
- Ensured timely delivery of products by proactively identifying risks and mitigating potential roadblocks in the development process.
- Optimized product performance with diligent troubleshooting and root cause analysis.
Technical Engagement Lead
Fidelity Investments
05.2023 - 07.2024
- Company Overview: Employee of Capgemini Ltd
- Responsible for leading the transition of client's Workplace Investing data platform from legacy tool stack of Oracle to SAAS based tool, Snowflake and Analytical platform from OAS to cloud base Power BI
- Designed and deployed Retirement Analysis and Client Plans Data Products for Analytics
- Designed and implemented security model for external users via embedded platform
- Responsible for design and implementation of Capgemini in-house solutions of GenYoda to incorporate prompt engineering and RAG based content generation along with Gen AI based validation tools
- Designed and implemented Gen AI based Reports rationalization tool for reducing the analytical content
- Designed and implemented Proof of Concept for Gen AI Use cases – 'Ask Database' for a modernized Reporting platform.
Data & Analytics Architect, IT Product Lead
Morgan Stanley
12.2014 - 04.2023
- Company Overview: Employee of Capgemini Ltd
- Responsible for transitioning HRIT team’s global data and analytics systems from NY to India and growing business operating model to be executed from India
- Responsible to raise Analytics/ML maturity, strategy planning and building vision of client's organization through mentoring, leading analytic workgroups, consulting, and architecting innovative solutions in partnership with business stakeholders
- Researched, designed and implemented scalable applications for data extraction, analysis, retrieval and indexing that supported highly varied (structured, semi-structured, and unstructured) and high-velocity (near real-time) data processing and delivery
- Created proofs of concept for innovative new solutions and evaluated potential software products based on new and existing system development and migration requirements
- Created user groups to guide overall strategy for different layers of architecture stack and to establish specifications and system designs
- Maintained existing applications and designed, developed and delivered new applications
- Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements
- Responsible for design and end-end implementation of Data Products and Analytical platform for SMCR, Lateral and Campus Recruitment, Promotion, Compensation, Workforce Activity and Headcount, Attrition, Manager Analysis
- COVID Analytics and Return to Office Analytics for Management Committee
- Employee Churn model with 17 identified features and helped in reducing Attrition rate by 1.7%
- Attrition Anomaly model to identify defects with Voluntary Attrition and reduced anomaly by 68%
- Outlook Network Analysis model with 8 identified features and finding better ways to engage and retain employees
- Designed and implemented Row-Level Security architecture for data entitlements across multiple platforms (SAP BO, Tableau, Snowflake, Power BI)
- Architected, designed, and implemented BI metadata accelerators and embedded portal integrators using Java and Rest APIs for SAP BO, Tableau, Power BI
- Analyzing and providing effort estimation, risks with mitigations and timelines, generating test cases, knowledgebase insight document, development standards document, process improvement documents, user trainings, etc
- Partnered with software vendors and infrastructure teams to plan and build out new systems, understand scalability and constraints of software, designing and setting up enhanced security in BI layer
- Responsible for a team of 11 DB, ETL, Report developers and an active member of the Organization's recruitment & assessment process
- Integral part of Data Analytics COE involved in pre-sales and solutioning - across presentation preparation, sales pitch, solutioning, estimations, proposal preparation for various use-cases of data engineering
- Employee of Capgemini Ltd
Data Engineer and BI Analyst
Silicon Valley Bank
08.2013 - 11.2014
- Company Overview: Employee of Mindtree Ltd
- As part of the DART Reporting team, involved in developing Reports used by the users across various markets and portfolios for all the projects involving financial data displayed in client specific requirements
- Involved in source to target mapping for the GL data flow and all the other upstream and downstream applications using SAP BODS
- Includes Adhoc reporting by the client along with predefined reports in WEBI viewed and run monthly, weekly, daily and Event based generating PDF and Excel extracts
- Implemented BO Mobile for senior users to access reports on mobile platform
- Involved in implementation of EMIR(European Market Infrastructure Regulation) regulatory reporting of derivative contracts and implementation of risk management standards
- It requires that all entities entering into derivative contracts must submit reports to their corresponding trade repositories, outlining each over-the-counter trade
- These daily mandatory reports must also include a Unique Transaction Identifier (UTI), legal entity identifier (LEI), information on the trading capacity of the counterparty, and the marked-to-market valuation of the position
- Responsible for a team of report and ETL developers
- Employee of Mindtree Ltd
Data Modeler and BI Analyst
Western Union
04.2012 - 07.2013
- Company Overview: Employee of Mindtree Ltd
- Involved in defining and identifying Key Performance Indicators (KPIs) of reporting money transfers across various sectors like geography, modes of business, Gold Card business, Prepaid Card business
- Involved in integrating data from diverse source systems, transforming it to suit business requirements and loading into separate system from which data would be extracted for reporting by using summarized tables and which would serve as a single source of information for Adhoc reporting needs of customer's business
- Involved in automating, manual roster reports to build a more robust BI architecture
- Involved in gathering requirements and full development life cycle of data and reporting environment providing details at different levels like Delivery Unit, Business Unit, Process Unit, etc
- Involved in design and development of different reports and universe including Database structure and Data models
- Created complex summarized and detailed reports using slice and dice and migrating to much detailed reports through hyperlinks
- Developed various operational reports and dashboard modules used by senior management and other departments for improvement in operations
- Extracting data from Flat files and Relational tables, transforming it as per business requirement & loading datamarts and online database
- Creating and maintaining database tables, functions, stored procedures, triggers, Sql queries and database tuning for quick results etc
- Creating and maintaining user accounts with roles and access control, managing groups in CMC
- Employee of Mindtree Ltd
Data Modeler and BI Analyst
Keenan
09.2011 - 04.2012
- Company Overview: Employee of Mindtree Ltd
- Involved in Business Requirement Gathering and Analysis of the Data Integration project which aims to equip Customer's business end users with a robust reporting platform that will enable them to generate key Claim Analytics Reports which will provide critical insight into the claim details for the Workers Compensation and Property & Liability lines of business
- The business end users will be able customize the reports to suit their needs and can select the Key Performance Indicators (KPIs) for which they would like to view the data across various dimensions like time range, location, occupation, severity etc
- Involved in integrating data from diverse source systems, transforming it to suit the business requirements and loading into a central ODS that will serve the as a single source of information for the adhoc reporting needs of the business end users using SAP BODS
- Involved in Universe and Report development using SAP BOXI 3.1 and BO 4.0
- Involved in enhancement of existing Reports and Universes
- Involved in supporting the month end activities of Report Bursting
- Employee of Mindtree Ltd
Data Modeler and BI Analyst
Unilever
03.2011 - 08.2011
- Company Overview: Employee of Mindtree Ltd
- Finance Dashboard is a one stop for all finance related data for the CFO
- The dashboard was built to help the business user's track the KPI's for the last year and last three months of the current year at a Business, Category, Sub Category and Brand Level
- It has a What-If-Analysis dashboard to do the predictive analysis related to the KPI's
- All the five dashboards are incorporated into a single dashboard for ease of use
- Elicitation of Business Requirement Gathering and Analysis
- Involved in Developing Data Models, build Dashboards and integrating them all together
- Involved in integrating with Share Point Portal and testing of both the online and offline integrated dashboards
- Involved in testing of the BW Queries
- Involved in TDP process of scheduling the Crystal Reports to the clients
- Employee of Mindtree Ltd
BI Analyst
Alliance Bernstein
10.2006 - 10.2010
- Company Overview: Employee of Nuware Systems
- GPS is part of EIMT(Equity Investment Management Technology) which mainly deals with equity fund management
- The fundamental requirement of every portfolio manager is the ability to track, analyze and predict the performance of an investment portfolio and also manage the associated risk
- The client deals with the daily trading and has an integrated technology driven approach to conduct portfolio analysis and a structured approach to picking stocks
- The different accounts(Growth,Value and Blend) are managed by the portfolio manager who invests in various investment categories depending on the RISK factor
- The APM(Account Portfolio Manager) deals with the investment based on the research done by a Research director of a particular stock over a period of time
- Requirements Gathering of Analytics and regulatory reporting requests
- Developing Database Objects and Crystal Reports as per the requirement
- Performance Tuning of reports, stored procedures and queries
- Employee of Nuware Systems
Education
Diploma - Data Science and Machine Learning
McGill University
Montreal, QC03.2022
Masters - Computer Application
Visveswaraya Technological University
07.2006
Skills
- Advanced Analytics
- IT Architecture
- HR Analytics
- Statistical Analytics
- Cloud Architecture
- Operating Systems
- Data Visualization
- Business Intelligence
- Database
- Data Wrangling
- ELT
- ETL
- Data Governance
- Scripting Languages
- ML Tools
- IDE
- Repository
- Applications
- Other Tools
Accomplishments
- Achieved [Result] by completing [Task] with accuracy and efficiency.
- Collaborated with team of [Number] in the development of [Project name].
- Achieved [Result] through effectively helping with [Task].
Certification
- TOGAF – Business Architecture
- Certified Azure Solutions Architect Expert from Microsoft
- Certified SnowPro Core/Advanced from Snowflake
- Certified DuetAI from Google
- Certified Google Cloud Big Data and Machine Learning Fundamentals from Google
- Certified Python for Data Science from DataCamp
- Certified Harvard Manage Mentor from Harvard University
- Certified Scrum Master [CSM] from Scrum Alliance
- Certified Collibra Data Steward, Community Manager, Developer and Platform Admin from Collibra
- Certified Big Data Consultant using Hadoop Ecosystem from Government of India
- Certified Banking and Financial consultant from FLIP
- Certified in Financial Markets module from NCFM, IBM
- Certified professional in DB2 Database version 10.1
References
To be provided on-request.
Languages
English
Full Professional
French
Elementary
Timeline
Technical Product Specialist
Fidelity Investments (Employer of Capgemini)
08.2024 - Current
Technical Engagement Lead
Fidelity Investments
05.2023 - 07.2024
Data & Analytics Architect, IT Product Lead
Morgan Stanley
12.2014 - 04.2023
Data Engineer and BI Analyst
Silicon Valley Bank
08.2013 - 11.2014
Data Modeler and BI Analyst
Western Union
04.2012 - 07.2013
Data Modeler and BI Analyst
Keenan
09.2011 - 04.2012
Data Modeler and BI Analyst
Unilever
03.2011 - 08.2011
BI Analyst
Alliance Bernstein
10.2006 - 10.2010
Masters - Computer Application
Visveswaraya Technological University
Diploma - Data Science and Machine Learning
McGill University
Similar Profiles
Mahesh MelmuriMahesh Melmuri
Principal IT Consultant at Capgemini | Fidelity InvestmentsPrincipal IT Consultant at Capgemini | Fidelity Investments
Sanika DeshpandeSanika Deshpande
User Experience Architect at Fidelity investments/consulting through CapgeminiUser Experience Architect at Fidelity investments/consulting through Capgemini
MICHAEL O'BRIENMICHAEL O'BRIEN
FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)
Ros Niko VillagraciaRos Niko Villagracia
Machine Operator at Balcan Innovations IncMachine Operator at Balcan Innovations Inc
Haia NakshoHaia Naksho
Warehouse Technician at SSENSEWarehouse Technician at SSENSE