SAS Developer/IT Professional with over 20 years of experience in design and development in various environments involving complex relational database design, development, enhancements, and management. Extensive experience in automating processes and data quality control with analysis, design, and maintenance of large, and multiple systems as well as vendor package support. Considerable experience with coding in SAS and SQL, data mining, combining data from multiple platforms, statistical modeling, and integration/regression testing. Have worked with very large datasets, analyzes, and synthesizes into meaningful conclusions / recommendations. Diverse work experience in IT. Lead SAS Developer recognized for excellence in the creation of detail design specification documentation and the timely delivery of high-quality, customer-focused solutions. Senior IT Team member sought out and respected for technical abilities and broad business knowledge. Proven ability to interact with individuals at various functional levels within the organization in order to design and implement quality IT solutions for business and technical enhancements or challenges. Business Analyst with 10+ years experience in the health benefits industry with proven ability to deliver high performance technology solutions to challenging business processing and reporting needs. Recognized for initiative, dedication and ability to effectively analyze workflows, improve processes, and implement quality assurance environments through development and automation. Project Management with 5+ years experience including larger projects. Knowledgeable in all phases of System Development Life Cycle (SDLC) and Six Sigma DMAIC methodology. Change Acceleration Process and Six Sigma Greenbelt Certified. Work recognized as best practice and used as a model for other projects.
Principal SAS Developer January 2007 to CurrentEvaluation Systems, PEARSON － Hadley, MA
Other Technical Experience: SQL Server Management Studio.
Microsoft Office (Word, Excel, PowerPoint, Access, Project).
Past experience with Unix, VAX, Mainframe, Lotus Notes , LaTeX.
Skills: Complex relational database design, querying and working with large tables (DB2), combining data from different sources.
Responsible for data analysis, reporting and data transfer according to client deliverables for major clients.
Code complex statistical formulas relating to measurement criteria.
Maximize program efficiency.
Evaluate, design and implement quality control related to scoring calculations and automated processes related to production.
Create, document, validate, process, and maintain statistical programs and reports with high quality.
Lead SAS developer responsible for data analysis and reporting,.
Provide technical guidance, share knowledge and experience with SAS team members.
Selected accomplishments Re-engineered legacy SAS programs as project migrated to new scoring system on SQL server with complex relational database design.
Re-engineered existing programs to run more efficiently reducing CPU time and resources.
Quality Control.Develop quality control processes to verify score calculations, data integrity, data file and report results, and scoring computations.
Build reports in Excel utilizing macros, pivot tables, and visual basic code in order to steamline and automate results and eliminate errors.
experience in analysis, design, development, and testing applications in a highly technical and quantitative field.
Responsible for validating on-line client reporting system (ResultsAnalyzer).
Consultant for automation to improve manual processing and controlling accuracy.
Able to develop new functionalities and implement new models in a complex combination of SAS and SQL implementation Production batch jobs.
Statitiscal reporting related to testing.
create, document, validate, process, and maintain statistical programs and macros that generate analysis datasets, tables and graphics with high quality.
eProductivity Project Leader January 2006 to October 2007GENWORTH FINANCIAL － Windsor, CT
Transferred to lead Eligibility Imaging and Workflow project following the SDLC model that eliminated paper from processing eligibility transactions, implemented an electronic workflow system in eProcess including random QC, and established an historical tracking and electronic document archive database using FileNet.
Lead multiple projects to add functionality to existing Web applications used by client administrators, brokers and internal users.
Identified opportunities for automation.
Developed / recommended solutions to urgent business processing and data management needs.
Selected accomplishments Directed cross-functional teams in multiple locations working directly with Image COE, IT, contractors, and off-shore resources to deliver results as required and on time.
Communicated progress to Senior Leadership team and conducted project reviews with Legal, Finance, and Compliance Leaders.
Prepared documentation including project proposal, risk assessment, cost benefit analysis, and multiple generation project plan.
Wrote business requirements, developed functional specifications including process maps for software development, and reviewed and approved technical design documents.
Re-engineered manual process to deliver a straight-forward, automated system in eProcess that created accountability and increased efficiency and time-service, and reduced cost.
Leveraged knowledge from established workflow concepts acquired from previous projects.
Created a dynamic, transferable model to accommodate different work sources.
Wrote Service Level Agreement and negotiated vendor contract that delivered project under budget.
Documented and lead test team to ensured functionality, data loads, and legacy system updates.
Instructed, directed, and checked the work of testers.
Used data mining techniques to verify test results.
Worked as technical liaison to establish relationship and advise clients on file structure and data requirements during development and testing of National EDI files.
Reviewed, validated and verified test files and communicated results.
Increased electronic customer base by 28% in six months.
Developed repeatable audit program using SAS that compared electronic data files from clients to system data and produced a discrepancy report that reduced audit review time by 90% and achieved 100% accuracy in system updates.
Method was also used to verify production updates.
Systems Consultant July 1997 to December 2005GE Financial － Greenfield, MA
Promoted to consult on software development initiative.
Identified automation opportunities such as process re-engineering, testing for system enhancements and database updates, quality / compliance assurance, and reporting.
Excelled at driving change by delivering results that exceeded expectations.
Resolved complex application use issues.
Administered databases in SAS, Access, and Lotus Notes.
Wrote business specification, test plans, and perform testing for system changes and enhancements.
Worked with business and recommended solutions using structured, transferable methodologies that increased efficiency, accuracy, and reduced cost.
Selected accomplishments Business Project Leader for the Dental Benefits Imaging and Workflow project following the Six Sigma DMAIC model that eliminated paper from processing claims, created a web-based data entry tool with real-time system calls in eProcess, and created an electronic document archive and historical tracking database using FileNet.
Facilitated meetings, lead JAD sessions, wrote business requirements, implementation plan, test plan, and training material.
Lead user acceptance testing.
Designed, developed, and maintained data entry and workflow systems for the Dental and Medical Benefits departments using SAS PC (Base, Proc, Macro, FSP, DDE) with DOS call routines and Excel including macros.
Business Analyst for National EDI Dental Claim project to accept dental claims electronically.
Wrote business specifications, test plan and lead system testing.
Developed a Drug Re-pricing database in Access to re-price medical drug claims that reduced cost by over $6M annually by analyzing data from Micromedex and applying statistical methods using SAS.
Implemented a monthly update process to realize maximum savings.
Developed an audit program using SAS to verify actuarial data calculations used in claims adjudication by analyzing health insurance data (HIAA) and applying relativities.
Developed complex reports for state regulatory, compliance, and quality reporting.
Mentored three employees in relational database structure, SAS programming, and writing SQL code to extract data for research and reporting.
Data Analyst/Database Administrator August 1992 to July 1997PHOENIX HOME LIFE － Enfield, CT
Managed sales quote, commissions and sales databases for the Group Sales and Marketing Department in the insurance industry.
Responsible for data analysis and reporting.
Selected accomplishments Collected, validated and verified quote and sales data compiled from Mainframe and VAX systems using SAS.
Calculated commissions, bonuses, and sales leader's data.
Built and maintained databases using SAS.
Extracted and combined data from multiple platforms using SAS PC and Viewpoint on the Unix system for analysis and reporting to support Sales Force, Actuarial and Underwriting departments.
Developed statistical models for forecasting sales goals and worked with senior management to modify commission formula and develop bonus programs.
Education and Training
Bachelor of Science : Mathematics, 1992University of Massachusetts － Amherst, MAGPA: GPA: 3.6/4.0 Cum LaudeMathematics GPA: 3.6/4.0 Cum Laude
Associates : Arts and Science, 1990Holyoke Community College － Holyoke, MAGPA: GPA: 3.7/4.0Arts and Science GPA: 3.7/4.0
automate, automation, Benefits, budget, Business Analyst, Consultant, CPU, client, clients, Data Analysis, data entry, data management, data transfer, data mining, databases, database, documentation, DOS, driving, EDI, senior management, FileNet, Finance, forecasting, functional, graphics, DB2, Image, Imaging, insurance, Leadership, Legal, Lotus Notes, Macros, Mainframe, Marketing, meetings, Access, Excel, Microsoft Office, PowerPoint, Word, ODS, developer, pivot tables, pricing, process re-engineering, processes, Programming, progress, Project Leader, proposal, quality, Quality Control, real-time, relational database design, relational database, reporting, research, risk assessment, Sales, SAS, SAS 9.4, SDLC, Six Sigma, Service Level Agreement, software development, specification, SQL, SQL Server, structured, tables, training material, Underwriting, Unix system, Unix, VAX, VISIO, Visual Basic, Web applications, Workflow