SUMMARY

• Perceptive and logical data analyst with proven ability to communicate with both technical professionals and end users to identify and translate business requirements.
• Offering six (6) years of experience driving data accuracy and integrity.
• Proven ability to build and lead teams of talented professionals to develop valuable process solutions to meet business objectives.
• Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
• Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
• Experience with DATA MINING. Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands - on data modeling experience using Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension Table, Physical and Logical Data Modeling using ERwin 3.x/4.
• Skilled in using SAS statistical procedures like PROC Report, PROC TABULATE, PROC CORR, PROC ANOVA, PROC MEANS, PROC TTEST, PROC FREQ, PROC UNIVARIATE, and PROC LOGISTIC.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
• Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks.
• Strong ability to write SQL queries using PROC SQL. Excellent knowledge and usage of reporting tools such as Tableau and SAS
• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).

TECHNICAL SKILLS

Querying Tools: SQL Management Studio 2008/2012/2014/2016, Teradata SQL Assistant, SQL Plus, SQL Developer

Querying language: SQL, PL/SQL, TSQL

Databases: MS SQL Server 2008/2012/2014/2016, Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2, SAS

Operating Systems: Win XP, Vista, 7, 10, Windows Server 2003, 2008, 2012, Unix

ETL/Other Tools: Informatica Power Center 8.6.1/9, SSIS (Visual Studio), SAS Base 9.x, SAS Enterprise Guide, SSIS, Erwin Data Modeler, ER Assistant, MS Access, MS SharePoint 2007 & above

Business Intelligence Tools: Tableau 9.2, 9.3, 10.4,2018,2019, 2020, Excel and Power BI, SSRS, MicroStrategy

PROFESSIONAL EXPERIENCE

Tableau Developer & Data Analyst

Confidential - Gaithersburg, MD

Responsibilities:

• Assessed platform statistics to create customized, data-intensive BI analytics.
• Monitored assessment software for performance, security and database availability throughout lifecycle.
• Wrote and optimized SQL statements to assist business intelligence practices.
• Produced Logical Data Models/Physical Data Models.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Documented whole process of working with Tableau Desktop and evaluating Business Requirements.
• Developing reports and dashboards using Tableau and Power Bi to support client and business users.
• Creating dashboard by leveraging techniques such as parameters, sets, groups and calculations for granular and drill-down into reports.
• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server.
• Used Text Files/ SQL Server Logging for ETL load at package level and task level to log number of records processed by each package and each task in package using SSIS.
• Identified long running stored procedures using Execution Plan and optimized queries for more effective data retrieval.
• Deployed and supported SSIS packages to production server, and jobs were scheduled run the packages.
• Analyzes data by defining quality requirements, making recommendations for changes on the source system, working with users to correct historical data and by applying standard data cleansing in integration services flows using SQL Server.
• Helped business users to reconcile reports generated from Data Warehouse with reports from legacy systems and validate data before and after the migration/integration.
• Created Drill-through, Drill-down, Cross Tab Reports, Sub-Report and periodic reports based on the statistical analysis of the data using SQL Server Reporting Services, deploy them onto SharePoint.

BI/ SAS Data Analyst

Confidential - Tampa, FL

Responsibilities:

• Designed customized data collection models for specific visualization tasks.
• Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
• Integrated BI assets into customer relationship management (CRM) tasks, improving service personnel's available intelligence.
• Responsible for developing, analyzing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
• Created derived columns from present columns for given requirements.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail Level summary reports and dashboards using KPI & #39;s
• Excellent knowledge and usage of statistical/mathematical analytics software like Stata, SPSS, SAS and Minitab.
• Used SAS to import and export data from and into Teradata tables. Excellent knowledge of Teradata DWH platform including architecture.
• Involved with DBA group to create Best-Fit Physical Data Model from Logical Data Model using Forward engineering with Erwin tool.

Tableau /SQL Analyst

Confidential - Framingham, MA

Responsibilities:

• Helped business users to reconcile reports generated from Data Warehouse with reports from legacy systems, and validate the data before and after the migration/integration
• Produced Logical Data Models/Physical Data Models.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Documented a whole process of working with Tableau Desktop and evaluating Business Requirements.
• Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering with Erwin tool
• Creating dashboard by leveraging techniques such as parameters, sets, groups and calculations for a granular and drill-down into reports
• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server
• Responsible for developing, analyzing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
• Created derived columns from the present columns for the given requirements.
• Used Text Files/ SQL Server Logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Identified long running stored procedures using Execution Plan and optimized queries for more effective data retrieval.
• Deployed and supported SSIS packages to production server, and jobs were scheduled run the packages.
• Analyzes data by defining quality requirements, making recommendations for changes on the source system, working with users to correct historical data and by applying standard data cleansing in integration services flows using SQL Server.