We provide IT Staff Augmentation Services!

Software Developer/engineer - Sql Developer Resume

0/5 (Submit Your Rating)

Glendale, CO

SUMMARY:

  • My natural curiosity and tenacity lends me to complex problem solving and design. I enjoy finding the right solution that provides value and delight to the customer.
  • This aptitude and attitude makes me an ideal Intermediate to Senior SQL Developer for a range of industries. I have ten years of experience with Microsoft SQL Server.
  • Currently developing stored procedures, functions, and triggers with T - SQL. Including complex multi-table joins, error handling and generating alert notifications.
  • My IT career began as an IT Help Desk Technician in 1994 and has progressed through Desktop Support Engineer to Development (through solid, and respect of my direct supervisors).

TECHNICAL SKILLS:

Databases & Tools: Microsoft SQL Server 2000, 2005, 2008/R2, 2012, 2014

ETL Development w/T: SQL/Programming Languages: Transact - SQL Visual Studio 2013 VB.NET C#.NET ASP.NET HTML 5 w/CSS 3 Shell Scripting (csh, bash)

Reporting Tools: SSRS Report Builder Soft Skills Clear Communication - Written and Verbal Self-Motivation Collaboration Coaching Problem Solving Decision Making Accountability Technical Adaptability BackOffice/Server Administration Active Directory Microsoft Windows Server 2003/2012 UNIX/Solaris/HP-UX/LINUX

Ticketing Software: JIRA CA Service Desk Team Foundation Server Desktop Administration Microsoft Windows XP/7/8/10 Microsoft Office 2010/2013 Google Cloud/Apps Mac OS

PROFESSIONAL EXPERIENCE:

Confidential, Glendale, CO

Software Developer/Engineer - SQL Developer

Responsibilities:

  • Research, define and test complex queries to retrieve Key Performance Indicator data from several disparate databases
  • Create, tune and maintain stored procedures to transform and compile data into data marts for access by SSRS reports
  • Research, define and test complex queries to produce real time statistics and statuses for several in-process item types (pipeline reports)
  • Create SSRS graphical reports based on complex queries/stored procedures
  • Deploy and manage SSRS reports in PROD/DEV MSSQL SSRS environments
  • Create and maintain index on data for performance tuning
  • Work with Business Users to gather and verify requirements for reporting and software functionality
  • Quality check sql code to verify functionality
  • Use TFS to add, maintain and update code objects (stored procedures, functions, indexes, etc.)
  • Work with BA to develop queries and procedures to generate letters for specific criteria
  • Investigate, troubleshoot and resolve issues with stored procedures, functions, triggers and jobs in an MSSQL environment.
  • Investigate, troubleshoot and resolve issues with specific records being excluded from queries and processes

Confidential, Denver, CO

Enterprise Application Developer

Responsibilities:

  • Develop data marts containing confidential information for internal processing
  • Work with business analysts, users and other developers to verify accurate data and correct interpretation of business rules
  • Work with the Vendor to streamline processes within the data warehouse
  • Investigate and correct data errors with SQL statements, aggregate functions and tables
  • Perform configuration tasks within .NET application
  • Create ELT processes and queries that satisfy business needs
  • Modify MSSQL tables and set constraints for DB health with T-SQL code and proprietary tools
  • Work with the Vendor to insure that data warehouse meets Federal Tax Information Security Standards
  • Develop new functionality and correct defects in a VB.NET application with an MSSQL backend
  • Troubleshoot .NET code with MS Visual Studio 2012 using standard and proprietary development tools and add-ons
  • Work with users, other developers and business analysts to ensure the application meets strict tax code standards, user requirements and business processes
  • Manage migrations to production environment and verify versioning with proprietary tool
  • Monitor and troubleshoot after-hours job stream processing
  • Document procedures and resolutions with proprietary ticketing tool

Confidential, Denver, CO

End User Support

Responsibilities:

  • SQL: Create, administer, report on and maintain an SQL 2008 read-only database
  • SQL: “Go To” technician to resolve database issues with SQL Server, MS Access and other DB applications
  • Lead - Xerox Device Manager pilot implementation
  • Lead - Windows 7 upgrade project
  • Perform Desktop Support at an enterprise level: including support for Microsoft Windows 7, Microsoft Windows XP, Microsoft Office 2003/2007/2010 and Mac OS
  • Build and maintain multiple computer images with Norton Ghost
  • Advise and assist with compliance of HIPAA regulations in regard to IT services
  • Setup and administer users using Active Directory
  • Troubleshoot issues within Active Directory and eDirectory
  • Setup new users for proprietary applications
  • Manage access to shared network folders
  • Track IT assets and inventory
  • Create resolution documents for end user and help desk staff use
  • Troubleshoot network connectivity issues
  • Perform Hardware break/fix determinations and replacements
  • Document issues with CA Service Desk

We'd love your feedback!