THEJESWI

Sr. Business/Data Analyst

Ph :732-***-****

E: ac0ypb@r.postjobfree.com

PROFESSIONAL SUMMARY:

•Business System Analyst with 8+years of experience in business process analysis/modelling, business requirements gathering, database design and development of Web Based, and Client/Server applications, with hands-on experience in Healthcare Sector.

•Excellent knowledge of Software Development Life Cycle (SDLC) models like Waterfall, Agile Scrum, Waterfall- Agile Scrum Hybrid and Rational Unified Process (RUP).

•Proficient in the agile framework, and handling requirements and project tasks and deliverables swiftly.

•Experienced in facilitating scrum ceremonies and resolving impediments as Scrum Master.

•Worked closely with Project Manager for budget allocation, Work Breakdown Structure (WBS), monitoring and reporting structure.

•Successfully performed Scrum Ceremonies and resolved impediments faced by the team members.

•Conducted elicitation techniques like Focus groups, Brainstorming, Interview and Joint Application Development (JAD) sessions for requirements gathering and requirement refinement.

•Excellent in creating document creation like Business requirements document (BRD), Software Requirement Specifications (SRS), Business Process Reengineering (BPR), Use Case Specifications, User stories/flows, Functional Specifications (FSD), Requirement Traceability Matrix (RTM), Test case and Test Plan.

•Expert in creating Specifications and developing Conceptual, Logical / Physical ER diagrams.

•Skilled in documenting Unified Modeling Language (UML) diagrams like Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams, Data Flow and Business Flow Diagrams using MS Visio and Rational Rose.

•Experience in supervising Black Box Testing, Functionality Testing, System Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.

•Good knowledge in writing data dictionary for data models.

•Extensive Knowledge working with ETL tools like Informatica Power centre, Data stage, Microsoft SSIS.

•Proficient in Business Intelligence tools like IBM Congo’s, Tableau, MS SharePoint, SAP, Qlik and Spot Fire.

•Experience working in SOA Framework, Ajax, SOAP, Web Services, WSDL and Client and Server Validations.

•Application Development experience in a team environment, agile methodology.

•Possess good working knowledge of validation scripting like JavaScript, JQuery and Angular JS.

•Extensively worked with web services related projects that utilized Ajax.

•Experience with XML, JSON and SQL development.

•Assisted in developing Test Plans and Test Case and preparing requirement traceability matrix.

•Working knowledge of Structured Query Language (SQL) for data manipulation and retrieval from data ware house and transform it to required Database like DB2, Oracle and so on.

•Working knowledge of project management tools like Version One, JIRA, HP ALM/QC, MS Project, and Financial Force Project Management.

•Proven ability to work under pressure, prioritize and working with deadlines.

•Strong team playing skills owing to past involvement in team sports and a leader when required.

•Proficient in problem solving skills with an ability to comprehend different perceptions

•Result oriented, hard working with excellent communication and presentation skills.

•Excellent interpersonal and negotiation skills with Developers, Application Architects, Subject Matter Experts, business users as well as senior executives.

TECHNICAL SKILLS:

Business Skills

Business Process Analysis & Design, Requirement Gathering, Use Case Modelling, JAD/JRP Sessions, Gap Analysis and Impact Analysis.

Methodology

RUP, Agile, Scrum, SDLC, OOAD and Waterfall.

Standard and Codes

HIPAA, EDI, ICD-10, ICD-9, ANSI X12, HL7, CMM, ISO, CPT and CMS form.

Management Tools:

Rational Rose, Requisite Pro, Clear Quest, Clear Case, Serena Team Track, MS Visio and MS Project.

Testing Tools

Test Director, Win Runner, Load Runner and TOAD.

Database

Oracle 8i/9i/10g, DB2, Teradata, MS SQL Server.

Languages

SQL, T-SQL, PL/SQL, CSS, VB, HTML, XML, MHTML, Java, VB.NET, C++, C, C#

Operating Systems

UNIX, Windows 95/2000/NT/XP.

Office tools

MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Client: Revature LLC, Reston, VA March 2015 – Present

Senior Business/Data Analyst

Involved in creating a sales and service data mart required for Business Intelligence and reporting purposes. The Existing RML system which allows the agents to enter, modify recent sales/service data is used as one of major source systems.

Responsibilities:

•Performed data profiling in the source systems that are required for RML System.

•Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.

•Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.

•Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.

•Involved in defining the source to target data mappings, business rules and data definitions.

•Responsible for defining the key identifiers for each mapping/interface.

•Responsible for defining the functional requirement documents for each source to target interface.

•Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.

•Reverse engineered all the Source Database's using Erwin.

•Documented data quality and traceability documents for each source interface.

•Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.

•Involved in data warehouse design.

•Experience with various ETL, data warehousing tools and concepts.

•Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.

•Worked with internal architects in the development of current and target state data architectures.

•Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.

•Used data analysis techniques to validate business rules and identify low quality missing data in the existing Amgen enterprise data warehouse (EDW).

Environment: UML, Visio, Windows, Oracle, Microsoft Project, SQL Navigator, XML, J2EE, JSON, T-SQL, TOAD, Microsoft Office suite, Business Objects.

Client: Lincoln Financial Group, Lutherville, MD December2014–Febraury2015

Role: Business Analyst

Involved with the Social Security team {Office of Electronic and Technology (OEST)} for the e-Authentication project. The goal of the project was to re-engineer their current fraud and authentication system to stop fraudsters from hacking into the Social Security Administration website. Responsible for end-to-end analysis, design of the fraud analysis system and procedure details.

Responsibilities:

•Extensively practiced good customer service skills with the client.

•Coordinated project scheduling and status reporting with the project manager.

•Interacted extensively with various business groups, stakeholders and users to develop the Vision Document that is aligned with corporate strategic objectives.

•Extensively used Requisite Pro for managing and documenting requirements to develop test plan, test cases and test scripts.

•Performed analysis of cash, banking and treasury activities as well as maintain debt schedules and prepare debt covenant computations.

•Managed Migration of 500+ application instances from infrastructure discovery to execution phase.

•Developed a dashboard tool based on the SharePoint repository to track progress of migration phases.

•Documented the “AS-IS” Business Workflows adhering to UML standards.

•Collaborated with J2EE developers for implementing code, per business requirements.

•Conducted JAD sessions to define requirements and finalize the Functional Requirement Document (FRD).

•Documented meeting minutes from JAD sessions and obtained sign-offs from JAD participants.

•Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, functional and non-functional requirements.

•Make recommendations for process improvements and evaluate the related outcomes.

•Identified use cases from the functional requirements, wrote use case specifications and created “TO-BE Business Process Workflow” diagrams (activity diagrams) in MS Visio.

•Conducted requirement workshops to verify and validate business requirements.

•Created use case diagrams using MS Visio to show interaction between the actors and the use cases as well as to demonstrate the relationship between the use cases.

•Build an application using service oriented architecture (SOA) and XML to assist the Stock-Borrow Loan team in sending Buy-In requests to DTC for post settlement date clearings.

•Identify, assess and record business needs.

•Designed and created Report templates based on the financial data using SQL.

•Assisted in the design of star schema and snow flake schema.

•Advice on options, risk and cost vs. benefit.

•Research new and existing technology solutions.

•Provide leadership to other team members by providing knowledge and expertise on metadata.

•Lead cross-functional, cross-business teams in process improvement efforts.

•Drive change, championing new activities and manage implementation effectively.

•Produce detailed process flows and other documentation associated with current and future processes and procedures.

•Recommend process design changes and identify opportunities to improve existing processes.

•Demonstrate and apply analytical techniques to help optimize customer experience and business operations.

•Ability to make and expedite independent, unpopular decisions when appropriate.

Environment: Windows 7, Agile environment, MS Office, MS Visio, XML, J2EE, JSON, Quality Centre-ALM, T-SQL, MS Excel

Client: Verizon Wireless, Dayton, OH May 2013 - November 2014

Role: Business Systems Analyst

The project emphasized on improving and enhancing the existing Accounts Management System. The system was intended to provide various services such as Current Balance, Usage History, Plan Options, Payment History, Tax and Insurance Data, Online Payments, Applications for Secondary Cards, Theft Report, or loss of card. Customers could use the Accounts Management System to manage their accounts and keep track of previous records. Additional responsibilities included the validation and verification of Networking and Mobile Devices.

Responsibilities:

•Acted as a liaison between system users, clients and managers to congregate business requirements.

•Conducted JAD sessions with management, SMEs (Subject Matter Experts), vendors, users and other stakeholders for open and pending issues to develop specifications.

•Analyzed the Business and System Requirements utilizing RUP for various existing modules.

•Drafted Use Cases using Activity diagrams and Sequence diagrams.

•Actively participated in all the phases of Software Development Process.

•Preparation & Review of High Level Functional Designs (FDS) documents for Verizon Wholesale Application implementation from a business perspective to ensure all functional requirements are captured properly.

•Involved in Requirement Scoping and analyzing high priority requirement for implementation.

