Jay B. Email & Phone Number

Phoenix, Arizona, United States

Minneapolis, Minnesota, United States

Primary Technologies: Microsoft SQL Server, SQL Server Integration Services (SSIS), Amazon Relational Database Service (RDS). • Develop, test and implement ETL packages within Microsoft SQL Server SSIS along with creating stored procedures and ad-hoc queries.• Analyze performance of database queries and take action to correct deficiencies• Trouble-shoot and correct data load exceptions or inaccuracies• Load and perform data validation procedures/checklist for participant and performance data on assigned programs and data migrations (on-premises SQL Server to AWS RDS/EC2 ETL SQL Server)• Research and create “proof of concepts” to evaluate potential infrastructure improvements (ex. AWS) • Introduce and implement source control management (SCM)/version control management (VCM) concepts.

Remote

Primary Technologies: Amazon Web Services (AWS), TerraForm, PostgreSQL, Docker, Apache NiFi* Assist in new client FHIR resource onboarding/ingestion for July 1st compliance deadline.* Setup AWS EC2 instances and PostgreSQL databases to meet various requirements.* Perform data analysis and mapping. * Configure Apache NiFI DataFlows to load and convert Health Care data in compliance with FHIR standards.

St Paul, Minnesota, United States

* Primary Technologies: Amazon Web Services (AWS), Google Cloud Platform (GCP), Linux (Ubuntu), Docker, Python, Flask, Apache, NGINX, uWSGI, VS Code. * Explore cloud deployment pipelines for a Python Flask JavaScript web app.* Propose and implement best practices ex. using github.com for version control.

Minneapolis, Minnesota, United States

• Primary Technologies: SQL Server 2014 & Visual Studio 2017• Analyze business applications and their data to identify sensitive information.• Review the information with its owners & work with them to determine a remediation plan.

Anoka, Minnesota, United States

* Primary Technologies: SQL Server Reporting Services (SSRS) & C# * Perform enhancements to existing SSRS reports.

Minneapolis, Minnesota, United States

• Primary Technologies: Visual Studio 2013, C#, VB, SQL Server & SSDT-BI• Share .NET related knowledge with less experienced developers.• Set up TFS and development environments i.e. select versions of Visual Studio/SQL Server Data Tools.• Manage architecture, development and deployment of all back-end databases.• Design, build and maintain ETL jobs for data warehouse using SQL Server Integration Services (SSIS) packages.

Minneapolis, Minnesota, United States

• Primary Technologies: SQL Server, SSIS-DT & Teradata• Review user business requirements, create functional system/report designs, design and code data extracts, develop and execute test scripts, and other functions in support of business objectives.• Collaborate with members of the Data, Analytics and Report Team and other risk professionals to migrate current manual data source load processes to a production environment.• Responsible for working with technical partners to assist in translating business needs into complex analysis designs and recommendations.• Identify and recommend internal and external data sources, compile/mine data from multiple, cross business sources.• Support the design and development of complex queries. Including prototyping new approaches to demonstrate target state views, as well as designing and developing short-term solutions to support immediate business needs.• Assist with validation/testing of data during parallel runs.• Ensure adherence to data management/data governance regulations and policies.Assist in the technical build-out and support of databases, query tools, reporting tools, BI tools, dashboards, etc. that enable analysis, modeling, and/or data visualization.• Act as an internal consultant within technology and business groups to re-engineer technical processes for greater efficiencies.• Modify/run PowerShell scripts.• Create SharePoint/SOAP requests.

Minneapolis, Minnesota, United States

• Primary Technologies: SQL Server, SSIS & SSRS & C#• Agile environment under transition to Waterfall• Create and modify existing ETL process/SSIS packages• Create and review project designs/docs• Create and modify SSRS reports• Review/create Business Requirement Documents/Use Cases/Datamapping • Support Data Warehouse

Minneapolis, Minnesota, United States

• Primary Technologies: TOAD, Oracle SQL Developer, SSRS & PeopleSoft• Utilize exceptional technical knowledge to consult with internal departments on complex systems, data or reporting challenges and opportunities or initiatives• Developing complex queries from administrative systems to audit the quality of the data, provide information for decision-making, automate manual processes or provide data sets to other IT teams• Evaluating and leveraging system functionality or conceptualizing technological solutions to accomplish critical data initiatives• Sharing knowledge of IT systems, business policy and practice, and reporting best practice and technological possibilities through consulting and other collaborative endeavors with internal employees • Monitoring the impact of upstream technical changes or business process changes on data and reporting systems

Minnesota, United States

• Primary Technologies: Visual Studio, VB.NET, TFS, SQL Server & Teradata• VB.NET/VS2012/TFS applications to support Store Planning Team• Created new classes/modules that seamlessly integrate into legacy systems and support existing applications• Imported, exported, updated data via MS SQL/SSMS• Performed SQL Server Admin functions.• Wrote MS SQL stored procedures and various store sales reports• Gathered Informal business requirements

Minnesota, United States

• Primary Technologies: SQL Server, SSIS, MS Access, MS Excel & VBA• Created MS SQL ETL scripts based on business requirements to load and perform calculations on confidential class action data• Identified and resolved data issues with BA and QA teams to ensure requirements are met and data integrity is maintained

Minnesota, United States

• Primary Technologies: VB.NET & SQL• Responsible for a new data exchange process that moved SKU level data between external vendors and internal business systems• Performed data mapping and integration of multiple sources to a single standard.

St Paul, Minnesota, United States

Collaborate with operational groups to facilitate operational efficiency gains via the identification of technical solutions* Participate in the development/enhancement of systems which support products and/or services * Conduct meetings to communicate project status and prioritizationParticipate in the review and recommendation of operational systems and procedures affecting assigned unitsMap and integrate disparate data* Generate productivity/ KPI charts and reports for management* Develop applications via Microsoft Access Databases utilizing VBA and SQL queries* Program MS Office macros and user forms* Pursue additional operational knowledge

St Paul, Minnesota, United States

* Identify and maximize opportunities to use information and technology to improve service and business processes* Coordinate with internal stakeholders to define project objectives and requirements* Determine and implement prescribed solution* Ensure project requirements are satisfied* Implement cross-system integration solutions involving data validation and complex reporting Support existing legacy, VB applications with extensive code-level troubleshooting, repair and maintenance

St Paul, Minnesota, United States

* Solution specialist for Corporate Trust/Wealth Management and Bondholder Services function* Researched, processed and resolved customer bondholder compliance issues* Designed applications to facilitate faster resolution of bondholder inquiries

Professional Certificate, Applied Data Science, 90.69%

Bachelor Of Arts (B.A.), Psychology, Business

High School/Secondary Diplomas And Certificates

Activities and Societies: Swim and Golf Teams