SUMMARY:

• 8 years of IT industry experience in all aspects of analysis, design, testing, development and implementation of client/server applications. Experience covers all aspects of business Intelligence applications with strong background in developing a QlikView Dashboards and SQL
• Certified Data architect in QlikView and QlikSense.
• Certified Administrator in QlikView and QlikSense.
• 7+ years of experience in Designing and development of business Intelligence application with QlikView 9.x to 12.10 .
• Goal oriented, experience in mentoring the colleagues, team player with strong analytical and excellent communication skills.
• Experience in Requirement gathering, analyzing, and documenting business requirements and data specifications.
• Ability to offer end - to-end solutions starting from requirements gathering, design, development and deployment of Business Intelligence applications. Experienced with Agile Development methodology in providing quick analysis and visualizations for business users.
• Experience in connecting to databases using ODBC and OLEDB connection strings.
• Experience in extracting Data from different sources like DB2, Oracle, SQL Server, Teradata with QlikView.
• Experience in QlikView server installation, upgradation and configuring for the business needs.
• Experience with Creating QVD’s and Scheduled jobs for QVD extracts and report loads.
• Well versed with QlikView Schemas like Star and Snowflake Schemas and loading techniques Incremental, Buffer, Preceding, and Binary loads.
• Strong experience in writing functions and sub routines in QlikView.
• Experience in creating scripts to resolve circular loops, Synthetic keys and Modeling issues in QlikView.
• Experience in publishing the reports and scheduling the publisher tasks.
• Extensive knowledge in Sheet objects, Charts, exporting the reports to MS-Excel, handling the variables and aggregated functions of QlikView.
• Expertise in using QEMC and QMC for creating the tasks, managing the schedules and triggers.
• Expertise in reducing the complexity using different methods like using Macros, Set Analysis, Joins, Keep’s and Mappings using QlikView.
• Extensively used set analysis expressions to develop different KPI’s like MTD, QTD, YTD, etc.., over accountable zones and time periods.
• Experience and good understanding of data warehousing concepts, ETL, Cubes and normalizations to translate business requirements into effective business intelligence solutions.
• Experience in providing support and maintenance to the QlikView applications developed.
• Experience in writing SQL queries, Functions, Views and Stored procedures.

TECHNICAL SKILLS:

Operating System: Windows server 2008/2012, Windows 7 Enterprise, windows 10

Programming Languages: C, C++, .NET, SQL and PL/SQL, Go (Beginner).

RDBMS: Oracle 11g/10g, SQL Server 2012/2014/2016

Other: Jira, Autosys, ControlM, SSIS, SSRS, Service Now

Development Tools: Sql server 2008/2012/2016 , SQL server data tools, Oracle Databases, MS-Access Database, QlikView 11.2/12.0, QlikSense 3.0, SAP R3, SSIS, SSRS

PROFESSIONAL EXPERIENCE:

QlikView Architect and Administrator

Confidential

Responsibilities:

• As per the growing number of user of QlikView in US region for QlikView reports, we are requested to Setup a QlikView platform on cloud server for the US region which consists of 3 different environments, Development, UAT and Production environments and cluster the servers wherever is required.
• Apart from this, we are also requested to migrate the existing applications from older version of QlikView to newer version, automate them by scheduling jobs on server and publishing the applications to users.
• Liquidity team is supposed to submit the everyday reports to Federal Bank for which they required an automated process of generating the reports.
• The application is used by the executives at the level of CX0.
• The application consists of macro’s, automated generation of PDF reports, section access for security, and uses different sources of data like Database, excel flat files, Qvd’s, csv and txt files.
• Human Resource team wants to have a global view of the number of employees based on regions and departments.
• This application consists of highly confidential data and hence uses multilevel Data Security features.
• This information will be used to take decisions that help organization expand its operations wherever required.
• The main users include the executives typically at the level of CXO and HR team which is located globally.
• This application is used internally to understand the positions where company stands with its investments and Overnight repo and reverse repo values and this gives information about whether the company has passed the stress tests for that Day.
• This makes life a lot easier for the internal teams to make decisions.
• This application is used internally to track the performance of vendors and to assess the risk associated with them.
• We get the data from Dun & Bradstreet and based on this data and the questionnaire answered by the third parties will be put together to assess the risk associated with them.

Confidential, New Jersey, NJ

QlikView Developer

Responsibilities:

• Involved in requirements gathering sessions with business users to prepare functional requirements
• Worked on the documentation for application development.
• Generated ODBC Connections to extract from data bases and store them in QVDs.
• Extracted data from multiple data sources (SQL Server, Excel) and designed data model.
• Implemented Star Schema and Snow Flake schema in designing the data model.
• Used Link Tables to avoid circular reference and Loop issues.
• XML external report request, Excel report, on demand report, HTML report using NPrinting.
• Developed Dashboards using different QlikView Objects Line Chart, Bar Chart, Gauge Chart, Pie Chart, List box, Multi box, Table Box, Container etc.
• Worked with Alternate States to distinguish the selections for different charts with in a sheet. 
• Implemented Security involved in Deployment of QlikView Applications.
• Extensively implemented advanced SET Analysis for aggregation calculations.
• Automated and Scheduled data loads and Dashboard Applications weekly and Notifications by email to assigned users using Server.
• Modified Existing Login page to Access point to Client Specific Login Page. 
• Responsible for the performance and tuning of the application, including performing maintenance upgrades on applications programs and systems as required.
• Converted Excel and crystal reports to QlikView dashboards.
• Experience in reporting activities which involved Business score card, sales and operations report.
• Coordinated with Business users in development process to integrate with the Test and Production Servers and helped creating use cases.
• Involved in User Training Sessions and Preparing Documentation.
• Involved in Production Support for QlikView applications Server. 

Environment: QlikView 10, SQL Server 2008, SQL, HTML, Excel, CSV Files, Publisher.

Confidential

QlikView Developer and Administrator

Responsibilities:

• Involved in Requirement gathering, analyzing, and documenting business requirements and data specifications.
• Mainly designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Understanding source systems and Designing Data Modeling and Loading data from Multiple Data sources.
• Designed and developed User interface and QlikView reports using combination of charts and tables.
• Implemented advanced visualization techniques like Alternate states to generate reports on ad-hoc basis and for comparison purposes.
• Developing Set Analysis to provide the custom functionality in QlikView Applications.
• Imported data from different sources like Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Created link tables on the needed basis and as per the data.
• Created Master Calendar and worked with date fields as per the user needs.
• Applied mapping function to look up and fetch the required field.
• Used advanced scripting, set analysis, advanced aggregation functions and advanced charts for applications.
• Creating complex expressions for dynamic aggregation and Actions and triggers, Document Chaining & linking experience.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Developed link tables, & incremental loading on the needed basis.
• Published dashboards on Access point. Deployed QVW's on the production server, Created Reload and Distribution tasks on QlikView Server/publisher.
• Extensively implemented section access for row, object, column and sheet level security.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point and administered Security using Active Directory.
• Wrote SQL Scripts to load relevant data in QlikView Applications.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.
• Establishing QlikView Environment setup, configuration and Implementation with the BI Support Teams.

Environment: QlikView 9/10/11.20, QlikView Server and Publisher, Oracle, SQL Server, Informatica Power Center, PL/SQL Developer, SQL Loader and UNIX.