We provide IT Staff Augmentation Services!

Sr Business Technical Analyst Resume

Oak Brook, IL

SUMMARY:

  • Experienced Information Technology professional with emphasis in Product Management & Ownership, Business Analysis, and Software Quality Assurance; strong analytical skills with passion for delivering quality software products; proactive communicator with proven ability to effectively collaborate and delegate across teams, and hands on experience in Agile/Scrum methodology, coaching and mentoring.
  • Gathered and develop user requirements and functional requirement specifications (FRS) for portions of client's SAP solution that are GxP - relevant.
  • Facilitated Scrum ceremonies, e.g., Iteration planning, daily stand up meeting, Iteration demo and iteration retrospective
  • Designed Data flow for newly created and existing tables
  • Reviewed DDL and DML scripts with DBA and Data Modeler
  • Created Mockup by using Axure RP to map desired interface behaviors
  • Worked with Endeca developer to fix search related issue when there is available inventory but product is not searchable
  • Conducted UAT to make sure that all the user requirements are catered by the application.
  • Created use cases for alerts for margin calls, price triggers
  • Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly
  • Produced and presented activity diagrams through Visio during UX session for designers and developers.
  • Developed/Updated System Test Plan, Test scenarios and Test Scripts as per the requirements and Change Request Document.
  • Wrote and executed SQL queries to verify the proper insertion, deletion, and updates into the Database.
  • Extensive knowledge & experience in Mortgage, Healthcare, Property and Casualty, General & Life Insurance, Automotive Domain, E-commerce.
  • Good knowledge of Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures)
  • Experience in requirements gathering, analyzing them, and Writing Business Requirements Documents (BRD), Use case specifications, Systems Requirements Specification (SRS), Project planning, scheduling and management.
  • Hands on experience in analyzing the high level requirements, developing User Stories, Test Plans, writing Test cases, creating RTM, building test data using Excel & SQL queries, testing & documenting issues and collaborating with development teams to resolve issues using tools like TFS and Quality Center
  • Strong Knowledge of Business Intelligence, Data Warehousing and Business Architecture.
  • Good Knowledge of SOx related to software development.
  • Involved in testing Web services and XML files using SoapUI .
  • Highly proficient in Data Analysis, Data Mapping, and Datsa extraction by writing complex SQL queries for large databases.
  • Extensive experience in designing SOA services (SOAP & REST) and middleware integration for large distributed enterprise applications, especially for Banks

TECHNICAL SKILLS:

  • SQL (Oracle/MS SQL)
  • Agile (SAFe)
  • Waterfall
  • Java
  • MS Project
  • Visio
  • MS Office
  • ALM Explorer
  • Quality Center
  • Rally
  • JIRA
  • Confluence
  • DbVisualizer
  • SQL Developer
  • TOAD
  • Balsamiq
  • Axure
  • Confluence
  • Salesforce

PROFESSIONAL EXPERIENCE:

Sr Business Technical Analyst

Confidential, Oak Brook, IL

Responsibilities:

  • Conducted and Participated in Usability Study to analyze and improve Restaurant File Maintenance (RFM)
  • Assisted Confidential 's in the analysis of gathered user requirements
  • Use rapid wire framing tool to create mockups
  • Receive and review technical designs on new and revised capabilities
  • Develop and share solution expertise to provide application integration support across Product Integration and, as needed, other development phases
  • Subject matter expert on the client's e-commerce Platform and its configuration with other application components
  • Create and manage product backlog in JIRA
  • Write user story and design wireframe for each story using balsmiq
  • Work with PMO, product teams, and other stakeholders to define development integration requirements and timelines
  • Triage issues related development
  • Facilitate and lead meetings
  • Develop environment strategies which align with development work streams
  • Manage work entry and exit criteria for Product Integration
  • Ensure entry criteria to Solution Integration is met
  • Ensure availability of integrated environments and test data
  • Document environment configurations and test data
  • Work with product teams to determine schedule for integration requirements for active development
  • Work with partner support team

