Piyush Kumar Email & Phone Number

United States

Plano, Texas, United States

● To acquire requirements for ACH processing, requirements were gathered using survey/questionnaire, interview sessions, and focus groups and the feasibility of the requirements was analyzed. Working with engineers, programmers, and end users to guarantee the correctness of the check transfer upgrades and understanding the transaction process requires knowledge of NACHA operating standards and SAME DAY ACH processing. Identified the necessary ACH and NACHA component of rules for all stakeholders involved to secure the data from unauthorized usage.● Conducted GAP Analysis to fully comprehend and record the TO-BE process flow by considering all the functional and non-functional needs. Evaluation of Porter's Five Forces, cost analysis, impact analysis, and feasibility assessment. Interacted one-on-one with Subject Matter Experts (SMEs), asking thorough questions, and meticulously documenting the requirements in a way that could be understood and approved by both technical and business professionals. ● Developed automated workflows within Loan IQ for ACH transactions, reducing manual processing time and minimizing errors associated with loan payment schedules.● Created wireframes, Graphical user interface (GUI), Mock-ups using Lucid Charts and created Evolutionary and throwaway prototypes using Balsamiq to make team understand the details of the project and its end-to-end system.● Monitored post-implementation performance of ACH enhancements within Loan IQ, analyzing transaction metrics to evaluate the impact on loan servicing efficiency and customer satisfaction.● Conducted comprehensive testing of ACH enhancements within Loan IQ, ensuring that new features functioned as intended and met the needs of end-users.● Used ODM to create customized routing for ACH transactions, improving the efficiency of settlement processes by automatically directing transactions based on risk profiles and customer categories.

Charlotte, North Carolina, United States

● Worked with various capital market instruments like Equities, Fixed Income, Asset Allocation and Wealth Management, Futures, Bonds, Bond Pricing, Derivatives (Options), Credit, Interest Derivatives and Equity Order Processing.● Played a key role in integrating a third-party solver library for complex investment portfolio calculations in the asset and wealth management system. Ensured system scalability during high-traffic periods, like marketing campaigns.● Facilitated JAD Sessions with users, developers, and database design team to deal with backend synchronisation issues accompanied with interviews and document analysis. Conducted interviews with structured and unstructured questions.● Helped in enhancing risk assessment tools to analyze and manage investment risks, supporting better decision-making for asset management and clients.● Prepared low and high-fidelity wireframes along with mockups using MS VISIO to present the end-users & elicit feedback.● Maintained and built relationships with stakeholders to ensure their performance management and analyse the business.● Extensive experience and used Amazon Web Services components such as AWS Beanstalk to run its application and customer facing website, Amazon Simple Storage Service (S3) and Amazon Aurora (AML Database) to store customers data.● Cooperated with the project manager in defining Lambda functions for seamless computing and integration with each addition of new data to Amazon S3 (Simple Storage Service).● Used AWS API Gateway for creating secure, scalable APIs to facilitate smooth data exchange between our cloud-based solution and legacy systems.● Used API technical documentation tools like Swagger and assisted in API testing using Postman to document all the test logs.● Supported the Quality Analyst (QA) and Development teams in execution & preparation of test documents like Test Plans, Cases, Scenarios and tracked them to user stories with help of Requirement Traceability Matrix (RTM).

Stamford, Connecticut, United States

