Sr. Business System Analyst Resume
5.00/5 (Submit Your Rating)
Cambridge, MA
SUMMARY
- To align my professional Business Analysis skills and experience with a progressive Organization wherein the application of my functional and analytical skills renders a significant contribution to the company’s success.
- IT professional with over 4 years of global experience as a Business System Analyst performing Techno - functional roles across various domains like Digital Marketing, E-Commerce and Retail domain in various SDLC methodologies like Waterfall, Scrum, Kanban and a Water-Scrum-Fall hybrid.
- Worked with various stakeholders including business users, designers, developers and QA Analyst regarding Systems and Application development projects, process improvement and streamlining process including Object-Oriented design, requirements gathering and extensive workflow management.
- Possess In-depth knowledge in Contact data platform, Retail Applications, Customer Relationship Management, Ecommerce platforms and digital marketing strategies.
- Expert in performing GAP and Risk analysis, Cost - Benefit analysis and Effort Estimation.
- Planned, Scheduled and Monitored the project along with the Project Manager and strongly experienced in requirement elicitation techniques like Brainstorming, JAD sessions, Job shadowing. etc.,
- Experience in creating a Work Breakdown Structure and Project charter document.
- Created and maintained artifacts such as Business Requirement Document (BRD), Functional Requirements Document (FRD) and System Requirements Specification (SRS).
- Created and documented Mockup screens, Wireframes and prototypes to visualize Graphical User Interface (GUI) and provide Technical/Functional Specifications using MS Visio and Balsamiq.
- Worked with front-end and middleware technologies including HTML, CSS, JavaScript, jQuery, AJAX and UI MVC to create responsive websites, ability to interact with development team to achieve desired results.
- Supported the development team to pursue best practices like - Version Control, better exceptions handling, Unit testing, Continuous Integration and Continuous Deployment and error/exception logging.
- Worked with SMEs’ to understand Key Performance Indicators (KPIs’) and Service Level Agreements (SLA) to enhance application performance through data exchange between external Web Services.
- Skillful at designing and implementing SQL queries using joins (inner joins, outer joins), unions, select within select, order by, group by and aggregate functions to extract data from different data sources.
- Adept in writing and executing Create Read Update Delete (CRUD) operations and complex SQL queries including complex joins, unions, grouping, aggregation, triggers, stored procedures, etc
- Proficient in data modeling with experience in creating Conceptual diagrams and Logical diagrams and UML diagrams such as Activity diagrams, Sequence diagrams, Business Process Models, Use-case diagrams, data-flow diagrams, Workflow Diagrams using MS Visio, Lucid chart and Smart Draw.
- Detailed understanding on Data integration, Data Migration, Data table structures, Data Analysis.
- Experience in developing test plans, building Test Conditions and Test Cases, creating test data, analyzing bugs, and interacting with development team members to fix errors.
- Strong testing experience in Functional Testing, Smoke Testing, Regression Testing, Progression Testing and User Acceptance Testing (UAT) in both manual and automated testing environments.
- Thorough understanding of Business Intelligence (BI) and experience in creating interactive, analytical dashboards and reports like canned and ADHOC using Tableau.
- Adept in team management, conflict management & resolution and stakeholder negotiations.
- Excellent communication skills, fast learner along with an ability to adapt quickly to any domain and environment. Self-motivated, Dependable, Organized, Competent Leadership and Time-management skills.
PROFESSIONAL EXPERIENCE:
Confidential, Cambridge, MA
Sr. Business System Analyst
Responsibilities:
- Elicit, gather, document, and translate business requirements into technical specifications
- Engaged and worked directly with operations teams to document business process design
- Been a Liaison between business and technical teams to provide solutions that meet user needs
- Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions.
- Performed Feasibility study, declaring AS-IS and TO-BE systems and determine the complexity levels of the system and prioritize the requirements based on these reports along with the project manager.
- Used Confluence as Content management system for maintaining the high-level documents like Project charter document, Business Requirements and Data mapping documents.
- Provide consultation to users and lead cross-functional teams to address business issues.
- Modeled high level design of the system through Use Case Diagrams and Sequence Diagrams, activity diagram, business process models using lucid charts with the help of MS Visio.
- Worked closely with the UI team in describing the requirements and to develop mockups and wireframes.
- Created, maintained and follow information technology processes and procedures
- Stayed up-to-date on the latest process and IT advancements to automate and modernize
- Monitored deliverables and ensuring timely completion of projects.
Confidential, New Jersey
Sr. Business System Analyst
Responsibilities:
- Maintained monthly online reporting metrics through Google Analytics and applies learnings to suggest and implement improvements for online user experience to benefit external customers .
- Measured and reported performance of all digital marketing campaigns and assess against goals like Return on Investment - ROI and Key Performance Indicators - KPI.
- Utilized Facebook and Instagram Ads Manager to develop insights, tracked and analyzed the website and social media traffic and action items intended to increase our revenues month-over-month MoM.
- Conducted focus group meetings, Joint Application Development (JAD) sessions and requirements workshops with stakeholders to acquire requirements and collaborated with SME’s for system pre-analysis.
- Consulted the business users and SMEs, aided to create and prioritize Product and Sprint Backlogs
- Extensively used few AWS services like Cloud Config, Cloud Trial and Cloud Trusted Advisor
- Actively monitored all the resources, applications and track metrics using AWS CloudWatch.
- Well versed in writing SQL queries in order to do data manipulation for analysis and reporting.
- Created conceptual and logical data models using Oracle SQL Developer Data Modeler.
- Used SQL operations like VIEW, SORT, Filter, LOOKUP and many more.
- Used ETL transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator .
- Used Bulk API, SQS Receive Message API, REST API for the applications in the organization’s private cloud.
- Maintained a defect backlog, prioritized it against the backlog items and tracked them down using JIRA.
- Participated in writing test cases, test strategies, test plans, test reports, test scenarios and requirement traceability matrix (RTM) that satisfy the user’s functional, performance and usability requirements.
- Participated in System testing, Smoke testing, Regression testing, White box and Black box testing and User Acceptance Tests (UAT) using Selenium.
- Developed templates and layouts for reports , dashboards and independently demonstrate solutions and reports to clients and users via tableau.
Confidential
Business Analyst / Scrum Master
Responsibilities:
- Implemented digital strategies including PPC, SEO, and SEM, managing a digital marketing spend to increase site traffic by 15% on average and increase ecommerce sales by 50%.
- Delivered monthly and yearly audit reporting which provided MoM and YoY metrics, trends and provides client with insights needed to make better business and marketing decisions.
- Managed all forms of marketing channels; Email, SEM, SEO, Display, Social, Analytics and creative such as banner ads, landing pages & website design.
- Worked out across several marketing platforms including digital, print, & mobile platforms.
- Defined the scope of the project and created high level BRD with the senior project manager.
- Established a comprehensive brand guide and digital strategy guidelines for all the three given brands.
- Manage all internal communication between teams and team members through status reports, project schedules and holding weekly meetings
- Worked with Project Manager on various Project Management activities like keeping track of Project Status, deadlines, deliverables and Risk management.
- Analyzed client requirements using document and workflow analysis.
- Worked with the UI team in designing and implementing all aspects of the convenience store’s new customer loyalty program, including program terms, traditional and digital marketing assets, generating 10,000+ enrollees in the program’s first six months.
- Created Test cases and helped the team in performing regression tests.
- Created User Acceptance Testing manuals for business users.