PROFESSIONAL SUMMARY:

• Business Systems Analyst with about 8 years of experience working primarily in Banking, Mortgage, and Finance domains using several Software Development Life Cycle (SDLC) methodologies including traditional Waterfall, Waterfall - Agile Hybrid to modern Agile frameworks like Scrum, Kanban and Scaled Agile Framework (SAFe) along with extensive knowledge in Scrumban, Extreme Programming (XP), Spiral and Rational Unified Process (RUP) and sound expertise in performing Business requirements elicitation, Business Intelligence Analysis and liaising among business and technical stakeholders.
• Extensive knowledge in Anti Money Laundering Process, Small Business Loans, and Delinquencies, Identity Access Management, Identity Access Governance, Risk-Based Access.
• Fair knowledge of the Banking sector’s regulatory and compliance acts relating to the fraudulent practices like Bank Secrecy Act, SOX, Suspicious Activity Report, Currency Transaction Report, Patriot Act, Know Your Customer, Enhanced Due Diligence, GAAP, Bank Regulations Act, Bank Holding Company Act, and AML laws, regulations, and procedures.
• Knowledge of Mortgage Loan Origination Systems, Loan Servicing, Payment Card Industry Data Security Standards (PCI DSS), and PA DSS requirements and compliances.
• Worked along with ITIL specialist to create, deliver and Support along with driving the stakeholder value by following the ITIL framework to create management standards and improve service practices.
• Working with the PM in determining the deliverables produced like Project Plan, Project Scope Statement, and identifying management tools like SWOT Analysis, Work Breakdown Structure (WBS), Critical Path Analysis, Earned Value Management (EVM) and making a RACI chart along with performing GAP Analysis, Cost-Benefit and Impact Analysis.
• Analyzing and disposing of the risk assessments prompted, along with fine-tuning the parameters required for Risk Assessments resulting in successful implementation and continuous development of the project along with the team.
• Seasoned in a wide variety of requirements elicitation techniques such as Document Analysis, Surveys, Interviews, Brainstorming, Introspection, Prototyping, Observations, Interface Analysis, Reverse Engineering and Requirements Workshops and experience conducting Joint Application Development (JAD) sessions.
• Transformed Business requirements into functional requirements and focused on documentation while creating artifacts such as Business Requirements Document (BRD), Use Case Specifications, Functional Requirements Document (FRD), and System Requirements Specifications (SRS) and having a broad knowledge on deliverables at various stages.
• Experience in organizing Backlog Grooming, Sprint Planning, Release Planning, Daily Scrum, Sprint Demo, Sprint Review Meetings and handling requirements churns, negotiating with development teams.
• Efficient in breaking EPICS and writing User Stories and Acceptance Criteria along with the INVEST criteria in mind.
• Experienced with a wide variety of Agile Estimation, Prioritization techniques like MoSCoW, Planning Poker and KANO models, the 100 Point Method, and the Walking skeleton, and horizontal and vertical slicing techniques.
• Experience in Organizational Change Management and Conflict Resolution at various stages of the Project lifecycle.
• Acclimatized to Business Process Modeling and Notation (BPMN), Workflow diagrams along with Behavioral Unified Modeling Language diagrams (UML) such as Activity, Use Case Diagrams and Interaction UML diagrams such as the Sequence, Timing diagrams and Process Maps by leveraging on various modeling tools like the MS Visio, Lucid Chart, and Balsamiq Mockups for creating low and high fidelity mockups and wireframes.
• Extensive subject knowledge in Data Modeling including creation of both conceptual & logical models, E-R Modeling, Data Mapping, Data Migration, Profiling, Integration and thorough knowledge of DBMS, and RDBMS concepts.
• Leveraged Informatica Power Center (IPC) for extraction, transformation, and loading (ETL) process, data mapping and transformations along with monitoring the workflow for Data Integration.
• Solid understanding of Enterprise Data Warehouse system (EDWH) along with Dimensional Modeling using Facts, Dimensions, Star and Snowflake Schemas & performing various operations like Slicing, Dicing, Roll Up, Drill Down, and Pivot on OLAP cubes of MOLAP, ROLAPb .
• Tracking the requirements along the project by creating a Requirements Traceability Matrix (RTM), and collaborating with the QA team in writing Test Cases, Test Plans, Bug Reports and Test Reports.
• Leveraged tools like JIRA, JIRA Zephyr for Issue tracking, User Stories, Test Cases and Traceability Matrix.
• Skilled in Business Intelligence and Data Mining tools like Python, Power BI, Tableau, and R Studio, for visualization.
• Leveraged collaboration and interactive tools like Confluence and SharePoint to improvise team’s communication.
• Profound knowledge of the Service-Oriented Architecture (SOA), Client-server Architecture, Application Programming Interfaces (API), the Simple Object Access Protocol (SOAP), Representational State Transfer (REST), eXtensible Markup Language (XML), JavaScript Object Notation (JSON), the Web Service Design Language (WSDL).
• Closely worked with the team while developing new APIs and enhancing existing APIs along with preparing API technical and testing documentation leveraging Postman and SoapUI.
• Exceptionally good in writing SQL queries Data Manipulation Language (DML), Data Definition Language (DDL), and the Data Control Language (DCL) for requirements research analysis, data analysis, data validation, and system testing.
• Worked closely with Business in developing BCP(Business continuity planning) by defining processes and procedures.
• Was involved in risk management which included BCP’s and DRP’s and documenting them for various scenarios.
• Skilled with Six Sigma, Lean methods, and applying them to improve various business processes.

