We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

3.00/5 (Submit Your Rating)

Salt Lake City, UT

OBJECTIVE

  • Ebullient, meticulous, pragmatic, and a goal - oriented Business systems analyst professional with teh experience of 8+ years adhering coherently in teh various Digital Marketing, Retail, E-commerce, and Supply chain domains 0and recognized for taking on major initiatives, strategy, and course correction and well versed to rapidly changing environments, focused on achieving real world results with business & IT alignment using various waterfall, agile and SAfe developmental methodologies and relevant tools.

SUMMARY

  • Experience in digital sales management and proficient in Content, Social-Media, and personalized Marketing Strategies. Possess strong analytical, time management, conflict management team leadership abilities and
  • Certified in SCRUM Master accreditation certification issued by International Scrum Institute (ISI)
  • Extensive background in eCommerce, (SAP hybris, Magento), Digital Strategy, CMS (content management systems), CRM (customer relationship management), Data Management and related applications /technologies utilized by teh e-Commerce, Media, Manufacturing, and entertainment services industry.
  • Excels in teh bringing and implementing changes with teh structure of working methodology incorporating preparing comprehensive documents such as change management document, change approval document, etc.
  • Proficient in Business Requirement gathering, Business Process flow, Business Process Modelling (BPM), Process Redesign, Business Process Reengineering, Documenting Enhancement Requests, Automatic and manual testing, etc. with a keen awareness of developers and end - users needs and able to deal with user groups at all levels.
  • Expedited work in Marketing Automation, Content Management, Customer Engagement, SEO, SEM, PPC, CPI-CPM Campaigns, Lead Generation, Sales Insights, Revenue Cycle Analytics & Social Media Marketing.
  • A thorough understanding of teh variousSDLC methodologiesand hands-on experience working inAgile-Scrum, Waterfall/Scrum/Kanba Hybrid, Safe 4.6 (Scaled Agile Framework), andwith an in-depth noledge of other industry-standard methodologies such as Spiral Model and Extreme programming (XP).
  • Possess core competencies and leadership skills, including communication, decision making, problem-solving, empirical analysis, critical thinking, documentation, visual modelling, facilitation, elicitation, stakeholder analysis, issue management, risk management, conflict resolution, team building, staff, and resource management.
  • Effective at liaising with consumers, and stakeholders and at adopting best practices adhering to various regulations in E-Commerce and Digital Marketing compliances such as General data protection regulation (GDPR), Children online privacy protection act (COPPA) and US Securities and exchange commission (SEC) thoroughly.
  • Adept at coordinating with Stakeholders, Subject Matter Experts (S.M.E.s), and End Users to understand, analyse, and gain consensus of requirements through techniques suchPrototyping, Brainstorming, Interviews, Focus Groups, Joint Application Design (JAD) and Joint Application Review (JAR) sessions.
  • Experience in preparing/assisting Project Deliverables such asProject Charter, Work Breakdown Structure (WBS), Statement of Work (SOW), Business Case, Business Requirement Document (BRD), System Requirement Specification (SRS), Functional Specifications Document (FSD), Requirement Traceability Matrix (RTM), Data Mapping Document, Dependency Matrix, Test Scenarios, Test CasesandTest Reports.
  • Expertise in performing As-Is/To-Be G.A.P. Analysis, SWOT Analysis, Cost-Benefit Analysis, Risk Analysis, Feasibility Study, Fishbone Analysis, Tree Hypothesis, Benchmarking, and Root-Cause Analysis.
  • Proficient in prototyping wireframes, mock-ups, and illustrating diagrams such asUnified Modelling Language (UML) Use Case, Activity, State, Sequence, Flowcharts using tools such as Lucid Charts and MS Visio.
  • Adept atcreating User Stories using JIRAandslicing Themes, Features, and Epicsin Horizontal/Vertical slices based on Business Value and made sure dat teh user stories follow teh INVEST Criteria thoroughly.
  • Assisted teh Product Owner is defining MVP (Minimum Viable product), MRF (Minimum Releasable Features) and MMF (Minimum marketable features) in various Scrum agile projects in teh initial phases.
  • Participated inSprint Ceremonies(Backlog Grooming, Sprint Planning, Sprint Review & Retrospective) & efficient in usingprioritizingtechniques likeMoscow, KANO, business value, technical risk-based methodologies.
  • Mentored teh team in habituating to followbest practicessuch as Test-driven development (TDD), Behavioural Test-Driven Development (BTDD), UAT Test driven development in teh different project phases.
  • Knowledge ofData Warehouse architectures- Hub and spoke, federated, independent, centralized, along with teh understanding of Data Marts. Knowledge of different schemas- Star/Snowflake and Galaxy Schemas.
  • Strong understanding of Data mapping documentation incorporating steps such as Source data analysis, target data analysis, GAP analysis and in writing various transformations rules using different ports and mathematical operators and prepared Data Mapping Specifications document in teh form of spreadsheets.
  • Hands on experience in data migration projects and possess clear understanding of different phases involved in data migration such as- source system exploration, migration design, ER Diagrams- Conceptual and Logical, migration build, execution, transition, and rolling into production stages.
  • Comprehensive noledge about different types of OLAP Cubes such as MOLAP, ROLAP, HOLAP and performed different techniques such as- Roll-up, drill-down, slicing, dicing, and pivoting in OLAP Cubes in warehousing jobs.
  • Contributed teh team in carrying ETL (Extract Load and transformation) process using tools such as- Informatica power centre and performed roles such as source system exploration, data assessment and resolved data redundancy and other issues related to cleansing and consistency.
  • Have experience in Adobe data Analytics and intensive Excel experience in formulating documents dat supports data driven decision making by converting various insights into instrumental actionable steps.
  • Ability to work and analyse teh Point of Sale (POS) systems and retail store layouts with ease providing guidance to teh decision support system to teh organization through data driven approach and best practices.
  • Proficient in identifying & documenting REST APIs using Swagger and in performing API testing using Ka talon Studio to perform various API Testing such as Load testing, functionality testing, penetration testing, performance, and security testing to ensure smooth communication pathway for API Systems.
  • Adept in retrieving and analysing complex data usingSQL queries, including complex joins, unions, grouping, aggregation, nested subqueries, triggers & stored procedures in resolving teh data redundancy issues.
  • Experienced in supervisingBlack-box Testing, System Testing, and writing test plan documents, writing test cases and scenarios for User Acceptance Testing (UAT) and working in with developers while Unit testing.
  • Performed analysis using various Business Intelligence (BI)practices and experience increating interactive and analyticaldashboards usingTableau for various external stakeholders and internal team members.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile Scrum, Waterfall-Scrum Hybrid, SAFe, Kanban, Scrum ban, RUP, XP

