We provide IT Staff Augmentation Services!

Etl Informatica Business Analyst Resume

0/5 (Submit Your Rating)

Nashville, TN

SUMMARY

  • Eight years of professional experience as a Business analyst in varied industries that include Manufacturing, Financial, Health Care, Pharmaceuticals, and Insurance.
  • Content Management, Functional Specification Design, Process Flow Diagram, Data Modeling, and Process Mapping, In - depth knowledge of SDLC, Business Process Modeling, UML, RUP, Rational Suite including Rational Rose, Requisite Pro. Good knowledge of Six Sigma tools and concepts for Quality Improvement.
  • Good knowledge of Informatica 9.0, databases like Oracle, SQL servers, Data warehousing concepts and tools. Ability to gather business and technical requirements from both formal and informal sessions through interviews, NetMeeting, questionnaire, video conferencing, JAD sessions and conference calls. Documentation of Business assumptions and Constraints.
  • Experience working in different methodologies such as Agile, Waterfall and RUP. Prepared Business Workflow Models and documented “As Is” and “To Be” processes. Expertise is preparing Business Requirement Document (BRD), Functional Specification Document (FSD) and Requirement Traceability Matrix. (RTM). Performed GAP Analysis and checking the compatibility of the existing system infrastructure with the new Business requirement documents.
  • Understood, Analyzed and optimized the Business Processes .Defined scope of the Project, User Requirements, data analysis & Data mapping. Experienced in converting User Requirements into Business Requirements. Good functional experience in data warehousing tool Informatica, Data Modeling tool Erwin and ERP such as SAP.
  • Developed Test Plans and Test Cases as per the business process requirements to match the functionality requirements and UML diagrams for Quality Assurance (QA) and Change Management.
  • Overlooked Functional testing, Regression testing, GUI testing, and User acceptance testing (UAT) and assisted the testing team. Possess Excellent Verbal and Written Skills along with interpersonal, presentation, and self-organizing skills. Dynamic and Assertive team player with Strong Commitment

TECHNICAL SKILLS

UML Tools: Rational Rose / Microsoft Visio

Version Tools: Clear Case/ Clear Quest, Clarity, Doors

Databases: Oracle, MS Access, SQL Server

Testing Tools: Win Runner, Load Runner, quick Test Pro, quality centre

Database Skills/Tools: Stored Procedures, Triggers, and Packages/ Toad

Languages: SQL, SAS, Java Script

Front end tools: Microsoft Project, Rational Portfolio Manager, Lotus Notes 8.1

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

ETL Informatica Business Analyst

Responsibilities:

  • Developed Functional Specification Documents (FSD) and Business Requirement Documents.
  • Worked on Informatica maps to understand the functional aspect of each map.
  • Base lined the Functional Specification Document (FSD) for the Quality Analyst for making Test cases.
  • Work with Sr. Systems Analyst and business users in requirements; identify required data, data conversion rules for exchange of information between existing application systems & databases.Conducted JAD sessions to discuss discrepancies found in the Informatica conversion maps & functionality of those maps.
  • Expertise with content management and Requirement Traceability Matrix (RTM). Worked on Oracle 10i Data Base. Involved in streamlining the process and helped the QA team in Process Mapping with the traceability. Overlooked Test Plans, Test Cases for system testing as well as for User Acceptance testing (UAT), and Validity Testing.
  • Assisted the developers and Quality Analyst with SQL queries. Worked in close coordination with the Quality Analyst and Developers in communicating the functional aspect of each Informatica map.
  • Managed change management efficiently.

Confidential, Irving, TX

Business Analyst

Responsibilities:

  • Conducted JAD sessions and called out meetings for gathering Business requirements.
  • Developed Use Cases and Use Case Diagrams. Followed Agile methodology for gathering requirements and converting those requirements into Functional specifications.
  • Documented the As-Is processes and developed Flow Diagrams in Visio.
  • Developed Level 1 and Level2 Process flow diagrams for the existing and the future state processes.
  • Participated regularly in Walkthroughs and review meetings with Project Manager and development team.
  • Prepared Use-Cases Use case diagrams, Cross Functional Diagrams and BIA (Business Impact Analysis).
  • Followed WBS (Work Breakdown Structure) for organizing and presenting the Business with the Process, Functions and the Requirements for the final sign off from the Business owners. Content Management and Data Mapping to facilitate GAP Analysis. Prepared RTM (Requirement Traceability Matrix).
  • Worked in Lotus Notes version 8.1

