Software Engineer Sql Server

Brian Shojaei (***) *** - ****

***-*** ** *** **, Calgary, AB T2R 0M8 *****.*******@*****.***

EXPERTISE

An accomplished Software Engineer with over 9 years of experience capable of performing in a variety of roles and utilizing excellent interpersonal and communication skills to work effectively as a software developer, enterprise systems architecture, database designer, technical lead and mentor.

Strong IT background specializes in object oriented software design and development (OOD), web technologies, database design, data architect, programmer analyst, solution implementer, performance tuning and project planning. Experience is complemented by past experience developing multiple enterprise applications from scratch using variety of programming languages and technologies.

Always achieved a high level of knowledge of the business requirements and subject matter to maximize quality of product and meeting business requirements. Skilled in planning, scheduling and executing all phases of the projects, time management, and continually analyzing technology trends and development process to follow through for ensure that the job gets done well and on time

TECHNICAL PROFILE

Programming Languages: C++, C#.NET, ASP.NET, ASP.NET MVC, VB.NET, Java, PYTHON, HTML, HTML5, JavaScript, jQuery, JSON, PHP, ASP, XML

Databases: Oracle, MS SQL server, MY SQL, ACCESS,

Applications: MS Visual Studio, Rally, ALM, TFS, VSS, SVN, TOAD, Oracle SQL Developer, MS Project, MS Office, VISIO, VMware, Rational Rose

Web application platforms: Click Commerce, SharePoint

Operating Systems: Windows 98/XP/VISTA/7/8, MS Windows Server 2000/ 2003/2008/2012, MS Dos, Linux

Networking: Active Directory, TCP/IP, DHCP, DNS, WINS, IIS, (CCNA, CCNP-BSCI, MCSE 2000/2003/2008/2012 trained)

Soft Skills: Teamwork, Leadership, Problem-solving, Fast Learner, Self-direction

PROFESSIONAL EXPERIENCE

Technical Lead and Data Architect

ConocoPhillips Canada Sept 2014 – Now

Contributed in analyzing, architecting, and developing database for enterprise Digital Oil Field (DOF) project, which holds all operating metrics that actually have a meaningful impact on production and reserves.

Analyzed, architected, and developed database for enterprise Daily Operations Report (DOR) project. The DOR tool provides a dashboard view of key operations metrics for the Surmont Oil Sands asset along with the capability to generate a daily snapshot for email distribution. The tool provides both access to data from specific source systems as well as calculated and historical information to ensure consistent repeatable management reporting. Robust and complex engines developed in database side to ensure high quality data will provide to the operation team all the times.

Contributed in development of new features for Short Term Forecast (STF) project. STF tool designed to generate a short term bitumen production commercial forecast for the marketing team to buy the right amount of diluent required to transport the bitumen through the pipelines, and estimate the levels of production that they will be able to sell on the market.

Worked with the business analyst in gathering requirements, analysis, design, and then documenting functional and technical requirements, including software architecture documentation, HLDs and LLDs

Improved QA test cases by reviewing them and making suggestion in enhancing the efficiency of application

Environment: ORACLE, SAP MII, HTML5, CSS, JavaScript, jQuery, and JSON

Principal

Tekland Solutions Inc. Dec 2011 – Now

Developed a home automation system based on Raspberry Pi (Software and Hardware)

Analyzed, architected, and developed a sprint planner application to help optimize product backlog items selection for sprints

Analyzed, architected, and developed an e-commerce software that contains both a catalog frontend and an administration tool

Environment: C++, C#, ASP.NET MVC, HTML5, CSS, Twitter Bootstrap, JavaScript, jQuery, JSON, and MS SQL Server 2008

Scrum Master and Project Team Leader

ConocoPhillips Canada April 2014 – August 2014

Established agile methodology for DOF, Digital Oil Field, project at ConocoPhillips and prepared all related documents and standards for the methodology. Consulted other projects at ConocoPhillips to follow Scrum/Agile methodology. Mentored project team members with Agile/Scrum methodology.

Established and owned Defect Triage Process for DOF project at ConocoPhillips. A successful process to review defects in a daily meeting for 15 minutes with QA team, Product owner and technical lead

Negotiated approval of the project plan with management and ensured that the plan is re-evaluated, adjusted and re-negotiated at regular intervals, or when certain objectives may not be met.

