Robert Williams Email & Phone Number

Indianapolis, Indiana, Us

Design, develop, and maintain data pipelines to pull and integrate data from diverse sources into a unified database.Write efficient SQL, Teradata SQL, SnowSQL, and SAS code for data extraction, transformation, and loading (ETL) processes.Work closely with data architects and analysts to design and implement data models that support analytics and reporting needs.Create and maintain documentation for data integration processes, ensuring knowledge transfer and supportability.Develop very complex and varied strategic report applications from a Data Warehouse.Establish and communicate common goal and direction for team.Establish and maintain advanced knowledge of data warehouse database design, data definitions, system capabilities, and data integrity issues.Act as a source of direction, training and guidance for less experienced staff.Monitor project schedules and costs for own and other projects.Develop and support very complex Data Warehouse-related applications for business areas requiring design and implementation of database tables.Conduct trainings on use of applications developed.Communicate effectively with multiple levels within the organization

Westlake, Oh, Us

Achievements Implemented over 250+ clients to our system Migrated outdated vb6 code to C# Implemented source control (Microsoft Azure) Implemented a new automation system (Active Batch) Implemented a new ticketing system (Microsoft TFS) Traveled to India twice to train the offshore team Responsibilities Writing complex stored procedures for ETL processes Build client imports & exports to run on our .Net Framework through automation. Creating client DB’s for new clients & making sure they have all the standard tables, Stored procedures, views, and indexes. Database optimization to make sure client imports and exports are running in a timely manner. Manage the offshore team & provide technical oversight Act as a technical liaison for Our business analyst & project managers on team projects Using ETL processes to send client export reports based on their needs and uploading them to their FTP Using Azure Dev Ops for reporting, version control, & Project management Using SDLC To implement any changes for our established clients Provide Code Review (C#, SQL, VB6) for our team and give feedback on changes that need to be made. Deploying code development changes to QA & production environments Ensure QA environments are in sync with production Provide accurate estimates on project deadlines Execute unit & integration tests on code development Working directly with clients as a form of communication when roadblocks are met between departments Use innovative problem solving and critical thinking approaches to trouble shoot challenging data problems Manage all IT aspects from start to finish for Implementing new clients Using SSMS to Research client data related issues Writing complex stored procedures for balancing medical claims on client imports

Westlake, Oh, Us

Oversee the Implementation offshore team to coordinate what they are working on & answer any questions or concerns they have about there workManage all IT aspects for Implementing new clientsVerify code review changes for productionConverting code from VB6 to C#Using SQL 60% of the day to validate dataCreating & Modifying Stored Procedures to meet customer needsUsing Joins in SQL to cross reference data and validateUsing Crystal report for our EOB’s & EPP’s using SQL to populate data on the reports.Deploy code changes to productionData Validation for initial Go-Live'sDatabase Validation to be sure new client Databases are current with productionClient Enhancements after Go-LiveProvide full life cycle support for code changes in the production environment and development of new extensions to existing platform. Use innovative problem solving and critical thinking approaches to trouble shoot challenging data problems.Analyze business requirements and scope of programming tasks.Provide on call support during Night time production processesMaintain a high proficiency level with system architectures and database system models.Contribute to a nimble and responsive application development organization.Responsible for coordination of IT implementations for new clientsWorking with our off shore team to coordinate implementations

Strongsville, Oh, Us

Working on the E-Comm IT team to improve sites Using C# & MVC 2Using Integration Systems to make sure processes are running smoothlyTesting Production builds for errorsKeep track of Server Drive Memory using ExcelUsing Google Analytic to check Site Traffic & conversion rateCheck cache status of Consumer Crafts & Darice automatic resetUsing Integration Systems and Stored Procedures to update the pricing table.Manually reset the application pool in IIS 7 on production servers for the application poolUsing the Event Viewer to check for errors outside of the normDevelop some Sql scripts to help breakdown the log entries and making a spreadsheet log which will be used to see trends and outliers on performance.Manually compress and label all the log files and delete all the old files not in use in IIS 7Keeping track of the Bandwith Updating current Promotion

New York, Ny, Us

-Interface with internal clients and managers to gather requirements-Develop process design to meet business needs-Analyze and interpret specifications-Develop web-based applications, including user interface functionality-Work as part of challenging and fun team environment

Overland Park, Kansas, Us

Sells company products and services to walk-in customers in retail outletsProvide a high level of customer service support with product expertise and advanced selling skillsGuide customer through the purchasing decision and activations process, and educates the customer on their new purchasedevelop new customer prospects or referrals and builds customer relationships to drive salesAchieves sales goals and service performance requirements through new customer sales, sales of accessories and features, and by providing excellent customer satisfaction

Akron, Oh, Us

Scanning blueprints and writing up proposals for CAD users to implement these blueprintstroubleshooting modems and rebuilding themworking with clients and serversRunning a real e-state business

Bellevue, Wa, Us

Build customer confidence of customers by making the store experience interactive, engaging and reassuring.Maximize customer experience by solving the whole problem as opposed to pushing products.Maintain the visual appeal of my store.Make the most effective use of store displays and interactive devices for each of your customersUse my time well, even when not serving customers.Keep abreast of the rapidly evolving T-Mobile technology.Develop positive customer relationships.Sold most business leads for corporations within my region.Sales Lead as a blackberry Representative