Faig Garayev, Ph.d., PMP Senior Solutions Architect & IT Manager

Database Architecture ~ Process Improvement ~ Team Management

Dedicated Database Manager and Solutions Architect with 15+ years of experience in improving database functionality, diagnosing problems, building successful project teams, and improving business processes. Solid track record of accomplishments in offshore coordination, team building, problem resolution. Collaborative communicator continually focused on building relationships with colleagues, clients, and senior leadership to and enhance profitability and work efficiency. Project Management Professional (PMP), License 1623808. Areas of Expertise include:

Project Management

Problem Resolution

Offshore Coordination

Database Architecture

Relationship Building

Process Automation

Functionality Diagnostic

Staff Training & Leadership

Customer Relationship

Skills:

Database system modifications, data structure planning, day-to-day system integrity, database policies and procedures, back-up support to the Director of Information Technology, routine and special reports, data layouts, enterprise risk management, information systems support, applications development, server and client-side code, T-SQL and PL/SQL scripts, application and feature design and re-factoring, testing process, defect minimization, deployment process, management of development resources, schedule releases, iteration management, quality control, user experience; application design, application development; database design; application environment.

Education

M.Sc. (MIS, Information System Management) Northwestern University, Evanston, IL Expected 2018

Ph.D. (Economics) Institute of Cybernetics, Baku, Azerbaijan 2007

M.Sc., Honors (Cyber Economics) Baku State University, Baku Azerbaijan 2003

B.Sc., Honors (Cyber Economics, Programming, Mathematics) Baku State University, Baku Azerbaijan 2001

Certifications

Project Management Professional (PMP) PMI License D406-6187 2013-2019

ITIL Foundation EXIN 5053073.20276182 2014

OCA: Oracle 9i, Programming with PL/SQL Oracle 2009

MCTS: Microsoft SQL Server 2008, Database Development Microsoft D406-6187 2011

Six Sigma White Belt Aveta Business Institute 2014

Experience & Notable Contributions

AON HEWITT Chicago, IL Jun 2014-Present

Senior Solutions Architect/Manager

Create and implement long term road-map for the database strategy, including platform/technology and tools/vendors selection. Work on and integrate deployment, configuration, DR, security, encryption, testing and support strategies for the database solutions.

Contributions & Process Development:

Manage 2 direct reports and a pool of 10 India and London-based developers. Train them in design, development, and code review best practices.

Oversee career development, salary reviews, and performance management resulting in a promotion for one direct report in 2015 and recommendations for 5 other developers.

Increased team performance by 80% and improved ability to complete more challenging tasks within tighter deadlines.

Lead by example and serve as information resource for the latest knowledge of business and technology, emerging industry trends, and new capabilities to meet business needs.

Prepared decision making matrix for ETL, data model and architectural pattern selection.

Created best practices document for the development team resulting in improvements in code review process.

Reduced re-work by 80% via efficient approach to on-time risks and code disruptions.

Implemented KPI development process resulting in a growing knowledgebase of success and failure measured over time and ability to react quickly and introduce improvements.

Ensured full compliance with QA processes and proper storage of documentation artifacts.

Developed productive relationships across the IT and business organizations and key customers and shareholders.

Reduced market time requirement by 50% by improving communication between business teams and IT teams.

SEARS HOLDING, INC. Chicago, IL Feb 2012-May 2014

Solutions Architect

Develop Agile methodology framework for ongoing projects. Lead reporting and analysis of systems and applications.

Contributions & Process Development:

Built cross-functional and dispersed agile teams. Oversaw an outsourced team of 10-15 in an international location.

Trained teams in Scram methodology Agile team processes, including process improvement.

Led design, development and delivery of a $36M reporting and analytics solution of the IDRP product, including HLD.

Introduced APEX technology and successfully implemented it as a reporting platform for the team.

Led a team that delivered a security module of the IDRP product.

Oversaw a team that identified and delivered 10+ reports using APEX and DataMeer.

Served on architectural board that made program governance decisions.

Praised by leadership for working with a sense of urgency to perform a series of functional and performance tests with Kettle and Talend Open Source ETL tools, overcoming obstacles, and delivering tests results in a timely manner.

SYNOVATE, INC. Chicago, IL Oct 2007-Feb 2012

Senior SQL Developer

Led an offshore team of 6-8 in multiple projects. Designed database structures as well as ETL processes. Analyzed and designed complex Batch Sampling System for a large scale Oracle Database using PL/SQL and T-SQL. Worked on development of generic batch sampling system. Designed a generic sampling system.

Contributions & Process Development:

Improved response time to generate application reports by analyzing functionality of the existing database.

Demonstrated solid expertise in PL/SQL and T-SQL procedures, packages, and functions.

Created T-SQL best practices documentation for offshore team resulting in increased work efficiency.

Added automation and flexibility to the sampling process by developing dynamic PL/SQL stored procedures that generated Oracle views based on the predefined metadata.

Delivered from scratch sampling products for following clients: US cellular, Sears, Kaiser Permanente, US Army, Sodexo, Amex.

Designed and developed ETL tools for junior developers that reduced development time 10 times.

Career Note: Previous positions include: Team Manager, Sr. PL/SQL Delphi Developer at the Department of Revenue, Azerbaijan Republic (2000-2007): increased efficiency of outside tax audit from 66% up to 98% by developing mathematical model using index-based, neural-network and econometrical analysis; to prevent tax evasion at the earliest stations developed a methodology and registration software for taxpayers, resulting in 95% overall system efficiency.

Technical Skills

RDBMS and BigData: Oracle, SQL Server, MS Access, Paradox, Dbase, FoxPro, Hadoop, Teradata, My SQL

Tools and technical TFS, ER modeling, SVN, CVS, TOAD, MS Visual Studio, Eclipse, SQL Optimizer, AWS

expertise: Benchmark Factory, SQL Navigator, Apache, Tomcat, iceScrum, Control-M, DataMeer, SAP Power Designer, APEX, Jasper, Pentaho Reporting, Pentaho Kettle, CCMDB, Talend, PL/SQL, T-SQL, SSIS, SQL Loader, SQL Plus, OLAP, HTML, Regular Expressions, SSRS, SSAS, Java, .NET, C#, JavaScript, XML, XSLT, Delphi, DTS. Shell scripting

Contact this candidate