SUMMARY:

• A result oriented Business Analyst having more than 7+ years of experience in the Pharmaceutical Industry with extensive requirement gathering for custom solution in the cross functional areas like pre - clinical, clinical and pharmaceutical.
• Professional experience in Business Analysis, Software Development Life Cycle: System Analysis, Design, Development, Testing, and Implementation on Business Systems.
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
• Strong experience in Requirements elicitation techniques - conducting user interviews, document analysis, JAD sessions and managing the requirements.
• Highly experienced in pharmacy benefit management portion like claims processing and payer information.
• Worked on Clinical Trials to conduct global clinical trials and manage the large volumes of data generated.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
• Extensive experience with validation of pharmaceutical software for compliance with the FDA standards.
• Have referred to the 21 CFR Part 11 for the company’s compliance with the FDA requirements for electronic records and electronic signatures.
• Experience in Clinical Data Management and Clinical Trial Management.
• Created design documents like data flow diagrams, process flow charts using MS VISIO and UML.
• Strong Object Oriented Analysis and Design using UML, Rational Unified Process, RATIONAL ROSE.
• Comprehensive experience in writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Mercury Interactive such as TEST DIRECTOR, WINRUNNER.
• Actively involved in developing, executing and managing User Acceptance Testing (UAT).
• Built strong relationships with clients and demonstrated commitment to delivery.
• Strong communication, business understanding, critical thinking and analytical skills.
• Highly motivated, organized and target oriented team player who enjoys working with multi-functional team towards a common goal.

TECHNICAL SKILLS:

Databases: MS ACCESS, MS SQL SERVER

Methodologies: RATIONAL UNIFIED PROCESS, OOAD, UNIFIED MODELING LANGUAGE

Modeling Tools: RATIONAL ROSE, ERWIN 4.0, CRYSTAL REPORTS, MS VISIO

Testing Tools: MERCURY WINRUNNER 7.0, TEXTDIRECTOR 6.0

Operating Systems: WINDOWS 98/2000/ME/XP, WINDOWS NT, UNIX

Office Tools: MS WORD, MS EXCEL, MS POWERPOINT, MS PROJECT 2002/2003

EXPERIENCE:

Confidential, West Hills

Business Analyst

Responsibilities:

• Conducted group and one-to-one interviews and gathered preliminary requirements following Waterfall methodology.
• Performed GAP Analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system and generated workflows.
• Used Prototyping method to gather additional requirements from the users in order to describe the business needs in terms of the system being created.
• Involved in creating business requirements document and functional requirements document.
• Have a good understanding of SQL queries.
• Designed and developed the Test plan and Test case documents.
• Participated in various testing related review meetings to analyze defects.
• Closely worked with Users and Technical team in managing and handling User requested Changes and User Conflicts.
• Communicated Business Users to identify needs, define project scope, and detail functional and non-functional requirements.
• Gathered and analyzed business requirements by facilitating JAD Sessions, Focus Groups.
• Successfully used Waterfall model, gathered requirements and facilitated use case workshops in sessions.
• Worked as a liaison between the IT and Business team. Was instrumental in providing the issue resolution to the IT team by working closely with the business.
• Successfully developed UAT strategy and worked with the users during UAT.
• Fixed issues /defects rose during UAT by working with the IT team.
• Excellent understanding of the PBM Networks model and claims processing.

Environment: MS Visio, MS Project, MS Office Suite, Windows 2000/XP, Waterfall SDLC, Mainframe, MS Access 2003.

Confidential, New Haven, CT

Business Analyst

Responsibilities:

• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Wrote Business Requirements, analyzed them and tested them.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Designed report templates based on the requests by account managers.
• Interface captured project and work order information residing on the IMS data base and built transactions to insert the data into a Datacomm/DB database under CICS.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Designed Functional Specification Documents for the reports.
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Conducted RAD sessions for the report users, requestors, and the developers.
• Used MS Project to manage project time lines
• Managed 21 CFR Part 11 validation activities for clinical trial and development laboratory information systems.
• Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
• Documented all the changes in the initial templates and was responsible for Release Management.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Coordinated with the developer, on day-to-day basis, during the development process.
• Created Test Scripts & Test Scenarios to check report content, layout, and parameters.
• Worked on Report Re-engineering Project and made enhancements to the system flow.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Worked with ETL team during the upload process.
• Helped with Data Mapping between the data mart and the Source Systems.
• Worked with SQL queries using MS Access for data manipulations.
• Enhanced communication lines between executives, managers, and peers.

Environment: Windows XP Professional, Enterprise Architect, PL/SQL, MS Access 2000, Data Stage, MS Excel, MS Project, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS Office suite, MS Visio 2003

Confidential, Cambridge, MA

Business Analyst

Responsibilities:

• Analyzed user requirement documents (URD), software requirement specification document (SRS) and prepared System test plan by dividing the application into manageable units.
• Involved in Annotating CRF’s, Creating Database Specifications based on Database Structures provided by the client and writing Conversion Programs by extracting Oracle Clinical data.
• Generated Reports on AE and SAE as a part of clinical data management process.
• Developed, implemented and executed test methodologies and plans to ensure software product quality as per the RUP methodology. Test some of the Extensions in Facets application manually.
• Developed reports based on the Clinical Trial protocol
• Perform Gap Analysis of the processes to identify and validate requirements.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Executed and scheduled tasks; batch processing, metadata management and data mapping.
• Prepared spreadsheets with the help of MS Office to show like specific geographic regions etc.
• Conducted several demos driven by MS PowerPoint Presentations.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Involved with the business users, developers to make sure the reports were developed right to the specification.
• Was responsible for indexing of the tables in that data warehouse.
• Documented existing applications with the creation of UML sequence diagram and class diagram to document.
• Involved in creating use case diagrams for the purpose of the team to understand the workflow of the system.
• Involved in the User Acceptance Testing to make sure the defects raised by the business users were resolved up to the Management Expectation by the developer group. Prepared documentation using MS Word.
• Created reports in MS Word for account processing of each client group.
• Worked with the quality assurance group through out the company identifying the major changes with the greatest opportunity for cost reduction. Involved in generating Test Plans, Test Scripts and Test Cases manually in MS Excel.

Environment: Oracle, Windows, Pl/SQL, Rational Enterprise suite, Enterprise Architect, RUP, UML, COBOL, Data Stage, Microsoft Word, Excel, Visio, MS Project.

Confidential, Worcester, MA

Business Analyst

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Conducted user interviews and documented business and functional requirements.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Created use case scenarios and documented work flow and business process using Rational Rose
• Involved in project management using MS Project
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Used Rational Clear case for version control
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Used Rational clear quest for defect management

Environment: SDLC, UML, User Count Tool, Rational Tools Suite, WMB, MS Project, MS Office, Windows XP, SQL.