Sr. Business Systems Analyst Resume
Irvine, CA
PROFESSIONAL SUMMARY:
- Around 8 years of work experience in Business System Analysis, Data Analysis, Software Design, Development, Implementation and Quality Assurance of business applications with knowledge of the Software Development Life Cycle and Quality Assurance Life Cycle.
- Excellent understanding of SDLC methodologies: Waterfall, Agile/Scrum, Kanban, SAFe, and Hybrid Methods
- Collaborated with Solution architect to create Application Arch, Logical Arch, Component Arch, Security Arch models.
- Proficient in Eliciting complex business Requirements using techniques such as Document Analysis, Stakeholder Interviews, Brainstorming, Joint Requirements Planning (JRP), Joint Application Development Sessions (JAD).
- Extensive experience performing Data Mapping from source data to target data for several projects.
- Proficient in SOA implementation, with a good knowledge of web services, web methods, XML, WSDL, SOA,
- Hands on experience identifying and documenting with Client side, Server side and Database Validations.
- Actively contributed for SOA Orchestration and extensive knowledge in 3 - tier and n-tier architecture.
- Adept at analyzing and anticipating the possible interdependencies between systems, potential risks, issues
- Analyzing Business requirements and preparing functional requirements document (FRD), business requirement Document (BRD), project charter and, systems requirement specifications (SRS) and DSD (Design specifications Document).
- Conducted GAP analysis by analyzing the existing system, recommended strategies to improve processes.
- Proven success performing Risk Analysis, Impact Analysis and Interface Analysis on multiple projects.
- Involved in various Testing Methods such as Black box testing, Functional Testing, Regression testing, Performance Testing, ad hoc Smoke testing, Load testing, Integration testing as well as User Acceptance Testing (UAT).
- Experience in creating Test Plan, Test Cases and Test Scripts for Functional and Non-Functional testing.
- Expertise in Enterprise Security Architecture and delivery of strategic security solutions.
- Hands on experience Tracking, prioritizing defects using HP Quality Center based on criticality and severity and tracking the progress of testing by creating Requirement Traceability Matrix and Defect Matrix.
- Expertise in Business Process Modeling Notations (BPMN) and UML Diagrams (Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Entity Relationship Diagrams) using MS Visio.
- Expertise in logical and conceptual data modelling (LDM, CDM) for both data migration and web applications
- Experience in creating Static Prototypes, Dynamic Wireframes, Mockup screens using HTML, Visio and
- Experience working in different databases like Oracle, DB2, SQL server, data visualization and reporting tools like Tableau, SQL Server Reporting Services, and Pl/SQL.
- Extracted data from databases and reconciled results against production data for AUM (assets under Management) and analytical purposes using SQL
- Experience in financial management: Financial Statements, Cash Flow Analysis, and Cost Analysis.
TECHNICAL SKILLS:
Methodologies and Frameworks: Waterfall, Agile, Scrum, Hybrid, Kanban, Scrumban, SAFe (DevOps), ATDD, TDD, BDD, CICD
Operating Systems: Windows, Unix, Linux
Languages: SQL, NoSQL, PL/SQL, CQL, R, Python, HTML
Dev Environments: .Net, Java, C, C++, JavaScript, Node.js, HTML, CSS, SOA
Web Technologies: Hadoop Stack, AJAX, JWT, JSON, XML, HTML & CSS, RESTful Services, Apache Hive, MapR, Apache Spark, Pig, Zookeeper, Kafka, Flume, HBase, Sqoop, Storm, Flink
Databases: SQL server, ORACLE, MS Access, DB2
Project Management Tools: Jira, Confluence, Rally, MS Project, HP ALM, TFS, SharePoint
Prototyping: Fluid UI, Balsamiq, MS Visio, Lucid Charts
Business Analysis Tools: Office 365, MS Visio, Wikidsmart
Business Intelligence Tools: Power BI Desktop, Qlikview, Tableau
Mapping Tools: Informatica PowerCenter, Erwin, MS Excel
Reporting Tools: Tableau, Crystal Reports, Xslfo
Testing Tools: Load Runner, Zephyr, Postman, Swagger, Selenium
DevOps Tools: Jenkins, AWS Code Commit, GitHub, Splunk, AWS CodePipline
Cloud Services: EC2, Redshift, RDS, S3
PROFESSIONAL EXPERIENCE:
Confidential, Irvine, CA
Sr. Business Systems Analyst
Responsibilities:
- Consistently collaborated with Solution architect to create Application Arch, Logical Arch, Component Arch, Security Arch models for the portfolio management system.
- Actively participated in Pre PI planning and PI planning to ensure alignment, transparency, and built in quality.
- Dealt with spike user stories efficiently by ensuring accurate time-box and swarming session or team swarming.
- Facilitated ceremonies including Daily Iteration meetings, Iteration planning, Product Backlog Grooming, Iteration review, and Iteration retrospective and involved in every scrum ceremony.
- Experience using Pl/SQL for reporting capabilities on oracle database in order to extract insights such as comparison, rebalancing, and block trade reports
- Assisted product owner to prioritize the product backlog routinely using techniques like MoSCoW, Kano, and WSJF
- Facilitated team Agile Games such as Oscars and Wall-to-Wall to help build a better collaborative environment within the team and to better understand SAFe principles and benefits.
- Worked with the Product Owner (PO) to write technical User Stories, Acceptance Criteria DOD (Definition of Done and DOR (Definition of Ready) in order to mitigate any development risk.
- Effectively handled the Requirement Churn during the sprint cycle and added the PBI to the next sprint.
- Assisted PO to convert high level requirements EPICS into small User Stories as well as tasks using INVEST criteria.
- Skillfully managed any change requests in the project effectively and efficiently while maintaining and managing scope creep, time, and budget.
- Facilitated the CICD in Jenkins and Puppet by monitoring developer committed codes using Splunk.
- Played a pivotal role in setting up User Acceptance Criteria for user stories to be accepted by the business.
- Responsible for resolving various impediments affecting the progress of the project with the help of product owner for improving the velocity of the project and help team members work in a faster manner.
- Lead the QA team in executing many test cases with BDD (Behavior Driven Development) framework using cucumber to run automated acceptance tests written in a gherkins format
- Dealt with loosely coupled system and used SOA architecture to interact with other Web Services and databases.
- Performed both LDM and CDM (physical and conceptual data modelling) data models using Erwin in order to visualize the flow of data with the application.
- Conducted statistical test such as descriptive summarizing reports in order to check the accuracy of the predictive models, such as logit and probit regression models.
- Created Dynamic Wireframes using Fluid UI for better understanding of the GUI and flow of the application.
- Supported the Surveillance Monitoring and Testing in managing certain aspects of the SMT Compliance Program which focused on managing the annual Americas CIB risk assessments.
- Involved in identifying and implementation of RESTful based web services, micro services, and APis.
- Acted as the point of contact for clarifying business and functional requirements to the development team.
- Performed Data Mapping to identify and standardize the data from various distributed systems.
- Modelled Web Orchestrations involving multiple web services for generating Performance reports for supervisors and Relationship Managers/Custodians.
- Assisted developers in implementation of SSO (Single Sign On) with security measures to secure the application without dampening productivity.
- Assisted Data Services to implement custom regression and machine learning models for what-if analysis feature.
- Performed API Documentation using SwaggerHub, also for use of visualization and version control of APIs
- Involved in creating templates in crystal reports for performance reports using the data available based on the needs and the requirements.
- Facilitated many KT sessions on capital market domain topics for the development team like asset allocation, portfolio models, derivatives, rebalancing, fee calculations, private equity etc.
- Facilitated meetings with the development team to help them better understand user stories and to help them come up with code flow for these research items.
- Worked to make sure of ample compliance testing in pipeline to make sure the application was compliant to SEC, Regulation T, and Dodd-Frank.
- Created Mockups and Wireframes for better understanding of the GUI and worked with the line of business, the technical team to identify the Client Side, Server Side and Database Validations required and documented them.
- Effectively translated the functional specifications in to test scenarios and test cases.
- Experience in creating Test Plans to allocate testing resources as well as testing methods and procedures.
Environment: SAFe, UML, BPMN, VISIO, C#, ASP.net, Oracle, Excel, Postman, Web Services, MS-Office, Crystal Reports, SharePoint, Ajax
Confidential, Minneapolis, MN
Business System Analyst
Responsibilities:
- Functioned as the liaison between the line of business and the technical teams throughout the project life cycle.
- Conducted Joint Requirements Planning(JRP) sessions with the Subject Matter Experts(SME) and the key stakeholders to understand business processes and the functionalities in detail.
- Conducted Walkthroughs and Meetings involving leads from Development, Database and Technical Support teams.
- Evaluated current and develop new processes and procedures and ensure their relevance and accuracy.
- Ascertained the scope of data needed to be migrated by using the business processes as a point of departure.
- Supported and lead, where needed the various activities between the teams, for the implementation of the new data lake, including decommissioning, to ensure the business and technical requirements are met.
- Analyzed the risks involved by conducting Cost-Benefit Analysis in Microsoft Office Environment.
- Created Unified Modeling Language(UML) diagrams including BPMN, Activity, and Data Flow Diagrams.
- Understanding and implementing of Data Lake technologies (Hadoop stack) for Big data solutions
- Inextricably involved in tool selection by facilitating and participating in many JAD sessions
- Worked with data governance team to implement Data Catalog Tagging System (DCTS) based on transformation rules with Hadoop Ecosystem.
- Prepared status updates as well as MOM (Minutes of Meeting) on a regular basis to follow progress of teams.
- Assisted in implementing of Role based access to further secure the Data Lake to mitigate risk of data breaches.
- Developed high level requirement documents and consulted the technical team and d to the detailed System Requirement Specification (SRS) document for source data.
- Coordinated the definition, evaluation and agreement of the business solution options in collaboration with the Big Data Solutions Architect and Data Services Technical Lead.
- Tested the requests and responses provided by the Restful Services using Postman.
- Helped to performed both conceptual and physical data modelling using Erwin for a visual representation of data including business rules, regulatory compliances, and government policies on the data.
- Extensively involved in performing Data Mapping to understand organization and flow of data moving into the Lake.
- Develop a test plan including functional QA, integration testing, string testing, ICAT, ECAT.
- Drafted Service Level Agreements (SLAs) in conjunction with CLIP (Compliance, Legal, Info Sec, Privacy)
- Conducted Product Demo meetings upon the readiness of a new deliverable, PSP (Potentially Shippable Product).
- Leveraged technical abilities to create technical user stories with acceptance criteria, and the Definition of Done (DOD) and Definition of Ready (DOR) in order to mitigate any development risk.
- Effectively managed WIP Limits along with PO in Jira for the Kanban boards to ensure the maximum amount of productivity.
Environment: Hybrid, Kanban, NoSQL, SQL Server, Oracle, JSON, HDFS (Hadoop Distributed Filing System), Apache Hive, Pig, Apache Spark, MapR, Big Data, Hbase, Flume, Kafka
Confidential, Tampa, FL
Business Analyst
Responsibilities:
- Performed Document Analysis and conducted Stakeholder Interviews to elicit high level functional requirements.
- Assisted the Project Manager in creating the Work Breakdown Structure(WBS) for the project.
- Conducted JAD and Brainstorming sessions for refining the requirements in coordination with multiple teams.
- Analyzed the as-is and to-be state of the project and performed Gap analysis.
- Performed Interface Analysis to understand the dependencies among the various distributed teams.
- Dealt with and used SOA architecture to interact with other Web Services, APIs, Microservices, and databases.
- Analyzed the Databases of the various teams by using SQL Queries and performed Data Mapping.
- Created Use Case diagrams, business flow diagrams, Activity/Workflow diagrams using Rational Rose Modeler.
- Created Mockups and Wireframes using Fluid UI and MS Visio for better understanding of the GUI and worked with the line of business, the technical team to identify the Client Side, Server Side and Database Validations required and documented them.
- Documented compliances needed for the enhancement project such as FINCEN, SEC, SOX, and IRS.
- Automated iterating tasks using macros in MS Excel reducing manual effort and increasing productivity.
- Performed Risk Analysis to identify the project critical success factors and prioritize functional requirements.
- Effectively conducted Change Request Management and assigned priority on each change.
- Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing.
- Conducted Triage calls, tracked, logged and prioritized the defects based on the severity and criticality.
- Conducted UAT (User Acceptance Testing) and wrote the user manual for UAT.
Environment: Waterfall, Jira, UML, MS Project, Visio, TFS, MS SharePoint, Excel, MS SQL
