Business Intelligence Machine Learning
Resume:
To, Manager,
Human Resource Department.
SUBJECT: Application for an above Position vacant.
Respected Sir,
I am writing to express my keen interest in the position Vacant at your esteemed organization, as advertised. With a strong background as a Senior Oracle EBS Techno-Functional professional, Qlik Sense & Power BI Consultant, Oracle Analytics Pro, Machine Learning Associate, and Financials Process Specialist with proficiency in Oracle Cloud, I am confident in my ability to contribute effectively to your team. During my tenure at Accelerated Technology Inc. spanning over seventeen years, I have honed my skills in designing, developing, and maintaining dashboards and reports that provide actionable business intelligence relevant to our products and services. My experience extends to identifying impactful trends, usage patterns, and growth patterns, allowing me to make informed and strategic decisions in collaboration with cross-functional teams.
Working closely with products and engineering teams, I have successfully implemented data-driven strategies by processing available data. My hands-on experience in data analysis, coupled with strong problem-solving skills, has equipped me to answer complex analytic questions with precision. Enclosed with this letter is a copy of my curriculum vitae, providing a comprehensive overview of my background and qualifications. I am confident that my skill set aligns well with the requirements of the position, and I am enthusiastic about the opportunity to contribute to the success of your organization. I appreciate your consideration of my application and am available at your earliest convenience to discuss how my experiences and skills can contribute to the goals of your team. Thank you for your time, and I look forward to the possibility of joining your esteemed organization. Again, thank you for your consideration.
Yours Sincerely,
SALMAN AHMAD KHAN
Mob: +1-571-***-****
Email. ******.***.****@*****.***
LinkedIn: www.linkedin.com/in/salman-ahmad-khan
Curriculum Vitae
SALMAN AHMAD KHAN
Email: ******.**.****@*****.***/ *********.******@*******.*** Location : Sterling,Virginia, United States of America Cell: +1-571-***-****
2
SUMMARY
• More than 17 years of professional experience of working on different projects with different organization.
(7 years Microsoft and 10 years Oracle platform)
• Bachelor’s Degree from University of Karachi in Computer Science in 2006.
• Demonstrated leadership ability and experience in team management.
• Exceptional analytical and problem-solving skills, with a data-driven approach.
• Business Intelligence Management professional with more than 8 years of experience organizing competitive intelligence for marketing and sales action planning.
• Knowledgeable in the drivers of customer satisfaction, brand awareness and visibility, loyalty, and corporate technology usage.
• Proven leader utilizing strong interpersonal skills to build consensus towards organizational short- and long- term goals while fostering accountability and productivity.
• Strong MSSQL / Oracle database experience in writing store procedures, triggers, queries and performance.
• Functionally hands on experience in Finance Modules like General Ledger, Fixed Asset, Sub-Ledger Accounting, Payables, Cash Management and Receivables.
• Experience in ERP software implementation, client interaction.
• A dedicated worker who works well under pressure & develops resourceful solutions and to be an active member of a team of professionals accustomed with enthusiasm.
• Identifying opportunities for team training and skills advancement.
• Assuring that IT activities are within the limits of applicable laws, codes and regulations.
• Remaining up to date with advances in technology and industry best practices.
• Multi-tasking and time-management skills, with the ability to prioritize tasks.
• Highly organized and detail-oriented.
• Demonstrated leadership qualities and experience in project management. TECHNICAL SKILLS
• Efficient at streamlining IT operations.
• Business Intelligence, Data Analysis, Program Management, Business Analysis, SQL.
• Proven expertise in Microsoft Power BI and data visualization tools.
• Solid understanding of Oracle Apex and application development principles
• Skilled at formulating long-term strategic IT plan.
• Agile Framework.
• Infrastructure development.
• Project Lifecycle Management.
• Requirement Analysis.
• Brainstorming ideas and benchmarking them against your competition.
• Integration expertise with ecommerce platforms.
• Modelling and predicting potential outcomes and financial impacts.
• Undertaking qualitative, quantitative and cost analyses.
• Presenting and reporting the results of analysis to a broad audience.
• Prepared solicitations competitive bids for prospect suppliers.
• Conducted sourcing events and worked closely with Business Development in planning finding relevant suppliers.
• Worked with IT and purchasing departments to develop and implement an upgraded, expanded CCTV security monitoring system.
• Build and manage a high-performing team of data analysts and IT professionals dedicated to analytics and ERP support.
• Efficient with data warehousing and ETL processes to ensuring data quality and accessibility for BI solutions.
Curriculum Vitae
SALMAN AHMAD KHAN
Email: ******.**.****@*****.***/ *********.******@*******.*** Location : Sterling,Virginia, United States of America Cell: +1-571-***-****
3
Programming Languages : Oracle,C#.Net, VB.Net, JavaScript. Database : Oracle / SQL
BI Tools : Microsoft Power BI, Qlik Sense, Qlik View Markup Languages : HTML, CSS, Media Query, XML,, LINQ, XML, WCF, JSON. Other Tools : Jira, OA Framework, PL/SQL, Workflows and Report Builder, BI Publisher, Oracle Forms, Oracle JDeveloper, Web Services, SSRS and Crystal Report. Skills: Microsoft Power BI, Oracle Apex, ERP Implementation, Data Governance, Team Leadership, Strategic Planning, Continuous Improvement, Stakeholder Collaboration, Vendor Management, Communication, Project Management.
Certification for Oracle Cloud Infrastructure
Sno
Exam
Number
Exam or Assessment Title
Course
Detail
1 1Z0-1107-2 Oracle Financials Business Process Foundations Associate Rel 2 View 2 1Z0-770 Oracle APEX Cloud Developer Professional View 3 1Z0-1110-23 Oracle Cloud Infrastructure 2023 Data Science Professional View 4 1Z0-1096-23 Oracle Machine Learning using Autonomous Database 2023 Associate View 5 1Z0-1041-23 Oracle Cloud Infrastructure 2023 Enterprise Analytics Professional View 6 1Z0-1085-23 Oracle Cloud Infrastructure 2023 Foundations Associate View 7 1Z0-1105-23 Oracle Cloud Data Management 2023 Foundations Associate View 8 1Z0-1122-23 Oracle Cloud Infrastructure 2023 AI Foundations Associate View ORGANIZATION DETAILS
Sno Organization Position Duration
1 Freelance (USA) Oracle EBS (Techo-Functional) Feb 2025 to date 2 Patel Hospital (PAK) Lead of ERP Application and Business Intelligence
Aug 2022 to Jan 2025
3 Gul Ahmed Textile Mills Limited
(PAK)
Manager IT April 2021 to March 2022
4 Pakistan Cables Limited (PAK) Senior Executive Software May 2015 to April 2021 5 Al Busalah Al Lienah Systems (DXB) Project Manager May 2013 to Feb 2015 6 Pakistan Cables Limited (PAK) Software Developer Aug 2007 to April 2013 7 Naveena Textiles(PAK) Software Developer Jul 2006 to Jul 2007 Curriculum Vitae
SALMAN AHMAD KHAN
Email: ******.**.****@*****.***/ *********.******@*******.*** Location : Sterling,Virginia, United States of America Cell: +1-571-***-****
4
PROJECTS DETAILS
Project#1:
Title : Oracle EBS Implementation (Purchase to Pay, Order to Cash and General Ledger) Client : Patel Hospital
Domain : Healthcare
Project Type : Closing of Legacy parallel System and Transformation to Oracle EBS. Team Size : 12
Role : Senior Techno-Functional Oracle EBS and Project Manager. Period : Aug 2022 – June 2023
Technologies used: OA Framework, PL/SQL, Workflows and Report Builder and BI Publisher, SQL Developer, Oracle Form and Toad for Oracle.
Roles and Responsibilities:
1. Strategic Planning:
• Develop and execute a strategic plan for Oracle E-Business Suite (EBS) implementation in Purchase to Pay (P2P), Order to Cash (O2C), and General Ledger (GL) modules.
• Align ERP and BI initiatives with organizational goals. 2. Team Leadership:
• Lead and manage a cross-functional team for efficient ERP implementation.
• Provide direction, mentorship, and performance feedback to team members. 3. Oracle EBS Implementation:
• Oversee end-to-end implementation of Oracle EBS in Purchasing, Inventory, Order Management, Cost Management, Account Payables/Receivables, Cash Management, Fixed Assets and General Ledger modules.
• Ensure compliance with industry standards and streamline processes for optimal efficiency. 4. Custom Integration:
• Design and implement seamless integration solutions for Inventory and Billing modules.
• Collaborate with IT teams and external vendors to ensure successful data integration. 5. Change Management:
• Lead change management efforts for smooth ERP adoption.
• Develop and execute training programs to facilitate user transition. 6. Risk Management:
• Identify and mitigate risks associated with ERP implementation and integration.
• Develop contingency plans to ensure project timelines. 7. Performance Optimization:
• Implement monitoring tools to track and optimize Oracle EBS and BI performance.
• Recommend and implement improvements for enhanced system efficiency. 8.Vendor Management:
• Engage with Oracle and other vendors to stay informed on product updates.
• Manage vendor relationships for timely support and issue resolution. 9. Reporting and Communication:
• Provide regular updates to executive leadership on ERP and BI project status.
• Communicate effectively with stakeholders to ensure alignment. 10. Continuous Improvement:
• Drive ongoing improvements in ERP and BI processes.
• Stay updated on industry trends for enhanced system capabilities. Project#2:
Curriculum Vitae
SALMAN AHMAD KHAN
Email: ******.**.****@*****.***/ *********.******@*******.*** Location : Sterling,Virginia, United States of America Cell: +1-571-***-****
5
Title : Business Intelligence Dashboards (Clinical and Non-Clinical) Client : Patel Hospital
Domain : Healthcare
Project Type : Dynamic Reporting (Supply Chain, Emergency Room KPI’s) Team Size : 12
Role : Senior Techno-Functional Oracle EBS and Project Manager. Period : Jul 2023 – Nov 2023
Technologies used: Microsoft Power BI and Oracle Apex, PL/SQL, SQL Developer and Toad for Oracle. Roles and Responsibilities:
1. Project Leadership:
• Spearhead the KPI Project from inception to completion, ensuring successful delivery within timeline.
• Manage project scope, milestones, and resources while driving clear communication and collaboration across stakeholders.
• Identify and mitigate potential risks and challenges to maintain project momentum and achieve desired outcomes.
• Data warehousing and ETL processes: ensuring data quality and accessibility for BI solutions. 2. Data & KPI Definition:
• Collaborate with procurement and finance teams to define comprehensive sets of KPIs aligned with organizational objectives and created twelve KPIs like (Order Fill Rate, Procurement Cycle Time, Po Processing Time, Amendments In Pos, Percentage Of Cash Purchases And Contractual, Request Fill Rate, Inventory Turnover Ratio, Days In Inventory, Slow Moving Stock, Dead Stock, Pending PR, Expired Stock, Total Average Length of Patient Stay, LAMA Month Average) .
• Map KPIs to relevant data sources within the ERP system and external databases.
• Implement data quality control measures to ensure reliable and consistent data for analysis. 3. BI and Visualization:
• Utilize Microsoft Power BI to build interactive dashboards and reports showcasing key procurement metrics and trends.
• Design compelling data visualizations for easy comprehension and actionable insights.
• Develop custom applications in Oracle Apex to enhance user experience and streamline data access for procurement teams.
4. ERP Optimization:
• Evaluate and optimize the ERP system for efficient data extraction and integration with BI tools.
• Automate routine tasks and workflows within the ERP system to free up resources for strategic analysis.
• Promote data governance practices to ensure data integrity and security throughout the project. 5. Communication and Collaboration:
• Communicate project progress and insights to stakeholders through engaging presentations and reports.
• Facilitate data literacy workshops to empower procurement teams with data analysis skills.
• Collaborate with IT and other departments to ensure seamless integration of the BI solution within the organization.
Project#3:
Title : Point of Sales (Oracle Apex)
Client : Patel Hospital
Domain : Healthcare
Project Type : Pharmacy Sales integrated with Oracle EBS. Team Size : 4
Role : Senior Techno-Functional Oracle EBS and Project Manager. Period : Aug 2023 – Nov 2023
Technologies used: Microsoft Power BI and Oracle Apex, PL/SQL, SQL Developer and Toad for Oracle. Curriculum Vitae
SALMAN AHMAD KHAN
Email: ******.**.****@*****.***/ *********.******@*******.*** Location : Sterling,Virginia, United States of America Cell: +1-571-***-****
6
Roles and Responsibilities:
• Lead the strategic design and implementation of a customized Oracle Apex-based POS solution.
• Integrate the POS system seamlessly with your existing ERP system, ensuring data accuracy and real- time updates.
• Optimize workflows and processes to enhance operational efficiency and streamline sales transactions.
• Drive user adoption and training to empower employees and maximize system utilization. Project#4:
Title : Purchase Order Standard Oracle EBS Approval System (Oracle Apex) Client : Patel Hospital
Domain : Healthcare
Project Type : Out of on-premises Management Approvals. Team Size : 4
Role : Senior Techno-Functional Oracle EBS and Project Manager. Period : Aug 2023 – Nov 2023
Technologies used: Oracle Apex, PL/SQL, SQL Developer and Toad for Oracle. Roles and Responsibilities:
1. System Analysis and Redesign:
• Evaluate the existing PO Approval System in Oracle EBS, identifying pain points, inefficiencies, and potential for improvement.
• Collaborate with procurement and finance teams to define desired functionalities and user requirements for the optimized system.
• Design a flexible and scalable PO Approval System architecture utilizing the strengths of Oracle Apex for faster processing, improved user experience, and enhanced analytics. 2. Apex Development and Integration:
• Develop a custom and intuitive PO Approval application within Oracle Apex, integrating seamlessly with the existing Oracle EBS environment.
• Automate routine tasks and workflows to reduce manual work, errors, and processing time.
• Implement dynamic approval routing rules based on pre-defined parameters and user roles, ensuring efficient decision-making.
• Integrate real-time data visualization dashboards for transparent tracking of PO approvals and budget expenditure.
Project#5:
Title : Cloud Transformation and Oracle EBS 12.1.0 upgradation Client : Gul Ahmed Textile Mills Limited
Domain : Textiles
Project Type : Upgradation 12.1.3 to 12.2.10
Team Size : 12
Role : Manager IT
Period : April 2021 – June 2021
Technologies used: OA Framework, PL/SQL, Workflows and Report Builder and BI Publisher, SQL Developer, Oracle Form and Toad for Oracle.
Roles and Responsibilities:
• As Head of PMO, supervised IT project managers, business analysts, and quality assurance personnel in establishing high-performing IT project teams.
Curriculum Vitae
SALMAN AHMAD KHAN
Email: ******.**.****@*****.***/ *********.******@*******.*** Location : Sterling,Virginia, United States of America Cell: +1-571-***-****
7
• Implemented and drove adoption of key tools and processes to effectively deliver IT projects for the company.
• Facilitated prioritization discussions between IT and executive leadership to ensure alignment of company’s IT investments.
• Design, evaluate and improve business processes for determining software, IT infrastructure and ERP required by management functions in the Company.
• Make and implement the overall IT strategy of the Company.
• Lead IT Teams through all stages of ERP, manage IT projects, technology, cost and quality.
• Plan, organize, control and evaluate IT and electronic data operations.
• Manage IT staff by recruiting, training and coaching employees, communicating job expectations and appraising their performance.
Project #6
Title : Qlik Sense Business Intelligence Implementation. Client : Gul Ahmed Textile Mills Limited
Domain : Textiles
Project Type : Design and Development
Team Size : 1
Role : Techno-Functional Oracle EBS.
Period : Jun 2021 – Dec 2021
Technologies : Oracle E-Business Suite 12.2.10, Oracle Database 19c, Qlik Sense Project Description:
The system based on the following modules:
• Purchasing to Pay Cycle
• Order to Cash
• General Ledger/ Sub ledger Accounting
• Fixed Assets
• Payables
• OPM Financials
Roles and Responsibilities:
• Manage the design, development, testing and deployment of the company's dashboards.
• Develop business requirements, assess current reporting capabilities, and make recommendations regarding enhancement of our BI analytical tools.
• Work closely with various functional teams to translate business requirements into optimized semantic layers, reports and dashboards.
• Continuously build a strong relationship with internal business and technical stakeholders including presenting technical solutions while showing a strong understanding of business activities and objectives.
• These efforts have greatly increased data availability and provided patient and practice level analysis for operational, tactical, and strategic decision-making.
• Manage the deployment of a data lake and business intelligence platform that integrate and transform ERP data into meaningful, actionable solutions.
Oracle EBS Modules:
• Purchase to Pay Cycle
• Order to Cash Cycle
• General Ledger
• Fixed Assets
• Cash-Management
• Sub ledger Accounting,
• Landed Cost Management
• Manufacturing (Production)
• Giving support for existing custom modules.
Curriculum Vitae
SALMAN AHMAD KHAN
Email: ******.**.****@*****.***/ *********.******@*******.*** Location : Sterling,Virginia, United States of America Cell: +1-571-***-****
8
Project #7
Title : Oracle EBS 12.2.4
Client : PAKISTAN CABLES LIMTED
Domain : Cable Manufacturing
Project Type : Design and Development
Team Size : 2
Role : Techno-Functional
Period : May 2015 – Present
Technologies used: OA Framework, PL/SQL, Workflows and Report Builder and BI Publisher, SQL Developer, Oracle Form and Toad for Oracle.
Project Description:
Designing, Development, Implementation, and Production support for Oracle EBS R12. The system based on the following modules:
• Purchasing
• Inventory
• Payables
• General Ledger
• Fixed Assets
• Cash-Management
• Sub ledger Accounting
• Landed Cost Management
Roles and Responsibilities:
• System Administration activities like defining Responsibilities, Users, setting profiles, Flexi fields, Forms, Reports, managing concurrent programs and providing support to Apps end users.
• Expert in Defining Flex field segments and value definitions for GL, FA, INV, AP and PUR.
• Extensive experience in developing Interface/Conversion programs to import data from legacy systems to Oracle Applications using PL/SQL, SQL Loader and UTL File.
• Extensive experience on importing data from external / legacy systems for AP Suppliers, AP Invoices and Journal Entries using various PUB packages and Interface tables.
• Expert in reconciling the respective Sub-ledger data of AP / AR / FA to GL thru Sub ledger accounting tables
(SLA).
• Expert in debugging and identifying the issues as part of PROD support.
• Excellent programming skills in stored procedures and Oracle (PL/SQL including Procedures and Functions) and expertise in database Performance Tuning by implementing parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding. Project #8
Title : Qlik Sense Business Intelligence Implementation. Client : PAKISTAN CABLES LIMITED
Domain : Cable Manufacturing
Project Type : Design and Development
Team Size : 1
Role : Techno-Functional.
Period : Jun 2018 – March 2021
Technologies used: Oracle Database
Project Description:
The system based on the following modules:
• Purchasing to Pay Cycle
• Order to Cash
• General Ledger/ Sub ledger Accounting
• Fixed Assets
• Payables
• OPM Financials
Curriculum Vitae
SALMAN AHMAD KHAN
Email: ******.**.****@*****.***/ *********.******@*******.*** Location : Sterling,Virginia, United States of America Cell: +1-571-***-****
9
Roles and Responsibilities:
• System Administration for Qlik Sense Server activities like defining Responsibilities, Users, setting profiles, managing licensing and providing support to Apps end users.
• Discovering the new Extensions for third party for Dashboards of the projects.
• Monitoring Dashboards backup with other supporting’s.
• Conducting continuous brainstorming sessions with the management to discover as well as adopt dynamics reporting system.
• Helping management to identify the major Key performance indicators, for decision making. Project #9
Title : Dashboard Application (.Net) for supporting Implementation. Client : PAKISTAN CABLES LIMITED
Domain : Cable Manufacturing
Project Type : Design and Development
Team Size : 1
Role : Techno-Functional.
Period : Oct 2016 – May 2018
Technologies used: .Net and Oracle Database
Project Description:
The purpose of this project is to develop User daily routine report transformation from Static to Dynamic nature. Client and productivity reports used by the business were limited and generated manually. So, by using this application, users can transform data into any report layout they want to create by themselves. Roles and Responsibilities:
• Design and development for simplify the reconciliations for the user.
• Worked on Incident created by end user of the application.
• Finding the root cause analysis of the issues faced by the user. Other Projects:
S No Organization Duration
4 Insurance Information System May 2013 to Feb 2018 5 Customer Relationship Management Jan 2011 – Dec 2012 6 Supplier Relationship Management Apr 2010 – Dec 2010 7 General Ledger Aug 2009 to Mar 2010
8 Account Payables Jan 2008 – Jul 2009
9 Account Receivables Jan 2008 – Dec 2010
10 Product Price Calculator Aug 2007 – Dec 2007
11 Quotation Processing Module Jan 2007- Jul 2007
Tools: Using .NET and SQL Server 2008, Janus and DevExpress Controls. TRAININGS
• Qlik Sense Architect.
• Attended training on Oracle Forms, OAF, BI Publisher.
• Oracle University Certifications.
EDUCATIONAL QUALIFICATION
• Bachelor of Science in Computer Science 2006 from University of Karachi, Pakistan.
Contact this candidate