syed ali

Syed Ghufran Ali

Profile: Technical Lead/ Senior Software Developer

Senior software developer and systems analyst with 16+ years of experience and technical expertise in the analysis, design, development, debugging, enhancement, production support, and testing of leading-edge applications, systems, and programs. Areas of expertise include IT consulting, sensitive data security, system design, and deployment.

• Leverage understanding of organizational goals, business objectives, and technology to establish policies, procedures, and priorities in the development of programming standards and system workflow.
• Apply a full understanding of agile and scrum methodology, tools, and technologies to gather and translate user requirements into solutions that meet evolving business needs and objectives.
• Advanced technical knowledge and a thorough understanding of business applications, project management, and software solutions design complemented by a proven ability to assimilate and utilize emerging technologies.
• Analyze and drive key platform decisions, software development, and technology selections to design and enhance product standards and further product technologies.
• Designed and developed complex data pipelines and maintained the data quality to support a rapidly growing business

Skills & Capabilities

1. Over 16 years of experience in a production and development environment with the ability to translate business needs into technical specifications and solutions.
2. Application development and technology, enterprise applications, systems integration, product development, launch, and support.
3. Corporate thought leader with a superior understanding of systems architecture and data management functions across multiple technologies and platforms.
4. Proactive nature with the ability to manage multiple priorities under tight deadlines and constraints and quickly comprehend the functions and capabilities of new technologies.

1. Oracle Application Express (APEX)
2. Oracle (19c,12c,11g,10g)
3. SQL
4. PL/SQL
5. Oracle Forms
6. C#
7. Visual Studio 
8. Java
9. JavaScript
10. ASP.NET
11. jQuery
12. HTML5
13. XML
14. Hadoop 
15. Spark
16. MongoDB
17. Hive
18. Pig
19. MapReduce
20. R
21. Python
22.  NoSQL
23.  Power BI
24. Cognos Power Play 6 and IMPROMPTU 6
25. WMS 
26. JDA/Blue Yonder (PMM, PROMO, DNF, CKB) 
27. Oracle RETEK (v9, v10)
28. Oracle JDeveloper
29.  Oracle Containers Java (OC4J)
30.  JIRA
31.  Pro*c 
32. UNIX (SUN, HP, AIS)

• ERWIN, PVCS
• Application development and technology
• Enterprise applications
• Systems integration
• Product development
• Launch and support
• Systems architecture
• Data management
• Agile and scrum methodology
• Issue investigation
• Project Leadership
• Performance Optimization
• Test-driven development
• Systems Development Lifecycle Management

Professional Experience

Rexall Pharma Plus, Mississauga, Ontario                          May 2015 – To date Technical LeadDeliver and support an industry-specific, secure, comprehensive, and centralized software solution (JDA/Blue Yonder) used for the Supply chain implementation and process improvement project for consumer goods. Implementation with JDA application including Promotion, Pricing, PMM (Portfolio Merchandise Management), Category Management, Demand and Fulfillment.

1. Responsibilities include enhancing and supporting Blue Yonder (JDA) applications which include (Promotion, Pricing, Category Knowledge Base, Demand, and Fulfillment).
2. Leading and coordinated with the Development and Testing team for well-planned deliverables.
3. Review codes and other standard protocols to test the performance quality of products.
4. Works with Project Managers to identify development risks and align internal expectations.
5. Ability to interact effectively in an extremely dynamic environment with multiple priorities. Initiating necessary tasks and ensuring follow-up.
6. Execute effective processes for enhancements of existing systems and new user needs
7. Environment & Tools: Windows UNIX, .NET, GIT, JIRA,  HTML5,  XML, SQL, and PL/SQL, Power BI.

Pearson North America., Burlington, Ontario         February 2012 – April 2015Senior Software DeveloperDeliver and support an industry-specific, secure, comprehensive, and centralized software solution (eSIS) used to retrieve, collect, and store student-related data. Troubleshoot and resolve issues and applications affecting production performance and new development initiatives. Provided extensive support for the Tomcat application server.

