Data Developer

Gyarmathy, Jeff

**** ***** **** ****** **** Pierce, Florida 34982 Phone: 772-***-**** email:******@*****.***

OBJECTIVE

To be a productive member of a top-notch software development team, by using my skills and experience to the team's and organization’s benefit. I also aspire to continue in a role in dealing with project, software, and team management.

EMPLOYMENT

SYSTEM ANALYST (OCTOBER 2018 – MAY 2019)

Olympus Insurance Palm Beach Gardens, FL

Work with various Team leads and Department Heads to determine requirements and develop team and business dashboards using Power BI, including creating calculated columns using DAX.

Help the CTO plan migration of SQL Servers from on premises to a cloud based system in Azure.

Create SSIS packages to import and export data from various databases, regularly using Script objects using C# code.

Use SSRS to develop reports which will be distributed to various individuals throughout the company

Work with the Lead Database Developer to test and design the database warehouse in SSAS.

Help the Lead Database Developer analyze data from internal and external sources to get the data in a mature state to begin the process of performing data analytic routines.

Worked in conjunction with the Lead Database Developer to make adjustments to the SSAS data cube, adding numerous calculations using MDX and adding needed cells to the cube for reporting to other departments.

DATA ENGINEER (OCTOBER 2017 – JUNE 2018)

Levatas Palm Beach Gardens, FL

Helped various clients analyze their needs and examined their databases and verified their data to determine whether their data was in a mature enough state to beginning to perform Data Analytic processes and retrieve accurate predictions based on the data models.

Worked to get clients data into a mature state by identifying any gaps in the data or possible outliers in the data; then either bridged the gap with median data or helped the client find the original data and had it entered into the their database system.

Discussed with Project Managers to determine how long specific database items would take to develop and then worked them into the project stories.

Developed T-SQL stored procedures, functions and SSRS reports based on client specifications.

Executed R and Python code to see if the data model worked the way the Data Scientist designed and programmed it to work and to learn about how it worked.

Worked with clients to help clients with questions they had with their ETL processes whether the ETL environment was SSIS or Talend.

Worked with the VP of Data Science to develop analysis for clients what data warehousing solution would work best from them, SSAS, Redshift or Snowflake.

Talked directly with clients and potential clients about what their needs where concerning their data environment, how Levatas could help them and what the action plan would be to meet their data needs.

Guided business analysts to help them formulate their presentations regarding any data related items.

Worked with a client to analyze their existing Power BI reports to fix a problem they were having and helped them build a few new reports.

Worked with several clients to help them develop and implement a plan to migrate their data from an on-premises solution to a Cloud based solution, either AWS or Azure whichever the client felt the most comfortable working with.

LEAD TECHNICAL DATA ANALYST (MARCH 2017 – OCTOBER 2017)

Weiss Group, LLC. Palm Beach Gardens, FL

Worked with the IT Director to develop a Dashboard to report information about the ticketing system which uses a MySQL database as a backend system. The Dashboard is designed to display the status of the open tickets, which departments have made requests, the numbers of tickets in each priority category and other stats determined by the IT Director.

Analyze and solve technical problems in dealing with report accuracy and database timeouts. Enhance underlying stored procedures and queries to prevent reports from timing out when run manually so the business can stop relying on subscription based reporting as much.

Worked with the IT Director, the CEO and heads of other various departments to analyze and reverse engineer their existing solution, which is currently very old and not robust at all.

Performed analysis of what is needed by each department for their needs that can be met by a new system and the database needs of the new system. Developed any ETL packages and processes which would be needed to migrate the existing systems data with the chosen replacement system; using SSIS and some C# code.

Develop a plan to migrate our existing data systems into the new systems being considered; from a hardware, software, data and process points of view.

Implement a set of standards for database development and source control; currently there are absolutely no standards, no documentation and very little source control.

Worked on creating a SSAS Data Warehouse for the Enterprise Reporting group to use; using Dimension and Fact tables to organized the data properly and provide efficient response time.

Helped the Head of the Enterprise Reporting Group analyze the Redshift database that he developed to test the correct values were being returned and to make sure all the necessary data was in the Redshift database.

Setup the ETL processes for transferring the data from the day to day database to the Data Warehouse using SSIS.

Worked with the Money and Markets team to help create Tableau dashboards connecting to their Redshift database.

HEAD OF DATABASE DEVELOPMENT (OCTOBER 2016 – MARCH 2017)

Reverse Mortgage Solutions, Inc. Palm Beach Gardens, FL

Enhanced the existing standards for all developers creating T-SQL code and releasing code into RMS various environments, to include naming convention standards, documentation code, managing version control, and coding to avoid slow performing code.

Created standards for creating SSIS packages to maintain efficiency, maintainability and security

Found, interviewed and give final approval for hire of a new Database Administrator position

Work with the Database Administrator to develop a plan to implement a greater detailed monitoring and reporting systems to provide more in depth reporting of when system jobs fail, since the DBMail system is not available because of security concerns.

Worked with the Senior SQL Developers on each application to develop and maintain a coherent architecture for each application and how the applications work together and transfer information between each other using SSIS packages.

