Professional Summary

• Architect, manager, project management, business requirements gathering, systems analysis and development experience
• Over 15 years of professional IT experience
• Proficient with MDM solutions, database design, data governance, data standardization, development, data analysis and cleansing, building reports in various database environments Oracle, DB2, Microsoft SQL, MySQL, Microsoft Access
• Experienced with designing and developing 3 - tier web applications with a comprehensive background in web development languages
• Self-motivated with excellent analytical and problem-solving skills.

Computer / Technical Skills

• Databases: Oracle 8i/9i/10g/11g, IBM DB2 9.7, Microsoft SQL 2000/2005/2008, MySQL, Microsoft Access, SQL PLUS, PL/SQL, T-SQL, DTS, SSIS
• Languages: ASP, PHP, COLDFUSION, TANGO, UNIX Shell scripts KSH, BASH, PERL, JAVASCRIPT, VB, VBSCRIPT, VBA, ASP.NET, C, JAVA, JSP, XML, XSLT, HTML, DHTML, CSS
• Tools/Applications: IBM Initiate Workbench, Master Data Center, Data Quality Center, MS Visual Studio.NET, Photoshop, Erwin, Sybase PowerBuilder, XML Spy, MS Word, MS Excel, MS Project, Visio, Cognos ReportNet, Crystal Reports, Informatica, Plumtree, Documentum, Notepad, WinMerge, SyncBack, FileZilla, Putty, 7-Zip
• OS: Windows 95/NT/XP/Vista/2000/2003/2007, UNIX, LINUX
• Web Servers: IIS, Apache, WebSphere

Work Experience

Confidentia

• Provided leadership and hands-on MDM technical and functional expertise in architecting and implementing the MDM solution for the state of Louisiana, within the Department of Children and Family Services.
• Provided expertise and defined data standardization processes, MDM design, high and low level MDM architecture and implementation roadmaps for various Data Governance and MDM engagements.
• Supported pre-sales for MDM opportunities and provided expertise to the Product group to help with enhancing IBI's product suite for Data Quality and MDM.
• Provided expertise in architecting and implementing MDM solutions.

Confidential

Senior Consultant

• Lead technical implementation of IBM Initiate Master Data Management software for Fortune 500 and large healthcare clients such as Wal-Mart, National Bank of Canada and Province of Nova Scotia, Department of Health.
• Implemented one of the first HL7v3 implementations in Canada for Province of Nova Scotia, Department of Health.
• Improved deployment processes and documentation, making it more efficient and resulting in repeatable, successful deployments.
• Delivered small 10M members to large 300M members, complex implementations Involved in all phases of the SDLC
• SME for providing guidance in using the Initiate tools and MDM implementations -- Inbound and Outbound broker, Workbench to configure algorithm, adjust weights and thresholds and working with the Initiate SDK.
• Actively involved in client facing meetings and requirements gathering and technical discussion sessions Built strong relationships with clients, business partners and project members.
• Provided training and support to clients, peers, sales and managing consultants.

Confidential

Manager, Data Analytics

• Managed the data and operations team, delivering prompt, accurate reports on data and monitoring ETL processes between Call Centre platform, CRM system, data warehouse and over 50 external clients' CRM systems e.g. R R, ADP
• Worked closely with the Sales and Marketing team, developing strategies and solutions with the goal of helping dealerships retain customers and maintain customer loyalty
• Maintained close relations with senior management and clients, constantly enhancing Ignition's proprietary CRM system, following an Agile software development methodology
• Designed and created an activity report using Excel pivot tables and charts to help the senior management group and external clients to see current activities and help forecast future activities
• Developed ad-hoc and monthly reports for various departments Sales, Marketing, Call Centre, Finance Tools used include: Cognos ReportNet, SSRS, Crystal Reports, DTS, TSQL, stored procedures, UDF, Excel pivot tables, VBA
• Created Call Centre reports for various campaigns to measure such things as call effectiveness, call duration, time of call, connection rate and responses from customers Worked closely with the Call Centre manager, refining the reports and ensuring accurate data and analysis
• Performed database tuning and data cleansing exercises which improved the overall performance of the database Monitored, identified, corrected anomalies and removed duplication of data to provide a more accurate complete view of all company data