Participated in data validation to improve the accuracy of the data, reviewed and simplified scientific calculations. Developed verification and validation report to confirm daily bitumen production for Surmont oil sands facility.

Involved in reviewing, writing and executing of the test cases

Environment: Rally, ALM, ORACLE, SAP MII, HTML5, CSS, JavaScript, jQuery, and JSON

Sr. Software Engineer & Tech Lead

University of Calgary Nov 2012 – Dec 2013

Leaded Daily Scrum, Sprint Review, Sprint Retrospective, and Technical meetings. Contributed to CAB and Leadership meetings effectively

Participated in organizational development to optimize staff productivity of IRISS technical team which resulted in incremental efficiency and cost savings within the team

Worked with the business analyst in gathering requirements, analysis, design, and then documenting functional and technical requirements, including software architecture documentation, HLDs and LLDs

Contributed to the development of complex features for IRISS project (50% of working time)

Changed existing software product lifecycle process and established a new process incorporating agile methodology and mentored team members to work in an Agile/Scrum environment.

Environment: C#, ASP.NET, ASP.NET MVC, JavaScript, jQuery, JSON, Drupal, Click Commerce Portal, SharePoint, and MS SQL Server 2008

Sr. Software Engineer

University of Calgary Jan 2012 – Oct 2012

Analyzed, architected, and developed security access controls to manage authorized and unauthorized access to application

Participated in analyses and preparing efficient design documents for IRISS project. Prepared low level design document templates, and mentored technical team to involve in low level design

Contributed to the development of complex features for IRISS project including implementing web forms, background automated tasks, business cycle transitions and email notifications

Improved QA test cases by reviewing them and making suggestion in enhancing the efficiency of application

Mentored development team members and reviewed their codes to improve quality of development

Environment: C#, ASP.NET, ASP.NET MVC, JavaScript, jQuery, JSON, Drupal, Click Commerce Portal, SharePoint, and MS SQL Server 2008

Web & Database Developer

FoundLocally Media Inc. Nov 2011 – Jan 2012

Programmed, enhanced, and improved efficiency of the web-database integration

Programmed several key features a sleek new interface, which were rolled out over work term

Programmed significant enhancements in the website(s) integration of Google Maps

Developed hands-on awareness of mobile website development

Environment: ASP, HTML5, CSS, JavaScript, jQuery, JSON, and MS SQL Server 2008

Sr. Software Engineer / Tech Lead

TPWW 2009 – 2010

Supervised, trained and directed team of software engineers through Scrum project life cycle

Directed analysis, design, creation, testing, and implementation of an open system software development kit (SDK) with a client-server architecture, providing standard SCADA functions for water distribution systems

Designed network infrastructure of individual telemetry stations, supervised the installation of network devices and configured local machines

Environment: C#, C++, MS SQL Server 2008, Oracle 9g, Telerik Reporting V3

Sr. SCADA Software Engineer

TPWW 2007 – 2009

Participated in development of an open system software development kit (SDK) with a client-server architecture, providing standard SCADA functions for water distribution systems

Analyzed, architected, and developed an Active Directory management application to manage groups and users and their access levels to SCADA software

Designed network infrastructure of the telemetry center, supervised the installation of network devices and configured the servers

Environment: C#, C++, MS SQL Server 2008, Oracle 9g, ActiveReports

SCADA Software Engineer

TPWW 2004 – 2007

Analyzed, architected, and developed a visual management application providing a quick and clear overview of present faults via its workspaces in SCADA system

Analyzed, architected, and developed an application to calculate water consumption for twenty two municipal districts of City of Tehran

Developed an application to track Preventive Maintenance (PM) of instruments, equipment and facilities of Tehran water distribution system

Environment: C#, ACCESS, MS SQL Server 2008, Oracle 9g, ActiveReports

EDUCATION

Object Oriented Software Development Certificate SAIT Polytechnic 2011

Software Engineering (B.Sc.) University of Shiraz (Iran) 2004

TECHNICAL COURSES

Certified Scrum Master 2013

Cisco CCNP – BSCI 2008

Cisco CCNA 2008

Windows server 2003 Active directory 2008

Windows server 2003 Infrastructure 2008

Windows Server 2003 2007

Windows XP Professional 2007

Network+ 2007

UPS training 2006

Instrumentation devices installation 2006

SCADA System Engineer Training 2006

Contact this candidate