SUMMARY

• Business Systems Analyst wif 8 years of experience in Business Development Process and System and Data Analysis. Experience wif working in the domain of Banking, Finance and Ecommerce.
• Business Systems Analyst wif proven ability to work wif self - organizing and cross-functional teams in a wide spectrum of banking and ecommerce sectors. Have hands on Experience on Waterfall, Agile Scrum and Hybrid of Waterfall and Agile methodologies.
• Strong noledge of Software Development Life Cycle (SDLC) and its different phases - Scope Initiation, Requirements elicitation, Analysis/Design, Development and Testing.
• Good understanding of AML laws like USA PATRIOT Act, Bank Secrecy Act and lending laws like Real Estate Settlement Procedures Act, Truth in Lending Act, Fair Housing Act and Fair Credit Reporting Act
• Extensive noledge of various concepts like Loan Origination and Processing, Anti-Money Laundering, Customer Relationship Management, Trade Financing, Data Warehousing, Machine learning.
• Participated in Scrum Ceremonies (Backlog Grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) for Agile Scrum Methodology.
• Experience in conducting GAP analysis, SWOT analysis, Cost benefit analysis, Root cause analysis, Feasibility study, Impact analysis, Risk Analysis and As-Is and To-Be business analysis
• Proficient in networking wif individuals at various levels while organizing, conducting and facilitating elicitation sessions such as Brainstorming and JAD sessions
• Well acquainted wif workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Class Diagrams, Sequence Diagrams, Data Flow Diagrams, Data Mapping and ER Diagrams
• Collaborated on creating Work Breakdown Structure (WBS) using MS Project to track milestones
• Skillful at designing and implementing Hive and SQL queries using joins (inner joins, outer joins), unions, sub queries, common table expressions, inline views, aggregate and window functions (sum, avg, count, row number, rank, dense rank, lead, lag, ntile) to extract data from different data sources
• Dimensional Data Modeling (Star, Snowflake, Constellation, Facts, Dimensions, Conceptual, Logical and Physical) experience using Erwin Data Modeler
• Extensive noledge in architecture design of Extract, Transform, Load environment using Mapping Designer, Source Analyzer, Target Designer, Transformation Developer, Workflow Manager, Repository Manager and Workflow Monitor in Informatica Power Center.
• Significant experience gained by extensive client interactions in highly cohesive and loosely coupled Service Oriented Architecture (SOA) and 3-tier architecture wif strong and in-depth understanding of XML, Web Services (WSDL, SOAP, REST) and SQL across heterogeneous IT environments
• Extensive experience testing SOAP and Rest Web Services using Postman and SoapUI
• Adept at supervising Black-box Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, Security Testing, User Acceptance Testing (UAT), Load Testing and Performance Testing
• Strong noledge of Automation Testing using Selenium Web Driver and QTP. Assisted automation test engineers to develop automation testing scripts for web and client server applications.
• Thorough understanding of Business Intelligence (BI) and experience in creating interactive, analytical dashboards using Tableau and MicroStrategy for decision making.
• Extensive hands on experience using R for data manipulation, exploratory data analysis, statistical analysis, machine learning and reporting using packages like plyr, data.table, tidyverse, ggplot2, caret, lubridate, knitr,e 1071, nnet, stringr, stringi, dplyr.
• Excellent Analytical, Problem Solving, Communication and Documentation skills. Dedicated & Self- motivated, proven Leadership capabilities and Time Management skills

TECHNICAL SKILLS

Project Management Tools/Methodology: Unified Modeling Language (UML), MS Project, Rally, JIRA, Agile-Scrum, Waterfall-Scrum, Waterfall, Extreme Programming, Kanban, RUP

Requirement: MS Office Suite, JIRA, Confluence, Rational Requisite Pro

Defect Tracking: JIRA, HP ALM, HP QC, Rational ClearQuest

Modeling: MS Visio, Smart Draw, Erwin Data Modeler, Mockup Screens, Balsamiq

ETL/Reporting Tools: Informatica, SSAS, SSRS, Tableau, Pentaho, MicroStrategy, Salesforce, QlikView

Databases: Oracle, Teradata, SQL Server, MySQL, PostgreSQL, DB2

