SUMMARY

• Served as Senior Business Analyst, and Quality Assurance Analyst for over 8 years in Banking and Finance domain.
• Exposure to regulations & compliance such as FINRA, ERISA, SEC, GAAP, Bank Secrecy Act, SOX, Dodd Frank Act, Basel II, Basel III .
• Knowledge in core banking functionalities: Money deposits, withdrawals, account management, transaction management, KYC profile creation, import of new schemas for loan & disbursal management.
• Experienced in working with technologies like SWIFT, IBAN and Automated Clearing House (ACH).
• Analyzed the compliance documents for 401(k), 403(b), 401(a) and 457(b) accounts to facilitate the regulatory compliance within the data specification.
• Prior knowledge in financial and investment banking concepts: Financial Securities (Bonds, Stock, and Other Financial Instruments), Underwriting, Risk Management, and IRA, ETFs, Derivatives (Forwards, Futures, Options, Swaps), & Mutual funds.
• In depth knowledge of Software development life cycle (SDLC) methodologies like Waterfall, Scrum, Waterfall - Scrum hybrid, Scale Agile Framework (SAFe), Scrumban, Kanban, XP and Spiral.
• In depth knowledge of Requirement Management, Change Management, Defect Management, Release Management, Project Management and Risk Management using JIRA, HP ALM and MS Project as project management tools.
• Proficient in networking with individuals at various levels and facilitate Requirements Elicitation sessions like survey/questionnaires, Interviews, Brainstorming, Focus group, Requirement workshops, Interface analysis, Document analysis and JAD.
• Conducted detailed project analyses of Business Processes by GAP analysis (AS-IS & TO-BE), Risk analysis, Impact assessment, Cause and effect analysis (Root cause analysis), Effort estimation, Cost-Benefit analysis, SWOT analysis & Feasibility Analysis.
• Proficiency in documenting artifacts by gathering requirements such as Business Requirements Document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS), Use Case Document (USD), Requirement Traceability Matrix (RTM), Change Request Document, Work Breakdown Structure (WBS), Risk Register and Project Charter.
• Experience in creating Wireframes and Mockups using MS Visio and Balsamiq to visualize Graphical User Interface (GUI).
• Well acquainted with Unified Modeling Language (UML) diagrams including Use Cases, Activity Diagrams, Sequence Diagrams.
• Detailed working knowledge of SCRUM and its Ceremonies like Backlog Grooming, Release Planning, Sprint Planning, Daily Standups, Sprint Review and Sprint Retrospective Meetings and SAFe Ceremonies like PI Planning and Scrum of Scrum Meetings.
• Experienced in writing User Stories, defining Acceptance Criteria, writing Definition of Done (DOD) and Definition of Ready (DOR).
• Efficient in performing Vertical and Horizontal slicing of User stories and assisted the development team in assigning Story points by Estimation Techniques like Planning Poker, T shirt sizing, Relative Mass Valuation, Bucket sizing and Affinity Mapping and Assisted Product owner in Prioritizing User stories in Product Backlog artifact using Prioritization Techniques like Moscow and Kano.
• Assisted ART (Agile Release Train) and scrum teams in resolving dependencies and empowering teams with the Pillars of Scrum by increasing Transparency, Inspection and Adaptation and achieving goal to deliver the PSPI at the end of every Iteration.
• Excellent understanding of System Architecture like Service Oriented Architecture (SOA), Microservices and N-Tier architecture.
• Significant experience of working on Application Programming Interface (API) Documentation using Swagger and API Testing using POSTMAN and SOAP UI to test the request and responses of APIs in JSON and XML format.
• Performed Analysis to Identify the Sources, the Targets and wrote the Transformation Rules for the process of Data Migration.
• Involved in Conceptual, Logical models and created ER diagrams (Entity-Relationship diagrams) for data modeling phase.
• Experience in implementation of Dimensional data modeling with Star & Snowflake schema, Facts, Fact tables and Dimensions.
• Proficient in creation of Data Dictionary, Data Glossary and Data Mapping Specification document.
• Worked on Relational Database Management System (RDBMS), Data Warehouses, Data marts, Operational Data store (ODS).
• Extensive knowledge of ETL, Extraction of data from source systems, Transformation of data sources into an integrated system (Transformation includes Sorter, Filter, Source Analyzer, Aggregator, Joiner, Lookup, Stored Procedures, Source Qualifier, Expression and Router) and Load the data into the target database or data warehouse using Informatica PowerCenter.
• Experienced using SQL queries for Data Analysis, retrieval, validation, modification, creation of Data Manipulation Language (DML), Data Definition Language (DDL) & Data Control Language (DCL), using, Joins, Unions, order by, aggregation and stored procedures to extract the data from multiple sources and worked on various database like Oracle, SQL Server and MYSQL Workbench.
• Worked with AWS Cloud platform and its features which includes EC2, VPC, IAM, RDS, S3 and CloudWatch.
• Solid understanding of HADOOP environment and its components such as HDFS, YARN, MapReduce, Spark, etc;
• Worked with HADOOP developers enabling HADOOP Cluster creation and monitoring using Cloudera Enterprise Manager.
• Experienced in Black Box, Manual, Unit, System, System integration (SIT), Performance, Load, Stress, Regression, Automated, GUI, Non-Functional, User Acceptance UAT, Smoke and Sanity Testing of applications with knowledge on STLC (Software Testing Life Cycle) by creating Test plan, Test Scripts, Test cases, Test Scenarios, Test reports and Requirements Traceability Matrix.
• Used HP QC and Load Runner to test the system and report defects/bugs/Errors and Experienced in Bug tracking and following up for successful maintenance & delivery of service tickets using JIRA.
• Excellent in creating reports using Tableau, PowerBI and IBM Cognos and creating heat maps for Business Intelligence.

