SUMMARY:

• Demonstrated ability to communicate and interact effectively with individuals on all levels of an organization.
• An experienced team player, bringing over 14 years of BI experience, best practices and energy into group efforts.
• Demonstrated ability to deal directly with department leaders in multiple Fortune 500 companies and I have achieved and maintained consistent client satisfaction.
• Have the soft skills as well as the technical expertise needed to make the project a success.
• Strong SQL Server, SQL and Analysis skills, proficient in all facets of business intelligence from the gathering of report requirements from users, ETL - SSIS, Data Warehouse creation, SSAS cube creation, SharePoint BI portal creation, Power view, and Excel and SSRS report creation.

TECHNICAL SKILLS:

Database Technologies: Confidential SQL Server 7.0/2000, Confidential SQL Server 2005, IBM DB2, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, Oracle, Hadoop, Spark, Studying for Azure .

Programming: Python, SQL (Stored Procedures and T- SQL), MDX, C#, DAX, PL-SQL

Server Technologies: Windows NT/2000 Server, Window 2003 Server, Internet Information Server 5.0, Windows 2008 R2, Windows Server 2012

Design Tools: SQL Server Diagramming Tool, Visio 2007, Erwin, ER Studio, SQL Server Administration Reporting Crystal Reports 8.5/.0, Business Objects XI (11), Crystal Enterprise 8.5, Confidential Reporting Services Beta (Rosetta), Confidential Reporting Services, MS SQL Clustering Business Intelligence Data Warehousing, MS-SQL 2000/2005/2008/2012 Analysis Services (OLAP), DTS, SSIS, SSAS, SSRS, MDX, Dimensional Data Modeling, ProClarity, Performance Point Server Excel 2007, Logical and Physical Data modeling

PROFESSIONAL EXPERIENCE:

Confidential - San Francisco

Business Intelligence Architect/Lead Developer

Responsibilities:

• It’s been my personal and professional pleasure to work with Kevin Lloyd this last year. I’ve been fortunate to work closely with many Software Engineers over the years and few match Kevin’s rigorous approach, thoroughness, intellectual discipline and accountability in managing his countless responsibilities at Confidential . His approach to his work is consistently marked by personal integrity, curiosity, openness and intelligence and his performance is consistently stellar.
• In particular, his ability to translate business goals into tangible deliverables, uniquely reinforced by his sound technical and analytic knowledge, innate reliability and excellent organization skills always means that the business is "covered”.
• Under pressure he remains eminently approachable and straightforward in describing the work at hand, and displays an admirable willingness and patience to follow-up to ensure that his instructions and the 'big picture' goals of the work are apparent to his Team, his peers and business proponents.
• A natural leader, Kevin regularly and selflessly acknowledges his Team's individual performance and contributions, combining natural empathy with practical, analytic thinking and coordination, concentrating on positive aspects while simultaneously suggesting improvements. In his tenure at First Republic, the entire company continues to benefit from his insights, unwavering generous and warm nature and outstanding professional guidance.

Confidential - San Francisco

Business Intelligence Architect/Lead Developer

Responsibilities:

• Created the Data Model in ERwin, Data mapping and documentation, ETL (SSIS) and OLAP (SSAS) cube in SQL 2012. Utilized Tableau, SSRS and Excel for data visualization.
• Lead a team of BI developers as well as developed to simultaneous create two data marts (Deposits and Loan data) in one year.
• Supported the team technically and personally and delivered a superior product.
• Performance tuned ETL, TSQL, processes, Database and OLAP cubes.
• Created Data Quality ETL, database and dashboards.
• Deployed solution into production.
• Trained Users on the new Mart and SSAS cube.

Confidential, San Francisco, CA

Business Intelligence Architect/Developer

Responsibilities:

• Created Dimensional Data Model for EDW using Power Designer. Architected and created the ETL using SSIS.
• Created the OLAP cube, kpi's and calculated members using SSAS. The entire implementation was done in SQL Server 2012 and source control was with TFS (Team Foundation Server). The reporting is utilizing SSRS, Power BI and PowerPivot integrated into SharePoint 2013.
• The project consisted of pulling data from several subsidiaries throughout Europe, Latin America, and MESA into a conformed Data warehouse to provide reporting and data analysis to corporate and regional subsidiaries.

Confidential

Position - Senior Business Intelligence Developer

Responsibilities:

