Charitha Amaraneni

Phone # 732-***-**** E-Mail: adg36t@r.postjobfree.com

Summary:

Qualified Software Professional with 9+ years of total IT experience in analysis, design and development of software applications.

Expertise on TIBCO suite of products and very experienced in architecting, designing, developing and deploying distributed enterprise applications on TIBCO middleware platform

Expertise in Middleware technology on Service Oriented Architecture (SOA) concepts by designing and developing Web Services using WSDL, SOAP and Service palettes using SOAP/HTTP and SOAP/JMS with TIBCO Business Works.

I have end-to-end software development life cycle experience including Architecture, Design, Development and Application Industrialization applying Performance Testing/Analysis, Optimization.

Expert level skills in Tibco Spotfire and Tibco ActiveMatrix Enterprise Suite – TIBCO/Rendezvous, TIBCO/EMS, TIBCO/Business Works, TIBCO/Business Events, TIBCO/Business Studio, TIBCO/API Exchange, TIBCO/ADB adapter, TIBCO/MQ Adapter, TIBCO/SmartMapper, TIBCO/Hawk, TIBCO/Repository, TIBCO/Administrator.

Proficient in B2B integrations using TIBCO Active Exchange Suite – TIBCO/SOAP and Web services.

Experience in creating Channels, Concepts, DB Concepts, Events, Rule Functions and Rules using Business Event studio.

Created Complex Information Links to pull the data from Oracle 10g/11g, TDV (Tibco Data Virtualization), CIS Studio.

Experience in using Tibco Spotfire, Spotfire Server, and Spotfire Web Player.

Experience with the BI tools Tibco Spotfire Professional, Web player, Tableau and Business Objects.

Good Experience in Python Scripting, R, TERR Engine

Expertise in Customizing the Analytics dashboard using Java scripts and JMOD feature

Experience in creating Complex Spotfire Dashboards or Reports Using Tibco Spotfire Professional.

Created Complex Information Links to pull the data from Oracle 10g/11g and SAS datasets.

Expertise in creating Triggers, Exceptional Expertise in TIBCO Spotfire installation and upgrading existing version.

Worked extensively on Spotfire Professional and created various visualization.

Worked as Spotfire Lead, responsible for gathering requirements, developing POC, analysis, design, development and production.

Worked on development of Dashboards for Key Performance Indicators for Top management

Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Spotfire.

Responsible for converting business requirements to Spotfire reports.

Designed and developed complex Spotfire reports integrated with stored procedures, custom SQL’s, automated reports.

Designed Business processes using Tibco Business Studio.

Strong working knowledge in XSD, XML, XPATH, XSLT and Web Services using WSDL, SOAP, API.

Extensive Knowledge of Oracle Apps Integrations using TIBCO.

Excellent work experience with XML/Database mapping, writing SQL queries, Store Procedures, Triggers with major Relational Databases Oracle 9i/8i, DB2, and MS SQL Server.

Utilized Power BI (Power View) to create various analytical dashboard that depicts critical KPIs along with slicers and dicers enabling end-user to make filters.

Implemented Power BI gateway different source to matching analytics criteria and further modeling for Power Pivot and Power View.

Proficient in designing and scheduling complex SSIS packages for transferring data from multiple data sources and integrates data based on business logic and to load it in data warehouse.

Experience in working with Datasets from Multiple Data sources.

Experience in pulling Data from External Data Sources through an API by writing ironPython scripts

Experience in using messaging services like TIBCO EMS and TIBCO Rendezvous.

Excellent Knowledge in Teradata, Oracle 8i,9i,10g&11g, 12g, EBS Adapters, SQL Server 2008, My SQL.

Well Versed in Enterprise Application Integration (TIBCO).

Good experience in Java, JDBC, servlets programming, JMS, JavaScript.

Experience in Object Oriented Developemnt.

Extensive Knowledge on Enterprise Directory Information Systems.

Education: Bachelor of Technology in Computer Science & Engineering, India

Technical Skills:

EAI Tools

