SUMMARY

• Well seasoned professional with business and technical experience in the Information Systems industry.
• Experienced in managing complex and enterprise project teams for development in disaster recovery/business continuity, ecommerce, client - server, on-line and batch applications, data warehouse, network communications, architecture and mainframe applications.
• Proven ability to deliver large-scale projects requiring full Application Software Development Life cycle as well as acquisition of software and infrastructure with budgets in the millions.

TECHNICAL SKILLS

Tools: Rational Suite, ERwin, TOAD, Cognos, Brio, Crystal Reports, Sharepoint, Jbuilder, VisualAge for Java, PowerBuilder, MS Project, Excel, Visio, Powerpoint, Informatica, Endevor, Easytrieve, ISPF, FileAid

DBMS: Oracle, DB2, DB2/UDB, DB2/400, MS SQL Server, Sybase, VSAM, FoxPro, FoxBase, Clipper, dBase

Methods: UML, RUP, Use Cases, SDLC, Software Engineering, JAD, RAD, OOAD, OOP, OLAP, Data Warehousing, Dimensional Modeling, OLE, Agile, Information Engineering, 6-Sigma

WebTechnology: WebSphere, MQSeries, Apache, Java, JavaScript, JSP, Java Beans, ASP, HTML, DHTML, XML, Forte, PERL

Languages: COBOL II, Cobol/400, JCL, RPG/400, RPG III, Visual Basic, C++, Java, SQL, PL/SQL, T-SQL, ‘C’, Visual C++, CL/400, SQL/400, Clipper, FoxPro, FOCUS

PROFESSIONAL EXPERIENCE

Confidential

TECHNICAL BA

Responsibilities:

• Responsible for gathering requirements from end users and preparing business and functional specifications for an Internet / Intranet project.
• Participated in the architecture, design, testing and implementation of the Internet Application Infrastructure and Web Application. Responsible for complete system documentation which included Use Cases, Business modeling, Work Flow Diagrams, Component Diagrams Class Diagrams, etc.
• Translate user requests into technical requirements and design for interactive web-based application for energy saving for customers switching to new energy provider.

Confidential

BA / DATA BASE ANALYST / DBA

Responsibilities:

• Performed Business and data analysis for Business Intelligence reporting.
• Performed Analysis and provided application support and enhancements for proprietary software used to analyze risks and score business in real-time for the purpose of creating innovative investment opportunities from diversifying insurance returns. Prepared detailed test plans for all software upgrades & enhancements.
• Created documentation for DBA procedures for production, application, and UAT database environments.
• Prepared detailed backup plans and preliminary DR/BC plans.
• Review and tune SQL queries, stored procedures, SQL Server configuration settings, and performance relating to real time production reports and Data Warehouse projects.

Confidential

TECHNICAL BA/PROJECT MANAGER

Responsibilities:

• Work with project managers, SMEs and department users in defining business needs and requirements and preparing all documentation pertaining to business and functional specifications including Use Cases, process diagrams, etc.
• Translate user requests into technical requirements and design for interactive web-based application for completion of bank merger and applications integration and enhancements.
• Work with development teams performing front-end integration deploying browser and database applications (C#, JavaScript, Java, ASP, ASP.Net), getting data from mainframe, AS/400, Unix, AIX, and PC databases.
• Performed hands-on data analysis and coding SQL scripts to ensure data validity and program processing accuracy.
• Served as liaison between the business users, third party vendors, offshore and domestic developers.

Confidential

PROJECT MANAGER/ADMINISTRATOR

Responsibilities:

• Involved with the entire SDLC, updating the project plan, conducted JAD & RAD sessions, and requirements specification reviews. Worked with users helping to define business system requirements.
• Provided delivery management to ensure customer satisfaction and reference ability.
• Developed project plans and assumed responsibility for project profit and loss.
• Prepared detailed functional specifications documentation for data architecture design, data modeling and coordinated data warehouse related activities with DBAs, Software Engineers, and department managers.
• Responsible for managing the setup and installation of incoming hardware and software.
• Planned and programmed data transfers between Unix, AIX, Mainframe, LANs, and AS/400 systems.
• Transfers happened between Oracle, DB/2, SQL Server and Sybase databases.
• Plan and co-ordinate hardware, operating system, application software upgrades, and PTF installs.

Confidential

Sr. DBA/Technical BA

Responsibilities:

• Prepared project plans for system and application upgrades and gathered all additional last minute requirements.
• Participated in data center consolidation planning and implementation.
• Worked with environment analysts, system administrators, DBAs, and managers to ensure proper planning and documentation.
• Participated in preparing all production and application databases for SOX compliance, security, and Disaster Recovery.
• Created documentation for DBA procedures for production, application, and UAT database environments. Participated in Emergency release for applications and database updates also MTP releases.
• Performed Analysis and provided application support and enhancements for ERP / CRM packages Seibel and SalesLogix within SOA.
• Performed Business and data analysis for Business Intelligence reporting and Data Warehouse projects.
• Review and tune SQL queries, stored procedures, SQL Server configuration settings, and performance relating to Data Warehouse projects.
• Performed daily health checks on all MS SQL Server and Oracle databases.
• Responsible for all Production DBA functionality for all world-wide databases (MS SQL Server 2000, 2005 & Oracle 9i, 10g, 11g) and applications Databases running on HP-UX, and Windows 2000 & 2003 Servers.

Confidential

Project Manager / Technical Business Analyst

Responsibilities:

• Performed Analysis of currently defined business and functional processes. Made specific recommendations pertaining to improvements and corrections.
• Worked independently using a preliminary project plan and maintain detailed level records for all phases of the applications systems and programming activities. Developed implementation plans, including recommendations regarding the allocation of staffing resources and other requirements.
• Advised and assisted departmental users in defining business needs, and data requirements, and devise solutions. Translated user requests into technical requirements and design for interactive web-based application for international clients. Prepared all specifications for the web based publishing of financial reporting and data feeds from the data warehouse.
• Served as technical liaison between the credit union SMEs and third party vendors in defining, designing, and implementing automated systems as well as the Data Warehouse environment.
• Provided technical assistance to IT staff in the detection and resolution of system problems, especially during testing. Performed hands-on data analysis to ensure data validity and program processing accuracy.

Confidential

Project Manager / DBA / BA

Responsibilities:

• Monitored project activities and advised staff of issues due to resource availability.
• Executed and maintained project management processes and disciplines in the areas of: program schedule and quality management; requirements management, WBS, communications management; human resource management; procurement management; risk / issue management; change control management.
• Performed the analysis, evaluation, and selection of the new CRM / ERP System.
• Performed the requirements gathering, conducted JAD & RAD sessions between IT dept., vendor, and users.
• Prepared Use Cases and EDDs (Enhancement Definition Documents) for all modification requests.
• Planned and coordinated all project status meetings between upper management, department heads, IT, and user community.
• Worked closely with all levels of users to help define additional user needs, discoveries and problem resolution.
• Managed all vendor activities pertaining to specification to technical design, deliverables, programming, testing and overall performance.
• Worked closely with BAs and developers in requirements definition and prototyping.
• Participated in training end users in several modules. Prepared condensed user guides for quick reference.
• Responsible for all enhancements, specifications, and modifications performed for the financial portion of the application, G/L, A/P, A/R, Chart of Accounts, etc. Ensured the accuracy of all accounting tables in the finance database. Performed additional data modeling for the finance and distribution portions of the new system. Performed all programming and coding for the of the Detailed General Ledger reporting system.
• Established a corporate disaster recovery business continuity plan: performed project management for the company’s first disaster recovery simulation. Established the project plan and ensured all preparation activities were completed for the collection of backup software and configuration documentation. Prepared proposal for the various scenarios for Hot site configuration as well as BC issues.