Manager Data
Resume:
Namrata Gade ****.*******@*****.***
Senior Technical Consultant Phone: +1-203-***-****
Professional Summary
Senior Consultant with 14 years of experience in Financial Services and life sciences with a range of BI Administration & Development, Business Analysis, Technical lead and IT Project Management roles to achieve business goals.
Tibco Spotfire: Platform Administration and development of dashboards on Tibco spotfire version 10.3, 7.11, 7.10, 7.6, 7.0, 6.5, 4.5.
Proficient with installation, configuration and upgrading spotfire server, spotfire node manager, automation services, tibco data visualisation tool (TDV), Statistical Services for TERR.
Work on third party plugins like EPAM Excel, EPAM SharePoint, and Scistream Signals.
Experience in creating information model, visualizations, collaborations, automation jobs.
Implement Caching mechanism to reduce the load and interactions with Database.
Work on IQOQ process (Installation Qualification Operational Qualification).
Troubleshoot and resolve incidents relating to interfaces implemented.
Ensure adherence to client's processes and regulatory compliance needs.
Cognos BI: Experience with Report Deployment, Scheduling, Creating Portal pages, Cognos Administration, security implementation of Package, Object, Data level security using Framework Manager and Cognos Connection.
Maintain Windows servers including patching, disaster recovery, and security
Work with system admin and network teams to troubleshoot any system level issues impacting application health.
Promote, implement, document, and communicate BI best practices and Standard Operating Procedures
Knowledge of Tableau, PowerBI and Microsoft Azure
Technical Skills
Business Intelligence - Tibco Spotfire 10,7.11, 7.10,6.5,4.5, IBM Cognos Business Intelligence 10.2/8.4/8.2, Reportnet, Impromptu
Database - Oracle 10g/9i/8i, MS SQL Server 2000/2005
Operating Systems - Windows 2016, Windows 2000 Server, Windows XP
Project Management -Agile and Standard waterfall Model approach. Project Planning and execution in Confluence & JIRA, Tech Lead Activities, Process Simplification, change management and ITIL processes.
Domain Experience - Treasury, Financial Services, Regulatory Reporting & Compliance, life science/Pharmaceuticals
Tools - PL/SQL Developer, Notepad++, ALM, Putty, Openstudio, MS visio, JIRA, Service Now, leankit, Azure Devops
Certifications and Key Achievement
oCognos 10 BI Author
oSix Sigma Green Belt (GB)
oPublished white paper on TM1 at IBM’s Business Analytics (https://www-304.ibm.com/connections/blogs/basupportlink/entry/automated_archival_of_cognos_tm1_data_servers7?lang=en_us)
Educational Qualifications and Training:
Master in Computer Application (MCA), Indira Gandhi National Open University, India
Bachelor in Commerce (B.Com), Mumbai University, India
PROFESSIONAL EXPERIENCE:
Employers:
BPK Inc- August 2020 till Date
LNT Infotech - Jan 2020 till August 2020 (8 months)
Quantum Integrators LLC – July 2017 till Dec 2019 (2.5 yrs)
Tech Mahindra – Jan 2015 till July 2017 (2.5 yrs)
Eyork Consulting Inc – Oct 2014 till Dec 2014 (4 months)
Tata Consultancy Services Limited – Dec 2011 till Oct 2013 (2 yrs.)
Aditya Birla Minacs – Oct 2005 till Dec 2011 (6 yrs.)
Job titles/Roles:
Senior Technical Consultant
Spotfire Admin
Associate Technical Architect
I.T. Analyst
BI Analyst
Technical/Module Lead
Offshore Lead
KEY PROJECTS
BPK Inc August 2020 till date
Work closely with Business to provide instantaneous insight by transforming data into visually appealing, interactive visualizations called dashboards using Spotfire.
Customer - BPK
Role – BI Analyst
Tools: Spotfire 10.3 Server, Spotfire 10.3 Node manager, Spotfire Automation Services, Azure Devops
As a Spotfire Admin, performed upgrades, hot fixes, server installations & webplayer installations.
Installed Spotfire Server Hotfixes, Database drivers.
Perform day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting
Hands on development assisting users in creating, modifying Spotfire visualization dashboard and getting data into Spotfire from different data source.
Installed a configured and administered the server environment, including Users, Groups, Licenses, Preferences, and Properties.
Configured the Spotfire Application Server and the Spotfire Web Player Server for optimal use
Performed daily admin tasks of user registration, security configuration and usage monitoring
Administered Spotfire programs and supported library management.
Evaluated log files and implemented performance tuning.
Supported Spotfire logs for resolution of issues.
Participated in connection of Spotfire with Oracle data sources.
Implemented system modifications as per established requirements.
Prepared project estimates and analyzed reporting issues.
Formulated dashboard specifications and generated status reports.
Documented and maintained practices for system installations and configurations.
Data Integration and Analytics Managed Services January 2020 till August 2020
Provides troubleshooting and diagnostic support at L2 / L3 level for reporting technologies. Work closely with Business to provide instantaneous insight by transforming data into visually appealing, interactive visualizations called dashboards using Spotfire. Monitoring the server and maintaining platform. Handling POCs for the new projects and Performance enhancements.
Customer - Johnson and Johnson Information Technologies
Role - Senior Technical Consultant
Tools: Spotfire 10.3 Server, Spotfire 10.3 Node manager, Spotfire Automation Services, leankit, Servicenow
Roles and Responsibilities
Upgrade Spotfire server node manager and webplayer version to 10.3 from version 7.10.
Implement Caching mechanism in spotfire to reduce the load and interactions with Database.
Configure spotfire for Kerberos authentication.
Upgrade Statistical Services version 7.10 and Install TERR as a node manager service.
Upgrade Spotfire professional/analyst.
Apply appropriate hotfix and fix packs to include the upgrade feature and keep the environment upto date.
Trust spotfire scripts for the dashboard including Scripts.
Documented and maintained practices for system installations and configurations.
Configure Library Administration for appropriate folder structure and assign folder permissions.
Coordinate with Control M and Tidal teams to create jobs in spotfire to externally trigger spotfire dashboard refresh and send job alerts when dashboard refresh completes.
Support 24*7 for platform for users from NA, SA, EMEA and Asia.
Fully Compliant with SLA timelines.
Formulate dashboard specifications and generated status reports.
Support spotfire reports using SBDF Files, SAS, and Sci-stream Signals.
Design and develop Information Model, Bookmarking, Collaborations, and Visualisations to develop and support spotfire dashboards.
Manage migration of objects between Development, QA and Production environment in the appropriate and recommended order.
Create spotfire migration automation migration process for promoting spotfire library objects to higher environment.
Create automation jobs to send spotfire reports via email or to shared location and send email notification to users when the file is delivered.
Create spotfire environment monitoring dashboard to monitor the health and utilisation spotfire servers.
Create automation jobs to send email alerts after the spotfire scheduled updated have completed for their teams and attach txt file with details.
Create an altering system for spotfire servers to send email alerts when the services stop or when the server utilisation increase the specified threshold.
Develop user utilisation reports in spotfire environment to track spotfire license usage.
Work on third party plugins like EPAM Excel and EPAM Powerpoint to export spotfire dashboards.
POC on spotfire silent installation thru automated scripts to reduce the installation process and time.
Work on service- now (ITSM Model) to raise and resolve request tickets, incidents.
Follow the Change Management cycle work on raising and Initiate, submit and implement change requests
Attend CAM meetings for approvals of exceptional change request.
Trouble shoot errors and work on priority tickets.
Evaluated log files and implemented performance tuning.
Supported Spotfire logs for resolution of issues.
Used spotfire automation services to create automated jobs via xml builds and schedule jobs daily, weekly basis.
Log technical support tickets with vendor helpdesk
US Build Admin July 2017 till December 2019
Provides troubleshooting and diagnostic support at L2 / L3 level for these technologies. Work closely with Business to provide instantaneous insight by transforming data into visually appealing, interactive visualizations called dashboards using Spotfire. Monitoring the server and maintaining platform. Handling POCs for the new projects and Performance enhancements are included in scope.
Customer – Quantum Integrators-Johnson and Johnson Information Technologies
Role - Spotfire Admin
Tools: Spotfire 10.3 Server, Spotfire 10.3 Node manager, Spotfire Automation Services, leankit
Roles and Responsibilities
Hands on development assisting users in creating, modifying Spotfire visualization dashboard and getting data into Spotfire from different data source.
Used Spotfire Automation Services Builder to Export DXP file during Migration Process.
Apply the best design practices for analyses and dashboards
Expert in manipulate existing data columns, merge data, add data tables, connect to in-database data, using bookmarks, tags, and lists to capture aspects of your dynamic analysis and consider the available aggregation options and expression shortcuts
Installed a configured and administered the server environment, including Users, Groups, Licenses, Preferences, and Properties.
Configured the Spotfire Application Server and the Spotfire Web Player Server for optimal use
Performed daily admin tasks of user registration, security configuration and usage monitoring
Optimized Information links and queries to increase performance Design and implementation of a global, enterprise class Spotfire environment
Installed and Configured the Spotfire Statistics Services on a standalone Installation
End to end experience in designing and deploying data visualizations using TIBCO Spotfire
As a Spotfire Admin, performed upgrades, hot fixes, server installations & webplayer installations.
Installed Spotfire Server Hotfixes, Database drivers.
Perform day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting
Work on third party plugins like EPAM Excel and EPAM Powerpoint to export spotfire dashboards.
Update the CMDB Model for spotfire and related upstream and downstream CI.
Trouble shoot errors and work on priority tickets.
Evaluated log files and implemented performance tuning.
Supported Spotfire logs for resolution of issues.
Log technical support tickets with vendor helpdesk
Part of the team created for POC for installing spotfire on Microsoft Azure.
Participate in project planning and system requirement for spotfire installation and configuration
Create Resource for installing spotfire server
Create Database for creating spotfire repository and audit database
Create virtual network for installing spotfire servers
Create virtual machine to install spotfire servers and node manager on windows 2016 datacenter servers
Manage security thru azure AD.
GE Global Operations EDM Platform January 2017 till July 2017
GE is accelerating the establishment of shared services to deliver better outcomes at lower cost for our businesses and customers.
Customer - TechMahindra Americas Inc-GE Capital Corporation
Role - Associate Technical Architect
Tools: Spotfire Server 7.0/7.6, Spotfire webplayer 7.0/7.6, MS Office, Servicenow
Roles and Responsibilities
Leading a team of 16 and supporting a user base of 12000 users.
Worked on a distributed and complex environment to ensure it is available 24*7.
Prepare project status report, lead daily hand over calls, daily request tracker.
Prepare KT plan and conduct KT sessions.
Prepare migration plan and testing strategies for Upgrade to 7.6 and on-going hotfixes.
Upgrade Spotfire sever, webplayer and automation services from 7.0 to 7.6.
Configure Apache services to load balance spotfire servers.
Install and configure automation services to optimize and automate the process of dashboard caching.
User access automation thru IDM integration.
Scripts to generate auto alerts for long running schedules.
Performed daily admin tasks of user registration, security configuration and usage monitoring.
Install and configure non default data drivers like Teradata, greenplum and denodo to use with spotfire. Perform POC on hadoop hive datasource.
Develop dashboards for end users to provide daily status of the dashboard utilization, show the latest caching status of dashboards, dependant components of a dashboard.
GE Treasury ET environment Admin January 2016 to December 2016
GE Capital is the financial services division of GE, focused on serving customers and markets aligned with GE’s industrial businesses
Customer - TechMahindra Americas Inc-GE Capital Corporation
Role - Associate Technical Architect
Tools: Spotfire Server, Spotfire Webplayer, IIS, MS Office
Roles and Responsibilities
Proficient with Spotfire installation and configuration on windows environment
Prepared project proposal and timeline for upgrade project including the database and server sizing
Working with vendor to get the application software for installation
Responsible for working with database team to get the database ready
Worked on a distributed environment to ensure it is available 24*7
Follow best practices to install and configure spotfire components.
Configure the server for database, ldap configuration, data drivers, library paths
Install the configure non default data drivers like Teradata, greenplum and denodo to use with spotfire
Configure IIS and appropriate feature required to be used by the customize portal pages designed in spotfire
Configures Library Administration for appropriate folder structure and assign folder permissions and assign appropriate licenses and preferences to the groups.
Deploy objects from spotfire 6.5.3 to spotfire 7.6
Work with network teams to get the dns names created and load balance the environment.
Work with SSO team to make spotfire siteminder protected.
Apply appropriate hotfix and fix packs to include the upgrade feature and keep the environment upto date
GE Treasury ET environment Admin Jan 2015 to December 2015
GE Capital is the financial services division of GE, focused on serving customers and markets aligned with GE’s industrial business.
Customer - TechMahindra Americas Inc-GE Capital Corporation
Role - Associate Technical Architect
Tools: Spotfire 4.5/6.5
Roles and Responsibilities
Prepared project proposal and timeline for upgrade project including the database and server sizing.
Working with vendor to get the application softwares for installation.
Responsible for working with database team to get the repository and action log database
Worked on a distributed environment to ensure it is available 24*7
Provide training to end users on using the tool.
Review the release document and participate in release management meetings
Manage migration of objects between Development, QA and Production environment in the appropriate and recommended order.
Trouble shoot errors and work on priority tickets
Actively participate in failover activity and disaster recovery management performed semi-annually.
Act as a liaison between multiple teams actively required for successfully failover
Configured the Spotfire Application Server and the Spotfire Web Player Server for optimal use
Performed daily admin tasks of user registration, security configuration and usage monitoring
As a Spotfire Admin, performed upgrades, hot fixes, server installations & webplayer installations.
Installed Spotfire Server Hotfixes, Database drivers.
Perform day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting
Eyork Consulting Inc October 2014 till January 2015
Consult with customers on project status, proposals, or technical issues, such as software system design or maintenance.
Customer - Eyork Consulting Inc - Internal - New York
Role – Programmer Analyst
Tools: Open Studio, MS Office, Spotfire 6.0
Roles and Responsibilities
Modify existing software to correct errors, to adapt it to newer hardware, or to upgrade interfaces and improve performance.
Develop or direct software system testing or validation procedures.
Direct software programming and development of documentation.
Consult with customers or other departments on project status, proposals, or technical issues, such as software system design or maintenance.
Analyze information to determine, recommend, and plan installation of a new system or modification of an existing system.
IRRM, Third Party Debt, GE Treasury DDS Reporting & Y9C December 2011 to Oct 2013
Interest rate risk is that which exists in an interest-bearing asset, such as a loan or a bond, due to the possibility of a change in the asset's value resulting from the variability of interest rates. The purpose of the IRRM Reporting project was to outline business requirements for design and development of the automated reporting solution (Balance sheet, Income Statement, curve and eve Sensitivity Reports, gap analysis etc.) that can be leveraged in the future for any IRRM Data quality issues.
Customer - Tata Consultancy Services-GE Capital Corporation
Role: - Cognos Developer-BI Analyst
Tools: Cognos Report Studio, Cognos Query Studio, Cognos Framework Manager, MS-Visio, Spotfire 4.5
Roles and Responsibilities
Develop reports in Cognos report studio, related to change management requests.
Track the project status and all the SDLC phases of the project.
Understand reports created using Spotfire and convert it to Cognos 10.
Create multi page reports by using cascading prompts, conditional formatting and page rendering.
Develop active reports using Cognos 10 version in various environments.
Create Dashboards in Report Studio to display the data interactively to the end users as per the business requirement.
Supplement regular prompts, cascading prompts, filters, conditional style, drill through to the reports using report studio.
Define Governor Settings accordingly to improve the performance by restricting unnecessary querying
Use hash prompts to pass default value for an optional prompt.
Use both Cognos functions and vendor specific functions to simplify the report design and improving the performance.
Use page break property to show each group of values in the different pages.
Develop queries against the database to test the existing reports.
Test the prototype of reports.
Prepare technical design, Unit test specifications and deployment documents as per the process compliance
Co-ordinate with deployment and support resources to ensure that solutions gets implemented smoothly into QA and production environments
Coordinate with business and IT users for user acceptance testing
Compass - BPO Reporting May 2007 to December 2011
The project provides an insight into the Financial activities of COMPASS-BPO Pvt. Ltd. Whose Business is Spread across UK, USA and Middle-East. Involved in initial setup of Cognos 8 and Development of Finance reports for data analysis and decision making by business owner.
Customer - Aditya Birla Minacs BPO Pvt Ltd - Mumbai, India
Role - Business Analyst
Tools: Cognos Report Studio, MS Visio, MS Office
Roles and Responsibilities
Requirement analysis to initiate SDLC process on modelling.
Mapping functional specifications and translating these requirements into Technical specifications.
Correlate and analyses the different source systems, identify and understand the business rules.
Development of HLD, LLD, Unit Test. Project management in terms of various technical and functional documents creation, production releases, review of functional design and impact analysis.
Planning testing scenarios, preparation of test cases and data validation using PL/SQL.
Create adhoc reports for testing purpose. Create data standalone filters, parameter maps and session parameters macros in framework manager model.
Develop drill through reports in Report studio using Cognos BI tool according to the business requirements.
Reports and Packages deployments to Development, QA and finally to Production.
Designing Portlet’s for different users using Portal Administration in Cognos Connection.
Import metadata from multiple databases to create subject oriented business models and publish packages to Cognos Report server in Framework Manager.
Create relationships between query subjects to better represent the logical structure of the business and the user requirements.
Author reports using Report Studio to develop multiple queries in a single report to optimize the report and to improve performance of the report.
Use advanced features of Report Studio like Conditional blocks, Conditional layout, Drill-through, Master detail relationship, conditional formatting etc. to highlight the business needs and to create Sample Dashboards.
Create Dashboards – AP Ageing, AR Ageing, and Revenue Analysis.
Project Status Report – showing the revenue and cost analysis of various projects in an organization. Troubleshooting and deploying Reports on Production Server.
Prepare help documents or instruction manuals
Compass - Consulting Projects Oct 2005 – May 2007
Costpoint is an integrated ERP system designed for project-oriented businesses. It integrates project and organizational accounting features with powerful capabilities in traditional accounting modules like GL, Labour (TS), Payroll, AP, AR, Purchasing, and FA.
Customer - Aditya Birla Minacs BPO Pvt Ltd -AECOM Migration and Reporting, Anham- Mumbai,India
Role – BI Analyst
Tools: Impromptu 7.2
Roles and Responsibilities
Create catalogs using Impromptu 7.2 and developed complex reports using Hot File Concepts.
Migrate Impromptu reports into Cognos 8.4 environment.
Create various Billing formats & Invoice reports in the standard government formats.
Create Dashboards – AP Ageing, AR Ageing, and Revenue Analysis.
Project Status Report – showing the revenue and cost analysis of various projects in an organization. Troubleshooting and deploying Reports on Production Server.
Contact this candidate