SUMMARY:

• Extensive years of experience as Business System Analyst in I.T. industry
• Experience with business requirement identification and analysis, data modeling and/or mapping; moderate to complex programming and coding to automate and/or support the database environment
• Strong experience using SQL/BI tools for data integration and data analysis. (T - SQL & SSIS)
• Comfortable working independently or as part of a team
• Fast learner with strong troubleshooting and problem solving skills
• Always willing to take ownership of work
• Bilingual: Spanish / English

TECHNICAL SKILLS:

Languages & Technologies: .NET Technologies VB.NET, ASP.NET, C#.NET, VB, MS Access, VBA, Business Objects, ASP, JavaScript, VBScript, CSS, HTML

Databases: MSSQL (T-SQL), MSDE, SQL Express, MS Access, SSIS, SSRS, DTS, Informix, Sybase

Other PC Software and languages: MS Office, Visio, TFS, Contour, RRC(Doors Next Generation)

PROFESSIONAL EXPERIENCE:

Business Analyst / Data Analyst - Independent Contractor

Confidential

Responsibilities:

• The Composite Rate project would provide small groups with the option of using either age band rating or composite rating for medical products / The Dental PPO project would provide clear benefit differential designed to encourage members to use INN dental providers.
• Review, analyze, and evaluate business systems and user needs.
• Document requirements, define scope and objectives, and formulate systems to parallel overall business strategies.
• Be accountable for supporting the solutions through the Systems Design, Systems Integration Testing, User Acceptance Testing, and Implementation phases.
• Participate effectively in meetings, calls, etc. in a variety of roles ranging from facilitator, to requestor, to solutions coordinator, to consultant.
• Conduct JAD sessions and requirement review sessions.
• Work with business partners and technology partners to identify, define, interpret and clarify scope of problems/issues in terms of business and/or system requirements and processes.

Environment: /Tools: MSOffice, Visio, RRC (Doors Next Generation), Waterfall Methodology

Confidential

Responsibilities:

• The eDockets project aimed to enhancement and redesign the system of record for Power and Transmission Rate Proceeding.
• Perform interviews and research to determine IT business requirements and translate them into specifications.
• Help the assigned project meet business, schedule, and budget objectives.
• Analyze, facilitate, model and organize information in order to elicit requirements, reconcile conflicts, and distinguish solution ideas from business needs.
• Complete documentation for project development efforts (including use cases, requirements, process maps) and work closely with development team and business teams to ensure successful implementation.
• Assist in negotiating priorities and resolving requirement conflicts among various stakeholders.
• Assist in project planning and tracking activities.
• Assist in data discovery and analysis and modeling of requirements, verification of deliverables.

Environment: /Tools: MSOffice, Visio, Contour, Waterfall/Agile Methodologies

Confidential

Responsibilities:

• Part of a diverse team tasked with replacing a legacy mainframe system used by numerous departments with an online system. The system is available to external applicants interested in opening a business in the Confidential as well as to city’s employees in charge of processing the applicants’ requests.
• Interface with numerous business departments to determine requirements, and then work with production data to validate those business requirements.
• Analyze and document business requirements.
• Perform meaningful data analysis with database queries.
• Development of functional specifications.
• Development of use cases, state diagrams, workflows and screen mock-ups
• Assist on resolution of data conversion issues, and the creation of test plans.
• Provide guidance to other Business Analysts in the team.
• Facilitate UAT and training sessions.
• Lead scrums when PM was absent, and used Team Foundation Server (TFS) for Agile planning and collaborations
• Participate in the management of all phases of the software development life cycle (SDLC) for the solution.

Environment: /Tools: MSSQL2008/2012, SSRS, .NET technologies, Agile-Scrums, TFS, MSOffice, Visio

Confidential

Responsibilities:

• Complex data conversion project to a legacy system that reinvents both the data model and user experience when managing cruise pricing that produces increase in revenue.
• Identification and analysis of conversion business requirements.
• Development of functional specifications.
• Data mapping.
• Conversion test plans.
• Development of conversion validation scripts, and execution of the validation scripts.
• Worked in an Agile and highly organized PMO environment.
• Active participation in the initial phases of the software development life cycle (SDLC) for the solution.

Environment: /Tools: AS400, DB2, MSSQL2008, SQLExpress, MSOffice, Visio, Agile Methodology

Confidential

Responsibilities:

• Insurance documents conversion and ODS creation.
• Business requirement identification and analysis.
• Plan, analyze, design, implement, maintain, and control the department's databases.
• Perform moderate to complex server-class database activities across various environments.
• Data modeling and/or mapping; moderate to complex programming and coding to automate and/or support the database environment.
• Performance monitoring and tuning; analyzing database metrics and assisting with capacity planning.
• Planning, testing, configuration and execution of installations, upgrades and migrations.
• Participate in the development of data/ database architectures and management policies, procedures and standards.
• Pull data from the different life insurance system and compile the data to build the ODS for reporting.
• Maintain conversion programs (databases, SSIS packages, etc) for document management system.
• Execute future conversions from CBDDoc to FileNet.
• Assist in general troubleshooting of new Insurance Document Management System.

Environment: /Tools: MSSQL2005/2008, SSIS, SSRS, SQLExpress, C#.NET, ASP.NET

Confidential

Senior Business Analyst/ Developer

Responsibilities:

