PROFESSIONAL SUMMARY:

• Professional Senior Business Systems Analyst with 8 years of progressive experience in Banking, Finance and IT.
• Knowledge of SDLC best practices, frameworks, and methodologies such as DevOps, Six Sigma, Lean Startup, Kanban, Scrum, Scrumban, Nexus, SAFe, Waterfall, XP, CICD, TDD, FDD, and BDD
• Developed knowledge in Fraud Management, Digital Payments, New Product Development, Hybrid Integration Platforms, Enterprise Application Integration, Mobile Applications, and Global ERP implementation
• Skilled in legacy modernization, process improvement, technology integration, and building Digital 2.0 solutions using social, mobile, analytics, cloud, and advance technologies such as Machine Learning/Artificial Intelligence
• Led cross - functional teams across geographies to develop digital products and capabilities across multiple channels
• Experienced in eliciting Business Requirements with various techniques such as Joint Application Development (JAD), Interviews, Focus Groups, Document Analysis, Job Shadowing, and Survey/Questionnaire
• Proficient in preparing wide range of documents including Business requirements document (BRD), Systems Requirements Specification (SRS), and RACI matrix (Responsible, Accountable, Consulted and Informed)
• Skilled in Documentation and Analysis that include prototyping documents, models, and attributes and designing What-If Scenario Analysis (WISA), Requirements Traceability Matrix (RTM), and Go-live documents
• Expertise in writing INVEST user stories, SMART tasks, and refining product backlog using prioritization techniques such as MoSCoW and KANO, and estimation techniques such as Planning Poker and T-shirt sizing
• Worked with SMEs’ to understand Key Performance Indicators (KPIs’), and Service Level Agreements (SLA)’s
• Experienced in performing Gap Analysis, SWOT Analysis, PERT Analysis, Risk Analysis, Impact Analysis, Cost-Benefit Analysis, ROI analysis, Risk Assessment, Feasibility study, and using Porter’s Five Forces
• Managed end-to-end project lifecycles using Scrum framework/Waterfall methodology and followed PMBOK principles and guidelines to ensure consistent high-quality standards in producing project deliverables
• Experienced in UML Modelling like Activity Diagrams, Sequence Diagrams, and Use Case Diagrams, Process Workflow Diagrams, Class Diagrams using Rational Rose and MS Visio
• Comprehensive understanding of software design including 3-tier, SOA, and Microservices architecture
• Experience in Graphic User Interface Design (GUI), Wireframes and UI mock-up using Balsamiq tool
• Experience in creating and executing SQL queries to fetch complex data from different tables in remote database using Joins, database links and formatted the results into reports and kept logs
• Extensive implementation knowledge of Databases, Data Table structures, Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot.
• Experience in Data Integration Using Data center with Hub and Spoke. Worked in Data warehousing project and used the ETL tool, Informatica Power Center for data mapping and performing transformation
• Vast experience of working in data management including Data analysis, Gap analysis and Data mapping
• Adept in writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary
• Experience working in Three-Tier architecture, Ajax, Web Services (SOAP, WSDL), Client-Side Validation, and Server-Side Validation. Possess good knowledge of validation scripting like JavaScript, JQuery and Angular JS.
• Used API/Web Service frameworks such as Postman and Swagger for documenting and testing REST Webservice requests and responses in XML and JSON formats
• Experience supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing
• Created Feature Files in Gherkin to aid developers in coding the step definition files in Cucumber and used the Record and Playback functions in Selenium IDE to automate functional tests
• Worked with QA team to design Test plans and Test Cases for User Acceptance Testing (UAT) using HP Quality center/ HP ALM

TECHNICAL SKILLS:

Project, Requirement Management Tools: Microsoft Project, JIRA, Trello, Confluence, Team Foundation Server (TFS), Slack

Modeling Tools: Erwin, MS Visio, Lucid Charts, Smart Draw, SAP PowerDesigner

Product Roadmap: Google Sheets, Blueprint, Aha

Wireframing: Balsamiq, Axure

Big Data: Hadoop, MapReduce, Hive, Apache Spark, Mahout, Sqoop, Kafka, Flume