TECHNICAL SKILLS:

Modeling Tools: MS Visio, Balsamiq Mockups, Lucid Chart.

BI/Reporting/ Visualization Tools: Tableau, Power BI, Alytrex, R studio, SSRS, MS Office Suite, Excel, Vlookups, PivotTables, VBA.

API Testing/Documentation Tools: Postman, SoapUI.

Version Control Tools: Microsoft TFS, CVS, GIT.

Statistical Tools: SAS, Minitab, Excel, R Studio.

DWH ETL Tools: Informatica Power Center, SSIS.

Database Management Tools: Microsoft SQL Server, MySQL, Oracle RDBMS.

Project Management Tools: Jira, MF QC/ALM, Confluence, MS Project, MS SharePoint, Rational RequisitePro, Rational ClearQuest

Testing Tools: Selinium, MF UFT

Languages and Others: Python, XML, HTML, MATLAB, SQL, C/C++, MS Office (Word, Excel, PowerPoint, Access), Jupyter Notebook(Python).

PROFESSIONAL EXPERIENCE:

Confidential, Boston, Massachusetts

Sr. Business Systems Analyst

Responsibilities:

• Scrupulously involved with AML Investigators, Analysts, and Auditors in identifying the process flows and improving the workflow to develop a Case Management Tool.
• Maintained compliances by studying and ensuring that the organization’s regulations, policies, procedures comply with work including Bank Secrecy Act(BSA), Anti Money laundering (AML), Know your Customer(KYC), Enhanced Due Diligence(EDD), Customer Due Diligence(CDD),SOX Compliance and Customer Identification Program(CIP).
• Focused on the SAR auto-filing process and continuous improvement of core metrics through automation and workflow
• Followed ITIL 4’s 9 guiding principles along with focusing on feedback and managing risks, standards and governance.
• Performed GAP Analysis reviewing the existing As-Is process and recommending possible areas of improvements in the future To-Be system.
• Made sure there was Process Alignment between Business Process Objectives and performance measures with organizational objectives and strategies to avoid conflicts and uncoordinated activities.
• Facilitated JAD sessions, interviews with SMEs & PO to better understand requirements of AML Process starting from false positives and alerts to filing the SAR reports.
• Conducted market research on features that could add weightage in the future and can be used by the AML Investigators.
• Wrote user Stories, set acceptance criteria and checked if they passed the criteria of INVEST rule.
• Held Knowledge Transfer sessions between the team and also leveraged JIRA for project planning, scheduling and drafting epics, stories, sprint burn up, burn down charts, expectation charts and status reporting while using the KANBAN board for the visual flow of the process.
• Created UML diagrams for Use Case, Sequence, Activity diagrams, Process flow diagrams by leveraging MS Visio.
• Created Data Mapping artifacts for the source and target data fields that are being populated automatically by the system like alerts, tables, SARs, CTRs, lists, transaction reports, KYC information, and also applying transformation logic where required and was responsible for assessing the cross impacts as a part of project support.
• Executed SQL queries by leveraging MySQL on large data sets for exploratory analysis, research analysis, and extracting data and ad-hoc reporting using SSRS.
• Used Balsamiq mockups for making high and low fidelity wireframes and mockups for features like Link Analysis and visualization tools being implemented in the application.
• Assisted in SOA by determining along with the team how the best requirements and Business Rules can be crafted and grouped for maximum efficiency and visibility during SOA.
• Instigated communication using Rest with data type JSON and then documented API and web service requests and responses using Postman.
• Acted as a through leader for data-informed initiatives and piloted the team’s direction overall.
• Knowledge in Agile techniques such as Test-Driven Development(TDD), Continuous Integration and assisted QA Team in testing the application during Smoke Testing, Black Box Testing, Regression and User Acceptance Testing and improving, altering, running Test Scripts using Jira-Zephyr, created training and testing material and documenting.
• Used Confluence as a collaboration tool for Knowledge sharing, Artifacts sharing, and as a communication tool.
• Used Excel VBA for creating Macros and automating Excel tasks like Project Status Reporting.
• Leveraged Tableau, V-lookups and Pivot Tables, VBA for ad-hoc reporting, automating Project Status and get insights from data for business needs.
• Performed Business Impact Analysis for determining and evaluating the effects of an interruption and to assess a disaster’s impact over time to establish recovery strategies, priorities and requirements based on criticality.
• Worked along with the business leaders and management in determining the system recovery priorities, dependencies and artifact them along with prioritizing the recovery efforts.
• Documented an ERT team and their roles and responsibilities as they handle the disaster recovery.
• Worked along with ITIL specialist to create, deliver and Support along with driving the stakeholder value by following the ITIL framework to create management standards.

