• Advise leadership to develop or influence analytical strategies for complex business and technical needs• Lead in resolving complex and unique challenges requiring analytical application of industry techniques using data from multiple sources• Deliver solutions for large-scale projects that require vision, creativity, innovation, advanced analytical, and coordination of highly complex activities• Ensure solutions are designed and created according to business requirements, published processes, and procedures• Complete risk-mitigating activities including: code testing, peer review, consolidation of similar recurring processes• Prepares documentation for reviewers, partners, and regulatory agents• Work in partnership with other senior members of the team to drive change and mentor/develop other team members that have diverse skillsets and backgrounds. • Engage with peers, managers, compliance, and serve as an expert advisor to leadership team• Ability to grasp complex business issues quickly, recommend solutions, and drive for resolution

Prepared test datasets for development, testing, and staging. Created SQL statements, stored procedures and data extraction processes. Built Python applications to perform ETL and calculation tasks for business users. Created SSIS packages to process large amounts of data. Managed TFS and Git software repositories for several teams. Evaluated and Standardized data processing.

Develop and maintain new or existing database applications and systems. Create requirements, scope and estimates for database projects. Develop and support SSIS packages as well as convert DTS to SSIS packages. Write and maintain documentation on databases and processes. Prepare test datasets for development, testing and staging. Performance tune queries and tables via index optimization. Create SQL statements, stored procedures and data extraction processes. Monitor Database backups and implement database security.

Develop and maintain new or existing database applications and systems. Create requirements, scope and estimates for database projects. Develop and support SSIS packages as well as convert DTS to SSIS packages. Write and maintain documentation on databases and processes. Prepare test data sets for development, testing and staging. Performance tune queries and tables via index optimization. Create SQL statements, stored procedures and data extraction processes. Monitor Database backups and implement database security.

Develop and maintain new or existing database applications and systems. Create requirements, scope and estimates for database projects. Develop and support SSIS packages as well as convert DTS to SSIS packages. Write and maintain documentation on databases and processes. Prepare test data sets for development, testing and staging. Performance tune queries and tables via index optimization. Create SQL statements, stored procedures and data extraction processes. Monitor Database backups and implement database security.

Develop and maintain new or existing database applications and systems. Create requirements, scope and estimates for database projects. Develop and support SSIS packages as well as convert DTS to SSIS packages. Write and maintain documentation on databases and processes. Prepare test data sets for development, testing and staging. Performance tune queries and tables via index optimization. Create SQL statements, stored procedures and data extraction processes. Monitor Database backups and implement database security.

Performs troubleshooting duties on semi-routine hardware, software, and data network problems for individual users. Installs, repairs, and provides preventive maintenance of personal computer and related systems. Performs hardware and software moves, adds, and changes. May provide training to users on hardware and software applications. Test and document hardware and software changes. Troubleshooting software issues and identifying the difference between trouble tickets and training needs. Answering incoming phone calls from sales force about proprietary systems.

Performed troubleshooting duties on semi-routine hardware, software, and data network problems for individual users. Installs, repairs, and provides preventive maintenance of personal computer and related systems. This person performs hardware and software moves, adds, and changes. Additionally, William provided training to users on various hardware and software applications.

Drafted high level testing documentation; Created detailed test scripts based on requirements; Executed test scripts in both GUI and backend systems; Documented defects in HP Quality Center; Discussed data needs and defect resolution

Reviewed and tested software prior to releasing to the public; Performed, Installed and configured software; Provided expert-level input and entering all suggestions and incidents into a ticket system; Reported any bugs and needed changes to management; Worked with Compuware's TestPartner to setup automated testing.

Responded to broadband internet service related phone calls; Assisted current and future broadband customers by answering questions related to service; Troubleshot broadband customers with service-related issues including hardware, software configuration and hardware malfunctions.