POST GRADUATE PROGRAM IN
DATA ENGINEERING

The position involved 90% development. Responsibilities include developing Business Processes. Implementing web applications in PHP 4.0 and MySQL server. Providing operational support for hosted system. Enhancing existing XML documents, transformed XML documents into XHTML using XSLT. Application development work in ASP.NET C#. API Documents for our existing applications. Testing and debugging Business Processes. Designing and executing test cases. Travel to client location for product installation and training. Develop applications in MS SQL 2000 and T-SQL Create store procedures, scripts for database maintenance and enhance performance Keep track of latest updates and development and implement business processes as required

Programmer Analyst

Working with huge (Multimillion records) MSSQL databases. Upgraded BI systems (MSQL, SSIS, SSRS, and SSAS) from version 2005 to 2012. Creating and deploying complex SSIS packages. Working with SQL Reporting Services SSRS. Working with data marts and cubes SSAS. Extensively working with SQL Server OLTP building complex queries.

Business Intelligence Developer

Responsibilities include rapid updating and maintenance of the website. Use HTML, ASP, Macromedia and JavaScript to enhance website Add extra features according to client's need and requirements

Website Developer

At Unmile we have built a robust engine that can be utilized in building your next Web/App with relative ease. Feel free to connect with me if you have an established business that you would like to build a web/App or have a new startup idea that you need to implement MVP to test out the market. Portfolio: http://www.eatcraze.pk Web application + Android and IOS Apps. The food portal has more than 400 restaurants and a separate admin portal. https://play.google.com/store/apps/details?id=com.unmile.eatcrazepk&hl=en_US https://play.google.com/store/apps/details?id=com.unmile.beckscuisine&hl=en_US https://play.google.com/store/apps/details?id=com.unmile.gloriajeans&hl=en_US https://play.google.com/store/apps/details?id=com.unmile.linnchau&hl=en_US https://play.google.com/store/apps/details?id=com.unmile.treatscafe&hl=en_US https://play.google.com/store/apps/details?id=com.unmile.thephorestaurant&hl=en_US

CTO/ Co-founder

SQL/.NET Developer This position required 80% development. Developing Enterprise level ASP.NET web applications in .NET 2010 and SQL 2000/2005/2008. Implementing Business logic in Microsoft Dynamics NAV ERP system. Leading an intermediate and a junior developer. Building and maintaining business processes for web applications. Developed enterprise web applications.

Senior Programmer Analyst

SQL/.NET Developer The position required 90% development. Developing Enterprise level Windows/ASP.NET applications in .NET 2005 and SQL 2005. Creating CRM. Work Processes. Developing reports using Crystal Reports Developing reports using SQL Reporting Services. Set up replications between two SQL 2005 servers.

Developed production software and its security components using VB.NET. Utilized MS Access 2002 and setup LAN for three offices Worked closely with two production managers and performed the manufacturing requirements Provided quality customer service

Software Developer

Technology Lead  Data Engineer

This position required 50% development and 50% management. Setup an offshore IT branch of the company in Pakistan. Hiring and mentoring five developers for the offshore office. Transferred the knowledge and business processes of enterprise level application. ASP.NET, C#, Visual Studio 2003, Visual Studio 2005 and Visual Studio 2008. Studying BCDecker web application code and processes thoroughly. Documenting all current system processes in word, making Visio diagrams and document future implementation and enhancements in each Decker Publishing web application. Migrating oracle 7.3 database on Sun Solaris to SQL Server 2000 and integrating databases into Decker Publishing database. Setting up replications between SQL Server databases. Documenting all processes for the following web applications. Mentoring Junior Developers. Implemented Foundation Server 2008 to collaborate in house projects.

Senior Software Analyst / IT Lead

● Mentor and guide team members, delegate tasks and allocate resources effectively to ensure optimal team performance. ● Communicate closely with business stakeholders to understand and gather requirements for assigned tasks. ● Lead the creation of Jira tickets and actively participate in SCRUM calls to facilitate efficient project management. ● Contribute to developing SSRS and Power BI reports, as well as SSIS Packages, ensuring the delivery of high-quality solutions. ● Conduct monthly performance reviews with the team, adjusting goals and direction based on team input to enhance future outcomes. ● Maintain up-to-date documentation in Confluence to ensure clarity and transparency within the team. ● Architected and optimized ETL workflows to ingest, transform, and store structured and semi-structured data from multiple sources. ● Worked closely with business stakeholders to define data models and ensure alignment with analytical and reporting needs.

Data/BI Team Lead

● Led the ingestion, transformation, and secure hosting of Microsoft Support data, ensuring full compliance with Schrems II and EU data sovereignty regulations (GDPR, PII). ● Designed and implemented regional data centers across the EU, guaranteeing that all personal/support data remained within EU boundaries (no cross-border transfers). ●Spearheaded the development of high-performance ETL pipelines using Azure Synapse Analytics, Synapse SQL Pools, and Apache Spark Pools, handling sensitive PII data. ● Managed and optimized Azure Data Factory (ADF) pipelines, reducing data processing latency by 30%, while maintaining robust data lineage and audit trails. ● Integrated On-Premise SQL Server with Azure Synapse for hybrid cloud architecture, ensuring compliant, secure data flows for regulated workloads. ●Led and mentored offshore engineering teams in building and maintaining scalable data pipelines in PySpark on Azure Synapse, with a focus on security and compliance. ● Maintained, governed

Technology Lead Data Engineer

Builder / Platform Architect

Lead Data Engineer building scalable pipelines with Azure, Databricks, and performance-focused data systems

Know about Asghar Shah's work experience, education, bootcamps, certifications, and much more. Asghar Shah