Management Sales

Sanjaykumar Maisuria

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

Mobile: 908-***-****

Professional Summary:

• 11 + years of work experience in Analysis, Design, Development and Maintenance of various

Business Intelligence and Analytic projects in industry verticals like Health Care, Marketing, oil

& Gases and Finances

• Extensive experience in TIBCO Spotfire Professional and TIBCO Spotfire Web Player

component to perform business analytics on various business processes.

• Deep conceptual knowledge and hands on experience on Visualizations, Details on Demand,

Information Designer, Automation Job Builder, Property controls, Action controls, filters and

custom plugin, Library Administrator, ADS, In-memory Architecture.

• Created dashboards, reports, analytics and advanced data visualizations

• Responsible for Spotfire Administrative tasks, installation/configuration of servers and

supporting the implementation of TIBCO Spotfire products.

• Excellent data skills, including the ability to analyze, visualize, and present data in a clear and

concise manner.

• Strong SQL skills including use of nested table expressions, unions, multi-table joins

• Expert in creating various PL/SQL stored procedures, views, functions and temporary tables for

data input to the Crystal Reports

• Expert in creating Complex Crystal Reports (Ad Hoc Reports, Frequency Reports, Summary

Reports, Drill-down, Dynamic grouping, graphical, aging reports)

• Have strong understanding of Data Modeling concepts (Relational, dimensional, Star and

Snowflake Schema), Data analysis, implementation of Data warehouse.

• Excellent knowledge on SQL Server Integration Service (SSIS), SQL Analysis Services

(SSAS) and Reporting Services (SSRS).

• Strong experience in .Net Technologies in Design, Development, Implementation and Testing

of Software Applications.

• Specialist in Validation/Implementation/SDLC, Quality Analysis, ARGUS Drug Safety Systems.

• Ability to understand, analyze and design business processes and workflows with the objective of

providing recommendations for the best use of technology for improvement.

• Excellent communication and Inter personnel skills. Exceptional ability to learn and master new

technologies and to deliver outputs in short deadlines.

Technical Skills Summary:

Business Intelligence / : Spotfire Professional 3.0, 4.0, 5.0, 6.0, 6.5 Spotfire Server,

Visualization Tools Spotfire S+, Spotfire Automation Service, Spotfire Web Player,

Spotfire Application Data Services, Tableau 6.0, 7.0

RDBMS / DBMS : MS SQL Server 2008, 2010, Oracle 7.x, 8i, 9i, 10g, Sybase 10.0,

MS-Access 2010, MySQL 5.0/5.1/5.5,

Data Warehouse & Report : Crystal Report 2008, Business Object XI 3.1, SSIS, SSRS,

Hyperion

Essbase

Statistical Language & Tools : R, R Studio, WEKA, S+

Languages : C, C++, C#, Sun JAVA 1.4, 5.0, 6.0, SQL, PL/SQL

Script Language : Iron Python Script, Shellscripts

OS : Sun Solaris, Linux, Win XP, Windows 7, Win 95/98/NT,

Win2000,

Ubuntu 8.10, 9.10

Application Servers : Tomcat 5.5/4.0/6.0/7.0, Web Logic 9.1/8.1/7.1/6.0, Windows

2003 Server, IIS 7.0

Web Technologies : Java Script, ASP, ASPX, XML HTML, DHTML, CSS

Projects Profile

Baker Hughes July 2014 to

Continue

Data Analyst / Business Intelligence Developer (Tibco Spotfire )

Houston, TX

Project: Business Pulse – North America Executive Dashboard

The goal of the project to provide the key potential information to management; Project consists of the

landing page and detail page. Landing page has 16 KPI’s for various departments. This dynamic KPI’s are

provided high level information to management on the daily, weekly, monthly and quarterly basis. Users

can click on the each of the KPI to get the detail level of information. Each page consists of various levels

of filters so users can filter the data according to their need. Detail pages display the various charts,

graphs, visualizations and tables to compare the number from current period to prior period as well as

predication for next period.

Responsibilities:

• Requirement gathering and discussion with business users to come-up with a feasible solutions

• Improve the look and feel of the site using Cascading Style Sheets, HTML and JavaScript

using in text area