Data Warehousing: ER Modeling, Dimension Modelling, Data Marts, OLTP, OLAP, Data Profiling, Data Mapping, Data Mining, Data Validation, Star schema, Snowflake Schema

ETL and EAI Tools: Informatica Power Center, TIBCO, Mulesoft

Testing Tools: HP QC, HP ALM, Load runner, Cucumber, SOAP UI, Postman, JMeter, Selenium

ML/AI/AR: Amazon Machine Learning, Apache Mahout, H2O.ai

Web Services: SOAP, REST, AJAX, XML, JSON, WSDL, WADL, XSD, DOM

Databases: SQL Server, Access, Oracle 11g/12c, HBase, Amazon Aurora, DynamoDB, Teradata

IDE: Visual Studio, Eclipse, Xamarin

AWS: Amazon EMR, S3, Snowball, Redshift, Kinesis, Lambda, EC2, CloudFront

Languages: SQL, R, Python, C, C++, VB.NET, Java, HTML, XML

BI and Analytics Tools: Tableau, Power BI, SAS, Qlikview, Zeppelin, Google Analytics, ELK

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Senior Business Analyst

Responsibilities:

• Familiar with VPC, AWS IAM, Config, Cloudwatch, and AWS S3 (PCI DSS compliant)
• Involved in building the enterprise data hub and AI/ML platform using microservices architecture and Hadoop ecosystem on AWS as IaaS and PaaS
• Elicited requirements and translated them into features/user stories with clear acceptance criteria
• Facilitated Joint Application Development ( JAD ), Brainstorming Session involving business unit stakeholders, technical analyst, SME, portfolio managers, and financial analyst to gather requirements
• Gathered requirements on the different frequencies of data ingest (Batch/streamed real-time/part-time) to be loaded on the HBase using Flume, Sqoop
• Assisted in transaction monitoring, watch list filtering, detection engine, entity-linked analysis, AML system implementation and Risk based filtering
• Reviewed systematic Anti Money Laundering (AML) alerts and determined if transactions occurring are valid Anti Money Laundering risks.
• Integrated H2O.ai with the existing platform to enable data scientists to continuously develop and deploy new machine learning models such as AdaBoost, Xgboost, SVM, Random Forest and neural nets
• Contributed to the continuous improvement of the CICD pipeline that included Git, Jenkins, Selenium, and Docker for versioning, unit testing, integration testing, and deployment
• Used Behavioral Driven Development (BDD) development technique for building the components
• Used Jenkins for automating the continuous integration of the components on a regular basis
• Worked cross-functionally with all departments to support integration in multiple business areas
• Performed root cause analysis to identify data quality problems, and historical trends
• Apache Pig and Hive for loading and transforming structured and unstructured data for data analysis
• Performed data analysis using SQL and reporting on the ODS after data extraction from the HBase DB
• Identified and defined Data sources and conducted Data profiling, Data cleansing, and Data Governance
• Allowed users to extract the reports into CSV and Excel to create pivot charts and advanced formulas
• Created mockups using Balsamiq to better illustrate requirements in functional specification document
• Assisted Web services team in designing REST services and configuring WADL
• Involved in creation of User Acceptance Test cases and plans, defect tracking using JIRA and validated reports and dashboards
• Used Zeppelin for data reporting, studying the trends, data patterns, data forecasting, and visualization
• Performed Data Analysis and Ad-hoc query reporting using SQL and PowerBI to get the Business user feedback and for data validation

Environment: Scrum, JIRA, Jenkins, Git, Selenium, MS Visio, Balsamiq, H2O.ai, Apache Mahout, Java, Python, R, Sqoop, Flume, Kafka, Apache Spark, Apache Ignite, HBASE, Hive, Pig, Amazon Lambda, CloudFront, Cloudwatch, Amazon S3, Amazon EMR, Zeppelin, PowerBI

Confidential, Atlanta, GA

Senior Business Analyst

Responsibilities:

