AZADEH DANESHPANAH
Scottsdale, AZ 85258
Cell: 480-***-**** email: *******@**********.***
OBJECTIVE: Senior Database Developer
ACCOMPLISHMENT AND HIGHLIGHTS
Superb analytical and problem solving skills
Perform well under pressure and ability to meet deadlines
Responsible and positive team player
Dedicated to continuous improvement and committed to lifelong learning
Supervised team for tasks and projects related to program design
Selected by software management to create a software prototype for its clients
TECHNICAL SKILLS
Databases – SQLServer 2005, 2008 and 2012
Tools – MSVisual Studio, SSIS, SSRS,Tableu, DTS, SVN Tortoise, Red Gate and VSS
Languages – SQL, T-SQL, C#, VB.Net, ASP.Net, VB6, Visual Basic.Net, XML, HTML and Javascript
Environments – Microsoft Windows
PROFESSIONAL WORK EXPERIENCE
Advertising Checking Bureau, Tempe, AZ, Apr. 2008 – Present
Senior SQL Developer/SQL DBA:
Design, develop and maintain Microsoft SQL databases in dev, test, staging and Production environments.
Design and tune procedures, functions, triggers and views to review and manage client data.
Designed and Developed ETL processes using SSIS for data migration and daily system management.
Report development in SSRS 2005, SSRS2008 and SSRS 2012.
Installed and configured SQL2005, 2008R2 Enterprise, SQL2012 and SQL2016.
Created maintenance scripts and jobs to help maximize server response and data recovery.
Responsible for collaboration with offsite clients to gather data specific requirements within allotted project deliverable time frames.
Major Achievements:
Designed an enterprise level claiming processing system for Warner Music Group, AT&T, Directv, Verizon and Pioneer. Created SSIS packages for Stellantis-FCA data files. Created complex SQL routines and processes according to client needs. Followed best practices and standards for the full development life cycle of these products. Responsible for the data modeling of the projects. Mentored developers to adhere to company SQL standards to maintain the products after production release. Made recommendations for performance improvements to maintain high level availability and performance. Overall results were our client was extremely satisfied.
,…2
AZADEH DANESHPANAH Page 2
Concurrently support over 8 websites and migrate our environments from SQL2005 to SQL2008R2 (Visual Studio 2010). Also migrated the report server to 2012 report server.
During our migrations found areas of further improvements taking advantage of SQL Servers latest features where applicable.
New Architecture initiative – A majority of older existing sites were slow and maintenance hours were high. Continued to work within our cross functional team consisting of our customer support team, business analyst and developers to provide a base model for our Cooperative
Advertising Applications. Lead the design of the new structure to improve overall response time, data flow and reliability. Re-engineered and migrated existing clients into the new architecture successfully.
Software Developer Nov. 2007 – Apr. 2008
First National Bank of Arizona, Tempe, AZ
Developed and implemented a vendor relationship web application.
Modified existing windows application program to create a user friendly interface.
Customized Nonprofit Store Front Application to meet user’s requirements.
Utilized VB.Net, ASP.Net, C#, ADO.Net, SQL Server 2005, Stored Procedure, T-SQL, and Source Control.
Information Technology Specialist III May 2007– Nov. 2007
Arizona Department of Economic Security, Phoenix, AZ
Developed and implemented an object oriented application of the Encounter System.
Developed an application for correction processing of pended Encounters.
Tested and implemented an existing intranet and internet web application for gathering user’s input and validating data against business rules.
Utilized C#, ASP.Net, ADO.Net, SQL Server 2005, Stored Procedure, T-SQL, and Visual Source safe.
Software Developer Feb. 2004 – Nov.2006
Aralco Retail Systems, North Vancouver, B.C.
Worked individually and as a member of a team to develop point of sale
and back office systems to meet the users’ needs.
Gathered requirement from clients, maintained and modified existing application program, tested and implemented codes to increase efficiency for users.
Provided support through line response via phone, fax and e-mail to confirm technical assistance requirements.
Responsible for accounting interface and converting data from MS Visual FoxPro to MS SQL Server.
Utilized VB6, SQL Server 2005, Stored Procedure, MS Access, ADO, XML, HTML, and Visual Source safe.
….3
AZADEH DANESHPANAH Page 3
Accounting Assistant Jun. 2000 – Feb. 2004
Hatfield Consultants Ltd., West Vancouver, B.C.
Prepared client invoices; processed Accounts Receivable, and Accounts
Payable using ACCPAC.
Performed general office duties.
EDUCATION
B.Sc. in Applied Mathematics in Computer Science 1999
Esfahan University
PROFESSIONAL TRAINING
Software System Development Certificate 2003
British Columbia Institute of Technology, Vancouver, BC
Computer Programming Concepts/Methods Course 2001
British Columbia Institute of Technology, Burnaby, BC
Business Communication Course 2000
British Columbia Institute of Technology, Burnaby, BC
Visual Basic Certificate 1999
Advanced C++ Certificate 1997
Computer Service Organization of Esfahan
REFERENCES AVAILABLE UPON REQUEST