Data Sql Server

USHA

QlikView/QlikSense Developer Phone: 585-***-**** Email: ***.*******@*****.***

SUMMARY:

* ***** ** ********** ** Analysis, Design, Development, Testing and Implementation of Business Intelligence applications using QlikView and over 2+ years of experience as QlikSense application developer.

Strong knowledge in designing and developing QlikView and QlikSense dashboards by extracting data from different sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files.

Worked installation & configuration, environment, system analysis, design, deployment, testing of projects.

Experience in optimizing QlikView and QlikSense applications to improve the performance.

Developed QlikView and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.

Proficient in troubleshooting and fixing the QlikView and QlikSense dashboard issues.

Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.

Hands on experience in customizing the QlikView and NPrinting reports as per the business requirements.

Created incremental load process to load the data into QlikView applications from different source systems.

Involved in Performance Tuning and Deployment of QlikView and QlikSense applications.

Hands on experience in QlikView advanced features like Alternate States and Direct Discovery.

Worked in Agile methodology environments and involved in scrum meetings.

Experience on QlikView Scripting, Set analysis and Section Access.

Scheduled the jobs and distributed to end users from QMC.

Experience in database programming, SQL, Tables, Views, Indexes, Joins, and Sub-Queries.

Trained end users to develop and use QlikView and QlikSense applications.

Managing job failure analysis and production support for various applications.

Involved in Onsite-Offsite coordination in delivering Business Intelligence Solutions.

Understanding of data modeling, dimensional & relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables; experience in Extract, Transform and Loading process of data.

Created detailed design, development, testing & migration documents and performing Proof of Concepts (POC).

Delivered all the projects and assignments within the specified time lines with accuracy.

Strong ability to work within a demanding and aggressive project schedules and environments.

TECHNICAL SKILLS

Reporting Tools: QlikView, QlikSense

Programming: C, C++, .Net, SQL, PL/SQL, VB-Script, Html

Databases: Oracle, SQL Server, Salesforce, SAP

Others: QViewer, Kdiff, Toad, Putty, Rally, Tidal, MS Office

Operating Systems: Windows, Unix

EDUCATION QUALIFICATION

Bachelor of Technology in Computer Science and Engineering, JNTU, Hyderabad, India.

WORK EXPERIENCE

Role: QlikView/QlikSense Developer Citi Group, NJ (Dec’15 – Till Date)

Responsibilities:

Responsible for gathering business requirements and technical specifications from the users.

Involved in designing, developing, testing, publishing, maintaining, and supporting QlikView & QlikSense applications.

Building QVDs, QVWs, QVFs using source systems like Oracle, SQL Server, Excel files, Sales Force & SAP

Involved in the requirement analysis and identifying sources and targets.

Created QlikView & QlikSense dashboards using different objects like List Boxes, Multi Boxes, Pie charts, Line charts, Funnel charts, Scatter charts, Bar charts, Combo charts, Straight tables, Pivot tables, Buttons, Containers.

Created PixelPerfect reports, Excel reports, PowerPoint reports and Word Reports using NPrinting tool.

Created tasks and scheduled the jobs in NPrinting server.

Involved in performance tuning of QlikView & QlikSense apps for faster data reloads and efficient response times.

Involved in analyzing the data and defining Key Performance Indicators (KPI).

Developed Proof of Concepts for Direct Discovery feature to load the data from SAP.

Created tasks and set dependencies using QlikView Publisher.

Assisted in installation and configuration of QlikView and QlikSense servers.

Involved in optimizing the existing data models and load scripts to improve the performance.

Simplifying complex expressions in the dashboards and improving front end.

Implemented section access to make the application available to the desired users.

Developed Proof of Concepts (POC) for various projects using QlikView and QlikSense.

Assisted users with demo sessions in using QlikView & QlikSense; converted QlikView applications to QlikSense.

Created detailed technical specification, business requirements and unit test report documents.

Responsible for validating the developed applications against the predefined design standards.

Involved in creating test case scenarios for end users to test the applications.

Perform error handling process, debugging and troubleshooting the applications.

Involved in testing process and performing the Unit testing and System testing.

Actively involved in upgrading to the latest QlikView versions.

Handled applications performance tuning, including maintenance & upgrades of applications and systems.

Used TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.

Developed different Key Performance Indicators based on business requirements.

Build ad-hoc reports for business data analysis based on end user requirements & distribute reports to end users

Developed reports in QlikView and in NPrinting and emailed the reports to end users.

Sending the updated status report to the managers on daily, weekly and monthly basis.

Automated and scheduled daily data loads of QVW documents using QlikView Publisher.

Coordinated with Onsite team on project development tasks and provided updates to the managers.

Environment: QlikView, QlikSense, QlikView Publisher, QlikView Management Console, Microsoft SQL Server, Oracle, Salesforce, SAP.

Role: QlikView Developer John Wiley and Sons, NJ (Oct’14 – Nov’15)

Responsibilities:

Gathered functional requirements & developed QlikView dashboards.

Developed, enhanced, & maintained QlikView applications. Provided production support to QlikView applications.

Redesigned applications to improve performance by eliminating Synthetic keys & Circular Loops in data model.

Used Mapping Loads to eliminate dimension tables & reduce no. of tables & complexity in QlikView data model.

Building QVD’s from different data sources like SQL Server, Oracle, SalesForce, Excel, CSV and Flat Files.

