Sardar Khan Email and Phone Number

• Review and refine user stories by gathering requirements and communicating with the Developer team.• Create documentation such as user guides, FAQ, Quick Guides while building a Center of Excellence• Lead UAT/QA testing for current sprints.• Experienced in Software Development Life Cycle (SDLC) methodologies such as Waterfall and Agile, adept at requirements gathering, design, implementation, testing, deployment, and maintenance. Skilled in Business Analysis methodologies including Agile Analysis, Lean Analysis, and Business Process Modeling (BPM), with expertise in eliciting, documenting, and validating requirements to align with business objectives• Interacted with various business team members to gather the requirements and documented the requirements.• Analyzed the Scope of the Requirements, and managed requirements to avoid Scope Creep.• Participated in Requirement Gathering Sessions & JAD Sessions.• In charge of conducting the UAT with the Business users and gathering feedback and providing the same to the Development team.• Reviewing the test cases provided by the QA team and providing feedback.• Used field level security along with page layouts to manage access to certain fields.• Designed and deployed Custom tabs, Validation rules, and Auto-Response Rules for automating business logic.• Created user Roles and Profiles and sharing settings.• Created workflow rules and defined related tasks, email alerts, and field updates.• Developed a web-to-lead functionality to vertrue.com site which directs leads to Salesforce CRM.• Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization.• Familiar with Twilio CTI salesforce application which is used to provide agents with click-to-dial and screen pop capabilities.

• Prepared Business Requirements Documents, Functional Requirement Documents.• Conducted JAD sessions, meetings, workshops to gather requirements from various stakeholders and SMEs.• Facilitated all Aspects of scrum framework, including product backlog, release backlog, sprint planning session, daily scrum meeting, sprint reviews and sprint retrospectives.• As scrum master communicated dependencies and potential risk to the completion of the sprints including resources, costs and systems.• Created data mappings to transform the data according to business rules.• Developed Test Cases for unit testing, prepared spreadsheet for testing criteria, including regression, positive and negative testing, process flow testing and screenshot for test results to complete expected and actual results.• Provide strategic consulting services to healthcare organizations and life science companies, leveraging expertise in biology, genetics, and healthcare delivery.• Conduct market research and competitive analysis to identify growth opportunities and inform business strategy development.• Analyze healthcare data sets, including patient outcomes, clinical trials, and population health data, to derive actionable insights.• Collaborate with clients to define and document business requirements for healthcare IT systems and data analytics solutions.• Develop business cases, feasibility studies, and ROI analyses to support investment decisions and strategic initiatives.• Facilitate workshops and stakeholder meetings to gather requirements, prioritize initiatives, and drive consensus.• Provide subject matter expertise on healthcare industry trends, regulatory requirements, and best practices to clients and project teams.• Conducted project related Presentations periodically to the management and end users during various phases of Software Development Life Cycle SDLC.

• Review and refine user stories by gathering requirements and communicating with the Developer team.• Lead UAT/QA testing for current sprints.• Create documentation such as user guides, FAQ, Quick Guides while building a Center of Excellence.• Support the Business by working requests such as user profile updates, permission set changes, troubleshooting errors, cleaning up data, etc.• Proficient in using Excel to import, clean, and transform data from various sources to facilitate informed decision-making.• Designed visually appealing and informative presentations using Excel charts and graphs, enhancing the communication of complex data to stakeholders.• Proficient in customizing chart styles and formats to align with branding and presentation standards.• Provide efficient and effective analysis and impact of transfer businesses (in and out) of regions or among producers. • Calculate and review producer compensation, incentive, and bonuses, including impact of new business, lost business, change in market and transfers.• Record keeping of Licenses and permits as required.• Business Trend analysis of trailing twelve months for new/lost business and six months for change in market.• Create and present producer dashboard from databases for leaders to monitor individual producer’s performances. • Setting targets/goals for unvalidated producers and helping them achieve goals by providing them monthly/quarterly performances analysis on their book of business.

