Data Python

Name: Kuldeep Matharasi

Phone: 618-***-****

Email ID: **********@*****.***

Designation: SR SPOTFIRE DEVELOPER

PROFESSIONAL SUMMARY:

• Total 10 years of IT experience and 7 years of experience in Data Visualization development using Spotfire, Tableau and Power BI to create complex, intuitive, and innovative dashboards from multiple data sources.

•Experience in Data Analysis

•Worked with ETL team for dataset creation

•Have knowledge of Spotfire architecture, Spotfire Client, Spotfire Webplayer, TIBCO Automation Services, admin roles,responsibilities and migration procedures.

•Conceptual knowledge in Data modeling concepts.

•Experience in SQL Queries, Views and Stored Procedures,.

•Strong analytical, presentation, problem solving and excellent inter-personal skills, ability to work independently and active team player with proven work ethics and leadership qualities.

SKILLS SUMMARY:

Operating Systems : Win, UNIX, Linux.

Languages : Java, C, SQL, PL/SQL.

Database Systems : My SQL, Oracle 8i/9i/10g/11g,SQL Server, MS Access.

Scripting : Perl, Python, UNIX, Iron Python for Spotfire

Reporting Tools : TIBCO Spotfire Professional Desktop, Spotfire Server, Web Player,

Power BI, Power BI Service, Tableau Desktop, Tableau Server.

Web Technologies : HTML, CSS, Java Script.

Agile Methodologies : Agile, Waterfall and Scrum Models.

IDE Tools : Eclipse IDE, Jupyter Notebook, Pycharm

Application Software : SVN, CVS, Microsoft Word, Excel, PowerPoint, Outlook.

PROFESSIONAL EXPERIENCE:

Dolphin Solutions Inc., Florida Jan 2016 – Current

Title: Spotfire Developer

Client: Bayer Crop Science / Monsanto

Project Description: Project Portfolio

Developed Portfolio Management Dashboard to enable stake holders to track the projects by status, portfolios and region. Track the budget and hours for the projects.

Responsibilities:

Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.

Worked extensively to provide end-to-end project management from requirements gathering and

analysis, through implementation, and post implementation support.

Translate product requirements and business questions into report requirements and visualization dashboards.

Created dynamic charts including bar charts, line charts for trending, cross

tables, tables,pie charts and text area for dynamic presentation/calculations..

Implemented complex filtering schemes using Iron Python.

Implemented dynamic year calculations using property controls in the text area.

Implemented complex calculations to transform the data to be presented in the charts .

Extended the spotfire functionality using Java Script and Iron Python .

Customized filter capabilities in the text area.

Developed Information Links as one of the data source.

Implemented data scripts to export data from data base to text files.

Scheduled Spotfire Automation Services jobs to refresh the dashboard at scheduled times.

Environment: TIBCO Spotfire 7.12 (Professional clients, Spotfire Web Player, Automations, Web Player Server), Oracle 11g, .NET Framework 4.0, Microsoft Internet Information Services 7.0, ASP.NET 4.0.

Project Description: Service Now Evaluation

Worked on Service Now tool and reporting to assess the feasibility, functionality of operational and enterprise level dashboard.

Project Description: SLA Tracking

Purpose of the dashboard is to have one central area to view and measure MSP and Monsanto SLA's for operational purposes. Ideally, the users will be able to view all SLA's by default,

then use filtering to view SLA results by Company, Process, Assigned Support Group, SLA Type and SLA Status .

Users will be able to see the kpi’s with daily, weekly or monthly trend, up/down arrows and color coding to indicate whether the result Met or Missed the SLA target for the KPI.

Responsibilities:

Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.

Worked extensively to provide end-to-end project management from requirements gathering and

analysis, through implementation, and post implementation support.

Translate product requirements and business questions into report requirements and visualization dashboards.

Created dynamic visualizations in Power BI and Spotfire.

Worked on Power BI Query Editor, data modelling and calculations to transform the data.

Implemented complex calculation using DAX.

Implemented several visualizations like gauge, map chart, cross table, bar chart, kpi chart, line and stacked chart, spark lines and implemented visualization in tooltip,

Implemented slicers.

Environment: Power BI Desktop, Power BI Service.

Project Description: ITLT Services

This dashboard is used to measure the Availability % of Foundational Services and Critical Services over the last 6 months period and indicates upward /downward trend over previous month.

This will help the ITLT members to analyze the trends and make decisions to improve the performance of the services.

Responsibilities:

Developed the dashboard in Power BI and Spotfire.

Worked on Power BI Query Editor, data modelling and calculations to transform the data.

Implemented complex calculation using DAX.

Implemented slicers.

