Ibrahim Khan Email & Phone Number

Santa Clara, CA, US

Chicago, Illinois, United States

• Excellent Knowledge in RDBMS Concepts and Data Modeling using Star and Snowflake Schemas. Hands-on experience on Data warehouse Star Schema Modeling, Snow-Flake Modeling, Kimball Model, FACT & Dimension Tables, SCDs.
• Proficient in writing T� SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Batches, Scripts, Functions, Triggers, Views, Cursors (prefer Temp Tables) and Query Optimization.
• Responsible for performance tuning of stored procedures, Database Tables using Table Partitioning, SQL Profiler and Database tuning wizard, Looking at Execution Plans
• Skilled in High Level Design of ETL Packages for integrating data from heterogeneous sources Excel, CSV, SQL or other DBs, flat file, xml, Parquet, Json data.
• Worked on Notification services in setting up the Scheduled jobs and alerts.
• Use Azure Data Factory to create linked services to your data sources. Configure data extraction pipelines to periodically pull data from these sources.

Kansas City, Missouri, United States

• Serve as Services Solution Architect responsible for translating the client's business requirements into specific systems, applications or process designs with interlocked financial modeling for very large complex.
• Work with a team of DevOps/SecOps Engineers to architect AWS solutions with the responsibility to ensure the customermaintains an overall cohesive integration with partner systems, and solution
• Support and advise on application assessment, migration and modernization.
• Design cloud infrastructure, virtual private cloud, virtual private network, relational database services, auto scaling, and computing resources to meet customers' requirements.
• Maintain an understanding of advancing cloud capabilities, IT and business needs, while identifying and proposing cost andfunctional efficiency options for the customer's collaborative decisions and actions.
• Worked on Multiple on prem to Cloud Migration Projects.

Chicago, Illinois, United States

• Actively interacted with end users to gather business requirements, system specifications, and enhancements.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, and Table Structures.
• Actively involved in 3 phases of the Automated ETL homegrown framework, making troubleshooting, re-startability, and near real-time data load an easy task.
• Designed, implemented, and maintained all AWS infrastructure and services within a managed service environment.
• Performed data migration from on-premise environments into AWS services.
• Led development team in designing/migrating AWS cloud-based solutions and performed data migration from on-premise environments into AWS services.

Delhi, India

• Drove architectural plans for future data storage, reporting, and analytic solutions, achieving a 20% increase in dataretrieval efficiency.
• Automated ETL processes for over billions of rows of data, reducing manual labor by 45 hours per month andincreasing processing speed by 30%.
• Collaborated with Senior Architects to develop automated data pipelines that efficiently processed over 100 milliondata points, enhancing data flow by 25%.
• Implemented multiple projects on Microsoft Azure, setting up Azure Data Factory pipelines that improved dataintegration efficiency by 40% and utilized Azure Databricks to accelerate big data analytics processing by 50%.
• Managed Azure Synapse Analytics to scale data warehousing solutions, which improved data access and analysiscapabilities by 60%, directly impacting strategic decision-making.
• Trained in troubleshooting ETL Processes and Data pipelines, reducing downtime by 40% and enhancing systemreliability.

Master'S Degree, Data Science

Master'S Degree, Big Data Analytics And It

Bachelor Of Engineering, Electrical, Electronics And Communications Engineering

Activities and Societies: Management Head of IEEE Student Branch at the University.During my tenure as the Management head, organized.