Data Analyst Business Intelligence

DERRICK BELL

Award-winning record of success in development, programming, analysis, and software design

San Rafael, CA 94903 415-***-**** ****.*******.*@*****.*** LinkedIn

SOFTWARE ENGINEERING & DATA ENGINEERING PROFESSIONAL

SQL Developer – Software Engineer – Data Analyst – ETL Developer – Data Engineer

SUMMARY

Highly experienced in software development and engineering, data engineering, and data analysis, with special expertise in business intelligence (BI), data warehousing, and data-driven software. Consistent history of improving efficiency and lowering costs by streamlining workflows, reducing development time, and enabling new capabilities. Extensive background in AzureSQL, SQL Server analysis and integration services (SSIS, SSAS), and Extract, Transform, and Load (ETL) solutions. Proven ability to direct complex projects and lead top-performing teams. Previously led initiatives in the business, government, eCommerce, defense, manufacturing, and entertainment sectors. Able to bridge the gap between technical and non-technical teams. Built and led 2 software development firms servicing Fortune 500 clients.

TECHNICAL SKILLS

Languages: VB.Net, C#, C++, Objective-C, TSQL, ASP.Net, VB6, UNIX Shell Scripts, PowerShell, SQL, XML, BIML, PL/SQL, SOQL, JavaScript, Python

Applications: Project, Visio, PowerBI, GIT, Informatica Cloud, tSQLt, Logi Analytics, SharePoint, WordPress, SiteCore, Joomla, Visual Studio, TeamCity, ER/Win, Dreamweaver, Photoshop, CaseComplete, Balsalmiq, WF, WCF, WPF, CSLA, CAB/SCSF, LINQ, TFS, SSIS, SSAS, Power Pivot, Informix, x-Base, ZAP Reports, Business Intelligence (BI), JSON

Databases: SQL Server, AzureSQL, Snowflake, MySQL, PostGres, Access, SSRS

Key Skills:

ü Business Transformation

ü SDLC Management

ü Process Improvement

ü Strategic Planning

ü Requirements Determination

ü Customer Relations

ü Budget Administration

ü Vendor Relations

ü Business & Needs Analysis

ü Technical Training

ü Implementations

ü Change Control

ü Information Architecture

ü QA & Testing

ü Website Development

ü Risk Management

ü Behavior-Driven Development

ü Continuous Integration

ü Object Oriented Analysis

ü Object Oriented Design

ü Design Patterns

ü Agile Methodologies

ü Unified Modeling Language

PROFESSIONAL EXPERIENCE

CEPHEID, SUNNYVALE, CA 08/2022–06/2024

Application Integration Developer

Developed a web solution to meet regulatory compliance and improve business processes for this leading molecular diagnostics company that manufactures, markets, and supports automated diagnostic systems.

Improved FDA compliance and reduced unplanned deviations risk by developing a centralized global web application for tracking planned deviations requests, including attachments and commitments. ·

Enhanced visibility and decision-making capabilities 40% by integrating advanced reporting and analytics features, enabling real-time monitoring and evaluation of deviations.

Increased user adoption 60% and improved overall efficiency by designing an intuitive user interface and implementing standardized workflows.

Boosted cross-functional collaboration 35% by working closely with quality assurance, project management, and other stakeholders to gather requirements and conduct user testing.

Completed 100% of projects on time and within budget.

Derrick Bell Page 2 of 3 ****.*******.*@*****.***

SYAR INDUSTRIES, Napa, CA 2019 – 08/2022

Application Integration Developer

Developed integration solutions to link applications and created stand-alone front-end applications to meet changing business and regulatory needs for this producer and supplier of concrete and paving materials that also owns and operates a vineyard.

Improved OSHA and MSHA safety compliance 30% by designing, developing, and delivering a mobile-friendly, Azure-based training management system that was integrated with the corporate HR system.

Enhanced compliance with California Air Quality Board requirements by creating a visible emission application.

Increased data accuracy and efficiency 90% by refactoring a legacy mechanic lien tracking system.

Completed 100% of projects on time and within budget.

“Derrick has the ability to dive deep and work tirelessly to solve tough technical problems. He has been able to solve many technical issues where others have given up.” – Mark Williams, IT Director, Syar Industries.

SYUFY ENTERPRISES, San Rafael, CA 2017 – 2018

Senior Software Developer

Developed ETL and integration solutions, supported various business systems, and streamlined workflows for this company that manages a portfolio of businesses in multiple sectors, ranging from entertainment to retail. Applications included business management, point of sale (POS), labor management, inventory control, and film management, along with JD Edwards. Maintained and optimized enterprise financial and operational reports.

Reduced development time 50% by introducing SSIS Framework and BIML to streamline ETL processes.

Increased efficiency by creating a process to distribute customer-facing emails by using custom HTML templates and SQL Server database mail.

BERRY APPLEMAN & LEIDON, San Francisco, CA 2015 – 2017

Application Support Developer

Carried out the provisioning of embedded BI reports, dashboards, and visualization for this global firm specializing in immigration law. Designed, developed, and tested embedded BI reporting solutions.

Improved performance 20% by tuning and optimizing legacy SQL reports.

SHORENSTEIN REALTY SERVICES, San Francisco, CA 2014 – 2015

Developer / Analyst Lead

Primary support resource for the SharePoint team, maintaining multiple instances. Investigated and resolved end user and technical issues. Designed and developed solutions using SharePoint. Streamlined workflows. Created business process models and data mapping specifications.

Improved Yardi Voyager production and test environment support and administration.

