We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

Pittsburg, PA

PROFESSIONAL SUMMARY:

  • Domain knowledge in Mortgage Life Cycle including Conventional, VA, FHA, Non - Conventional mortgage loans.
  • Good understanding of mortgage workflow from end to end, risk associated with the Mortgage process.
  • Good Understanding of TRID i.e., TILA / RESPA and about Loan Estimator and Closing Disclosers forms.
  • Effective communication to identify needs and evaluate alternative business solutions with project management.
  • Working with developers and Salesforce admins, describing profile and data visibility requirement, setting up workflow rules and validations, Setting up reports and dashboards.
  • Techno-Functional experience with Salesforce, Sales cloud and Marketing cloud and guiding clients on CRM solution for sales, marketing and services teams.
  • Experience with Salesforce.com Reports, Dashboards, Forecasts, Workflows.
  • Possess Comprehensive understanding of CRM business processes like Campaign Management, Lead Management, Account Management, Case Management and Call Center.
  • Integrated Web Services for extracting the data from external systems to display in the pages of salesforce.com.
  • Engaged with stakeholders to gather software requirements to ensure alignment with development team.
  • Understanding of Salesforce.com implementation cycle in Sales, Marketing, Service and support modules.
  • Expertise in conducting Brainstorming sessions, Interviews, Joint Application Development Sessions (JAD), Focus sessions for requirements gathering, analysis and design with stakeholders, Developers and system architects.
  • Well versed in documentation of Business Requirement Document (BRD), Use Cases, Requirements Traceability Matrix (RTM), System Requirement Specification (SRS) and Test Requirement Document (TRD).
  • Facilitated GAP Analysis, Impact Analysis (Business/Technical), SWOT Analysis, Cost-Benefit Analysis, Root Cause Analysis and Risk Analysis along with creating As-Is and To-Be Business Models.
  • Collaborated in identifying Key Performance Indicators (KPIs) to accurately analyze the needs of clients leading to optimization of the business processes, which eventually led to value creation for the organization and client.
  • Created Use Cases, Data Flow diagrams and Activity diagrams using UML tools like MS Visio and Rational Rose .
  • Created Prototypes, Wireframes and Mock-Up Screens by assisting the UX team to visualize Graphical User Interface (GUI) according to GUI requirements using tools like Balsamiq Mockups and Mockup Screens.
  • Worked in close co-ordination with the QA and software testing team in developing test plans and test cases from functional and business requirements for Integration testing, Quality Assurance and User Acceptance Testing.
  • Executed SQL queries using joins, group by and order by to extract data from different data sources and to perform DDL (Data defining language) operations to create, read, update and delete (CRUD) the data in the database.
  • Familiar with DB concepts like Data Structures, Data Marts, Data-Entity Relationships and User Administration. ­
  • Implemented Databases, table structures, mapping Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice and pivoting.
  • Involved in client interactions and converting business functionalities into Service Oriented Architecture (SOA) models across heterogeneous IT environments. Extensive knowledge of SOAP/RESTful web services.
  • Knowledge about SaaS cloud-based architecture and services such as AWS EC2, S3, RDS, Aurora and EBS.
  • Highly proficient in writing and slicing User Stories and handling the Requirements Churn.
  • Efficient at user story prioritization techniques such as MoSCoW & KANO Model.
  • User Story Estimation techniques such as Planning poker, Relative Mass Valuation & T-Shirt Sizing.
  • Participated in Scrum ceremonies like Backlog/Grooming Refinement, Sprint Planning, Daily Scrum Meeting, Sprint Review and Sprint Retrospective Meetings for each sprint in Agile Scrum Methodology
  • Experience in recording and maintaining the artifacts like impediments list, sprint burndown charts and sprint burnup charts to track the team’s performance and keeping it visible to the team members and owners.
  • Self-Motivated and Objective driven professional with excellent communication and Interpersonal Skills with a sound understanding of the balance that must exist between customer satisfaction and technical excellence.

SKILL:

SDLC Methodologies: Waterfall, Spiral, Waterfall-Scrum Hybrid, Scrum, Extreme Programming, Scrumban

Business skills: Impact analysis, Gap analysis, Change analysis, JAD sessions

Languages: jQuery, JavaScript, Java, HTML5, XML, PL/SQL, AQL, AML, JCL, Bootstrap

Databases: My SQL, Oracle, Microsoft Access, DB2, Microsoft SQL Server

Requirement management tools: JIRA, Rally, Confluence, Microsoft Office, MS TFS, MS Share Point, ClearQuest

Reporting/BI Tools: Informatica, Tableau, Power BI, IBM Cognos, SSRS

