SUMMARY

• 8+ years of experience in design, development & analysis of SQL Server 2008/2008 R2/2012/2014 and SQL Server Business Intelligence tools - SSIS and SSRS
• 4 years of experience in Data Visualization Reporting via Tableau, QlikVIew, Qlik Sense and etc.:
• Strong experience in transforming business requirements into functional requirements for Tableau and Qlikview reports design, development and deployment
• Strong experience in developing complex dashboards using multiple chart types (Combo charts, Scatter plots etc.) and functionalities (filters, parameters, bookmarks etc.) in Tableau and Qlikview
• Strong experience in reports tuning by performance record analyzing in Tableau and data source optimizing in database
• Strong experience in publishing reports to Servers under security rule/row level security and scheduling automatic report refreshing
• Strong experience in system design, development and implementation using Waterfall and Agile
• 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 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 creating Jobs, SQL Mail Agent, Alerts and scheduling SSIS Packages
• Strong experience in maintaining Batch Logging, Error Logging with Event Handlers
• Strong experience in developing Drill Down, Cascading, Parameterized, Drill through, Linked and Sub reports using Global Variables, Expressions and Functions in SSRS
• Strong experience in configuring SQL Mail Agent for sending automatic emails on errors
• Strong experience in developing ad-hoc reports and scheduling automatic report deployment
• Good team player and communicator, self-motivated and possess ability for critical thinking and analysis and Strong inclination for finishing job before project deadline

TECHNICAL SKILLS

Relational Databases: SQL Server 2014/2012/2008 R2 / 2008/2005, DB2

Languages: T-SQL, VBA, R, SAS, Python

Operating Systems: Windows, Virtual Machine

Web Technologies: Google Analytics, Google Adwords, HTML, XML, MS FrontPage, AWS

Application Packages: Tableau, QlikView, Qlik Sense, Microsoft Office Suite, Cognos, Hadoop, SPSS, Content Analyzer, SpiderUs, Gephi

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), SQL Server Management studio, Database Engine Tuning Advisor, SQL Server Business Intelligence Development Studio, SQL Server Visual Studio

PROFESSIONAL EXPERIENCE

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 8.2, 9.1 and 9.2, Tableau 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 teh IT lifecycle (SDLC) using teh 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 teh referential integrity of teh database
• Created stored procedures which generated teh necessary fact and dimension tables and functions that allowed performing necessary calculations depending upon teh 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 halp 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 teh data on teh fly with teh 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, Newark, NJ

MS SQL Server/BI Developer

Responsibilities:

• Involved in performance tuning of existing database objects such as stored procedures and complex stored procedures
• Developed SQL queries, optimized stored procedures and sub queries for faster retrieval of data
• Created and deployed SSIS packages for data extraction, transformation and loading, and scheduling them as SQL Server jobs
• Loaded data from different sources (text based files, Excel spreadsheets) in legacy system to SQL Server databases using SQL Server Integration Services (SSIS)
• Tuned packages by updating statistics and reorganizing teh indexes to improve teh server efficiency in SQL Server 2014
• Designed and developed SSIS model package for historical load and incremental load (daily updates) to feed teh data warehouse from different sources including OLE DB, flat files, CSV files, and Excel 2007
• Generate different types of reports such as tabular report and matrix report etc. using SSRS and publish them in flat file and excel file forms
• Created SSRS reports using OLAP cube data sources and deployed on report server
• Deployed and scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports including current status

Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS) 2008, SQL Server Integration Services (SSIS) 2008, SQL Server Analysis Services (SSAS) 2008, MS Visio, SQL server Profiler, MS Office

Confidential, Cranbury, NJ

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in writing SQL statements including joins, functions, triggers, CTE, views and other complex queries
• Responsible for trouble shooting and problem solving of SQL development and creating back up plans
• Optimized and tuned existing stored procedure, indices and queries by monitoring through SQL profiler and Database Tuning Advisor
• Used common table expressions for removing duplication and ranking functions, and generating final tables
• Created different user defined functions and system functions as per teh requirement
• Implemented database management techniques that include backup/restore, import/export and generated scripts
• Normalized and de-normalized tables to maintain referential integrity by using Primary and Foreign Keys
• Exported or imported data from sources such as flat files using Import/Export through SSIS
• Built up high performance ETL package, migrated data from Oracle, flat files and MS Excel, cleaned and backed up data, and synchronized daily transactions by using SSIS
• Incrementally and dynamically loaded and transformed data by using SSIS (like change data capture, slowly changing dimension)

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

Confidential

MS SQL Server BI Developer

Responsibilities:

• Installed SQL server 2008 R2 with latest service pack and established connectivity with teh 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 teh Data Mart from teh 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 teh 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 teh report design as per teh need and identified and defined teh 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