SUMMARY:

• Business Analyst (CMMI Level 3), business systems analyst (BSA) and systems analyst.
• Project leader, data modeler, database designer, architect and developer.
• Experienced in Business Analysis, Requirements Analysis, Business Intelligence
• Experienced in SDLC, Object Oriented Programming (OOP), Service Oriented Architecture (SOA) and web.
• Educated in information technology, business, international relations and the physical, biological and social sciences.
• Good verbal and written skills that bridge the gap between business and technology.
• Financial, HealthCare, Pharmaceuticals, Telecom, Government, Insurance, Manufacturing, Retail.

TECHNICAL SKILLS:

Business Analysis: (RUP (Rational), Agile, Waterfall, Caliber, UML, Visio, Use Cases, Quality Center, Clear Quest)

Languages: (SQL, Java, Visual Basic, Cobol, PL1, JCL); Web (WAS, J2EE, HTML, XML, JavaScript)

Database: (DB2, Oracle, Teradata, Sybase, SQL Server, MS Access)

Computers: (PC, Mainframe, Stratus); Mainframe (TSO, SPF, QMF, SPUFI, CList, FileAid)

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn NY

Tech Business Analyst Hybrid, Project Manager

Responsibilities:

• Gathered requirements for converting accounts receivable and billing from Mainframe (Cobol CICS DB2) to Internet (C# .Net SQL Server). Documented application. Met with users. Led JAD sessions. Wrote business and functional requirements. Designed logical data model and database. Designed screens and navigation. Mapped data for ETL.

Confidential, Franklin Lakes NJ

Business Analyst

Responsibilities:

• Triaged deductible, out - of-pocket and copay issues for pharmaceutical claims as SME. Created and ran SQL queries against Teradata data warehouse for other BAs. Verified claims and fixed plan setup during migration. Authored lessons for (Client Benefit Management (CBM), Triage and Bi-Query (SQL) in PowerPoint.

Confidential, NYC

Business Analyst

Responsibilities:

• Migrated requirements from Word to Caliber for data. Wrote functional requirements for repos (repurchase).
• Taught BAs how to write Use Cases in Caliber and developed curriculum in PowerPoint.

Confidential, Valhalla NY

Business Analyst

Responsibilities:

• Wrote functional requirements in Caliber for Product Vision package in a .NET environment for Identifying suppliers, developing formulas, costing new products, generating ingredient and nutritional labels, configuring packaging and hazmat (hazardous material) data sheets for shipping concentrate from plants to bottlers.

Confidential, NYC

Business Analyst

Responsibilities:

• Wrote uses cases for rating municipal bonds.

Confidential, Basking Ridge NJ

Systems Analyst

Responsibilities:

• Wrote system specifications (CICS DB2 Cobol) for adjudicating medical claims.
• Triaged defects for HIPAA 5010 EDI 837/835 balancing and Coordination of Benefits (COB).

Confidential, NYC

Business Analyst

Responsibilities:

• Gathered requirements for mark to market pricing of financial derivatives (interest rate swaps and currency swaps) for managing credit and market risk. Analyzed XML feeds (XML Spy) for data mapping.
• Wrote data extract and transformation (ETL) requirements (Informatica) for loading Operational Data Store (ODS).

Confidential, Franklin Lakes NJ

Business Analyst

Responsibilities:

• Wrote functional requirements (FRD) to adjudicate pharmaceutical claims & reward switching from brand to generic.
• Made presentation of Consumer Driven Health care (CDH) plans in PowerPoint.

Confidential, NYC

Systems Analyst / Programmer Analyst

Responsibilities:

• Developed business requirements for settlement of Mortgage Backed Securities (MBS).
• Developed a proprietary OLTP DBMS in PL1 for the investment product master.
• Developed task management reporting tool in TSO SPF Dialog Manager.

Confidential, NYC

Business Analyst

Responsibilities:

• Conducted JAD sessions with business users and stakeholders.
• Wrote business and functional requirements consisting of epics and user stories and use cases for Web 2.0 social networking, Web Content Management (WCM) and extranet portal ( Confidential WebSphere and Quickr).

Confidential, Montvale NJ

Business Analyst

Responsibilities:

• Interviewed partners. Wrote business and functional requirements to track engagement opportunities.
• Mapped data to extract data (SSIS) from CRM (Customer Relationship Management) software (LexisNexis).
• Created BI (Business Intelligence) reports (SSRS).

Confidential, White Plains NY

Business Systems Analyst

Responsibilities:

• Wrote project charter, business process flows (BPM), use cases, business rules, class diagrams, object models and sequence diagrams (Visio) to create strategic forecasts, project working capital and capture actual volumes.
• In a Web-based multi-tiered service-oriented architecture (SOA) using Java/Oracle following RUP (Rational) SDLC.
• Built data warehouse with dimensional modeling of facts for drill down inquiry.
• Managed applications for planning global strategies for trading, processing and delivering soybeans.
• Produced consolidated position reports from contracts and exchange feeds.
• Hedged risk with futures, options and foreign exchange (FX) for managing market risk.
• Communicated with planners and controllers worldwide.

Confidential, Edison NJ

Web Developer

Responsibilities:

• Converted warehouse management from Stratus to Intranet/Mainframe using Confidential WebSphere in J2EE environment.
• Developed JSPs (Java Beans, Java Scriptlets) and Java programs (JDBC, Stored Procedures) connecting web screens (HTML, CSS, JavaScript) to legacy application (CICS DB2 PL1) for pick lists, truck arrivals and labor standards in MVC (Model View Controller) architecture.

Confidential, Rye Brook NY

Programmer Analyst

Responsibilities:

• Created Visual Basic SQL Server application for foreign exchange, subsidiary signatories, bank accounts, authorizations and loan guarantees. Created forms to enter data and produce reports in client server architecture.

Confidential, NYC

Programmer Analyst

Responsibilities:

• Wrote Stratus VOS PL1 programs for International funds transfer using SWIFT, CHIPS and Fedwire.

Confidential, NYC

Programmer Analyst

Responsibilities:

• Wrote CICS Cobol DB2 programs for customer check request at Confidential, corporate asset funding at Confidential and letters of credit at Manufacturers Hanover Trust.

Confidential, Kenilworth NJ

Project Manager, Data Modeler, Developer

Responsibilities:

• Gathered sales data from distributors for a new product. Modeled sales data (LDM). Created marketing database in MS Access. Created VB application. Reported sales with Crystal Reports. Converted MS Access to SQL Server.

Confidential, Battle Creek MI

Data Base Administrator

Responsibilities:

• Designed a physical database of 250 tables from a logical data model (LDM) for US DOD (Dept. of Defense).
• Optimized OLTP (Online Transaction Processing) database for a CICS DB2 environment.