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.
• 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.

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.
• 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.

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).