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:

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, Cincinnati OH

Data Analyst Lead/Admin

Environment: TIBCO Spotfire professional 6.5, 7.0, Spotfire web player, SQL Developer.+

Responsibilities:

Administration:

• 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.

Development:

• 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, Houston, TX

Sr. TIBCO Spotfire Developer/ Administrator

Environment: TIBCO Spotfire professional 6.5, Spotfire web player, Oracle 11g, Toad.

Responsibilities:

Administration:

• 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.

Development:

• 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.

Confidential

Technical Lead

Domain: Banking and Finance

Environment: TIBCO Spotfire professional 5.x, Spotfire web player, Oracle 11g, Toad.

Responsibilities:

• Understand existing business model and customer business requirement.
• Involving in requirements gathering and leading offshore development team.
• Design & Develop SOA and REST Based applications using TIBCO BW.
• Design and prepare ICD (Interface Control Document) documents.
• Interacting with WebSphere MQ.
• Create Confidential scripting for installation of software’s.
• Check logs, CPU utilization and start/stop the applications in different environments.
• Prepare Technical Design & Unit test case documents.
• Testing services in DEV, IT and UAT environments by coordinating with end system (HOGAN) team members.
• Prepare J-Unit & Parasoft test cases for the developed services.
• Fixing the defects raised in DEV, IT, UAT Environments.
• Raise Build request in DEV, IT & UAT environments.
• Suggesting best practices and providing alternate solutions for the applications.
• Design and provide TIBCO end to end solutions.
• Create functional and nonfunctional design using TIBCO products.

Confidential

TIBCO Technical Lead

Domain: Gambling

Environment: TIBCO ActiveMatrix Service Grid, AMX Administrator, TIBCO BW, BW Administrator, EMS, Hawk, & Java, TortoiseSVN, WinSCP, JEMS, Message & monitoring tool (M3), Oracle VM VirtualBox, Putty, soapUI, ant, Altova XMLSpy, Mozilla Thunderbird, Beyond Compare, Notepad++

Responsibilities:

• Understand existing business model and customer business requirements.
• Analyzing requirements, providing architectural directions, guiding/mentoring and leading development and support teams.
• Design and prepare High level design documents, Service designs, Technical design documents & API’s.
• Design & Develop SOA, REST Based applications using TIBCO BW 5.11 & TIBCO AMX Service Grid 3.1.3.
• Deploy and configure developed applications in TIBCO BW/AMX Administrator.
• Install and configure TIBCO EMS, AMX Administrator and BW Administrator in Linux operating system.
• Install & configure various TIBCO products (TIBCO BW, AMX Service Grid, EMS, Hawk, AMX Administrator and BW Administrator) in all the environments like DEV, SIT, UAT, PRE-PROD, PERF, and PROD.
• Set up fault tolerance based EMS Servers in Production and Performance environments.
• Created Script deployments for installation of TIBCO products in Linux environment.
• Start/Stop processes of BW and AMX applications, Hawk, Administration domains.
• Raising Support tickets to TIBCO Support team regarding AMX Service grid issues.
• Create Message Selectors on Bridges to route the traffic as per Business Requirements.
• Involved in On Call Production Support for L3 Teams.
• Involved in logging, monitoring, and statistics facilities to effectively view system activities and track system performance using TIBCO/EMS.
• Involved in TIBCO BW and AMX Deployments in all the environments like DEV, SIT, UAT, PRE-PROD, PERF, and PROD.
• Involved in Production build and release of application EAR’s.
• Testing the interfaces in DEV and PPR by coordinating with source and target applications.

Confidential

MS SQL /SSIS/SSRS Developer

Environment: SQL Server 2005/2008, SSIS, SSRS

Responsibilities:

• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end
• Extensively used joins and sub queries to simplify complex queries involving multiple tables. Developed views using complex split week logics
• Involved in query optimization and performance tuning
• Implemented error handling in several existing Stored Procedures using Try Catch blocks.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2005
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports

Confidential

SSIS, SQL Developer

Environment: C#.NET. ASP.NET, Java script, SQL Server 2005, SSIS, Web services

Responsibilities:

• Analysis of the user requirements and Database design
• Design, Coding & Development of various modules in Visual Studio 2005 on 3.0 Framework
• Created tables & written stored procedures in SQL Server 2005
• Created the SSIS Packages for data transformation.

Confidential

.NET Developer

Domain: Healthcare

Environment: C#.NET. ASP.NET, Java script, SQL Server 2005, SSIS, Web services

Responsibilities:

• Analysis of the user requirements and Database design
• Preparing test case as per the SRS/developer design document
• Preparing URD, FDD, SRS and OOD documents
• Design, Coding and development of Complaint logger screen which enables the user to give a compliant where the complaint will be registered and a mail will be sent to respective government authority
• Design, Coding and development of Information provider screen for contact centre which enables any of the Information provider to view the Email, Fax, SMS, Chat which is sent by the caller and also it has the option of sending the reply to the caller via any media mentioned above I used the technologies like Windows applications, Web Services, and SQL Server 2005