Candidates About

 

Gajalakshmi B

 

Professional Summary:

 

·         8+ years of IT experience in all facets of Business intelligence applications with a strong background in Database development, Data Warehousing / Decision support systems and Business Intelligence (BI).

·         Over 6 years in the field of Business intelligence and Analysis with QlikView 11.2/10.0/9.0 and QlikSense 1.0/2.0 and SAP Business Objects 3.1/4.0 as BI tool.

·         Strong experience in Qlik product family such as QlikView Desktop Client, QlikView Management Console, QlikView Server, Qlik Sense Hub and Qlik Sense Management Console etc.

·         Expertise in using complex multiple data sources such as Oracle, SQL, Flat Files, Excel and Access for designing and modeling of QlikView.

·         Knowledge of QlikView Publisher and NPrinting.

·         Experience in using ETL Tasks such as Data Cleansing, Joins, Aggregation Tables using QlikView and Qlik-Sense.

·         Designing Data Mart and Data Warehouse and Implementation of QlikView and Qlik-Sense for BI Reporting Solutions.

·         Extensive knowledge with Dimensional data modeling, star schema, snow flake schema, Fact and dimensional tables.

·         Experience with Oracle Application Modules - Account Payables, Order Management, Purchase Order, Account Receivables and General Ledger.

·         Created scheduled jobs for QVD extracts and Report reloads.

·         Hands on experience in SDLC processes and methodologies in Business Intelligence domain.

·         Developed business requirements, dashboard development, and data verification and analysis.

·         Experience with Multiple Relational Databases including Oracle, MS SQL Server, DB2, DBeaver and MS Access.

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

·         Created set analysis applications, according to user needs.

·         Hands on experience in solving performance problems such as timeouts, rendering delays, session disconnects, etc.

·         Proven ability to troubleshoot and solve problems in a production support environment; possess analytical skills to effectively resolve technical problems, identify and implement process improvements, and think creatively. 

·         Excellent technical, analytical, and problem solving skills. Strict attention to detail and ability to work independently as well as within a team environment.

·         Excellent written, oral communication and interpersonal skills.

·         Strong experience in writing SQL Queries, views, stored procedures and SSRS processes.

 

 

Skill Set:

 

Reporting Tools	QlikView 11.2/10.0/9.0, QlikSense 1.0/2.0, SAP Business Objects 3.1/4.0
Project Methodologies	Agile-Scrum, Waterfall, V-Model, Erwin
Databases	Oracle 11g/10g/9i/8i, SQL Server 2008/20052000/7.0/6.5, SAP BW, SAP BPC, SAP BODS,
Programming	SQL, PL/SQL, Transact SQL, ANSI SQL, XML, HTML, JAVA
OS Environments	Windows XP/2000/ NT/7, UNIX (HP, Linux)
Microsoft Office Suite	Excel, PowerPoint, Access, Outlook, Lync

 

 

 

Education

 

·         Master of Sciences in Computer Application (MCA) University of Madras

·         Bachelors in Commerce (B. Com) Thiruvalluvar University

 

 

Client Experience:

 

 

 

JPMorgan Chase & Company, Jersey City, New Jersey                            June 2017 - Present

Role: Sr QlikView Consultant

 

Responsibilities:

 

• Imported data from Excel data sources and data modeling as per user requirements. 
• QlikView 12 implementation and integration for financial data Risk Management.
• Created advanced Dashboard using QlikSense.
• Created Variables and Triggers to enhance the functionality of Qlik View.
• Created Architectural Conceptual documentation and Technical Specification Documents. 
• Creating complex data models without synthetic tables and circular loops. 
• Developed QlikView applications creating expressions using set analysis for Risk Management control Processes.
• Created and scheduled Complex reports by leveraging the basic components of QlikView. 
• Involved in data modeling and worked on a complex model as per given user requirement by eliminating Circular loops, Synthetic tables and ambiguous relationships.
• Implemented Set analysis and Aggregate functions.
• Developed Drill through Dashboards, which enabled users to drill down between dimensions.
• Created charts as per the customer requirements on Quarterly, Monthly and Yearly for report analysis with charts provided by QlikView.

• Strong understanding in creating Dashboards for the required KPI’s in QlikView.
• Created various Flags based on users requirements.

·         Dashboards included customer detail drilldowns, threshold gauges, alerting mechanisms and pop report.

·         Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.

·        Trained End Users on Using QlikView Tools.

·         Performed testing of dashboards for functionality, data, performance, look and feel.

·         Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView Enterprise Management Console (QEMC).

• Involved in Script development, script functions, script variables, inline load, QVWs, QVDs, set analysis and section access.
• Installed IE plugins and trained the end users to use the reports effectively, to build and customize their ad-hoc reports.

