SURENDER

Personal Synopsis:

Over **+ years of Experience as specialist in Business Intelligence related tools and technologies

8+ years of experienced in QlikView and 4+ years Qlik Sense development (dashboards, reports), Server and Publisher maintenance

12+ years of Experience as specialist in Data Warehouse, ETL related tools and technologies

Developed executive dashboards using QlikView/Sense and delivered through the web and for mobile clients.

Good understanding of QlikView/Sense Architecture. Extracting, Transforming and Loading data (historical and incremental loading) from different data source.

Extensive experience with the design/development/scripting of QlikView/Sense applications. Working Knowledge in Configuration and Administration of QlikView/Sense Publisher/Server.

Working knowledge of object-oriented programming(python) and R language.

Working experience on Big Data – Hadoop, worked with sqoop in extracting data from comdb2 to Hadoop file system and to hive tables, worked with hive queries to understand data within the tables and did some analytics, working on spark to do analytics on data tables.

Experience in end-to-end implementation of Business Intelligence (BI) projects, especially in scorecards, KPIs, reports & dashboards

Experience in sourcing data from disparate systems with a good understanding of their Data Models

Results-driven with the ability to take initiatives, handle multiple tasks and shifting priorities and meet deadlines

BI - Visualization/Data warehouse/ETL/Database Experience

Expertise in analyzing, designing, development and implementation of QlikView and Qlik Sense applications.

Expertise in Qlik Sense SDLC and Governance.

Expertise in QlikView and Qlik Sense Apps, Stories, N-printing and Story generation.

Proficient in creating N-Printing reports and using cycling feature.

Involved in optimization of QlikView and Qlik Sense dashboards with a focus on visualization, usability, performance, long term, flexibility, accuracy and standardization.

Expertise and Proficient with QlikView and Qlik Sense data modelling, master items and Maps.

Experience in Qlik Sense extensions using Java script and workbench.

Extensive experience with Qlik sheet objects, scripting and optimizing applications and building qvd’s, qvw’s and qvfs.

Expertise in Qlik Sense set analysis, section access and setting up custom rules based on roles.

Experienced with Dimensional Data Modeling, Star Schema, Snow-Flake, Fact and Dimension Tables, Physical and Logical Data Modeling, Erwin, Master Data Management

Supported existing Cognos reports and fix any bugs that are identified by users. Also support in creating new reports based on user requirements.

Worked with informatica tool to create ETL workflows needed to clean the data and structure the data for reporting purposes. Very good understanding of Logical and physical data model.

PM/BA Methodologies Experience

6+ year’s Experienced Participated in PMO activities, Project Planning sessions, user workshops, interviews, conference calls and white board sessions to keep executive staff and the project team members apprised of goals, project status, and resolving issues

Good knowledge in standard SQA methodologies, Agile methodology, Processes, Techniques and Business Workflows and expertise in implementing them with emphasis on Quality Process.

Efficient in analyzing, gathering & enumerating clear and concise requirements.

Knowledge of Risk Models like Credit risk management, Operational risk management, and Market risk.

Familiar with regulations such as Basel I and II.

Agile methodology: We have daily scrums, sprint planning, sprint retro … use agile methodology for our development and delivery.

TECHNICAL SKILLS:

Reporting/ GUI Tools

QlikView Qlik Sense, Informatica (Power Center), Business Objects, Oracle Dev (Forms, Reports, Graphics), Visual Basic, Crystal Reports, Actuate, Cognos, Microstrategy

Database Management Systems and Tools

MS-Access, Teradata, Oracle/DB2/Sybase, Oracle, MS SQL Server, SQL Developer, Netezza, Greenplum

Microsoft Tools

MS Project, MS Visio, MS Office, MS Outlook, MS Office (Word, Excel, PowerPoint)

Languages

C, SQL, PL/SQL, HTML, Java Script, VB Script, JAVA, PYTHON, JDBC, PERL, UNIX, LINUX

Methodologies & Standards

SDLC, RUP, Six Sigma, SCRUM, Agile, Water Fall

Data Warehouse Tools:

Visualization tools

Informatica, Sunopsis/Oracle Data Warehouse Integrator,

Data Modeling, Fact and Dimensions Tables, Master data

Management, Cognos

QlikView, Qlik Sense, Tableau, Sisense, Microsoft BI

PROFESSIONAL EXPERIENCE:

Johnson and Johnson (JNJ), NJ May 2018 – Present

