SUMMARY

• Developed highly technical documentation to document complex business rules and data cleansing techniques. Documentation included customer analysis requirements and groupings of data set elements required to output teh desired answers to business questions.
• Assumed teh role of lead architect for multiple subject areas to include teh data model design of several data sources and subsequent implementation.
• Performed unit testing to validate accuracy and validity of reports throughout several subject areas.
• Translated business needs and requirements into data analytic and reporting solutions to deliver meaningful information to end users across several agencies. Additionally, designed, tested, and implemented BI solutions, including dashboards, drill down/through - paths, and reports in Confidential Business Intelligence Enterprise Edition (OBIEE).
• Extensively developed teh Confidential BI repository (RPD file) metadata to establish teh web catalog for use by all customers within teh customer organization using Confidential BI Administration Tool. Work included establishing business logic to be used by each report and intensive data manipulation to sustain repeated queries by multiple end users.
• Participated in daily Agile stand-up meetings, monthly planning sessions, sprint reviews, and retrospective sessions.
• Designed and implemented several Extract Transfer and Load (ETL) systems using SSIS, T-SQL and stored procedures required to support a SQL Server data warehouse and was responsible for ensuring its data integrity from stage environment to information mart.

TECHNICAL SKILLS

• Extensive professional communication, organization, and relationship building skills
• Comprehensive project management experience in distributing limited resources to achieve project success in complicated technical architecture design processes
• Proficient in SQL, Python, Microsoft Suite, ArcGIS/ArcMap, Analyst’s Notebook, and Sharepoint, Confidential Database, and Visualization Creation
• Familiarity with SAP SuccessFactors and Business Intelligence, Microsoft Azure, Hadoop, MapReduce, PowerBI, Amazon Web Services, Cyber Security, DevOps, Machine Learning
• Robust understanding of database architecture, database administration, table relationships, data types and values
• Ability to investigate/ask pertinent questions, analyze and interpret data, develop and present visual representations, i.e. charts, graphs, pivot tables etc. using MS Office, Tableau, OBIEE or other software suites
• Ability to perform in-depth current and long term analysis to build summary reports from multiple sources to provide a clear operation picture for executives

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Data Engineer

Responsibilities:

• Designed Extract Load and Transfer (ELT) processes to integrate highly disparate data sources into an amazon web services (AWS) using Confidential Data Integrator (ODI)
• Assisted in teh cloud migration of a large on premises Confidential data warehouse into amazon web services (AWS). Included teh configuration and integration of Confidential Data Integrator (ODI), OBIEE, Confidential 12c database, and Confidential Weblogic
• Assisted in teh development of object storage buckets (Amazon s3 Object Store, Confidential Object Store) that would be utilized as data lake solution for machine learning models and relational database queries.
• Developed highly technical documentation to document complex business rules and data cleansing techniques. Documentation included customer analysis requirements and groupings of data set elements required to output teh desired answers to business questions
• Assumed teh role of lead architect for multiple subject areas to include teh data model design of several data sources and subsequent implementation
• Performed unit testing to validate accuracy and validity of reports throughout several subject areas
• Translated business needs and requirements into data analytic and reporting solutions to deliver meaningful information to end users across several agencies. Additionally, designed, tested, and implemented BI solutions, including dashboards, drill down/through - paths, and reports in Confidential Business Intelligence Enterprise Edition (OBIEE)
• Extensively developed teh Confidential BI repository (RPD file) metadata to establish teh web catalog for use by all customers within teh customer organization using Confidential BI Administration Tool. Work included establishing business logic to be used by each report and intensive data manipulation to sustain repeated queries by multiple end users
• Assisted in teh development of an Confidential Cloud tenancy to include teh configuration of database schemas, ETL development, middleware development, and production of analytics.
• Utilized python to pull data from various web service end points and processed that data into a relational model that was used by executive members to understand teh impact of code changes to internal Confidential systems.

Confidential, Springfield, VA

Data Warehouse Architect

Responsibilities:

• Participated in daily Agile stand-up meetings, monthly planning sessions, sprint reviews, and retrospective sessions
• Designed and implemented several Extract Transfer and Load (ETL) systems using SSIS, T-SQL and stored procedures required to support a SQL Server data warehouse and was responsible for ensuring its data integrity from stage environment to information mart
• Assisted with documenting data flow processes, database objects with their relationships, technical data model documents, and diagrams
• Performed in teh roles of system sustainment analysis, architecture design, business defined development, testing, code debugging, technical documentation, training, deployment and post-production support for a large-scale data warehouse solution
• Gathered data requirements from subject matter experts (SME) and assisted with analysis and reporting of queried data with teh use of a Tableau or SSRS
• Developed data models involving multiple data sets through SQL Server Management Studio with teh use of logical and physical tools. Data models were stored on team SharePoint site for use by clients to develop an interactive knowledge bank of various data sets to attain business intelligence

Confidential, Tempe, AZ

Server Management Analyst

Responsibilities:

• Provided support to teh server management team through maintenance of databases (MS SQL/ Access) including master data pertaining to physical and virtual machine instances located throughout teh Phoenix Metro Area
• Assisted in teh development/review of end of month usage reports and ad hoc reports utilizing Microsoft SQL Server to analyze statistics regarding energy usage of teh data center, new server installation, virtual machine instances, etc
• Assumed a lead role in teh data validation/ data cleansing step of a database migration to ServiceNow requiring teh interaction with clients in person or virtual conferences
• Assisted in server hardware setup to include initial server boot and HP iLo configuration to allow remote maintenance of servers hosting cloud technologies. Additionally, oversaw installation of server operating system and system monitoring through Spectrum

Confidential, Tempe, AZ

Financial Analyst

Responsibilities:

• Assessed monthly financial information and records accruals to appropriately report results while simultaneously preparing monthly, quarterly, and annual projections to identify emerging trends
• Assisted in teh development of cost controlling initiatives and identifying areas of opportunity to ensure achievement of established financial objectives
• Assumed a managerial role in maintaining databases of supplier invoices nationally and ensured prompt payment of all accounts payables
• Performed bookkeeping, payroll functions, and bank reconciliations as well as developing ad hoc reports for sales forecasting
• Served as backup to finance manager for two high volume restaurants

Confidential, Augusta, GA

Data Analyst

Responsibilities:

• Led teh development and maintenance of project schedules, planning, risk monitoring and computer network operations, milestone tracking, status reporting, issue management, and other tasks required to TEMPeffectively manage and monitor a project through to successful completion
• Worked collaboratively and efficiently with various teams as a technical resource in teh geospatial metadata analysis development phase as well as delivery of data-oriented solutions to support critical national security enterprise needs
• Conducted digital network intelligence analysis with various databases to infuse multiple types of data to complete detailed standardized reports while working with stringent timelines
• Optimized staff productivity by organizing and instituting comprehensive training programs
• Functioned as staff advisor in charge of utilizing classified proprietary software and cybersecurity protocols in surface, subsurface, air, and satellite forces
• Assisted in reconciling project needs across multiple agencies and service units; collecting and interpreting data and performing threat warning analysis to provide critical support to personnel