Summary:

• Qualified professional with over 10 years of extensive experience in the field of Business Data Analysis, working with the technical staff to implement management and staff's business requirements into the software application in various Industries.
• Worked as a Team Lead for the projects involving conversion of the Business Requirements to Technical Requirements and their execution to achieve Project Timeline.
• Performed AS-IS and TO-BE analysis for the impacted system as part of Project.
• Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.
• Highly proficient in doing Data Validation using the tools Toad and MS office.
• Extensive experience in writing business Requirement Document, Technical Requirement Document, Functional Requirement Specification Document.
• In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Strong understanding of project life cycle and SDLC methodologies
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Conducted JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations as part of the Projects.
• Used the requirement attributes priority, effort, and risk as the basis for negotiating the inclusion of the requirement, to manage the scope of the system efficiently.
• Gathered and documented Non-functional requirements. Created RACI Metrix and RTM Documents as part of Analysis.
• Experienced in preparing Business Process Re-engineering Models
• Familiar with HIPAA EDI transactions such as 835, 837 P, D, I 276, 277, 278 etc
• In depth knowledge of SDLC and implementation in all phases of a project: Analysis, Design, Development, Integration Testing, Implementation and Maintenance.
• Utilized a fusion of industry knowledge and technical programming to provide executive management the development and implementation of interactive business tools, and strategic analysis, vital for use in mission-critical decision-making
• Conducting requirement gathering sessions, feasibility studies and Impact Analysis and organizing the software requirements in a structured way to track development.
• Interacting regularly with the development team, creative services, database designer, system administrator and the higher management to meet the deadlines of Project milestones.
• Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.
• Strong experience of Data Warehousing concepts and ETL Tools like Data Stage and Informatica
• Performed UAT and exposure to User Certification Testing UCT and Operational Readiness Testing ORT
• Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing , System documentation and user training.
• Well versed in writing queries/Scripts for Data Analysis and QA reporting and testing.
• Experience in Change Management Process Identify, Analyze, Evaluate, Plan, Implement, Review and Close .
• Expertise in Procurement and Management Services.
• Excellent skills in Project and Performance Management to support Strategic Planning, Goal Setting, Strengthen Accountability, Enhance Decision Making, and Improve Customer Service.
• Experience in implementing Microsoft Office SharePoint 2007.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Analyst

Responsibilities:

• Performed Requirement Analysis, Impact Analysis. Performed the requirement gathering for the project. Conducted interviews and meetings with the Business to understand their needs.
• Created the Business Requirement Document and Technical Requirement Documents for the Project that provided appropriate scope of work for technical team to develop prototype and overall system.
• Worked on Share point and Windows Active Directory.
• Created the Functional Requirements document and STTM documents for the Project.
• Worked as Team Lead and assisted Project Manager with the Timelines for Project.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Worked in mainframe environment and used SQL to query various reporting databases in Datawarehouse.
• Worked with COBOL, JCL, and VSAM.
• Worked with Mainframe teams and ETL teams through all phases of SDLC using technologies: Oracle, Toad, Data Stage, Data warehousing and ESAWS and COGNOS.
• Designed queries for the Customer Service Applications and created Views for the ESAWS application.
• Performed Data Validation for the Data loaded to Data Warehouse. Created Report for the validation.
• Worked with ChangeControl Teams and VSS for the implementation part of the Project.Worked on the technologies VSS and Putty.
• Used the requirement attributes priority, effort, and risk as the basis for negotiating the inclusion of the requirement, to manage the scope of the system efficiently.
• Involved actively in determining the quality and quantity of data to be provided for UAT.
• Worked together with Mainframe teams for the FTP and MFT processes for the new jobs.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Conducted presentations of the Q/A test results with analysis to the stakeholders and users and documented modifications and requirements.
• Coordinating and Developing QA activities.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Worked with the QA team to provide them required Technical Documents and created Test Cases for them.
• Maintained proper communication with the developers ensuring that the requirements and modifications were addressed and also monitored these revisions.
• Worked with IT team to map sources and targets, populating the data warehouse, extracts and loads, monitoring the timing of loads, validating and testing the loaded data using ETL process.

Accomplishments

• Proposed a Link Master Document as a Standard for maintenance of STTM Documents in one shared location to be used by different teams working on different Projects. The proposed solution would make the search of documents fast. The solution was implemented successfully upon approval.

Environment Windows 7 Enterprise edition, MS Office 2013, SharePoint, Toad 9.7.2,Oracle 11g, MS Visio, MS Visual Source Safe, Windows Active Directory, Putty, UML, COBOL, MS Excel ,MS Word, MS VSS 2005, Data Stage 8.1,WinSCP, UEdit

