SUMMARY

• Experienced BA professional with 8 years proven abilities in leveraging technology to achieve business - driven objectives, manage competing priorities, solve complex problems, and define requirements to bridge the information gap between non-technical and technical staff.
• Team player, result-oriented, fast learner, excellent communication skills with strong research capability.
• Demonstrated strengths in process development and improvement, communications, and relationship.
• Customer-focused team player who thrives in dynamic, challenging work environments.
• Expertise in Business Systems Analysis and Requirements Management.
• Conduct data analysis using SQL & Excel as part of requirements analysis and to assist data quality teams.
• Designed and implemented complex SQL queries for QA testing and report/data validation.
• Understanding the Business Architecture and Business Processes of technology network like insurance, banking, finance, and investment industry.
• Provided data modeling support for numerous strategic application development projects.
• Strong business acumen, analytical, problem solving, interpersonal and presentation skills.
• Experience in mapping data elements for information exchange between two systems.
• Highly experienced with requirements gathering, planning, organizing, and Change Management.
• Involved in requirements verification as a SME and helped to produce all BA documentation as part of project requirement.
• Experience in all phases of software development life cycle (SDLC), including Requirement gathering and documentation, Use Case Documentation, FRD Specification, Business Case Study/Analysis, Quality Assurance/Testing.
• Experience in developing and writing functional business requirement, Scope documents, Gap analysis, Risk analysis documents,
• Experience in conducting JAD sessions for project definition involving analyzing requirements, creating prototypes and user interface.
• Experience in Business Process definition, Risk Analysis, Use case Analysis,
• Experience with Rational Tools including Rational Requisite Pro, Rational Rose.
• Extensive exposure to SDLC Methodologies like Rational Unified Process (RUP) methodology Agile, Waterfall, Spiral.
• Experienced in GAP Analysis, Traceability Matrices, SWOT Analysis and Cost Benefit Analysis.
• Experience with User Acceptance Testing (UAT), Unit Testing, application testing, integration testing, Black box testing.
• Strong knowledge of XML: XML coding, XML Schema and validation.
• Designed and implemented basic SQL queries for QA testing and report / data validation.
• Experience with MySQL or MS Access
• Developed Process flows, use case diagrams, class diagrams, sequence diagrams, collaboration diagrams, state diagrams and activity diagrams using UML to make users and developers understand the system.
• Worked on onsite-offshore business model.
• Worked with test teams to develop test scripts and ensure the testing results correspond to the business expectations.

TECHNICAL SKILLS

Methodologies: Software Development Life Cycle SDLC), Waterfall, AGILE, Rational Unified Process

Case Tools: Rational Rose 4.0, MS-VISIO

Tracking Tools: Rational Requisite Pro, Mercury’s Test Director

QA Tools: Mercury Test Director quality center

Databases: MS-Access 2.0, Oracle 8i, SQL Server 2000/2005/2008

Languages: SQL, PL/SQL, C, C++

Workflow Tools: MS-Project, MS-Excel, MS-Word, MS-PowerPoint, MS-Publisher

Operating Systems: Windows 2000/NT, XP, Suse Linux

PROFESSIONAL EXPERIENCE

Confidential, Marshall, MN

Senior Business Systems Analyst

Responsibilities:

• Participate in full-life cycle software development for the projects by performing requirements analysis and testing using development methodology.
• Develop implementation plans, produce user documentation and training materials.
• Designed and implemented complex SQL queries for QA Testing and Report / Data Validation.
• Documented functional requirements, including data mapping, data types, field length, translations and data transformations.
• Analysed and documented the business requirements and generated reports for the Stakeholders- Change Request.
• Responsible for providing business requirements within an AGILE software development SCRUM environment.
• Responsible for Write-Up and maintaining the Business Requirement Document (BRD).
• Created User Requirement Specifications (URS) and Functional Requirement Specifications (FRS) documents.
• Acted as a liaison between the business team and technical team and was instrumental in resolving conflicts between them.
• Performed complete and through testing for the entire software life cycle and across client server and web platforms, including version and change control.
• Utilized Cognos Report Studio and Query Studio to enhance and support client production reports.
• Prioritized all the reporting requests and ensured that the suite of Cognos reports meets customer requirements and enables management to optimize performance.
• Involved in testing and exploring tools using Cognos Query Studio and Report Studio.
• Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
• Creating detail design, work on development and perform code reviews.
• Analysis & implementation of better performance strategies.

