Home

I.M - BA Resume - Business Analyst / Data Analyst /database developer

[email protected]

Location: Chicago, Illinois, USA

Relocation: NO

Visa: Ead

Resume file: I.M - BA_1761836017649.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

I.M Seasoned Business Analyst with more than 15 years of experience in converting complex business requirements into accurate technical specifications. Expert in upgrading legacy systems and developing user-centric solutions within Agile and Hybrid SDLC models. A collaborative leader skilled in guiding cross-functional teams, mentoring junior analysts, and leveraging data analysis to deliver strategic, high-quality software solutions. ProfessionalExperience Lead Business Analyst |MazdaNorthAmerica|Irvin,CASep2022 Present Enterprise Data Platform Modernization Led the business analysis efforts to facilitate the migration of Canada's enterprise data systems from legacy SQL Server and Excel reports to a contemporary Snowflake and Power BI platform within a Scaled Agile Framework (SAFe), ensuring technical solutions aligned with strategic business objectives. Gap Analysis: Conducted a comprehensive gap analysis comparing the existing reporting capabilities with the target future state in Snowflake and Power BI. Requirements Gathering: Led comprehensive workshops with Canadian stakeholders to collect and rank requirements for sales reporting, dealer analytics, and financial data. MoSCoW & Prioritization: Used the MoSCoW method to rank data sets and dashboards, targeting high-impact areas for the initial migration. Documentation: Prepared technical design documents and system specifications outlining the data migration process and reporting needs for the development team. Results: The modernization provided Canadian leadership with a unified data source, enabling faster reporting and more reliable business insights. CertifiedPre-Owned(CPO)Reporting Migration Led the initiative to transfer the CPO department's reporting from multiple Excel spreadsheets to a unified Oracle Business Intelligence Enterprise Edition (OBIEE) platform. RequirementsElicitation:ConductedinterviewswiththeCPOdepartment executives and sales teams to identify reporting needs, KPIs, and data definitions related to dealer performance, vehicle inventory, and sales incentives. Data Analysis: Developed a mapping document that links data from existing Excel reports to OBIEE data models, ensuring data integrity and consistency during migration. Documentation:Created comprehensive Business Requirement Documents (BRD) and use case documents to support development and testing. Results: The migration delivered near-real-time, interactive dashboards to theCPOdepartment,removingtheneedformanualreportsandsupporting more data-driven decisions. EnterpriseEyeQPromoCodeDataExchange Led the data exchange project for promo code details in the Enterprise EyeQ system, facilitating smooth integration with marketing and customer management platforms. Process Mapping: Outlined the entire process of generating, distributing, and redeeming promo codes, while pinpointing gaps and inefficiencies in the current workflow. System Integration: Worked with cross-functional teams and external vendors to establish data transfer protocols and validation rules. Use Cases & Test Plans: Created detailed use case scenarios and test plans to verify the accuracy and functionality of the promo code data exchange, ensuring a seamless user experience. SeniorBusinessAnalyst|Ascension|St.Louis,MO May2018-Aug2022 AccountsReceivable(AR) Optimization Led a project aimed at analyzing and decreasing outstanding accounts receivable, with an emphasis on aged claims. Created a system specification document for a new dashboard with tools such as Tableau, offering leadershipreal-time insightsinto AR performance. Used RACI matrices to define responsibilities for collections follow-up and appeals, resulting in a 50% decrease inAR pending follow-up. ClaimsDenialManagementandAppealsAutomation Identified the root causes of ongoing claim denials through thorough data analysis and process reviews. Prepared BRDs and use case documents for creating an automated denial management system, ensuring integration with existing billing software. Used a Kanban methodology to oversee the project, leading to a 20% reduction in medical claim denials and notable improvements in operational efficiency. ChargeCaptureProcess Improvement Performed a thorough analysis comparing the current and future charge capture processes across various service lines to reduce revenue leakage. Conducted requirements gathering meetings with clinical and billing teams to pinpoint system deficiencies and develop improvement plans. Provided a system specification document for implementing an updated charge capture module within the EHR, resulting in an estimated $2M boost in yearly cash flow. PatientFinancialServices Modernization Outlined the requirements for updating the patient registration and financial systems to enhance patient experience and ensure earlier collections. Created comprehensive use case documents for a new patient financial portal, detailing features such as online bill pay, pre-registration, and insurance verification. Utilized the MoSCoW prioritization technique to manage stakeholder expectations and define project scope throughout the entire project lifecycle. SeniorBusinessAnalyst|Toyota|Chicago, IL Mar2016-Apr 2018 Led the development of technical design documents for applications that support vehicle logistics and parts distribution, ensuring alignment with business requirements. Created Initiatives, Epics, and User Stories with detailed requirementdescriptions and user acceptance criteria. Created detailed use case documents to define system functionalities and assist the quality assurance team in developing thorough test cases. Facilitate daily Scrum meetings with development teams to get updates on the assigned stories. Collaboratedwithsystemarchitectstoreviewthetechnicaldesign documents. Ledcomprehensiveuseracceptancetesting(UAT)toverifythatsolutionsaligned with business requirements and quality criteria, resulting in a decrease in post- release defects. BusinessAnalyst| Cargill|Hopkins,MN Jun2013 -Feb2016 Acted as the business analyst overseeing the development and launch of a next-generation digital platform for feed formulation, aimed at optimizing nutrient profiles and reducing costs for customers. Collected and recorded requirements from nutritionists, sales teams, and animal scientists to ensure the application addressed the various needs of the business and its clients. Collaborated with development teams to integrate the platform into existing supply chain and commodity management systems, ensuring smooth data exchange for pricing and inventory management. Mapped the current and future state process flows to optimize the formulation workflow, enhancing efficiency and shortening the time to market for new feed products. Analyzed and documented supply chain processes in the animal nutrition sector to boost efficiency, lower costs, and enhance transparency. Used data analysis to pinpoint bottlenecks in the supply chain, including transportation delays and warehouse inefficiencies, and offered actionable insights to management. Created and managed KPI dashboards for supply chain management with BI tools to track performance against goals. BusinessAnalyst|SureDecisions|CapeGirardeau,MO Jul2010 -May 2013 ContractModelingApplicationModernization Led the complete business analysis for modernizing the contract modeling application, which directly improved the efficiency of the revenue cycle process. Requirements Elicitation: Led interviews, workshops, and surveys with revenue cycle stakeholders, finance teams, and legal personnel to gather and document business needs for the new contract modeling system. Reimbursement Calculation: Worked with subject matter experts to convert complex payer contracts and fee schedules into straightforward business rules for the application, enabling precise reimbursement estimates. Process Analysis: Created current and future state flow diagrams to visualize and improve the revenue cycle's contract modeling process, making workflows more efficient and decreasing manual work. Documentation: Created detailed BRDs and system specification documents that specify both functional and non-functional requirements for the development team. Agile Methodology: Facilitated Agile ceremonies like sprint planning and backlog grooming to assist the development team in making iterative improvements to the application. User Acceptance Testing (UAT): Assisted in UAT activities, outlined test scenarios, and collaborated with client teams to verify the correctness of reimbursement calculations. Results: The updated application led to a decrease in billing discrepancies through more precise reimbursement estimates and greatly sped up the contract loading process. Skills CoreCompetencies BusinessProcessAnalysis RequirementsElicitation&Documentation Agile/HybridMethodologies(Scrum,Kanban,SAFeAgile) Legacy SystemModernization TechnicalDesignReview DataAnalysis&Insights StrategicPlanning MoSCoWPrioritization RACI Matrix TechnicalProficiencies Tools:Jira,Confluence,MicrosoftVisio,SQL,Tableau,PowerBI Methodologies:Agile,Scrum,Kanban,DevOps,SAFe DatabaseSystems:SQLServer,Snowflake Education Master'sinInformationSystems-Dec2009 Robert Morris University Training Successfullycompletedthe8-sessiontrainingon: BusinessAnalysisProfessional(CBAP) AgileCertifiedPractitioner(PMI-ACP) I.M Seasoned Business Analyst with more than 15 years of experience in converting complex business requirements into accurate technical specifications. Expert in upgrading legacy systems and developing user-centric solutions within Agile and Hybrid SDLC models. A collaborative leader skilled in guiding cross-functional teams, mentoring junior analysts, and leveraging data analysis to deliver strategic, high-quality software solutions. ProfessionalExperience Lead Business Analyst |MazdaNorthAmerica|Irvin,CASep2022 Present Enterprise Data Platform Modernization Led the business analysis efforts to facilitate the migration of Canada's enterprise data systems from legacy SQL Server and Excel reports to a contemporary Snowflake and Power BI platform within a Scaled Agile Framework (SAFe), ensuring technical solutions aligned with strategic business objectives. Gap Analysis: Conducted a comprehensive gap analysis comparing the existing reporting capabilities with the target future state in Snowflake and Power BI. Requirements Gathering: Led comprehensive workshops with Canadian stakeholders to collect and rank requirements for sales reporting, dealer analytics, and financial data. MoSCoW & Prioritization: Used the MoSCoW method to rank data sets and dashboards, targeting high-impact areas for the initial migration. Documentation: Prepared technical design documents and system specifications outlining the data migration process and reporting needs for the development team. Results: The modernization provided Canadian leadership with a unified data source, enabling faster reporting and more reliable business insights. CertifiedPre-Owned(CPO)Reporting Migration Led the initiative to transfer the CPO department's reporting from multiple Excel spreadsheets to a unified Oracle Business Intelligence Enterprise Edition (OBIEE) platform. RequirementsElicitation:ConductedinterviewswiththeCPOdepartment executives and sales teams to identify reporting needs, KPIs, and data definitions related to dealer performance, vehicle inventory, and sales incentives. Data Analysis: Developed a mapping document that links data from existing Excel reports to OBIEE data models, ensuring data integrity and consistency during migration. Documentation:Created comprehensive Business Requirement Documents (BRD) and use case documents to support development and testing. Results: The migration delivered near-real-time, interactive dashboards to theCPOdepartment,removingtheneedformanualreportsandsupporting more data-driven decisions. EnterpriseEyeQPromoCodeDataExchange Led the data exchange project for promo code details in the Enterprise EyeQ system, facilitating smooth integration with marketing and customer management platforms. Process Mapping: Outlined the entire process of generating, distributing, and redeeming promo codes, while pinpointing gaps and inefficiencies in the current workflow. System Integration: Worked with cross-functional teams and external vendors to establish data transfer protocols and validation rules. Use Cases & Test Plans: Created detailed use case scenarios and test plans to verify the accuracy and functionality of the promo code data exchange, ensuring a seamless user experience. SeniorBusinessAnalyst|Ascension|St.Louis,MO May2018-Aug2022 AccountsReceivable(AR) Optimization Led a project aimed at analyzing and decreasing outstanding accounts receivable, with an emphasis on aged claims. Created a system specification document for a new dashboard with tools such as Tableau, offering leadershipreal-time insightsinto AR performance. Used RACI matrices to define responsibilities for collections follow-up and appeals, resulting in a 50% decrease inAR pending follow-up. ClaimsDenialManagementandAppealsAutomation Identified the root causes of ongoing claim denials through thorough data analysis and process reviews. Prepared BRDs and use case documents for creating an automated denial management system, ensuring integration with existing billing software. Used a Kanban methodology to oversee the project, leading to a 20% reduction in medical claim denials and notable improvements in operational efficiency. ChargeCaptureProcess Improvement Performed a thorough analysis comparing the current and future charge capture processes across various service lines to reduce revenue leakage. Conducted requirements gathering meetings with clinical and billing teams to pinpoint system deficiencies and develop improvement plans. Provided a system specification document for implementing an updated charge capture module within the EHR, resulting in an estimated $2M boost in yearly cash flow. PatientFinancialServices Modernization Outlined the requirements for updating the patient registration and financial systems to enhance patient experience and ensure earlier collections. Created comprehensive use case documents for a new patient financial portal, detailing features such as online bill pay, pre-registration, and insurance verification. Utilized the MoSCoW prioritization technique to manage stakeholder expectations and define project scope throughout the entire project lifecycle. SeniorBusinessAnalyst|Toyota|Chicago, IL Mar2016-Apr 2018 Led the development of technical design documents for applications that support vehicle logistics and parts distribution, ensuring alignment with business requirements. Created Initiatives, Epics, and User Stories with detailed requirementdescriptions and user acceptance criteria. Created detailed use case documents to define system functionalities and assist the quality assurance team in developing thorough test cases. Facilitate daily Scrum meetings with development teams to get updates on the assigned stories. Collaboratedwithsystemarchitectstoreviewthetechnicaldesign documents. Ledcomprehensiveuseracceptancetesting(UAT)toverifythatsolutionsaligned with business requirements and quality criteria, resulting in a decrease in post- release defects. BusinessAnalyst| Cargill|Hopkins,MN Jun2013 -Feb2016 Acted as the business analyst overseeing the development and launch of a next-generation digital platform for feed formulation, aimed at optimizing nutrient profiles and reducing costs for customers. Collected and recorded requirements from nutritionists, sales teams, and animal scientists to ensure the application addressed the various needs of the business and its clients. Collaborated with development teams to integrate the platform into existing supply chain and commodity management systems, ensuring smooth data exchange for pricing and inventory management. Mapped the current and future state process flows to optimize the formulation workflow, enhancing efficiency and shortening the time to market for new feed products. Analyzed and documented supply chain processes in the animal nutrition sector to boost efficiency, lower costs, and enhance transparency. Used data analysis to pinpoint bottlenecks in the supply chain, including transportation delays and warehouse inefficiencies, and offered actionable insights to management. Created and managed KPI dashboards for supply chain management with BI tools to track performance against goals. BusinessAnalyst|SureDecisions|CapeGirardeau,MO Jul2010 -May 2013 ContractModelingApplicationModernization Led the complete business analysis for modernizing the contract modeling application, which directly improved the efficiency of the revenue cycle process. Requirements Elicitation: Led interviews, workshops, and surveys with revenue cycle stakeholders, finance teams, and legal personnel to gather and document business needs for the new contract modeling system. Reimbursement Calculation: Worked with subject matter experts to convert complex payer contracts and fee schedules into straightforward business rules for the application, enabling precise reimbursement estimates. Process Analysis: Created current and future state flow diagrams to visualize and improve the revenue cycle's contract modeling process, making workflows more efficient and decreasing manual work. Documentation: Created detailed BRDs and system specification documents that specify both functional and non-functional requirements for the development team. Agile Methodology: Facilitated Agile ceremonies like sprint planning and backlog grooming to assist the development team in making iterative improvements to the application. User Acceptance Testing (UAT): Assisted in UAT activities, outlined test scenarios, and collaborated with client teams to verify the correctness of reimbursement calculations. Results: The updated application led to a decrease in billing discrepancies through more precise reimbursement estimates and greatly sped up the contract loading process. Skills CoreCompetencies BusinessProcessAnalysis RequirementsElicitation&Documentation Agile/HybridMethodologies(Scrum,Kanban,SAFeAgile) Legacy SystemModernization TechnicalDesignReview DataAnalysis&Insights StrategicPlanning MoSCoWPrioritization RACI Matrix TechnicalProficiencies Tools:Jira,Confluence,MicrosoftVisio,SQL,Tableau,PowerBI Methodologies:Agile,Scrum,Kanban,DevOps,SAFe DatabaseSystems:SQLServer,Snowflake Education Master'sinInformationSystems-Dec2009 Robert Morris University Training Successfullycompletedthe8-sessiontrainingon: BusinessAnalysisProfessional(CBAP) AgileCertifiedPractitioner(PMI-ACP) Keywords: business intelligence Arkansas Illinois Minnesota Missouri