SUMMARY:

• EXCELLENT inter - personal skills with experience as a Business Analysis and proficient in various SDLC methodologies. Solid understanding of Business requirements, Business Intelligence Reporting, analyzing Fact and Dimension Tables using VLOOKUP.
• Acted as a technical liaison between the technology department and the business customers.
• In-depth knowledge of Agile Software Development and has solid knowledge on Web Base applications, SQL and Reporting Tools. Expertise in facilitating JAD sessions, develops user stories and As-Is and To-Be process flow diagrams.
• Worked in diverse domains like Mutual Insurance, Health Insurance, Human Resource and Freight Forwarding.
• Accomplished in Business Analysis, System Analysis, Quality Assurance, Marketing and Project Management with extensive experience in business products, operations and Information Technology.
• Proficient with various SDLC methodologies such as RUP, Agile(Scrum) and Waterfall
• Understanding of Data Warehousing, Business Intelligence Reporting, analyzing Fact and Dimension Tables and using VLOOKUP
• Proficient with Unified Modeling Language (UML) (Use cases, Activity Diagrams, Sequence diagrams, ER diagrams etc.)
• Experience in delivering extensive documentation but not limited to Functional Specification Document(FSD), Business Requirement Document(BRD) and Technical Design Document(TDD)
• Strong knowledge in creating User Stories and analyzing test scenarios
• Expert in developing, writing and maintaining gap analysis, business requirements and technical documentation.
• Knowledge in conventional and non-conventional requirement gathering techniques such as interviews, questioners, and JAD sessions.
• Expertise in Data Quality Processes which includes Data Mapping, Data Mining, Data Validation and Data Cleansing.
• Experience in Business Process Modeling (BPM)
• Worked extensively with QA Team in understanding and documenting Test Cases, System Test Plans (STP).
• Worked collaboratively with the Development and Quality Assurance teams during the Test Life Cycle and experienced in performing User Acceptance Testing.
• Experienced with production of documentation using templates, following writing standards for documentation, use cases using Rational Unified Process (RUP).
• Hands on experience in project management activities including scheduling project kick off meetings, creating project schedule, coordinating with cross functional groups and well versed in project management tools like MS-Project for status reporting and planning.
• Analyzed business processes and write system process specifications to be used.
• Worked with clients to determine their business needs to transform them into information technology system requirements.
• Experience working with business users as well as Senior Management.
• Proven ability to serve as a liaison between technical developers and product management.
• An organized professional with excellent verbal and written communication, presentation and problem solving skills.
• Conduct data analysis and data profiling

TECHNICAL SKILLS:

Methodologies: Agile, Scrum, Waterfall Model, Six Sigma

Business Modeling Tools: MS Visio, Rational Requisite Pro, TOAD

Databases: MS Access 2003/2007, Microsoft SQL ServerSoftware Tools: JIRA, Confluence, Blueprint, RRC, RTC

Requirements Tools: HP Quality Center, Rally, TFS

Testing Tools: SOAP UI, Postman, Versionone, HP Quality Center

ETL and Reporting Tools: SQL Server 2014, Tableau Desktop

Microsoft Office Suite: MS Project, MS Word, MS Excel, MS SharePoint concept, MS PowerPoint, MS Visio

Operating Systems: Window Server 2003/2012, Windows XP, Windows 7, Windows 8, Mac OS

Project Management and Business Skills: Impact Analysis, Change Management, SWOT Analysis, JAD Sessions, Project Planning, Project Scheduling, Cost and Time estimation, Quality Assurance and Project Budgeting, Content management

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, Ohio

Lead Requirements Analyst

Responsibilities:

• Eliciting requirements, creating documentation and facilitating meetings related to I&O projects.
• Collaborated with stakeholders and SMEs on designing solutions for business problems.
• Performed data analysis and worked on Excel & VLOOKUPs.
• Translated business and system needs into Solution Requirements for Designers, Developers and Testers to consume and used Requirements elicitation, analysis, specification, verification and management techniques for the purpose.
• Worked with business to identify capabilities, define scope and maintain a log of Action items.
• Engaged in work efforts at all scales ranging from minor defect fixes and enhancements to development of new applications.
• Involved in all types of solution approaches (custom development, package implementation.) and solution domains (business applications, data warehouses, web services, infrastructure)
• Formulated and defined systems scope and objectives with competency, through research and fact-finding combined with an understanding of applicable business systems and industry requirements. Developed and modified complex information systems with this knowledge.
• Maintained project dashboards on RTC to project the status and health of the project.
• Analysis of business and user needs, documenting requirements, and revising existing system log difficulties as necessary.
• Experienced in monitoring compliance with the data governance operating model and ensuring that changes in metadata are captured centrally and are kept up to date.
• Worked with Security and Legal team to ensure data lineage and quality and security controls are fully implemented for all Critical Data.
• Guided and advised less-experienced analysts.
• Considered the business implications of the application of technology to the current business environment.

Environment: RTC, RRC, MS Visio, MS Excel, Access, Power Point and Outlook

Data Analyst

Responsibilities:

• Documented the types and structure of the Health Spring business data (logical modeling), about the various regions of operation.
• Preformed analysis and mining of business data to identify patterns and correlations among various data points, using SSMS.
• Mapping and tracing data from system to system to solve a given business or system problem, as a part of systems analysis.
• Perform statistical analysis of business data.
• Worked closely with management to prioritize business and information needs, located and defined new process to improve opportunities.
• Participated in efforts to drive adoption of Data Governance process in the security and compliance area.
• Involved in Data Analysis & Mapping to track all data elements used in the application from the user interface through different interfaces to the target databases in which they are stored.
• Troubleshoot problems found and validating against business rules in through QNXT GUI and QNXT Database through SQL. Validated codes in QNXT using SQL Server.
• Involved in Data Analysis, Data Mapping and Data Modeling and Performed data integrity, Data Portability testing by executing SQL statements.
• Derived insights from large amounts of data from diverse sources.
• Served as a subject matter expert by providing extensive business and technical analysis based on customer needs and acted as liaison between business end users and IT.
• Created and maintained documentation of reporting, processes, data sources, metric definitions, and distribution schedules to meet customer satisfaction.
• Analyzed existing business processes and logic in inventory / warehouse operations through statistical analysis, observation, and user interaction.
• Continuously looked for areas of improvement and proposes improvement initiatives within the QNXT system.
• Performed tasks using skills in MS Excel, Access, Word, Power Point and Outlook.
• Performed Claims and adjustments processing status and analysis by markets and networks.
• Experienced in data analytics for finding and cleaning out errors within the data. Experienced in querying databases using SQL programming.

Environment: SSMS, QNXT GUI, MS Excel, Access, Power Point and Outlook

Business Analyst

Responsibilities:

• Gathered requirement from various sources like Keys Business stakeholders and Business sponsor.
• Converted requirement into documents like BRD and FRD along with Use Case.
• Created UML diagrams such as Business Flow Diagrams, Use Case, BPM and Activity Flow in coordination with technical team using MS-Visio.
• Facilitated sessions and engaged with SME’s and appropriate resources to support and plan requirements definitions.
• Created Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Used Interview and Brainstorming methods to gather high level requirement.
• Followed Iterative Software Development Life Cycle Process (SDLC) as per Rational Unified Process (RUP).
• Facilitating JAD sessions for communicating and managing expectations of SME’s and Stakeholders
• Successfully handled Change Request using Rational Requisite Pro and implemented them on the system.
• Worked on projects in different solution domains like business applications, data and web services.
• Facilitated meetings with SME have in order to gather requirements related to business, data definition.
• Prepared monthly Status Reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.
• Conducted Impact Analysis to check how system will respond to new change request.
• Performed manual testing in UAT testing phase and reported the bugs.
• Created simple SQL queries over the data base.
• Assisted the Testing Team in creating Test Case, Test Script and Test Plan.
• Support and maintain the implementation of data policies & standards, business rules, data definitions, testing depth & data quality controls.
• Involved in weekly walkthroughs and inspection meetings to verify the status of the testing effort and the project as a whole.
• Created Requirements Traceability Matrix based on high level requirement including process and project views.
• Used Tableau Desktop for analytical reporting and graphical presentations of key performance indicators (KPI).
• Worked on Market linked time deposits introduction, its impact on the interest rate offered.
• Involved in Identifying security risks, threats and vulnerabilities of networks, systems, applications and new technology initiatives.
• Assisted testing team in strategizing the Test Plan, executing Test Cases using HP quality Center
• Worked with UAT team to prepare a user document and business process document for reference.

