SUMMARY:

• 6+ years of professional experience as Business System Analyst with good understanding, analyzing and documenting Business requirement, Business Process, Data Mapping, Data Modeling, Data Analysis, and Data Warehousing.
• Experience in Financial, Insurance, Healthcare, Banking and Retail domains.
• Experience in Conducting Gap Analysis , Joint Application Development sessions , white board sessions to understand and resolve revolving issues and facilitate the coordination between the business and teams for requirement and data gathering.
• Good understanding of Waterfall, Agile Scrum Software Development Life Cycle (SDLC).
• Skilled in documenting Unified Modeling Language (UML) diagrams like Use Case Diagrams , Activity Diagrams , Sequence Diagrams , Class Diagrams , Context Diagrams , Wireframe Diagram, Data Flow Diagrams , Business Flow Diagrams and Architectural Diagram .
• Experienced in dealing with different data sources ranging from flat files, Excel, Oracle, Teradata, Sybase, and SQL server.
• Adept in designing visualizations using SAS and Tableau, Dashboards, Business Metrics, Operating Statistics and Graphs.
• Expertise in Transform and Load data from data source to SQL Server Analysis Services (SSAS), SSIS, SSMS and SQL Server Reporting Services (SSRS).
• Experienced in facilitating scrum ceremonies (Grooming, Sprint Planning, Daily Stand - Ups, Review, Retrospectives) in Agile Scrum Methodology as Scrum Master.
• Worked closely with Product Owners, coordinating product backlog grooming and story estimation.
• Experience in evaluating User Stories from epics and refining Backlog list with Business owner and Product management.
• Experienced in Functionality Testing , System Testing, and User Acceptance Testing (UAT) in different projects.
• Experienced in reviewing Test Plans, Test Scripts, Test Requirements, Test Cases, Test Reports , and using defect tracking tool to address bugs/issues as required by the project.
• Excellent experience in written and verbal communications skills, ability to interface with all levels of the organization, specific strength in influencing decision makers and managing expectations.

SKILLS SUMMARY:

Project Management: JIRA, Version One, TFS, SharePoint.

Databases & Tools: Soft SQL Server, MS Access, Teradata, TOAD.

Reporting Tools: Cognos, Crystal reports, SSRS, Micro Strategy, Tableau.

ETL tools: DataStage, SQL Server Integration Services (SSIS), Microsoft SSMS, Oracle Data Integrator (ODI), Clover ETL, Informatica-Power Centre.

Languages: C, C++, .Net, Java, HTML, XML, PL/SQL.

Operating System: Window, UNIX, Linux.

Methodologies: Waterfall, Agile-Scrum.

Testing Tools: UFT, HPALM, Selenium.

Other Tools: Blueprint, MS -Office, MS-Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Moorpark, CA

Business System Analyst

Responsibilities:

• Gather and understand requirements work with clients, users, business/product owners & SMEs to understand the goal and be able to get translate and breakdown requests into user stories.
• Designed and developed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams to define the Business Process, analyzed the data entity relationships.
• Participated in all phases of data mining (data collection, data cleaning, developing models, validation, visualization) and performed Gap analysis.
• Extracting and integrating data from multiple databases/system sources to support status reporting and analytical efforts elated to management, services, execution, planning and tracking.
• Develop ad-hoc reports, analysis and manipulating spreadsheets, databases, and data and web analytical tools.
• Provide thought-leadership in measurement and analysis for upgradation. Identify new ideas and opportunities for analytic projects.
• Writing SQL queries to validate data movement between different layers in data warehouse environment.
• Sets, runs and contribute to effective recurring status meetings with the product backlog, sprint planning and release backlog meeting.
• Facilitating for Grooming sessions for creating well developed user stories with user acceptance criteria and mock-up’s if required for developing a good product backlog.
• Negotiating effectively with Product owner on the release priorities and exceptional scope creep.
• Conducted retrospective meetings to inspect the team’s performance and adapt new changes.
• Define, implement and provide routine reports (weekly / monthly) for Planning to management.
• Conducted User Acceptance Testing (UAT).

Environment: JAVA, Oracle 11g, SQL Server 2012, SQL Server 2014, Windows, UML, SharePoint , MS Project, MS Visio, JIRA, Excel and SharePoint 2007 .

