SURENDRA SINGH
Business Intelligence Developer
Summary
Business Intelligence Developer
Experience Summary: -
CURRENT EMPLOYER: Tricentis
Total Experience: 3 Years
Designation: Business Intelligence Developer
Summary
BI developer with creative, result driven IT specialties with 2.9 Years of total professional experience in Data warehousing/Business Intelligence, Implementing & Development of projects.
Repeated success as Senior Business Intelligence Developer, Admin and single Qlik POC in multiple projects from inception to execution.
Analyzing client’s business strategy and determine system architecture requirements to achieve business goals delivered by Organization.
Direct Communication with Clients, End users, Delivery Managers and Onsite Coordinators.
Extensive experience in Dashboards Requirement gathering for global scale applications, Developing Qlik Sense/ QlikView Data Model, Dashboard development, Analysis report creation, Unit testing and Data Validation.
Proficient in trouble shooting of applications, script reload management, memory optimization, security and section access, distribution of Qlik View applications.
Dimensional data modeling using Qlik techniques like link table, mappings, concatenation, composite keys, joins, different load type, circular reference and synthetic keys, etc.
Created Dashboards using Qlik KPIs like Charts, List Box, Buttons and Bookmarks etc.
Worked with multiple extensions as per requirement Using Qlik Sense.
Provide suggestions on performance improvement of the Reports Checking for Cartesian Products, joins used in the query full table scans etc.
Strong experience in Qlik application migration and Scheduling and monitoring the tasks in Qlik Management Console (QMC).
Created different Mashups and Widgets to provide extra functionality to users that helps them to improve their business operations.
Used NPrinting to distribute Reports via mail, shared folder to users in different formats.
Executed R&D and POC for other Qlik Products like Qlik Replicate, Qlik Compose, Geo Analytics and other BI tools.
Part of COE team and supported multiple projects in current Organization.
Provided Training on Qlik View and Qlik sense and mentored fresher’s on Qlik.
Professional expertise includes Requirement Analysis, SDLC, Root Cause Analysis, Development, Testing (UT, UAT) & Support with documentation as per Organization standard.
Strategically allocating tasks to resources to achieve on-time, on-budget delivery.
Conceptually strong with an innovative and analytical approach to the work with an eye for detail. Delivering Business Intelligence Solutions for 4+ years of experience BI tools and different data sources.
Since last 4 years working with many of the clients for designing Agriculture/Sales/Operation/Support/Product and Digital Marketing Dashboards.
Around 4 years of experiences as BI Programmer in Qlikview,Qlik Sense, NPrinting, Power BI.
Work with technical and end users tunderstand business requirements and identify data solutions
Designed and developed multiple dashboards using Qlikview,Qlik Sense, NPrinting, Power BI.
Overview
3
3
years of professional experience
6
6
Certificates
Work History
Developer
- Agronomic Reporting
- Domain: Agronomy/Health Care, Qlik View and Qlik Sense Developer
- Data source: SAP and Rest APIs
- Environment: QlikView and Qlik Sense
- Description: Agronomic Reporting is a group of dashboards developed for one of the leading Agriculture Company that produces agrochemicals and seeds
- The data is extracted mainly from SAP Foundation tables, SQL, REST APIs etc
- The dashboards are developed to give the planning team an eye on the situation regarding inventory, sales, Simulation etc
- Responsibilities:
- Involved in end-to-end development of several dashboards in Qlik Sense and Qlik View
- Actively participated in requirement gathering, development planning, data modelling, designing, security of dashboards and optimization
- Understanding client needs and view to generate meaningful insights to help their business
- Worked on distribution of flat files through email, to a folder using NPrinting
- Account Receivables
- Domain: Agronomy/Health Care, : Agronomic Reporting is a group of dashboards developed for one of the leading Agriculture Company that produces agrochemicals and seeds
- The dashboard mainly consists of Finance data, which was extracted from SAP Foundation tables, to create interactive and summarized Graphical Reports
- Responsibilities:
- Requirement gathering & analysis, data modelling, dashboard designing and development
- Customized QlikView charts to achieve Heat Map and Side Menu
- Experience using groups, conditional display, and calculation condition, error messages for various charts and different graphs using Rolling concept
- Unit testing, Security of dashboard using section access, dashboard optimization, Migration and production support of QlikView Business Intelligence reports
- Supply Chain Management
- Domain: Supply Chain
Qlik Sense Developer
SAP
- This dashboard was developed for one of the leading company in automotive company
- It consisted of supply chain management data which provided the view to the leadership about the existing situation, also provided insights which could help the clients to take appropriate business decisions
- Responsibilities:
- Project included requirement gathering, ETL process, Data Modeling, Front end development and reporting using Qlik Sense
- Worked with Variables, Set Analysis, Aggregate functions and mapping functions
- Used different Qlik Sense charts objects and worked with multiple Custom Objects and extensions like Side Menu, different Climber extensions, Image Navigation, date range picker, Hide, show container and Map with drill down etc
- Created Master Items for reusable Expressions, Dimensions and Visuals
- Involved in deployment activities processes.
Data Architect
06.2018
- Training of HTML, CSS, and Java script for Web Developers from Coursera
- Training of Python for Data Science and AI from Coursera
Qlik developer
Capgemini
10.2018 - 08.2021
- And working in Tricentis
Skills
Technical SkillsQlik Sense/Qlik View DeveloperTools: Qlik Sense, Qlik View, NPrinting, TableauDatabases: Oracle, SAP, Rest APILanguages: PythonWeb DevelopmentHTML, CSS, JavaScriptKnowledge ofLoading data from flat files( Excel, CSV) Oracle, MS Access and SQL ServerKnowledge of Best data models Practice, various loading techniqueKnowledge of set analysis expressions, security modelsKnowledge of administration and architectureKnowledge of Star and Snowflakes schemaExperience working with Software Development Life Cycle (SDLC)Exposure tall aspects of analytics/data warehousing solutions (Database issues, ETL development, data migration and reporting solutions)
Certification
Attunity Compose
Timeline
Qlik developer
Capgemini
10.2018 - 08.2021
Data Architect
06.2018
Developer
Qlik Sense Developer
SAP