Sql Server Data

SEAN GHARAVI

** ********* **., *******, **., M*H 1C5 Residence: 647-***-****, Mobile: 647-***-****

Email: **********@*****.***

SUMMARY OF QUALIFICATIONS:

• Information system professional offering more than 10 years’ experience in analysis, design,

implementation and deployment of enterprise database management system, data warehouse and

application software development.

• Strong background in requirement gathering and analysis, use case modeling, developing

technical models/specifications, designing test cases and application interfaces.

• Expert in relational database and data warehouse, data modeling, ETL/mapping design, reporting

and BI.

• Proven skills in project management, documentation, client and colleague relations, written and

verbal communication, training and development, team leadership/motivation and time

management.

TECHNICAL SKILLS:

Methodologies and SDLCs:

SSADM, RUP, SCRUM, XP

Modeling and CASE Tools:

Visio, Enterprise Architecture, Power Designer, Rational Rose, Toad Data Modeler

Software Architecture and Technologies:

WPF/WCF, MVVM, Spring, Prism, SCSF/WCSF, Enterprise Architecture, API, SOA, SaaS

Project Management and Control:

Microsoft project, Mindjet, Primavera, PMBOK

Database technologies:

Microsoft SQL Server 2000/2008 (SSIS/SSRS/SSAS), Oracle 10/11g (OWB/BI), MS Access

Design and Models:

Requirement Analysis, Use case Modeling, Relational/Dimensional data models, ETL Design, DDS

Programming languages:

C, C++, C#, Java, T-SQL, VB

Software tools:

Microsoft Office (Word, Excel, PowerPoint), Crystal Report, SharePoint, ESRI GIS

Operating Systems and Virtualization:

Windows 7/XP, Windows Server 2003-2008, Linux, ESX, VMware Workstation, Citrix

Proven domain’s knowledge: Transportation, Energy and Financial sectors

PROFESSIONAL WORK EXPERIENCE:

Data Management / Information Technology Consultant April 2014 – Present

Ideal Pharma Canada Inc.

Key achievements:

• Requirement analysis, Data modeling and database designing.

• Preparing charter, vision and planning development phases for Information Technology and data

management projects.

• Infra structure and software development platform selection.

Projects:

• Online marketing and retail sale (mobile/web development project).

Senior System Analyst and Development Lead March 2007 – February

2014

TGN Software Consultant Co.

Key achievements:

• Supervised and mentored multiple teams of analysts, designers and developers on various enterprise

data management, data warehouse and software development projects.

• Preformed requirement gathering and analyzing, use case modeling, software and database

architectural designing.

• Provided software project charter, vision and software development plan and presented project

progress and achievements to stockholders, collaborating and supervising software development

team(s) during project course.

• Prepared software architectural and component design, conceptual and logical data models.

• Analyzed and prepared database security and users’ privileges.

• Designed database backup and recovery strategies and preformed database performance tuning

strategies.

• Analyzed and designed required infra structure and software and development platforms.

Projects:

• Enterprise data warehouse for road maintenance and transportation. Utilized Oracle 11g (OWB, BI),

to extract various data from more than10 different data sources (Oracle 9/10, SQL Server 2000/2005,

Access and excel) into a comprehensive data warehouse consist of ETL, data mapping, and cleansing,

CDC, MOLAP data marts and SOA data visualization dashboards.

• Referenced energy system, energy sector enterprise data management and analytical data warehouse.

Utilized SQL Server 2008 (SSIS/SSRS), ESRI ArcGIS Server 10 for gathering energy sector data and

building an analytical data layer for energy production, supplying and consumption modeling. Consist

of TPS layer, data warehouse, data visualization dashboard.

• Municipality DEPC projects data management system with Oracle 11g, ESRI ArcGIS Server 10, to

develop enterprise geo spatial data management system for gathering and manipulating spatial,

descriptive and archival data consisted of relational data base, Administration and technical and

managerial dashboards and applications.

• Petroleum full field study data management system, comprehensive relational data management

system for manipulating petroleum full field studies and master development planning information.

Utilized SQL Server 2005.

• Fleet management system for manipulating municipality’s vehicle tracking and navigation. Utilized

SQL Server 2008, ESRI ArcGIS Server 10, .NET. Enterprise system consists of Communication

server, Data base server, GIS server and web applications.

• Parts and ordering system, for developing inventory data management and parts’ selection to fulfil

ordering procedure from international Caterpillar parts’ providers with SQL Server 2005, Oracle 10

and .NET.

Senior System Analyst June 2003 – October

2006

Ashkan Tech, IT Development Inc.

Key achievements:

• Supervised and mentored a team of web designers and developers on a software development project.

• Preformed requirement gathering and analyzing, use case modeling, software and database

architectural designing.

• Prepared software development plan and conceptual and logical database design.

• Analyzed and prepared database security and users’ privileges.

• Participated in Software development projects as business system analyst and technical RUP /UML

writer with Rational Rose.

Projects:

• Hotel reservation system, a relational data management system with SaaS technology to fulfilled hotel

reservation procedure. Utilized SQL Server 2000 and .NET.

• Electronic medical record system for manipulating patient clinical data and archiving medical records.

Utilized SQL Server 2000 and .NET.

Senior System Analyst and Designer October 1999 – March 2003

NIOC, Exploration Directorate

Key achievements:

• Preformed requirement gathering and analyzing, use case modeling, software and database

architectural designing.

• Provided software project charter, vision and software development plan and collaborated and

mentored software development team during project course.

• Prepared conceptual and logical data models and physical database structure.

• Analyzed and prepared database security and users’ privileges.

• Designed database backup and recovery strategies and preformed database performance tuning

strategies.

Projects:

• Petroleum information management system (PISDB), enterprise distributed database System for four

major NIOC subsidiaries companies with more than 20 technical software applications with SQL

Server 7/2000 and Visual studio 6 and .NET.

• Oil/gas exploration data management system for gathering and manipulating exploration data in

various upstream domains such as geology, well drilling, geophysics, and petro physics. Utilized SQL

Server 7/2000 and Visual Studio 6 and.NET.

Lecturer February 1996 – February

2003

North Tehran Azad University

Key achievements:

• Taught database design essential course for 12 semesters.

• Taught data storage and retrieval methods course for 14 semesters.

• Taught applied geographical information systems course for 3 semesters.

• Instructed students in database lab for 10 semesters.

• Instructed more than 30 B.Sc. student’s thesis.

Education:

• M.S., Engineering degree from Sharif University of Technology

• B.S., Engineering degree from Sharif University of Technology

Interests:

• Tennis, fishing and chess.

References:

Available upon request

Contact this candidate