Resume of Crystal Reports Developer

Title
Crystal Reports Developer

Primary Skills
Crystal Report XI, SQL Server 2000/2005, Visual Basic Programming, SQL/T-SQL, MIS

Location
Canada-ON-Mississauga (will consider relocating)

Posted
May-06-07


SHORT OBJECTIVE
MIS Specialist/Reporting Analyst
PROFILE

Over 8 years experience in system development including of analysis, design and development databases (SQL Server, Visual FoxPro and Access) performance tuning i.e. stored procedures, triggers, views & functions.

Crystal Reports Developer with 5 years experience using Crystal reports version 8.5 to XI for different types of application.

•Create different type of reports including: Cross-tab, Conditional, Drill-down, Top N, Summary, OLAP, Sub reports, Drill-down and Parameter prompts
•Integrate Crystal Reports with SQL Server 2000 and Access databases
•Design interactive Visual Basic 6.0 interfaces for report selection, criteria and display
•Modify report content and export reports in multiple formats based on user input
•Upgrade Crystal Reports version 8.5 to version XI
•Hands-on experience of MIS in leather and shoe industry, real estate, pharmaceuticals marketing group, Inventory management, MCH clinic and accounting/financial reporting from 1998.
•Excellent skills on accounting, inventory and financial statement preparation
•Demonstrated experience in SQL and Transact-SQL programming of SQL server and Crystal report version XI


CAREER HISTORY

Canadian Tire, Mississauga, ON June 2006 -- Present
Customer Service and Inventory management

•Maintain daily sales and prepare report and all related customer service activities

Apex Group, Dhaka, Bangladesh September 1998 -- April 2006
Lead Software Development & Management Information Service (MIS)
A multinational manufacturing company (3500 work forces)

•System developed for inventory, accounts, export, import and production department (multi-user environment)
•Generate verity of monthly/weekly/daily reports was regulatory submission and documented stored procedures and triggers to improve daily operations and improve business operation and user efficiencies
•Developed GL, receivable/payable, trial balance, bank/cash book reconciliation report and all financial statements
•Generate monthly/weekly/daily sales statement of export and import department
•Generate inventory and requisition report was regulatory submission
•Saved information for each year with potential to generate graphical representation of Customer's performance over specific period to aid in the crop planning and sales analysis
•Provided Crystal Reports training for the other programmers

Tools: Crystal Report 8.5, SQL Server 2000, Visual Basic 6.0, Visual FoxPro and Sheridan controls


Pacific Pharmaceuticals marketing group January 2002 -- April 2006
Dhaka, Bangladesh (Part Time)
Business Analyst/Crystal reports Developer (Part Time)

•Developed a complete pharmaceuticals billing system and create verity of MIS report using Crystal Report 8.5, 9.0
•Created complex Stored Procedures and Views to be used in the reports
•Created parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting, Visual Basic syntax to create formulas for the reports
•Generate more then 1500 invoices daily to distribute the Pacific's product to the customer
•Created excellent performance charts of medical representatives (MR) wise using Crystal Report 8.5
•Item wise sales and inventory report regulatory submission using crystal report 8.5

Tools: Visual Basic 6.0, SQL Server 7.0, SQL Server 2000, Crystal Report 8.5


Swadesh Properties Limited December 2004 -- April 2006
Dhaka, Bangladesh (Part Time)
System developer and Reporting Analyst

•Developed SQL server database for Installment Collection, Accounting and MIS system
•More then 1470 plots was sold and about 940 customers pay there monthly installment
•Generate sector wise monthly/daily/weekly sales, balance statement of each customer, statement of defaulter, plot cancellation report
•Auto generated monthly notice for the defaulter
•Sales performance report of all marketing staff graphically using crystal report

Tools: Visual Basic 6.0, SQL Server 7.0, SQL Server 2000, Crystal Report 8.5, Power Point

Certifications
SQL Server 2005 Administration New Horizons, Mississauga, ON Canada Jan, 2007
Crystal Reports XI (Level-I & II) Computer Help, North York, ON Canada Apr, 2007

Bachelor Degree, BA Dhaka University, Bangladesh, in 1989
Diploma in Computer Science Dhaka, Bangladesh 1991, Bangladesh
Oracle 8i Concourse InfoTech 2002, Bangladesh
Visual Basic 6.0 Microsoft certified education centre CTEC 1998 Bangladesh
SQL Server 2000 Microsoft certified education centre CTEC 1998ý Bangladesh
NT 4.0 and Visual FoxPro Active Net (IBM) 1997 Bangladesh

TECHNICAL SKILLS

?LAN Installation, Network troubleshooting, Administration, and configure HUB, Switch, PC and Operating system Installation
?Operating Systems and Networking environments: Windows 2000, Windows XP

?Databases and Tools: MS SQL Server 2000 & 2005; ORACLE 8i; MS ACCESS 97
ODBC, Scanning, Looping, SQL, Transact-SQL, Store Procedure, Triggers and Views for large data manipulation

?Visual Basic 6.0 (4yrs Experience), Visual FoxPro (8yrs) programming
?MS-Word, MS-Excel, Power Point, Crystal Report 8.5, XI



You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in Canada-ON-Mississauga »
View all resumes in Canada-ON »

View other Crystal Reports Developer resumes, Programmer / Developer resumes