We provide IT Staff Augmentation Services!

Mysql Data Analyst/ Developer Resume

Langhorne, PA

SUMMARY

  • A self - starter who is exceedingly motivated and ambition. As an IT Professional with more than 10 years’ experience in MVS system and application programming
  • I will always aim to excel as a team and individually in order to improve processes, workload, and outcomes.
  • With 6+ years of software development, data migration experience using a variety of environments specializing in Microsoft Visual Studio (2003, 2005, 2008 and 2010) and SQL Server (2000, 2005, and 2008), and SQL development, user administration, backup, and much more, the skills obtained can be an asset to any company.

TECHNICAL SKILLS

Databases: Microsoft SQL Server, 2000, 2005, 2008, MS Access. Google Cloud with MySQL Workbench 8.0.22

Programming Languages and Development Tools: T-SQL, SQL Server Management Studio, MySQL, SSIS, SSRS, Business Intelligence Development Studio, Visual Basic.

Operating Systems: Windows 10/Windows 2008/Windows 8/Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Langhorne, PA

MySQL Data Analyst/ Developer

Responsibilities:

  • Identified opportunities for improved performance in SQL operations and implementations.
  • Oversaw the operations of the production and staging environments databases.
  • Performed technical troubleshooting to diagnose, isolate and correct data and database issues.
  • Wrote Stored Procedures in MySQL to use them in Adivore@ ROI Reporting Dashboards.
  • API pulled data from Google, Bing, Amazon, Facebook, Wikipedia.

Confidential, Philadelphia, PA

SQL Data Analyst/ Developer

Responsibilities:

  • Authored Stored Procedures (T-SQL) in SQL Server 2012 in SQL Server Management Studio, Oracle, and Toad version 12.6 as data sources for reporting purposes.
  • Created, Edited, Published and distributed reports in SSRS using MS Visual Studio for Circulation, Sales, Finance and Advertising Departments.
  • Created reports using Pivot Tables, Charts, Graphs and Drill Down Functionality in SSRS.
  • Created a process in SQL Server for sales department that predicts future distribution levels by outlet for all customers for the Circulation Department.
  • Developed automated data migration packages for transfer of information between database architectures and both internal and external systems.
  • Create and manage transfer of files to various financial institutions.
  • Administered Third Party Software used by Circulation, Sales and Finance departments.

Confidential, PA

SQL Server Developer

Responsibilities:

  • Created numerous simple to complex queries involving joins, self joins and correlated sub-queries for diverse business requirements.
  • Prepare and send Purchase Orders, Invoices and Reports to Customers according to business requirements using JReport.

Confidential, Philadelphia, PA

SQL Server Developer

Responsibilities:

  • Worked closely with Manager, subject-matter experts, and data modelers to obtain requirements, objectives, and business rules for projects.
  • Responsible for researching gaps in requirements, existing Access, SQL database and finding solutions where a gap exists.
  • Create SSIS packages and implemented failure alerts using email in SSIS.

Confidential, Manhattan, NY

SQL Server Developer/QA

Responsibilities:

  • Created and tested Unicode data using Microsoft SQL Server.
  • Re-designed ETL /SSIS process and programming the new elements integrating them into the existing routine.
  • Convert application to support and display Cyrillic information from the database correctly (GUI).

Confidential, Princeton, NJ

SQL Server Developer/Application DBA

Responsibilities:

  • Responsible for all aspects of Microsoft SQL Server development as well as maintaining existing systems and technical support.
  • Heavily used SSRS, SSIS, custom ETL routines, participated in business process analysis, and QA methodologies along with documentation and user training sessions.
  • Designed reports according specification using Access, Excel, SSRS and Visual Studio.
  • Created complex analytical reports with the graphic elements, reflecting industry trends.

Hire Now