SUMMARY:

• 10+ years of IT experience and 6+ years of experience in administering, developing and implementing Data Warehousing and Business Intelligence (BI) applications using reporting tools like QlikView and Cognos
• Thorough hands on design and implementation on Data Warehouse / Marts, QlikView/ QlikSense architecture
• Proficient in working on development environment in SQL Server 2012 / 2014 / 2016
• Worked with users to analyze business processes, understanding business requirements, product demonstration and product support as well as developing functional and technical design documents
• Expertise in developing Dashboards and Scorecards
• Strong experience in client interaction, understanding business applications, business data flow and relations
• An excellent team member with great inter - personal and communication skills, ability to adapt quickly to different situations as well as a team player

TECHNICAL SKILLS:

BI Tools: QlikView 10/11, QlikView Server/Publisher 10, Qlik Sense, Tableau, Business Objects, Crystal Reports, WebI, MS Excel, Cognos 8/10 BI Suite / ReportNet 1.1 / Framework Manager / PowerPlay / Transformer / Access Manager / Upfront / Scheduler / Scripting,

Database: MS SQL Server, Oracle 9i, 10i, 11g, MS Access, Modeling Transformer & Framework Manager

Languages: SQL, PL/SQL, Java, VB, HTML, DHTML, XML, JavaScript

OS: Windows XP/Vista/7/8/10, Windows 2000, Server 2003, Server 2008, Server 2012, Hadoop, Linux

PROFESSIONAL EXPERIENCE:

QlikView/ Qlik Sense Developer

Confidential, Princeton, NJ

Responsibilities:

• Updated existing QlikView layout, design elements and Confidential branding elements
• Designed and developed Qlik Sense application based on existing QlikView data model
• Used Javascript in macros to develop a Status Bar to show status of fields being exported to Excel to be analyzed by engagement partners
• Designed and extended existing QlikView / Qlik Sense dashboard to include Analysis, Reports and Engagement Summary module
• Increased performance in QlikView / Qlik Sense application by exporting complex calculations to views and stored procedures in the SQL Server database
• Coordinated with offshore developers and testing team to log and fix existing defects and enhancements
• Prepared documentation for future development references
• Used Qlik Sense Extension templates to further enhance layout presented in Requirements based on QlikView design
• Installed Qlik Sense Server and configured Qlik Management Console to manage licenses, content security and monitor system performance

QlikView Developer/ Sr. Pricing Analyst

Confidential, Pittsburgh, PA

• Created business discovery documents to understand the scope of the business
• Working with Business SMEs to analyze and document business requirements and functional specification.
• Designed and developed Dynamic Pricing Model (DPM) dashboard to analyze Target Prices (TP) and Floor Prices (FP) for each product in the every product line based on the specific regions in North America
• Coordinated with offshore team to deploy the DPM dashboard on tablet and manage SQL Server activities
• Worked with SAP BI team to analyze and identify data sources
• Prepared Mockups to understand the data and present sample visualizations to the Director and VP of Sales & Marketing
• Utilized NPrinting connection to QlikView to create adhoc reports to users for analysis
• Implemented Section Access in DPM dashboard and provide user access to DPM application in QlikView Access Point
• Schedule tasks in QlikView Server and Publisher to run dashboards on daily and biweekly basis

QlikView Lead/ Developer/ Admin

Confidential, Woodcliff Lake, NJ

• Leading a team of 5 QlikView developers ( 2 onshore developers, 3 offshore developers)
• Designed and developed extensive QlikView reports using combination of charts and tables using Set Analysis to provide the custom functionality in QlikView applications.
• Four dashboards were created, assisting other teams to create QlikView and Qlik Sense reports.
• Implemented security, published and deployed dashboards based on business requirements provided in the Business Requirements Document (BRD) and Product Requirement Document (PRD)
• Develop Test Cases and Scope Items for defect fixing when taking builds of dashboards.
• Utilize HP ALM Quality Center in defect management as well as tracking and giving the overall quality of the release at any stage of the development process.
• Organize Design Review Meeting (DRM) meetings to view and fix defects as well as assign status based on viewpoints of clients and developers involved.
• Prepare demo dashboards for clients using QlikView and Qlik Sense
• Creating scheduled jobs for QVD extracts and report reloads using QlikView Server, Publisher and NPrinting
• Coordinate with data sources such as SQL Server and Hadoop

QlikView Developer/ Admin

Confidential, Dodgeville, WI

