We provide IT Staff Augmentation Services!

Sr. Business Analyst/ Data Analyst Resume

Indianapolis, IN

SUMMARY:

  • Senior Analyst with 10+ years of experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
  • Experience as Business Intelligence/Systems/Data/Business Analyst with expertise in Insurance, Healthcare processes, Business Process Engineering, Systems/ Solutions Engineering, Strategic Planning, and Systems Analysis
  • Experience with healthcare system, Medicaid and with prime focus on claims adjudication, provider, eligibility and prior authorization.
  • Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
  • In - depth knowledge of creating use case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
  • 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).
  • Experience in Designing, Creating and maintaining the Universes, Business object reports, WEBI reports and Domains (Security, Universe, Document) in Business Objects.
  • Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
  • Expertise in the EPIC Medical software application (EMR).
  • Knowledgeable of HL7 Messaging protocols.
  • Extensive experience in all phases of RUP and SDLC processes
  • Managed content using Docushare 5 and DocushareCPX and integrated it with other products like Liberty, Xerox Advanced Multifunction Devices
  • Assisted in SOX and Six Sigma Procedures
  • Extensive experience with the SAS programming and in data step and with various SAS Procedures in Base SAS and SAS/Stat, including thorough knowledge of SAS Macro.
  • Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions
  • Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
  • Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).
  • Strong oral and exceptional written business communication skills
  • Hard working, positive thinking, self starter with a strong goal orientation
  • Excellent meetings facilitator with excellent inter-personal and conflict resolving skills.
  • Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.

TECHNICAL SKILLS:

Programming Languages: C,C++,C#,VC++,VB,VB.NET,C#.NET, ASP.NET, Java, SQL, PLSQ

Development Methodologies: RUP, AGILE, Waterfall, ESDM, STV

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS )

Data warehousing Tools: Informatica, Business Objects, Confidential, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunnerNiku Project WorkBench

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Sr. Business Analyst/ Data Analyst

Responsibilities:

  • Gathered and documented business requirements for existing and future business systems.
  • Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
  • Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Confidential .
  • Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
  • Reverse Engineered the existing ODS in to Erwin.
  • Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
  • Defined Functional Test Cases, documented, Executed test script in Facets system.
  • Analyzed trading partner specifications and created EDI mapping guidelines.
  • Healthcare system implementation including enterprise Electronic Medical Records (EMR) software.
  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
  • Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
  • Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries
  • Lead the team in designing and developing rules and processes for data exchange and file transfers
  • Created interface requirements documents which became the baseline and standard for all data exchanges
  • Ensured that project requirements are properly tracked and documented.
  • Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.
  • Assisted in monitoring ancillary data transactions and addressed problems with HL7 messages.
  • Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
  • Worked in mainframe environment and used SQL to query various reporting databases
  • 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. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
  • Used Test Director, PL/SQL for testing the application
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Used different ad-hoc analysis, the Reports assist in defining strategy for each customer category. Informatica was used for ETL process and Business Objects 6.5.1 & XI R2 are used for Reporting duties.
  • Tracked UAT issues/bugs and prepared reports.
  • Capture and Formulation of Business Rules and delivery of Business Rules Templates.
  • Creation of UML Diagrams including Context, Business Rules Flow, and Class Diagrams
  • Created Business process workflow diagrams using IBM business process modeler
  • Implemented RUP recommended visual models to draft business requirements by using Use Cases.

Environment: Microsoft Office 2003 Professional (Outlook, Word, Excel, Visio, Access, etc.), Microsoft SharePoint 2003,UML, RUP, UAT, ERWIN, db2, Peoplesoft GL,Mercury Test Director, SQL, PL/SQL, .NET, Clear Case

Confidential, Washington DC

Sr. Data Analyst/ Business Analyst

Responsibilities:

  • Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
  • Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
  • Led the development of a training program to train users on a custom web application and a Confidential ad-hoc reporting environment.
  • Used knowledge of Health Care Information Systems EMR model to develop proposed workflow in MS Visio.
  • Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
  • Designed High level design, for New process, integrating with legacy and Facets
  • Responsible for integrating with Facets .Designing test scripts for testing of Claims in Development, Integration and production environment.
  • Conduct complex documentation and user needs analysis. Interface with team and staff to develop HL7 integration.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
  • Excellent in Developing and evaluating business process Models.
  • Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
  • 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
  • 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.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
  • Involved in the testing phase right from the Unit testing to the User Acceptance testing.
  • Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
  • Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
  • Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
  • Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc
  • Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
  • Tuned the batch programs and online transactions to alleviate performance problems.
  • Developed & executed several Optimized queries in SQL on this data.

Environment: RUP, UAT, GAD (Gap Analysis Document), Microsoft Office 2003 Professional (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint 2003, ERWIN, SQL, PL/SQL.

Confidential, Chicago, IL

Business Analyst/ Data Analyst

Responsibilities:

  • Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting a document that contains the essential business elements and detailed definitions.
  • Working with clients to better understand their needs and present solutions using structured SDLC approach.
  • Accurate processing of Medicare claims using the Diamond system
  • Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
  • Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
  • Troubleshot the designed jobs using the DataStage Debugger.
  • Tuned DataStage transformations and jobs to enhance their performance.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Created test scripts for all the test cases in PL/SQL.
  • Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Worked with Confidential and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
  • Developed business process models in RUP to document existing and future business processes.
  • Designed workflows and allocated permissions within SharePoint.
  • Wrote detailed specifications for various reports generated
  • Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
  • Responsible for designing and developing universes for development of reports using business object designer
  • Used Query Analyzer, Execution Plan to optimize SQL Queries.
  • Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers.
  • Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time.)
  • Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
  • Created Mock-up forms in MS word for better visualization and understanding of the software solution.
  • Identifying and modeling Use case diagrams, Sequence diagrams, Activity diagrams, Collaboration diagrams using UML.
  • Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
  • Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
  • Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
  • Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
  • Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.

