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.