We provide IT Staff Augmentation Services!

Sr. Business /data Analyst Resume

3.00/5 (Submit Your Rating)

RI

SUMMARY:

  • Over 8 years of business/system and data analysis experience.
  • Certified Business Analyst Profession (CBAP)
  • Extensive experience in the Agile/Scrum/iterative/Waterfall/Hybrid software development methodologies
  • Extensive experience in Migration and Network Infrastructure projects.
  • Implemented EDI integration solutions, sourcing, and conversion of data.
  • Implemented SOAP, XML and Web services solutions.
  • Extensive experience in Business Intelligence (Tableau/Cognos)Analysis, reporting structures, databases and system development life cycles and documenting them through industry standard needs.
  • Extensive experience in writing functional speciation documents to meet business requirements and business needs
  • Expertise in creating SQL queries to retrieve data and do research
  • Considerable knowledge in the analysis and design of system applications and business processes across different networks to bring them on single platform.
  • Worked on many aspects of IT including design, analysis, testing, implementation and support of various systems.
  • Experience in documenting systems, business requirements and specifications, step - by step technical and user manuals with illustrations, design and development of use of test-case scenarios and root-cause analysis, gap-analysis, developing test plans, conducting user acceptance testing, training, and implementing new processes and technology.
  • Knowledge of Software Development Life Cycle (SDLC) concepts, roles and stages
  • Excellent Analytical skills with a good understanding at the Conceptual Level and possess excellent Presentation, Interpersonal skills with a strong desire to achieve specified goals.
  • Strong written and verbal communication skills
  • Team player, strong work ethics and self-starter always committed to Organization, Dedicated, self-motivated and quick learner
  • Ability to meet deadlines and keep all professional goals above personal goals.
  • Expertise in back-end testing on SQL server and Oracle databases using TOAD .

TECHNICAL SKILLS:

Operating system: Windows

Technologies/Languages: SQL

Methodologies: Agile and Waterfall

Bug Reporting Tools: HP Quality Center and JIRA

Browser: Internet explorer, Firefox, Google Chrome and Safari

RDBMS & Databases: MS SQL Server, Oracle

Miscellaneous: MS Office, MS Visio, Adobe Photoshop, Adobe InDesign, AutoCAD, Cognos 10.2

PROFESSIONAL EXPERIENCE:

Confidential, RI

Sr. Business /Data Analyst

Responsibilities:

  • Conducting interviews, fact-finding, and independent research to design creative, progressive IT solutions for business problems based on the agile software methodology. Participated on the daily scrum meeting to report status. Collected user stores to support scrum development.
  • Worked as IT Data Analyst on the Value Based program to provide incentive to the providers on their Care Coordination scores.
  • Establish / capture new data feeds, perform data integration, analysis for several initiatives supporting multiple Health Insurance products using the state of art technologies built on SOAP, XML, API, REST and Web services solutions.
  • Discovered and documented Infrastructure requirements for building the application Infrastructure components.
  • Prepared QA test plan and executed test cases to test applications components in new Infrastructure components.
  • Performed document analysis involving creation of Use Cases and Use Case narrations using Microsoft Visio, in order to present the efficiency of the gathered requirements.
  • Worked on Product Master Data Management Solution (MDM) to create one centralized product repository to be used by all downstream systems to avoid several pitfalls such as duplication/redundant information
  • Facilitate collaborative system and data design sessions with the user community, technical architecture resources and development teams.
  • Extensively using Informatica Data Quality Center for Profiling the healthcare claims and patient data. Used the Quality center for the purpose of data cleansing.
  • Developing system workflow diagrams, data flow diagrams (DFD), use cases and create storyboard diagrams and wireframes.
  • Working with Subject Matter Experts (SMEs) to elicit, analyze, document functional requirements to meet project needs.
  • Creating data mapping requirements for Extract, Load and Transform (ETL) programs to load data/information from the several systems, which includes BI tool - Tableau
  • Working with development team to create and submit EDI transactions
  • Creating SQL queries to do data analysis, and data quality
  • Authored more than 5 Functional Specifications documents
  • Facilitating the design and mapping of data conversion strategies, Documents, tracks, and resolves issues related to data quality.
  • Appling specific functional and/or business expertise to perform assigned tasks and develop specific project deliverables.
  • Completing project activities on time and within budget, and proactively identifies and communicates issues that may jeopardize milestones or project budget to the Project Manager, adhere to SDLC/APLC project management methodology by utilizing internal procedures and tools and identifying areas for methodology improvement.
  • Implemented Agile and Waterfall methodologies for SDLC.
  • Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing. Used JIRA and Quality center for managing all defects.
  • Wrote SQL queries in TOAD to validate the test case results for back-end test cases.
  • Process Cognos reports using Report studio 10.2
  • Created data mapping and wireframes for Tableau front end
  • Coordinated with developers and product managers for product improvement with timely suggestions and helped resolving technical issues.
  • Conduct impact analysis of technology changes on business processes and existing technology.
  • Coordinated with QA team for defect resolution and tracking

Confidential

Business System Analyst

