(617)
501-4520
jpasterick@hotmail.com
summary
§ Solutions Architect and Tech Lead with over 14 years’ experience designing and developing business and system solutions. Has delivered solutions for Global 2000 clients in the Financial Services, Insurance, Transportation, and Pharmaceutical industries.
§ Solutions have focused on OLTP applications, Customer Relationship Management, Sales Force Automation, Business Intelligence, Data Warehouse, eCommerce and automated chemistry.
§ Hands-on technical. Expertise and leadership skills in enterprise architecture, application architecture and development, performance tuning, business analysis, database design, and database administration.
Technical Skills
Databases
and Operating Systems
Oracle 9i,
Oracle 8i, SQL Server 7.0/2000, Sybase, Solaris, Windows 2003/XP/NT/ 2000/95,
Windows 3.1.
Technology
Microsoft .NET, VB.NET, C#.NET, Visual Basic 6.0, Microsoft Visual C/C++ 6.0, MFC, PL/SQL, Java, JSP, Microsoft Transaction Server, Internet Information Server, Apache Web Server, Active Server Pages, Siebel 2000, ADO, XML, UML, Rational Enterprise Suite, XSLT, PHP, VBScript, JavaScript, Win32 SDK, Korn Shell, ActiveX, DCOM/COM, PowerBuilder 4.0, SQL, Informatica.
Clients
Clients have included AIG, Bank of America, Columbia Management, Marsh, St. Paul Travelers, Pfizer, Fidelity Investments, Wachovia, USPS, POLK, Liberty Mutual, Putnam Investments, MetLife, Surge Industries, Synapse, Transamerica, Corbis Motion, LongView Group, Bennett and Company, and eReturns.
Experience
1/06 – Present Axis
Technology,
Senior Architect
§ Evaluation and full development life cycle engagement of a Mutual Fund Management and Revenue Aggregation system for Wachovia. Responsible for defining business requirements with the business owners, architecting the system, data architecture, technical client relationships, data migration, and the complete design and build of the database. The system was built using Java, Oracle, Informatica, and Siebel Analytics.
§ Led the architecture, database design, data analysis, and data governance for an aggregated central holdings database for Columbia Management. Responsible for defining the business requirements, architecting the system, database design, data profiling, data analysis, and data governance process of the system. The system was built using Oracle BI, Netezza, and Ab Initio.
§ Responsible for data analysis, load performance enhancements, process improvement, and development of a CRM system for Bank of America. This system, which manages personal banking and investment account data on one platform, was built utilizing Oracle and Siebel.
4/05 – 1/06
Solutions Architect
§ Responsible for defining the technical architecture, translating clients’ business issues and problems into technology solutions, lead technical reviews and requirements definitions with clients, and recommending enterprise technologies and tools
§ Roadmap engagement for St. Paul Travelers. Established a clear vision of how the claim organization and its business partners will integrate to improve overall business performance with enhanced claim management information. Focused on organizational changes, process changes, enterprise data warehouse architecture, and information exchange.
§ Evaluation and architecture engagement of an integrated common application platform for Fidelity. Define and architect the components for replacing the current disparate set of applications, processes, and systems with an integrated set of services and capabilities. . Integration components include portfolio management, document management, research, collaboration and event management, and document assembly.
6/04 – 4/05 Surge
Industries, Inc.,
Solutions Architect/Project Manager – CRM and Client Payroll Processing – Consulting Assignment
§ This business-critical, PEO system is improving Surge’s business processes by increasing the effectiveness and efficiency of its workforce and enhanced client management.
§ Served as the Project Manager, Architect, developer, and DBA.
§ Performed system analysis, documented system requirements and design specifications, developed project plan and managed deliverables, formulated corporate technology strategy, and designed IT infrastructure.
§ Technical environment included Microsoft .NET, C#, SQL Server 2000, XML, Crystal Reports.
10/02 – 6/04 Foster-Miller,
Inc.,
Project Leader/Technical Lead/DBA – Pfizer – Pharmaceutical Automation Lab – Consulting Assignment
§ This business-critical, automated pharmaceutical lab project is revolutionizing how this pharmaceutical company performs drug testing, using robotics and software, by automating a totally manual process.
§ Served as the Project Leader for the main controller component that managed and monitored the entire automated lab system.
§ Wrote document design specifications and developed applications to FDA standards.
§ Served as the DBA leading the data modeling, database design and development, and data management.
§ Technical environment included Microsoft .NET, C#, Oracle 9i, XML, COM, ActiveX and UML/Rational tools.
5/02 – 10/02
Solutions Architect – Marsh – Insurance Data Mart – Consulting Assignment
§ Data warehousing and reporting project. The project objective was to leverage the centralized data warehouse to support the regional office's needs related to analyzing revenues, premiums and aged receivables.
§ Led the gathering of the technical requirements and the design of the test and production environments.
§ Served as the team member leading the database development, the systems testing, uncovering data issues, and recommending solutions to support the business and technical requirements.
§ Technical environment included Oracle 8i, PL/SQL, Informatica, and Business Objects.
10/01 – 4/02 AIG,
Software Architect Consultant, Data Warehouse and Campaign Management System – Consulting Assignment
§ Led the architecture, design and development of converting a packaged Unix-based data warehouse to Windows 2000. The information-based marketing system has numerous supporting applications and is being implemented globally. Technology included Solaris, Oracle 8i, SQL Server 2000, VB, SQL, and Korn Shell.
§ Led the analysis, architecture, design, and development of Marketing Campaign Management System that can be configured to run on top of any data warehouse within the global AIG firm. Technologies include VB, Oracle 8i, Korn Shell, and SQL Server 2000.
§ Responsible for full project life cycle from requirements and design through QA and deployment. Developed project plans, project schedules, documentation, system architecture, and source code while performing code reviews, developer management, and design documents for developers.
5/01 – 10/01 Fidelity
Investments,
Architect Engineer, Strategic Advisors Inc. Group – Portfolio Management Systems – Consulting Assignment
§ Responsible for performing a technical audit of the 30+ disparate applications produced by the group. This included a critical assessment of the inefficiencies of the applications, developing a new system architecture, meeting with the business users to gather business requirements, designing application enhancements, and resolving process flow issues.
§ Responsible for the design and development of a portfolio management application using VB, ASP, XML, XSLT, COM, and Sybase. This system is used to manage the department’s high-profile clients.
4/99 – 5/01 iXL/Tessera
Solutions Architect - Sales Force Automation, CRM, and Order Entry System
§ Performed as the Technical Team Lead, System Architect, and a Lead Business Analyst of a 12-person team that designed and developed a sales force automation, CRM, and order entry system.
§ This multi-tier system was built using Siebel 2000, VB, and Oracle 8i.
Solutions Architect - Merchandise Returns and Logistics System
§ Led a 10-person team that designed and developed a web site for customers to return products on the web. This system was integrated into the web sites of retail merchants to provide seamless return functionality for customers of the particular merchants.
§ This multi-tier system was built using ASP, VB, Oracle 8i and Lawson.
Solutions Architect - Operational Data Store/Data Warehouse – National Transportation Data
§ Led the design and development of a two-terabyte data warehouse. This system extracted, transformed, and loaded 20 gigabytes of data from the data warehouse to an ODS daily. The system runs on SGI Irix and was developed using Oracle, Korn Shell scripts, and C.
§ Designed and developed in Unix/C++ a detailed algorithm that determined a vehicle’s status (new, used, in-use, junked, etc.) and history from a national vehicle registration database.
§ Designed/Led development of a metadata-driven, production-quality job control system. Important features include job dependencies and load-balanced execution.
§ Led a team of developers who designed and developed a web application for governing marketing campaigns. Also served as the business analyst on the project. This system was built using Apache Web Server, Oracle Application Server, JSP, and JavaBeans.
Senior Software Engineer – Data Warehouse – Insurance
§ Led a team that designed and developed a CRM data warehouse system that receives feeder files from various legacy systems, loads and transforms the data into the warehouse, utilizes cubes and OLAP tools to generate reports, and finally, emails the data to individual users.
§ Responsibilities included designing the load process using parallel processing and data warehousing techniques, writing PL/SQL to transform the data, and designing and developing the cube, report, and email generation system. The system was built using Oracle 8i running on a 12 processor Sun Solaris machine, C, PL/SQL, Korn Shell, Informatica, Cognos PowerPlay, and Visual Basic.
2/99 – 6/99 Putnam
Investments,
Database Technical Lead - Mutual Fund and Cash Reconciliation System – Consulting Assignment
§ Responsibilities included designing the database, developing the PL/SQL for transforming and loading the data into the database, writing algorithms for matching the reconciliation records, stored procedure and package development, database optimization, and supporting the data access of the web based GUI.
§ The system utilizes Oracle 8.0.5 running on a Sun Solaris machine.
2/99 – 6/99 Municipal Management Inc., Marlboro, MA
Technical Lead, Municipal Tax Management Application – Consulting Assignment
§ System replaced an existing mainframe application that supported municipals’ real estate and personal property tax transactions, delinquency tracking, and bill printing.
§ Responsibilities included designing the system architecture, development of the online system (web site, application server, and database), and managing the efforts of four developers.
§
This system was built as a three-tier,
client/server system using VB 6.0, COM,
6/98 – 2/99 Longview
Group, Inc.,
Technical Lead - Portfolio Management and Trading Systems – Consulting Assignment
§ Responsibilities included business analysis, system architecture, database design, stored procedure development and optimization, ActiveX server and component development (including a Blotter Database Refresh Engine), and GUI development.
§
This system was built using VB 6.0, SQL Server
6.5, Sybase System 11,
1/94 – 6/98 Edgewater
Technology, Inc.,
Senior Engineer/Technical Lead -
§ Performed the business analysis, system architecture, development of the CRM system, and managed the efforts of ten developers. Additionally served as the main point of contact for all database related issues as they pertained to application development and tuning, including stored procedure development (PL/SQL), query optimization, reporting, and data analysis.
§ The Customer Service System is a three-tier, client/server system that functions as an online transaction application using VB 5.0, VC 5.0, ATL, DCOM, ADO 1.5, ActiveX, Microsoft Transaction, and an Oracle 7.3 database on a Sun Solaris machine. System has a Web based front end, in addition to the VB front end, using MS Internet Information Server, Active Server Pages, VBScript, and JavaScript.
§ C++ was used to develop the Unix-based processes for order entry, billing, fulfillment, etc. Information World recognized this application as the 15th of the Top 100 IT Innovators for 1998.
Senior Engineer/Technical Lead –
§ This client/server system was developed using an Oracle 7.1 database on Windows NT. The front end was written in C++, utilizing MFC and Crystal Reports API.
§ Responsibilities: designing the logical and physical database design, designing the GUI, designing the system architecture, developing numerous stored procedures (PL/SQL), performing numerous database administration processes, management of four team members, and developing several key object-oriented, front-end components.
Senior Engineer/Technical Lead – International Order Entry, Material Planning and Logistics System
§
This order entry, materials planning, and shipping
system provided an international garment manufacturer with MRP capabilities in
§ Responsible for the application’s client architecture, designing system architecture, developing stored procedures, and conducting business analysis with the client.
Engineer, Network Operation Management System
§ This system provided the U.S. Postal Service with a logistical command center during high-volume holiday shipping seasons. The system encompassed all aspects of logistical support from command console and workstations to decision support functionality for logistics optimization.
§
The system has been featured in several industry
publications, and has been showcased by the Vice President of the
§ Responsibilities included design of the GUI interface, analysis, and application development. This client-server system was written using C++, MFC, CTI, and accessing MS SQL Server.
2/93 – 1/94 The
Wyatt Company,
Programmer/Analyst – Human Resource Management
§ Responsible for system development, system support, and client consulting. The software was developed on various platforms, using C, MS Access, MS FoxPro for Macintosh, Clipper, and Cobol.
5/92 – 12/92 Hewlett-Packard,
Programmer/Analyst Intern – Information Technology
§ Developed and supported internal systems. Technological tools applied to the systems were Borland's InterBase database and C on a Unix platform and Cobol and MVS JCL on an IBM mainframe.
EDUCATION
1993,
B.S., Computer Information Systems
Oracle Education Classes
Oracle 7 Database Administration and Oracle 7 Performance Tuning Workshop
Siebel Education Classes
Siebel eBusiness Essentials
Certifications
Microsoft Certified Solutions Developer (MCSD) and Microsoft Certified Product Specialist (MCPS)