Design Tools: MS Visio, Rational Rose, Mock-up Screens, Balsamiq

Testing Tools: HPQC, HPALM, Cucumber, Selenium

Misc Tools: MS Office Suite (MS Word, MS PowerPoint, MS Excel), Putty, Inspector, HP service center

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, PA

Sr. Business Systems Analyst

Key Responsibilities:

  • Created Business requirement document and functional specification document to tailor the needs of the client.
  • Worked with the team for decomposing the functional specifications into user stories and acceptance criteria.
  • Performed GAP analysis using the AS-IS process flow document and the TO-BE process flow document.
  • Interviewed SME’s to understand the current TILA/RESPA Integrated Disclosure Rule .
  • Configured security and organizational hierarchy for sales for salesforce implementation.
  • Involved in Design and development of workflows, triggers, validation rules and customizations with Salesforce .
  • Administered Salesforce CRM applications for Sales, Marketing and Support Departments.
  • Designed, developed and deployed the custom objects, page layouts, custom tabs, components, VisualForce pages to meet the needs of the application.
  • Led analysts in the system integration analysis, data analysis and requirements elicitation for the implementation of data in/from enterprise data services hub in data format .
  • Customized Page Layouts for Salesforce.com Standard and Custom objects.
  • Created Use case diagrams, activity diagrams and class diagrams for graphical representation using MS Visio.
  • Involved in designing and implementing cases and service ticket management using salesforce Service cloud.
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.6.
  • Used JIRA to allot task and track issues, user story management and requirement traceability.
  • Developed Views, Joins, Procedures, and Functions using PL/SQL & SQL to transform and structure data.
  • Developed tables, reports, graphs and listings using various Stored procedures to perform data manipulations .
  • Maintained RTM to trace the requirements with corresponding test cases to satisfy test scenarios.
  • Actively involved in planning Test Cases , Test Plans and Test Scenarios to perform Functional Testing , Smoke Testing , Regression Testing and User Acceptance Testing and logged down defects and managed them in JIRA .
  • Understanding in Saas infrastructure in Amazon Web Service such as EC2, RDS and S3.

Environment: Agile, Scrum, AWS, EC2, AWS RDS, Expere, AWS S3, Jira, HP QC, Microsoft SQL, MS Visio, MS Word, MS excel, JAVA, XML, HTML5, Bootstrap, AJAX, Jquery, Angular JS, Eclipse EDE, Jenekins Informatica.

Confidential, Warren, NJ

Sr. Business System Analyst

Key Responsibilities:

  • Gathered project requirements, using techniques such as JAD, document analysis, interface analysis, requirements workshops, and interviews with Subject Matter Experts (SME) and stakeholders.
  • Reviewed, analyzed and developed Business Requirement Document (BRD), Functional Requirement Document (FRD) and helped in transforming them into a complete System Requirement Specification (SRS).
  • Understanding of Salesforce.com SFA, Force.com Apex Classes, Apex triggers, Integration, Visual force, Force.com API, SOQL, and SOSL .
  • Administrated and monitored the company’s Salesforce CRM application. Created the workflows for automated lead routing, lead escalation and email alert
  • Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Opportunities, Quotes, Activities, Dashboards and Reports.
  • Manage forecasts, contract management and pipeline maturity through the Sales Force.com CRM software.
  • Helped in prioritizing Product Backlog Items by breaking down EPICS into user stories using INVEST criteria.
  • Facilitated Product Backlog Grooming meeting whenever required for reprioritization of product Backlog.
  • Assisted in preparing UI wireframes, Mockup screens for the lender’s home page requirements document.
  • Created Use Case document by specifying actors, normal flow, alternative flows for all use cases.
  • Created activity diagrams, context flow diagrams and sequence diagrams to specify the order of interactions.
  • Wrote SQL queries for data analysis queried relational databases daily to resolve operational issues.
  • Involved in Salesforce.com application setup activities and customized the apps to match the functional needs of the organization
  • Involved in Data Extraction, Transformation and Loading (ETL) from Source to target systems using Informatica.
  • Composed and actualized Salesforce Service Cloud to empower the Customer Service group to manage.
  • Worked on data migration from databases to SFDC using Data Loader.
  • Implemented and maintained Salesforce Service Cloud and Sales Cloud. Built custom solutions with Apex and VisualForce, which support most critical processes and workflows.
  • Assisted QA team to identify test scenarios pertaining to loan origination, underwriting, processing and closing.
  • Coordinated with operations team to maintain stability and functionality pertaining to different environments of the application like System integration, UAT and production environment.
  • Gathered requirements for all automation workflows as per business requirements and translated in to salesforce business terms.
  • Assisted product owner in Sprint Review and solution demo meetings by facilitating product demos and backtracking them to the requirements to determine when it is DONE and shippable.
  • Helped the team in creating visual information radiators. Managed timely communication between various internal and external stakeholders. Helped the team to inspect and adapt process in the retrospective meetings to improve their productivity

