| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE EMAIL AVAILABLEPRINCIPAL DATA SYSTEM ENGINEERHighly experienced Principal System Engineer with over 20+ years of experience in database architecture, dataengineering, data analysis, data modeling 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 SKILLSDatabase 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 System Capacity and Planning Data Security Data Warehousing Data Governance Data Compliance Business Intelligence And AnalyticsTECHNICAL SKILLSOperating System: MS Windows 3.11 Windows 95 Windows NT Windows XP Windows 2003 UNIX MS DOS VMSSoftware: Oracle 12c/18c/19c Oracle Developer/2000 Oracle Discoverer SQL Server 2000 MS Access Sybase Application Development Tools Microsoft VizioLanguages: SQL PL/SQL Python C JAVA C# .NetCloud Platform: Amazon Web Services (AWS-RDS), Azure, Multi Cloud PlatformScripts: SQL Perl Korn ShellPROFESSIONAL EXPERIENCEOlympic College, Bremerton, WA Feb 2024 - PresentData Analysis Engineer/Sr. Oracle PL/SQL ProgrammerAnalyze and interpret large datasets to identify trends and insights that drive business decisions.Develop dashboards and reports using Tableau and Power BI to provide insights and recommendations to board of directors.Collaborate with cross-functional teams to ensure data accuracy and completeness.Lead and manage projects related to data analysis and reporting, ensuring timely and accurate and delivery of required data.Develop automated process to streamline data analysis and reporting tasks.Collaborate with cross-functional teams to understand data needs and deliver high-quality data solutions.Utilize tools such as Microsoft Visio for creating detailed data flow diagrams, system architecture diagrams, and other visual representations.Managed data quality and data governance processes, ensuring data accuracy and completeness.Developed and optimized complex PL/SQL stored procedures, functions, and packages to enhance application performance and support critical business functions.Collaborated with business analysts and stakeholders to gather requirements and translate them into efficient database solutions using Oracle PL/SQL.Created and maintained detailed technical documentation for PL/SQL code, ensuring clarity and ease of maintenance for development teams.Analyzed and optimized complex SQL queries to enhance database performance, resulting in a significant reduction in query execution time and improved overall system efficiency.Developed advanced stored procedures and functions in Microsoft SQL Server to streamline data retrieval processes and facilitate efficient data manipulation.Collaborated with cross-functional teams to gather and analyze requirements, translating complex business logic into efficient SQL queries and database structures.Resolved intricate database issues by diagnosing root causes and implementing effective solutions, demonstrating strong problem-solving skills and a deep understanding of database architecture.Bellevue, WA June 2023 - PresentFreelance Data Analysis EngineerConducted data cleaning, data validation, and data transformation using Python and SQL to extract valuable insights.Developed and maintained dashboards to monitor KPIs and automate data visualizations using Tableau.Collaborated with cross-functional teams to design, implement and evaluate data-driven experiments and A/B tests.Built out the data and reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights into the product, marketing funnels and business.Using Excel and SQL, built a calculator for the client to help them prioritize their project roadmap.AT&T, Bothell, WA January 2006 - February 2023Principal-System Engineer /Lead Data EngineerManaged a team of data professionals to ensure timely delivery of data projects and high-quality data products to internal and external stakeholders.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.Help the project management staff with the management of project scope, budget, and schedule.Highly organized and able to manage multiple projects and associated tasks successfully.Proficient in developing comprehensive cost estimates for various phases of the product life cycle, leveraging analytical skills and industry knowledge to provide accurate and data-driven financial projections. Successfully contributed to cost analysis for many projects, ensuring cost-effectiveness and budget adherence.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.Utilized JavaScript, HTML5, and CSS3 to maintain dynamic and responsive web applications, enhancing user experience and interface design.Maintained and support webpages using HTML5 and CSS3, ensuring compatibility across various browsers and devices.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.Demonstrated proficiency in SQL with a track record of creating performant queries and building robust datasets.Developed a robust ETL pipeline using Apache Airflow, resulting in a significant reduction in data processing time and increased data accuracy.Implemented and optimized data integration workflows using Informatica ePIM, enhancing product information accuracy and streamlining processes.Managed Product 360 system configuration, ensuring seamless product data synchronization across multiple channels for improved consistency and efficiency.Developed and maintained data processing pipelines using Apache Spark and Python, enabling real-time data analysis for a multi-terabyte dataset.Designed and implemented automated data processing workflows using ADP systems to streamline retail operations and enhance data accuracy.Developed and maintained complex data models for retail applications, ensuring data integrity and optimizing database performance.Designed and implemented relational and dimensional data models to support business intelligence and reporting needs.Conducted data analysis and mapping to identify relationships between disparate data sources, facilitating the creation of a unified data model.Collaborated with cross-functional teams to gather requirements and translate business needs into effective data models.Created detailed process flow diagrams and data architecture diagrams in Microsoft Visio to support system integrations and business process reengineering initiatives.Utilized Microsoft Visio to create detailed and accurate data flow diagrams, process maps, and organizational charts, facilitating clear communication of system structures and workflows.Utilized ER diagrams and other modeling techniques to visualize and communicate data structures to stakeholders.Managed large datasets related to retail sales, customer transactions, and inventory within the telecom sector, ensuring timely and accurate processing through ADP.Utilized Python and Apache Spark for data preprocessing, feature engineering, and model development.Worked closely with the data science team to design and implement several predictive analytics models, resulting in improved business decision making and increased revenue.Utilized distributed systems such as Spark and Hadoop to handle and analyze data at scale.Leveraged cloud database technologies like Snowflake, Redshift, and Big Query to store and manage large datasets.Administration in Linux, Windows, and cloud-based operating systems.Supporting critical production workload automation environments.Experience with scripting, automation, and batch scheduling tools.Design and architect database for database-dependent applications, particularly involving Oracle databases.Managing and upgrading large enterprise-wide server-to-agent platforms.Hands-on experience with cloud platforms, particularly Azure and AWS.Exposure to networking and load balancing concepts.Demonstrated ability to work with APIs and integrate systems.Proficiency in Splunk for log analysis and monitoring.Some experience with Java development and Apache-based solutions.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.Demonstrated proficiency in utilizing system planning and capacity tools for analysis purposes during my 15+ years of experience, enabling data-driven decision-making and optimal resource allocation.Configured, installed, and provided support for various equipment based on business requirements for over 15 years, ensuring seamless operations and adherence to specifications.Effectively managed assigned projects and program components, delivering services in alignment with established objectives and meeting project timelines for over 15 years.Diligently maintained configuration and support documentation, ensuring accuracy and accessibility of critical information for efficient troubleshooting and system management throughout the years.Leveraged engineering skills and test/development experience to contribute to the enhancement and optimization of IT systems and processes over the course of my career.Adept at using ADO (Application Development and Operations) methodologies and effectively communicating project check-ins and updates to stakeholders during various projects and assignments.Possess extensive knowledge in IT Systems engineering, accumulated through 15+ years of experience, enabling me to handle complex IT challenges and optimize system performance.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 LoaderDeveloped and Modified PL/SQL packagesWorked on advanced PL/SQL constructs like Oracle supplied packages,Performed analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.Hands on experience with AWS-RDS.Experienced in Scrum and Agile methodologies, facilitating collaborative and iterative development processes.ADDITIONAL RELEVANT EXPERIENCET-Mobile, Bellevue, WAApplication DeveloperDesigned 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 using Microsoft Visio and designed efficient database schemas, resulting in improved data retrieval and storage efficiency.Microsoft, Redmond, WAApplication DeveloperSuccessfully 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, WAProgrammer/ AnalystSuccessfully 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 SQLs. Implemented and educated team in complex business logic using SQLs, 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.EDUCATIONBachelor of Science (BSc) in ElectronicsIndiaCERTIFICATIONSOracle with Developer2000 CertificationProfessional growth |
