Spotfire Developer
Resume:
TANVI SAHAY
**** * **** *****, ******, Texas,****3
Cell : 469-***-****
EXPERIENCE SUMMARY
More than 8 years of IT industry experience in Business intelligence and System Integration Projects with involvement in all phases of SDLC like requirement gathering, estimation, design, development, review, testing, documentation, bug fix and proactive support.
Experience of working on Enterprise Service Bus (ESB), Middleware Services, Messaging Services, Web Services, WSDL, SOAP, REST, IBM MQ, XML, XSD, XPath etc.
Hands on experience in the following Enterprise Application Integration (EAI) tools including TIBCO BW 6.4, TIBCO BW 5.x, TIBCO EMS 8.3, TIBCO Enterprise Administrator, TIBCO ADB Adapter 6.1, TIBCO TRA 5.7, TIBCO
Administrator 5.7, TIBCO AMX BPM.
Experience in BI using TIBCO Spotfire Professional, and TIBCO Spotfire Web player.
Experience of working on Core Java, Python, PL/SQL, Oracle.
Knowledge to perform Data Modeling retaining concepts of RDBMS, Logical, Physical Data Modeling and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions). Also, thorough understanding of ETL concepts.
Good understanding of Data Munging, Data Cleaning and Data Visualization using Python programing and Scientific Libraries NumPy, SciPy, Scikit-learn, Matplotlib and Pandas.
Knowledge and experience of data cleaning, feature extraction, data mining techniques and predictive analytics using variety of Data Mining techniques: Linear Regression, Random Forest & Decision Trees for prediction models
Knowledge of basic UNIX scripting commands.
• Gathered Experience in Agile methodologies (Scrum) and waterfall models.
EDUCATIONAL QUALIFICATION
MS Information Systems, The University of Texas at Arlington, USA May’2017
GPA: 4.0/4
Bachelor of Engineering (Elec and Telecomm), Pt RSU, Raipur, India July’2008
GPA: 7.06/10
ACHIEVEMENTS AND CERTIFICATIONS
Spot award in Synechron for exceeding expectations.
Received WAYNE WATTS Graduate Scholarship at University of Texas at Arlington.
Microsoft Certified Professional.
TECHNICAL SKILLS
Developer Tools : TIBCO Spotfire 7.12, TIBCO AMX BusinessWorks 6,BW 5.11, TIBCO EMS 8.4, TIBCO GI 3.5/ 3.9,
TIBCO ADB Adapter 6.1, TIBCO TRA 5.7, TIBCO Administrator 5.7,TIBCO AMX BPM, Tableau,
Weka, R Studio, Eclipse, Anaconda
DBMS Package : MS SQL and Oracle Server
Big Data Ecosystem : HDFS, HBase, Hadoop MapReduce, Hive, Sqoop, Flume, Spark, Impala, Kafka
Languages : Java, Python, R, HiveQL, PySpark, PL/SQL, XML/XPath/XSD
Testing Tool : SOAP UI
Tracking Tool : HP Quality Centre, Jira, IBM CC/RTC
Messaging Tool : TIBCO-Enterprise Message Service, TIBCO-RV, IBM MQ
Operating System : Windows, Unix
Version Control : IBM Clear Case, Tortoise SVN, Microsoft TFS
Work Experience
Abacus Technical Services, Plano, TX, USA Dec’18 – Till Date
Role: Tibco Developer
American Airlines Dec’18 – Till Date
Description: American Airlines, Inc. AA is a major United States airline headquartered in Fort Worth, Texas, within the Dallas-Fort Worth metroplex. It is the world's largest airline when measured by fleet size, revenue, scheduled passengers carried, scheduled passenger-kilometers flown, and number of destinations served. American, together with its regional partners, operates an extensive international and domestic network with an average of nearly 6,700 flights per day to nearly 350 destinations in more than 50 countries. Customer Notifications sends the notifications and flight alerts to the customers by phone (text or voicemail) or email every time you fly. It allows to customize the alerts for Day-of-travel delays and cancellations, Schedule changes, Bag carousel information, Departure reminders, Gate changes, Arrival alerts.
Responsibilities:
Participate in Business and Functional Requirement discussion with business analysts/Technical Product owner.
Understanding existing functional specification along with impact and interdependency with other application system.
Interact with Application owners, DBA's, Operations, Release management groups to expedite user story deployments.
Develop and maintain the integration application.
Problem troubleshooting, root cause analysis and bug fixes.
Tasks Involved:
•Develop JMS applications and SOAP Web services using TIBCO ActiveMatrix Business Works 5.x., Tibco BE, Tibco Administrator hence creating web applications to enable integration of applications and flow of data across varied systems.
•Develop applications and SOAP Web services using TIBCO ActiveMatrix Business Works 5.x. Create processes and sub process using JMS Queue receiver, Mapper, JDBC call procedure, XSLT, XML, XSD, Amazon SQS, Render JSON, Parse XML activities, HTTP palette, SOAP palette for WSDL(Web Service Description Language) and many other palettes.
•Deployment of code manually/using scripts/ using CI/CD pipeline in various environments.
•Creation of Java Messaging Queues and Topics. Create Bridges for data flow and create Routes for data flow between servers.
•Developing XSD’s and WSDL’s which would be shared with other systems for seamless integration over the internet.
•Unit Test the developed code in development environment and perform the integration testing.
•Develop deployment configuration for complex business solutions, which would be used in live Production environment.
•Implement complex in-memory cache solutions using TIBCO ActiveSpaces.
•Develop the Spotfire Dashboards to show the volume and trend for AA notifications
•Deployment of dashboards and reports to the development and production environments.
•Create the Spotfire dashboards and reports using Bar Charts, Scatter Plots, Map Chats, Pie Charts, Cross tables, Graphical tables, combination charts and various other visualizations.
•Create the visualizations by creating complex calculations/functions and writing Iron Python scripts that can be executed from action controls in the Text Area, from the Graphical Table or the KPI Chart or be triggered by Document Property changes.
•Perform defect troubleshooting, root cause analysis and bug fixing.
Synechron Inc, NYC, NY, USA Jul’18 – Nov’18
Role: Business Intelligence/Spotfire Developer
Asurion Jul’18 – Nov’18
Description: Asurion is the global leader in technology protection services. From lost, stolen and damaged wireless handsets to malfunctioning computers or HDTVs, Asurion provides more than 90 million consumers worldwide with best-in-class, next day device replacement. Asurion also offers protection of user content and software.
Responsibilities:
Participate in Business and Functional Requirement discussion with the Business Analyst/Team lead.
Perform analysis to migrate the existing reports from SQL Server 2012 to Amazon Redshift and Hive.
Interact with Application owners, DBA's, Operations, Release management groups to expedite user story deployments.
Problem troubleshooting, root cause analysis and bug fixes.
Tasks Involved:
Migrate the existing reports from SQL Server 2012 to Amazon Redshift SQL, HiveQL and Denodo VQL by rewriting the reports in the respective formats.
Write scripts for Table/view creation and deletion in Amazon Redshift and Hive.
Write and run L2 Framework scripts to unload the data from Amazon Redshift to Hive.
Perform testing to ensure that the data is properly migrated from SQL server 2012 to Amazon redshift and Hive data platforms. Also coordinate with the BA’s and Business users to ensure the data integrity.
Create Spotfire dashboards / reports with complex multiple data sources (SQL, Excel, Flat files)
Design and develop the Data Source, Columns, Joins, Filters and Procedures in Spotfire dashboard.
Administer users and perform library Management, grant access levels and rights in the Spotfire server for the Spotfire Dashboards.
Develop the Spotfire Dashboards to show the Key Performance Indicators (KPI) hence enabling better management capability and to evaluate vendor performance.
Deployment of dashboards and reports to the development and production environments.
Create the Spotfire dashboards and reports using Bar Charts, Scatter Plots, Map Chats, Pie Charts, Cross tables, Graphical tables, combination charts and various other visualizations.
Create the visualizations by creating complex calculations/functions.
Perform defect troubleshooting, root cause analysis and bug fixing.
GuideIT – a Perot Company, Plano, TX, USA Jul’17 – Jul’18
Role: Tibco Developer/Business Intelligence/Spotfire Developer
Flotek Industries Jul’17 – Jul’18
Description: Flotek is committed to becoming the premier global provider of energy services focused on best-in class technology and exceptional customer service in the support of cutting-edge chemistry solutions that maximize the value of each wellbore for our clients.
Responsibilities:
Participate in Business and Functional Requirement discussion with the clients.
Understanding functional specification and prepare the mapping documentation, detailed design document (DLD) and responsible for overall dashboard implementation.
Providing proactive DEV support for the Dashboards all the way from Dev through PROD.
Worked extensively to provide end-to-end project management from requirements gathering and analysis, through implementation, and post implementation support.
Defect troubleshooting, root cause analysis and bug fixes.
Tasks Involved:
Involved in designing Spotfire dashboards / reports with complex, multiple data sources (SQL, Excel, Flat files) relational design and optimizing applications.
Designing and developing the information links, Data Source, Columns, Joins, Filtering and Procedures. Administered users and Library Management, access levels, rights and folder structure.
Developed Key Performance Indicators (KPI) to enhance management capability and to evaluate vendor performance.
Deployment of dashboards and reports to the testing environments.
Created dashboards, reports with Bar Charts, Scatter Plots, Map Chats, Pie Charts, Cross tables and Graphical tables using the key concepts like filtering scheme (Global Filter), (Local Filter).
Created Dynamic Visualizations using advanced Trellis, Scatter plots, 3D Scatter Plots, Map charts and Tree Map, Text Area, Input Field, Lists, drop down lists, Property, Document Properties, On-Demand Data and In-Database.
Created the visualizations with complex calculations/functions.
Worked on Information Designer, building Information links, elements, filters, joins, prompts, prompt groups.
Code migration across environments (Dev> QA > Prod).
Performed v-lookups in Excel for data comparison within multiple excel worksheets.
Root cause analysis and fixing the issues with the Spotfire environment.
Created Action Controls using Iron Python Scripting to refresh data tables, changing filtering schemes, reset axes, reset marker size, jittering, refresh calculations, on demand data.
Worked on User Access Management, Spotfire library Administration for folder and report management
Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
Environment: SQL 2012, Oracle 11g, Spotfire Server, Web Player Server, Spotfire Professional 7.12, 6.5
Hospitality Management Corporation Feb’17 – Apr’17
Description: Hospitality Management Corporation (HMC) is a privately held provider of management solutions and hospitality industry services, each customized to fit our clients’ unique needs.
Responsibilities:
Participate in Business and Functional Requirement discussion with the clients.
Understanding functional specification and responsible for overall service implementation.
Defect troubleshooting, root cause analysis and bug fixes.
Tasks Involved:
Created TIBCO BW REST and JMS based applications.
PROD support for the component deployed and handling any defects in live environment.
Developing XSDs, WSDLs, Rest API’s.
Developing interfaces between different systems (Creation of new applications).
Taking care of Code Review, Unit Test Review sessions.
Fixing defects found during testing.
Environment: TIBCO Business Works 6.4.2, EMS 8.3, TIBCO TEA, TIBCO Adapters, TIBCO Hawk, TIBCO RV.
Synechron Inc, Pune, India Jul’12 to Jun’14
Role: Sr. TIBCO Developer
Asurion Jul’12 to Jun’14
Description: Asurion is the global leader in technology protection services. From lost, stolen and damaged wireless handsets to malfunctioning computers or HDTVs, Asurion provides more than 90 million consumers worldwide with best-in-class, next day device replacement. Asurion also offers protection of user content and software.
Asurion provides the claim settlement facility through iCare (CSR), iWEB and IVR for claim settlement process fast and easy. To enable this, the Claim filing, processing and settlement application functionalities are exposed in the form of Middle Tier TIBCO services. The underlying BW process was responsible for orchestrating the request and responses and calling appropriate sub services.
Responsibilities:
Participate in requirement discussion with the clients.
Understand functional spec and prepare the design document and responsible for overall service implementation.
Interact with Application owners, DBA's, Operations, Release management groups to expedite user story deployments.
Problem troubleshooting, root cause analysis and bug fixes
Tasks Involved:
Developed XSDs, WSDLs and Web-Services.
Developed interfaces between different systems.
Reviewed the developed interfaces.
Documented the technical design, operation support document.
Created Dev, QA, UAT & PROD artifacts (EAR, deployment configuration files and properties file)
Analyzed and traced defect during system test.
Fixed defects found during QA test with challenging timelines.
Provided support to QA in the testing.
Provided support to deployment team during production releases.
Environment: TIBCO BW 5.6, TRA 5.6.2, Tibco Administrator 5.4, EMS 5.1, MS Visio.
Mahindra Satyam, Hyderabad, India Mar’10 – Jun’12
Role: Sr. Software Engineer
Golden Rule Insurance Mar’11 – Jun’12
Description: Golden Rule Insurance is a part of United Health Care Group, which is the largest health insurance provider in the United States. Previously, Golden Rule processes were manual, requiring human centric workflow to perform the required task and were tied to Mainframe applications that were difficult and time consuming to manage. The architecture used was open to allow easy future extension and business continuity and scalability.
Responsibilities:
Understand the requirements raised by the client.
Understand the existing project setup and bring up the changes as per service change requests.
Completed Software Development Life Cycle (SDLC) of the changed code, analyzed the code, prepared design documents, and implemented the design.
Create services which adhere to SOA.
Tested and deployed the codes.
Worked on TIBCO BW 5.9, TIBCO GI 3.9, and TIBCO iProcess 11.1.1.
Performed Software Testing Life Cycle (SDLC) of the code.
Problem troubleshooting, root cause analysis and bug fixes.
Tasks Involved:
Developed XSDs, WSDLs and Web-Services.
Developed interfaces between different systems.
Reviewed the developed interfaces.
Documented the technical design, operation support document.
Created Dev, QA, UAT & PROD artifacts (EAR, deployment configuration files and properties file)
Analyzed and traced defect during system test.
Fixed defects found during QA test with challenging timelines.
Provided support to QA in the testing.
Provided support to deployment team during production releases.
Environment: TIBCO BW 5.7, TIBCO GI 3.9, TIBCO iProcess 11.1.1, MS SQL Server
Cisco Systems Oct ’10 to Feb’11
Description: The Cisco Cash Rover (Quote To Cash Q3FY11) is a migration project where we migrated the existing applications from San Jose to RCDN, USA. RCDN architecture is based on virtualization of the physical hardware using SODC technologies. BPIM RCDN architecture will provide scalability and flexibility while at the same time increasing system resilience. The BPIM environment provides a location to run TIBCO Businessworks (BW) and TIBCO Active database Adapter (ADB) applications. It is a middleware environment which facilitates app-to-app integration.
Responsibilities:
Complete SDLC for the new set of Tibco adapters based on existing set of Tibco Adapters.
Performed code deployment on UNIX servers using scripts and by creating packages using Cisco Specific Kintana Tool.
Perform Software Testing Life Cycle of the Tibco Adapters to check the flow of data.
Creating/Maintaining Project Workbook.
Tasks Involved:
Developed XSDs, WSDLs and Web-Services.
Developed interfaces between different systems.
Reviewed the developed interfaces.
Documented the technical design, operation support document.
Created Dev, QA, UAT & PROD artifacts (EAR, deployment configuration files and properties file)
Analyzed and traced defect during system test.
Fixed defects found during QA test with challenging timelines.
Provided support to QA in the testing.
Provided support to deployment team during production releases.
Environment: TIBCO BW 5.8, TIBCO ADB Adapter 6.0, Tibco EMS 4.4.3
National Australia Bank Mar ’10 to Oct’10
Description: The NAB Tibco Refresh is a migration project to migrate the existing services in NAB built using TIBCO BW 5.3 to TIBCO BW 5.8. The services build on TIBCO BW version 5.3 are to be migrated to new Tibco Version.
Responsibilities:
Understanding the services built in Tibco BW 5.3
Worked on the migration of the existing services built using TIBCO BW 5.3 to TIBCO BW 5.8.
Created test cases using SOA Test suite 6.2 and tested services prior to migration captured the responses.
After the services are migrated to TIBCO BW 5.8, tested the services using the test suites created earlier and validated the response against the response got prior to migration.
Tasks Involved:
Developed XSDs, WSDLs and Web-Services.
Developed interfaces between different systems.
Reviewed the developed interfaces.
Documented the technical design, operation support document.
Created Dev, QA, UAT & PROD artifacts (EAR, deployment configuration files and properties file)
Analyzed and traced defect during system test.
Fixed defects found during QA test with challenging timelines.
Provided support to QA in the testing.
Provided support to deployment team during production releases.
Environment: Tibco BW 5.8, Tibco EMS 4.4.3, Tibco ADB Adapters, TRA, TIBCO Hawk
Convergys India ltd., Pune, India Mar’09 – Mar’10
Role: Support Engineer
Microsoft Corporation Mar’09 – Mar’10
Worked to resolve performance related issues like Server Hang, Server Crash, High CPU usage, terminal Services, RDP, DCOM, WMI and server printing related issues.
Environment: Windows Server 2000, Server 2003, Server 2008, Server 2008 R2.
ACADEMIC PROJECTS
H1B Petition 2011-2016 Jan’17 – Mar’17
Predicted the H1b petition acceptance with an Accuracy of 89% using Pyspark and ML and MLLib modules.
Tools & Packages Used: PySpark, Apache Hadoop, IBM BlueMix, Anaconda 2.7, CDH, Python: Pandas, SKLearn, MatPlotLib,
Wine Quality Prediction Jan’17 – Mar’17
Predicted the wine quality with an Accuracy of 89% using Pyspark and ML and MLLib modules.
Tools & Packages Used: PySpark, Apache Hadoop, IBM BlueMix, Anaconda 2.7, CDH
Movie IMDB Score Prediction and Recommendation Aug’16 – Dec ‘16
Analyzed and visualized IMDB movie dataset from Kaggle and predicted the IMDB score of the Movie with 80% accuracy. Also, build Recommender System using KMeans clustering algorithm and UI using Flask.
Tools & Packages Used: SKLearn, MatPlotLib, Plotly,MLlib, Pandas,Numpy,Clustering, Anaconda 2.7, PyCharm Prof. 2016.3
Post-Election Social Media Analytics Aug ‘16 – Dec’16
Scraped Hillary, Trump and Obama’s data using Twitter Streaming API, Twython. Calculated sentiment score and created word cloud for each person. Performed Topic Analysis using NNF and LDA.
Python Packages Used: Twython, TextBlob, NLTK, Wordcloud, SKLearn, Gensim.
Pokemon Go! Analytics Aug ’16 – Dec’16
Performed Web Scraping to collect data. Performed Deep Learning to predict the number of customer ratings.
Used python packages - BeautifulSoup, MatPlotLib, Tensor Flow.
Automotive Sales Relational Database Implementation Jun ‘16 -- Aug ‘16
Identified entities for automotive sales and procurement business process and created Entity-Relationship diagrams to represent the relations between entities and converted logical model into physical model. Created Tables, Views, Constrains, Synonyms & Sequences. Used PL/SQL on Oracle database.
Predicting Phishing Websites-Data Mining Jan ‘16 – May’16
Researched the UCI Learning Repository for the data set. Predicted whether a website is phishing website or not, used data cleaning, feature extraction techniques and used data mining algorithms like J48, Naïve Bayes, PART and analysed the results. Used Excel -Look-ups, Pivot tables, Macros, VB and Weka for analysis and Tableau for visualization.
Personal Details:
https://www.linkedin.com/in/tanvisahay/
*******@*****.***
Father’s name
Mr. Prakash Bhushan
Present Address
7911 N Glen Drive, Irving, Texas, 75063
Contact this candidate