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.
• Good experience working with Clinical Trials Databases.
• 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.
• In depth knowledge Rational Unified Process RUP methodology, Use Cases, Software Development Life Cycle SDLC processes, Object Oriented Analysis and Design OOA/D .
• Responsible for all aspects of metadata repository implementation project including formulating the requirements, creating the Request for Proposal, evaluating the vendors products, and ultimately the repository selection and installation. Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Experienced in complete SDLC, Client /server architecture providing a well balanced understanding of business relationships, business requirements, worked for financial and technical solutions and help the team at all levels until final product release.
• Extensive experience with Process Modeling using UML, Flow Charts, Task diagrams, Sequence diagrams, Activity diagrams and Use Cases.
• Ability to follow CDISC data standards and maintain SDLC documentation.
• Strong project management skills including planning, scheduling, monitoring and budgeting with experience in requirements gathering, gap analysis, risk analysis, effort estimation etc.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Extensive experience in configuring data mapping between different Databases.
• Strong experience in conducting User Acceptance Testing UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Knowledge in the ETL Extract, Transform and Load of data into a data ware house/date mart and Business Intelligence BI tools like Business Objects Modules Reporter, Supervisor, Designer, and Web Intelligence .
• Extensive knowledge of financial instruments like Equities, derivatives risk pricing, bonds, swaps, options and market Greeks.
• 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.

Software/Environment:

MS Visio, MS Project, Rational Rose, RequisitePro, ClearQuest, Windows XP/2000/Me/98/95/3.1/NT, OS X, SunOS, MS-DOS, Dream Weaver, Adobe Photoshop, Flash, Business Objects, SAS, XML, UML, HTML, C , UNIX, Dreamweaver, Frontpage, AGILE, VB.NET,ASP.NET, PL/SQL, Java, j2ee, Access, Microsoft Word, Power Point, Excel, Outlook.

Confidential

Sr. Business Data Analyst

Member of team that supports the financial portion of the claim payment System for the state of VA Medicaid program. Facilitate meetings with state of VA Medicaid representatives to determine requirements for changes to the financial portion of the claim system that pays over 100 million dollars a week in Medicaid claims.

Responsibilities:

• Analyzed User Requirement Document, Business Requirement Document BRD , Technical Requirement Specification and Functional Requirement Specification FRS .
• Created Testing Requirements Document TRDs and Test Case Scenarios to test functional changes to the system/application as per the project requirements.
• Assisted the Technical team with Formal Integration Testing of I-many Government Pricing. Created Testing Inventory report, Test Scripts and developed Formal Integration Test Cases. Also, assisted the technical team with parallel testing by being onsite with client as well as providing remote assistance.
• Designed workflows using Informatica Power Center to perform ETL on the data from the staging area to the transaction enrichment data store and to the compensation data marts.
• Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
• 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.
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse EDW .
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Worked with the TrackWise and SAP Business One Solution System Administrator, software vendor Sparta Systems and client first, Product Specialists, and MAXIMO staff to define and documented business processes.
• Developed and maintained programs in SAS for UNIX in a user support environment. Developed, modified, validated and implemented SAS programming work.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Analyzed data using Excel VBA scripts and Macros
• Elicited and gathered user and business requirements through open ended discussions, brainstorming and prototyping, Designed and developed, Use Cases, Activity Diagrams, Sequence Diagrams, Visio and Business Process Modeling. Involved in jobs and analyzing scope of application, defining relationship within between groups of data, Star Schema etc
• 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.
• Developed small applications with Teradata at the backend.
• Facilitated Joint Requirement Planning JRP Sessions for communicating and managing expectations with the client whose customers were going to be the final users of the product and facilitated Joint Application Development JAD sessions with all IT group members for communicating managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• 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.

Confidential

Data Analyst

Confidential and their goal is to provide quality healthcare and improved human life.As a Business Analyst Worked on the up-gradation of their database that has all the record of all the patients and customers. Including merging of several different data marts and building a new database so that managers can see all the information all together and then managed the database. Including managing their claims processing system plus managing the government funding part to support Medicare and Medicaid through the internal software system within the company

Responsibilities:

• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Provided a summary walkthrough of new features and functionality in the I-many Government Pricing v3.5 release, and facilitated a discussion on value and applicability of new features to the customer organization.
• Transferred data ETL to Data ware house Environment using SSIS and SSAS.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Conducted TRD walkthroughs with development team to explain all the functional requirements and made sure that all open questions/issues are resolved for a smooth development process.
• Created SAS programs that are used for data validation, statistical report generation and program validation and automated the Edit Check programs using Macros
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• 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.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• 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.
• Defined the duplication of data and columns between tables using TOAD and SQL.
• Perform Source-to-Target Data Mapping Data Lineage Analysis and documentation using the Enterprise Metadata Repository.
• Designed and developed an XML product key generation system that allowed for conditional access to features based upon customer purchase levels, while maintaining a unified deployment.
• Work closely with Business Owners and Stakeholders to outline Business Requirements.
• Work with System analyst and IS teams to understand the flow of data.
• Used Test Director, PL/SQL for testing the application
• Wrote automated Test Scripts for Regression Testing using Win runner.
• Designed conceptual and logical data models of Data Warehouse and tables.
• 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
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Prepared Data Comparison tool by using VBA Excel Macro .
• 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.

Confidential

Data Analyst

Confidential is a leading specialty pharmaceutical company that uses innovative science and market insight to develop responsive products for a changing world. Watson has pursued a growth strategy combining internal product development, strategic alliances and collaborations, and synergistic acquisitions of products and businesses.Confidential is uniquely positioned with its infrastructure and internal research and development capabilities to support its three divisions: U.S. Generic, Brand, and Anda Distribution. The project involved remediation of lab instruments and bringing them into compliance with FDA regulations. It also involved in the integration of the instruments system with the Calibration Manager System.

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Studied business requirements and conduced User Interviews to identify and document the data discrepancies and their sources as related to Government Contract Compliance GCC , Government Disclosures, Government Pricing, Customers, Products, Product pricing.
• Prepared graphical depictions of Use Cases, Business process diagrams, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design UI screen using Microsoft Visio.
• Government Disclosures, Government Pricing, Customers, Products, Product-Pricing. Using SQL queries, investigated data discrepancies between various source systems such as INTERACT, COACT, CARS/IS, Rebates- Chargeback and the Data Warehouse and the Price Point and Sales Data Marts.
• Involved in the PRD Project review , TRD Technical Requirements , SDD System design meetings. Reviewed the documents to make sure that this Re hosted applications are supposed to meet all the functionality requirements as existing applications in Stratus.
• Thoroughly analyzed impacts to the Envision system components DB2 tables, programs, copybook, JCL, interfaces, reports, windows, and the data warehouse in order to support the current MMIS functions, as well as prepare for updated or changed functions identified in the Business Rules Comparison.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• 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.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Designed and developed Project document templates based on SDLC methodology.
• Managed Scope and Change throughout the life cycle of the product and identified areas of risk exposure and loss techniques adopted.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Used teradata fast load utility to load the tables using UNIX corn shell and SAS.

Confidential

Business Analyst/Data Analyst

This project involved creating the medical claims processing system for Aetna. It consisted of different modules like provider enrollment, member enrollment, programs and coverage. This project also involved the maintenance of claims workstation that automatically handles the entire claims life cycle.

Responsibilities:

• Gathered user requirements and directed developers for practical deliverables.
• Worked with the full SDLC, elicit, analyze and define requirements.
• Conducted JAD sessions with the clients to identify the requirements.
• Worked with the software architects / developers to ensure that the applications conform to customer requirements.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint. Used the ODBC/SQL to migrate all data to one database before uploading it into the Knowledge Base.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Used Rational Unified Process RUP for streamlining the team's development activities.
• Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Participated Testing and Evaluation of projects at established integration points to assess progress and identify key functionality issues.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Uploaded the technical specification documents to Planview SharePoint portal.
• Identified and documented Issues, Risks and Gaps and their descriptions and impact, and provided recommendations and alternatives. Analyzed the Gaps for Training purposes.
• Maintained Test Matrix with the test results obtained during testing phase
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Actively participated in writing User Manuals.
• Conducted JAD sessions to facilitate discussion between the different users to resolve issues and come to an agreement.
• Worked on data modeling and produced data mapping and data definition documentation
• Tracked UAT issues/bugs and prepared reports.
• Performed job of contact point for all stakeholders business, legal, compliance, development .
• Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project