PROFESSIONAL SUMMARY:

• Over 12 years of IT experience on Application Development and Business Intelligence Analytics in various domains like Pharmaceutical, Healthcare, Retail Marketing, Transportation, Aerospace, Heavy Earth movers, Energy Solutions etc.
• 6 years of experience in Designing and Development of Data Warehouse/Business Intelligence application with QlikView 12.x/11.x/10.x, QlikSense 2.x/3.x, Tableau 10.x as BI tools.
• 2+years of experience as QlikSense & NPrinting Developer using different Extensions & Mashups,
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView & QlikSense
• Experience in IT Software Development Life cycle involving Business Requirements, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing and Database Business Systems
• Expertise in installation, configuration and upgrading from existing versions of Qlikview / Qlik Sense / Nprinting to latest versions on Desktop, DEV, UAT and PROD servers.
• Building QVDs, QVWs, QVFs using source systems like Oracle, SQL Server, Excel/Flat file
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Extensively worked on set analysis, advanced aggregation and section access
• Expertise in working with QlikView Desktop, QMC, QlikView Publisher, QlikView Web Server.
• Implemented Star Schema & Snow Flake for Dimensional Data Modeling in QlikView and QlikSense.
• Expertise in Performance Tuning & Deployment of QlikView/QlikSense Applications.
• Build and customize Customer ad - hoc reports (Self Service) Qlikview applications.
• Implemented the 3-tier architecture (Data-Extraction, Data-Modeling and Application Development) as recommended in QlikView best practices guide.
• Created complex security rules in Qlikview/ QlikSense Management Console including hiding sheets, apps, objects for multiple users.
• Expertise in QlikView 11.2 S8/12.2, Qliksense 3.x, NPrinting, Qlik Geo Analytics connectors
• Did Automation for QlikView/QlikSense Projects with Cybermation jobs, QV EDX and batch files.
• Created PixelPerfect reports, Excel reports, PowerPoint reports and Word Reports using NPrinting tool and expertise in CIA reporting manager for generating reports from QlikView
• Strong Database experience in Oracle 9i, DB2, MS Access, SQL Server, Netezza.
• Customized extensions objects from Qlik Branch for QlikSense projects using D3/Java Script
• Solid hands-on experience in implementing new features of QlikSense like Storytelling, Beta Maps integrations, Pivot Table, KPI Object, PDF Printing etc.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Excellent communication, presentation and interpersonal skills, able to work on Onsite and Offshore co-ordination model.
• Provided implementation and ongoing support related to QlikView/QlikSense applications.
• Provided training sessions on the use of QlikView/QlikSense to analyze organizational data.
• 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.
• Designing and Developing Web forms using C#, ASP.Net 3.5, HTML, XML, LINQ, WCF, java script, Ajax Tool kit, silver light

TECHNICAL SKILLS:

Dash boarding/Analytics: Qlikview 10.x/11.X/12.x, QlikSense 2.x/3.x, Tableau 10

Databases: MS SQL Server 10.0/7.0/05/08/2012, Oracle 9

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

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

Exporting Tools: MS Reporting Services, Report Builder, CIA Reporting Manager, NPrinting 16.0

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

Database Modeling & Other Tools: SQL Compare, SQL Trace

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

PROFESSIONAL EXPERIENCE:

QlikView/ Qlik Sense Architect and Programmer

Confidential, Danville, PA

Responsibilities:

• Design and development of QlikView dashboards like Data Quality Audit, Daily Claims, Provide Analytics, Daily Membership, Pharmacy, Medical dashboards
• Developed Dashboards for Claims pending and High Dollar Claims
• Gained Expertise in designing and modeling in QlikView with complex multiple data sources relational designs.
• Developed in dashboard layout design and internal data mapping design and developed 3-Tier architecture application
• Designing the data models in QlikView/QlikSense to accommodate the application requirements.
• Designed Data Quality Audit dashboard with Summary, Failures and History tabs and Daily Membership with Dashboard Geo Analytics and Reporting tabs
• Developed SET ANALYSIS to provide custom functionality in QlikView/QlikSense applications.
• Generated OnDemand reports with the help of Nprinting November 17
• Used TOAD and SSMS to run SQL queries and validate the data in Data warehouse and Data Marts
• Perform error handling process, debugging and troubleshooting the applications.
• Created tasks and set dependencies using QlikView Publisher and Qlik Sense Streams.
• Worked Closely to the ETL team to build good data model and to solve data issues
• Experience in complete project life cycle including Documentation, Analysis, Development and Testing under Agile methodology.

Environment: QlikView 11.2, QlikView Publisher, QMC and QlikView Access Point, QlikSense3.2, SQL Server 2014, NPrinting,November 17, Windows Server 2012 R2, AWS, IE Plug-ins, MS Office 2010/13, QV Document Analyzer, Toad 12.1, Remedy, ServiceNow, TFS

QlikView Architect and Lead Programmer

Confidential, Wayne, PA

Responsibilities:

• Design and development of QlikView dashboards, scorecards, KPI and other reports using all the charts and GUI features available in QlikView.
• Developed Alignment Dashboards between PCP, Specialist, Hospital, SNF. And KPIs such as Cost, Utilization and Market share for Attributed/Non- Attributed Providers
• Developed Dashboards for Medicare/Medicaid Risk Analysis as HCC Category level and HCC - Group TIN Provider level.
• Gained Expertise in designing and modeling in QlikView with complex multiple data sources relational designs.
• Developed in dashboard layout design and internal data mapping design and developed 3-Tier architecture application
• Designing the data models in QlikView/QlikSense to accommodate the application requirements.
• Developed Macros for Default selections and export charts to PPT with data as behind the char worked with QlikView 21.x, SQL Server 2012.
• Developed SET ANALYSIS to provide custom functionality in QlikView/QlikSense applications.
• 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 Patient & Prescriber Alignment and Risk as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Extensively used QlikView Document Analyzer for tuning the existing documents
• Optimized QlikView dashboards and built QlikView extensions
• Worked Closely with BA and Clients to understand the requirements
• Worked Closely to the ETL team to build good data model and to solve data issues
• Experience in complete project life cycle including Documentation, Analysis, Development and Testing under Agile methodology.

Environment: QlikView Developer Tool, QlikView Publisher, QMC and QlikView Access Point, QlikSense2.x, SQL Server 2012, Oracle 11g, Cybermation, NPrinting, Windows Server 2012 R2, AWS, IE Plug-ins, MS Office 2010/13, QV Document Analyzer, Toad 12.1

Sr. QlikView/QlikSense Consultant/Onsite Lead

Confidential, PA

Responsibilities:

• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Involved in full project life cycle implementation (requirement gathering to production) of QlikView/ QlikSense dashboards.
• Developed executive dashboards in QlikView, delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Developed Macros for Default selections and export charts to PPT with data as behind the chart
• Developed load script using QlikView/ QlikSense Functions (Date and Time, Keep, Join, Apply Mapping, Triggers, Interval match etc...)
• Worked with QlikView 10.x, 11.x SQL Server, Oracle 11g, NPrinting, IE Plug-ins, Excel, flat files.
• Coordinating in implementing Qlikview and QlikSense environment
• Installed Qlikview / Qlik Sense / Nprinting on Desktop, DEV, UAT and PROD servers.
• Designed the QlikSense Governance and development cycle.
• Configured different QlikSense roles and attribute based access control
• Developing heated maps, Area Maps in QlikSense using idevio maps and Qlik maps.
• Hands on experience on the third-party extension QlikMaps. Created maps based on spider analysis, custom pop up which displays bar chart, etc. both in QlikView & QlikSense.
• Experience in setting up Server, Publisher configurations and Security authorization at different levels.
• 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.
• Extensively designed & Developed Start to End Automation for complete QlikView Project from ETL to QlikView Distribution
• Developed batch files to transfer files from Local server to AWS and validation process at AWS to publish document
• Extensively used QlikView Document Analyzer for tuning the existing documents
• Configured/Enabled IE Plug-ins on Server with Tunneling and without tunneling.
• Worked on DEV, UAT and PROD environments and successfully completed Production move
• Managed 10 members of offshore team to deliver multiple projects at a time under Agile Methodology
• Worked Closely with BA and Clients to understand the requirements
• Worked Closely to the ETL team to build good data model and to solve data issues
• Experience in complete project life cycle including Documentation, Analysis, Development and Testing.
• 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.
• Performed architecture, redesign of QlikView / QlikSense BI platform running 40+ dashboards that improving availability, scalability and performance to accommodate high volume data

Environment: QlikView 11.X, Qliksense 2.X, SQL Server, Oracle 11g, Cybermation, QMC, NPrinting, Windows Server 2012 R2, AWS, IE Plug-ins, MS Office 2010/13, QV Document Analyzer, Toad 12.1, D3, Java Script

Sr. QlikView Developer

Confidential, New York, NY

Responsibilities:

• Requirement Gathering from Customers, Visiting customer locations.
• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Extracted data from different systems transformed and integrated in the QlikView.
• Developed a standard/optimized theme which is further used across the system.
• Extensively used set analysis to calculate/aggregate the fact data as per the requirements.
• Developed QlikView Dashboards using Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Input Field, Table Box, Statistics Box etc.
• Done metadata management by implementing the governance Dashboard.
• Developing WTD, MTD, PTD, QTD, STD, YTD values for the customers
• Extensively done business user support, resolved various issues for accessing dashboard and enhanced the dashboard as per user needs.
• Designed and implemented the Incremental Load using QVDs.
• Extensively implemented section access for row, object, and column and sheet level security.
• Developed Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Extensively worked on performance (DB, Design and UI level) for fast response of the application/dashboard based on the end user selection.
• Migrated existing QlikView 11 SR5.0 dashboards to QlikView 11 SR 11.0 environment, also added new QV11 features to the Dashboards.
• Created Ad-Hoc Dynamic tabs for the users over the QV Documents.
• CIA Reporting Manager to generate Automation emails

