SUMMARY

• 6 years of Business Intelligence experiences in Data Modeling, Database System, Data Visualization, Enterprise Data Warehouse and Report Development.
• Rich Domain knowledge and experience in Healthcare and Banking industries.
• Expertise in transforming business resources and tasks into regularized data and analytical models, developing data mining and reporting solutions across a massive volume of structured and unstructured data.
• Involved in entire data science project life cycle including Data Acquisition, Exploratory Data Analysis, Data Cleansing, Data Manipulation, Visualization, Feature Engineering, Modelling, Testing, Optimization and Deployment.
• Proficient in designing and developing T - SQL queries, ETL packages and business reports using SQL Server Management Studio (SSMS), BI Suite (SSIS) and Tableau.
• Profound understanding of Enterprise Data Warehouse (EDW) concepts including OLTP/OLAP, Dimension/Fact table, Top-down/Bottom-up approach, Star/Snowflake schemas.
• Extensive experience in Relational Database Management System including developing optimized SQL queries, stored procedures, User-defined Functions, Views, Dynamic-queries, Temp table, CTE, Table Variables, Subquery, Join, Triggers and Transactions.
• Excellent knowledge in Python including NumPy, Pandas, SciPy, Matplotlib, Seaborn and Scikit-learn.
• Comprehensive knowledge in various reporting objects like Facts, Attributes, Joins, Sorting, Hierarchies, Transformations, Filters, Calculated fields, Sets, Groups, and Parameters in Tableau.
• Knowledgeable of statistics Methodologies such as Hypothesis Testing, Principle Component Analysis (PCA), A/B Testing, ANOVA, Chi-Square, and Cross-Validation.
• Knowledge and experience in the Hadoop ecosystem and Apache Spark framework such as HDFS, Map-reduce, Pig Latin, HiveQL, SparkSQL, PySpark.
• Familiar with Cloud Services Amazon Web Services (AWS) and Microsoft Azure such as EC2, RDS, S3, and Azure HDInsight, Azure Data Lake to assist with big data tools, solve storage issues and work on deployment solution.
• Passion for exploring modern technology, strong team-work spirit, outstanding interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS

Languages: Python (NumPy, Pandas, Scikit-learn, Matplotlib, Seaborn), R, SQL, T-SQL, VBA

Databases: Microsoft SQL Server 2008 R 2/2012/2014/2016 , MySQL, SQLite

BI Tools: Tableau 8.x/9.x/10.x, Microsoft Suite (SSIS), Power BI, MS Excel (Pivot Table, VLOOKUP)

Statistical Methods: Hypothesis Testing, ANOVA, Time Series Analysis, Cross Validation, Principal Component Analysis (PCA), Exploratory Data Analysis (EDA)

Hadoop Ecosystem: Hadoop 2, HDFS, HIVE, Pig, PySpark, SparkSQL

Cloud Services: Amazon Web Services (AWS) EC2/S3/RDS/EMR/Redshift, Microsoft Azure

Project Management Tools: GitHub, Slack, Microsoft Project, Google Shared Services

PROFESSIONAL EXPERIENCE

Confidential, Whippany, NJ

Tableau Developer/ Data Engineer

Responsibilities:

• Collaborated with Business Analysts and other BI developers to identify existing report needs, new reporting requirements and translated them into deliverable solutions.
• Involved in designing the data warehouse to ensure that it is efficient and accurate for reporting purpose and the data inside is cleaned and structured.
• Built ETL packages in SSIS to perform full loads as well as incremental loads from OLTP to data warehouse using different data flow and control flow tasks and provide maintenance for existing jobs.
• Developed Tableau data visualization using Cross tabs, Heat maps, Bar Charts, Gantt charts, Waterfall charts, Scatter Plots, Geographic Maps, Pie Charts and Donut Charts.
• Optimized existing report performance by improving source data readability, query & ETL design and efficient report features & function selection.
• Organized reports and validated queries for fellow BI developers.
• Collaborated with QA Team and DBAs to test and troubleshoot reports to ensure reports quality and smooth report deployment.
• Created complex, high performance stored procedures in Database which were used to populate report contents.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the updated data accurately.
• Assisted in Tableau admin activities including granting access, managing extracts and installations, caching configurations to support large volume usage.
• Built efficient SQL queries for new report development and assisted in testing queries for fellow report developers.
• Participated in training end users across departments to use the reports and collecting feedbacks on how to improve user experiences.

