PROFESSIONAL SUMMARY:

• Highly motivated and result oriented business systems analyst with 8+ years of experience in business analysis working in a wide range of IT projects in finance sector. Certified scrum master with a proven track record of working in self - organized, cross-functional teams and effectively interfacing with stakeholders both internal and external to the business.
• Thorough knowledge of all the phases in SDLC working in methodologies such as Waterfall, Waterfall-Scrum Hybrid, Scaled Agile Framework (SAFe), Agile-Scrum and good exposure to development practices including Test Driven Development (TDD), Behavioral Driven Development (BDD).
• Solid Written and Oral Communication skills, Presentations skills to keep executive staff and team members apprised of goals, project status by making use of Microsoft Office 365 Suite (MS Word, PowerPoint, MS Excel, SharePoint Server) and Project Management tools such as HP ALM, TFS, Jira, Confluence.
• Proven Track Record in conducting AS-IS and TO-BE analysis, ROI Analysis, Risk Analysis, Cost-Benefit Analysis and SWOT Analysis to assist PM in Project Planning and creating Change Management plans.
• Expertise in using various Elicitation techniques such as Interviews, Brainstorming, JAD sessions, Surveys, Reverse Engineering, Focus Group sessions to elicit business requirements and translate them into technical requirements and managing all stages of requirements from initial research to user acceptance testing.
• Experienced in creating Business Case, Product Roadmaps, Business Requirement Documents (BRD), Software Requirements Specification Documents (SRS), Functional Requirements Documents (FRD).
• Excellent track record of influencing organizational initiatives by positively influencing change management, process improvements that significantly reduce workloads adding value to the business.
• Proactive in collaborating with appropriate stakeholders on complex issues and conflicts that impact time, cost, scope, quality of assigned projects and recommend appropriate solutions to support business operations.
• Created SOP’s and related templates for Risk Assessment, Validation Protocols, Software Change Control, Validation Summary Reports and good experience in managing vendor relationship and Software tool selection.
• Experience in building UML diagrams including Use Cases, Activity diagrams, Sequence diagrams, Class diagrams, Data Flow Diagrams and transforming the requirements gathered into functional specifications focusing on workflow analysis and design, user interface design, data flow and process flow.
• Expertise in representing Graphic User Interface Design (GUI), Mocks-ups using Balsamiq tool, MS-VISIO and Smart Draw.
• Considerable experience gained in highly cohesive and loosely coupled Service Oriented Architecture (SOA) and 3-tier architecture with strong and in-depth understanding of XML (eXtensible Markup Language), Web Services (WSDL, SOAP, REST) and SQL.
• Proficient with Cloud Environment specially in AWS technologies, such as Amazon IAM, Amazon EC2, Amazon S3, Amazon EMR, Amazon RDS, Amazon Cognito, Amazon DynamoDB, Amazon CloudWatch, Amazon Lambda, Amazon Restful API Gateway.
• Designed and implemented SQL queries and stored procedures using joins, unions, inner & outer joins, group by, order by and aggregate functions to extract data from databases (Oracle, SQL Server) for timely reporting, validation.
• Good understanding of Data Warehousing Architecture, Data Modeling, ETL, OLAP operations such as Drill Down, Roll Up, Slice and Dice Techniques and OLTP systems and Source to Target System mappings.
• Experienced in API testing using Postman and SoapUI to check if the API’s are returning the data in JSON (Java Script Object Notation), XML (eXtensible Markup Language) format as defined in the API documentation and required by workflow.
• Worked with QA team to design, deploy Test plans and Test Cases for User Acceptance Testing (UAT) using HP ALM.
• Experience in Testing Life Cycle, supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.
• Thorough understanding of Business Intelligence (BI) and experience in creating interactive, analytical dashboards using Tableau and IBM Cognos/ Power Business Intelligence for visualization, historical data analytics and decision making.
• Mastered the Scrum Rules and Principles and art of facilitating Scrum Meetings such as Sprint Planning, Daily Scrums, Sprint Review, Sprint Retrospectives ensuring stakeholder collaboration to verify requirements are satisfied and delivered on time.
• I’ve Possessed Strong command on Defect management using tools such as JIRA, RALLY and HP ALM. Efficient at using Prioritizing and Estimation techniques to estimate User Stories after they were broken down from EPICS using INVEST criteria.

