Professional Achievements

Business Analyst /Data Analyst with 7 years IT experience in all phases of an SDLC project with a primary focus on analysis, product implementations, and system-integration/migration and process improvement. An effective communicator, excellent team player, quick learner and creative problem solver with finely tuned analytical skills and significant hands-on experience in Mortgage, healthcare, Banking and Financial industries.

Professional Summary

• Experience working in all phases of Software Development Life Cycle SDLC , using Project Management concepts involving Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting, Reporting and Drafting remedy procedures.
• Excellent ability to analyze research and test on Oracle, SQL Server and SAS.
• Strong Knowledge of SDLC, RUP, Agile and Waterfall methodology, project life cycle.
• Expertise in writing Business Requirements Document BRD , Functional Requirement Document FRD , Non-Functional Specification Document, System Design Specification, Use Case, Screen mockups and training manuals.
• Experience in ETL Informatica and data modeling
• Experience with Data Analysis/Data Mapping on Data warehouse system for various reporting systems within an organization.
• Experience in Data Transformation, Data Loading, Modeling and Performance Tuning.
• Good understanding of relational database concepts and client server concepts
• Experience in data validation in RDBMS by writing SQL Queries.
• Proficient in SQL, Scrum and Agile methodology
• Extensive use and knowledge of MS-Excel features and tools like lookup functions, referencing, conditional formatting, data analysis, data filtering, creating pivot tables and charts, macro and form functionalities for reporting and connection to MS-Access database for data extraction
• Experience with Data Analysis using Oracle as a backend and TOAD as the querying interface
• Experience in SQL, DML, DDL, writing complex SQL and testing scripts for data validation against relational Databases including Data warehouse systems.
• Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams and document them using Microsoft Visio and Rational Rose.
• Experience in conducting User Acceptance Testing UAT , SWOT analysis, Cost Benefit analysis, GAP analysis, Risk Analysis and ROI analysis.
• Expertise in writing test plans, Test cases, test scripts, test data, test checklist and RTM .
• Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.
• Advance level expertise in MS Office tools such as Excel, Word, PowerPoint, Visio, Doors, Requisite Pro

Tools Environment

Professional Experience

Business analyst

• Description: CONFIDENTIAL provides RCM technology solutions and consulting services to cover the full spectrum of providers' revenue cycle needs from patient access to claims denials.
• Project I Contract Manager is a Web-based revenue management solution designed to help hospitals and healthcare systems accurately forecast, calculate, and capture net revenue owed to them. The Project included redesigning the 10 years old Contract Loading Web Application based on legacy platform , into .NET platform, enhancing the UI, Functionality and Compatibility.
• Project II ICD9-ICD10 conversion with aspect of the CM product suite to be able to support and recognize new ICD 10 codes from claim file, UB 40, and HIPPA 5010.

Responsibilities

• Participated for the creation of Business Process Workflow Diagrams with Stakeholders involved throughout the business solution Development Life Cycle SDLC AGILE.
• Conducted meetings with business users and SMEs to identify and gather various functional and non-functional requirements.
• Conducted User Design Studio, for functional requirement gathering purposes, creating Mock Up for the new UI, and translating requirements into User Stories and Epics.
• Conducted PPT, and presented the product owner and executive with outcomes and several options.
• Created other artifacts such as BRD, Use Cases, Activity Diagrams, and Sequence Diagrams to supplement the development process and to reduce error and misrepresentation of requirements and User Stories.
• Participated in daily SCRUM stand-ups and assisted Scrum master and development team, in conducting Iteration planning meeting and sizing User stories for the release.
• Process Reengineering by creating Business Process Analysis, Flow Charts, of individual major functionalities, support and work around gathers from users, to conduct GAP analysis.
• Worked closely with QA, to develop test cases, and involve in other testing, before approving it for release.
• Conducted UAT for version release and gathered feedback.
• Explored and analyzed every aspect of data table loading and service type loading for CM to understand the need to support new ICD 10 codes.
• Worked with cross functional department as Government Programs, and Common platform, to discuss and raise any issues that changes in CM suite might cause in other depended products.
• Worked very closely with SCRUM master, and Development team, with ownership mentality and made sure the User Stories were coded, tested, documented and ready for release.