Confidential

SYSTEMS ANALYST

• Project managed and developed a physician profiling application for the Sales Marketing division using Cognos ReportNet to generate reports and using Informatica, WSH, DOS and FTP to automatically handle the XML data retrieval from an external source
• Project managed consolidation of 20 external facing systems to a globally shared hosting environment which resulted in saving over 400K Managed DNS changes, SSL Certificate transfers, website and database migrations
• Performed business requirements gathering, analysis and delivery of solutions following a structured project methodology Provided technical expertise database design, web design, development, implementation to multiple business units
• Worked as a team consolidating servers and migrating Oracle databases from 9i to 10g Developed a common method for connecting to Oracle databases from disparate systems
• Provided support for Sales Marketing systems with an emphasis on web design and Oracle database development Supported the online order management system for vaccines backend system involved Oracle, JDE, AS/400
• Supported Intranet Plumtree portal developed various portal gadgets to monitor daily sales, new alerts, surveys and polls Designed database schemas, developed PL/SQL packages and tuned SQL queries utilized by intranet applications and websites
• Technical lead for launching new corporate Internet site gsk.ca and other site launches herpeshealth.com, healthyholiday.ca and immunizecanada.com Coordinated with external vendors and internal business units to implement integration plans and test cases
• Established working relationships with multiple external vendors to resolve production issues with web sites, analyze data, maintain security
• Main support for Internet sites, hosted on UNIX and Windows operating systems, using various languages e.g. ASP, PHP, JAVA, JSP, JAVASCRIPT
• Implemented Verity Search system that helped Regulatory to search and locate documents within the tens of thousands of documents on file shares and within Documentum

Confidential

SYSTEMS ANALYST

• Provided consulting support to Tokio Marine Management, a major marine insurance company, to develop and create an online insurance system, which allowed worldwide customers to request quotes, check their transactions and bills, and receive instantaneous certificates, all online Worked closely with the business, gathering and documenting functional requirements
• Remodelled and normalized an Oracle database, and implemented integrity constraints based on business logic Used ERWIN to document and print schemas for all databases
• Built COM objects, using VB, to produce insurance certificates and monthly bills in a protected, MS WORD document format
• Successfully resolved problems with Virtual Policy, an intricate insurance system involving COLDFUSION, MS Access, DB2, and a legacy DOS application Documented functional and technical specifications of entire system
• Provided MS Access and Oracle PL/SQL support for ongoing projects
• Technologies used include COLDFUSION, Oracle 8i, VB, COM, ASP, PL/SQL

Confidential

LEAD PROGRAMMER

Improved performance, corrected bugs and modularized the TheGlobe.com's forum application so it could easily be customized for branding

Developed a web publishing tool for, which allowed publishers to create game reviews cheats

Converted SQL queries embedded in web pages to stored procedures which resulted in improved page load times for the main TheGlobe.com website

Utilized UNIX CRON jobs, PL/SQL stored procedures and Tango to converted dynamic web pages to static pages to help reduce the load on the database servers

Developed automated email reports for monitoring forum activity to help forecast revenue potentials

Confidential

CONSULTANT

• Developed an online competency assessment test and learning resource application for The McGraw-Hill Companies Oracle database backend with ASP web pages
• Developed interactive, dynamic web pages for General Electric's corporate website
• Developed a web-based job posting application for Forest Laboratories using ASP, ORACLE, PL/SQL, JAVASCRIPT, HTML, DHTML, CSS
• Migrated MS Access databases to Oracle and web enabled legacy application

Confidential

DATABASE AND SYSTEMS ADMINISTRATOR

• Administered Oracle databases, NT network, Seattle Labs email and IIS 4.0 web servers
• Designed, developed and supported a 3-tier web enabled sales support system for pharmaceutical companies Developed reports using Crystal Reports database components utilizing PL/SQL functions, procedures, packages and triggers web pages using ASP, JAVASCRIPT, VBSCRIPT, ActiveX, HTML
• Responsible for monitoring daily ETL operations involving point of sale data
• Provided technical support and training to pharmaceutical sales representatives across Canada for Moir's proprietary sales system