Manager – Digital Capability Management Technical Analyst
| Company | Bristol Myers Squibb |
|---|---|
| Location | Princeton, NJ, USA |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | |
| Experience Level | Senior, Expert or higher |
Requirements
- Expert with advanced SQL commands and complex queries.
- Expert database concepts in Oracle and SQL Server
- Expert knowledge of relational databases and tools such as Oracle, MSSQL, Toad, SQL navigator, SQL Server Management Studio.
- Working Knowledge of Crystal Reports.
- Working knowledge of programming languages such as PL/SQL, Javascript, JQuery, XML, CSS, HTML.
- Working knowledge of scripting (any language)
- Working knowledge of Power BI or Tableau
- Working knowledge of job scheduling on any platform.
- Working knowledge of the use of transfer protocols such as sFTP.
- Working knowledge of integration technologies such as MFT, WebMethods, and encryption methods.
- General knowledge of source code repositories such as Git or SVN.
- General knowledge of AWS, RDS, Java/JSP, .NET
- General knowledge of middleware platforms such as Websphere and Oracle OHS.
- Basic Understanding of Windows and Linux Operating System.
- Basic Understanding of Web and Cloud Computing and Client Servers Architecture.
- Basic Understanding of Network Protocol and Topology.
- Proficient use of Excel for data manipulation.
- Demonstrated experience in delivering Corporate Application Services capabilities and managing/partnering with software vendors and service providers.
- Strong IT domain expertise in multiple sub-units and an understanding of how the teams are supported by IT tools and systems.
- Proven track record of successful IT delivery (BUILD) and ongoing operations (RUN).
- Excellent collaboration and communication skills, with the confidence to build strong partnerships with IT colleagues, external technology partners and service providers.
- Experience with both web/front-end and back-end applications.
- Extensive experience in report writing and data visualization.
- Excellent skills working within the IT matrix to define, deliver and run digital capabilities.
- Deep analytical skills and logical thinking to identify and resolve technical issues.
- Ability to focus on details while maintaining a clear understanding of high-level design requirements.
- Capable of managing multiple simultaneous high priority workloads.
- Experience with application maintenance and support as well as troubleshooting application and data related issues.
- Understanding of supporting financial teams during quarter end financial closes.
- Experience with Project Management and leading projects to completion.
- Ability to apply technical solutions to business processes.
- Familiar with agile and scrum methodologies.
- Experience with creating application workflow and database design.
- Familiar with Change Management Process.
- Experience managing offshore technical development team.
- Experience with creating Wire Frames and Business Process Flows.
- Experience with creating architectural diagrams/understanding of infrastructure setups/managing deployments ranging with varying complexities.
- Experience with organizing and leading conference calls to troubleshoot issues with stakeholders which can include the business.
- Knowledgeable with data migration process.
- Proficient with use of ServiceNow to create Change, Demand, Incident tickets or similar tool.
Responsibilities
- Develop and maintain Crystal Reports in Quantum Treasury Management System
- Develop and maintain various interfaces between Quantum and other systems (Autobank, AtlasFX, Bank Statements, Bloomberg, CashOptix, ABR and others)
- Develop, maintain, and monitor automated scheduler jobs
- Provide support for the Quantum Dataloader (360T, Actual Cashflow, Projected Cashflow)
- Develop and maintain Bloomberg Data License scripting requests for interface files
- Provide support for monthly multilateral netting process
- Provide troubleshooting/investigative/research support for various applications both custom built and vendor that requires database design knowledge and expertise.
- Provide Quantum Citrix and WinSCP/SFTP access assistance
- Provide support for custom application AutoBank Reconcilation
- Provide support for custom application TAMS (account management, certification, FBAR reporting)
- Provide support for custom application WP Occupancy Planning.
- Develop, maintain, and provide support for Tango badging interfaces (CCure and Lenel) for Global Real Estate Workplace Services
- Provide support for custom interfaces for Concur 350 feed, Brazil Flytour
- Provide support for custom applications Central Bill Form and VIP Travelers Admin
- Provide support for PL/SQL custom applications (ACS, File Import Tool, Internal Audit Report, Leapfrog Analytics Security Access)
- Provide support for custom application R&D Custom Valuation
- Develop and maintain PowerBI dashboards
- Possess aptitude to learn new programming tools and apply them
- Serve as a surrogate for the development and maintenance of Wdata integration processes within the Workiva Wdesk platform
- Serve as a surrogate for Tango PowerBI dashboards and DREWS database.
Preferred Qualifications
- General knowledge of AWS, RDS, Java/JSP, .NET
- General knowledge of middleware platforms such as Websphere and Oracle OHS
- Familiar with agile and scrum methodologies
- Experience managing offshore technical development team.