Candidates About

 

Ajaybabu

·         Over 7+ years of total IT industry experience analysis, design, testing, development and implementation of client/server applications. Experience covers areas of designing and development of Data warehousing and Business Intelligence applications.

·         Over 5 years of Business intelligence and analytics experience with strong experience on QlikView reporting tool to develop, design and support reports, dashboards and scorecards for a variety of business users.

·         Extensive experience in creating QV data models, QV objects, reports, graphical interactive UI and dashboards using QlikView from multiple data sources like SQL, Teradata, Sales Force, Oracle, SAP BW/ECC, Big Data Sources and Flat Files(XML, CSV , Excel).

·         Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.

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

·         Strong knowledge in basic components of QlikView Enterprise like List Boxes, Multi Boxes, Tables, Charts, Current Selection Boxes, Buttons, etc.. And experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.

·         Experience in optimizing existing QlikView reports with a focus on usability, performance, flexibility, testability, and standardization.

·         Experienced in Creating QlikView access point for Client application rollout and administrator security by Active Directory technology using QlikView Publisher.

·         Experience in implementing the new features of QlikSense like Story Telling, Beta maps integrations, Pivot Table, KPI Object, PDF Printing, Extensions using D3 Visualization Library etc.

·         Explored new Features of Qlik Sense 2.0 like Data Profiling, Smart Data Associations etc.

·         Design of QlikView applications using QlikView Data (QVD) files generated by ETL logic.

·         Good knowledge of Data Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.

·         Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).

·         Experience in report generation using SQL server reporting services (SSRS) from relational databases as well as OLAP cubes.

·         Expertise in optimizing, Debugging and testing SQL queries.

·         Good working knowledge in Data Modeling including Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.

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

 

 

 

 

 

PROFESSIONAL EXPERIENCE

 

Shire,

Lexington, MA

QlikView/Qliksense Consultant                                                                                               May 2016 to Present

 

Responsibilities:

• 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 QlikSense 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.

• Installed various QlikSense extensions to provide out of the box features to users.

• Excellent knowledge on Security rules and Custom properties in QlikSense.

• Hands on experience in setting up QlikSense for external users/providers.

•Developed dashboard for manual testing as complexity index which is integrated with    QliksenseGovernance Dashboard.

•Developed dashboard Performance index where it shows the values of CPU and RAM of all servers in one dashboard

• Installed and Configured QMC utilities.

•Created the external triggers in QlikSense and QlikView like Qliksense Task runner and Qlik Branch.

•Hands on experience with Qlik Support Portal raising the cases.

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

 

Environment: Qliksense Sep 2017, QlikView 12, QlikView Server, QlikView Publisher, Netezza, HIVE, Oracle, SQL, Nprinting 16

 

 

Qlikview / Qliksense Consultant

Shields Pharmacy- Quincy, MA                                                                                                  JUN 2015- April-2016

 

Shields pharmacy services partners with leading health care systems to provide medication management and healthcare consulting to its patients. As a Qlikview/Qliksense Developer of the Strategy & Business planning team I am responsible for data reporting, analysis, trending, forecasting, dash boarding and internal business consulting.

 

Responsibilities:

 

•        Configured and deployed the application on server and Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.

•        Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.

•        Experience in implementing the new features of Qlik Sense like Story Telling, Beta maps integrations, Pivot Table, KPI Object, PDF Printing, Extensions using D3 Visualization Library etc.

•        Explored new Features of Qlik Sense 2.0 like Data Profiling, Smart Data Associations etc.

•        Having knowledge on Oauth and SAML Authentication,

•        Explored Qliksense development and Mashups using javascript.

•        Extensive experience in creating QV data models, QV objects, reports, graphical interactive UI and dashboards using QlikView from multiple data sources like SQL, Teradata, Sales Force, Oracle, SAP BW/ECC, Big Data Sources and Flat Files(XML, CSV , Excel).

•        Hands on pulling data from different data sources like sales force, Rest API’s.

•        Experience in creating QlikView Dashboards using Chart Box, List, Input Field, Table Box, and Master Calendar.

•        Mainly designed and developed software applications and complex server-based QlikSense dashboards from scratch to support reporting and Business Intelligence initiatives.

•        Worked on dashboards related to Revenue Management, Sales, Daily Reports and Operations departments and implemented performance tuning that offers fast and flexible access to all key information across the enterprise.

