We provide IT Staff Augmentation Services!

Data Analyst Lead/admin Resume

SUMMARY

  • Sr. Developer/Administrator with around 10 years of professional IT experience in Analysis, Design, Development and Production Support using TIBCO suite of Products.
  • Experience in installation, configuring, load balancing and administering Spotfire Server components TIBCO Spotfire, Application Data Services, Spotfire Web Player and Automation Services.
  • 4 years of Rich experience with TIBCO Spotfire in analyzing data, developing dynamic analytic applications, implementing, integrating, customizing, deploying and maintaining BI solution.
  • Design, develop, and support Spotfire Visualizations with complex data sources across multiple applications and platforms (SQL, Oracle, Access, Excel, Text, HTML, etc.)
  • Worked extensively on visualization properties and complex interactive features such as multiple markings, filtering schemes, configure bar chart, line chart, graphical table, combination chart, scatter plot, pie chart, table, cross table, and summary table visualizations.
  • Ability to combine data from multiple sources and expose them to TIBCO Spotfire client users through information links.
  • Created Complex Information Links to pull the data from Oracle 10g/11g and SQL Server datasets.
  • Managing and Migration of Spotfire contents, Security Setup, designing Information Links, setting up licenses and preferences.
  • Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
  • Strong SQL development skills in writing Database Queries, Stored Procedures in Oracle/SQL Server.
  • Extensive Experience in installation, configuration, development, deployment and troubleshooting of TIBCO Active Enterprise Suite of applications and Analytical tools such as TIBCO Business Works, TIBCO Designer, TIBCO EMS, TIBCO Active Database Adapter, TIBCO MQ Plugin, Service Grid, HAWK, TIBCO BW Administrator.
  • Experience in analysis, design, development, deployment, testing and production support of EAI projects using TIBCO products in Banking, Oil & Gas and Betting domain.
  • Hands on experience in Web Services using SOAP/HTTP and SOAP/JMS, WSDL and Schemas XSD with strong skills in understanding and implementing Service Oriented Architecture (SOA)
  • Expertise in using messaging standards such as TIBCO EMS for developing distributed applications.
  • Thorough understanding of XML, XML Schemas (XSD, DTD), XPATH and XSLT.
  • Experience in code migration between Development, Test, Acceptance and Production Systems.
  • Full life cycle experience in architecture, requirement analysis, design, development, testing, deployment and support.
  • Designed and implemented SSIS packages for data integration.
  • Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
  • Domain Knowledge in Banking and Financial, Oil& Gas Domains.
  • Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent Interpersonal and Communication Skills.

TECHNICAL SKILLS

Technical Skills: TIBCO Spotfire 7.x, 6.x, 5.x, MS SQL SSIS, SSRS and SSAS, TIBCO Business Works 5.x, TIBCO Administrator 5.x, TIBCO EMS 6.x, 7.x, 8.x, TIBCO Adapters (ADB, File and SAP),TIBCO Hawk 5.x

Operating Systems: Windows, UNIX.

Languages: Java, .Net, SQL, Unix Confidential scripting.

Databases: Oracle 10g, 11g, MS SQL Server 2005/2008/2012.

Web/Application Servers: Tomcat 5.x, ASP.NET

Tools: TOAD, SQL Developer.

XML Technologies: XML, DTD, XSD, WSDL, SOAP.

Version Control systems: Tortoises SVN, Clear case, Microsoft Visual SourceSafe (VSS), JIRA.

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst Lead/Admin

Technical Skills: TIBCO Spotfire professional 6.5, 7.0, Spotfire web player, SQL Developer.