TECHNICAL SKILLS

• Business Skills: Change Management, Impact Analysis, Risk Analysis, Cost - Benefit Analysis, ROI Analysis, JAD Sessions, SWOT analysis
• Project Management Tools: MS Project (2013,2016), MS SharePoint (2010,2013), Confluence (v.6.4, 6.3, 6.2)
• SDLC Methodologies: Waterfall, Waterfall-scrum hybrid, Agile-Scrum, SAFE
• Requirement Management: MS Office, JIRA (v.6.3,7.0), HP ALM (v.11.5), HP-QC (v.11,12)
• Modeling Tools: MS Visio (v.14, 15, 16), Lucid Chart, Balsamiq
• ETL Tools: Informatica Power Center, AWS Glue
• Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up
• Databases: MYSQL, Microsoft SQL T-SQL, PL/SQL, Oracle RDBMS
• Defect Tracking/Testing Tools: HP QC v10.0, HP ALM V11.5, Load Runner (v. 11.5, 12.02), Selenium, POSTMAN, Soap UI, Cucumber, Swagger.
• Reporting/BI: Tableau, MS Power BI, IBM Cognos, Quick View 

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Sr. Business System Analyst

Responsibilities:

• Worked in Scrum Framework to achieve the project deadlines and post live support using Agile.
• Conducted JAD session, Questionnaire, one-on-one interviews to collect requirements with Product Owner about security levels and present security controls within the Enterprise.
• Performed market analysis to see the trends in Cybersecurity and recognize the advanced threats plaguing Enterprises.
• Conducted Cost Benefit analysis, Feasibility check, Risk analysis and Impact analysis of implementing such a system.
• Conducted extensive GAP analysis by identifying AS-IS of the project and TO-BE’s for process vision and process flows.
• Identified and documented Business Process Workflows and UML diagrams such as Use Case and Sequence diagrams.
• Extensively used JIRA to capture and manage User stories and actively participated in all the Scrum Ceremonies.
• Assisted in creating a Conceptual Model and Logical Model of the Cybersecurity decision platform.
• Created and maintained documentation as necessary for operational and security audits and to stay current on IT security threats and industry best practices.
• Performed Data Masking with Informatica to scramble sensitive data for any party without the right level of permission.
• Worked with the policy group in the organization to understand the enterprise’s security policies and making sure the organization is in compliance with policies by US NIST (National Institute of Science and Technology) Cybersecurity framework.
• Prepared for and conducted activities in compliance with Federal Guidelines (NIST 800-53, 800-53A, 800-37, 800-171, etc.) and client requirements and maintained compliance with all applicable regulations including the Bank Secrecy Act.
• Created Data Mapping Document to capture Source to Target Mappings and ensured required datasets were present.
• Utilized Microsoft Excel to create spreadsheets that require sorting, organizing, and manipulation of data in accordance to project specifications (pivot tables, v lookup, and IF nested statements).
• Created high and low fidelity Mockups, Wireframes to prototype the User Interface using Balsamiq.
• Collaborated with the Scrum team in preparing test data for positive and negative test scenarios as per application specifications.
• Acted as proxy scrum master, facilitating all sprint events and sprint reports (Burndown charts, information radiators).
• Used Web methods of GET, POST, DELETE & PUT for testing API endpoints and validated the response, response time & error code by executing HTTP requests using Postman, to ensure that API aligns with expectations.
• Performed Data migration audit, Data reconciliation and Exception Reporting and used QuerySurge to automate Data validation.
• Used IAM to grant fine-grained access to AWS resources to users and Managed roles including permissions of users to AWS account.
• Backed up AWS EC2 instances by creating an Amazon Machine Image (AMI) using AWS Lambda service to run the specific code.
• Create new EC2 instances in AWS, allocate volumes and give Provisionals using IAM.
• Used SQL queries (select, insert, update, delete, sub-queries, joins, etc;) to manipulate the data in the databases.
• Monitored the overall health of the cloud during module integration using AWS CloudWatch to handle potential issues as they arise.
• Kept track of bugs and defects using JIRA, maintained issue logs and handled the change requests efficiently.
• Developed Test Plans, Test Cases and Test Scripts to assist testing team in Performance Tests, Functional and Non-functional tests.

