We provide IT Staff Augmentation Services!

Technical Applications Analyst Resume

Alpharetta, GA

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.

Hire Now