SUMMARY:

• Senior (VP level) IT / technical business analyst / project manager working on data and systems projects in both IT and business organizations:
• Experienced in all phases of SDLC/PLC from initial conversation and analysis through development, testing, implementation and production support.
• THIRTY years in IT as Business Analyst (FIFTEEN years), Development & Data Analysis Team Lead (ELEVEN years), Developer (TWENTY years).
• Data Analysis, Systems Analysis, Process analysis, Business Analysis with Project Management (Certified PMP).
• SQL, Excel, Access, Visio, Quality Center, Oracle, SQL Server, Business Objects.
• Energetic, go - getter, yes-we-can-do attitude (accustomed to working in fast-paced environments).
• Excellent analytical, organizational, communication and interpersonal skills.
• Certified PMP, Six Sigma Greenbelt, Certificate in Project Management, Certificate in Client Server Programming, BBA in MIS.
• BA Skills: Business requirements/BRD, documentation, gap analysis, technical requirements, functional specs/ FRD, process design, workflow analysis, process diagrams/flowcharts, JAD sessions, testing requirements/scripts, data quality, production support, root cause analysis.
• Data Skills: Data requirements, sourcing, data mapping, data analysis, data modeling, data warehouse / relational database (Teradata, Oracle, Access, DB2, SQL Server, Sybase), SQL, IT Skills.

TECHNICAL SKILLS:

Web: HTML, JavaScript, VBScript, ASP, CSS, Adobe Photoshop.

Client Server/Windows: UNIX, C-shell, Perl, C, C++, PowerBuilder, Visual Basic.

Mainframe: TSO, COBOL, ISPF, SPUFI, EZTrieve, JCL, Proc, CICS, VSAM.

Software: Quality Center, Visio, SharePoint, TOAD, SQL Assistant, SQL Server Management Studio, MS Office, MS Project.

PROFESSIONAL EXPERIENCE:

Confidential - Sleepy Hollow, NY

Sr. Business Analyst Consultant

Responsibilities:

• Process analyst / systems analyst / Solutions analyst - Review and document end-to-end current state of legacy business and information systems targeted for platform upgrade, including automated procedures, manual procedures, workflows and dataflow; Identify gaps; Recommend improvements. Consult on problem processes to provide guidance, perform root cause analysis and implement solutions.
• MS Office (Excel, Project, Visio, Word), Lotus Notes, SharePoint, Mainframe, Oracle, SQL Server.

Confidential, New York, NY

Sr. Business and Data Analyst Consultant

Responsibilities:

• Instrument and Client Account Reference data - Liquidity Risk Liaise between business partners and IT technical teams to acquire new data sources, remediate instrument master and client account reference data quality issues. Work with business partners to elicit requirements and author requirements documents. Work with technical team to design, test, implement technical solutions and ensure solution meets business needs. Author BRDs, FRDs, testing documents. Open and/or remediate defects; Perform data analysis of instrument master waterfall and client accounts reference data. Participate in end to end testing.
• Oracle, TOAD, MS Office (Access, Excel, Project, Visio, Word), ALM, SharePoint.

Confidential, New York, NY

Sr. Business Process and Data Analyst Consultant

Responsibilities:

• Accounts Reference Data systems, Finance Change Management Perform business and data analysis activities necessary to establish a golden source for trading accounts hierarchy and reference data maintenance from multiple dissimilar systems: identify scope, reconcile/migrate/ synchronize data, decommission legacy systems. Business analysis, BRD, GUI design, detailed data analysis, data flow diagram, data mapping, data transformation rules, proof of concept, business and technical SME interviews, face off with IT and middle office, author and execute test plan and test cases for unit, SIT and UAT.
• SQL server, Access, MS Office, Visio, MS Project, TSO, Sybase.

Confidential, New York, NY

Senior Business Systems Analyst Consultant

Responsibilities:

• Participate in requirements for new Client Onboarding and Account Opening systems; Perform legal entity data analysis for Dodd Frank; Function as an internal consultant and IT SME: Regulatory and business rules analysis: current/future state analysis and diagrams, gap analysis, BRDs; Business process modeling, data and access entitlements, common modules definition & modeling (SAAS); Data investigation: Data analysis, data mapping across multiple systems, data flow.
• Oracle, SQL Server, Access, MS Office, PowerPoint, Visio.

Confidential, New York, NY

Business Data Analysis Team Lead Consultant

Responsibilities:

• Worked within the newly-formed data services group as analytical resource, Subject Matter Expert and team lead responsible for acquiring and analyzing data sources in regulatory reporting automation program and enterprise contract, balances, positions data warehouse; Managed a team of 9 analysts; Worked with globally located clients and staff.
• Elicited business and data requirements from customer; Created/maintained project plans; Identified data sources; Reviewed data standards for required elements.
• Created map of data elements between contract/reference data source systems and enterprise data warehouses (data mapping).
• Reviewed data profiles created with Ab Initio; Perform gap analysis.
• Acquired contract and reference data; Conduct analytical discussions with and coordinate interaction between business customer, operations, IT.
• Participated in testing; Document and report findings to senior management; accomplished signoffs; Calculated and presented analytical metrics to senior management.
• Managed efforts of 9 offshore and onsite project team members.
• Mainframe, Teradata, Oracle, SQL Server, MS Office, PowerPoint, Access, Visio, MS Project.

