Crystal reports - SQL - PL/SQL Resume

Title
Crystal reports - SQL - PL/SQL

Primary Skills
SQL / PL/SQL / VB / CRXI

Location
Canada-BC-Victoria or Vancouver

Posted
Sep-16-07


Technologies: Oracle, DB2, Visual Basic, Crystal Report V11, Business Objects, Access
Experience in: Data migration, database design and development, reports, software development, PL/SQL
Business analysis, business model, translation of business needs into technical specification
Desired Status: Full time -- Contracts
Career Level: Experimented (more than 15 years of experience)
Work status: Canadian citizen
Languages: Bilingual - English and French (native language)

Career profile
I have developed complete knowledge of application development lifecycle, from requirement definition and analysis to data modeling, design, coding and testing, implementation, training, documentation and client acceptance.
I am a dynamic and self-starting individual. I collaborate with business leaders and subject matter experts.
I specialize in Crystal Report development, SQL, Oracle, PL/SQL coding, Oracle database design and development, data migration and knowledge transfer.


KEY COMPETENCIES
Technical
1. Extensive technical background in software development
2. Experienced in Crystal Reports since 2000, including version 11 and Crystal Report Server XI from Business Objects.
3. Extensive experience in data migration and data modeling, analysis, tuning and optimization using PL/SQL Oracle database
4. Extensive experience in database development using PL/SQL, what includes writing complex sub-queries with multi tables joins, packages, cursors, views and functions
5. Ability to work in teams and mentor team members
6. Ability to work with minimal/none supervision
7. Ability to get along with all levels of staff and executives
8. Ability to work to tight deadlines under pressure
9. Ability to research and generate solutions to complex problems in a timely manner
10. Tolerance for ambiguity in project specifications and direction

Team lead / Project manager
1. Actively work on a project plan, including dependencies, slipping tasks and rescheduling of work
2. Manage all elements of change control relating to the project
3. Ensure that all stakeholders and team members are regularly updated on progress, issues, and achievements
4. Actively manage quality assurance through the lifecycle of the project, and ensure quality measures are in place and understood
5. Manage all aspects of the project implementation phases, ensuring appropriate implementation planes are in place
6. Ability to forge good relationships with clients and vendors


PROFESSIONAL EXPERIENCE

IBM Canada Ltd - Victoria July 2007 -- September 2007
Company profile: IBM Canada on wonderful Vancouver Island.
Business intelligence - SQL & Crystal Report developer expert
IBM called me to provide help due to resignation of team members. I provided assistance in Crystal development.
Technologies used: DB2, Crystal Reports V11, Crystal Reports Server XI. (Business Objects)
ISM Canada Ltd - Victoria July 2006 -- March 2007
Company profile: ISM Canada part of IBM Canada on wonderful Vancouver Island.
Business intelligence - SQL & Crystal Report developer expert
I developed Steady State SLA/SLO reports and other metric reports for the delivery managers using Crystal Report V11 and two large and complex DB2 databases to maintain ISM Asset Centre and ISM Service Centre. Reports are to follow-up tickets and vital statistics to ensure Service Level Agreement with BC govt. Statistics are based on seconds of work and consider non-workings days. A specific process was done to handle that specific business rule. I worked alone for gathering requirements from high-level managers and executives and writing code to deliver ad hoc reports. I also build a metric that shows hot tickets and time left before SLA goes to expiration. This one saved time and gain SLA success up to 95% compare to 55-70%.
Technologies used: DB2, Crystal Reports V11, Crystal Reports Server XI. (Business Objects)
Montreal City Hall November 2005 -- March 2006
Company profile: IT department of Montreal City Hall
Business intelligence - SQL & Crystal Report developer expert
1. I optimized Crystal Reports and implemented parameters to avoid redundancy of reports. I created new reports using both SQL Server (UniCenter Asset Management) and Oracle databases (UniCenter ServicePlus - ServiceDesk). I created reports by building complex SQL multi-tables joins with sub-queries in views
2. I installed and configured Crystal Reports Server XI to have clients to get reports directly from the Webb browser. I've estimated CRXi and then provided recommendation for purchase.
3. I debugged a custom tool using Visual Studio.Net C#
4. I trained staff to better use Crystal reports and teach them how to manage Crystal Reports Server XI
Technologies used: Oracle10g, SQL/Server V8, Microsoft server 2000/2003, Crystal Reports V9 with migration to V10, Crystal Reports Server XI. (Business Objects)
Montreal November 2003 -- November 2005
Technical consultant -- working from home with small size client base.
Symcor Inc. - Toronto September 2002 - July 2003
Company profile: Symcor is a North American provider of business process outsourcing services for the financial services industry.
PL/SQL Oracle expert
1. I created Oracle PL/SQL triggers, packages, functions, cursors, procedures and views to handle specific business rules.
2. I created a specific tool to migrate data from 4 databases into a 1-schema database. (ETL-SQL*Loader)
3. I created VB and DLL's programs and Crystal Reports to match users needs.
4. I assisted customer's team to improve quality of code and reduce time to develop custom features.
5. I assisted customer's team to improve productivity and reduce cost by reducing keying during the validation process
6. I frequently travelled to Vancouver, Calgary, Winnipeg and Halifax offices for roll out and to assist/train staff.

