Sql Server Data
Gajalakshmi B
acybh5@r.postjobfree.com
Executive Summary
Specializing Over 7+ years of IT experience in QlikView, QlikSense, Business Objects, Data Warehousing applications, designs and usage of Data Warehouses, Quality Analyst, Software Testing.
Experience in QlikView Dashboard Development and Reports Designing.
Successfully Developed good number of simple and complex and Implemented 5 Projects for different clients using QlikView (10/11)
Good hands on Experience on QlikView 10/11, SAP BW, SQL Server, Oracle.
Extensive experience in end to end BI Implementation using QlikView.
Involved in Requirement gathering process with Clients.
Has experience in building and maintaining QVDs and QVWs.
Involved in creating Complex reports and dashboards in user friendly way to the end users.
Good knowledge on Performance tuning of QV Applications.
Well experienced in design and development of QlikView for OLTP and OLAP Systems.
Involved in writing complex expressions using Set analysis and advanced Aggregation functions.
Excellent knowledge on fixing data model issues such as synthetic keys, circular references.
Involved in QlikView unit Testing and script review.
Extensive experience in SQL - Databases in MySQL, SQL Server.
Knowledge on Performance tuning on SQL Queries.
Wrote queries against Teradata SQL Assistant to fetch data into Qlikview and Qlik Sense.
Wrote complex SQL Queries using joins, sub queries and correlated sub queries.
Knowledge in maintaining Version control for QlikView Applications using SVN.
Support for Developing Internal QlikView Team for RFC and POC.
Experience in handling ongoing Production support by identifying and resolving Production Issues.
Experience in Functional Testing, Data Driven Testing, Load Testing.
Experience in developing Test Scenarios, Test cases, Test Scripts and Test reports for various applications to ensure proper business compliance.
Experience in GUI, Regression, Functional, Integration, System, User Acceptance (UAT), Sanity, Performance, Stress, Reliability and compatibility, Cross Browser, Security and Database Testing.
Strong knowledge of Software Development Life Cycle (SDLC) methodologies such as Agile, SCRUM and waterfall models.
Ability to communicate in a clear, customer-friendly manner to all levels of an organization to present findings and recommendations to team members and senior management.
Highly motivated team player with analytical, organizational and technical skills, unique ability to adapt quickly to challenges and changing environment.
Skills & Certifications
QlikView (10/11), QlikSense 2
Business Objects (3.1,4.0)
SQL, Oracle 10g, SAP BW
Microsoft Office Suite (Excel, PowerPoint, Access, Outlook, Lync)
BMC, SAP Solution Manager
Project Methodologies Agile-Scrum, Waterfall, V-Model
Languages CSS, XML, HTML, JAVA, SQL
Other Tools Toad, SQL Developer, JIRA, Quality Center
Operating Systems Windows, UNIX
Education
Master of Sciences in Computer Application (MCA) University of Madras
Alcon, Fort Worth, Texas March 2016 - Present
Senior QlikView/QlikSense Developer
Responsibilities:
Imported data from SAP BW data sources using OLEDB and ODBC connections and modeling data as per user requirements.
QlikView 11 implementation and integration for SAP Profit center accounting data’s
Created advanced Dashboard using QlikSense.
Involved in utilizing QlikSense solutions to develop complex reports and executive dashboard on Cost center, cost element and WBS levels.
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.
Involved in data modeling and worked on a complex model as per given user requirement by eliminating Circular loops, Synthetic tables and ambiguous relationships.
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.
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.
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.
Novartis, East Hanover, NJ May 2015 – Feb 2016
QlikView Developer
Responsibilities:
Participated and proposed new business analysis for data which has no prior reports
Extracted data from the database, stored into QVD files, and wrote load scripts
Eliminated Synthetic keys, ambiguous relationships and closed loops.
Designed proficient dashboards according to the requirements.
Established a secure environment using QlikView Section Access.
Optimized existing data models like changing load scripts to load data in optimized way to achieve reduction of loading time, simplified complex expressions in the front-end and improved layout structure.
Extensively worked on set analysis and advanced aggregation functions.
Developed SQL Scripts, database objects, procedures, functions and packages.
Adapted Kimball's approach for building data marts.
Deployed the reports on the production server using QlikView server and Publisher.
Experience in creating Macros to automate.
Worked with internal and external clients for import and normalization of third-party data.
Documented and maintained database system specifications, diagrams, and connectivity charts.
Monitored and provided front-line support of daily processes.
Plan, design, and implement application database code objects, such as stored procedures and views.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Identified data issues and provided recommendations for resolution to ensure optimal performance.
Environment: QlikView 10, SAP BW, SQL Server, MS SQL Server Management Studio, Erwin Data Modeler, MS PowerPoint, MS Excel, SAP Solution Manager.
PFIZER, Cognizant Technology Solutions, Chennai July 2013 – Apr 2015
QlikView Developer
Responsibilities:
Develop, Enhance, Re-engineer, 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, Erwin Data Modeler, MS PowerPoint, MS Excel
CENTRICA, Cognizant Technology Solutions, Chennai October 2011– June 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 June 2010 - September 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.
Environment: Business Objects 3.1, SQL Server 2005/2008 Enterprise Edition, MS SQL Server Management Studio, Erwin Data Modeler, MS PowerPoint, MS Excel
GLUDAD, 3i Infotech, Chennai June 2009 - May 2010
SAP Business Objects Developer
Responsibilities:
Created and maintained around Business Objects reports and Web Intelligence reports.
Built Cross-Tab reports.
Added/created complex objects to the universe to enhance the report functionality.
Built Custom Hierarchies in universe to facilitate drill down in the reports.
Analyzed the reports using Slice and Dice, and Drill Down.
Created graphical representation for existing reports.
Performed data validation by creating ad hoc reports.
Created different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
Created complex reports with multiple data providers/different universes and databases (Oracle, SQL server, DB2).
Documented the deviations from the original specifications.
Interacted with Project Manager and Business Analyst to understand the requirements and modifying universe, report specifications
Enhanced the reports by providing event-handling features.
Optimized the usage of user objects, conditions and universe level filters.
Extensively used multiple data providers for building reports
Tested objects in the universe, to ensure the correct mapping of the objects.
Performed Check Integrity in universe.
Tested the universe structure to ensure the tables are properly updated along with the database
Environment: Business Objects 3.1, SQL Server 2005/2008 Enterprise Edition, MS SQL Server Management Studio, Erwin Data Modeler, MS PowerPoint, MS Excel
Contact this candidate