Introduced the use of Informatica Cloud for automating back-end ETL processes.

WELLS FARGO COMMERCIAL MORTGAGE SERVICING, Oakland, CA 2014

E-Business System Consultant

Formulated functional ETL requirements for Salesforce integration, working closely with internal systems specialists and SaaS providers. Developed user stories, use cases, screen mock-ups, and workflows. Conducted root cause analysis to resolve integration issues.

Improved data integration sprint speed 30% by automating the creation of user stories, use cases, screen mock-ups, and workflows.

REDWOOD TOXICOLOGY, Santa Rosa, CA 2013 – 2014

Business Systems & Data Analyst

Provided system and data analysis support for manufacturing projects.

Coded the IVR solution for a fully automated channel for a telephone management system.

Managed the evaluation of 3 contract management systems. Presented performance and ROI evaluations reports for senior management, along with recommendation for purchase.

Derrick Bell Page 3 of 3 ****.*******.*@*****.***

MAUKASOFT, San Rafael, CA 2012 – 2013

Owner/Senior Consultant / ETL Developer

Established a consulting firm specializing in data integration, using SSIS. Planned and led all projects and oversaw requirements gathering. Supervised projects. Carried out ETL development, process maintenance, flow documenting, and management, plus T-SQL tuning and SSIS for clients of Analyst Int'l, including Bank of America, Commonwealth of Pennsylvania, and Nordstrom.

Led successful conversion of SQL Server 2008 data integration process to SQL Server 2012.

Supported ETL framework for processing and monitoring import of flat files in SSIS for key client.

Enabled clients to align human resource onboarding initiatives with business goals to facilitate competitiveness and productivity.

INFOR, Novato, CA 2011 – 2012

Technical Lead, ETL

Led development of ETL packages using SSIS. Determined interface requirements. Supervised ETL development and core application teams, including developers, support techs, QA persons, and business analysts. Oversaw customization and improvement of products. Provided technical guidance to project management team during customer implementations, and assisted infrastructure team with hardware and software builds and installations.

Ensured proper resolution of issues as senior on-call engineer for third-tier production support.

Enhanced efficiency and quality by training and mentoring new team members and project managers.

Personally supported ETL processes for Infor-Enwisen client base of 100.

DESIGNMIND, Novato, CA 2011

ETL Developer (Consultant)

Carried out ETL development, process management, and flow documenting for clients. Also performed SSIS, T-SQL tuning, report creation, and more.

(ETL Developer, DesignMind, continued)

Successfully determined solution for importing HB Capital's SalesForce data into a relational database.

Key member of team that developed system for automating the population and refreshing of sustainability master data into SAP Carbon Impact data for Autodesk. Personally developed tSQLt scripts and SSIS applications.

MARIN COUNTY - IST, Novato, CA 2006 – 2010

Senior Programmer Analyst V / Lead Developer

Analyzed, designed, prototyped, and constructed a desktop application (JURIS) to manage traffic cases in Marin County. Carried out use case and candidate solution design, analysis process mentoring, data analysis, and testing in the resulting system. Managed vendor relationships.

Facilitated the development of the first Windows-based Traffic Court Management system (JURIS) in California. Project included database and stored procedures modeling and design, web service integration, and data/software architecture consulting. Designed SQL-based source tracking solutions for JURIS database operations.

Modernized the software development toolkit, which reduced development times and enabled developers to focus on business logic, UI, and applications services without detailed knowledge of the infrastructure.

Reviewed and guided consensus making among teams for the technical architecture of the JURIS project.

Evaluated SharePoint implementation feasibility and developed migration plan to SharePoint 2010.

Created a .NET desktop application to query California 3270 DMV information.

VIRTUALOGIC, INC., San Rafael, CA 2002 – 2006

Founder / Chief Technology Officer

Founded a progressive consulting group. Hosted and developed enterprise learning, incentive, testing, and community management systems on the .Net platform using ASP.NET, C#, and SQL Server for Fortune 500 clients.

Increased learning program participation 150% for Volvo by designing a Learning Management System to deliver corporate training and testing, and match offerings to specific needs of employees and their business goals.

Developed online survey system for Sony Computer Entertainment that enabled independent software publishers to vote for winners at annual Publisher’s Choice Awards. This doubled response rates.

Reduced development costs by creating a tool to manage the community web presence.

CHANNELNET (formerly SOFTAD GROUP), Mill Valley, CA 1997 – 2002

System Architect & Tech Lead & Web Developer

One of the original architects of ChannelNet application framework for eCommerce channels.

Earned Employee of the Year Award. Received Web Award from the Web Marketing Association.

CAREER NOTES: Previously a Programmer/Business Analyst at COMPUTER SCIENCE CORP.

EDUCATION

Associate of Applied Science in Electrical Engineering, HEALD University, San Francisco, CA

CERTIFICATIONS & TRAINING

CompTIA Certified Trainer & Microsoft Certified Trainer

Microsoft Certified Professional Developer, SharePoint 2010

Sitecore Certified Developer

Pragmatic Works SSRS Workshop

SQL Saturday: Performance Tuning with Indexes: Internals and Best Practices

SharePoint Saturday

ADDITIONAL INFORMATION

Affiliations: Bay Area Association of Database Developers, Microsoft BI User Group – San Francisco Chapter, Knights of Columbus – Vacaville Chapter

Military Service: Helicopter Electronics Systems Support Specialist, US Army (Honorable Discharge)

Patents: Modular E-commerce Website Development System (ChannelNet)

Contact this candidate