SUMMARY

• Experience working in and managing various Software Development Life Cycle (SDLC) Methodologies including Waterfall, Waterfall - Scrum Hybrid, Agile-Scrum, Kanban, Scaled Agile Framework (SAFe®) 4.0.
• Worked closely with Business Users, Product Owners, Project Managers, Development Teams, Solution Architects, Quality Assurance Teams, Deployment Teams, Maintenance Team, and Scrum Master through all phases of SDLC.
• In-depth knowledge of Capital Markets and Asset Classes Mix like Securities including Equities and Debt, Derivatives Market such as Futures/Forwards, Options and Swaps, Commodities (Oil, Metals, etc) and Foreign Exchange.
• Familiar with Financial Regulations like SEC, SOX, IFRS, US-GAAP, FINRA, CFTC, FinCEN, Dodd-Frank, MiFID II and Basel III .
• Experienced in working on projects related to Portfolio Management, Wealth Management and Identifying High-Net-Worth Retail Investors, with core understanding of Trade Life Cycle and Trade order Management.
• Proficient in Eliciting Requirements, SWOT Analysis, Document Analysis, GAP Analysis (As-Is and To-Be), Process Analysis, Risk Analysis, Break-even analysis, ROI Analysis, Root Cause Analysis, Feasibility Study, Cost-Benefit Analysis.
• Facilitated and Scribed Joint Application Development (JAD) sessions, Surveys, Focus Groups, Reverse Engineering, Interviews, Brainstorming, Benchmarking & Market Analysis, Laddering, and Observation.
• Expertise in Low-Fidelity Wireframes and High-Fidelity Mock-Ups using Moqup and Balsamiq. Proficient in Business Process Modelling and constructing UML diagrams like Use Case, Sequence, and Activity diagrams using Lucid Chart and MS Visio.
• Experience in working on both On-Premise and Cloud deployed enterprise products and application including Deployment, Maintenance and Migration to cloud (AWS).
• Experienced running and maintaining enterprise level applications in AWS using Elastic Compute Cloud (EC2), Elastic Load Balancer (ELB) clusters, Lambda, Kinesis, Identity Access manager (IAM), CloudWatch for logging and monitoring, Relational Database (AWS RDS), and Simple Storage Service (S3) bucket for storage.
• Understanding on Big Data concepts and tools such as Hadoop, HDFS, Hive, Spark, Flume, Sqoop, Kafka, HBase, MapReduce, Yarn, Oozie, NiFi, and Zookeeper.
• Exhaustive knowledge of implementing Data warehousing, Data Migration, Data Modeling, Data Mapping, Data Profiling, Staging, ODS, ETL Process, Schemas, Data Marts and OLAP Operations such as Roll-Up, Drill-Down, Pivot, Slice and Dice.
• Worked closely with teh Informatica PowerCenter developer to create Source to Stage to Target Data Mapping Documents indicating teh Source Tables, Columns, Data Types, Transformations Required and Business Rules.
• Expertise in Software Requirement Specifications (SRS), Functional Requirement Document (FRD), Business Requirement Document (BRD), Requirement Traceability Matrix (RTM), Test Cases and Process Map during teh project. Collaborated with Project Manager to create Project Scope, Project Charter, Project Management Plan, Work Breakdown Structure.
• Extensive knowledge of Service Oriented Architecture (SOA), 3-tier and N-Tier Architecture systems. Extensible Markup Language (XML), JavaScript Object Notation (JSON), Open API Specification (OAS).
• Adept in web service Application Programming Interfaces (APIs) such as Representational state transfer(REST), and Simple Object Access Protocol (SOAP). Experience in using Swagger for REST Documentation and used Postman for API Testing.
• Worked Closely with Product Owner, Scrum Master and Development Team to break Epics and write User Stories with INVEST criteria. Contributed in Release Planning Meeting, Product Backlog Grooming sessions including Slicing, Prioritization and Estimation and also, in ceremonies like Sprint Planning, Sprint Review and Sprint Retrospective. Analyzed Scrum Reports like Burn Up/Burn Down Charts, Impediment list, and Sprint Report to facilitate successful project delivery.
• Skilled in Bug Tracking and Analysis, and also in Organizing, Documenting and Tracking Changes using JIRA and Confluence.
• Assisted Product Owner in User Acceptance testing (UAT), and performed Functional (Black Box) Testing. Collaborated with QA/Testing Team to develop Test Plans, Test Scenarios, Test Cases, and Test Objectives. In-depth knowledge of Test-Driven Development (TDD), Behavior Driven Development (BDD), and Acceptance Test Driven Development (ATDD).
• Comprehensive knowledge of DevOps Framework dat includes Continuous Development, Continuous Testing, Continuous Integration, Continuous Deployment and Continuous Monitoring practices and various tools like GitHub, Maven, Docker, Selenium, Jenkins, Bamboo and Nagios.
• Experience in creating interactive, analytical Business Intelligence (BI) dashboards using Tableau and Excel. Proficient in SQL queries like Select, Joins, Group By, Subqueries, and Aggregate Functions such as Max, Min, Count, Sum, Average to ensure Integrity between Database and User Interface and for timely Validation and Reporting.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Hybrid (Waterfall - Scrum), Agile - Scrum, SAFe, Kanban, DevOps

