Fe Silva Mendoza Email and Phone Number

Lead Software Engineer, ETL and SQL Developer at JPMorganChase Co• Developed algorithms to load and transformed (ETL) using SSIS for applications and reporting consumption.• Acquired and configured internal and external data sets from multiple sources that align with business and reporting needs.• Developed and maintained comprehensive data mapping and infrastructure solutions.• Ensured data integrity and compliance with data governance and security policies• Utilized SQL Development (SSMS, T-SQL) to create Data Manipulation Language (DML) and Data Definition Language (DDL) scripts, including tables, stored procedures, views, and functions.• Collaborated with database administrators during the migration to SQL server 2022, ensuring a seamless transition.• Utilized GIT for version control of scripts and code, and ServiceNOW (SNOW) for managing environment deployments.• Automated and scheduled ETL processes using Control_M and/or SQL Server Agent to enhance data processing efficiency.• Experienced in NoSQL technologies particularly DataStax and Cassandra DB, to support scalable data solutions.• Engineered innovative data design concepts to meet evolving business requirements.• Generated and maintained comprehensive technical documentations including architecture diagrams, to support development and operational initiatives• Performed knowledge transfer to team members

• Managed and mentored application developers and report writers.• Developed various application using Visual Basic, MS Access with SQL server backend, ensuring seamless integration and functionality.• Developed and executed data loading (ETL) processes using SQL Server Integration Services (SSIS) to transfer data from multiple sources into ERMS data warehouse.• Designed and implemented tables, views, stored procedures, and functions in SQL server (T-SQL) utilizing SQL Server Management Studio (SSMS).• Created insightful reports using Crystal Reports and COGNOS to support business intelligence initiatives. • Upgraded and converted SQL SSIS packages to higher version, enhancing performance and functionality.• Automated and scheduled ETL processes through Control_M and SQL Server Agent to streamline data workflows.• Provided support for business needs by generating ad-hoc reports using T-SQL and PL/SQL (Oracle) queries.• Configured internal and external data sets from various sources for Cognos Project and Frame Work Manager, facilitating data analysis.• Utilized Bitbucket and PVCS for effective code versioning and collaboration.

• Built a Robust Data Warehouse o Developed a reliable and stable data warehouse infrastructure capable of supporting multiple internal applications, including reporting tools such as COGNOS and Tableau.• Automated Data Loading Processeso Engineered automation and validation for manual data loading processes, significantly enhancing data efficiency and accuracy.• Optimized Performance o Developed and optimized SSIS packages and SQL queries (T-SQL), improving performance and meeting data loading and business reporting service level agreements (SLA).• Ensured Data Accuracy o Provided comprehensive data mapping documentation to the business, ensuring high levels of data accuracy and integrity• Facilitated Cross-Application Data Migrationo Established a structured data migration process across applications to alight with business needs and priorities effectively.• Enhanced Client Engagement o Accelerated client adaptation through diverse engagement strategies and collaboration across platforms, including interactions with vendor data.• Compliance with Data Governance o Successfully automate manual processes while adhering to data governance policies, ensuring data integrity and compliance.