Environment: Agile-Scrum, Windows server 2016, Oracle 12c, MS Office (2016), Python, JIRA 7.0, Informatica PowerCenter 9.6, QuerySurge 5.0, Balsamiq, Postman v4.1.1, AWS, Oracle RDBMS, Confluence 6.4.

Confidential, Whippany, NJ

Sr. Business system Analyst

Responsibilities:

• Conducted face-to-face workshops & collaborative meetings with customers, stakeholders & development team to gather the list of high-level requirements for retirement accounts and calculation of score to deduce the benefits.
• Interviewed Subject Matter Experts and Business/Technical Leads to gather high-level Business Requirements.
• Performed Ad- hoc analysis, Cause & Effect Analysis, Risk consideration & GAP analysis and performance results.
• Worked with Retirement solutions team to understand the requirements and needs of potential customers so that User stories & A/c Criteria were created further for better converting the requirements in-to respective features.
• Created AS-IS and TO-BE processes and integrated them to show one end-to-end business model and process mapping.
• Created wireframes & mockup screens using MS Visio to facilitate discussion before designing the UI/UX application.
• Managed and monitored requirements by developing Requirement Traceability Matrix against the test cases.
• Executed SQL Queries to perform back-end testing to check the server side and data validation for the client end.
• Analyzed the compliance documents and pre-existing conditions such as 401(k), 403(b), 401(a) and 457(b) accounts to facilitate the regulatory compliance within the data specification.
• Measured VaR risk factors for IRA opening using historical method, Variance-covariance and Monte-Carlo Simulation.
• Compiled the end-to-end solution matrix for different age groups of investors according to the Publications 590-A & 590-B from IRS determining the RMD, IRA interest, Tax advantages, early savings and Control limits.
• Worked closely with business stakeholders, BI analysts, developers and SAS users to establish SLAs and acceptable key performance metrics for Hadoop service and offering.
• Participated in analyzing source system from front end, middle management and risk analytics to perform ingestion into HDFS.
• Participated in data extraction and data ingestion from data sources in Hadoop Data Lake by creating ETL pipeline using PIG and HIVE.
• Involved in cluster maintenance, commissioning and decommissioning data nodes, cluster monitoring, troubleshooting, manage and review data backups, manage and review Hadoop log files.
• Analyzed and logged the metadata of Hadoop using Mphasis platform, Used Apache Sqoop and Flume to extract data from Oracle and NOSQL relational databases. Used Apache mahout for analytics.
• Involved in planning the Hadoop cluster infrastructure, resource capacity and build plan for Hadoop cluster installation.
• Used SOAP API web services to communicate with data sources that include customer information of other modules.
• Facilitated discussion between Business Team and QA team to determine the test requirements, test plan, test cases development (around 55 test cases for 20 scenarios combined); conducted functional and non-functional testing.
• Conducted User Acceptance Testing (both Alpha & Beta) along with trade managers and registered representatives.
• Created and maintained dashboards for reporting the behavior of consumers using the application system to determine the retirement planning using QlikView for business analytics (factors chosen: age, gender, date, type of account, occupation, marital status, region, annual income, credit score worthiness, occupation and spending power).

Environment: JIRA 7.0, HTML, CSS, MS Word, MS Visio, UFT- Unified Functional Testing (v 14.01, 14.02) Ms Excel, RESTful API (Swagger tools), XML, Oracle DB, IBM WebSphere (app server), Cucumber v 3.1.0, Hadoop HiveQL, JavaScript, Java EE and QlikView v 11.20.