Technical Applications Analyst Resume Alpharetta, GA - Hire IT People

SUMMARY:

Solutions - driven professional with comprehensive growth, experience, and in the area of Business Intelligence and Analytics.
Outstanding track record of meeting with business units to gather requirements for software development and bug fixes.
Using Tableau Desktop 2018.1 as a front-end BI tool and Microsoft SQL Server 2012 as a back-end database, design and develop workbooks, dashboards, global filter pages, and complex parameters-based calculations.
Proficient with Microsoft Excel to create pivot tables, reports, and dashboards to monitor case volume and Key Performance Indicators (KPI).
Experienced writing SQL statements to select, insert, update, and delete data in Oracle and SQL server databases.
Thorough understanding of data analysis, data mining, and statistical tools combined with the ability to master new concepts quickly and efficiently.

TECHNICAL SKILLS:

BI & Statistics: Tableau 2018.1 Desktop, R and RStudio, MiniTab, Data Warehouse, Data Mining, Data Analysis, IBM Cognos Query Studio

Microsoft Office: Excel, Access, Word, PowerPoint, Project, Outlook

Databases: Oracle, SQL Server, MS Access, Toad, Golden, SQL Plus

Software Languages: SQL, SQR Programming for PeopleSoft, Visual Basic for Applications (VBA)

Applications: PeopleSoft/ADP HCM (Payroll, HR, Benefits, and Time & Labor)

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Technical Applications Analyst

Responsibilities:

Extract, format, and distribute weekly dashboard and pivot table reports for Custom Payroll Programming Support manager and team members using Tableau, SQL Server, IBM Cognos Query Studio, Excel, and SharePoint.
Write SQL to Insert, Delete, and Update production payroll data.
Meet with internal and external clients to determine the root cause of reported programming issues and provide appropriate solutions.
Write new and maintain existing Structured Query Report (SQR) programs for ADP Enterprise Payroll, Human Resources and Benefits.
Developed Microsoft Access databases and utilized ODBC connections to the Oracle PeopleSoft 8.0 database tables to extract data and create complex Human Resources reports.