Software Developer/engineer - Sql Developer Resume
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
