Database Developer Resume San Diego, CA - Hire IT People

SUMMARY:

Confidential is highly motivated and customer - focused developer with a concentration in business intelligence.
She is a reliable, organized hard worker who enjoys challenges and producing creative, out of the box solutions.
Angel conducts strategic data analysis to prevent potential issues, react proactively with planning measures, and provide subject matter expertise on operating business rules.
Her desire to increase visibility and transparency is demonstrated through documentation and use of best practices.
With strong leadership skills, a team oriented attitude and flexibility she excels in getting the job done right.

SKILLS:

SQL 2005/2008/2012/2014 data extraction, stored procedures, table & logic creation, job scheduling
SQL 2005/2008/2012/2014 Management Studio & Reporting Services
Worked with both the sever and analytical sides of Tableau
Created Alteryx workflows and applications
Experience with a variety of change tracking and trouble ticket systems
Microsoft Office suite including Word, Excel, Access and PowerPoint
Adobe suite including Acrobat, Captivate and File Maker
Experience managing Visual SourceSafe project and Team Foundation Server

PROFESSIONAL EXPERIENCE:

Database Developer

Confidential, San Diego, CA

Responsibilities:

Engaged Alteryx to create Analytical Applications
Published Data Sources and created Worksheets in Tableau
Automated over 100hrs of manual data ingestion of multiple file types using SSIS
Utilized extensive SQL and analytical knowledge to derive business intelligent data
Used SSRS to create reports for use by Executives and Managers
Determined raw source data necessary for the creation of analysis
Harmoniously collaborated with cross-functional teams comprising of managers, business analysts, operations and developers
Created in depth analysis of data that ensured internal/external clients made smarter decisions as well as provided cost benefit savings

Data Analyst

California, San Diego, CA

Responsibilities:

Creates and maintained T-SQL scripts, stored procedures, optimized SQL statements, complex queries, joins, triggers, pivots, common table expressions, and subqueries
Created SSIS packages to automate time-consuming user-based processes
Ensured data integrity though testing and provided problem solving solutions
Developed more than 60 SSRS and Crystal reports depicting broad business outlooks and decision making information
Effectively extracted appropriate data in a timely manner while meeting multiple deadlines
Provided project documentation for large SSIS packages and long-term reporting

Programmer/Analyst

Confidential, San Diego, CA

Responsibilities:

Upgraded Production and Development environments from SQL Server 2000 to 2005
Utilized SQL commands to clean and move data as well as to gather data for users
Produced financial reports for user review and data submission
Met with users to document and implement data structure changes
Made live updates and planned changes to Data Warehouse

Database Analyst

Confidential, San Diego, CA

Responsibilities:

Wrote code for database access, modifications, and constructions
Designed, developed, and maintained SQL Server 2005/2008 databases, including optimization, troubleshooting, database integrity, data recovery and rollouts
Reporting and Software Development
Developed SSRS reports that provided analytical information and business intelligence
Created CRM business specific customizations for company and customers use.
Analyzed business processes to create valuable and efficient software solutions.
Testing and Documentation
Produced multiple user manuals in written and video format for new and existing company products as well wrote multiple products’ internal help.
Met with business executives and users to document requirements and business rules
Created and utilized test cases to ensure application features met desired requirements