Responsibilities:

  • Conducted design sessions to gather system requirements in order to develop specifications for applications.
  • Consulted with business groups to determine the best way to leverage technology to solve specific business problems.
  • For data cleaning/data quality used the Informatica Data Quality Center.
  • Worked on the project to migrate applications to new state of art Tier 2 Data Center. The application Infrastructure was built on the new Tier 1 data center. The CA assets management tools were used to capture application Infrastructure assets. I was responsible for building application that maintains all application Infrastructure assets such as server, database, security, network assets in centralized Infrastructure storage.
  • Prepared QA test plan and executed test cases to test applications in new Infrastructure
  • Performed document analysis involving creation of Use Cases and Use Case narrations using Microsoft Visio, in order to present the efficiency of the gathered requirements.
  • Documented and implemented technical ideas to paper and then finally on the web for everyone to start using them.
  • Involved in data mapping the flat file structure to Oracle applications table structure for Invoices, Customers and Requisitions.
  • Assisted in logical, physical data modeling and conceptual data modeling.
  • Created SQL Scripts to do data research and generate reports on an ad-hoc basis
  • Implemented Agile approach towards development of various services for different applications.
  • Analyzed technical requirements, designing timelines and preparing ETAs making sure that they are not missed at any cost.
  • Studied and assessed the business system and processes
  • Conducted individual and group (JAD)sessions with business stakeholders and technical units
  • Performed requirement analysis with Rational Requisite Pro.
  • Analyzed the source systems data and current reports to gather requirement.
  • Provided key input in working with users in defining project and system requirements.
  • Provided inputs to develop project plans and managed scope.
  • Designed and developed use cases, activity diagrams and sequence diagrams using UML.
  • Assisted Project Teams in preparing Software Requirement Specifications (SRS), Software Design Documents (SDD), User Interface Design, designing of Application Architecture & Database Modeling.
  • Functioned as primary liaison between the business line, operations and the techies throughout the project cycle.
  • Played a key role in planning User Accepted Testing, implementation of system enhancements and conversions.

Confidential, NJ

Business System Analyst

Responsibilities:

  • Participated in gathering user requirements, developing functional and non-functional requirements and technical specification for Business Intelligence reports built on Product Master Data
  • Conducted user interviews sessions with end users, stakeholders and developers.
  • Documented the requirements and list of application to migrate new Infrastructure build on Windows 7. Prepared test plan and executed test cases to test applications in new Infrastructure Performed document analysis involving creation of Use Cases and Use Case narrations using Microsoft Visio, in order to present the efficiency of the gathered requirements.
  • Worked closely with Project Team to design targeted business process and ensure current data and operational processes are in support of Policy Management across various business units and areas.
  • Wrote business requirements specification (BRS) and functional requirements specification (FRS) documents as per the business requirements and process flow.
  • Created SQL queries to do data validation
  • Analyzed various tables using Data manipulation techniques like merging, appending and sorting.
  • Worked with large data sets (15+ million records).
  • Tested highly customized reports of claims data using tabular and summary formats.
  • Monitored and managed the execution plans for SQL code using SQL developer.
  • Documented the Business Process and Business Functionality, and translated them to requirement specifications document.

Confidential, VA

Business Data Analyst

Responsibilities:

  • Responsible for gaining a good understanding of user needs and accurately representing them in a well-documented software functional specifications document.
  • Gathered Business Requirements, interacted with the users, designers and developers, project manager and QA team to get a better understanding of the Business Processes.
  • Worked on version one maintaining user stories, epic, Iteration tracking.
  • Managed and conducted Backlog prioritization with business.
  • Conducted Sprint planning with development & QA team.
  • Facilitated retrospective discussing on action items, what went well, what needs to be done.
  • Conducted Sprint review with team and stakeholders.
  • Prepared detailed user stories.
  • Co-ordinate with development &UI team to come up with wireframes and was also involved in BA acceptance testing.

Confidential, Washington, DC

Business Analyst

Responsibilities:

  • Acted as a liaison between the developers and management staff and was instrumental in resolving conflicts between the management and technical teams.
  • Conducted meetings/interviews and JAD sessions with stakeholders to collect business requirements. This information along with the vision document was used to transform business requirements into System Requirement Specifications.
  • Prepared business workflow models that cover "How" business processes are accomplished.
  • Identified the business requirements from the end users keeping in mind their need for the application and documenting it in MS Excel and MS Visio for the developers.
  • Conducted milestones planning of the project through walkthroughs and meetings involving various leads from development, QA and technical support teams.
  • Created and managed project templates, use case project templates, requirement types and traceability relationships in Rational Requisite Pro.
  • Created Analysis Model and Data Model and used these artifacts to develop the Design Model: Class Diagrams, Collaboration, and Sequence Diagrams.
  • Created Use Case Model and detailed use cases in conjunction with the project team to define f the application and to be used by the development team.
  • Helped the QA team to devise the test plan for the application by explaining the vision document and the business case.
  • Attended change request meetings to document corresponding changes and implemented procedures for enforcing changes through defect tracking using Rational Clear Quest.

We'd love your feedback!