Software Development Data Analyst

Sudip Dhakal

*******************@*****.*** 718-***-**** Greater Seattle Area

PROFESSIONAL SUMMARY

Data Analyst with over 7+ years of experience in the Banking and Finance domain.

Extensive experience and knowledge on all stages of the Software Development Life Cycle (SDLC) and Object-Oriented Analysis and Design (OOAD) utilizing project life cycles such as Agile, Rational Unified Process (RUP), and Rapid Application Development (RAD).

Proficient in Python and SQL for data analysis, data manipulation, and automation of tasks, with extensive use in querying, extracting, and transforming large datasets.

Experience with R for statistical analysis, predictive modeling, and visualization of complex data.

Skilled in Spark for big data processing and analysis, implementing ETL pipelines, and working with distributed data environments.

Experience in diversified industry sectors including Credit/Debit Card, Home Mortgage, Online Banking, Mobile Banking, Deposits and Wealth Management.

Experience in Data Analysis, Data Profiling, Data Integration, Migration, Data governance and Metadata Management, Master Data Management and Configuration Management.

Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing, Testing) with expertise in Data Validation, Source to Target mappings, SQL Joins and Data Cleansing.

Expertise in data models, database design development, data mining and segmentation techniques.

Strong experience in Data Analysis, Data Profiling, Data Cleansing & Quality, Data Migration, Data Integration.

Experienced Data Modeler with strong conceptual, Logical and Physical Data Modeling skills, Data Profiling skills, Maintaining Data Quality, creating data mapping documents, writing functional specifications, queries.

Knowledge of full Project life Cycle, Software Development Life Cycle (SDLC) including Agile Scrum, Waterfall, and Spiral methodologies.

Extensive experience on usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Data analysis experience in business process modeling, creating prototypes, mockups of wireframes and Graphical User Interface (GUI) for web development applications

Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database

Advanced experience with Microsoft Office applications, including Excel and Access, as well as Oracle, VBA, SQL and Cognos

Experience in IT industry as BI Developer with Tableau and MS SQL Server with strong background in Databases and Data warehousing concepts.

Identify gaps in the requirement and prepare Gap analysis document.

Create Functional Specification Documents and Data Mapping Analysis for System Integrations.

Strong technical skills emphasizing Oracle ERP implementation, Project Management, Management Consulting, Strategic Planning, Forecasting, and Budgeting Process Management

Well versed in Business Process Modeling with expertise in creating User Cases, Sequence Diagrams, Class Diagrams, Activity Diagrams, writing User Stories.

Experienced in facilitating Joint Application Development (JAD) sessions with end-users, SMEs

Expertise includes following the RUP/Waterfall/Agile methodologies in defining the business process and acting as a bridge between the Management and the Development teams.

Extensive experience with authoring Business Requirements Document (BRD), Functional Specification Documents (FSD), Software Requirement Specifications (SRS), Use Case documentation,

Experience in all phases of the Software Development Life Cycle (SDLC) including Requirement gathering, Design, Development, Testing and Deployment.

Technical experience in Interfaces, Screen mockups, Data conversion and Data mapping.

Used various approaches of SDLC like Agile, RUP, and Waterfall

Well versed with Joint Application Development method (JAD), Rational Unified Process (RUP), have knowledge of Rapid Application development and Agile Application development methods.

Assisted QA Team in defining the Test Plans, Test Cases, and test execution.

Extensive expertise in databases like Oracle, SQL.

Exceptional Documentation Skills for writing Use Cases and Functional Requirement Documents.

Expertise in creating Use Case diagrams, Activity diagrams, Data Flow Diagrams (DFD), Sequence diagrams, State diagrams based on UML Methodology and business process flow diagrams using MS Visio/Enterprise Architect/Rational Rose.

Good Knowledge of Test Plan, Test Scripts and Test Cases for Functional, System, Integration, UAT, and Regression Testing based on the Design Document and User Requirement Document for the Functional, Security, and Performance Testing.

TECHNICAL SKILLS

Computer skills: Data cleaning, Data Mining, Data Visualization, Microsoft office.

Analysis tools: My SQL, Microsoft SQL server, Tableau Desktop, Microsoft Azure, Power BI Desktop, Alteryx.

Languages: Python, R, Spark, SQL, Pandas, NumPy, Scikit-learn,Spark, PySpark, SAS, XML.,

Cloud: Azure, AWS, GCP.

Tools: Git, Jira, Informatica, Azure DevOps.

WORK EXPERIENCE

Sr. Data Analyst [Truist Financial - Glen Allen, VA] [May 2023 - Present]