• Define best practices for modeling design, development and migration for Business Partners as well as IT
• Partner with other technical (Operations) and consulting team to develop security standards for QlikView applications
• Participate in design plus code reviews of prototypes, and applications ready for production
• Develop a solution/framework for provisioning data for consumption by business users who create ad hoc QlikView applications
• Gather and analyze business requirements and desired features. Also, analyze and estimate feasibility, time, and efforts
• Design & Develop Enterprise wide QlikView Application
• Act as the QlikView subject matter expert and assist business clients with complex technical challenges and optimize QlikView script files for performance
• Advanced scripting involving Set Analysis and integrate data from multiple data sources (CSV files, Excel files, Db2 databases, etc.) into a QlikView Data Model
• Involved in migration from QlikView 8.5 to QlikView 10 and now to QlikView 11
• Write and maintain documentation to describe program development, logic, coding, testing, changes, and corrections plus the description of installation and operating procedures
• Create test scenarios and run tests to find errors and confirm program meets specifications. Also, consult with clients to prototype, refine, test, and debug programs to attain client approval
• Analyze, assist installs, and test upgrades of internally and externally developed application programs
• Provides technical assistance by responding to inquiries regarding errors, problems, or questions with program. Monitor performance of programs after implementation
• Was actively in the Server migration and the fresh QlikView Installation process.
• Automated the QlikView jobs and define the user security and data reduction using QlikView Server/Publisher
• Generate, schedule, and distribute customized reports using NPrinting
• Used web analytics tools such as Google Analytics, Omniture and Piwik
• Task set up are done using QMC and created architecture for the interdependent applications and execute in proper order.

QlikView Developer

Confidential, Santa Clara, CA

• Developing the QlikView Data Models and creating QVWs for upper management
• Developed load Scripts with Sopheon to be integrated into database
• Created Dashboards style of reports using QlikView components Implemented Security & involved in Deployment of QlikView Applications
• Design, Build, Test, Debug the QlikView application in QV Test server environment
• Involved in deployment, monitoring, troubleshooting QlikView applications
• Trained Confidential users effectively to use the reporting tool, to build and customize their ad-hoc reports
• Provided support for custom Sopheon Accolade PLC software provided for Confidential
• Resolved assigned issues by users such as access issues, plugin issues, and users unable to view projects or files
• Communicate with companies such as Sopheon and QlikView regarding product bugs
• Load and validate data into Accolade database to be used for dashboards
• Produced support plans and contingency documents in event of application failures

QlikView Developer

Confidential, Cranbury, NJ

• Gathering data sources like QVD files, Excel, ERP, and Oracle in developing the QlikView Data Models
• Created QlikView files updated on timely basis as database updates
• Developing Scripts while loading the data, resolving issues in scripts
• Developed QlikView Functions and Reports as business needs
• Writing SQL Scripts to load the relevant Data in QlikView Applications
• Implemented Security & involved in Deployment of QlikView Applications
• Performance tuning by analyzing and comparing database applications
• Design, Build, Test, Debug the QlikView application in QlikView Test server environment.
• Coordinate with data sources such as SQL Server and Oracle using PL/SQL
• Involved in deployment, monitoring, troubleshooting QlikView applications
• Trained the Confidential users effectively to use the reporting tool, to build and customize their ad-hoc reports

QlikView Developer

Confidential, Warner Robins, GA

• Gathering and analyzing Business requirements
• Developed and maintained Reporting tools across multiple data sources
• Identified data sources and prepared data for QlikView applications
• Provided implementation and ongoing support related to QlikView
• Assisted in transition from QlikView 9 to QlikView 10
• Involved in distributing dashboard reports to users
• Documented functional and technical design specification and user guides

Business Intelligence Consultant

Confidential, City of Industry, CA

• Catalogs creation and modification.
• Created Drill-Through Reports to provide users with more detailed information
• Provided Confidential user training on application level and provided production system support
• Created daily, weekly, monthly, and quarterly reports for the management team and field operation managers

Business Intelligence Developer

Confidential, Byron, GA

• Gathered Business Process Requirements from business users, for the reports to be developed
• Developed a technical specifications by analyzing the business
• Trained users to access their corresponding reports
• Developed various reports including simple lists, cross tabs, charts and complex reports
• Developed Dashboards and creating reports
• Tested the data model and relationships
• Moving/deploying reports from Development to testing and production servers
• Created views and tables in Oracle Server database as a requirement for some reports
• Involved in Unit Testing