TECHNICAL SKILLS

Databases and Servers: MySQL, MS SQL Server, Mongo DB 12, Oracle 11g,12c, MongoDB, Apache Tomcat 5.x,6.x,8. Oracle Web Logic Server, JBOSS.

Programming Languages: Java, Python, C, C++, .NET.

Scripting and Web Technologies & Services: JavaScript, Angular.js, Node.js, JQuery, HTML, CSS, JSON, PHP, RESTful and SOAP Web Services.

Testing Tools: Selenium Test Suite, Appium, SOAP UI, JUnit, HP LoadRunner, Cucumber, Swagger, Postman.

Project Management Tools: HP ALM/QC, Version One, Jira, JAMA, Confluence, MS SharePoint, MS Project, Microsoft Office suite, TFS, Microsoft Office Suite- MS Word, MS Excel, MS Project, MS PowerPoint, MS SharePoint server.

ETL and Data Warehousing & Reporting: Informatica Power Centre, SSIS, DataStage, SSAS, SSRS, Power BI, Tableau, IBM Cognos.

Design and CASE Tools: MS Visio, CA erwin, Rational Rose, iGrafx, Balsamiq, FluidUI.

CI/CD and Version control tools: Jenkins, Ant, Maven, Git, Tortoise SVN, CVS.

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Sr. Business Systems Analyst

Responsibilities:

• Gathered requirements from business owner, relevant stakeholders by conducting story writing workshops and story mapping sessions with scrum team and conducted Interviews, Document Analysis, JAD Sessions to gather the Business requirements.
• Worked with the Compliance Team to adhere to the Data Storage Compliances with TRACE regulation.
• Evaluated the Business requirements for the enhanced Reporting system and identified the gaps as well as impact to reconcile conflicts and decompose high-level information into detailed technical requirements.
• Worked with Product Owner to create the Product roadmap and participated in project meetings to review the project deliverables, timelines and interacted with SME to establish the technical vision and performance needs.
• Developed relevant survey questions to be embedded with the Automated survey generating tool and set the triggers and timelines for the surveys to be sent out to customers and analyzed the collected survey data.
• Delivered effective PowerPoint, MS Excel Reports and Charts for findings and recommendations to multiple levels of stakeholders.
• Created Business Matrix and E-R diagrams using CA erwin Data Modeler tool and analyzed them to create "AS IS" and "TO BE" scenarios and further created PRD and made all documents accessible for the teams by using Atlassian’s Confluence tool.
• Assisted the Product Owner to efficiently reprioritize and groom the Product backlog for maximizing business value or return on investment (ROI) on the development effort based on the MoSCoW and KANO model.
• I’ve been assisting architect and developers in creating, maintaining and documenting various Amazon services like IAM, S3, Cognito, API Gateway, DynamoDB, CloudWatch, Route53, Redshift, Glue, Lambda and EC2 Instances.
• Designed UI Mock-up of the reports using Balsamiq, Smart Draw, MS-Visio tool as part of Proof of Concept and documented the feedback and used Jira and Confluence to maintain the project artifacts and kept the information radiators updated.
• Created the source to target mapping specifications documents and validated the Data Fields, Data Types and Data Integrity by writing complex SQL queries such as Joins, Unions, Stored Procedures on MS SSIS.
• SQL Probing to check validity of existing data within the databases and to protect the systems from SQL Injection Attacks. Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Responsible for review, validate and normalize historical data in Briefing Source before integration and ingestion into Redshift.
• Experience in Data Warehousing, Dimensional modeling, Data Normalization (1NF, 2NF, 3NF), Data Indexing, ETLmapping using and Informatica Data Quality for Data Profiling and Data Integrity.
• Tested Report Service SOAP API that was integrated the Salesforce CRM and other front office applications using Swagger Tool.
• Identified and Integrated various data sources like OLTP and Flat files and performed Data Verification, Validity and Normalization in maintaining the accuracy and effectiveness of data on Oracle.
• Created Reports and Sub-reports with Drill down, drill through in SSRS and formatted the reports using the Global variables, expressions and Functions and used Tableau for Interactive Visualizations of Geospatial Data.
• Integrated third party services for enhanced due diligence (EDD) on our onboarding customers ID documentation using REST API.
• Created Test Scenarios and Test cases and traced the requirements to Test Cases by creating Requirements Traceability Matrix (RTM) and ensured 100% Test Coverage of all the Business requirements.
• For proper functioning of blotter engines which is connected to Bloomberg API’s like B-PIPE, wrote, tested and implemented PL/SQL stored procedures, functions etc.
• Assisted in Acceptance Criteria for User Stories to perform User Acceptance Testing, Manual Testing and Automation Testing.
• Worked with Tableau Desktop, Confluence to perform data analysis of the traders and their stocks. Assisted the team in repository management and collaboration.
• I was held responsible for maintaining the defect log part of Defect management using tools such as HP ALM, JIRA and RALLY.

