We provide IT Staff Augmentation Services!

Business Intelligence Engineer Resume

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Engineer

Responsibilities:

  • Achieved 100% on time delivery of data daily refresh for large - scale, complex datasets by re-engineering ETL and optimizing SQL queries.
  • Successfully migrated all data sources from AWS Redshift to AWS EC2 (SQL Server) for Strategic Pricing Analytics platform on time and on budget.
  • Reduced time taken to pull and insert data by 100% by writing scripts that automated the data processing using PowerShell.
  • Improved instant responses by 60% by implementing ETL status real-time feedback and job failures instant email notifications sent by SQL Server.
  • Successfully designed and implemented complex datasets and analytics for Transportation and CSR dashboards.
  • Leading team of developers delivering up to 6 projects simultaneously on time and on budget.

Confidential

Sr. Software Engineer

Responsibilities:

  • Reduced production issues by 85% by designing and implementing data and process quality testing, decision making and reporting solution.
  • Achieved 100% proficiency and expertise designing and developing custom interactive reports using Insights (Viz FX) Reporting Platform.
  • Successfully designed and implemented WDG Security Operation Executive Scorecard and Conflux Asset Security Summary dashboards.
  • Reduced time taken to investigate data processing (ETL) unexpected behavior by 90% by designing and implementing progress instant feedback solution.
  • Improved existing ETL solution by 50% by enhancing new features and optimizing SQL server stored procedures and queries.
  • Achieved 100% on time deployment for all releases with no severity one or two issues by designing code deployment best practices.
  • Successfully developed best practiced of team development cycle and weekly deployments by using GitHub source control and team code reviews.

Confidential

Software Engineer

Responsibilities:

  • Achieved 100% on time delivery of all planned team work items by designing and implementing team Kanban board using TFS, SQL Server and Tableau.
  • Developed and successfully implemented Demand Management data warehouse and daily refresh ETL jobs on time, on budget and in scope.
  • Achieved over $1M cost reduction by creating FY16 Budget Planning and Planned Work vs Team Capacity dashboards using Tableau and SQL Server.
  • Reduced time taken to create a report manually by 100% by automating the Demand executive summary one page charter report using SSIS and SQL Server.
  • Improved daily refreshed jobs by 40% by writing scripts that process and loads TFS data into SQL Server database using C# and ADO.NET.

Confidential

Business Intelligence / SQL Server Developer

Responsibilities:

  • Delivered on time and on budget 20 complex dashboards and over 50 reports using SQL Server databases and Reporting Services.
  • Designed and implemented user access management web application using ASP.NET MVC 5 (C#) and Entity Framework on time, on budget and in scope.
  • Successfully designed and implemented quality assurance web application using ASP.NET MVC 5 (C#) and SQL Server.
  • Designed and implemented SQL Agent ETL jobs to support user access and quality assurance web applications on time, on budget and in scope.
  • Reduced quantity of production report by 20% by designing complex multi-functional dashboards and coordinating requirements.
  • Achieved 100% on time delivery bank operational data to internal audit team by developing and scheduling ETL jobs with SQL Server Agent.

Confidential

Lead Quality Assurance team

Responsibilities:

  • Achieved 98% efficiency by developing standard operational procedures and Team Performance Dashboard using MS Excel and SQL Server.
  • Improved quality of communication across multiple departments by 50% by presetting simple behavior of effective communication.
  • Achieved 100% efficiency of production equipment seasonal calibration by using Statistical Control and Predictive Analytics
  • Recognized by PEPSICO with Caleb Bradham Quality Award for great performance and improvements initiatives.
  • Successfully developed and implemented product batching application on time and on budget.
  • Reduced errors incidents by 70% by developing operational best practices and training programs for quality assurance personnel.
  • Successfully established network connections between all QA lab equipment and computers that automated the data entry process.

Hire Now