• Ensure EMV data transferred through various subsystems is secure and adheres to PCI-DSS guidelines
• Involved in building the digital payments platform using serverless architecture and AWS as IaaS, PaaS
• Created functional requirement documents, use cases, issue logs, project status documents, scope change documents, mapping specifications.
• Conducted one-on-one interviews, JAD sessions and brainstorming sessions to elicit requirements
• Used Confluence for repository management; JIRA for issue tracking, and user story management
• Experience in continuous development and deployment using JIRA, Bitbucket, Jenkins, Selenium
• Collaborated with development team to wrote user stories and define Acceptance Criteria for PBIs
• Facilitated Scrum meetings including sprint planning, daily scrums, sprint reviews and retrospectives
• Identified and categorized all relevant stakeholders involved in the project using RACI Matrix
• Verification of EFT Electronic Funds Transfer reports and escalate in case of any discrepancies
• Partnered with design teams to create differentiated payment experiences using lean UX principles
• Utilized A/B testing and Google Analytics to gain insights on user behavior and validate feature decisions
• Actively involved in reading data from varied file types created standard and ad-hoc reports using SQL and Erwin, generating delimited files and SQL script to load data into SQL tables
• Wrote SQL queries for data analysis and confirming data accuracy and integrity of various reports.
• Wrote transformation rules, performed data profiling to cleanse data, and created mapping documents
• Conducted API designs sessions and worked on developing API integration documentation
• Obtained various Element and their description pertaining to JSON under API documentation
• Involved in writing Features, Scenarios and Steps in Cucumber for testing
• Assisted testing team in UI testing using Selenium and documented the defects in the JIRA
• Conducted User acceptance test (UAT) and communicated the results to the development team.
• Used ELK stack - Elasticsearch, Logstash, and Kibana Dashboard to deliver end-to-end solution for analytics, logging, search and visualization and generate actionable insights in real-time

Environment: SAFe, JIRA, Confluence, Blueprint, Erwin, Jenkins, Bitbucket, Selenium, HTML5, CSS3, JavaScript, JQuery, Amazon Aurora, Amazon S3, ECS, Amazon CloudFront, Amazon Lambda, Amazon SQS, Amazon Cloudwatch, KMS, Zuul, Eureka, REST API, Google Analytics, Elasticsearch, Logstash, and Kibana

Confidential, Malvern, PA

Senior Business Analyst

Responsibilities:

• Led the teams in interaction between Data Modelers and Business Analysts to understand requirements and the impact of the ETL on the business
• Involved in Application Integration of the Salesforce CRM, contemporary systems and the AWS ecosystem
• Interviewed stakeholders to define project scope boundaries, milestones, deliverables and KPI
• Performed Scope Analysis for the proposed solution in collaboration with the business sponsors
• Engaged in requirements gathering and gap analysis workshops with SMEs
• Acted as a liaison between business and technology stakeholders to ensure appropriate communication, expectation management, coordination & facilitation of objectives, requirements, and constraints
• Analyzed business needs in developed use-case scenarios to aid and facilitate JAD sessions
• Participated in user story writing and Backlog grooming sessions and assisted the team in slicing epics and estimating & prioritizing the product backlog
• Demonstrated strong communication and facilitation skills by liaising between stakeholders at multiple levels including SVP, VP, Director, other senior managers and built credibility for high visibility projects
• Manage the project goals, scope and project teams to ensure overall project success, including customer satisfaction and the Chief Information Officer’s (CIO’s) Leadership Group goals and objectives
• Reviewed Business Requirement Documents (BRD) based on the gathered requirements; defined KPIs, reports & dashboards in Tableau & various models in Visio
• Worked on Informatica Power Center tools - Designer, Workflow Manager and Workflow Monitor
• Involved in customized Data Modeling supporting data from multiple sources in real time
• Involved in the maintenance of stored definitions, transformation rules and targets definitions using Informatica repository Manager
• Guided the team in implementing various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mapping in the Informatica Designer
• Collaborated with data architects for data model management and Salesforce Objects
• Worked on Informatica Power Exchange for Salesforce plugin to get Salesforce connectivity and Salesforce related transformation
• Collaborated in drafting strategies for data movement across AWS S3 to AWS Redshift Cluster using Informatica cloud
• Documents were prepared for Data Layer Mapping, Change Control, and Specifications on the ETL for the architectures. Any issues that needed to be tracked for the data were prepared
• Assisted in formulating testing documents like Test Plans, Requirements Traceability matrix (RTM) and Test summary report and developed Test Scenarios and Cases based on functional requirements
• Planned and Facilitated User Acceptance Testing; compiled results, reviewed them & formulated reports
• Performed application functionality demonstrations in various departments; conducted and designed one on one end user training module for the implementation team and formulated user manuals

