We provide IT Staff Augmentation Services!

Senior Business Systems Analyst Resume

Santa Clara, CA

PROFESSIONAL SUMMARY:

  • Over 8 years of experience in all aspects of the software development lifecycle process including design, development, Automation Testing, project management, documentation and support of software solutions for business needs on various database platforms across and Banking domains.
  • Thorough knowledge of SQL, Data Warehouse ETL, Python, Big - Data tools (Hadoop, HBase, Hive, Pig, Swoop, Flume, and Map/ Reduce.
  • Interacted with the Subject Matter Experts (SMEs) and stakeholders to get a better understanding of client’s business processes and documented and gathered the requirements for business productivity.
  • Excellent team player worked in various team sizes performing cross-functional roles.
  • Strong understanding of various banking compliances & acts that includes The Global and National Commerce Act, Bank Secrecy Act(BSA), Sarbanes - Oxley Act and PCI -DSS Compliance.
  • Experienced in entire SDLC process, requirement analysis testing and maintenance of projects with hands-on experience working in Waterfall, Spiral, Extreme programming, and Scrum framework.
  • Created Sequence Diagram, use case diagrams, Activity Diagrams, Class Diagrams using Ms Visio.
  • Experienced in interacting and communicating with business users to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), Functional Requirement Document (FRD) and Software Requirement Specification (SRS) across the deliverables of project .
  • Experienced in Business Analysis, SWOT Analysis, Gap Analysis, Risk Analysis, Disaster Recovery Planning, Testing and Project Planning, ensuring maximum productivity of the project.
  • Participated in requirement gathering, analysis and structuring of Business Intelligence objects reports based on user requirements and conducted meetings every month for a group of Directors to help them understand how their units are doing and assisted them to remove any blockers.
  • Experience in manual testing and automated testing using different tools like Selenium (Web Driver) using python. Knowledge and familiarity with different Selenium automation frameworks.
  • Experience in designing stunning visualizations using tableau software that includes Bar charts/Tree Maps/Geographical maps and publishing and presenting dashboards on web and desktop platforms.
  • Knowledge of Automated Web Services using SoapUI, REST with knowledge of WSDL, RESTful eclipse. Assisted in Testing of open web API, B2B API, Enterprise API and Product Integration API
  • Worked on developing the Implementation plan for the entire Enterprise Integration Team supporting multiple enterprise-wide applications during Conversion time-period and supported all the Enterprise, applications for a smooth transition from the legacy system to the new system.
  • Proficient in the understanding Execution plan, used SQL Server Profiler to trace the slow running queries and performed SQL Queries optimization for improved performance and availability.
  • Having knowledge of languages like Python, HTML, and JavaScript with familiarity in Java and C.
  • Excellent Technical writing skills and customer interfacing skills. Exceptional focus and coordination skills with several IT groups. Proven ability to develop and manage project schedules and known for working well with the cross-functional team to achieve on-time project completion.
  • Validated that data mart that contained the necessary data from the data warehouse in federated architecture and that reports created from data marts were correct adhering to the business process.
  • Extracted data from different data sources - Oracle and Excel spreadsheets, transformed and mapped non-standard data to standard codes for data integrity and loaded the target Oracle database
  • Experience in Data Modelling by using techniques like ER Modelling, Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables, and Physical and Logical data modeling
  • Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, triggers, cursors, collections, Ref cursor, System reference cursor, indexes and aggregate functions.

TECHNICAL SKILLS:

Operating Systems: DOS, Unix, win 8, win 10, mac os, ubuntu

Languages: Python, JavaScript, HTML, CSS, XML/XSL

Database: MYSQL, SQL Server, Oracle, MS Access, Hive

Reporting/Data Mining: Tableau, R, SAS Enterprise Miner

Testing/Tracking Tools: Selenium IDE, Selenium Web driver, Cucumber, HP ALM, Zephyr, JIRA

Application Server: BEA WebLogic 6.1/8.1, IBM WebSphere, Apache Tomcat Portals (DAS) environment

Methodologies/Framework: Agile, Waterfall, Scrum, XP

