Bob G. Email & Phone Number

Indianapolis, Indiana, Us

Anthem, Inc. is an American health insurance company and the largest for-profit managed health care company in the Blue Cross and Blue Shield Association.• Develop strategic report applications and dashboards from Salesforce Marketing Cloud and Adobe Campaign Engine databases using MicroStrategy Developer 11.2 and Tableau Desktop 10.2.2.• Writing and troubleshooting complex SQL along with relational database design and development.• Provide analytic consultation to other business areas, leadership and external customers. • Convert and automate existing SQL reports utilizing MicroStrategy Developer and Report Services.• Create COVID-19 executive PowerPoint presentation employing MicroStrategy Office.

Frisco, Texas, Us

Magellan Health is a leader in managing the most complex areas of health, including special populations, complete pharmacy benefits and other specialty areas of healthcare.• Data and Integration Engineer that can write PL/SQL packages, problem solve, perform root cause analysis, trouble shoot issues and coach other developers.• Work with business and stakeholders to develop requirements and data mapping documentation.• Responsible for all data and transformation between internal and external systems at Magellan Health. Using UNIX platforms, Informatica, SnapLogic and Oracle PL/SQL packages.• Perform analysis on projects and provide a project plan that shows the tasks needing to be completed and a time estimate for each task.• Participates in design walkthroughs with appropriate focus groups and related users to verify accuracy of design in meeting business needs.

Indianapolis, Indiana, Us

Anthem, Inc. is an American health insurance company and the largest for-profit managed health care company in the Blue Cross and Blue Shield Association.• Lead data steward in Anthem’s Clinical Data Acquisition (CDA) project. Responsible for all data management including; data quality, data provisioning and data governance.• Work with electronic medical record (EMR) datasets of varying degrees of size and complexity.• Utilize TOAD, Teradata SQL Assistant 15.10 and Apache HUE in order to conduct analysis, explore trends, evaluate risks and opportunities, as well as prepare weekly/monthly reporting documents for executive presentations.• Develop specification standards for incoming clinical data sets. • Support an Agile Software Development process as co-product owner, working in conjunction with end users / stakeholders and technical delivery team to align on the vision, program backlog, and roadmap.• Create and chair the bi-weekly CDA - Data Quality Developer Forum to discuss new data acquisitions, and data quality and integrity issues with internal stakeholders.• Identify critical data elements with initiatives and create data validity metrics to measure, track and improve data quality.• Develop strategic report applications from the claims Enterprise Data Warehouse (Teradata) and Hadoop clinical data environments utilizing Tableau Desktop 10.2.2.

Charlotte, Nc, Us

SunTrust Bank’s primary businesses include deposits, lending, credit cards, as well as trust and investment services.• Support Student Lending and Portfolio Management department’s data needs. Including requirements gathering, design documentation, report development, testing and delivery in Cognos 10.2.2.• Create new and improve existing reports to support Line of Business operations.• Perform reporting transition and automation from SAS to Cognos Report Studio.• Ensure all operational and regulatory/compliance reporting is delivered timely, accurately and adhere to our SunTrust’s data governance policies.• Fully support off-shore report delivery model by creating requirements documents, performing knowledge transfer and mentoring.• Implement and promote the self-service BI model to reduce delivery costs and turnaround time.• Streamline and automate data and reporting processes to contribute to the stability of our data environment.• Manage and implement the Consumer Lending Business Intelligence Office’s (BIO) Cognos promotion process between environments.

Richmond, Va, Us

VCU is a premier urban, public research university focused on academic success.• Provide BusinessObjects reporting support for Cerner’s electronic medical record (EMR) data.• Design, develop, and implement the VCU Health System (VCUHS) Clinical Data Warehouse on Oracle 11g. • Create clinical reports utilizing Cognos Report Studio.• Perform ETL (extract, transform and load) from the Cerner Millennium EMR database to VCUHS’s data warehouse on Oracle 11g using IBM Datastage tool. • Lead meetings with researchers to gather requirements for extracting clinical data from Cerner Millennium’s EMR database.• Founding member of VCUHS’s Data Integration and Analytics Council (DIAC). Our purpose is to evaluate and prioritize incoming data requests throughout the organization.

