Azhar Jamal

Developed and Maintained Reports: Created and maintained a suite of interactive reports and dashboards using SAP Business Objects to support decision-making processes across various departments. Data Integration and Analysis: Integrated data from multiple sources, including databases and ERP systems, to provide comprehensive insights and reports tailored to business needs. Optimized Performance: Improved report performance by optimizing queries and data models, reducing load times. User Training and Support: Provided training and support to end-users on SAP Business Objects functionality, enhancing their ability to generate and interpret reports effectively.

• Gather and translate business requirements into report design. Wrote complex T-SQL quires to get data from different sources and test result with expected results. Develop Custom SSRS 2017 reports as well as some tableau reports for senior executive leadership. • Design SSIS packages for transient and persistent staging area, to extract data form SharePoint and different applications, from excel and flat files using for each container, sequence container and tasks such as execute SQL task, loop up, merge, merge join etc. • Implemented performance tuning for slow running packages, using execution plan, SQL Server Profiler, implemented parallelism in SSIS. Designed and implemented for data loading to the dimension and fact tables. Create parameter and inserted parameters for each package which is used to retrieve information about package on run time enabling packages work dynamically.

• Responsible for planning and executing and development of highly usable components and services • Loyalty CRM App development and feature enhancement according to client needs. • Assist in developing applications with the development team. • Delegate tasks, oversee the day-to-day operation and set deadlines • Collaborate with product managers and other partners to build a product strategy and roadmap • Strong understanding of web development technologies, standards, and tools used by our company (Ex. Visual Studio, C#, Python, Django Services, Angular, TypeScript, Oracle, query tools and stored procedures, security, testing, configuration, and implementation).

• Participate in functional design reviews. • Develop Awqaf Web portal according to Business needs on Sharepoint portal (www.awqaf.ae) • Develop and architect business services.

• Participate in functional design reviews. • Collecting, documenting and analyzing business applications requirements • Managing and documenting changes in existing applications and reports • Analyze business requirements and do gap fit analysis • Recommending enhancements to the business applications, systems and reports

DUTIES AND RESPONSIBILITIES: • Design and guide implementation of large scale software solution. • Provide technical analysis for overarching strategic architecture. Analyze various system architecture, design, interfaces and API documents to document system capabilities and identify hidden requirements. • Provide technical assistance to web developers, system developers, and designers. This includes: Web services, SOA architecture, web service, and presentation layer architecture. • Ensure that all systems and software development adheres to existing client standards for programming, screen layout, user interface, configuration management, system interface, etc. • Participate in the planning and development of requirements, design (program and database), program specifications, interface requirements, and input/output file layouts, through the use of workshops, user meetings/discussions, and walkthroughs. • Develop and maintain System Design Document and Solution Architecture Document. • Actively involved in programming with ASP.NET MVC, REST API, OData Connectivity, SQL Server, Oracle with other LOB Application

CRIS Application (CRM for Airline Industry) • Collect information to analyze and evaluate existing or proposed systems. • Lead team of 10 from design to development. • Research, plan, install, configure, troubleshoot, maintain and upgrade operating systems and CRIS CRM Product. • Prepare detailed flow charts and diagrams outlining systems capabilities and processes. • Research and recommend hardware and software development. • Troubleshoot and resolve hardware, software, and connectivity problems, including user access and component configuration. • Work as a team member with other technical staff, such as networking to ensure connectivity and compatibility between systems. • Write and maintain system documentation. • Conduct technical research on system upgrades to determine feasibility, cost, time required, and compatibility with current system. • Deliver excellent customer service and gained respect of client management and end-users. • Delivered system to end-users with positive results.

• Manage team of 10 through development and System integration testing. • Resource estimation and Project management • Contribute to the development and continuous review of appropriate practices, standards and guidelines • Development and distribution of release notes and feature lists • Compliance with all Change Control & Software Configuration Management processes and procedures • Creation of release notes & training aids for every project

Abacusoft is an American based software house (Microsoft Gold partners), which Provides solutions with Microsoft latest tools and technologies. • Responsible for designing, developing and implementing Electronic Resources Planner systems that derives organizational performance in alignment with company’s vision values and culture. • Collaboration with Project Controller to define, analyze and review business requirements

E-Intelligence is a karachi based software house that provies IT solutions to its clients in USA, Canada and Germany. My responsibilities were system analysis and design, development, testing, deployment and support. Projects: POLM: A web based application for an American client to manage the work of attorneys. The Attorneys are assigned different cases and they had to manage the results of each case and provide feedback to the administrator. Technologies used were C#, ASP.NET and SQL SERVER 2000

• Collaboration with the technical team to define technical specifications and system design • Collaboration with end-users to define, analyze and review business requirements • Facilitate and participates in design reviews and code walkthroughs • Software testing Organize and participate in testing activities to ensure delivery of quality systems