Applications Developer Reporting Specialist
Life Storage
2022.06 - 2023.07 (1 education.year_Label & 1 education.month_Label)
Hi, I’m
JANNETTE JONES
Data Engineer
Tulare,CA
Summary
Results-driven SQL Data Engineer with a proven track record in creating complex SQL procedures, developing SSRS reports, and designing efficient ETL processes. Skilled in collaborating with stakeholders to analyze data needs, troubleshoot processes, and implement business-driven solutions. Ready to leverage my expertise to drive data-driven strategies and contribute to the success of your organization.
Work History
Life StorageBuffalo, NY
Applications Developer Reporting Specialist
2022.06 - 2023.07 (1 education.year_Label & 1 education.month_Label)
Job overview
- Developed reports, analytics, insights,SSIS packages and visualizations development to top-level management executives using SSRS in Visual Studio.
- Formulated realtime reporting informative table structures that met business requirements using time series modeling.
- Assessed and created data modeling, database normalization, database management technologies, and optimization and performance tuning using SQL column store indexes and table partitions.
- Actuated, re-factor, and enhance Tableau application reports using custom template according to company specifications.
- Evaluated data to identify potential issues within ETL pipelines, notify end-users, and propose adequate solutions.
- Analyzed complex business problems and implement solutions for CRM Axxerion platform using scripts.
- Created and follow processes and procedures to ensure maintainable application development, including source code management, automated build processes, and appropriate documentation.
- Analyzed impact and effectiveness of Axxerion UI changes on Customer Relations Managers retention and identified features of users behavior and implemented additional menu modifications in Axxerion CRM system.
- Implemented workflow automation in Axxerion work order management CRM system at the functional and organizational levels.
- Assisted with scripting complex business rules in Axxerion CRM system.
- Integrated constructive programs into cohesive Axxerion CRM product.
- Designed, developed, and implemented software applications for website based on analyzed requirements and understanding of industry technical standards.
- Designed reusable and reliable code for use within distributed cloud environments.
- Revised, modularized and updated old code bases to modern development standards, reducing operating costs, and improving functionality.
Total Expert
Senior Data Engineer
10.2021 - 03.2022
Job overview
- Develop multi-table SQL procedures to extract loan data from Total expertise back-end database for their customer reporting and development of customer loans outreach programs.
- Develop SQL parameter based, custom CODE, SSRS reports for intervention and corporate level customer performance level reporting.
- Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
- Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
- Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Designed and developed analytical data structures.
Nichols Farms
SQL Analyst/Data SAP Analyst
10.2020 - 10.2021
Job overview
- Created and provided a monthly management report to top-level management executives.
- Devised and deployed predictive models using machine learning algorithms to drive business decisions.
- Fine tuned SQL queries that met company AG production requirements and assisted in providing real - time production information across all departments.
- Streamline the use of large data tables in Sage X-3 reducing the . data across Nichols Farms company systems.
- Established and managed large spreadsheets with a framework that allows for R Integrations and temporal series modeling.
- Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate data solutions
- Managed and optimized databases by using SQL column store indexes and table partitions to implement database design, data engineering, data modeling, and database normalization
- Maintained and ensured the integrity of information on the Sage X3 CRM system.
- Identified system process improvement opportunities as they relate to data Sage X-3 integration.
SAP, Leprino Foods
Database Developer
11.2015 - 10.2020
Job overview
- Designed advanced SQL Queries and stored procedures
- Created, Maintained, Modified, and optimized SQL Server databases
- Ensured assigned tasks are completed within the TIME frame established by the project plan.
- Collected and analyzed data to evaluate existing and potential product and service markets by providing tactical marketing and analysis support to business clients
- Performed extensive project profiling, segmentation, and manufacturing product lifetime value analysis
- Identified opportunities, prospective plant continuous improvement patterns to generate high revenue
- Developed and Optimized Stored procedures and functions using T-SQL.
- Understood business requirements and converted them into quality SQL code for database specific projects
- Monitored SQL Server and tuned poor performing SQL scripts.
Education
University Of Advance TechnologyPhoenix, AZ
Bachelors of Artificial Intelligence from Artificial Intelligence
07.2023
Southern Careers Institute PoweredSan Antonio, TX
By WOZ-U Certificate in Mata Science
10.2020
University of New YorkEast New York, NY
Bachelor of Applied Science from Information Technology
05.2001
Skills
- Azure
- SQL and SSRS
- HTML
- JavaScript
- Skilled in Using Python
- HTML and XML
- Tableau
- A/B Testing
- SSRS
- Sage X-3
- NET CORE 50
- Interface Design and Implementation
- R
- Python
- Databricks
- Pyspark
Timeline
Senior Data Engineer
Total Expert
10.2021 - 03.2022
SQL Analyst/Data SAP Analyst
Nichols Farms
10.2020 - 10.2021
Database Developer
SAP, Leprino Foods
11.2015 - 10.2020
University Of Advance Technology
Bachelors of Artificial Intelligence from Artificial Intelligence
Southern Careers Institute Powered
By WOZ-U Certificate in Mata Science
University of New York
Bachelor of Applied Science from Information Technology