It Database Analyst Resume Profile
Haines, CitY
Professional Profile
Knowledgeable Database Analyst and Developer with more than 5 years of SQL experience. Excel with data analytics and reporting, including performing ETL, data morphing, and data mapping with a variety of data sources and reporting formats. Skilled in T-SQL, SSRS, SSIS, SSAS, Crystal Reports, and Access practical exposure to Oracle databases and PL/SQL.
Technical Skills
- Languages: T-SQL, DAX, MDX, XML, HTML5, RUBY, XML, JavaScript
- Programming: Visual Studio 2012, Visual Studio 2014, Java Eclipse, VBScript, SQL Server 2008R2, SQL Server 2012 , SSIS, SSRS,SSAS, MDX, DAX, XML, HTML 5, JavaScript, T-SQL, Power Pivot , Power View, Power Maps, Excel , Access
- BI Tools: Tableau, Qlikview, Pentaho, GoodData, Birst, Crystal Reports 2011
Professional Experience
confidential
Business Applications Analyst Short Term
- Gathered Requirements in an Agile Environment. Devolved Reports as required by client.
- Coded and Built Custom Reports
- Supported and trainer users how to run the reports Built reports in both Report Builder and Visual Studio. Query Tuning for Large Reports.
- Built 30 Custom reports for the new system migration
- Worked the Across Many Dev teams to gather Requirements and Deploy Reports
confidential
IT Database Developer contract
- Coded Script, Visual Basic Designed Reports and SQL Views and maintained production databases at an enterprise level.
- Provided reports and data across many teams Developer SSRS reports per requirements
- Designed stored procedures, triggers, and functions.
- Designed Macros and Web forms within Access and Excel Designed ETL processes and changed Reports as needed Data Warehouse
- Cloud Web Services
- Agile Development Methodologies and focused on rapid speed-to-market
- Data Mining and SSAS, forecasting with the marketing team, providing a good ROI.
confidential
IT Database Analyst
- Installed, upgraded and configured IT Infrastructure including SQL Server 2012 SSIS, SSRS and Visual Studio 2010
- Maintained production databases at an enterprise level
- Responsible for backup and recovery solutions for all database and restore of major databases. Developed SSRS reports per requirements
- Maintained stored procedures, triggers and functions
- Implemented SQL Server High Availability and Disaster Recovery Deployment Architectures
- Provided month End and Year end Full backups and incremental backup in a Tape Management capacity
confidential
RFID Database Solutions Analyst contract
- Managed Supply Chain, Manufacturing and Inventory Management process analysis Responsible for RFID tag selection and validation testing
- Provided an in depth knowledge of tag encoding and printing, read zone design, design reader environments, GS1 EPC standards and GS1 EPC Reader Protocols
- RFID tag printer configuration, monitoring and management, RFID reader features evaluation and reader selection
- RFID read configuration, monitoring and management, RFID read antenna section Update documents as changes are made to database and servers
- Tag event processing, local event management and remote application integration
- Managed 14 other Helpdesk Tech's as well as trained on new updates to the software.
- Managed production databases and data warehousing systems for the RFID systems we developed. Built custom reports using Crystal Reports and Reporting Services SSRS
- Developed SQL databases and design applications to interface with SQL databases
- Document code, provide progress reports, and perform code review and peer feedback
confidential
Verizon Small Business Desktop Support
- Provided remote support for the end users cleaning viruses out and locking routers down. Troubleshot software for end users
- Ran system scan and optimizing the end user's PC's and/or Mac's Resolved on average 25-30 calls a day with follow up's
- Played the role of a Team Lead and provided a wealth of knowledge to the team
- Assisted other tech's in they ran in to an issue they were unable to resolve Monitor other tech's for quality assurance
confidential
Help Desk Level II contract
- Responsibilities included supporting internal clients, RSA remote support and advanced level support for Loan Officers and Mortgage Brokers
- Provided an in-depth knowledge of financial regulations and support of the applications to close loans.
- Other responsibilities included adding new users to the network, set up/configuration for new hires, added network printers and rebuilt the user profiles.
- Install appropriate upgrades, patched and drivers.
confidential
Junior Administrator contract
- Merged two networks together Vista to partners
- Responsible for re-scoping for all IP addressing for network printers and workstations
- Converted all users to rooming profile and disjoined them from the network in order to join them to the new network.
- Managed network changed as they happened as well as tested the changes Acted as a backup project manager for that location
- Provided 24/7 on call support for all of the call center issues
- Responsible for warranty repair work for the entire network and subbed the work if needed.
- Responsible for setting up all of the audio/video conferencing equipment for meetings and classes. Provided support to all of the branch locations.
- Responsible for outages, desktop support and computer moves.
confidential
Field Network Engineer
- Installed, configured and troubleshot banking systems and their network Supported Wachovia Bank branches and data centers
- Installed network printers, rebuilt profiles, imaged desktops and thin clients. Troubleshot servers, network issues and supported field agents
- Provided phone support in a very fast paced environment
- Provided service in very high security areas and data sensitive areas.
confidential
Tech Support Tier
- Supported Philips audio video equipment and Dell desktop computers
- Supported anything from MP3 players to resetting passwords to troubleshooting hardware Troubleshot Windows XP Home Edition, Windows ME and Windows 9X Systems
- Made decision regarding hardware and software issues and correct the problem
- Maintained and logged calls, updated tickets and provided customer services and support to end users.
- Provided 80 phone support and 20 supporting the team and other call centers. Supported fiend technicians and data centers.
- Supported point of sales system POS