SQL Developer Resume Presque Isle, ME - Hire IT People

SUMMARY:

21+ years’ experience with SQL Database Programming along with 13 years’ experience with SQL Server SSRS & SSIS.
21 years’ experience with writing, editing and optimizing TSQL code
Programming experience with C# and VB - ASP .NET.
Extensive use of SSIS for complex data import/export routines.
Extensive use of SSRS for reporting purposes.
Some use of SSAS for business reporting.

TECHNICAL SKILLS:

TQL Coding: 21+ years Analyze coding needs and write, neat, complete and efficient code to accomplish goals. Skilled in coding and troubleshooting functions, stored procedures, triggers, DML, DDL, etc.

SQL Admin: 9+ years of SQL Admin experience

SSRS: 13+ years gathering requirements from customers and turning requirements into Reporting dashboards using drilldown, parameters, matrixing, etc.

SSIS: 13+ years collecting data from disparate sources and getting them into the relational database or data warehouse for effective use. Building complex ETL routines using events and scripting. Imported data using data sources such as flat files, Access, Excel, Oracle.

SSAS: 5+ years experience with modelling an OLAP database using Kimball methodology. Built simple multi-dimensional cubes for business requirements.

Programming: Built multiple projects in .NET platform using both C# and VB and JavaScript.

Programming Languages: C# .NET, VB .NET, VB6, VBA

Scripting Languages: JavaScript, HTML5, XML, VBScript, CSS3

Databases: MS SQL Server MS Access

Tools: SSMS, Visual Studio, TFS

Methodologies: Agile, Scrum, UML, Design Patterns

PROFESSIONAL EXPERIENCE:

SQL Developer

Confidential

Worked for a customer (Verso Paper) optimizing and writing new TSQL code, setting up SQL SSRS, SSIS, SSAS etc. for reporting purposes and data import from various sources. Wrote complex TSQL queries against databases using features such as CTE’s and multiple sub queries, cursors, joins, etc. Worked on creating databases to fulfill needs of customer. Worked on Azure cloud databases, administering them such as backups and query optimization and regular administrator duties. Also working on Azure database development such as writing stored procedures, functions, views, etc. Also worked on on-prem SQL servers. Created complex triggers and functions for use in customer databases. Worked on complex indexing strategies for optimal database performance. Worked exclusively in SQL 2016.

SQL Developer

Confidential, Presque Isle, ME

Built an entire complex SSIS package suite for a health care client bringing in patient and health plan data from multiple vendors and placing it in their OLTP relational database for processing for the ACA.
Built a simple database with SSIS feeds into data warehouse for simple OLAP multi-dimensional cubes (SSAS) for reporting purposes.
Did extensive TSQL coding against multiple SQL Databases.
Did some SQL Admin work for clients, including backup/restore, TDE, monitor db performance, always on technology, etc.
Brought older reporting systems (Excel, Access, VBA) into an SSRS environment starting with nothing and growing into an entire ecosystem of reporting and dashboards. Wrote complex queries to get data into reporting from a MS SQL Server database.
Built an intranet reporting suite using ASP .NET (VB & C#) and JavaScript
Extensive use of SQL Query Tuning for optimal database performance
Worked in an agile environment
SQL 2012/2014/2016

SQL Developer

Confidential, Presque Isle, ME

Built an entire reporting platform using SSRS, MS Excel, and MS Access (whilst using VBA) to maintain reporting standards for a very demanding client (Verizon Wireless)
Extensive use of SSIS to bring data into call center databases and export data to destinations for reporting purposes
Used C#, VB and JavaScript to build out an intranet for reporting metrics to call center floor.
Supported database users (application developers) with SQL coding standards and optimization techniques.
Lead a team of 3 database engineers, assigning tasks and following up on project deadlines.
SQL 2005/2008 R2

We provide IT Staff Augmentation Services!

Sql Developer Resume

Presque Isle, ME

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship