Post Job Free

Resume

Sign in

SQL Developer

Location:
Toronto, ON, Canada
Posted:
February 24, 2017

Contact this candidate

Resume:

MOZHGAN JAVADI

**, ******** ****, ***** **** ON M2N 2R2

Cell: 416-***-****) Email: acyzlf@r.postjobfree.com

CAREER TARGET: SQL OR BI DEVELOPER

PROFESSIONAL SUMMARY

Detail-oriented and team player Database/BI Developer with 2 years of experience in SQL, T-SQL, SSAS, SSIS, SSRS and writing MDX query. Familiar with data warehousing and data mining concepts. Good experience in working with large amounts of data in banking industries. Flexible and works analytically in a problem-solving, results oriented environment. Proactive, dynamic, sense of organization, team spirit.

Technical Skills

Database design and development with SQL Querying SQL Server databases MS SQL, SSAS and SSIS Designing and implementing SSRS reports MDX Dimensional modeling techniques Data warehousing and data mining concepts Microsoft Office Suite VBA

WORK HISTORY

Junior BI Developer - Hooshodanesh, Tehran, Iran Jan 2015 - Dec 2016

Updated and tested OLAP data cubes including banking facilities using SSAS and MDX

Created MDX queries to extract data from Data Mart

Maintained bank facilities data warehouse

Designed and developed SQL store procedure to create ETL model to validate, extract, transform and load data to data warehouses and data marts

Created parameterized reports and linked reports through knowledge of report serving architecture

Optimized queries using SQL profiler, execution plan and database engine tuning advisor

Monitored, maintained and optimized reporting environments and components

Worked closely with bank specialist team members to evaluate business requirements and informative views and dashboards

Responsible for working with external clients to develop reporting/analytics solutions in response to their requests

Participated in design and development of “Biar” online store application database

Performance Reporting Analyst - DHL Express, Tehran, Iran July 2008 - June 2014

Generated various reports to aid performance improvement

Reviewed Operations’ Productivity, Service Performance and Process Compliance data

Managed, analyzed, monitored and reported operational data using KPI’s, dashboard within set deadlines

Validated data against other sources both local as well as central information and analyzed related information

Kept track of all Operation KPIs in order to ensure KPIs reach set targets

Ensured performance reports were generated according to specifications and distributed as per the agreed timetable

Identified areas of opportunity to improve quality of service, proposed action to take. Followed up and

monitored actions by other departments and their effects and impacts on performance

Participated in problem solving by utilizing performance improving project and workshops

MOZHGAN JAVADI Cell: 416-***-****) Email: acyzlf@r.postjobfree.com Page 2/2

IT Helpdesk Support - DHL Express, Tehran, Iran June 2007 – June 2008

Implemented and provided 1st level support to all data/voice communication devices (PC, laptops and printers) and line (LAN, WAN, PABX); this support consisted of all users at IR DHL Express included Tehran office and substations at other cities

Supported and implemented the DHL front end systems and applications; provided IT solutions to meet IT requirements

Observed network security standard and antivirus security

Took regular back up from databases, data files and systems state

Achievements: Nominated Employee of The Year 2007

Network Administrator - RAMPCO International Kish Engineering Co. Tehran, Iran June 2006 – June 2007

Designed cover field and running wireless LAN using JEEE802.11G & setting of 5 access points for 50 working stations with bandwidth 54MBPS

Responsible for the maintenance and protection of the network

Installed & configured ISA Server and Print server

Network Engineer - STPC, SHAHID TONDGOYAN Petrochemical Company, Tehran, Iran Sep 2004 – June 2006

Maintained and supported LAN network in Tehran office

Supported and implemented all software and applications; provided IT solutions to meet new and existing business/IT requirements

Installed, configured and maintained domain controller, ISA server, MDaemon as a mail server

Supported automation system with SQL database

Networks monitoring with IT tools (Solar winds, Server Alive)

EDUCATION

B.Sc. Computer Software Engineering Azad University, Tehran, Iran 2004

CERTIFICATES

Business Intelligence using SSAS 2014

(Data Warehousing, OLAP, SSIS & ETL, Data Mining, Presentation) Faratar_Az_Danesh, Tehran, Iran, 2015

Microsoft SQL Server Reporting Services - Faratar_Az_Danesh, Tehran, Iran, 2015

Programming in C# - Sematec Institute of Technology, Tehran, Iran, 2016

SQL 2014 Design and Implementation - Faratar_Az_Danesh, Tehran, Iran, 2015



Contact this candidate