Environment: Scrum, Jira V6.3, Confluence V5.9, IBM DB2 V8.1.0, Mock-Up Screen, Informatica, MS Visio V14.0, Subversion, Apache Tomcat V7.0, Tableau V8.2.1, JCL, CICS V3.2, XML, SOAP UI, SOA Architecture, Win-FTP, Java servlets V3.0, JSP V2.2, Java EE 7.

Confidential, Boston, MA

Business System Analyst

Key Responsibilities:

  • Understood state of art processes by interacting with stakeholders and analyzing the available documents.
  • Facilitated JAD sessions as a Moderator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.
  • Conducted Gap Analysis to identify missing data attributes from source system coordinating with database team.
  • Assisted in preparation of Business Requirement Document (BRD) and System Requirement Specification (SRS).
  • 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.
  • Retrieving data from various sources, analyzing using statistical techniques and providing ongoing reports.
  • Assisted in extracting data to staging area and loaded it to target database by ETL processing using Informatica.
  • Assisted Database team to create database objects like tables, views, procedures and joins using PL/SQL.
  • Responsible for data mapping with XML and RESTful APIs to integrate with different web services.
  • Performed analysis and testing of relational databases and resolve any issues pertaining to data retrieval.
  • Experienced in identifying different database schemas pertaining to specific information.
  • Involved in creating data flow diagrams, data mapping from Source to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied in SSIS.
  • Worked with QA team in developing Test Plan and Test Cases to perform UAT, Functional and Regression Testing.
  • Assisted in creating conceptual, logical ER diagrams and designed database schemas for accurate Data Warehouse Structure.
  • Integrated various OLTP to the OLAP by using Informatica as an ETL tool and used Tableau as reporting tool.
  • Maintained Data Integrity by normalizing the data adding verification for accuracy and effectiveness of data.
  • Assisted product owner in segregating user stories into different types such as data disclosure stories, data presentation stories, data augmentation stories, data validation stories and data configuration stories to identify specific requirements.
  • Logged the defects using HP ALM. Created an error repository and managed the testing process with QA team.
  • Analyzed Business Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, User Interface, Performance, Usability and Security requirements.

Environment: Waterfall-Scrum Hybrid, Version one V13.1, Informatica V9.1, GIT Hub, MS Visio V14.0 HP ALM, Mock-Up Screens V4.32, Microsoft SQL Server 2012, Tableau, MS SharePoint

Confidential, New York, NY

Business System Analyst

Key Responsibilities

  • Interacted with stakeholders and end users to define the scope of application and gather User Requirements.
  • Created Requirement Specification Documents after conducting JAD Sessions and analyzed the current systems.
  • Conducted functional requirement reviews and walkthrough with the Integration experts and stakeholders.
  • Identified Use cases and UML diagrams like Use Case Diagrams, Activity Diagram using MS-Visio.
  • Assisted the UI team in creating GUI mock-ups using MS Visio according to the UI and UX requirements.
  • Monitored Defect Tracking to ensure that testing efforts progressed with the development effort of the team.
  • Created logical and physical models using best practices to ensure high quality and reduce redundancy.
  • Created schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
  • Closely involved with developers to write SQL queries in order to populate different tables used for reporting.
  • Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
  • Drafted the Test Plan and prepared various test cases, test scenarios and test scripts for the project items.
  • Designed Test Cases for User Acceptance, Regression, Black Box and White box testing with the help of QA teams.
  • Analyzed Business Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, User Interface, Performance, Usability and Security requirements.
  • Tested the final application for usability to verify whether all the user requirements were catered by the application.

Environment: Oracle, MS Access, Rational Requisite Pro, Mercury Quality Center, MS Visio, MS Project, Windows XP/2000

Confidential

Business Analyst

