PROFESSIONAL SUMMARY:

• Over 5 Years of IT experience on Application Development and Business Intelligence Analytics in various domains like Pharmaceutical, Retail Solutions, Cloud Computing etc. 3 years of experience in Designing and Development of Business intelligence application with QlikView 11.x as BI tool.
• Having 1 Year experience on Tableau Business Intelligence/Business Analytics software.
• Experience in IT Software Development Life cycle involving Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing and Database Business Systems.
• Strong knowledge in using sheet objects of QlikView like List Boxes, Multi Boxes, Tables, Charts, Current Selection Boxes, Buttons and experience in editing scripts for creating variables, fields, connection strings and calculated expressions, basic and aggregated functions.
• Extensive knowledge on QlikView Enterprise Management Console (QEMC), QlikView Publisher, QlikView Web Server, QlikView Extensions.
• Expertise on database such as creation of data models, Star schema, snowflake schema, users and their security access levels.
• Worked with QlikView 10.x, 11.x SQL Server, Oracle 11g, NPrinting, IE Plug - ins, Excel, flat files.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Expertise inOLTP/OLAPSystem Study,Slowly Changing Dimensions types(SCD'S) Analysis andE-R modeling, developing Database Schemas likeStar flake schemaandSnowflake schemaused in relational, dimensional and multidimensional modeling.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
• Exhaustive experience in Data Extraction and Transformation and Loading (ETL) using SQL Server Integration Services (SSIS) in MS SQL to import/export bulk data.
• Hands on experience on developing Qlikview Macros and IE Plugins, enabling IE-Plugins on QMC server
• Developed Set Analysis to provide the custom functionality in Qlikview Applications.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview with the help of Document Analyzer 2.x.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, report delivery and report security.
• Experienced on Tableau Admin activities, Multidimensional database and writing SQL queries
• Extensively worked with SQL Queries, and capable of handling Oracle, SQL Server, MS Access databases.
• Strong in SQL and PL/SQL Database programming - development of stored procedures, cursors, triggers & Views.
• Extracting the data tables using custom generated queries from Excel files, Access/ SQL database and providing extract data as an input to Tableau.
• Writing SQL Scripts to load the relevant data in Qlikview Applications.
• Testing Applications, reports using review checklists, Data quality for quality assurance before delivering to the end users.
• Experience on working onsite & offshore model to deliver projects on time with agile methodology.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/03/08/12 Server, Windows XP/NT/7/8.1

Databases/BI Tools: MS SQL Server 10.0/7.0/2000/05/08/12 Tableau 7.0/8.2, Tableau server 8.2, Tableau Reader 8.1, IBM

Languages: T-SQL, PL/SQL, C, C#, VS 2005/08, ASP.net 3.5.

SQL Server Tools: SQL Management Studio, Business Intelligence Development Studio, Visual Studio 2005/08/10, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, SSIS, SSRS

Report Tools: MS Reporting Services, NPrinting 16.x, CIA Reporting Manager

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Database Modeling & Other Tools: SQL Compare, SQL Trace

Dash boarding/Analytics: QlikView 10.x/11.x, QMC/QEMC

PROFESSIONAL EXPERIENCE:

Confidential: San Antonio, Texas

QlikView Developer/ Data-IT Analytics

Responsibilities:

• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Provided implementation and ongoing support related to Qlikview.
• Developed extensively Alerts, Variables and Input boxes.
• Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc.
• Created Dashboards style of reports using QlikView components like Slider, Buttons, Charts, and Bookmarks.
• Support included creation of reports and standard relational databases for upload to SharePoint dashboard web part pages, and creation of supporting SQL queries.
• Worked with QlikView 10.x, 11.x SQL Server, Excel, flat files.
• Managed 5 members of offshore team to deliver multiple projects at a time.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance the performance of the business with analytical capabilities.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software.
• Hands on publishing/scheduling tasks on QMC & experience on assigning user access
• Solid experience on implementing by enhancing the code for an already existing code like fine tuning, performance tuning, add/modify or clean up unwanted things and improve the efficiency of the script by making it short and simple for the end user.
• Exposed on developing a script right from the scratch by seeing the end visualization, thereby providing the design document, BRD document and also the business document if any logic involved.
• Worked with various external database sources like the flat files, CSV files, Microsoft access database, Oracle, SQL databases by tweaking the data and loading it into Qlikview application.
• Experience in complete project life cycle including Documentation, Analysis, Development and Testing.
• Worked on 3 levels of implementation such as DEV, UACC and PROD
• Document event trigger and field event triggers are created. Incremental reloading is implemented.
• Developed executive dashboards in QlikView, delivered through the web, enabling to measure the performance of the business with analytical capabilities.

Environment: SQL Server 2005/08/12, Oracle 11g, IBM DB2, Windows 08/08R2/12 Servers, T-SQL, PL/SQL Developer Tool, Qlikview 11.2, MS Office 2010/2013, QV NPrinting 16.x, QMC

Confidential: Plano, TX

Tableau Developer

Responsibilities:

• Extracting the data tables using custom generated queries from excel files, access/ SQL database and providing extracted data as input to tableau.
• Created Tableau scorecards, dashboards using stack bars, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with advanced analysis actions, calculations, parameters, background images, maps, trend lines, statistics and log axis. Group hierarchies, sets to create detail level summary report and dashboards using KPI’s.
• Defined best practices forTableaureport development.Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems.
• ISupervised Vizql and WGSQL processes to monitor performance and system stability.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Provided 24/7 production support for Tableauusersand conducting s to user on interact, filter, sort and customize views on an existing visualization generated thruTableaudesktop.
• Created SQL Queries for testing the tableau Dashboards.

Environment: Tableau Server 6/7, Tableau Desktop 6/7,MS SQL Server 2008, Oracle 10g, SQL BI Suite (SSIS, SSRS, SSAS) Visual Studio 2010, Windows

Confidential : Hartford, CT

SQL Developer

Responsibilities:

• Involved in Data Migration from legacy to master using DTS-import and Export wizard.
• Created views to facilitate easy user interface implementation, and triggers to enforce Data and referential integrity.
• Created indexed views in T-SQL to increase the query performance.
• Develop Backup & Restore scripts for SQL server as needed.
• Created reports using SQL Server Reporting services.
• Has done DBCC checks to ensure the physical consistency of the database and objects.
• Checking Space monitoring, Index Defrag, Update Statistics, Log Shipping between Primary production servers and Standby and Extracted data from internal data warehouse system to SSRS
• Developed SQLReporting servicesweb applications using .Net 3.5 principles
• Provided 24 X 7 dedicated supports for Production, QA & Development environments.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports

Environment: Windows 2003 server, VB6.0, XML, SQL Server 2005, T-SQL, SQL Server Reporting services

Confidential

C# Web & SQL Developer

Responsibilities:

• Designing and Developing Web forms using C#, ASP.Net 3.5, HTML, XML, LINQ, WCF, java script, Ajax Tool kit, silver light
• Designed and Developed the .NET GUI for the user interface using ASP.NET Web Forms.
• Created triggers, UDF, views, tables and generated T-SQL script for application and indexes for better performance.
• Responsible for installation, configuration and maintenance of MS SQL Server on various environments.
• Created various complex stored procedures for ETL as well as maintenance of the database.
• Developed stored procedures and T-SQL code to accomplish various tasks.
• Tuned SQL statements and Stored Procedures.
• Posted HTML files to server and updated database and returned the response back to ASP.NET.
• Involved in designing and creating Web UI screens using ASP.Net.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications

Environment: MS SQL Server 2000, DTS, .NET Framework, HTML, MS Excel, MS Access, SQL, Visual Basic 6.0C#.net 3.5 and ASP/VB.NET.