• Analyze change in market and timing of payment process. Forecast the change of market and timing as per the renewal of contracts and policies.• Applied hands-on expertise in SQL within the dynamic banking environment, showcasing adeptness in crafting intricate queries and building robust functions to facilitate seamless data retrieval, analysis, and manipulation for informed decision-making and enhanced operational efficiency• Leveraged financial analysis to optimize marketing strategies, collaborating with cross-functional teams to align budget allocation with high-impact campaigns, resulting in a 20% increased on revenue growth.• Conducted comprehensive financial evaluations of marketing campaigns, from initial budget forecasting to post-campaign analysis, providing actionable insights that led to 10% cost reduction and enhanced performance by targeting the right sets of customers, while ensuring alignment with organizational financial objectives.• Effectively showcased an in-depth mastery of Extract, Transform, Load (ETL) processes through practical engagement, driving successful data integration and transformative initiatives that optimized information flow, accuracy, and utility• Created intricate financial models in Excel, incorporating dynamic formulas and scenario analysis to support forecasting and budgeting processes.• Expertise in building cash flow projections, sensitivity analyses, and valuation models using Excel.• Managed and maintained large datasets in Excel, employing sorting, filtering, and data validation techniques to ensure data accuracy and integrity.• Proficient in using Excel to import, clean, and transform data from various sources to facilitate informed decision-making.• Designed informative presentations using Excel charts and graphs, enhancing the communication of complex data to stakeholders.• Provide efficient and effective analysis and impact of transfer businesses (in and out) of regions or among producers.

• Prepare, review, and analyze forecasts and recommend changes when appropriate. • Prepare monthly financial analysis and operational metric performance for presentation to Senior Leadership team.• Skillfully showcased a comprehensive understanding of Extract, Transform, Load (ETL) processes through hands-on experience, notably optimizing data integration and transformation initiatives within the credit card business of a banking environment. This proficiency contributed to streamlined information flow, heightened accuracy, and enhanced operational efficiency, crucial for efficient credit card transaction processing and risk assessment.• Applied SQL expertise to generate customized financial reports, streamlining data presentation for management reviews and regulatory compliance.• Design, generate, review, and communicate P&L statement to key stake holders.• Negotiate pricing with vendors to improve profit margins and reduce costs.• Utilized Excel to conduct quantitative analysis of financial data, including variance analysis, trend identification, and statistical modeling.• Applied advanced Excel tools to perform regression analysis, correlation studies, and Monte Carlo simulations for risk assessment.• Inventory analysis and management of products as required.• Financial reporting to higher management and be a part of decision-making as per analytical reports. • Manage the financial planning, financial modeling, forecast and budgeting processes and their continued development focusing on maximum company-wide support, efficiency, and accuracy.• Responsible of two business types; Food and service, how to find the room for improvement by using different analytical techniques like SWAT analysis etc.• Cost saving and increased profit margin by detailed financial statement analysis with higher management. • Train new team members on tools, procedures, processes, administration, and governance with leadership management guidance.

Generate complex and interpretive financial analyses. Provide periodic reports and special studies. Provide forecasts, statistical reports, including financial performance, variance explanations, and cost analysis to senior management. • Design, generate, review, and understand reports through SQL queries. Use aggregate data from multiple sources to assist in creating a complete analysis, improvement and/or recommendation.• Subject Matter Expert (SME) for key systems/processes in Tableau reporting and its functions.• Review the accuracy of information provided and responds to requests from teams in MENA Region.• Prepare and present results of analysis and reports along with their relative impact(s) to the business to all levels of management. • Project lead including supervisory and/or managerial activities, in the coordination of the analyst team to successfully complete specified projects between/among different LMA (Local Market Area) for Mortgages, business unit, large department or work group.• Ensure shared knowledge to implement process improvement and performance improvement in business operations.• Data extraction from several tools such as Business Intelligence, TM1, COGNOS to make reports in Excel, and dashboards in Tableau. • Manage companywide KPIs by establishing appropriate scorecards and tracking mechanism.

• Data mining, data manipulation, Data modeling and running queries in MS Access.• Receipt of Collection MIS of all Merchants across the country• On Us and Off Us, transaction comparison and helped Business unit to target potential merchants• Customer Master Data cleansing and updating the master record in SAP CRM and build queries through SQL in relational databases.• Extract data from SAP to Excel for manipulation and make models.• Analysis of Master Data with other sources in MS Excel, MS Access, and SAP CRM.