SUMMARY

• 20 years plus of IT experience in system analysis, design, development and administration of software applications and 11 years in the field of ETL methodologies, business intelligence and data Warehousing principles and architectures including concepts, designs and usage of data warehouse.
• 6 Years’ experience in Qlikview and Qliksense technologies, strong knowledge in all phases of Software Development Life Cycle (SDLC) developing, testing, Migrating, Administrating, security management and production support.
• Solidunderstandingof Data Warehousing concepts.Strong experience in design & development ofBusiness Intelligence / Data warehousereporting.
• Efficient in Optimizing, Debugging and testingSQL queries.
• Experience in using different databases likeOracle12i, MS SQL Server, DB2 and MS Access.
• Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).
• Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building qvd’s and qvw’s.
• Experience in setting up server, publisher configurations and security/authorization at different levels.
• Strong understanding of Dimensional Modeling technique, Multi - Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in QlikView and DW concepts.
• Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.
• Expertise knowledge in Set Analysis, Advanced aggregations, synthetic keys and circular references
• Extensively worked on QlikView designer objects like straight/Pivot tables, Containers, line charts, bar charts and pivot tables Etc.

PROFESSIONAL EXPERIENCE

Lead Qlikview & Qliksense Consultant

Confidential, Columbus, OH

Responsibilities:

• Interacted with customers to gather business requirements and developed functional and technical specification document
• Hands on experience in Installing and configuring Qlik sense/ Qlikview Server and Publisher
• Provide troubleshooting and diagnostic supportat L2 / L3 level for these technologies
• Extracted data from the database, stored into QVD files, and wrote load scripts
• Provide administrative services
• Experience in User License management
• Incident, problem and service outage management
• Gathering requirements from project teams covering areas such as capacity, users, data
• Data Source Configuration and Maintenance
• Document and maintain work - instructions
• Maintaining Server Logs, Qlikview/Qlik Sense Server Backup
• Backup, data recovery and service restoration management
• Collaborate with L3 on patch and bug fix deployment
• Identify and raise system capacity related issues (storage, licenses, performance threshold)
• Server Performance, capacity, utilization monitoring and Health monitoring
• Optimization and Performance tuning of Qlikview/Qlik Sense applications
• Define best practices for Qlik deployment and create reusable templates
• Manage security for all Qlik applications
• Participate in overall architecture and strategy for the deployment of Qlik suite of products.
• Research and recommend alternative actions for problem resolution based on best practices and application

Environment: Qlik Sense 3.1 SR4, Qlikview 11.20 SR12, NPrinting 16.5 SQL Server, Amazon Red Shift, Oracle 12i

Lead Qlikview Consultant

Confidential, Raleigh, NC

Responsibilities:

• Interacted with customers to gather business requirements and developed functional and technical specification document
• Analyzed dashboards in the presentation layer, gather understanding of the data model using table viewer and system fields.
• Developed a systems architecture forQlikViewimplementation identifying the data sources and target reports match
• Participated and proposed new business analysis for data which has no prior reports
• Extracted data from the database, stored into QVD files, and wrote load scripts
• Eliminated Synthetic keys, ambiguous relationships and closed loops. Designed proficient dashboards according to the requirements.
• Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Connected to different ODBC, OLE DB data sources (Teradata 13.0) and flat files to create and schedule different complex reports
• Eliminated Synthetic keys, ambiguous relationships and closed loops
• Designed proficient dashboards according to the requirements
• Configured QlikView Server /Publisher. Scheduled jobs, & security.
• Implemented QlikView desktop and publisher, managed user authentication, established publisher tasks, streamlined loading procedures and reviewed log.
• Enhanced existing dashboards with new functionalities and tuned ETL scripts for better performance.

Environment: QlikView 11.2SR9/10X, Teradata 13.0, Toad, SharePoint

Lead Qlikview Consultant

Confidential, Phoenix, AZ

Responsibilities:

• Interacted with customers to gather business requirements and developed functional and technical specification document
• Analyzed dashboards in the presentation layer, gather understanding of the data model using table viewer and system fields.
• Developed a systems architecture forQlikViewimplementation identifying the data sources and target reports match
• Participated and proposed new business analysis for data which has no prior reports
• Extracted data from the database, stored into QVD files, and wrote load scripts
• Eliminated Synthetic keys, ambiguous relationships and closed loops. Designed proficient dashboards according to the requirements.
• Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports
• Eliminated Synthetic keys, ambiguous relationships and closed loops
• Designed proficient dashboards according to the requirements
• Established a secure environment using QlikView Section Access.
• Configured QlikView Server /Publisher. Scheduled jobs, & security.
• Implemented QlikView desktop and publisher, managed user authentication, established publisher tasks, streamlined loading procedures and reviewed log.
• Enhanced existing dashboards with new functionalities and tuned ETL scripts for better performance.
• Provided training and supported client - in house business users

Environment: QlikView 11.2SR9/10X, Microsoft Access, Oracle, SQL server, Toad, SQL Developer, SharePoint.