Data Conversion Engineer Resume
2.00/5 (Submit Your Rating)
Tampa, FL
SUMMARY:
- 8.5 years’ experience in DATABASE ADMINISTRATION\DEVELOPMENT
- 8 years’ experience in SYSTEM ADMINISTRATION
- Certifications: Microsoft MCP / A+ / NETWORK+ / 70 - 461 querying SQL server 2012/2014
PROFESSIONAL EXPERIENCE:
Data Conversion Engineer
Confidential, Tampa, FL
Responsibilities:
- Administered PostgreSQL and Azure DB for PostgreSQL databases
- Wrote stored procedures
- Created tables and designed indexes
- Installed and configured K10 Data Management Platform for backup and restore of Azure DB for PostgreSQL
- Utilized Kettle\PDI for the development of ETL jobs to migrate data to Workday
- Utilized JavaScript to devleop SOAP requests for the migration of data to Workday
- Wrote SQL scripts to cleanse and transform client data for migration
- Configured production docker images to host data migration application
Systems Admin\SQL DBA
Confidential, Tampa, FL
Responsibilities:
- Modified database schema through creation of new tables, indexes and views
- Created complex TSQL stored procedures, functions and transactions
- Developed ETL processes utilizing SSIS to transfer data from company ERP system to SQL server
- Utilized C# script components within SSIS packages for advanced ETL techniques
- Developed T-SQL scripts necessary to transform transactional ERP data into data warehouse format
- Responsible for planning and deployment of Business Intelligence reporting solution utilizing Microsoft Power BI
- In process of integrating transactional data from multiple ERP suites into a consolidated data warehouse as part of corporate merger process
- Developed custom CRM solution utilizing third party REST API’s and SSIS ETL package
- Responsible for tuning, troubleshooting, securing and providing programming support for all databases including OLTP e-commerce system and BI data warehouse
- Assisted in deployment of e-commerce system including deployment of web, application and SQL database servers
- Utilized Git for source control
- Utilized Agile development practices
- Utilized Visual Studio for development and deployment of database projects
- Administrated Oracle databases via Enterprise Manager and SQLPlus
- Performed data analysis via Oracle SQL developer
- Re-engineered company’s network infrastructure including routers, switches, firewalls, Wi-Fi gateway and site-to-site branch office VPN topology
- Responsible for deployment and administration of VMware and Hyper-V based server virtualization
- Responsible for maintenance of all server and user workstation hardware including storage arrays
- Maintain company Domain Controllers and Active Directory infrastructure, including extensive group policy and share\NTFS permissions architecture
- Automate windows domain infrastructure administration tasks through authoring of PowerShell scripts
- Enabled secure remote desktop services for mobile users through deployment of Remote Desktop Gateway server
- Manage Office365 exchange online services
- Manage SharePoint and Dropbox for Business file sharing infrastructures
Systems Analyst Intern
Confidential
Responsibilities:
- Wrote PowerShell scripts to automate network administration tasks
- Provisioned Windows and Linux virtual machines and managed through System Center VMM
- Performed test migration of multi-tier PeopleSoft\Oracle database implementation from HP-UX to Windows Server 2012 R2 back end
- Conducted load testing of Oracle 11gR2 database on both Windows Server 2012 R2 and Oracle Enterprise Linux 7 platforms
- Implemented production Oracle Secure Enterprise Search Server
Systems and Network Administrator / Programmer
Confidential, Tampa, FL
Responsibilities:
- Maintained network of 200-plus systems including Domain controller, DHCP server, DNS server, Linux FTP server
- Performed network connectivity troubleshooting
- Maintained SonicWall firewall
- Implemented VPN servers
- Configured RAIDs
- Developed group policy
- Performed hardware repair and OS troubleshooting
- Performed maintenance on multiple SQL database servers
- Did some basic T-SQL data processing and development
- Used VBA to develop data entry database application
- Developed a Vbscript to implement data backup strategy
- Performed diagnostics and troubleshooting of application, hardware, network and procedural issues
- Assisted lead programmer with database connectivity issues
PC Technician
Confidential
Responsibilities:
- Installed, configured and upgraded operating systems and software
- Installed, assembled and configured computers, monitors, network infrastructure and peripherals such as printers, scanners and related hardware; pulled cables and rewired or directed the rewiring of cables as required
- Troubleshooting of problems with computer systems, including troubleshooting hardware and software, e-mail, network and peripheral equipment problems; made repairs and corrections where required
- Made hardware and software acquisition recommendations, including helping users assess needs and providing justification for equipment and services
