Sql Server Data

* ******** *****, ***. *** E-mail: *********@*****.***

Toronto, ON M4C5L8 Cell: 647-838-

2052

PROFILE SUMMARY:

An accomplished total 7 years experience in Information Technology (IT) as

a Reporting Analyst with 4 years of experience as a SharePoint & Database

Administration in working with various versions of MS SQL Server

2000/2005/2008 RDBMS System; also simultaneously experiences in Report

developer by using various reporting tools; SAP Business Objects, SQL

Server Reporting Services, Crystal Reporting, Microsoft Excel.

. 4+ years of experience in installation, configuration, administration,

and maintenance WSS 3.0, MOSS 2007, and SP 2010.

. Experience in Portal Migration from MOSS 2007 to SP 2010 using Hybrid

approach and SPS 2003 to MOSS 2007 using Gradual approach.

. Proficiency in Creating, Configuring & Customizing Web Application,

Site Collections, Document Libraries, Content Types, RSS and Custom

Lists.

. Extensively used Active Directory for creating Users and Groups, and

integrating with SharePoint.

. Extensively worked on managing security; and setting up permissions

and permission levels to users and groups for Sites and Lists.

. Expertise in configuring Search, SSO, Excel Services, InfoPath Form

Services and User Profile Management in SSP.

. Expertise in customizing SharePoint Site; creating and modifying

Content Type, creating Site Column, and modifying Navigation Bar.

. Worked on creating and customizing dashboard pages in Report Center.

. Expertise in creating Sites, Sub Sites, Lists, List Views, Blogs, Wiki

Pages, Alerts, Page Layouts, Site Templates, Team Sites, List

Templates, and Navigation.

. Extensively worked on BDC and BCS to integrate business data from back-

end server application to MOSS 2007.

. Experience in integrating SharePoint with MS Office.

. Extensively worked on creating and modifying Master Pages and Content

Pages in SharePoint Designer 2007/2010.

. Worked on creating Workflows in SharePoint Designer 2007/2010.

. Expertise in SSAS, SSIS, SSRS.

. Experience in ETL Process in various databases.

. Involved in writing Transact-SQL command line script for various

needs.

. Proficient at web-based programming, leveraging the .NET framework

. Proficient at developing web-forms and connecting with databases

. Proficient with databases and SQL ?

. Proficient with MS Access, Excel, and VBA programming ?

. Proficient with data modeling

. Reviewed, evaluated, designed, implemented and maintained reporting to

support current business initiatives.

. Developed complex reporting utilizing Crystal Reports, Business

Objects, SQL stored procedures and Microsoft Excel.

. Advanced Microsoft Excel experience in data processing (including

basic Excel functions such as vlookup, index, match, pivot table, and

macros).

. Identified and researched data issues and areas for improvement.

. Developed highly complex reports and provided information and data

across divisions.

. Provided technical and analytic expertise in responding to complex

specialized report requests.

. Developed new insights and analysis to meet marketing objectives.

. Conduct periodic customer surveys to evaluate the value of end-user

support tools, help desk support services, and training needs

. Sound Knowledge in Backup & Restore using company SOP(Standard

Operating Procedures) for different backup medias, Involved in

creating & documenting Backup strategy & Disaster Recovery plan for

production, test and development servers within specified Maintenance

Window

. Experience with Power point presentation for various and expert with

Microsoft office.

. Experience with test case scenario and create user manual for

potential system.

. Advanced knowledge in Microsoft Excel, Microsoft Access

. Working knowledge of Microsoft Project 2010

. Excellent interpersonal skills necessary to successfully work with

users, developers, analysts and other writers to produce in a fast-

paced environment

Looking for a career advancement opportunity with a company that will

challenge my problem solving skills and allow me to develop my knowledge

& potential.

TECHNICAL SKILLS:

Operating : Windows 95/98/NT, Windows Server 2000/2003/2008/2008 R2,

Systems Unix, Linux RHEL, Oracle Enterprise Linux, Windows XP/7.

Hardware : IBM Compatibles, HP & Dell Servers, TCP/IP

Languages : T-SQL, PL/SQL, C, C++, Visual Basic, Java

RDBMS : SQL Server 2008 /2005 /2000/7.0, Oracle 11i/10g.MS Access