Chantilly, Us

Provide Oracle database support for the DLA Fusion Center project at the Defense Supply Center Richmond (DSCR), the Defense Logistics Agency's aviation demand and supply chain management directorate. DSCR is the primary source of supply for more than 1.3 million repair parts and operating supply items supporting 1,300 major weapon systems.Design, develop, implement, and maintain the Fusion Center data warehouse on Oracle 10g. Create and support tables, views, synonyms, and materialized views. Extract, transform, and load multi-terabyte datasets using PL/SQL and UNIX scripts. Integrate SAP Business Warehouse into DLA Fusion Center utilizing Oracle SQL*Loader and external tables. Tune database queries using indexing, partitioning, database hints, and materialized views.Load source data for DLA’s Base Realignment and Closure (BRAC) support, provided by multiple DLA supply depots. Create Oracle tables in support of operation ‘Unified Response,’ DLA’s supply and service relief response for the January 2010 Haiti earthquake. Load flat file supply data from multiple field sources into database tables to provide a consolidated view of DLA’s ‘Unified Response.’

Dominion Resources is one of the nation's largest producers and transporters of energy.• Provide Cognos reporting support for the Enterprise Business Intelligence department of Dominion Resources. • Design, develop, implement, and maintain the Dominion Energy Clearinghouse Data Warehouse. • Create and maintain Cognos PowerPlay cubes for the Energy Supply division using Transformer.• Create and support tables, views, synonyms and materialized views in an Oracle 9i and 10g environment. • End-user support for Energy Supply and DEC business channels.• Develop, support and maintain daily, monthly, and quarterly loads to the data warehouse utilizing Cognos 8 Data Manager ETL tool.

Us

HMC is one of the nation's largest leaders in integrated care and total-population health solutions.• Provide Business Objects support for the Business Intelligence team of Health Management Corporation. • Successful migration of Business Objects software and reports from version 6.5 to XI R2. • End-user support for all business channels.• Create ad-hoc Business Objects and Crystal reports against SQL Server Data Warehouse.• Build and maintain Business Objects Universes.

Reston, Va, Us

• Provide Business Objects support for the Business Intelligence branch of the Defense Commissary Agency. • Successful migration of Business Objects software and reports from version 6.5 to XI. • End-user support for all business channels.• Create ad-hoc Business Objects reports against Teradata Enterprise Data Warehouse.• Build and maintain Business Objects Universes. • Design logical and physical data model for Retail Sales data mart.• Develop and modify subject areas in Claraview’s Retail Data Warehouse product using CA ERwin 7.2.

• Designing, developing, implementing, and maintaining the Saxon Enterprise Data Warehouse (EDW)• Creating and supporting tables, views, synonyms and materialized views in an Oracle 9i environment.• End-user support for all business channels• Support and maintenance for all daily, monthly, and quarterly loads to the data warehouse utilizing Informatica’s PowerCenter 7.1 ETL suite.• Development of BI queries, reports, dashboards, and scorecards using the Hyperion 8. 2 BI toolset• Administering the Hyperion Performance Server

• Extract customer information from SunTrust Bank’s corporate Oracle database, transform and load data into Mortgage Marketing SQL Server database utilizing MS DTS. • Gather and analyze business rules for Cross Sell department. Create Cognos 7.3 catalogs and Impromptu reports from collected business rules.• Design and create SQL Server databases in support of marketing analytical needs.• Collect, integrate and analyze data from disparate data sources in order to produce ad-hoc marketing reports.• Create and encrypt flat file extracts of current Mortgage customers for use by third party vendors.• Analyze marketing requirements and create pertinent selection criteria. Produce prospect lists to support mail campaigns. • Utilize SQL Server Agents to schedule routine DTS packages.• Import and transform internet based mortgage leads into SQL Server database utilizing MS DTS.