Developed dashboards using different sheet objects like List boxes, Multi boxes, Buttons, Text objects, Input boxes, Scatter charts, Bar charts, Pivot Table, Straight Table, Containers, Slider, Funnel chart.

Developing scripting templates, coding standards, design guidelines, migration strategy and implementation plan.

Created PixelPerfect reports, Excel reports, PowerPoint reports and Word Reports using NPrinting tool.

Created tasks and scheduled the jobs in NPrinting server.

Automated and scheduled daily data loads of QVW documents using QlikView Publisher.

Optimized existing data models and load scripts to improve performance.

Assisted in upgrading the QlikView tool to the latest version.

Simplified complex expressions in the front-end and improving performance.

Analyzed data & defined Key Performance Indicators.

Created ad-hoc reports in QlikView and supported the users with the adhoc reporting queries.

Provided demo of QlikView dashboards to enhance user’s knowledge on key capabilities of QlikView application.

Perform error handling process, debugging and troubleshooting the jobs.

Involved in testing process and performing the Unit testing and System testing.

Sending the updated status report to the managers on daily, weekly and monthly basis.

Prepared Run books, migration documents and production monitoring and support handbooks.

Wrote scripts and created batch files for automatic running of QlikView applications.

Implemented Set Analysis to improve the calculation times on the front end.

Involved in Production Support for various applications and failure analysis using error logs.

Security implementation and deployment of QlikView applications to the production environment.

Designed the daily refresh process and created tasks and triggers using QMC.

Used Set Analysis and Alternate States for Comparative Analysis

Deploying QlikView applications to the QA access point for the UAT.

Developed Proof of Concepts (POC) for various projects using QlikView.

Implemented Direct Discovery feature to fetch Live Data from huge fact table that consists of user’s information.

Tested applications & reports using predefined review checklists; tested data quality before delivering to users.

Environment: QlikView, QlikView Publisher, Microsoft SQL Server, Oracle, Rally, Excel, Access, Salesforce.

Role: QlikView Developer Constellation Brands, NY (Oct’13– Sept’14)

Responsibilities:

Developed technical specifications & business requirement documents, defined KPIs, and identified data sources.

Designed & developed reporting applications using QlikView.

Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the User Interface to make the data easily accessible to the users. Implemented data level security using Section access

Analyzed the QlikView data model, script logics and the ETL business logic for the existing QlikView applications.

Built QVD’s from SQL Server Database, Flat files and Excel files.

Simplified complex expressions in the front-end and improved load times.

Designed User Interface based on the business requirements and business rules.

Developed QVD scripts to load history and current data using Incremental logic.

Gave demo on QlikView applications to users and gathered feedback at every phase.

Created PDF reports and scheduled the reports to generate PDF’s every week.

Used Section access and Sheet access to make the application available to desired users.

Used SET Analysis, Aggregate functions to look at the history data and get required information.

Sent updated status reports to the project managers on weekly, monthly and quarterly basis.

Installed & configured QlikView tool and upgraded QlikView software to the latest version.

Improved overall applications performance and redesigned data model applying QlikView Performance Tuning

Implemented Security and involved in deployment of QlikView Applications to the access point.

Maintained QlikView applications user guides & documentation. Migrated QlikView applications to production environments and handled performance tuning of the QlikView dashboards.

Conducted end user training sessions and prepared the training documentation.

Migrated jobs & common objects between environments and scheduled jobs using QlikView publisher

Created test cases and conducting Unit Testing, Integration Testing and System Testing.

Participated in design & code review meetings.

Environment: QlikView, Oracle, Flat files, Excel files, XML files, Microsoft SQL Server.

Role: QlikView Developer Zensar Technologies, India (Apr’11 – Sep’13)

Responsibilities:

Gathered requirements from business users and designing, developing, testing & migrating QlikView applications

Analyze business requirements, technical specifications, source repositories and physical data models for data Extract, Transform and Load process and develop QlikView applications.

Developed dashboards using different objects like List boxes, Multi boxes, Straight Table, Pivot Table, Buttons, Text objects, scatter charts, Input boxes, Containers, Slider, Bar chart.

Developed three layered architecture which involved data extraction layer to fetch data from sources and store as QVD’s, transformation layer to build the data model and finally building dashboard layer.

Involved in design, development, testing and migration meetings of QlikView applications.

Extracting data from large tables and views into multiple QVD’s used by different applications

Eliminated synthetic keys and loops in the data model and developed effective data models.

Interacting with end users to gather the functional requirements and customizing QlikView dashboards accordingly and involved in developing, enhancing, maintaining and supporting QlikView applications.

Involved in converting the existing QlikView applications to QlikSense.

Developed Proof of Concepts (POC) for various projects using QlikView. Used Section Access & Set Analysis.

Sending the updated status report to the managers on daily, weekly and monthly basis.

Automated QlikView jobs in QlikView Publisher and migrated the applications to QlikView access point.

Developed reports in QlikView and in NPrinting and emailed the reports to end users.

Responsible for deployment of QlikView applications to the production environment.

Involved in validating the QlikView data against the data in the database tables and views.

Made changes to the QlikView scripts based on the response time on the front end.

Analyzed data & defined KPIs; created tasks and set dependencies using QlikView Publisher.

Involved in performance tuning of various QlikView applications.

Implemented section access to make the application available to the desired users.

Involved in Production Support for various applications and failure analysis using error logs.

Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.

Environment: QlikView, Oracle, PL/SQL, SQL Server, Excel files SAP

Contact this candidate