Confidential, Santa Clara, California

Sr. Business/Data Systems Analyst

Responsibilities:

• Worked with the team during the source data exploration to identify the source and group data like credit worthiness, financial solvency, mortgage transactions data along with understanding the data structure, its interrelationships.
• Identified the GAP between source and target data by performing GAP Analysis and also identifying the source of the missing data that was needed there by lessening the inherent risks and increasing the overall value thus increasing ROI.
• Performed data assessment to check for inconsistency, integrity of the data along with data profiling and data validation.
• Leveraged on MS Access to collate data from various sources and analyze them along with improving the quality.
• Worked in SAFe (Scaled Agile Framework) with scrum framework at team level utilizing Kanban Visualization Board.
• Organized interviews, JAD sessions for capturing the end attributes of target data like transactions, customer information, Debt to Income Ratios, Risk Scores.
• Captured and converted all requirements and analyzed key points (KPI), pain points and recommended optimum solution.
• Created a Data Mapping specification artifact by comparing existing source system Data marts to attributes of target systems and defining the transition rules by collaborating with the SMEs.
• Formulated the Data Migration approach by assisting DB architects in modeling Bus Architecture, preparing ER diagrams and Schema diagrams by leveraging Lucid Chart to comprehend data warehouse and relationship among tables.
• Collaborated with Data Engineers to configure storage with a separate data mart to receive data associated with borrower and co-borrowers from application, performed and documented it.
• Analyzed requirements in terms of the dimensional data elements and measurable facts, grains and also created Proof of Concept (POC’s) for ELT process.
• Assisted in performing Data Normalization process to reduce anomalies, eliminate data redundancy.
• Actively involved in the ETL process using Informatica Power Center by assisting developers in designing transformation logic, preparing workflow sessions, and monitoring the process results.
• Leveraged Informatica Workspace like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer for transforming data from source to target.
• Actively involved in testing the migration solution in small subsets by ensuring the mappings, transformations and data cleansing routines are working.
• Responsible to review and approve any changes to master data in production along with making audit trail and logs.
• Integrated OLTP to the OLAP by using SSIS/SSAS as an ETL tool and used SSRS as a reporting tool.
• Used Excel VBA for Dashboard reporting purposes, data collection and prep up data for data analysis by creating Macros.
• Leveraged SQL queries for ad-hoc reporting, source data exploration and research analysis.
• Knowledge on Continuous Integration Continuous Delivery Pipeline (CICD) and worked along with Dev Ops.
• Validated data quality and integrity by assisting in operations like drill down, roll up, slice for OLAP cubes generated by OLAP queries.
• Assisted in creating a Data backup plan artifact for disaster recovery to ensure data is available to restore systems during emergency and non-emergency situations.
• Worked with the business in creating a recovery and response action plan to document the steps on recovery procedures to restore systems and data to ensure business continuity.
• Assisted in implementing various testing methods for Disaster recovery for multiple scenarios and documenting them.

Environment: Agile (SAFe) 4.0, Informatica Power Exchange, MS Access, Tableau, MySQL, Lucid Chart. JIRAv7.0, AWS Redshift, S3 Buckets.

Confidential, O’Fallon, Missouri

Business Systems Analyst

Responsibilities:

