Database Developer Resume
4.00/5 (Submit Your Rating)
San Diego, CA
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