Languages: R, Python, Java, C, C++, SQL, PLSQL, HTML, JavaScript

Big Data Tools: Hadoop, Hive, Pig, BigQuery, AWS Redshift, Sqoop, Flume, Storm, Kafka, HBase

Testing Tools: HP QC, HP ALM, QTP, Selenium, Load runner, Postman and SOAP UI

Data Warehousing: Data Marts, Data Modeling, OLAP, OLTP, Data Mining, ETL, Slicing/Dicing, Drill Down/ Roll up, Pivot, Star and Snowflake Schema

Web Services API: SOAP, REST, XML, JSON

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Senior Business Systems Analyst

Responsibilities:

• Performed impact analysis on the changes to the different objects (tables and views) in integrated data warehouse (IDW) by interacting wif the downstream users.
• Interacted extensively wif the Product Owner, Business Analysts, Data Modeler, ETL lead from different teams to understand the requirements as well as discuss Business/technical challenges.
• Created Business Requirement Documents for the Fact and Dimension tables as well as reporting views.
• Developed complex SQL queries using joins (left, inner, outer), union, union all, coalesce, case when statements, group by, having, nested sub-queries, row number() etc. to perform analysis.
• Developed and tested logic for the newness attributes in the Account Dimension.
• Reviewed data models (logical and physical) as well as SQL code (DDL) before handing them over to ETL team for development. Performed Production Migration Checks.
• Performed User Acceptance Testing on the different IDW objects and new processes being developed.
• Designed framework for UMT applications for the new hierarchies (Segment, Revenue and Expense).
• Performed analysis on how the tables in the Single Gateway source be retired and new tables be built in the Finance Reporting Layer.
• Participated in various scrum meetings like daily stand up, sprint retrospective as well as sprint demo.
• Performed manual data quality checks for various financial metrics (Net New Assets, Count of Brokerage Accounts, Count of Open/Active Brokerage Accounts) and developed process to automate those checks.
• Visualized dashboards in Tableau for Management Reporting to analyze trends in financial metrics like NNA, NTR Households, New Households, New Advisors etc.
• Worked on data governance activities relating to Segment Hierarchy using Collibra.

Environment: Scrum, Teradata, SQL Server, SQL, Toad, Tableau, MS Word, MS PowerPoint, MS Excel, Erwin Data Modeler, JIRA, Visio, Collibra, Hadoop

Confidential, Phoenix, AZ

Senior Business Systems Analyst

Responsibilities:

• Good understanding of Mortgage Lending, Cash Management, Debit and Credit cards
• Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one session.
• Prepared Business Requirement Document (BRD). Analyzed, modified and validated these documents.
• Developed Conceptual and Logical ER diagrams. Created Data Dictionary for the data models.
• Conducted Impact Analysis for all Change requirements and determined the impact of a change request on project scope, project timelines, and other projects/systems effected, project cost and presented the findings to project stakeholders and Sr. Management
• Assisted Data Modelers wif logical and physical data modeling, reviewed and validated Relational and Fact/Dimensional (Star - Schema, Snowflake, slowly changing type 1 and type 2) Data models.
• Involved in documentation of Data Mappings from source data fields to their related target data fields and ETL specifications for Data warehouse.
• Worked on developing Mappings, Mapplets, Sessions, Workflows and Worklets for data loads using Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Designed and developed complex mappings in Informatica to load the data from various sources using different transformations such as Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.\
• Provided production support to resolve issues after implementation of new enhancements or upgrades.
• Optimized and improved performance of SQL queries using SQL Profiler and SQL Query Analyzer.
• Wrote complex SQL queries using joins, inline views, common table expressions (CTEs), unions, sub queries, window functions (rank, dense rank, sum, avg, count, lead, lag, ntile) to analyze data
• Worked closely wif the testing teams to debug the defects and testing issues.
• Involved in Integration testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Created Tableau dashboards using advance charts, drill downs, stack bars, bar graphs, scattered plots, geographical maps to gather key business insights.

Environment: Waterfall-Scrum Hybrid, Oracle 11g, SQL, Informatica PowerCenter, Tableau, Business Objects, MS Word, MS PowerPoint, MS Excel, Erwin Data Modeler, JIRA

