Chaitanya - Sr. QlikView Consultant, Data Analyst - Resume - Available on C2C

Chaitanya

Sr. QlikView Consultant/Data Analyst

Ph: 630-449-7840 / Ajay@neoprisminc.com                                         

                                                                                  

Summary:

• 8+ years of experience in architecture, development, and deployment of information delivery systems with extensive focus on DataWarehouse/Business Intelligence using QlikView 11.x/10.x/9.x, Qlik Sense, Business Objects, MS BI etc.
• Domain experience includes Publishing, Pharmaceutical, Healthcare, Manufacturing, Technology and Banking.
• Hands on experience in implementing the new features of Qlik Sense like Pivot table, KPI Object, PDF Printing etc.
• 4+ years of extensive experience in Full Life Cycle Development including Analysis, Design, Implementation and Maintenance of different analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).
• Implemented the 3-tier architecture (Data-Extraction, Data-Modeling and Application Development) as recommended in QlikView best practices guide.
• Performed POC on Qlik Sense to generate immediate analyses and insights for reporting from mobile platform.
• Expertise in working with diverse business users to understand the requirements and develop a robust data model that will support the current requirements and future business growth utilizing Agile Methodology.
• Good experience in performing detailed data analysis/data profiling (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).
• Ensured a focus on data quality by developing data standards such as a common business vocabulary, naming conventions, data standards and transformation rules.
• Strong Knowledge in designing and developing Data marts, Data Warehouse using Multi-dimensional models such as Snow Flake and Star Schema.
• Expertise in designing efficient Data-Models from multiple data sources and QlikView scripting.
• Proficient in design and development of various Dashboards using chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box, Containers and Calendar & Date Island
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Experience embedding QlikView applications into host applications using QlikView OCX Control.
• Implemented data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects to accommodate KPI’s into Dashboards.
• Expertise in customizing Dashboards/Reports using Java, JavaScript, jQuery APIs, Web Services and third party plugins.
• Good at performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• Strong Database development experience in writing functions, packages, procedures, triggers and views in PL/SQL.
• Strong Database experience in Oracle, DB2, MS Access, Teradata, SQL Server, Netezza.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Strong Communication, Organizational and Interpersonal Competencies along with Detail-oriented and problem solving skills in the technology arena.
•     Developed different apps for Qlikmap (Points and Polygon), Extension objects to let the user to explore best features in Qlik Sense and to compare with QlikView.
•  

Technical Skills:

Analytics/ Reporting	QlikView 9/10/11.0/11.2, Qlik Sense, Business Objects, SSRS
DBMS/Tools	Oracle, SQL Server, DB2, Teradata, Netezaa, MS Access; Toad, DataStudio, RapidSQL
ETL Tools	SSIS, DataStage, Informatica
Languages	SQL, PL/SQL, HTML, XML, Java Script
Change Management	JIRA, SVN, Autosys, SharePoint
Operating systems	Windows7/XP/Vista, Windows 2003/2008 Server, Linux, UNIX.