SUMMARY:

• Over all 8 Plus years of IT experience in system analysis, design, development, administration of software applications and in the field of ETL methodologies, business intelligence and data Warehousing principles and architectures including concepts, designs and usage of data warehouses.
• Over all 5 years of experience on QlikView 8.5/9.0/10/11/12 and Qliksense Experience in working with Data Warehousing and business intelligence tools for developing/Administration of various reports using QlikView
• Expertise in working with Data Warehousing and Business Intelligence tools for developing various reports using QlikView BI.
• Configured and managed and planned the QlikView/Qliksense infrastructure.
• Well experienced in design, development & Administration of QlikView for OLTP and OLAP Systems.
• Analyzed modeling data in conformance to business needs.
• Planning and configured the Qlikview environment in Organization.
• Hands of experience in Configuring up the Clustered Environment in physical and Virtual (VM) environments.
• 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.
• Installed and configured NPrinting in multiple environments.
• Developed Custom dashboards/reports using QlikView.
• Explored intensively and Implemented Qlikview 11 advance features like Direct Discover, Alternate states, Grid Container, Dimension Limits.
• Implemented of section access in environment.
• 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 optimizing existing QlikView reports with a focus on usability, performance, flexibility, testability, and standardization.
• Expertise knowledge in Set Analysis, Section Access, Advanced aggregations, synthetic keys and circular references.
• Ensure that new solutions are built in a way that ensures functional requirements are met whilst also ensuring that service qualities (performance, scalability, extensibility etc) are achievable
• Investigate and identify causes and effects of poor data and systemic issues across the systems that DSM supports, propose solutions and a means for evaluating their effectiveness upon implementation
• Tested QlikView apps and supported BO integrations.
• Hands on Experience with QlikView Architecture, sizing in development and deployment.
• Expertise in the Qliksense architecture and sizing
• Experience on Qlikview applications using QMC and Qlikview Enterprise Management Console
• Experience with QlikView Architecture in development and deployment
• Hands on experience on implementing QlikView hierarchies using QVD approach.
• Worked on QlikView server/publisher to handle user security/data reduction.
• Strong understanding of Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.
• Experienced in Creating QlikView access point for Client application rollout and administrator security by Active Directory technology using QlikView Publisher.
• Design of QlikView applications using QlikView Data (QVD) files generated by ETL logic.
• Expertise in designing and modeling of QlikView with complex multiple data sources (SQL, Flat Files, Excel and Access,) relational designs.
• Extensive experience in gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers and QA engineers.
• Experience working on End - To-End implementation of Data warehouse and strong Data modeling experience using Star/Snowflake schemas, Normalization, Dimensional Data modeling, FACT & Dimensions tables and Physical & logical data modeling.
• Highly motivated and capable of working both individually and in a group environment and proven communication, presentation Skills and Leadership Qualities

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy, QlikView, Qliksense

ETL: Informatica, Pentaho BI Suite, MS SSIS

Databases: MS SQL Server, Oracle, MySQL, HIVE, Greenplum

Languages: PHP, Java, C, HTML, PL/SQL

Other tools: Oracle CRMOD, TOAD, SQL Loader, MS Office

PROFESSIONAL EXPERIENCE:

Confidential, NC

Consultant / Admin.

Responsibilities:

