We provide IT Staff Augmentation Services!

Sql/telecom Specialist Resume

OBJECTIVE

  • To obtain a challenging position in a growth - oriented organization, which offers diverse job responsibility.

SUMMARY

  • Results-driven expert skilled in phases of computer technologies including network server installations and tuning configurations, PC network backup, and system upgrades, system patches
  • Provides ongoing analysis, maintenance, and technical and functional support for application systems throughout the organization
  • Proactive self-starter known to initiate processes and system improvements to increase system stability and staff productivity
  • Secure networking, hardware software administration and integration.
  • Applications development and design deployment
  • Over 5 years of progressive computer network operations in large global data centers with mixed computing environments including Unix, Windows and interconnected mainframes
  • Solid understanding of relational databases
  • Aptitude for analyzing, testing, debugging code, identifying problems, and creating solutions
  • Flexible, self-motivated creative problem solver.
  • Excellent problem-solving and strong analytical skills.
  • Strong oral and written communication skills, management and leadership skills.
  • Able to deliver informative, well-organized presentations
  • Detail oriented and accurate with strong work ethics.
  • Capable of learning new technologies, company cultures\ processes, and successfully applying them to projects and operations.
  • Aptitude for analyzing, testing, debugging code, identifying problems, and creating solutions
  • Strong organizational and interpersonal skills.

PROFESSIONAL EXPERIENCE

Confidential

SQL/Telecom Specialist

Responsibilities:

  • Designed, coded, tested and debugged custom queries using Microsoft T - SQL and SQL Reporting Services.
  • Worked closely with marketing and call center teams to gather change requests, convert into technical documents and implemented those based on schedule.
  • Developed scripts on the spot to react to unforeseen problems and also to pro-actively automate future task. Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Expert in developing Data Definition Language (DDL) and Data Manipulation Language (DML)
  • Wrote SQL Queries, Joins involving multiple tables, TSQL, Stored Procedures, Views, Functions, database Triggers.
  • Create/Edit/Maintain ETL processes utilizing Microsoft SQL Server Integration Services (SSIS) from a diversity of data sources including other servers, flat files, MS Access and Excel.
  • Utilized Powerpivot to cleanse tables and facilitate excellent analysis for large data sets of millions of rows, combining data from multiple sources to create visually appealing analytical models of data
  • Used SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Worked on administration tasks such as data loading, batch jobs, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs. Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
  • Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server
  • Reporting Services (SSRS).
  • Administered Avaya Interaction Center workflow for Email/ Chat and Call routing.
  • Tested applications and communicated issues and resolutions
  • Designed and developed specific databases for collection, tracking and reporting of data.
  • Created and managing Avaya Infrastructure diagram using MS Visio for detailed cabling and rack elevation along with each call flow. Managing procedures and policies for telephony administration and preventive maintenance.
  • Performed and conducted complex custom analytics as needed by executive management.
  • Managed call flow programming using vectors, VDNs and BSR treatment for calls to send over. Also created call flows for remote support to activate and deactivate variables

Confidential

Systems Analyst

Responsibilities:

  • Install and configure components to support advertising billboards
  • Operate and monitor control room for Confidential news located centrally in Times Square
  • Provided user assistance and training with operation of multimedia systems.
  • Manage audio and video data feeds for the Good Morning America Show in Times Square
  • Provided digital video and audio editing and duplication if needed.
  • Provide remote assistance through VPN tunnel when needed to restore services located in the control room.
  • Schedule ads to appear on billboards at certain times throughout the day at various places throughout Times Square
  • Manage audio, video, servers, PC’s locally and remotely from the control room
  • Provided technical support for meetings, conferences, classes and corporate-wide broadcasts.

Confidential

Technical Support Consultant

Responsibilities:

  • Install and configure peripheral components
  • Answer questions about operation, installation, and configuration of existing hardware and software
  • Update and maintain website and database of users
  • Expert level HTML, CSS, and Javascript (including AJAX/JSON and libraries like jQuery), including semantic markup, as well as a great deal of experience with SEO (search engine optimization) and web-based user interface design. Extremely comfortable working within MVC template frameworks like Rails, and administering Apache web servers.
  • Considerable knowledge of design, administration, and performance tuning of MySQL. Also experienced at designing databases and fine tuning complex queries.
  • Troubleshoot compatibility conflicts, application errors and recommend solutions to correct problems.

Confidential

Help Desk Associate

Responsibilities:

  • Apply basic diagnostic techniques to identify problems, causes and apply solutions
  • Escalated issues as needed and maintained communication between customer and technical teams while extensively utilizing REMEDY to record and track issues
  • Support as necessary on a 24-7 basis to limit system down time during internal or external outages and peak enrollment periods
  • Regularly provided efficient technical support over the phone, maintaining presentable phone demeanor, courtesy, and creativity.
  • Troubleshoot problems involving hardware, software and system compatibility conflicts and malfunctions, application operations, connectivity issues, telecommunications problems in a LAN/WAN environment, network, security, and printing issues.
  • Assisted 500 users with policies and procedures for setting up conference calls, new accounts, web/network presentations and voicemail.

Hire Now