SUMMARY:

• 8+ Years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing /Decision Support Systems and Business Intelligence.
• 4+ Years of experience with QlikView Applications and Dashboard development.
• Expertise in designing and modeling of QlikView with complex multiple data sources (SQL, Flat Files, Excel and Access,) relational designs.
• Experience with QlikView sheet objects including Pivot, List, Multi box, multiple charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Experience in optimizing applications by using QVD’s, removing non key fields and script variables (Loading phase).
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView/Qlik Sense BI.
• Proficient in migrating reports from different platforms (such as Excel, Actuate, SQR, Crystal reports) to Qlikview.
• Proficient in implementing Business needs and Batch process in backend using Stored Proc and Functions.
• Experience in Oracle 10g/9i/8i/8.x, PL/SQL, SQL, TOAD, Stored Procedures, Functions, Triggers, SQL Server 7/2000.
• Excellent logical, analytical & debugging skills.
• Possesses good leadership qualities, good Interpersonal skills, team - working attitude, takes initiatives and very proactive in solving problems and providing best solutions.
• Strong understanding in creating Dashboards, scoreboards for the required KPI’s in QlikView.
• Developed load scripts to work with multiple data sources (SQL, DB2, AS400, Excel, and Share point site).
• Developed production-grade QlikView reports and dashboard to meet business requirements in timely manner.
• Designed an applications for to support the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multi-boxes, slider, current selections box, buttons, charts, text objects, bookmarks.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher
• Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0 versions. Did end to end Unit Testing when migrating the applications.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT, Manufacturing, Purchasing and Finance QlikView applications.
• Wrote SQL Scripts, procedures and views which are required for QlikView projects.
• Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Schedule QVW reloads on server and troubleshoot errors and failures.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Mainly designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Worked on dashboards related to Sales Analysis, Production over time and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.
• Testing dashboards and data validation.

PROFESSIONAL EXPERIENCE:

Operating Systems:  Windows XP/7/8, Linux, Unix

Web Technologies:  HTML

Languages:  C, C++, R, Python

Database:  MySQL, ORACLE 9i/10g/11g, SQL Server 2005/2008/2012 , MongoDB, MS Access

Business Intelligence:  QlikView Desktop (10/11/11.2), Tableau, Microsoft SSRS

Other Tools:  TM1, Microsoft Office Suite, Macromedia Dreamweaver, Unified Modeling Language (UML), GIMP, Adobe Photoshop, Adobe creative suite CS6.

PROFESSIONAL EXPERIENCE:

Confidential, Morristown, NJ

Sr. QlikView/QliksenseAdmin/Developer

Responsibilities:

• Collecting functional and reporting requirements from application stake holders.
• Developed applications in the desktop as well as in the Qlik Sense Hub and shared the apps with the team through Qlik sense Cloud. 
• Facilitating and setting up QlikView environment.
• Designing the data model in QlikView to oblige the application necessities.
• Dealing with composing complex Scripts to load Data in QlikView Applications.
• Designed a road-map to successfully run the existing reports while data base migration.
• Setting up and managing security using Active Directory.  
• Responsible for gathering requirements, business and technical rules, implementing QlikView and Qlik Sense applications
• Created Dashboards style of reports using QlikView and Qlik Sense components like List Box, Slider, Buttons, Charts and Bookmarks.
• Good knowledge of deploying Qlik Sense dashboards on the Qlik Sense Server.
• Involved in performance tuning of various QlikView and Qlik Sense applications. A master calendar was used for time related dimensions and a strong source control methodology was used for tracking changes
• Timely Monitored QEMC to avoid load fails.
• Monitored and enabled logging to analyze logs after every service restart.
• Integrating data in to data marts for efficient development.
• Performed testing of dashboards for functionality, data and performance.
• Provided training sessions on the use of QlikView to analyze organizational data.
• Involved in the requirements gathering, analyzing, reporting and documenting business requirements and data specifications with International business teams.
• Extended help to troubleshoot and resolve QlikView Script errors, fixed data issues on production dashboards and ongoing consultation to the development team.
• Published dashboards on Access point. Deployed QVW's on the production server, Created reload and distribution tasks on QlikView Server/publisher.
• Scheduling and managing Qlik Sense jobs using Qlik Sense Scheduler for Qlik Sense application dashboards.  
• Managed Named CALs, Document CALs, Session CALs and Usage CALs for different users.
• Created template as per User preferences for developing advanced QlikView reports.
• Installed QlikView Server (11.2 SR3).
• Developing SQL Scripts to load the relevant Data in both QlikView and Qlik Sense Applications. 
• Upgraded service release from SR3 TO SR12.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point for distribution and administered Security using Active Directory. 
• Good Knowledge and Expertise in Qlik Sense. Developed dashboards in Qlik Sense to replicate existing QlikView Dashboards/reports. 
• Experience on IIS Server services for TM1Connect.
• Involved in configuring of TM1Connect (ETL) to export budgets for QlikView.
• Migrated TM1 environment to new servers.
• Performed QlikView to Qlik Sense Migrations by loading the script from the QlikView workbooks to QlikSense. 

  • Utilized Qlik Sense Scalability tools to create execute and analyze of load and performance tests. 