Confidential, Charlotte, NC

Sr. Business Analyst Consultant - Retail Credit

Responsibilities:

• Team member participating in Basel II project as BA representing Basel data warehouse, Responsible for sourcing credit risk data into enterprise data warehouse from origination, servicing and loss/ recovery application systems for input into risk calculator.
• Gathered and documented business requirements, data mapping, data transformation, participating in JAD sessions, SQL, data verification, problem resolution, root cause analysis.
• Discovered and resolved errors in project prior to deployment which would have made a $22B portfolio unusable, saving bank $1.1M in correction costs. Six Sigma projects.
• Mainframe, Teradata, Quality Center, Oracle, SQL Server, MS Office, PowerPoint, Access, Visio, MS Project.

Confidential, Charlotte, NC

Sr. Business Analyst Consultant - Retail Banking

Responsibilities:

• Gathered business requirements, translated business needs into system requirements for development and QA teams.
• Created documentation.
• Coordinated UAT process and worked within defined SDLC.
• Web, client server, Access, .Net, Smalltalk, UNIX, mainframe.
• Sr. Technical Analyst - Bank, Finance, Treasury, Balance Sheet Translated business requirements into functional/technical specifications using COBOL, SQL, DB2, EZTrieve, UNIX and Perl.

Confidential, Tampa, FL

Consultant - Insurance

Responsibilities:

• Architected and implemented commissions structure, agent ids, licenses, certifications & reference information: Gathered business requirements from external client; Performed gap analysis, data analysis, data mapping, reconciliation; Created and executed test plans, verified results, tracked defects; Directed the activities of 4 programmers; Coordinated systems changes across IT and business areas; Developed reporting and ETL processes.
• Access, COBOL, DB2, VSAM, EZTrieve, SyncSort, JCL, SQL, and FTP.

Confidential, Bergenfield, NJ

Web Designer/Developer

Responsibilities:

• Gather business, technical requirements, produce sample designs, negotiate client contracts, provide follow-up support, respond to client inquiries, and explain technical concepts.
• Design, create, and implement Web sites using HTML, JavaScript, Dreamweaver, Flash, Fireworks, Adobe Photoshop, and Adobe ImageReady.

Confidential, Jersey City, NJ

Senior Analyst/Developer

Responsibilities:

• Responsibilities included gathering business requirements, producing functional and technical documents, creating Web pages using HTML, ASP, JavaScript and VBScript, writing UNIX and Perl scripts, database design, ETL processing, writing and optimizing SQL stored procedures and queries, writing COBOL, DB2 and IDMS programs, performing quality assurance, providing first-line post-implementation support and providing production support for legacy systems.
• Consolidated multiple stockbroker ID systems into a single system, allowing brokers a complete view of anticipated and historical compensation. Gathered business requirements, performed initial analysis, created functional and technical documents, designed database structures, created batch interfaces and overnight processing, created Web pages for real-time updates, coordinated data cleanup with business clients.
• Created various MS Access databases including table design, queries and reports.
• Converted millions of trade transactions from mainframe (COBOL, DB2, and IDMS) to Sybase (ETL processing).
• Worked with team to set up user entitlements based on brokerage team associations.
• Close/reopen month-end processing with broker paycheck calculation and interfaces to payroll and PeopleSoft HRIS: Gathered business requirements, created functional and technical specs, coded Web pages, stored procedures, UNIX and Perl scripts.
• View and update broker reference data, calculate paychecks, and set up special compensation deals: Coded Web pages, stored procedures, UNIX and Perl scripts.
• Wrote and executed unit, systems, functional, parallel and regression tests.
• Participated in creating system manual and training users.
• Was responsible for a distributed processing asset management fee system consisting of a PowerBuilder front end and a Sybase and IBM mainframe back end. Duties included gathering business requirements, designing solutions, writing business and technical documents, coding PowerBuilder programs and Sybase stored procedures, training user, providing user support, and performing PowerBuilder version upgrades.
• Provided IBM mainframe systems support:
• Responsible for all IDMS issues including production support, version upgrades, new programming, and program updates.
• Participated in mainframe disaster recovery planning and drills.
• Created and maintained COBOL and DB2 programs.
• Created systems procedures using MVS/TSO, JCL, FileAid, and SyncSort.

Confidential, Ridgefield Park, NJ

Technical Specialist

Responsibilities:

• Produced mapping documents and technical specifications.
• Performed extensive data analysis, cleansing, reconciliation, reporting, testing to ensure data integrity.
• Coded pilot system in Visual Basic and Access to re-engineer mainframe system.