Microsoft Products: Microsoft Office Suite, MS VISIO, Microsoft Project Plan, Project Server, Microsoft SharePoint

Mailing Systems: Lotus Notes, MS Outlook

Quality Management: Quality Center, Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Senior Business Systems Analyst

Responsibilities:

  • Interacted with Business Users, IT Leads, Developers and System Architects to gather and analyze business requirements and translated requirements into functional and technical design specifications and ensured that it is understood by the Technical and functional teams in the project.
  • Created targeted questionnaires for SME to gather requirements and understand the business process goal from them, Gathered the project requirements from the stakeholders by facilitating Joint Application Design, JAR, Interview sessions, Focus groups, and other elicitation techniques
  • Performed review of the business process, involved in GAP Analysis Requirements Analysis, prepared System Design Documents, Test Plan preparations, and Development of Business Process.
  • Used MS Visio to document the AS-IS business process and TO BE process and create workflows.
  • Ensured that all the products and services adhered to the e-sign/The Global and E-commerce Act and BSA act that required performing continuous AML checks to track money laundering activities.
  • Effectively used Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Dynamic SQL, Records, PL/SQL Tables, Oracle-supplied packages, Ref Cursor, Aggregate Functions, Query Rewrite and Transportable tablespaces in Oracle PL/SQL
  • Analyzed the features that are loaded and split them into user stories using the INVEST criteria and worked with the product owner to prioritize them by using Moscow Techniques and KANO model.
  • Facilitated and performed Sanity/Smoke Testing, Unit Testing, Integration Testing, System Testing, user acceptance testing (UAT) and wrote feature files and test scenarios using cucumber.
  • Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Pivot Transformation, and Slowly/Rapidly Changing Dimensions.
  • Extensively used Selenium web driver with python for automating test scripts in keyword driven framework, took Screenshot for Capturing Failed test cases, select for selecting multiple values from list, Action for various key and mouse event, with different Locators (XPath, CSS, id, Link text)
  • Responsible for executing Selenium test scripts on different browsers and checked for compatibility
  • Involved in migrating huge data from different sources including SQL Server into Oracle database.
  • Collect performance data using standard tools such as SQL Profiler. Backup and restore databases, performance tuning, code promotion, grant user access by determining the ACID properties.

Environment: and Tools - Agile, Jira, Hadoop, Selenium, Python, Ms. Office Suite, MySQL, Tableau, Ms SharePoint, Ms. Visio, Pig/Hive, Apache Sqoop, Apache Flume, SAS Enterprise Miner, XML/XSL

Confidential, Boston, MA

Senior Business Analyst

Responsibilities:

  • Monitored systems and processes to ensure they meet or exceed established standards and service level agreements (SLAs) for availability, continuity, performance, and security of the systems.
  • Identified and assisted with changes to systems and processes and procedures by working with internal and vendor resources through the change process, ensuring that changes meet stated expectations, documented all the required change activities and updated system documentation.
  • Conducted functional walkthroughs, Beta, and alpha testing under User Acceptance Testing (UAT) sessions, ensured the entry and exit criteria and supervised the development of User Manuals.
  • Monitored and analyzed exception reports for suspicious activities and ensured timely AML checks.
  • Monitored project progression and communicate pertinent information to stakeholders. Identified and mitigated team risks/blockers and impediments (Blocking Issues, Critical Defects, errors) daily.
  • Promoted to serve as a liaison between risk, portfolio management, marketing teams and information technology, providing them with reports and data to effectively assess fund risk.
  • Responsible for development of Test Scenarios, Test Cases, Test Scripts, Requirement Traceability Matrix and ensuring the traceability of Business, Functional and System Requirements in Test Plans
  • Used web-debugging tools like Firebug and Fire Path to locate elements by class, link, name, and id.
  • Responsible for producing business requirements, functional requirements, non-functional requirements, business rules, researching enterprise-wide collaboration and repository solutions
  • Created and modified XML templates using HTML and XML schemas, including CSS style sheets. Converted company documents from Word format to XML & documented it using the swagger tool.
  • Participated in SIT/UAT testing, updated test plans, and tested methodologies, performed GAP analysis, documented bugs, reviewed defects and bug fixes, and tracked defects with JIRA.
  • Designed and developed various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Geographic Maps
  • Participate in designing overall conceptual, logical & physical data warehouse and data mart model.
  • Collect performance data using standard tools such as SQL Profiler. Backup and restore databases, performance tuning, code promotion, grant user access by determining the ACID properties.

