SQL Developer
Resume:
MOZHGAN JAVADI
**, ******** ****, ***** **** ON M2N 2R2
Cell: 416-***-****) Email: *************@*****.***
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: *************@*****.*** 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