We provide IT Staff Augmentation Services!

Business Analyst Resume Profile

Richmond, VA

Summary:

  • Seven plus years of experience with expertise in Business Analyst/Data Modeling and Business Intelligence reporting.
  • Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language UML in an SOA environment.
  • Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
  • Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2000.
  • Adequate knowledge in Health Administration Claims processing auto adjudication , COB, EOB/Drafts, Claims pricing and testing, HIPAA, enrollment, EDI, Medicare, Medicaid, CDHP consumer driven health plans .
  • Design and review of various documents including the Business requirements document BRD , Use Case Specifications, Functional Specifications FSD , Requirement Traceability Matrix RTM and testing documents.
  • Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
  • Extensive experience in configuring data mapping between different Databases.
  • Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
  • Proficient in discussing and defining project, Gap Analysis with the clients from both a business and technical perspective.
  • Proficiency in business requirement gathering techniques, conducting JAD and RAD sessions and meetings.
  • 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.
  • Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams , Class Diagrams based on UML using Rational Rose
  • Worked extensively on user requirements gathering, gap analysis, and development of functional speculations for critical mission accomplishing projects.
  • Proficient in Unit Test Plans UTP , Integrated Test Plans ITP Extensive experience in User Acceptance Testing UAT .
  • Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow-Flake schema
  • Provided technical and functional consulting to corporate and divisional users for Cognos.
  • Highly motivated, result oriented professional with a short learning curve and strong communication skills.

Software/Hardware: ERWIN, ETL: Ascential DataStage 7.x, 6.x, 5.x , Star-Schema Modeling, Snowflake Modeling, FACT and dimension tables, Erwin 4.0, Business Objects, Micro strategy, SAS, Macros, Erwin 4.x, C/C , Java SE 1.4, TURBO PASCAL 7.0, VB.Net, HTML, COBOL, SQL Server, SOA, SAP SD, MySQL, Agile/Scrum, Oracle 8i,Visio, Sybase ASA 6 - 9 .ASP/ASP.net, PHP, Microprocessors 8085 8086, Unix, MVS, MS Windows/95/98/NT/2000/XP, MS DOS, MS Office 2000

Professional Experience:

Confidential

Business Analyst

Responsibilities:

  • Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
  • Gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
  • Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits including Medicare .
  • Involved in requirement gathering and testing of consumer web portal for the enrollment of Medicare members.
  • Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
  • Conducted meetings for the Data Modeling and Analysis.
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Helped with data modeling and defining the conceptual and logical model of the data warehouse.
  • Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
  • Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language UML in an SOA environment.
  • Involved in development phase meetings for business analysis and requirements gathering for the Common Claim Layout CCL .
  • Worked with SME's to collect the Business process requirements, documented them in Business Requirement Document BRD and performed Business Process Re-engineering.
  • Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin..
  • Transform disjointed data from several different sources including Business Objects, Spreadsheets, Remedy and other management tools.
  • Facilitated joint application development JAD sessions, one on one interview and meetings with business users and subject matter experts SMEs .
  • Deal with data mapping issues between various source systems and staging area and data-marts.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Organized and led JAD/JAR sessions and interviews with the various stakeholders in the organization
  • Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
  • Managed Scope and change throughout the SDLC process of the product.
  • Conducted user interviews, gathered requirements, and analyzed the requirements by using Rational Rose, Visio and Requisite pro RUP.
  • Gathered requirements and modeled the data warehouse and the underlying transactional database.
  • Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
  • Set up definitions and process for test phases including Product test, integration test, system test and User Acceptance Test UAT .
  • Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Created the test cases for all the Use Cases using EA tool.
  • Created test scripts for all the test cases in PL/SQL.

Environment: RUP, UML, UAT, SDLC, Rational Rose, Ascential Data Stage 7.5, Rational Test Manager, XML Spy, Data Stage, Rational Requisite Pro, Rational Clear Case, Clear Quest, Rational Rose, UNIX, Oracle 11g, PL/SQL, DOS and UNIX Sequential Files, Mercury Test Director Agile, Waterfall, MS Access, CSV Files, XML File,

Confidential

Business Analyst

Responsibilities:

  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Performed In-Death analysis of systems and business processes of Medicare Part D as per CMS rules and procedures.
  • Involved in gathering Business Level Requirements and reviewed manual testing methods.
  • Worked on developing Master Validation test plan, Validation Protocols, Requirements Traceability Matrix RTM , Gap analysis, remediation plan, FDA Audits, SOP's.
  • Built business requirements into the Medicare Advantage MA requirements database and created the Project Requirements Document for the three functional areas
  • Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
  • Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
  • Designed the business requirement collection approach based on the project scope and SDLC methodology.
  • Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
  • Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
  • Reported and analyzed all application defects, user issues and resolution status to the higher manager using Mercury Test Director.
  • Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
  • Provided technical and functional consulting to corporate and divisional users for Cognos.
  • Performed initial manual testing of the application as part of sanity testing
  • Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
  • Conducted Functional Walkthroughs, User Acceptance Testing UAT , and supervised the development of User Manuals for customers.
  • Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
  • Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries
  • Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project is Data Mapping.
  • Performed extensive requirement analysis including data analysis and gap analysis.
  • Worked on project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
  • Developed business process models in RUP to document existing and future business processe.
  • Troubleshot the designed jobs using the Data Stage Debugger.