Environment: s: MS SQL Server 2014, SQL Server Management Studio (SSMS), Visual Studio, SQL Server Integration Service (SSIS), Tableau 10.x (Desktop/Server), MS Excel

Confidential, Lakewood, NJ

Data Engineer

Responsibilities:

• Collaborate with our organizations to source data from existing SQL server DB, Excel sheet, flat file and interoperate with existing systems.
• Rebuilt the data architecture and managed the relationships by applying several constraints: primary key, unique key and creating reference tables between different source systems and queries for extracting data.
• Developed SSIS packages to perform data extraction from various sources, data cleansing, and batch loading to ensure efficient and accurate data migration.
• Performed full loads using different data flow and control flow to migrate data to MS SQL Server 2016 new database.
• Designed deployment plan and developed project deployment package in SSIS.
• Maintained SSIS packages for large scale data conversion, data import, and export processes.
• Supported QA testing of the packages and resolved any issues found in the testing processes; Using different types of error handling for various events.
• Enhanced ETL packages performance by adjusting properties, restructure flows and tuned embedded queries by adjusting indexes using execution plan and data engine tuning advisor.
• Maintained and developed complex SQL queries, stored procedures, views, functions in MS SQL server.
• Wrote documentations for each package including purpose, data source, column mapping, transformation.

Environment: MS SQL Server 2008 R2/2016, SQL Server Management Studio, SQL Server Integration Service (SSIS), SQL Server Data Tools (SSDT), Office 365, T-SQL

Confidential, Fort Wayne, IN

BI Analyst/ SQL developer

Responsibilities:

• Collected requirements from report developers and designed report demos to satisfying user demand supporting decision making.
• Collaborated with data engineers and operation team to implement the ETL process, wrote and optimized SQL queries to perform data extraction to fit the analytics requirements.
• Created SQL Store procedure, CTE, Trigger to validate, extract, transform and load data into Data Warehouse and Data Mart.
• Cooperated with data scientists to perform data preprocessing and feature engineering for further building models like Classification Model to predict potential.
• Conducted data preparation using SQL for Tableau consumption and publishing dashboard to Tableau Server.
• Developed Tableau data visualization using Cross tabs, Heat maps, Bar Charts, Gantt charts, Waterfall charts, Scatter Plots, Geographic Maps, Pie Charts and Donut Charts.
• Utilized quick filters, action filters, parameter controls, achieved functionalities such as dynamic displaying title, commentary, and corresponding records, collapse and expand the table, sub-report linkage, dynamic tooltip displaying, etc.
• Using Tableau Desktop to analyze and obtain insights into large data sets using groups, hierarchies, sorts, sets and filters.
• Generated Tableau Public Dashboard with constraints to show specific aspects for a different purpose.
• Involved in automating reports generated a weekly and monthly basis for the client and business sales teams.

Environment: SQL Server 2012, SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), SQL Server Data Tools (SSDT), T-SQL, Tableau 9.x, Tableau Server

Confidential, Cambridge, MA

Tableau/BI Developer

Responsibilities:

• Responsible for collecting the business requirements of the projects and converting requirements into technical designs.
• Gathered the data from multiple data sources and validated source data as per requirements.
• Designed and created data warehouse solutions by applying Ralph Kimball methodology including dimensional modeling and star schema.
• Modeled the data and managed the relationships by applying several constraints: primary key, unique key and creating reference tables between different source systems and queries for extracting data.
• Performed incremental loads as well as full loads to transfer data from OLTP to Data Warehouse using different data flow and control flow tasks in SSIS and provide maintenance for existing jobs.
• Used multiple dataflow tasks, execute SQL task, script task and other tasks to accomplish the ETL process, and created SSIS Event Handler to notify ETL support team, DBA, users and log the execution information of the packages.
• Transformed all reports, dashboards previously built-in Excel into Tableau.
• Wrote complex SQL queries using inner join, left join and temp table to retrieve data from the database for reporting purpose
• Built dashboards with a bar chart, line chart, heat map and apply quick/context/global filters, parameters and calculated fields on Tableau.
• Implemented dashboards and views in Tableau for the management team for retrieving business insights and conducting further analysis.
• Collaborated with the QA team, report users to test reports and troubleshoot issues to ensure data quality for each report.
• Refreshed data on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards display updated data.

Environment: SQL Server 2012, SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), SQL Server Data Tools (SSDT), Excel, T-SQL, Tableau 8.x