Process Modelling Tools: MS Visio, Moqup Screens, Lucid Chart, Balsamiq, Proto

Business Skills: Change Management, Impact Analysis, Risk Analysis, Cost-Benefit Analysis, ROI Analysis, Feasibility Study, SWOT Analysis, Financial Reporting, Project Valuation (NPV, DCF, IRR), Pricing, and Budgeting

Elicitation Techniques: Interviews, Survey/Questionnaire, Observation, Laddering, JAD, Brainstorming, Focus Group, Reverse Engineering, Document Analysis, Prototyping

Project Management: Jira, Confluence, Rally (CA Agile Central), MS Office 365 (Exchange, SharePoint, Project, PowerPoint, Visio, Word, Excel, PowerPoint), GitHub, BitBucket

Testing Tools: HP QC, HP ALM, Cucumber, Jenkins, Postman, Swagger, Selenium, TestNG

Financial Tools: Bloomberg Terminal, Bloomberg B-Pipe, Thomson Reuters, Morningstar.

Defect Management: BugZilla, JIRA

Operating System: Windows XP, Windows 8, Windows 10, Linux-Ubuntu

Big Data Tools: Apache Hadoop, HDFS, HBase, Kafka, Flume, Sqoop, MapReduce, Yarn, Hive, Pig, SparkML, Oozie, ZooKeeper, NiFi

Amazon Web Services Platform: EC2, ELB, EBS, S3, DynamoDB, Redshift, Glue, IAM, CloudWatch, CloudTrail, API Gateway, EMR, Athena, QuickSight, Kinesis, ElasticCache, SNS, SQS, SES, Lambda

ETL Tools: Informatica PowerCenter 8.6

Data Analysis / Reporting: Tableau, MS Excel, QuickSight, Apache Zeppelin

Databases: MySQL, Oracle 11g/12c, Teradata

Data Modelling: Logical, Conceptual, E-R Diagrams, Star and Snowflake Schema

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up

Architecture and Framework: Service Oriented Architecture (SOA), N-Tier Architecture, 3-Tier Architecture, Cloud Platform (SaaS, PaaS, IaaS)

PROFESSIONAL EXPERIENCE

Confidential, NH

Sr. Business System Analyst/Product Owner

Responsibilities:

• Worked closely with Project Manager and conducted Risk Analysis, SWOT Analysis, Break-Even Analysis, ROI Analysis, Root Cause Analysis, Feasibility Study, Gap Analysis (As-Is and To-Be).
• Assisted Project Manager in preparing Project Scope, Project Charter, Project Management Plan and Work Breakdown Structure. Created Project Kick-Off Documents and assisted Project Manager in drafting Product Vision and Product Roadmap.
• Worked with Regulatory and Compliance Department to understand teh SEC, SOX, IFRS, US-GAAP, FINRA, CFTC, FinCEN, Dodd-Frank to build Business Rules to be used during Predictive Analysis for Portfolio Recommendation.
• Worked with Finance and IT Department to weigh API options for Real-Time Streaming Data on Equities, Bonds, Forex, Derivatives. Looked at Bloomberg Terminal, Bloomberg B-Pipe, Thomson Reuters, Morningstar as various options.
• Analyzed UML diagrams like Class Diagrams, Sequence diagrams, Use-Case diagrams and Activity diagrams using MS-Visio.
• Identified and Mapped Stakeholders to RACI (Responsible, Accountable, Consulted, and Informed) Matrix to ensure smoother change process and to clarify roles and responsibilities in teh cross-functional project environment.
• Worked with Key Stakeholders to decide Product Discovery Process and Team’s Agile Cadence by conducting direct interviews and surveys using Qualtrics.
• Worked with Project Manager, Scrum Master, and Development team to capture Project Objectives, and slice it into User Stories, and created an Initial High-Level Prioritized Product Backlog.
• Moderated Product Backlog Grooming Session so dat teh User Stories are Independent, Negotiable, Valuable, Estimable, Small and Testable, so dat they are Ready to be pulled into Sprint Backlog. Also, specified teh Acceptance Criteria for every Story.
• Worked with Development Team and Vertically Sliced teh Epics and Themes based on Roles, Business Rules, Workflows. Adopted MoSCoW and KANO Model for Prioritization. Facilitated Planning Poker, T-Shirt Sizing and Relative Mass Valuation for Story Point Estimation, keeping in mind Business Value, Dependencies and Technical Risks.
• Coordinated Releasing Planning Meeting, including Development Team, Scrum Master and other Key Stakeholders and decided on Incremental Product Delivery Process. Based on teh inputs decided to adopt Feature-Driven Delivery with development in Two Weeks Sprint and Release after every Three Months. Created Expectation Charts to ensure everyone was on-board.
• Organized Sprint Zero, to Set-Up teh Environment, clear all teh Clarification Questions and Build a level of Trust within teh team.
• Participated in all Scrum Ceremonies such as teh Sprint Planning, Daily Stand Up, Sprint Review and Sprint Retrospective Meeting. Gave Feedback and Inputs to drive commitment, accountability and continuous improvement.
• During Sprint Review ensured dat Definition of Done was satisfied, a Live Demo was conducted and did User Acceptance Test (UAT) to classify teh User Story as Potentially Shippable Product Increment.
• Encouraged Sprint Retrospective, as more of fun exercise to relax teh team and teh same time adopted frameworks like Mad, Sad, Glad and Happiness Histogram to share teh thoughts in order to improve teh process in next Sprint.
• Worked with teh DevOps team to setup Continuous Integration and Continuous Deployment pipelines using JIRA, GitHub and Jenkins; Promoted DevOps practice by enabling training for developers.
• Assisted in creation of REST APIs documentation using Swagger. Tested Request and Response, Source and Targets for Web Services using Postman.
• Assisted teh Quality Assurance team in teh creation of Test Plans, Test Scenarios, and Test Cases. Mapped test cases to business requirements/user stories in teh Requirements Traceability Matrix (RTM). Used HP ALM to write Test Cases and Log Defects and Track Defects and systematically manage defects and bugs.

Environment: Agile-Scrum, DevOps, EC2, ELB, DynmoDB, Glue, EMR, SparkML, Zeppelin, Athena, QuickSight, Kinesis, S3, Lambda, API Gateway, IAM, ElastiCache, CloudWatch, CloudTrail, SES, SNS, SQS, RESTful API, OAS, JIRA, Confluence, Jenkins, OAuth 2.0, GitHub, MS Project, MS Visio, MS PowerPoint, Qualtrics, Tableau, Postman, Swagger, HP ALM, Proto

Confidential, NH

Sr. Business System Analyst