Confidential, Corpus Christi, TX

Senior Business Analyst

Responsibilities:

  • Accumulated requirements from various Subject Matter Experts (SME) through surveys and interviews
  • Carried out Business Process Management to optimize the existing process and developing new processes.
  • Conducted research to collect and assemble data for databases - Assisted in the design/development of relational databases for collecting data.
  • Assisted in Creating ERD for proper understanding of data base functions and relations.
  • Expertise with Analytical reporting using Advanced Excel features such as Pivot tables and charts.
  • Participated in the implementation of Six Sigma Tools such as FMEA, Pareto charts, QFD and Regression Analysis for Quality improvement.
  • Performed SWOT Analysis to identify the best Business Process to be implemented.
  • Experience in communicating with the business users; document their needs in to requirements and converting them in to functional specifications for the web services application using Agile methodology.
  • Conducted individual and group (JAD) sessions with business and technical units. Analyzed requirements and transformed them into System Requirements and validated with technical and business teams.
  • Working experience on backup system and worked with HP Quality Center in creating requirements, test cases, tracking defects. Created non-functional system requirements pertaining to data quality and system performance. Involved in streamlining process and helped the QA team in Process Mapping with traceability.
  • Overlooked Test Plans, Test Cases for system testing as well as for User Acceptance testing (UAT), and Validity Testing. Managed change management efficiently.

Environment: Oracle 8i, RUP, Rational Requisite Pro, Clear case, Clear Quest, UML, Microsoft Project, MS Visio, Sequence diagrams, Power Point, MS Excel, Pivot tables, MS Outlook, Use cases.

Confidential, Ridgewood, New Jersey

SR. Business Analyst

Responsibilities:

  • Conducting user interviews at both in-house and client locations, gathering and analyzing requirements using Microsoft Visio using spiral methodology. Designed and developed ERD, Use Cases, Activity Diagrams, Cross Functional Diagrams, OOD using UML .Identify, research, Realize, investigate, analyze, define and Document Business Processes and Use Case Scenarios.
  • Used MS Visio to design and create ERD. Perform Gap Analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
  • Conduct Workflow, Process Diagram and Gap Analyses to derive requirements for existing systems enhancements. Working knowledge of Scenario Analysis and Optimization.
  • Prepared Business Requirement Documents (BRD),Functional Specification Document(FSD) and Requirement Traceability Matrix(RTM). Assist with User Testing of Systems (UAT), developing and maintaining quality procedures and ensuring that appropriate documentation is in place.
  • Responsible for identifying and documenting business rules and creating detailed Use Case Conduct User Acceptance Testing. Worked with development and testing teams to accomplish timely release objectives.
  • Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications.
  • Liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships. Assisted in maintaining vendor data bases and carrying out vendor ratings.

Environment: UML, UAT, Requisite Pro, Test Cases, MS Visio, Excel, Word, PowerPoint, SQL, MS Project, Sequence diagrams, Activity diagrams.

Confidential, San Diego, CA

Business Analyst

Responsibilities:

  • Improved implementation of payment of bills - by providing automation of monthly payments
  • Coordinated interaction between UI team, billing services payments team, Billing service integration team, Customer plan service team, Post settlement Team, Customer service, Security, Legal and Confidential Business/Technology team. Facilitated Joint Application Development (JAD) sessions and interview sessions to elicit requirements from various teams.
  • Developed a list of user stories and estimates with the help of development team and QA team.
  • Conducted daily scrum sessions for development teams to keep project and priorities in track. Reviewed Use Case Diagrams & Sequence Diagrams developed by development team to verify business use cases.
  • Used waterfall methodology.
  • Conducted cross team meetings with customer service team and legal team to develop user text to be added to the payment automation page. Conducted tri-weekly meetings with the business teams to get contracts and SLA agreements signed. Played a key role in development of technical API SLA’s.
  • Involved QA team for testing as a part of a sprint. Played a key role in development of a comprehensive test plan to test and coordinated the testing. Coordinate deployments between various teams.
  • Created test case in production using pre defined accounts to ascertain smooth launch.
  • Coordinate work between with HP Info Touch Technology team and Cricket Billing Web Service team.
  • Conducted JAD session to gather internal reporting requirements and to allow for API definition between Billing Service Team and Info Touch Team. Worked with Customer Service and Legal to develop blurbs for Forms and Error messages. Reviewed Use Case diagrams and Cross Functional diagrams developed by the development teams to verify business use case and workflow.
  • Played a key role in development of the test plan - in development and controlled testing in production.