Sr Business Systems Analyst

Confidential, St. Paul, MN

Responsibilities:

  • Develop user requirements and functional requirement specifications (FRS) for portions of client's SAP solution that are GxP-relevant.
  • Worked directly with business owners & stakeholders, project managers to identify roadmaps, scope, feature requirements.
  • Prioritized functionality and feature requests and groomed the backlog for Scrum team
  • Assist in building a requirements traceability matrix (RTM) to be used during validation execution.
  • Conducts interviews with business stakeholders and process owners to identify system requirements.
  • Help to integrate user requirements and functional specifications with test scripts.
  • Help to build repository of user requirements and functional specifications.
  • Improve and standardizes existing user requirements and functional specifications to become CSV compliant.

Sr Systems Analyst

Confidential, Raleigh, NC

Responsibilities:

  • Facilitated daily Scrum meeting, Sprint planning, Sprint retrospectives and Sprint reviews.
  • Interacted with stakeholders/product owners to prioritize stories for upcoming Sprints. Schedule/facilitate sprint planning meeting(s) prior to the beginning of each sprint. Work with product owners and delivery teams to groom stories in advance of each sprint.
  • Prepared detailed and clearly written product requirement specifications, acceptance criteria based on Product owner/stakeholders needs and coordinate review of the requirements with internal partners.
  • Supported and educated the Product Owner, especially with respect to grooming and maintaining the product backlog.
  • Enabled improvement in team delivery commitments and capacity planning for sprints by identifying & tracking hidden tasks that increased customer satisfaction.
  • Updated Agile (scrum) metrics tracking variables to provide transparency on product and Sprint backlogs.
  • Collaborated with technology managers and directors to lead projects in support of the department's strategic plan.
  • Documented the requirements for team and maintain on SharePoint for team to have access
  • Created functional specification docs based on KT sessions for existing applications
  • Delivered reverse KT with the business
  • Worked with Product Owner and Dev team to write stories
  • Conducted PI planning sessions
  • Conducted Sprint planning session
  • Engaged team for clarification through sprint standup and 3Amigos session
  • Created process flow through Visio to capture the existing business process
  • Worked with Scrum Master for day to day coordination to support the team including improving on team processes
  • Designed Data flow for newly created and existing tables
  • Created source to target mapping documents, business rules and data definitions to help create both logical and physical data models
  • Reviewed DDL and DML scripts with DBA and Data Modeler
  • Communicated Data Model Changes to the Dev team
  • Worked with QA team to create and review test scenarios
  • Wrote ETL test scenarios for both Developers and QAs
  • Performed data analysis and extensive data quality checks as part of the ETL design.
  • Designed the transformations as per the reporting requirements during the ETL into the Data Mart.
  • Wrote and Execute SQL scripts and queries to do data validation
  • Helped the Middleware team with the XML inputs and outputs of the web-services which were utilized.

Sr Systems Analyst

Confidential, Minneapolis, MN

