Bill Gilbert Email & Phone Number

Atlanta, Ga, Us

Atlanta, Ga, Us

San Diego, California, Us

• Collaborate with cross-functional teams to establish data mapping definitions for the integration project, facilitating a unified understanding of data across different business units.• Conduct workshops to streamline requirements gathering processes for the data migration initiative, fostering effective communication between technical and business stakeholders.• Leverage expertise in data integration to provide valuable insights and recommendations throughout the project lifecycle, ensuring alignment with organizational goals.• Implement data cleansing initiatives to address data quality issues, resulting in improved accuracy and reliability of the integrated datasets.• Spearhead data mapping definitions for acquisition data integration and migration projects, ensuring accurate and seamless transition of crucial information.• Provide standard and ad hoc reporting support to multiple business units and external stakeholders, contributing to informed decision-making.• Engage in continuous professional development, staying abreast of emerging trends and best practices in data management and IT systems analysis.• Routinely perform data segmentation, transformation, and mapping documentation, ensuring a well-structured and organized approach to data handling.• Lead requirements gathering, employing workshops on a data migration initiative, and actively sought feedback from business users to enhance project alignment with organizational needs.• Conduct thorough data analysis, identifying and addressing data quality issues, leading to the successful implementation of data cleansing initiatives.• Ensure compliance with industry standards and regulations in all aspects of data handling and migration processes.• Responsible for data mapping definitions in a data integration and migration project• Develop comprehensive business requirements documentation, to guide software development projects.

Saint Louis, Mo, Us

• Facilitated efficient development by creating wireframes for application screens and user workflow using Balsamiq, ensuring adherence to business requirements and timely project delivery.• Organized and stored wireframes, API integration details, Swagger links, and terminology definitions in Confluence, improving access to essential resources for the team.• Monitors project deliverables, milestones and required tasks and helps determine priority, scope, time frames, costs, risks and staffing requirements for projects.• Facilitate meetings to gather additional requirements, user requirements, status updates, providing clarification on requests to our support groups and occasional client surveying.• Met project needs by effectively communicating with internal and external business partners, resulting in reports that drive informed decision-making and program success.• Conduct testing on new or Modified System while communicating with Application developers on findings and corrections prior to Migration.• Streamlined automation testing processes for reengineered products, resulting in a significant decrease in testing time, accelerating product delivery and time-to-market.• Serve as primary Subject Matter Expert in multiple sub projects, resulting in 40% reduction in project errors and rework, leading to improved project quality and successful project outcomes.• Ensured the integrity and accuracy of company data across all locations and systems on a regular basis.• Provide standard and ad hoc reporting support to multiple business units and external.

Long Beach, California, Us

• Analyzed and prioritized project deliverables, milestones, and tasks, resulting in a 15% increase in project efficiency and timely completion, positively impacting overall project success.• Performed routine and ad-hoc migrations from on-premises and multiple sources like Azure to AWS• Facilitated meetings to gather additional requirements, user requirements, status updates, providing clarification on requests to our support groups and occasional client surveying.• Communicated with internal/external business partners to ensure reports include the most current information and are meeting the needs of the program.• Conducted testing on new or Modified System while communicating with Application developers on findings and corrections prior to Migration.• Acted as primary Subject Matter Expert in multiple projects.• Ensured the integrity and accuracy of company data across all locations and systems on a regular basis.• Hands-on experience with Amazon Web services (AWS) and implementing solutions using EC2, S3, and RDS in cloud formation Json templates, EBS, Elastic Load Balancer, Auto Scaling Groups, Auto scaling Launch Configuration and Auto scaling Lifecycle Hooks• Provided standard and ad hoc reporting support to multiple business units and external clients.• Drafted BRDs, intakes and Supplemental Report Read Me guides (includes Reporting Approach, Observations, and data definitions)• Supported the planning, requirements definition process, and analysis of legacy data for conversion programs and decommissioning• Analyzed and made recommendations to consistently improve business processes and technology with analysis.• Streamlined decision-making process by providing timely and accurate documents, spreadsheets, and presentations for management, resulting in improved productivity and strategic planning.•

Atlanta, Georgia , Us

Conduct testing on new or Modified System while communicating with Application developers on findings and corrections prior to Migration.• Participate in development of specifications and test plans associated with system development or modification.• Perform ad-hoc reporting as well as manipulate complex data on Oracle SQL server.• Confer with and provide support to technical group in systems development.• Validate Data during prior and after system conversion phases• Frequent testing of new or modified systems• Participate in the definition of user business requirements and monitor related application implementation• Used SQL queries to query server database for data analysis and documentation of data flow processes• Identified opportunities for process improvement by analyzing business needs and delivering improved business process/engineering through business process improvement and creating the related documentation to support the operations• Developed and maintain controls catalogs for operational business units identifying the link between our controls and regulatory and compliance requirements• Worked closely with the Integration System Test team to ensure all identified scenarios are properly tested and defects are resolved, and a quality end user product is delivered• Analyzed the impact of the proposed solution across the business and developed use cases to demonstrate the business requirements to the technical team• Utilize SISS for ETL data modeling, data migration, and analysis• Prepare high level analysis reports with Excel• Provides feedback on the quality of data including i• Gathered, analyzed, and documented Business process flow, Information flow, Business and System requirements, and Budget estimates.• Identification of billing patterns and outliers• Map data to find discrepancies in similar data in various system location• Facilitate communications between user and technical group as needed.

Responsible for the Architecture, design, normalization of SQL server database● Design and update a 150 table ERD (Entity Relationship Diagram) for the entire project.● Effectively queried total inventory and all order-related transaction history using SSMS.● Wrote SQL queries that were highly tuned using concepts like CTEs, derived tables Views and Stored Procedures.● Reviewed reports on negative inventory, adjustments, credit sales and physical daily counts for variance and make rectifications as needed.● Carried out Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler troubleshooting software.● Ran ad hoc queries in data lake to confirm if the columns contained correct Personal Identifiable Information.● Ensured the integrity and accuracy of company data across all locations and systems on a regular basis.● Utilized Excel and Tableau to validate data sent across to clients and other departments.● Analyzed and monitored the financial and operational impact of any inventory adjustments.

Us

• Involved in extensive data validation by writing several complex SQL queries and with back-end testing and data quality issues.• Routinely created and ran reports for insurance and pharmacy claims • Created dashboards utilizing tableau for claim types and authorization paths• Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.• Experience in creating various views with Tableau (Tree maps, Heat Maps, Scatter Plots).• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Subqueries and other concepts like Aggregate functions.• Performed ad-hoc reporting as well as manipulate complex data on MS SQL server.• Experienced in Data mapping, Data transformation between sources to target data models.• Involved in data extraction, transformation and loading directly from different sources systems like flat files, Excel, Oracle ad SQL server.• Experience in creating filters, quick filters, table calculations, calculated measures and parameters.• Created Views, Database Triggers, Stored procedures and functions such that information entered by a certain WM can make appropriate changes to the respective tables.

Biomedical Science

Bachelor Of Science - Bs, Management Information Systems, General