We provide IT Staff Augmentation Services!

Bi Developer And Sql Server Dba Resume

Boston, MA

SUMMARY:

  • Extensive experience in Tableau Desktop, Server, Reader, Public. Using the latest version of Tableau 10.5
  • Proficient in design and development of various dashboards, reports utilizing Tableau visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
  • Experience in creating dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources.

TECHNICAL SKILLS:

  • SQL SERVER Management Studio (2008,2012,2014,1017)
  • Tableau (public,server,desktop)
  • Visual studio ( SSIS and SSRS)
  • Informatica
  • Mongo
  • Idera
  • Amazon(RDS,AWS)
  • Business Intelligent.

PROFESSIONAL EXPERIENCE:

BI Developer and SQL SERVER DBA

Confidential, Boston,MA

Resposibility:

  • Involved in translating the business questions and business requirements to actual and final dashboard technical requirements
  • Used Tableau for the data / business predictive analysis, for trending, for finding the pattern of data over the period of time.
  • Used Tableau for Sorting, Grouping, Dual Axis, building parameters with filters and parameters with set.
  • Used Tableau to Combine fields for analytical purposes, Data blending calculations.
  • Building the customized and interactive dashboards using multiple data sources
  • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created worksheets and dashboards by using custom queries and multiple tables.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Effectively used data blending feature in tableau.
  • Defined best practices for Tableau report development.
  • Administered user, user groups in Tableau.
  • Developing Standard and Create reports using Tableau Desktop.
  • Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
  • Preparing Report Mapping Documents as per Specifications.
  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Mentored business power users to create reports/dashboards using tableau desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Confidential, Cambridge,MA

Business Intelligent Developer

Responsibilities:

  • Excellent in creating simple and complex reports, Dashboard, visualization, Story, using Tableau.
  • Experience in Performance Tuning, Migration, Alert, email notification, Auditing, database security.
  • Database monitoring, Database Auditing and Security.
  • Query and Index performance monitoring using Idera
  • ETL trouble shooting skills
  • Proficient SQL programming.
  • Business Intelligence SSIS, SSRS, SSAS .
  • Design, building, test, publish, Tableau workbook and dashboard.
  • Conduct information-gathering interviews and obtain feedback.
  • Collect data and extract data from warehouse for reporting.
  • Analyze current data with software application.
  • Create summary report of a company current standing.
  • Present recommendation to senior management

Junior Oracle Database Administrator

Confidential

  • Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability.
  • Created primary database objects ( tables, views, indexes) once application developers have designed an application.
  • Monitored customer Databases and user access to the database and Remote administration of various production Databases.
  • Defined and implemented Backup Recovery and daily monitoring of the production database.
  • Worked on physical and logical designing of the database, which includes the distribution of data-files on different disks.
  • Set database access privileges for different users and user groups.
  • Managing database object permissions, user accounts, and all security-related tasks.
  • Allocate the separate rollback segments for the Batch processing jobs in order to speed up processing.
  • Reorganized data file, identification and elimination of contention factor like I/O, buffer and luck.

Controller Assistant

Confidential

  • Installation of SQL server both management studio and developer.
  • Created Database objects including Tables, Triggers and Views.
  • SSIS, SSRS, SSAS, Data warehouse Maintenance and monitoring of database using OEM and Custom Script.
  • Setup a fine green audit.
  • Data integrity Forecast and Analyze data and help client with analysis Provided database development support to development team. Migrating data from Access, Text file to SQL Server through DTS.
  • Planning and implementing capacity expansion in order to ensure that the company's databases are scalable.
  • Created and managed databases for clients as well as systems to provide import of client data, and reporting of
  • Came up with several programs so as to ensure that there was correct data transfer finalized data.

Hire Now