Responsibilities:

  • Clarified and examining business requirements with business analyst and resources
  • Facilitated cross team collaboration between the customer and development team to gain understanding of existing features and functions to translate into new and enhanced features and functions
  • Led regular communication feedback loops and demos with stakeholders to obtain feature requests and feedback for next Sprint/Iteration
  • Translated high level business requirements into a backlog of epics, user stories and acceptance criteria
  • Served as a resource and Subject Matter Expert for a new healthcare management platform product offering
  • Scrum Master for agile ceremonies, ie: daily scrum, weekly scrum of scrums, pre-grooming, grooming, Sprint planning, demo/sprint review, retrospective
  • Managed product backlog
  • Worked closely with product managers, product owners, UX designers, engineers/developers and QA team throughout various phases to provide clarification of requirements and ensure proper feature execution and implementation (Backlog grooming & refinement)
  • Conducted JAD sessions to flesh out the requirements and design
  • Scheduled working session for assigned project and provide direction for other analyst’s story
  • Sent approval request after changes are made to the handoff documents
  • Validated defect by providing required documentation and direction
  • Verified Schema changes will not result in side effects to existing functionality
  • Created, updated and sent REF request for adding any new value to table in ICUE DB
  • Updated or Created WSDL Mapping based on request and response copybook
  • Prepared source to target mapping and technical specification document.
  • Imported, transformed, and integrated healthcare Claim, Provider, Member, Enrollment, Lab, and Pharmacy data from various health plans into SQL Server schemas
  • Identified and developed a team of internal personnel to deliver healthcare provider data to various states in the format needed to meet federal regulatory requirements.
  • Worked with the assigned developer and data architect to identify and finalize database changes
  • Reviewed and analyzed requirements for various system interfaces (REST/SOAP web services)
  • Helped the Middleware team with suggesting web-services from UDDI and also developing XML inputs and outputs of the web-services from which the XML schema was developed.

Sr Business Analyst

Confidential, San Antonio, TX

Responsibilities:

  • Analyzed business requirements to design and document test scenarios for UAT
  • Analyzed, understood and reviewed the comps for email confirmation to make sure order summaries are captured properly.
  • Updated BRD and FRD as per new business requirements from business during UAT.
  • Participated in daily standup to analyze and resolve issues.
  • Involved in Sprint planning and participated in daily scrum meeting to discuss the work status.
  • Conducted JAD sessions with management, SME, vendors and other stakeholders for open, pending and critical issues.
  • Assigned problems to appropriate software development team for fixes
  • Performed document management using Microsoft SharePoint.
  • Analyzed and Validate product data to facilitate UAT.

Business Systems Analyst

Confidential, Durham, NC

Responsibilities:

  • Implemented an integrated RUP solution with complete line of traceability for all the artifacts of web development projects.
  • Involved in requirement gathering using Rational Requisite Pro which included interviews, brainstorms and meetings with stakeholders and SMEs.
  • Involved in the creation and maintenance of the Workflow plans and artifacts for all the waves.
  • Developed and Supported requirements for trading platforms to offer faster trading capability, directed trading, Dow Jones News and trailing stops.
  • Created use cases for alerts for margin calls, price triggers, stock research and breaking news and when trade executes.
  • Extensively involved in all the waves to make sure that documented functional requirements are met.
  • Maintained and kept track of stake holder’s requests for enhancements and changes using Rational Clear Quest.
  • Performed Gap analysis by identifying existing processes and technologies, documenting the enhancements needed to meet the end state requirements.
  • Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
  • Performed all kinds of testing including system, integration, functional testing.
  • Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
  • Involved in preparing a simple and detailed User manual for the application, for an intended novice user.

Business Systems Analyst

Confidential, Fremont, CA

Responsibilities:

  • Solid understanding of wholesale commercial card functional requirements.
  • Worked closely with stakeholder, business to identify and validate the requirement for phase 1.
  • Identified requirements which need to be out of scope for phase 1 and needs to be included for future phase.
  • Produced and presents activity diagrams through Visio during UX session for designers and developers.
  • Coordinated cross functional meeting for the purpose of design related problem and to mitigate it.
  • Coordinated offshore meeting and clarify requirements for the developers.
  • Worked with the content team to produce and deliver messages/error messages for this website to be built.
  • Designed SOA services and performed middleware integration with upstream and downstream interface partner.

Sr. Business Systems Analyst

Confidential, Simi Valley, CA