•Created Business Requirements Document and converted them into System Requirement Specifications Document.

•Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs ensuring that all critical requirements are followed.

•Attended meetings with management to discuss projects and draft strategies for future endeavors.

•Produced functional specifications and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.

•Followed the RUP methodology right from inception to the transition phase.

•Participated in Design walk-through with SME’s to baseline the business architecture.

•Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.

•Created and managed project templates, use case project templates, requirement types and traceability relationship in Requisite Pro.

•Coordinated with the development team, database team, data warehousing team and QA team throughout all phases in the RUP methodology.

•Documented business workflows textually as well as in UML diagrams according to Rational Unified Process for stakeholder review.

•Prepared test cases, test plans, test strategies, traceability matrix for QA team.

•Analyzed data requirements from the users and assisted data analysts, data modelers and developers for interpreting the data definitions, fields & attributes.

•Developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

•Wrote basic SQL queries for validating the data and the business rules.

•Frequently worked with SQL to create basic statements: select, updated, delete, insert, and create.

•Applied Database concepts, DDL, DML, and Grant/revoke.

•Estimated effort for the projects (and change requests) using function point analysis (.Net or SQL

Environment: Windows XP, MS office, MS Visio, MS Access, Rational Requisite Pro, Rational Rose, Unified Modelling Language (UML). Oracle, MS SQL Server2005

Client: Independence Blue Cross (IGI Health), Piscataway, NJ November 2012 - April 2013

Role: Business Analyst Consultant

Independence Blue Cross provides millions of families with top-quality, affordable health insurance. Its nation's oldest and largest family of health benefits companies. The goal of the project was to re-engineer benefit enrollment and eligibility testing for various health plan options. Apart from the web based customer facing application, the goal of the project was to maintain the mainframe based application -PIBA for new and existing customer base in tune with their eligibility and enrollment benefits.

Responsibilities:

•Extensively practiced good customer service skills with the client.

•Interacted extensively with various business groups, stakeholders and users to develop the Vision Document that is aligned with corporate strategic objectives.

•Documented the “AS-IS” Business Workflows adhering to UML standards.

•Conducted JAD sessions to define requirements and finalize the Functional Requirement Document (FRD).

•Documented meeting minutes from JAD sessions and obtained sign-offs from JAD participants.

•Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, functional and non-functional requirements.

•Identified use cases from the functional requirements, wrote use case specifications and created “TO-BE Business Process Workflow” diagrams (activity diagrams) in MS Visio.

•Designed User Interface-level wireframes detailing interaction models and user experience using Axure.

•Conducted requirement workshops to verify and validate business requirements.

•Created use case diagrams using MS Visio to show interaction between the actors and the use cases as well as to demonstrate the relationship between the use cases.

•Maintained a Traceability Matrix to ensure that all functional requirements are addressed at the use case level as well as the test case level.

•Performed functional and GUI testing to ensure that the user acceptance criteria are met.

•Co-coordinated the User Acceptance Testing (UAT) on a daily basis with the SME’s to make sure that all the business requirements are addressed in the application.

•Coordinated project scheduling and status reporting with the project manager.

Environment: Windows 7, Waterfall environment, MS Office, MS Visio, Quality Centre-ALM, MS Excel, Sales Force.

HTC Global Services Pvt Ltd – Hyderabad, India May 2008 to July 2012

Business Analyst Consultant

Responsibilities:

•Conducted interviews with the product owner and other stakeholders to understand the scope and requirements of the system to be implemented.

•Presented GAP Analysis on As-Is and To-Be models to confirm clear and unambiguous requirements.

•Worked in coordination with the Project Manager to evaluate resource and budget planning.

•Utilized SQL to extract data relevant to requirements analysis, including data on the number of blacklisted incoming messages, calls experiencing issues due to signal threshold etc.

•Used ETL to transfer required information to Data warehouse, for further use in the course of the project.

•Generated reports to elucidate the statistics regarding the As-Is model and its drawbacks.

•Involved in creating Operational Risk Analysis, feasibility study and Work Breakdown Structure.

•Evaluated the requirements through communication with the product owner in order to create clear and concise user stories, and create use cases, Mockup models, HTML models and process flow diagrams.

•Assumed the role of Scrum Master for the remainder of the software lifecycle, and organized sprint planning, daily scrum, scrum review and scrum retrospective meetings.

•Organized and participated in UAT sessions.

•Participated alongside the test teams in continuous integration testing sessions.

Environment: MS Visio, MS Project, SharePoint 2010, JIRA, MS Access, MS Excel, MS Outlook.

Contact this candidate