Data Architect Analyst

Johnson Daniel

*******-*-******@*******.*** 214-***-**** Allen, TX LinkedIn

PROFILE

An experienced business intelligence developer with a demonstrated history of working in the financial services industry and skilled in Financial Databases, Agile Methodologies, Team Leadership, SQL, and T-SQL. A strong information technology professional with a Bachelor of Business Administration focused in Management Information Systems from Texas A&M University-Commerce.

EDUCATION

Bachelors in Business Administration, Management Information Systems SKILLS

Agile Methodologies SCRUM Team Leadership

Coordinated

Administration

Microsoft SQL

Server

Microsoft SSIS

Documentation Mentorship

Programming

API

System Data warehouse Data modeling Data Mapping

BI Developer SQL Transact-SQL

Microsoft SSRS Visual Studio SQL tuning

Oracle Cloud PL/SQL Scripting

Oracle

Transact-SQL

Debugging

Scripting

PROFESSIONAL EXPERIENCE

Data Analyst

USAA by Apex Systems - Remote

10/2021 – 05/2022

•Create T-SQL queries to map Hadoop business activity to documenting customer activity and functionality between Cross Channel Customer Interactions (C3i) and the MAAC database to Snowflake Data Lake.

•Utilizing Cognition Pro for Hadoop, Squirrel SQL Client, and Box applications to code in HiveQL to maintain big data.

•Inquire Kafka Topic database on validating C3i Business Activity.

•Operate Control-M to check Daily Monitor of Data Processing jobs and logs for C3i and MAAC batch tasks events. SQL Developer

Country Place Mortgage by Robert Half Technologies - Addison, TX 10/2018 – 02/2021

•Administrate multi-mortgage systems operations for accuracy and performance. Develop procedure specifications and validate program accuracy by preparing unit test plans/scenarios and evaluating results against plans.

•Plan work unit packages which include source code, documentation, unit test data/plans, debugging, and evaluating test results against expected results.

•Implement resource guide, instruct, and monitor team members in coding techniques, technical and user procedures, and established standards.

•Expertise in SSIS, SSRS, T-SQL, PL/SQL, PowerShell, DOS script, and API scripts on SQL Server 2018 and 2019 Oracle, and VM/Oracle Cloud projects.

•Automation, DR Plan, coordinating SQL Agent job schedule cross-platform.

•Evolve new and existing programs that reflected changes in systems performance. Design Team Lead

Bank of America GIS by Randstad Technologies - Frisco, TX 06/2017 – 01/2018

•Developed a capacity planner database to increase efficiency on reporting by 30% on evaluation metrics.

•Transformed LLD & HLD requirements documentation of CPU, memory, and disk requirements. Designed technical evaluation for Splunk (30 servers), Hadoop, and MapReduce expansion projects. Coordinated management through the research of server performance improvement and planning. Senior Technical Consultant

Concerto Cloud Services by DXC Technology - Remote 03/2016 – 07/2016

•Administrate and manage multiple VM database instances on a private cloud environment. Utilize performance tuning, optimization, and maintenance for the client's database and SQL Server 2005, 2008, 2012, 2014

•Monitor database server operations using Spotlight, logs, and Windows Management tools. Database Administrator

Dallas Fort Worth Hospital Council by DXC Technology - Irving, TX 06/2015 – 01/2016

•Head reconstruction of SQL Server 2008-2014 for relocation to a new facility.

•Implement DR plan before financial database failure that results in a full recovery of a database. Direct optimization initiative to use performance tuning and page life expectancy (PLE) for all production

•servers.

•Perform system maintenance regimen to scrub database of outdated configurations and code.

•Strengthen development procedures, triggers, SSIS, Index, and ad hoc T-SQL for SQL support. Monitor server using Fog Light and Power Designer for data architecture. Process Analyst

Bank of America - HomeLoan by Apex Systems - Plano, TX 08/2014 – 11/2014

•Led development of migration of SQL Server and other databases to new platform and database.

•Utilized Power Designer for Data Modeling and Data Architect for standardization and documentation.

•Designed end to end conceptual and logical data models of databases and tables.

•Created SQL Server 2005, 2008, 2012, SSIS and ETL package for production systems migration (Agile/ Scrum).

•Identify and construct complex SSIS, T-SQL, PL-SQL, and stored procedures.

•Evaluate AWS network and storage platform for cost and feasibility.

•Developed data warehouse design in Sybase Power Designer for data architecture. BI DBA II

RealPage by The Intersect Group - Carrollton, TX

09/2013 – 02/2014

•Create customized reports using SSRS for SQL Server 2005, 2008, 2012.

•Backup/Restore database for offsite customization of client database.

•Perform tuning and optimizing reports using query analyzer/T-SQL to increase retrieval performance. Coordinate with teammates to construct and deploy a schedule of reports. BI Developer

Alkami Technologies by Robert Half Technologies - Plano, TX 04/2013 – 05/2013

•Develop SQL Server 2008 SSRS reports for management, operations, and security. Work in Agile/Scrum methodology to update existing reports for additional functionality. Generate Web-Hosting scripts and migrations for multiple IIS servers.

•Coordinate with team members for deployment on SQL Agent schedule. SSRS Reporting Analyst

ZeOmega Inc. - Plano, TX

12/2010 – 02/2013

•Employ Microsoft SQL Server 2000 and 2005, Oracle for data identification, extract data and support diverse client schema to create system-based reporting.

•Determine the capability schema of creating medical, financial, performance, and quality control base reports using SSRS.

•Coordinate with the team on AWS, Teradata, and SunGuard Cloud Virtual Report Server. Apply hybrid connectivity and networking landscape for the clients onboarding to AWS. Design JIVA database to use Star schema and Snowflake schema on UDS product.

Contact this candidate