Jason Franklin Email & Phone Number

Austin, Texas, United States

Reston, Virginia, United States

Contracting company, assignment was with GSA (General Services Administration).Developed new MySQL ETL processes for time-based loads, data accessibility, and reliability.Assisted in creating data flow diagrams for MySQL and Oracle ETL processes to enhance efficiency.Served as a technical expert on HR data warehouse implementation and development needs.Championed data management practices, enhancing consistency and quality in HR analytics.Analyzed OHRM data needs and coordinated with teams to streamline timelines.Reviewed and optimized queries for peak performance, enhancing data retrieval times.Configured and maintained Visual Cron job scheduler and Pentaho ETL application.Documented requirements and built reports according to those requirements.Designed and developed dashboards, scorecards, charts, pivot tables, and reports according to business requirements.Delivered ad-hoc reports under tight deadlines, as needed by the business.Estimated technical effort required to deliver assigned tasks.

Austin, Texas, United States

Developed automated reporting solutions utilizing SSRS.Conducted data mining for KPI reporting, delivering insights that drove strategy.Initiated workflow creation to monitor production changes and enhance productivity tracking.Crafted custom SSIS projects for complex data imports/exports to optimize workflows.Developed internal websites to improve access to vital information for leaders and clients.Automated data import/export tasks, reducing manual workload across databases. Mentored junior infrastructure members and analysts, significantly fostering skill development within the team while concurrently improving overall project outcomes.Provided daily on-site application support services, ensuring seamless functionality through prompt resolution of complex issues related to mobile devices and reporting needs.

Austin, Texas, United States

Maintained the Infor Syteline v9 on-perm and Syteline/CSI v10 hybrid environments for each business unit.Installed and tested upgrades and patches for all Syteline environments. Assisted with the development of a comprehensive plan to upgrade and transition from v9 to v10.Collaborated with vendors/external consultants to upgrade, design, configure, and test interfaces.Worked closely with managers/users in each department to plan and configure, deploy and train team members on CSI modules and features.Organized and scheduled application and mobile device training for users.Hands on experience focused on Purchasing, Order Entry, Factory Track, Pick-Pack-Ship, and supporting modules within Syteline.Helped improved company performance through report generation and data views that highlighted potential problems. Developed business reports using Mongoose Reports, SQL, Crystal, SSRS.Working knowledge of design, configuring, and processing orders using Portals.Development & extensibility programming with VB.net, C#, and SQLIntegrated third-party systems with Syteline, like UPS and FedEX.Customized forms within CSI like adding fields, adding a grid, and enhancing transactions within the system.Created IDO’s and built SQL queries used in those business objects.Created integrations to connect CSI to other business systems like data warehouses, WMS’s like Manhattan SCALE.Oversaw SQL database admin, EDI connections, and automation to enhance data management.Conducted data mining for KPI reporting, delivering insights that drove strategy.Crafted custom SSIS projects for complex data imports/exports to optimize workflows.Assisted with troubleshooting and debugging the Syteline environments.Managed user requests and resolved technical issues.Documented and updated database operating procedures.

Austin, Texas, United States

Synthesized Visual Basic knowledge from Access to VB6 to enhance application development.Trained new database users, along with internal team members, on essential programming suites and tools, thereby fostering a highly knowledgeable and proficient workforce.Crafted comprehensive internal business rules for daily operational functions, ensuring adherence to established data guidelines and significantly minimizing service disruptions.Identified critical process flow improvements that led to significantly optimized data source management methods, resulting in clearer and more comprehensive client ETL documentation.Produced comprehensive pre-import, daily, and post-export report summaries that provided critical insights into data integrity and performance metrics for enhanced decision-making.Designed custom client databases to enhance user experience and functionality.Leveraged database tools and programming to automate tasks and generate reports.Expanded proficiency in C# for .Net projects, enhancing versatility in programming skills.Mastered DTS/SSIS to automate tasks and generate customized Office reports efficiently.Streamlined database systems design and management, enhancing operational efficiency.Evaluated various database platforms, including MS Access and FileMaker, to meticulously assess their overall effectiveness and suitability for our specific project needs.

Information Resources Management

Information Management/Business Administration