Business Intelligence Engineer
- 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.
Sr. Software Engineer
- 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.
- 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.
Business Intelligence / SQL Server Developer
- 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.
Lead Quality Assurance team
- 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.