SUMMARY

• Strong experience in tailoring communications and gathering requirements from stakeholders, and transforming business requirements into functional requirements
• Strong experience in drawing business insights and developing story - telling dashboards, advanced reports and interactive visualizations to support decision making
• Strong experience in cleaning, analyzing and manipulating large dataset and combining multiple data sources from varies source systems
• Strong experience in managing user group credentials and licenses in QlikView, Qlik Sense QMC and Tableau Server
• Strong experience in designing, developing and maintaining multi-dimensional database and relational model
• Strong experience in T-SQL (DDL, DML, DCL and TCL) and constructing Normalization / De-normalization techniques
• Strong experience in query optimization and performance tuning using Data Engine Tuning Advisor, SQL Profiler, Execution Plan, Index Tuning Wizard and Debugger
• Strong experience in creating, testing and maintaining Stored Procedures, Views, Triggers, User Defined Functions, Sub-Queries, CTEs, error handling, exception handlers and other objects
• Strong experience in data Extraction, Transforming and Loading (ETL) by creating dynamic packages using containers and various transforms in SQL Server Integration Services (SSIS)
• Strong experience in tuning packages by dividing task to run in parallel, by modifying C# scripts in Script Task, by optimizing Stored Procedure and queries used in the package
• Strong experience in maintaining Batch Logging, Error Logging with Event Handlers

TECHNICAL SKILLS

Data Visualization: QlikView, Qlik Sense, Tableau, Power BI, MicroStrategy, Cognos, SSRS

Database & Scripting: SQL Server (T-SQL), DB2, Oracle (PL/SQL)

Other BI Tools: Advanced Excel, Python, R, SAS, SSIS, SSAS, Informatica

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

BI / Tableau Developer

Responsibilities:

• Extracted and analyzed large dataset from different source systems to draw business insights, to support decision making and to expand business opportunities
• Gathered and documented business requirements by leading meetings and collaborating with stakeholders and domain heads
• Developed 10+ interactive Tableau dashboards and reports with advanced functions, LOD calculations, and extensions
• Tuned Tableau report performance and decreased 70% of executing time by optimizing DataMart and writing stored procedures
• Published dashboards to Tableau Server, scheduled auto refresh base on required frequency and managed entitlement for different user groups
• Maintained Tableau Server by managing Users, Groups, Schedules, Tasks, Status and Settings as Tableau Server / Site Admin
• Managed multiple projects by planning, tracking and executing workable streams and held sprint / scrum meetings following Agile methodology
• Presented reports to internal stakeholders and trained users to have better utilization of the interactive dashboards
• Supported team as a subject matter expert (SME) through troubleshooting and identified opportunities to solve business problems through BI

Environment: Tableau Desktop and Server 10.5, 2019.2, DB2

Confidential, New York, NY

BI / QlikView Developer

Responsibilities:

• Mentored junior developers and provided technique guidance for them, and supported whole team as SME
• Functioned as Business Analyst collaborating with internal users and stakeholders to gather and document business requirements
• Extracted and analyzed large dataset from different source systems to draw business insights and to find patterns to support decision making
• Developed interactive 20+ QlikView / Tableau dashboards with advanced data visualization, calculation, and extensions
• Scheduled auto-refresh for all reports base on required frequency and delivered excel / pdf / PowerPoint reports via NPrinting
• Designed data structure and optimized data model by modifying loading scripts / custom SQL in QlikView and Tableau to tune report performance
• Applied Section Access and Security Rules to manage access and authorization for both external and internal users
• Managed multiple projects by planning, tracking and executing workable streams and held sprint / scrum meetings following Agile methodology
• Presented reports to internal senior leads and trained user to have better understanding and utilization of the interactive dashboards
• Supported team as a subject matter expert (SME) through troubleshooting and identified opportunities to solve business problems through BI

Environment: QlikView 11.2 SR15 and 12 SR7, Tableau 10.5, 2018.3 and 2019.1, DB2, SQL Server, Informatica, SharePoint, Unix, CIA platform

Confidential, Trenton, NJ

BI / Tableau Developer

Responsibilities:

• Designed relational/dimensional SQL Server database/data mart using Visio, implemented in SQL Server Management Studio and migrated data using linked server and store procedure
• Created stored procedures, user defined functions, views, tables and T-SQL scripting base on complex business logic
• Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL
• Designed, developed and maintained daily, weekly, monthly and year-end 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 including combo charts, stacked bar charts, Pareto charts, donut charts, geographic maps, sparklines, crosstabs etc.
• Defined visualization pixels and created dashboards using vertical/horizontal containers and collected dashboards in Tableau Story
• Published workbooks and extract data sources to Tableau Server under row-level security environment and scheduled automatic extract refresh
• Tuned reports performance by recording and analyzing performance workbook on timeline and execution query, tuned and optimized analysis, calculated fields, layout and data source
• Supported team and report readers as a subject matter expert (SME) through troubleshooting, recommendation solutions and identifying opportunities to solve business problems through BI

Environment: MS SQL Server 2008 R2 and 2012, Tableau Desktop and Server 8.2, 9.1 and 9.2, Microsoft Visio, Cenbase Portal, Sharepoint

