Robert Blalock Email & Phone Number

Jacksonville, Fl, Us

Jacksonville, Fl, Us

Jacksonville, Florida, Us

Supported new and current business analysis efforts in the organization including requirements gathering for enterprise application development in an Azure/MS Office 365 environment. • Developed multiple artifacts including flow charts, cross functional diagrams, data mapping documents, screen mock-ups.• Gathered and documented the business requirements for application development and process improvement initiatives.• Instrumental in identifying Initiatives, Epics, Features and User Stories from Azure DevOps to bring structure to development backlog in an Agile/Scrum environment.• Identified and defined Epics, Features and User Stories from requirements and entered into Azure DevOps including details and acceptance criteria for each.• Led weekly meetings for business process automation and Power BI reporting initiatives.

Dallas, Tx, Us

Supported new and current reporting and data analysis efforts in the organization including support for Construction and Engineering operations in MS Office 365 environment. • Developed multiple BI artifacts including mapping documents, views, SQL scripts and Stored Procedures for data analysis, ETL, and reporting from SQL Server, Azure, Business Objects and web interfaces. • Mapped data interaction between multiple sources.• Developed extensive VBA for Excel data refresh and data manipulation• Provided data analysis and reporting for construction and engineering evolutions including personnel quality inspections, training compliance, project management and billing. • Provided support for multiple construction and engineering markets as well as assisted PMO group with reporting projects.

Supported new and current application and analysis efforts in the organization including support for applications and interfaces for Crowley Maritime and Acosta Marketing. • Developed technical Visio diagrams for existing architecture and processes.• Developed multiple BI artifacts including mapping documents, views and SQL scripts for data analysis, ETL, and reporting from SQL Server, Oracle and AWS data sources.• Migrated SSIS packages from SQL Server 2008 to SQL Server 2019 including testing and validation after migration.• Gathered and documented the business requirements for BI, ETL and Process Improvement initiatives.• Documented and mapped interaction (source-to-target mapping) between multiple data sources.• Day to day support for marine ERP application and external interfaces.

Dallas, Texas, Us

Supported new and current reporting and analysis efforts within the core business functions including loan servicing and reporting. Developed multiple BI artifacts including tables, views, stored procedures and SQL scripts for data analysis, ETL, and reporting from SQL Server. • Developed Business Intelligence reports, dashboards, pivot tables and associated tools for statistical analysis and metrics reporting including stored procedure development using MS BI Studio (SSIS) and SSMS in a SQL Server 2012 Environment

Boca Raton, Florida, Us

As member of Business Operations Department, supported multiple concurrent projects and initiatives ranging in size, scope and complexity within the core business functions including security system marketing, sales and servicing. Developed multiple project artifacts including requirements, data model and complex queries for data analysis, ETL, and QA/testing from a variety of sources including Oracle, SQL Server, AS/400 and flat files. • Gathered and documented the business requirements for BI, ETL and Process Improvement initiatives.• Provided input to business data definition and design in Conceptual, Logical and/or Dimensional Model to support business automation.• Documented and mapped interaction (source-to-target mapping) between business processes and data.• Developed Business Intelligence reports, dashboards, pivot tables and associated tools for statistical analysis and metrics reporting including stored procedure development using MS BI Studio (SSIS) and SSMS in a SQL Server 2008 R2 Environment. • Developed, implemented, and supported methodologies, standards, and tools for data management including data mining, modeling, cleansing, transformation and matching, quality, integration, and security.

Jacksonville, Fl, Us

As member of Empower Technical Analysis Team, supported multiple concurrent initiatives ranging in size and complexity within the core business functions surrounding mortgage originations. Developed multiple project artifacts including functional design specification, screen mockups, and data mappings for .Net based mortgage origination application.• Researched and documented complex application relationships that describe and support complex business problems and business rules.• Provided input to business definition and design in Conceptual, Logical and/or Functional Model to support process automation.• Documented and mapped interaction between business processes and data.

