We provide IT Staff Augmentation Services!

Bi/tableau Developer Resume

0/5 (Submit Your Rating)

Phoenix, AZ

SUMMARY

  • Master of EE with over 7+ year experiences in Sql server/Oracle/Mysql, 6+ year experiences in the areas of analysis, design and development of Business Intelligence solution using Microsoft BI suite (SSIS, SSRS and SSAS), Excel2013/Access 2010/2013, Crystal Report 2011/2013 and Tableau (Desktop & Server) tools in Data Warehousing, Client Server Technologies and Web - based Applications.
  • Experience in design and development of various dashboards, reports utilizing Tableau Visualizations like donut chart, Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization according to the end user requirement. Dynamically Show and Hide Sheets in dashboard. Using parameter to change dimensions and measures.
  • Professional experience in Data Extraction, Transform & Load (ETL) development using SQL Server Integration Services (SSIS): loading variety of large volume data files into data mart/data warehousing, migrating Oracle and MySQL database into DW and generate Reports with SSRS.
  • Hands on experience in creating Jobs, Alerts and Scheduled SSIS Packages.
  • Power user of advanced SQL queries with multi-table joins, group functions, sub-queries, nested sub-query, stored procedure, UDF, temp table, CTE, views, pivot operator, table merge, triggers, cursor, set operations and T-SQL or PL/SQL functions.
  • Experience on trim, format, slice, and dice data and also experience on Data modeling and Database design.
  • Experience on analytic function to analysis data for cumulative distribution value, finding median, ranking, etc.
  • Hands on experience of generating variety of business reports using SQL Server 2008/2012 SSRS including tabular, Matrix, parameterized, cascading parameterized, sub report, dashboard with chart, graph, dashboard, drill-down, drill-through, map report, by using global variables, parameters, expressions and functions, build reports from Analysis Services cube; configured report server and deployed reports on web server.
  • Experience in design and implement Data marts, thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.
  • Using SQL server profile and tuning advisor, execution plan to improve server performance.
  • Involved designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
  • Generated variety of business reports using SQL Server 2012 SQL query, SSAS, SSRS, Crystal Report 2011/2013, Excel 2010/2013(Using VBA to generate Macro to generate dynamic reports), and Tableau.

TECHNICAL SKILLS

Relational Databases: SQL Server 2008R2/2012/2014, Oracle11g/12c, Access 2010/2013, MySQL, Teradata

Reporting Packages: Excel 2010/2013,SSRS, Crystal Report 2011/2013, Tableau 9.x, PowerBI, OBIEE

SQL Server/BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS)

Programming Language: SQL, T-SQL, Excel Visual Basic, HTML, CSS, Java, Python, C#, VB.net

MS Office: Word, Excel, PowerPoint, Access

Platforms: Windows Server 2008/2008R2, Windows 7/8/10, TFS, Linux, Github, AWS, S3, visual studio, VMworkstation, putty, SSH

Bigdata: Hadoop, HBase, Pig, Hive, MongoDB, Sqoop, JDK, HDFS OSCH

PROFESSIONAL EXPERIENCE

Confidential, Phoenix AZ

BI/Tableau Developer

Responsibilities:

  • Replicated the entire ETL process from Production to Development environment for debugging production issues and demoing results of new requirements to business users.
  • Pulled data automatic from Amazon S3, designed and created ETL packages by using SSIS to load data into staging tables and Data Warehouse, including Data Flow Task, Execute SQL Task, Execute Package Task, Execute Process Task, File System Task, Script Task, Foreach Loop Container, For Loop container, Sequence Container, Conditional Split, Lookup, OLE DB Command, Row Count, Script Component, Multicast, Union All, Store Procedures, Logging, even handler, etc. (daily loading 401 flat files into staging tables)
  • Normalize ICD9 and ICD10, updated existing SSIS packages to meet the new data model requirements.
  • Created, coded, tested, implemented and troubleshooting new/existing SSIS packages
  • Design and implement Data mart and SSIS package, SSIS package production deployment.
  • Worked on client requirement and wrote Complex SQL Queries to generate Ad hoc Report.
  • Creating and automating the regular Jobs.
  • Tuned and Optimized SQL Queries using Execution Plan and Profiler.
  • Trouble shooting ETL SSIS Packages. Daily Monitor SSIS Package in Production.
  • Moving archive files to Amazon Glacier, working on AWS S3. Source control with Github.
  • Design and implement the Nurses’ Job Schedule Web Form Application by using VB.Net
  • Experience in design and development of various dashboards, reports utilizing Tableau Visualizations like