Database Tools : MS SQL Server 2005/2008, SSMS,BI, Query Analyzer, SQL

Profiler, Erwin Data Modeler, MS Visio

Utilities : BCP, BI, OSQL, SQLCMD, DTS Import/Export, FTP,

SharePoint2007 and SharePoint 2010, Office 2010, InfoPath

2010, Microsoft Project 2010

Internet Tools : HTML, MS FrontPage

Tools : DB Artisan 8.1, SQL Lite speed, SQL Backup, Fog light

Manager and Control M-Agent, OOAD, RUP, UML, Agile, MS

Visio, Erwin Data Modeler, POS (Digital dining, Sharp and

Radiant System), SAP Business Objects, SQL Server

Reporting Services, SQL sever Integration Services,

Crystal Reporting, HP Quality Center, Advanced Microsoft

Excel, Advanced Microsoft Access, Lotus Notes 8.5

Other : IIS 5/6/7, Active Directory, DNS, DHSP

Technologies

EDUCATION:

Master of Science in Software Engineering, University of Toronto,

expected graduation 2013

BBA in Computer Information Systems, City University of New York,

2005, NY USA

CERTIFICATIONS AND TRAININGS:

. Microsoft Certified Professional (MCP).

. Oracle Certified Professional (OCP)

. SAP Business Objects

. Crystal Reports 2011

. Microsoft SharePoint 2007, 2010

. Microsoft Project 2010

. Advanced Microsoft Access 2010

. SQL Server 2008 Reporting Services, Integration

Services,

. MCSE training

. A +, N+

. Sun Solaris, Linux

. Quick Books

. Intermediate and Advanced Excel 2003, 2007 & 2010

. Advanced Microsoft Access

PROFESSIONAL EXPEREINCE:

Ontario Lottery and Gaming, Toronto, Canada July 2012 -

October 05, 2012

Ontario Lottery and Gaming Corporation (OLG) is an Operational Enterprise

Agency created by the Government of Ontario. OLG and its affiliated

companies employ more than 18,000 people throughout the province. We are

responsible for 24 gaming sites and sales of lottery products at

approximately 10,000 retail locations across the Province of Ontario.

Data / Report Analyst

Responsibilities:

Develop reports using tools that include SQL Server Reporting Services, MS

Access and Excel. Work as liaison to the Data Base Administrators for large

data uploads from other sources, while also testing new and revised reports

for data accuracy and reporting reliability and in creating required

documentation for all new and revised reports.

. Manage the reporting function including scorecard and databases.

. Extensively work with InfoPath Form Services and published in

SharePoint

. Used VBA and Macros to automate Business Processes, Functions and

Capabilities

. Design and/or build strategies (reports, dashboards, etc.) that

analyze quality performance.

. Work closely to define reporting needs and to enhance the data

warehouse and data packages.

. Consolidate Excel workbooks from multiple sources into a consolidated

Excel workbook.

. Review RFI responses, follow-up questions and comments from multiple

Excel workbooks to ensure data quality consistency for further data

processing.

. Test and validate key data points generated from the data warehouse.

. Define new performance metrics

. Assist in the implementation and tracking of key performance

indicators; utilize data trends to identify opportunities for

improvement

. Work closely within a team of highly experienced, analytically

inclined professionals

. Execute ad hoc data analyses in response to business requests

. Work cross-functionally within the organization

C'EST WHAT Software Solutions, Toronto Aug

2006 - Jan 2012 Reporting Analyst/SharePoint Admin

SUMMARY:

Assisted managers in the development of weekly, monthly status reports

and payroll reports. Document process flows, policies and maintains a

responsibility for gathering and analyzing user requests, documenting

business processes, creating workflow documentation, and analyzing system

data relative to the SharePoint Applications across business lines. This

role owns the management of all requirements gathering, analysis, and

testing of incoming user requests, including effectively documenting and

articulating tactical and strategic requirements to management, business

stakeholders, and developers for the purpose of developing SharePoint

solutions for the business units involved. Besides the project work; also

maintain and create the SharePoint site and all users request on daily

basis.

. Develop and support custom web applications built on the SharePoint

2010 platform and other related technologies;

. Develop and support custom SharePoint components such as web parts,

lists, libraries, and event receivers

. Worked as business analyst to support the re-design of company's