Tibco Active Matrix Enterprise Suite - Tibco Spotfire 10.x,7.x/6.x/3.x, Tibco Spotfire Server 10.x,7.x/6.x/3.x, Spotfire Web Player 6.x,7.x,10.x Repository, ADB 7.x/6.x/5.x, MQ Adapter 5.x, Oracle Apps Adapter 5.x, File Adapter 6.x, Hawk 5.x/4.x, Business Works 5.x, Business Events 5.x/4.x/3.x, Business Works Service Engine 5.x, Business Studio3.x/2.x, Active Spaces 2.x, TIBCO/API Exchange 2.x, TIBCO EMS 8.x/7.x/5.x/4.x, TIBCO Designer 5.x and TIBCO Administrator 5.x.

XML Technologies

XSL, XSLT, XML, DTD, WSDL and SOAP.

Database

SQL Server, Oracle 9.x, 10g, 11g,12g, EBS Adapter, DB2

Others

XML Spy, Web Logic, WebSphere, IIS, IIB, UNIX

Protocol

TCP/IP, Telnet, FTP, SFTP, SOAP and HTTP

Testing Tools

SOAP UI, HP Software Quality Center, SOA TEST, POSTMAN

BI Tools

Tibco Spotfire Professional 3.x,4.x,5.x,6.x,7.x,10.x, Spotfire Web player, Tableau 8.0, Power BI 2.7

Work Experience

Dataserv Inc

Client: Chevron

Senior Spotfire Developer

July 2019 – Present

Responsibilities:

Worked in Agile Environment. Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system. Study and understand the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules

Created Spotfire report file (DXP) and Database connection in Spotfire server

Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use

Pull Data from Multiple Data Sources like API, DB, Spreadsheets and Semantic Layer.

Create Cached version of Web Links in Spotfire Server which refreshes data every 60 minutes.

Worked with end users to explain Spotfire workbooks, creating ad-hoc reports

Trained developers on Spotfire Professional, Spotfire web player and pulling data through API in terms of best developing and design practices

Pull Live data from External Data Sources through API

Created dynamic and cascading prompts using Business views.

Create toggling between multiple visualizations using ironpython Script.

Create Ironpython Script to Display 1- n number of data sets on Map Feature based on Button clicks

Created server-based Spotfire workbooks(DXP) dashboards and applications from scratch based on Clients needs

Developed bar charts, pie charts, dashboards and cross tables.

Coordinated ETL Migration from Shared / Composite DB to Cloud DB between Multiple teams

Performed ETL Refactoring to transform the raw data into useful Information which could be used by Business Users to Support Decision Making.

The ETLs were built using Microsoft SSIS, which extracts data from data warehouse, processes data and loads it into the application DB in Azure cloud. Spotfire Analytics will consume the Data from the application database side and display the visualizations.

Developed Dashboards that shows the Performance Analysis and Trend Analysis.

Created Action Controls using Python Scripting, TERR Engine, R.

Designed complex reports with data on demand, details on demand options.

Developed information links with multiple data tables using Information designer.

Used Automation Job Service Builder to Export DXP file during Migration Process.

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 SAS data sets required to create the reports.

Created various complex Cross tables, Bar Charts, Line Charts and Tree map.

Created Data sources for Report creation.

Experience in enhancing the visualizations using Custom expressions.

Experience in creating Bookmarks.

Experience in Handling Multiple data tables in Analysis.

Performed integration testing and performance testing.

Environment: Windows 7 Enterprise, Tibco Spotfire Analyst 10.3, Tibco Spotfire Analyst 10.4, Tibco Spotfire Analyst 10.5, Oracle SQL Developer 3.2, Microsoft SQL Management Studio V17.9, Tibco Enterprise Runtime for R environment, Tibco Data Virtualization Studio.

Dataserv Inc

Client: FedEx

Lead Spotfire Developer

March 2018 – July 2019

Responsibilities:

Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system. Study and understand the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules

Created functional specification documents, based on the technical specification documents for dashboard and reports.

Created Spotfire report file (DXP) and Database connection in Spotfire server

Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use

