Project Manager Data Warehouse

A rshad Syed

***** ********* **** ***** ****, TX 77498 M: 713-***-**** **********@********.***.**

S UMMARY

Solutions oriented and highly analytical IT Professional with 10+ years of proven track record of

development, maintenance, management, execution and post implementation support of Business

Intelligence and Operational Reporting across mid to large size projects. Demonstrated excellence in all

phases of technical lifecycle including requirements definition, business and technical design, application

development, deployment, user training and day to day support of data warehouses.

Good communication and interpersonal skills, ability to prioritize and multi task, an excellent team player

that possesses strong problem solving, analytical and leadership skills.

Salient IT Skills:

• Microstrategy • Unix Shell Scripting

• SQL • TOAD

• T SQL • ERWIN

• PL/SQL • Project Management

• SSIS • Data Modeling

• Oracle • Agile Methodologies

• SQL Express/2000/2005/2008/2012 as a DBA • Control_M V6/V8 Installation/Administration and

• NetApp Snap manager for Microsoft SQL Server Support

• Quest • SQL Tuning in an Oracle/SQL Server

Environment

E XPERIENCE

Kmart Australia Limited 9/2000 – Present

(Largest retail company in Australia with 25,000+ employees)

Senior Technical Analyst 9/2008 – Present

9/2005 – 8/2008

Senior Analyst Programmer

9/2000 – 8/2005

Analyst Programmer

• Achieved 99% availability of critical reporting of enterprise wide operational and organizational

metrics to all management tiers across the organization on daily, weekly and quarterly basis

• Effectively supported on 24 7 basis over 300+ users of multiple data warehouses using tools such

as SQL,T SQL, Microstrategy v9 and Cognos v6

• Independently planned, developed and continue to manage daily reporting needs of users across

functional areas and various management levels

• Accomplished successful and reliable generation and maintenance of over 2000 Microstrategy

reports

• Proactively liaised with end users for anticipated BI analytics and reports

• Ensured accurate and on time turnaround of project estimates in cross functional teams

• Mentored and guided junior team members to develop into effective contributors

• Successfully led as Project Manager on a variety of projects

• Designed and developed Disaster Recovery plans as part of Business Continuity Planning

Major Projects and Key Assignments:

HR data warehouse design

As data warehouse architect, successfully designed, built and managed the implementation of HR data

warehouse employing Erwin data modeler tool, ensuring seamless integration with Kmart data warehouse

to create an Enterprise data warehouse. Provided post implementation support, user acceptance and

training.

I-Care safety system design

As Project Manager and data warehouse architect, wrote technical specifications, designed and built from

scratch a system for capturing product safety related incidents across the business. Managed the front end

development team for successful deployment to 250+ retail locations and head office. Developed Safety

data warehouse integrated with Kmart data warehouse to provide organization wide accurate and timely

incident reporting saving the company multi million dollars in potential fines and penalties. Provided

comprehensive post implementation support and training to users across the organization.

Upgrade of Kmart data warehouse

As Technical Lead, planned and managed the upgrade of Kmart data warehouse involving DBMS

upgrade from Oracle 9i to 10g, UNIX OS move from AIX to HP UX and reporting applications upgrade

from Micro strategy version 8.1 to 9.0 while ensuring no disruption to users across the organization.

Detachment as SQL Server Database Administrator

Managed 500+ SQL Server instances including SQL Server Express 2000, 2005, 2008 and 2012 across

400+ Kmart and Kmart Tire & Auto Stores retail locations and 100+ head office instances. Ensured

seamless, timely and reliable transactions across functional areas from sales, marketing, HR as well as

online retail through the website.

Gap IT Consulting, Melbourne, Australia 6/2000 – 10/2000

(An Australian IT&T recruitment consultancy)

Technical Systems Support

Concept Systems Int’l, Melbourne, Australia 3/1999 – 3/2000

(Developers of high end Oracle based Payroll and HR system)

Technical Consultant

E DUCATION & T RAINING

Victoria University of Technology, Melbourne, Australia 10/1998

Master of Business Computing, Major in Computer Science

Swinburne University of Technology, Melbourne, Australia 6/1995

Bachelor of Applied Science, Major in Computer Science & Software

Engineering

Contact this candidate