Responsibilities:

• Interacted with Marketing Team and Marketing Director to document teh requirements they has from teh proposed system.
• Identified Key Stakeholder for teh project and prepared a Stakeholder Matrix and Stakeholder Engagement Plan to analyze teh ways and means to accommodate teh Requirements, Suggestions, Concerns, Feedback of Key Stakeholders.
• Facilitated Interviews, JAD Sessions, Brainstorming with Product Owner, Line of Business Managers and otherBusinessStakeholders, Subject Matter Experts (SMEs) to refine teh Business Case.
• Moderated sessions with Solution Architect to decide teh new product needs to be built using AWS based on Machine Learning Predictive Analysis. Worked with Architects and Data Analyst to explore various component option to build teh architect such as a choice between AWS S3, AWS DynamoDB, AWS RedShift and between Python and R to build Machine Learning Models.
• Documented, and Negotiated teh Service Level Agreements (SLA) with both internal and external providers for audit purpose.
• Helped teh Project Manager conduct ROI Analysis, Cost Benefit Analysis and SWOT analysis as part of Risk Identification and assessment process.
• Used AWS Athena, which provide seamless integration and run SQL queries in order to pull data for validation and quality check.
• Worked with Solution Architect team and Data Scientist team to deploy teh Hadoop Architecture over AWS EMR. Integrated data in S3 Buckets with teh Flume and Sqoop to bring data to HBase connecting it to Spark MLlib finally to Tableau.
• Integrated Tableau to get Real-Time understanding of High-Net-Worth Retail Investors. Categorized into client clusters based on likelihood of investment.
• Contributed in drafting user stories to teh Product Backlog Items (PBIs), helped further slicing of user stories by business values, and employ INVEST criteria as a quality check for making teh user stories Ready.
• Documented teh carried-out analysis, data sources, data inputs, and other project artifacts in JIRA-Confluence.
• Prepared and analyzed UML Diagrams like Class Diagrams, Sequence diagrams, Use-Case diagrams and Activity diagrams.
• Monitored AWS Architecture using AWS CloudWatch. Identified Stakeholders and kind of access dat need using AWS IAM.
• Aided testing team to develop Test Plans, Test Cases and Test Scenarios and Requirement Traceability Matrix in JIRA.
• Built JIRA boards and Filters to manage Product Backlog and Ongoing Sprint, and added necessary Charts for tracking project performance such as teh Release Burn-Up and Sprint Burn-Down Chart.
• Maintained teh Scrum Board during teh Daily Stand-Ups to help teh team Track teh stories To Do, Work-In-Progress, Done.
• Closely worked with Testing Team to perform Smoke Testing, Black-Box Testing, Integration Testing and User Acceptance Testing. Used Jira to Track and Manage Defect Life Cycle.
• Developed Reports using Tableau and shared it with all teh Key Stakeholders of teh project to gather Feedback.

Environment: Agile-Scrum, EC2, ELB, DynmoDB, EMR, Hbase, Sqoop, Flume SparkML, Zeppelin, Athena, Tableau, S3, IAM, CloudWatch, CloudTrail, ElastiCache, EBS, JIRA, Confluence, Jenkins, OAuth 2.0, GitHub, MS Project, MS Visio, MS PowerPoint.

Confidential,MO

Business System Analyst

Responsibilities:

• Elicited Requirements from Customer Service Department to understand teh needs, pain-points and requirements from teh proposed system using various Elicitation Techniques such as Interviews, Observation, Laddering, JAD, Document Analysis.
• Designed a Requirement Traceability Matrix (RTM) to manage teh Scope of teh requirements. Identified Dependencies and documented Functional, Non-Functional, Data and Graphic User Interface requirements in Business Requirements Document (BRD), and Systems Requirements Specifications (SRS) documents.
• Worked closely with System Architects and Data Analyst to identify teh architecture of teh Hadoop Cluster and also analyzed teh flow of data from Ingestion to ETL to Modelling to Visual Report. Verified Data Quality and Data Integrity by running SQL.
• Facilitated Program Backlog Planning, along with key Stakeholders to get a better understanding of teh Business Objectives, and state of teh Architectural Runway.
• Prepared Logical and Conceptual Data Models for teh Data Team and also established Data Mapping by building Relationships between Entities. Defined and Identified Primary and Foreign Keys.
• Defined Business Rules to be incorporated to Build Model to form Clusters and do Classifications of Complaints received.
• Documented teh Change Request received from Key Stakeholders. Conducted Business and Technical Impact Analysis and submitted teh Report to Change Control Board for Approval. Updated all teh Relevant Documents as per teh approval.
• Created a Risk Register for managing risks and identified risk response plan. discussed with teh stakeholders to check if teh risk can be Resolved before teh start, or it has to be Owned, Accepted or Mitigated. Used ROAM board for dis process.
• Assisted Scrum Master in calculation of Team’s Capacity and then calculated Velocity. Ensured dat Sprint Goals are met at teh end of each Sprint by verifying if teh PSPI meets teh Definition of Done.
• Worked with Development Team and Scrum Master and ensured dat best practices while development are followed such at Test Driven Development, Acceptance Test Driven Development, or Behavioral Driven Development.
• Kept teh track of Impediments faced by team dat effected their Velocity and Documented them. Generated a Report to make sure dat these are not faced by team in future. Assisted Scrum Master in Resolving teh Impediments.
• Collected quality and performance metrics such as Velocity planned vs Velocity achieved, number of Refactors, Percentage of Test Case Coverage, Number of Defects etc.

Environment: Waterfall-Scrum Hybrid, Apache Hadoop, HDFS, HBase, Sqoop, Flume, Kafka, Yarn, MapReduce, Hive, Spark, Pig, Oozie, NiFi, ZooKeeper, JIRA, Confluence, Balsamic, MS Office Suite (Exchange, SharePoint, Project, PowerPoint, Visio, Word, Excel, PowerPoint), Tableau.

Confidential, NJ

Business System Analyst

Responsibilities:

• Elicited Requirements by Facilitating JAD Sessions, Conducting Interviews, Preparing Questionnaire, Analyzing Documents in order to prepare various Business Intelligence Reports. Also, Understand teh Business Users’ Requirements for Information and Communicate them to teh rest of teh Data Warehouse Team.
• Documented elicited requirements in Business Requirement Document (BRD) and System Requirement Specification (SRS). Created a sample of Data Prototypes for approval from Sponsors and Business Owners.
• Assisted Data Warehouse Data Analyst in analyzing existing reports and identifying iteration metrics. Clarified teh Data Team with all teh requirements.
• Worked with Data Analyst and performed Conceptual and Logical Data Modelling. Also, actively involved in teh process of Data Mapping by identifying and specifying teh links between Data Models. Also developed teh data dictionary.
• Identified and Explored Source Data and Specification of Target Data systems. Conducted teh Gap Analysis, Performed Quality Check, Identified Dependencies, Recognized Meaningful Data and Data Pattern dat is to be migrated.
• Assisted teh Product Owner in transforming Business Requirements into User Stories. Participated in Product Backlog Grooming Sessions and assisted in slicing epics into User Stories and then Prioritizing and Estimating them.
• Created Data/Process Flow Diagrams, Sequence Diagrams using UML methodologies for easy understanding.
• Collaborated with teh Data Analyst in Data Profiling. Assisted teh development team for Data Cleansing and Data Analysis before Loading teh data into teh Enterprise Data Warehouse using Informatica PowerCenter.
• Facilitated meeting between Product Owner, Development Team and other Key Stakeholders in deciding teh type of Data Migration Technique to be followed.
• Worked with teh ETL developer to create Source to stage and Stage to Target Data Mapping Documents indicating teh Source Tables, Target Definition, Columns, Data Types, Transformations Required and Business Rules and Logic to be applied. Rigorously reviewed teh Data Mapping and Transformation logic applied to data to check if requirements are met.
• Used Dimension Modeling like Star Schema, and Snowflake Schema in designing teh data warehouse to define teh relationship between teh Fact tables and Dimension Tables, identifying Primary Keys and Foreign keys.
• Created SQL queries in Toad to perform Data Analysis, Data Review, Data Validation and Data Manipulation operations.
• Used Tableau for Data Reporting, studying teh Trends and Patterns and for Data Forecasting.
• Drafted Test Strategy, Test Plans and Test Cases, and Exit Strategy by working closely with teh Quality Analyst Team.
• Led teh User Acceptance Testing (UAT) efforts by conducting UAT and logging Defects on HP ALM.

