SUMMARY

• Qualified Business Systems Analyst with 8+ years of experience in successful delivery of high - quality IT solutions in Banking Domain . Used analytical and critical thinking to solve a wide variety of critical business problems.
• Contributed to all phases of Software Development Life Cycle (SDLC) in multiple projects by working with the Business Users, Key Business Stakeholders, Subject Matter Experts (SMEs), Project Managers (PMs), Scrum Master, Product Owner, Architects, Testers, Developers, analysts and delivered end-to-end business solutions by facilitating important meetings. Worked in traditional Waterfall and Agile Methodologies such as Scrum , Scrum-Waterfall.
• Experience with compliances such as Anti Money Laundering (AML), Know Your Customer (KYC), Customer Due Diligence (CDD), Enhanced Due Diligence (EDD), OFAC(Office of Foreign Asset Control) and regulatory acts such as Bank Secrecy Act (BSA), Sarbanes-Oxley Act (SOX), USA Patriot Act, Dodd Frank Act, Gramm-Leach Bliley Act, Basel II, Basel III.
• Strong experience in requirement elicitation techniques like Brainstorming, JAD Sessions, Document Analysis, Interviews, Focus Groups, Job shadowing, Interface analysis, Requirements Workshops & Marketing Analysis.
• Extensive experience in creating Screen Mock-ups & Prototypes , conducting Gap Analysis , Impact Analysis , SWOT Analysis , Cost-Benefit Analysis , Risk Analysis , Root Cause Analysis , Feasibility Study and Return on Investment.
• Created several artifacts such as BRD (Business Requirements Document), FRD (Functional Requirements Document), SRS (Software Requirements Specification) and RTM (Requirements Traceability Matrix). Enabling documenting and collaboration through tools like Microsoft SharePoint, JIRA, VersionOne and Rally.
• Assisted PM in developing Project charter and Project Plan . Good understanding of Risk Identification , Risk Assessment , Risk Mitigation , Quantitative Risk Analysis and Qualitative Risk Analysis and Acquisition Plan.
• Competent in creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams , Activity Diagrams, Collaboration Diagrams, Data Flow Diagrams and Sequence Diagrams in MS Visio.
• Extensive experience in Information technology (IT) industry including hands on experience in Big Data ecosystem technologies such as Hadoop, MapReduce, Spark, Hive, HBase, Sqoop, Kafka, Oozie, Cassandra and Flume.
• Experience with Apache Spark with Scala, Python. Extensive experience with monitoring Spark workflows using Oozie.
• Worked with RDBMS including MySQL, Teradata and Oracle SQL. Proficient in writing HiveQL and SQL queries to achieve data manipulation and validate data quality and training data sets.
• Participated in Scrum ceremonies including Backlog Refinement , Sprint Planning , stand up meeting , Sprint Review and Sprint Retrospective and experience in Prioritizing Techniques like MOSCOW, KANO and Estimating Techniques like Planning Poker, Relative Mass Valuation, T-shirt Sizing and Bucket Sizing.
• Assisted product owner with the Definition of Done (DoD) and Definition of Ready (DoR) for backlog items.
• Helped with the story mapping process in Agile after elicitation and documentation of requirements (user stories).
• Facilitated Release Planning sessions for the product, assisted all the teams in writing business epics. Helped in the sizing and estimation and prioritization of epics by helping SMEs performing SWAG Analysis.
• Experienced with issue creation and resolution using Atlassian JIRA. Facilitated the team and created Scrum artifacts like Product Backlog and helped define the User Acceptance Criteria, MVP (Minimum Viable Product) and MRF (Minimum releasable features) to assist with an overall release and feature plan for the products.
• Hands on experience in writing and executing SQL queries using Data Definition Language (DDL), Data Manipulation Language (DML), DQL & DCL statements to perform CRUD operations on database and experience in executing queries like Joins, Subqueries and Aggregate functions. Good understanding of Procedures, Functions and Triggers.
• Created Source to Target Data Mapping documents indicating the source tables, data types, transformations required and business rules to be applied using Informatica. Knowledge of Data Mapping, Integration and Migration.
• Knowledge of the implementation of dimensional data modelling including the star and snowflake schema, dimension and fact tables and the various OLAP operations like slice, dice, roll-up and drill down.
• Experienced in creating Entity Relationship diagrams, Conceptual and Logical data models.
• Proficient in using tools like Informatica PowerCenter, Tableau, SSRS (SQL Server Reporting Services) and QlikView
• Managed ETL (Extract, Transform and Load) testing, data cleansing, transformation testing, data profiling in databases
• Assisted in performing automated test scripts to test APIs to check if data returned is in JSON, XML format as defined in the API documentation using Swagger Tool to execute the scripts during deployment or during manual testing.
• Knowledge of Service Oriented Architecture (SOA), 3- Tier and n-Tier architecture with a good understanding of XML, Web Services (SOAP, REST) at heterogenous IT environment.
• Experienced in Black Box, Manual, Unit, System, Performance, Load, Stress, Regression, Automated, Functional, Non-Functional, UAT, Smoke and Sanity Testing of applications with knowledge on STLC (Software Testing Lifecycle) by creating Test plan, Test Scripts, Test cases, Test Scenarios and Test Analysis reports .
• Experience in creating analytical Business Intelligence (BI) dashboards using Tableau, IBM Cognos.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum hybrid

