TECHNICAL SKILLS:

Project Development: Business Analysis; Gathering Requirements; Agile Methodology, Documenting Business/Functional Requirements; Creating Use Cases; Creating QA and UAT scripts, Data

Cleansing; ETL: UI Wireframe Development; Full SDLC; Creating Data Base Structures; Visio Workflows; Defining Key Metrics, JIRA.

Database: SQL Server 20 ; DB2; Oracle 9I, 11g; Access.

Development: Visual Studio, TOAD, UNIX scripts .

Programming: SQL, PL/SQL, T - SQL, ASP.NET, REST API

Software: SharePoint; Visual Studio; Microsoft Office Suite; Visio.

EXPERIENCE:

Confidential

Business Analyst Consultant

Responsibilities:

• Delivered under strict regulated timelines, analysis and documenting of business and functional requirements, ‘as is’ vs. ‘to be workflow processes, for workman’s compensation for addition of state regulation's requirements.
• Created agile methodology templates and processes for development team of 6 developers on Team Foundation Server.
• Modified, or designed wireframe UI modifications for UI of claims applications.

Confidential

Business Analyst Consultant

Responsibilities:

• Analyzed Confidential systems, and REST APIs for system conversion to external clients, eBay and WalMart, facing web applications.
• Created epic, user stories, UI wireframes for agile sprint releases of global ecommerce shipping solution, using JIRA, Confluence and SharePoint for business and functional requirements capture and exchange.
• Researched, and created T-SQL scripts for client’s Confidential order details.
• Generated QA acceptance criteria for user stories and Confidential pricing systems, within 2 week sprints.

Confidential

Business Analyst/ Associate Project Manager Consultant

Responsibilities:

• Performed gap analysis, project management of client systems, on JIRA for user stories.
• Coordinated JAD meetings capturing data mart definitions, for creation of business and functional requirements for data analytics modeling.

Confidential

Business Analyst Consultant

Responsibilities:

• Analyzed, supported global member partners’ compliance applications, with design and coding of SQL Server SSIS automated solutions, web UI and reporting solutions, for data quality checking and ETL processing.
• Capture business requirements, coordinating with subject matter experts to document Visio UML data workflow processes.
• Performed ‘as is’ and ‘to be’ workflow processes gap analysis, capturing in Visio data state versions.

Confidential

Business Analyst Consultant

Responsibilities:

• Analyzed UI wireframe modifications, PL/SQL coding for life & health application front end, and data loads.
• Performed version change control, requirements gathering, use case creation, documentation for business requirements and support tickets for a global life & health insurance treaty management web application.
• Designed and coordinated QA testing and UAT for system changes and verification.
• Maintained database and reference data structures and processes for compliance requirements.

Confidential

Business Analyst

Responsibilities:

• Created QA and UAT PL/SQL testing scripts, systems transaction plans and operations procedures for IT and external user communities.
• For Macys account, gathered, documented, functional, business requirements, ‘as is’ workflow processes and data sources for development of UI wireframe and SQL processing for a web base solution, with time savings in reporting turnaround.
• Documentation and redesign of major client’s monthly Media Ocean data feeds, API calls, and SSRS reports, leading to a time savings of 3 days’ work and increased data analytics results accuracy by being the liaison between Confidential ’s internal teams and external client’s user base.
• Gathered requirements for out of house data asset management needs for proprietary ad campaign images, art work and content utilized by marketing department.

Confidential

Business/ Data Analyst Consultant

Responsibilities:

• Created PL/SQL scripts for QA, ETL and data quality testing.
• Documented gap analysis and functional requirements between existing and new web based front end reporting systems for consolidation, standardization and process improvements.
• Gathered, elicited data source, data definitions, QA test requirements, and business requirements from key users.

Confidential

Business Analyst Consultant

Responsibilities:

• Developed structured data analysis procedures, functional requirements documentation and scripts for imports of equities stock data, working with external clients on Confidential plans rules clarification, exercise rules, option plans definitions and data definitions, meeting deadlines dictated by securities laws and requirements.

Confidential

Business Analyst Consultant

Responsibilities:

