Sql Server Management
Resume:
M E H RDAD ORANG
*******.*****@*****.***
Whippany, NJ 07981
QUAL I F ICAT IO NS & SK I L LS:
• More than 5 years of experience in analyzing t erabyte databases, writing complex
SQL queries, and developing f inancial and performance reports .
• More than 5 years of experience in T-SQL, P L/SQL, MS SQL Server, Oracle, MS
E xcel, MS Access.
• Detail oriented data analyst with solid a nalytical and p roblem solving skills
combined with extensive knowledge of b usiness processes.
• Strong team player and highly adaptable in multinational environments.
M BA,
E DUCAT IO N Master of Business Administration
M ay 2008 - Apr 2010
Florida International University - Chapman Graduate School of Business, Miami, FL
Politecnico di Milano - M IP School of Management, Milan, I taly
Focused on International Business
Computer Engineering
B.Sc.,
Sep 2001 - Jul 2006
Azad University – School of Electrical and Computer Engineering, Tehran, I ran
Focused on Software Engineering
EXPER I E NCE S kyBOX I nc.
J an 2010 – Apr 2010
Online retailer and shipping company, presence in over 52 countries, Miami, FL
Business Data Analyst/Consultant
P rovided analytical support on strategic projects as needed to improve the efficiency and
effectiveness of marketing, advertising, and communication strategies.
• Business Data Analysis: Supported the analytic needs of the business by analyzing
online shopping and customer behavior.
• Data Analysis: Developed several SQL queries in MS Excel to analyze the market
research of SkyBOX costumers; Including the analysis of data on customer
demographics, preferences, needs, and buying habits.
• Business Analysis: P repared and delivered various management reports and
p roposed different strategies to address different customer segments.
A donis Co.
A pr 2006 – Ma r 2008
Specialized in design and implementation of Management Information Systems (MIS),
Tehran, I ran
Business Analyst/Reporting Analyst
Analyzed, designed and implemented two information systems for human resources and
retirement departments of the largest national airline to manage internal processes and
analyze data of more than 100,000 employees.
• P rocess Engineering: Defined and reengineered internal processes to increase
efficiency that resulted in reduction of required work force by 15%.
• Reporting Analysis: Collaborated with two departments to gather necessary
i nformation, establish and clarify analytical needs and Key Performance Indicators
( KPIs) of the departments.
• Data Analysis: Developed an extensive number of complex SQL queries and reports to
manage and analyze the data of all employees.
• Technologies included : MS-SQL Server 2000, MS-SQL Server 2005, T-SQL, Crystal
Reports, Visual Basic, Visual SourceSafe, and Microsoft Project.
Pooya I nc.
J ul 2002 - Feb 2006
ISO IT certificate holder and one of the top national IT companies, Tehran, I ran
Database Application Developer/Data Analyst
Analyzed, designed and implemented enterprise application software for Maskan Bank,
one of the largest national banks with more than 1 million account holders, in a team of 12
to 15 software developers/analysts and through all phases of Systems Development Life
Cycle (SDLC).
• SQL Data Analysis:
o Designed and implemented advanced SQL queries consisting of several joins and
aggregate functions to analyze the terabyte database of more than 1 million account
holders.
o Designed and implemented complex and custom financial and performance reports
for different levels of management.
o Optimized several complex queries and reports to minimize their execution time;
reduced the execution time of one report from 37 hours to 45 minutes.
• Mentoring: T rained and supervised three new employees in writing complex
T ransact-SQL (T-SQL) & PL/SQL statements and working with MS SQL Server
objects.
• P rogramming: I mplemented several applications such as opening checking and
saving accounts, transferring data between headquarter and branches of the bank, and
issuing debit cards.
• Technologies included : MS-SQL Server 2000, Oracle 9i, T-SQL, PL/SQL, Crystal
Reports, Rational Rose, Visual SourceSafe, Microsoft Project, and Visual Basic.
Computer skills:
OT H E R
• T-SQL, PL/SQL, MS SQL Server 2000, MS SQL Server 2005, Oracle 9i, Crystal
Reports, Visual Basic 6 (VB), MS Visual Source Safe (VSS), Microsoft Project.
• Microsoft Office Suite 2003/2007: MS Excel, MS Access, MS PowerPoint, MS Word, MS
V isio.
P rofessional activities:
• Led a team of five i n Global Management Challenge (GMC), the largest strategy and
management competition in the world. R anked number 1 i n the business school with
18% higher share price than all other teams.
o Data Analytics: P rovided analytical support for proper strategic decisions and
t actical implementations; synthesized the data of finance, marketing, accounting,
h uman resources, and production departments.
o Data Analysis: Developed MS Excel packages to forecast demand and calculate
p rofitability of multiple products in multiple regions based on various market
researches and company’s datasets.
• Proactive member of the M IP Consulting Club. Active participant of various business
seminars associated with companies like BCG, Bain, Acer, GE, Microsoft and
Whirlpool.
• Proactive member of FIU International Students Club (ISC).
Related Courses:
• MBA: B usiness Statistics, Corporate Strategy, Finance, Marketing, Accounting,
M anagement Accounting, Economics, Innovation Management, Technology Strategy,
P roject Management.
• Computer Engineering: P robability and Statistics for Engineering, Relational
Database Management Systems (RDBMS), Software Engineering, relational data
modeling and databases design, Advanced Programming, Computational mathematics.
• I n te rnational Business: G lobal Financial Strategies, International Accounting,
I nternational Business Environment.
Languages: E nglish (fluent), I talian (basic).
Notes: Legally authorized to work in U.S. for any employer.
Reference : References available upon request.
Contact this candidate