We provide IT Staff Augmentation Services!

Business Analyst/dot Specialist Resume

Atlanta, GA

SUMMARY:

  • Business Intelligence & analytics professional with 7 years of work experience in Airlines, Banking and Education industry.
  • Demonstrates key skills in providing data - driven insights and solutions by performing ETL data integration and creating analytical data models as well as interactive visualization dashboards based on performance metrics, KPIs and historical trends using BI tools such as Power BI, Tableau and MS Office.
  • Performed key role maintaining cross-divisional collaboration for gathering business requirements from stakeholders, designing process flows, performing risk/impact analysis and implementing improved business processes.
  • Proficient in database technologies such as Teradata, SAS, SQL Assistant and XML and programming languages such as Java Spring, Jquery, HTML and Bootstrap CSS.
  • Worked on various data migration and ETL projects as product owner/subject matter expert in an agile environment gaining experience in creating product and sprint backlogs as well as preparing user acceptance testing scenarios and audits.

TECHNICAL SKILLS:

Languages & Databases: Teradata, SQL, SAS, Python, Java, HTML, XML, Bootstrap CSS, jQuery

BI Tools: MS Excel, Power BI, Tableau.

Project Management: Agile, JIRA, Waterfall, Requirement Analysis, Risk Analysis, Impact Analysis

WORK EXPERIENCE:

Confidential, Atlanta, GA

Business Analyst/DOT Specialist

Responsibilities:

  • Critical role in maintaining operational data integrity and accuracy of monthly performance reports mandated by the United States Department of Transportation (DOT) and Transport Canada (TC).
  • Support high priority requests from Operations and Customer Center to understand drivers behind changing trends and performance metrics by identifying business problems and present data-driven business solutions using BI tools such as MS Office and Power BI.
  • Prepared dashboards for DOT on-time metrics, chronically delayed flights and tarmac delays for Weekly Investigation Reports and Monthly Performance Reviews.
  • Acted as Product Owner and subject matter expert for operational data migration from legacy systems (DBMS and Attachmate) to EDW and implemented a streamlined reporting process with improved turnover time for high-end business requests using SAS and Teradata.
  • Management of cross-divisional communication with operating divisions such as Flight Operations, In-Flight Services, Airport Customer Service, and Customer Care for reporting the tarmac delay investigations for compliance with the Passenger Bill of Rights.

Confidential, Atlanta, GA

Marketing Operations Analyst Intern

Responsibilities:

  • Built reporting models and visualization dashboards for customer trends and demand-supply gap analysis to support Delta Sky Club Liquor Inventory Management with the Customer Engagement and Loyalty Department.
  • Prepared SAS/Teradata data mining models for the optimization of the Revenue Pipeline Analytical Database (RPAD).
  • Worked closely with the Customer Intelligence Hub (CIH) in order to analyze data that is required for designing marketing campaigns across online and offline channels.

Confidential, Atlanta, GA

Graduate Research Assistant

Responsibilities:

  • Prepared and tracked budgets for sponsored projects by analyzing budget expenditure trends for the Economics department.
  • Prepared personnel projections for faculty and staff using MS Excel.
  • Maintained monthly expense audit reports using Oracle Spectrum and GSU Panther Mart.

Confidential

Software Engineer & Analytics Engineer

Responsibilities:

  • Researched and developed framework for FinnAxia and Digital Compass including modules for Cash Management - Payments and Collections, Liquidity Management using Java Spring, Bootstrap CSS and jQuery.
  • Implemented security and performance improvement methodologies compliant with OWASP in order to achieve faster and safer query executions and avoiding SQL injections and Cross-site Scripting (XSS).
  • Performed data migration using Oracle, Hibernate and Web Services.
  • Performed In-house Impact Analysis, Quality Assurance, and maintained JIRA issue trackers.
  • Experienced in financial environments working with Standard Bank of South Africa (SBSA), Ambank, Ratnakar Bank (RBL) and Bank of Baroda (BOB)
  • Implemented banking portfolio analysis models and predictive scoring models throughout the loan management lifecycle in FinnOne Neo - Lending Analytics.
  • Prepared customized and interactive visualization dashboards using Tableau for insight generation to support informed decision making regarding improved customer acquisition and efficient delinquency management.

Hire Now