• Technical Lead for the design and development of VHDA’s data warehouse.• Design logical and physical data models for the data warehouse and data staging databases using PowerDesigner.• Administrator for Cognos tool suite; including Impromptu, IWR and PowerPlay.• Install and implement Cognos Series 7.3 reporting software on new server. • Create financial reports and catalogs using Cognos.• Supervise and educate Cognos developers on development standards, procedures and best practices.

Us

• Supervise a team of eight developers. As sub-task leader my duties include creating status reports (weekly, monthly and quarterly), directing weekly status meetings with client, assigning and prioritizing employee work assignments, and ensuring adherence to work plan timeline.• Informatica lead developer for the National Weather Service’s integrated data warehouse. • Design logical and physical data models for the data warehouse and data staging databases using ERwin.• Install and implement Informatica PowerCenter 6 on new server. Successful upgrade of Informatica repository from version 5.5 to 6.2.• Perform ETL (extract, transform and load) from the Commerce Administrative Management System (Oracle Financials) to NWS’s data warehouse on Oracle 9i using Informatica’s PowerCenter 6 tool. • Supervise and educate other Informatica developers on development standards, procedures and best practices.• Create financial reports and universes using Business Objects.

Redwood City, Ca, Us

• Define and propose technical architectures (including associated business and technical benefits) that meet the objectives and requirements of prospects.• Explain the benefit of Informatica’s products (including but not limited to their architecture, features, technical/business benefits, etc.) to prospects through presentations, detailed discussions, demos, etc. in order to reinforce the value proposition.• Install Informatica’s PowerCenter server and drivers on Windows 2000, AIX, HP-UX and Sun Solaris servers.• Gather end-user requirements for Proof of Concept (POC). Create target data model according to technical specifications and perform data ETL in a very short period of time. • Create data mappings to extract data from heterogeneous data sources, consolidate and transform the data, and populate various target database tables.• Ensure customer satisfaction through post-sales assistance with technical questions and issues.

Austin, Texas, Us

PeopleSoft, Inc. is a world leader in enterprise application software.• Manage the development of the Process Workbench (pre-packaged data mart), including gathering and analyzing requirements from current customers.• Develop the data model for the Process WB and used Sterling’s OLAP tool suite to create the project schema and reports in an SQL Server 7.0 environment.• Build data models for multiple PeopleSoft EPM modules; including Supply Chain Management, Retail, Work Force Rewards and Analytics.• Maintain the data model for PeopleSoft’s Enterprise Warehouse using ERwin and Visio Professional.• Understanding data source requirements in order to create meaningful sample/demo data for the Enterprise Warehouse.

Tysons Corner, Va, Us

MicroStrategy, Inc. is the leading Relational OLAP (ROLAP) software vendor within its industry. • Design and implement mission-critical decision support systems for Fortune 1000 corporations.• Install and configure MicroStrategy software and ODBC network connections on client systems.• Experience in every phase of the DSS development life cycle: project planning, requirements gathering and analysis, data model and schema design, report development, testing, database tuning, rollout and maintenance.• Upgrade client MicroStrategy software to most recent versions. • Apply expertise in data modeling and MicroStrategy products, design and develop reports.• Provide direction for client data warehouse schema. • Supply onsite troubleshooting and product support. Analyzed new report requirements and dimensional models, monitored warehouse usage, and determine project configuration. • Perform query tuning and optimization.

Us

Logic Works, Inc. is the leading provider of data modeling tools for client/server, Web and data warehousing development.• Responsible for sales of data and process modeling tools, ERwin and BPwin, and services to large commercial and DoD accounts.• Extensive contact with customers through phone calls, meetings, on-site presentations and trade shows.• Consulted potential clients on the physical and logical data models of their relational databases.

Hanover, Maryland, Us

• Marketed software and hardware professionals to senior MIS staff at client companies. • Worked with technical hiring managers to source, screen and assist in the selection of technical MIS professionals.

Education record

Bachelor Of Science (B.S.), Business, Management, Marketing, And Related Support Services