Environment: Ascential DataStage 7.5, Designer, Director, Manager, Parallel Extender Debugger, Data Stage BASIC language Expressions, SAP SD, SQL Server, Rational Test Manager, Cognos, Data Stage, Rational Requisite Pro, Rational Clear Case, Clear Quest, Rational Rose, Erwin, Mercury Test Director , Agile, Waterfall, MS Access, SDLC, RUP, UML, UAT, XML Files, MVS, IMS

Confidential

Business Analyst

Responsibilities:

  • Developed, modified, validated and implemented SAS programming work.
  • Created source table definitions in the DataStage Repository by studying the data sources.
  • Gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
  • Involved in the requirements gathering and functional specification phases.
  • Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
  • Conducted Joint Application Discussions JAD , project meetings, reviews walkthroughs, client interviews and coordinating various technical team at off shore and managerial teams at all levels.
  • Performed Gap Analysis for new functionality requirements, as well as prioritized them based on actual business needs so as to align them with the product release roadmap.
  • Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
  • Converted various SQL statements into stored procedures thereby reducing the Number of database accesses since Stored Procedures passes the whole block at one time.
  • Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
  • Assist other project teams with data analysis, data mining and data profiling as needed.
  • Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
  • Used SQL to test various reports and ETL load jobs in development, QA and production.
  • Created UML Class, Sequence and Component Diagrams diagrams using Visio.
  • Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing reviewed their consistency with the business requirements
  • Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized

Environment: SAS, Oracle 8i, Windows NT, SQL Server, Visio, MS- excel, CSV files, UNI X, Sybase, Rational Test Manager, XML Spy, Data Stage, Rational Requisite Pro, Cognos, Rational Clear Case, Clear Quest, Rational Rose.

Confidential

Business Analyst

Responsibilities:

  • Gathered user requirements and directed developers for practical deliverables.
  • Provided FDA 21CFR Part 11 Documentation Remediation for corporate-wide Clinical Trial System
  • Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
  • Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle SDLC to discuss open issues and resolve them.
  • Preformed regular sittings with stakeholders modeled system requirements through JAD/JAR sessions and maintained project stakeholder request baselines.
  • Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
  • Gathered requirements and modeled the data warehouse and the underlying transactional database
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Interacted with department heads to finalize business requirements, functional requirements and technical requirements and also created Business process model.
  • Responsible for business requirements gathering and technical requirements analysis and documentation for FileNet-based document management system.
  • Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
  • Designed the online screens and reports for the Medicaid Online Electronic Claims Submission System.
  • Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs.
  • Responsible for identifying requirements and translating business requirements to system requirements.
  • Analyzed and Documented Business Requirement Document BRD , Functional Specification Documentation, and System Requirement Documentation, using UML methodologies
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
  • Performed In-Death analysis of systems and business processes of Medicare Part D as per CMS rules and procedures.
  • Developed BRDs, FRDs and FSDs using corporate templates developed Use Case Diagrams, Activity Diagrams and Sequence Diagrams using UML.
  • Configured the Data mapping between Oracle and SQL Server 2005.
  • Created SAS programs that are used for data validation, statistical report generation and program validation and automated the Edit Check programs using Macros
  • Used SAS ODS to create output files in different formats including PDF and RTF
  • Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis.
  • Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
  • Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Web sphere and Cognos.
  • Used SQL to test various reports and ETL load jobs in development, QA and production environment
  • Tracked UAT issues/bugs and prepared reports.
  • Performed job of contact point for all stakeholders business, legal, compliance, development .
  • Took approvals from business owners for business requirements.

Environment: UNIX, DB2 UDB, MS Power Point, MS Excel, COGNOS, RUP, UML, SAS, Rational Rose, Oracle 10g, Testing Strategies.

Confidential

Business Analyst

Responsibilities:

  • Conducted and participated in JAD/JAR Sessions periodically with various Subject Matter Experts at various phases of the Development Life Cycle to discuss open issues and resolve them.
  • Develop change management procedures for implementing requirement changes and/or enhancements and consistently tracked the requirements status throughout the project life cycle.
  • Document and communicate changes throughout the user organization, supporting Information System Change Management ISCM and compliance.
  • Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
  • Worked on broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design
  • 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.
  • Conducted JAD sessions for communicating with Stakeholders and Project directors
  • Actively participated in gathering requirements from various SMEs, Financial Analysts, Risk Analysts and Portfolio Management via JAD/JAR sessions.
  • Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Web sphere and Cognos.
  • Worked in mainframe environment and used SQL to query various reporting databases.
  • Used XML for building and parsing of Application Configuration file.
  • Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing using Mercury Test Director
  • Supported web design and user-interface layout for public and internal web based solutions.
  • Performed User Acceptance Testing UAT for various web based and database related applications.
  • Enabled Proper selection of the hash table design parameters for faster table look-up.
  • Conducted User Acceptance Testing UAT , Unit testing and System testing
  • Imported and exported repositories across projects.
  • Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
  • Used Aggregator stages to sum the key performance indicators used in decision support systems.
  • Troubleshot the designed jobs using the Data Stage Debugger.
  • Created jobs sequences.
  • Created job schedules to automate the ETL process.
  • Enhanced the job properties for performance tuning.

Environment: Rational Rose, DB2, Rational Clear Quest, Requisite Pro, UI/GUI, CaliberRM, MS Visio, AGILE, Rational Administrator, SQABasic, AS/400, DOORS, SQL, VB.Net, SDLC, Oracle, XML, IBM Business Modeler, SEI, UML.

Hire Now