Confidential, Columbus, Ohio

Senior Business Systems Analyst

Responsibilities:

• Actively participated in training initiatives related to Federal Anti-Money Laundering, BASEL III, Dodd-Frank Compliances and Mortgage Reform Acts.
• Generated a streamline process to understand the various steps in the loan lifecycle and desired functionality of the new system by interacting wif users, management, SME (Subject Matter Expert), stakeholders, lenders, underwriters using JAD sessions and interviews.
• Conducted Gap analysis between the current loan application system & the target automated system
• Created mock ups and wireframes using Mockup Screens and Balsamiq for the loan officer, loan processor and customer portal interfaces
• Created Activity Diagrams, Sequence Diagrams using MS Visio to depict the flow of functionality
• Maintained the Requirements Traceability Matrix (RTM) across the deliverables of a project to keep track of the origin and status of requirements.
• Developed complex SQL queries using joins (inner, left, right, full outer), sub queries, unions and common table expressions(CTEs) to validate the data dat is written into the database after performing various test scenarios as per the functional requirements.
• Tested Web Services, Validated Request and Response XML, SOAP Calls and WSDL using SOAPUI tool. Added data related assertions to validate response XML in Web Services.
• Assisted Automation Test Engineers in preparing Test Suites and Test Cases using Selenium Web Driver to perform functional testing of web-based applications. Formulated Test Strategy and Test Plans.
• Assisted end users to perform User Acceptance Testing. Assisted QA team in designing Test Cases, Test Plans and Test Scenarios to perform Functional Testing, Regression, System and Load Testing.
• Analyzed Business Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure dat test cases reflect user needs for the Performance, Usability and Security requirements
• Developed Tableau Dashboards to visualize loan trends using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts, Bar Charts and Density Chart.
• Generated Dashboards wif Quick filters, Parameters and sets to handle views more efficiently
• Analyzed mortgage data using R Packages to find useful insights about customer behavior and reported those findings to the Director of Analytics using PowerPoint presentations.

Environment: Scrum, Tableau, Oracle WebLogic, Oracle 11g, JavaScript, SQL, jQuery, React.JS, Salesforce, Angular JS, JIRA, R, MS Visio, Mockup Screens, Selenium, Balsamiq, HTML, XML, SOAP UI, Windows Server 2008.

Confidential, Charlotte, NC

Senior Business Systems Analyst

Responsibilities:

• Elicited and gathered user and business requirements through open ended discussions through brainstorming and conducted JAD sessions to gather cross function information and different opinions.
• Interacted wif different business groups to perform Gap Analysis to identify the deficiencies in the system by comparing the actual objectives wif the system objectives desired
• Worked wif subject matter experts and project team to perform Financial Assessment, Security & Compliance Assessment, Technical and Functional assessment comparing the existing environment (Microsoft SQL Server-based data warehouse) wif a new AWS environment.
• Assisted in designing, planning and managing the data migration process from on on-premises Microsoft SQL Server based data warehouse to AWS Redshift.
• Facilitated and ensured the Agile Scrum ceremonies (Daily Standups, Sprint Review and Sprint Retrospective Meetings) were well coordinated wif the Product Owner and the scrum team to ensure delivered product meets the desired acceptance criteria.
• Created Data Mapping Document and Data Dictionary for the data models
• Prepared Requirement Traceability Matrix and interacted wif QA team to ensure quality of software
• Developed best practices, processes, and standards for effectively carrying out data migration activities.
• Created new, and modified existing SQL queries using joins, unions, subqueries, derived tables for use in the data integrity testing of the data warehouse application's ETL process.
• Worked wif QA team to design and develop Test Schedule, Test Plan and Test Cases to perform Integration and System Testing of the data warehouse
• Performed Data Mining using R to find correlation and pattern in existing data
• Developed timelines for project delivery, and managed project and resources to successful completion.

Environment: Waterfall-Scrum Hybrid, SQL Server 2008, AS400/DB2, SQL, AWS Redshift, Quality Center, JIRA, Sqoop, Amazon S3, Amazon EC2, DynamoDB, Lambda, MySQL, SSRS, SSAS, Tableau, R.

Confidential, New York, NY

