Robert Dill Email & Phone Number

Newark, De, Us

London, Gb

London, Gb

Dublin 2, Ie

-Work with business contacts to discover current application technical details to support application migration activities to Azure or new Data Center. -Submit and track requests for servers and infrastructure to support application migration activities.-Support application remediation efforts with client contacts. -Work with various internal teams to complete application migrations. -Report statuses, risks, potential issues to program team.

Dublin 2, Ie

Produce detailed technical and functional designs for Informatica and DataStage. Develop mappings and workflows in Informatica and parallel jobs in DataStage to facilitate data integration. Perform administrative functions to maintain user accessibility, version upgrade, security, system availability and performance.

Dublin 2, Ie

-Defined the test approach across SAP BW, Data in Hub, Business Objects, and ETL. -Created and executed test scripts. -Provided direction and assistance to resources resolving defects.-Maintained entry and oversaw the scheduling and management of System Integration and User Acceptance testing. The application HP ALM (HPQC) was the primary tool used.

Dublin 2, Ie

-Led analysis, design, coding and testing of Informatica TDM and Informatica PowerCenter components as they applied to the data subset function of Test Data Management. - Implemented ETL performance enhancements.- Designed, implemented and maintained a UNIX shell script based solution to backup crucial Informatica objects. The solution uses a combination of metadata queries and shell scripting to parse, export and archive xml files.- Contributed to people development and education through one-on-one instruction and by hosting instructional WebEx's, brown bag lunch presentations and code reviews.-Relationship discovery and sub-setting of a major system (1200 tables) of extremely large transactional data tables with hierarchical complexity while maintaining referential integrity

Dublin 2, Ie

-Supported data integration for the HCM Governance & Business Processes MDM project using Informatica - Powercenter, offshore coordination, design documentation, data Integration, data analysis, system validation, Oracle databases, stored procedures, shell scripts and UNIX.-Worked closely with the offshore ETL team supporting multiple data sourcing initiatives. -Extensive interaction with the client process owners and architecture team.

Dublin 2, Ie

-Provided interim support for all ETL related systems during performance coatings business transition from Dupont to Axalta.-Acted as liaison and SME of ETL processes to ensure smooth and uneventful cut-over.-Performed troubleshooting for resolution of helpdesk tickets.

Dublin 2, Ie

-Developed solutions to issues reported through help desk service tickets as well as client requests.-Supported existing applications and the development of new components. -Performed in-depth levels of analysis on rich and transaction intensive data augmenting the ETL technical support. -Demonstrated a high level of communication skill in relaying complex technical solution descriptions for extensive approval and tracking processes.Informatica PowerCenter was the primary ETL tool. BW, SAP R/3, and BOBJ experience was necessary. UNIX scripting was used extensively and a deep understanding of them and file manipulation was necessary for trouble shooting and issue resolution. DB2, Oracle and SQL databases were all used and mastery of their related syntax and functionality was required.

Charlotte, Nc, Us

Developed, tested, and rolled out technology-based projects for use in event marketing of approximately 1.2 million customers annually. • Saved $23,200 annually in processing and fulfillment costs by developing, testing, and implementing a wireless solution to obtain credit applications at live venues via PC tablets.• Identified $8,302 in duplicated invoicing by creating a vendor compensation reconcilement database which reduced a 2 day process down to 1 hour. 100% error-free processing was obtained.• Researched and documented process flows and developed desktop procedures and audits.

Charlotte, Nc, Us

Produced granular, critical, statistical analysis of account portfolio performance by marketing channel. Developed all supporting FOCUS and SAS queries. Created full function spread sheets through formulas, automation and pivot tables.• Reduced report production time by 25% by reengineering existing database to automate routine data retrieval and established a pushbutton, user-friendly interface.• Initiated monthly account projection meetings with marketing managers to quantify expected growth.• Produced and presented 6 weekly, time sensitive reports directly to the department head. The reports were relied on for crucial business decisions.

Charlotte, Nc, Us

Created, implemented and maintained databases, system applications, and production queries for the identification and fulfillment of 400,000+ customers annually.• Saved $42,311 annually in reduced customer service inquiries by writing all company-wide IBM FOCUS queries. Increased target identification accuracy 38% with a resulting 33% decrease in negative customer inquiries.• Reduced average fulfillment time from 60 to 14 days by converting from monthly tables to daily DB2 tables and reengineering the fulfillment process.• Designed, created, implemented, and maintained the premium fulfillment database. A company-wide database solution encompassing all aspects of fulfillment including merchandising, warehousing, source coding, list generation, tracking, and reporting.

Charlotte, Nc, Us

Conducted critical business analysis for various departments companywide. Coded and administered complex IBM FOCUS queries for customer fulfillment or key analytical reporting. Processed lists to media (tape, disk, cartridge).• Researched and implemented encryption solution (PGP) for security of data shared with 17 vendors.• Communicated regularly with third-party vendors to resolve data-match and formatting obstacles.• Tested and documented FOCUS query logic to ensure Y2K compliance and mitigate possible detriment.

Charlotte, Nc, Us

Reported system outages, root causes, and resolutions to senior management. Determined, coordinated and communicated necessary system downtime and impacts of major business systems with the appropriate business units. • Knowledgeable liaison between the technology area, users, and management. Rotational on-call team member responsible for high-level detailed communication directly and through structured daily voicemail reports. Conducted case follow-up to ensure resolution.• Maintained constraint database and reports.• Established and implemented 5 internal audits for the area.

Charlotte, Nc, Us

Oversaw scheduling of company-wide hardware/software/application installations. Reviewed installations for possible contention and imminent negative impact. Coordinated installations to mitigate negative impact to respective business units and align with overall priorities.• Implemented database enhancements to automate and reduce processing time of system change requests.• Developed and implemented a standardized change request form for automatic entry into database.• Facilitated daily installation review meetings.