Ankit Singh Email & Phone Number

London Area, United Kingdom

London Area, United Kingdom

Lloyds Banking Group (Assistant Consultant at TCS)•Employed diverse requirement-gathering techniques to collect and analyse business requirements across multiple functions, ensuring a clear understanding of project objectives and scope. Created BRD and SRS documents to align projects with client expectations, minimize risks, and ensure successful outcomes.•Have helped liaising between business users and technologists•Designed and optimised ETL processes to align business requirements with technical implementation, ensuring seamless data flow and high-quality standards. Identified and resolved bottlenecks, enhancing efficiency and reducing processing time.•Facilitated team communication, ensuring effective collaboration and understanding. Addressed queries and concerns promptly, improving overall project success and stakeholder satisfaction.•Collaborated with cross-functional BI teams to gather requirements and design impactful dashboards, resulting in a 30% boost in report efficiency and improved decision-making across multiple departments.•Leveraged data modelling, SQL, and business acumen to demonstrate data interoperability between two projects. Utilized GCP techniques and IAM roles to enhance data mapping and metadata management.•Implemented CDC tools to ensure seamless data transition; generated extensive test data sets with Data Spawner, successfully validating data integrity through SQL queries in Google BigQuery, reducing testing time by 40%•Designed and developed interactive dashboards using Tableau and Power BI, transforming data presentation and enabling real-time analysis. This innovation streamlined reporting processes, cutting report generation time by 25% and significantly enhancing decision-making efficiency.•Spearheaded the development of a Proof of Concept (POC) demonstrating DBT integration with GKE clusters and Jinja; engineered custom DBT macros that enhanced data processing speed by 40%, improving overall workflow efficiency.

London, England, United Kingdom And Gurgaon, India

•Executed a comprehensive management strategy for agile project releases, collaborating with cross-functional teams to streamline processes; enhanced release frequency by 30% and increased team productivity, resulting in 15 new features delivered quarterly.•Established a centralized release calendar that organized timelines for 15+ projects simultaneously, enhancing visibility for all releases and improving cross-departmental communication efficiency by 30%.•Led and coordinated the release process across development, testing, and production environments, ensuring seamless code deployment and minimizing disruptions.•Orchestrated the deployment of five critical components across three separate environments, enhancing system reliability and achieving a 25% decrease in testing interruptions, ultimately supporting a more efficient quality assurance process.•Conducted thorough Release Readiness, Milestone, and Business Go/No-Go reviews to ensure successful deployment. Analysed and estimated efforts required for defect resolution, support ticket management, and environment delivery.•Facilitated key project meetings, including CAB sessions, and communicated critical updates on QA plans, schedules, and scope changes.•Developed and implemented a communication protocol that improved stakeholder alignment, resulting in a 25% increase in release approval speed.

Gurgaon, India

Worked with the project team to understand the requirement and accordingly develop and deliver the application. Developed and Maintained an Application IBAA(Internet Banking Admin Application) for Lloyds Banking Group