Reporting Lead Developer
Demonstrated experience with Looker.
Demonstrated experience with Tableau (Desktop/Server/Reader/Public/Mobile).
Demonstrated experience with Crystal Reports XI.
Demonstrated experience with Business Objects.
Demonstrated experience with OBIEE.
Reporting Lead Developer open to new opportunities
Work with a cross-functional team of developers and business analysts to deliver on strategic data and analytics initiatives.. Lead developer of the Looker environment and supporting the business decision process.. Worked on LookML extensively.. Version controlling via GIT.. Implement continuous integration (CI) and continuous deployment (CD) pipelines to automate the testing, building, and deployment processes of BI reporting solutions.. Implement advanced Looker functionalities such as derived tables, templated filters, and custom visualizations to meet complex reporting requirements and enhance user experience. Worked on Table filters and custom formatting.. Assess code quality, including resolution of validation errors and warnings.. Act as the subject matter expert for Looker and promote knowledge across the McKesson community. Develop, analyze, and modify processes, data structures, and models. Implementing looker best practices.. Integrate Looker API into web applications or portals to embed Looker reports, dashboards, and visualizations directly within the user interface, providing users with seamless access to analytics insights without switching between applications.. Develop ‘Explores’ in working with the data warehousing team and product management to allow users to do Ad hoc reporting.. Expertise in database technologies such as Redshift, Snowflake, PostgreSQL, and working with large sets of data.. Maintain the health of LookML projects in a given scenario, including ensuring existing contents are working (e.g., Content Validator, audit, search for errors).. Facilitate knowledge transfer sessions with the support team to ensure they are equipped with the necessary technical knowledge to handle common issues independently.. Collaborate with the support team to prioritize and triage incoming issues, determining severity and impact on users.. Ensure that support processes, troubleshooting guides, and known issues are documented accurately and kept up-to-date to assist both the support team and end-users.
Full life-cycle development and implementation of BI in enterprise wide.. Leading the Tableau, Qlikview and QlikSense development environment.. 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.. Building the Qlik Sense advanced Mashups and Themes. Performance tuning of SQL Queries.. Attribute based access control and role creation.. JMETER setup and Scalability Tests of QlikSense and Qlikview dashboards.. QlikView and QlikSense Extensions.. Qlik APIs and building the custom solutions.. 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.. 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.. Developed Many Qliksense templates, themes, master library items and story generation.. Studied the existing data model and incorporated the new fields including static and dynamic flag fields to meet with the business requirements.. 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).. Worked on integrating NPrinting setup with Qlikview reports for creating automated Pixel Perfect reports and Office Reports.. Qlikview data modelling by building the Star schema and resolving loops/synthetic keys following Qlikview dashboards optimization.. Working with all types of data loads and functions like Automap.. Worked on bulk volume of data sets and different data sources like .csv files, oracle tables, excel files, images, etc.
Worked on all phases of data warehouse lifecycle, from gathering requirements to testing, implementation, and support.. Analyzed the business requirements from the given specifications.. Involved in developing the Audit, Complaint Management, and Event management related reports using Web Intelligence.. Designed Queries and developed universe for the WebI Reporting needs.. Modified the existing Universe and created New Universe against Oracle database as per the reporting requirement to add new features to the reports.. Developed the reports in Reports Designer using Vertical stacked chart, Pie Chart to view the quarterly metrics.. Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common reports.. Created parameter driven reports according to user requirements using Web I.. Documented Design Documents for reports to provide the detail design and explanation of the reports. And documented Unit Test documents to evaluate and validate reports.. Created Universe consisting of Derived tables to create the report for different Business Segments.. Involved in troubleshooting and tuning of the existing reports.
Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs for Loyalty Program.. Solving and helping the users with the data issues in the Customer aggregate project, Transaction aggregate.. Performed data analysis and extracted data from various tables in the Enterprise Data Warehouse to identify the problem with the existing data and prepared documentation on the ongoing fix and data issues.. Interacted with end-users and functional analysts to gather and identify the requirements for developing Customer Analytics Platform.. Interacted with business users and performed Gap Analysis of Client requirements.. Analyzed dimensional and fact tables in data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.. Worked closely with business power users to create reports/dashboards using tableau desktop.. Worked with technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.. Produced accurate analysis of project datasets as defined by the required specification.. Built compelling, interactive dashboards in Tableau that answer key business questions.. Created very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.. Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.. Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.