Jason Potocki Email & Phone Number

San Antonio, Texas, United States

Agile team lead that provides guidance and works with a cross-functional group to ensure successful completion of tasks and serves as a mentor for team members. Responsible for development, testing and deploying ETL (Extract, Transform, and Load) SSIS (Microsoft SQL Server Integration Service) packages and database changes utilizing Microsoft SQL Server and an agile delivery methodology. Participates in code reviews ensuring application design and related work products satisfy the requirements, improve quality and ensure compliance including refinement of requirements and design artifacts. Assists teammates to produce deliverables in compliance with standard procedures guiding the team in the design, creation and management of data structures, data transformation, data models, schemas, data quality, and workload management. Participates in execution of performance and automated testing for each new capability developed. • Utilize a Git Repository for source code and database script management• Utilize Microsoft Team Foundation Server for tracking and management of SSIS project initiatives• Application design utilizing PowerShell scripts, C#, Microsoft SQL Server, current DBMS technologies, Data Tools and Visual Studio• Design database schema to store and process data from various data sources• Create and maintain efficient SQL T-SQL queries, views and stored procedures to use with stored data• Extracting data from various applications and data sources to include Microsoft Excel, SharePoint, Intelink, Knoa, SAP HANA, Hadoop, Oracle DB, Business Objects, SQL Server DB, MongoDB, and HTTPS Web Services into the data platform• Defined file organizations, indexing methods, and utilized security procedures for the development of the applications

San Antonio, Texas Area

Responsible for recording system checks, documenting system details, installing new instances, installing service packs, installing security updates, and working closely with the IA team and other infrastructure teams to maintain compliance and functionality. • Evaluated and recommended available DBMS products to support validated user requirements• Applied Security Technical Implementation Guides (STIGs) for compliance• Defined file organization, indexing methods, and security procedures for specific user applications• Upgraded to current DBMS technologies and design to a clustered Microsoft SQL Server 2012 environment restructuring storage configuration utilizing uniform mount point design• Developed, implemented, and maintained database backup and recovery procedures for the processing environments and ensured that data integrity, security, and recoverability are applied.• Trained cross-functional team members in daily activities and troubleshooting process• Utilized SQL and PowerShell scripts to automate data collection and create daily system status reports• Provided ongoing progress to leadership, system owners, and peers regarding health of the environment and capacity planning• Created implementation documentation

San Antonio, Texas Area

Managed and developed a cross-functional team. Ensured team members had well defined objectives and monitored their progress against those objectives. Advised customers on matters related to overall business analytics and decision support solutions. Became subject matter expert in all vendor management and support processes. Managed projects from start to finish with business leaders, programmers, technicians and other engineering and project personnel to troubleshoot, analyze complex processes and make strategic business decisions; provided oversight on problem resolution issues and directed software installation.• Managed client expectations regarding system configurations• Monitored equipment functionality to ensure specifications were met• Developed and directed software system testing and validation procedures• Provided project turnaround expertise with emphasis on continuing customer confidence• Responsible for staff/account management, prioritization and forecasting• Provided delivery management to ensure customer satisfaction• Monitored project activities and advised staff of issues due to resource availability

San Antonio, Texas Area

Senior Software Developer able to lead in the phases of the software development life cycle including planning, analysis, resource estimation, development, integration, testing, documentation, implementation and training. • Communicated with end users to gather requirements, configure, test and debug with new and existing applications of basic to high complexity.• Identified, defined, and designed requirements into solution design and ensured implementation.• Provided work break down structures with cost and resource estimates.• Communicated development status, concerns and recommendations to management.• Led software development projects by managing timelines, configuration, testing, installation, debugging, training and customer satisfaction analysis.Senior Database Administrator certified in Installing, Configuring, and Administering Microsoft SQL Server. Highly skilled in database development, administration, analysis and ETL development. • Created users and assigned permissions based on the level of database access the user would need.• Designed database backup and restoration strategies for all customers and monitored jobs to insure regular performance and completion.• Created data replication of data from multiple locations to main location for centralized reporting tool.• Designed and created databases• Used performance tuning tools to improve response times of quires and reports.• Documented changes in database structures• Validated availability of sufficient storage on drives to support databases, backups, and batch processes.

San Antonio, Texas Area

C/C++ Programmer maintaining applications in both UNIX and Windows platforms. Helped reduce overdue projects and completed new requests. • Converted data management system for point of sale from FairCom c-tree to Microsoft SQL and Oracle.

• Graded semester projects and test for Assistant Professor, Kleanthis Psarris' Analysis of Algorithms.

Scheduled employees for daily operation and special events based on seasonal budget. Trained and evaluated employees to determine performance. Member of Sea World Environmental Action Team (SWEAT). Coordinated projects with park management, security and SWEAT.• Received Environmental Stewardship and Leadership Award for community involvement; multiple employee of the month awards and certificates of appreciation including an award of excellence.