existing system. Extensively involved in the development of Reporting

Data Warehousing System.

. Migrated SQL Server 2000/2005 databases to SQL Server 2008 R2.

. Developed the conceptual & logical data model for the proposed

solution.

. Designed and implemented ETL process, UI controls and reports'

templates.

. Creating Pivot table, Macros using Microsoft Excel and integrate with

SharePoint 2010 in Company's Business Intelligence center.

. Conducted interviews with key business users to collect requirement

and business process information.

. Performed extensive requirement analysis including data analysis.

. Developed business requirement specification documents as well as high-

level project plan.

. Planning and administrating data migration from previous intranet

sites

. Setting up SharePoint governance techniques.

. Document management specialist, developing documents rollups

. General Administration of MOSS 2007, 2010 and WSS 3.0 sites

. KPIs (Key Performance Indicators), SharePoint content publishing,

dashboard, business data catalogs, Gantt charts, managing content

types, metadata, InfoPath form services, excel services, SharePoint

blogs, wiki's, discussion threads.

. Serve as liaison between the business divisions and development;

interview staff and conduct functional requirements gathering

sessions; participate and facilitate meetings that identify SharePoint

solutions to meet business need; analyze user requests for new

systems, enhancements to existing systems.

. Played a key role in the planning, testing, and implementation of

system enhancements and conversions.

. Functioned as the primary liaison between the business line,

operations, and the technical areas throughout the project cycle.

. As necessary assisted with the process of identifying and recommending

vendors, and assisted with the vendor relationship.

. Extensively work on Access, Excel, Erwin DM, SharePoint 2010, MS VISIO

and SQL.

SP Data Solution

Sept2005 -July 2006

Data Analyst/ SharePoint Admin

Develop reports using tools that include Crystal Reports, SAP Business

Objects, SQL Server Reporting Services, MS Access and Excel. Work as

liaison to the Data Base Administrators for large data uploads from other

sources, while also testing new and revised reports for data accuracy and

reporting reliability and in creating required documentation for all new

and revised reports.

. Strong background in analysis, design, development, testing and support

of advancement information systems with an emphasis on data quality

control

. Excellent analytical skills for report specification development

communicate well with end users in order to translate their reporting

needs.

. Ability to document code and systems according to established standards

and broad knowledge of industry best practices in data reporting and data

modeling

. Established the SAP Business Objects Proof of Concept to make sure the

Senior Managers have enough understanding for BO reporting tools.

. Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams,

OOD using UML

. Responsible for identifying and documenting business rules and creating

detailed Use Case

. Translated the business needs into system requirements, communicating

with the business on a non-technical level, and with the System Analyst

on a more technical level.

. Documented and delivered Functional Specification Document to the project

team.

. Participated in the logical and physical design sessions, developed

design documents.

Bon Secours New York Health System, NY

March 2004- Aug 2005

Business Analyst/QA

Responsibilities:

. Extensively involved in setting up business rules to establish various

functionalities in the organization and validating those rules against

live data.

. Created a segment extraction process to derive a required segment from an

inbound transaction.

. Responsible for defining and documenting the data migration processes

including providing extensive guidelines

. Participate in Requirements JAD sessions, performing end-to-end business

analysis deriving client requirements

. Communicated and maintained strong working relationship with various

business groups such as Project development and external clients

regarding functional requirements

. Worked with technical teams to research and advice on alternative

technical solutions to address critical/major business issues and

opportunities

. Provided input to the project work plan for Business Analysis team

activities and deliverables

. Designed and wrote test cases for assisting the quality assurance team

with the help of User Interface Design Document's, Use Cases and

Functional Requirements.

. Responsibilities also included coordinating User sign-off, Acceptance

testing and User training.

. Translated complex functions like Tax Reporting and Death Benefit Values

into requirements into Use Cases

. Documented enhanced functional requirements for multiple financial

transactions like surrenders, remittances, maturity and verified the

numbers using calc tools.

. Verified database integrity for accurate data mapping and data conversion

. Authored a comprehensive system plan and created Test strategies and Test

Matrix translating technical requirements into testing specifications.

. Communicated and liaison with developers through all phases of testing to

prioritize bug resolution.

. Provided Knowledge Transfer by training new recruits for the project.

REFERENCES: Available Upon Request

Contact this candidate