Responsibilities:

  • Experience in CFPB requirement, Home loan, Mortgage, Home Equity loan, Loan Origination process, Loan servicing, Loan Suppression
  • Function as an end to end business analyst producing artifacts using BA standards/Tools. I.e. Scope doc, BRD, FRS, Workflows, Interface prototypes, Operational Procedures, Internal and external SLA’s, Contingency plans, Training guides, Client on-boarding.
  • Worked closely with developers and testers to ensure requirements and functional designs are translated accurately into working technical designs
  • Worked closely with SMEs to ensure that test plans/scripts serve customer needs
  • Actively participated in HLD (high level design) & LLD (low level design) review
  • Actively participated in BRD review
  • Effectively maintain document version control for BRD requirements and Change Requests
  • Good understanding of what loans need to generate statements, when do the statements need to be generated, type of statement should each loan get
  • Worked on loan selection process to make sure all eligible loans are selected and generating statement
  • Worked on loan suppression process to make sure non eligible loans are not selected by the loan selection process (i.e. Bill & Receipt, Sweep, POA, / IO, Manual Coupon etc.)
  • Analyzed business requirements and functional requirements specification to get a better understanding of the system from both technical and business perspective
  • Facilitated and managed JAD sessions with committee of SMEs from various business areas
  • Reviewed and modified loan selection process diagram to draft high level overview of the test scripts
  • Developed/Updated System Test Plan, Test scenarios and Test Scripts as per the requirements and Change Request Document.
  • Assisted in Data mapping and writing transformation rules
  • Developed and executed SQL queries to verify the proper insertion, deletion, and updates into the Database.
  • Executed Test Cases in Test Lab and logged Defects in Quality Center
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts
  • Performed SOX walkthrough and gap analysis with remediation plans and follow up.
  • Maintained the Traceability Matrix table to uniquely trace the identified business requirements to general design to testing as proof that requirements requested have been developed into a solution and that it has been tested and tracked
  • Performed Data Analysis and Data Validation by writing complex SQL queries
  • Used Management Studio 2008 to write SQL queries against the database for data validation processes
  • Used Transact-SQL to convert an expression, to evaluate a list of conditions in SQL Server
  • Wrote Data conditioning to validate different types of loans and the loan volumes

Sr. Business Analyst

Confidential, Torrance, CA

Responsibilities:

  • Analyzed new Business Requirements and updated the BRD accordingly.
  • Worked closely with the development team to translate the requirements and determine the design specifications.
  • Worked closely with the internal users to have better understanding of the previous system and to address different system issues during UAT
  • Conducted interviews with key business users to collect requirement and business process information.
  • Worked on the layout and content of the website
  • Analyzed the data flow and content flow through the different screens.
  • Queried the database system for assembling of the data from multiple physical locations.
  • Queried and Created random distributors’ ID to manage different functionalities (i.e. create, update, delete, transfer) within the system across different distributor hierarchy
  • Worked closely with project managers to assist them with project plans, budgeting, scope creep, feature creep, feasibility analysis-schedule, and technical, economical, and operational feasibility study.
  • Conducted regular progress evaluation sessions and secured timely approval.
  • Strong product lifecycle and SDLC experience with focus in Agile methodology.
  • Ensured traceability of Business requirements to Test cases.
  • Always coordinated with the business users to get the feedback to make changes in requirement document.
  • Reviewed Functional Test Cases
  • Configured Managed metadata service applications, enterprise taxonomy, content type hubs and Record Center sites with custom content types, expiration policies, content organizer rules, record management settings, advanced search configurations, custom features and metadata navigation settings.

Sr. Business Analyst

Confidential, Torrance, CA

Responsibilities:

  • Analyzed the requirements given by the vendors ‘Saatchila’ and ‘Hitachi’ who provided Use cases and Comps Respectively.
  • Both these documents were provided by two different vendors, so this involved constant interaction with all parties involved.
  • My role also included functional review of the developed modules, to check if all the requirements are met.
  • My major responsibility was to understand the requirements, tweak the requirements to match technical feasibility and pass this understanding to offshore team.
  • After every deployment in DEV & Staging I was involved in Smoke Test, Sanity Test, and Exploratory Testing.
  • Conducted meetings on daily basis to make sure the developers from onsite and offshore are on the same page of the requirements.
  • Created the AS-IS and the TO-BE process flows for enhancements to the website.
  • Updated my team whenever the requirement changes or new requirement comes.
  • Worked with internal and external clients, content producers, and stakeholders to conduct interim project reviews and final project tweaks prior to launch.
  • Used Digite as a common repository to save all the project related files, comps and emails.
  • Created and modified tables, views and indexes; SQL stored procedures, functions and triggers according to business requirement
  • Provide analysis on middleware messaging system

