SUMMARY:

• Over all 6 years of experience in IT industry with a strong background in Analysis, Design and Development in the field of Database and implementation of Business Intelligence applications
• Designed and developed Analytics solutions using TIBCO Spotfire for various business domains
• Proficient in designing multiple enterprise level Spotfire Analytical solutions
• Work with users on how to use Spotfire as an analysis tool including training as well as collaborating on report generation
• Customization of Spotfire reports using Spotfire APIs and scripts.
• Responsible in creating the Analysis Design and Building dashboards by creating the information links from warehouse to display data in reports.
• Created Action Controls using Iron Python.
• Strong attention to detail in supporting management reporting with clear and concise data analysis and presentation.
• Ability to quickly learn new database design and development methodologies, concepts and tools.
• Knowledge of Oracle 10g/9i, Teradata, SQL server 2000/2003 and reporting tools.
• Experienced in delivering user training to different levels of user groups and conducted workshops.
• Proficient at working as a team player with an aim of contributing towards the team's success. Involved in unit testing, systems integration testing and documented the same.
• Excellent problem - solving skills with the ability to provide creative solutions.
• Worked on both Development and Support & Enhancements Engagements.
• Effective communicator with excellent relationship management & negotiation skills; possess a flexible & result oriented attitude
• Proven Client relationship management

TECHNICAL SKILLS:

Database Tools: Oracle 10/11g, SQL Server, My SQL, DB2, IBM

Programming Languages: R, SQL, Iron Python, JavaScript, Teradata

Reporting tools: Power Pivot, Tableau, TIBCO Spotfire Professional 7.6/6.5,6.0, QlikView

Scripts: VBScript, HTML and XML.

Web Tools: MS-Front Page, Macromedia Suite, IIS, Outlook Express.

Applications: Microsoft Office, Visio, and Visual SourceSafe.

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, Tennessee

Spotfire Developer/ Administrator

Responsibilities:

• Worked on creating Pie chart, Scatter Plot, Stacked bar Chart and Map chart based on the requirement document provided by the business team.
• Configuring data tables for data on demand and parameters to fetch data from data sources based on user selections.
• Pivoting and transforming data in Spotfire professional before building visualizations.
• Created reports and advanced visualizations by using the key concepts filtering scheme, Data on demand, property controls etc.
• Created the visualizations with complex calculations/functions.
• Built parameterized queries using Tibco data virtualization tool.
• Worked on Information designer, building Information links, elements, filters, joins, prompts, prompt groups etc.
• Worked on the defects raised by QA team.
• Testing and debugging the dashboard for quality assurance.
• Created stored procedures for each report.
• Conveying problems, solutions, updates and project status to project manager in a timely and regular basis.
• Worked on End-User training.
• Assisted the team in solving the defects using Iron python Script.
• Responsible in writing scripts to create action controls, buttons and property controls to increase user friendliness to perform analytics.
• Responsible for creating cost effective efficient Data visualizations.
• Analyze and document process along with quick resolutions for typical issues in Deployment and which were critical to the process.
• Project Delivery aspects like UAT, Production Migration and Production Implementation.
• After the deployments to QA and UAT environments, involved in smoke tests to ensure reports are working.
• Coordination with various internal/external system interface team for design/integration testing/ deployment and production issues.
• Created Spotfire design document and database design document for reference.

Environment: Spotfire 7.8,7.6,7.6.5, SQL Server 2008, Iron Python, HTML and JavaScript

Confidential, Dallas, Texas

Tibco Spotfire Developer

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Created, developed and supported reporting and Business Intelligence initiatives using Spotfire application suite.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports
• Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use.
• Created Database connection and Spotfire Dashboard file (DXP) in Spotfire server
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Creating TERR script for predictive analysis using R statistical programming language.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Spotfire.
• Use In-memory capabilities of Tibco Spotfire, Spark as well as rich Machine Learning applications with easy to use Data visualization of Models using built in TERR (Tibco Runtime R engine) and Revolution R/R Studio.
• Customized Reports by writing complex custom SQL.
• Worked on a plan to develop the process for remote systems administration and ongoing Spotfire application enhancement and maintenance
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.
• Experience with Spotfire application performance monitoring, capacity planning, and tuning of the Spotfire environment.
• Provided high level, complex support services and delegate low level support to off-shore support staff
• Administered Spotfire programs and supported library management.
• Evaluated log files and implemented performance tuning.
• Supported Spotfire logs for resolution of issues.
• Participated in connection of Spotfire with SQL data sources.
• Executed the queries in Teradata and verified the data. Also connected to Spotfire using Teradata connector.
• Implemented system modifications as per established requirements.
• Prepared project estimates and analyzed reporting issues.
• Formulated dashboard specifications and generated status reports.
• Documented and maintained practices for system installations and configurations.
• Experienced with load balanced web architecture using Apache Tomcat.
• Experienced with continuously available Spotfire Server configuration
• Experienced with RDBS including SQL Server and Oracle, SQL skills

Environment: TIBCO Spotfire 7.5, 7.6.5, 6.0, Spotfire Automation Services 7.0, Spotfire Statistics Services 7.0, Spotfire Web player 7.0, Spotfire ADS 7.0.

Confidential

Cognos Developer

Responsibilities:

• Working on Cognos Administration , Framework Manager, Transformer , ICS and Accelatis .
• Deploying Reports and other necessary files between environments as requested by Developers / Deployment co-coordinators for Business Units.
• Provision of technical advice and guidance related to IBM Cognos environment and other software included in the suite. (For example: Transformer, Report studio)
• Open PMR with IBM support, working along for resolving the issues, if necessary, applying Hotfix .
• Upgrading Cognos software 10.1 to 10.2 to 11, making sure that Client has up to date experience on tool.
• Perform weekly maintenance on all Cognos servers including restarting servers, enabling Perform and ensure all schedules are running successfully.
• Handling incident requests and resolving issues as per SLA and follow procedures recommended for incident closure.
• Auditing, Logging and monitoring all Cognos environments in order to ensure this product remains IRM and IP complaint.
• ICS and Accelatis are the third-party tools used for better Support and Maintain Cognos environment.
• Supporting Cognos Server migration from one location to other.
• Practicing DRP (Disaster Recovery Plan) Quarterly.

Environment: Cognos 10.x Operations and Platform Support, DB is MS SQL, Cognos servers (IIS, Application/Dispatcher, Content Manager, Framework Manager) are on Windows server, PowerShell Scripts, ICS (Integrated Control Suit)

Confidential

Tableau Developer

Responsibilities:

• Worked as a Reporting admin , in charge of the report development and maintenance
• Worked on the ad insight team and dealt with lot of financial data in Excel. Used Tableau to great effect.
• Built and maintained many dashboards.
• Training classes to the employees on this new version of Tableau .
• Creating dataflow diagram and documenting the whole data movement process.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic.
• Writing high level and detail design documents.