PROFESSIONAL EXPERIENCE

Tableau/Reports Developer

Confidential

­­Responsibilities:

• Handled Tableau admin activities granting access, managing extracts and Installations
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently
• Embedded Tableau views in to SharePoint
• Created adhoc reports to users in Tableau by connecting various data sources
• Experience in generating several interactive business dashboards
• Analyzed teh source data and handled efficiently by modifying teh data types
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports
• Generated context filters and used performance actions while handling huge volume of data
• Used Java Script API to auto refresh teh data in teh views of dashboards
• Generated tableau dashboards with combination charts for clear understanding
• Documenting and updating teh Project related process manuals
• Coordinate with different teams regarding data analysis and work with them to create new dashboards
• Coordinate with teh Tableau admin team to migrate teh workbooks into various servers.
• Analyzed data collected by teh Highway Safety Research Group to identify patterns and trends in teh data and knowledge of data mining decision trees
• Developed Power Pivot Reports in Excel by publishing them to SharePoint for providing ad - hoc reports according to client need
• Developed Charts and other visualization using Power View, Filter and Sorting Data using Power View in Excel
• Developed Power Maps using Excel for Reporting

Environment: Tableau 8.x, Excel 2012, Power View, MS SQL Server 2012, SSRS, BIDS, TFS

Business Intelligence Analyst

Confidential

Responsibilities:

• Gathered business requirements, definition and design of teh data sourcing and data flows, data quality analysis
• Written SQL script to analyze teh historical data and extract required data to support teh management decisions
• Extensively involved in Developing Stored Procedures, Functions and Triggers using T-SQL
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search (DB2 and Oracle), critical staging procedures for loading data marts and reporting database
• Graduate AssistantInvolved in teh design of data warehouse using Kimball Methodologies
• Created SSIS process design architecting teh flow of data from various sources to target
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access and Excel
• Written basic C#.Net scripts to implement Type 1 and Type 2 Slowly Changing Dimensions for incremental load
• Implemented SSIS packages to perform ETL Operations from multiple data sources including excel and text files
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of performance tuning operations
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, recovery and Disaster recovery procedures. Planned teh complete Back-up of various databases for disaster recovery scenarios
• Developed Multi dimensional Objects, cubes, dimensions using SSAS
• Designed Dimensional Modeling using SSAS packages for End- ser. Created Hierarchies in Dimensional Modeling and created reports using MDX queries
• Statistical analysis and machine learning with R
• Database development with Python DB-API, MS SQL Server

Environment: MS SQL Server 2012, .NET 3.5, Oracle 11g, XML, R, Python, T-SQL, SSIS, SSAS, MDX, SSRS, BIDS, TFS, SQL Profiler, Windows ServerConfidential

Graduate Assistant

Responsibilities:

• Developed and maintained IGERT and TIER websites under cct.lsu.edu and me.lsu.edu domains respectively
• Duties included research, building and testing a Mat lab program for analyzing teh images of ‘cooling of jet engine turbine blade’ process
• Based on teh results of teh program teh research team could analyze teh ability of air as a coolant to cool down teh blade material compared to other coolants
• Worked with software tools to correlate teh tree growth patterns of trees on teh banks of Mississippi river and worked at university libraries’ research desk

Database Developer

Confidential

Responsibilities:

• Experience writing T-SQL queries using joins, sub queries, temp tables
• Created complex database objects such as Tables, Functions, Store Procedures, Views, Cursors and Triggers
• Created reports using SSRS for teh patient (EEG) data from teh database based on teh Researchers requirements
• Processing raw electroencephalographic (EEG) data and converting EEG data into event-related potentials (ERP) using Neuroscan software and SPSS 18
• Worked on enhancing teh look and feel of teh Scans by Using EXCEL and Adobe Photo Shop
• Responsible for Loading teh data into database using Import- Export wizard, SSIS packages and retrieving teh data using Reporting Services
• Scheduled Jobs and Alerts using SQL Server Agent
• Migration of data from one environment to another environment using Import-Export, dts and SSIS packages
• Generated custom and parameterized reports, Sub Reports, Charts using SSRS

Environment: SQL Server 2008R2, Data Tools, SSMS, windows XP/2000, Excel, SSRS