Sunaina Joshi
WEST DES MOINES,Iowa
Summary
Adaptable System Analyst and Data Engineer with strong skills in troubleshooting and exposure to data pipeline development. Experience in coding in PL/SQL, SQL Server, Snowflake, and Azure Synapse, and worked on Oracle HCM, Oracle EBS and BI data warehouse projects. Collaborative team player with a focus on timely issue resolution and enhancing software performance.
Overview
24
24
years of professional experience
Work History
Data Engineer
LCS
01.2021 - Current
- Conducted troubleshooting to identify root causes of issues so team members working on ETL could implement effective resolutions in a timely manner.
- Gathered, defined and refined requirements for a few source systems.
- Worked on building a few Azure Synapse pipelines.
- Worked on designing test plans using Azure DevOps. for source systems (20+ source systems), Pipelines and Data validation associated with each source system.
- Worked on building queries , procedures , views and automated scripts for QA process -both on Snowflake and SQL Server and used Jira board to track those bugs so they could be communicated with the team on a regular basis.
- Helped in the migration of OBIEE (Oracle Business Intelligence) Data warehouse to SQL Server and helped in the transition to the new LCS Insight Analytics Dashboard.
- Worked on supporting BI data warehouse, OBIEE/OAS (Oracle Business Intelligence) prior to the migration of OBIEE Data warehouse to SQL Server.
IT Solution Developer (Full Time)
LCS
04.2017 - 01.2021
- Implemented effective testing strategies to ensure high-quality products and minimize defects.
- Maintained accurate documentation of solution design specifications and implementation details for future reference or updates.
- Collaborated with cross-functional teams ( Oracle HCM, Oracle Financials, Payroll,URM) for successful project delivery, maintaining clear communication throughout.
- Worked extensively on Absence Management Module and helped in the migration of Accrual Plans from Oracle EBS to Oracle HCM initially independently and then in partnership with outside consultants.
- Worked on Oracle Financials in partnership with vendor-partner for Oracle upgrade.
- Worked on feeds to Oracle HCM, as it pertained to time clock and 401k data integrations.
- Worked on knowledge transfer for Oracle HCM Absence , 401K Data and Time clock integrations.
- Worked on supporting in house custom solutions on Oracle like Stock System, Direct Deposit,Positive Pay.
- Worked on enhancements for URM platform.
IT Solution Developer(Part Time 30 Hours )
LCS
06.2013 - 03.2017
- Increased customer satisfaction by providing timely and efficient support for software issues
- Worked on developing new custom Accrual Plans on Oracle- EBS -Absence Management System and supporting existing Accrual Plans. Managed approximately 100+ Accrual Plans.
- Worked on supporting and developing custom code for Oracle Financials and custom code for Oracle EBS- Payroll.
- Worked on supporting existing reports and enhancements of custom reports on the EIS express Oracle Reporting Tool.
IT Solution Developer (Part Time - 20 Hours)
LCS
11.2004 - 05.2013
- Worked on Oracle EBS with a focus on Absence Management. Was responsible for configurations of accrual plans , creation of Absence elements , writing fast formulas associated with accrual plans. Created and managed approximately 80 + Accrual Plans.
- Worked on the design and development of custom solution for Oracle EBS-(Direct Deposit Process) Designed , implemented and supported a new secure technology used to transmit files from Company (LCS) Servers to the Bank’s server.
- Worked on migration of Discoverer reports to EIS Reports.
- Overall, enhanced software performance by optimizing code, reducing bugs, and streamlining processes.
IT Analyst
ADP
08.2000 - 10.2002
- Developed custom solutions for clients, tailoring technical specifications to meet unique needs related to File transmission processes.
- Worked with various file transmission methods like Connect Direct, FTP and PGP File transmission.
- Worked on file transmission scripts , developed shell scripts on Unix Platform for automated file transfer. Managed approximately 30+ incoming and outgoing files.
- Re-engineered existing transmission process to promote ease-of-use and improve system security.
Education
Bachelor of Engineering - Computer Science
Birla Institute of Technology , Mesra
Ranchi, India06-1995
Skills
- SQL and Relational databases(Oracle, SQL Server, SnowFlake)
- Data Analysis
- Data Quality Assurance
- Analytical Thinking
- Teamwork and Collaboration
- Multitasking Abilities
- Attention to Detail
- Problem-solving abilities
- Reliability
- Adaptability and Flexibility
- Continuous Improvement
Timeline
Data Engineer
LCS
01.2021 - Current
IT Solution Developer (Full Time)
LCS
04.2017 - 01.2021
IT Solution Developer(Part Time 30 Hours )
LCS
06.2013 - 03.2017
IT Solution Developer (Part Time - 20 Hours)
LCS
11.2004 - 05.2013
IT Analyst
ADP
08.2000 - 10.2002
Bachelor of Engineering - Computer Science
Birla Institute of Technology , Mesra
Similar Profiles
Silvia MoralesSilvia Morales
Laboratory Analyst at LCSLaboratory Analyst at LCS
Annette MaguAnnette Magu
Social Media Intern/CNA at LCSSocial Media Intern/CNA at LCS
Jessica QuillJessica Quill
Executive Director at LCSExecutive Director at LCS