Environment: RUP, UML, Windows 2000, MS Visio, Word, Excel, PowerPoint, Rational Rose, Requisite Pro, Clear Case, Clear Quest, Use Case, Test Case, Activity Diagrams, Cross Functional Diagrams.

Confidential, Detroit, MI

Business Analyst

Responsibilities:

  • Interacted and arranged meetings with Business and End users to gather business requirements for changes triggered by Government regulations and HIPAA, Business needs and process improvement.
  • Worked closely with project manager in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly.
  • Received the Client and Business user appreciation for the implementation of Prescriber NPI update.
  • Gathered the business requirements and prepared the analyzed data/workflows for business users.
  • Worked on HL-7 version 2.X. Analyzed business needs and created Business Requirement Document (BRD), Application Use Case (AUC) documents for business and end user review.
  • Translated user needs to business requirements using Unified Modeling Language (UML). Worked with the software architects / developers to ensure that the applications conform to customer requirements.
  • Prepared Requirement and Business Specification documents and arranged user reviews.
  • Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level. Maintained Project Glossary for the entire project team.
  • Conducted JAD sessions between the end users and the development team. Followed a structured approach to organize requirements into logical groupings of essential Business Processes, Business Rules, and Information Needs, thus ensuring that Critical Requirements are not missed.
  • Followed the RUP based methodology using Rational Rose to create Use Case, Activity/ State Chart, Sequence, and Collaboration Diagrams. Performed Defect Tracking and Change Control Procedures using Rational Clear Quest, and Configuration Management and Version Control using Rational Clear Case.
  • Involved in the peek review of Test Plans, Test Cases with the QA team to verify implementation of new features and enhancements. Have exposure of working on Peg works for the project.

Environment: RUP, Rational Requisite Pro, Rational XDE, Rational Rose, UML, Use case, Activity/ state diagram, MS Visio, Test Director, MS Office, Windows 2000/XP, Visual Basic, Oracle 8i, Java, J2EE, MS Office, SQL, DB2,cobol.

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:

  • Analyzed and documented the System specifications, Business requirements and detail design of the software for full understanding of the business. Used Requisite Pro for requirement tracking and analyzing.
  • Prepared and analyzed workflow scenarios and performed Gap analysis
  • 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 process Workflows, Functional Specifications and project initiation artifacts.
  • Assisted in writing advanced SQL queries to test the database backend.
  • Assisted in developing test cases and scripts based on Business requirements for the GUI, functional, User Acceptance, Performance, Integration testing, System Back-end testing and End-To-End testing.
  • Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs. Worked closely with the Business Owner to create User Acceptance Test (UAT) Strategy, Scenarios, and Test scripts, based on “day-in-the-life” scenario.
  • Documented Entry and Exit Criteria, Project and Product Risks and created several other artifacts for Product Acceptance. Used Sales force to interact with the customers online.
  • Reviewed test cases and defects created by QA team. Assigned resources and coordinated defect resolution. Prepared and communicated daily test status report to management and team.
  • Actively attend meetings with fellow testers and other groups to evaluate the progress and performance of the application. Defect Reporting and Tracking using Quality Center

Environment: Quality Center, QTP, Rational Unified Process (RUP), UML, Load Runner, Clear Trust, JavaScript, HTML, Agile methods, web sphere, Sales force, Oracle, TOAD, Tomcat 5.0, UNIX and Windows2000Server.

Confidential

System Analyst

Responsibilities:

  • Requirement Gathering through Business Systems Planning. Worked in the RUP Frame work though out the Project Life Cycle. Gathered Client Specific Business Requirements and translated it in a proper manner to the developers and ensured that these requirements were fully tested and implemented accordingly for each production cycle by creating Traceability Matrix.
  • Defined high-level system actors and Use Case Text Reflecting the scope of the project.
  • Involved in requirements representation and modeling in UML Use Cases Modeling, Data Flow Models in Rational Rose. Involved in Baseline process. Wrote Functional Specifications for upgrades or system changes during each production cycle. Submitted changes to CCB using Clear Quest.
  • Participated JAD Sessions to refine prototypes, prioritize and additional Use Case Development. Assisted in Black Box Testing and UAT.

Environment: Exchange Server 2000/2003, Remedy helpdesk, Share Point Portal, Office Suite, UML (Use-Case Modeling Using Visio).

We'd love your feedback!