Business Analyst

Confidential, Bronx, NY

Responsibilities:

  • Gathered requirements and prepared business requirement documents (BRD).
  • Consulted with healthcare third-party Administrator Company to develop conversion specifications for member, enrollment, and authorizations.
  • Interacted and gathered information from several insurance companies to build an error free software solution
  • Responsible for translating BRD into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
  • Conducted JAD sessions to define the project and to reduce the time frame required to complete deliverables.
  • Created business reports by joining multiple tables from multiples database using complex SQL queries.
  • Responsible for creating SQL queries for data extraction and data mining.
  • Developed and maintained all operational and technical flows using Visio and Power point.
  • Drafted the Physical Data Mapping document for the data flow from Facets to the data warehouse
  • Used Rational Rose/MS Office Suite for creating use cases, workflows, and sequence diagrams according to UML methodology thus defining the Data Process Models.
  • Defined Use cases from requirements and helped convert them into software specifications
  • Aided in workflow analysis and process design.
  • Used Ms Visio to create process maps of current as-is state of middleware system and future to-be state, leveraging Visio functionalities such as swimlanes to indicate the relationships of the business process and associated functional units and their applications

Business Analyst

Confidential, Boston, MA

Responsibilities:

  • Responsible for overall planning, coordination, and execution of projects including, but not limited to updates, maintenance, modifications, trouble shooting, best practices research, and training.
  • Studied and assessed the client’s systems and business processes
  • Addressed all aspects of the claim processing lifecycle, starting from identifying a claim right up to closure.
  • Conducted GAP analysis to identify customer channel usage trends and interactions focusing on likelihood- to-buy, product recommendations and reduce customer attrition.
  • Analyzed functional specifications and data from various data sources like mainframe, oracle database, and flat files.
  • Authored Functional Specifications communicated them to development, and testing teams.
  • Designed and developed project document templates based on RUP methodology.
  • Assisted with budgeting process, preparation of financial summaries and various project implementations.
  • Designed and developed Use Cases, Use Case Diagram, Activity Diagrams, and Sequence Diagrams - UML
  • Support compliance of all corporate policy and general procedure guidelines.

Business Analyst

Confidential, Bentonville, AR

Responsibilities:

  • Established business analysis Waterfall methodology.
  • Developed Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams, and State Diagrams to view the system from different perspectives using Visio
  • Collaborated in building a business analysis process model using MS Visio.
  • Conducted workflow, process diagram, data process diagram, and data process workflow and gap analysis to derive requirements for existing systems enhancements for the web based ordering system.
  • Worked on performance tuning and testing of the SQL database Packages, procedures and triggers of various applications.
  • Designed and developed Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams and web page mock-ups using Microsoft Visio and Microsoft FrontPage.
  • Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented data processes, data work flow.
  • Complete understanding of the Business Flow between the application and the Content Management System.
  • Using detailed knowledge of application features and functions, assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.

Business Analyst

Confidential, Thousand Oaks, CA

Responsibilities:

  • Involved in reviewing the Functional Specifications and User Stories.
  • Worked on a fast paced Agile methodology.
  • Analyze the development of schedule, work breakdown structure, and estimate packages during the different phases of a project
  • Responsible for interacting with the developers to explain the proposed changes and understand the system requirements to handle these changes
  • Developed test plans, test cases based on functional specifications and design documents.
  • Used Agile Methodology.

Hire Now