Confidential, Bay Area CA

Database/ Tableau Developer

Responsibilities:

  • Used python weekly crawling data from webs with different ways.
  • Used python to Extract and import data into MySQL database/Excel/flat files.
  • Used Workbench to manage MySQL database, such as configuration, create new schemas and tables, join tables, store procedures, queries etc.
  • Used dynamic SQL to replace old tables and columns, etc. Created trigger to insert new data to different databases
  • Used analytic function to analysis data for cumulative distribution value, finding median, ranking, etc.
  • Created ad hoc reports by using SQL queries.
  • Scheduled jobs to automatic crawl data based on the business requirements.
  • Used Amazon AWS and Source control with Git.
  • Used SSIS ETL packages to load Data in to Data mart from different date source and Deployed SSIS Package.
  • Used double pivot, recursive CTE, etc.to generate reports by different business requirement.
  • Created Trend Analysis of the Business growth by using store procedure.
  • Experienced in working withSSASin creating cubes, data source views and deploying of analysis services projects.
  • Developed, designed and supported interactive Tableau dashboards and views from scrach.
  • Translated business requirements into sustainable and efficient visualizations and reporting.
  • Techniques from Tableau such as aggregates, hierarchies, data blending, table calculations, trend lines, forecast analytics, calculated measures were used in all the projects.

Confidential

MS SQL BI Developer

Responsibilities:

  • Analyzed weblog data and using SSIS extraction, transformation, and load weblog data into SQL database using SQL server 2012 and SSDT.
  • Optimized data access in SQL Server by wisely using indexes and execution plan.
  • Analyzed customer information from different source.
  • Developed and deployedSSISpackages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Detail orient to find special case and direct report the performance by using SSRS.
  • Worked in a cross-functional agile scrum team to build up a Data Mart.
  • Experienced on BI SDLC: Data Source, Data Profile, ETL(ETL QA), BI Development.
  • Experienced on dealing with Data Quality Issues, such as Data type conversions, handling white space, 0, nulls, decimals, and identifying useful data vs. non-useful data by business meaning.
  • MS SSIS to ETL Data to Data Warehouse with Data profiling, Data Cleansing.
  • CreatedSSISpackages to transform data from different data sources into application required formats for e.g. Unpivoting/Pivot.
  • Used Macro automatic import/export data from different data sources to Excel. And also used Macro generate dynamical report in excel 2013.
  • Experienced on SSAS, SSRS and Tableau for reports.

Confidential, Seattle WA

BI Developer

Responsibilities:

  • Detailed analysis customers’ and product data and generated reports to management.
  • Loaded excel and flat files into SQL server Database by DTS.
  • Created and Used Macro to import/export data from Access and Sql server to Excel to generate reports.
  • Generated products reports by using Graphical Indicators, add Gauges to tables and used parameters to filer tables, add list to the report, Document Map report.
  • Generated variety of business reports using Excel 2010 Pivot table.
  • Added Charts to reports and Linked Reports using tables and generated dashboard with chart, graph.
  • Migrated the data fromdifferent sources toSQLServer
  • Improved Report performance
  • Created database driven application by Visual Basic

Confidential

SQL BI Developer

Responsibilities:

  • Successfully performed in installation and configuration of SQL Server. Experienced in login and user creation, role and permission configuration.
  • Configured SQL Server and Oracle SQL 11g/11gR2 database parameter files to adjust the memory usage and file size.
  • Created database tables with various constraints including primary key, foreign key, etc.
  • Successfully loaded the raw data to SQL Server and analyzed the data using SQL Server and Access as an important tool.
  • Extracted data from SQL Server database tables and Oracle database tables into flat data files and Excel sheet.
  • Migrated data from text files, Excel spreadsheets, and Access toSQLServer databases using DTS,SQLServer Integration Services (SSIS) to overcome the transformation constraints.
  • Analyzed Base Stations data by using SSRS to report the performance of BS to manager.
  • Analyzed Base Stations data and gave suggestion to management to improve the services.
  • Used different Primary Key, Foreign Keys and linking their related data together.
  • Retrieved and modified data using SQL Server and analysis customer information from different database.
  • Experienced on SQL/T-SQL including stored procedures, temp tables, CTEs, views, etc.
  • Experienced on Data modeling and Database design.
  • Created a lot of ad hoc reports by using SQL queries
  • Used SSRS to generate tabular, Matrix, cascading parameterized, sub report, dashboard reports.

We'd love your feedback!