Candidates About

Sowmya

 

  Professional Summary:

 

·         7+ years of experience in the field of Business Intelligence and Analytics with a strong background in data warehousing.

·         Good Knowledge in SQL concepts.

·         Ability to write complicated yet efficient SQL queries and stored procedures.  

·         Hands on experience on different version of QlikView 10/11/12 suite of Products.

·         Well experienced in design, development & Administration of QlikView from various data sources.

·         Experience in complete project Life cycle including documentation, analysis, development and testing.

·         Worked under Agile methodology.

·         Prepared system and unit Test plan to ensure all the business logics are implemented correctly.

·         Designed QlikView applications using QlikView Data (QVD) by following Multi-tier architecture (Two and Three Tiers).

·         Expertise in designing and Modeling of QlikView with complex multiple data sources (SQL, Flat Files, Excel and Access) relational designs.

·         Strong understanding of Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.

·         Experience in development of scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues.

·         Extensively used SET analysis expressions to develop different KPI’s like MTD, QTD etc. over accountable Zones & time periods.

·         Experience with QlikView sheet objects including Pivot, List, Multi box, multiple charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.

·         Developed Custom dashboards/reports using QlikView.

·         Experience in QlikView Functions (Date and Time, Keep, Join, Apply Map, String and input Fields etc...)

·         Proficient in creating QV data models, QV objects, reports, graphical interactive UI and dashboard using different data sources like Oracle, SQL Server, QVD files, Access, text files, excel documents etc. as per the user requirement.

·         Experience in Performance tuning by optimizing existing QlikView applications with a focus on usability, performance, flexibility, testability, and standardization.

·         Hands on experience in implementing Incremental load and QlikView hierarchies using QVD approach.

·         Worked on QlikView Management Console to handle user security/data reduction.

·         Experience in promoting files to the server and distributing based on active directory groups using QMC. Scheduled applications to refresh data based on multiple types of schedules.

·         Played the role of LOB Administrator for promoting files onto Access point.

·         Experience in designing dashboards using QlikSense and creating basic Mashups.

·         Knowledge in QlikView Extension objects.

·         Extensive experience in using NPrinting for quick generation of reports.

·         Dedicated, highly motivated, disciplined, detail oriented, with the ability to work both independently and as part of a team with Excellent Technical, Analytical, and Communication skills.

 

 

 

 

 

 

 

 

 

Technical Skills:                                               

               

BI Tool:	QlikView 10/11/12, QlikSense, NPrinting, Cognos
Database:	Oracle, SQL Server, Teradata, MySQL
OS:	Windows XP, Windows 7, Windows Server 2008/2012
Programming Language:	C, C++, C#, SQL.
Web Technologies:	HTML, CSS, JavaScript, .NET.
Defect Tracking Tool:	HP Quality Center.

 

 

Training Summary:

 

·         Underwent Qlik Designer Training by Qlik.

·         Underwent Qlik Developer Training by Qlik.

·         Underwent Qlik Master Training by Qlik.

 

 

Daimler Trucks, Portland, OR                                                                                                       Oct 2016 – Till Date

Sr. QlikView Developer       

 

 Responsibilities:

·         Worked closely with Business analyst to understand the requirements and translated that into technical specification document.

·         Extracted the data from various data sources such as MS Access, Excel documents and CSV files, transformed the data into standard format and loaded the data so that it is available for analysing and creating dashboards.

·         Created 3 Tier architecture to load the data into Qlikview application.  

·         Eliminated synthetic keys using concatenation and/or Qualify based on the nature of synthetic keys.

·         Developed QlikView Dashboard using Drill Down & Cyclic Grouping in charts, Pie chart, Line charts Scatter chart, Sliders, KPI’s and Date Island for a self-service.

·         Worked closely with Business to design, develop and enhance the Qlikview Dashboards.

·         Implemented complex set analysis to show various time based KPIs.

·         Used alternate states for showing comparative analysis.

·         Created an Ad hoc report for self-service.

·         Secured the customer information from some of the employees using section access.

·         Created and Scheduled QlikView reports using NPrinting based on business requirements.

·         Application processed tables with over 20 million records. Analysed this application using document analyser and optimized this application by following all the best practices and standards.

·         Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.

·         Altered the QlikView scripts based on any unusual latency in the response time on the UI.

·         Deployed application onto server and distributed based on active directory groups using QMC.

·         Developing unit testing modules prior to QA submission.

 

Environment: QlikView, NPrinting, SQL Server, MS Access, Excel.

 

 

 

QlikSense Developer

 Responsibilites: -

 

·         Participated in gathering requirements from business users and developed technical specifications.

·         Experience in loading data into Qlik Sense from various sources and modeling data as per user requirements.

·         Resolved Circular Loops and Synthetic Keys by renaming or removing unwanted columns and using Qualify statement.

·         Developed UI using Extension Objects from Qlik Branch, charts, Filter pane, map, KPI’s etc.

·         Used Set analysis, variables and various Qlik Sense functions in writing expressions for sheet objects.

·         Implemented new design objects like Maps & Extension objects.

·         Applied the Story telling Feature of QlikSense.

·         Created scheduled jobs through Qlik management console (QMC).

·         Involved in creating and building a basic mashup.

·         Optimized the application by following all the best practices and standards for the efficient performance of the UI.

·         Trained users on Qlik Sense as a self-service tool and provided guidelines and best practices.

