Resume of: Cynthia Smith-Schenkel

acvrnx@r.postjobfree.com, Cell 585-***-**** / 585-***-****

Overview:

I am a results oriented individual and can quickly assess a business problem or opportunity, envision a solution that incorporates new technologies, lead a high performance team or be a productive member of one. I successfully deliver results that consistently delight customers. . I provide a solution and the ability to solve problems with work flows, productivity, or quality and display information and knowledge in a way that is understandable and valuable.

As a Business Intelligence Technical Architect and Sr. Software Engineer/Developer, I am familiar with all phases of the definition and delivery lifecycle from a technical perspective and ensure the technical integrity of the design and implementation of the Transaction, .NET/BI solutions and Data warehouse system. I am able to evaluate and learn emerging technologies and products as they mature as well as write and develop future applications.

Technical skills/Certifications:

.NET Application Developer and Architect of .NET DASHBOARDS (Assignee on Patented products) for Health Care, Financial P&L, Distribution, and Asset Management systems: SQL, NoSQL, Data Analytics and big data architectures, including Hadoop, Columnar data stores such as HBase, Parquet, Vertica and other big data querying tools such as Hive, Impala. .NET DASHBOARDS across MSDN, Oracle, SAP, Peoplesoft with complete role base security that passes all CMS, Corporate, Hipaa, and SEC Audits. .NET custom Dashboards with custom Widgets/Branding. Also Tableau and Qlikview plug ins for Server Applications. Robust and secure Websites complete with Role Base Security, Prodictive Analytics.. Master in J2EE, Springs, Struts, Hibernate, Java Script, C#, VB Script code. Visual Studio and all FRAMEWORK Master Developer., Also RESTful web and Big Data architectures, Precision BI, IIS Web .NET, ASPX and ASP’s, VB, Jscript, C#, HTML, XML, Custom Forms, Dreamweaver, Shell Scripting. Custom Graphics. Branding, Digital Photography, collages, specialized graphics. Cloud Computing, 2008 and higher webserver platforms. Framework 1,2,3,4,5. Javascript/JQuery, C#, COM, LDAP, YUI 2/3, Alfresco, Restful Webservices, Spring MVC, VBScripts, XML, XSLT 2.0, Apache Tomcat / HTTPD, Linux, Rake, MySQL, Freemarker. N-Tier Architecture and JEE Servlet Container Master. SharePoint, Sql Server DBA. Apache Hadoop framework. DevelopSAP BOBJ& BI Launch Pad web application.

Certified Microsoft Developer & MSDN Datawarehouse Architect. Health Care and/or Financial P&L, Distribution, and Asset Management systems using MSDN 2008r2/08, 05, MS SQL Procedures, FTP, DTS Pkg’s/SSIS Pkgs, ADO, OLEDB. DBA & Production Job Control. Complete System DBA/Procedures and Performance specialist. Also XML, Analysis Services, Visual Studio 2005/08/10/12/13 & ETL software. Specialize in precision performance.

Certified Oracle/UNIX DW Developer and Architect: Health Care and/or Financial P&L, Distribution, and Asset Management systems using Oracle Development –Unix, OLAP, Custom Data Warehouses, Applications, Forms. Financial, Marketing, SUNGARD Education Systems. Oracle 7.2.3, 8i, 9i, 10G and Oracle 11i Forms, & 11G, TOAD, Enterprise Manager, SQLPLUS, PL/SQL procedures, packages, functions and performance tuning along with DBA and Security. Unix, VI. Kornshell scripting, Crontab, PERL. Also have modeling and Fact/Dimension complete systems.

SAP DW Developer and Architect of Health Care and/or Financial P&L, Distribution, and Asset Management systems & the Cost Accounting Modules using SAP. ABAP . SAP Business Objects, SAP ABAP WebDynpro, SAP BW / BI, SAP BODS, SAP BPC, SAP SCM,SAP SRM, SAP Security, SAP ABAP, SAP ABAP HR, SAP ABAP Workflow, SAP NetWeaver, SAP EP Development. SAP BOBJ& BI Launch Pad web application

Resume of: Cynthia Smith-Schenkel

