SUMMARY:

• Over 5 years of experience in Data Visualization Reporting via QlikView, Qlik Sense and Tableau etc.:
• Strong experience in gathering requirements from stakeholders and transforming business requirements into functional requirements
• Strong experience in extracting, blending and joining varies data sources to implement and optimize QVD and loading scripts in QlikView
• Strong experience in developing complex UI dashboards and parameterized reports using varies objects and functionalities
• Strong experience in performance tuning by identifying and enhancing the performance of the Dashboards/Reports
• Over 8 years of experience in MS SQL Server Database management and T - SQL:
• 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 T-SQL (DDL, DML, DCL and TCL) in constructing Tables, Normalization / De-normalization techniques
• 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 of database / data warehouse design, management and maintenance.
• Over 8 years of experience in SQL Server Integration Services (SSIS)/ETL:
• 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 maintaining Batch Logging, Error Logging with Event Handlers
• 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

SKILLS:

Application Packages: QlikView, Qlik Sense, Tableau Desktop, Tableau Server, Microsoft Office Suite, Cognos, Hadoop, SPSS

BI Tools: SQL Server, DB2, SSIS, SSAS, SSRS, Informatica

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Data Analyst/QlikView Developer

Responsibilities:

• Leading user meetings and collaborating with internal stakeholders to gather and document business requirements
• Performing data source testing, cleaning, extracting and analyzing to support report design, development and deployment
• Extracting and analyzing large dataset from different source systems to draw business insights and to find patterns to support decision making
• Developing meaningful QlikView dashboards with advanced data visualization, calculation, and user-friendly interactions
• Designing data structure and optimizing data model by modifying loading scripts in QlikView so that turning report performance.
• Reconciling reports and calculations in QlikView to perform data validation and ensure data accuracy and integrity
• Troubleshooting data problems and solving data issues by tracking data flow / transformation and finding root cause
• Managing multiple projects by planning, tracking and executing workable workstreams and holding sprint meetings following Agile methodology
• Presenting reports to internal senior leads and training user to have better understanding and utilizing the interactive dashboards
• Supporting team as a subject matter expert (SME) through troubleshooting and identifying opportunities to solve business problems through BI

Environment: QlikView 11.2 SR15 and 12 SR7, DB2, Informatica, SharePoint, Unix, CIA platform

Confidential, Trenton, NJ

BI/Tableau Developer

Responsibilities:

• Designed relational/dimensional SQL Server database/datamart 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 for complex business logic
• Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL, split and data blending
• 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 andoptimized 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