Environment: Retail Marketing, SQL Server 2005/08/12, IBM DB2, Windows 2003/08/08R2 Servers, T-SQL, PL/SQL Developer Tool. Qlikview10, 11.x, MS Office 2010/2013, CIA Reporting Manager

Confidential, Chicago, IL

Qlikview Developer

Responsibilities:

• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Extensively used set analysis to calculate/aggregate the fact data as per the requirements.
• Resolved synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields.
• Done metadata management by implementing the governance Dashboard.
• Conducted various meetings and conferences with application teams to meet corporate milestones for dashboard design, planning issues met as well as testing and training.
• Designed and implemented the Incremental Load using QVDs.
• Extensively implemented section access for row, object, column and sheet level security.
• Generated/Developed Reports based on SSRS, Report Builder, Qlikview
• Participating in pre-sales activity working with prospective client and assisting with technical contributions to help my employer win new business.
• Ad hoc excel reports are created based on the business user requirements.

Environment: SQL Server 2005/08/12, Windows 2003/08/08R2 Servers, T-SQL, PL/SQL Developer Tool. SSIS, SSRS, Qlikview 11.x, MS Office 2010, Tableau

Confidential, Chicago, IL

Sr. SQL Server BI Developer\Qlikview Developer

Responsibilities:

• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Extracted data from different systems transformed and integrated in the QlikView.
• Designed the Data-Model using data from various sources like Oracle 10g Database and flat files.
• Developed a standard/optimized theme which is further used across the system.
• Conducted various meetings and conferences with application teams to meet corporate milestones for dashboard design, planning issues met as well as testing and training.
• Extensively worked on performance (DB, Design and UI level) for fast response of the application/dashboard based on the end user selection.
• Generated/Developed Reports based on SSRS, Report Builder, Qlikview
• Worked with Qlikview 11.x, SQL Server, Excel, CSV files.
• Developed few POCs on Tableau environment

Environment: SQL Server 2005/08/12, T-SQL, SSIS, SSRS, Qlikview 11.x, MS Office 2010, Tableau

Sr. SQL Server Developer/BI/SSIS/SSRS

Confidential, Jacksonville, FL

Responsibilities:

• Work with business users, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Gather user requirements, analyze and design solutions.
• Support production operation activities with focus on integration and development of new and existing products and services.
• Create/Update database objects like tables, views, stored procedures, function, and packages.
• Rigorously test the Stored Procedures, SSIS packages and SSRS reports; fix bugs.
• Involved in capacity planning, sizing and database growth projections.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments
• Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
• Reviewed DB Scripts from the development team before releasing them into the Production.

Environment: Windows 2003 Server, SQL Server 2005, SSIS, SSRS, T-SQL, PL/SQL, JavaScript, MS IIS Server 5.0, SOAP, HTML/DHTML, XML

SQL Server DBA/Developer

Confidential, Philadelphia, PA

Responsibilities:

• Involved in Data Migration from legacy to master tables 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.

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

Confidential, Peoria, IL

SQL Server DBA/Developer

Responsibilities:

• Creating and maintaining various databases for Production, Development and Testing use SQL Server 2005.
• Planning and scheduling backups and developing recovery procedures.
• Migration of data across different databases and different servers.
• Creating procedures, functions, and triggers, handling database performance and tuning.
• SQL Server Installation, patch application, migration of databases.
• Creation of new databases, planning the location of data, index, and Transaction log files on disks.
• Setting up backups for the Applications
• Providing support to the Application developers on the application databases.
• Handled 24/7 Production Issues.

Environment: MS Visual Studio 2005, SQL Server 2005, Windows 2003 Advance Server, Peregrine, CVS.

Software Engineer

Confidential, Jacksonville, FL

Responsibilities:

• Involved in creating Requirement Specification and the architecture of the solution
• 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.
• Have to use Ajax Controls for the Partial Page Refresh extensively.
• Troubleshooting the application in production environment without scarifying the uptime and services.
• Code Review, Unit testing, Debugging and Integration testing of the application. Also analyzed the business and design the screen flow of the application.
• Involved in to publishing & deploying the application. Creating end user documents.
• Involved in Developing ASP.NET Web Services using C#.NET as per the client requirements.

Environnent: C#, MS - SQL Server 2005, ASP. Net 3.5, IIS, ADO.Net 3.5, VSS, Visual Studio 2003/2008, Windows XP, Excel, MS Word

SQL Server DBA/Developer

Confidential

Responsibilities:

• Installation, configuration and maintenance of the MS SQL Server 2000.
• Migration of SQL server 6.5 to 7 and from SQL server 7 to 2000.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Administrative and Production support for various applications in all environments.

Environment: SQL Server 2000, SQL server 7, SQL server 6.5, T-SQL, Oracle PL/SQL, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data, TOAD.