Sql Server Developer

Aamer Shariff ** Gatwick Lane, Brampton, ON L*S *E4

********@*****.** Cellular 416-***-**** Home 289-***-****

BUSINESS INTELLIGENCE DEVELOPER/ANALYST

Information Technology professional with considerable experience (8+ years) with proven ability to design and develop BI solutions, implement new processes & programs and support information and data warehouse operations on a large scale.

TECHNICAL COMPETENCIES

BI & Reporting : SQL Server Reporting and Analysis Services 2005, Crystal reports10, Cognos 8, SAS 9

Languages & Environment : Visual C#.Net, Visual Studio.Net, SQL, XML, Unipaas, Edeveloper 9,

ASP.NET, JavaScript, HTML, AS/400, UML, ITIL, Windows Vista

Software, Tools and Utilities: Sage PFW, MS Dynamics CRM, MS Great Plains, ibolt, Photoshop,

MS office 2007,MS Project 2007, SharePoint 3.0

Databases: SQL Server 2000/2005, IBM DB2, Pervasive, Btrieve, Oracle 11g.

EXPERIENCE

Workplace Safety and Insurance Board, Ontario, Canada http://www.wsib.on.ca

Information management department Toronto, Ontario, Canada

Cognos Developer Analyst / Information Specialist July 2010 – Present

Participated in cognos 8.3 upgrade to 8.4 and development of reportsDeveloped a executive dashboard solution for a new worker reintegration programIntroduced some new cognos reporting capabilities and best practices within the organization.External and Internal application support for cognos usersConducted training sessions for cognos end users on report studio, query & analysis studio.Designing and developed reports, cubes & data models using framework manager & transformerInvolved in development of Corporate balanced scorecard for KPI using metric studioConduct JAD and brainstorming sessions for gathering business requirements, GAP analysis. Develop prototype solutions for requirements gathering and business analysisWrite technical and functional specification documentsWrite SQL Stored procedures and Validation SQL scripts on DB2 database.Gathering and analysis of the KPI data and supporting the business analysts.Involved in the development of data marts and data warehouseDeveloped and designed the hot files reporting capability Working on development of cognos TM1 cubes for a pilot project

Dimensional Strategies Inc / Vincor Canada – A Constellation company http://www.vincor.ca

Business Intelligence department Mississauga, Ontario, Canada

Cognos BI Developer / Business Intelligence Analyst Dec 2008 – June 2010

Administer the daily operational BI tasks and processes. Build and publish cubes. Implement and designed new operational procedures and processes. Gather and analyze third party sales data. Developed a complete technical, operational and end user documentation framework. Develop reports in Cognos 8 and automate their execution. Data analysis and modeling. Troubleshooting issues with SSIS, Cognos Decision Stream ETL, and Cognos Reporting.Develop utilities using visual C#.net for automating the BI processes.End-user requirement gathering, technical support and trainingData modeling using Cognos Framework manager and TransformerDeveloped a technical and end user documentation.Build business dashboards and scorecards using metric studio for analysis.Cognos Connection Administration and securityDevelopment of queries, stored procedures and views for the ETL using SQL Server 2000/2005.

Industrios Software http://www.industrios.com

Client support and Custom development department Oakville, Ontario, Canada

Business Intelligence Developer /Application Support Analyst July 2007 – Nov 2008

Deploy, Install and configure software at client sites remotely or onsiteDesigned, developed and customized crystal reports using version 8 and 10.Designed and developed the ETL process.Teamed to develop processes and procedures for application supportExcellent 1st line & 2nd line customer support and end user training (Onsite and Offsite)Writing Queries and troubleshooting issues in Pervasive and SQL Server database.

VadimSoftware http://www.vadimsoftware.com

Client support and software development department Kelowna, BC Orillia, Ontario, Canada

Cognos developer/ Application Support Analyst May 2003 – June 2007

Implementation and Support of Canadian municipal and utility systems. Successfully served as project lead, process owner and business analyst.Sucessfully led an $5 million systems development project outsourced in IndiaRequirement and business analysis for existing customers requiring customized applications.Developed business dashboard and reporting systems using cognos 7.4 and crystal reports.Data design and SQL scripts development using SQL server 2000/2005.Integration with other tools and utilities viz synergize document management, GIS, MS Office.Customer support, user documentation and training (Onsite and Offsite).

Addidas Salomon – http://wwww.addidas.ca

Application development department .Vaughan, Ontario, Canada

DB2 Technical Consultant Oct 2002 – Dec 2002

Served in the team as a consultant for the sales order inquiry systemConversion of legacy data into DB2 database. Integration of email into the application

Himalaya Drug Company – http://www.himalayahealthcare.com

Information technology department Bangalore, India

Cognos developer/Systems Analyst Apr 1999 – Sep 2002

Developed and integrated technologies to support operational and financial needs. Recognized for excellent problem-solving skills, various program development and database related skills.Designed and developed a sales data warehouse for the implementation of Cognos BI reporting Preparation of Training manuals and user guides for the Information systems.

EDUCATION & CERTIFICATIONS

IBM Cognos Certification 2010

IBM Certified Cognos 8 reports designer, Cognos 8 Scorecard developer

ITIL V3 Foundation Certificate 2010

Information technology Infrastructure Library – Service lifecycle framework

Sheridan College Institute of Technology, Brampton, ON 2009Certificate in Project Management Certificate in Business Analysis (Continuing)

Thomson Rivers University, BC, Canada 2004(Financial Accounting -1, Computer Business Applications, Systems Analysis and Design)

Canadian Payroll Association, Toronto, ON 2005Certified Payroll Administrator

University of Mysore, India Master of Business Administration (Finance) 1999

University of Mysore, IndiaBachelor of Commerce 1996

National Institute of Information technology, India Diploma in computing 1995

IBM, IndiaDB2 Solutions Expert Certified 1999

Contact this candidate