Environment: Agile (Scrum), UML Rational Rose, Word, PowerPoint, Visio, JAD, Tableau, HP quality Center

Business Analyst

Responsibilities:

• Reviewed Project Charter with project sponsor and client manager along with program manager for every agile iteration.
• Wrote Scope and Vision of the Business Requirement Document and ensured all the requirements and processes were in line with SOX compliance.
• Managed project timelines and tracked progress of deliverables in order to keep project on track.
• Documented Functional Requirement Document and Business Requirement Document.
• Evaluated business requirements. Participated in the process of analyzing the current activities in order to recommend solutions for process improvement.
• Analyzed and documented problems and explained requirements to development and testing team.
• Identified potential test cases and shared with testing team. Reviewed test plan with stakeholders.
• Involved in Daily Scrum meetings with the team. Followed agile methodology.
• Participated in User Story Creation and Sprint Creation.
• Suggested measures and recommendations to improve the current application performance with the aid of SCR (Small Change request).
• Identified resources and scheduling conflicts; change in project scope; function as an escalation point to keep all the parties aware of overall project impact, facilitating management decisions at earliest possible time.
• Managed conflict and negotiated resolution by identifying business risk and recommend options to business stakeholders to make sound business decision.

Environment: Agile, Scrum, UAT, SOX, MS Office, MS Visio.

Business Analyst

Responsibilities:

• Worked with the Business users to understand the user requirements, layout, and look and feel of the dashboard to be developed.
• Analyzed the source data and handled efficiently by modifying the data types.
• Created Data Connections through Teradata and published on the Tableau Server.
• Developed Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Built complex calculations in Tableau for various business calculations.
• Responsible for creating AD group for users to be added to access the dashboard.
• Responsible for creating CR’s for migration from development to QA and QA to production.
• Worked closely with WorldApp and Cross mark for setting up the SFTP servers for data transfers.
• Analyzed and designed a cross reference data table to compare the survey data between WorldApp and Cross mark.
• Involved in UAT testing along with the business for the Executive and COE view of the dashboards.

Environment: Teradata, Tableau, MS Power Point, MS Word, MS Access, SSRS

Sharing Happiness

Responsibilities:

• Analyzed, documented, and managed all project requirements and changes to requirements throughout the software development lifecycle using Version one.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Version one.
• Modeled the information and then came up with the requirements prioritization. Groomed the product backlog by screening out multiple versions of user input. Final prioritization was based on both, product and process requirements.
• Facilitated the daily stand up meetings, sprint planning sessions, retrospective meetings and managed the project development.
• Worked on a daily basis with the front end UX team in gathering requirements and designing the application in the required native Android and iOS form.
• Assisted QA team in assembling, evaluating, and reviewing testing strategies and test plans.
• Performed Unit testing, performance testing & regression testing and gave feedback to the team on the application performance on both android and iOS mobile platforms.
• Involved in UAT testing along with the business to meet client requirements.
• Evaluated business process requirements to ensure proper system configuration (i.e. Identifying key decisions, process changes, pain points, interface issues, training considerations).
• Involved in presenting during meetings with stake holders and concerned teams.

Environment: Version One, JIRA + Green hopper, MS Visio, Rational Requisite Pro.

Business Analyst

Responsibilities:

• Gathered the business requirements from users by utilizing methods like meetings, requirement workshops and conducting an impact analysis, Joint Application Design, SWOT and Cost Benefit analysis.
• Performed System Studies through JAD's and Decision Tree Analysis.
• Worked in an agile environment and involved in sprint planning, work estimation, sprint retrospectives and release planning.
• Worked on creating Business Requirement Documents, Functional Specifications Document and System Requirement Specification Document.
• Involved in Strategic Planning, Risk Analysis and Market research.
• Developed a thorough understanding of business processes, practices, and available supporting technology & documentation.
• Involved in presenting in meetings with stake holders and concerned teams.

Environment: MS Project, MS Visio, SQL Server, PowerPoint.