Description
SUMMARY * 7 years of professional experience as MS SQL Server/ETL/BI developer in designing and developing T-SQL queries, ETL package, and business reports using SSMS, SSIS and SSRS * Highly qualified in Tableau Desktop and Tableau Server with 4 years of professional experience in various versions of Tableau (8.x/9.x/10.x). * Worked with multiple System Development Life Cycle (SDLC) methodologies including Waterfall, Agile -Scrum Framework and have extensive experience working with Development, Production and QA environment. * Robust understanding of logical and physical Database design and development, data conversion and Normalization concept. * Proficient at data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems. * Experienced in SSIS for creating, documenting and deploying ETL packages under Package Deployment Model and Project Deployment Model to load data from source to destination. * Proficient using SSIS for implementing initial data load using Bulk Insert Task, Bulk Copy Program and Fast Load. Also, expert at implementing incremental data load using Slowly Changing Dimension (SCDs), Change Tracking and Change Data Capture (CDC). * Skilled at Error Logging, Exception handling and Custom Logging for SSIS package and Performance tuning in SSIS package. * Profound understanding of Enterprise Data Warehouse (EDW) concepts including OLTP/OLAP, Dimension/Fact table, Top-down/Bottom-Models, Star/Snowflake schemas. * Proficient in T-SQL, Query optimization, creation of Views, Triggers, User-defined functions, Store Procedures, Dynamic-queries and using CTE, Temp table, Table Variable, View as well as Subquery and join. * Broadly Intricated in Requirement gathering, Requirement documentation, Writing test plans, Testing and Quality reviews. * Experienced in designing and deploying tabular reports, drill-down reports, drill through reports, multicolumn reports, linked reports and parameterized reports by using SQL SSRS. * Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including the status. * Hands-on experience with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Donut Charts, Circle Views, Line Charts, Bullet Graphs and Histograms in Tableau Desktop versions (8x/9.x/10.x). * Proficient at Developing Dashboards and user stories using Tableau to deliver insights and advanced visualization. using Data blending, Replace references and customized queries in Tableau. * Proficient at using Alteryx for Customer Churn Analytics, Data Blending, Data Cataloging, Data Profiling, In- Database Processing. * Passion for exploring modern technology, strong social responsibility, outstanding interpersonal communication, problem solving, documentation and business analytical skills.
Accomplishments
Highlights:
Keywords
- Structured Query Language
- Management
- Microsoft SQL Server
- SQL Server Integration Services
- SQL Server Reporting Services
- SSIS
- Desktop Computer
- Business Intelligence
- Data Quality
- Data Warehouse
- Tableau 9.x/8.x (Desktop/ Server), SQL Server 2014, SQL Server Management Studio, Alteryx, SQL BI Suite (SSIS, SSRS), Jira(5.x/6.x)