MIAN KALEEM
Email: kalim_2000@yahoo.com
1-905-481-3682

Data Analysts, Data Trending and insight for Healthcare, Security, Financial including Fraud and Money Laundering, Consumer Products, Manufacturing and many more sectors.
Data Analyst/Crystal Report Developer
 Collected and documented user’s requirements
 Designed and developed database for information systems projects
 Designed, constructed, modified, integrated, implemented and tested data models for reporting
 Analyzed database management systems to study data and perform analysis and reporting
 Supervised other workers in this group
 Researched and documented data requirements, data collection for analysis
 Conducted research and provided advice to other information systems professionals regarding the collection, availability, and suitability of data
 Wrote scripts related to stored procedures.
 DAC Easy Accounting, MYOB, AccPac, Crystal Reports, and SQL Reporting Services, and MS Office
 Proficient in Crystal Reports, MS Access, MS Excel and SQL Reporting and programming using data from data from various RDBMS (Sybase, MSSQL, MySQL, Oracle).
 Experience in Data Mining using XL Miner, SPSS and Excel as well as completed a Graduate Level Course in Data Mining and Business Intelligence 2011.

EXPERIENCE

Organizational Health INC Dec 2011 to Present
Mississauga, Ontario, Canada

Fulltime Employment as Crystal Reports Development, Data analysis and reporting on Disability management and Employment family assistance services provided by the company. Updating, modifying and creating new reports as well as ad hoc reporting based on the special requests. Use of Time: 70% Report Development, Coding Crystal Reports Functions, Arrays, Manual Running Totals, Manual Cross Tabs, Creative use of Cross Tabs; 30% Reports Testing and quality assurance. Technical Environment: Crystal Reports XI, Sql Server 2008, Windows 2003 Operating System.

Iview Systems Nov 2010 to Present
Oakville Ontario CANADA

Consultant

Crystal Reports- New and Canned reports maintenance for Incident Reporting System which are being used in Security, Surveillance and Risk Management related applications in Healthcare, Entertainment facilities and governmental organizations. Main focus in this project is to modify canned reports into Clean, professional look and feel to modern standards and consistency with Clear delineation of Data type groups / Sections/Graphs. Improved Ergonomics for at a glance interpretation of the data presented, guiding and setting reporting standards.

In Reports I used advance graphs and charts for at glance interpretation and comprehensive presentation of data. Created complex reports for Fintrac for keeping track of financial disbursements and foreign exchanges to detect money laundering cases, graphs for Personnel and Incident reporting modules, Human Resource Module reports such as Time Allocation report and graph and Report.

Use of Time: 70% Report Development, Coding Crystal Reports Functions; 30% Reports Testing and quality assurance. Technical Environment: Crystal Reports 2008, Sql Server 2008, Windows 2003 Operating System.

Prime Group Sep 2009 to Oct 2010
Sql Programmer/Crystal reports developer
SQL Data base Programmer /Crystal Report developer

Prime Group is a steel rolling mills and Export Company having its offices in Dubai and Pakistan. This project was to create /upgrade database and Crystal Reports to facilitate changes in business rules and expansion in manufacturing facility.
In my first report Company’s Business rule of receiving full payments on export invoices was changed in partial payments, consequently it became critical to record the related exchange rates, commission charges and bank charges on partial payments. In coordination

with management, I extended SQL Server database functionality by creating additional table to store partial export receipts and related data. Developed crystal reports for higher
management showing payments received against each export invoice along with detail of related exchange rates, the bank charges, commissions and discount and sum of net amount received and related information like average exchange rates and summary of all expenses.

Second report in this project involved the raw material optimization. Steel billet was received in different sizes and then cut into 3 or 2 lengths for further usage in rolling mill. In coordination with their engineers, I developed a report which showed sizes of lengths of billets to be cut depending on full length of the billet received. Crystal reports 2008 was used and all the data was in SQL Server 2008. Contract was successfully completed. In this project Crystal Reports 2008, SQL topics like floor function, temp tables and case SQL statements were utilized.

NEXT DIMENSION Jan to June 2009
Windsor, Ontario SQL Specialist and Crystal Reports Developer

Next Dimension had the service contracts with many companies in Windsor Ontario. The contracts charges customers based on monthly/yearly as well as per visit basis. The issue was to calculate the bonus of the employees based on hours sold and the hourly rate. Hourly rate was calculated and effected by the hours spent and the nature of contract. If the contract was expensive and less hours spent then employees were awarded according to high hourly rate. If the contract was of less expensive and more hours spent then hourly rate dropped and consequently bonus. That project involves usage of Crystal reports 2008, SQL Sub queries; Sub reports with passing data through variables between main and sub report were used.

Unrix Pharmacy November 2006 to July 2008

New York

SQL Programmer/Crystal reports developer (Healthcare)

