| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Data Engineer Software Beaverton, OR Senior Data Engineer Portland, OR Data Analysis Ml Engineer Portland, OR Software Engineer Data Hillsboro, OR Engineer Process, operations, equipment maintenance, metrology Portland, OR Application Engineer Validation Hillsboro, OR Mechanical Engineer Manufacturing Canby, OR |
|
Click here or scroll down to respond to this candidateCandidate's Name
PROFESSIONAL SUMMARYI am a highly skilled technical professional with over 15 years of experience, with extensive experience in SQL Server data warehousing, database development, and database administration. I have extensive experience in SQL Server Management Studio and has used Visio for data modeling. On my last position I was responsible for analyzing performance bottlenecks using SSMS and updating procedures to reduce memory requirements. I have analyzed legacy data sources and has found effective ways to combine them into coherent set of business models and data marts, including combining CRM, software licensing and help desk ticketing into management reports. I have experience doing SQL design of legacy and new databases using Visio an ERWin, tracing data lineage of reports to their main sources. I have helped automate on-prem SQL Data Warehouse which improved overall reliability of the system. Im looking for my next opportunity where I can use my well-rounded SQL skills to add immediate value to an organization.Professional EXPERIENCEContract Data Engineer, Ryan Specialty Group 11/23 to 3/24Modified SSIS reports to include auto-correcting steps and optimized performance to pick up where last left offCreated early validation on data inputs, automated and flexible that email importers quicklyImproved performance through proper indexing strategiesReduced validation processing stepsBordereaux report design and validationNew SSRS reports to allow inserting data into tablesAutomated and scheduled DEV database environment refresh from Production. Can be expanded to other systemsDocumented process steps to accelerate learning curve for new hiresRecommended database designs to simplify reportingSSRS and PowerBI report optimization such as simplifying administration, security, data sources and parsing the reportsData Engineer and DBA, Digimarc Corporation 3/21 to 9/23Modified legacy SSIS packages to run more efficiently, identify errors and notify business owners of statusUpdated SSIS for more consistent variable usage and cleaner deployments with environment variables.BigQuery analysis of large sets of giant filesProfitability and Cost analysis by customer to determine Cost Per Customer Service, done for the first time at DigimarcAutomated on-prem SQL Server data mart, reducing dozens of daily errors to one every few weeksSystem integration with a variety of feeder applications and multiple export and report systems, including SSRS and PowerBICreated monitoring for database and reporting processes, with enhanced error handling with logging, notification and retriesMade the DataMart and DBA services available to multiple department consumers, with consumption reports and validationModernized MongoDB Atlas environment and used Studio 3T for analysis, usage and clean upEnhanced Postgres customer databases to allow for more flexible reporting in LookerSnowflake conferences in anticipation of companywide usagePatent application potential for automatically recognizing and categorizing JSON structural changes in individual recordsPatent application for archiving data by table/monthPatent application for automating DEV data environment creation from PRODBI Engineer, Columbia Sportswear 3/19 to 2/21Simplified business model by centralizing calculations in Databricks, and aggregates in AASCreated and maintained Tabular performance tuning using DAX Studio.Wrote automated daily process of business model processing in PowerShell with YML configurations, later in TidalMade business model enhancements using Kimball practices and dimensional modelling.Created security settings in Azure and AAS using Active Directory groupsVerified calculations using DAX Studio, PowerBI and Excels PowerPivot, depending on my audienceWorked on PowerBI reports and VertiPaq, created to show system status, such as security, data freshness and record countsCreated Perspective for easier visuals and reporting for a variety of audiencesDocumented Data Flows for the first time in our group to track impact of changes.Attended Mastering DAX Workshop with Marco RussoBI Analyst and Developer, KinderCare 7/18 to 3/19SQL Server 2017 Tabular data warehouse performance analysisoWrote customized script to gauge performance for each measure in a group of reportsoTracked progress and performance at each step of program execution to help recommend configurationoCollaborated heavily with Octopus Release Manager, debugging process and adding stepsoDesigned SSRS data driven subscription that automated report deployments and allowed multiple filtering modelsInfrastructure standardizationoStandardized security at all levels of SSAS and SSRS, with a much more nuanced modeloReconfigured SQL and Windows environments that put an end to frequent crashes of database and modeloTook six disparate environments and standardized them, giving a detailed outline to InfrastructureoAutomated installation and configuration; gave multiple PowerShell and SQL scripts to Octopus Release ManagerSQL Server DBA, Standard Insurance Corporation 5/15 to 7/18DBA for SQL Server 2008 r2 to 2017, including but not limited tooUpdated SSIS packages for more consistent deploymentsoSSRS 2016, including architectural framework of software configuration, security and deployment methodologyoPerformance tuning and troubleshooting poorly performing queries, using PerfMon changes, sp_Blitz, indexing/statistics strategies, partitioning, archiving, execution plansoSSIS 2016, including hardware and software configuration, security and deployment frameworkoMade the DataMart and DBA services available to multiple department consumers, with consumption reports and validationoAutomated install of SQL Server through PowerShell 4.0 scripts, migrating over 60 servers to SQL 2014 from SQL 2000 and 2008.This came in ahead of schedule and under budgetoSystem Integration with a variety of data sources and systems through SSIS and data validation scriptsoOracle 11g reporting environment clean up with new architecture and templates for development, as well as monitoring of future releases for complianceoStudied R and machine learning for better use of data resources in Azure.OperationsoManager of offshore Operations DBAsoOperationalized most routine actions for offshore resources. Created Run Books and Knowledge Transfer sessions for those resources.oIntroduced SSRS and SSIS guides and templatesoManagement approach identified as a standard for other infrastructure off-shore operations teams, with increased staff retention ratesoPaired senior staff with new members for a better onboarding processArchitectural successesoReporting architecture for Crystal Reports to SSRS migration with a simplified approach that was very scalable and self-documentingoNetwork drive crawl for Oracle Split project, where entire network was analyzed for reporting objects that connect to Oracle databasesoData model design approaches for Hadoop and Apache Spark that would allow for rapid querying of Key / Value pair data set using NoSQLs columnar indexing strategyoIdentified ownership of SQL databases, extended that ownership to applications and security groups, first time in company historyoRepeatable server environments. Best practices followed for all environmentsoStandardized servers and security environment. Extending this to automation using Ansible.oSecurity clean up and standardizationSQL Server Developer and DBA, ShiftWise 11/13 to 4/15Data Architect and Developer, including but not limited tooConverted legacy Maintenance packages to SSIS with notification and loggingoSSRS reports and report tables for integration partnersoCreated Excel dashboard ad hoc reporting tool that allowed users to create reports with SQL WHERE and ORDER clausesoPartitioning, archiving and indexing strategies for greatly improved performanceoWorkflow modellingoWrote audit and scheduled reports to stake holdersoWrote stored procedures, triggers, indexed views and workflow for OLTP and reporting data storesoData publication using Always On, Change Data Capture, ReplicationDBA for SQL Server 2008 r2 to 2014, including but not limited tooScripted installs for instances from VCAC (vCloud Automation Center)oPublished in http://SQLServerCentral.comoSystem integration with source systems through SSIS packages and tracking Data Flows between systems.oPowerShell 4.0oDell Spotlight SQL monitoring and trendingSenior SQL Server ETL Developer and DBA, Integra Telecom 10/10 to 11/13SSIS creation, standardization, repair and tied to SQL job release, included error handling and loggingConverted Access 2007 data import processes into SSIS scripts and SQL jobs, VBA scripts to stored proceduresDBA for SQL Server 2005 to 2012, including but not limited toodatabase creation,oreplication,obackups/restore, permissions,olinked servers, job creation/monitoring,oPowerShell and xpCmdShellospace monitoring,oservice pack patchingHeaded operational DBAs with on-call rotation but was able to bring in practices that reduced production stoppages by 75% byoEarly warning systems and threshold notificationsoScripted error handling based on more common errorsoAutomated modification of scheduled SQL jobsoStandardized server creation, patching and database maintenanceoGrowth pattern analysisoAutomated and on-demand security resetOracle PL/SQL developerCreated and maintained clustered servers, LUN additions, snapdrivesDell Spotlight setup and monitoringSenior ETL and Application Developer, Wilshire Credit Corporation 2/06 to 10/07Wrote dynamic Data Transformation Services in SQL to include error checking, notification and execution until successful completionChanged job requirement from 80% maintenance to 15%, through stronger error handling, correcting common data anomalies, notificationMigrated Microsoft Access 2000 and 2003 applications to SQL Server 2000 for the Accounting, Treasury and HR departmentsDashboard. Display audit logs through a .NET web application for customers to evaluate the processes. Could drill down to all detailsOpt In/Out application. Created SQL backend and .NET front end to allow users to set their level of process notificationWorked closely with Business Analysts and Quality Assurance to create a standardized project flow. First department to do so.Market Architect and Lead DBA, Comcast 2/04 to 1/06Created Excel dashboard ad hoc reporting tool that allowed users to create reports with SQL WHERE and ORDER clausesDeveloped tools to allow users to create and save custom reports, gave application owners the ability to maintain users, selection lists, reportsPerformed new database installations, scheduled and maintained backups, handled security through Active Directory groupsCreated standardized status reporting process to show in-process systems and compared to historical durations and successesCreated capital tracking application for finance group in C# and ASP.NET, administered IIS 5 and 6 web environmentsManaged other developers and contractors in application developmentPublished in http://SQLServerCentral.com2004 Nominee for company-wide award for outstanding achievementSKILLSDatabase Applications SQL Server 2022, back to 6.5 with SSIS, SSAS, SSRS, Team Foundation Server,DTS and T-SQL, ADO.NET, AWS Postgres, MongoDB Atlas, BigQuery, Oracle PL/SQLData Warehouse Azure Analysis Services, Azure Data Factory and Databricks, SQL Server Data Tools, Tabular Editor, DAX Studio, PowerBI, PowerShell, GIT, Tidal,Dev Tracking GitHub, Agile, Jira, SCRUMs, retrospectives, story writing, Kanban planning, BitBucket, DockerProgramming Languages T-SQL, PowerShell, Terraform, Puppet, C#, BASIC, PERL, AWK, COOL:Gen, SAPs ABAPInterface tools: Visual Studio Code, DBeaver, Studio 3T, and SQL Server Management StudioScript Languages JavaScript, Excel VBA, BASH, Access VB Script, Word VBAReporting Tools PowerBI, Looker, SSRS, Excel, Access, Crystal Reports, Active Reports, Bordereaux, BRIOEDUCATIONColumbia SportswearMastering DAX, June 2019Standard InsuranceSSRS 2016 report creation and configuration, July 2017. Runbooks and templates createdOracle Database Performance Tuning Workshop, August 2017Integra TelecomMS-6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services, July 2011Implementing SQL Server 2008 Analysis Services, September 2012SQL Server 2008 Reporting Services, March, 2013UNIX Shell Scripting Basics, March, 2013Instructor, Portland Community College, Portland, OregonAdvanced Visual Basic (CIS 234B), spring and summer semester 2000Columbia UniversityCertificate Program: Computer Technology & Applications in C Programming and TelecommunicationsCity University of New YorkBA in Accounting, minor in Economics and ProgrammingLanguagesFluent in German |
