SUMMARY

• Over 7 years of extensive experience in Business Analysis / Project Management, Software Validation and business process re - engineering with proven ability to articulate business values.
• Functional experience with concentration on Use Case modeling using UML, Business Process Modeling, Data Modeling, Change Management, Technical Training, Software Development methodologies, QA testing, and Systems Testing of client server and web-based systems.
• Understanding of the AS-IS business processes and collected and maintained business and system requirements for the TO-BE system, created GAP analysis reports from “As-Is” and “To-Be” documents. Prepared Visio process diagrams, system architecture/feasibility studies.
• Data Warehousing Analysis: Understanding of Fact tables, Dimensions tables, Star schema and Snowflake schema, Data Analysis, Data Modeling, BI reporting, logical and physical models with specific reference to Informatica Enterprise.
• Expertise in generating and executing Ad-hoc Reports.
• Excellent communication skills to help facilitate requirements and communication between the client and the project team. Developed and conducted internal training programs for various applications. Developed, updated, and reviewed training documentation and course materials.
• Responsible for all aspects of metadata repository implementation project including formulating the requirements and ultimately the repository selection and installation. Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Extensive experience with Process Modeling using UML, Flow Charts, Task diagrams, Sequence diagrams, Activity diagrams and Use Cases.
• Strong project management skills including planning, scheduling, monitoring and budgeting with experience in requirements gathering, gap analysis, risk analysis, effort estimation etc.
• 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).Hands on experience with Statistical and Analytical tools like SAS.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Excellent Training skills, facilitation, power point presentations, maintaining performance metrics, devising training documentation & communicating to users.
• 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.

TECHNICAL SKILLS

Methodologies: RUP, UML. Full SDLC, Agile, waterfall

Project Management: Microsoft Project, Microsoft Office

Business Modeling Tools: Rational Rose, Microsoft Visio, EA, BPMN

Change Management Tools: Rational Requisite Pro, Clear Quest

Version Control Systems: Rational Clear Case

Testing Tools: Rational Enterprise Suite

Operating Systems: Windows Family, MAC OS, Unix and Linux

RDBMS and Databases: SQL Server, Sybase MS Access

Reporting: MS SQL Server Reporting Services, Crystal Reports

Programming Languages: SQL2008/2008R2, PL\SQL, .Net, Visual Basic, C, C++, VC++, Java, Perl, C#

Databases: Oracle10g,11i, MS SQL Server 2008R2/2008/2000, MS-Access

PROFESSIONAL EXPERIENCE

Confidential, WI

Business System Analyst

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Communicate with business users to capture their business needs which include requirements for data, reports, analysis, metadata, training, service levels, data quality, and performance.
• 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.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Worked with the Program Manager & stakeholders in developing the Business Plan, Initial Project scope document, financial projections, Business requirements document (BRD).
• Conducted walkthroughs of the BRD to obtain sign offs from the Business Stakeholders. This BRD was then the basis of Functional Specifications Document (FSD).
• Participated in Requirement Gathering Sessions (RGS), Joint Application Development (JAD) sessions and Joint Application Requirement (JAR) sessions and lead the effort to get Business and System requirements baseline (stakeholder approval).
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Worked with ETL Architects, Designer and Data modeler to ensure that the applications conform to customer requirements.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Created Mapping Documents, Report Mockups and modified existing report mockups as RTS (Return to Stock call List) requirements and finalized for development.
• Involved in data mapping activities and creating mapping templates of source and target mapping.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications, Data Mapping, and process flows.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.

ENVIRONMENT: TERADATA 12.0, SQL, Business Objects Reporting. 4.0, Oracle 11i.

Confidential, Deerfield - IL

Sr. Business Analyst

Responsibilities:

• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• 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.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle. Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Gathered all required data files from Legacy systems for comparison.
• Assisted the Project team in identifying data sources especially for the legacy systems.
• Worked as an Interface between the Users and the different teams involved in the application development for the better understanding of the Business and IT Processes.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Created Mapping Documents, Report Mockups and modified existing report mockups as to requirements and finalized for development
• Followed a structured approach to organize Requirements into logical groupings of essential Business Processes, Business Rules, and Information needs that insures any Critical Requirements are not missed
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Work closely with business users to capture their business needs which include requirements for data, reports, analysis, metadata, training, service levels, data quality, and performance.
• Defined the current clinical and financial business processes and practices.
• Created traceability matrix to ensure that the requirements are traced to the test cases.
• Worked closely with the project team in planning, coordinating and implemented QA methodology on various phases of the application and analyzed results of Regression Testing as performed by Testers using QTP.

Environment: Java, J2EE, UML, Rational Rose, Requisite Pro, MS Word, Excel, IBM Web sphere, PowerPoint, Zachman Framework, ClearCase, ClearQuest, Process Modeling, SAS EXCEL, Rational Clear Case.

Confidential, Mclean, VA

Business Analyst

Responsibilities:

• Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, according to UML methodology thus defining the Data Process Models.
• Directed the clinical trial data capture and worldwide data collection systems for various therapeutic areas. Used SAS ODS to create output files in different formats including PDF and RTF.
• Also extend the metadata to include new object based on the clients need.
• Performed the business requirements gathering by questioners, Interview business area experts, surveys and JAD sessions.
• Develop Technical specification, Use cases, data model etc.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Was responsible for indexing of the tables in that data warehouse.
• Developed business case, objectives, cost analysis and budget for implementation clinical and financial business systems. Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Heavily involved in writing requirements for the ETL process that would occur after data comparison from Legacy system in order to succeed with parallel testing.
• Coordinate with other organizations to obtain an automated monthly data feed, from an external system, which in turn is used to update Track Wise.
• 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.Involved in coding using Java created web pages using HTML, Java script.
• Wrote automated Test Scripts for Regression Testing using Win runner.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Created Mapping Documents, Report Mockups and modified existing report mockups as to requirements and finalized for development
• Provide technical expertise as an early engagement to different modules and enhancements to access impacts and define scope.
• Involved in set up of testing methodologies and improvement of process model.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• 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.

Environment: RUP, Rational RequisitePro, Rational Soda, Rational Rose, SAS BASE/MACROS, Rational Clear Case, Rational Clear quest, Java, J2EE, VISIO, Oracle 9, Sybase, UNIX, XML SPY, GOXML, LINUX, HTML, WINDOWS, MS Office.

Confidential

Business/Systems Analyst

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Identified internal and external system Requirements, design and configuration set-up.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Designed and developed Project document templates based on SDLC methodology.
• Developed Business Requirement Document as well as High-Level Project Plan. 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.
• Involved in projects including Enterprise Data Warehouse (EDW) infrastructure, Data acquisitions, Data migration, Business Objects executive dashboards, OLAP cubes, Data work flows documentation, Metadata repository management. Develop and maintain Portal leveraging Web Logic Portal Design, C, C++, Java and JavaScript.
• Conducted interviews with end-users to collect requirement and business process information.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Involved in Metadata meetings to insure one true source for all business rules and definitions are implemented throughout the organization.
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Conducted User Acceptance Testing (UAT).
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
• Environment: Microsoft Office Suite, Process Modeling, Microsoft Visio, Documentum, SAS, UML, Java, J2EE, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, PL/SQL, UNIX, VBScript, C#. NET.