Operating Sytems & Complete DBA master: MSDN 12,08,05,00. Blade & cache performance, UNIX, Windows. IBM AS400, Teradata, IBM DB2, MS Access, Informix. Performance tuning, functions, triggers, shell scripts, run control

INFORMATICA-9.5, Cognos, Cognos TM1, Cognos Plng & Budg,Cognos, Discoverer, Crystal, and Hyperion Essbase reporting Cubes. DATASTAGE-8, Ab Initio, MicroStrategy, MSBI, OBIEE, Hyperion Interactive.

Graphs custom widgets, statistical reports.. Web Sites, ASP’s and .NET(ASPX) forms with backend data base procedures. ZEBRA Bar Code. Excel/Access with VBA programming

Business Modeling, Metrics and Architecture in:

EMR modules :EPIC inpatient, outpatient,Billing. GE Flowcast and all feeds. I mapped the GE Flowcast system and transferred from mainframe to sql server, FRS, ALLSCRIPTS, MEDENT .

Financial P/L Actuals, Plan, Outlook, Marketing, Payroll, and Cost Accounting Systems, Materials & Asset Management Systems. Complete P&L reporting. MSDN, Oracle, SAP, Peoplesoft, Hyperion ESSBASE, Excel and Access VBA.

Project Management and Systems Development experience and IT Security. MSProject and working to get new Certifications in COBIT 5. Currently passed Corporate Security requirements on all development versions and custom built fire Walls and Role Base Security application and Tables within applications.

SEC Audit Requirements on Financial Systems. Passed all audits at Xerox, Kodak, B&L.

Sarbanes Oxley Compliance models. Specializing in Financial Systems.

FDA Compliance Models. Used for Bausch & Lomb Patents and Processes.

Healthcare Compliance to HIPAA and all Payer & Operational Audits:

CMS and Medical Home Healthcare Metrics. Data Governance Teams.

NCQA Quality Healthcare Metrics

HEIDIS Quality Healthcare Metrics

Primary Care Organization Work Flows and Quality Dashboards. Technical design, programming/architect for URMC Quality Dashboards. Payer & Operational Audits

Education:

Attended Night School for a BA in Computer Science at Rochester Institute Technology.

Regents High School Diploma H.W. Schroeder High School, Webster, New York.

Certifications upon request.

Work History:

2011 to present:University of Rochester Medical Center ISD & Primary Care Division:

Sr. Software Engineer/Developer and Architect of the Primary Care EPIC/Flowcast Medical Home Dashboards & PC DataWarehouse providing Daily workflows to practices and physicians along with compensation, medical grants and studies helping healthcare providers and Primary Care Practice organizations transition from fee-for-service volume to value-based reimbursement and accountable care delivery. Data Gov. for Primary Care, Accountable Health Care Partners, AC5, Strong Pediatrics, Highland Family Medicine, Flaum Eye Center, Strong Cardiology, OBGYN, ORTHO, and Geriatrics. All 3 hospitals with multiple input sources including EMR EPIC transactions, Billing & Claims, Payer Claims Files, MEDENT, Thompson Health, Strong, Highland,AHP Organizations. Designed for each ROLE and consistently pass all Payer, CMS, Hipaa Audits. ACQA, NCQA.

Resume of: Cynthia Smith-Schenkel

Work History Continued:

2010-2011 University of Rochester project Developer, Sr Programmer and Analyst Web Services/Decision Support HAMFC Group. Mapped GE Flowcast, FDR BAR from mainframe to SQL Server. RE-wrote code to SQL Server Procedures and online dashboards.

2007-2009 University of Rochester project Developer, Sr Programmer and Analyst on FRS Funding and Project Team Systems Development. Implement & customize the SunGard Fund Raising & Higher Education Application System for UofR. Provided technical Programming and Multi Platform expertise for the implementation of the Advancement’s SunGard Fund Raising and Gift of Memory System at the University of Rochester. Included additional development of ORACLE pl/sql procedures UNIX Kornshell scripts, and modifications to SunGard Packages along with Branding for the University of Rochester. Provide training, testing, and demo environments to development staff and End User/Super User community. Provide Custom Home Pages and other customizations and additional edits and validations within the SunGard product for UofR. Also provided JAVA scripts and ADVANCE Configuration set up and deployment of the WEB and NT tools. In addition, used Harvest to manage source code and migration through the development life cycle.