Modelling Tools: Lucid Chart, Balsamiq, MS Visio, Wireframe Pro

Collaboration Tools: MS SharePoint, Confluence

ERP & CRM: SAP, Salesforce CRM, HubSpot CRM. Magento E-commerce

Requirement Management: JIRA, HP ALM, Confluence, MS Project, MS Office 365 (MS Word, MS Excel, MS-PowerPoint, MS Access) MS SharePoint, MS Outlook

ETL Tools: Informatica Power Center 8.x/9.x

Testing Tools: HP QC/ALM

Databases: MYSQL, Microsoft SQL T-SQL, PL/SQL

Data Warehousing: ER Modelling, Dimension Modelling, Data Marts, OLTP, OLAP, Data Profiling, Data Mapping, Data Mining, Data Validation, Star schema, Snowflake Schema

Reporting Tools: Tableau, Power BI, MS office suite

Analytical Tools: SPSS, Tableau, Google Analytics, Power BI

Cloud-Based Tools: Salesforce DMP, Informatica cloud

Web Services: XML, JSON, Swagger tool, Postman, Magento

PROFESSIONAL EXPERIENCE

Confidential, Salt Lake City, UT

Sr. Business Systems Analyst

Responsibilities:

  • Responsible for overall coordination of Magento implementation project from inception, managed teh design and implementation, product management and development of teh Magento at teh enterprise.
  • Performed a GAP Analysis to analyse teh 'As-IS' process to conclude teh 'To-Be' system and documented teh results in an Analysis Report and obtained signoffs and required approval from teh higher level.
  • Involved as an analyst in program backlog refinement and prep for Program Increment (PI) planning and played a significant role in teh planning events in cadence with teh team and stipulated time.
  • Performed tasks incorporating story definition, providing teh clarifications necessary to assist teh team with their story estimates and sequencing as per teh team structure, assigned roles and responsibilities.
  • Maintained team backlog by building, editing and persistently checking teh user stories, defects sand enablers at teh team level to make sure dat those defects won’t hamper release schedule and tasks.
  • Validated dat teh story meets acceptance criteria, dat it TEMPhas teh appropriate, persistent acceptance tests, and dat it otherwise complies with its Definition of Done (DoD) and other boundaries.
  • Reviewed and reprioritized teh backlog as part of teh prep work for Iteration Planning, including coordination of dependencies with other POs.
  • During teh iteration planning event, communicated teh story detail and priorities and ensured teh team aligns and agrees on a final iteration plan
  • Worked across teams to define and implement improvement stories dat will increase teh velocity and quality of teh program at teh value stream level of teh enterprise
  • Created prototypes, implemented visual changes with high-fidelity and low-fidelity mock-ups and wireframes using teh Balsamiq tool and manifested in front of teh decision board to assess teh plausibility of teh entire migration project based on teh obtained feedbacks and suggestions from teh board.
  • Conducted data mapping workshops with business data owners and functional teams to perform data mapping of data migration objects and checked teh data migration routes are working correctly.
  • Created and reviewed data mapping documents with teh business data owners based on teh information gatheird in teh data mapping workshops to make sure all teh data mapping rules were captured correctly
  • Created teh functional and technical specifications for teh data migration programs and documented same.
  • Configured settings in teh A/P & A/R, such as house bank, bank accounts, ranking order, PO related vendor invoicing, manual outgoing/incoming payments, automatic payment program, payment media, terms of payment, check lots, void reasons, and running/editing dunning proposal.
  • Conducted parallel tests to ensure wat migration system would be required- zero downtime migration or complete decommissioning of teh old system so dat routine could be non and developed successfully.
  • Assisted teh team and played a key role in carrying out teh entire ETL Process (Extract, transform and loading) using Informatica by using teh Admin Console and performed operations such as data dumping, profiling and matching, creating migration routines and making sure dat ports of Informatica are appropriate with data.
  • Created Test Plans, Test Cases, Test Scenarios to assess teh vulnerabilities of Magento and to understand limitations.

