Mdm Business Analyst Resume
IL
SUMMARY:
- Facilitator between Business Analysis and Information Technology with many years of various environment experiences in the field of business analysis and project management.
- Extensive years of experience with full Software Development Life Cycle (SDLC) including requirements gathering and analysis, design and implementation of major systems.
- Unblemished understanding of Unified Modeling Language (UML) and SDLC models like Rational Unified Process (RUP), Waterfall, Prototyping and Agile.
- Created Entity relationship diagrams (ERD), Function requirement document (FRD), data flow diagrams (DFD) and enforced all referential integrity constraints.
- Experience with Master Data Management, in identifying sources / creating tables and data analysis.
- Experience in understanding database structures and writing SQL/PLSQL statements; review Stored Procedures and Batch Jobs.
- Vast experience in requirement gathering for business and application requirements, business processes, identifying risks, impact analysis, UML modeling, Sequence and Activity Diagrams using Rational Rose and Microsoft Visio.
- Adapted in writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary, Data Migration and Interface Requirements Documents.
- In house experience with project management tools like MS - Project, JIRA, Creative Pro Office for status reporting, planning and error tracking and correcting.
- Proficient in working with UML development tools like MS Visio, Eclipse, Enterprise architecture framework, UML2 Tools, and Power Designer etc.
- Experienced in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Risk Analysis and mitigation plan, Cost benefit analysis and ROI analysis.
- Extensive experience with Business Process Management (BPM).
TECHNICAL SKILLS:
Business Analysis: MS Visio, Test Manager, Test Director, Win Runner
Project Management: MS Project (Server), Creative Pro Office, JIRA, TFS
Operating System: Windows XP, Windows 7, UNIX, Linux, Mac OS
Application: Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Visual Studio, Eclipse, Share Point
Database: MS SQL Server, Oracle 8i, 9i, 10g, MS Access
Methodologies: Agile, Waterfall, UML
PROFESSIONAL EXPERIENCE:
Confidential, IL
MDM Business Analyst
Responsibilities:
- Acted as a liaison between the business and development team in gathering requirements and supporting the MDM team.
- Thoroughly followed Agile methodology throughout the project and conducted Scrum meeting with the team members on day to day basis for the update on project status
- Full understanding of Unified Modeling Language (UML) and SDLC models like Rational Unified Process (RUP), Waterfall, Prototyping and Agile.
- Practiced Agile Scrum development through user stories, standup meetings and close interaction with the clients.
- Created User stories using TFS to project and identify the task size and release cycle.
- Performed Analysis for Confidential Master Data Management team supporting internal teams like (Supply Chain, Restaurant management, Franchisee and Corporate owned stores)
- Supported McDonald’s vendor application system by creating requirement document, business designs and business rules for application customization.
- Integrating data from multiples sources to build reporting spreadsheets and user interface which met business information requirements
- Extensively used SQL queries to perform Data Analysis and Data Profiling.
- Performed data modeling for new sources and subscription coupled with adding entities and attributes.
- Process client requests using data mining tools in SQL Server, and MS Access.
- Performed impact and root cause analysis, which helped in improving efficiency of the current system in production as well as reduced unwanted creation of redundant objects.
- Documented all the sources of customer Data and created Source to Target data mapping.
- Created data flow diagrams using MS VISIO
- Created use cases / user stories for various new data management request.
- Managed sources of DATA entering the system and provided information to clients through generation of reports or regular data dumps based on the client requirements.
- Created CRs and estimations for out of scope request.
- Setup JAD sessions with the development team in identifying and verifying changes or modification made to various Tables, Views, Stores Procedures and attributes.
- Through understanding of batch processes and worked with ETL informatics developers in running of all the batches
- Extracted, compiled and tracked data and analyzed data to generate reports
- Used MS Excel Power BI tool for reporting purpose
- Used TFS (Team Foundation Server) for creating Test Plans, User Stories, Requirements and Assigned task to developers and testers .
Confidential, MN
Curam Business Analyst
Responsibilities:
- Followed Agile and Scrum methodologies for various project phases.
- Involved in Sprint Cycle Planning, Burndown Charts, Story points and Product Backlogs.
- Acted as a liaison between the business and development team, in gathering requirements and designing Health care application using IBM Curam OOTB application.
- Acted as a SME for the offshore development team, by clarifying federal legislation requirements.
- Designed and worked with IBM CURAM framework to implement renewals.
- Designed and documented rules for citizen eligibility for renewing citizen’s eligibility for next year.
- Expertise in process engineering for maintaining business rules procedural and training documents.
- Designed batches to identify and select citizen eligible for next year benefit renewals
- Created VISIO diagrams and workflows in defining system process for the renewal release.
- Created use cases for various batch processes to identify and select the eligible citizen
- Through understanding of batch processes and worked with ETL informatica developers in running of all the batches
- Created online user private insurance shopping cart, topic select insurance programs for non-eligible citizens
- Designed rules for citizen’s eligibility between private and public programs.
- Led contingency project, and provided direction to accomplish task for case closure and duplicate person record.
- GAP analysis for CURAM upgrade for new releases.
- Maintained requirement traceability Matrix to ensure all the releases had all the requirements. Maintained the mapping excel sheet and reported this to the PMT.
- Lead BA for production support on identifying duplicate cases and correcting person record.
- Worked with the integration team for MMIS and Curam integration of cases.
- Created Test plans, test data and testing timelines for all the new releases.
- Managed all the defects through JIRA and maintained traceability matrix.
Confidential, MO
IBM Curam Business Analyst
Responsibilities:
- Business design for MEDES, COTS Missouri state health care eligibility application.
- Followed quick and fast agile development process to develop all applications.
- Conducted formal interviews, Live Meetings and JAD sessions with business users and matter experts.
- Followed extensive Agile methodology in Software implementations by Interviewing Business users, working with the PMO team to identify different release cycles.
- Participated in Daily scrum meetings to discuss any road blocks, project progress and updates to Product Owners.
- Designed and developed Curam Use Cases, Activity Diagrams and Sequence Diagrams using UML.
- Documented, identified, organized and tracked the requirements using Rational Requisite Pro.
- Worked with ETL informatica developers in setting up batch process, staging tables and test cases.
- Created Data Flow Diagrams (DFDs), ER diagrams for data modeling and Web-page mock-ups using MS Visio for acceptance from end users.
- Integrated single secure sign on between IBM Tivoli and Curam to login into different state programs with the same user credentials.
- Implementation of citizen lawful presence program, MEDES (COTS state application) would automate and find out citizen resident status.
- Setup Curam organizational chart for Missouri State.
- Mapped Curam organizational chart and roles for different state users (Sdup worker, HCR case worker, Eligibility specialist, Case worker and MO Admin).
- Designed Curam interface document for inbound/outbound.
- Designed and integrated Curam account creation, role mapping and organizational structures.
- Created business design document for PARIS (Public Assistance Reporting System) for participant that are actively receiving benefit in MEDES.
- Defined project milestones, schedules, and monitored progress using MS-Project, creative pro office and modified, updated the project scheduled plans as required.
- Written down test scripts for Curam business designs and tested them in various environments and launched tickets for Fail or Pass tests.
- Responsible for creating SIPOC, swim-lane, UML use case business process representations.
- Used Curam framework to drive requirements, process flow documents, and subsequent design estimation. Used Query Analyzer, Execution Plan to optimize SQL Queries.
- Worked in Curam evidence mapping for MAGI / non Magi and implementation of business rules.
- Analyzed system configuration and mapped evidence against the DST in Curam
- Responsible for working with Curam Business Application suite.
Confidential
Business Analyst
Responsibilities:
- Gathered requirements from stakeholders for provider management and member management.
- Worked on Agile and Scrum Methodology for Curam app implementation.
- Involved in Scrum meetings and
- Identified and validated business rules and data elements.
- Developed the stakeholder list and created stakeholder assessment matrix to prioritize them.
- Conducted Risk analysis and developed mitigation plans.
- Used JIRA as an AGILE tool to manage defects and tasks.
- Conducted Impact analysis when there is any change in the requirements and updated the Business Requirements Document (BRD) and Systems Requirements Specification (SRS).
- Facilitated meetings with the technical team and client team to analyze the current process and gather requirements for the proposed process.
- Used detailed knowledge of the application features and functionality to assess the scope of the business needs throughout the analysis and completion of enhancement specification.
- Used Curam framework to drive requirements, process flow documents, and subsequent design estimation. Used Query Analyzer, Execution Plan to optimize SQL Queries.
- Conducted Business Impact Assessment and the results were compared with the EHR standards to determine the current level of compliance and developed an action plan for approval by the project steering committee.
- Modeled the ‘as-is’ process flow and the ‘to-be’ process flow and analyzed the gap and developed the action steps to fill the gaps for the EHR and HIPAA compliance.
- Implemented automated COB processing of Medicare claims into Facets
- Active participation in development of Curam Business Application suite.
- Tested and delivered Inbound/Outbound Facets interfaces.
- Designing Functional Specifications for the target physical database.
- Facilitated JAD sessions for Requirement Validation with Dept. Of Health & Human Services (DHHS) to gather requirements for the new MMIS.
- Analyze different data crosswalks, complicated logic & look ups required by different fields for the source to target transformations.
- Worked with legacy team in developing BRD for multiple system change requests and participated in system testing.
- Developed UAT test cases associated with the functional requirements.
- Maintained a bi-weekly status report for the requirements team and incorporated the same to the PMO status reports send to CMS.
- Participated in developing test plan, test scripts, and test scenarios and designed user documentation.
Confidential
Operational Business Analyst
Responsibilities:
- Involved in Requirements Gathering from user groups and analyzed workflows and UI screen dynamics.
- Created Statement of Work (SOW) document for various capabilities in the initial requirements gathering phase.
- Involved in Risk Assessment for each project.
- Involved in the Defect Management process.
- BOM (Bill of Materials) management from Development to Obsolescence Ensuring BOM setup and implementation per Engineering spec End-to-end involvement in all levels of the BOM management: Raw Material >> Sub assembly components >> Packaged SKU >> Finished Goods Inventory
- Ensured all the stages of BOM are effectively qualified and alignment with PLCT to progress to next status.
- Managed 100+ SKUs for CSS product lines.
- Ensured BOMs are ready with all the components for Generic and Non Generic customers.
- Aligned with key teams to ensure key deliverables are met, like Label, Packaging, and Engineering teams.
- Contributed an increase in overall BOM readiness by 20%. Status change aligned 90% on schedule
- Program Manager between Operations, Engineering and Factory from Build to Ship execution Forecast compilation of SSD Drives and sub-assembly component requirements based on Sample Qualification Target timelines Drive material procurement and readiness to meet assembly start dates Launch precise build instructions and work orders with Factory during Customer Qual cycle
- Provided factory with the latest engineering requirements to execute the builds via Assembly Instructions.
- Ensured all deliverables and engineering test programs are ready on time to reduce assembly time.
- Improved overall assembly cycle time by 15% to meet the build qual plan expectation.
- Worked with the Marketing teams and launched work orders to ensure forecast target is met.
- Managed raw material inventory by aligning with the factory on a regular basis and improving the over all availability of resources
- Process liaison with Sales Operations for Sample cockpit Go-live for Consumer SSDs on SAP Portal Management of customer samples using cockpit Order Hold application/ release and PGI (post goods issue) date management accounting for Factory build plan, F/W readiness, BOM changes, Quality verification etc. Management of customer samples using cockpit.
Environment: Rational Rose, Requisite Pro, Java, J2EE, SharePoint 2.0, .Net, MS Word, Excel, Visio, PowerPoint, MS Office Suite.