OBJECTIVE:

Interested in a Lead or Senior role in a SQL Server database development environment.

SUMMARY:

• 23 years, software development
• Expert database/data architect
• Big Data, Cloud Services - AWS, Azure, Hadoop, Hiveql
• OLTP, OLAP, data warehouse, BI stack
• Performance tuning, database optimization
• Reporting, data analysis, database migration, troubleshooting data quality issues
• Database Administration (MS SQL Server), capacity planning
• Web design, development, cloud-based CRM solutions
• 3rd party tools, systems integration
• Project management, documentation
• Agile/waterfall, SDLC methodologies
• Dependable, resourceful, work well under pressure
• Outstanding customer service, team collaboration skills
• Industries worked include: software, telecommunications, warehouse, legal, forestry, financial, manufacturing, medical, hospitality, Academic, aviation, footwear & apparel and Government

UI/MIDDLE-TIER SKILLS:

C# (6)

Java (1)

Web Services (1)

Windows API (9)

SOAP (2)

HTML (8)

.Net Core(1)

COM+ (2)

CSS (5)

ASP .NET (6)

VBA (6)

XHTML (2)

IIS (6)

C (1)

XML (3)

VB .NET (4)

JQuery (1)

Javascript (6)

VB6 (9)

OOP (9)

AJAX (1)

OLE Automation (4)

Dreamweaver (1)

Code Repositories Skills

GitHub (3)

TFS (6)

Source Depot (1)

Subversion (3)

VSS (6)

Vault (1)

Product Studio (1)

Database Skills

Azure SQL Database (2)

Hadoop (1)

HiveQL (1)

AWS (1)

Dynamics CRM (1)

Eloqua Mktg Automation (1)

SQL Server (19)

SQL Profiler (10)

Database Schema Design (19)

SSIS (11)

Performance Tuning (10)

Data Modeling (7)

SSAS (8)

SSMS (22)

Dimensional Modeling (5)

T-SQL (19)

Confidential Access (13)

Database Administration (3)

OLAP Cubes (5)

Quantrix Modeler (1)

Partitioning (1)

MDX (3)

Oracle (1)

Visio (10)

OLTP Databases (21)

AS/400 (1)

Erwin (1)

DTS (5)

Sybase IQ & ASE (1)

Aqua Data Studio (1)

Dezign (1)

TOAD (1)

SalesForce Workbench(1)

Tabular Model (1)

Reporting Skills

SSRS (6)

Crystal Reports (7)

Access Reports (10)

PDF Automation (2)

Web Reporting (6)

Confidential FOCUS (1)

Data Access Skills

ADO .NET (8)

ODBC (10)

RDO (4)

DAO (10)

JDBC (1)

Quality Management

HP Quality Center (1)

Fogbugz (2)

AccuRev (1)

Version 1 (1)

Jira (1)

Confluence (1)

Target Process (1)

WORK EXPERIENCE:

Sr. BI/SQL Server/.Net Developer

Confidential, Mclean, VA

Responsibilities:

• Designed and implemented data models against a SQL Azure database to support analytics initiatives
• Created a new ETL framework rolled out enterprise-wide which ensured ETL jobs never failed but exited gracefully. Utilized c# for framework
• Utilized GitHub for source code repository; also GitHub desktop
• Was key contributor on BI projects
• Developed standards, policies and procedures for the form, structure and attributes of the business intelligence tools and systems
• Developed data transformations, reports, dashboards, OLAP cubes, and applications in cooperation with other team members
• Solved complex technical problems from skeletal requirements
• Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary
• Participated in requirements gathering from various product owners and stakeholders
• Researched new technology and developed business cases to support enterprise wide business intelligence solutions
• Mentored colleagues on best practices and provided peer reviews on developed solutions
• Work on multiple projects as a project leader or sometimes as a business subject matter expert

Sr. Net Developer Architect/SQL Server Developer

Confidential, Seattle

Responsibilities:

• Was hired short-term to create a brand new Customer Care database, with PCI Compliance, for tracking and processing chargeback data from financial institutions and customer gift cards
• Worked with management and business users to firm requirements
• Created supporting documentation i.e. data model, database schema, mapping and data dictionary
• Designed database for security, authorization, authentication, encryption and error logging techniques
• Created database objects in an Amazon Web Services (AWS) RDS SQL Server instance
• Utilized GitHub source code repository for continous integration and deployment
• Created AWS Lambda function using Visual Studio, c# .net core APIs, for ingesting data into the RDS SQL Server instance
• Attended daily scrum meetings

Sr. Web/API/SQL Server developer

Confidential, Edmonds, WA

Responsibilities:

• Site provided features for managing concert tours for performing arts groups world-wide i.e. flight reservations, lodging, meals and special requirements
• Tour participants login to review travel status, make special requirements, arrangements and payment
• Utilized ASP .Net, c# and APIs to integrate with PayPal payment system
• Created web reports as well as Confidential Access reports
• Write complex SQL Server stored procedures and T-SQL functions
• Responsible for providing time estimates for work
• Performed DBA responsibilities i.e. backups, restore, maintenance tasks and security