Implemented graphical table and text area for dynamic presentation/calculations.

Implemented dynamic month/year calculations using property controls in the text area.

Implemented complex calculations to transform the data to be presented in the charts.

Environment: Power BI Desktop, Power BI Service, TIBCO Spotfire 7.12 (Professional clients, Spotfire Web Player, Automations, Web Player Server), Oracle 11g, .NET Framework 4.0, Microsoft Internet Information Services 7.0, ASP.NET 4.0.

Project Description: ITSM Service Integration

Built a single pane of glass dashboard that enables Digital Foundations and the IT organization to measure performance of our IT services as well as our ITSM processes like Incident, Service Request, Knowledge Change and Problem Management and Continuous Improvement. Key Performance Indicators (KPI) have been developed for each process area and custom filters allow users to slice and dice the data in the several ways based on their requirement.

Responsibilities:

Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.

Worked extensively to provide end-to-end project management from requirements gathering and

analysis, through implementation, and post implementation support.

Translate product requirements and business questions into report requirements and visualization dashboards.

Created several dynamic charts including bar charts, line charts for trending, cross tables, tables,pie charts, spark lines and text area for dynamic presentation/calculations.

Implemented complex filtering schemes using Iron Python.

Implemented dynamic year calculations using property controls in the text area.

Implemented complex calculations to transform the data to be presented in the charts .

Extended the spotfire functionality using Java Script and Iron Python.

Customized filter capabilities in the slide out menu.

Implemented data scripts to export data from data base to text files.

Scheduled Spotfire Automation Services jobs to refresh the dashboard at scheduled times.

Environment: TIBCO Spotfire 7.12 (Professional clients, Spotfire Web Player, Automations, Web Player Server), Oracle 11g, .NET Framework 4.0, Microsoft Internet Information Services 7.0, ASP.NET 4.0.

Project Description: Monsanto IT Go Green

Created the IT Go Green Dashboard to benefit all stakeholders of the process including Process Owners, Service Managers, and IT Leadership. The new dashboard allows teams to review their performance in managing tickets using industry standard ticket management key performance indicators, perform trending and analysis with backlogs and provides data-driven metrics for teams and individuals to gain insights to facilitate remediation of incidents and work orders and identify service improvement opportunities.

Responsibilities:

Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.

Worked extensively to provide end-to-end project management from requirements gathering and

analysis, through implementation, and post implementation support.

Translate product requirements and business questions into report requirements and visualization dashboards.

Created several dynamic charts including bar charts, line charts for trending, cross tables, tables,pie charts, spark lines and text area for dynamic presentation/calculations.

Implemented complex filtering schemes using Iron Python.

Implemented dynamic year calculations using property controls in the text area.

Implemented complex calculations to transform the data to be presented in the charts .

Extended the spotfire functionality using Java Script and Iron Python.

Customized filter capabilities in the slide out menu.

Implemented data scripts to export data from data base to text files.

Scheduled Spotfire Automation Services jobs to refresh the dashboard at scheduled times.

Environment: TIBCO Spotfire 7.12 (Professional clients, Spotfire Web Player, Automations, Web Player Server), Oracle 11g, .NET Framework 4.0, Microsoft Internet Information Services 7.0, ASP.NET 4.0.

Project Description: Metrics Search Portal

This new functionality will allow IT Portal users the ability to search (like on Google.com) with keywords to find IT operational metric visualizations, providing a one-stop, quick and easy method to find metric visualizations that meet their search criteria and interests. Users can search for reports using keywords from the metrics landing page. The search will provide results on a Spotfire page with several features.

Responsibilities:

Implemented the functionality to launch reports from search results

Implemented the functionality to sort reports using metadata such as category, create date, modified date, or last launched.

Implemented the functionality to view a list of all user favorites and likes

Implemented the functionality to create personalized bookmarks for easy retrieval of views

Created a new fly out menu containing filters

Implemented the functionality to see popular reports by sorting on total likes or total favorites

Implemented complex calculations to transform the data and functionalities presented in the dashboard .

Extended the spotfire functionality using Java Script and Iron Python.

Environment: TIBCO Spotfire 7.12 (Professional clients, Spotfire Web Player, Automations, Web Player Server), Oracle 11g, .NET Framework 4.0, Microsoft Internet Information Services 7.0, ASP.NET 4.0.

Dolphin Solutions Inc., Florida December 2014 – Jan 2016

Title: SPOTFIRE DEVELOPER

Client: P&G / TEK Systems

Project Description: Stability Space Visualization (SSV)

The SSV project provides easy access to and analysis of historical stability data to allow