Technologies used: Oracle 8i, NT, VB5, Crystal Report V8, Client/Server 3 tiers, LAN and WAN, EMC Network appliances, ICR (Intelligence Characters Recognition), MS/Office. Transactions average is 500.000 per day, 6 sites across the country and 4 applications on each site.
BancTec Canada - Montreal June 2000 / August 2002
Company profile: BancTec is a worldwide provider of comprehensive enterprise content management, image capture devices, infrastructure support services and payment processing solutions. For over 30 years, BancTec has helped customers become more efficient through our innovative technology and services. BancTec's technology and service solutions help customers simplify the process of managing their information.

Senior technical project manager, Oracle based
1. I technically managed the major account (Symcor Inc) in Canada: (Toronto, Montreal, Calgary, Winnipeg, Halifax and Vancouver). The goal of this project was to upgrade all customer sites to the new release.
2. I created tools to migrate data from older application to newer.
3. I created a tool to automatically install and configure Oracle database and the application.
4. I travelled across the country and frequently travelled to the customer main office in Toronto for roll out and training.
Supervisor
1. I managed a team of 6 to implement new customers across the US and to keep current customers up-to-date. Customers are banks and related financial institutions working 24hrs/24 7days/7 Transaction average across US is about 1.000.000/day.
2. I travelled to Louisville (Kentucky) for Bank1One and to Chicago (Illinois) for FirstUSA for roll out.
Technologies used: Oracle 8i, NT, VB5, Client/Server 3 tiers, LAN and WAN, NetApps Network appliances, ICR (Intelligence Characters Recognition), Crystal Reports V8, Visual SourceSafe, Microsoft project, Visio and MS/Office 2000
IBM Canada -- Global Services - Montreal August 1999 / February 2000
Company profile: At IBM Business Consulting, we combine deep industry expertise with high-powered technology to unlock business value for our clients. Our teams have the ability to think globally and act locally with consultants positioned in virtually every country and culture worldwide.
Projects manager
1. Assigned as a technical expert to an outsourcing contract regarding a BI department of a major customer. The goal was to run a Due Diligence.

2. The project was about assessing all Business Intelligence applications as well as assessing the underlying architecture and the people/organisation that are supporting it. I was in charge of interviewing IT employees; evaluating and documenting the architecture and applications they manage. I also had to quickly adjust an existing evaluation methodology to be used for this particular situation.

3. Assigned to technical assurance reviews. (Proposals were over $3 millions)


LGS - Montreal July 1997 / July 1999
Company profile: LGS is a full service consulting and systems integration firm assisting organizations in Canada to meet their business objectives through the deployment of technology-based solutions. We're responsive, nimble and effective. As partners in our customers' success, we design, build, implement and run the technology solutions that make our clients industry leaders. We do it professionally and with zeal. We're small enough that our processes allow for flexibility and big enough that we boast a suite of proven methodologies and experience.
Analyst -- Team lead
1. Assigned to a troubled project, implemented effective corrective measures to ensure successful completion on time. In that project, I managed the project with a technical team of 7. I have done the functional analysis, supported team members and on a day-to-day base, managed change request and schedule with the customer.
2. I actively participated on modelling database. I created scripts to generate database tables and script to update tables. I set up the security rules.
3. I actively participated on development such as programming forms and reports, triggers and packages. I optimized report performance by reducing the overall time for singles report form 20 to 5 minutes.
4. I gave recommendations to the internal staff on how to use the case Designer and how to manage databases with the tool.
5. This major software application manages more than 1000 buildings with leases and subleases and tracks over $8 million of monthly rent expense and $ 5 million rent revenue. That software has been implemented on network architecture for a user community of 2000 agents running more than 450 applications.
6. The cost has been over $1.5 million. Customer expects to save 35% on common area expenses, which is around $ 1.2 million a year.

Technologies used: Oracle 6 migration to Oracle 7, Designer 2000, Developer 2000, Forms 5, Reports 5, PVCS, NT, Client/Server 2 tiers, LAN, Microsoft project, Visio and MS/Office
PCVoyages - Montreal February 1997 / July 1997
Company profile: Software development in travel area.
Senior analyst
1. The goal of that project was to define risks and realism on development software for travel agencies and tour operators.

