SQL Database Administrator
Resume:
Jonathan Avellaneda
********.**********@*****.***
http://www.linkedin.com/in/jonathanavellaneda
Professional Profile:
Database Administrator and Reporting Analyst with a history of surpassing customer and employer expectations. Leverage technical SQL Server, Access, and Excel strengths to identify opportunities, create and maintain databases and reports. Dedicated and tenacious IT professional, with a reputation for consummate professionalism and exemplary ethics. Remain current on the latest trends in the industry; with comprehensive knowledge of Database best practices. Passionate leader and team player, skilled at bringing diverse individuals together with a focus on service delivery and accountability for goal achievement. Strong interpersonal skills that allows efficient and effective interactions with stakeholders, team mates, and managers.
Currently looking to further my development and experience in the IT sector through a challenging database administrator role. Proven ability to manage multiple projects with competing and overlapping deadlines maintaining quality, accuracy and completing all efficiently. Talented in SQL queries, reporting through various platforms, and problem solving.
Core Competencies:
* MTA Certified * MS SQL Server 2008 R2*MS SQL Server 2012- 2014* MS Access * MS Word * MS Outlook * MS Excel * MS Power Point * MS Visual Studio * MS Visio* Crystal Reports * Aqua Data Studio * Tableau * Salesforce *Aspect Workforce Management* HTML * CSS * Javascript *Effective Communication* Relationship Builder * Team Player *Adaptable to Customer Needs * Excellent Listening Skills * Dependable * Punctual * Multitasking * Hard Working* Flexible * Leadership & Management * Writing &Reading Skills * Conflict Resolution * Performance Driven * Quick Thinking * Can See the BIG Picture * Creative * SSRS * SSIS* Data Cubes * Data Warehouse* ETL *
Academic Experience
Bellevue College
Information Systems /Database Administration Fall 2014- Presently Attending
Database Theory: In-depth focus of database concepts and terminology, emphasizing model, database design, normalization of database tables, and Structured Query Language (SQL). Special emphasis was placed on designing relational databases, creating data models, and being able to utilize existing data model diagrams.
SQL Fundamentals: Developed the concepts and skills required to run SQL queries to retrieve data. This includes working with Microsoft SQL Server 2012 to build well structured tables and write both simple and more complex SQL queries using but not limited to joins, filters, sorts, and sub queries.
Systems Analysis and Design: In-depth focus on the system-development cycle. Topics included, problem identification, problem solving, and information-gathering techniques. Current structured
tools were used to describe business rules and objects, data flow, data structures, and process flow and documentation. Creative problem solving and working in a team environment were stressed.
Data Warehouse: Learned the concepts associated with the development of a data warehouse. Applied the "Extract, Clean, Conform, and Deliver" process to organizational data and built the dimension and fact tables required in a data warehouse using SQL Server 2014.
Database Skills: Developed coherent plans for security, disaster recovery, backup and restore, replication and other administrative functions, including the creation and use of SQL scripts to automate administrative tasks. Using industry best practice to establish database policy and documentation, develop a backup plan for production databases, monitor and maintain SQL Server performance, configure related components and manage files and databases, and evaluate an installation plan to install SQL Server and its related services.
Professional Experience
DBA/Reporting Analyst (2015 – Current) Capital One Financial, Seattle, WA
Built and implemented ETL process through SSIS packages to import data from call center phone systems into SQL server for reporting purposes to automate 90% of data import for reporting.
Design, build, test, and deploy new databases and reporting features using SQL, Access, Excel and Crystal Reports.
Designed, Tested, Implemented, and Deployed a migration from current Access databases to SQL Server 2012.
Database maintenance, update, backup, and restore for SQL server and Access Databases.
Completed daily, weekly, monthly, quarterly, and YTD reporting of key call center metrics.
Maintain employee database data up to date with changes.
Designed, maintained, updated and reported on call center payroll incentive plan for key associate metrics.
Claims Generalist Intermediate (2011 – Current) Progressive Insurance, Bothell, WA
Investigate and resolve coverage and liability for complex attorney represented claims.
Handle over 250 injury claims at any one time, with emphasis on negotiations and settlements.
In charge of over a million dollars in reserves at any one time for claims.
Required to read, interpret, and make decisions on verbiage in policy contracts as related to coverage investigations.
Top injury claim closer in my office with average of 20 claims closed per month year to date.
Marketing Specialist (2009-2010) American Family Insurance, Puyallup, WA
Sold, Implemented, and Administered home and auto insurance packages for families.
Marketed products via cold calls, referrals, and internet leads.
Sold anywhere between 20-30 policies per month
Answered multi-line phone system and assisted current and future clients.
Wealth Building and Marketing Specialist (2006-2009) Kingdom Consulting and Management, Tacoma, WA
Sold, implemented, and administered health insurance benefits for employer groups saving up to 40% in most cases.
Marketed products creating flyers and other materials using Microsoft Publisher.
Coordinated, registered, and spoke at monthly goal setting workshops.
Customer Service Agent(2002-2007) Alaska Airlines, Seattle, WA
Started out checking in passengers, boarding and controlling flights, and taking in baggage claims for lost luggage.
Promoted to lead customer service agent where I oversaw as many as 30 employees at one time.
Became a Seattle Station Trainer, coordinated on the job training for new leads, attended agent probationary meetings, and in charge of agent support during irregular operations supporting the whole airport with as many as 100 or more employees at any given time.
Given an opportunity as a research assistant for business analysts in the ITM/Web Check in corporate department.
Researched, coordinated, tested and implemented the first version of a Spanish Kiosk for Alaska Airlines.
Real world experience working on a project following the agile development cycle, including iterations, testing, release planning, implementation, and post release support all the time meeting an established deadline.
Proven ability to work with all levels of management including, but not limited to, supervisors, managers and directors.
Chosen to attend meetings for the planning and implementation of the Airport of the Future at the Sea-Tac airport.
Sales Associate (2001-2002). Famous Footwear, Anchorage, AK
Sold shoes and checked out customers to help meet and exceed LY goals.
Maintained store cleanliness merchandising as well as put backs.
Received freight and stocked floor with shoes and merchandise.
Custodian (1998-2001) MC Corporation, Anchorage, AK
In charge of cleaning entire Air Force building on base with security clearance.
Vacuum, garbage, and dusting duties.
Contact this candidate