• Coordinated meetings with key business sponsors to elicit business rules, QA scripts, for EDI requirements for recently merged corporate wide systems with agile development cycles.

Confidential

Business/Data Analyst Consultant

Responsibilities:

• Created PL/SQL UAT test scripts, QA test strategies for consumer marketing and ad analytics system.
• Gathered and documented test objectives for ETL processes for Informatica and Micro Strategy reporting ELT procedures, with interviews of internal IT staff.

Confidential

Sr. Technical Analyst Consultant

Responsibilities:

• Using PL/SQL, Access, Word, Visio and Excel, for pharmaceutical companies, advised and designed pricing and contracting solutions for commercial contracts and Model N implementation.
• Gathered business workflows of contract pricing system for creation of a new employee training manual.
• Created corporate standard operating procedures for Part D Gap Coverage Discount, class of trade and managed care contract approval, for a pharmaceutical client through client interviews and meetings.

Confidential

Data QA Analyst Consultant

Responsibilities:

• Programming PL/SQL and using TOAD, delivered improvements in data quality, technology and process of data load, merges to support the health care provider and organization CRM database.

Confidential

Business Analyst Consultant

Responsibilities:

• Analyzed, and programmed PL/SQL audit scripts for tracking database changes, covering Oracle, SQL Server and Teradata instances.
• Created and documented database loading procedures for offsite database administration staff for data quality and security

Confidential

Business Analyst

Responsibilities:

• Consulted internal and external clients for developing and programming PL/SQL and analysis Oracle and SQL Server 2005/2008 data source feeds and product software, streamlining and consolidating ETL processes.
• Working in agile scrum meetings, gathered client business needs for data feed process to document, standardize and consolidate business work processes across multiple client data feeds and data formats.

Confidential

Business Systems Analyst

Responsibilities:

• Performed analysis for iMany pharmaceutical contract management system implementation.
• Programmed Oracle /SQL Server interface utilizing TOAD, for foreign exchange rate updating process.
• Managed pharmaceutical contract workflow system SharePoint project, and developer resources, including meeting with project sponsors and stake holders, gathering business requirements, business rules and key metrics.
• Analyzed, designed and coded UI interfaces for global web for sales and marketing team’s campaigns.

Confidential

Data Migration Analyst

Responsibilities:

• Created UML data sequence diagrams for external client data.
• Using Oracle 9I/10g, and SQL Server 2005, analyzed, extracted, transformed, and loaded client’s legacy database sources into customized museum software, using TOAD.
• Performed QA testing on incoming client data for transfer to company’s web based software.

Confidential

Senior Healthcare Data Analyst

Responsibilities:

• Hired to rescue and retain second largest healthcare provider account, succeeding in re-engaging client to rollout Confidential ’s services to all 52 states, by stabilizing SQL Server data and SQL code, resulting in retention of client business.

Confidential

Senior Programmer/Business Analyst

Responsibilities:

• Analyzed, generated financial information contributing to IRS, government and state insurance regulatory reports, with adherence to strict internal financial standards.
• Created business and functional requirements for year end, quarterly and ad hoc financial reporting needs.

Confidential

Independent Business Analyst Consultant

Responsibilities:

• Programmed SQL for database QA data analysis, testing and confirmation, using UNIX scripts and regression testing for Amisys upgrade from HP to Oracle platform.
• Identified and documented college’s payroll system functionality, while cross training other system users.
• Decreased turnaround time of client reporting request and eliminated multiple programs by standardizing data formats for HMO plan data feeds to central Oracle 10 database using FoxPro and PL\SQL.

Confidential

IT Instructor

Responsibilities:

• Designed, instructed classroom curriculum for adult class in Microsoft Office Suite 2000, Excel, Access and Internet web design.

Confidential

Senior Analyst/Programmer

Responsibilities:

• For one of reinsurance’s industry’s global premier software packages, analyzed, designed, coded, implemented and maintained data load programs portions of the application, using Oracle, TOAD.
• Created business and functional requirements for 2 on shore consulting resources, supporting major software version releases.
• Within strict deadlines, QA standards, performed QA regression and UAT testing with internal and external client live data, analyzed and corrected client’s data conversion and business processing.