Environment: SAFe, Magento E-commerce, JIRA 7.1.9, Confluence, REST API, MS Office Suite 2016, Tableau10.0, SPSS Statistics, JavaScript, HTML, Informatica PowerCenter

Confidential, Beaverton, OR

Sr. Business System Analyst

Responsibilities:

  • Monitored a thorough analysis of an existing relational database of teh company using SQL Queries to identify missing data and values and checked teh quality of teh existing database by using different queries techniques.
  • Daily engagement with teh development team as a member of teh Scrum team to design, test and deliver features and defect fixes and make sure everything aligns with teh business goals precisely and coherently.
  • Responsible for providing leadership for all SAP integration activities related to Finance and Supply Chain Management Systems integration project and made sure teh integration process is smoother and working fine.
  • Produced various Conceptual Models, Logical Models and systems diagrams and helped in defining various keys, attributes, and dimensions.
  • Worked in Migration design by defining technical architecture by manifesting Snowflake Schemas and prepared timelines and seek out other concerns of approvals from teh approval board (Governing Council).
  • Created transformation logics and performed data mapping from source and target system and performed data profiling, data cleansing, setting teh data connection and data integration of Salesforce.
  • Wrote user stories based on based on categories incorporated under data migration: Data Disclosure stories, data presentation stories, data augmentation stories, data validation stories and data configuration stories.
  • Tested multiple set of data and multiple categories in parallel and ensured dat transformations and cleansing routines are working properly.
  • Participated in our strategic Digital Marketing team meetings to help coordinate initiatives to improve our processes
  • Managed promotional website campaigns and strategic enhancements
  • Worked with QA team to write test cases and helped in UAT to test teh front end of teh system and documented bugs/errors if any, in teh Test Analysis Report.
  • Generated Business intelligence report for senior management and created dashboards and data visualization reports using teh Hootsuite reporting tool.

Environment: Agile-Scrum, .Net, Katalon Studio, Salesforce CRM, JIRA 7.1.9, Confluence, Balsamiq, Qualtrics XM, Apexdataloader, REST API, MS Office Suite 2016, SWAGGER, Tableau, SAP ERP, Zendesk CRM.

Confidential, Cincinnati, OH

Business Systems Analyst

Responsibilities:

  • Responsible for creating and reviewing business requirements, functional specifications documentation and BRD.
  • Conducted workflow, process diagram, and gap analyses to derive requirements for existing systems enhancements.
  • Responsible for identifying and documenting business rules.
  • Created detailed Use Cases and wrote cases required for conducting (UAT) User Acceptance Testing.
  • Created conceptual and logical models of teh data warehouse and mapped entities with ER diagrams and documented keys to allow for easy reference during development.
  • Documented source & target systems and profiled extracted data to comply with target system architecture.
  • Aided developers with teh design of migration plans and migration execution to not effect business actions and processes.
  • Mapped new system with Informatica PowerCenter to ensure data from teh data warehouse smoothly operate as per teh business logic while incorporating information ported from teh current database.
  • Documented all ETL transformations and mappings performed while establishing a data warehouse.
  • Involved in scrum ceremonies (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective.)
  • Developed teh test plan, test conditions, and test cases to be used in testing based on business requirements, technical specifications, and product noledge.
  • Used SQL scripts/queries extensively for data verification at teh backend as per teh requirements of teh mapping document.
  • Used Tableau to create customized dashboards, showing reports dat satisfied business need.

Environment: Waterfall- Scrum, Informatica PowerCenter, MS Project, MS Office Suite, MS PowerPoint, Tableau, Oracle.

Confidential

Business System Analyst