• Evaluated information systems needs assessment, information gathering and recommend appropriate business systems and IT infrastructure.
• Architect and configuring Qlikview environment setup including the Cluster environment in Virtual (VM) Environment in United Guaranty.
• Configured and managed and planned the Qlikview infrastructure at client place.
• Architect of the environment right from the scratch to build the environment.
• Documentation for Server capabilities and estimates to build the servers which involves on setting up servers and ram capacity for utilization.
• Involved in meetings with Qliktech right from accruing the Licences and so.
• Upgraded the Qlikview environment from Qlikview 11.2 SR 10 to11 .2 SR12 and then to12 SR5.
• Interacting with end users to gather the functional requirements and customize QlikView dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting QlikView applications.
• Worked on the Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts
• Oversee the development/Deployment of Qlikview applications.
• Documented the process and implemented the Qlikview & Qliksense best standards in environment.
• Configured the Qliksense environment on the sandbox.
• Involved in setting up the Hive and Greenplum data base into the environment.
• Developing the Qlikview and Qliksense environment and supporting the business decision process.
• Resolved technical problems and implemented QlikView consultation services.
• Configured QlikView Server /Publisher. Scheduled jobs, & security and implemented the Best practices and security in environment.
• Documented technical specifications and reviewed call statistics.
• Worked closely with Business to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports.
• Designed and developed the Qliksense App development/Data model to support the business.
• Designed the Qliksense data modelling.
• Troubleshooted the Qliksense performance related issues.
• Configured different Qlik Sense roles and attribute based access control.
• Configured the Oracle/DB2/SqlServer /Hive/Greenplum connections to the QlikView environment.
• Worked on implementing improvements and optimizations of QlikView environment.
• Responsible for managing QlikView servers and administration of users and applications, troubleshooting and corrections in operating procedures, logs and other parts that belong to the QlikView environment.
• Implemented security using QlikView™section access that dynamically hides selected areas of the dashboard depending upon user privileges.
• Responsible for Server and Application performance and health monitoring, System setup and configuration and
• Handling of User and License Management and Support the QlikView development teams in their daily work.
• Worked on Cognos Admin such as providing the security and publishing the reports.
• Scheduled and managed QlikView jobs using QlikView Scheduler for QlikView application dashboards.
• Hands of experience on Qlikview Enterprise Management Console (QEMC) and Qlikview Management Console(QMC)
• Deployed, Maintain the QV Applications/Dashboards to the Development, Test, UAT and into Production environment.
• Provided production support to the existing Qlikview applications.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: Qlikview 12(SR4)/Qliksense, Clustering, Virtual Machine/Cloud Environment, SQL Server, QMC, HIVE, Greenplum, IIS, Server 2012 R2, Oracle, DB2, Qlikview Server and Publisher, Cognos.

Consultant / 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 prioritized reports.
• Identify, propose and implement enhancements over the existing reports to improve user experience.
• Installed and configured the NPrinting into the environment and pushing the reports through the NPrinting.
• Designed and Developed QlikView reports, dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar & Date Island meeting the business requirements.
• Upgraded the Qlikview environment from Qlikview 11.2 SR 6 to 11.2 SR10.
• 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.
• Worked on the Dimensional Modeling technique, Multi-dimensional database Schemas like Star Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.
• Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.
• Hands on Experience with QlikView Architecture in development and deployment
• Worked on Qlikview Management Console(QMC) and Qlikview Enterprise Management Console (QEMC)
• Automated and scheduled daily data loads of QVW documents using QlikView Publisher.
• Optimizing 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.
• Deployed, Maintain the QV Applications/Dashboards to the Development,Test,UAT and into Production environment
• Assisted in demoing QlikView application to users and gather feedback at every phase

Environment: Qlikview 11.2, Oracle 11g, Set Analysis, Qlikview Server and Publisher, NPrinting.

QlikView Developer / Bi Consultant.

Responsibilities:

• Interviewed users to identify problems, reporting requirements and problems in existing systems design.
• Collaborated with Business Intelligence team to learn current processes and practices.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Identified various KPI’s with businesses users and analyzing existing Business Objects Reports.
• Generated new QVD files from the EDW by writing scripts in QlikView applications. Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Extensively worked on QlikView Set Analysis.
• Created batch scripts to process the data periodically as per the business requirements.
• Applied metrics in the data via QlikView scripts and transformed QVDs to cater the business needs.
• Designed and Developed QlikView dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar & Date Island meeting the business requirements.
• Published Client application using QlikView Publisher and rolled out to Access point and administered security using Active Directory technology/Access DB integration.
• Scheduled and managed QlikView jobs using QlikView Scheduler for QlikView application dashboards.
• Monitor computer systems to minimize unscheduled downtimes and ensured availability of resources.
• Involved in performance tuning to optimize the functionality of dashboards.
• Provided production support to the existing Qlikview applications.