Confidential, Cleveland, OH

BI / QlikView Developer

Responsibilities:

• Supported Agile development practices, multiple IDEs and platforms locally and manage software development projects throughout the IT lifecycle (SDLC) using the suite of client-server tools in Visual Studio Team Foundation Server (TFS)
• Created stored procedures, user defined functions, views, CTE and TSQL scripting for complex business logic
• Migrated data from multiple sources into QlikView applications, performed detailed analysis of source system data and model that data in QlikView
• Designed, developed, and tested QlikView scripts to import data from source systems and test QlikView reports/dashboards to meet customer requirements
• Effectively visualized data (dashboards, reports, etc.) in QlikView, Qlik Sense and MicroStrategy for different business users and requirement
• Implemented visualizations including bar chart, line chart, combo chart, crosstab, Gantt chart in QlikView and Qlik Sense.
• Generated objects and functionalities including section access, alternate states, buttons, bookmark, list box etc. in QlikView
• Deployed QlikView applications onto server under security rule environment using QlikView Management Console (QMC) and access point and scheduled auto-refresh using trigger
• Published Qlik Sense workbooks onto Qlik Sense test server and production server
• Supported team and end-users as a subject matter expert (SME) through troubleshooting, recommendation solutions and identifying opportunities to solve business problems through BI

Environment: QlikView 10, Qlik Sense, MicroStrategy, MS SQL Server 2012, SQL Server Integration Services (SSIS) 2012

Confidential, New York, NY

BI / QlikView Developer

Responsibilities:

• Designed, created and tuned physical database objects (tables, views, indexes) to support logical and dimensional models, maintain the referential integrity of the database
• Created stored procedures which generated the necessary fact and dimension tables and functions that allowed performing necessary calculations depending upon the requirements
• Modified OLAP cubes by adding facts and changing dimensions for further analysis of data visualization and SSRS reporting.
• Designed and created different ETL packages to migrate data from various sources including CSV files and Excel Spreadsheets to SQL server 2012 using SSIS
• Used various SSIS Transformation tasks such as conditional split, merge, pivot, un-pivot, sort, lookup, fuzzy lookup, aggregation and derived column
• Created gauge report, sub-reports, drilldown reports, summary reports, linked reports, and parameterized reports and Qlikview for different business users
• Performed detailed analysis of source systems and source system data and model in QlikView, extracted, transformed and loaded data from multiple sources into QlikView application
• Designed and developed dashboards and scorecards, debugged problems and optimized performance of reports in QlikView and Qlik Sense
• Provided input on proposing, evaluating and selecting appropriate design alternatives which meet client requirements and are consistent with client’s current standards and processes

Environment: QlikView 10, Qlik Sense, MS SQL Server 2012, MySQL database, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Confidential, New York, NY

BI / Tableau Developer

Responsibilities:

• Designed dynamic ETL SSIS packages dealing with different data sources and loaded data into target data warehouse by performing different kinds of transforms using SSIS
• Developed T-SQL coding and table templates in database for preparing, processing and analyzing risk data
• Communicated with statistics, SAS, risk management team for better preparation of T-SQL and to help generate risk management model
• Utilized SQL programming skills within SAS model team and performed all programming required for branded card analysis and reporting
• Created scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using both Tableau and QlikView for different requirements
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed managers to understand the data on the fly with the usage of quick filters for on demand needed information
• Generated complex reports using multiple functionalities including global filters, parameters, actions, dynamic sets, groups
• Deployed Tableau workbooks onto Tableau Server and implemented row level security, scheduled data refresh on Tableau Server to ensure data accuracy
• Analyzed report performance by recording workbook timeline execution query and by generating performance workbook using Tableau desktop and Tableau Server

Environment: Tableau 8.1, Tableau 8.2, QlikView, MS SQL Server 2012, MySQL Database, SQL Server Integration Services (SSIS), MS Office

Confidential

MS SQL Server / BI Developer

Responsibilities:

• Installed SQL server 2008 R2 with latest service pack and established connectivity with the database, created, configured and maintained databases
• Created and handled maintenance plans for various tasks
• Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers and also created SQL scripts for tuning and scheduling
• Maintained course addition and status update SSIS packages of daily feeds to source system via third party SQL server application
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Pivot, Union all etc.
• Created, tested and deployed SSIS packages for data migration into facts and dimensions tables in the Data Mart from the source data warehouse tables
• Developed complex SSIS packages using various tasks, containers, data transformation like fuzzy lookup, for each loop and for loop sequence container
• Created SSIS packages for incremental loading, slowly changing dimensions, data conversion, cleansing tasks
• Performed the tuning of existing ETL packages and reduced process time from 8 hours to approx.6 hours, a 25% gain in performance
• Defined report layouts for formatting the report design as per the need and identified and defined the data sets for report generation using SSRS 2008

Environment: MS SQL Server 2005/2008/2008 R2, SQL Server Reporting Services (SSRS) 2005/2008, SQL Server Integration Services (SSIS) 2005/2008, MS Office