• Developed and maintained sales and marketing application that was used to identify business opportunities and to schedule the work of the sales force. Responsible for both front and back ends of the system. Frontend was written using .Net technology and backend relied on SQL stored procedures, functions and views for data management and extraction. Managed all phases of the software development life cycle (SDLC).
• Assisted in the migration of legacy VB6 Systems into web based applications using .NET technology.
• Participated in business discussions with Sales and Marketing department to gather information and later produce detailed requirements for software creation.
• Planned, designed and implemented several database processes to integrate data from diverse sources (ASCII, EXCEL, ACCESS, DBF, SQL server) into company warehouse.
• BCP and bulk inserts were the preferred methods to import data supplied by external providers (USPS, MSAi, and TD). Some of these processes were later handled by SSIS packages.
• Replication and as straight SQL scripts were used to handle data from company production databases (SQL Servers) and documents from different departments (Excel, Access, text files, etc).
• SQL Jobs were created to schedule download data feeds.
• Complex stored procedures were used to validate, to process and to make these feeds available for company applications and report systems.
• Designed and implemented changes to data warehouse to form the base for Business Objects universes.
• Created several BO universes.
• Consolidated redundant BO universes into one.
• Designed and created reports to be used by Sales and Marketing department.
• Performed code reviews and quality assurance of application software and SQL server environment. Identified data and performance issues and provided solutions to improve processes quality.
• Monitored and provided forefront support of everyday processes and applications.

Environment: /Tools: C#.NET, VB.NET, ASP.NET, VB6, SSIS, MSSQL 2000/2005/2008, MSDE, ADO, Business Objects, SQLExpress, Win2000 platform on Fujitsu TablePC, Win2002 Servers, Win2008 Servers

Confidential, Winston, NC

Developer/ Business Analyst

Responsibilities:

• Coded new functionality in Payments System for better tracking and processing of payments’ corrections and adjustments. System was written in C# for the application interface. MSSQL for the backend.
• Migrated of a VB6 client/server app to a VB.NET based intranet app. System will take advantages of new Object Oriented capabilities available in VB.NET.
• Designed and developed a framework for data file manipulation.
• The framework consists of Configurable Windows Service for data files detection.
• Extensible data files processing system, which handles each data file according to configuration parameters.
• Parameterized DTS packages to perform data transformation and data import/export from/to databases.

Environment: /Tools: C#.NET, VB.NET, ASP.NET, VB6, DTS Libraries, Crystal Reports, JavaScript, XML, XSL, CCS, HTML, MSSQL2000, ADO, Win2000 platform, COM+, IIS 5.0

Confidential, White Plains, NY

Senior Developer

Responsibilities:

• Worked as part of a team developing several applications for diverse clients:
• Synchronization Module - This module was integrated with a system designed for auditing. It allowed different auditors working on the same project to share and synchronize their information. It also assisted them in solving any conflicts, as well as creating detailed reports about the synchronization process.
• Web point of sales - Internet system developed for a non-profit organization to provide audio-visual materials for the blind and dyslexic.
• Auditing System - Auditing system used by one of leading auditing companies was redesigned to use a thinner client, and take advantage of the latest Microsoft technologies.

Environment: /Tools: VB6, MSSQL2000, MSACCESS 2000, ADO, XML, XSL, ASP, VBScript, HTML, CSS, Windows API, Win2000 platform, COM+, IIS 5.0

Confidential

Senior Developer / QA Analyst

Responsibilities:

• Responsible for new functionality and maintenance of online system that processed mortgage insurance payments.
• System was built using ActiveX Documents, COM objects deployed on MTS, and RDO was used to connect to SQL Server database.
• Responsible for creation of store procedures and database objects to support new functionality.
• Developed a DCOM application (Loan Resubmission Tool) by using out-of-process and in-process server components, and a standard exe for client interface.
• Responsible for configuration of DCOM components in server machine using dcomcnfg.exe.
• Loan information transmitted as XML files.

Environment: /Tools: VB5-6, MSSQL Server 6.5, MTS, COM, DCOM, RDO, XML, ASP, Windows API, Win 95 Client/ WinNT 4.0 Server, MTS, IIS 5.0

Confidential, Jacksonville, FL

Database Developer

Responsibilities:

• Developed core store procedures that held business rules for Health & Welfare enterprise system. Coded and documented new store procedures for new clients.
• Redesigned database tables and workflow process for Correspondence Module.
• Detected and corrected performance and workflow issues in existing code.
• Developed several utilities for testing and work synchronization purposes.

Environment: /Tools: VB6, Sybase SQL Server 11, ADO, ODBC, MS Access 97, Win95, UNIX, MS Access, SQL Server 6.5, DAO, RDO, Win API, Win95/Win NT

Confidential

Business Analyst/ Database Developer

Responsibilities:

• Responsible for total project cycle (requirements gathering, design, coding, and deployment) of a ‘Human Resources System’ for tracking medical and family leaves.
• Created a report engine, and provided numerous ad hoc reports.

Environment: /Tools: VB5, Crystal Reports 6.0, RDO, DAO, MS Access, Informix 7.x, Win 95 Client/ UNIX Server

Confidential, Jacksonville, FL

Developer/ Database Developer

Responsibilities:

• Worked as part of a team developing windows-based application for EMS and Rescue Organizations.
• SQL Server or MS Access was used as back end based on client size and needs.
• Created the application's databases for new clients, creation of Help Files using Visual Help Pro, and provide technical support for clientele using Confidential products.
• Built and maintained the company's contact management database.

Environment: /Tools: Access Basic, VB4, Asymetrix ToolBook, Asymetrix ODBC connectivity, SQL Server, MS Access, Win95