Qlik Sense Lead/Architect

Project: Workforce Analytics

The scope of the projects was to create Dashboards for Workforce, Scorecards, Diversity, Organization Effectiveness and provide end to end solutions to all core business and system requirements for the implementation of QlikView Qlik Sense Dashboards at corporate and enterprise level. These dashboards are created based on client requirements and provide users with powerful analytic capabilities and detailed information. These dashboards provide access to critical employee’s data, enabling evidence based-decisions making. HR Professionals can easily access multiple data sources together into a consistent, single source of truth allowing analytics at speed of thought.

Qlik sense Responsibilities:

Worked with business users to understand and develop the important key KPI’s from functional areas like – Finance, operations, products, clients, service … etc.

Created Visio flowcharts/use cases for Business using Qlik Sense Data model.

Used Complex Qlik functions like apply map, lookup, keep char, previous, aggr, date and time functions etc.

Helped in centralizing the data models for the existing dashboards and debugged the errors in the code.

Implemented section access and security rules for Qlik Sense based on client requirements in QMC.

Developed Qlik Sense customized extensions

Implemented Star schema data modeling, removed complex synthetic keys in the existing data modeling of various dashboards.

Created Nprinting reports by using cycle feature, which helps in providing customized reports to users.

Implemented best practices of scripting and ensured that Qlik Sense can handle millions of data without having performance issues.

Experience administrating Qlik applications in QMC / Sense hub using Security Rules and utilizing admin tools to manage system parameters and environments.

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

Implemented Stream/App level security to limit access based on user groups.

Worked on enhancements and Performance tuning on existing dashboards.

Provided User meetings and training on Qlik Sense Dashboard functionalities.

Developing Set Analysis to provide the custom functionality in Qlik Sense Applications.

Creating and Managing Qlik Sense Reports & Dashboards.

Implemented Security & section access that’s involved in Deployment of QlikView and Qlik Sense Applications.

Implemented incremental load for better performance of Qlik Sense loads.

For operational dashboards did Performance tuning by analyzing and comparing the turnaround times.

Specified the standards/best practices for universes like maintaining design consistency.

Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.

Involved in to create Hierarchies from providing drill down options for the end-user.

Created Dashboards style of reports using Qlik Sense components like List Box, Buttons, Charts, and Bookmarks etc. Created reports using charts like Pie, Bar, Line etc.

Any issues/bottlenecks that are caused in existing dashboards were resolved very efficiently by using expertise.

Trained business users and junior QlikView developers and provided guidance for center of excellence team.

Collecting statistics from Google Analytics and providing usage of Qlik Sense users on daily and monthly basis.

Environment: QlikView, Qlik Sense, Workday, Sharpoint, SQL Server, Qlik Sense APIs, PYTHON, Oracle, MySQL, Erwin.

Blue Orbit solutions, NJ Jan 2017 – April 2018

QlikView and Qlik Sense Lead/Architect

Project: Multiple Projects Implementations

The scope of the projects was to create Dashboards and provide end to end solutions to all core business and system requirements for the implementation of QlikView Qlik Sense Dashboards at corporate and enterprise level. These dashboards are created based on client requirements and provide users with powerful analytic capabilities and detailed information.

QlikView and Qlik sense Responsibilities:

Perform detailed analysis of source systems and source system data and model that data in Qlik Sense

Design, develop, and test Qlik Sense scripts to import data from source systems and test Qlik Sense dashboards to meet customer requirements

Perform quality coding to business and technical specifications

Helped in centralizing the data models for the existing dashboards and debugged the errors in the code.

Insure that the Qlik Sense server process continues to run and operate in the most efficient manner

Implemented section access and security rules for Qlik Sense based on client requirements in QMC.

Developed Qlik Sense mashups and used customized extensions

Created On demand dashboard based on volume of data.

Work directly with business units to define and prototype Qlik Sense Applications

Extracting, transforming and loading data from multiple sources into Qlik Sense applications

Provide input on proposing, evaluating and selecting appropriate design alternatives which meet client requirements and are consistent with client's current standards and processes

Migrated QlikView applications to Qlik Sense applications

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

Implemented Sheet level security to limit access based on user groups.

Worked on enhancements and Performance tuning on existing dashboards.

Provided User meetings and training on QlikView and Qlik Sense Dashboard functionalities.

Strong knowledge of Qlik Analytics Platform / Server architecture with installation experience.

