SUMMARY

• 7+ years of IT experience in Business Intelligence, Data Warehousing, and Reporting application in Financial, Healthcare, Pharmaceutical and Manufacturing industries.
• Around 4 years’ experience working with Tableau Desktop, Tableau Server in various versions including Tableau(8.x/9.x/10.x).
• Around 3 years of work experience with statistical data analysis such as linear models, multivariate analysis, Statistical Analysis, Data Mining and Machine Learning techniques.
• Familiar with Python(2.x,3.x) to develop analytic models and solutions.
• Hands - on experience in creating insightful Tableau worksheets, dashboards, and stories to generate segment analysis and financial forecasting reports by plugging in various maps.
• Proficient at using Alteryx for Data Blending, Data Cataloging, Data Profiling and In- Database Processing.
• Strong skillset in MS SQL Server 2014/2012/2008 with SQL Server Data Tools (SSDT), Business Intelligence Development Studio (BIDS), SQL Server Integration Server (SSIS) and SQL Server Reporting Services (SSRS).
• Experienced in designing and deploying tabular reports, drill-down reports, drill through reports, multicolumn reports, linked reports and parameterized reports by using SSRS.
• Proficient at Data Scrubbing, Data Cleansing and Data Validation checks during staging before loading the data into the Data warehouse.
• Used ETL packages to apply control flow tasks (for loop, for each loop and Execute SQL task) and data flow tasks using various transformations (Conditional Spilt, Data Conversion, Loop up, Derived Column, Merge and Union all).
• Highly proficient at using T-SQL for developing complex Stored Procedure, Triggers, Indexes, Tables, User Defined Functions, Relational Database models and SQL joins to support data manipulation and conversion tasks.
• Strong experience in Store Procedure/T-SQL coding, Performance tuning and Query Optimization using performance monitoring tools such as SQL Server Profiler and analyzing Execution Plans, creating Clustered and Non-Clustered Indexes.
• Excellent hands-on experience in capturing and preserving the state of data by setting up Slowly Changing Dimensions(SCD), Change Data Capture(CDC) mechanisms to extract data from staging tables to partitioned tables with incremental load.
• Highly skilled in creating, maintaining and deploying Extract, Transform and Load(ETL) packages to Integration Server using Project Deployment and Package Deployment models.
• Expert in Software Development Life Cycle (SDLC), including implementation and execution of methodologies such as Waterfall and Agile-Scrum.
• Outstanding interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS

RMDBS: MS SQL Server 2014/2012/2008 R2/2008/2005, MySQL, Postgre SQL, Oracle11g/10g/9i, MS Access

ETL Tools: Server Integration Service(SSIS), Alteryx(11.x)

Reporting Tools: Tableau Suite of Tools 10.x, 9.x, 8.x which includes Desktop, Server, Online and Public, Server Reporting Services(SSRS), Report Builder 2.0/3.0

Languages: SQL, TSQL, PL/SQL, C#, Python (2.x/3.x), R, SAS

Operating Systems: PowerShell, UNIX, Linux, Ubuntu and Windows

Source control tools: TFS, GIT, SVN, JIRA, SharePoint

PROFESSIONAL EXPERIENCE

Confidential - Ewing Township, NJ

BI Developer/Data Scientist (SQL/SSIS/Alteryx/Tableau/Python)

Responsibilities:

• Designed SSIS package to perform extract, transform and load (ETL) data across different platforms and validate the data and achieve the data files into the database.
• Conducted Data blending, Data preparation using Alteryx and SQL for tableau consumption and publishing data sources to Tableau server.
• Worked with unstructured data creating workflows in Alteryx with documentation and implementation of the processed data.
• Designed, developed and maintained daily and monthly summary, trending and benchmark reports repository in Tableau Desktop.
• Generated complex calculated fields and parameters, toggled and global filters, dynamic sets, groups, actions, custom color palettes, statistical analysis to meet business requirements.
• Implemented visualizations and views like combo charts, stacked bar charts, pareto charts, donut charts, geographic maps, spark lines, crosstabs etc.
• Published workbooks and extract data sources to Tableau Server, implemented row-level security and scheduled automatic extract refresh.
• Analyzed workbook performance on timeline and execution query, tuned and optimized analysis, calculated fields, layout and data source.
• Applied tableau security and published report to Tableau Server based on Sector Level & Market Level.
• Worked on data cleaning and ensured data quality, consistency, integrity using Pandas, Numpy.
• Participated in feature engineering such as feature intersection generating, feature normalize and label encoding with Scikit-learn preprocessing.
• Performed Naïve Bayes, KNN, Logistic Regression, Random forest, SVM, LightGBM and XGboost to identify whether a loan will default or not.
• Implemented Ensemble of Ridge, Lasso Regression and XGboost to predict the potential loan default loss.
• Used various metrics (RMSE, MAE, F-Score, ROC and AUC) to evaluate the performance of each model.

Environment: MS SQL Server 2014, SSIS, Alteryx 11.0 & 11.3, Tableau Desktop (9.x/10.x), Tableau Server (9.x/10.x), Python 3.x (Pandas, Numpy, Scipy, Scikit-learn package), Machine Learning (Naïve Bayes, KNN, Regression, Random Forest, SVM, LightGBM, XGboost, Ensemble), SharePoint 2013

Confidential, NYC, NY

BI Developer/Data Analyst (SQL/SSIS/Tableau/Python)

Responsibilities:

• Created and maintained SQL Server Integration Services (SSIS) packages to load data daily from different resources to create and maintain an analytical data warehouse. Data sources include flat files, spreadsheet, access, SQL Server databases and other third-party sources.
• Worked with SSDT to create SSIS packages and created data mappings using different transformations such as Conditional Split, Lookup, Merge, Multicast, slowly changing Dimension, OLE DB Command, Derived Column.
• Created SQL jobs to process packages and load data at specified times and specify certain action upon failure or success of the job.
• Cleaned data in SQL Server and prepared data source in Tableau metadata using Join, Custom SQL, Split and Data Blending.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Motion Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Developed various kinds of reports (pivots, charts, tabular) using global and local Filters.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server to allow end users understand data on the fly by using quick filters for on demand needed information.
• Created groups in the repository and added users to the groups and granted privileges explicitly through group inheritance.
• Conducted independent descriptive analysis and statistical analysis.
• Used Python to build statistical models involving Linear Regression, Ridge Regression, Lasso Regression, Gradient boosting for estimating the risks of assets.
• Identified and targeted high-risk groups with Machine learning algorithms involving Logistic Regression, Random forest models and Support Vector Machine.

Environment: MS SQL Server 2012, SSIS, Tableau Desktop (8.x/9.x), Tableau Server(8.x/9.x), T-SQL, TFS, Python 2.x (Pandas, Numpy, Scipy, Scikit-learn package), Machine Learning (Regression, Random Forest, Gradient Boosting, SVM, XGboost)

Confidential, Thorofare, NJ

BI/Tableau Developer(SQL/SSMS/SSIS/Tableau)

Responsibilities:

• Design ETL packages using SSIS, imported data into SQL Server databases from various data sources such as SQL Server, Oracle and flat files.
• Extracted and transformed source data using SSIS. Soundly used SSIS transformations, such as Fuzzy Lookup, Conditional Split, Merge, Union ALL and Derived Column.
• Developed complex stored procedure, views and user-defined functions on MS SQL Server (2008 R2 and 2012); Identified weaknesses in T-SQL code and improved those weaknesses for future release.
• Analyzed data requirements for the business applications; Developed data models and planned data migration/conversion strategies for internal and externally hosted applications.
• Collaborated with other groups (business partners, developers, QAs and engineers) for implementation of analytical and technical solutions.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations to build dashboards.
• Developed tableau reports/dashboards using bar graphs, scattered plots, geographical maps, pie charts, heat maps, Gantt charts etc. and extensively used calculated fields, Quick Table Calculations, Parameters, Sets, bins etc.
• Created metrics, attributes, filters, reports and dashboards. Also, created advanced chart types, visualizations and complex calculations, Analytics and BI and Production Support issue resolution.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Participated in the full life-cycle development process from definition and design to production delivery.
• Created unit test cases and technical documentation also performed detailed code reviews.