Business Systems Analyst

Responsibilities:

• Managed investigations of suspected cases of activity related to money laundering, terrorist financing, tax evasion and prepared Suspicious Activity Reports (SARs) in accordance wif FinCENs guidance.
• Performed periodic Enhance Due Diligence (EDD) reviews of Banks high-risk customers, 90-Day Reviews, Branch Referrals, 314(a) requests. Interacted wif Branches and departments on Bank Secrecy Act issues.
• Used MS Visio for Process Modeling, Process Mapping and Business Process Flow diagrams. Understood the AS-IS system, developed the TO- BE system concepts and prepared the System Process Maps
• Participated in SCRUM meetings (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective and Backlog Grooming) and worked closely wif the Subject Matter Experts and the Product Owner.
• Prepared Business Requirement Document (BRD) and Drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents
• Designed and implemented queries in HiveQL using joins, unions and sub-queries for Data Validation
• Assisted Automation Test Engineers in creating automated tests to monitor APIs for uptime, responsiveness, and correctness using Postman’s API Development Environment (ADE). Used Get, POST, Delete and PUT methods for API testing
• Assisted in developing QA Test Plans for Functional, Integration and System Testing, performed black box testing. Also assisted in GUI testing, smoke testing, regression testing and Performance Testing.
• Extensively involved in the User Acceptance Testing phase to ensure the requirements and functionality of the system was in accordance to the users and their feedback was incorporated
• Logged and tracked the defects using HP ALM and created an error repository to store them
• Performed detailed analyses to detect patterns, trends, anomalies and schemes in transactions and relationships across multiple businesses/products using R
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly wif the usage of quick filters for on demand needed information.
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes

Environment: Waterfall-Scrum Hybrid, HDFS, HBase, Spark, Python, R, HP ALM, MS Visio, Pentaho, Tableau, Kafka, Storm, Flume, Hive, Sqoop, Postman, JIRA, Linux

Confidential

Business Analyst

Responsibilities:

• Conducted highly interactive JAD sessions wif project stakeholders, subject matter experts (SME’s) and project management team for requirement gathering
• Extracted data from various file formats and databases, including Excel, CSV, PDF, SQL Server and HDFS
• Communicated effectively wif client/onsite personnel and documented understanding and action items from meetings.
• Developed a model for a banking client to predict the customers who would subscribe to a loan offer using machine learning techniques like Logistic Regression, Random Forests, SVM, XGBoost
• Developed a fraud detection model to detect credit card frauds for a financial services firm
• Wrote complex SQL queries using joins (left, right, inner, full), group by, having, unions, nested subqueries and window functions (rank, dense rank, row number, lead, lag, ntile)
• Extracted, cleaned, and manipulated large datasets (structured and unstructured) for model building using Python libraries like Pandas and Numpy
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality

Environment: R, R Studio, PyCharm, Python, MS SQL Server, Oracle SQL Developer, Teradata, Tableau Server, Tableau Desktop, Hadoop, HDFS, HiveQL, MS Excel, MS PowerPoint, MS Word, Windows Server 2008, Linux

Confidential

Data Analyst

Responsibilities:

• Conducted extensive meetings and brainstorming sessions to collect the data requirements and technical specifications to move ahead wif the analysis team and business clients
• Responsible for creating, analyzing and reviewing the business requirements document and functional requirement document
• Developed a working module of a new social media marketing software using R Shiny which can be used by Marketers to gain audience insights based on text mining and machine learning.
• Extracted and analyzed data from Facebook and Twitter using Rfacebook and TwitteR packages.
• Created reports using R Markdown and Knitr covering key insights using plots and charts.
• Performed text mining on social media data using tm and quanteda packages.
• Performed statistical tests like correlation and regression analysis to find trends and associations among users on social media sites like Facebook, Twitter, Instagram and YouTube.
• Performed sentiment analysis on Tweets, Facebook Posts and Comments as well as Instagram Posts using several sentiment packages in R to explore public sentiments all over the world.
• Stored aggregated data in MySQL database tables to automate summarized data report generation.

Environment: R, R Studio, Shiny, MySQL, MS Excel, MS Word, Windows Server 2008 R2, HTML, XML