Modeling Tools: Tableau, IBM Cognos, Power BI, Lucid Charts, MS Visio, Balsamiq

API Testing Tools: Postman, Swagger

ETL Tools: Informatica Power Center

Databases: MySQL, HBase, Oracle, SQL Server

Project Management Tools: Jira, Version-One, HP-ALM, MS Office

Languages: Scala, Python

Hadoop Ecosystem: Apache Hadoop 2.5, Apache Spark 1.6, Apache Sqoop Hive, Oozie, Kafka

PROFESSIONAL EXPERIENCE

Confidential -Riverwoods, IL

Senior Business System Analyst

Responsibilities:

• Participated in Program Increment Planning meeting and Scrum of Scrums. Assisted Product Owner in selecting Program Increment objectives that enable fulfillment of enterprise goals.
• Facilitated Interview sessions with Business Owners and Product Management to increase granularity of features.
• Assisted Scrum Master to facilitate various Scrum ceremonies such as Daily Standup Meeting, Sprint Planning Meeting, Sprint Review Meeting and Sprint Retrospective Meeting. Co-ordinated with the Product Owner in backlog grooming.
• Maintain communication channels with both the offshore teams and the clients to understand the business needs. Also share the model metrics with the teams.
• Used JIRA for the project planning, scheduling & status reporting, while maintaining the Kanban board to visualize the workflow.
• Held Knowledge Transfer Sessions while also assuming the role of Proxy Product Owner in certain instances & sprints. Made use of JIRA to draft epics, stories, tasks and Sprint Burndown Charts. Also validated tasks with SMART criteria of each one.
• Helped monitor the jobs using Oozie and troubleshoot delays with data ingestions issues.
• Helped troubleshoot Sqoop jobs for data ingestion from Oracle and Teradata databases.
• Assisted in troubleshooting Spark performance issues with Spark tuning.
• Validated data flow within the pipelines from different teams at the time set for the auto job run.
• Used HiveQL to validate the data accuracy and quality of data and to check for training data availability.
• Identified sources for OFAC sanction list having Specifically Designated Nationals (SDN), Politically Exposed Person (PEP) lists and implemented mechanisms for list refresh at specified intervals. Documented rules and filters to be applied before storing it to Apache Hive using Sqoop with Pig wrapper. The entire process was managed by Cloudera Hadoop Distribution.
• Coordinated with Data Analysts to implement data cleaning Spark jobs on data in Hive clusters before being fed into OFAC screening engine. Thresholds were identified and implemented to maintain data quality.
• Probabilistic model developed using Apache Mahout to screen ACH and International ACH were tuned to minimize False Positives and False Negatives for the organizations to avoid hefty fines.
• Created dashboards using Tableau and HiveQL to validate and monitor the performance of the OFAC screening engine.
• Used JIRA to generate and maintain the artifacts such as Product backlogs, Sprint backlogs, user stories, Impediments list, tasks, defects. Generated Burnup and Burndown charts to monitor Scrum Team performance to devise sprint strategies.
• Coordinated with the QA team in designing test plans and test cases for User Acceptance Testing.

Environment: SAFe, JIRA, HP QC 10.0, Lucid Charts, Cloudera, Hive, Scala, Spark, MS Project, MS Office, Microsoft SQL Server, Tableau

Confidential -Wilmington, DE

Senior Business System Analyst

Responsibilities:

