Data/business Analyst Resume
Mountain View, CA
OBJECTIVE
- To acquire the position of a Senior Data/Business Analyst in an organization to utilize my analytical skills on the system effectively to the working of the business enterprise.
SUMMARY
- Business Analyst with 15+ years of experience in various industries like financial, banking software, healthcare insurance and hi - tech.
- Strong experience in all phases of Software Development Lifecycle using Waterfall, Agile/ Scrum, and Software Testing Life Cycle (STLC) and well versed in writing user stories.
- Liaison between Business, Technology, User Experience and Quality Assurance teams in different phases of the project life cycle to transform complex issues into software solutions
- Experienced and effective in conducting/ anchoring sessions during Requirement gathering/ analysis phase, in interacting with business users to identify information needs and initiate process changes and process modeling using Use Cases, Sequence and Context Diagrams.
- Ability to elicit requirements across multiple business areas by analyzing, interviewing SMEs to determine workflows, data requirements and functional requirements
- Considerable experience in conducting GAP Analysis and Impact Analysis, Cost Benefit Analysis, Risk Analysis and creating screen mockups and wireframes.
- Extensive experience in maintaining and organizing data in excel, skilled in VLookup formula development, Pivot table generation and Pivot reporting.
- Excellent organizational and interpersonal skills with a strong facility for acquiring new knowledge very rapidly.
- Outstanding organizational skills including ability to multi-task, prioritize, and manage increasingly complex issues.
- Flexible, innovative and able to thrive in a fast paced, growth-oriented and time-critical environment.
TECHNICAL SKILLS
Requirement Management: Requisite Pro, UML 2.0, EA
Document Management: SharePoint, JIRA
Business Modeling: MS- Visio, Rational Rose, Balsamiq
QA Management: Quality Center, QTP, TFS, MS Test Manager
Tools: Used MS Visio, MS Office, MS Outlook, MS FrontPage, MS Project, Adobe Acrobat, Business Explorer, Toad
Database & Other Languages: PL/SQL, HTML, XML, SQL, Oracle 8i/9i MS SQL Server, MS Access 2.0
Environment: Worked Agile/Scrum Hybrid, Waterfall, SDLC
Financial: SAP/FICO, QuickBooks
Operating Systems: Windows 95, 98, NT, 2000, XP, 7, 8, 10 Unix, Linux
Mainframe: Z/OS
Mac OS X: Leopard, Snow Leopard, Lion, Mountain Lion, Mavericks, Yosemite
PROFESSIONAL EXPERIENCE
Confidential, Mountain View, CA
Data/Business Analyst
Responsibilities:
- Analyzed, developed and evaluated data mining in a data warehouse environment
- Tested the data integrity and gap analysis among various sources and targets
- Led and conducted JAD sessions for requirement gathering, analysis and design of the system
- Created pivot tables and modified spreadsheets to achieve analytical goals.
- Documented and tested dashboard reports using SQL Queries.
- Prepared mock ups for various ad-hoc reports.
- Developed ad-hoc reports for the stake holders using Excel and Tableau.
- Created and maintained workflows for the production and distribution of ad-hoc reports.
Environment: Agile/ Waterfall Hybrid, Pencil, MS Office, JIRA, Sharepoint, Tableau
Confidential, Boston, MA
Sr. Business Systems Analyst
Responsibilities:
- Facilitated cross-functional team meetings to develop new business reports and enhance existing ones for the Foster Care Reviews.
- Conducted impact analysis of upgrades and changes for department/functional areas, and evaluated systems and business processes for feasibility.
- Led JAD sessions and acted as a lead facilitator for various projects through life cycle of SDLC.
- Managed the conversion of the Mainframe Operation System to the Commercial off the Shelf product with several web portal menu items.
- Prepared comprehensive test plan based on requirements and develop test scenarios based on use cases.
- Developed Requirement Traceability Matrix to record the relationship of the requirements to the design, development, testing and release of the software.
- Performed GAP Analysis to define gaps between AS-IS and TO-BE processes.
- Responsible for protecting all PII/PHI and complying with federal laws such as the Privacy Act of 1974 and the HIPAA Privacy and Security Rules.
- Consulted with business to develop conversion specifications for existing Access DB to SQL DB.
- Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data and refreshed and formatted pivot tables.
- Documented and tested dashboard reports using SQL Queries.
- Created and maintained workflows for the production and distribution of ad-hoc reports.
- Identified and completed report enhancement and fixes.
Environment: Windows 10, Agile/ Waterfall, Visio, Pencil, MS Office, JIRA, SharePoint
Confidentia, Charlestown, MA
Sr. Business Systems Analyst
Responsibilities:
- Effectively identified the list of end-user requirements.
- Responsible for requirements gathering and documenting the business processes.
- Performed detailed design and mapping specification creation for translation between Legacy and EDI formats.
- Led JAD sessions and acted as a lead facilitator for various projects through life cycle of SDLC.
- Created and updated Business Requirements, Functional Requirements which included vision, scope and wire frames for the web-based application based on HIPAA Guidelines.
- Created Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, and Sequence Diagrams.
- Prepared comprehensive test plan based on requirements and develop test scenarios based on use cases.
- Developed Requirement Traceability Matrix to record the relationship of the requirements to the design, development, testing and release of the software.
- Managed implementation of industry standard security best practices, including HIPPA, PHI and PII compliance.
- Consulted with business to develop conversion specifications for existing Access DB to SQL DB.
- Responsible for the testing and requirements documentation of the conversion of the mainframe operating system to SQL Database.
- Imported and exported data from text files into excel data. Also formatted spreadsheets and workbooks for print, document reproduction and presentations.
- Documented and tested dashboard reports using SQL Queries.
- Developed and prepared various ad-hoc reports using Excel and Tableau.
Environment: Windows 10, Agile/ Scrum, Balsamiq, Spira, MS Office, JIRA, Tableau, SharePoint
Confidential, Danville, PA
Sr. Business Analyst
Responsibilities:
- Manned for in-depth source system analysis and ensured Data Quality
- Gathered and assessed business information needs and prepared system requirements
- Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level
- Experience in Facilitating organizational change strategy development and objective setting with a cross-functional group ofBusiness/Statestakeholders
- Led and conducted JAD sessions for requirements gathering, analysis and design of the system
- Used data extracting, BI and data analysis tools.
- Responsible for protecting all PII/PHI and complying with federal laws such as the Privacy Act of 1974 and the HIPAA Privacy and Security Rules.
- Analyzed, developed and evaluated data mining in a data warehouse environment.
- Performed data replication, extraction, loading, cleansing, and data modeling for data warehouses
- Ensured data integrity and timely output of daily, weekly, and monthly scheduled jobs.
- Tested the data integrity and gap analysis among various sources and targets.
- Experience in integrating claims, eligibility, provider and data information.
Environment: Windows 10, Agile/ Scrum, Mocking Bird, Spira, MS Office, JIRA, SharePoint
Confidential, New York, NY
SR. Business Systems Analyst
Responsibilities:
- Participated in the requirements gathering and documented the business processes.
- Performed GAP Analysis to define gaps between AS-IS and TO-BE processes
- Acted as a facilitator in JAD sessions to analyze and prioritize competing business needs
- Determined traceability and dependability between the requirements.
- Created BRD, Vision, scope, wire frames and Functional Spec
- Performed query unit testing and worked with end-users to schedule and perform UAT for the queries
- Extensively worked with VLookup formulas to compare data in different spreadsheets and workbooks.
- Experienced with initial and delta loads from RCS systems, also scheduling and monitoring data loads.
- Ran reports out of the SAP BCS system to troubleshoot issues found during testing by the user.
Environment: Windows 10, Agile/ Scrum, Balsamiq, Spira, MS Office, JIRA, Tableau, SharePoint
Confidential, Pasadena, CA
SR. Business Analyst/ Project Manager
Responsibilities:
- Analyzed and documented information system requirements and the corresponding impact on business processes using Business Process Models.
- Interacted with business owners to identify business system needs, evaluated solutions or business problems and proposed alternate methods to increase efficiency
- Responsible for defining the scope using project backlogs and sprint backlogs and implementing business rules of the project, gathering business requirements and documenting user stories and personas
- Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS)
- Formulated comprehensive test plan based on requirements and develop test scenarios based on use cases
- Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
- Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
- Successfully implemented all tactical operational monthly releases. Eight releases to date with a 100% success rate ranging from 20 to 28 enhancements, 30 to 42 bug fixes and numerous emergency fixes.
- Managed a team of 8 developers, testers and analysts and performed all HR processes including performance and career growth
Environment: Agile/ Scrum, SDLC, Visio, Quality Center, SQL Server, MS Office
Confidential, Newark, NJ
SR. Business Analyst
Responsibilities:
- Conducted JAD and facilitated brainstorming sessions with a diverse global group of SAP Users and Consultants to understand users' requirements
- Responsible for defining the scope using project backlogs and sprint backlogs and implementing business rules of the project, gathering business requirements and documenting user stories and personas.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams using UML and Visio.
- Handled many design change and requirement changes in various versions and service packs of the product.
- Represented end user to the development group for product prototype validation.
- Created Product Quality Management Plan in MS project in parallel with the Product Development Plan created by Development Managers to fit into overall Project Plan.
- Convened SDLC deliverable reviews and planned all QA activities and created QM schedule.
- Performed the testing of the conversion of the mainframe operating system to SQL database.
- Conducted quality gate review meetings with higher management for logical transition of the product to the next phase of product life cycle and apprised them of the quality status of the product.
- Assisted in the coordination of the operational and functional planning processes for the Fixed Income Management group.
- Completed various reports by retrieving data from the database by writing SQL statements to add, modify, copy and delete data.
- Performed advanced problem solving and analytical analysis to reduce complex data to simple concepts for communication to team members and management.
- Acted as a liaison between the different departments and units and worked very closely with the Business managers of the different departments.
Environment: AGILE Scrum, UML, MS Project, MS Visio, Rational Requisite Pro, MS Office, SQL
Confidential, Newark, NJ
SR. Quality Assurance Analyst
Responsibilities:
- Participated in Feature Design review meetings and presented test case review, strategy and feature functionality and documented test cases and conducted manual testing.
- Translated the information to test cases and test procedures, based on use cases.
- Created Test Cases from Functional Requirement document and maintained traceability matrix
- Prepared Test environment (installation and configuration of product builds)
- Developed strategies for Test Planning, Test Case Designing, Test Scheduling, Test Estimation, Test Execution and Defect Tracking
- Developed Requirement Traceability Matrix to record the relationship of the requirements to the design, development, testing and release of the software.
- Created test scripts and performed interface, system, functionality, user acceptance testing and regression testing.
- Prepared the Cause and Effect spreadsheet based on the functionality of the application for easy analysis.
- Utilized Issues Tracking Database for communication with the production personnel, developers and team members.
- Worked closely with software developers to isolate, track, and troubleshoot defects.
- Attended reviews and walkthroughs to better understand the requirement documents.
Environment: AGILE Scrum, UML, MS Project, MS Visio, Rational Requisite Pro, MS Office, SQL
Confidential, Newark, NJ
Financial Analyst
Responsibilities:
- Handled diversified Accounts Payable/Receivable and Expense Control procedures including bank and account reconciliations, cash receipts, disbursements and preparation of daily bank deposits.
- Performed accounting and reporting functions as well as weekly payroll processes for salaried employees and monitored payroll taxes for accuracy and on-time payments.
- Collaborated extensively with external auditors, providing in-depth assistance with periodic corporate audits.
- Prepared, analyzed and communicated key expenses, headcount and production reports, as assigned.
- Researched account transactions, demonstrated a keen ability to recognize and resolve discrepancies.
- Followed through on timely and accurate month-end closings and financial reporting activities.
- Responsible for billing and clearing various intercompany account balances.
- Determined the accounting procedures necessary to adopt new regulations or standards.
- Performed reconciliation and analysis for general ledger accounts with the help of pivot tables.
Environment: MS Office, MS Visio, TFS, QC, QTP, SQL
Confidential, Pennsylvania
Business Systems Analyst
Responsibilities:
- Developed the prototype for Security Access Tracking System(SATS)
- Developed prototype of new information processing application. Facilitated collection of functional requirements from system users
- Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes
- Made sure that the Approval process in place when there is a deployment in SATS
- Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and insured that critical requirements are not missed
- Involved in planning, execution, coordination of entire testing (QA) life cycle
- Assisted the QA team in SIT and Business in UAT
Environment: Agile/ Scrum, SDLC, Visio, Quality Center, SQL Server, MS Office