Tarun Tuteja Email & Phone Number

Portland, Or, Us

Portland, Oregon Area

• Mastered ad-hoc 500+ queries per year to collect data for internal reference, legal inquiries, and a wide range of requests for information for team members, management, and customers increasing productivity by 50%.• Created and refactored hundreds of stored procedures to either replace inline code or enhance existing procedures for scalability and performance to help the business grow and increaseproductivity by 50%.• Developed complex SQL queries to extract and manipulate data from RedShift, Oracle, and S3 data sources, ensuring the accuracyand efficiency of business reporting.• Delivered in-depth data analysis, creating detailed reports and dashboards to present key business insights to both technical and non-technical stakeholders.• Leveraged data visualization tools, particularly Tableau, to represent data in a consumable and actionable format, helping drive decision-making processes.• Collaborated with cross-functional teams to query cloud-based AWS databases and perform data extractions and analyses in support of backend systems.• Conducted thorough data validations to ensure the integrity of reports and dashboards used by the business.• Created interactive dashboards and reports in Tableau, enabling real-time data analysis and visualization for end users.• Provided ongoing support and maintenance of Tableau reports and dashboards, ensuring optimal performance and usability.• Developed 100+ business intelligence solutions for ETL (Extract, Transform, and Load), monitoring, debugging, and troubleshooting.• Provided support for proprietary desktop and web-based applications including the Loan Servicing module of The Mortgage Office designed for payment application and Escrow Administration.• Performed code reviews and provided timely feedback to engineers on the team.• Managed QA Engineers to clarify testing strategies to ensure requirements were fully implemented and met acceptance criteria.

India

• Monitored, tuned, and optimized performance at the server, instance, database, and object level including execution plan analysis and optimization.• Performed data analysis and developed complex SQL queries and scripts.• Used SSIS to develop jobs for extracting, cleaning, transforming, and loading data into the data warehouse.• Participated in various efficiency and capacity-building initiatives, including automation/ standardization efforts.• Laid the groundwork for data-driven decision-making by creating SQL data extracts for Power BI dashboards, facilitating an improvement in report generation speed by 20%.• Led the development of complex SQL queries for data extraction from multiple databases, including AWS RedShift, Oracle, and S3, optimizing the performance of backend systems.• Provided business-focused data analysis by interpreting large datasets and transforming them into insightful reports and visualizations.• Designed and maintained Tableau dashboards to monitor key business metrics, supporting decision-making for multiple business units.• Utilized AWS cloud infrastructure for data processing and storage, ensuring smooth integration between data sources and reporting tools.• Played a key role in troubleshooting and optimizing SQL queries to improve reporting accuracy and performance.• Created SSIS packages for export data from OLE DB Source (Oracle), Excel spreadsheet to SQL Server.• Performed operations like data reconciliation, validation, and error handling after extracting data into SQL Server.

Noida Area, India

• Automated routine tasks and oversee repeatable processes.• Solved for increasing need to transform dynamic data formats to standard.• Troubleshooted and resolved performance issues related to PL/SQL code.• Created conceptual, logical, and physical data models to deploy and load database table structures in support of system requirements.• Designed, deployed, and monitored ETL packages with SSIS for data warehousing environment and automation of batch cycle.• Interacted with customers and the team for requirement gathering, risk assessment, and finalization of technical specifications.

Noida Area, India

Developed several in-house applications and utilities to enhance and service portfolio for a mortgage company using multiple technologies like VB .NET, Web Service, MVC, .NET Core, Entity Framework, Angular, Python, VBA, MS Access, and SQL Server Application. • Developed a web application using Angular as the front-end and using Web API to receive and pass data to the back end.• Created Angular Components, Directives, Services, and Reactive Forms to collect input from users.• Coded business logic and data access layer using C#.• Implemented forms-based authentication to authenticate the users.• Monitored, tuned, and optimized performance at the server, instance, database, and object level including execution plan analysis and optimization.• Performed data analysis and developed complex SQL queries andscripts.• Developed multiple database objects(Stored procedures, Triggers, Views) for supporting business operations. • Wrote thousands of complex queries to gather and share data for business needs as a member of the support team. • Used SQL Profiler for finding queries for third-party applications like TMO(The Mortgage Office).• Designed and developed database solutions for analysis and workflow• Maintained structure for the data warehouse which includes database objects, SSIS packages, and data.• Provided technical consulting to other departments.

Noida Area, India

Worked on an application that generates documents for commercial lending. As a software engineer, worked on different tasks to develop and maintain different modules for applications using Visual Studio 6.0, Python and SQL Server. • Performed unit testing and code review before handing over tasks for QA to maintain high-quality deliverables. • Used SQL Sever extensively for the back end part and worked with multiple DB objects(Stored Procedures, Views, and Triggers) and profiler.• Provided technical leadership and mentorship to junior engineers, fostering a culture of continuous learning and improvement.• Performed data analysis with Pandas and NumPy, identifying key market trends that shaped the product roadmap and directed strategic planning.• Automated the extraction and transformation of research data using Python, slashing data preparation time by 60% and enabling real-time data analysis.• Monitored, tuned, and optimized performance at the server, instance, database, and object level including the execution plan analysis and optimization.• Performed data analysis and developed complex SQL queries and scripts.

Noida Area, India

Worked on an application that generates documents for commercial lending. As a software engineer, worked on different tasks to develop and maintain different modules for application using Visual Studio 6.0 and SQL Server. Performed unit testing and code review before handing over tasks for QA for maintaining high quality deliverables.

Noida Area, India

Worked with a team responsible for production support for the banking domain. Worked on providing data on time as support tickets had SLA and priorities.

Gurgaon, India

Worked as an application developer for applications built around Visual Basic 6.0 & Microsoft VB . NET. Application extensively used SQL Server as database and multiple database objects(Stored Procedures, Views, Triggers). Created design documents, did unit testing and code review for following SDLC and documentation.

New Delhi Area, India

Worked as a project engineer for a Healthcare project. Was involved in the implementation of software at multiple hospitals for MCD, Delhi. Job responsibilities included the installation of server and client machines for users including patching.

Master Of Computer Applications - Mca, Computer And Information Sciences And Support Services

Master Of Science - Ms, Computer And Information Sciences And Support Services

Post Graduate Diploma In Computer Applications, Computer And Information Sciences And Support Services

Bachelor'S Degree, Accounting