Environment: Waterfall-Scrum Hybrid, JIRA, MS Office Suite, Informatica Power Center, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 11g, MS Visio, SQL Server 2008, AWS S3, AWS Redshift, Tableau

Confidential, San Francisco, CA

Senior Business Analyst

Responsibilities:

• Used JIRA for allotting tasks and issue tracking, user story management and requirement traceability
• Analyze business and functional specifications, use cases and define scope of sprints
• Facilitated Scrum Activities: Release Planning, Sprint Planning, Daily Stand-ups, Retrospectives
• Organize and lead project status and working meetings; prepare and distribute progress reports
• Manage change management process for program including intake, sizing, impact and trade-off assessment, and decision-making processes
• Participate in project team meetings to gather project status information as well as to provide information and guidance to the project team members.
• Assist in team development while holding teams accountable for their commitments, removing impediments to their work, leveraging organizational resources to improve capacity for project work
• Manage project schedules across cross-functional teams, identify and mitigate risks and facilitate an open channel of communication between stakeholders and project teams.
• Fetched the data from multiple data sources and Informatica was used to perform the ETL
• Created DFD’s and Activity Diagrams to map data from multiple databases to staging area
• Worked on data profiling and various data quality rules development. Performed Data validations
• Assisted in formulating testing documents like Test Plans and Test summary report and developed Test Scenarios and Cases based on functional requirements
• Planned and Facilitated User Acceptance Testing; compiled results, reviewed them & formulated reports
• Wrote Feature files in the Gherkin format for step definition files that were fed into Ruby as scripts for performing Automated testing using Cucumber
• Documented requests and responses to REST Web Services in JSON; Executed, manually tested them using Postman and helped the QA team in automation of REST service testing
• Responsible for coordinating efforts such as integration of systems, go-live initiatives, and development of verification and validation tests (UAT plans)
• Directed efforts of testers and business analysts toward accomplishment of individual milestones; solving time and resource conflicts

Environment: Scrum, MS Project, MS Visio, Java, MS SQL Server, Microsoft IIS, Microsoft Azure, Mulesoft, Informatica-Power Center, Informatica Data-Quality, JIRA, Tableau, Postman, Cucumber, HMTL5, CSS3

Confidential

Business Analyst

Responsibilities:

• Conducted PCI-DSS Business and IT Security gap analysis, noting findings and making recommendations for PCI credit card processing gap remediation
• Used Team Foundation Server to provide source code management, Direct reporting, requirements management, project management for agile software development, testing and release management
• Involved in defining the scope and business rules of the project, gathered business requirements, which involved interaction with cross functional teams to facilitate gathering of business requirements
• Conducted Joint Application Development (JAD) sessions, interviews and Document analysis
• Involved in transferring and reviewing data from heterogeneous sources like Excel, CSV, and flat files
• Participated in the initial Impact Analysis for all the critical functions; worked with internal team to build a high-level roadmap & timeline to achieve objectives
• Involved in continuously grooming the roadmaps and backlogs, integrating new information about architecture, resources and business strategy, constraints, assumptions and dependencies
• Created a mapping document that maps all the fields in the HTML pages to XML tags which are in turn mapped with the tables and column names in the database and involved in performing client-side validation
• Created mock-ups for the UI and assisted UX team in developing the UI with good aesthetics
• Produced international business cases, functional specifications (including SEO), data validation mapping, non-functional specifications, use cases, and user stories for web and mobile application changes
• Customized reports to support various analytical and presentation needs using MS Access and Excel
• Designed and implemented an account reconciliation tool in MS Access and later migrated it to MS SQL
• Executed pre-defined transactional Test scripts in ICC test tool through Point of Sale POS device to verify the authentication of information shared between EMV cards and bank host
• Assisted User Acceptance Testing (UAT) in communicating testing principles and guidelines with team
• Created product documentation including online help, user manual, and training materials
• Provided user test cases and collated and track defects. Communicated defects to development team
• Created complex Dashboards using Qlikview and published it to Stakeholders for feedback
• Developed Reports with multiple Data Connections, performed data Blending, and created different Visualizations like Bar Charts, Tree Maps, Bubble Charts using complex joins with Qlikview