Environment: Rally, Primavera, Query Analyzer, SQL, .NET,HTML, Legacy, MS Visio, HPQC, Agile /Scrum, MS-access ,Requisite PRO, Lucid chart Macintosh OS mock up

CONFIDENTIAL

Business Analyst

Description: The project was web based application upgrade to the existing desktop application to Cloud Net. I worked on the MPCI application process.

Responsibilities

• Gathered, analyzed business and functional requirements and documented for full understanding of the business.
• Worked in multi-environment facilitating development of web-based User Interface that supported various departments
• Primary liaison between the various Business Units, Agent Licensing, Marketing, Commissions, Policyholder Services Department and the IT development team
• Actively involved in conducting reviews, walkthroughs and facilitating in requirement definition workshops JAD to confirm business requirements for the project
• Designed Workflows and participated in the creation of Use Case models and the writing of corresponding Use Cases
• Created Use Case diagrams, Class Diagrams and Sequence Diagrams using Visio to help development teams visualize the functional requirements
• Performed Gap Analysis between Legacy System and writing queries in MS Access and Oracle Database
• Designed Interface Documents and Conversion Mapping Documents
• Documented As-Is and To-Be Business Processes in alignment with the Business Process strategy
• Identified potential areas of automation and reengineered underlying Business Process
• Documented and implemented SOX 404 Controls for information security
• Conducted Training Sessions for Testing Team and Business User's involved in UAT and coordinated UAT effort before Production Roll-out
• Maintaining Traceability Matrices for monitoring project success
• Lead the Defect Review and Process Review Meetings to ensure software quality and discuss the areas of improvement
• Created Mock Up screens using MS Visio for better visualization and understanding of the software application.

Environment: Windows, .NET, MS Office, MS Visio, MS Project, SQL Server and Oracle, RUP SDLC, IBM requisite PRO.

CONFIDENTIAL

Business Analyst

• Description: CONFIDENTIAL is the largest Commonwealth secretariat with jurisdiction over 16 agencies including oversight of the Medicaid programCONFIDENTIAL Care Finance and Policy, and responsible for nearly half of the Commonwealth's 28 billion budget and a major purchaser and regulator of healthcare.
• The MMIS Conversion project where team was responsible for converting approximately 4.5 years of HSN Paid Claims History, which included Institutional and Professional Medical 837I 837P claims with valid Member IDs, SSN or ZZ ID legacy with a single match within MMIS. Efforts in the conversion will include a detailed analysis of the data and data structures to be converted. The Gap Analysis document was prepared while mapping HSN and MMIS's data. Also BA highly involved in testing the transformed data.

Responsibilities

• Worked with a cross functional and diverse team of business users and developers to enable accurate communication of requirements and ensure consensus.
• Engaged in Gap Analysis with the clients from both a business and technical perspective
• Created the Functional Requirement Document from the Business Requirements Document which was used as the reference by the development team while preparing the design and held the responsibility of the required data setup.
• Proficient in discussing and defining project, Gap Analysis with the clients from both a business and technical perspective
• Testing - Developed Test Cases, Test Scripts and coordinated with developers to quickly resolve the defects associated with them
• Ensured that project/requirement s are properly tracked and documented as per Project Managers needs
• Responsible for addressing, diagnosing, and resolving issues that arise on a day to day basis for the team. Also responsible for documenting the causes, analysis and final resolution to the issues/errors.
• Developed detailed auditing and reporting of the current status and history of all components related to the project.
• Validated the source field of a particular claim with the Mapping document.
• Handling different production issues as a single point of contract SPOC
• Worked with Internal and External Users to define requirements and coordinated user management and developer expectations.
• Documented the UAT Plan for the project and worked with the UAT Team to ensure every acceptance criteria for the requirements has been included in the UAT task plan.

Environment: Share Point, Quality Center, MS Word, MS Visio, MS Project, MS Excel, MS PowerPoint, XCELYS, SQL

CONFIDENTIAL

Business Analyst