Environment: Java, J2EE technology, SQL, PL/SQL, Windows 2000 Advanced Server, Liberty,UNIX / Oracle Platform, MS Visio, RUP, UAT, ERWIN, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot.

Confidential, OH

Business/ Data Analyst

Responsibilities:

  • Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
  • Collects requirements from department managers and users for enhancements. Acts as liason between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
  • 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.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
  • Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
  • Run the SQL queries using TOAD and SQL Navigator.
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Was responsible for indexing of the tables in that data warehouse.
  • Reverse Engineered the existing ODS in to Erwin.
  • Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Confidential .
  • Delivered requirements for integrating transaction, previous day and current day information reporting, for ACH, Wires, Memos, Returns, Controlled Disbursements, Lockbox, and Data Exchange.
  • Created job schedules to automate the ETL process.
  • Worked on data modeling and produced data mapping and data definition documentation
  • Configured the Data mapping between Oracle and SQL Server 2005.
  • Tested Performance & Accuracy related queries under SQL Server
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Designed and implemented basic SQL queries for testing and report/data validation
  • Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
  • Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
  • Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
  • Used Data warehousing for Data Profiling to examine the data available in an existing database.
  • Prepared graphical depictions of Use Cases, 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.
  • Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
  • Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
  • Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, PL/SQL, Sybase, EVPN, IBM Websphere Business Process Modeller, ACORD, XML,Business Objects, TestDirector, LoadRunner

Confidential, Miami, Florida

Business Analyst

Responsibilities:

  • Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
  • Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
  • Worked on HL7 and xml interface messaging.
  • Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
  • Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
  • Designed the system, prepared UML and sequence diagrams using Rational Rose.
  • Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
  • Prepared Functional Specification Documentation (FSD) and communicated these to the stakeholders.
  • Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
  • Conducted Business Requirements, Functional and Technical meetings with Business groups.
  • Used MS Visio for Process modelling and Business Process flow diagrams.
  • Extensively involved in regression testing during various phases of the application.
  • Used Aggregator stages to sum the key performance indicators used in decision support systems.
  • Troubleshot the designed jobs using the DataStage Debugger.
  • Tuned DataStage transformations and jobs to enhance their performance.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest) UAT, RUP, WinRunner, LoadRunner, MSOffice2000

Confidential, Richmond, VA

Data Analyst

Responsibilities:

  • Gathered legacy system requirements by shadowing Customer Service Representatives (CSRs), Customer Relationship Representatives (CRRs), preparing questionnaires, to identify limitations in the current system and GAPS in the proposed system.
  • Created an enterprise workflow application based on CRUD rules for Customer Data that would allow for future integration of data infrastructure across various business areas into a single UI.
  • Prepared logical data model in the form of Business Context diagram to include various entities and attributes in order to facilitate the design of Data model in the form of ER Diagrams. Studied current information structures and data models of the current databases to better understand the design of target data source.
  • Performed custom data conversions and developed custom software for risk management applications including general claims, vehicle accident and administrative tracking. Performed all data field mappings.
  • Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.
  • Used Rational Rose to model the process using UML to create behavioral and structural diagrams.
  • Used Rational Clear Quest to track required changes and Rational Clear Case to maintain different versions of the project documentation
  • Involved in integration of various Customer Data Sources and provided Data Mapping from various sources like CCD, LPCD, DCD into the target centralized customer data source.
  • Modeled Business requirements into workflows to depict various scenarios of system to request RFI and RFP responses from major vendors.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
  • Supervise and guide junior analysts to Identify and document business process flows and data requirements using Microsoft Visio, Excel and Microsoft Word.
  • Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis
  • Performed detailed comparative analysis of response to RFPs of vendors and Graphically Represented the recommended solutions in PowerPoint to Senior Management
  • Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
  • Conducted Requirements walk- through with the Business Team to ensure that all their needs are met and gathered sign off on the requirements for SOX compliance after the requirements were base lined.
  • Prepared and maintain Business Rules Spreadsheets (BRS) identifying Rules, Triggers and corresponding data fields from Legacy to target CRM application.
  • Followed a methodical Change Management Process and documented any Change Requests into Clear Case for any changes in the requirements after the requirements were base lined.
  • Conducted Architectural Discussions to prepare the Proposed Architecture and provided insight in the Business Case to the Architecture Review Board (ARB).
  • Lead the effort of Data Migration from disparate data sources into normalized data to eliminate redundant information and organizing the tables to easily maintain the table structures.
  • Prepared Test Cases based on base-lined Requirements Document, prepared Requirements Traceability Matrix and provided Performance Testing Requirements. Worked very closely with the Test team to Test all iterations during the Testing Phase and documented all the defects.

Environment: Windows, Oracle, SQL, PL/SQL, MS Visio, MS Access, MS Project, MS SharePoint, UML, Requisite pro, Rational ClearQuest.

Hire Now