OBJECTIVE

• To obtain a Lead Database Administrator/Developer, Data Analyst, or Data Scientist position that will challenge and enhance my education and experience in Computer Information Systems.

TECHNICAL SKILLS

Programming Languages: TSQL, basic Linux commands, basic VI scripting, HTML, Visual Basic 6.0, basic Python

Operating Systems: Windows Server 2012 (R2), Windows Server 2008 (R2), Window Server 2003, Windows Server 2000, Windows 8, Unix, Red Hat Linux

Databases: MS SQL 2014, MS SQL 2012 (R2), MS SQL 2008 (R2), MS SQL 2005, MS SQL 2000, MS Access, Oracle 9i & 11i, basic DB2 skills, Hadoop, Google Big Query, MySQL SQL Server, query, queries, T - SQL, Microsoft SQL, OLTP, DMV, AGILE, CDC, Administration, Scripting

Database Tools: SSIS, DTS, SSDT, SQL Developer for Oracle, Quest LiteSpeed Backup, Quest Spotlight, Red Gate SQL Backup, SQL Stripes, Idera SQL Admin Tools, Idera SQL Diagnostic Manager, TOAD, PuTTY, HUE, Teradata SQL Assistant Microsoft SQL Server, RDBMS, SQL Analysis Services

Applications: Microsoft Office Suite, Kronos WFC, McKesson Paragon 12.x upgrades, BMC SDE, WinSCP, Sharepoint, Squirt JDBC GUI Tool, Secure CRT, HL7 Interface, Veritas Backup Software, Erwin Data Modeler, Visio, Visual Studio 2015, Rapid Miner, R Studio, Talend PCI, analytical, Microsoft SQL, HIPPA

Data Visualization Tools: Tableau, Power BI, SSRS, QlikView

Others: Software/hardware installation and Windows components, software upgrade, troubleshooting software/hardware, map network drives, manage server logins, knowledge of Network Design, TCP/IP, SAN, System Development Life Cycle, security techniques, and Agile methodology.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Data Analyst/Business Intelligence Architect

Responsibilities:

• Gather requirements from Merchandizing and Financial Leads to create Tableau and Power BI reports displaying KPI metrics utilizing several back-end sources (Google Big Query, Hadoop, Teradata, SSAS cubes, and DB2)
• Continue maintaining SQL 2014 data warehouses; ETS from other sources using SSIS.
• Created tables and Views in Google Big Query
• Performed planning for retiring SQL server and transitioning current SSRS and Sharepoint reports to Tableau (Project Lead).
• Weekly import of csv files from 3rd party vendor into Google Big Query
• Scheduled Big Query refresh jobs using Sqoop to pull from DB2 and Hadoop
• Worked closely with Salesforce Developers on Audit software transition from Formsite to Salesforce, creating and mapping reporting on Salesforce.

Business Intelligence Architect/DBA

Confidential

Responsibilities:

• Monitor Finance SQL 2014 databases troubleshooting locking, slowness issues and failed jobs.
• Coordinate with Finance Dept. and Reporting Team to gather requirements for new scorecards and reports.
• Create tables, views, and complex stored procedures for new scorecards and reports, using JOINS, UNIONS, and other rollup methods.
• Create SSIS packages to import/transform data from Teradata Data Warehouse and DB2 databases.
• Modify existing stored procedures, tables, and views to include new columns as requested by Finance Dept. and for performance improvements.
• Create Excel Pivot Tables to display SQL data, and rank and rate vendors based on customer satisfaction.
• Create flowcharts and documentation to store in SVN share directory.
• Redesign processes that previously used Access database to use SQL database, SSIS and Store Procedures.
• Data analysis on questions related to Weekly Reports
• Assist other team members when they have difficulty with creating stored procedures and views
• Perform query optimization by modifying stored procedures and adding indexes where needed
• Work with Windows Team on space monitoring and resolve space issues when they arise either by shrinking, purging old data, or requesting space due to new growth on the server
• Grant access to databases using least required privileges.
• Assisted with upgrade from 2008 to 2014, rewriting OPEN QUERY to SSIS package, modifying stored procedures, developed, deployed, and tested on new server.

Confidential, McDonough, GA

Sr. SQL DBA Consultant

Responsibilities:

• Work on migrating project from SQL 2008 to SQL 2012 including SSRS and SSIS, consolidating hundreds of jobs, planning and documentation of upgrade of Business Intelligence server, moving SSIS packages from Prod to BI and pointing SSRS to BI Server, reducing the time taken for end-of-month processes and basic DBA duties, maintenance upkeep (Backups, jobs, indexing, optimization, troubleshoot performance issues) and. Interviewed end-users to gather requirements

Confidential, Gainesville, GA

Database Administrator

Responsibilities:

• Maintained several 24x7 high transaction databases.
• Responsible for performance tuning, troubleshooting using native SQL tools, creating and managing database maintenance plans.
• Performed database/login migrations to new servers.
• Installed and configure SQL 2008 R2 or SQL 2012 R2 for new projects.
• Migrated SQL 2008 R2 databases, SSIS packages, and SSRS projects to new SQL 2012 R2 database servers.
• Applied online SQL Patches and Cumulative Updates to the SQL 2012 Database cluster.
• Queried Oracle databases using SQL Developer tool and Putty.
• Extracted Data from Oracle 11i database and insert into SQL Database using SSIS.
• Performed server-side application upgrades and create workstation documentation for end-users.
• Daily monitoring of SQL Job and free space for trending and prevention of outages/down-time.
• Created and maintain reports using SQL Reporting Services, Power BI, and QlikView.
• Refreshed QA and Test Environments upon request (SQL and Oracle).
• Troubleshoot and modify SSIS packages as needed.
• Created documentation for recurring DBA Team tasks and keep current on Sharepoint site.
• Monitored DBA Team Service Request queue and assign to Team Members where appropriate.
• Monitored server space and work with SAN Admin to project growth.
• Troubleshoot Microsoft Access database issues.
• Ran Linux, VI, and Oracle scripts provided by vendor documentation to upgrade applications.
• Researched Oracle issues and apply fixes where appropriate.
• FTP’d to Mainframe servers to copy files to Windows or Linux servers
• Trained BI Team members on SSIS and SSRS for those requesting training.

Confidential, Alpharetta, GA

Sr. Database Administrator

Responsibilities:

• Set up and maintained login security on all SQL databases.
• Solely maintained over 100 production databases and several Dev/Test databases.
• Upgrade Centricity databases from SQL 2000 to SQL 2008 R2.
• Rewrote hundreds of DTS packages into SSIS packages
• Updated processes to perform Month End process, including rewriting queries and DTS to SSIS
• Worked closely with Developers on Upgrade modifications.
• Responsible for performance tuning, creating and managing maintenance plans.
• Refreshed Test Environments upon request.
• Moved databases from existing hardware to new hardware, modify logins, jobs, and test functionality.
• Assured good backups to SAN using Quest LiteSpeed backup tools.