SUMMARY

• More than 6 years of IT experience in fields of design, development, implementation, testing and production support.
• Have been successfully delivered Business Intelligence solutions using Qlikview and QlikSense
• Professional Experience in Data Extraction, Data modeling, and Data Reporting.
• Professional Experience with Advanced scripting for extracting, transforming and loading (ETL), to structure the data model as star schema.
• Strong background in gathering the requirements for reporting and analysis, developing the design matrix of reports to capture objectives, KPI’s
• Experience in developing different analytical applications using QlikView/QlikSense Qlikview - Publisher and Server.
• Experience working with QMC troubleshooting with services using log files.
• Strong experience in writing scripts to load data in optimized way, through joining, concatenating, mapping and exist.
• Strong Hands on experience in front end objects like ListBoxes, MultiBoxes, Tables, Charts(Straight tables, Pivot tables, Line charts, Bar charts, Gauges, heat maps, etc..) Buttons, creating variables, calculated expressions, as aggregated functions and basics.
• Experience in extracting data from different databases like Oracle, SQL Server, flat files, QVDs XML files and connecting to SAP data-sources and different application tables of SAP to generate different dashboard style reporting user interfaces.
• Worked with QA business resources to complete the System and Integration Testing. Based on documented Test Plans and completed Unit Testing of Developed Objects and Reports.

TECHNICAL SKILLS

Languages: HTML, PHP, CSS, SQL, JavaScript, XML, PYTHON, C#, VB

ERP: Oracle, SAP

Data warehousing & Business Intelligence: Qlikview, Tableau

Databases: MS SQL Server, Oracle, MS Access and MYSQL

Software Tools: Qlikview, Qliksence, Visio, Lotus Notes, Primavera P6, MS Project.

Platforms: Windows Server, Linux (Ubuntu)

PROFESSIONAL EXPERIENCE

Confidential, Mason MI

Design Engineer

Responsibilities:

• Led the team of 3 developers and recommended best practices and Qlik standards of coding and solutions.
• Involved in various stages of Projects including, requirement gathering, and proof of concept (POC), analysis and design, scripting, development, testing, optimization, documentation and production support.
• Played multiple roles of administration includes installation, configuration, upgrade, scheduling, monitoring and clustering in QlikView.
• Have created QlikView objects (bar chart, pie chart and combo chart) from SAP data through Installing and configuring the SAP connector
• Created QlikView dashboard which gets an overview of the organization and which can be drilldown to an operational level.
• Provided mentoring and consulting to other BI team members.
• Developed Qlikview applications by leveraging Mapping, ApplyMap, exists, Interval match, inline, joins, preceding load statement, no concatenate, concatenate, let and set, peek, previous, actions and triggers, set analysis, variables, cyclic groups, drill downs, trellis chart, etc..
• Configuring the Qlik apps on the publisher to set the user security, data access, schedule, triggers and publish it on the server.
• Published, scheduled and distributed static excel and pdf reports to end user community

Confidential

Design & Development Manager

Responsibilities:

• Conducted user’s training by demonstrating sessions to educate the end users being a part of the highly caring team to support and resolve the issues of end users.
• Played a critical role in company’s adoption of the system not only resolving the issues as well as modifying the system to make it more user friendly.
• Gathered requirements and develop the object matrix of all the reporting requirements. Documented all the detailed design technical requirements.
• Created Dataflow and designed the BI Landscape using MS Visio.
• Worked extensively in activation and configuration of Business Content in lower environments; transported several BI objects from Dev Server to QA Environment using transport connection
• Intensively used Microsoft SQL Server Integration Services (SSIS) to keep that Data clean.
• Created dashboard style of layouts using HTML, JavaScript, SQL and PHP
• Being a Strong planner and organizer with demonstrating ability to master new concepts quickly, incorporated the latest technology and introduced the Qlikview for dashboard repotting.
• Created dashboard style of layouts using different components of QlikView like Listboxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc...
• Extracted information from disparate data sources like excel files, flat files and Transformed into relational by Loading in Qlikview (ETL), formed in star schema with the help of joins, resident, concatenate, exist, qualify, unqualify, etc…
• Created help functionality on front end objects like charts, list boxes, multi boxes by maintain help statements for initial require inputs
• Customized and tweaked the scripts for cross-tables and generic loads and created simple and complex expressions.
• Created custom macros with JavaScript to meet the complex reporting requirements
• Exported reports to different formats (Excel, PDF) based on the user requirements,
• Executed IoT project should I say intranet of Thing Project. For collecting the data of Compressors in plant