Environment: and Tools - UML, Jira, Hadoop, Selenium, MS SQL Server, JSP, Python, Ms. Office Suite, Tableau, Ms SharePoint, Ms Visio, Pig/Hive, Apache Sqoop, Apache Flume, XML/XSL, HTML

Confidential, O’Fallon, MO

Senior Business Analyst

Responsibilities:

  • Partnered with business users to understand and document business processes, reporting requirements daily, performed gap analysis, and designed enterprise data warehouse solutions
  • Interacted with the business users, internal and external stakeholders and collected the requirements that are required for solving issues by using various requirement elicitation techniques and surveys.
  • Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of BRD and FRD for tracking purpose.
  • Developed ER Diagrams, Data flow diagrams based on the business requirement by using Ms Visio.
  • Reviewed testing strategy and testing scenarios along with SQL query development to assist as Subject Matter Expert during key phases of test execution cycle, which include System unit testing, Integration Testing, smoke/sanity testing, Quality Assurance, Regression Testing, and Simulation.
  • Facilitated & performed user acceptance testing (UAT) to validate system sanctity & requirements
  • Tested request and response of XML's based web services interfaces using REST API for business.
  • Used Chrome developer tool to identify Elements' by Name, CSS, XPath, and Links on Web Pages.
  • Involved in designing of Keyword-Driven Automated Frameworks using Selenium Web driver.
  • Involved in performance tuning of SQL procedures for execution using Indexing, Oracle Hints, Materialized views, Table Partitioning and also used aggregate and analytical functions extensively.
  • Worked with technical specifications to show the data movement from legacy systems to the DWH.
  • Involved in functionality, End to End, Black Box, Front End, Backend, Regression, and Stress tests.
  • Involved in Data Analysis, Data Mapping to track various data elements used in the different applications from the User Interface through different interfaces to the necessary target databases.
  • Ensured regular database backups and recommend the appropriate recovery models for the production databases as per the database used to bolster both functional and technical needs.

Environment: and Tools - Waterfall-Scrum Hybrid, Jira MS Excel, UNIX, Swagger, Ms Office Suite, MySQL, Tableau, Ms SharePoint, Erwin, Pig/Hive, XML/XSL, HTML/CSS, Gap Analysis, Cucumber

Confidential, Dallas, Texas

Business Analyst/Scrum Master

Responsibilities:

  • Function as a Scrum Master within inter-organizational collaboration and working with multiple-development teams designing UI/UX/accessibility, web management server and the creation and maintenance of mission-critical web-based software applications using Agile and Scrum framework.
  • Improved team velocity by incorporating velocity-driven planning into sprint planning sessions
  • Gathered Functional Requirements and Data Requirements for creating workflows, user interface requirements, User Interface specifications, requirements traceability matrix and Use cases.
  • Facilitate the scrum teams, work with Product Owners to define the product backlog and priorities, and work to implement standards and best practices within the development team and organization
  • Worked closely with various Stakeholders to establish priorities, then filtering to the delivery team.
  • Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, bar chart, heat maps Column Selector, with both global and local Filters).
  • Facilitated JAD/JAR sessions with SME and business users to gather and document requirements.
  • Proofed and tested the finished XML/PDF products. This included creating and executing test scripts, designing use cases, regression, and negative testing scenarios and creating testing matrices.
  • Setup and maintained all aspects of the role and access levels for all new and changing end-users to ensure SOC compliance and acted as a liaison with the software vendor for software enhancements.
  • Identified the key business processes, business logic, requirements and use case scenarios to facilitate the construction of Business Rules Engine (BRE) for system integration and design.

