We provide IT Staff Augmentation Services!

Sql Server And Tableau Developer Resume

3.00/5 (Submit Your Rating)

Edison, NJ

Hire Now

OBJECTIVE:

Seeking new challenges in the IT industry where relevant experience and education will be utilized and advanced.

SUMMARY:

  • MS Excel, MS Word, MS Access, and MS PowerPoint
  • Masters in Data Science Certification - Simplilearn Institute
  • Trained on Administering SQL server 2012 Databases
  • Knowledge of T- SQL Queries server 2012, SSIS and SSRS ETL and Reporting Tool.
  • Knowledge of TABLEU Data analytics Software
  • Completed Training on Data Analytics in Excel
  • Working on SAS Analytical software training.
  • New Jersey Comprehensive Financial System
  • Management Acquisition Control System Enhanced
  • Personnel Management Information System; Business Objects
  • Strong work ethic
  • Excellent communication skills
  • Excellent analytical skills
  • Ability to work independently

PROFESSIONAL EXPERIENCE:

Confidential, Edison, NJ

SQL Server and Tableau Developer

Responsibilities:

  • Experienced in TSQL (DDL,DML), documenting, coding, programming, modifying and implementing Business Intelligence solutions using SQL Server.
  • Expertise in creating Complex Stored Procedures , Queries for the application team and for the end users based on the business requirement.
  • Performed data profiling and analysis of structured and unstructured data.
  • Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats and Power View Reports with multiple views featuring tiles, and a number of visualizations, using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
  • Understanding of various source transformations, including flat files, XML and relational systems.
  • Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
  • Designing and developing SQL Server 2012 Databases, Tables, Stored procedures, Views, Triggers.
  • Written Common Table Expressions (CTE) and used analytical functions while writing stored procedures.
  • Performed complex joins to extract data from various tables in the databases
  • Written complex SQL statements using joins, sub queries and correlated sub queries.
  • Performed data conversions from flat files into a normalized database structure.
  • Worked on project specification documents, participated in data analysis meeting etc.
  • Used SSIS to transform and load data into SQL database via FTP from XML files, MS Excel as source data
  • Generated Tableau reports for the Management based on the requirement.
  • Created Tableau scorecards, dashboards using stack bars, bar graphsscattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.Creating users, groups, projects, Data connections, settings as a tableau
  • Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.

Confidential, Trenton, NJ

Assistant Auditor -Senior Auditor

Responsibilities:

  • Responsible for conducting financial, compliance, and performance audits for various Confidential Agencies.
  • Audit to verify compliance against government contract, department Laws, policies and procedures
  • Analyze Government Payroll, Expenditures, Revenue and Wage Reporting data, Ran Access queries and Excel Pivot tables for analytical review of the transactions related to the Department.
  • Assist in issuing audit reports which identify millions in potential cost savings and revenue enhancements.
  • Lead interviews with agency management and key personnel to obtain an understanding of internal control processes and identify risks.
  • Evaluate audit test results and develop additional procedures needed to determine the financial or organizational impact.
  • Evaluated the auditee’s internal control environment and assessed compliance in accordance to NJ statutes, circular letters, grant requirements, and organizational policies.
  • Performed analytical reviews and testing to analyze the internal control environment and identify deficiencies.
  • Prepared audit work papers, internal control evaluations, findings, and recommendations.
  • Performed risk assessments.
  • Conducted payroll audits to ensure ghost employees did not exist, leave time balances and overtime hours were accurate, employees were paid the proper unused leave time upon termination, employees were properly removed from the payroll system upon termination, and that timesheets were approved by an immediate supervisor.
  • Researched state and federal laws, administrative codes, circular letters, and executive orders related to state agencies and advise supervisors of potential risks of noncompliance.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship