Overview
Work History
Education
Skills
Certification
Additional Information
Work Preference
Work Availability
Timeline
Hi, I’m

TARUN TUTEJA

SQL Developer
Portland,OR

Overview

19
years of professional experience
1
Certification

Work History

Aspen Capital
Tigard, Oregon

Software Engineer Software Engineer
06.2018 - Current

Job overview

  • Created and refactored hundreds of stored procedures to either
  • DBeaver - PostgreSQL
  • PagerDuty
  • Jenkins - SQL Scripts Deployment
  • Data
  • REST APIs

Aquilasys Inc

Programmer Analyst
04.2016 - 06.2018

Job overview

  • Aspen Capital
  • 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
  • Integrated SSAS cubes with Excel workbooks to provide users with intuitive and interactive data analysis tools including other sources such as Teradata and Snowflake
  • Interacted with customers and the team for requirement gathering, risk assessment, and finalization of technical specifications
  • Improved existing data warehouse processes, optimizing reporting, and improving data integrity throughout the organization
  • Created SRS & TDD documents based on requirements.

Senior/Lead Consultant
05.2012 - 04.2016

Job overview

  • Client – Aspen Capital
  • Automated routine tasks and oversee repeatable processes
  • Troubleshooted and resolved performance issues related to PL/SQL code
  • Designed, and 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.

Tavant Technologies

Senior Software Engineer
09.2009 - 04.2012

Senior Software Engineer
11.2008 - 05.2009

Keane India

Senior Software Engineer
08.2007 - 11.2008

Wipro Healthcare IT Ltd

Project Engineer
04.2006 - 08.2007

Education

Kurukshetra University

Master of Computer Application
2005

Kurukshetra University

Master of Computer Science
2004

Kurukshetra University

Post Graduate Diploma from Computer Science
2003

University of Delhi

Bachelor of Commerce
2002

University Overview

Designed forms & databases using MS Access, Word, and Excel Worked with different DB Objects like Stored Procedures /Views /Queries /Triggers in SQL Server. 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.

Skills

  • TECHNOLOGY SNAPSHOT
  • Databases
  • MS SQL Server
  • Oracle
  • PostgreSQL
  • MS Access
  • ETL Tools
  • Data Transformation Services
  • SQL Server Integration Services
  • Boomi Web Services
  • Boomi Process Modeling
  • Boomi database connectors
  • Reporting Tools
  • SQL Server Reporting Services
  • SQL Server Analysis Services
  • Programming Languages
  • Python
  • VB Net
  • C#
  • ASP Net
  • Visual Basic 60
  • VBA Programming
  • Database Tools
  • SQL Server Management Studio
  • SQL Query Analyzer
  • SQL Profiler
  • Data Visualization
  • Tableau
  • Tools
  • Anaconda Spyder for Python
  • PgAdmin - PostgreSQL
  • Seasoned application programmer and data engineer offering
  • Over 18 years of diverse industry success in application programming, support, and implementation
  • Expert in analyzing, designing, developing, installing, configuring, and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services
  • 15 Years of experience writing and optimizing SQL queries, creating, and managing stored procedures, data backups, and restoring, importing, and exporting data to different sources
  • 10 Years of MSBI experience with SSIS, SSRS and SQL
  • 8 Years of experience with PL/SQL (Packages, Procedures, Functions, Triggers)
  • 5 Years of programming experience with VB NET, C#, ASP
  • NET, Web Services and Python
  • 5 Years of experience in VBA Programming, including Excel, Word, Access, Pivot tables, and array functions
  • Advanced understanding of object-oriented programming concepts
  • Working knowledge of cloud-based technologies (AWS)
  • 12 Years of Mortgage Servicing Industry experience spanning all phases of Loan Boarding, Servicing, Foreclosure, Bankruptcy, Loss Mitigation, Taxes, Insurance Escrow, and de-boarding for Lending and Servicing Company
  • 5 Years of experience with Healthcare, Banking, and Manufacturing ERPs
  • Supported day-to-day operations and management of over 20 enterprise-level production database instances in development, testing, staging, and 24/7/365 production environments
  • Able to dive-in in any of the existing code and debug for any reported issues
  • Experience with business requests and translating them into technical business requirements
  • Experience in System Integrations and client interactions for preparing functional designs
  • Lead Agile delivery, JIRA story creation, Sprint planning, and Sprint Demo
  • Effectively managed multiple projects and prioritized them based on the needs of stakeholders
  • Experience with Agile and Waterfall methodologies
  • H1-B and I-140 Approved
  • JSON
  • HTML
  • XML
  • Front-End Technologies
  • CSS
  • JavaScript
  • API Tools
  • Postman
  • Insomnia
  • Scripting
  • PowerShell
  • Batch Script for Windows
  • ERP/CRM Software
  • Sage Intacct
  • TMO – The Mortgage Office
  • Code Repository
  • Git
  • Bitbucket
  • TFS
  • Microsoft Office Suite
  • Word
  • Excel
  • Visio
  • PowerPoint
  • Outlook
  • SharePoint
  • OneNote
  • Project
  • Agile Tools
  • JIRA
  • Confluence
  • WIKI
  • OS
  • Windows
  • MAC
  • TECHNICAL AND
  • INTERPERSONAL SKILLS
  • Data Analysis
  • Replace inline code or enhance existing procedures for scalability
  • And performance to help the business grow and increase productivity by 50%
  • Gap Analysis
  • Root Cause Analysis
  • Data Mapping
  • Processes and Workflows
  • Use Cases and Scenarios
  • End-User Training
  • Release Planning
  • Agile Development
  • Multi-Tasker
  • Detail-Oriented
  • Analytical Thinking
  • High Energy Contributor
  • Results-Oriented Team Player
  • Quick Learner
  • Problem-Solving Skills
  • Documentation and Presentation Skills

Certification

AWS Certified Cloud Practitioner Issued - 09/2022 Expires - 09/2025

Additional Information

  • SQL ETL DEVELOPER AND DATA ENGINEER . CONTACT , Portland, OR 97229 - Open to Relocate

Work Preference

Work Type

Contract Work

Work Location

RemoteHybridOn-Site

Important To Me

Career advancementPersonal development programsTeam Building / Company RetreatsWork-life balanceCompany CultureFlexible work hoursWork from home option
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Software Engineer Software Engineer

Aspen Capital
06.2018 - Current

Programmer Analyst

Aquilasys Inc
04.2016 - 06.2018

Senior/Lead Consultant

05.2012 - 04.2016

Senior Software Engineer

Tavant Technologies
09.2009 - 04.2012

Senior Software Engineer

11.2008 - 05.2009

Senior Software Engineer

Keane India
08.2007 - 11.2008

Project Engineer

Wipro Healthcare IT Ltd
04.2006 - 08.2007

Kurukshetra University

Master of Computer Application

Kurukshetra University

Master of Computer Science

Kurukshetra University

Post Graduate Diploma from Computer Science

University of Delhi

Bachelor of Commerce

Similar Profiles

CREATE PROFILE
TARUN TUTEJASQL Developer