•        Designed the architecture of data model with the 3 tier methodology of data extraction, aggregation and usage, designed to yield faster and better performance from system.

•        Used advanced scripting, set analysis and VBScript, advanced aggregation functions and advanced charts for applications.

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

•        Designed QVWs to generate QVDs for faster and efficient data reloads.

•        Trained Qlikview developers and users on best practices and general “how to” procedures.

•        Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.

•        Schedule QVW reloads on server and troubleshoot errors and failures.

Environment: Qlik Sense 2.0/2.1, QlikView10/11, Oracle11g, SQLServer 2000,Toad9.6.1/SQL Developer, SQL Loader.

 

Qlikview /Qliksense Developer

Verizon, Warren, NJ                                                                                                       NOV 2014 – JUN 2015

Verizon is a United States multinational Banking and financial holding company which provides financing and Projects are focused to consolidate / integrate existing applications and provide actual data for Analysis.

Responsibilities:

•        Involved in Requirement gathering & designing QlikView applications.

•        Worked with the team to identify the business reporting needs and studied current reporting practices outside of QlikView through pivot tables.

•         Maintained and administered source documents, source documents sets, and user profiles and executed resource management services like Access point resources, distribution folders and email servers. Monitor user access to manage the limited number of licenses. Participated in Scrum stand up meetings.


•        Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.

•        Designed and created the dashboard reports for Executive board of company using Incremental Logic & Developed the data model using Link Tables and concatenate.

•         Ability to offer end-to-end solution starting from requirement gathering, design, development & deployment of Business Intelligence applications.

•         Experienced with Agile Development Methodology in providing quick analysis and visualizations for business users.


•        Created QVD's & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.

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


•        Designed UI using different types of sheet objects like Trellis chart, Pivot table, Straight table, Bar chart, Scatter chart, Trends, KPI's, Bookmarks, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI's.


•        Use of Set analysis, Triggers, QlikView functions and optimizing expressions for sheet objects.


•        Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.


•        Implemented Star & snowflake schema (confirmed dimensions).Writing SQL Scripts to load the relevant Data in QlikView Applications.


•        Using QlikView functions such as Date and Time, Keep, Join, Mapping, String & input Fields etc.


•        Working on Microsoft Excel, Access to automate the process by creating/modifying Macros as per the requirements.


•        Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.

•         Developing unit-testing modules prior to QA submission.


 

Environment: QlikView 11.0/11.2, Qlik Sense 2.0, SQL Server 2008 R2, Oracle 10g/11g, SQL Assistant, HP Quality Center 10.

 

Qlikview Developer

Omnicare – Cincinnati, OH                                                                                                           JUN 2013 – DEC 2013

 

Omnicare is a service-based company focused on meeting the regulatory compliance needs of our clients in the pharmaceutical, biotechnology, medical device, and other life sciences fields.  The scope of the project was to develop Medicaid State Sponsored Regulatory qlikview reports for the business.

Responsibilities:

·         Responsible for Requirements Gathering, Data modeling and QlikView Application development

·         Managed QlikView reporting environment which includes QlikView Server, QlikView Publisher and QlikView Desktop

·         Delivered advanced and complex-reporting solutions such as dashboards and standardized reports using QlikView

·         Loaded data into QlikView from Database, text file and also from excel file

·         Implemented incremental load by creating QVDs and optimized the periodic data additions.

·         Created optimized QVDS which loads faster and helps to improve the performance

·         Created different complex sheets and sheet objects based on client requirements.

·         Resolved synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields, etc.

·         Added dimensions to a bar chart and turning bar chart into a multidimensional pivot table.

·         Created List boxes, Statistic boxes to show the statistics of the sales held on different products in different years.

·         Implemented complex SET Analysis for aggregation calculations so that set of records can be defined in an expression

·         Designed and developed different types of charts (Drill Down, Cyclic Field grouping)Bar charts, Straight Tables, Pivot Tables, Pie charts and Radar charts etc

·         Created multi boxes, table boxes, and input boxes to fetch data based on the input given.

·         Developed Linked Tables, Concatenation and solved issues with loops

·         Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges

·         Created Layout themes and applied it to several documents.

·         Moving reports from development to testing and testing to production server

·         Involved in resolving Performance issues with various reports

·         Developed a standard/optimized theme, which is further used across the system

·         Modifying the existing reports based upon the change requested by the user.

·         Provided administration support and Development support for development and production issues