Environment: Waterfall- Scrum, Jira, MS SharePoint, MS Office Suite, MS Visio, Mongo DB, Salesforce CRM, Apache Tomcat 7.0, Dataedo, CA ERWin, MS SQL Server 2016 Suite (SSIS, SSAS, SSRS), Survey Gizmo, Tableau, Selenium Web-Driver, SOAP API, Swagger, SOAP UI.

Confidential, Malvern, PA

.Sr. Business Systems Analyst

Responsibilities:

• Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements
• Executed and enhanced management of portfolio pertaining to Digital Activity Data, Customer Data and Investment Risk Tolerance Data. The enhancement provided suggestions, which followed the SEC (U.S. Securities and Exchange Commission) SIPC (Securities Investor Protection Corporation) and FINRA (Financial Industry Regulatory Authority).
• Ensured that PO prioritizes the product backlog and PBI's with higher priority are at the top of Product Backlog.
• Conducted CATWOE Analysis to gather requirements for Security Suggestion and ensured that the Parking Lot List issues/suggestions were focused upon in a timely manner and maintained in JIRA as well.
• Developed work flows using Lucid Chart, and involved in creating wireframes using axure, mockups in Balsamiq, Smart Draw, MS-Visio and prototypes using the JustInMind tool.
• Performed Gap Analysis of the "As-Is" and "To-Be" process within the organization to analyze and fill the existing gaps in the business processes and participate in business processes.
• Created Business Requirements Document (BRD) to incorporate Business requirements, Business process flow and Information flow, Software Requirements Specification (SRS) to incorporate functional, non-functional, GUI requirements, Data requirements, Use Case Model, Conceptual Models, Requirements and Traceability Matrix (RTM) and analyzed Epics, user stories to decompose complex stories by vertical slicing which were based on the INVEST criteria.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
• Performed data validation with use of SQL queries and functionalities like cardinalities, inner and outer joins, unions, views, aliases, aggregate and made reports using SSRS.
• Designed data warehouse on Power center using extraction, Transformation and Loading data from heterogeneous source systems into the target MYSQL database.
• Created the source to target mapping specifications documents and validated the Data Fields, Data Types and Data Integrity.
• Administered ETL Process, identified source table, target table and mapped the data of various Portfolios and securities using Informatica Power Center and created the data-mapping document using MS Excel.
• Involved in web services using JSON for creating documents based on the business information using REST API.
• Involved in User Acceptance Testing, Manual Testing and Automation Testing using tools as QTP, Selenium, Jmeter, providing teams with user guide, user manual and was responsible for creating Requirements Traceability Matrix to track the requirements with different functional areas.
• Involved in developing the test strategy document and assisted in developing test plans, test case objectives and test Helped in developing QA Test plans for Functional, Integration and System Testing. Performed Black Box Testing. Assisted in GUI testing, smoke testing, regression testing cases.
• Worked with Tableau and Excel for reporting and analyzing the portfolio performance and fixed income analytics such as Asset Allocation, Cash Flows, Profit and Loss of Hedge.

