SUMMARY

• A senior business analyst with over 8 years of industry - wide experience in the domain of Banking, and Finance.
• Excellent analytical and problem-solving skills in designing, developing, and implementing innovative business processes and providing system solutions using advanced approaches, technology, and training.
• Excellent leadership skills including issue management, conflict resolution, business and process analysis, team building and staff management.
• Proficient in Black Box, Smoke and Sanity testing, documentation, modeling, and systems implementation skills.
• Extensive experience in full SDLC Governance and Collaboration right from Inception to Deployment.
• Worked in Waterfall, Agile - Scrum, and Scrum-Waterfall hybrid methodologies.
• Proficiency in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and transforming them into functional and non-functional specifications.
• Expertise in eliciting and synthesizing business requirements and in ensuring those requirements meet approved business plans. Seamless understanding of business and technology and their interrelationships.
• Extensive experience communicating with Subject Matter Experts (SME’s), performing Requirements Gathering, Business Analysis, Data Analysis, Use Case Design and developing Logical Models.
• Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using MS Visio.
• Exceptional ability to build productive relationships with colleagues, clients, and vendors across all functional and technical disciplines. Experience in providing constructive inputs to the project management team.
• Experienced in GAP Analysis, Traceability Matrices, SWOT Analysis, Risk Analysis and Cost-Benefit Analysis.
• Understanding of Test Driven Development (TDD), Behavior Driven Development (BDD), and Acceptance Test Driven Development (ATDD) which are used in test-centric development.
• Collaborated in various types of testing like Functional (Black-Box) testing, End to End Testing, Regression Testing, and User Acceptance Testing (UAT).
• Expertise in developing Test plans, Test case, test scripts and Test procedures in manual and automated test environments.
• In-depth knowledge of ESB, FTP, HTTP protocols, web service APIs - SOAP, REST, AJAX, XML, and JSON.
• Extensive implementation knowledge of Data warehousing, Data Structures, Schemas, Data Marts and OLAP Operations such as Roll-Up, Drill-Down, Slice, Dice, and Pivot.
• Demonstrated the ability to work both in independent and team-oriented environments with well-developed organizational skills, excellent interpersonal and communication skills, solving and delivering solutions under high-stress environment.

TECHNICAL SKILLS

Methodologies: Waterfall, Agile- SCRUM, Scrum-Waterfall Hybrid, SAFe.

Operating Systems: Windows, Mac OS

Database/ ETL: MS Access, Oracle DB, SQL Server, Informatica- Power Center and Data Quality, SSIS, Erwin.

Defect Tracking/ Testing Tools: HPUFT, Load Runner, Cucumber, JIRA, Test Director, Soap UI, Gherkin.

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Roll Up/Drill Down, Pivot

Business Modeling Tools: MS Visio, Balsamiq, Lucid Chart.

Reporting/ BI: Tableau, Oracle’s Business Intelligence Enterprise Edition (OBIEE), SSRS, IBM Cognos, Microsoft Power BI

Big Data Analytics (Hadoop): Apache Sqoop, Flume, Kafka, Storm, HBase, HDFS, Hive, Pig, Atlas, Ambari, Zeppelin, Mahout

Language: HTML, XML, SQL,JSON

PROFESSIONAL EXPERIENCE

Sr. BUSINESS SYSTEMS ANALYST

Confidential, O’ Fallon, MO

RESPONSIBILITIES:

• Intensive knowledge of Credit card Transaction Lifecycle, Card holder management Lifecycle and Credit card dispute resolution process and Understanding of PCIDSS.
• Conducted workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements.
• Liaison with the business community to define business requirements by conducting JAD sessions and one on one interview and provided input towards technical solutions in the form of BRD and FRD.
• Prioritized new features and functionality based on business needs.
• Assisted Product Owner in converting features into user stories.
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery using Microsoft Visio.
• Designed and developed use case diagrams, activity diagrams, sequence diagrams, and class diagrams.
• Involved in creating Entity-Relationship diagrams for the design of the database.
• Involved in technical writing of JSON and XML.
• Integrated Opsnet, MCCGUI and Wisdom to the main case manager by using Rest API.
• Analyzed data warehouse requirements and supported data ETL plan, data staging, and data quality plan.
• Assisted QA Team in writing test cases, test plans and tested the final application to verify whether all the user requirements were catered to by the application.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures and ensured that appropriate documentation is in place.
• Supported in conducting Conference Room Pilot & User Acceptance Testing.
• Timely tracked progress and reported it to Product Owner and Project Manager using CA Agile.

ENVIRONMENT: Scrum, CA agile, MS Office Suite(2016), SQL, MS Project (2016), OPSnet, MS Visio (v16.0), MCCGUI, GCM, Wisdom, Aspect, SSIS (2016), SSAS (2016), SSRS (2016), Selenium(3.0), Rest API, JSON

Business System Analyst

Confidential, Pennington, NJ

RESPONSIBILITIES:

• Knowledge of the Dodd-Frank Act, the Bank Secrecy Act, FinCEN and Sarbanes-Oxley Act.
• Assisted in identifying documents needed to develop Suspicious Activity Reports (SAR) as required by Bank Secrecy Act and FINCEN for generating reports and red flags to report fraud, money laundering, patterns and inconsistencies activities.
• Integrated third party services for enhanced due diligence (EDD) on our on-boarding customers, companies and ID documentations using REST API.
• Used SQL queries to retrieve data such as Select queries, Joins, Unions etc.
• Used JIRA for issue tracking, user story management and requirement traceability.
• Involved in testing activities such as test plans, test scenarios, test cases and test scripts.
• Assisted with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place.