2007-2008 LPA Software Consultant for Xerox and UofR Accounts:

Xerox Corporation, Corporate Finance and the Global Finance Re-Engineering effort., Oracle and INFORMATICA-9.5, Cognos, Cognos TM1, Cognos Plng & Budg,Cognos, Discoverer, Crystal, and Hyperion Essbase reporting Cubes. DATASTAGE-8, Ab Initio, MicroStrategy, MSBI, OBIEE, Hyperion Interactive. Support for ESSBASE reporting and hierarchy re-statements for Corporate Finance..Work using VBA with Excel and Access and Essbase. Generate Cubes and use Report Analizer for financial reporting of P/L line items in different hierarchy re-statements to support the Global Re-Engineering for Global Finance decision support and SEC reporting. Also for COGNOS Reporting and Crystal Reports.

As BI Dashboards and Datawarehouse Technical Architect at XEROX North American Financial (NAF) Reengineering Projects XGS FIX System to New XPRO Financial System as Architect for Oracle OWB 10G, OLAP Application, Relational Data Warehouse and Discoverer Reporting tools Multiplatform System in Oracle 10G and JAVA). Also pl/sql procedures and functions to be embedded in the new system. My position was Architect, Document/build System and Business Specifications SLA, SLR /Data requirements and Fact requirements, Functions, Hierarchies. INFORMATICA-9.5, Cognos, Cognos TM1, Cognos Plng & Budg,Cognos, Discoverer, Crystal, and Hyperion Essbase reporting Cubes. DATASTAGE-8, Ab Initio, MicroStrategy, MSBI, OBIEE, Hyperion Interactive.

2006-2008 Eastman Kodak Company Sr. Software Consultant & Developer for World Wide Cost Accounting and Management Information System (CMIS). This project was conceived to address the needs through the development of a worldwide cost management information system. The existing system also needed to be SOX compliant. Using SAP and Oracle & ETL together to provide a better cost and operational data system worldwide to support Financial Analysts and Management. Created the database objects and mapping from source systems (SAP, AMAPS, Fourth Shift, other legacy and operational systems). Extracted and loaded into the operational data store (ODS) within the Oracle databases. Successful completion of all PL/SQL Stored Procedures and promoted to production. Gain user sign off and

Resume of: Cynthia Smith-Schenkel

Work History Continued:

2006-2008 Eastman Kodak Company (continued)

implementation. Created and tuned the stored procedures, views, objects and Scripts to tune the Network performance. Oracle 9i & 10g, OEM, QuestToad, SQL Optimizer, IBM-AIX, Sun Solaris

2004-2006 Kodak R&D as Sr.Software Engineer-. I worked in the R&D division at Kodak generating adhoc customer reporting, feeds and applications using PL/SQL, VBA in Excel and Access, Com Scripting to build additional Network capability. Data taken from Oracle Supply and Inventory Systems & R&D Labs recipe files. Also created Zebra Bar Code Labels for the LABS.. My coding included MS-SQL, SQL*Plus, PL/SQL, VBA, HTML, VB6, ASP, ADO., ADO.NET, ASP.NET Aso C, C++, Com+ and RAD Pro C.,Windows NT Shell Scripting.. Unix Oracle DB, NT, and SQLSERVER2000. Also helped on a conversion effort from Unix Oracle to Sql Server .net framework..

2003-2004 Bausch & Lomb Clinical Study Group for Statistical Reporting. Statistical Programmer for the Clinical Study Group Writing in both PL/SQL Unix (The datawarehouse) and PCSAS using ODBC for Statistic Reporting on Clinical data to gain FDA approval on Optical (surgery) and pharmaceutical data. . PL/SQL mainly for qualifications and data mining.

2002-2003 Thomson Rueters in Toronto: Sell Financial Dealer Rooms and Product Portfolio items. Work to get Rueters Key Software products in Software Migration and Software Product Compliance Media. This included demonstrations how Rueters Products and Software can be included in Oracle Portfolios, PeopleSoft, SAP, and MSDN. Software Stock Trading Software for Rueters Tokyo Stock Exchange, Canadian Stock Exchange and London Stock Exchange. Customers included CITIBANK, McDermot Oil to name a few.

