John Ostheimer Email & Phone Number

Wilmington, De

Senior functional and technical data analyst ensuring the accurate alignment of technology with business objectives at a 3rd party financial services debt management provider for top global bank clients. Deploy technical solutions to meet client data analysis expectations and service level agreements. Member of team responsible to develop, design, test and implement SAS programs using both SAS and Microsoft SQL databases.● Perform data analysis with high complexity in support of ad-hoc customer requests and new customer onboarding.● Work with customers to define requirements and ensure designs meet the business objectives. ● Develop SQL and SAS queries and reports for analyzing and presenting data.● Solve time sensitive production issues to meet customer delivery expectations.● Deliver both external and internal audit initiatives that call for data extracts and reports.● Responsible for migrating the running of batch jobs from Windows Task Scheduler to HelpSystems AutoMate scheduling package.● Participate in Code Reviews and Mentor for junior SAS developers and Interns

CRM Implementation, Software Development, Systems Analysis, COBOL, JCL, IMS, DB2, MS SQL, Documentation, Data Mapping, Data Scrubbing, Waterfall SDLC, ACAPS, ETL, SAS, VBA

Newark, Delaware

Senior analyst team member with responsibility to develop, design, test and implement customer relationship management (CRM) business system solutions. Prepared project plans, technical requirements, unit and system test plans, and scripts, and change control documentation using corporate approved SDLC templates.• Led system integration analysis, requirements analysis design and testing support as Sales Logix CRM application migrated to Salesforce SaaS application● Delivered System Admin support for SalesLogix thick client that included user setup and retirement, installing the SalesLogix application on remote desktops, cutting and installing remote databases as needed.● Managed data mappings and defined interfaces for downstream systems for conversions to SalesForce cloud environment and consolidation of local solutions to enterprise SalesLogix and OracleCRM standards. ● Created data maps, scribe jobs, Microsoft SQL Views, functions and statements, converting data from SalesLogix to Oracle CRM On-Demand system.● Functioned as technical lead for conversions of client data from diverse formats (iAvenue, ACT! and Excel) into SalesLogix CRM application using Scribe ETL tool, MS ACCESS and SQL tools, consolidating information into one package. ● Prepared documentation for” train the trainer” activities in support of global system conversions.

Developed high quality technical solutions that addressed needs communicated by business clients. Worked as part of a team to develop, design, test and implement business system solutions. Prepared Clear Choice, technical requirements, time estimates, unit and system test plans and scripts using approved Risk Based Project Management templates.

Provided high quality technical solutions that addressed needs communicated by enterprise-wide business clients. Provided analytical and technical support for a SalesLogix client server CRM package, versions 5.2 and 6.1, and mainframe Customer Information System (CIF).