SUMMARY:

• Around 6+ years as an IT professional and more than 4 years of Qlik Sense, Qlikview and SSIS with extensive experience developing Qlikview and Qlik Sense applications, ETL design, database development, designing data modeling, data warehouse, requirements analysis and data conversions.

TECHNICAL SKILLS:

QlikView Tools: Qlik Sense, QlikView, Publisher, Enterprise Management Console, Management Console, QV Ajax Client, QV IE Plug - In.

Other Tools: SSIS, Cognos, Visio, SQL Developer, SQL Tools, Altyrex, Informatica, Automate MS Office.

Databases: Oracle 11g/10g, SQL Server 2005/2008, Big Data, Teradata, MS Access.

Languages: SQL, PL/SQL, VB-Script, C

Operating Systems: Windows 2005/2008/XP.

Web Applications: IIS 6/7, Web Logic 8.

PROFESSIONAL EXPERIENCE:

Confidential, Westlake, TX

Sr. Qlik Sense Consultant

Responsibilities:

• Involved in the requirements Gathering and Understand ing the end- user business requirements and develop creative and visually effective user interfaces for Dashboards, Analytics and Reporting.
• Building the Qlik Sense dashboards and data modelling.
• Analyzed the existing Qlik Sense QlikView data model, script logics and the ETL business logic for the existing QlikView applications and optimizing them.
• Installing, configuring and upgrading the Qlik Sense multi node clustered environment.
• Built the SSIS reports
• Experience in SSIS designer.
• Developed User Interactive Sheets & Reports as business needs. Writing SQL Scripts to load the relevant Data in Qlik Sense Applications.
• Extracted data Using SSIS and transformed & loaded into Qlik Sense.
• Responsible for the QlikView Dashboard & Report development, which includes dashboard design /QlikView Script writing - connecting with varied sources (flat file/Oracle etc.), data cleansing, data analysis etc.
• Expert in Qlik Sense Management console.
• Worked on Qlik Sense App development, templates, story generation, data modeling and Qlik Sense app performance optimization.
• Configured different Qlik Sense roles and attributes based access control and designed the Qlik Sense Governance and development cycle.
• Designed and developed a wide variety of charts and associated sheet objects to satisfy complex business requirements.
• Creating a relevant data model and front end to satiate the Qlikview requirements
• Educated different user groups and peers with Qlik functionality.
• Have done the integration of project with the existing applications and used the Qlikview 11 features (Giving the users option to pick the Dimensions and Metrics).
• Implementing Security and Incremental Loading in Qlik Dashboards
• Monitoring the defects with HPQC and interacting with users to solve the issues.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Provided Production support to the existing qlikview applications.
• Designed and developed user manuals, product documentation using technical skills.
• Direct interaction with business analysts and managers on daily basis.

Environment: QlikSense Nov 2017,3.x,2.x, Qlikview (12,11),SSIS, Microsoft SQL Server, SAP BW, SFDC,HPQC,BMC Remedy, MS- Access, Excel Spreadsheets, SharePoint, Subversion Qlikview Server, SSIS, Windows Server/XP/2003.

Qlikview Consultant

Responsibilities:

• Developed QlikView dashboard applications.
• Designed and developed a wide variety of charts and associated sheet objects to satisfy complex business requirements.
• Designed Graphical User Interface with Qlikview Extension objects according to requirement.
• Qlikview Data Modelling.
• Qlikview and Qlik Sense Development
• Created the report datasets in SSIS.
• Created a navigational system that utilized QV hierarchy that used weights to identify values.
• Worked on enhancements and Performance tuning of existing Apps.
• Implemented Security & involved in Deployment of QlikView Applications.
• Back traced data to make sure it works cohesively as well as accurately by looking for discrepancies such as duplicates, rescinded information etc...
• Was given the task to define major KPI so analyzed, brainstormed the needs of the company and created a trigger system that alerted higher ups in problems with any unit of measure they are measuring or would fall under their jurisdiction to know the status of.
• Wrote Complex set analysis statements.
• Used SQL Server Management Studio, TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Code review as well as fine tuning of applications as well as fixing data model.
• Scheduled tasks in server and Troubleshooted application in access point as well provided maintenance.
• Dealt directly with CEO, CFO as well as all managers on day to day basis to create an effective system and that tailored to each person moreover primarily focused on CEO needs.
• Coordinated with offshore team in India on daily basis.
• Educated different user groups and peers with QlikView functionality.

Environment: Qlik View 11.0 SR3,SSIS, Windows Server 2003, Oracle 11g, MS Access 2005, MS SQL Server 2008, MS Office.

BI Consultant/SQL Developer

Responsibilities:

• Analyzed and reviewed Business Requirement and Specification documents.
• Coordinated with business team to provide and receive feedbacks on the business requirements.
• Created Functional Design documents, and hold the reviews with business and IT team.
• Created SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) and .NET data access components
• Implemented business logic as .NET Framework assemblies (C#, VB.NET)
• Envisioned and built front-end for the site written in MS Visual Studio .NET, VB.NET, XML, VBScript, HTML, DHTML.
• Performed business and system analysis, designed application and database structure, converted existing data into SQL Server using Data Transformation Services (DTS) and VBScript.
• Individually designed MS SQL Server 2000 database, coded stored procedures (T-SQL).
• Coded ASP in MS Visual InterDev 6.0 using VBScript, JavaScript, HTML/DHTML/CSS, XML and ADO.
• Created components in MS Visual Basic 6.0, used CDO and Outlook 2000 for messaging.
• Deployed the solution, participated in testing and documenting.

Environment: Sql server 2000, Microsoft Visio, Oracle 10g