• Good understanding of leading IAM concepts, lifecycle, process architecture such as Least Privilege, Privileged Access, Roles and Data Mining, Segregation of Duty (SOD), and Role-Based Access Control (RBAC).
• Coordinated with business stakeholders to identify the Segregation of Duties (SOD) and enforce that policy.
• Basic understanding of compliance and audit requirements for business governance like SOX, PCI DSS, GBLA.
• Execution of role lifecycle processes like role definition, approval, retirement, role recertification, role maintenance.
• Proficient in requirements elicitation, test plans, scenarios, defect tracking, and any requirements churn.
• Transformed business requirements into functional design specifications like BRD, FRD, SRS artifacts and created architecture diagrams, end to end process flow diagrams and sequence diagrams.
• Handled Change requirements, Impact Analysis followed by proper documentation for Change and Impact Analysis.
• Profound knowledge of enterprise directory like Active Directory and also about LDAP.
• Tracked and maintained stakeholder requests and changes using the Requirements Traceability Matrix.
• Leveraged on SQL for research analysis, ad-hoc reporting and a good understanding of RDBMS concepts.
• Ability to read, create and modify UML diagrams leveraging on MS VISIO and also review process flows for gaps.
• Heavily involved in API testing and created API documentation along with experience in XML message creation (SOAP).
• Leveraged on Rational Requisite Pro for requirements management and Clear Quest for bug tracking system.
• Built complex business process workflows and diagrams to depict business and system processes leveraging MS VISIO.
• Managed the UAT process by performing smoke testing, test case validation and obtaining business approvals

Confidential

Business Data Analyst

Responsibilities:

• Generated questionnaires with an exhaustive list of control questions based on operational risk callouts.
• Strong knowledge of payment processors and PCI DSS, PA DSS, KYC compliance involved with the project.
• Identified, measured and monitored risks involved within the technologies that enable Mobile Financial Services (MFS).
• Created comprehensive Detailed Finding Reports (DFR’s) to document findings within each risk assessment and ROI.
• Identified GAP’s in the existing As-Is application and recommended possible areas of improvement in the To-Be system.
• Engaged with the SMEs to include or de-scope channels based on their existing operations/functionalities.
• Worked in a Scrum Framework facilitating Requirements Elicitation, elaboration, deriving user stories along with performing Stakeholder Analysis, Feasibility study and Use case Narratives.
• Helped Product Owner (PO) break down Epics and Features into User Stories using Slicing techniques and developing MVP. Worked with the Development team in proposing, negotiating Definition of Done and Acceptance criteria for Potentially Shippable Product Increment (PSPI).
• Leveraged on Jira developing user stories, backlog grooming, status reporting, burnup, burndown charts and used Confluence for collaboration, updating, document sharing and communication.
• Took part in scrum ceremonies which included Release Planning, Sprint Execution, Daily standups, Sprint Planning, and Sprint Retrospective meetings with the team.
• Elaborated the acceptance criteria for user stories and assisted in Solution support to the scrum team.
• Leveraged Power BI for ad-hoc reporting, visualizations and dashboards to present to the stakeholders.
• Teamed with the QA Team in developing and altering the test cases, test plans, test scenarios based on the requirements by the business and technical specifications in UAT using MF UFT along with test case automation.
• Maintained and backed different versions of documentation with Concurrent Version Systems (CVS) for future uses.

Environment: Agile(Scrum), JIRA7.0, MF UFT, MSVISIO, Confluence, MSSQL, BalsamiqMockups, MS OfficeSuite, Power BI.

Confidential

Business Data Analyst

Responsibilities:

• Elicited requirements for Portfolio System which included trend analysis, forecasting returns and interfaces for risk management.
• Facilitated JAD sessions with the business users, developers and administrators along with interviews with stakeholders and performed document analysis.
• Predicted portfolio’s returns using Monte Carlo Simulation.
• Created data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks.
• Leveraged on Tableau for creating ad-hoc reports, visualizations and dashboards and KPI reports.
• Assisted the QA team in writing test cases, test reports, test scenarios and taking part in UAT testing and tracked defects using HP QC ALM.
• Created ER diagrams and UML Activity, Use Case Diagrams by leveraging on MS VISIO.

Confidential

Data Analyst

Responsibilities:

• Managed metadata and modeled data marts of different transaction repositories, investments and finance.
• Leveraged Tableau reports utilizing Data Blending, multi-level hierarchy, Table Calculations, Parameters, Graphs.
• Designed, developed and implemented Power BI Dashboards, Scorecards & KPI Reports of no of transactions.
• Project Lead accountable for providing strategic and tactical leadership to ensure full project life cycle design, development, and implementation of database solutions.
• Performed due-diligence with the existing data in the data warehouse, generated ad-hoc SQL queries and transformation rules to compare and evaluate the prediction models.
• Leveraged Python for data manipulation, loading and extraction using python libraries such as Matplotlib, NumPy, SciPy, and Pandas for data analysis.

Environment: Waterfall, Python, MATLAB, Tableau, MySQL, Excel, MS Office Suite.