Responsibilities:

  • Migrated from TIBCO Spotfire Server 6.5 to 7.0 in Windows Server 2008R2
  • Deployed Client Packages in the Server.
  • Wrote Spotfire server Backup scripts to take backups regularly.
  • Created Scheduled tasks to Start & Stop Spotfire Server. modify Projects, Groups, Users and set up Permissions. create and monitor all the Spotfire scheduled update jobs for multiple environments. updating Web.Config and Bootstrap.xml files to troubleshoot the issues.
  • Applied TIBCO Spotfire Server HotFix, Spotfire Client HotFix and Automation Server package deployments.
  • Monitored Spotfire server to detect issues with server, LDAP Servers, Network problems, External databases to reduce server downtime and eliminate performance bottlenecks.
  • Deployed TIBCO Spotfire DXP files to UAT and Production environments.
  • Provided 24X7 support for Tibco Spotfire infrastructure and Visualizations support.
  • Responsible for requirements gathering, data analysis, implementation and publish the dashboards to Spotfire webplayer.
  • Co - ordinate with IT and business to understand the business requirements and translate those needs into technical terms, design specifications and solutions.
  • Develop reports, dashboards, charts etc. in Spotfire and Migrate the changes in Dev, QA and Prod environments.
  • Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions.
  • Create Information links by using Information Designer to pull the data from Oracle Database and SQL data sets required to create the reports.
  • Utilize complex Spotfire features to build complex corporate dashboards and visualizations with multiple graphs and charts.
  • Design, develop, and support Spotfire Visualizations with complex data sources across multiple applications and platforms (SQL, Oracle, Access, Excel, Text, HTML, etc.)
  • Used Iron python scripts for few actions like carrying of filters from one filtering scheme to other, toggling between different visualizations etc.
  • Analyzing the end systems, including Data Model, Protocols, and legacy systems etc., based on functional requirements.
  • Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
  • Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions.
  • Created Information Links By using Information Designer to pull the data from Oracle Database and SQL data sets required to create the reports.
  • Created detailed visualization and cross tab reports for each business unit to highlight the driving point.
  • Used data table properties, property controls, filters, joins and custom functions
  • Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc.,
  • Used Filter Schemes to isolate the filter behaviors on visualizations.
  • Used Dynamic Calculations based on the selection of markings in the visualizations.
  • Problem determination and troubleshooting for any issues in PROD and Non PROD environments.
  • Involving project discussions, implementation and implementation support.

Confidential

Sr. TIBCO Spotfire Developer/ Administrator

Responsibilities:

  • Installed & Configured TIBCO Spotfire Server 6.5 in Windows Server 2008R2
  • Created Spotfire Database by Executing oracle db creation scripts
  • Created and configure bootstrap file using Configuration tool
  • Deployed Client Packages in the Server.
  • Integrated Spotfire Server with an existing LDAP environment.
  • Wrote Spotfire server Backup scripts to take backups regularly.
  • Created Scheduled tasks Start & Stop Spotfire Server.
  • Set up Projects, Groups, Users and set up Permissions.
  • Monitored Spotfire server to detect issues with server, LDAP Servers, Network problems, External databases to reduce server downtime and eliminate performance bottlenecks.
  • Deployed TIBCO Spotfire DXP files to UAT and Production environments.
  • Provided 24X7 support for Tibco Spotfire infrastructure and Visualizations support.
  • Responsible for gathering requirements, analysis, creating documentation, report creation and testing
  • Designed Practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in Spotfire for Analytical Projects and Data Visualization Community.
  • Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
  • Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions.
  • Created Information Links By using Information Designer to pull the data from Oracle Database and SQL data sets required to create the reports.
  • Utilized complex Spotfire features to build complex corporate dashboards and visualizations with multiple graphs and charts.
  • Created detailed visualization and cross tab reports for each business unit to highlight the driving point.
  • Used a graph table visualization to create stand-alone Reports on corporate and Business Unit Dashboard Reports.
  • Used data table properties, property controls, filters, joins and custom functions
  • Created complex query information link to connect to various data sources.
  • Created complex dashboards using property controls, prompts, Filters, Calculated columns for different functionalities
  • Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc.,
  • Used Filter Schemes to isolate the filter behaviors on visualizations
  • Used Dynamic Calculations based on the selection of markings in the visualizations
  • Participated in troubleshooting visualization performance issues and involved in tuning reports for better performance.
  • Involved in creating Views, Materialized View and good at writing tuned queries that are partition aware.
  • Involved in performance tuning Queries by analyzing execution plans and building indexes as needed.
  • Documented and maintained Best practices for system installations, configurations and migration from one environment to another.

Hire Now