● Experienced in utilizing various tools and components such as LoanIQ for loan approval and concessions, Loan Modeling Tool (LMT) for real-time loan management, and Fixed Loan Transactions (FLT/LTOF) for initiating and managing loan transactions. Additionally, integrated Web Service Middleware for brokerage service integration and collateral information retrieval and implemented Business Logic Layer within web services to perform credit checks and risk assessments.● Managed and optimized loan servicing processes using LoanIQ, ensuring accurate administration and reporting for syndicated loan portfolios.● Customized Loan IQ modules to meet specific banking needs, improving the institution's ability to offer tailored financial services to customers.● Interviewed Subject Matter Experts to identify areas for improvement and performed extensive Document Reviews to develop a thorough understanding of the current state of business processes to aid Business Processes Improvement (BPI).● Devised complete process model of state of the As-Is processes and To-Be processes to achieve greater efficiency.● Helped PO and PM in ROI Analysis and SWOT analysis to be prepared for potential business and technical risks to the system.● Identified Business Rules for credit line approval by conducting extensive one-on-one interviews with Subject Matter Experts (SMEs), by observing the process, conducting workshops, and analysing the Business Documents and business process data.● Prepared and analysed UML diagrams like Process Diagrams and Activity Diagrams using MS Visio to analyse, model complex workflows, design the structure of the system, behavior, and interactions in the system design.● Conducted User Story Writing Workshops for the stakeholders not proficient in the art of writing user stories.●Utilized Python Matplotlib and Seaborn for data visualization, creating clear and informative charts to display trends in loan performance, repayment rates, and delinquency.

Chennai, Tamil Nadu, India

● Thorough knowledge on financial assets of various securities and investment management like stocks and mutual funds.● Performed a GAP analysis in order to identify redundant source fields, additional target fields, and transformation logic.● Conducted one-on-one interviews and JAD sessions to identify Data Marts and captured various OLAP queries.● In collaboration with the architecture and the design team, they created different UML diagrams – Activity Diagram, Use Case Diagram and Sequence Diagrams using Lucid Charts to define the different actors and interactions within the system.● Created a data migration strategy by assisting Database architects in modelling Bus Architecture, designing Galaxy Schema, and constructing Entity Relationship Diagrams to understand the target data warehouse and relationships between data tables.● Participated in all Scrum Ceremonies, by converting the requirements to User Stories by defining the Acceptance Criteria.● Collected, improved, and prepared the staging area using MS Access based on information collected from various sources.● Analysed the existing source systems by collaborating with system experts to prepare a Data Mapping Specification.● Consistently involved in all ETL processes using Informatica PowerCenter for data integration, assisting ETL development team to apply designer transformation logic, prepare workflow sessions configuration and monitor results.● Developed Sharing Rules in Force.com to increase Organization Wide Default (OWD) sharing settings by increasing record accessibility based on roles, and prepared Summary and Matrix-based dashboards to improve record accessibility and insight.● Proficiently managed different Informatica Workspaces (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, and Transformation Developer) to transform data from the source system to the target system effectively.

Mumbai, Maharashtra, India

● Interacted with Business Users and Stakeholders to identify business issues, analysed, evaluated, and recommended solutions.● Participated in JAD sessions, conducted one-on-one interview sessions with Business users and Stakeholders, performed card sorting, requirement re-engineering and consulted existing system documentation to gather Business Requirements.● Ensured compliance with various financial regulations and internal policies by leveraging FIS Integrity’s robust reporting and audit trail features. Facilitated smoother audits and regulatory reviews by maintaining detailed and accurate records.● Developed an understanding of the problem statement and present business situation in collaboration with the Data Architect and Enterprise Architect, and Solution advisors to provide solutions by performing various solution analysis.● Experience in understanding the Software Development Life Cycle (SDLC) and experience in system architecture mapping. ● The project was conducted according to the Waterfall methodology (Research and development centric), and we had a deep understanding of the requirement gathering process and maintaining documentation. Additionally, the project status, milestones and deliverables were communicated clearly and consistently to the internal team IT team, and all stakeholders.● Utilized FIS Integrity to manage daily liquidity, accurately forecast cash flows, and optimize short-term investments. Developed sophisticated liquidity models and reports to ensure optimal cash positioning and liquidity buffers.● Developed timelines for project delivery, and managed projects within the budget and resources to successful completion.● Understood the AS-IS system, developed the TO-BE system, and prepared the System Process Maps to approach clients.