SUMMARY

• In - depth knowledge in various RDBM Sconcepts like database, schemas, tables, data type constraints, views, indexes, stored procedures, variables, user defined functions, triggers, CTE(common table expression) etc.
• Database design and complex query building for data extraction usingMicrosoft SQL Server2012 and 2016.
• Descriptive statistics and visualization (dashboards) wif,Power Pivot,Power BIDesktop andTableau(ad hoc reporting tools).
• Complex report development and dashboard creation wifstored proceduresinSSRSusing
• SSDTandMicrosoft Visual Studio2010 - 2017.
• Data migration from diverse sources to diverse destinations using SSIS (ETLprocessing).Extensive experience in Information Technology wif special emphasis on design and development of Database, Data Warehousing applications and Software Development Lifecycle (SDLC).
• Data analysis/modeling, data management and data cleansing wifR,SAS,SQLandSPSS.
• Data mining (supervised and unsupervised learning algorithms).
• Creation of highly professional and scientific articles, books, posters and presentations using LaTeX.

TECHNICAL SKILLS

• Power Pivot
• Power BIDesktop
• Tableau
• Microsoft Visual Studio2010 - 2017
• SAS
• SQL
• SPSS

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Garland, TX

Responsibilities:

• Responsible for creating complex stored procedures, triggers, tables, views, temp tables, joins, user defined functions.
• Involved in designing the physical databases model on SQL Server 2012 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL).
• Wrote complex stored procedures to process prospective customer information.
• Performed SQL Scripting, using Microsoft SQL Server Management Studio 2012 and 2016, to research, update, add, or delete information for records wifin tables using SELECT, UPDATE, INSERT, or DELETE statements wif JOIN, WHERE, GROUP BY, and ORDER BY clauses.
• Modified stored procedures and formulated basic coding and scripting to be utilized for reports wifin the organization.
• Designed and maintained Tableau dashboards for business users.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, joins, data blending, and dashboard actions.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created dashboards in Power BI desktop wif trends and forecasting features.
• Generated parameterized, cascading, linked reports,Sub-Reports,Drill down reports, Drill through reports and graphical reports wif stored procedures in MS SQL environment as well as dashboards using SSRS 2012 and 2016 and Visual Studio 2010 to 2017.
• Build complex conditional expressions for formatting in SSRS reports using the iif, switch and choose functions.
• Worked in collaboration wif company representatives, end users and other developers in the design of custom report templates for clients.
• Deployed SSRS reports on native Report server. Created linked reports in report manager.
• Created SSIS packages to export and import data from CSV files, text files and Excel spreadsheet. Involved in installation, configuration and development of SSIS packages using Visual Studio 2012 and 2016.
• Used SSIS package to populate data from excel to database, used lookup, derived column and conditional split to achieve the required data.
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.

Tableau/SSRS Report Developer

Confidential

Responsibilities:

• Defined best practices for Tableau report development.
• Design Dashboards using filters, parameters and action filters in Tableau.
• Built dashboards for measures wif forecast, trend line and reference lines in Tableau Desktop.
• Created scatter plots, line charts, tables, histogram, bubble charts, Gantt charts, maps, highlight tables, box and whisker plots, pie charts and treemaps in accordance wif business requirements.
• Develop Tableau reports that provide clear visualizations of variousindustry-specificKPIs.
• Work on generating various worksheets, dashboards and stories in Tableau Desktop using various data sources.
• Hands-ondevelopment and assisting users in creating and modifying worksheets and data visualization dashboards in Tableau.
• Designed, published and customized interactive reports and dashboards, report scheduling using Tableau server.
• Developed views,sub-queriesand joins for complex queries involving multiple tables.
• Created and updatedTransact-SQLstored procedures for report development.
• Worked extensively wifTransact-SQLDDL and DML.
• Designed and developed complex queries efficiently as per the given business requirements.
• Maintained SQL scripts, indexes and complex queries for analysis and extraction.
• Used SQL Server Reporting Services (SSRS) for creating matrix and tabular, drill down, drill through, and parameterized reports based on business requirements.
• Deployed and subscribed reports using SSRS to generate daily, weekly, monthly business reports.
• Created dashboards in Tableau and Power BI.
• Experience in scheduling and deploying reports on report manger.

Research Data Analys

University Teaching Hospital

Responsibilities:

• Performed exploratory data analysis, created spreadsheets and visualizations in Excel and Power Pivot.
• Performed statistical analysis using Excel, SPSS and R.
• Querying databases wif SQL programming language.
• Wide array of experiences in interpreting and analyzing data using statistical techniques.
• Documented success in acquiring data from primary and secondary sources, and determining its integrity at entry point.
• Hands-onexperience in identifying, analyzing and interpreting trends and patterns in complex data sets.
• Wrote reports and created charts in support of business operations, while remaining wifin the set protocols for report creation.
• Collect and analyze data in preparation for statistical and analytical reports. Data dictionary maintenance, data collection instruments, data cleansing, data manipulation, pattern identification, data reporting, redundancy management, results interpreting and presentation.
• Worked wif other team members to complete special projects and achieve project deadlines.
• Created visually impactful dashboards in Excel for data reporting by using pivot tables and VLOOKUP.
• Extracted, interpreted and analyzed data and transformed raw data into meaningful, actionable information.