Sr. Business Intelligence Developer

Name - Manan Mehta

Mail ID - **********.*@*****.***

Contact - +1-682-***-****

SUMMARY:

• Over 6+ years of experience in system analysis, design, development, Support and maintenance of business applications in client/server technology, 3-tier architecture and web development.

• Over 10 months experience as a Technical Lead, successfully leading a team (6 members) spread over multiple geographic locations in an offshore - onshore model.

• Extensive experience in Client Facing Role – Worked as a Liaison with clients, stakeholders, business partners and vendors.

• Over 6 months of experience as a Qlik Solutions Architect.

• Extensive experience using Qlik View Enterprise / Cloud, Qlik Sense Desktop / Enterprise / Cloud, Qlik Data Catalyst, Tableau (Desktop / Server), Power BI (Desktop / Cloud Service), SSRS, SAP Business Objects, SQL Server 2000/2005/2008/2014, Oracle 9i/10g/11g, REST API, POSTMAN, GitHub, Web services.

• Worked in project extensively using Agile and SCRUM methodology.

• Worked in a Web based project extensively to develop/Enhance third-party extensions, widgets, mashups, hypercubes using JavaScript, AngularJS, jQuery, require.js, D3.js, connecting Qlik with Python language for forecasting/predictive analysis and used Libraries - NumPy & Pandas.

• Strong knowledge of all Charts for set analysis, aggregations and default data filtering for KPIs, Hierarchies, Straight / Pivot Tables, Line / Pie / Pareto / Area Charts, GeoAnalytics in QlikView, Qlik Sense, Tableau and Power BI.

• Expertise in Database Design and Programming (Stored Procedures, Functions, Triggers, Views) using SQL Server 2000/2005/2008/2014.

• Hands-on experience with SQL Reporting Services (SSRS) and Crystal Reports for report generation, integration into .NET applications.

TECHNICAL SKILLS:

BI Tools QlikView Enterprise, Qlik Sense Desktop/Enterprise/Cloud), Qlik NPrinting, Qlik Data Catalyst, Tableau (Desktop/Server), Power BI (Desktop/Cloud), SSRS, SAP Business Objects.

Databases Oracle 10/11g, Hadoop/Hive, T-SQL, SQL, MongoDB, MS Access. Applications SSMS, PyCharm 2018.x.x, Anaconda, Jupyter Notebook 6.x, Talend Data Integration, Microsoft Visual Studio, POSTMAN, MVC, MS Office – Excel, PowerPoint, MS Visio, Adobe Illustrator, Photoshop, JMeter. Languages/Technology Java/J2EE, HTML5, XHTML, CSS3, XML, AJAX, AngularJS, JavaScript, jQuery, JSON, REST API, Require.js, D3.js, Python, R. Version Control GitHub, GitLab.

Methodology Agile/Scrum, Waterfall.

EDUCATION:

M.S. Computer Science The University of Texas at Arlington, Texas USA Jan 13 – Dec 14 B.E. Computer Engineering Gujarat Technological University, GJ India Jul 08 – Aug 12 PROFESSIONAL EXPERIENCE:

Olympus Corporation of the Americas Nov 19- Present Sr. Business Intelligence Engineer/Qlik Center Valley, PA

• Worked extensively on QlikView and Qlik Sense Administration, implementation, and dashboard development, in addition to complex SQL queries, stored procedures, views, and temporary tables performing ETL (Extract, Transform, Load) operations on data from various data sources.

• Actively participated in daily standup scrum calls, sprint reviews, project retrospectives, and bug discussions during each sprint using JIRA and Confluence.

• Strong Dashboard design experience and passionate practitioner of effective data visualization striving for implementing best practices around visualization and design.

• Responsible for managing Tableau Server, as Server and Site administrator, for various projects and developing end-to-end dashboard and providing 24x7 support for all production-related issues - troubleshooting, and system maintenance ensuring maximum server uptime.

• Eased the notification process reducing 5 man-hours weekly, developing Qlik Nprinting Report Automation: Dynamic Email Alerts with filters, exceptions, task failures, maintenances, and approvals.

• Provided complete Analysis of the Qlik environment with optimization measures like reducing server load – performance enhancement, reducing daily data loads times by 20% by manipulating data load editor scripts, remodeling the data models.

• Worked extensively on Qlik QMC (Management Console) – excelling in admin responsibilities like implementing security rules, managing users, data connections, streams, users, auditing, section access, Load Balancing, Data Modeling, managing virtual proxies, and Server-Side Extension (SSE), AAI

(POC), token management, Developed/Enhanced third-party extensions, widgets, Qlik mashups, hypercubes using JavaScript, AngularJS, jQuery, require.js, D3.js, connecting Qlik with Python for forecasting/predictive analysis and used Libraries - NumPy & Pandas.

• Worked on QlikView APIs – Engine API, Repository API(QRS), and Proxy (QPS) using POSTMAN to extract information related to Tasks, Apps, App Objects, and Qlik Extensions.

• Worked on Power BI Desktop/Service - Developed customized complex, calculated measures using DAX (Data Analysis Expressions) / MDX Querying Language including time intelligence.

• Successfully implemented Qlik and Power BI features - ETL, user/app security, DAX, MDX Query, incremental load, dynamic Qlik NPrinting reports, Web Connectors, GeoAnalytics, BigData Analytics.

• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived in different environments in Data Load Editor.

• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.

• Provided new users with guided training for a better understanding of QlikView, Qlik Sense and its documentation.

• Performed dashboard development and enhanced/resolved bugs for multiple client’s departments. Environment: QlikView Enterprise, Qlik Sense (Jun 19 P1/ P2), Tableau Server/Desktop, Power BI Desktop / Service, Qlik NPrinting, Agile, SAP Business Objects, Python, MS Excel/Office Suite, Postman, Oracle, SQL, JavaScript, AJAX, jQuery, HTML5, CSS3. Verizon Communications Inc. Jun 17- Nov 19

Business Intelligence Engineer Irving, TX

• Developed and implemented visual data reports and created personalized, interactive, dynamic data visualizations, reports, and dashboards from multiple data sources to manipulate complex data sets.

• Worked closely with Scrum Master, Project Managers, business personnel and peers for daily standup scrum calls, and project reviews / retrospectives / bug resolutions / discussions.

• Regularly reviewed business requirements and analyzing data sources designing, developing, testing, and producing reports/projects within Qlik/Tableau.

• Demonstrated in-depth knowledge of Qlik’s 3-tier architecture, overlooked continuous enhancements for multiple projects, data modeling, and performing ETL implementing data warehousing techniques and schemas - snowflake and star utilizing various data sources, ensuring optimal performance.

• Developed complex dashboards using Tableau/D3 and python by extracting data from different sources like OLE DB, ODBC, AWS - RedShift, HDFS, and flat files.

• Worked towards setting up Qlik NPrinting, ODAG apps for consuming Transactional Data, load balancing, scalability testing - JMeter and Qlik Scalability tools using proxies and virtual proxies, managing repositories, schedulers, and certificates.

• Developed highly customized Qlik NPrinting Reports in PowerPoint, Word and Excel for the executives and business users to keep them updated by applying section access and various filters.

• Designed, developed, tested, and maintained Tableau functional rich Graphic Visualization reports using dynamic filtering Drill-down/Drop-down menu options, data blending parameters and LOD calculations, Quick Table calculations, applying advanced analysis using Actions filters, Background images, Maps, Trend Lines, Statistical calculations on charts from multiple data sources by blending data based on user requirements.

• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, and Density Chart.

• Created database objects like tables, views, procedures, triggers, functions, and used Query Analyzer for optimization.

• Migrated the existing oracle scripts to hive scripts using HQL in the Hadoop platform for data usage. Environment: Qlik Enterprise (Jun 17 - Jun 19 P1), Qlik NPrinting, Tableau Desktop (10.4 & 10.5)/Server, Talend Data Integration, JIRA, Confluence Python, Microsoft Visual Studio, JMeter, GitLab, JavaScript, jQuery, SQL Server(T-SQL), AWS Redshift, Apache Oozie, HIVE. Lowes Companies Inc. Feb 15 – May 17

Data Analyst Mooresville, NC

• Migrated the existing oracle scripts to hive scripts using HQL in the Hadoop platform for data usage.

• Extensive working knowledge of QlikView and Tableau Server/Desktop while understanding business challenges and provided calculated reporting solutions and developed prototypes using SQL and SAP Business Objects.

• Responsible for indexing activities demonstrating seasoned SQL skills (Oracle and T-SQL) in analyzing and validating SSIS ETL data warehouse processes.

• Successfully interpreted data in order to draw conclusions for managerial actions and strategy.

• Responsible for physical/logical data modeling, documenting detailed metadata, user, technical, and production specs developing detailed ERDs and DFDs using various modeling tools and techniques in SDLC.

• Strong interpersonal and communication skills within all levels of the organization and familiarity of regulatory mandates and internal controls.

• Worked on data standardization creating database layers with materialized views applying data security in SSMS for QlikView and Tableau dashboard development.

• Actively participated in Qlik Community to help fellow Qlik Users while implementing business requirements.

• Worked extensively on QlikView and Tableau Chart Scripting - implementing complex calculations through set analysis, default data filtering, using dynamic runtime Action filters, Parameters, LOD calculations, Quick Table calculations, and using data blending for various data sources.

• Developed data conversion strategy, statistical techniques for data migration, and hypothesis testing from legacy systems to Technology product modules.

• Wrote complex SQL Queries including store procedures, views, clustered / non-clustered indexes, highly complex joins for data manipulation, performance tuning, index tuning, and ETL processes. Environment: QlikView, Tableau Desktop (10.4 & 10.5)/Server, SSMS/SSRS, Oracle, Teradata, Data Mining, Data Modeling, SQL Server, T-SQL, MS Office Suite (Excel / PowerPoint), GitLab. Hathway Cable and Datacomm. Ltd. Aug 11 – Oct 12

Jr. Data Analyst India

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

• Deployed rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

• Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently.

• Extensively involved in creating graphs by using measures and dimensions using data blending concept.

• Worked with advanced analysis Actions, Calculations, Parameters, Maps, Trend Lines, Statistics and table calculations.

• Provided Production support to Tableau users and wrote Custom SQL to support business requirements.

• Responsible for creating calculated fields, combined fields, bins, sets, geocoding, and hierarchies using Tableau Desktop.

Environment: Tableau Desktop 6.x, SQL Server 2008, IBM DB2, MS Access, Windows 2007 server, MS Office 2007.

Contact this candidate