Worked with the program mangers for each application to co-ordinate and handle each applications release to QC (Regression) and Production.

Check during the process that the database scripts, SSRS Reports and SSIS packages are ready and available for the release manager to provide as smooth a release as possible.

Mentor junior level SQL developers to help them increase their skills and confidence when dealing with SQL code so that when they are discussing the database aspect of an application they will be able to speak with authority.

Worked with each Project Manager to help them refine their specifications in regards to the database and help them architect a solution to meet their required change requests. I coordinated with the database developers on each team to help them implement the architected solution.

Documented each version of the database from release to release, creating ERD and Data Modeling diagrams using Embarcadero ER/Studio and Erwin.

Plan and implement to upgrade from SQL Server 2012 to SQL Server 2014 company-wide; replacing log shipping transfer of data to using SSIS packages for various ETL processes to transfer the same data between servers.

Manage the work flow of the in house DBA who resides in the Houston office.

Worked with the top management to get them to agree to implement the enhanced and newly created database standards throughout the company.

Helped the Data Warehouse Group, using SSAS with their reporting needs and database connections; they used Power BI as their primary reporting tool.

DATABASE DEVELOPER/DBA/ARCHITECT (FEBRUARY 2012 – OCTOBER 2016)

Reverse Mortgage Solutions, Inc. Palm Beach Gardens, FL

Create and modify T-SQL code for stored procedures, functions and triggers that meet the Internet-based application requirements.

Worked with application developers to analyze, design and develop stored procedures using T-SQL and any underlying database objects and structures that might be need to support the agreed upon design.

Analyzed any database T-SQL code that the application developers write to make sure that the code integrates into the existing code, overall design, and maintains the needed performance standards.

Work closely with the project manager to architect out any new database design needs based on new or changing requirements from the management team that uses the Internet-based program.

Develop SSIS packages that transfer text-based orders to outside vendors, receive the completed work orders from the outside vendors and then integrate the completed work order into the system.

Create SSIS packages that take information from the database and create various files including both comma delimited and space formatted text files for use to import into various programs in addition to creating a text file for use as an ACH import by RMS’s bank.

Build SSIS packages that combines data from parts of databases throughout the organization then perform data validation on the collected data as well as any necessary data aggregation and finally transfer the data into the various data marts into RMS’s data warehouses.

Monitor server based resources for each environment, Development, Quality Assurance and Production.

Added to the Process Improvement Team to analyze how the company designs, develops, create updated Production release procedures, and measures adherence to specifications. This team looks into existing procedures and works to improve those procedures and if no procedures exists to work with management and development teams to create a new set of procedures.

Called a Web Service to help the application to fully populate information about a specific property.

Create nightly jobs that analyze data and create new tasks for users in the system to finish based on the data analysis.

Develop SSRS reports based on the criteria given by the management of application users.

Been given the assignment to lead the initial interviews for any new SQL Developer/DBA positions that become available. This allows me to decide based on an interviewee’s performance in the initial interview on whether or not a follow-up is warranted.

DATABASE DEVELOPER (FEBRUARY 2007 – FEBRUARY 2012)

Spectorsoft Vero Beach, Florida

Helped to develop and maintain the turnkey, back-end database of the Spector360 corporate monitoring software.

Spector360 database is a dynamic, high performance a database developed using SQL Server; that is designed to be a stand-alone system, no need for an on-site DBA to manage system.

Created stored procedures using T-SQL that created and ran jobs that handled backing up the multiple databases to removing data that is older than a prescribed number of days

Developed and troubleshot T-SQL stored procedures that returned datasets Spector360 used in reporting; aggregate data, transactional data and histograms.

Developed stored procedures to migrate Spector360 databases from SQL Server 2000 to SQL Server 2005.

Dealt with customer problems related to the database. Developed scripts to fix problems with their data or possibly to the stored procedures and functions themselves.

Created series of SSIS routines that migrate the internal Spectorsoft database from SQL Server 2000 to SQL Server 2005.

Worked closely with tech support to resolve customer issues; from providing scripts to remoting into customer’s system to perform hands-on problem solving.

EDUCATION

BACHELOR OF ARTS (MANAGEMENT INFORMATION SYSTEMS) (2002-04)

Florida Atlantic University Port Saint Lucie, FL

ASSOCIATE OF ARTS (COMPUTER SCIENCE) (1992-94)

Indian River Community College Fort Pierce, FL

Elected vice-president and the president the following year of Phi Beta Lambda, a business fraternity at I.R.C.C.

Awarded 2nd place in Computer Programming at Phi Beta Lambda’s State Leadership Conference.

Awarded 8th place in Telecommunications at Phi Beta Lambda’s National Leadership Conference.

SKILLS

Software Skills:

T-SQL, SSRS, SSIS, SSAS, Power BI, Agile Development, AWS, Azure C++(Visual C++ and C++Builder 1-4), R, Python, Delphi 2-6, Visual Basic, SQL, Java, HTML, ASP, COBOL, PASCAL, CGI, ISAPI, WordPerfect, MS Word, MS Excel, MS Access, Talend, Quattro Pro, Snowflake and Redshift, Tableau.

Hardware Skills:

Netware and NT administration skills.

Contact this candidate