SUMMARY

• Over 8 years of experience in the field of Information Systems with emphasis on Business Analysis, Healthcare Processes. Focused on Healthcare, Medicare, Medicaid and banking.
• Strong knowledge of SDLC methodology and project life cycle, Including Analysis, Design and Review of Business and Software Requirement Specifications.
• Excellent Business writing skills in writing Business Requirement Documents Specifications, Functional Specification documents.
• Extensive experience in managing project requirements, which includes requirement gathering, requirement rating/analysis and requirement priority assignment.
• Extensive Experience working on Data Modeling and Using Business Intelligence Tools like SSIS, Crystal Reports Joins, Update, Stored Procedures, Indexes, Reports, ETL.
• Extensive knowledge SDLC Processes like waterfall, Agile, Scrum, RUP Rapid Unified Process
• Gathered information using Brainstorming, SWOT Analysis, Questionnaires
• Extensive experience in gathering User and Business Requirements and creating Business Requirement documents BRD , Functional Requirements FRD ,Technical Requirement TRD , Logical Design, Change Request Process, Use Cases, Scope document, Contingency Plan
• Thorough understanding of Rational Suite including Rational Rose, Requisite Pro, Rational Clear Case, Rational Clear Quest and Object Oriented Analysis.
• Extensive experience with Unified Modelling Language and proficient in creating Use Case diagrams, Sequence Diagrams, Activity Diagrams.
• Experience working with Medicare and Medicaid insurance data and Insurance Claims.
• Expert with HIPAA 4010/5010 HL7 transactions such as 837, 835, 834, 278, 270 and 271. And Electronic Medical Records.
• Expertise on EDI transactions, ICD-9/ICD-10/CPT-4, HCPCS codes.
• Worked on various Line of business PPO, HMO, POS, Medicare and Medicaid claims.
• Knowledge of Object Oriented Analytical Design OOAD , Data Modeling and Mapping Design and implementation of RACI charts.
• Knowledge of project management tools, approaches, methodologies and processes that help implement the Change Management, Content Management and Configuration Management effectively.
• Experience in Conducting Joint Application Development JAD sessions, Elicitation sessions, workshops, interviews sessions with Subject Matter Experts SMEs / end users/development group/Client, asking detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.

Technical Skills:

Professional Experience

Confidential

Business Analyst

Roles Responsibilities:

• Documented Business Use Cases as well as System Use Cases.
• Gathered Requirements and documented the proposed additional extension to the existing HIPAA application.
• Performed functional gap analysis and system gap analysis.
• Facilitated several Joint Application Development JAD sessions
• Worked on HIPAA Transactions 270, 271, 276, 277,834, 835 and 997.
• Used MS Visio to create Use Cases and Sequence Diagrams.
• Worked on FACET claim processing system
• Accomplished experience through whole SDLC from requirement analysis till deployment using highly efficient Agile SCRUM process of Software development.
• Assisted development team to translate requirements into technical specifications.
• Performed data analysis and Data mapping from source system to target system
• Worked with the ETL development team to prepare data mapping from the source data base to target data base and also for reporting purposes.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Extensively analyzed XML's and documented business rules and Validations for XML documents.
• Created and Maintained the Requirement Traceability Matrix RTM .
• Initiated Test Plans, developed and executed test cases and scenarios, worked with users to develop Specific acceptance criteria and prepare test exhibits.
• Conducted User Acceptance Testing UAT sessions with business users and prepared document for enhancements and bug fixes.
• Used Test Director and HP Quality Center to report any bugs found and communicate to the developers and product support team.
• Analyzed and evaluated User Interface Designs, Technical Design Documents and Quality Assurance Test Condition the performance of the application from various dimensions.
• Extensive experience with preparing reports in the reporting phase of the project.

Environment: MS Visio, MS Project, Windows XP, HIPAA, HL7, Microsoft Office Suite, HP Quality center, Agile SCRUM,UML,ETL, Informatica 9.0.1,Crystal Reports.

Confidential

Business Analyst

Roles and Responsibilities:

• Conduct Business Requirements meetings with clients to identify and document business requirements.
• Prepare Project Requirements Document and Design Information Systems Business Solution.
• Actively Involved in Pre-Analysis of project with SME Subject Matter Experts , Developers.
• Created Business Requirements and converted them into System Requirement Specifications.
• Expertise in HIPAA, Phases of Clinical trials, Clinical trial designs, safety reports, adverse event management and reporting, Protocol designing and regulatory requirements.
• Studied and analyzed requirements to be achieved and brainstormed to gather effective requirements for a quality product. Generated various SQL queries whenever required and worked on the documentation of the databases.
• Created Functional Requirement Specification Document which included UML, Use case diagrams, Scenarios, activity, work Flow diagrams and data mapping, and Data modeling with MS VISIO.
• Created several prototypes using MS VISIO to show the representation of different screens involved in the tool.
• Performed Impact and Cost Benefit Analysis for Project. Creation and Maintain of Workflow Plans and Artifacts.
• Worked on the Documentation of databases like the SQL, Oracle and did the documentation for the Data Marts.
• Written complex SQL queries like Joins, Update, Stored Procedures, Indexes, Reports, and
• Through understanding of Rational Unifies Process RUP , Unified Modeling Language UML , and Rational Suite including Rational Rose, Requisite Pro, Rational Clear Case, Rational Clear Quest and Object Oriented Analysis.
• Assisted with user testing of systems, developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Proficient in creating Use Cases, Sequence Diagrams, Activity Diagrams.
• Worked on the Data warehouse for the requirement gathering and updated to the SharePoint.
• Created business rules, business vision document, business glossary and implementation up to functional and technical specifications.
• Participated in Design walk-through with end users to baseline the business architecture.
• Implemented Automation Testing using Quick Test Professional, Mercury Quality Center .
• Involved in preparing a simple and detailed User manual for the application, for an intended user.
• Developing and executing test cases Change Control requests CCRs and updating scope with new changes.
• As a Business Analyst involved in business requirements, analysis, design, project planning scheduling, creating UAT Test Plans / Test Cases. Developed Test Cases from Use Cases, reviewed Test Plans to ensure Use Cases accurately.
• Reflected Functional and User Interface testing.

