Naga_Qlikview Resume

Naga K

972-***-****- ******@*************.***

SUMMARY:

• 9+ years of working experience in IT industry as Qlikview developer / BI analyst /SQL Developer with strong background in Databases and Data warehousing concepts.

• Over 6+ years of Business intelligence and analytics experience with strong experience on QlikView 11.0,11.2, Develop, design and support reports, dashboards and scorecards for a variety of business users.

• Professional experience in developing Business Intelligence applications.

• Experience in dealing with multiple data sources such as SQL Server, SAP, MS Access, MS Excel, and Knowledge about Tally, FoxPro, and XML files.

• Experience with entire application development process including data Extraction, scripting, Data Modeling, Dashboard designing, Section Access.

• Experience with QlikView objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI’s.

• Extensively used functionalities such as Incremental load, Generic load, Cross table, Partial load, Sorting, QVD, Section Access, Variables, Triggers, Point in Time Reporting in Qlikview Applications.

• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long-term, flexibility, and standardization.

• Good hands on optimizing the reports at Script Level and Design Level.

• Excellent understanding of concepts like Star-schema, Snowflake schema using fact and dimension tables

• Prototyping different dashboards in QlikView for different areas which helps in evaluating the tool for reporting

• Experience in interacting with business users to analyze the business processes and requirements and transforming them into dashboards, documenting and rolling out the deliverables.

• Experience in complete project life cycle including requirement gathering, analysis, development, testing and documentation.

• Knowledge of QlikSense, Data warehousing.

• Diagnostic Ability-Ability to go to the core of the problem.

• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

EDUCATION:

• Bachelors in Engineering - Information Technology, India

TECHNICAL SKILLS:

Business Intelligence Tools QlikView 9.0,10.0/11.0/11.2

Languages SQL, PL/SQL, C, Java

Database Technologies Oracle SQL Developer 3.0.04, Oracle11g/10g, MS SQL Server 2012/2008, DB2

Operating Systems Windows Hyper-V, Windows 7/8, Cent OS, Ubuntu, Unix Shell Scripting.

Domains Financial, Banking, Healthcare, Services, Manufacturing.

Programming GUI Unix, Putty 0.63, WINSCP 5.1.7

Data Modeling Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and dimensions tables, Physical and Logical Data Modeling

Methodologies SDLC, Agile Software Development, Waterfall, Six Sigma Implementation, Business Intelligence best practices.

WORK EXPERIENCE:

First Data, Atlanta, GA Jan 2016 to Till Date

Qlikview Developer/BI Analyst

Responsibilities:

• Designed & developed QlikView dashboards for Operations & Marketing business groups.

• Create Dashboards using different components of QlikView like list boxes, Multi boxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table).

• Analyzing data using Dimensional-modeling techniques.

• Identify KPI stos how YTD&LYTD, MTD, QTD, Current period, rolling period etc., as per user input for from and to Date using Calendar.

• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.

• Extract information from different data sources like Excel, QVD, SQL Server by using different ETL script statements like Resident, Concatenate, Join, Keep, Mapping Load, Interval Match, Incremental Load, Cross Tables.

• Customize and tweak the scripts for cross-tables and generic loads and create simple and complex expressions.

• Providing analytical dashboards by focusing on Budget, Actual sand variance.

• Drill Information by creating Groups/Cycles in QlikView.

• Entitlement and data level security for dashboard using Section Access.

Environment/Tools/Database:

QlikView11.2, Windows 8, SQL Server 2008, MS Access2007, MS Excel2007

UPMC, Pittsburgh, PA Feb 2015 TO Dec 2015

Qlikview Developer

Responsibilities:

• Work directly with business users to define and prototype Qlikview Applications.

• Developed complex multi-sheet Qlikview applications incorporating show hide functionality, set analysis, lists boxes, multi boxes, pivot tables, straight tables, sliders, buttons, cyclic and drill down groups, input variables, pass through and transfer state functionality,

• Developed Qlikview OLEDB and ODBC data loading strategies including QVD’s, resident, binary loads, mapping, inline tables, concatenations and renaming.

• Created Qlikview formulas, functions, event triggers and variables.