Responsibilities:

  • Identified key stakeholders and gatheird functional and non - functional requirements associated with Store Management, Marketing, Inventory Management, Potential Stores, etc. through interviews, document analysis, and JAD sessions
  • Performed AS-IS and TO-BE analysis to identify a gap tan existing Store Management System and layout, to how it can be constantly updated into teh application
  • Worked closely with teh Design/UI team in converting teh functional requirements into technical specifications like Prototypes, Graphical User Interface (GUI) and User Interface (UI) mock-ups using teh Balsamiq tool
  • Documented User Stories and Acceptance Criteria for teh PSPI (Potentially Shippable Product Increment)
  • Worked with teh Mobile application team to create a wireframe and Mock-up of teh website to appear teh same on teh Mobile platform.
  • Created Workflow for mobile application platforms to update teh product catalogue and user profiles. Captured customer engagement through Mobile application and desktop application.
  • Participated in Scrum ceremonies and assisted Product Owner in converting requirements into User stories, writing acceptance criteria, Definition of Done (DoD) and prioritizing them in teh Product Backlog using JIRA.
  • Performed retrieval queries in SQL & stored procedures using SELECT & JOIN for drilldowns to pull data while being actively involved in reading data from varied file types, created standard and ad-hoc reports using SQL, generating delimited files and SQL script to load data into SQL tables. Mainly focused on retrieve data to understand teh data.

Environment: Agile Scrum, Balsamiq, Power BI, Jira 7.1.9, Office 365, REST.

Confidential

Business Analyst

Responsibilities:

  • Actively involved in requirement gathering and requirement management. Analysed requirements, assigned attributes and segregated them into high-level and low-level use cases using Rational Requisite Pro.
  • Conducted JAD. Sessions with different stakeholders and development teams, when necessary, to elicit use cases.
  • Developed requirement traceability matrix documents.
  • Created complete life cycle documentation from product requirements in teh developmental stage to functional specifications for teh completed modules of application components.
  • Created Use-Cases, Wireframes, and State Diagrams to demonstrate software architecture and interaction of system components before prototyping. Used Rational Rose, Requisite-Pro for requirement traceability.
  • Worked in managing change requests by conducting impact evaluations of teh incorporated changes and re-baselined teh input documents and seek approval from teh Change request board (CRB).
  • Prepared documents to conduct professional meetings for teh client, team members and other stakeholders and manifested information to stakeholders to evaluate teh developmental effort of teh entire team.
  • Participated in enhancement meetings to make teh product more effective in real-time. Worked with developers and QAs to clarify issues.
  • Extensively used Excel VLOOKUP's, Pivot tables, Macros, Graphs, and advanced formulaefor generatingAd-hoc reportsforthe Supply chain.

Environment: Waterfall, UML, SQL Server, MS Office, MS Project, DB2, SharePoint 2007, JIRA, QC, HTML, CSS3, Node.js, Rational Rose.

Confidential

Business Analyst

Responsibilities:

  • Interviewed SMEs and stakeholders to understand application requirements better.
  • Conducted Document Analysis to gather business requirements from stakeholders, business users, and external users.
  • Included features like expenses by category and had options to view expense graphs to help account holders manage their finances.
  • Supporting functional product enhancement through requirement gathering, assisting in teh writing of business specifications.
  • Implemented teh entire SDLC (Software development lifecycle) methodology of application development with its various workflows and activities.
  • Documented high-level and detailed Use Cases to include all teh functionalities of teh new system.
  • Followed teh UML methodology to Create UML Diagrams, including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, and Data Flow Diagrams to understand teh development team.
  • Assisted in User Acceptance Testing (UAT) to test teh usability of teh application.
  • Interacted with other teams through walkthroughs, teleconferences, meetings, etc., to resolve various issues.
  • Assisted teh QA team in performing Functional, Integration, System, and Regression testing.

Environment: RUP, UML, SQL, MS-Office Suite (Word, PowerPoint, Access, Excel, Outlook) MS Visio, HP Quality Centre.

Confidential

Tester

Responsibilities:

  • Documented teh raw excel data files and list of stores and inventories and prioritized wat was necessary to transfer to teh existing ERP Implementation system.
  • Regular activities included upgrading teh application as per requirement, work with teh vendor to troubleshoot an issue with teh product, on-call support, maintaining teh application dat provides manager and agent software upgrade, applying software fixes.
  • Eliciting feedback from teh backend bank managers in terms of using SAP Supply chain features and gatheird reports on ease of procuring funds in teh bank.
  • Maintaining liaison with fund suppliers and transportation in charge and track teh efficacy of teh money transfer process.
  • Conducted feasibility of transaction process and evaluated several other alternatives about efficient fund transfer in teh faster way.

Environment: Waterfall, SAP ERP Module, MS Office Suite, MS Projects

We'd love your feedback!