This project includes deposit and loan accounting, exception item processing, item processing, EFT, and branch check capture. This implementation includes the coordination of efforts across multiple vendors, regulatory agencies such as the FDIC, Fed Reserve, and key internal operations groups, migration of core data, AML reporting, and development of new interfaces to streamline processing, and bring added efficiencies. Responsible for the data conversion, vendor consolidation, and operational, compliance and regulatory procedures for the migration of deposit and loan accounting processing from Open Solutions to Fiserv Premier for core banking, and item processing.

Responsibilities:

Perform requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.

Prioritize project efforts, developed project plans, process flows and SRS using scrum.

Responsible for defining the key identifiers for each mapping and data modeling process.

Responsible for conversion of data in Data Mapping and writing transformation rules.

Interact with Software development team and Business users as a liaison in helping developers to understand the business requirements thereby ensuring the proposed applications comply with the business specifications.

Assist in the automation of the mortgage portal with the Loan IQ system for the conditional approval

Facilitate JAD sessions, Interview sessions, Questionnaire and Focus Groups to Elicit Requirements

Developing Use Case Models, Activity Diagrams, State Diagrams and Data Flow Diagrams (DFD) using Rational Rose prepared reports and presentation of key components and milestones to Top Management.

Participate in user meetings, gather Business requirements & specifications for the Data-warehouse design. Translate the user inputs into ETL design docs.

Create mockup diagrams using MS VISIO and provided the screenshots replicating the changes to the User Interface (UI) as per the requirements. User Interface Requirements were optimized for mobile and touch screen interfaces.

Work on Tableau workbooks from multiple data sources using Data Blending.

Create Users, User Groups and Projects through Tableau Server Web and assigned roles and permissions for Tableau Users.

Leveraged Python to automate data cleansing and transformation tasks, streamlining reporting processes and improving efficiency.

Used PySpark to handle large-scale data processing for core banking migration, improving data processing time by 30%.

Implemented SQL queries for in-depth analysis, data extraction, and validation from various data sources including SQL Server and Oracle databases

Create reports requesting cash deposits when transactions didn't reflect the correct shares' owner.

Work on Fixed Income, Bonds & Bond Trading Cycle, Equities & Equity Trade Cycle, Derivatives (Options & Futures), Portfolio Management, Wealth Management, and Sales & Marketing.

Participate in reconciliations and ensure the consistency of the exposure between the Accounting and the Risk systems for calculation of Risk Weighted Assets

Contribute to the data collection and data source analysis and use historical data as a base to prepare use cases and validate the aggregator

Requirement gathering from Inception and creating RTM, Functional Specification Documents and Data Mapping Analysis for System Integrations.

Responsible for defining the key identifiers for each mapping and data modeling process

Responsible for conversion of data in Data Mapping and writing transformation rules.

Involve in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.

Implement and manage the formal SDLC implementation using the RUP/Agile Methodologies (depending on the client and project).

Work with Agile and Waterfall methodology in tracking schedules, call out timeline conflicts and suggest timeline changes.

Define Use Cases and Process flows for new functionality and document in Business Requirements Document

Unveil and scrutinize new insights by diving deeply into the data combining various sources (database and web-analytics data sources) from across the business, to support decisions and resolve strategic questions

Coordinate tasks with other programmers, business users, database administrator, mainframe team, testing team and development team.

Create Dashboards, reports as needed using Tableau Desktop and Tableau Server.

Experience with developing User Stories throughout the Agile Lifecycle as well as created UML diagrams such as Use Case, Activity, ER diagram and Chart diagrams with MS Visio.

Conduct Impact analysis when there is any change in the requirements and updated the Business Requirements Document (BRD) and Systems Requirements Specification (SRS).

Facilitate meetings with the technical team and client team to analyze the current process and gather requirements for the proposed process.

Identify potential gaps and fits within project plans, to vet out potential issues

Assist in documentation of the OnBase solutions using Microsoft Visio and Project.

Write and execute SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.

Perform Unit Testing and User Acceptance testing (UAT) and document detailed results.

Design and develop Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML

Interact with the ETL, BI teams to understand / support on various ongoing projects.

Translate business concepts into XML vocabularies by designing XML Schemas with UML.

Design Star and Snowflake Data Models for Enterprise Data Warehouse using Erwin.

Use SQL for inserting columns in Tables and deletion of Rows.

Data Analyst [Ally Financial - Detroit, MI] [Sep 2021 – March 2023]

The central idea behind the project was to automate the mortgage loan origination process beginning with the customer initiation to title transfer. All business functions of the loan process such as the appraisal, credit, income, and title functionalities were to be performed by the system. Additional features required were account administration, customer service, payment processing, account reporting, arrears management, foreclosure, and securitization.

Responsibilities:

Created functional specification document (FSD) based on the final business requirement document (BRD) and performed FSD walk through with the team and managements.

Created a high-level use case with the normal, alternative, and exceptional paths for different user scenarios.

Created a high-level swim lane diagram to document the front end and back-end process steps, activities, and related web services.

Participated in daily Agile Scrum, Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories for a project of changing the client's software maintenance structure of their various software products.

Created a wire frame diagrams for the UI update of the mobile application of the Bill Pay.

Involved in digital strategy planning and implementing with cross domains with the goals of higher traffic, better client experience and better customer service for mobile app.

Created test cases for FDR to perform Integration tests and verify the integrity of the accounts built on FDR.

Built predictive models using R for mortgage loan forecasting, increasing accuracy of risk assessments.

Utilized SQL for developing and executing complex queries to validate and manipulate data for automated mortgage processes.

Analyzed large datasets using Spark to identify trends and insights for strategic business decisions.

Assisted on projects for data movement for both internal and external company transfers. This involved assisting to create files and transaction cards for MSP, files for external investors, government required files, and files for primary lenders.

Created wireframes, mockups and prototypes for user interface and user experience applications.

Gathered requirements for business process flow and on-screen flow for wizards driven products from SMEs and Salespeople and created Requirements documents to implement in Pega PRPC.

Worked with ETL, Informatica, component testing on windows and mainframe / AS400, performed component test, assembly test and product tests in different stage of software development life cycle (SDLC),

Collect, analyze, and validate data to allow for accurate Tableau based reporting.

Created action filters, parameters, and calculated sets for preparing dashboards and worksheets using Tableau.

Create Created Mock-up for better visualization and understanding of the software solution.

Develop all UAT testing scripts, and management internal staff testing assignments through completion of specific UAT testing phases.

Created SQL database tables and views for the data collected from the field.

Provided data modeling support for numerous strategic application development projects.

Wrote and ran SQL queries in Microsoft SQL Server to check the status of the loan in the database and to research the issues in production.

Effectively implementation of the System Development Life Cycle SDLC, the BABOK and RUP methodologies from Initiation to Deployment.

Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Requirement gathering from Inception and creating RTM, Functional Specification Documents and Data Mapping Analysis for System Integrations.

Involved in creating Test Case Scenarios, Test Case Execution and maintaining defects using JIRA Tool.

Analyzed current investor report field calculations and defined future state calculations. Extensive use of MSP Navigator to research fields and reports. Worked with BKFS to define fields and functionality. Utilized Excel spreadsheets to track and document report requirements. Experience with full suite of MS products.

Design of Big Data platform technology architecture. The scope includes data intake, data staging, data warehousing, and high-performance analytics environment.

Dealt with AML, KYC, PEP, USA PATRIOT act, OFAC, Suspicious Activity Reports (SAR) subjects to understand the verification process of the existing and non-existing customers, and accounts funding, Certificate of Deposit, Money Transfer transactions.

Performed GAP/ AS IS- TO BE analysis to identify the deficiencies in the system by comparing the actual objectives with the desired system objectives

Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.

Implemented ETL techniques for Data Conversion, Data Extraction and Data Mapping for different processes as well as applications.

Involved in the JAR and JAD Sessions, daily scrum session, scoreboard sessions, high level release and deployment sessions as part of an Agile Methodology.

Optimized and updated UML Models (Visio) and Relational Data Models for various applications.

Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.

Data Analyst [Bank Leumi – NYC, NY] [January 2020 - August 2021]

The project's scope was to build an Integrated Online Portfolio Management System, which encompasses an individual's Bank Accounts, Credit Cards, Loan Accounts, Investments and Mortgage. This Online Portfolio system helps the users to access all the financial accounts on one page and get real time balances for each account. This helps the bank to suggest a more comprehensive offering to its clients and propose different options for loans, credit cards and other financial marketing programs.

Responsibilities:

Worked with Business Users to define Functional Requirements and Business Process Flows.

Interfaced with SMEs to prepare Functional (FR) and Non-Functional Requirement (NFR) Documents.

Conducted JAD/JRD sessions with business users and development teams to gather Business, Application & Quality requirements.

Involved in Mainly in Integration testing, Regression, System, Smoke, and UAT (User Acceptance testing).

Worked on researching and pre-grooming user stories by understanding the business requirements as stated in the business requirements matrix by including key members from business teams, underwriting team, and closing SMEs and later translating those in an IT standpoint to explain the work to the team.

Extensively worked on testing web services built using SOAP UI

Developed Business Requirement Document (BRD) and Use Case Document (UCD).

Conducted previews and User Acceptance Test (UAT) sessions with the marketing team.

Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.

Prepared graphs and diagrams using MS Visio and MS Excel to understand and describe Collateral approach to the developers