In this contract I was assigned to develop/modify existing Crystal Reports in MED ACT health care software for pharmacies. The reports involved showing amounts received and outstanding balance with insurance companies, Sale figures by sales agents, by regions and analysis as well as modifying existing reports to show additional data on the reports. Oracle 9i database was used as backend database and Crystal report 10 was used in this software or reporting.
Use of Time: 70% Report Development, Coding Crystal Reports Functions; 30% Reports Testing and quality assurance. Technical Environment: Crystal Reports 2008, Oracle 9i, Windows 2003 Operating System.

CRUNCH FITNESS August 2006 to November 2006
New York City, New York Sql Programmer/Crystal reports developer

In this contract I was assigned to develop several crystal reports for Executive level to operational departments. I started with Monthly billing report. The exact report specifications were given. This report showed the club members count, member billed, and member collected, ratio of billing vrs collections of the current month and a previous month to see comparison. Crunch Fitness database was consisted of about 300 tables, due to the nature of business, Country wide branches, membership and employees categories, the database structure was very complex. My second report was employee bonus report. The issue was to track and calculate the bonus if employees made sales contracts and this contract lasted more than 60 days.

I utilized Crystal reports XI in these reports and extensively used Transact-SQL Language, Sub queries, SQL Case statements, Sub reports with variables for passing data between main and sub report, Cross Tab Reports as well as created underlying stored procedures and views.

In this project I coordinated with Chief financial officers, Chief technology officers and project managers.

MorrelWines June 2005 to October 2005
New York

Sql Programmer/MS Access/Data transformation services

I was assigned on data scrubbing/cleansing project and worked with Director of Technology and outside project consultants. This task involved the separation of the first and last names stored in one column into 2 separate columns named as First_name and Last_name.

There were 80 thousand rows or eighty thousand customers. I first exported data from name column to text file along with prime keys, then re-imported into access database using space delimiter which separated first name and last name into 2 columns. There were many other similar tasks of Data Scrubbing / cleansing in this contract.

I successfully accomplished all assigned tasks by using MS ACCESS, SQL Data Transformation services and Transact SQL statements.

BUSINESS INTELLIGENCE ASSOCIATE January 2005 to May 2005 New York
Sql Programmer / Data analyses on Insurance database

I worked there as a sub-contractor and was assigned on project of importing very large excel flat files to SQL Server 2000 and to create reports in Crystal Reports. The most of the key data was missing like policy no numbers and agent ids. Created data analysis and generated reports based available complete data.

ALTECH ENGINEERS 1996 – 2004
Lahore, Pakistan
Data Manager

When I joined the company in 1995 most of the accounting data was recorded in Manual registers ledgers / spreadsheets consequently extensive time was spent on preparing reports and making timely decisions.
In 1996, I initiated utilization of MS Access and led the logical data modeling of the Altech, and gradual implementation of RDMB format in MS Access. The data in MS Excel flat files was imported into MS Access and transformed into RDMS format. Created tables to store Master data about all accounts including customers, suppliers, employees and entity related to Altech business. Designed tables to record financial and material transactions and coordinated with Accounts departments to create general ledger and related reports in Crystal reports 8-9.

In 2000 this database was upgraded to SQL Server 7 utilizing MS Access as front end using Access data project. All the data entry forms and reports were upgraded accordingly. From 2000 to 2002 all the data was centralized in a SQL Server database on server. This facilitates the in-depth business analyses through Crystal reports 9-10 and fast and correct data entry using MS Access Forms.

During the approximately 10 year of my first job, I learned and mastered several concepts of data management such as changing dimensions, notably how to keep track of historical data. For example every month company’s 300 production employees were rotated into different departments and issue was to produce employee historical reports. Database was extended to keep the monthly production activities of employees. New reports were developed in Crystal Reports in Crystal Reports 10 for example complete individual employee performance for any time span, departmental performance. Labor cost by production activities.

Automated the posting of inventory data to financial ledgers for example as soon as new raw material received it was stored in inventory table and updates vendor accounts and material accounts.

My first job set the foundation of database technologies, logical data modeling techniques like entity relationship diagram and translating these into physical model. Understanding of transact SQL Statements, Data input strategies and mastering Crystal reports software for preparing meaningful information, data cleansing/scrubbing and when to use to text files for data and spread sheets.

EDUCATION

2011 McMaster University
Hamilton, Ontario
Business Intelligence and Data mining Graduate Level Course and Training

1995 ARKANSAS STATE UNIVERSITY
Jonesboro, Arkansas
Masters in Business Administration

1992 UNIVERSITY OF CENTRAL PUNJAB
Lahore, Punjab
Bachelor of Business Administration

1990 PUNJAB COLLEGE OF COMMERCE
Lahore, Punjab
Bachelor of Commerce

SPECIAL CERTIFICATES

2000 MCDBA – NKFACT INSTITUTE
Lahore, Punjab
Microsoft Certified Database Administrator (MCDBA)

REFERENCES
Available upon request