SUMMARY:

• Over 7 years of extensive experience as Senior Business Analysis, Software Validation, Laboratory Information Management Systems (LIMS) and business process re - engineering. Good experience working with Clinical Trials Databases Crystal reports and Dashboards also administered BusinessObjects.
• Excellent experience in Analysis, Design, development, implementation and support of Business Intelligence Applications using Business Objects Enterprise
• years of data warehousing experience. Developed many complex Universes based on these concepts
• Expertise of working with Xcelcius, Web Intelligence, Desktop Intelligence, Universe Designer, Business View manager, Crystal Reports, Import Wizard, Central management Console (CMC), Central Configuration manager, Bi Launch pad, Information design tool, QaaWS, Live Office, BI Web Services for Xcelcius, XML for Xcelcius, Flash variable
• Extensive experience in creating Functional Specifications, UI specifications and UI prototypes.
• Strong project management skills including planning, scheduling, monitoring and budgeting with experience in requirement gathering, gap analysis, risk analysis, effort estimation etc.
• Different software development environments including Agile- and Waterfall models. 
• Knowledge of FDA 21 CFR Part 11, 210, 211, 820 and ISO 13485 for medical and pharmaceutical industries. 
• Strong Business Analysis Skills including In depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing and Practical knowledge of Rational Unified Process (RUP).
• Extensive Knowledge of Systems Management, Design and Data Modeling.
• Created reports from SAP modules using Business Objects / Crystal Reports based upon business requirements.
• Excellent business writing skills in writing Preliminary Investigation Report, System Requirements document, Systems Design Specification and System Requirement Change Request.
• Excellent Training skills, facilitation, power point presentations, maintaining performance metrics, devising training documentation & communicating to users.
• Strong understanding of information technology capabilities and dependencies, including platforms, content management, e-document strategies and process mapping.
• Demonstrated high capacity to learn new technologies rapidly with no formal training.
• Proficient at creating and transforming business requirements into software requirement specification (SRS) using Rational RequisitePro and designing business models using UML diagrams such as use case model, Class Diagrams, Activity Diagrams, Sequence Diagrams and Collaboration Diagrams in Rational Rose and MS Visio.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
• Expert in Root Cause Analysis, Feasibility studies and Risk Assessment studies.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities

SOFTWARE/ENVIRONMENT:

Methodologies: SDLC, RUP, UML, CMM, Agile, SIX SIGMA, JAD

Testing Tools: WinRunner, LoadRunner, Test Director and Quality Center

Change Management Tools: Rational Clear Quest, PVCS, Clear Case

Business Modeling Tools: Rational Rose, Microsoft Visio for UML and ER diagrams

Programming Language: C, C++, Visual Basic, JAVA, SQL, PL\SQL, VB.NET,ASP.NET

Project Management: Microsoft Project, Microsoft Office (2010)

Applications: MS Office Suite, Lotus Notes

Databases/Query Tools: Oracle 8i/9i, MS SQL Server, MS-Access, DB Visualiser, OBIEE, SQL*LIMS, LabWare LIMS, Qumas and Web LIMS

Reporting/Documentation Tools: Crystal Reports, Rational SoDA / MS Word, Adobe Acrobat SAP

Web Technologies: HTML, XML, ASP, JavaScript, MS Front Page and Dream weaver 2004

Requirement Gathering Tools: Requisite Pro

PROFESSIONAL EXPERIENCE:

Mason, OH

Sr. Business Objects Developer

Responsibilities:

• Managed multiple Business Intelligence projects through all SDLC phases, involving technical and functional expertise. Written Complex SQL queries to retrieve the required information.
• Involved in testing universes and reports for correct mapping of the objects and data correctness.
• Involved in creating dashboards for graphical presentation, Created resource plans, programming specifications, testing and validation procedures, Acted as Data Lead and Liaison between ERP projects and value center data.
• Developed Xcelsius presentations/visualizations for customer trend analysis, profitability of products and services, member satisfaction, loan and mortgage rates, and call center performance.
• Worked closely with the project leadership team to document schedules, resource requirements, business requirements, test strategy, and plans for data migration, Involved in migration of reports from BO 6.5 to BO XIR3, Migrated universes, reports and security domain from 6.5 to BO XIR3 Using Import Wizard, Resolved several issues with installation, designing, reporting and migration
• Produced technical document and user manual for migration from one built to another built of Business Object, Identified skills needed, mapped resources to skills and provided training for BO migration, Converted Deski (Desktop Intelligence) reports to Webi (Web Intelligence) reports using Report Conversion Tool, Used Crystal Report XI Enterprise to design the front end reports.
• Worked on group expert, select expert, sort expert, section expert for different report formatting activities for crystal reports, developed and formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built in/custom functions
• Created Business ObjectsWeb Intelligence&Desktop Intelligence reports and published on the INFOVIEW, Involved in migration and deployment of the universes and reports across multiple repositories, Published report to Enterprise server, to get the report access from INFOVIEW
• Environment: BI4.0,BI3.1, BO XIR3,BO 6.5, UDT, IDT, BILaunchpad, Infoview, dashboards, Webi, Deski, Import Wizard, Crystal Report XI, Windows.

Environment: BI4.0,BI3.1, BO XIR3,BO 6.5, UDT, IDT, BILaunchpad, Infoview, dashboards, Webi, Deski, Import Wizard, Crystal Report XI, Windows.