Environment: SQL Server 2012/2008 R2, SQL Server Management Studio, SSIS, T-SQL, Tableau Desktop 8.x, Tableau Server 8.x, Oracle 11g, PL-SQL, SharePoint 2010, Visual Studio 2010.

Confidential -Newark, DE

Business Intelligence Developer(SQL/SSIS/SSMS/SSRS)

Responsibilities:

• Migrated data from Heterogeneous data sources and legacy system (Oracle, MS Access, Excel) to centralized SQL Server databases using SQL Server Integration(SSIS) to overcome transformation constraints.
• Created SSIS packages to extract patients’ information and medical records from various sources to company’s database and scheduled SQL Server Agent Jobs to call the packages.
• Performed incremental loading from source systems into data warehouse & data marts using a combination of techniques including T-SQL/Stored Procedures (Merge Statement/Checksum Function), Slowly Changing Dimensions(SCDs) Type 1/2/3.
• Wrote complex SQL queries using joins, subqueries and correlated subqueries to retrieve data from the database.
• Created packages to validate, extract, transform and load data to a centralized SQL Server using OLEDB providers from the existing diversified data sources.
• Retrieved data such as patient medical records, radiology information systems, and healthcare claim adjudication to support Hospital/Clinical operations.
• Managed and maintained data in MS Access database, generated relational database reports.
• Worked to create, develop and deploy multiple Drill down, Drill through, Sub-report and Parameterized reports by using SQL Server Reporting Services(SSRS).
• Wrote Parameterized Queries for generating Tabular reports and Sub-reports using Global variables, Expressions and functions, sorting data, defining data sources and Subtotals for reports using SSRS.

Environment: SQL Server 2012/2008 R2, SQL Server Management Studio(SSMS), T-SQL, Visual Studio 2012, MS BI Suite(SSIS/SSRS), Oracle 10g, PL-SQL, SharePoint 2010.

Confidential

Microsoft BI Developer(SQL/SSIS/SSMS/SSRS)

Responsibilities:

• Collected requirements directly from business users, and designed report models to meet business requirements.
• Maintained and developed complex SQL queries, stored procedures, views, functions and reports that meet customer requirements using Microsoft SQL Server 2008 R2.
• Created Views and Table-valued Functions, Common Table Expression (CTE), joins, complex subqueries to provide the reporting solutions.
• Optimized the performance of queries with modification in T-SQL queries, removed the unnecessary columns and redundant data, normalized tables, established joins and created index.
• Created SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task.
• Created, managed, and delivered interactive web-based reports to support daily operations.
• Validated reports and resolve issues in a timely manner.
• Developed and implemented several types of Financial Reports (Income Statement, Profit& Loss Statement, EBIT, ROIC Reports) by using SSRS.
• Developed parameterized dynamic performance Reports (Gross Margin, Revenue base on geographic regions, Profitability based on web sales and smartphone app sales) and ran the reports every month and distributed them to respective departments through mailing server subscriptions and SharePoint server.
• Designed and developed new reports and maintained existing reports using Microsoft SQL Reporting Services (SSRS) and Microsoft Excel to support the firm's strategy and management.
• Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using SSRS.

Environment: SQL Server 2008 R2, SQL Server Management Studio, MS BI Suite(SSIS/SSRS), T-SQL, SharePoint 2010, Visual Studio 2010