Works closely with the business and other Information Technology (IT) teams to analyze, develop, implement, and support the data in our systems.• Gather, analyze, and document the data requirements for projects of medium to high complexity and moderate to high risk. • Research, develop and document complex data relationships that describe and support complex business problems and business rules.• Create and manage logical and physical data models for projects of medium to high complexity and moderate to high risk. • Provide or contribute to business data definition and design in Conceptual Data Model, Logical Data Model and and/or Dimensional Model to support business automation projects.• Document and map interaction (source-to-target, source-to-ETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high risk. • Develop, implement, and support methodologies, standards, and tools for data management such as metadata management, data mining, data modeling, data cleansing, transformation and matching, data stewardship, data quality, data integration, data security, and data marts. • Provide input to the design of applications, interfaces and systems to ensure data access, integration, integrity, and security for projects which are of medium to high complexity and moderate to high risk.

Deerfield Beach, Florida, Us

As member of Project Management Office, supported ongoing operations and initiatives within the core business functions. Provided support for multiple concurrent projects ranging in size, scope and complexity. Developed multiple project artifacts including complex queries for data extraction, and business intelligence from a variety of sources including Oracle, SQL Server, DB2, VSAM and flat files. • Facilitated requirements gathering for a variety of business IT initiatives including working with internal and external clients.• Served as liaison between business units and internal and external development teams.• Worked closely with management, data architects, and development to ensure solution compliance with IT standards and data governance rules.• Developed complex SQL scripts and data mapping documents to be used by developers in Cognos reports, Informatica ETL jobs and datawarehouse updates/loads.• Served as a primary data tester for staging layer of Integration Repository including writing queries for load validation and assisting other analysts with testing activities.• Created mapping documents and test scripts for the creation and testing of annual financial statement.• Utilized technical skills to automate multiple business tasks including improving accuracy and saving hundreds of man-hours normally expended in the creation of documents and analysis exhibits.• Prioritized work and met deadlines while delivering high-quality outcomes.• Worked with sales oriented business owners and VP’s to communicate analysis findings.• Communicated answers and solutions to all business and technical questions. Most of these conversations were based around giving functional / technical answers to non-technical business owners in a way they can understand.

Ambler, Pa, Us

SQL development, MS Analysis Services cube development, MS Reporting Services report development, requirements gathering and business/financial reporting in a desktop and SharePoint environment.• Developed Business Intelligence reports, dashboards, pivot tables and associated tools for statistical analysis and metrics reporting including multi-dimensional cube development with SSIS, SSRS and SSAS• Mapped and automated business and financial processes including requirements gathering, data modeling and extensive use of SQL for data analysis and report development on data from SQL Server.• Developed EDI processes for transfer of data between various systems and entities internal and external as well as different formats.• Developed MS access database which joined multiple SQL tables and data sources into a user friendly interface for determining collection account status and activity.• Developed multiple Excel pivot tables for data analysis and reporting which utilized SSAS cubes and SQL tables as data sources.

SQL Server database administration and development, Hyperion Cube and Report development, MS Analysis Services cube development, MS Reporting Services report development, requirements gathering, business process analysis and re-engineering, and business/financial reporting in a SharePoint environment.• Developed a multitude of SSRS reports and charts from various data sources. • Migrated existing static mainframe reports to dynamic SSRS reports.• Extensive T-SQL development to process data from multiple sources into datawarehouse using SQL Query Analyzer, SSIS, DTS, and Stored Procedures.• Migrated existing static reports to multidimensional SSAS Analysis cubes including cube and T-SQL development and development of MDX calculated dimensions.• Developed EDI processes for transfer of data between various systems and entities internal and external as well as different formats.• Mapped and diagramed business processes through interviews of operations and management personnel for process improvement and automation efforts utilizing Visio and Excel for process and data mapping.• Gathered requirements and designed applications for migration of processes from mainframe to client/server and web interfaces.• Facilitated multiple user training sessions for SSAS Cubes, Hyperion Analyzer, MS Access, and Excel.• Developed MS Access applications, Excel spreadsheets and PowerPoint presentations including extensive use of VBA for process automation, Excel data cube and pivot table development and custom graphics work for reports and presentations.

Clients included: Agency for Workforce Innovation (State of Florida), Citigroup, Dell, ABN-AMRO, Blackford Group Insurance, Loretto Elementary, UBS, NFCCJPerformed requirements gathering, business process analysis and reengineering, and business/financial reporting for several process implementation and application development projects.• Gathered requirements and designed enterprise CRM application through interviews of managers and business operations personnel to determine current business processes and identify data elements required.• Facilitated multiple user requirements gathering and business review, and Use Case analysis sessions.• Developed and provided input for project documentation using MS Project, Primavera, MS Office and client proprietary tools.• Developed group/role based security model for applications using business process flows and business rules.• Analyzed data and developed Legal Spend reporting application which imported legal matter and invoice data from multiple sources, performed data translations, and produced on-demand reports for legal business users which resulted in 20 man-hours per month saved in process time.• Analyzed and migrated data between old and new donor database systems for Non-Profit organization including the development of multi-table SQL queries for data transformation and restructuring.• Performed feasibility study and analysis of corporate business processes and workflows to determine areas of improvement and restructuring; utilized PowerPoint, Excel, Word, and Visio for reporting of results to corporate executives.• Managed the complete overhaul of a school website (www.lorettoelementary.org) - interviewed school staff for requirements gathering to determine content and layout.

Us

Developed SAP financial and business reports automation processes; involved in all phases of the Software Development Life Cycle (SDLC) from concept phase through initiation, requirements gathering, analysis, design, documentation, testing, training, and project closure phases. Discovered and repaired major issue ($12MM error) with a treasury reporting process.• Developed OLAP/EDI application which extracted data from multiple company sources, transmuted and realigned data, and exported data for upload to corporate data warehouse; accomplished using Excel, VBA, SAP/BW queries and complex formulas. • Developed and implemented roles based security model for applications using application logon process as well as system logon security inheritance.• Analyzed processes and developed mortgage collections team performance reporting application; cross platform development with Client/Server and AS/400 development teams.• Gathered business requirements through interviews of management, supervisors, and business partners as well as reviewing existing processes.• Utilized analytical and SDLC skills to develop and automate SAP financial report processes including budget, forecast, strategic plan, balance sheet, and treasury in Six Sigma environment.• Tested systems/applications using mirrored production data including the use of test cases, multiple pass/fail checks, and parallel UAT testing prior to project acceptance.• Worked with management to ensure applications/reports were Sarbanes-Oxley compliant.• Performed data mapping, extraction, and export between data warehouses using EDI/ETL/SQL skills.• Built complex formulas; developed macros and VBA for the manipulation of financial data in Excel.• Developed application training materials complete with flowcharts and screenshots.

Clients included: Shands Jacksonville Healthcare; Citibank; Kennedy Space Center; Duval County Schools; MediaOne Financial Group; Unisys Corporation; Merrill Lynch; Naval Air Station Jacksonville. Managed multiple simultaneous projects through SDLC methodologies to consistently meet customer timelines requirements and budgetary constraints in JAD/JAR environments. Projects included HIPAA security regulations compliance implementation, process reengineering, cash control reporting, hardware/software rollouts. NASA – revamped SQL coding for complex report which reduced processing time by 75% as well as adding QA logic to process to automatically report errors.• Analyzed, developed, and automated HIPAA and healthcare business processes; HIPAA security certified.• Defined project parameters, assessed client goals and objectives, established milestones, gathered requirements and managed project deliverables on a variety of business/financial projects.• Utilized Visio to map business processes, workflows, technical processes, and data modeling including updates to corporate process library.• Conducted IT process and system compliance reviews/audits against Corporate and government standards.• Utilized Customer Contact Management processes to ensure the best overall experience and quality service was conveyed to customers and business partners.• Documented and provided input to business process documents, Scope documents, requirements, project plans, SLA’s, Use Cases, RFPs/proposals, and project issues using MS Word, Visio, PowerPoint, MS Project and Excel.• Conducted application training including the development of training materials and guides.• Provided project estimates including development time, man hours, and phase completion dates based on established client standards and manpower.• Acted as liaison between business and development on complex projects.• Performed statistical analysis and metrics reporting including development of associated tools.