reduction or elimination of new stability studies for new product initiatives. Accessing historical data is currently challenging, often resulting in the placement of new stability programs when a technical rationale recommending no or limited testing based on historical data would have been supportable.

Responsibilities:

Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.

Worked extensively to provide end-to-end project management from requirements gathering and

analysis, through implementation, and post implementation support.

Translate product requirements and business questions into report requirements and visualization dashboards.

Administered users and Library Management, access levels, rights and folder structure.

Designing and developing the information links, Data Source, Columns, Joins, Filtering and Procedures.

Developed Key Performance Indicators (KPI) to enhance management capability and to evaluate vendor performance.

Created dashboards, reports with Bar Charts, Scatter Plots, Map Chats, Pie Charts, Cross

Tables and Graphical tables using the key concepts like filtering scheme (Global Filter), (Local

Filter).

Created Dynamic Visualizations using advanced Trellis, Scatter plots, 3D Scatter Plots, Map charts and Tree Map, Text Area, Input Field, Lists, drop down lists, Property, Document Properties, On-Demand Data and In-Database.

Created the visualizations with complex calculations/functions.

Worked on Information Designer, building Information links, elements, filters, joins, prompts, prompt groups etc.

Code migration across environments (Dev > QA > Prod).

Root cause analysis and fixing the issues with the Spotfire environment.

Analysis of the Server Issues, Library issues, etc

Iron Python scripting to refresh data tables, changing filtering schemes, reset axes, reset marker

size, jittering, refresh calculations, on demand data.

Environment: TIBCO Spotfire 6.5 (Professional clients, Spotfire Web Player, Automations, Web Player Server), Oracle 11g, .NET Framework 4.0, Microsoft Internet Information Services 7.0, ASP.NET 4.0, Windows Server 2008 R2.

Project Name: What’s Made Where

Description: What’s Made Where is a retail project. It is related to the Production, Shipment and Packing Material details of P& G products like Oral Care, Beauty Care and Perfume Analysis.

The end users are the R&D and financial department of P&G who make business decisions.

Based on the reports for Yearly/Quarterly/Monthly Sales and Profits, Top and bottom performing

Products and Formulae across the globe.

Responsibilities:

•Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.

•Worked extensively to provide end-to-end project management from requirements gathering and analysis, through implementation, and post implementation support.

•Translate product requirements and business questions into report requirements and visualization dashboards.

•Created custom SQLs for Information Links from the Information Designer to optimize the performance of the reports.

•Identified the KPI’s for the dashboard requirements

•Created dashboards, reports and advanced graphical virtualizations by using the key concepts filtering schemes, Data on demand, property controls etc. .

•Created the visualizations with complex calculations/functions. .

•Worked on Information Designer, building Information links, elements, filters, joins, prompts, prompt groups etc.

•Created information links using Information designer using parameterized procedures, modified SQL to accept parameters dynamically according to user's requirement.

•Advised on TIBCO Spotfire best practices, tools and specific technical solutions to support complex business requirements.

•Contribute to project plans if needed. Ensure that all tasks undertaken are completed to a quality standard. This includes delivery on time, within the budget and to specification.

•Collaborate with other parts of the technology team, including product, QA, marketing, etc. to deliver solid product.

•Conduct code review of projects, providing feedback. Review technical requirements provided by the business for key projects and concepts from design to delivery.

•Provide solid software/component level designs supporting technical requirements.

•Transfer accrued knowledge to the junior members of team through meetings, walk-throughs, conference calls and other appropriate method.

•Provide constructive feedback to implementation proposals and feature suggestions, either in meetings or in written form when required.

Environment: Spotfire Professional 6.5, Spotfire Server, Spotfire Web Player, Iron Python

Scripting, .NET Framework 4.0

Washington University in St Louis, MO Jul 2010 –Oct 2014

Title: Biomedical Informatics Asst

Project Name: ClinPortal

Description: ClinPortal is a life science domain project. It is a web based portal developed for Clinical Trail Management and Analysis of Clinical data .This application is user comprehensive developed with tailored feature for managing data regarding clinical trials and Patients information.

Responsibilities:

•The application uses java,j2ee to process the data and save in the Oracle database

•Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.

•Worked extensively to provide end-to-end project management from requirements gathering and analysis, through implementation, and post implementation support.

•Translate product requirements and business questions into report requirements and dashboards.

•Identified the KPI’s for the dashboard requirements

•Created dashboards, reports by using the key concepts

•Created the reports with complex calculations/functions.

•Deploy the developed reports in production environment.

Environment: JDK1.6, J2EE, Oracle 10, SVN, Maven,JDBC, Windows, Unix.

REFERENCES:

References are available upon request.

Contact this candidate