Key Responsibilities

  • Gathered requirements from key stakeholders, customers and SME’s to define the scope and requirements of online banking system and conducted GAP analysis to better understand To-Be scenario.
  • Defined the context of the system by creating various Use Cases for the system requirements specifications (SRS) encompassing Functional and Non-Functional requirements.
  • Created Requirements Traceability Matrix (RTM) using HP QC tool to map the test cases with the requirements.
  • Used Microsoft Visio to create Use Cases, Activity Diagrams, Sequence Diagrams and Collaboration Diagrams.
  • Create logical and physical models using best practices to ensure high quality and reduced redundancy.
  • Made use of SQL queries and MS Excel to perform a detailed analysis on the existing human resource data.
  • Focused on creating database objects like tables, views, materialized views and functions using PL/SQL.
  • Worked on all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults and Check, Unique, etc.)
  • Used DDL and DML commands to write triggers , stored procedures and data manipulation.
  • Developed data maps for retrieval of information from existing account systems.
  • 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.
  • Assisted in validating XML documents, SOAP services, client side and server-side validations.
  • Worked with the development team to verify that business needs are fulfilled and produced within the Triple Constraints.
  • Assisted the QA team to design Test Plan and Test Cases for the User Acceptance (UAT) and Regression Testing.
  • Supported development of UAT cycle test scripts, Review User Acceptance Test Plan (UATP) and attend walkthroughs.
  • Conducted UAT with clients to get UAT approval on all applications delivered with the correct client configuration.
  • Engaged in Functional, Smoke, Usability, Performance and Integration testing.

Environment: Waterfall, MS Office, SQL, UAT Testing, HP QC, MS Visio

Confidential

Jr. Business Analyst

Key Responsibilities:

  • Conducted JAD Sessions with the SMEs and managers to understand the business processes and functional details.
  • Worked as a liaison for business and technical teams to communicate requirement prioritization.
  • Performed GAP and Impact Analysis to identify solutions for key business issues and define project goals.
  • Utilized MS Project to create Work Breakdown Structures (WBS), prioritize tasks and track progress of the project.
  • Documented the gathered business requirements into a detailed Business Requirements Document (BRD).
  • Validated BRD against business processes to ensure that requirements accurately meet the needs of stakeholders.
  • Prioritized deliverables, identified gaps, tracked defects, defined system requirements, created artifacts for testing and development. Documented the Traceability Matrix for tracing Test Cases and requirements related to them.
  • Translated Business Requirements into functional and non-functional requirements using industry standard documentation processes like Data Flow (DFDs) and UML Diagrams (Use Case, Sequence and Activities Diagrams).
  • Carried out ETL processing of the data from different sources using transformations and control flow tasks.
  • Conducted Requirement Walkthroughs with the development and test teams before the development and testing phases started respectively, to ensure that the requirements are accurately understood.
  • Assisted the development team in creating Stored Procedures and triggers as per needs and deploying it.
  • Assisted the QA team in creating the test plan, test conditions, and test cases by conducting knowledge transfer.
  • Performed Manual Tests according to Test Plan to identify defects for web based application.
  • Attended Change Control Process Meetings with Lead QA and PM to document changes and implemented those changes to corresponding test plans.
  • Carried out regression testing to ensure builds were working efficiently after defect alterations had been made
  • Created User Acceptance Testing (UAT) plans with several test scenarios to ensure that the proposed features are functioning correctly, and changes suggested by the users were incorporated into the application.
  • Tableau was used as a data visualization tool to communicate information clearly and efficiently via the statistical graphics, plots, information graphics, tables, and charts selected throughout the project.

Environment: Waterfall Methodology, Power designer, MS Visio, MS Project, Justin Mind, My SQL, Java, HTML, HPQC.

Confidential

Jr. SQL Developer

Key Responsibilities:

  • Involved in creating logical and physical models using Erwin.
  • Wrote DDL and DML queries to implement data loads, data migrations and validations.
  • Migrated data from heterogeneous data sources and legacy system to centralized SQL Server databases, which involved cleansing, data mapping and data conversion.
  • Implemented and tested Referential Integrity rules and regulations through constraints, triggers and views.
  • Created complex Stored Procedures, Functions, Indexes, Tables, Views, Triggers and SQL joins for application.
  • Performed Query Optimization for improving the performance of the data warehouse.
  • Converted various SQL statements into stored procedures thereby reducing the number of database accesses.
  • Created Views for specific columns on a table to maintain privacy of a customer data.
  • Created logins and users with specific roles and permissions as per security rules.
  • Identified and automated repetitive tasks or processes to save time.
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes
  • Analyzed reports and fixed bugs in stored procedures on the ongoing operations, to resolve business problems.
  • As per client requirements generate the reports in the form of Table and Matrix.

Environment: Waterfall, Oracle 8i, PL/SQL, SQL*Plus, SQL*Loader, Erwin, UML, Payment Processing, SQL Server, Rational Requisite Pro, Rational Rose, MS Office, MS Project, SharePoint 2007, HTML, CSS.

Hire Now