HASSAN KHAWAJA ALI
**** ****** *** # ***, ******, TX 75219
******-****@*******.*** Phone: 407-***-****
OBJECTIVE
Seeking an Analyst position in your organization.
PROFESSIONAL SUMMARY
Experienced as an Analyst in various roles. 8 years of experience in various industries with
emphasis in IT, Finance, Business, Healthcare, Management Consulting and Non-Profit.
Experienced in Data Analysis, Research, Reporting, Account Management, Ad-Hoc Reporting,
End-user reporting, Vendor & Client Relationship and ability to identify and use creativity to
resolve issues. Experienced in Data manipulation, Report creation, Importing & Exporting Data
in different formats and from various sources. Proven ability to learn and utilize in-house
databases and systems. Deadline and Goal oriented - driven to achieve goals both independently
and in a team environment.
TECHNICAL SKILLS
MS Access – MS Excel – MS PowerPoint - MS Outlook- MS Word-MS Project-MS Visio
PeopleSoft Financials (8.9) & (9.1) – SQL Server 2005/2008 – Crystal Reports –Data Modeling,
Data entry, PC Tech and Desktop skills, Windows XP 2003, 2007, Vista &Windows 7
Installation and Troubleshooting Software’s, Hardware, Scanners, Printers.
Knowledge of Databases, Data Management, Information Systems
PROFESSIONAL EXPERIENCE
Sedgwick CMS / Healthcare Claims Irving, TX Senior Data Analyst
04/2012 – 07/2013 (Contract)
• Initiated and completed the project for the company’s Claims management services data.
• Performed Data research, Data Discovery, Data crunching, Data cleansing and
manipulation to have one master data source.
• Initiated team meetings to understand and gather requirements for business processes.
• Supervised a team of in-house and off shore Analysts to ensure that all the goals are being
met.
• Interacted with cross functional teams to ensure data accuracy.
• Performed queries in SQL Server 2008 to examine clients existing data against newly
discovered data.
• Performed queries to pull reports in various systems including Cambridge SRS, Ovation
BI, and Via One (Oracle Platform).
• Filled a scorecard with the results gathered as one final product.
• Uploaded & Shared files on Sharepoint to make files accessible for Managers and team
members
Sedona Technologies (IBM/State Farm Project) Dallas, TX IT Data Analyst
01/2012 – 04/2012 (Contract)
• Visit client’s sites to perform data backups, analyze and create improvement plan reports.
• Follow up with the clients to discuss and schedule the implementation of the installations
• Run queries on SQL Server 2008 to collect data on existing clients and referral
• Analyze data and forward recommendations and proposed solutions to the upper
management.
Aids Arms, Inc. (Healthcare/Clinical Non-profit) Dallas, TX Data Analyst/ BA
04/2011- 10/2011
• Support, manage, and maintain organizations clinical data in databases in SQL Server.
• Acted as an in-house Business Analyst to facilitate teams of Data and Business Analysts.
• Initiated meeting as a lead to understand / gather requirements and document processes.
• Maintain patients’ information in in-house database systems (Clear Health & Aries).
• Reporting on periodical basis for federal funding and grants.
• Ad-hoc reporting and querying for the staff data requests though SQL Server 2005.
• Prepared user guides and training manuals for the new users and clients
• Weekly analysis of the new data entered in database.
DFW Minority Business Council (Non –profit) Dallas, TX Business Data Analyst
05/2009 – 04/2011
• Manage and maintain MS Access 2007 database, and Council’s National online
Database. Develop queries, prepare reports, forms, and update records.
• Analyze and audit data for accuracy and credibility in MS Access 2007 and Excel 2007
• Collect, sort and analyze data from different sources to create reports in Access, Excel,
and Crystal reports.
• Ad-Hoc reporting according to a given criteria
• Maintain client/vendor relations through meetings, networking events, and regular
correspondence.
• Organize/Coordinate events, seminars, luncheons and business meetings.
• Main point of contact for clients to help them through the council’s certification process,
documentation, and any assistance they may need.
• Sourcing of information, RFP’s, Government RFP’s, Bids to clients and vendors.
3S Networks Dallas, TX IT Consultant
08/2008 - 01/2009
• Key individual responsible for supporting networks at client sites. Also responsible for
identifying and resolving technical issues as they arise.
• Set up computers, printers, scanners, routers and other equipment according to the company
requirements and client specifications at given sites.
• Install and maintain software, anti-virus, programs and applications
• Responsible for installing of new software and creating training manuals for internal
employees.
• Train employees on new equipment and software if needed.
• Audit existing and new services and report to the Project Manager.
Hilton Grand Vacation Club Orlando, FL Reporting Analyst/Accounting/Finance
11/2006 - 08/2008
• Principle business lead, responsible for analysis and support for all Hilton vendor
relationships.
• Used data analysis/querying expertise through various tools such as PeopleSoft
Financials 8.9& 9.0(Oracle), Access, and SQL to identify issues relating to vendor
invoices and resolving those issues in a timely and concise manner therefore reducing
billing errors and duplicate payments.
• Subject Matter Expert for the accounting and finance team as it relates to vendor
issues.
• Eliminated various issues relating to duplicate invoicing by thoroughly analyzing
data in Access, Excel and creating reports to present issues to management.
• Looked upon Ad-hoc requests by the Accounts Payable team.
• Filling in and acting as back-up to the Accounts Payable team on as needed basis to
meet important deadlines.
• Audit expense report and make sure of any discrepancies.
• Enter invoice information and vendor payments for assigned business units. Vendor
setups, check runs, check matching, check for proper GL coding and audit expense
reports.
• Solve any vendor concerns regarding payments and maintain good vendor relations.
• Used IT skills to automate certain aspects of the invoicing process such as scanning
invoices, creating and maintaining database to track those invoices therefore
streamlining the process and reducing errors.
Hilton Grand Vacation Club Orlando, Fl HR Compliance Analyst
08/2006 - 11/2006
• Quickly learned and utilized an in-house MS Access database to create and maintain
all data as it relates to applicant and other HR information.
• Performed internal data audits to make sure all information is accurate and confirms
to the HR data retention rules using PeopleSoft HR.
• Used database to analyze existing data and perform ad-hoc reporting requests
utilizing the data to create reports in MS Access and Excel.
Zaid Investments Orlando, Fl Data Analyst/Purchasing
12//2005 – 08/2006
• Responsible for purchasing of the raw material from various US and International
sources.
• Created and maintained client related data in a Microsoft Access database.
• Utilized data to analyze and create reports in Excel to report to management.
• Performed various Ad-hoc requests from identifying and researching Client issues,
and working with clients via email or phone to resolve those issues.
Florida Metal Trading Orlando, Fl Procurement Assistant/Account Analyst
01/2005-12/2005
• Responsible for overseeing procurement operations from start to finish.
• Made sure to check on all the necessary documents related to customs, taxes, duty paid
and BL’s.
• Made arrangements to transport the goods from delivery to the warehouse and then to the
clients.
• Data entry and prepared Purchase orders, Invoices, and Sales quote.
• Correspondence with clients in US and abroad regarding shipments and orders.
EDUCATION
Masters in Management Information System 2011
Nova Southeastern University, FL
Bachelors of Science in Technical Management 12/2007
Specialized in Business Management and Information Systems
Devry University Orlando, Fl
Associate Degree in Criminal Justice 10/2005
Valencia Community College Orlando, Fl
Diploma: Computer Technician 08/2002
Southern Technical Institute Orlando, Fl