We provide IT Staff Augmentation Services!

Sql Developer Resume

4.00 Rating

SUMMARY:

  • Good Knowledge and experience of 1 year in Creating Dashboards in Qlik Sense.
  • Expertise in designing and creating various analytical reports and Dashboards to identify critical KPIs and facilitate strategic planning in the organization using QlikView.
  • Experience in Dimensional data modeling, snow flake schema, star schema, Fact and dimensional tables.
  • 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 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.
  • Experience with QlikView sheet objects List, Multiple chart types, Pivot, and Multi box.
  • Custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
  • Experience in developing and maintaining QlikView QVDs and QVWs and generating automated reports from QlikView application (QVW).
  • Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys and Modeling Issues.
  • Proficient in SET ANALYSIS to provide customized functionality in QlikView Applications.
  • Performed different types of loads Binary Load, Incremental Load, Optimized Load.
  • Excellent skills in Triggers to achieve event based requirements.
  • Expertise in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis.
  • Experience in installing and configuring QlikView Desktop, QlikView Server, QlikView publisher, QlikView document Security with section access.
  • Experience in customizing Dashboards/Reports using Java, JavaScript, jQuery APIs, Web Services and third party plugins.
  • Used CSS files, XML, JavaScript in QlikView/Qlik Sense object extensions.
  • Testing Applications, reports using review checklists, Data quality for Quality Assurance prior to making delivery to end users.
  • Outstanding knowledge in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
  • 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.
  • As a key member of Agile Team actively participate in user story Backlog Grooming, Sprint Planning, Retrospective and other ceremonies.
  • Collaborate with Agile Team and business stakeholders to ensure quality and value of Agile Team deliverables
  • Good in validating (Tracebility Matrix, Design Indexes) the BI reports/dashboards.
  • Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS:

ETL 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.

Database Technologies/RDBMS: Oracle 9i/10g/11g, SQL Server, Teradata, MySQL, DB2, SSIS, Teradata,PL/SQL

Documenting and Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio, MS Project, MS Office(Word/ Excel/ Access/ Power Point), SharePoint, Documentum.

Scripting/Language: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Operating Systems: Windows 10/7/Vista/XP/2000/NT, Server 2012/2008R2/2003, Exchange 2003.

PROFESSIONAL EXPERIENCE:

Confidential, CA

QlikView |QlikSense Developer

Responsibilities:

  • Extensively worked to confirm and clarify requirements and business logic.
  • Analyzed the reporting requirements with the business users and came up with the technical specifications.
  • 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, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks etc.
  • Involved in QV server administrator, administration for QV services, integration into IT infrastructure etc
  • 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 & Finance QlikView applications.
  • Worked on Qlik Sense App development, templates, story generation, data modeling and Qlik Sense app performance optimization.
  • As a QlikView Admin Monitored reloading tasks, ram usage, access restrictions to the document and also involved in managing the server components.
  • 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
  • Analyze customer requirements and develop proposals of technical solutions as needed.
  • Wrote SQL Scripts, procedures and views which are required for QlikView projects.
  • Good understanding in the area of monitoring the various services in QMC, Task setup, Managing client licenses, Mounting folders, session collaboration, enable session, performance and audit logging, type of authorization(NTFS and DMS),loop and reduce and Section access management in PAT
  • 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.
  • 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.
  • Trained Distribution Center, Planning and Purchasing & Finance Teams on how to use QlikView applications.
  • Testing dashboards and data validation.

Environment: QlikView12,11x/10(Desktop, Server/Publisher, Access Point),Nprinting for QlikView (14.03.), Qlik Sense 2.2, SQL Server/ 2008/12, Tableau, Informatica, Windows XP/7.

Confidential, CA

QlikView Developer

Responsibilities:

  • Consolidated two existing QlikView applications into one.
  • Created POC’s, proposed and documented the requirements to the user for consolidated application.
  • Did the analysis of the application regarding user experience (Front end), QlikView data model change, volume estimation, QVW size estimation, BI processing time saved after consolidation.
  • Did testing in two different servers and validated the data.
  • Resolved the failure issue of existing publisher job in Production server.
  • Validated the data of the reduced QlikView files.
  • Executed the job in Publisher.
  • Implemented security using QlikView section access that dynamically hides selected areas of the dashboard depending upon user privileges.
  • QlikView best practices were used in implementation of scripting, set analysis and usage of variables.
  • Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
  • Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives.
  • Implemented Section access and hidden scripting for the Application Security.
  • Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
  • 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.
  • Identified data sources and targets for data modeling and solution architecture.

Environment: QlikView 10, Tableau, SQL Server, Toad /SQL Developer, Qlik View Server and Publisher.

Confidential

SQL Developer/Tableau Developer

Responsibilities:

  • Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.
  • Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
  • Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server.
  • Created database documentation for table and column dictionaries and other reference material.
  • Implemented indexes on tables and views for optimum performance tuning.
  • Involved in reviewing business requirements andanalyzingdata sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
  • Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
  • Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
  • Involved in creating calculated fields, mapping and hierarchies.
  • Created drill through reports in dashboard.
  • Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
  • Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
  • Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
  • Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.
  • Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
  • Performed Tableau type conversion functions when connected to relational data sources.
  • Maintained and Installed Tableau Server in all the environments.
  • Created incremental refreshes for data sources on Tableau server.
  • Monitored VizQL server, Application Server and data server activity to track performance and system stability.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Created report schedules, data connections, projects, groups in Tableau server.
  • Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
  • Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: MS SQL Server 2012/R2,2010,2008, SQL Server management studio, Tableau Server 8.1/8.2, Tableau Desktop 8.1/8.2, Windows Server Standard R2,, Excel, MS SQL Server 2008R2.

We'd love your feedback!