Processed teller transactions for customers, including servicing client accounts, accepting loan payments, managing safe deposit box payments, cashing checks, balancing cash drawer, handling night deposits, and correcting discrepancies.

Performed tasks like test cases, identifying defects, mockups, quality reporting, data cleansing and data quality.

Used Python scripts to automate portfolio management system processes, reducing manual efforts by 25%.

Conducted statistical analysis and visualized insights using R for investment product evaluations.

Wrote optimized SQL queries for portfolio performance analysis, supporting real-time decision-making.

Followed the principles of Agile methodology during the entire development process.

Responsible for forecasting, financial reporting and review of company's accounting function and managed annual budget for Global Equity and Derivatives.

Worked with the database designer in data modeling through ER diagrams to identify tables, attributes, and relationships between tables.

Performed data analysis for the financial data and created SQL queries for data validation and accuracy

Conducted Functional Testing by modeling the calculation methodology on excel and then comparing with the actual result

Gathered and documented the business requirements for the transition of the Investor Reporting work stream from their Legacy systems to BKFS MSP.

Analyzed data architecture, documented, and delivered data mapping, performed risk analysis.

Worked on User Acceptance Testing (UAT) with users along with providing training to end-users.

Managed defects and assisted QA team in developing test strategy, test plan, test cases, and test scripts; and conducted unit testing, integration testing, system testing, and regression testing

Communicated with multiple departments to ensure the mortgage process was followed: Underwriting, sales, closing, and subordinations.

Coordinated Joint Application Development (JAD), Interview sessions with stakeholders throughout SDLC to resolve open issues.

Responsible for ETL setup for data transfer and data integration across different applications, RDBMS, flat files and mainframe systems.

Created capacity, process adherence metrics for the team using Tableau.

Handle any custom development request for interface functionality outside of the scope of our standard interface templates, including SQL stored procedure.

Participated in daily Agile Scrum, Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories for the project of changing the client's software maintenance structure of their various software products.

Gathered data and documenting it for further reference and designed Database using Erwin DATA modeler.

Worked closely with application analyst, interface engineers, and vendors to design, test, and troubleshoot interfaces.

Developed and executed various VB Scripts using QTP for automated testing of various functionalities of the applications.

Wrote scripts using regular expressions, created various Checkpoints and handles unexpected errors using exception handing mechanism of QTP.

Primary duties consisted of data analysis by investigating, evaluating, and forecasting residential and commercial mortgage loan data, private party foreclosure buy-outs, title deeds, and business loans.

Analyzed and evaluated customer financial services products including mutual funds, mortgages, stocks, bonds, annuities, and investments.

Create screen mockups for the new platform using MS Visio.

Data Analyst [Wintrust Financial – Rosemont, IL] [June 2017 – November 2019]

Translated business concepts into XML vocabularies by designing XML Schemas with UML.

Conducted the FRD reviews and walkthroughs with designers, developers, and stakeholders.

Work with business process owners with the performance of UAT in the development environment for quality assurance.

Evaluate workflows, methods, and recommend appropriate solutions.

Created User Interface Specification Documents, which comprised of system mock-ups and page field elements.

Gather analytical data to develop functional requirements using data modeling and ETL tools.

Designed User Interfaces and mockup screens using HTML to validate the requirements.

Gathered and documented business requirements, business process flows, use cases using different business techniques such as interviewing customer & stakeholders, workshop facilitation, conducting seminars, presentations, storyboards, JAD sessions.

Work with business process owners with the creation of detailed UAT test scripts designed to ensure that all requirements have been successfully executed to meet customer and stakeholder expectations.

Implement the financial database and reporting structure ensuring that proper accounting processes and contractual requirements are supported.

Create Tableau Dashboards with interactive views, trends, and drill downs along with user level security.

Facilitated daily Scrum meetings, Sprint review meetings, and Sprint retrospective meetings, assisting Scrum Master in developing project timelines/deliverables/strategies for effective project management during Sprint Meetings. Acted as Scrum master in some critical events.

Manage day to day execution of accounting system implementation.

Designed and implemented basic SQL queries for QA testing and report/data validation.

Conduct requirement gathering sessions including JAD, Brainstorming, Questionnaire with Business Users and Stakeholders to understand the business process and the system capabilities in reference to BABOK.

Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams (UML).

Created Project management plans for managing on-time delivery using MS Project along with writing test cases, unit, and systems integration test plans in Test Director.

Conducted User Acceptance Testing (UAT).

Documentation of Training Material for the implementation and the maintenance of the application.

EDUCATION

Golden Gate University- MS Accounting Data and Analytics

Queens College- BA Accounting

Contact this candidate