Environment: and Tools - UML, Jira, MS SQL Server, Ms Office Suite, Tableau, Ms SharePoint, Ms Visio, XML/XSL, HTML, Microsoft Project Plan, Project Server, Microsoft SharePoint, Oracle

Confidential

Business Systems Analyst

Responsibilities:

  • Interacted with Business Users, IT Leads, and System Architects to gather and analyze business requirements and translating the requirements into functional and technical design specifications.
  • Gathered Business Requirements, created Functional Requirements Document and Business Requirement and analyzed data/workflows; defined the scope, and performed cost/benefit analysis.
  • Involved in QA processes like Test Case design technique, Test Case Review, Test Case Execution, Requirement Traceability Matrix, Test Execution Report and automated test scripts using selenium.
  • Experience in manual testing and automated testing using different tools like Selenium (Web Driver) using python. Knowledge and familiarity with different Selenium automation frameworks
  • Created aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters using Tableau for various reporting purposes on daily basis.
  • Created and maintained different kinds of objects including tables, views, synonyms, indexes, and sequences using SQL server, extensively used select statements, aggregate and analytical functions.
  • Involved in Data Cleansing, Data Profiling and created profile reports for business users to review.
  • Maintained the Requirements Traceability Matrix (RTM) across the deliverables of a project.
  • Analyzed user requirements, attended change request management (CRM) sessions to create, track and schedule change requests using Rational ClearQuest and updated the change report within time.
  • Ensure that all the product and services that were provided by the organization adhered to PCI-DSS.
  • Used Execution Plan, SQL Profiler, tuning SQL query & Database Engine Tuning Advisor to optimize queries & enhance the performance of databases along with faster & efficient data retrieval

Environment: and Tools - UML, Jira, Swagger, Rational ClearQuest, MS SQL Server, JSP, Python, Ms Office Suite, Tableau, Ms SharePoint, Ms Visio, Pig/Hive, Apache Flume, XML/XSL, HTML

Confidential

Datawarehouse Developer

Responsibilities:

  • Delivery Management of the entire program including preparing feasible Development schedules based on Business priorities, Testing strategy, Project Risk Management and Mitigation strategy.
  • Participated in various meetings and discussed Enhancement and Modification Request issues.
  • Tested Extract, Transform, and Load (ETL) process that loaded data from various sources into the company's Enterprise Data Warehouse (EDW) which contained both historic and recent data.
  • Responsible for extracting large volumes of records from Oracle OLTP system for loading into the repository and also creating various reports to meet the functional and technical needs of business .
  • Defined testing strategy for Data Warehouse projects. Created test plans and reported testing status.
  • Responsible for creating MYSQL queries and functions for Data Validation and Data Conversion.
  • Created indexes on the tables for faster retrieval of the data to enhance entire database performance.
  • Identified and documented different significant architectural aspects and behavior of the system.

Environment: & Tools: SQL, Rational Suite, Visio & MS Project Erwin, MS Office Suite, XML, Excel

Confidential

SQL/Data visualization Analyst

Responsibilities:

  • Design visualization on various reports using reporting tools like Tableau and MS Excel to forecast the growth of various KPI and predict customer behaviors by analyzing the reports on daily basis.
  • Developed solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Line/Area Charts, Bullet Graphs, Bar charts and Histograms
  • Created Geographical Dashboards showing current service subscribers by color that were broken into regions allowing a business user to understand where we have most users vs. least users.
  • Creating and maintaining database objects like Tables, Views, Indexes, Constraints, Sequences, Indexes, Triggers, grants and Synonyms and used both aggregate and analytical functions in SQL.
  • Wrote DML scripts as a part of testing various modules that are being modified, created DDL scripts that are required for the updates on the applications, used joins to retrieve data from multiple tables
  • Build scripts to create tables, views, queries for new enhancement in the application using MYSQL.
  • Designed 2-3 dashboards & custom reports from multiple data sources to display gross total sales.
  • Create new Excel templates to extract all the financial forecast files with the accurate data.
  • Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, clusters, indexes, procedures, triggers, functions, and parameters.

Environment: & Tools - Clear Quest, MS Access, MySQL MS Project, MS Excel, Visio, Siebel

Hire Now