• Communicated with IBM for several requirements in process of TM1 migration.
• Manage analyze and resolve trouble tickets via Service management tool 
• Install and support a variety of software and hardware issues.
• Install, configure, map network drives, trouble shoot and backup
• Provided documentation for all the existing dashboards for future reference.
• Support Citrix user setups
• Migrated to Qliksense, maintenance of server

Environment: QlikView 11.20 SR12, ERP System(Cost Point), SQL Server 2008 R2 Service Pack 2, SharePoint, MS Excel, Windows Server 2012,TM1Connect 10.2.2, IIS Server.

Confidential, Nashville, TN

Sr. QlikView/QlikSense Developer

Responsibilities:

• Involved in full project life cycle implementation (requirement gathering to production) of QlikView dashboards.
• Created and developed SET ANALYSIS to provide custom functionalities in QlikView Applications.
• Developing trend analysis reports using complex graphs for study of data quality patterns.
• Worked on large scale and data volume based applications. Worked on VBA Macros
• QlikView and Qlik Sense Data Modelling by building the Star schema and resolving loops/synthetic keys. 
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions.
• Collaborated with Business clients and cross practical groups to create Business Requirement Documents (BRD), characterized KPIs (Key Performance Indicators), and recognize data sources.
• Dashboards were served to track administrations and administration request data and to screen different KPIs.
• Dashboards included client point of interest drilldowns, limit gages and alarming components.
• Developed official dashboards in QlikView conveyed through the web, empowering to gauge the execution of the business with systematic abilities.
• Analyzed and short listed Critical universes and reports which can be migrated to QlikView and Qliksense 
• Worked with QlikView, SQL Server, Oracle, SAP, Excel, level documents.
• There will 9 million records with 200,000/Month new records coming into framework.
• Understanding Business objectives and accordingly developing reports that substantiates the data captured.
• Business destinations and creating reports.
• Expert in Installing, configuring and upgrading the Qlik Sense multi node clustered environment. 
• Dashboards were served to track services and service order information as well as to monitor various KPIs.
• Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Expertise in using advanced scripting, set analysis, advanced aggregation functions and advanced charts for applications.
• Extract, transform and load data from multiple sources into QlikView and Qlik Sense applications. 
• Design, Develop, Test, debug and implement Qlik Sense Applications based upon specified requirement. 
• Worked with QlikView, SQL Server, Oracle, SAP, Excel, flat files.

Environment: QlikView12, Qlik Sense, SQL Server 2012, Excel, SAP, QlikView 11.

Confidential, Hartford, CT

QlikView Developer

Responsibilities:

• Developed dashboards pertaining to Revenue and Sales monitoring.
• Managed and distributed application using QlikView Publisher.
• Managed the QlikView Server tasks: developing tasks, assigning license, creating user groups etc.
• Participated in QlikView server migration from one physical server to another.
• Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.
• Performed analysis, documentation, for calculation for various attributes.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Promoting dashboards to production environment and manage user access.
• Involved in Requirement gathering & designing QlikView applications.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Developed Custom DATE Calendar Object and Linked with in the Model.
• Strong Experience in Working with Charts ( Table Box, Pivot, Straight, Pie, Line Gauge, Trillies)
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• Developed User Interactive Sheets & Reports as business needs.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Implemented Security & involved in Deployment of QlikView Applications.
• Created QVD’s & updated on timely basis as database updates.
• Sound skills in developing hide/Show Objects based on Condition & Triggers.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Experience with building applications using SAP BW.

Environment: QlikView 11.0/10.0, SAP BW, Teradata, SQL Server 2008, Oracle 10g, Access, .CSVFiles, Windows 2003 Server.

Confidential, Omaha, NE

QlikView Developer

Responsibilities:

• Working with the management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business
• Assembled monthly report of all capital expenditures for management.
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Setting access permissions and assigning CALs based on users.
• Schedule QVW reloads on server and troubleshoot errors and failures.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Mainly designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Worked on dashboards related to Sales Analysis, Production over time,and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.
• Testing dashboards and data validation.
• Used advanced scripting, set analysis and VBScript, advanced aggregation functions and advanced charts for applications.
• Designed QVWs to generate QVDs for faster and efficient data reloads.
• Trained Qlikview developers and users on best practices and general “how to” procedures.
• Designed Master Calendar.
• Implemented security using QlikView‘s section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Provided ongoing QlikView consultation to the development team.
• Helped company to do a complete inventory of all assets prior to going public.

Environment: QlikView 10.0, Oracle10g, Sql, Oracle 10g, Netezza, SQL Server2008

Confidential

SQL Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Generates the report into Excel Spreadsheet form from SQL server 6.5/7.0/2000.

Environment: SQL Server 2000, T-SQL, Enterprise Manager, C#, Query Analyzer, Windows 2000 Server, MS Office 2000, Crystal Reports 7.5,VB