Environment: Waterfall-Scrum Hybrid, TFS, Visual Studio IDE, .NET v4.0, C#, IIS, WCF, ASP.NET v4.0, LINQ, HP Quality Center, LoadRunner, Xamarin, SQL Server, MS Office, Qlikview

Confidential

Business Analyst

Responsibilities:

• Functioned closely with the business, control, and technology teams to understand the end to end process, data security, and Financial Compliance documents MiFID, SEC and GAAP
• Gained knowledge in Predictive Modeling, Asset Intelligence, Trade Life Cycle, Front Office, Back Office, Capital Markets, Derivative Markets and Equity Trading
• Elicited business requirements from stakeholders via Interviews, Brainstorming, and JAD sessions
• Transformed requirements into Functional, Non-Functional Requirements and Business Rules
• Conducted extensive GAP analysis by identifying AS-IS and TO-BE process models and process flows
• Created UML diagrams like Use Cases, Activity Diagrams, and Sequence Diagrams using MS-Visio
• Facilitated the “Change Discussions” long before the training begins with each impacted group. Established Incident Reporting and Change Control procedures using ClearQuest
• Extracted data using SQL for data validation and presentation from third party trade data like Bloomberg
• Performed various ETL transformations on extracted data using Informatica like Unconnected and connected Lookups, Routers, Joiners, Filters, Aggregators, Union on flat files.
• For proper functioning of blotter engines which is connected to Bloomberg API’s like B-PIPE, wrote, tested and implemented PL/SQL stored procedures, and functions
• Improved the communication and execution of triggers from the sell- buy point of view by letting the traders know their limits through a simple settlement process, improving the Straight Through Processing (STP)
• Worked on service-oriented architecture to connect compliance engine to various compliance web services using SOAP API
• Involved in scripting business logic in the web methods of Web Services and analyzing the Web Service Level Agreement (WSLA) document through XML for Service Level Agreement
• Generated test data inputs for both positive and negative data to enhance Recovery or Fail-over testing

Environment: Waterfall, Microsoft Office Suite, Microsoft Visio, UML, XML, Sybase Power Designer, Informatica PowerCenter, Microsoft Project, IBM Rational Clear Quest, Selenium

Confidential

Junior Business Analyst

Responsibilities:

• The methodology used was Waterfall and had a deep understanding of the requirement gathering
• Extensive study by Eliciting information from SMEs & Functional Teams for system requirements
• Developed the Use Case Modeling and prepared Business Requirement Document (BRD) Functional Requirements documents (FRD) and System Requirement Specification (SRS)
• SPOC for Development team and business users and effectively bridge the Techno-Functional gaps
• Provided clear and consistent information about project status to both internal team and stakeholders
• Functional understanding of OLTP, ODS, Staging Area, Data Marts, Data Warehouse, and OLAP
• Wrote complex SQL queries, queried database and generated test reports on Account Payable Database
• Worked in extraction, transformation, and loading (ETL) of data from Disparate Source systems
• Involved in EDI Document Analysis, Mapping, Transformations, and Validations according to IFRS
• Designed the ETL processes using Informatica to Load Data from Oracle, Flat Files (Fixed Width and Delimited) to Staging Database and from staging to the Target Warehouse Database
• Preformed Impact analysis under Change Control Procedure to facilitate CCB for a go-no- go decision
• Accountable for Track, Capture, and Communicate the Requirements using RTM which helped in controlling numerous artifacts produced by the teams across the deliverables for the project
• Involved in unit testing, UAT, Error Resolution with Production Incidents and Post go-live releases
• Created clear and compelling communications and presentations using Powerpoint and Tableau

Environment: Waterfall, SQL Server, MS Access, Informatica PowerCenter, Tableau, UML, MS Office, MS Visio