Technologies used: Oracle 7, Designer 2000, Developer 2000, NT, Client/Server 2 tiers, VB4, Visual SourceSafe, LAN, Microsoft project and MS/Office
Robert transport - Montreal August 1995 / June 1996
Company profile: Road transportation
Team leader for the improvement in business transportation, dispatch
1. The project was to implement software used in business transportation, truck delivery, with satellite positioning. The software ran on Oracle and to make it useful in the customer environment, I programmed APIs to send data from Oracle to Pick, and vice versa, inside a gateway when an event came on one of theses database. That critical communication ran 7 days, 24 hours.

2. I build software to control the dispatch of the palettes. That project saved $800,000 to Robert Transport each year.

Technologies used: Pick, Oracle 7, NT, Client/Server 2 tiers, VB4, LAN, MS/Office
Les systèmes Proxima - Montreal March 1995 / April 1995
Company profile: Software development in cable TV.
Technical consultant
1. I integrated, tested and configured Unix systems. I made internal and developers technical support in shell scripting and code writing.

Technologies used: Pick, Unix SCO, Novel, MS/Office
Groupe TVF - Strasbourg - France November 1992 / December 1993
Company profile: Manufactory of electronics products
Development team manager
1. I managed a team of 5 developers using Universe, Visual Basic, and ODBC. I participated on recruitment.

Technologies used: VB, Universe, Oracle V6, Unix SCO, Novel, MS/Office 2000

Ultimate France - Paris - France August 1990 / March 1991
Company profile: Software management
Senior analyst-programmer
1. I analysed and programmed in Business Basic an application to control the production of concrete. I added new functionality in Rubbermaid France delivery process.

Technologies used: Universe, Unix SCO
Centre hospitalier Gabriel Martin -- Reunion island August 1989 / August 1990
Company profile: Hospital (La Reunion -- island in Indian ocean, close to Mauritius)
Manager Information System for the deployment of software and material in a hospital

1. That project has been realised from the beginning, such as supervision of technical staff who 'plug cables', up to the end, such as users education delivery.
2. I generated code to build an electronic mail, and a communication process between mainframe and bio-technical machine.
3. I analysed how to integrate medical pictures in the hospital, and gave a proposal for the future that better matches the environment with respect to the plan Director's.

Technologies used: Pick, Unix SCO.
Industrielle sucrière de Bourbon -- Reunion island March 1989 / August 1989
Company profile: Manufactory of sugar (La Reunion)
Analyst-programmer
1. I built software for managing the results from the chemical calculator inside the laboratory of a sugar manufactory. I wrote a communication process between the computer and the chemical calculator.

2. I did trained users in Madagascar on an accounting system.

Technologies used: Universe, Unix SCO
Groupe TVF - Strasbourg - France September 1988 / December 1988
Company profile: Manufactory of electronics products
Analyst-programmer
1. I was responsible for making preliminary analysis for the production cost control.

Technologies used: VB, Universe, Oracle V6, Unix SCO, Novel, MS/Office
Informatique de Tahiti -- French Polynesia January 1985 / November 1987
Company profile: Software management
Analyst-programmer
1. I generated code in business basic for the needs of some local companies.

Technical and business management of the education department
2. Planned, scheduled and provided documentation for appropriates courses. Train users with Pick system and Business Basic programming - SQL and procedural (15,000 hours). The sales objectives were $80.000. The quality of the courses gave me over $200.000 of revenue.

3. Auditing the social insurance office. Provided training to the staff of the atomic centre of Mururoa and the Pasteur institute.

Technologies used: Pick
Conseils et realisation informatique - French West islands November 1982 / May 1984
Company profile: Software management
Analyst-programmer
1. I generated code in basic for the needs of some local companies.

Technologies used: IBM PC
Mafioly SA - Lausanne - Switzerland December 1981 / July 1982
Company profile: Electronics vendor
Technical assistant
1. Custom assistance -- Setting up accountable software, office tools and user training.

Technologies used: Commodore

CURSUS

2000 The George Washington University
Financial management for projects managers - IBM Canada
(PMI -- Project Management Institute)

2000 Manage project with Microsoft project 98 and Planner WSDDM (World-wide Solution Delivery & Design Method) - IBM Canada
(PMI -- Project Management Institute)

1999 HEC - Hautes Études Commerciales
Management and supervision (courses)

1997 Designer -- Oracle Corporation Canada Inc. (Montreal)
Conception and creation of applications
Including a part of Developer -- Forms 4.5 & Reports 2.5

1997 Designer -- Oracle Corporation Canada Inc. (Calgary)
Up and Running with Designer

1997 Zenon Inc
Visual Basic 4.0 Visual Basic 5.0 / Upgrade

1994 Institut français de Gestion
Management and financial control

1980 - 1981 University of technical sciences
Natural sciences

1977 - 1979 Marie-Curie School
Mathematical and physical sciences

References on request

Certifications
See above


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

Resumes in Victoria or Vancouver, BC | Resumes in British Columbia

View other Crystal reports - SQL - PL/SQL resumes, Programmer / Developer resumes