Sr. Business Analyst/sql Developer Resume
Minneapolis, MN
SUMMARY
- A Business Systems Analyst with over eight plus years of experience in Healthcare industry focusing mainly on Iterative Software Development Lifecycle (SDLC) principles of Agile Methodology and Rational Unified Process (RUP), with extensive experience in the field of Business analysis
- Business modeling, document processing, process re - engineering and decision support systems In-depth knowledge in Claims Processing and Billing Module effective analytical and problem solving skills and hands-on experience in creating UML Diagrams including Use Case Diagrams
- Context Diagrams, Activity Diagrams, Software Requirements Specifications Documentation, and Scope Documents skilled at building a strong team environment, and have the ability to acclimatize to new technologies, conditions and situations with ease; possesses excellent verbal and written communication skills.
- Worked with various modules which include claims processing using EDI X12 transactions like 837, 276/277 and 270/271 which fall under the HIPAA compliance.
- Performed Impact Analysis on moving from ICD-9 to ICD-10 coding system.
- Interacted with stakeholders, gathering requirements, rating them and assigning priorities to each of them.
- Elicitation techniques such as interviewing, brainstorming, focus groups, prototyping, cost/benefit analysis and risk analysis.
- Performed data flow analysis using use cases, dataflow diagrams and activity diagrams.
- Checked and validated requirements in conjunction with the stakeholders.
- Traced requirements throughout development process and verifying adherence.
- Managed requirements using tools like HP Quality Center and Enterprise Architect.
- Managed reporting, analysis and decision-making for a change request.
- Creating use case models in Microsoft Visio.
- Excellent problem solving, team building, judgment and decision making skills.
- Technical writing skills including drafting contracts, documentation and editing of user manuals.
TECHNICAL SKILLS
Languages: C, C++, Visual Basic, SQL, Python, Java, .Net.
Web Technologies: HTML, XML, CSS, PHP.
Databases: Oracle, SQL Server, MS Access.
Operating Systems: Windows 7/Vista/XP/NT/2000, Unix.
Requirement Management Tools: HP Quality Center, Enterprise Architect.
Defect Tracking Tools: HP Quality Center.
Business Modeling Tools: MS Visio, Dia.
SDLC Methodologies: Agile, Rational Unified Process, SCRUM.
Testing Tools: HP Quick Test Professional, HP Quality Center.
Project Management Tools: HP Project and Portfolio Management (PPM), MS Project.
Document Repositories: MS SharePoint 2007.
Office Communication: MS Office Communicator, MS Live Meeting.
Other: Sun VirtualBox, VMWare.
PROFESSIONAL EXPERIENCE
Confidential, Minneapolis, MN
Sr. Business Analyst/SQL Developer
Responsibilities:
- Worked with Procurement, Accounting & Finance, Warehouse Management, Customer Service and Order Management teams to capture requirements for the implementation of High Jump & MS Dynamics SL.
- Responsible for redesigning of business processes based on the advanced capabilities of systems to be implemented.
- Used MS SQL Server 2012 skills extensively for development of multiple data extracts (text files, XML files, CSV files, etc.) from the Warehouse and Testing databases to be provided to external and internal clients alike.
- Responsible for conducting JAD sessions and engaging the business to realize the requirements.
- Created use cases, business requirements documents and functional requirements documents to support the projects.
- Managed specific pieces of the project plan in conjunction with the managers.
- Responsible for integration testing with external vendors.
- Responsible for writing and executing test cases, and assisted in conducting UAT with the business.
- Submitted RFPs to various vendors to understand their product’s capabilities and evaluate whether they would be a suitable fit for DRC’s needs.
- Reviewed responses to RFPs and various other documentation submitted by the vendors and presented to the stakeholders for approval.
- Managed the Scope of Work submitted to the vendors, and captured regular status updates to make sure the work was being completed on time.
- Conducted review sessions with the development team to help them understand the requirements.
- Worked on Crystal Reports and MS Access for generating various reports that were requested by the business groups.
Confidential, Minneapolis, MN
Sr. Business Systems Analyst/SCRUM Master
Responsibilities:
- Followed Agile Methodology including 2-week long Sprints; Daily technical and non-technical Morning meetings for status updates; managed daily project status, risks, roadblocks
- Communicated status updates on a weekly basis to the rest of the teams working closely with the integration team
- Conducted SCRUM stand-ups meetings on a daily basis to capture status updates for the team
- Coordinated with the team to help remove any roadblocks faced by individual team members
- Conducted bi-weekly retrospective sessions and Sprint planning sessions
- Kept Version One up-to-date with the tasks assigned for each team member
- Assisted with Version One task tracking to keep an up-to-date progress of tasks
- Worked with the Product Owner to understand the priorities for Sprint Planning
- Collaborate with remote and on-site vendor partner resources to clarify and agree on design/mapping modifications
- Worked with the System Analysts to capture functional requirements and convert them into technical stories.
- Conducted review session with the development team to help them understand the requirements.
- Conducted process review sessions to modify and update the code delivery process from third party vendors in order to help facilitate faster code delivery for testing.
- Worked with the QA team to review test cases and provide input on any missing and/or required/important test scenarios requested by the business team.
- Assisted with EDI mappings for integration solutions
- Involved with the business partners to define requirements, determine solution alternatives, and develop high-level designs and estimates
- Involved in a continuous updating of the artifacts based on the stakeholder/SME feedback.
- Performed the gap analysis between the As-Is and the To-Be system and evaluating the impact of each gap on the existing application
Confidential, Chicago, IL
Sr. Business Systems Analyst/SCRUM Master
Responsibilities:
- To work with various carriers to gather requirements for the various EDI 834, 820, 835 and proprietary file feeds to be sent to them.
- To work with various groups to ensure their employee data was correctly loaded into Confidential ’s systems for the feeds to be generated properly.
- To work with the development team to make sure they understood the captured requirements in order to proceed with development.
- To conduct internal testing of the EDI 834, 820, 835 and proprietary files that were generated by the dev team.
- To conduct trading partner testing with various carriers to make sure the file conforms to the file specifications provided by them.
- To ensure the weekly load of all EDI 834, 820, 835 and proprietary files was getting correctly loaded into the carrier’s systems
- To provide post-production support for files/records that were flagged as erroneous by the trading partners.
- To lead SCRUM sessions and maintain the backlog of feed configurations that were pending and assign them to various Sprints
- Using JIRA to log and track defects, push feed configs into development from the requirements stage.
Confidential, Naperville, IL
Sr. Business Analyst/SCRUM Master
Responsibilities:
- To develop and maintain a requirements work plan and assess the performance metrics of the team members.
- Implemented a Commercial-off-the-shelf software for making sure enrollment processes are well defined.
- To maintain a bi-weekly status report for the requirements team and in corporate the same for the PMO department.
- To model the ‘as-is’ process flow and the ‘to-be’ process flow and analyzed the gap and developed the action steps to fill the gaps.
- To conduct risk analysis and develop mitigation plans.
- To develop the User Interface (UI) prototypes to capture and validate requirements and spike solutions to the current problem.
- To design Functional Specifications for the target physical database.
- To create monthly/weekly status reports to update the project schedules & deliverable plan.
- To maintain Traceability matrix throughout the project.
- To create standards / guidelines for business process modeling, Use Cases, Work Flows, Data Dictionary, and requirements specifications.
- To gather requirements and generate test data files for EDI 834, 820, 835, 837 transactions.
- To develop UAT test cases associated with the functional requirements.
- To analyze requirements and formulate a Test Plan for testing the functionality, navigation, and integration testing of the application
- To create automation test scripts in QTP for testing various web applications.
- To create the test plan to serve as a guidance for integration testing the software code.
- To create test cases for manual testing of certain software elements.
- To create and track defects through their entire lifecycle from analysis through to fix deployment in the test environment.
- To generate Integration Test and UAT reports to track the status of testing of the EDI 834, 835, 820 837, and XML files.
Confidential, Milwaukee, WI
Business Systems Analyst/SCRUM Master
Responsibilities:
- To develop a process flow that will take the EDI 834s being received from the State Exchanges into internal database systems.
- To develop mapping documents for incoming EDI 834 files from the Exchange to an XML file that would be processed for business validations and further converted to an MMS keyword file that will be uploaded to their internal databases.
- To develop a process flow that will take the EDI 820s being received from the State Exchanges to Oracle’s BRM for revenue collection for the client.
- To develop mapping documents for incoming EDI 820 files from the Exchange to an XML file that would be processed for business validations and further converted to an MMS keyword file that will be uploaded to internal databases.
- To generate new reports for Exchange enrollments for the client, MVP.
- To complete revenue analysis for Exchange payments based on various payment type codes for the client using Oracle’s BRM.
- To analyze the business processes and systems to provide business process improvement ideas.
- Used BaseCamp for Project Management tasks like baseline, change request, project plan, resource assignment and other project related activities.
- Used JIRA for managing user stories and logging issues.
- Worked on data conversion from EDI 834/820 to XML.
- Worked on building a Commercial-off-the-shelf product that could be deployed for various clients with minimal customization.
