PROFESSIONAL SUMMARY:

• Over 7 years of experience in Analytics and Data warehousing.
• Developed numerous enterprise level analytical solutions using Spotfire.
• Experienced in developing dashboards using TIBCO Spotfire, Iron Python and DWH process based on Informatica Power center 8.1.1, Oracle DB, and SQL & PL/SQL.
• Created, modified, and administered analytics Intelligence dashboards, HTML text; links to documents; and embedded content, such as images, text, charts and tables.
• Expertise in debugging and optimizing Spotfire Dashboards/ Reports and Designing and scheduling the jobs.
• Worked extensively on Information Designer, Scheduled updates, Custom HMTL templates and advanced concepts like database write back from Spotfire reports.
• Good Knowledge on Iron python and Spotfire APIs for customizations.
• Understanding of R scripts for predictive models in Spotfire.
• Strong knowledge on visualizations like Bar charts, Combination, Map, Tree Maps, Cross Tabs, Scatter plots, heat maps etc.
• Created Pareto Charts, Histograms, Trend charts and what if analysis in Spotfire.
• Strong knowledge on Property controls, Script control and document properties.
• Worked on Spotfire Automation Service Job builder for scheduling and delivering reports through mail as per business needs.
• Integrated URLs in Spotfire and on demand data refreshes in Spotfire.
• Expertise in data transformation, creating calculated, binned, predicted columns in Spotfire.
• Created parameter, prompts for information links.
• Used shape files for map visualizations, created guided analysis.
• Good knowledge on analytical models for data mining.
• Experience in installing and maintaining web player server, Automation jobs services and TIBCO Spotfire statistical services (TSSS) and monitoringserver usage, configurations etc.
• Created bookmarks, tags, lists on Spotfire analysis templates.
• Implemented collaboration in Spotfire.
• Worked Extensively on Data Migration and Informatica/ Spotfire Production Support(L2)
• Expertise in Performance Tuning Spotfire reports and Informatica ETL Jobs.
• Created numerous executive level reports. Dashboards were generated to provide insight into the sales/ marketing/ financial data.
• Worked Extensively on ETL customizations using Informatica Power Center.
• Implemented SCD type 2 and Change Data Capture Logic.
• Expertise in Star and Snowflake designs of Financial, Sales and Supply Chain Analytics.
• Expertise in Oracle and SQL Server Databases.
• Experienced in transforming business requirements into technical and functional specifications.
• Managing and motivating others in a cross cultural/functional environment to achieve business and project objectives.
• Achieving consistent high performance in an area of rapid change and delivering high quality business solutions.

TECHNICAL SKILLS:

OLAP (BI): Spotfire 7.6/6/5.5/5.1/4.5/4.1

RDBMS: Oracle 11g/10g/, SQL Server, Teradata

ETL Tools: Informatica (Power center 9.x/8.x/7.x), SQL*Loader

Operating Systems: UNIX (Sun Solaris, HP Unix, LINUX), WIN 2000/ XP

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Iron Python, R, HTML, MATLAB

Other’s: Toad, Metadata Manager, DB Visualizer, Appworx

PROFESSIONAL EXPERIENCE

Confidential, TX

Responsibilities:

• Gathering requirements and creating mock up screens for reviews.
• 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.
• Setting up the information model for various projects in Spotfire.
• Helped in designing Data-warehouses/ETL workflows required for the reporting applications.
• Creating parameter information links, joins, filters in information designer for fetching data in to Spotfire as per the business needs.
• Developed Customized Reports using TIBCO Spotfire Professional.
• Created dashboards, reports, analytics and advanced graphical virtualizations by using the key concepts filtering scheme, Data on demand, property controls etc.
• Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc.
• Worked on Spotfire Standards & Guidelines Documentation which is used as a future reference in following guidelines for developing dashboards.
• Worked with Automation job services, configurations blocks to pass the values to parameterised information link to generate and email the reports to customers.
• Responsible for code deployments from DEV, QA to production environments.
• Created visualizations using advanced concept of data on demand and marking functionality in Spotfire from oracle to historian web services to increase greater performance in user analytics.
• Responsible in writing scripts to create action controls, buttons and property controls to increase user friendliness to perform analytics.
• Experience in setting up user action log Spotfire database to store all Spotfire action log.
• Responsible for Spotfire Administration activities, installing, configuring, user/group, library, server management etc.
• Created guided reports and workflows in Spotfire.
• Merging data tables in Spotfire and creating Pareto charts, waterfall charts etc.
• Created Tags, Bookmarks and transformations for data tables.
• Unit testing and participation in UAT and production cut over plans.
• Collaborated sales force chatter with Spotfire reports.
• Created write back to database functionality from Spotfire.
• Iron python scripts for better UI experience and customizations to out of box features.
• Provided mentoring and consulting to other BI team members in Spotfire.

Environment: Spotfire 7.6/6, Oracle, SQL Server, TERR, Essbase.

Confidential

Responsibilities:

• 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.
• Create and enhance Spotfire dashboards for financial leadership team.
• 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 information links using Information designer using parameterized procedures.
• Worked on End-User training.
• Used Filter Schemes to isolate the filter behaviors on visualizations.
• Used Dynamic calculations based on the markings user selects in the visualizations.
• Used Over statements and custom expressions for calculations.

Environment: Spotfire 5, SQL Server, Teradata, TERR, Salesforce.

Confidential

Responsibilities:

• Created mappings for Dimension Tables using SCD Type 2 and populated fact tables and modifying existing mappings according to customer requirements.
• Involved in Data Migration Activities across different environments.
• Involved in Data Extraction from relational sources and flat files using Informatica.
• Creation of sessions and workflows and scheduling batch jobs.
• Automation of data reconciliation output files and sending the excel reports through email.
• Created parameter files, Reviewing the code, performing tuning and unit test.
• Scheduling Informatica Workflows using Appworx.
• Created New Execution plans, Subject Areas, Adding new indexes, creating new task definitions, performing Pre and Post ETL tasks and setting up the dependencies.
• Documentation of the project Change Request by Client and production support.

Environment: Informatica 8, SQL Server, Teradata, Oracle, UNIX, PL/SQL.