Robert Blalock Email & Phone Number

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.

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.
• 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.

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.
• 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.
• 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.
• 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.

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..
• 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.

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.
• 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.

• 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.
• 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.

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.
• 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.
• 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.

• 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.
• 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.