Nitin Bajpai

• Delivering measurable business value through data strategies, architecture, and governance in complex environments
• Architected and led the modernization of a data platform for an Asset Management client using Databricks, Azure (ADF), and Collibra
• Standardized fragmented pipelines, optimized costs by 20%, and implemented data masking solutions for PII data
• Contributed to data modeling for key subject areas (Compliance & Investment Risk) and generated $2.3M in revenue through change requests
• Provided thought leadership on data trends (Generative AI, Data Ethics) and influenced senior stakeholders to drive value from data assets
• Developed data strategies and competitive proposals in Asset Management (FSI) and Public Sector domains
• Conducted workshops with key partners to explore new data and AI challenges and drive solution PoCs
• Led cross-functional teams to achieve project milestones and deliver high-quality results.

• Collaborated with clients to develop customized architectural solutions, meeting their unique needs and preferences in (AWS /Azure and On-prem Solutions) for Government Clients
• Led the migration of critical disparate data sources into a cohesive and well-structured data warehouse (in GCC) cloud environments, ensuring compliance with regulatory requirements
• Implemented and On-Prem to Databricks migration migration & modernization project.
• Implemented data platform architecture and build from scratch using (ADF, Snowflake and Power BI) for an insurance client.
• Conducted workshops to define client data strategies, integrating business objectives with technical solutions
• Delivered 3 major projects and contributed to 6 pre-sales bids (~$30M)
• Created poc's and Solutions for OCR solutions POC's in AWS(Tesseract) and Azure Form Recognizer.
• Designed AI/ML solutions ,including ML Ops pipelines , OCR solutions POC's in AWS(Tesseract) and Azure Form Recognizer to deliver the complex needs

• Managed and optimized the Data Analytics platform for various Lines of Business (LOBs)
• Implemented data model optimizations, data pipelines for operational efficiency and meeting users business SLA's
• Completed the migration of 4 Business Units (BUs) to a new Power BI-based data system

• Gathered, defined and refined requirements, for data analytics platform for Singapore Tourism Board (STB) in AWS ecosystem from ingesting the data from various sources and agencies till the end user consumption.
• Lead an project in Gov healthcare domain to ingest and manage large scale DWH Solution (~52TB).
• Managed an project for MOH during COVID which collected all trace together data and other agencies data and give deep insights for key decision makings during the pandemic situations.
• Designed and established secure usage of data contributed form various industry partners and then implement complex calculations on it to give back the high level industry insights to various tiered partners in secure enterprise-wide data analytics BI applications .
• Contributed in MDM (Master data management) , data modelling , Data Quality rules implementation.
• Lead multiple teams to deliver data sharing marketplace solution via CKAN and Python.

• Key purpose of data modernization was to create customer 360 view (Customer Data Platform ) , by stitching the user personas coming from OMNI channels .
• Innovated new ways of extracting actionable insights from complex datasets, driving business improvements for teams in finance , marketing and product .
• Worked on optimization of AWS glue pipelines DB for better adoption of the Data & BI platform across organization.

Served as the go-to tech partner for the Platform Health team, driving data-driven strategies to optimize critical KPIs across 6 regional markets.

• Partnered with senior leadership to identify factors impacting KPIs, designed initiatives for improvement, and conducted deep-dive analysis for key events (e.g., campaigns).
• Spearheaded strategic initiatives in Platform Policies, Seller Growth, and Compliance, tracking growth and ROI through measurable KPIs.
• Collaborated with Data Science teams to develop fraud detection models and real-time rules to identify abusive languages, counterfeit items, and policy violations.
• Delivered actionable insights during pre-launch and due-diligence stages for projects like Customer Growth Center, Seller Size Chart, and Non-Compliance.
• Built and maintained ETL pipelines and a robust data platform, enabling 50+ users to access insights via 15+ Qlik Sense Dashboards, 10+ FBI (Alibaba Analytics) Dashboards, and Big Screen Solutions for operational and C-level reporting.

• Led the design and implementation of an integrated data model for Group Finance, optimizing ETL processes and reporting frameworks.
• Developed a 3-tier architecture in Qlik Sense BI platform, enabling scalable and efficient delivery of business-critical reports for executive decision-making.
• Automated data validation rules to identify and resolve discrepancies across subsidiaries, ensuring compliance with regulatory reporting requirements.
• Collaborated with cross-functional teams to provide actionable insights for head office reporting for Group Finance, reconciling financial and regulatory data to support global consolidation and executive insights.
• Managed data preparation and reporting needs for regulatory reporting submissions.

• Transitioned the legacy Excel-based reporting system to QlikView, enhancing efficiency and scalability for client portfolio reporting.
• Designed and implemented robust data models and ETL processes, ensuring seamless data integration and accuracy.
• Established role-based data security rules in QlikView, enabling secure and tailored access to sensitive client data.
• Delivered one-click solutions for Relationship Managers (RMs), empowering them to access real-time client portfolio data during meetings, improving decision-making and client engagement.

• Worked collaboratively with team on Single Window and Customs Management Solution modules for the Royal Oman Police (ROP) using MSBI (SSIS) for ETL and Prognoz for BI dashboards and forecasting.
• Gathered business requirements for Trade Facilitation, including Clearance Management, Trade Statistics, Offense Management, and Revenue Generation.
• Performed data profiling, data modeling (LDM, PDM), and designed SSIS jobs for data integration, table definitions, and CSV/flat file processing.
• Developed and delivered 3 interactive dashboards to track and optimize Trade Facilitation processes, enhancing operational visibility and decision-making..

• .Supported Telstra’s transition of copper-based services to NBN Co by gathering required data and delivering 10+ BI dashboards to track major migration milestones.
• Managed Teradata DWH and performed CDM (Conceptual Data Model) modeling for retail business to ensure data integrity and alignment with business requirements.
• Developed ETL processes using DataStage and Wherescape RED to extract, cleanse, and load data into the enterprise data warehouse, enabling seamless data integration.
• Gathered requirements, created data models, and implemented Agile methodology to streamline product development and coordinate UAT for dashboard solutions.

• Involved in Analysis, Requirements gathering, function/technical specification, development, deploying and testing.
• Developed SSIS reporting solutions and special jobs to handle complex
  business scenarios.
• Optimized existing 100+ IBM Data Stage integration workflows, resulting in improved performance and reduced processing time.
• Fostered a culture of continuous learning around emerging trends in Data Integration among peers within the organization.

• Worked for banking(Citi Bank) and HealthCare(Satyam Foundation) clients as ETL developer to extract data from different systems and cleanse and manage data is SQL server for applications consumption.
• Developed applications using C# and SSIS for complex business scenarios and get pre calculated OLAP cubes data populated for end reporting needs.