Developing Set Analysis to provide the custom functionality in QlikView and Qlik Sense Applications.

Implemented incremental load for better performance of Qlik Sense loads.

For operational dashboards did Performance tuning by analyzing and comparing the turnaround times.

Specified the standards/best practices for universes like maintaining design consistency.

Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.

Involved in to create Hierarchies from providing drill down options for the end-user.

Environment: QlikView, Qlik Sense, Informatica, QlikView developer/Enterprise Server, SQL Server, QlikView APIs, PYTHON, Oracle, MySQL, Erwin.

Bloomberg LP, NJ Mar 2015 – December 2016

Sr QlikView Lead

Project: R & D Dashboards for Data Centers

The scope of the project was to create Dashboards to all core business and system requirements for the implementation of Qlikview at Bloomberg at corporate level for all R & D Data Center departments.

These dashboards provide executives and operational users with powerful analytic capabilities and detailed information on their operational and financial/budget performance.

Project: Enterprise Solutions global BI team Dashboards

Supporting data license/enterprise solutions team to create Dashboards to all core business and system requirements for the implementation of QlikView at Bloomberg at corporate level. These dashboards provide executives and operational users with powerful analytic capabilities and detailed information on their operational performance. Presently I am creating dashboards in QLIKVIEW and QLIKSENSE.

Other Support provided

Supporting existing Cognos reports and fix any bugs that are identified by users. Also support in creating new reports based on user requirements.

I built Tableau infrastructure and started supporting the infrastructure and in process of creating dashboard for DAPI users from London (new work stream)

Working with hive to understand data that is available in Hadoop, using python to move the data from Hadoop to Greenplum in structured tables.

Presently initiated to help team with SPARK (using python).

Responsibilities:

Created Visio flowcharts/use cases for Business using Qlikview Data model.

Designed data models from various sources.

Installed Qlikview Infrastructure and configured qlikview server and publisher

Created Qlikview scripts to load data from various sources.

Created mappings using Qlikview scripting.

Designed and developed extensive QlikView reports using combination of charts and tables.

Developing Set Analysis to provide the custom functionality in QlikView Applications.

Creating and Managing QlikView Reports & Dashboards.

Implemented Security & involved in Deployment of QlikView Applications.

Implemented incremental load for better performance of qlikview loads.

Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.

Created diverse types of reports such as master/detail and cross tab for trend analysis.

Specified the standards/best practices for universes like maintaining design consistency.

Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.

Involved in to create Hierarchies from providing drill down options for the end-user.

Developed User Interactive Sheets and Reports as business needs.

Created predictions and forecasting for finance and Operational teams

Unit and system tested the applications before providing to UAT

Testing the Qlikview application to make sure it has no performance issues.

Tuned Qlikview scripts as needed.

Any issues/bottlenecks are caused were resolved very efficiently.

Trained users and junior qlikview developers.

Environment: QlikView 10/11, Oracle, Excel, CSV files, Informatica, QlikView developer/Enterprise Server, SQL Server, Qlikview APIs, Java, PYTHON, Oracle, MySQL, .NET.

IIN (Institute for Integrative Nutrition), NJ Mar 2014 – Feb 2015

Sr. QlikView Lead/BI Architect

Project: Financial and Marketing Dashboards

The scope of the project was to create Dashboards to all core business and system requirements for the implementation of Qlikview at IIN for the Marketing and Finance department.

This dashboard provides executives and operational users with powerful analytic capabilities and detailed information on their Marketing operational and financial performance.

Provide Marketing reports and use these reports to strategize their marketing and sales.

Responsibilities:

Worked with business users to understand and develop the important key KPI’s from functional areas like – Finance, marketing… etc.

Designed and developed extensive QlikView reports using combination of charts and tables.

Developing Set Analysis to provide the custom functionality in QlikView Applications.

Creating and Managing QlikView Reports & Dashboards.

Implemented Security & involved in Deployment of QlikView Applications.

Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.

Created different types of reports such as master/detail and cross tab for trend analysis.

Specified the standards/best practices for universes like maintaining design consistency.

Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.

Involved in to create Hierarchies from providing drill down options for the end-user.

Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks etc. Created reports using charts like Pie, Bar, Line etc.

Developed User Interactive Sheets and Reports as business needs.

Built a warehouse for persisting and storing data in warehouse using SQL Server.

Created Data models for data that is being sourced from Facebook, google analytics, youtube and salesforce.