Environment: Cognos, SQL, Rational Requisite Pro, Test Director, UML, Rational Suite, MS Visio. Extensive use of MS Project, Excel, Word, Power Point, SQL client, Agile.

Confidential, Chicago, IL

Business System Analyst

Responsibilities:

• Conducted user interviews and JAD sessions, with client and development teams for requirement gathering
• Developed the Use Case, Activity, Logical, Component and Deployment diagrams using MS Visio and Rational Rose for assisting the development team and to have a good understanding of the requirements.
• Involved in Data Warehousing, Project Coordination, Documentation and Agile Processing Development
• Worked on identifying claims, claim review, claim processing, and claim adjustments and addressing the processing problems
• Tracked both the outgoing/incoming claims test queries & responses.
• Involved in working with ICD9, Medicare, Medicaid, CPT, EDI transaction codes such as 270/271(inquire/response health care benefits), 276/277(Claim status), 470 benefit codes, 835(Payment/remittance advice).
• Developed and reviewed, Integration Test Plan for integration of modules by using Rational Test Manager
• FACETS was used in the project to enhance the system efficiency and provide business solutions
• Identified and managed risks/issues by conducting routine system maintenance checks to evaluate the performance
• Responsible for Code fixing and testing. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Extensively used SQL and PL/SQL to understand, implement and test the applications.
• Generated the reports using Crystal Reports
• Documented all the aspects of System Validation Life Cycle in accordance with the FDA regulations, particularly 21 CFR Part 11 including Validation Plan and Protocol
• Extensively used Quality Center for test planning and Used Rational Clear Quest for bug tracking and reporting.
• Involving in White-Box testing via manual and automation
• Responsible for doing functional, regression and system testing along with release testing\
• Created and Maintained Test Reports, Test Metrics & Test Data
• Responsible for creating test bed for the application with valid and invalid data covering all positive and negative test scenarios.
• Interacted with the development team to report bugs and discuss the status of bugs with open status or hold status.

Environment: Rational Requisite Pro, Rational Rose, RUP,UML, Oracle 8i, SQL, PL/SQL,MS Office, MS-Project, Windows 2000, Crystal Reports.

Confidential, Sioux Falls, SD

Business System Analyst

Responsibilities:

• Prepared the BRD (Business Requirement document), FRD (Functional requirement document) UCN (Use case narrative), Screen Specification details, GUI documentation for the project.
• Performed GAP analysis on the existing hierarchy, legacy mod calculator and proposed prototype
• Involved with the project from its inception phase to transition and production rollout phase. Updated and modified progress and resources allocation in MS project for the team.
• Responsible for creating tracking system for daily schedules.
• Have provided projects with pre-project planning expertise; high-level and detailed project definition, as well as acted as the primary liaison between IT and Business Partner(s) on a daily and project basis.
• Have followed project management principles to develop project plans in order to deliver the project product.
• Worked closely with the Business Partners and IT teams to mentor and share their specialized knowledge base.
• Have prepared Sitemap, Data model, and Screen Specifications for the Plan design application.
• Implemented the RUP methodology to help analyze the problem, understand user needs, and manage requirements.
• Have good experience of using MS Visio, Enterprise Architect, Rational Requisite Pro, Rational Clearquest and Rational Clearcase.
• Facilitated and managed meeting sessions with Business Users to review business requirement capture.
• Have set-up weekly status meeting and JAD Sessions with the Stakeholders and Business Users.
• Used SQL queries to extract data from different databases including testing and production for data validation and data analysis.
• Worked with the QA team for designing Test Plan and Test Cases for the User Acceptance testing (UAT).
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams using UML.
• Defects were tracked, reviewed, analyzed and reported using Quality Center.

Environment: Hyperion Dashboard Builder, SharePoint, MS Visio, MS SQL Server 2008, MS Project, Rational Clear Case and Rational Clear Quest, PHP, Flickr API, HTML, CSS, JavaScript

Confidential, Overland Park, KS

Business Analyst

Responsibilities:

• Collaborated with project manager in tracking and managing project development process following RUP based SDLC methodologies.
• Conducted Interviews, User Meetings, and JAD sessions to elicit the project requirements in successfully upgrading the existing with the new system.
• Collecting the project requirements from the client team and documenting them from perspective of technical team following the HIPAA guidelines
• Developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams using Rational Rose
• For helping the business team, a thorough research was conducted on Center for Medicare and Medicaid (CMS) website for formulating the business rules.
• Documented the Process Flow Diagrams and Business Use Cases for the EDI transactions 276/277 and executed them in Requisite Pro.
• Analyzed mandatory and situational fields and compared with the user manuals for EDI
• Involved in up-gradation of HIPAA X12 4010 transaction to HIPAA X12 5010
• Created, and maintained EDI Business Rules with strict adherence to HIPAA 5010 and ANSI ASCX12
• Provided Mapping for HIPAA code sets and EDI transaction processing
• Executed Gap Analysis to check the compatibility of the existing infrastructure with the new business requirements.
• Data mapping, logical data modeling, used SQL queries to filter data within the Oracle
• Assisted Project Manager in updating and maintaining project schedule, assigning project resources and monitoring deliverables using MS Project
• Helped manage risk analysis and mitigation plans, status reports; prepared business process models, defined milestone deliverables, and established critical success factors

Environment: RUP, MS Project, ANSI X12- EDI UML, Rational Requisite Pro, MS Word, MS Visio, SQL, MS Excel, Mercury Quality Center.

Confidential, Marietta, GA

Business Analyst

Responsibilities:

• Involved in reviewing Entity Relationship, Data Flow, State Transition and Class Diagrams with the Systems Analyst.
• Worked with upper management to enforce HIPAA regulations and guidelines
• Involved in Customer Relationship Management (CRM) as well as Vendor Selection and Management Process.
• Interacted and communicated clearly with development, testing and production teams concerning release management policies and procedures
• Liaison between the client and development team to support the client’s data analysis and reporting needs.
• Proficient in discussing and defining project, Gap Analysis with the clients from both a business and technical perspective
• Engaged in analyzing requirements, identifying various individual logical components, expressing the system design through UML diagrams
• Worked on Rational Rose to develop the use cases, class diagrams and sequence diagrams.
• Worked on Requirement Change Management System in Rational Requisite Pro.
• Setting up document hierarchy and standards to define different level of requirement using Rational Requisite Pro.
• Developed SQL queries to retrieve data from the databases.
• Manage Scope and change throughout the SDLC process of the product.

Environment: Agile, UML, Clear Case 4.2, Clear Quest 6.0, HTML, Crystal Reports, SQL, MS Office, MS Visio, VCM Tool.

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

• Conducted user interviews and JAD sessions, with client and development teams for requirement gathering
• Developed Use Case, Activity, Logical, Component and Deployment diagrams using MS Visio and Rational Rose for assisting the development team and to have a good understanding of the requirements.
• Involved in Data Warehousing, Project Coordination, Documentation and Agile Processing Development
• Worked on identifying claims, claim review, claim processing, and claim adjustments and addressing the processing problems
• Tracked both the outgoing/incoming claims test queries & responses.
• Developed and reviewed, Integration Test Plan for integration of modules by using Rational Test Manager
• FACETS was used in the project to enhance the system efficiency and provide business solutions
• Identified and managed risks/issues by conducting routine system maintenance checks to evaluate the performance
• Generated the reports using Crystal Reports
• Documented all the aspects of System Validation Life Cycle in accordance with the FDA regulations.

Environment: Rational Requisite Pro, Rational Rose, RUP,UML, Oracle 8i, SQL, PL/SQL,MS Office, MS-Project, Windows 2000, Crystal Reports.

Confidential

Jr. Business Analyst

Responsibilities:

• Gathered requirements from Business Partners/SMEs.
• Conducted Joint Application Development (JAD) sessions with stakeholders.
• Conducted Impact and GAP analysis on the business requirement.
• Involved in walkthroughs and meetings with development team to discuss related issues.
• Involved in the creation and maintenance of the Workflow plans and artifacts.
• Conducted reverse engineering of the existing vendor system (OBTM) and developed the solution in-house for better integration with existing chase systems.
• Modified existing workflow to accommodate change request from the client.
• Updated Impact and Trace Matrix.
• Using information gathered from the stakeholders; produced various artifacts such as use-case specifications, software requirements specifications, screen mock-ups, workflow, functional specification documents, use case diagrams and activity diagrams as per JPMC SDLC methodology
• Maintained ongoing communication with back-end developers ensuring that modifications and requirements were addressed in a time manner and monitored all revisions.
• Participated in functional and technical reviews.
• Worked with QA team to design test strategy and test cases for User Acceptance Testing (UAT).
• Liaise with technical, project management, SME, client teams and other Business Analysts spread across globally to assist in the development, testing and deployment of application.

Environment: UML, Use Case Analysis, MS Visio, Enterprise Architect, MS Office.