• Facilitated requirements elicitation using Document Analysis, Interface Analysis and JAD session. Came up with a high-level model of the proposed solution to validate the proposed solution with SME’s and business users.
• Identified source, target and transformation logic and documented them in Data Specification Document and assisted Data Architects to create Data Flow Diagrams.
• Helped Product Owner (PO) break down Epics and Features into User Stories using Slicing techniques. Worked with Development team in proposing, negotiating Definition of Done and Acceptance criteria for Potential Shippable Product Increment (PSPI).
• Helped overcome technical barrier by creating UML diagrams using Lucid Charts.
• Assisted the product owner in defining Epics and slicing them into features and user stories. Facilitated Agile SCRUM ceremonies such as Sprint Planning, Daily Scrum, Sprint Review Meeting and Sprint Retrospective Meeting.
• Participated in Backlog Grooming Meeting and facilitated Slicing, Estimation and Prioritization of User Stories.
• Realized TWAIN enable scanners to capture images and send through MSXML6 to ABBYY FineReader.
• Enabled transfer of indexed and screened data from ABBYY FineReader to Hbase. Enabled transfer of batches from Hbase to ML Engine which classifies text and populates requisite fields in Salesforce Customer Relationship Management.
• Assisted Hadoop developers to manage nodes using Cloudera Enterprise Manager.
• Provided guidelines for developing the Intelligent Entity Extraction and Recognition Engine using Python libraries such as Pandas, Scikit-Learn, NumPy, NLTK, and TensorFlow.
• Validated data using HiveQL and SQL queries.
• Provided training data for ML engine from Hive using HiveQL. Triggered the workflows based on time or availability of XML data and performed ingestion and merging of the XML data using the Oozie Coordinator Engine which also automates the recurring Hadoop job. Conducted source and field mapping for Data Loader to Salesforce CRM.
• Created dashboards in Tableau and integrated it with Cloudera Enterprise to monitor performance metrics of the model.
• Completed technical API documentation using Swagger and API request and response testing using Postman.

Environment: Scrum, ABBYY FineReader, Cloudera Enterprise Manager, Apache Hbase, Oozie, ZooKeeper, Salesforce CRM, Data Loader, Hive, Pig, TWAIN, MSXML 6, Python.

Confidential - San Roman, CA

Business System Analyst

Responsibilities:

• Captured the high-level requirements in Confluence and JIRA to trace epics and user stories.
• Conducted Gap Analysis by highlighting the differences between the AS-IS and TO-BE model and developed the project requirements based on that.
• Coordinated with Banking Team to collect and organize KYC information for new and existing accounts, and review supporting documentation. Involved in walkthroughs with development team to discuss related issues.
• Conducted periodic AML risk-based review on individual and business accounts and highlighted high-risk jurisdictions, cash intensive/high risk businesses and Politically Exposed Persons (PEPs) accounts.
• Created page Mockups using Balsamiq and designed Activity Flow Diagrams , Use Case diagram , Sequence Diagrams using UML Business Process Modeling in MS Visio which aided in the understanding of the business user.
• Created technical requirement, functional and system specifications, project schedules using MS Project .
• Assisted the teams in creating clear and concise epics and further breaking them into user stories.
• Created Data mapping documents for tables and columns stored in the Database after coordinating with the development team, business users, subject matter experts, project managers and stakeholders.
• Involved in API documentation for REST/SOAP and documented XML request and responses. Tested the functionality of API endpoints and Bulk REST API calls using Postman and SOAP UI .
• Wrote and executed SQL queries to perform various types of analysis like data analysis, data validation and data manipulation using different types of Joins, Subqueries and Aggregate functions.
• Assisted the QA team to conduct UI Testing, functional testing, compliance tensing, performance testing and develop the test plan, test conditions, test cases using HP ALM. Performed checks against World Check Risk Screen, FinCEN list, and OFAC Specially Designated Nationals List (SDN) and Blocked Persons list to identify any potential discrepancies that can be corrected before going live. Also Executed View SQL queries with different Where Clauses in Views for reports to AML Compliance Office.

Environment: : Agile-Scrum, JIRA v6.4, Confluence v5.9, MS Visio, MS Project, REST API, Word, Excel, PowerPoint, Outlook, Oracle Database, SOAP UI, SharePoint 2013, Web Services, XML, JAVA, HTML, CSS, HP QC/ALM.

Confidential

Business Analyst

Responsibilities:

• Performed requirement walkthrough to understand and address the advantages of implementing the new system.
• Analyzed the existing system by implementing the Gap Analysis and created the AS-IS & TO-BE documents to address the areas of improvement and enhancements to address the system capabilities and needs.
• Performed Cost & Benefit Analysis , Feasibility Analysis to understand the net benefit and the feasibility.
• Assisted in the implementation of the Salesforce CRM to facilitate the development of the cloud-based Business Banking Console that would manage customer data and help bankers to recommend solutions to the customer.
• Used Salesforce Lightening Platform for Application Development.
• Actively participated in the transition process to the SFDC including the Design, Development, Planning, testing and integrating the Cloud services in SFDC for customer data management and enhancing the user experience.
• Identified the accounts and contacts of existing customers, leads and opportunities in source databases, source csv files and along with data team mapped them to the corresponding new records/fields on target Salesforce clouds.
• Built ER Diagrams as a part of cloud computing to visualize different entities and their relationships within the banking system and assisted the data team to migrate data from MySQL and Oracle databases onto the Salesforce CRM cloud using Dell Boomi, Data Loader and identified the corresponding records/fields.
• Used Salesforce Einstein Analytics on the customer data that would assist the bankers to identify the highest priority referrals based on the intelligent scoring.
• Assisted the QA team to develop the test plan and test cases to perform the testing and involved in Automated User Acceptance Testing (UAT) to ensure that the business requirements were being addressed in the test.
• Assisted the Quality Assurance team in performing functionality testing, reliability testing, and utility testing on the API web-services using tools Postman and Swagger .

Environment: Agile - Scrum, Salesforce CRM , Einstein Analytics, Community, Salesforce App Exchange, Windows 10, MS Office, Swagger, MS Visio, SOAP UI, JIRA 7.0, MS Project 2016, SharePoint 2013, Web Services, XML, SOAP, JAVA, REST, TABLEAU 8.2, MS SQL Server 2012, HTML, CSS, HP QC 10.0, Confluence 5.9.5.

Confidential

Business Systems Analyst

Responsibilities:

• Met with business stakeholders and successfully conducted Interviews, JAD sessions to gather functional and non-functional requirements to be communicated to the project team.
• Assisted PM with creating Project Plan and created several artifacts such as BRD, FRD, SRS and RTM.
• Assisted in mapping As-Is and To-Be processes for GAP analysis to identify the action steps to be implemented.
• Created Source to Target (STM) mappings in the Data Mapping Specification Document
• Examined Source Data using SQL queries as part of Data Profiling to configure and compute the profile data.
• Used Informatica tool to extract data from multiple systems during the Extract Load Transform (ELT) phase.
• Identified and documented Business Process Workflows using UML Diagrams and Assisted System Admin in defining process workflows using Business Process Execution Language Process Manager (BPEL PM).
• Reviewed and monitored Client Identification Program (CIP) aspects and account opening documents to ensure compliance with Know Your Customer (KYC), USA Patriot Act and Bank Secrecy Act (BSA).
• Created mockups and wireframes using Balsamiq to validate the User Interface.
• Assisted in configuring and defining case class, case type, case attributes and case priority matrix in the Enterprise Case Management (ECM) module to track and manage the investigation of cases.
• Configured and reviewed Standard Report Templates in the Regulatory Reporting feature to make filing of Suspicious Activity Reports (SAR’s) easier. Documented and tested API requests and responses using SOAP UI tool.
• Developed Test cases and assisted Quality Assurance team in System Integration Testing using HP ALM
• Created Test Cases for User Acceptance Testing (UAT) and validated the results.

Environment: Waterfall, Oracle Financial Services Analytical Application (OFSAA), Oracle 12c, MS Dynamics, MS Office, HP ALM, Jira, Informatica, Balsamiq, Soap UI, MS Visio, Tableau.

Confidential

Jr Python Developer

Responsibilities:

• Designed a dynamic and an interactive website that ensured positive customer experience, resulting in 40% increase in revenue.
• Developed, tested and debugged software tools.
• Implemented website functionality using class-based views and models to store data in SQLite database.
• Created, developed and maintained SQL processes for channel performance data warehousing
• Developed website using Python and Django Web Framework with the help of HTML template tagging, JS and Bootstrap in front end.
• Designed and configured database and back end application programs.
• Performed research to explore and identify new technological platforms.
• Collaborated with internal teams to convert end user feedback into meaningful and improved solutions.
• Resolved ongoing problems and accurately documented progress of project.

Environment: Oracle 12g, Ubuntu Linux, Python, Django web framework, HTML, CSS, Bootstrap, JavaScript.