Developed load scripts to work with multiple data sources (SQL, DB2, AS400, Excel, and Share point site).Strong understanding in creating Dashboards, scoreboards for the required KPI’s in QlikView.Analyzed the reporting requirements with the business users and came up with the technical specifications.Extensively worked to confirm and clarify requirements and business logic.Scripting/Language: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML Continually provided value added services to the clients through thoughtful experience and excellent communication skills.ĮTL Tools: QlikView (12.0/11.20 SR3, 11 SR1, 10 SR4), QlikView Management Console, Tableau (9.x 8.x / 7.x), Informatics Power Mart 4.5.2, 4.7.3 and 5.1.1, Power Center 1.7 and 5.1.2.ĭatabase Technologies/RDBMS: Oracle 9i/10g/11g, SQL Server, Teradata, MySQL, DB2, SSIS, Teradata,PL/SQLĭocumenting and Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio, MS Project, MS Office(Word/ Excel/ Access/ Power Point), SharePoint, Documentum. Excellent work ethics, self-motivated, quick learner and team oriented.Good in validating (Tracebility Matrix, Design Indexes) the BI reports/dashboards.Collaborate with Agile Team and business stakeholders to ensure quality and value of Agile Team deliverables.
As a key member of Agile Team actively participate in user story Backlog Grooming, Sprint Planning, Retrospective and other ceremonies. Extensively involved in Reverse-Engineering and Business rules extraction expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results. Outstanding knowledge in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues. Testing Applications, reports using review checklists, Data quality for Quality Assurance prior to making delivery to end users. Used CSS files, XML, JavaScript in QlikView/Qlik Sense object extensions. Experience in customizing Dashboards/Reports using Java, JavaScript, jQuery APIs, Web Services and third party plugins. Experience in installing and configuring QlikView Desktop, QlikView Server, QlikView publisher, QlikView document Security with section access. Expertise in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis. Excellent skills in Triggers to achieve event based requirements. Performed different types of loads Binary Load, Incremental Load, Optimized Load. Proficient in SET ANALYSIS to provide customized functionality in QlikView Applications. Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys and Modeling Issues. Experience in developing and maintaining QlikView QVDs and QVWs and generating automated reports from QlikView application (QVW). Custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting. Experience with QlikView sheet objects List, Multiple chart types, Pivot, and Multi box. Experience in developing User Interfaces and QlikView Dashboards using Chart - Box (Drill Down, Drill up & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars and Date Islands. Expertise in Creating Dashboards using QlikView using different data sources like Oracle, SQL Server, Teradata, Salesforce,QVD files, text files, XML,excel and generated dashboards as per the user requirements. Experience in Dimensional data modeling, snow flake schema, star schema, Fact and dimensional tables. Expertise in designing and creating various analytical reports and Dashboards to identify critical KPIs and facilitate strategic planning in the organization using QlikView. 
Good Knowledge and experience of 1 year in Creating Dashboards in Qlik Sense.
0 kommentar(er)