• Created architecture and packages using SSIS, wrote stored procedures, and participated in the design and development of Enterprise Data warehouse initiatives.

Confidential

Position - BI Architect/Developer

Responsibilities:

• Performed requirements gathering and analysis to create a logical and physical Operational Data Store (ODS) and Data mart data model in ERwin.
• Coded the ETL using SSIS and reengineered the ETL for the ODS. Used Denali (SQL Server 2012) to populate the ODS and Data Mart. Created Analysis tabular cube using SSAS.
• Created reports using Confidential Power view and Power pivot.

Confidential

Senior Business Intelligence Developer

Responsibilities:

• After gathering requirements from end users, I created a data warehouse utilizing the Confidential SQL 2008 database
• ETL utilizing SSIS to cleanse and populate the data warehouse, created a SSAS cube with KPIs and created reports utilizing Excel 2007 and SSRS to give users access to the data.

Confidential

Senior Business Intelligence Developer

Responsibilities:

• I created ETL packages to populate an EDW (Enterprise Data Warehouse) using SSIS, with the EDW being housed
• SQL SERVER 2005 and the source systems consisting of IBM databases, flat files, Excel spreadsheets and mainframe files.

Confidential

OLAP Developer

Responsibilities:

• I created a metadata driven application to automate the creation of partitions, create backups and process dimensions and measure groups for OLAP databases and cubes. I also created OLAP databases, cubes and created calculated measures using MDX.

Confidential

Contract Business Intelligence Consultant/Developer

Responsibilities:

• Worked with the Confidential Business Intelligence Center of Excellence (BI COE) group on an executive scorecard project. The project was a very high profiled project and utilized the Agile method of project management.
• I have worked on the ETL utilizing SSIS packages, created the OLAP cubes (Online and Offline) utilizing SSAS and MDX to create calculated members and KPI’s, created reports in Excel 2007 and ProClarity reports and deployed the solution to production.
• NGIM Distribution Project - Building OLAP cubes, used MDX to create calculated members and KPI’s and ETL for an EDW project utilizing SQL Server 2005 and Katmai (SQL Server 2008).

Confidential, Atlanta, Georgia

Contract Business Intelligence Consultant/Developer

Responsibilities:

• I created the project plan, tracked and provided status reporting to the executive sponsor. I interviewed subject matter experts and system participants and created functional and technical specifications for the proposed system
• .Based upon the functional gatherings, I determined the dimensions and facts that the system would require and designed the data warehouse architecture to reflect the required grain in ERwin.
• I then created the ETL using SSIS to extract the data from several source systems and flat files, perform transformations and populate the data warehouse.
• The OLAP cubes were created with SSAS and I created calculated members utilizing MDX to calculate the metrics that were revealed in the functional analysis of the subject matter experts and the system participants.
• The reporting was created with SSRS and utilized the cube and MDX to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Confidential

Business Intelligence Consultant/Developer

Responsibilities:

• Project was a large terabyte size EDW implementation utilizing DB2 as the database, Data stage as the ETL tool, Business Objects as the reporting tool and Hyperion as the OLAP engine.
• I functioned as Project Lead managing 4 resources for the OLAP, Reporting and Business Object Universe development, which utilized Business Objects, Hyperion and IBM DB2.
• I assisted in the development of the data model and Business Objects development.
• I participated in JAD sessions and presented development progress to project sponsors, received feedback and incorporated the feedback into the development.

Confidential

Business Intelligence Consultant/Developer

Responsibilities:

• Stop and Shop EPM Project (Boston, MA) - Worked with a team of 3 to perform requirements gathering for the creation of a SQL Server 2000 BI system consisting of a data warehouse, ETL using DTS and OLAP cubes using SQL Analysis services.
• I gathered functional requirements from the subject matter experts and IT staff. We determined the source systems and required grain of the system. We built the data warehouse and I created DTS packages for the
• ETL needed to transform and populate the data warehouse. We then created the OLAP cubes, with partitions and calculated members using MDX.Project Lead - Stop and Shop
• Returned to Stop and Shop for a second project. The project consisted of creating a SQL Server BI system that leveraged the Reporting services capabilities to deliver stronger interactive reporting and OLAP cubes to end users.
• Led team to create OLAP cubes, Build ETL processes using MS DTS, expand Data Warehouse and the team built reports and the front end and security extensions for a scorecard reporting project.