Mukesh G. Kumar

• Orchestrated the development of the conceptual and logical model for the data lake, revolutionizing data processing efficiency by an exceptional 75% through optimized data modelling techniques and streamlined workflows.
• Developed dimensional modelling for the risk and liquidity reporting system by identifying Fact and Dimension table using Erwin .
• Worked with Product Owner to understand there needs and translated business requirement to data models.
• Implemented logical and physical data models to capture the future state data element using Erwin and SCD dimension Mapping.
• Optimized significant data processing and transformations by converting Hive/SQL Queries into Spark transformations using Spark RDD, Data Frames, Datasets, and Scala concepts.
• Developed source to target data mapping and data profiling artifacts to the ETL team to perform data loads to the target data mart.
• Developed and performed reverse and forward engineering and created Dynamic DDL's and Scripts as per requirement.

Key Achievement

• Spearheaded the formulation of critical business, process, and system rules/logics to guide the development of software and user applications, ensuring precise implementation.
• Developed essential artifacts, including data dictionaries, ETL data mappings, DFDs, ERD mappings, and DDL documents, crucial for ETL and application support.

• Achieved an 80% improvement in project clarity by translating business requirements into tangible deliverables, leading to the creation of documents such as data mapping requirements, FRD, Use cases, and unified model diagrams.
• Implemented the user stories approach, leading to a 90% reduction in misinterpretations and significantly enhancing requirement documentation quality.
• Orchestrated highly productive walkthrough/JAD sessions with SMEs, architects, development leads, and requirement owners, facilitating efficient requirement gathering and approvals.
• Took complete ownership of sprints, leading to a 78% improvement in sprint productivity and delivery speed.
• Acted as a primary contact to clarify the delivery timelines and review test cases, ensuring to maintain the defect escape ratio not less than 90% in post-launch.
• Accelerated project delivery speed by implementing scrum agile and Kanban methodologies, effectively bridging the gap between the business user group and the technical team, resulting in swift and successful project deliveries.
• Collaborated with the target users for formulate the key business data requirement, data validation and used complex SQL Queries to confirm the user requirement and test data coverage and data quality
• Reviewed and provided sign-off on the UAT test plan, ensuring a thorough validation process.
• Created mapping between staging and data mart and perform validation using DB Visualizer between production and UAT test data.

Key Achievement

• Led successful project deliveries spanning APAC, EMEA, and NAM-based regulatory reporting commitments, encompassing consent orders, IMRs, DCRMs, and data quality improvements for risk and liquidity reporting requirements.
• Collaborated with data sources and consumers, facilitating streamlined data arrival and testing schedules, and effectively implementing risk mitigation strategies to ensure adherence to timelines.

• Created E2E architecture, conceptual, logical, physical and mapping using Erwin and ER-Studio data modeling tool.
• Collaborated with the development team to create a conceptual data models and data flows.
• Created database, view, create cluster indexes and non-cluster indexes.
• Performed extensive data validation using complex SQL queries and back-end testing.
• Involved in the process of migrating the data to various environments like Development, SIT, UAT, and Production.
• Worked on data modeling using Fact & Dimensional Tables , Star/Snow Flake Schema .
• Extensively worked on data extraction, Informatica Transformations involving complex logic and loading data from various sources like Oracle database, SQL Server and Flat files, deploy code from test to production environment.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Key Achievement

• Created mapping documents between upstream and downstream processes, building a logical data model that enhanced data flow efficiency.
• Conducted gap analysis to ensure compatibility of existing system infrastructure with new business requirements, mitigating integration challenges and reducing post-launch issues.

• Played a pivotal role in the Barclays Card Payment Management program, "B-paid," utilizing a suite of tools including Oracle, SQL, Oracle SQL, Jira, Confluence, MS-Excel, and MS-Visio, while adhering to waterfall methodologies.
• Successfully validated and aligned data requirements with APAC 40/29 standards, enhancing data quality and accuracy in payment processing.
• Significantly reducing processing time by leveraging expertise in SWIFT (MT 103, MT101, MT202, MT202 Cov), Faster Payments Services, CHAPS, and BACS to enhance payment processing efficiency.

Key Achievement

• This program achieved an 80-85% increase in payment processing efficiency and a 15% reduction in payment errors.
• Enhanced project clarity and minimized development rework through the organized creation of crucial requirement artifacts for agile projects.
• Achieved a well-documented set of requirements by spearheading the gathering of critical requirements in diverse areas, such as cards issuing/acquiring, migration, unsecured lending, partner finance, faster payments, BACS/SEPA/CHIPS/CHAPS, and more, thereby reducing ambiguity and ensuring alignment with key business objectives.

• Translate Business Requirements to Conceptual and Logical Data Models.
• Recognize the need for a specific relational design – OLTP, OLAP, Data Warehouse – from a set of requirements and/or from a Logical Data Model
• Promotion of ETL a set of requirement and/or from a logical data model.
• Evaluate other Modeler's logical and/or physical data models for adherence to modeling
• Manage multiple assignments simultaneously, whether working independently or in teams..
• Identify, recommend and implement emerging Modeling and IT trends, tools and solutions.
• Involved in data source identification, data modeling and its overall implementation

• Achieved a 20% increase in vendor partnerships by spearheading the initial analysis and strategy for migrating and integrating applications to accommodate additional vendors, thereby expanding business opportunities.
• Implemented agile methodologies, resulting in the efficient tracking of user stories and status reporting, which increased project transparency and enabled the completion of 90% of user stories within the planned sprint durations.
• Achieved a 35% increase in sprint velocity by communicating with the development team, addressing queries regarding the end product, and providing accurate effort estimations for each sprint, which enhanced development efficiency

Key Achievement

• Drove a substantial enhancement in application functionality by conducting a thorough feature gap analysis, examining data dictionaries and data models against existing application layouts, and successfully identifying and resolving critical feature gaps.
• Streamlined data process and reduced data integration time by developing ETL (Extract, Transform, Load) mappings for multiple layouts, enabling the integration of diverse data into a consistent format for loading into a data warehouse.

• Designed and implemented test case tracking tools that along with process documents for defect tracking and test execution, contributed to a 50-70% increase in testing productivity.
• Efficiently coordinated the integration testing of both system and sub-systems, and resulting in a 90% reduction in integration testing time. Thus showcasing expertise in managing complex testing environments.

Key Achievement

• Led a 15-member team to deliver bug-free code within stringent timelines while successfully reducing test execution time by 10% through the identification and implementation of optimized test approaches.
• Achieved higher level of software reliability and reduced post-release issues while supervising the execution of integration, system, and UAT test cases.