Sr. Data Warehouse Developer

Confidential, Seattle, WA

Responsibilities:

• Supported data warehouse development and maintenance
• Maintained Tabular Model for Marketing Group; worked with DAX
• Maintained Marketing SSAS cube. Performed updates to the Dimensional Model. Worked with MDX language
• Utilized Visual Studio database projects for SQL Server development and deployments
• Worked with GIT Lab and Team Foundation Server source code repositories
• Mentored team members on data warehouse development techniques and coding best practices
• Created ETL packages in SSIS for handling data flows from multiple sources
• Database performance-tuning, workload analysis using Extended Events
• Implemented MS SQL Server database partitioning for the data warehouse. First time ever at Confidential
• Worked on multiple data migration projects and systems integration across both cloud and on premise databases
• Conducted and participated in design and code reviews
• Participated in daily SCRUM meetings
• Performed production deployments of SSIS packages and SQL Server database objects
• Worked on big data platform ETL processes interacting with SalesForce cloud service
• Was key member of team to rollout big data platform for the company. Worked with HiveQL on Hadoop File System (hdfs) on an Amazon Web Services (AWS) Platform
• Maintained SSRS and Cognos subscription reports

Sr. ETL/SSIS Developer

Confidential, Federal Way, WA

Responsibilities:

• Hands-on project needing expert skills for migrating Pentaho ETL jobs to SSIS 2012 ETL Packages for the Confidential Campaign Operations and Lead acquisition programs
• Packages generated several text and Excel files sent via SFTP to vendor sites
• Applied efficient flow patterns and transformations as well as improving ETL performance
• Used TOAD, PL/SQL in working with Oracle Packages, procedures and views
• Provided strict work estimates
• Extended SQL Server database for job tracking and processing
• Created several SQL Server Agent jobs for executing SSIS packages
• Trained and mentored team members on advanced SSIS development techniques and c# programming skills
• Used Crystal Reports and Business Objects for reporting

Sr. SSIS Developer

Confidential, Seattle, WA

Responsibilities:

• Designed and maintained all SSIS packages handling ETL processes from SalesForce and Zuora cloud databases into Azure-hosted enterprise SQL Server data warehouses
• Built encryption algorithms for sensitive personal identifier information utilizing MD5 hashing during processing to Azure blob storage
• Extended database schema
• Designed packages, with flexibility in mind, to be able to run in any environment
• Created test cases and scripts for validating SSIS packages and for regression testing
• Handled data migration across multiple server environments
• Utilized SSDT, SSIS components such as script component using c# code
• Utilized Jira and Confluence as well as Git source code control
• Performance-tuned SQL Server database and SSIS packages
• Participated in daily SCRUM meetings
• Provided weekly status reports

Sr. SQL Server Developer

Confidential, Renton, WA

Responsibilities:

• Main SQL Server database resource supporting company’s SecureBase data archiving and protection databases
• Extended existing stored procedures for billing processes
• Developed and supported SSIS packages
• Monitor and manage SQL Server Agent jobs
• Handled database performance tuning and maintenance
• Introduced good coding techniques in T-SQL logic
• Utilized Jira for issues tracking/work estimation in the Agile environment
• Used Subversion for source code control
• Provided periodic ASP .NET MVC code updates in addition to some API development
• Participated in job interviews
• Participated in daily SCRUM meetings
• Played critical contributory role toward systems architecture/design

Sr. SQL Server Developer

Confidential, Redmond, WA

Responsibilities:

• Developed automated database testing tool in SQL Server
• Extended and maintained complex Confidential Sales and Channel revenue processes
• Extended functionality of custom Excel add-in reporting tool which built queries and MDX syntax dynamically.
• Maintained Sales cube, extended functionality of the dimensional model, added new attributes hierarchies in SSAS
• Performed requirements analysis and researches toward problem resolution
• Troubleshoot data quality issues
• Provided work estimates for monthly deliverables
• Database design: extended the logical and physical database design
• Created documentation, database schema and data models
• Worked with TFS for source code management and release builds
• Performance-tuned database processes (T-SQL queries, Views and Stored Procedures)
• Created and supported SSIS packages
• Performed systems integration testing and release deployments

Sr. Database/ETL/Java Developer

Confidential, Seattle, WA

Responsibilities:

• Designed and developed database objects in Sybase IQ data warehouse and ASE
• Created stored procedures, triggers, functions and database scripts
• Created test-driven Java applications using Spring Batch for handling ETL moving data from Teradata into IQ data warehouse
• Utilized JUnit for test-driven development
• Utilized AccuRev, Java Eclipse and Aqua Data Studio, Spring Batch
• Participated in daily scrum meetings
• Collaborated with dba’s, technical and configuration management staff
• Created business logic using SQL scripts in Sybase IQ and ASE
• Created technical and requirements documentation
• Conducted presentations on new ETL architecture and development techniques

Sr. BI Developer

Confidential, Seattle, WA

Responsibilities:

• Supported and maintained a SQL Server database Lead Acquisition System for Confidential Small and Medium Business Group in an agile environment
• Handled data flows from Confidential Dynamics CRM
• Performed databases analysis resulting in data mapping from source to destination systems
• Extended database logical design and implemented new functionality to the physical design
• Optimized T-SQL queries, stored procedures
• BI Development and OLAP Cubes in SQL Server Analysis Services 2012; MDX queries
• Created processes for nightly incremental loads; troubleshot data quality issues
• Worked with MDX Queries
• Provided reporting using Confidential FOCUS tool and Excel Pivots
• Requirements gathering as well as project estimation
• Created and maintained SSIS packages for processing daily advertiser signups
• Provided weekly status reports to team and management

Sr. Database Architect/BI/SQL Server Engineer

Confidential, Seattle, WA

Responsibilities:

• Responsible for high visibility project to develop the first data warehouse/OLAP cubes for no. 2 online shoe retailer in the USA
• Translated business requirements into technical specifications; documented all aspects of the project
• Created logical and physical models for the data warehouse. Applied dimensional modeling
• Created data dictionary and mapping documents showing data flow from the Operational Data Store to the data warehouse
• Developed ETL packages and complex stored procedures handling daily incremental loads from multiple data sources
• Built Dimensional Model star schema OLAP cubes in SSAS; worked with MDX queries. Created several hierarchies and named sets. Adapted logic to handle semi-additive and additive measures
• Collaborated with SSRS reports developers to come up with a reporting dashboard
• Conducted capacity planning and performance tuning of OLAP cubes
• Managed Sprint cycle production releases
• Was responsible for maintaining company data policies and standards
• Supported OLTP database processing an average of 5000 orders per day and over 60,000 inventory movement transaction
• Provided technical oversight on data warehouse and BI design initiatives
• Mentored team members in data warehouse design
• Provided ad-hoc reporting
• Participated in daily SCRUMS; utilized Fogbugz workflow tool
• Provided main support for company’s nightly ETL jobs

SQL Server/Quantrix Modeler Developer

Confidential, Redmond, WA

Responsibilities:

• Remote part-time contract opportunity supporting BI solutions Confidential stores worldwide
• Maintained T-SQL business logic for daily replenishment of store inventory
• Provided technical support for nightly ETL packages
• Participated in SQL Server database migration from 2008R2 to 2012
• Created Quantrix models used for day-to-day running of stores sales and Inventory
• Maintained existing SQL Server database tables
• Conducted database maintenance
• Created systems technical documentation as well as troubleshooting guides
• Participated in daily SCRUM meetings
• Mentored team on database design/data warehouse architecture

.NET Developer/SQL Server Developer

Confidential, Northgate, WA

Responsibilities:

• Analyzed, modified, designed, developed, and implemented SQL Server database and web solutions for health care provider
• Researched and analyzed production data quality issues
• Created T-SQL Scripts for fixing the production data quality issues
• Was SCRUM master
• Consulted with business users, I.T. staff and management on business solutions
• Created UI/middle tier components for processing member information.
• Adopted test-driven development approach in object oriented development for middle-tier components developed using C#
• Participated in design reviews and code reviews

Data Warehouse Analyst

Confidential

Responsibilities:

• Took on additional project running concurrently, supporting a data warehouse operations
• Performed data analysis and validation of business rules in views feeding dimension and fact tables
• Created views from source to destination databases
• Worked with master and child ETL packages
• Created and maintained mapping documents for data warehouse objects
• Performed unit testing of T-SQL logic
• Liaised with off-shore Indian development team
• Participated in daily scrum meetings
• Participated in code and design reviews
• Used HP Quality Center for tracking trouble tickets

OLAP/SQL Server Developer

Confidential, Bellevue, WA

Responsibilities:

• Data warehouse developer for Confidential Ads Center
• Supported OLAP Cubes (SSAS) and underlying SQL Server OLTP databases
• Maintained dimension and fact tables, Partitions and MDX and aggregations
• Deployed and Processed cubes
• Created and supported ETL packages for loading fact and dimension data
• Created stored procedures and views supporting fact tables
• Created SSRS reports and maintained the reporting dashboard
• Maintained automated deployment scripts
• Participated in daily SCRUM meeting

SQL Server Developer/Data Analyst

Confidential, Bothell, WA

Responsibilities:

• Provided SQL Server backend development/support services to regulated online prescription sampling business.
• The online application enabled B2B clients to quickly add offerings, such as shopping cart and delivery mechanisms into new and existing branded sites
• Created automated T-SQL scripts for production database deployments
• Created SSIS ETL packages for supporting executive information systems
• Created Orders data mart used for sales/ordering metrics reporting
• Developed, implemented and supported a reporting dashboard using SSRS
• Managed security and permissions on the SSRS reports server
• Created T-SQL scripts for database maintenance
• Multi-tasked, providing ad-hoc reporting services to management at moment’s notice
• Conducted requirements analysis, project/time estimation and strategy
• Participated in daily SCRUMs