PROFESSIONAL SUMMARY

• Experienced Business Intelligence Analyst/Developer with over sixteen years of combined experience in the career field of Data/ Statistical Analysis including Data Analytics, Research & Development, and Database Design.
• Strong background in client interaction and working with end - users to Design, Analyze, and create customized reports
• Strong background in organizational and time management skills, as well as demonstrating the ability to exercise discretion, tact, judgment, and diplomacy, and is also, is willing to accept and abide by corporate values, goals, and objectives.
• Possess experience with data migration initiatives and data warehouse concepts (cubes, star schemas, etc.), and experience with front-end web technologies (HTML, JavaScript). Possess knowledge and experience of working with relational databases and SQL. Possess experience in SQL coding/querying skills in Oracle, Toad for Oracle, & Teradata.

TECHNICAL SKILLS

• Cognos 10 Framework Manager
• TOAD (Oracle)
• SAFI - Security Association of Financial Institutions
• NCR Teradata Advanced SQL
• Oracle Server
• Microsoft SharePoint
• SQL Server Standard
• Microsoft Server Management Studio
• MS Advanced SQL Querying
• IBM Cognos
• Business Objects Tableau Business Analytics
• Tableau Business Analytics 8.0
• MicroStrategy Business Intelligence
• Visual Basic
• SQL Database Maintenance
• MS Access Advanced Tasks
• Data Warehousing
• MS PowerPoint
• MS Excel Advanced Tasks
• Oracle
• Microsoft SQL Server
• Microsoft Visual Studio
• JavaScript
• Android Development (Genymotion Studio)
• Oracle Client 11g
• Oracle SQL Developer 4.0
• Tableau 8.2
• MS Project

PROFESSIONAL EXPERIENCE

Fresh Associate

Responsibilities:

• Fulfillment of online customer orders in all customer tempered environments
• Provide daily warehouse sustainment & overall operational support
• Provide daily Amazon Prime support
• Forklift/Electric Pallet jack (PIT) certified
• Truck Dock Release certified
• Trailer Loading & Unloading
• Perform daily expired product audits & corrugated removals
• Perform problem solving solutions on customer orders
• Perform inbound/outbound product audits and stowing procedures

Business Intelligence Developer/Analyst (Contractor)

Responsibilities:

• Daily BI Development utilizing Cognos 10 Framework Manager utilizing military contracting data within the Cognos 10 Framework Manager Report Studio, Analysis Studio, and Query Studio across all DCMA business lines
• Provide daily Software Development Report sustainment
• Provide daily Help Desk support
• Perform daily analysis utilizing TOAD (Oracle) for data verification
• Perform daily data analysis of report outputs across development and production environments.
• Perform daily trouble shooting for data integrity problems, analyze data for alignment and integration to the data dictionaries, and data transformations
• Create and publish Cubes/Packages, Presentation/Business layers, bases on end user requirements
• Daily modeling of dimensional data, Importing data sources,
• Daily maintenance of stored projects via help desk support utilizing Change Gear IT Service Management support software

Data Management Analyst (Contractor)

Responsibilities:

• Support the automated/manual methods used to collect data from various authoritative sources using Oracle Business Intelligence 11g, SQL Developer 4.0, Tableau 81, 8.2., and MS Excel/Access 2010
• Publishes completed Dashboards/Workbooks to the Tableau Server
• Analyze data for alignment to the data dictionaries
• Perform daily data transformations
• Analyze data, identify data integrity problems, analyze data for alignment and integration to the data dictionaries, data transformations
• Create and modify Oracle Views, Modification of Stored Procedures within the Oracle Environment, and Extract, Transform, Load (ETL) process management
• Develop and test Complex SQL queries/dashboards for visualization and presentations to the DOD ODCMO/Defense Business Council-Investment Review Board and associated directorates
• Daily data preparation for ingestion into the development/test repository and the BI environments
• Daily generation of data flow models to be disseminated to the Directorate
• Creates sustainable data connection methods/extraction capabilities
• Configures user accounts to the data alignment portal
• Performed Integrated Business Framework help desk support

Data Engineer

Responsibilities:

• Support the automated/manual methods used to collect data from various authoritative sources using Oracle Business Intelligence 11g, SQL Developer 4.0, Tableau 81, 8.2., and MS Excel/Access 2010 which is used as the ETL process by which Tableau 81,. 8.2., is used to create the final visualization, as well as ad-hoc reports creation upon request.
• Analyze data, identify data integrity problems, analyze data for alignment and integration to the data dictionaries, data transformations
• Conducted analysis of Defense Business Systems mappings of system migrations
• Create and modify Oracle Views, Table creation Triggers, Procedures, and ETL process management for data extraction
• Develop and test Complex SQL queries/dashboards for visualization and presentations to the DOD DCMO/IRB and associated directorates
• Prepare data for ingestion into the development/test repository and the BI environments
• Create Data flow models to disseminate to the Directorate

Data Analyst / Engineer (Contractor)

Responsibilities:

• To provide programmatic evaluation and data analysis to support Harmonia’s efforts to ensure effective and consistent administration of Confidential ’s ( Confidential ) safety programs by utilizing Motor Carrier data
• Served as the Database Analyst/Engineer to convert and automate existing data reports from an MS Excel platform to updated platforms using SQL queries, Cognos, MicroStrategy, Tableau Business Analytics, SQL Server, and MS Excel/Access

Data Analyst

Responsibilities:

• Supported data extraction (Airline ticketing data, cash/credit transactions within the Enterprise Data warehouse Cognos, Microstrategy, Teradata, SQL Assistant, Business Objects FastLoad, BTEQ and Oracle extraction utilities.
• Developed and tested Complex SQL queries/dashboards (ad-hoc or scheduled) utilizing SAS, SSRS, Microsoft SQL Server 2012, Microsoft Visual Studio, Teradata SQL, BTEQ, Fast Load, MicroStrategy, Tableau Business Analytics, SQL Server, and MS Excel/Access, Tableau, MicroStrategy, Cognos, and Business Objects intelligence tools.
• Analyzed statistical and financial data to identify potentially fraudulent transactions using computer auditing and SAS statistical sampling techniques.
• Developed dashboards, ad-hoc reports, and reporting tools as requested by internal/external customer’s using the above listed BI tools, SAS and to establish technical and functional designs and business models that meet requirements of the internal/external end user.
• Contributed to the development of new products to increase revenue growth in emerging markets.
• Performed daily ETL performance tuning, complex SQL query design and ETL process verification for optimal performance.
• Developed time-saving Teradata SQL queries (hard coded) for faster production output by the internal/external customers
• Enhanced end-users understanding of database systems by delivering group and individual training sessions and creating user-friendly training materials
• Maintained/Managed all departmental database tracking systems
• Served as the DBA for departmental tracking databases, and analyzed business requirements to produce better delivery solutions to the department’s internal/external customers
• Monitored the daily ETL’s of dishonored bank drafts and to insure that all dishonored drafts were resolved within a 24 hr. period to protect company revenue
• Managed the Resolution of all non - reported sales transactions and to insure those financial transactions were properly loaded into all companywide financial reporting systems
• Analyzed existing data extractions using Microsoft Excel and Access Databases to determine data structure and report building

Investigative Fraud Analyst

Responsibilities:

• Produced reports to analyze and investigate fraud scenarios within the travel industry in an effort to minimize financial losses using financial/statistical models.
• Designed custom financial and auditing reports using NCR Teradata SQL, Tableau, Business Objects, and IBM Cognos, and MicroStrategy business intelligence software
• Extensive use of MS Excel (Pivot Tables, VLOOKUP, and advanced formulas), MS Access and Visual Basic programming to produce financial risk models for cash/credit transactions within the travel agency/airline carrier community
• Analyzed and implemented the design of financial risk models that were used by cross functional teams to determine risk
• Designed and implemented risk analysis ranking reports using NCR Teradata SQL for departmental and ad-hoc requests, via government subpoenas, arrest warrants and airline carrier submission requests
• Developed business requirements to reply to law enforcement inquires and subpoena requests within a twenty four hour period
• Designed data templates in collaboration with the Department of Justice (FBI), Immigration & Customs Enforcement (ICE), Unites States Marshals Service, Department of Homeland Security, Drug Enforcement Administration, Alcohol Tobacco & Firearms (ATF), US Navy (NCIS), Diplomatic Security Service, US Army and Local Law Enforcement agencies within the United States
• Designed Data content for distribution with Microsoft SharePoint