·         Migrated applications from QlikView to QlikSense.

 

Environment: QlikSense, Oracle, SQL Server, MS-Access.

 

 

 Insperity, Houston, TX                                                                                                                 Feb 2016 – Sep 2016

 QlikView Developer       

 

  Responsibilities:

·         Gathered, Analyzed, and transformed business requirements of the Client into Technical specifications.

·         Participated in project planning, documentation, budgeting, and requirement analysis.

·         Worked with cross functional team and business user to develop Business requirement document(BRD), define key performance indicators(KPIs) and identify data sources.

·         Designed the Data model by eliminating the synthetic key & circular relationships by defining link tables.

·         Used Joins and Apply Maps to reduce the no of tables in the Data Model to aid better performance of the Dashboard.

·         Developed Dashboard showcasing different KPI’s involving QlikView objects like Containers, Charts, Text objects, List boxes, Buttons, Bookmarks.

·         Designed and developed QlikView™ desktop applications and server-based QlikView™ dashboards from scratch to support BI initiatives.

·         Implemented Section access and Hidden scripting for the Application Security.

·         Performed performance tuning for improving overall performance of application.

·         Hands-on experience in setting up new task and troubleshooting existing task setup and other issues in QMC.

·         Created automatic schedules to reload the data as per requirements.

·         Identified data sources and targets for data modeling and solution architecture.

·         Implemented new production methodologies that resulted in optimizing employee's time to finish the tasks, thus enhancing employee efficiency.

·         Performed Unit Testing and Functional Testing for dashboards.

·         Created training manuals for the users, conducted training and presentations to the users to help drive user satisfaction.

 

  Environment: QlikView, Oracle 10g, Access, .CSV Files.

                                      

 

Plymouth Rock Assurance, Boston, MA                                                                                    Jan 2015 - Feb 2016

QlikView Developer/ BI Consultant

 

  Responsibilities:

·         Worked with Business Analyst and the Business user to identify the user requirements, business reporting needs, layout, and developed the architecture of reports.

·         Worked on data modeling and developed different complex data models as per given user requirement by eliminating circular loops, Synthetic tables and ambiguous relationships.

·         A master calendar was used for time related dimensions and to show KPI’s for different time periods.

·         Actively participated in the design, architecture and development of user interface objects in QlikView applications.

·         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 improve the response time and enhance the performance.

·         Identified, proposed and implemented enhancements over the existing dashboards to improve user experience.

·         Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView Management Console.

·         Responsible for ensuring stability of QlikView server applications and security management of all QlikView applications.

·         Provided ability for users to export/print PDF reports from the application.

 

  Environment: QlikView, Oracle 10g, SQL Developer, MS Access.

 

 

 

STSGI Group, Boston, MA                                                                                                             Jan 2014 -  Dec 2014

QlikView Developer

   

Responsibilities:

·         Participated in business requirements and design review sessions.

·         Imported data through ODBC connection and modeled data as per user requirements.

·         Created dashboards by extracting data from database, stored into QVD files and designed the UI based on business requirements.

·         Designed the Data model by eliminating Circular Loops and Synthetic Keys by renaming or removing unwanted columns and using Qualify statement.

·         Developed QlikView Dashboards using different types of sheet objects like Trellis chart, Pivot table, Straight table, Bar chart, Scatter chart etc.

·         Used Set analysis and various QlikView functions in writing expressions for sheet objects.

·         Optimized the expressions for the efficient performance of the UI.

·         Converted Cognos reports to QlikView dashboards.

·         Designed different types of triggers at sheet level and document level of dashboard.

·         Implemented new design objects like Containers, Mini-Charts & QlikView Extension objects.

·         Developed functional specifications and reports based on business requirements.

·         Optimizing the load scripts and UI for efficient performance.

·         Performed various levels of internal testing and support in resolving QA defects.

·         Providing user acceptance testing group support/training.

 

Environment: QlikView, Cognos, Oracle, Teradata, SQL, MS-Access

 

                                                   

 

Sys-Integration Pvt Ltd, India                                                                                                    July 2009 - Nov 2012
QlikView Developer

 

  Responsibilities:

·         Developing, enhancing, re-engineering, maintaining and supporting QlikView applications.

·         Gathered functional requirements from end users and documented Functional and Technical specifications.

·         Worked on modelling data as per business requirements by eliminating synthetic keys and ambiguous relationships and circular loops.

·         Created 3-tier architecture for loading data into application.

·         Created dashboards to meet the reporting requirements.

·         Strong Knowledge on QlikView scripting and advanced UI development.

·         Designed different types of triggers at sheet level and document level of dashboard.

·         Developed QlikView applications based on Incrementally Load Transactions using QVD files.

·         Scheduled weekly/monthly data loads of QVW documents and distributed tasks using QMC.

·         Redesigned data models by applying all the best practices and standards and improved overall performance of the application.

·         Created more efficient expressions that would reduce calculation time.

·         Tested applications and reports using review checklists.

·         Involved in Production support and maintenance phase.

 

   Environment: QlikView, SQL server, HP Quality Center.

 

 

 

 REFERENCES:

 

1.       Name: Sai Kiran Reddy Vallapureddy

E-Mail: Sai.vallapureddy@daimler.com

Contact No: 929-399-4972

 

2.       Name: Saitej Erupaka

E-Mail: sai.erupaka@insperity.com

Contact No: 832-350-4356