Scheduled and managed jobs to make sure the jobs are passed, and data is sourced properly without errors.

Environment: QlikView 10/11, Oracle, Excel, CSV files, Informatica, QlikView developer/Enterprise Server, SQL Server/

Bank of America, NJ Nov 2009 – Mar 2014

Sr. QlikView /BI Developer

Project: Financial performance Dashboards

The scope of the project was to create Dashboards to give an understanding of efficiency of Financials, sales and risk activities coming from the Data Marts.

This dashboard provides executives and operational users with powerful analytic capabilities and detailed information on their operational and financial performance.

Responsibilities:

Converted business requirement into high level and low-level design

Designing the data model in QlikView to accommodate the application requirements.

Developing trend analysis reports using complex graphs for study of data quality patterns.

There are 9 million records with 200,000/Month new records coming into system.

Worked on large scale and data volume based applications.

Dashboards were served to track sales and sales order information as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.

Implemented QlikView including scripting, data source integration, UI design, Data Modeling and ETL

Worked with QlikView Server, Publisher, QEMC, QlikView Access Point, deployment.

Trained internal business users to show how they can do their analysis and reporting using QlikView

Incorporated user authentication and data access into the solution using section access, and NT authorization

Experience in sourcing data from disparate systems with a good understanding of their Data Models

Experience in end-to-end implementation of Business Intelligence (BI) projects, especially in scorecards, KPIs, reports & dashboards

Environment: Qlikview 8.5/10, Oracle 9i/10g, Teradata, Batch scripting.

Daiichi-Sankyo Inc., NJ Oct 2005 – Sep 2009

ETL/Cognos developer

PharmaLytics Dashboard Reporting

The primary use of PharmaLytics dashboard is to understand the impact of discount levels and formulary restrictions on deal profitability and product performance during the contract negotiation process between drug manufacturers and Managed Care Organizations Other uses include the measurement of performance vs. expectations (i.e. Post Deal Analysis), expression of gross-to-net, aggregation of 3rd party and processed claims data using a single customer.

Responsibilities:

Designed dashboards for Project/Resource analysis application and Enterprise Key Metric application. These dashboards were utilized by higher management to do analysis on healthcare product development and their market share.

Analyzed and gained understanding of the underlying data. Enterprise Key Metric dashboard is sourced from multiple Excel files. Project/Resource Analysis dashboard is sourced from Oracle database.

Created data model in QlikView desktop to get all the data in required format. Used Mapping tables, Apply Map, resident load, concatenate, variables and so on.

Designed dashboard using the various sheet objects Current selection, list boxes, search, Straight table, Pivot table, Bar chart, Combo chart and so on.

Used Set analysis, Set modifiers.

Published dashboards on Access point. Migrated QVWs to the source document folder. Created distribution and reload tasks on Publisher.

Worked on enhancing the dashboards to create new charts, expressions and so on

Performed Extracting, Transforming and Loading data from different data source.

Created Cognos packages using Framework manager.

Created reports using report studio with new and existing packages.

Environment: Qlikview 8.5, Oracle 9i/10g, Java, HTML, JavaScript, SQL, Cognos

Credit Suisse, NYC Jan 2003 – Sept 2005

Sr. Business/ Data Analyst

BASEL The main objective of the Basel II is to provide comfort to the Swiss Federal Banking Commission (EBK) that a robust internal architecture has been created and will be able to accommodate the production of Basel II capital requirements under the Advanced Internal Ratings Based (AIRB) approach

Responsibilities:

Analyze the business requirements for report analytics and other reporting functionality

Develop a deep understanding of the FC business process and regulatory reporting needs

Produce Functional specifications and communicate with IT on business requirements

Collaborate with Developers within IT throughout the design and development periods

Develop a deep understanding Capital and Balance Sheet reporting

Promote emphasis on tools and process to facilitate analytics

Analyzed and created test cases/test scripts for manual testing using Business Requirements Documents (BRD) and Functional Specification documents

Capital Engine – responsible for creating a rules-based calculation engine to perform both the Basel 1 and Basel 2 capital calculations.

Reporting – responsible for sourcing and storing all data required to meet EBK and MIS reporting requirements

Environment: SQL/PLSQL, Quality Center, Oracle, SQL Server.

EDUCATION:

MS in Computer Information Systems, San Antonio, Texas

BS in Engineering

Contact this candidate