2001-2002 W2 Sigma Marketing Corp Sr. Software Engineer/Consultant: Programming support for the Xerox Account. Software support for customers using Dunn & Bradstreet and other Marketing Data Bases. Used Sqlserver2000, NT and the Unix Server.. Wrote scripts as required in MSSQL, VB6, & DTS Packages for the SQL Server applications and PL/SQL for Unix/Oracle, PC/SAS as required. Set up Data Bases, functions, triggers, reporting, and feeds creation for the Xerox Account and Field reporting.

2001 W2 EDS Corporation Sr. Software Engineer. MSDN Sql Server DBA, Oracle DBA, INFORMATICA-9.5, Cognos, Cognos TM1, Cognos Plng & Budg,Cognos, Discoverer, Crystal, and Hyperion Essbase reporting Cubes. DATASTAGE-8, Ab Initio, MicroStrategy, MSBI, OBIEE, Hyperion Interactive. Converting Sybase programs to Oracle PL/SQL programs and MSRS Visual Studio 2005 reporting solution /Cognos/Crystal and ASP/ASPX(.NET) for the EDS Assets World Wide System. Converted over 100 programs and coordinated retreival of Sybase programs to be converted to pl/sql programs for world wide regions. Trained EDS workers. SQL Server, UNIX, VS 2003/2005 and MSRS reporting tools, SYBASE, Block SQL code.

2000-2001 EDS. Outsourced from Xerox as Senior Software Engineer / Developer Corporate IM

Global Data Warehouse Group at the City Center in Rochester. Lead Oracle Software Developer and Architect of the Xerox Global Financial Data Warehouse known as the Profit System and also the Xerox Activity System and Asset Management System. Work included the creation of the Business Proposal documents, Requirements, pl/sql Code for the conversion of Mainframe and DB2 Data Bases (Cobol2/SQL) to ORACLE (7.2.3 & 8i and Sun Solaris Unix System). Set up cubes and generate ESSBASE Reporting System. Project also included migration of Plan data from Excel applications to Oracle. This was a world wide development project.

Resume of: Cynthia Smith-Schenkel

Work History Continued:

1997-2000 Xerox Corp. Corp IM Data Warehouse Group. Senior Project Lead and Developer for the HR and Payroll Data migration. Develop System Specifications, programming, Core member of the Design and Architecture team because of my expertise in Oracle, PeopleSoft, and MSDN skills. Code PL/SQL scripts, create, load tables, indexes, reporting and feeds. Schedule & implement per MS project plan. The Global Oracle HR Data Warehouse was responsible for all feeds (Over 300 nightly) in and out, tax & benefit calculations and all HR reporting. This was a successful conversion effort from IMS MF to Unix Oracle Data and included set up, install, and production implementation and scheduling. Provided support to another firm that put in the Peoplesoft Payroll Application..

1977-1997 Xerox Corporation 20 years. Corporate IM Professional at Xerox: Individual Contributor, Sr. Systems Developer and Manager Xerox Engineering Systems Division and ISD Sr Software Engineer for the migration from Mainframes to Oracle and Server Platforms. Sr Datawarehouse Developer and Reporting for Xerox Corporate Cost Accounting System World Wide. Always 100 Percent pass of all SEC requirements.

XES East Coast Business Systems and Financial Reporting for

Provided Financial and Marketing reporting, feeds, and end user System for XES Financial Analysts. Provide decision support Reporting and analysis for Promotions, Achieve Pricing and other business strategies along with Profit and Loss actuals, outlooks, and plans..

Corporate IM HEC, CAPS, AECS, CRR, EPR, EBS, Supply Chain

Senior Programmer/Developer:

HEC Cost Accounting System, Tax System, General Ledger National Cash

CAPS/AECS (Admin and Distribution System) and EPR Planning System

CRR/EBS Revenue and Billing.

MLS/MALS Materials Management and Procurement, Production Planning PIP

FWSS Service and XSS Supply Chain

References available upon request.

Contact this candidate