• Designed a new application to support the dashboard style of layouts using different components of QlikView like List boxes, Multi boxes, current selections box, buttons, charts, text objects, bookmarks, etc.
• Involved in client communication sessions to evaluate client needs & ensure timely project deliver
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation. 
• Worked on using extension objects in the front end for better visuals.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Involved in client communication sessions to evaluate client needs & ensure timely project deliver

 

Environment: QlikView 12, QlikSense, Publisher 9, Python, MS Excel, MS PowerPoint.

 

BMW of Manhattan, Plano, Texas                                                               Jan 2017 – May 2017

Role: QlikView Developer

 

Responsibilities:

 

• Imported data from OLEDB and ODBC connections and modeling data as per user requirements. 
• Involved in utilizing QlikSense solutions to develop complex reports and executive dashboard on Cost center, cost element and WBS levels. 
• Created Variables and Triggers to enhance the functionality of Qlik Sense.
• Created Architectural Conceptual documentation and Technical Specification Documents. 
• Creating complex data models without synthetic tables and circular loops. 
• Developed QlikView applications creating expressions using set analysis for Balance sheet, P&L report.
• Created and scheduled Complex reports by leveraging the basic components of QlikView. 
• Developed Drill through Dashboards, which enabled users to drill down between dimensions.
• Created charts as per the customer requirements on Quarterly, Monthly and Yearly for report analysis with charts provided by QlikView.

• Strong understanding in creating Dashboards for the required KPI’s in QlikView.

·         Dashboards included customer detail drilldowns, threshold gauges, alerting mechanisms and pop report.

·         Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.

·        Trained End Users on Using QlikView Tools.

·         Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through the data.

·         Performed testing of dashboards for functionality, data, performance, look and feel.

• Designed a new application to support the dashboard style of layouts using different components of QlikView like List boxes, Multi boxes, current selections box, buttons, charts, text objects, bookmarks, etc.

 

 

Environment: QlikView 11, QlikSense, SAP BW, Publisher 9, SQL Server, MS SQL Server Management Studio, Erwin Data Modeler, MS PowerPoint, MS Excel, SAP Solution Manager.

 

 

Alcon, A Novartis Division, Fort Worth, Texas                                      Feb 2016 – Dec 2016

Role: QlikView Consultant

 

Responsibilities:

 

·         Gathered the requirements from Business Users and passed on the requirements to the team.

·         Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule ad hoc reports by leveraging the basic components of QlikView.

·         Developed KPI’s and set analysis applications.

·         Developed QlikView data warehouse enterprise framework. 

·         Developed a QlikView Adventure Works Enterprise Template. 

·         Developed QlikView documents and frameworks for Financial, ERP, and CMMS, point-of-sale and medical industries. 

·         Used QlikView components such as List Box, Slider, Buttons, Charts and Bookmarks to create Dashboards.

·         Generated new QVD files created by ETL logic to feed QlikView applications.

·          Consulted with project/program stakeholders to understand business problems and translates them into functional and non-functional requirements

·         Performed ad hoc duties in accordance to business needs.

·         Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.

·         Dashboards served to track inventory and sales as well as to monitor various KPIs.

·         Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.

·         Involved in designing the Data model and Construction of the Data model and implemented the       Star schema for QV better optimization.

·         Created QVDs by importing data from the database tables using QlikView load script.

·         Load Data into Qlik-Sense application from different QVDs files, Excel, Oracle, Inline & txt files.

·         Developed the dashboard using chart objects such as Bar Chart, Line Chart, Pie Chart, Buttons, Straight table and Pivot table.

·         Created Variables and Triggers to enhance the functionality of Qlik-Sense.

·         Implemented Set analysis and Aggregate functions.

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

·         Implemented the Navigation among the Tabs and Sub-tabs to show only corresponding charts.

·         Implemented document chaining to drive through the channel and direct dash boards.

·         Created ETL scripts for optimized reload of data.

·         Provided first line of support to clients.

·         Created tasks and deployed applications in Qlik-Sense Hub using Qlik-Sense Enterprise Management Console.

·         Used Macros, Filters, Variables and Mapping Functions to achieve user requirements.

·         Implemented core business model by eliminating ambiguous, Circular joins using Qlik-Sense best practices. Also, involved in ETL testing for validating the outcome.

·         Improved the overall performance of the application and redesigned data model applying Qlik-Sense performance tuning techniques.

·         Developed Proof of Concept for Customers.

• Complete responsibility of deliverables as well as the production support. 

 

Environment: QlikView 10, SAP BW, SQL Server, MS SQL Server Management Studio, MS PowerPoint, MS Excel, SAP Solution Manager.

 

Pfizer (Cognizant Technology Solutions), Chennai                                              Jul 2013 – Apr 2015

QlikView Developer/Admin

 

Responsibilities:

      

 