1. Utilize agile methodology and scrum framework in the development of new and enhancement of existing application modules, system designs, and technical specifications, forms, standards, and reports.
2. Designed, developed, and maintained customized reports, screens, and database functions, triggers, and procedures using SQL, PL/SQL.
3. Work directly with developers in performing code reviews and on the optimization of code standards.
4. Working on modern web UI standards such as C#, HTML5, CSS3, Telerik, jQuery, and JavaScript.
5. Convert existing Oracle forms application into new object-oriented .NET application. Using WPF, WCF. 
6. Environment & Tools: Windows UNIX, .NET, Visual Studio C#, WPF, WCF, IReport, ASP.Net XML, HTML, Java, IReport, HTML5, CSS3, Telerik, Oracle forms & reports (9i, 6i), XML, SQL, and PL/SQL.

Swisslog USA Inc., Norfolk, VA                          December 2008 - January 2012System Analyst/Software EngineerProvided system and software engineering support for warehouse management and supply chain management systems. Responsible for managing WMS, SAP, and JDE interface, SQL query optimization, data administration, and the troubleshooting of issues related to system production and new development. 

1. Delivered consultation services, software solutions, and supply chain software optimization for improved order flow and production and simulation software used for the long-term strategic planning of production networks.
2. Wrote the client interface routine for Oracle WMS data to JDE and SAP systems for assigned clients (Church & Dwight Co. and E. & J. Gallo Winery).
3. Designed and developed various forms and reports using Oracle forms 9i, Report 9i
4. Support the Data Administrator, which includes the maintenance of the source code using CMS.
5. Optimization of the different SQL Queries to insure faster response time.
6. Developed and modified database procedures, functions, triggers, and packages to enhance and improve functionality.

Michaels Stores, Inc., Dallas, TX                            April 2006 - November 2008Senior Programmer Analyst

Responsible for the development, modification, and maintenance of programs and applications, including the maintenance, troubleshooting, enhancement, and performance of the company’s RETEK Information System. Translated business and customer requirements into customized applications and technical design specifications that enhance and support purchase order, transfer, and item processes within the hybrid distribution strategy.

1. Streamlined and supported vendor shipping with the consolidation of all merchandise into one warehouse shipping location.
2. Developed, customized, modified, and maintained Oracle reports and forms, database procedures and functions, and SQL queries.
3. Automated backend jobs with the development of UNIX Shell scripts and the loading of data using SQL*Loader.
4. Environment & Tools: Developer/2000 (Forms-6i, Report-6i), PL/SQL, SQL, SQL-Navigator v4.1, Windows NT, Pro*c, UNIX (AIX 4.1), Oracle v9i, PVCS, RETEK, and CTRL-M.

Hudson’s Bay Company, Toronto, Ontario          March 2000 - February 2006Senior Programmer AnalystDeveloped, maintained, and provided troubleshooting support for production and new development initiatives of the RETEK Information System, responsible for managing and serving as the central point of order and merchandise management information flow throughout the enterprise.

1. Analyzed, designed, and developed customized packages, procedures, and functions as well as Oracle forms and reports, and data extractions and transformation functions.
2. Modified web report logic using new built-in Run-Report-Object.
3. Developed order and item inquiry forms resulting in a faster query process.
4. Environment & Tools: Developer/2000 (Forms-6i, Report-6i), PL/SQL, SQL, Toad, PVCS, Windows NT4, Pro*c, UNIX (SOLARIS), and Oracle v9.2.0.7.

Education

University of Sindh, Jamshoro, Sindh, PakistanBachelor of Science, Physics, Chemistry & Mathematics, ComputerTrainingSheridan Collage, Toronto, ONDiploma in Big Data AnalyticsRyerson University, Toronto, ONASP .NET Programming | C# Programming | Java ProgrammingSeneca College, Toronto, ONData Warehousing Diploma | UNIX Administration DiplomaOracle Corporation’s Education CenterOracle Database Administration Diploma | Oracle Application Developer DiplomaPARAIX Institute, OttawaOracle Database Administration DiplomaLicenses & CertificationsIBM (Python for Data Science)LinkedIn (Artificial Intelligence, Machine Learning, Statistics, JavaScript)Project Management FoundationsLinkedIn LEARNINGCertificateOfCompletion_Oracle_APEX_Fundamentals (2023)Udemy