Sanjeev Trivedi

206-***-**** adz3qg@r.postjobfree.com

PRINCIPAL SYSTEM ENGINEER

Highly experienced Principal System Engineer with over 20+ years of experience in database architecture, data

engineering, data analysis, and data science. Proven ability to lead large-scale data projects, design and maintain

complex database systems and provide data-driven insights to inform business decisions. Offers expertise in managing cross-functional teams, collaborating with stakeholders, and implementing industry best practices can be leveraged to develop high-performing teams, implement innovative solutions and drive business growth.

KEY SKILLS

Database Architecture And Design Data Engineering ETL Pipelines Data Analysis Data Science Data Modeling Database Optimization Project Management Team Leadership Collaboration Cloud Computing DevOps Performance Tuning Capacity Planning Data Security Data Warehousing Data Governance Data Compliance Business Intelligence And Analytics

TECHNICAL SKILLS

Operating System: MS Windows 3.11 Windows 95 Windows NT Windows XP Windows 2003 UNIX MS DOS VMS

Software: Oracle Oracle Developer/2000 Oracle Discoverer SQL Server 2000 MS Access Sybase Application Development Tools

Languages: SQL PL/SQL Python C JAVA C#

Scripts: SQL Perl Korn Shell

PROFESSIONAL EXPERIENCE

AT&T, Bothell, WA January 2006 - February 2023

Principal-System Engineer / Lead Data Engineer/Lead Oracle PL/SQL developer

Managed a team of data professionals to ensure timely delivery of data projects and high-quality data products to internal and external stakeholders.

Loaded the data into database using the SQL*Loader from various sources.

Responsible for SQL tuning and optimization using Explain Plan and optimizer hints.

Involving in tuning SQL queries by using EXPLAIN PLAN.

Working experience in data extraction, transformation and loading operations into oracle using SQL Loader

Developed and Modified PL/SQL packages

Worked on advanced PL/SQL constructs like Oracle supplied packages,

Performed analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.

Developed and maintained Hibernate-based data access layers, enhancing database performance and scalability.

Implemented Hibernate ORM for seamless mapping between Java objects and relational databases, reducing code complexity.

Collaborated with cross-functional teams to design and implement Hibernate-based solutions for complex business requirements.

Built and maintained ETL workflows using Talend, automating data extraction, transformation, and loading processes, resulting in a 30% reduction in manual data entry.

Assisted in the design and execution of ETL processes using SQL and Python, enabling the extraction and transformation of data from various sources into a unified data repository.

Provided professional guidance to the team on technical issues, project management and team performance.

Led the development of the company's data architecture strategy and implemented several large-scale data engineering projects to optimize data processing and analysis workflows.

Led the design and implementation of a scalable database architecture, resulting in a 50% reduction in query response time and improved system availability.

Designed and implemented a data processing pipeline that processed over 10 terabytes of data daily, enabling the organization to gain real-time insights into customer behavior and improve marketing strategies.

Collaborated with business stakeholders to understand their data needs and provide insights that informed strategic decisions.

Developed and maintained data governance policies and procedures to ensure data quality and compliance with industry standards and regulations.

Conducted regular performance tuning and optimization of database systems to ensure maximum efficiency and scalability.

Designed and implemented a scalable data warehouse solution, which improved the performance and efficiency of the company's analytics processes.

Developed a robust ETL pipeline using Apache Airflow, resulting in a significant reduction in data processing time and increased data accuracy.

Worked closely with the data science team to design and implement several predictive analytics models, resulting in improved business decision making and increased revenue.

Conducted regular performance evaluations, identified skills gaps, and implemented training programs to enhance the team's technical skills and performance.

Maintained a secure and compliant data environment by implementing data security and privacy measures, and ensured regulatory compliance with GDPR, CCPA and other applicable regulations.

ADDITIONAL RELEVANT EXPERIENCE

T-Mobile, Bellevue, WA

Application Developer

Designed and developed database systems for multiple small to medium-sized applications, ensuring data quality and system performance.

Conducted regular performance tuning and optimization of database systems to improve query response time and reduce system downtime.

Collaborated with cross-functional teams to ensure data integration and consistency across different systems.

Implemented several data modeling techniques and designed efficient database schemas, resulting in improved data retrieval and storage efficiency.

Microsoft, Redmond, WA

Application Developer

Successfully developed a system in Windows 2003 server, ASP.net using C#, IIS, and SQL Server 2000 database.

Modified the database by adding complete structured tables.

Developed database stored Procedures, Functions and Triggers to support the application.

Developed email messaging system using database stored Procedures, Functions and Triggers to support the application.

Developed global purpose stored Procedures and Functions that be used by other systems or application too.

Wrote technical documentation for knowledge transfer and Internal/External Audits.

Adaptis Inc., Seattle, WA

Programmer/ Analyst

Successfully converted Adaptis system from FoxPro and developed in Windows NT/2000/XP, Oracle 8i/9i, Developer 2000 to facilitate routine activities like data entry, processing of Claims.

Troubleshot applications for pinpointing problem SQL’s. Implemented and educated team in complex business logic using SQL’s, Procedures, Functions, Triggers and Packages.

Mentored team with SQL writing/Tuning and trained them in best practices for SQL.

Designed and developed GUI based data entry screens using Oracle Forms 6.0/6i.

Worked with Providers, Claims, Refunds, Encounter Adjudication and Finance Teams to Design and Develop Forms and Report Modules.

Developed process using forms, packages to perform an Upload for the data received on weekly basis electronics files from the state. Designed new form to utilize it.

Developed process using forms, reports, packages to extract data from Adaptis system into text file format by using Bulk-Collect, PL/SQL tables, Case functions, External tables.

Analyzed user requirements and developed system specifications.

Analyze and design program logic to eliminate problems and to ensure efficient system functioning and ease to maintain.

EDUCATION

Bachelor of Science (BSc) in Electronics

India

CERTIFICATIONS

Oracle with Developer2000 Certification

Contact this candidate