Confidential, San Antonio, TX

Business System Analyst

Responsibilities:

• Closely work with internal business partners on all project phases and will need to understand the integration and data dependencies between multiple platforms.
• Performing business data analysis including transactional and data (accounts, Legal Entity, Currency, Clients)
• Creation of physical and logical models including data navigation skills.
• Researching and creating documentation on data dependencies and integration points between target platforms
• Technical specifications development using traceability matrix, data dictionaries and user stories.
• Demonstrated problem solving skills and ability to develop solutions to complex analytical/data-driven problems.
• Participate and support in delivering results and presentations to clients.
• Educated Agile teams on the use of Kanban and flow to optimize the team’s work.
• Involved in breaking down the concepts into user stories and streamlining the daily delegation of incoming issues using Issue tracking system.
• Mentored and empowered teams towards making appropriate commitments through story selection, establishing acceptance criteria, story sizing and task definition.
• Created Test Plan and Test Case Templates for testing the entire application using JIRA.
• Prepared the Use Cases from the high-level business specifications to detail the Business, Functional Specifications.
• Co-ordinated with the team in designing, security testing procedures with the verification for the security with the system applications and manage the remediation of identified risks
• Excellent communication skills both written and verbal, including ability to communicate across all levels Stay abreast of current trends and best practices in marketing analysis and tools/techniques.

Environment: Asp.Net, Excel, Oracle, Windows, Scrum, UML, Jenkins, MS Project, MS Visio, JIRA, SharePoint 2007, SQL,SQL Server 2008 and Excel.

Confidential, Moline, IL

Business System Analyst

Responsibilities:

• Conducted Requirement Gathering sessions in the form of questionnaires and business scenarios with the end users, subject matter experts (SME), legal experts and timekeepers.
• Involved in Knowledge transfer sessions with the design and development team to translate the application requirements to the technical team.
• Data manipulation and Aggregation from a different source using BusinessObjects, Power BI, and SmartView.
• Handled importing data from various data sources, performed transformations using Map Reduce, and loaded data into local.
• Run in-house query weekly and monthly basis and writing ad hoc queries and updating in-house queries to align new business requirements.
• Actively contributed and engaged the team throughout the scrum/agile process in daily stand-ups, product backlog refinements, Sprint planning, Sprint review and Sprint retrospective sessions.
• Conducted story mapping and story boarding session to elicit high level features and goals from the Product owners
• Develop user stories and grooming with product owners throughout the agile lifecycle.
• Generate, Analyze and Created internal reports to help assess product and category data performance.
• Facilitated effective Sprint Planning sessions with Sprint goals and Sprint backlog as outcome
• Collaborated with multiple cross-functional teams and communicated with Businesspeople from various LOB’s.
• Involving users actively in User Acceptance Tests (UAT) between development team and the end users from the business team.

Environment: Asp.Net, Excel, Oracle, Windows, Scrum, UML, Jenkins, MS Project, MS Visio, JIRA, Version One SharePoint 2007 , SQL, SQL Server 2008 and MS Office 2015.

Confidential

Business System Analyst

Responsibilities:

• Interacted with Business, SMEs, and team member to understand Business requirement, functionality and prepared Conceptual, Logical and Physical Data Models for various project solutions.
• Designed and created web applications to receive query string input from customers and facilitate entering the data into SQL Server databases.
• Perform marketing campaign and investment analysis for all Online advertising, and website related activities.
• Performed data analysis for the purpose of overhauling the database using SQL Server.
• Converted physical database models from logical models, to build/generate DDL scripts.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Actively contributed throughout the scrum/agile process in daily stand-ups, functional and technical grooming sessions.
• Organized Product backlog refinement, Sprint planning, Sprint reviews and Sprint retrospective.
• Acted as Agile Coach, Scrum Master and Servant Leader for technical cross functional teams implementing Scrum.
• Tracking and Radiating team metrics through burn-down charts to higher executives
• Resolved impediments/roadblocks to re-create the focus on accomplishing the sprint goal.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User documents.

Environment: Asp.Net, Excel, Oracle, Windows, MS Project, MS Visio, JIRA, SharePoint 2007, SQL, SQL Server 2008 and MS office.