Edi Data Analyst Resume
Austin, TexaS
SUMMARY
- Master Degree in Business administration and over 6+ years of progressive IT experience working as a business analyst and data analyst in the field of Information Technology with emphasis on business analysis, deployment of business processes and system solutions following waterfall, Agile and Scrum Methodologies.
- Varied Industry domain knowledge and expertise with delivery of projects focused on distinctive domains like Insurance, Healthcare, Retail Industry, Customer Relationship Management, and Business Process Management.
- Executed successful projects in Waterfall SDLC, Agile (Scrum and Kanban) Frameworks.
- Solid experience in handling project as a Business Analyst, Requirements Elicitation, Requirements Analysis, Domain Modeling, System Design and Implementation.
- Hands on experience in using Salesforce to create custom dashboards, profile and roles for various user groups and to generate user reports per the business needs.
- Expertise in Elicitation, Analysis and Documentation of User Requirements via JAD sessions, Workshops with business stakeholders and end users
- Analyzed and Created EPIC’s and User Stories as required for the Business and Engineering needs.
- Proficient in creating Activity diagrams, State diagrams and Domain modeling in Microsoft Visio, Enterprise Architect, Provision.
- Good knowledge on creating Process flows, Data flows, Swim lanes, Use case diagrams.
- Experience in mapping for import and processing of Proprietary and ANSI electronic data files.
- Expertise in Quality Assurance procedures like developing Unit Test Plan (UTP), and Test Cases; Experience in planning, managing and coordinating User Acceptance Testing (UAT)
- Extensive experience in designing Test Cases, Test Scenarios, Test Scripts and Test reports of manual tests.
- Experience in conducting Gap Analysis, Solution Feasibility Studies, Data Analysis and Data Management, System Analysis, and Risks Analysis. Ability to see the big picture, organizational impacts and interdependencies for a given business need.
- Strong Project Management skills which includes Risk, Scope and Time Management.
- Strong experience working with enterprise Software Management tools dealing with product management and project management.
- Strong mentoring skills, capable of leading and motivating individuals to maximize productivity while fostering cohesive teams in a virtual environment.
- Excellent Communication, Collaboration and Presentation skills.
TECHNICAL SKILLS
Programming: C, C++, JAVA.
Operating Systems: Windows 2000/2003/NT/XP/Vista/7
Database: MS Access, MS - SQL 2000/2005/2008/2012 , Oracle 9i/10g/11g
Package: Microsoft Office, Adobe Photoshop, Microsoft Project, Microsoft Visio
Tools: ARIS 7.0&7.1(BPM tool), Troux (EA tool), Salesforce.com
PROFESSIONAL EXPERIENCE
Confidential, Austin, Texas
EDI Data Analyst
Responsibilities:
- Process definition for EDI processing and interact with Client/Carrier to gather all the requirements required for the feed build.
- Worked on projects that involved waterfall as well as agile methodologies.
- Conducted daily scrum (stand ups) with the project team to ensure smooth going and identifying potential risks as necessary.
- Analyze the account structures and files specifications obtained before mapping the feed.
- Creating mapping for import and processing of Proprietary and ANSI electronic data files
- Utilize Benefit Relay, bSwift, or equivalent software for file processing.
- Design technical/functional documents, troubleshooting complex EDI failures and to establish process improvement including auto notifications.
- Manage client expectations and interact effectively with IT customers and resources, external trading partners, and upper management.
- Outlined the organization hierarchy and created profiles, roles accordingly in Salesforce; worked on visibility and security settings around them as required by the business.
- Designed different custom dashboards for various user groups based on their business functionalities and needs using Salesforce.
- Created and deployed several reports for different user profiles based on the need in the organization using Salesforce.
- Root cause analysis and Query databases in response to business inquiries.
- Planned and defined testing approach after consulting with development teams providing advice on prioritization of testing activity in support of identified risks in project schedules or test scenarios.
- Completed all support documentation on assigned projects, including creating and updating all user and technical procedures/manuals, operational support documentation and archival of all related project documentation.
- Development of timely and innovative solutions, with optimal use of technology and human Resources.
- Respond, address and resolve salesforce tickets in a detailed and professional manner
Environment: Benefit relay, Salesforce, bSwift, MS Word, MS Excel, SQL, MS PowerPoint.
Confidential, Austin, Texas
Business Analyst
Responsibilities:
- Conduct interviews with business partners to come up with a detailed list of business requirements.
- Client interaction and requirements gathering to prepare the business requirement document.
- Met with the application user group for gathering information from the functional and design prospect and document for the review.
- Worked closely with project stakeholders, SME’s and staff to understand the requirements and to analyze specifications for new applications along with re-engineering the existing application.
- Responsible for translating BRD into functional specifications and test plans.
- Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
- Conducted JAD sessions to define the project and to reduce the time frame required to complete deliverables.
- Translate the business requirements gathered into functional and technical requirements for the development team.
- Work with the development team to provide the details of the requirements gathered for developing the prototype.
- Defined Use cases from requirements and helped convert them into software specifications
- Aided in workflow analysis and process design.
- Created Logical/physical Data Model and have worked on loading the tables in the Data Warehouse.
- Performed data analysis and documented various data quality mapping document.
- Maintained Requirement Traceability Matrix (RTM).
- Maintained documents for change request and implemented procedures for testing changes.
- Define Use cases from requirements and helped convert them into software specifications.
- Collaborated with QA team ensuring test scenarios are prepared to provide proper test coverage and undertook reviews of test scripts and results to ensure quality delivery
- Maintained proper communication with the other team member to ensure that the modifications and requirements were addressed and also monitored these revisions.
- Prepared the project documentation and made sure it was consistent with the project standard and procedure.
Environment: MS Word, MS Power point, MS Visio, MS Excel, Windows 7, Salesforce.com, SQL, Java.
Confidential, Austin, Texas
Business Analyst
Responsibilities:
- Gather requirements and prepare business requirement documents (BRD).
- Responsible for translating BRD into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
- Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions with the user group and conduct document analysis.
- Assisted project manager to prepare project plan, Gap analysis, define the time for development and allocate requirements to each of them with resources using Microsoft Project.
- Analyzed and categorized the requirements of functional, operational, technical and transitional type for better understanding and deliver it to the respective group.
- Work with Data analyst to analyze data elements, data flow and performed data mapping between the existing system and new system to be developed.
- Performed data mapping from start to target.
- Work with the development team to provide the details of the requirements gathered for developing the prototype.
- Involved in defining the source to target data mappings, business rules and data definitions.
- Responsible for defining the key identifiers for each mapping/interface.
- Responsible for defining the functional requirement documents for each source to target interface.
- Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
- Assist to create test plans and strategies based on the development and software requirements.
- Define Use cases from requirements and helped convert them into software specifications
- Aided in workflow analysis and process design
- Maintain Requirement Traceability Matrix (RTM).
- Performed Regression Testing and created test scenarios for User Acceptance Testing (UAT).
- Maintain documents for change request and implement procedures for testing changes.
Environment: Microsoft word, excel, Visio, PowerPoint, Windows7, Rational Requisite Pro, Enterprise Architect, Rational Clear Quest, SQL, Java.
Confidential, Austin, Texas
Business Analyst
Responsibilities:
- Client interaction and information gathering to perform an exhaustive business study of the 'AS IS' system and to device the 'TO BE' system.
- Prepared the Project Charter document and presented it to the management for approval.
- Appraised project status to upper management on weekly basis using Weekly Status Report.
- Analyzed user requirement at every stage and attended change request meetings to implement the requested changes.
- Played an integral part in the preparation of Scope Statement, Business Case and in the design development and execution of the project.
- Prepared the Work Break Down Structure and Network diagram to analyze the critical paths of the project using MS-Project.
- Assisted Project Manager in determining Task Priorities, Milestone and Deliverables during Inception and Elaboration Phase using MS-Project.
- Designed prototypes for approvals using WordPress and presented the same to web designers to have a clear picture of the development.
- Communicated updates and helped resolved issues raised by customers, IT and management teams,
- Maintained proper communication with the other team member to ensure that the modifications and requirements were addressed and also monitored these revisions.
- Completed project tasks within approved timelines and budget. Conducted weekly project team status meetings in absence of the PM, tracked and closed issues on weekly basis.
- Prepared the project documentation in accordance with the project procedure and standard.
Environment: Web Services, MS Project, Windows XP, and MS-Word, MS-Excel, MS - PowerPoint, HTML.
Confidential, Austin, TX
Business Analyst
Responsibilities:
- Met with the application user group for gathering information from the functional and design prospect and document for the review.
- Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions with the application user group and conducted document analysis.
- Gathered and documented all the requirements using IBM Requisite Pro.
- Assisted project manager to prepare project plan, Gap analysis, define the time for development and allocate requirements to each of them with resources using Microsoft Project.
- Analyzed and categorized the requirements of functional, operational, technical and transitional type for better understanding and delivered it to the respective group.
- Worked with Data analyst to analyze data elements, data flow and performed data mapping between the existing system and new system to be developed.
- Worked with the development team to provide the details of the requirements gathered for developing the prototype.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
- Conducted routine meetings with PMO and other cross functional team members for better organization and documentation of existing documents such as project plans, project meetings and requirements.
- Created accessible requirements repository which helped improve team communication.
- Also Involved in Requirement gathering and preparing BRD for reporting processes.
- Prepared User Acceptance Testing test plans and conducted UAT Testing. Also prepared user reference documentation.
- Prepared test Data and performed data testing using the SQL. Also used MS excel for data mapping and data analysis.
- Developed requirements traceability matrices and used for tracking the project status through Initiation till deployment.
- Involved in end-to-end business transition by training end-users, providing with user manual for application and conducting job impact assessment and business readiness analysis.
Environment: IBM Requisite Pro, Microsoft Office 2010, Excel, Power Point, Salesforce.com, Microsoft SharePoint Server, Windows XP/2003/2008/8, SQL.
Confidential
Business Analyst
Responsibilities:
- Development of Process Assessment Frameworks including process capture templates and defining process meta-models.
- Assist with project management, including project design and planning, process mapping, testing, and training.
- Develop and enhance business reporting by using EA tools like Troux to support improved decision-making capabilities.
- Provided Business Support and Pre-Sales Support for business development and proposal work.
- Developing BPM and EA Tool expertise (ARIS, Troux) and imparting tool training.
- Leveraging the integration that ARIS has with SAP and Oracle.
- Development of Process Modeling Guidelines Documents, Solution Accelerators and other collaterals.
- Interacting with industry principals, Subject Matter Experts and conducting content harvesting exercises for building process libraries comprising of reference business architecture, industry value chains, prescriptive business process flows, business risks & control views.
- Developing and maintaining the “Pathfinder” portal and ensuring its robustness.
Environment: ARIS, Troux, Oracle, SQL Server, JAVA, MS Visio, Salesforce.com, MS Excel, MS PowerPoint, MS Word and Windows XP.
Confidential
Responsibilities:
- Facilitated requirements gathering sessions with users, performed data analysis, and documented user requirements, including process flow mapping and definition.
- Interviewed process owners and facilitated the “As-Is” discussions.
- Studied “AS-IS” process statistics, strengths and weaknesses.
- Conducted and steered the “To-Be” process workshops in conjunction with the Fit to ERP and corresponding to industry “best practices”.
- Created data trace map and data quality mapping documents.
- Performed Data Profiling and Data Quality.
- Identify the various business entities and the cross divisional relationships to propose a solution.
- Performed Process Optimization by using Business Process Modeling tools like ARIS.
- Created a comprehensive capture of the “To-Be” business processes in ARIS and came up with Process Manuals that also aided the ERP consultants with obtaining a process view for framing the ERP adherence and for Blueprinting.
- Involved in Updating User Manual and creating User Training Guides using Microsoft PowerPoint
Environment: ARIS, Oracle, SQL Server, JAVA, MS Excel, MS PowerPoint, MS Word and Windows