Environment: Waterfall - Agile Methodology, Oracle 11c, Toad, MS Office 365 (Exchange, SharePoint, Project, PowerPoint, Visio), Java, XML, SSMS 2014, Jira v 1.0.2.8, HP ALM, Informatica Power Center 9.5.1, Tableau v 6.0.9.

Confidential

Jr. Business System Analyst/SQL Developer

Responsibilities:

• Interacted with teh customers and internal stakeholders to elicit user requirements to make teh existingsystemsafer for a transaction by makingitPCI DSS compliant as increase control over cardholder data and reduce credit card frauds.
• Documented Requirements using Functional Requirement Document,BusinessRequirement Document, and Software Requirement Specification using various Elicitation Techniques such as Document Analysis, Focus group, JAD, Surveys.
• Maintained and Shared Documents using MS SharePoint. Managed Test Cases and Logged Defects using HPQC Tool.
• Assessedbusinesspriorities and advisedbusinessunits by Performing Risk Analysis along withSr.BusinessAnalyst.
• Created UML Diagrams like Activity diagrams, Sequence diagrams, Use Case Diagrams using MS-Visio.
• Performed GAP Analysis as to recommend corrective measures to improve productivity. Did Impact Analysis for Change Management along with Project Manager and Stakeholders.
• Created Logical Relationship between Entities and Primary Keys to making every payment per transaction unique in teh database. Helped data architect in database designing and other technical teams by participating in E-R modeling.
• Executed SQL Queries to Validate Data Quality and Verify teh Integrity of Data Stored in teh Databases.
• Assisted in teh preparation of Test Plans with teh Testing Team in order to ensure Testability, Reliability and Maintainability.

Environment: Waterfall SDLC, HP QC, Payment Processing, Payment gateways, MS Project, MS Visio, MySQL Server, SharePoint, MS Office (MS Excel, MS Word, MS PowerPoint)10, HPQC, SOAtest, Linux, MS-SQL server.

Confidential

Informatica Developer

Responsibilities:

• Worked on teh Requirements with Business Analyst and Business Users also involved in working were Data Modelers.
• UsedInformaticaPowerCenter as an ETL Tool to create Source/Target Definitions, Mappings and Sessions to Extract, Transform and Load Data into Staging Tables from various Sources.
• Defined and developed new design patterned, ETL frameworks, Data Model standards guidelines and ETL best practices.
• Used SQL to perform detailed Data Investigation and Analysis of known Data Quality Issues in related databases.
• Developed Workflows and Sessions associated with teh Mappings using Workflow Manager.
• Used various transformations of Informatica, such as Source Qualifier Transformation, Expression Transformation, Look-up transformation, Update Strategy transformation, Filter transformation, Router transformation, Joiner transformation etc. for developing Informatica mappings.
• Extracted source data from SQL Server, Flat files, XML files using Informatica, and loaded into Oracle target Database.
• Extensively transformed teh existing PL/SQL scripts into Stored Procedures to be used by Informatica Mappings with teh help of Stored Procedure Transformations.
• Used BugZilla for Defect Reporting and Management. Worked closely with teh Business Analyst's and Production Support to resolve any defects.

Environment: Waterfall, MS Office Suite, Informatica PowerCenter 8.6, Informatica DataQuality 8.6, Linux, SQL, PLSQL, Oracle 11g, TOAD, SQL Loader, Bug Zilla.