Environment: RUP, UAT, GAD Gap Analysis Document , Microsoft Office Outlook, Word, Excel, Visio, Access , SharePoint, HIPAA, HTML, SQL, Mercury Quality Center.

Confidential

System Analyst

Roles and Responsibilities:

• Involved in business analysis and project management, coordinating between the team members, and was involved in Development Phase of SDLC to ensure valid business requirements.
• Held interactive sessions with various groups about patient care, including business owners, subject matter experts and marketing team, for effectively gathering requirements assuring that business objectives and priorities are aligned.
• Used Complex SQL queries and Data Modeling Techniques to work on the databases and to find out their dependencies.
• Effectively understand the clinical trial operations and business problems of the organizations and effectively gather requirements. Developed Process Model and detailed Business Policies ensuring HIPAA -guidelines.
• Expertise on various HL7 transactions, ICD-9 codes.
• Followed the Agile scrum methodology for the entire SDLC. Created full life-cycle documentation from product requirements in the developmental stage to functional specifications. Experience in developing BRD's.
• Created Use case scenarios according to business needs and specifications and Implemented UML methodologies to design Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Assure the Traceability of application functional, performance, and security requirements to the business process steps.
• Involvement in full life modeling using UML, MS Visio and MS Access , development, testing and deployment.
• Involved in the Data mapping and Data Modeling and documented the data architecture of the databases to escalate to the SME's.
• Performed Gap analysis designed new process flow, documented the business process, various business scenarios and activities of the business from the conceptual to procedural level.
• Performed Defect Tracking and Change Control Procedures using Rational Clear Quest, and Configuration Management and Version Control using Rational Clear Case.
• Produced and managed documentation on release activities to support problem resolution.
• Interacted with developers and various members of my team to discuss and resolve defects and their priorities.

Environment: Agile Scrum, Rational Clear Quest, HL7, MS-Visio, SQL, MS Word, MS PowerPoint, MS Access, MS Visio WSDL, Oracle, SOAP, BPEL, SharePoint, SSRS

Confidential

Business Analyst

Roles and Responsibilities:

• Played a key role in the planning, testing, and implementing system enhancements and conversions.
• Provided key project inputs by working with users in defining the project and system requirements.
• Reviewed business process, and functional requirements.
• Worked on Hospital data processing for improving database for storing user files.
• Analyzed business needs, created and developed new functionality to meet real time data integration that facilitated decision.
• Worked on functions such as Change Control and Request, and managed complaints to ensure customer satisfaction.
• Experience of managing multiple stakeholders across the organization, and in QA integration of systems.
• Involved in detailing project mission, data process flow diagrams, and timelines.
• Worked with SQL queries for data manipulations.
• Assisted in building a business analysis process model using Rational Rose, Requisite Pro and Visio.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams.
• Assisted in process modeling conducted and participated in JAD sessions with system users helped with design walkthroughs with stakeholders for base lining architecture.
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products and processes.
• Research operational procedures and methods and recommended procedures for improvement with an emphasis on automation and efficiency.
• Assisted Test Lead, Testers understanding business process and help them successful completion of Unit Testing, Integration Testing.

Environment: Oracle 9i, Rational Rose, Requisite Pro, MS Visio, RUP, MS Project, SQL, MS Access, MS Excel and MS Word.

Confidential

Informatica Developer

Responsibilities:

• Designer tools were used to design the source definition, target definition and transformations to build mappings.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target.
• Used Transformation Developer to create the joiner, filters, router, Expression and aggregation transformations that are used in mappings.
• Created Workflows, Dimensions, Facts Mappings.
• Taking the Backup of Repository on regular intervals depending on the amount of work done.

Environment: Informatica 7.1, Oracle 9i, SQL Server 2000/2005, SQL, PL/SQL, Erwin, UNIX.

Confidential

SQL Server Developer

Responsibilities:

• Participated in database logical and physical design to fit new business requirement and implemented new design.
• Created and implemented triggers in T-SQL to facilitate consistent data entry into the database and implemented stored procedures and cursors according to the requirement.
• Involved in upgrading the SQL server 2000 to SQL server 2005.
• Imported, standardized and validated data on a timely basis using DTS.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Created DTS packages for uploading of various different formats of files into SQL Server 2000 using data transformation services.
• Enhanced the existing packages and also created new DTS packages which executed stored procedures that would populate tables and perform other data manipulation tasks.
• Configured the DTS packages to run in periodic intervals.
• Querying of source and target database for unit testing.
• Involved in creating different types of reports such as sub reports, ad-hoc reports and chart by using crystal reports.
• Supported front-end applications under .Net framework.

Environment: SQL Server 2000/2005, SSIS, DTS, T-SQL, Active X, .Net, Crystal Reports 8.5, Windows 2003, Oracle 8i.