Description: The project was web based application upgrade to the existing web product used by CONFIDENTIAL customer to integrate various features that would give the customers consolidated view for e-portfolio management online collaboration system. Also I worked on the implementation of the e-portfolio / Finance reporting system which was migrated from the legacy system. I performed both Business Analysis and Data Analysis for the e-portfolio consolidation.

Responsibilities

• Prepared Business Requirement Document BRD and Functional Requirement Document FRD
• Translated business requirements into BRD, Workflow and Use Cases.
• Performed UAT testing for various reports created from the data marts.
• Used DOORS to link requirements to test cases, business rules, and design items to maintain traceability
• Gained formal acceptance of the project in the project closing phase.
• Assured all artifacts/signoffs were in compliance with corporate policies and guidelines and archived.
• Worked on creating the business requirements for Data Migration from Legacy system to new MSSQL database.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams using UML
• Provided high level of data analysis and insights using business intelligence tools such as Cognos Business Objects.
• Creating Data Mapping Documents and Source to Target Transformation document.
• Created Mock Up screens using MS Visio for better visualization and understanding of the software application.
• Interacted with the business and operation groups in the international correspondent payments and trade areas.
• Techniques Initiation, Planning, Execution, Control and Monitoring and Closing.
• Developed project scope, schedules, timelines, status, system schematics and process work flows.
• Responsible for requirements generation and analysis using Requisite Pro
• Documented business need, assumptions constraints
• Conducted individual and group Joint Application Discussion JAD session with business and technical units.
• Assisted with test plans, test case and performance testing, and conducted UAT facilitated discussion between business team and QA team on determine the test requirements and pass/fail criteria.

Environment: Windows, .NET,C , Business Intelligence, Crystal Reports, MS Office, MS Visio, MS Project, Rational Tools, SQL Server.

CONFIDENTIAL

Business Analyst Automation of Mortgage based loan system

Responsibilities

• Served as a liaison between mortgage specialists and the project team.
• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose UML .
• Prepared Functional Specification Documentation FSD and communicated these to the stakeholders.
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Conducted Business Requirements, Functional and Technical meetings with Business groups.
• Used MS Visio for Process modelling and Business Process flow diagrams.
• Extensively involved in regression testing during various phases of the application.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Troubleshot the designed jobs using the Data Stage Debugger.
• Tuned Data Stage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Environment: Rational Rose, Rational Req Pro, RUP, Win Runner, Load Runner, MSOffice2003

CONFIDENTIAL

Business Analyst

Description: The project was based on credit appraisal system re-engineering focused on enhancing the functionality of the current system. The existing system required manual processing of all transactions, did not offer electronic approval to end-customers, and could not support the array of credit applications that were submitted for processing. This resulted in decreased efficiency and impacted the overall quality of service provided. The credit appraisal system re-engineering IT solutions were incorporated to bridge existing gaps, increase effectiveness, and help facilitate better system usability.

Responsibilities:

• Worked extensively with the team in agile environment from project initiation phase to post production.
• Communicated Project Requirements, Business Issues, Solutions and made recommendations.
• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from the user perspective.
• Gathered requirements by interacting with the stakeholders, interviewing, preparing questionnaires and getting feedback.
• Responsible for defining the scope of the project, gathering business requirements.
• Performed GAP analyses and documented them textually or within models.
• Involved in creating functional specification documents for the design, development and implementation of the project.
• Analyzed and documented Business requirements and detail design of the software for full understanding of the business.
• Involved in gathering and documenting business requirements and translating them into technical solutions
• Used Requisite Pro to document requirements and associated change requests with requirements.
• Involved in creating the Use Cases Diagrams, flow charts and process models using Rational Rose.
• Provided in-depth consulting to clients, IT management and IT staffs in the identification.
• Worked with Subject Matter Experts SMEs to identify high level requirements related to the Credit Card processes
• Documented business workflows textually as well as in Activity diagrams according to RUP for the stakeholder review.
• Conducted JAD sessions to bring the Business and Development teams on to the same page
• Performed Data validation by writing SQL queries using TOAD against the SQL Server database.
• Involved in maintaining and managing different versions of Documents using Rational Clear Case.

Environment: RUP, Rational Requisite Pro, Rational Rose, MS Visio, MS SQL Server.