Worked with end users to explain Spotfire workbooks, creating ad-hoc reports

Trained developers on Spotfire Professional and Spotfire web player in terms of best developing and design practices

Coordinated an employee training program for various Spotfire applications and basic troubleshooting principles

Created dynamic and cascading prompts using Business views.

Created server-based Spotfire workbooks(DXP) dashboards and applications from scratch based on Clients needs

Developed bar charts, pie charts, dashboards and cross tables.

Developed Dashboards that shows the Performance Analysis and Trend Analysis.

Created Action Controls using Python Scripting, TERR Engine, R.

Designed complex reports with data on demand, details on demand options.

Developed information links with multiple data tables using Information designer.

Used Automation Job Service Builder to Export DXP file during Migration Process.

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 SAS data sets required to create the reports.

Created various complexes Cross tables, Bar Charts, Line Charts and Tree map.

Created Data sources for Report creation.

Experience in enhancing the visualizations using Custom expressions.

Experience in creating Bookmarks.

Experience in Handling Multiple data tables in Analysis.

Performed integration testing and performance testing.

Environment: Windows 7 Enterprise, Tibco Spotfire Analyst 7.9, Tibco Spotfire Analyst 7.10, Tibco Spotfire Analyst 7.9-11, Oracle SQL Developer 3.2, CIS Studio 7.0, Tibco Enterprise Runtime for R environment, Tibco Data Virtualization Studio.

VensIt

Sr. Data Analyst

Jan 2017 – Feb 2018

Responsibilities:

Responsible for designing and orchestrating a complex workflow in TIBCO by leveraging most activities and developed custom functions to achieve the goal.

Implemented performance tuning and TIBCO Best Practices activities to ensure TIBCO processes run in the most optimized way.

Configured Spotfire Server, Node Manager, Spotfire web player instances and Spotfire automation services.

Involved in Spotfire Admin activities.

Responsible for converting business requirements to Spotfire reports.

Created Action Controls using Python Scripting, TERR Engine, R.

Defined Schemas and created namespaces.

Created Information Links By using Information Designer to pull the data from Oracle Database and SAS data sets required to create the reports.

Performed all the business workflow and published transformed data on the EMS and RVD using Business Works

TIBCO Business Works using ADB adapter to Publish/Subscribe to Oracle Database and also providing RV and SOAP interfaces

Created Static Queues, Topics, Bridges and Connection Factories on Tibco EMS Server for all applications.

Used MySQL, Oracle as database backend using Stored Procedures, triggers, functions and packages.

Involved on BW processes capacity planning

Involved in Process analysis, design and re-engineering, process modeling, system design, product evaluation and installation of TIBCO Products.

Developed Common Logging, auditing and Error handling services.

Supported several key SOA processes as well as their associated infrastructure components and services such as service mediation, Enterprise Service Bus (ESB), TIBCO infrastructure, Configuration Management & deployment, Monitoring and Management.

Implemented web services in tibco using SERVICE & SOAP palettes.

Extensively used SOAP, Service, JMS, and HTTP palettes during development.

Designed and developed various XSD schemas for Common Data Model.

Implemented complex transformation logic with XPath and XSLT.

Involved in creating web pages using HTML, CSS, JavaScript and jQuery.

Used J2EE technologies like EJB, Servlets, JSP and JDBC for backend programming.

Developed XMLs, Java Script for dynamic HTML generation to perform the server side processing on the client requests.

Implemented the security using SSL.

Responsible for fine-tuning service performance to improve overall response time.

Environment: TIBCO – TRA 5.8.0, Designer 5.8.0, Business Works 5.13, BW 6.2, Business Events 5.1, Decision Manager 5.1, RV 8.4.2, EMS 8.2.1, Spotfire 7.0, Active Spaces 2.2, TIBCO API Exchange 2.2, TIBCO Administrator 5.8.1, SAP Adapter 7.1.0, SQL Developer, TFS, SUSE Linux 11/12, Windows 7 Enterprise

Infosys - PWC, Melbourne, AUS

