Amjed Hamdan Email & Phone Number

Orland Park, Il, Us

United States

Greater Chicago Area

Report and Analytics Delivery Lead for a major multi-billion dollar merger and acquisition. Hand picked by Chief Acquisition Executive to lead a team of 60+ full-time resources to convert the transportation finance portfolio. Collaborate with cross-functional managers to strategize, design, build and deliver BI analytics reports to support the LOB. Project financial responsibility of $15 million, within the overall $100 million initiative.Rationalize and prioritize 3000+ reports by partnering with the LOB, reduce number of reports by 75% for a total of 750 reports Built a responsive and adaptive team of 70+ resources in less than 3 months, consisting of both on-shore an off-shore resourcesIncrease ETL devleopment by 80% using script Automation Lead this high-performance team in design and delivery of more than 750+ reports and 14 dashboards, technologies include Business Objects, Qlikview and SpotFire

Greater Chicago Area

Promoted to Senior Technology Officer, tasked to create a business intelligence enterprise solution for the LOB. Managed 7 full-time employees, led 5 strategic and compliance projects, forecasted resource needs and managed multi-million dollar budgets. Built SSRS (Microsoft Reporting Services) and SpotFire info-structure, served 300+ users, designed and developed complex dashboards and reports. Designed and delivered a solution to close MRA's via the OCC, by developing dashboards to monitor daily cash-flow activities for the Treasury DepartmentCreated a high-performance and stable SpotFire infra-structure, by using load balancing and disaster recoveryMet all critical dates by establishing a migration plan and road map with prioritized dependencies, contingency plans and governance checkpoints

Greater Chicago Area

Partnered with AML executives to design and plan a horizontal risk assessment solution.Leveraged Big Data to analyze time and dimension, and monitored AML activitiesTracked 4 million remote deposit capture activities by zip code and high risk countries, which allowed the users to view and monitor data via a single dashboardCollaborated with the LOB on meeting OCC expectations

Greater Chicago Area

Senior Consultant for 10+ years, tasked with driving a number of strategic and highly visible bank wide projects.Assumed Data Conversion Lead position for large merger and acquisition project between BMO and M&I bankBuilt a website to track customer marketing preferencesDesigned and developed a robust website to track and report sales, compensation, profitability and growth for BMO's entire US and Canadian Wealth Management organization​Designed and delivered SSRS reports to executive management Provided operation and risk compliance support

Data conversion leader for all Corporate and Commercial Loan Operations projects related to the M&I strategic integration initiative. Projects included all operational aspects of commercial loan conversion, dealer finance operations, equipment finance support, construction lending integration, and intra-application integration. Managed a team of 3 FTE

Build a data warehouse for all credit card transaction. Integrates agents and affiliate hierarchy and commission bases system. Support for different credit cards such Visa, Master card, Amex, and Discover.

Lead Consultant responsible for iPayment, one the largest credit card processors in the US.Created a data warehouse and reports to calculate and deliver agents residual information

Greater Chicago Area

Developed and designed email broadcast, database diagram, and automation solution between the Internet and FAX Server. 3Broadcast is a leading provider of Internet messaging services. The site offers its customers a number of on-line services such as contact list management, marketing campaigns, auto-responders, email, and fax broadcast. Faxed over 10,000 pages per day

Greater Chicago Area

Greater Chicago Area

Completed various projects for the Actuarial Department to analyze company sales. Data was collected from 4 sources (SQL Server, AS-400, FoxPro, and legacy system) and transformed into a SQL Sever data warehouse.

Bachelor Of Applied Science (B.A.Sc.), Computer Science

Bachelor, Computer Science