Environment: Waterfall-Scrum Hybrid, Java, JBoss AS 7.1.1, Scala 2.1, Spring 4.1, JustInMind 6.3.1, PingPlotter, SoapUI 4.5, HTML5, CSS3, jQuery 1.11, three.js, D3.js, Oracle 11G/R2, Tableau 8.2, JIRA 6.3, Informatica 9.1, MS Office Suite (Word, Excel, PowerPoint, Outlook), MS Project 2013, Rational Rose.

Confidential, New York City, NY

Business Systems Analyst

Responsibilities:

• Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems.
• Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
• Understood problem definition through one to one meetings with Data architect, Enterprise architect and Solution advisors.
• The methodology used for the project was Waterfall and had a deep understanding about the requirement gathering. Provided clear and consistent information about project status both internally, IT team and stakeholders.
• 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.
• Prepared Business Requirement Document (BRD/HLD) and Drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents.
• Created the source to target mapping specifications documents and validated the Data Fields, Data Types and Data Integrity and Involved in the Data Migration effort when data was migrated from the legacy database to SQL Server 2016 Database to meet the business requirements.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
• Worked with the Data Architect in identifying Dimensions and the appropriate atomic granularity of data required based on the reporting requirements for the Star and Snowflake Schema design of the Data Mart.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Assisted ETL developers to map data from different sources (Bloomberg B-Pipe and Thomson Reuters) and perform transformations for all the assets such as equities, fixed income and derivatives to the trader’s system enabling them to upload the order details as the business required.
• Assisted in increasing Data Integrity by performing Data Normalization, Data Standardization and Data Indexing to maintain accuracy and effectiveness of data using Oracle Database.
• Involved in User Acceptance Testing phase providing them with user guide user manual and was responsible for creating Requirements Traceability Matrix to track the requirements with different functional areas.
• Helped in developing QA Test plans for Manual, Functional, Integration and System Testing. Performed Black Box Testing.
• Assisted in Manual Testing using HP ALM, Jmeter, QTP, Automation testing using Tricentis, mabl, GUI testing, smoke testing, regression testing cases.
• Created various types of reports/ad hoc reports and drilldown like standard and cross tab -reports with bar chart, pie chart and line-chart graph representation reports for analytics using Tableau, Informatica and Talend.

Environment: SDLC, Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS SQL 2008, SSDT-BI

Confidential, Santa Monica, CA

Business Systems Analyst

Responsibilities:

• Documented liquidity and maturity timings, behavior and risk appetite of short and long-term trading entities, built process maps and API specifications for data consumption by evaluating their access patterns.
• Built Access Management, Messaging Queue and Rules based workflows and UML diagrams to deliver Batch/ Real time communication based on User, Market, Fund manager or Confidential system triggers.
• Analyzed the mainframe systems to document the database components needed for data modeling. Worked as the Data Analyst for creating database constraints, triggers, partitions, indexes and retention
• Worked on the volume impact for enterprise rollout, collaborated with performance engineers to perform load test activities in an iteration fashion to prepare a plan for capacity planning and determining the priority of feature rollout in incremental stages
• Led the story grooming activities by creating framework and technical stories, reviewing with business and technology partners in Sprint planning sessions.
• Worked on Confidential 's Custom platform to host content for the different messaging requirement for dashboard and email delivery to build templates for channel integration using Webservice protocols
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Reviewed project Status during Daily touchpoint calls, built reports for project tracking and velocity determination during each operational phase, offering demo to business partners to showcase project delivery status and identifying opportunities of improvements during 'Retrospective' meetings
• Provided ad-hoc reports to Business users by writing SQL queries or VBA macros.
• 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.
• Worked on a service-oriented architecture to connect compliance engine to compliance web services using SOAP API
• Involved in web services using JSON for creating documents based on the business information using REST API.
• Reviewed test plan and test cases for User Acceptance Testing (UAT), Manual Testing and Automation Testing. Coordinated UAT and provided a demo in UAT to Business users.
• Was involved in using Tableau for effective ad hoc reporting to provide Business Intelligence (BI) to facilitate expenditure tracking using various matrices critical to decision making.

Environment: Java, WSO2, CSS3, Custom CMS, MS Visio, JIRA, Confluence, SOAP UI, DHC/Restlet, MS SQL, Cassandra DB (Basic)

Confidential

Business Systems Analyst

Responsibility:

• Analyzed the business process along with the prior project documentation for document analysis in order to understand and prepared a configuration document to provide SAP Technical consultant for further analysis
• Conducted Brainstorming Sessions with end users and SME to understand the processes and gather requirements and facilitated one-to-one interviews with key stakeholders and SME’s for requirements gathering
• Complete comprehension of the task for materials administration module
• Performed knowledge transfer of business requirements and functional requirements with the development and test teams
• Used SharePoint 2007 for content management and document management
• Immediate resolution to PRs according to Schedule Level Agreement (SLA)
• Performed data validation with use of SQL queries and functionalities like cardinalities, joins, views, aliases, aggregate and made reports using SSRS.
• Developed Test Plans, Test Scripts and maintained Master Test Plan. Additionally, performed User Acceptance Test (UAT) and Systems Integration Testing (SIT)

Environment: ASAP, MS Visio, MS Office Suite, Windows XP, SAP Solutions Manager, SharePoint2007

Confidential

Java Developer/Business Analyst

Responsibilities:

• Driving Served as a liaison between HR department and the project team by assisting the business in identifying, understanding the recruitment process and documenting their business needs
• Initiated JAD sessions for design and documentation of the System Design Document (SDD) and monitored that all the requirements were implemented into functionality
• Created packages, views, functions using SQL queries to get data from SQL server
• Created prototypes for the application using HTML which helped business users to give their feedback
• Involved in designing Front-End User Interface (UI) Screens using HTML, CSS, Java Script
• Responsible for implementation of tasks to build required features and user training
• Involved in unit testing, debugging, and document test cases
• Created robust and efficient application following a Model View Controller (MVC) pattern for application development
• Worked on Stored Procedures, Database Triggers, Views and Transactions handling in SQL Server 2005

Environment: MS Office Tools (Word, Excel, PowerPoint, Visio), Visual Studio 2005/2008, HTML, CSS, SOA, SOAP

Confidential

Java Developer

Responsibilities:

• Understood the business process and assisted in developing Java Server Pages using HTML/CSS for User Interface and Java classes for business logic
• Designed the Front-end Screens using Servlets and extensively used JavaScript for client-side validations
• Used AJAX and JavaScript for validations and integrating business server-side components on the client side within the browser
• Coordinated with the back-end team for integration issues and participated in Code Review preparing Test Cases
• Coded Data Access Object layer to send data retrieved from Oracle RDMS database to controller, through business delegate layer
• Worked with servlets and used JDBC for database connectivity to MySQL
• Involved in defining the source to target data mappings, business rules and definitions. Created Report-Models for ad-hoc reporting and analysis.

Environment: Java, JavaScript, JDBC, JSP, Servlets, Apache Tomcat, PL/SQL, RDBMS