Project Manager Data
Resume:
Angel Sudario
Brentwood CA, ***13
************@*****.***
________________________________________________________________________
Highlights of Qualifications:
________________________________________________________________________
• Proven management, team lead, system architect, technical advisor, QA lead tester, data quality implementation expert, business analyst, project manager, data modeler, and end to end SDLC project implementation skills
• 20 years business experience in Finance, Data Quality, Marketing, Compliance, Health Care and Manufacturing
• 20 years SAS system development and system implementation experience
• Passionate self starter with an entrepreneurial spirit and exceptional team player
• Strategic thinker, solution oriented, mentor
• Pragmatic and results oriented
• Basel II, WF Credit Policy, and SOX experience.
________________________________________________________________________
Technical Skills:
________________________________________________________________________
SAS Software Products: Base (18), SAS Enterprise Guide (2), Access (15), Macros (18), SCL (7), Frame (2), AF (5), FSEDIT (4) Procedures (18), FSEDITOR (5), Stat (3), Graph (3), SQL (15), Tabulate (10), Report (5), ODS (6)
Other Languages and Tools: OS/JCL (18), TSO (18) VSAM (2), COBOL (1), Easytrieve (1), Access (3), Visual Basic (2), Rapid SQL, Toad, Bachman(2), QMF, Cronjobs (2), Scripts(1),FTP Editor, MDM
Databases: DB2/UDB (7), Oracle (15), Teradata (2), MS SQL Server (2), DB2 (15)
Operating Systems: UNIX, Mainframe, Windows, Solaris
Microsoft Tools: Word (15), Excel (15), Power Point (5), Project (7)
SDLC Development and Test Software: JIRA (2), Clear Quest (4), SharePoint (5)
Junior Level Language: Java J2EE, JavaBeans, Eclipse ______________________________________________________________________________________
Wells Fargo Banking Systems Experience
______________________________________________________________________________________
MDM, FDR PO, FDR East, EIW, EDW, ADW, ACLS East, CAR, Recovery One, Hemisphere, IDS, West FDR, Mini Master, Micro Master, Capitol Markets, Hogan, Star, CORE, CORE Upload, D11B, SASPROD1, EO, COD, DFL, STS, LIS, Post Closing, AIMS, CODA, Finance, Fidelity, SHAW, FDS, Integrated Solutions, and ACAPS.
_____________________________________________________________________
Wells Fargo
_______________________________________________________________________
From 8/10 to Present WBR Risk Management: Sr. Basel II SAS System Architect 6, 18 Month Contract
• As high level team member, assist in the design and maintenance of SDLC development artifacts. Attend walk through sessions during all system development phases of the project. Experienced in developing System Integrated Methodology; Project Stake Holder Business Requirements, Data Definition Business Requirements, Functional Specification Design Documents (data mappings, rules, and technical design), Master Test Plans, Test Cases, Data Quality plans, Business Cases, and Change Requests.
• Design hardware and software SAS infrastructure on SASPROD1 Unix systems for WBR Basel II data mart. Partnered with team members, obtained SAS architecture sign-off and working on implementing the solution.
• Help create and maintain project timeline, the SAS data mart is currently on time and on budget.
• Model SAS database logical design. Integrate East and West data into one data infrastructure.
• Create and automate SAS ETL, SAS production jobs, data structures used for statistical data model development, and quarterly Basel II submissions data for Corporate Credit.
• Automate production jobs that create submission to Corporate Credit.
• Design and implement production control procedures.
• Document SAS data mart, project specifications, and infrastructure design.
• Create master test plan.
• Perform and oversee Integrated System Testing (IST).
• Oversee User Acceptance Testing (UAT).
• Implement SAS data mart into production; ensure data quality techniques and controls are adhered to.
• Oversee the metadata management of the WBR SAS Basel II Data Mart.
________________________________________________________________________
Nursing Gowns Internet Company Web Based Apparel
________________________________________________________________________
From 1/10 to 8/10: Angel Sudario SAS Consulting Inc. /Project Manager, System Architect:
• Designed and delivered a SAS marketing data mart to support direct marketing analytics, business intelligence, and DM campaigns.
• Led the system design, testing, implementation, and continued with the SAS data mart’s on-going maintenance.
• Implemented Data Quality techniques that include; profiling, cleansing and data integrity checks.
• Designed in SAS direct marketing analytic reports.
• Created in SAS automated list services include exclude and waterfall reporting functions.
• Create ad-hoc reports.
________________________________________________________________________
Wells Fargo
________________________________________________________________________
From 11/06 to 08/09 TOG: Sr. SAS Applications Systems Engineer 5/Data Quality Implementation Expert:
• Maintain artifacts and system specifications throughout the system life cycle of development projects.
• Ensure SDLC artifacts are compliant, identify and document risk factors that impact systems in master test plans.
• Managed the implementation of Data Quality solutions on several large development projects.
• Improve data confidence and reduce risk to the business by implementing Data Quality solutions and standards.
• Partner, support, and mentor system architects, project managers, development teams, test teams, and lines of business about Data Quality standards and prevention techniques..
• Design project specifications for the SDLC utilizing IM Artifacts, BRD, DFD, FSD, project timelines, business cases, project funding, create test plans, and Data Quality plans.
• In SAS, Oracle, SQL, and MS Access, test Data Quality solutions on systems using Data Quality tools after implementation.
• Using SAS software, re-engineer code, perform end-to-end, valid value, data integrity, and audit trail testing.
• Profile and cleanse data, report and resolve data integrity issues using SAS.
• Log in JIRA, triage, and resolve data defects during IST and UAT test cycles.
• Design SAS macros that automated pass fail, audit trail, and data profiling reports continue to use as reuse code for new projects.
• Design SAS, Access databases, VBA, and Excel tools that track data anomalies during test phases of a project.
• Implement and test Data Quality prevention and recovery techniques.
03/05 to 11/06 Hemisphere Database Team Consultant, Contract with CCG Home Equity:
• Successfully led the SAS IDS to EDW data conversion effort on Hemisphere for the project team.
• Managed the Hemisphere Oracle database monthly release schedule, performed analytics on Hemisphere data in SAS, gathered functional business requirements, wrote project specifications, compiled timelines, designed IST and UAT test plans, executed tests using SAS and other software.
• Coded and provided ad-hoc statistical marketing reports, data models, and campaign mailing lists in SAS for the marketing staff.
• Mentored less experienced team members how to code efficiently in SAS. Worked with EDW to improved data quality, data modeled new EDW data sources for the Hemisphere marketing team.
09/01 to 02/05 SAS Team Lead /Senior Consultant, Contract with CCG Home Equity:
• Led the conversion of over 50 marketing campaigns and reports from SHAW on MVS to UNIX DB2-UDB IDS data warehouse. Mentored staff and trained them how to use new technologies and how to code in SAS.
• Designed data models, inclusion/exclusion logic, and waterfall reports in SAS.
• Standardized the way marketing programs were coded in SAS, audited and how direct marketing programs’ results were tracked for our program management business partners.
• Performed database analysis and reported anomalies using SAS/Access. Researched, tracked, and reported data integrity issues that impacted the business; followed up on fixes.
• Led and mentored all team members on how to code SQL, SAS, Oracle, DB2-UDB, and navigate in UNIX. Worked with system administrators helped IDS configure SAS properly on the UNIX server. Automated twice weekly and support programs via scripts and cron-jobs.
• Developed and executed month end and daily production programs that produce files for campaign support.
• Created a small marketing data mart in SAS for the direct marketing team.
03/00 to 08/01: Team Manager: Contract with Credit Card Services, direct marketing list services SAS Oracle, and Mainframe.
• Managed a team that performed over 60 monthly SAS non-monetary list preparations, and SAS statistical ad-hoc reports. Mentored staff, managed work effort and performed business analyst functions for new marketing lists.
• Prioritized and delegated work assignments, created and maintain project schedules, assisted with programming, and management reporting.
• Helped model the Oracle Promotion database.
• Communicated weekly to management the status of campaign executions. The environment was fast paced and required challenging deadlines and accuracy.
• Evaluated employees performance helped them strive for excellence.
______________________________________________________________________
Bank of America / Kaiser / Pacific Bell
________________________________________________________________________
06/99 to 12/99 Senior Marketing Consultant, 7 Month Contract with Marketing Household:
• Re-engineered Household Marketing Reports developed in FOCUS and Excel into a relational DB2 database.
• Analyzed, documented, coded, and tested programs that created over 41 monthly production reports in SAS.
• Designed SAS macros that automated the way data was extracted by date, designed macros that searched the DB2 sub-system tables, automated the search of proper table names and columns for data analysis and program design. Created SAS
• output files and convert them into Excel spreadsheets, these spreadsheets were then converted to BI reports on the Intranet.
02/99 to 6/99 Kaiser Walnut Creek, Senior SAS/AF Programmer Consultant, 5 Month Contract Y2K:
• Performed compliance reviews on batch and online production systems written in SAS and SAS/AF/SCL. Identified and remediated non-compliant dates.
10/97 to 01/99 Senior SAS/AF Programmer Consultant, 18-Month Contract, Time Management:
• Maintain Pacific Bell’s project management time reporting system, 4000 users developed in SAS/AF.
• Developed and implemented new SAS/AF system modules and releases, fixed technical system problems, provided technical support, coded ad-hoc reports upon user request.
• Developed conversion programs that converted SAS data into files for a WEB/ORACLE application.
• Coded HTML on the WEB to maintain documentation that pertained to the application.
___________________________________________________________________________________________________________
Kaiser Permanente Health Care PMO ________________________________________________________________________
1/95 to 10/97 Livermore, /Project Manager SAS/AF and Reports Developer:
• Responsible for leading PIMS redesign effort and project teams, mapping documentation, project specifications, data modeling effort, re-engineering pharmaceutical data, development, and implementation of the DB2 Drug Reporting Database, managed all subsequent releases. Database size was 63 million records.
• Developed and maintained SAS/AF formulary drug reporting system. Developed several client server applications that produced ad-hoc reports and graphs for health care professionals.
• Produced in SAS complex statistical ad-hoc reports for Drug Education Coordinators and other health care professionals within the organization.
11/92 to 01/95 Walnut Creek, Northern CA Sr. Senior SAS Business Analyst /SAS Project Manager:
• Managed and delivered several development projects using SAS and other software within the organization.
• Hired and managed the work of several SAS contract programmers.
• Provided third level SAS technical support to programmers and end users, designed ad-hoc reporting systems, wrote ad-hoc reports for finance, personnel, administration, management, and various health care professionals.
• Designed and delivered MVS/TSO/JCL and SAS training classes for end-users.
• Evaluated PC software and made recommendations regarding company standards.
• Traveled the Northern California Region designed specifications for new IT projects.
• Implemented automated solutions that solved manual or systematic business problems.
________________________________________________________________________
Hewlett Packard ________________________________________________________________________
09/85 to 11/92, Hewlett Packard Santa Clara Technical Team Manager:
• Responsible for managing the work of three development teams. Duties included:
o The re-engineer of Hewlett Packard’s warehouse distribution systems into a consolidated data Warehouse Distribution System.
o Designed a DB2 distribution-reporting database with a Windows client as the front end user interface
• Mentored staff and evaluated employee performance.
• Wrote SAS and QMF reporting systems for manufacturing users.
• Managed communication and resolved issues between eight functional business teams and the IMS/VSAM development teams.
Contact this candidate