Business System Analyst

Confidential, Pennington, NJ

RESPONSIBILITIES:

• Organized and Conducted the JAD team and in conducting the weekly sessions from requirement gathering to sign-off of the application after testing.
• Elicited demands from the stakeholders and analyzed them for consistency, completeness and flexibility.
• Interacted with SME’s, asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and business people.
• Communicated effectively across company contacts and clients, internal team about the project requirements, schedules and launches.
• Assisted the project manager to construct a project plan that included Project Schedules, Milestones tracking, and Meeting minutes using Jira.
• Developed use case documentation for system requirements, business process flows, and screen mockups using MS Visio.
• Created Wireframes and mock ups using Balsamiq and MS Visio, to effectively communicate the user-interface platforms to the system teams.
• Responsible for identifying and documenting business rules and creating detailed diagrams including Use Cases, Use Case diagrams, Business Flow diagram, Creating process models, Data flow diagrams.
• Involved in implementation by assisting in the preparation of training module. Helped the end users getting accustomed to the system by live demonstrations and system tutorials

Environment: Agile - Jira (6.0), MS Project (2013), UML, MS Excel (2013), SQL Server (11.0), MS Visio (15.0), Balsamiq2.2, HPUFT (11.5), Apache Sqoop, Flume, Kafka, Storm, HBase, HDFS, Hive, Pig, Atlas, Ambari, Zeppelin

BUSINESS ANALYST

Confidential, Madison, WI

RESPONSIBILITIES:

• Understood state of art processes by interacting with stakeholders and documents analysis and performed.
• GAP analysis to assist Product Owner and Project Manager in planning the transition.
• Facilitated JAD sessions as Moderator and conducted interviews with various Subject Matter Experts(SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.
• Prepared Business Requirement Document (BRD/HLD) and assisted preparation of System Requirement Specification (SRS). Analyzed, modified and validated these documents.
• Created Use Cases and built Use Case Diagram and Activity Diagram using MS Visio.
• Managed and tracked requirements using HP ALM through Application Life-Cycle.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to help development of an accurate Data Warehouse Structure.
• Integrated various OLTP to the OLAP by using Informatica as an ETL tool and used Tableau as reporting tool.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data,
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Was involved in using Tableau for effective reporting to provide Business Intelligence (BI) to facilitate expenditure tracking using various matrices critical to decision making.

ENVIRONMENT: Waterfall, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau, Informatica, MS Visio, MS Project, HP ALM, Wireframes, Mock-Up Screens, MsSQL Server, SharePoint, GAP Analysis, UML

Business Analyst

Confidential

RESPONSIBILITIES:

• Actively Involved in Pre-Analysis of project with SME (Subject Matter Experts) and Developers
• Conducted Gap analysis for ‘As-in’ and To-be of the process to identify and validate requirements.
• Participating JAD sessions with SME’s and multiple teams for requirement gathering and refinement.
• Analyzed the gathered requirement and reviewed Business Requirement Document (BRD)/Functional Specification Document (FSD).
• Created System requirement Specification (SRS) document to describe all data, functional and behavioral requirement of the system.
• Used Share point for content management and document management.
• Wrote Use Case and built Use Case Diagram/ Activity Diagram using MS Visio.
• Created Requirement Traceability matrix (RTM) using HP QC tool.
• Used JIRA for allotting task and issue tracking, user story management and requirement traceability.
• Worked with QA team for designingTest Plan and Test Cases, Test Scriptsfor UAT and regression testing.

ENVIRONMENT: Scrum, JIRA (4.4), MS Visio (v14.0), SQL, MS Word (2010), MS PowerPoint (2010), SharePoint (2010), UML

Business Analyst

Confidential

RESPONSIBILITIES:

• Worked in Waterfall as System Development Life Cycle (SDLC).
• Gathered requirements from key stakeholders, customers and SME’s to define the scope and requirements of the online banking system.
• Worked closely with Project Manager for any change request and helped to do Impact Analysis.
• Defined the context of the system by creating various Use Cases for the development system requirements specifications encompassing Functional and Non-Functional requirements.
• Developed plans for verification and validation of requirements at all levels so that developed software successfully fulfilled user expectations and business needs.
• Worked closely with the development team to verify that business needs are fulfilled and deliverables are produced within a specified budget, quality and time.
• Created Requirements Traceability Matrix (RTM) using HP QC tool.
• Developed UML Diagrams for modeling static and dynamic aspects of Online Banking System.
• Developed data maps for retrieval of information from existing account systems and outlined security measures for accessibility and transmission of information.
• Created ad-hoc reports using MS-Excel and Pivot tables to do the calculations and creating reports accordingly.
• Worked with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT) and Regression Testing.

ENVIRONMENT: Waterfall MS Project (2010), HTML, MS Visio (v12.0), MS Office (2010), XML, UML, HPQC

JUNIOR SQL DEVELOPER

Confidential

RESPONSIBILITIES:

• Created and maintained a database of restaurants.
• CreatedTableswithAttributesandConstraints and inserting Data into tables.
• Converted columns definitions -data types, default values, NOT NULL constraints, identity properties.
• Converted integrity constraints -primary and foreign keys, unique and check constraints
• CreatedStored Proceduresto make it easier for Supervisors to view data.
• CreatedTriggersto make sure no duplicate records are there in the database.

ENVIRONMENT: Waterfall MS SQL Server (v10.0), MS Office Suite (2007), SQL Server Reporting Services (2005)