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 the Informatica PowerCenter developer to create Source to Stage to Target Data Mapping Documents indicating the 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 the 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 that 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, Dover, 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 the 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 the 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 that the User Stories are Independent, Negotiable, Valuable, Estimable, Small and Testable, so that they are Ready to be pulled into Sprint Backlog. Also, specified the Acceptance Criteria for every Story.
• Worked with Development Team and Vertically Sliced the 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 the 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 the Environment, clear all the Clarification Questions and Build a level of Trust within the team.
• Participated in all Scrum Ceremonies such as the 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 that Definition of Done was satisfied, a Live Demo was conducted and did User Acceptance Test (UAT) to classify the User Story as Potentially Shippable Product Increment.
• Encouraged Sprint Retrospective, as more of fun exercise to relax the team and the same time adopted frameworks like Mad, Sad, Glad and Happiness Histogram to share the thoughts in order to improve the process in next Sprint.
• Worked with the 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 the Quality Assurance team in the creation of Test Plans, Test Scenarios, and Test Cases. Mapped test cases to business requirements/user stories in the 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, Dover, NH

Sr. Business System Analyst

Responsibilities:

• Interacted with Marketing Team and Marketing Director to document the requirements they have from the proposed system.
• Identified Key Stakeholder for the project and prepared a Stakeholder Matrix and Stakeholder Engagement Plan to analyze the ways and means to accommodate the 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 the Business Case.
• Moderated sessions with Solution Architect to decide the 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 the 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 the Service Level Agreements (SLA) with both internal and external providers for audit purpose.
• Helped the 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 the Hadoop Architecture over AWS EMR. Integrated data in S3 Buckets with the 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 the Product Backlog Items (PBIs), helped further slicing of user stories by business values, and employ INVEST criteria as a quality check for making the user stories Ready.
• Documented the 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 that 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 the Release Burn-Up and Sprint Burn-Down Chart.
• Maintained the Scrum Board during the Daily Stand-Ups to help the team Track the 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 the Key Stakeholders of the 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, O’Fallon, MO

Business System Analyst

Responsibilities:

• Elicited Requirements from Customer Service Department to understand the needs, pain-points and requirements from the proposed system using various Elicitation Techniques such as Interviews, Observation, Laddering, JAD, Document Analysis.
• Designed a Requirement Traceability Matrix (RTM) to manage the Scope of the 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 the architecture of the Hadoop Cluster and also analyzed the 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 the Business Objectives, and state of the Architectural Runway.
• Prepared Logical and Conceptual Data Models for the 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 the Change Request received from Key Stakeholders. Conducted Business and Technical Impact Analysis and submitted the Report to Change Control Board for Approval. Updated all the Relevant Documents as per the approval.
• Created a Risk Register for managing risks and identified risk response plan. discussed with the stakeholders to check if the risk can be Resolved before the start, or it has to be Owned, Accepted or Mitigated. Used ROAM board for this process.
• Assisted Scrum Master in calculation of Team’s Capacity and then calculated Velocity. Ensured that Sprint Goals are met at the end of each Sprint by verifying if the PSPI meets the Definition of Done.
• Worked with Development Team and Scrum Master and ensured that best practices while development are followed such at Test Driven Development, Acceptance Test Driven Development, or Behavioral Driven Development.
• Kept the track of Impediments faced by team that affected their Velocity and Documented them. Generated a Report to make sure that these are not faced by team in future. Assisted Scrum Master in Resolving the 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, Trenton, 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 the Business Users’ Requirements for Information and Communicate them to the rest of the 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 the Data Team with all the requirements.
• Worked with Data Analyst and performed Conceptual and Logical Data Modelling. Also, actively involved in the process of Data Mapping by identifying and specifying the links between Data Models. Also developed the data dictionary.
• Identified and Explored Source Data and Specification of Target Data systems. Conducted the Gap Analysis, Performed Quality Check, Identified Dependencies, Recognized Meaningful Data and Data Pattern that is to be migrated.
• Assisted the 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 the Data Analyst in Data Profiling. Assisted the development team for Data Cleansing and Data Analysis before Loading the data into the Enterprise Data Warehouse using Informatica PowerCenter.
• Facilitated meeting between Product Owner, Development Team and other Key Stakeholders in deciding the type of Data Migration Technique to be followed.
• Worked with the ETL developer to create Source to stage and Stage to Target Data Mapping Documents indicating the Source Tables, Target Definition, Columns, Data Types, Transformations Required and Business Rules and Logic to be applied. Rigorously reviewed the 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 the data warehouse to define the relationship between the 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 the Trends and Patterns and for Data Forecasting.
• Drafted Test Strategy, Test Plans and Test Cases, and Exit Strategy by working closely with the Quality Analyst Team.
• Led the 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 the customers and internal stakeholders to elicit user requirements to make the 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 the 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 the Integrity of Data Stored in the Databases.
• Assisted in the preparation of Test Plans with the 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 the 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 the 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 the existing PL/SQL scripts into Stored Procedures to be used by Informatica Mappings with the help of Stored Procedure Transformations.
• Used BugZilla for Defect Reporting and Management. Worked closely with the 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.