Please complete the CAPTCHA to continue
A concise factual answer block for searchers comparing this professional profile.
William Flood is listed as Solution Architect | Metrics & Performance Analytics | Optimization | Business Intelligence | Informatica | Master Data Management at Binary Bolt, LLC, based in Round Rock, Texas, United States. AeroLeads shows a matched LinkedIn profile for William Flood.
William Flood previously worked as Solutions Architect at Binary Bolt, Llc and MDM Infrastructure Administrator, Developer Lead at Charles Schwab. William Flood holds Master Of Science (Ms), Information Systems from University Of Colorado Denver.
This section adds company-level context without repeating William Flood's masked contact details.
Review company-level records connected to William Flood before choosing the right outreach path.
Over the years of working with data, I have had hands on experience with implementing many of the industry leading tools related to database management systems, Master Data Management, Data Quality, Data Warehousing, ETL, Metadata Management and Business Intelligence. I have specialized in developing and maintaining high performance solutions and applications. I have used many database tools including SQL Server, Teradata, Oracle, MongoDB and Hadoop. My Data Warehousing experience includes using the Informatica PowerCenter and Informatica Data Quality tools. As companies need for cleaner, more reliable data grew, I implemented a Master Data Management environment along with its infrastructure. As the usage of these tools grew, I continue to optimized the environment to be as efficient as possible. This resulted in faster processing time while limiting the need for license and hardware expenditures. I have implemented a number of additional tools in the business intelligence field including Enterprise Data Catalog, Data Validator Option (DVO) , Big Data Edition and Enterprise Data Lake on both Linux and Windows servers. Along with doing development, I worked to architect, implement and administrate many of these tools . If you feel my skillset could be helpful to your company, feel free to reach out to me.
Company context helps verify the profile and gives searchers a useful next step.
A career timeline built from the work history available for this profile.
Designed and developed a SQL based addons for the Informatica toolset. • Implemented SQL Server 2022 on-premise and Azure SQL Server database environments.• Implemented Azure SQL Elastic Queries, External Data Sources and External Tables.• Developed SQL Server application with JSON, Temporal Tables, Stored Procedures and Linked Servers.• Utilized Agile methodology, Jira, Confluence and Purview Data Catalog.
Austin, Texas, United States
Utilized Agile methodology, Jira, and Confluence. Administered Informatica tools, including user creation, permissions, repository settings, installs and upgrades. Developed and documented team’s standards, best practices, and processes.• Implemented SQL Server database environments with SQL Server 2019 with dedicated read-only SQL Servers.• Used advanced SQL Server features including dynamic data masking, JSON formatted SQL and data compression, which reduced data storage requirements by over 70%.• Created Master Data Management (MDM) Infrastructure, including server setup and software installation.• Trained developers on Informatica Data Quality (IDQ), PowerCenter (PC) and Data Validator Option (DVO).• Implemented MDM, Web Services, Address Validation, Identity Resolution IDQ, DVO, and Developer.• Created and managed security access for administrative tools as well as file and database access.• Analyzed and resolved a wide range of performance issues across tools, networks, and hardware.• Regularly tuned the SQL Server, IDQ and MDM tools to increase platform stability.• Helped team implement real-time Address Doctor processing in IDQ and MDM tools.• Partnered with the Global Data team to select and install a suite of data quality Informatica tools including Enterprise Data Lake, Enterprise Data Catalog, Big Data Edition, Data Quality and Data Streaming.• Created the infrastructure for the suite of Informatica tools, including servers, software, SQL Server, and Hadoop Hortonworks clusters.• Installed and configured Informatica Enterprise Data Lake, Enterprise Data Catalog, Big Data Edition.• Upgraded the Informatica IDQ and PowerCenter from 9.4 through 10.5 and MDM to 10.4.• Implemented a deployment process for IDQ code to validate and automatically deploy code.• Planned, built, and configured disaster tolerant servers across multiple data centers.• Implemented Git versioning in the IDQ tool to track code changes.
Denver, Co
Led and trained new and experienced developers. Utilized advanced Teradata features including temporal tables, columnar tables, and stored procedures. Leveraged MongoDB and other data sources, like SQL Server, Oracle, and Salesforce. Resolved technical issues and errors with Informatica Technical Support.• Developed Informatica PowerCenter ETL to load data into a Teradata data warehouse from multiple sources.• Streamlined code development times and quality through a custom code generation tool.• Performed code reviews and developed object queries to find coding standard violations.• Implemented PowerCenter versioning and deployment groups to control changes and code deployments.• Setup and implemented TFS for versioning and deployment of all Unix parameter and script files.• Trained and worked with the PowerCenter Administrators to add new features, tune, and troubleshoot issues.• Led the administration team in the PowerCenter 9.5 and 10.0 upgrades, each with new servers and databases.• Architected Schwab’s only shared Informatica instance while reducing the overall cost of ownership.
Denver, Colorado, United States
Led and trained developers in an Agile environment. Administered Informatica PowerCenter, including user creation, permission, repository settings, installs and upgrades.• Developed Informatica ETL to load data into an Oracle data warehouse from multiple sources.• Worked with Informatica Web Services, Informatica Data Quality (IDQ) and Data Validator Option (DVO).• Developed and documented standards, best practices, and processes for the team to follow.• Implemented versioning and deployment groups to capture change history and perform code deployments.
Englewood, Colorado, United States
Led and trained a group of onshore and offshore Informatica PowerCenter ETL developers. Developed PowerCenter ETL code and administered PowerCenter environment for the group.• Rewrote Data Warehouse to use best practices and streamlined design against Oracle E-Business Suite 11.5.
Englewood, Colorado, United States
Administrated SQL Server 2000 and wrote advanced SQL, scripts, and procedures. Wrote Informatica PowerCenter ETL for the processing of weekly data warehouse loads. Installed, upgraded, and administered PowerCenter 6.2 and 7.1.
Lakewood, Colorado, United States
Administrated SQL Server 2000 which included upgrades and installations.
Quick answers generated from the profile data available on this page.
William Flood works for Binary Bolt, LLC.
William Flood is listed as Solution Architect | Metrics & Performance Analytics | Optimization | Business Intelligence | Informatica | Master Data Management at Binary Bolt, LLC.
William Flood is based in Round Rock, Texas, United States while working with Binary Bolt, LLC.
William Flood has worked for Binary Bolt, Llc, Charles Schwab, Squaretwo Financial, Arrow Electronics, and Chi.
You can use AeroLeads to view verified contact signals for William Flood at Binary Bolt, LLC, including work email, phone, and LinkedIn data when available.
William Flood holds Master Of Science (Ms), Information Systems from University Of Colorado Denver.
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial Search contactsCheck these profiles if this is not the William Flood you were looking for.