Lead Developer

Nov 2014 – Dec 2016

Responsibilities:

Configured Spotfire Server, Node Manager, Spotfire web player instances and Spotfire automation services.

Involved in Spotfire Admin activities.

Responsible for converting business requirements to Spotfire reports.

Created Action Controls using Python Scripting and R.

Used Automation Job Service Builder to Export DXP file during Migration Process.

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 SAS data sets required to create the reports.

Performed integration testing and performance testing.

Implemented performance tuning and TIBCO Best Practices activities to ensure TIBCO processes run in the most optimized way.

Developed restful services for SWP Integration.

Developed Bug fixing as part of the user acceptance testing phase.

Build and deploy tibco interfaces into various environments.

Worked with Database teams and Business Analysts to design and create various interfaces (XSD’S) between the systems

Created TIBCO/BW Processes between each spoke involved in the integration.

Deployed Business Works applications in failover and load balanced mode.

Installed and Configured TIBCO EMS Server for supporting Fault tolerance.

Defined Schemas and created namespaces

Involved on BW processes capacity planning

Involved in Process analysis, design and re-engineering, process modeling, system design, product evaluation and installation of TIBCO Products.

Developed solutions with one or some combination of the following: TIBCO Active Matrix Policy Manager, EMS, Hawk, Business Events, and Business Works.

Developed Common Logging, auditing and Error handling services.

Supported several key SOA processes as well as their associated infrastructure components and services such as service mediation, Enterprise Service Bus (ESB), TIBCO infrastructure, Configuration Management & deployment, Monitoring and Management.

Implemented web services in tibco using SERVICE & SOAP palettes.

Extensively used SOAP, Service, JMS, and HTTP palettes during development.

Designed and developed various XSD schemas for Common Data Model.

Implemented complex transformation logic with XPath and XSLT.

Used Java/JEE with primary JavaScript, JQuery, Bootstrap and various plugins

Used HTML, XHTML, DHTML, Java Script, JQUERY, XML, XSLT, XPATH, JSP and Tag Libraries for back-end programming.

Environment: Windows 7 Enterprise, Windows Server 2008, TIBCO – TRA 5.7.0, Designer 5.8.0, Business Works 5.11, Business Events 5.1, Decision Manager 5.1, RV 8.4.2, EMS 8.2.1, Spotfire 7.0, Active Spaces 2.2, TIBCO API Exchange 2.2, TIBCO Administrator 5.7.1, SAP Adapter 7.1.0, MongoDB.

Infosys - jetBlue

Tibco Developer

Jan 2014 - Oct 2014

Responsibilities:

Build and deploy tibco interfaces into various environments.

Design and develop new tibco interfaces for new countries.

Implemented interfaces using event driven architecture.

Involved in test execution of the functional and non-functional test cases in DIT.

Configured tibco MQ Adapter for WebSphere MQ.

Involved in the installation and creation of EMS servers and Queues and topics.

Implemented various EMS destinations properties.

Created Channels, Concepts, Functions, Messages, Rules using BE Activities and Workbench palletes in designer.

Configured Spotfire Server, Node Manager, Spotfire web player instances and Spotfire automation services.

Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and Business logic underlying the requirement.

Created Reports /Visualizations using Spotfire and published them on the Server.

Created Bar charts, Line Charts and tabular visualizations.

Used various complex expressions to create Calculated columns used in the reports.

Created Destinations under Channels.

Created Rules using Rule pallete with Standard, RDBMS Fucntions.

Implemented various processes using Invoke RuleFunction Pallete.

Created EAR files with Business Event Archives included in it.

Used proactive SLA violation alert using Business Events rule engine.

Implemented web services in tibco using SERVICE & SOAP palettes.

Extensively used SOAP, Service, JMS, and HTTP palettes during development.

Implemented complex transformation logic with XPath and XSLT.

Implemented the security using SSL.

Created DDL, DML and PL/SQL store procedures.

Designed and developed a Common Object Business Model used for maximum extensibility.

Involved in the configuration of MQ series adapter publication and subscription services.

