Rohit Samsukha

· Project Overview:Leading a team of 50+ KNIME developers for a major U.S. bank, tasked with remediating End User Computing (EUC) processes and reducing operational risk.

Key Responsibilities:

· Team Management: Managing a large team of developers focused on automating and streamlining EUC processes using KNIME.

· Project Planning & Delivery: Overseeing resource planning, task allocations, and delivery milestones, ensuring alignment with client goals and timelines.

· Client Interaction: Regularly interacted with the client to update use case status, handle escalations, and ensure smooth project execution.

· SoW & Billing: Managed Statement of Work (SoW), client billing, and related contractual obligations.

· Performance Management: Handled team appraisals, providing feedback and ensuring team members met performance expectations.

Key Achievements:

· Delivered automated reports, reducing manual effort by 30% and ensuring audit compliance with no tampering of outputs.

Improved compliance and data governance by transitioning from manual Excel-based processes to KNIME workflows.

· Project Overview: Led and managed a team of 6 business analysts and Alteryx developers, focusing on automating data processing workflows for a major US banking institution.

Key Responsibilities:

· Requirement Gathering: Conducted detailed discussions and interviews with stakeholders to gather functional and non-functional requirements for Alteryx workflows.

· Workflow Design: Translated business requirements into workflow specifications, ensuring alignment with business objectives and regulatory guidelines.

· Process Mapping: Developed comprehensive process flowcharts and high-level design documentation to visualize both current and future states of processes.

· Stakeholder Collaboration: Engaged with business stakeholders to ensure that developed solutions met approval criteria and adhered to standard templates.

· Documentation: Created detailed business requirements documentation, including WIKI pages and SharePoint repositories for maintaining use case information.

· Testing & Deployment: Oversaw the development, testing, and deployment phases of Alteryx workflows, ensuring that all requirements were fully met and tested.

· Data Validation: Ensured robust data validation processes were in place to verify the accuracy and integrity of data before production.

Key Achievements:

· Facilitated smooth collaboration between business and IT, enhancing the workflow automation process and minimizing manual intervention.

· Played a key role in improving documentation practices by introducing structured knowledge-sharing methods, such as WIKI and SharePoint for better information management.

· Project Overview:Led a team of 6 resources, managing the migration and modernization of a legacy database system for a large US-based retirement planning firm.

Key Responsibilities:

· Project Management: Managed end-to-end project delivery, overseeing a 6-member team responsible for modernizing legacy database systems.

· Source-to-Target Mapping: Conducted detailed source-to-target mapping from the legacy IDAA and IPORT databases to modernized DB2 databases, ensuring accuracy and data integrity.

· Data Validation: Led the process of mapping tables and columns from IPORT to DB2, focusing on validation, data completeness, and ensuring that business requirements were met.

· Data Gap Analysis: Produced comprehensive data gap analysis reports, identifying discrepancies and proposing solutions to bridge gaps between legacy and modern systems.

· Reverse Engineering: Used reverse engineering techniques to trace legacy systems and ensure compatibility with modern database environments.

· Client Engagement: Presented data validation and mapping results to clients, securing sign-off for each phase of the project, and implementing feedback.

· Machine Learning Application: Explored and implemented machine learning techniques to improve data accuracy and process automation within the modernization framework.

Key Achievements:

· Successfully mapped and validated key datasets from legacy systems to the modern database, enabling smoother data migration.

· Improved project timelines by identifying and resolving potential data issues early through comprehensive data gap analysis.

Built strong client relationships, ensuring timely approvals and project sign-offs.

· Project Overview:Led a team of 5 resources in independent validation of spreadsheets used for financial and non-financial reporting in the Model Risk Management (MRM) division of a major US bank.

Key Responsibilities:

· Team Management: Directed a team responsible for validating spreadsheet models used across various business units for external reporting.

· Model Validation: Assessed the functionality, design, and development of spreadsheet models to ensure they met their intended objectives.

· Input Validation: Verified the accuracy of input data by tying sources to model inputs, ensuring alignment with the model's scope and objectives.

· Mathematical Soundness: Conducted detailed reviews of calculations and logical structures within the spreadsheets to ensure outputs were consistent with the model's design.

· Security Requirement Gathering: Collaborated with stakeholders to gather requirements for security architecture, identifying logical paths and user access to directories housing the models.

· Data Protection Audits: Performed checks on access controls, validating how key data within the models was secured and protected from unauthorized access.

· Client Communication: Regularly engaged with the client to obtain necessary information regarding access rights and security measures for the modules.

Key Achievements:

· Improved the accuracy and reliability of spreadsheet models used for critical financial and non-financial reporting.

· Enhanced data protection by implementing thorough access controls and security validation processes, ensuring compliance with regulatory standards.

Successfully led the validation of numerous models, helping mitigate risks related to external reporting.

· Project Overview: Served as a commodities research analyst for one of the largest EU banks and started leading the team of four members by May 2013 in research and data analysis.

Key Responsibilities:

· Commodities Research: Led in-depth research on various commodities, including crude oil, gold, and metals, using both fundamental and technical analysis.

· Predictive Modeling: Developed econometric models to forecast global crude oil prices based on demand-supply dynamics and macroeconomic statistics. Additionally, built models to predict the price of gold using worldwide monetary aggregates.

· Market Reporting: Generated daily, weekly, and monthly market condition reports, providing insights through comprehensive analysis of market trends and price movements.

· CFTC Report Analysis: Conducted detailed analysis of the CFTC report, examining positioning factors relative to macroeconomic variables and price fluctuations across commodities.

· Database Development: Played a key role in creating and maintaining the "Commodities User Guide," an extensive database containing crucial information on the largest producers, consumers, exporters, and importers of key commodities.

Key Achievements:

· Delivered predictive models that significantly improved the accuracy of commodity price forecasting, aiding strategic decision-making for the client.

· Helped build one of the most exhaustive commodities databases for the client, streamlining access to key market information.

· Provided actionable insights through rigorous econometric analysis, improving portfolio performance for the bank’s commodities division.

• Worked on SAP platform for assisting in clearing and disbursing payments based on GIT (goods in transit), RNB (returns not blocked) and reclass (Reclassification). Training on guidelines of trade on SAP platform, how to approve payments, code training on SAP, cancellation of orders and removing blocks on payment approvals