·         Develop Enhance, Re-Engineer and Maintain and Support QlikView applications to create robust services around business requirements to inform business decision-making.

·         Take responsibility for Management Information report design and production. Scope and prioritize work stream.

·         Participate in the analysis of trends and common issues to prevent future problems.

·         Communicate problems and issues to key stakeholders, including management, development teams, and business end users.

·         Participate in the design, development and implementation of QlikView applications.

·         Analyze source data; understand relationships, hierarchies, groups, trends etc.

·         Design QlikView dashboards, reports, data load procedures (ETL Scripts).

·         Deploy all QlikView components and configure schedule for ETL procedures.

·         Test QlikView application, script & QVDs as per the requirements.

·         Test fixes and perform post-resolution follow-ups to ensure problems have been adequately resolved.

·         Liaise with IT service center to facilitate solutions where applicable and assist in data understanding i.e. schemas and data definitions.

·         Work with relevant teams within the business to scope and define reporting & dashboard requirements and KPIs.

·         Requirements gathering, Impact Analysis and solution designing to incorporate the Business requests.

·         Understanding the business functionality & Analysis of business requirements.

·         Generated Reports using Global Variables, Expressions and Functions for the reports.

·         Assist with schema design and development of ETL processes.

·         Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.

·         Used QlikView Scripting and Complex SQL coding for loading, and transforming.

·         Designed and developed QlikView dashboards using different Charts (Drill Down, Cyclic Field grouping), Sheet Objects (List Box, Input Field, Table Box, Calendar & Date etc.) and extensions.

·         Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts.

·         Implemented Data Level Security, Object Level Security & Document Data Level Security.

Environment: QlikView 9, Publisher 9, SQL Server 2005/2008 Enterprise Edition, MS SQL Server Management Studio, MS PowerPoint, MS Excel

 

Centrica Plc (Cognizant Technology Solutions), Chennai                             Oct 2011 – Jun 2013

SAP Business Objects Developer

 

Responsibilities:

 

• Interacted with Business Users to know their requirements in developing and modifying Universes and Reports accordingly.
• Involved in translating these requirements into system solutions and developed implementation plan and schedule.
• Designed and Built the Universes, Classes and Objects.
• Specified the Joins, checked the cardinalities.
• Defined Cardinality based on the Business Requirements.
• Fine-tuned the joins avoiding outer joins and implementing shortcut joins.
• Improved the performance by resolving loops using Aliases or Contexts.
• Exported the universes to the Repository to share the resources among the users.
• Created different types of reports such as Master/Detail, Cross Tab and Charts.
• Applied slice-and-dice and drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Good experience in working with Ranks, Alerts, Filters, Prompts on reports.
• Extensively worked with multiple data providers and linking these data providers based on the requirements.
• Worked on Application Foundation and Dashboard Manager along with creating Matrix.
• Created reports on the web using Business Objects Web Intelligence.
• Extensively worked on Broadcast Agent server and customized scheduling and publishing reports.
• Published and Retrieved documents in Corporate document repository.
• Set up groups and users for Business Objects deployment. Managed user and user group profiles using Supervisor.
• Involved in migration from Business Objects 6.x to Business Objects XIR2.
• Performing the unit testing of the universes after the development.

 

Environment: Business Objects (Designer, Reporter, Supervisor), Dashboard/Performance Manager, Web Intelligence 6.0, InfoView, ZABO, Oracle 9i and Windows 2000.

 

SOFA (3i Infotech), Chennai                                                                               Jun 2010 - Sep 2011

SAP Business Objects Developer

                                                     

Responsibilities:

                                                                                                     

• Played a role of a Developer in developing Universe according to the Requirement from Data Source.
• Played a role of a Developer in developing Reports according to the Requirement from Universe.
• Perform Unit Testing and Capture Unit Test Logs.
• Work on Defects/incidents during the phase.
• Working with all BI and DWH concepts and architecture.
• Experienced with all the phases of project life cycle and full life cycle implementation (end to end). 
• Designed dashboard & building business logic for creation of reports.
• Performed unit Testing and script review.
• Involved in System testing / UAT & resolve issues.
• Providing support to reports and Business Objects Applications.
• Getting in to a discussion with the team members to get the best approach in the implementing the logics in order to deliver the report in the most effective and efficient manner.
• Deploying code in different environments and preparing Data validations.
• Analyzed and developed best practices for data management and Extract, Transform, Load (ETL) processes from multiple data sources.

·         Developed Proof of Concept for Customers.

• Complete responsibility of deliverables as well as the production support. 

 

Environment: Business Objects 3.1, SQL Server 2005/2008 Enterprise Edition, MS SQL Server Management Studio, MS PowerPoint, MS Excel

 

 

GLUDAD (3i Info-tech), Chennai                                                                  Jun 2009 - May 2010

 

SAP Business Objects Developer