• Provided ongoing maintenance and support to existing Qlikview documents.

• Published developer and users process and procedures guides.

• Implemented Star & snowflake schema (confirmed dimensions).

• Writing SQL Scripts to load the relevant Data in Qlikview Applications.

• Developed Macros, SET ANALYSIS to provide custom functionality in Qlikview Applications.

• Design, Build, Test, Debug the Qlikview application in QV Test server environment.

Environment/Tools/Database:

Qlikview 11.0, SQL Server 2005/2008, Windows Server2003, Windows XP, MS Access.

CUA, Brisbane, Australia Nov 2012 TO Jan 2015

Qlikview Developer

Responsibilities:

• Organized meetings with the clients to know the needs for the enterprise solution implementation.

• Designed and development of QlikView platform to integrate with Expandable Databases.

• Imported Data from Multiple data sources which also includes Web files, Oracle, MS-SQL Server, MS-Excel through OLEDB and ODBC connections, Text, CSV files.

• Participation in enterprise BI strategy developments.

• QlikView Implementation and Integration.

• Developing QlikView solutions and utilize them to develop complex reports and executive dashboard.

• Extensively used MACROS, Set Analysis and experience in creating expressions.

• Developed Dashboards using different QlikView Objects Line Chart, Bar Chart, Gauge Chart, Pie Chart, List box, Multi box, Table Box, Container etc.

• Documented Architectural Concepts and technical specifications.

• Create and Manage QlikView Scripts.

• Creating the data models, handling synthetic keys and circular loops.

• Implementing the reload tasks and distribution tasks using the QlikView publisher.

Environment/Tools/Database:

QlikView 10.0, Oracle 10g, Excel, Windows Server 2008

Suncorp, Brisbane, Australia Nov 2010 TO Oct 2012

BI analyst

Responsibilities:

• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using QlikView.

• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.

• Developed Linked Tables, Concatenation and solved the loops issues.

• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).

• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks etc.

• Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports more user-friendly in analysis purposes.

• Developed User Interactive Sheets and Reports as business needs.

• Implemented Star schema & snow flake schema (confirmed dimensions).

• Successfully performed UAT before releasing to Production environment.

• Optimized QlikView applications for performance tuning.

• Created scheduled jobs for QVD extracts and report reloads.

• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.

Environment/Tools/Database:

QlikView 10.0, SQL Server 2008, Linux, Windows XP.

Seeftech, Hyderabad, India Mar 2009 TO Oct 2010

BI Consultant

Responsibilities:

• Work directly with business users to define and prototype Qlikview Applications.

• Imported data from multiple data sources including SAP, MS Access, MS SQL Server and MS Excel through OLEDB and ODBC connection sand modeling data as per user requirements.

• Utilizing QlikView solutions to develop complex reports and executive dashboard.

• Created Architectural Conceptual documentation and Technical Specification Documents.

• Creating complex data models by removing synthetic tables and circular loops.

• Create and manage ETL script generation using QlikView Script Builder

Application.

• Developed QlikView applications creating expressions using set analysis.

• Created and scheduled Complex reports by leveraging the basic components of QlikView.

• Involved in organizing meetings to know the needs of clients for the Enterprise solution implementation.

Environment/Tools/Database:

QlikView 9.0, SSIS, Windows2003Server/XP, SQLServer2005/08, SAP, MS Access2007,

MS Excel 2007

Bridge-Logix, Chennai, India May 2007 TO Feb 2009

SQL Developer

Responsibilities:

• Worked as a developer on databases MS SQL Server 2000, MS SQL server 2005.

• Involved in migration of SQL server 2000 to SQL server 2005 using Upgrade Advisor.

• Designed DTS (Data Transformation Service) packages to transfer data between servers, load data into database, archive data file from different DBMS’s using SQL Enterprise Manager/SSMS on SQL Server 2005 environment, and deploy the data, scheduled the jobs to do these tasks periodically.

• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.

• Involved in Performance tuning and optimizing for SQL Server Application by using performance monitor.

• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2005, SQL server 2000, PL/SQL, MS Excel

Contact this candidate