·         Prepared Unit Test Scripts, performed unit testing, System Integration Testing

·         Documentation and training of the End Users.

 

Environment: Qlikview10, SR2, Oracle, SQL, MS Excel, CSVs, Access.

 

 

 

Business Analyst/Qlikview Developer

American Family Insurance, Madison, WI                                                                        SEP 2012 – APR-2013

 

The Global Metrics Dashboard is an automated Portal and Data Warehouse application which aims to track and manage metrics, over time and in many dimensions.

 

Responsibilities:

 

•        Gathering requirements from Performance Analytical Users, identifying functional requirements and documenting them into a Business Requirement Document (BRD)

•        Created Narrative Use Cases, Use Case diagrams, Work flow diagrams, flow diagrams using MS Visio

•        Worked with Business Owners, IT Group, QA Team to scope and prioritize development releases

•        Developed Process flows, Use Cases and System requirement specifications and analyzed the Business requirements and the site specifications

•        Analyzed System and Functional Specification documents

•        Worked on writing functional specifications for different modules

•        Developed T-SQL Scripts and SSIS packages for loading the DataWarehouse dimension and fact tables on a daily and incremental basis.

•        Constructed SQL database queries and performed Data Analysis and data mapping

•        Extract, transform and load data from databases and excel into QlikView applications

•        Created Qlikview dashboards for the users to track budgets, resources and goal progress

•        Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc

•        Extensive interactions with the client and the management teams to understand the requirements and report the status of the testing effort on their applications

•        Assisted in performing functional and GUI testing

 

Environment: SQL, PL/SQL, Qlikview, Business Objects, Oracle 10g, Oracle9i, UNIX, SQL Developer

 

 

 

 

 

Oracle PL/SQL Developer

Crystal Graph Technology Group, Hyderabad                                                                   JUN 2010 -AUG 2012

The main responsibility in the project involved purging the data which was beyond its retention period, while storing that data which was on Legal Hold.

 

Responsibilities:

•        Participated in designing the Functional and System Requirements.

•        Created the Application Design Document.

•        Handled the large amount of data with ease by using Partitions and Subpartitions.

•        Wrote stored procedures, functions, sequences, indexes, triggers.

•        Used Partition Exchanging for optimizing and better performance of the stored procedures.

•        Enhanced the performance of the procedures by creating suitable global and local indexes.

•        Involved in writing functions to check the existing partitions and validation of code.

•        Wrote UNIX Shell scripts for handling the calling pl/sql code.

•        Assisted in scheduling the every day activity of data purging using CRON jobs.

•        Created ad hoc reports using the fact tables.

•        Maintained the data integrity and security using integrity constraints and database triggers.

•        Used Oracle Defined Packages DBMS_METADATA, DBMS_OUTPUT to create appropriate indexes.

•        Made use of the PL/SQL WRAP utility for encrypting the codes for security purpose and to make it portable across platforms.

•        Manipulated numeric and character values that contained Null values by extensively using the NVL function.

•        Extensively used Cursors for manipulating the large amount of data and reducing the coding and error margin.

•        Used the Oracle Import/Export utilities for taking the backup of a particular partition data.

•        Gathered Statistics and Analyzed Tables and Indexes for Performance tuning. 

•        Made use of DB LINKS for accessing data across different databases.

•        Attended review meetings and walkthroughs to discuss the status of the project and for change requests. 

•        Stored data in the audit log tables using the old and new column attributes.

•        Performed debugging of the PL/SQL codes using the DBMS_OUTPUT.

•        Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation of the code.

•        Assisted the QA team in performing Load Testing and Performance Testing.

Environment: Oracle 9i, 10g, Erwin 4.0, UNIX, SQL Developer 1.1, Perl 5.

 

EDUCATION

 

§  Bachelor of Technology in Computer Science & Engineering, JNTU, India.    

 

TECHNICAL SKILLS

 

Databases                           Oracle 11g, SQL, HIVE,Netezza

Operating systems          UNIX, Linux, Windows Vista/XP/NT/2000/98

Utilities                                             SQL*Loader, Export / Import, RMAN, AWR                              

Languages                           SQL, PL/SQL, Shell Programming, C

Tools                                       Qlik Sense SEP-2017, Qlikview 12, Tableau, Cognos, SQL Developer,       SQL Plus,    Toad 9.0, SQL*Loader, Oracle Enterprise Manager