Confidential

Sr. Business Analyst

Responsibilities

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Created RACI Document for the Project.
• Performed AS-IS and TO-BE Analysis and Impact Analysis on the System. Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Perform Analysis on the Legacy System and created the Flow Diagrams in Visio for the Business Requirement document and Technical Requirement.
• Performed Cost benefit, ROI and ROM studies.
• Created Use Cases and Activity Flow Diagrams for the Project.
• Created Data Flow Diagrams and Validation Reports for the Clearing House.
• Created document for the Clearing House Standards which would be part of Data Validation in EDW.
• Conducted user interviews and documented business and functional requirements.
• Identify Member, Provider, Coverage, Medicare, and Medicaid.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams.
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Analyzed system performance and initiated process improvement measures for mainframe and Web-based applications.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Designed and developed Project document templates based on SDLC methodology
• Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
• Reviewed the Joint Requirement Documents JRD with the cross functional team to analyze the High Level Requirements.
• Implemented requirement gathering management using various methodologies.
• Been a part of Architecture and modeling team and have used SOA Service Oriented Architecture
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Worked with IT team to map sources and targets, populating the data warehouse, extracts and loads, monitoring the timing of loads, validating and testing the loaded data using ETL process.
• Analyzed the given source Dimensions and target Fact table structures to develop Surrogate Key tables referencing required dimensions.
• Assigned tasks among development team monitored and tracked progress of project following Agile methodology.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project.

Accomplishments

• Proposed and developed an internal tool for the QA department to detect the Parsing Errors in the

Processes/Jobs.

Environment Windows XP, Lotus Notes, MS Office 2010, MS Word ,MS Excel, Toad, SQL, Informatica Power Center 8.6, VSS,MS Visio, Agile, SDLC, MS Project, MS FrontPage 2003, MS Access, AS400

Confidential

Business Analyst

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Created the logical models and generated the physical models in the databases using Erwin.
• Worked with the IT team to develop service oriented architecture SOA , and data warehouse system to utilize data mining for data analysis.
• Managed the team of consultants responsible for developing on-demand Medicaid Management System reports.
• Facilitated JAR/JAD sessions with business and IT personals to understand and document the system requirements, and define the overall project scope.
• Defined, developed specs for federal reporting specific to Medicare Advantage
• Tested Performance Accuracy related queries under SQL Server.
• Created Graphical representation of reports such as Bar charts, Pie charts etc as per the End user requirements using Business Objects and Crystal reports.
• Analyzed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams according to UML methodology thus defining the Data Process Models.
• Responsible to import the data from Crystal reports by using Business Objects Live office into Microsoft Excel and Word.
• Conducted user interviews, gathered requirements and analyzed the requirements by using Visio.
• Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System
• Use Cases and other Process Flow Models were designed using MS Visio.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Involved in writing the detailed Test Plan using Mercury Quality Center, after analyzing business requirements and software/functional requirement artifacts.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process.

Environment: SDLC, UAT, Use Case, MS Visio, Agile, DB2/UDB Universal Database Oracle 8/9i, MS SQL Server 7.0, UNIX, Windows NT

Confidential

Business Analyst/Lead ETL Developer

Responsibilities:

• Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Responsible for writing Functional Requirement Specifications FRS and User Requirement Specification URS .
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams according to UML methodology thus defining the Data Process Models.
• Gathered requirements and modeled the data warehouse and the underlying transactional database.
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Strong understanding of Hospitality Industry concepts like Ships Inventory, Passenger Bookings, Reservations etc.
• Gained in-depth knowledge and experience in pricing, inventory, procurement, time attendance, barcode, EFT, credit cards, and handheld wireless technology in mainframe, client/server and web based environments.
• Used SoftTest software with pseudo code to ensure test cases covered all branches of project's code impacting the system. The system is an IBM mainframe based system that contains the master set of customer information used to bill customers.
• Defined Functional Test Cases, documented, executed test script.
• 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.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio.
• Developed the ETL jobs using ETL tool Informatica Power Center.
• Wrote Test Cases and performed User Acceptance Testing, documented the in detail defects using the Defect Tracking report.
• Used Test Case distribution and development reports to track the progress of test case planning, implementation and execution results.
• Carried out defect tracking using Clear Quest

Environment : SDLC, PL/SQL, HTML, MS Office, MS Visio, EDI, UML, Informatica Power Center 8.6, Oracle 9i, Lotus Notes