Used the agile scrum methodology in the entire project.

Build common libraries to be used across projects.

Modified existing interfaces and introduced more common components which can be reused.

Responsible for fine-tuning service performance to improve overall response time.

Environment: Solaris 10, Windows Professional, Windows Server 2008, TIBCO – TRA 5.5.0/5.6.2, Business Works 5.6, Business Events 4.0/3.0, TIBCO Active spaces 2.0, IProcess 11.0, RV 8.1.2, EMS 5.1.0, TIBCO Administrator 5.6, Hawk 4.8 MQ Series Adapter 5.6, SQL Developer, Tibco Spotfire 6.0

Infosys - Adidas, UK

Tibco Developer / Administrator

Nov 2012- Dec 2013

Responsibilities:

Involved in the architecture and design of the ISB Framework components.

Involved in development of proof of concepts to given requirements.

Designed the class diagrams, sequence diagrams using UML.

Created architecture flow diagrams in Visio.

Created Data Exchanges Technical design templates.

Designed ISB Templates for the construction of Data Exchanges in Tibco.

Configured web services and exposed to Integration Partner applications

Extensively used SOAP, Service, JMS, and HTTP palettes during development.

Created and configured queues, topics and users in tibco ems servers.

Deployed Web Services by defining WSDL’s and using SOAP activities.

Implemented the security using SSL and WS-Security.

Implemented complex transformation logic with XPath and XSLT

Built test harnesses using TIBCO Designer.

Involved in capacity planning of Tibco Infrastructure.

Deployed the service onto various environments by using TIBCO APPMANAGE Scripts.

Build the EAR Files for different processes and Adapters from TIBCO Designer.

Update the Global variables by using AppManage tools.

Created and Updated the shell scripts required for deployment

Deployed the “.ear” files on the Development, Testing and Production boxes.

Supported Testing Environment to test the code.

Involved in Proof of concepts for Oracle Webservices Manager which is a security component between ISB and Integration partners.

Deployed the service onto various environments by using TIBCO BW Administrator.

Performed unit testing, integration testing and performance testing.

Resolution of HP Service Manager Incidents & Service Requests for TIBCO middleware.

Environment: Solaris 10, Windows 2003, TIBCO – Business Works 5.7, RV 7.6, EMS 5.1.0, Administrator 5.6, Business Connect 5.2, SOAP Protocol, SmartMapper Adapter & Plug-in 5.3, Hawk 4.8, Microsoft Visio, SOAP 1.1, WSDL’s, Oracle Webservices Manager Security, FTP

Infosys - InQuba, India

Tibco Developer

Feb 2010 - Nov 2012

Responsibilities:

Configured ADB adapter for oracle database and used opcodes to insert or update into database

Designed and developed various XSD schemas for Common Data Model.

Implemented complex transformation logic with XPath and XSLT

Implemented the common logging and error handling service with the Interface.

Installed and configured TIBCO EMS fault tolerant servers, queues, topics, routes, zones, users and groups.

Deployed the service onto various environments by using TIBCO APPMANAGE Scripts.

Build the EAR Files for different processes and Adapters from TIBCO Designer.

Created Hawk Rules on deployed Process and Adapter Engines.

Update the Global variables by using AppManage tools.

Created and Updated the shell scripts required for deployment

Deployed the “.ear” files on the Development, Testing and Production boxes.

Supported Testing Environment to test the code.

Configured Spotfire Server, Node Manager, Spotfire web player instances and Spotfire automation services.

Created Hawk rule bases using TIBCO HAWK 4.5

Deployed code into DEV, Testing and Production boxes.

Provided rotational on-call Production support for all the EAI applications.

Developed testing BW processes to test the core BW processes.

Environment: HP-UX 11i, AIX and Windows Server 2003, TIBCO – Business Works 5.x, RV 7.x, EMS 4.3.0, Administrator, Active Database Adapter 5.2, File Adapter 5.3, Hawk 4.5, XML, XSD, Spotfire, Spring, Hibernate.

Contact this candidate