SUMMARY:

• Eleven years of IT experience in Business Intelligence, Web Applications, Requirements gathering, Design, Development.
• Good experience in creating complex Spotfire dashboards and visualizations by using the key concepts filtering scheme, Data on Demand, property controls, Text Areas in TIBCO Spotfire reports using Tibco Spotfire Professional.
• Worked Tibco Spotfire Professional, Tibco Spotfire Webplayer, Spotfire Server.
• Experience in ETL Informatica.
• Expertise in complete Life Cycle Development Process of a reporting solution that involves Gathering Business Requirements, Analyzing Business Needs, Implementing Design, Documenting Business Information.
• Experience in in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Spotfire Lead

• Created Information links, parameterization, defined join rules in Information designer.
• Created Action Controls and wrote scripts using Iron Python, performed several customization using the scripts
• Used Lists, tags and Bookmarks
• Worked on ADS composite to balance the load of the source database and performance.
• Used Filter Schemes to isolate the filter behaviors on visualizations
• Used Over statements for calculations, custom expressions and calculated columns
• Created configuration blocks in Spotfire and setting up guided analysis to carry the filter selections from one analysis to other
• Customized data by adding prompts, Filters, Calculations, by writing complex custom Oracle SQL, Summaries and Functions.
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
• Worked on the Migration plan to move the Spotfire dashboards to Acceptance/Production and guide the end users to get the necessary access through the corresponding Active Directories
• Worked on metadata creation such as Data Source, Elements, Information link etc.
• Good knowledge on almost all type of Visualization starting from Line chart, Bar Chart, Map Chart, combination charts, Hear map.
• Created Shop OTD and Supply OTD visualizations reports deals with the parts supply and used part details which were critical reports to drill down the data.
• Created POC reports which were already created in Tableau into Spotfire and migrated and tested.
• Environment Stability & Monitored Spotfire reports which were published.
• Support and Performance Tuning was given to Spotfire reports in production.
• Python Scripts were used to customize the dashboards and visualizations.
• Unix shell scripts were used to integrate with other data sources like ADS composite and cloud.

Environment: Spotfire 7.6, ADS composite, Greenplum, Jira, ADS, Tera Data, Oracle, Python, UNIX Shell Scipts, Informatica, Agile methodology.

Confidential, Durham, NC

Spotfire Technical Lead

• Interacted with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on non - technical level and with the System Analyst on technical level.
• End to support to the reports and performance tuning was done when the reports were not cached
• Worked with SMEs and stakeholders for the requirements and changes
• Created Data Definitions and help maintain Metadata repository.
• Optimized the reports according to the customer depending on the location, age and gender criteria
• Used Dynamic calculations based on the markings user selects in the visualizations
• Created Information links, parameterization, defined join rules in Information designer
• Created reports for blinded and unblended clinical trials throughout the globe for analysis.
• Modified and optimized the visualizations depending on the user access and denials.
• Co-ordinated with the ETL team for loading of the data and data modelling.

Environment: Tibco Spotfire, Informatica Power Center, UNIX, PL/Sql, SQL Server 2010, Oracle, DB2 Mercury Quality center, Agile Methodology.

Confidential, McLean, VA

ETL Lead

• Developed the mappings in Informatica power center according to technical specifications.
• Importing Source and Target tables and flat files from their respective databases and by FTP.
• Developed Informatica Mappings and workflows for migration of data from existing systems to the new system using Informatica Designer
• Preparing the Documentation for the mapping according to the designed logic used in the mapping
• Created connected and un-connected mapping.
• Using existing Shell scripts, customized the new jobs and running workflows in UNIX environment.
• Optimizing performance tuning at mapping and Transformation level
• Preparing Test Cases and worked closely with test team to validate the data.

Environment: Informatica Power Center 9.x, Unix, PL/Sql, Auto Sys, Windows 7, Oracle, Mercury Quality center, WinFTP, DB2, Visio,Office-2010

Confidential, Richmond, VA

ETL Developer

• Written SQL overrides in source Qualifier according to business requirements.
• Extraction, Transforming & Loading the data from source to target.
• Migrated the mapping to the testing and production department and introduced the concepts of Informatica to the people in testing department.
• Data is XML and Parsers and Generators are used to handle the data
• Created sessions and workflow for designed mappings.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Created session and mapping variables to adhere to different loading scenarios.
• Scheduled UNIX jobs using Auto Sys.

Environment: Unix, Windows 7, Informatica 8.x, Oracle, PL/Sql, Auto Sys, Mercury Quality center, WinFTP, DB2, Visio.