Environment: QlikView, Oracle 11g, TOAD, Business Objects, Erwin Data modeling.

Confidential

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 prioritized reports.
• Actively participated in the design, architecture and development of user interface objects in QlikView™ applications.
• Worked on data modeling and developed different complex models as per given user requirement by eliminating circular loops, Synthetic tables and ambiguous relationships.
• Managed schedules and reloading of QlikView™data model QVDs and QVWs through QlikView™server.
• A master calendar was used for time related dimensions and a strong source control methodology was used for tracking changes.
• 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 limit the response time and enhance the functionality.
• Identify, propose and implement enhancements over the existing reports to improve user experience.
• Responsible for ensuring stability of QlikView™server applications and all license and security management of all QlikView™ applications.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality in QV Publisher.

Environment: QlikView, Set Analysis, Oracle 10g, PL/SQL 8.0, SQL*Plus, SQL Developer, MS Access.

QlikView Developer.

Responsibilities:

• Extracted the data from various data sources such as databases, Excel documents and CSV files, transforming the data into standard format and load the data so that it is available for analysing and creating reports.
• Worked closely with Business to design, develop and enhance Reports.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Developed QlikView scripts to load the transformations and make enhancements to the user interface of the desktop application.
• Installed and configured Qlikview 9.
• Application processed tables with over 20 million records.
• Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Created batch scripts to process the data periodically as per the business requirements.
• Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Experience in scripting QlikView Set Analysis and Macros.
• Altered the QlikView scripts based on any unusual latency in the response time on the UI.
• Created User Interface and prepared layouts for the system by using QlikView.
• Participated in the developing/enhancement of star schema dimensional data model.
• Assisted in upgrading from QlikView 8.2 to version 9.0
• Wrote scripts and created batch files for automatic running of QlikView scripts.
• Worked on the UI for various applications

Environment: QlikView, Set Analysis, Oracle 10g, PL/SQL 8.0, SQL*Plus, SQL Developer, MS Access.

SQL Server Developer/BI

• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Worked on performance monitor counters for monitoring SQL Server environment.
• Managed indexes, statistics and optimizing queries by using execution plan.
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Designed DTS Packages to transfer data between servers, load data into database, and deploy the data, scheduled the jobs to do these tasks periodically.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.

Environment: SqlServer 2005, Erwin, .Net Frame Work, XML, MS Access, Excel, ER Studio, Performance point Server.

MS SQL Server Developer/BI

Responsibilities:

• Developed backup restore scripts for SQL Server as needed.
• Upgraded SQL Server databases to latest version 2005 from SQL server 2000.
• Involved in Performance tuning and Query Optimization.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Managed and coordinate with remote user for change request and optimization of application.
• Scheduled jobs, alerts and designed and implemented user log in and security.
• Resolved deadlocks issues with the databases / servers on a real-time basis.
• In-depth working knowledge of ODBC.
• Created many complex stored procedures / functions and used them in Crystal Reports directly to generate reports on the fly.
• Designed and created diagrammatic programming for the Data Model using Microsoft Visio.

Environment: MS SQL Server 2005/2000, Analysis Services (SSAS, DTS, Crystal Reports)

Confidential, New Jersey

SQL Developer

Responsibilities:

• Used the SSIS/ETL to migrate databases such as Oracle and Access database, flat files to centralized IT destination.
• Implemented slowly changing dimension on 500,000 records that took 11minutes to complete. Improved the performance by replacing it with checksum to 8minutes.
• Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
• Conducted performance tuning by using SQL Profiler and index tuning wizard.
• Involved in Creation of Crystal Reports, Created ODBC Connections and database Connections.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports.
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Environment: MS SQL Server 2000, MS SQL Server Reporting Services, Crystal Report, MS Excel, Window XP, MS Word, Visual Studio