JWilliams & Associates was founded on a passion for technology and a commitment to exceeding client expectations. We have consistently delivered cutting-edge software solutions that have propelled businesses to new heights of success.Our team of skilled developers, designers, and project managers work in harmony to bring to life bespoke software applications that not only meet but exceed client requirements. What sets us apart is our unwavering dedication to quality, innovation, and customer satisfaction. We approach each project with a fresh perspective, taking the time to truly understand the client's vision and objectives before crafting a customized solution that aligns perfectly with their goals.

* On Board with New Cleveland Startup as Technical AdvisorConsultant (interim Director) for startup company that was to provide consumer / crowd sourcing for restaurant delivery services; competing with incumbent providers like Grubb Hub and Uber Eats on a regional basis.

operation, merger and acquisition financial review, process management, vendor and contract management; automated process design and development. Work closely with vendors on projects that involve process automation. Architect and develop Web services in MS SQL. Develop automated workflow processes through sql development and web api integration.Architect, deployment manage technology solutions for properties such as subscriber based WIFI services; automated tenant management and billing.SQL ETL Development with Vendor data sync.

I reach out to children and young adults that may not otherwise have exposure to the challenging and mentally stimulating skills of SQL Development

3 month contract. Performance tune, re-write. .Net calls into stores procedures, create audit system in SQL.

I am a volunteer category supervisor and subject matter expert for Database related questions presented by the public. I am responsible for answering questions time permitting as well as auditing and subsequently permitting the publishing of answers given by the community.

Developed complex online store product search that partitioned and priced each product distinctly by Client profile / program type as well as vendor and participation organization rules; in real time against millions of products with grouping, ranking; and historical purchase weight. Automated various back-office systems cutting manual workload for 3 staff members by nearly 10%

● Responsible for the architecture of databases that manage fingerprint profile data.● Architecture, Design and development of systems in a manner consistent with the specifications in the IAFIS certification guidelines.● Design and implement a secure/encrypted dataset of fingerprint data in ISO/IEC 19794-5 format.● Current maintain existing databases, provide code enhancements, custom design and development for specialized projects.March 2016 - transition into advisory role

2 Week on-site contract. Advising on architecture / Review and modify - correct SQL code where needed. AS400 to x86 based network conversion* On_Site Wrap up 4/27/2017 Remote through 5/3/2017Very much enjoyed working with the entire team. Great experience and amazing new friends.

SQL Development / ETL / Data Architect, DBAApril - June 2015 (90 Day Contract)June - August 2015 ExtensionAugust - November 2015 ExtensionNovember - January 2015/2016 - ExtensionJanuary - March - 2016 ExtensionMarch - May 2016 ExtensionJune - August 2016 extensionSept - November 2016 ExtensionNov 2016 - March 2017 * Final Extension - Available for work march 13 2017

As of April 2015 - Contract complete - Maintaining Part-Time presenceProjected Project Completion: January 2015 (EOM)Responsible for Customer solution architecture with development team as well as MS SQl Architecture and development.Assist in overall SQL Architecture as well as provide all SQL Development for client side access as well as SQL based business logic; auditing, security, and data-access to include PCI and HIPPA compliance.End Client: NDA• Design and code Billing and processing capabilities to facilitate the invoicing of CER, Health And Welfare, and Pension dues for both Employer Contribution as well as Participant Contributions• Design and develop payment processing module as well as invoice computation• Compute Vesting pension credits as well as COBRA eligibility, billing and collection.• Create accounting / billing related jobs for scheduled tasks.• Create InvoiceLedger, EmployerLedger, Aging tables and associated logic to facilitate the population and maintenance of this data.• Implement encryption of personally identifiable data.

Assisted in asset selection, back-office architecture and and management of development efforts.

Houston * PasadenaSenior Solutions Architect.Database design / development / Data Analytic / Big-Data optimization

Data Linguistics / Data validation modeling / Data mining algorithms / Behavior data mapping

Contract with Baker as SQL DBA Firmwide. Provided support to a large MS SQL implementation to include both DBA management and SQL Development responsibilities.90 Day initial contract with extensions

Implementation and customization of wholesale client billing and ERP solution.

Designed and developed Automated Address change interface between mail processing center and the United States Post Office. The solution will automatically update change of address data provided to the post office for clients of the processor.

Full service IT consulting, systems and software implementation, custom solutions.

Customer Software development, IT Consulting,

Redesign architected existing Database schema, wrote complex SQL code for billing engine, and architected and developed custom functionality for new and existing clients.

I serve as chief technical expert and resource to the executive management and department heads; provide technical expertise in the emergence and problems related to technology integration. I Assist and work with systems developers to integrate architecture and implement new systems; develop and recommend related technical policies and procedures; maintain current knowledge of technology advancements and system enhancements; and ensures business processes provide effective data integrity and efficient systems operations.

Architected, SQL developed and application Project managed the first E-911 solution for VoIP providers. Provided architecture and project management for ongoing IT projects to include wholesale and retail billing engines, mediation engine; customer self care portals, and back-office / infrastructure support systems.I serve as chief technical expert and resource to the executive management and department heads; provide technical expertise in the emergence and problems related to technology integration. I Assist and work with systems developers to integrate architecture and implement new systems; develop and recommend related technical policies and procedures; maintain current knowledge of technology advancements and system enhancements; and ensures business processes provide effective data integrity and efficient systems operations.

Largest private ISP in N.E. Ohio. ** Named Crains Cleveland Business Top 40 under 40 Entrepreneurs Started as a hobby Now Online enjoyed rapid organic growth through 1998 when it began acquiring surrounding competitors. With nearly 2.5 million dollars spent on acquisitions Now Online was sold to a Cleveland based investment trio for nearly 10 million dollars in closing and deferred cash.Key Accomplishments:1. Over the course of 7 years took the company from pre-revenue to over 10 million annually.2. Responsible for hiring and management of nearly 70 employees.3. Established Market dominance in N.E. Ohio4. Provided internet access Nationally with a owned facilities reaching 70% of the Midwest.5. Established key accounts to include: Epic Games; Raleigh North Carolina Cleveland Police Department FBI - Cleveland Field Office Peterson Nut Company - Cleveland Ohio KEY Bank N.A. Jones Day - Cleveland Headquarters City of Cleveland Municipal City of Cleveland Schools Geauga County Municipal Cleveland State University ... More than 1,000 additional businesses and nearly 25,000 residential customers.Sold November 2001