| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateOver 10-year experiences as a DBA, SQL Developer, Data Analyst in databasedesigning, administration, development, optimization, Network Engineer inVLAN, VPN, Wi-Fi, Routing, Switching, Firewall, Securities, SystemsEngineer in migrating, upgrading, patching on Windows servers and SoftwareEngineer in full life cycle software developments._______________________________________________________________________________________________Certifications: MCITP, MCTS, MCSE, MCP, MCP+I, CCNASecurity, CCNA Routing & Switching_______________________________________________________________________________________________Educations: Computer Science in College of Engineering,Univ. of Illinois at Urbana-Champaign, IL_______________________________________________________________________________________________Skills Azure : Azure Data Studio, Data Migration Assistance, SQLServer Migration Assistance, SQL server objects creation, SQLobjects migration from on-prem to Azure, SSIS package migration to ADF(Azure Data Factory), Data Lake, Databricks, Synapse Analytics, Azure DataExplorer Analytics : Tableau, Power BI, Alteryx Desktop, ClickView,Postman, DynaTrace DB Admins : DB2 11.5, PostgreSQL 12/16, Oracle 11g/8i/7.3, Oracle Express Edition 11/21c, SQL Server 2022/2019/2016/2012/2008/2005/2000, MySQL 8.0/5.7/5.5 DBA Tools : SQL Workbench/J, R Studio, RazorSQL, DB2 Data Studio 4.1.4.0, pgAdmin 4, Orange 4, Toad 9/10 for Oracle, SQL Developer, PLSQL Developer, SQLplus, phpMyAdmin 4.9.5/4.9.11, MySQL Workbench 8.0/5.5, MS Enterprise Manager, SSMS, SSIS, SSRS, Query Analyzer, DTS, Business Intelligence Development Studio, Profiler, Surface Area Configuration, Server Configuration Manager, Reporting Service Configuration Manager, dtsinstall, osql, isql, sqlcmd, SQLIO 1.5, SQLIO Simulator 9.0, MSDE 2000, SQL Express, Jet Engine 2/2.5/3/3.5/4, Teradata QueryMan Languages : React, PL/SQL, T-SQL, VB, VB.NET, VBA, C#.NET, ASP.NET Core, C++, C, Java, HTML, PHP, R Program, Anaconda Python, Jupyter Notebook, Pascal, FORTRAN, dbase IV/III plus, Assembly 8086/8088 Scripting : vi, nano, WScritpt, VBScript, JavaScript, jQuery,PowerShell ISE, Robocopy Dev Tools : Git, Github, BitBucket, Jira, MongoDB compass, VS Code,Atom, Code Blocks, DAX, Power Query, PyCharm, Sublime Text,Notepad++, Forms 11g/4.5, MS Visual Studio 2022, 2019/2010/2005, Visual Basic 6.0/5.0,Visual C#.NET 2003/2005/2010/2013, Visual C++ 5.0, VBA 2019/2013/2010/2002/2000/97/7.0/2.0,Office Suite MS 365, 2019/2013/2010/2003/2000/97/7.0, DCOMCNFG,ActiveX Component, Windows API, Visual InterDev 6.0, Visual FoxPro 5.0 O/S Admins : Ubuntu Linux 18.04.4 on VirtualBox 6.14/ VMware 15, IBM AIX 7.1/6.1, Windows Server 2019, 2012 R2, 2008, 2003, 2000, NT 4.0, Workstation 4.0, 2000 Professional, XP, Vista, 7, 8, 10, 11, Windows 9x/3.x, MS DOS, NetWare 4.1/3.12 Server Utilities : Active Directory ntdstuil, dcdiag, ADSIedit,dcpromo, Dell OpenManage Server Administrator, Dell Array Manager, Dell DRACv2/v5, HP System Management, HP Array Configuration Utility, HP Array DiagnosticUtility, HP Network Configuration Utility, Diskeeper Corporation 2007 Enterprise Server Client Utilities : SecureCRT6.7, Veritas NetBackup Client, AttachmateExtra! X-tream, Sterling Commerce Connect Direct Requester, WS_FTP,FileZilla, PuTTY Security Admin : CrowdStrike, Cisco Firewall, SonicWall Firewall,Symantec System Center Console, Norton Personal Firewall, SSH Protocols/HW : TCP/IP, DHCP, SMTP, IPX/SPX, Cisco ASA5100/5512,Routers PHONE NUMBER AVAILABLE, Switch Catalyst 2960/4000, WAP 1040N, SonicWall1260 Pro Enhanced, Wireless Routers, DSL/Cable Modem, CAT 5/6 Cabling, Desktop PCs,Internal/External SCSI/SAS/SATA RAID Systems, Managed/Unmanaged Switches, Hubs, LowVoltage CablingExperiences Dec 2022 - Oct 2023 BMO Harris Bank100% REMOTE SQL DBA . Migrated 24 SQL servers from Windows 2012 to 2019 servers. . Migrated 300 + databases from SQL 2016 to 2019 . Configured Log Shipping for migrating databases with size overTerabytes. . Configured Always on Availability Group between Prod and DR SQLservers. . Full-filled the expectation of migration experience working in amission critical enterprise environment, ensuring downtime is planned and minimized as much as possible. . Took initiatives and showed the experience of working with changecontrol processes. . Demonstrated proficiency at building/configuring MS Windows Server(2012/2016/2019) and migrating on large server estates with the ability to work autonomously. . Migrated Shares, local server Users, and Securities from old to newserver without resetting the password. . Scripted to migrate objects in a big piece rather than object by object but all at once, SQL jobs, Linked Servers, Backupsets, Backup Devices, etc. . Migrated SSRS/SSAS/SSIS from Dev/QA/Prod/Disaster Recovery Windows Server 2016 to 2019 . Provided production support on SSIS packages . Analyzed Execution Plan to find the bottleneck in SQL statements . Used SQL Server Profiler to capture slow-running queries . Modified by adding columns to index to speed up the SQL statement . Used Performance Monitor . Used Database Engine Tuning Advisor . Created T-SQL scripts to generate Attach/Detach and Backup/Restore all database in an instance. . Ran scripts to migrate SQL Login without changing password from old to new SQL servers. . Created ad-hoc SQL Statements to automate adding hundreds of users into a newly created database. . Sync old and new SQL servers. . Demonstrated strong SQL knowledge as needed. . Analyzed and modified previously written VB .NET projects so thatconnection string in hundreds of Excel files to be pointing to new SQL servers. . Applied .Net web application and SQL development skills when setting Environment variables in both SSIS packages and web applications. . Performed on-call coverage for production support . Installed, modified, and troubleshoots repairs to computer hardwareand software systems, including VSLayout (Visual Studio 2019 Offline version), Sybase Client andDrivers, ODBC DNS settings and so on. . Created and maintained comprehensive documentation as it relates to servers, network topologies, equipment, and configurations. . Provided infrastructure services in all areas needed, including storage networking, Operating System, network security, directory services, server virtualization, system and network monitoring, application installations and configurations. . Identified, diagnosed, and resolved network problems including network connectivity, traffic utilization, etc. using available network tools in a timely fashion. . Maintained system functionality and capability by testing computercomponents. . Consulted with users to determine appropriate hardware and softwareneeds and assists in placing orders. . Maximized computer systems capabilities by studying technicalapplications and making recommendations. . Tested compatibility of new programs with existing ones. . Gathered data to identify and evaluate technical purchasing options. . Confirmed program objectives and specifications by testing new programs, comparing them with established standards, and making modifications. . Evaluated vendor-supplied software by studying user objectives and testing software compatibility with existing hardware and programs. . Installed software and necessary applications for workflow. . Carried out software, network, and database performance tuning. . Prepared reference material for users by drafting operationinstructions. . Performed experienced ETL tasks. . Configured firewall settings and installed CrowdStrike Agent Falconand ForeScout . Installed and monitored systems with Dynatrace. . Demonstrated the experiences with Windows 2012/2016/2019. . Provided excellent hand-on problem-solving ability andtroubleshooting skills. . Communicated technical information in an accessible manner to non-technical employees. . Shared the mindset of processes improvements. . Maintained Software maintenance and demonstrated testing capability. . Shared the knowledge of networking principles and operating systems. . Demonstrated ability to effectively prioritize and execute tasks ina high-pressure environment. August 2021 - Oct 2022 Guardian Electric Manufacturing Co. (DBAKelco Industries) Woodstock, IL Sr. Programmer / Analyst . Analyzed and provided resolutions for the CMMC (Cybersecurity Management Model Certification) levels. . Reduced 55 human hours per week to minutes by automating data entries using COM libraries. . Extensible use of IBM APIs to migrate data from Cloud to On- Premises Databases. . Visualized and automated end-to-end processes of Open Purchase Order management. . Resolved missing Customer Notes issues in Sales Orders by visualizing end-to-end processes. . Scripted SQL statements to clean up massive data in legacy BPCS system on AS/400 . Analyzed barcode systems and redesigned according to over-sea customer's specific requirements . Provided production support in Shipping/Receiving processes . Analyzed Execution Plan to find the bottleneck in SQL statements . Used SQL Server Profiler to capture slow-running queries . Modified by adding columns to index to speed up the SQL statement . Used Performance Monitor . Fined tunned SQL statements to reduce the performance time on Shipping/Receiving processes. . Coordinated meetings on departmental issues then simplified/resolved problems. . Analyzed apps developed in-house using SSMS 2019/2022 and 3rd party apps. . Fixed bugs on MS Access reports by writing VBA. . Investigated Hardware/Software Network Systems then came up with a Network Diagram . Advised IT members on day-to-day issues on what/how/when to-do. . Supported and Educated department Mangers advanced level of MS Office 365 . Support user tickets created in Lansweeper. . Set the baselines for the Cisco SD-WAN configurations on Meraki devices connected to Fiber Optic lines. . Designed VLAN infrastructure for secured data access. . Supported issues on complicated Pivot tables in Excel. . Provided support on DAX (Data Analytic Expressions) functions. May. 2000 - Sept. 2022 MSLink, Inc.Crystal Lake, IL Systems Engineer / SQL DBA / Data Engineer / Application Developer/Business Analysis . Rewrote MS Access 2000 application VBA code to 2013, 2019, Microsoft 365 Access . Revised Stored Procedures, Functions, Triggers of SQL 2000 to 2019 . Scripted for importing and exporting data using bcp and SQL statements. . Automated migration of functions, views, stored procedures to SQL 2019 . Migrated MS SQL 2000 database to SQL 2019 . DTS ETL to staging server then SSIS ETL to SQL Server 2019 . Created modified fixed SSIS Projects/Packages . Installed and configured SQL 2019 Enterprise, Standard, and Express Editions . Installed and configured Windows 2019 Server Standard Edition . Backup and restored to SQL 2008 databases. . Modified and Administered web apps connecting databases in MySQL on Ubuntu . Debugged PHP7.2.24 code reside in remote server with Visual Studio Code and Atom . ETL data from MySQL 5.5 to MySQL 5.7 and MySQL 8.0 . Generated and applied SSH keys for sftp and TCP/IP over ssh connections on Ubuntu . Installed and configured OpenSSH, PHP, Apache2.4, MySQL 5.5/ 5.7/8.0 on Ubuntu . Installed and configured Ubuntu 18.04 on VirtualBox 6.1 . Cleaned up Active Directory with ntdstuil, dcdiag, ADSIedit, and dcpromo. . EMR/EHR system implementation for Nursing Home Facilities . Switch Nortel PBX to VoIP Phone Systems . WiFi Network addition to LAN systems . Designed Cisco Firewall Configurations to split office and guest use . DNS management for email security . Implemented Dual Internet Connections for High Availability with zero downtime. . Legacy Hardware Systems Maintenance . Converting applications built in 2000 to current computing environments. . Strategic Planning for Server Upgrades from 2000 Editions to most recent Editions . Designed and implemented Windows 2003 Active Directory Local Area Network . Configured Windows XP pro workstations and networked printers. . Integrated firewall, router, and gateway. . Configured VPN server for tunneling and on-demand connection from remote offices. . Deployed anti-virus server and clients. . Configured VNC for remote administration on servers and workstations. . Monitored and maintained the Servers and Workstations on 3 different remote sites remotely. . Duties included: gathering system requirements, design, development, enhancement, and maintenance of the client/server Win Form based and Web based Staff Scheduling applications. . Migrated MS Access 2000 databases to MS SQL Server 2000 databases. . Troubleshot database application lockup issues caused by Windows NT network. . Coded 900+ Stored Procedures . Implemented push/pull Merge Replication on SQL Server 2000 . Created 100+ User Defined Functions Modified and added new features to custom-built application written in MS Access 95 . Migrated MS Access 95 application to Access 2000 and enhanced features in payroll, billing, scheduling, and reporting modules. . Developed custom utility tools, Auto Compacter, Auto Replicator, Auto Distributor, and Login Monitor using Visual Basic 5 . Managed project of C# .NET web-based application development with SQL 2000 database backend . Configured and managed mixed LAN composed of Windows NT, Windows 2000, and Macs. . Designed secure routing for 3 branch offices. . Configured and monitored 1 Primary and 3 Secondary DNS servers. . Configured DHCP server for VPN users. . Configured SonicWall Firewall Appliance and Norton Personal Firewall . Installed, configured, and monitored Symantec Antivirus Corporation Edition . Integrated and managed the Internet Firewall, Gateway, Router, and Terminal VPN servers. . Administered 4 remote sites remotely. Oct 2010 - Feb 2013 Hyundai C.E. USA, Inc. Norcross, GA IT Manager Responsible for IT department projects management for secure, scalable, and reliable systems to provide Online services to North America, South America, and overseas. . IT vendor management . Managed in-house Application Development of WMS, Warehouse Management Systems . Liaised between SAP accounting API and Oracle ERP . Coordinated upgrading from Oracle 8i to 11g. . Upgraded Oracle Forms from 4.5 to 11g. . Installed, configured, and maintained Hyper-V servers and Virtual Machines . Configured and maintained IIS Web Servers . Installed and configured Windows 2012 R2 Server . Installed and configured MS SQL 2012 Server . Installed and configured MS SQL 2012 Report Service . Managed existing Windows 2008 Servers . Network designed for VLAN infra, VPN sites, and server integrations with newly created remote offices. . Designed Configured Maintained Firewall/Router/Switch/VLAN/WiFi Network with Site Survey . Developed web applications using C#.NET and SSRS for Finance Department, LTFS . Maintained intranet websites with traditional ASP for Expense Management Systems . Developed office automation tools with VBA. . Agile Development, Analysis, and Modification of web based and form- based ERP applications running Oracle Packages, HTTP, Java script, ASP, ASP.NET . Performed analysis and migration on Oracle based data. . Administered Oracle Databases . Administered Remote offices network and applications . Troubleshoot Shipping program written in MS Access . Security Systems management with Cisco, Symantec, and Microsoft products Jan 2007 - June 2009 AT&T Hoffman Estate, IL SQL DBA / SQL Developer Played vital role to ensuring after-merger processes run smoothly as a major contributor to the clean-up processes that are responsible for distributing hundreds of millions of revenues. Applied combined expertise in Database Administration, Server Maintenance and Software Development to ensure the processes are intact during the transition to higher-level automated operations. Major achievements included: o Created stored procedures and functions which enabled cutting process time down to 70% (tcCleaner) o Project lead for processes of 2 weeks work down to 3 days (defaultPidMove) o Fine tuning ad-hoc processes of 32 hours down to 25 minutes (matchFinder) o Scripting SQL code for 3 days of manual work down to 1-minute automated processes (LBFeed). . Configured and maintained MS SQL 2000/2005 database servers for maximum resources usage. . Ran SQL 2005 Upgrade Advisor and made preparations. . Migrated logins, DTS packages, and databases of SQL 2000 to SQL 2005 . Low-level performance tuning, OS file level defragmentation and database level index defragmentation . Fine-tuned, streamlined, and automated 1000+ existing SQL statements. . Ran Profiler to support application/database developers to improve the database applications. . Optimized performance at application-level processes . Secured database server and database objects. . Monitored and administered services and hardware components of Domain Member Servers . Capacity planned on disk storage usages and added 5TB internal and external SATA drives. . Processed average of 100GB Teradata, 50GB Oracle database files monthly using SSIS . Managed average of 750GB flat text file and MS SQL database files monthly . Managed 27 GB of mission critical business logic files. . Created and maintained VB application to split 10GB+ flat text files into small database files. . Set hot/cold backup/restore routines for business logic and data in 30+ different databases. . Coded user-defined functions, SOUNDEX-like, for on files over 20GB each . Scripted for Teradata to automate file transfer average of 20 GB from MVS mainframe to SQL server. . Created DTS packages and Format Files for bulk insert on 45+ GB of data files with 100+ million row tables every week. . Migrated MS ACCESS 2002 databases to SQL 2000/2005 databases. . Helped team members with C#. NET, ADP, MDB with ADO, and SQL Server Technical Insights . Installed and configured Windows 2003 Server Enterprise on RAID 5 SCSI/SATA systems Jan 1999 - Jan 2001 MCIChicago, IL Application Developer Duties included development, testing, and implementation of report generating applications, ad-hoc queries, and file extracts for b2b clients. . ConTracker - project timing control systems, web-based application development. . FIR Tool - billing audit systems, web-based application development. . Genesis - integrated billing solutions developed with MS Access front-end and MS SQL back-end. . Skytel CR (contributing revenue) - reads data from MS Excel spreadsheet and text file as the criteria to filter data from the legacy systems and then the filtered data is processed to calculate the totals. . Volkswagen - parsed text files from the mainframe data pool, built processes to provide entry-error detection and correction on over 2,000 fields of records, and populated the cleaned data in relational database for further analysis. . Tech Data Corp. - created a database out of mainframe text files and built a reporting system, which lists top 10 communication services based on the customer's specific criteria and other numerous detail reports. . National City Corp. - performed analysis and fixed on hundreds of field data integrity. . United Airline - imported data from text file with complicated import specification and then transferred data into spreadsheet format. . Gateway, Proctor & Gamble, Skytel, TSO Frame, Teledyne, and PLBS - enhanced query and reporting systems. . Household Finance Corp. - developed Database Cleaning Tool, automatically finds missing data. . Dayton Hudson Corp. - parsed mainframe legacy database, populated the data in to normalized relational database, automated the billing process with reporting systems as to meet customers' specific requirements. . Developed OliPdf Generator, add-in tools equipped with user- friendly file selection interface, which converts any database reports into PDF file format. . Developed FIT (First Invoice Tool), parsing and searching tool currently used nationwide that analyzes the data layout pattern in the header portion of files from the legacy systems, parses the text file, and then transfer the data into a table. With dynamic query builder built in the system, the production time reduced to 5 minutes from 5 ~ 8 hours otherwise. . Developed Normalizer, which analyzes and reconstructs database structures to meet the desired normal form from non-relational table. . Developed Maintenance Tracking System, where users issue tickets for new developments, modified specifications, error reports and developers' response to it. With email functionality built in the system, teams monitor the tickets in a timely manner. . Developed Catch Audit, an add-in auto-upgrade capable tool, which provides the process of filtering reports contained in over 500 databases. . Developed pullout, report retriever, which collects report names and its location in the LAN. . Developed pulladdr, address puller that extracts email addresses, IP address, and MAC address of each and every workstation of the entire LAN._______________________________________________________________________________________________ |
