SUMMARY:

• 9 Years of real time IT experience in analysis, design, development and implementation of Business intelligence applications.
• 2+ Years of Looker experience in both Development and administration.
• Worked on Looker from 3.x to 6.x versions.
• Expert in LookML. Experience in advanced D3 visualizations and adding them to Looker.
• Expert in SQL and Query tuning.
• Active directory integration
• AWS and Azure experience
• Converted reports from Qliksense, Tableau to Looker
• Strong experience in Looker Administration.
• Strong experience with GIT workflow for version controlling.
• Expert in building the Looker dashboards and Looks.
• Expert in building the projects, Model and Views.
• Migrating the dashboards from other BI tools to Looker.
• Experience in all the major databases including Oracle, Amazon redshift, SQL server, SAP, DB2, Sybase, Greenplum.
• Embedding via Looker.
• Experience in Geographic analytics using Looker.
• Implemented Centre of Excellence for Looker development.
• Experience in setting up the data actions in Looker.
• Experience in Looker custom table calculations like offset etc.
• Proficiency in Parameter select, template filters and derived tables.
• Experience in Tableau.
• Certified in Qliksense and Qlikview both as development and administration.
• Strong experience in Performance optimization
• Experience in dimensional modelling using star and snow flake schemas. Very strong knowledge on data warehouse and data base concepts.
• Experience in error handling and debugging of Looker reports. Expert in handling production issues like reportfailures, missing counts in reports, resolving synthetic keys, Loops.
• Automating the Monitoring of the server and Fog light monitoring.
• Defining and implementing the Best Practices and Excellence.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Experience with Full Software Development Life Cycle (SDLC) from inception to delivery of product including requirements gathering, functional specification, design, estimation, implementation, debugging, documentation, Project Release and Production support.
• Highly motivated self - starter team player who is organized and methodical.

TECHNICAL SKILLS

Tools & Technologies: Looker 6.x,5.x, SAP Business objects,Qlikview, Qliksense, Tableau and Power BI, Studio 6.0/5.5.0

Languages: Java Script, D3, Node Js, SQL, T-SQL and PL/SQL

Database: Red Shift, Greenplum, SQL Server, Oracle 11g,Hadoop,Impala, Sybase, Big Data, SQL Server, Teradata, DB2, MS Access, HP Vertica

ETL Tools: Informatica

Operating systems: Windows 2008/2012 Server

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Sr Looker Developer

Responsibilities:

• Leading and managing the Looker environment and supporting the business decision process.
• Installing, configuring Looker Environment.
• GIT workflow for version controlling.
• Active directory integration
• AWS and Azure experience
• Converted reports from QlikSense, Tableau to Looker
• Building the projects, Model and Views.
• Migrating the dashboards from other BI tools to Looker.
• Embedding via Looker.
• Geographic analytics using Looker.
• Building the UI wireframes for the dashboard development
• Implementing Centre of Excellence for Looker development.
• Creating the Looks and Looker dashboards.
• Working directly with business users and gathering the requirements and use cases.
• Creating the views using the LookML
• Building the Model and Project
• Conditional Formatting.
• D3 visualizations and adding them to Looker.
• SQL Query tuning.
• Setting up the data actions in Looker Table calculations in Looker.
• Built the dashboards in Parameter select, template filters and derived tables.
• Creating the Qlikview and Qlik Sense dashboards and charts and performance optimization.
• Creating the optimized views for the faster data retrieval.
• Looker integration with the other tools.
• Looker custom table calculations like offset etc.
• Implementing the coding standards and best practices for Looker.
• Building the derived tables with the SQL runner Flow.

Environment:Looker 6.x,5.x, Qlik Sense November 2017, 3.2, Qlikview 12.1, Oracle, Amazon Redshift, SQL Server, Greenplum, MS Access, MySQL 5.3, Qlik SAP Connector, Hadoop HIVE.

Confidential - Englewood, CO

Sr. Business intelligence Consultant

Responsibilities:

• Full life-cycle development and implementation of BI in enterprise wide.
• Leading the Tableau, Qlikview and QlikSense development environment.
• Experience in error handling and debugging of QlikSense and Qlikview reports. Expert in handling production issues like report failures, missing counts in reports, resolving synthetic keys, Loops.
• QlikView and QlikSense development.
• QlikView and QlikSense Seta analysis, Data Modelling. Creating the Qlik Sense dashboards and charts and Qlik Sense performance optimization.
• Customizing the QlikSense Extensions using Java script and D3.
• Handled big data in Qlik Sense.
• Handling big data loads to QlikView and QlikSense and implemented impactful solutions.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques
• Having experience in developing the QlikSense/QlikView environment and supporting the business decisions process.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Qlik BI suite.
• Working with User for requirements and part of the team developing the software.
• Publish Qlik workbooks to cloud and schedule the refresh of data. Specialized in analysing the incremental refresh scenarios.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Created Qlik scorecards, dashboards, Heat maps using show me functionality.
• Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Consolidated data into QlikView from various data sources (SQL Database, Oracle Database, Xml, HTML, Green plum, Text files and Excel files).
• Working with all types of data loads and functions like Automap.

Environment: Qliksense, Qlikview dashboard, Business Objects, SVN, Curran 5.2, Oracle 10g/11g, Subversions, Service Now, MS SQL Server, SAP BW

Confidential

Sr. Qlikview Developer

Responsibilities:

• Developed highly customized QlikView, QlikSense, dashboard applications.
• Qlikview and Qlik Sense Design, Development and Administration.
• SSRS to QlikView report development.
• Created the report datasets in SSIS and OBIEE.
• Created a navigational system that utilized QV hierarchy that used weights to identify values.
• Worked on enhancements and Performance tuning of existing Apps.
• Implemented Security & involved in Deployment of QlikView Applications.
• Back traced data to make sure it works cohesively as well as accurately by looking for discrepancies such as duplicates, rescinded information etc...
• Designed and developed a wide variety of charts and associated sheet objects to satisfy complex business requirements was given the task to define major KPI so analysed, brainstormed the needs of the company and created a trigger system that alerted higher ups in problems with any unit of measure they are measuring or would fall under their jurisdiction to know the status of.
• Wrote Complex set analysis statements.
• Used SQL Server Management Studio, TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Code review as well as fine tuning of applications as well as fixing data model.
• Scheduled tasks in server and Troubleshoot application in access point as well provided maintenance.
• Designed Graphical User Interface with Qlikview Extension objects according to requirement.
• Qlikview Data Modelling.

Confidential

SAP BO Consultant

Responsibilities:

• Gathered requirements and written load scripts. Customized dash board by using expressions, Book Marks, Functions, Dynamic charts, Filters, Action triggers and system variables.
• Implemented section access security.
• Used the Business Objects for standard reporting.
• Resolved dashboard data issues by modifying load scripts.
• Created incremental load scripts for products and customers using multiple data source.
• Resolved data load issues like synthetic keys.
• Developed complex QV dashboards like product, Event, Therapy, Region and sales with multiple sheets using boxes, buttons, charts, cyclic groups and drill-down groups.
• Implemented NT Based security based on business requirements