• Developing and debugging many Dashboards / Reports with different Analytics Views ( Pivot

Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic /

Interactive Dashboards with drill-down capabilities using global and local Filters.

• Performed the analytical analysis, use different visualization methods like Bar Chart, Line

Chart, Combination Chart, Scatter Chart, Heat Map and Cross Tables.

• Configured Waterfall Chart to understanding how initial net revenue is affected by a series of

intermediate positive (revenue) or negative (cost) values.

• Worked on Information designer, building Information links, elements, filters, joins, prompts,

prompt groups etc.

• Created visualizations using advanced concept of data on demand, in-database connections to

increase greater performance in user analytics.

• Using Multiple Linear Regression and Node Navigation Method to predicate the result for

the next coming Quarter and Year.

• Creating various PL/SQL stored procedures, views, functions and temporary tables for data input

to the applications.

• Writing script in Iron Python language to make the application easy to use, improve user

interface of the application.

• Provide post production support to the end-users.

Environment: Tibco Spotfire 5.0/6.5 (Professional clients, Spotfire Web Player, Automations, Web

Player Server), Microsoft SQL Server 2010/2012, PL/SQL, .NET Framework 4.0, Microsoft Internet

Information Services 7.0, ASP.NET 4.0, Windows Server 2008 R2, C#, HTML 5.0, JavaScript, ASP.NET

4.0

Ernst & Young January 2014 to

June 2014

Data Analyst Business Intelligence Developer (Tibco Spotfire )

Boston, MA

Project: EY Audit Transformation (Intelligent Data Analytics)

Ernst & Young provides assurance (including financial audit), tax, consulting and advisory services to

their clients. The goal of the project to improving the information or the context of the information so that

decision makers can make more informed, and presumably better decisions. This project will provide

independent and professional opinions that reduce the information risk (risk that comes from incorrect

information). This project will help to their clients to identify the existence of unusual transactions,

events, amounts, ratios or trends in key financial statement. This analysis will help to investigate

fluctuations in gross margin that do not meet expectations.

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.

• Lead all the prototype creations for the R&D effort involved w.r.t TIBCO Spotfire Visualizations

and Extension development.

• Created dashboards, reports, analytics and advanced graphical virtualizations by using the key

concepts filtering scheme (Global Filter), 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 and managed process analysts work to realize the required solution

from a data perspective.

• Created visualizations using advanced concept of data on demand and marking functionality in

spotfire to increase greater performance in user analytics.

• Responsible in writing scripts (Iron Python) to create action controls, buttons and property

controls to increase user friendliness to perform analytics.

• Used Tagging functionality through Iron Python script so user can select the accounts and

compare them for various businesses prospective, wrote script to replace visualization, reset all

zoom sliders and perform complex business logic.

• Experienced in configuring and administering Spotfire Server components TIBCO Spotfire

Application Data Services and Automation Services.

• Created information links using Information designer using parameterized procedures,

modified SQL to accept parameters dynamically according to user’s requirement.

• Responsible for Spotfire platform administration tasks, Spotfire database administration tasks,

and providing production and operational systems support to Clients and Stakeholders

• Advised on Tibco Spotfire best practices, tools and specific technical solutions to support

complex business requirements.

Environment: Tibco Spotfire 5.0 (Professional clients, Spotfire Web Player, Automations, Web Player

Server), Microsoft SQL Server 2010/2012, PL/SQL, .NET Framework 4.0, Microsoft Internet

Information Services 7.0, ASP.NET 4.0, Windows Server 2008 R2

News America Marketing October 2008 – December

2013

Data Analyst / Business Intelligence Developer (consultant)

Wilton, CT

Data Analyst November 2011 –

December 2013

Project: In Store Order Processing Application

NAM has various existing systems like In-Store OM, Retail, Sales and Reservations, Production/Cycle

Planning, Credit Monitoring etc. Those systems are isolated or less integrated with its functionality for

business prospective. New system will replace/enhance the existing systems to provide single point of

access for the entire order processing lifecycle with following key aspects, Better management of

chain/store and recommendations, Facilitate cycle flexibility, Implement enhanced credit checking

capability and Improve system integration and accuracy

Responsibilities:

• Analyzed Business and Functional requirements documents

• Configured the Information Links based on the limitation of the User Groups under Information

Designer.

• Performed the analytical analysis, use different visualization methods like Bar Chart, Line Chart,

Combination Chart, Scatter Chart, Heat Map and Cross Tables.

• Built interactive dashboards for upper management that can provide quick information at a

glance.

• Used Bookmarks to Create Guided Analysis to predicate the result for next coming years based

on analytical analysis.

• Structured the Spotfire library to publish and share all the analysis material, information links,

data sources, etc.

Environment: Tibco Spotfire 4.5 (Professional clients, Spotfire Web Player, Automations, Web Player

Server) Oracle 10g, PL/SQL, .NET Framework 4.0, Microsoft Internet Information Services 7.0,

ASP.NET 4.0, Windows Server 2008 R2

Data Analyst June 2010 –

October 2011

Project: Store List Engine

Store List Engine provides NAM with the capability of generating real time stores lists to various levels

of abstraction. The output displays total selected, available, blocked (RS1, RS2, Sold and Restricted)

stores.

Responsibilities:

• Assessed, defined, and clarified functional and data requirements using TIBCO Spotfire

• Cleansing the data through TIBCO Spotfire to detect the inconsistencies and removed the

corrupt data, transform the data into right reporting format.

• Designed and developed interactive Reports to run in Spotfire Web Player.

• Using Global Variables inside Spotfire to calculate the totals across all countries using US

dollars

• Implemented Custom Expression to look the sales data between two separate range

• Drilling down data, using Marking to visually highlight records of interest for detail

visualization.

• Administrated and maintained Spotfire Server, provided post production support.

Environment: Tibco Spotfire 3.0/3.3 (Professional clients, Spotfire Web Player, Automations, Web

Player Server) Oracle 9i, PL/SQL, .NET Framework 3.5, Microsoft Internet Information Services 6.0,

ASP.NET 2.0, Microsoft ASP.NET AJAX Extensions 1.0

Data Analyst November 2009 –

May 2010

Project: Master Data Management

Master data maintenance is primarily for the maintenance of entities in the ISOP application such as

Product line, Item, Category, Vendor, UPC, Retail Chain & Store Management, Recommendations, Cycle

Maintenance and System Interfaces. Various users like Marketing, Trade Retail, Sales, Control Desk, Pre

Press, Production planning etc. create and maintain these entities through Master Data Management and

those entities are going to be used by ISOP application throughout the Reservation process.

Responsibilities:

• Requirement gathering and discussion with business users to come-up with a feasible solutions

• Loaded the data to perform the analytical analysis and found the correlation among various

restrictions and Product lines.

• Predicate the result for next coming years based on analytical analysis.

• Published and shared all the analysis material, information links, data sources to end user

according to their role and knowledge

Environment: Tibco Spotfire 3.0 (Professional clients, Spotfire Web Player, Automations) Oracle 9i,

PL/SQL, .NET Framework 3.5, Microsoft Internet Information Services 6.0, ASP.NET 2.0, Microsoft

ASP.NET AJAX Extensions 1.0

Crystal Report Developer May 2009 –

October 2009

Project: Category - Brand Application

The Category Brand application is the application that holds the crucial information like, but not limited

to categories and the brands that the clients do business in. it is used to process orders for the same client

or checking exclusivity when booking orders for a different client and placing the artwork in the sales

market.

Responsibilities:

• Developed User Requirement Specification URS documents.

• Loaded data to oracle table using SQL Loader and extensively used export and import

command for loading/unloading data.

• Developed the Stored Procedures for extensively reporting requirement.

• Developed Test scripts and test cases for functional and regression testing.

Environment: Crystal Reports 10/2008, Crystal Enterprise 10, Oracle 9i, PL/SQL, TOAD, SQL

Developer, UNIX, Windows XP and Excel modeling.

Crystal Report Developer October 2008 -

April 2009

Project: Client Credit Check Management

This system provides the organization with a more effective mechanism to proactively monitor credit risk,

potentially saving the company millions of dollars in uncollectible revenue and incurred order production

costs in the process.

Responsibilities:

• Analyze the Business Requirement Document (BRD), Functional Specification Documents to

prepare reporting requirement

• Developed the Stored Procedures for extensively reporting the system and used custom

designed parameters for reports

• Designed and developed the Dashboard to present dashboard data in rich interface.

• Developed Test scripts and test cases for functional and regression testing.

Environment: Crystal Reports 8.5/10, Crystal Enterprise 10, Oracle 10g, MS-Access and TOAD.

Genta Inc, Berkely

Height, NJ

Crystal Reports Developer/ PL/SQL Developer October 2005 – September

2008

Genta, Inc, developed manufactured, marketed and distributed oncology products. The project goal was to

implement an Argus environment integrated with a FDA and EMEA for compliance and regulatory needs

and generated intelligence reports on clinical trial and data collected for adverse effect.

Responsibilities:

Evaluated the business needs and the consumer requirements to create high level

•

design specifications for the reports d evelopment

Administered and maintained the Qumas Document and Content Management

•

application for the Quality Control department.

• Created reports with drill down option, Parameter fields, formulae, and heavy formatting.

• Created Cross Tab Reports, Pie and Bar Charts, and Parameter Reports, Running totals, Sub

Totals and embedded linked and unlinked sub-reports to separate and organize key information and to

promote reusability in data reporting.

• Tested the reports for accuracy using SQL queries in TOAD and SQL Developer.

Wrote Functional Requirements, Test Plan, test scripts for report validation

•

execution, disposition executed scripts, wrote UAT test scripts.

Environment: C rystal Reports 10/2008, Crystal Enterprise 10, Oracle 10g/9i, PL/SQL,

TOAD, SQL Developer, UNIX, Windows XP

FMZ Metal Stamping & Manufacturing, Canada December 2003 to September

2005

.NET Developer April 2004 to

September 2005

Project: Web Based Marketing Management System

Web Based Marketing Management System helps the management to get the benefit from time

management point of view. Optimum output from the least marketing staff should be generated through

such system. At the same time the area wise analysis helps management to compare quantitative from

other area. Management can have the solid proof about their product quality from the customer review.

Responsibilities:

• Involved in full life cycle of analysis, design, and deployment of the project.

• Performed code review and unit tested the application

• Prepare documentation for the technical flow chart, user interfaces and user guide.

• Provide post production support to the end-users.

Environment: C#, IIS 5.0, ADO.NET, SOAP, XML Web Services, Visual Studio 2003, UML, JavaScript,

XML, MS SQL Server2000, Windows 2000.

.NET Developer December 2003 to

March 2004

Project: Customer Tracking System

Customer Tracking System is utility software that helps organization to keep track of their valued

customers. It has various features like Planner, Customer Management, Lead / Inquiry Management etc.

that have been accessed and used by team leader and management team member. Various reports have

been provided to graph the status.

Responsibilities:

• Actively participated in the requirements specification process, analysis, design, development and

testing.

• Improved the look and feel of the site using Cascading Style Sheets

• Implemented ASP.NET AJAX to improve the page overhead

• Created Tables, Constraints, Stored Procedures, Functions, Views and Triggers in MS-SQL

database using T-SQL

• Written test scripts for assertions in Unit testing

Environment:ASP.NET 1.1, ADO.NET 1.1, VB 6.0, Visual Studio .NET, MS SQL Server 2000 (T-SQL

and DTS), Java Script, VB Script, Windows 2000, IIS 5.0, HTML, DHTML, XHTML, Crystal Reports.

Net vision Web Technologies, Surat, India February 2002 to November

2003

.NET Developer October 2002 to November 2003

Share Holder Management System

This application was designed to keep track of the client company’s share related work, like Trading,

Transferring and Adding new shareholder’s profile. It includes the volume of share trading the client have

done, their limits, purchasing profile, brokerage of company etc. It prepares trading volume, purchase

records, commission, due statements, payment schedules, billing, etc.

Responsibilities:

• Developed and implemented the GUI design

• Created ASP.NET pages using C#.Net for middle-tier processing of client requests with ADO

interfaces for database and implemented stored procedures

• Implemented template columns in the data grid to avoid in order achieving the functionality

• Participated in meetings with Business users and with other project teams to ensure that the

volatile business requirements reflect in the project development

Environment: NET Framework 1.0, VB 5.0, ASP, ORACLE, HTML, JavaScript, XML

.NET /PL SQL Developer February 2002 to September

2002

Sales Order Processing System

The system does the functions of order entry, invoicing and sales analysis. The system allows the user to

enter customer order and prepare invoices against any order. Orders and invoices can be printed at any

time. Finished goods are added to inventory and sales returns are also handled by the system. The

system can provide an analysis on sales based on region, territory and sales persons. The application

comprises of the following modules (Sales Order, Invoices, Item receipts, Sales returns)

Responsibilities:

• Wrote the technical requirements based on the business and functional needs.

• Converted user requirements into the technical requirements.

• System study at client place with the business users and the management.

• Screen designing, coding, testing of integrated system.

Environment:

Oracle 7.1, Windows 95, Developer 2000 (Oracle Forms 4.5, Oracle Reports 2.5)

Education

Masters in Software Engineering, Fairfield University, USA

Honors Diploma in Computer and Network Centered (HNC), National Institute of Information

Technology, India

Bachelor of Science: Mathematics & Chemistry, South Gujarat University, India

Reference

Available Upon Request

Contact this candidate