Muhammad Junaid Khan

M.junaid Khan Jr Business Intelligence Developer at Khushhali Microfinance Bank Email:-Phone: (- Address: Islamabad, Pakistan Industry: Banking Qualification: Bachelors Availability: 1 Month Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Data Engineer with experience in wrangling big data, Eager to build robust multiple databases pipelines that lay the groundwork for revealing game changing insights within organization and derive insightful data that proved to be effective and meaningful. Quality-driven and hardworking with excellent communication and project management skills. EDUCATION Bachelor of Science Software Engineering at International Islamic University - Islamabad, Pakistan October 2017 to October 2021 EXPERIENCE Jr Business Intelligence Developer Khushhali Microfinance Bank - Islamabad, Pakistan September 2022 to Present ● ● ● ● ● ● ● ● ● ● ● ● ● Automated the ETL that melded data from 5 different databases Optimized SQL scripts and reduced the ETL execution time Auto Extraction of Reports to all branches using Talend, reducing the time by 60% Partners with business areas to provide analytical and financial insights for company decision-making and strategic planning. Data & Analytics utilize advanced data manipulation techniques and tools in their expertise of sourcing and transforming data that provide actionable insights Crafting and executing ad hoc queries upon request for data and translating business needs to technical specifications Responsible for the Bank's daily monitoring file to SBP and submission of daily GL report to finance Data modeling, designing, and implementation of data in a repository using 3- tier architecture of Cognos Framework Development/Unit testing of BI publisher reports - Preparation & dissemination of raw data to internal / external sources for further preparation of weekly / monthly reports for various departments Performed daily reconciliation of tables across the EDWH to ensure data completion - In-depth understanding of database management system, database architecture for OLAP, OLTP applications and ETL (Extract, transform, load) framework and Cognos Framework Manager. Developed Reports using Lists , Charts ,Prompts and other user controls and Dashboard in Cognos Analytics develop KPIs on Business user demand Data Modeling on front-end in IBM Cognos Data Analyst Hired International - June 2022 to September 2022 Collecting and extracting data from CRM, Generation of hourly, day-end and weekly reports of Agents in Excel Maintaining weekly reports of cumulative recovery that helped company keep track of performance - l works on the business model of loan disbursements and recovery, maintaining weekly reports - Generating great business insights from data to the user to make his company performance and process improvement that provides feedback on the recovery of each individual working in their respective buckets - Analyzing data helped derived new insights that were helpful for the company to make better business decision for the company. Developed dashboard for visualization using Microsoft Power BI SKILLS ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● Analytics (Master) Big Data (Master) Cognos Framework Manager (Master) Data Integration (Master) Data Modelling (Master) Data Warehousing (Master) Database Management (Master) DBMS (Master) ETL (Master) Hard-Working (Master) Microsoft Excel (Master) Microsoft SQL Server (Master) OLTP (Master) SQL (Master) Cascading Style Sheets (Expert) HTML (Expert) IBM Hardware (Expert) Microsoft Transact-SQL (Expert) MySQL (Expert) OLAP (Expert) Power BI (Expert) Project Management (Expert) Unit Testing (Expert) Cognos Impromptu (Proficient) Oracle PL/SQL (Proficient) Process Improvement (Proficient) Python Programming (Proficient) Strategic Planning (Proficient) Informatica (Competent) CERTIFICATIONS ● ● ● ● ● Google Data Analytics Data Visualization and Dashboards with Excel and Cognos Getting Started wit Data Warehousing and BI Analytics Talend Data Integration SQL for Data Science ● ● ● Introduction to Data Engineering Excel Basics for Data Analysis Databases and SQL for Data Science with Python LINKS ● https://www.linkedin.com/in/muhammad-junaid-khan-ab660a213/