Henderson, Nevada

Business Analyst 

Responsibilities:

• Led the development of team information resource organization
• Led the development and implementation of team support strategies
• Led in interview screening and evaluation of numerous applicants for various Clinical IT and IT related positions in the organization
• Conducting Joint Application Development (JAD) sessions, IDBS, mapping data, data modeling, Project meetings, reviews and customer interviews and as a Scrum Master with excellent interpersonal skills
• Managed the planning and requirements phase for the implementation of a Laboratory Information Management System (LIMS)
• Performed Requirement Gathering & Analysis by actively soliciting, analysing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
• Identified opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements.
• Analyzed, designed and successfully completed the full product development life cycle of a high visibility, high throughput screening Laboratory Information Management System (LIMS). 
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Conduct Interface testing with SAP and Biztalk. 
• 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.
• Developed the project plan with assistance from the management, and included provisions for project scope changes and issues and initiated efforts to make improvements.
• Conducted project kick off meetings with team members to explain roles / responsibilities, relationships with other groups, deliverables, timelines, assignments and status reporting.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created GUI specifications with Page flows, page business actions and screen mockups
• Created RUP activity diagrams and sequence diagrams to analyse the requirements and recommend solutions.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Prepared scenarios, Use Cases & UML State Diagram for scenarios using Rational Rose.
• Prepare presentation slides in MS Project, which was extensively used in different JAD sessions and to track progress.
• Assisted the technical team in translating application functionality into application architecture.
• Participated in the bug review meetings, updated requirement document as per business user feedback and changes in the functionality of the application.
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
• Wrote test scripts for User Acceptance Testing (UAT).

Environment: Rational Suite (Rose, Requisite Pro), Dreamweaver, SQL, VB.Net, Rational Unified Process (RUP), Windows NT/XP/2000, UML, UNIX, MS-Project, MS-Office Suite, Casewise Corporate Modeller, WinRunner, Test Director

Jersey City, NJ

Business Analyst 

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Extensively involved in data modeling
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Led the development effort that designed and implemented a Laboratory Information System (LIMS) for collecting Return Analysis data.
• Created use cases to determine requirements of the proposed LIMS application configuration.
• Document systems and processes, provide user training and support for LIMS application configuration systems.
• Worked with HIPAA Team, IDBS Biobook for RIMS Companion Guide of X 12 ANSI 27 0/ 271 and 27 6/277 Companion guides for Professional and Dental claims.
• Perform Gap Analysis of the processes to identify and validate requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Evaluated and compared different potential solutions for laboratory data management, includingIDBS BioBook, Agilent OpenLAB, IBMS iSCORE, etc.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on AGILE methodology.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Organize requirements into high level Use Cases and low level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Utilized corporation developed Agile SDLC methodology. Used Version one and Microsoft Office software to perform required job functions. 
• Implemented SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Designed Functional Specification Documents for the reports.
• Coordinate and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Review the Test Plan developed by the testing team for testing the application.
• Assist the QA personnel in the creation of Test Cases using Rational Test Manager.
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.

Environment: Windows XP, Business Objects, Zachman Framework, MS Excel, Word, Casewise Corporate Modeller, power point, SQL, PL/SQl, DB2, SAS database

San Diego, CA

Business Analyst

Responsibilities:

• Directed the clinical trial data capture and worldwide data collection systems for various therapeutic areas.
• Analyzed, designed and successfully completed the full product development life cycle of a high visibility, high throughput screening Laboratory Information Management System (LIMS). 
• Perform Risk Assessment on processes within laboratory systems to determine the associated risk in each process and conduct Risk Analysis to determine level of control and testing over regulated activities
• Created use cases to determine requirements of the proposed LIMS application configuration solution.
• Author Standard Operating Procedures (SOP) required satisfying Computer Validation and 21 CFR Part 11 requirements.
• Documented all aspects of the computer system validation lifecycle, in accordance with FDA regulation which includes validation plan and protocol, Installation Qualification (IQ), Operational Qualification (OQ) and specification performance
• Analyze business requirements for new system requests, system upgrades, and system replacements to ensure compatibility with IT security policies and HIPAA standards.
• Work closely with Business Owners and Stakeholders to outline Business Requirements.
• Work with System analyst and IS teams to understand the flow of data.
• Reviewed and analyzed data from various sources.
• Participated as a core team member of a Clinical Development initiative to create an architectural business end-to-end solution for clinical trials as a standard for all Merck remote data capturing clinical trials.
• Documented Requirements for Management Reporting out of Clear Quest using Crystal Reports.
• Identified gaps and performed gap analysis with respect to CMS requirements
• Created Mapping Documents, Report Mockups and modified existing report mockups as to CMS requirements and finalized for development
• Used Silk Center to manage requirements and test plan and test cases
• Responsible writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Mercury Interactive such as test Director, Winrunner.
• Provide technical expertise as an early engagement to different modules and enhancements to access impacts and define scope.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Formulated logical statements of business requirements researched and evaluated alternative solutions and recommend the most efficient solution for system design.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Work with Compliance and Regulatory operations to follow and monitor different IT process bound by CMS Regulations.

Environment: Rational Suite (Rose, Requisite Pro), Dreamweaver, SQL, VB.Net, Rational Unified Process (RUP), Windows NT/XP/2000, UML, UNIX, MS-Project, MS-Office Suite, Casewise Corporate Modeller, WinRunner, Test Director