Senior Business Analyst Information Technology in West Palm Beach FL Resume Frank Galan

Document Sample
Senior Business Analyst Information Technology in West Palm Beach FL Resume Frank Galan Powered By Docstoc
					                                          Frank J Galan
                                         Wellington, FL 33414
                        (973) 780-6158 ● (561) 798-7308 ●

Performance driven client facing technical professional experienced in proposal preparation, scope
determination, stakeholder support, participating in and guiding teams through project and
software development life cycles, requirements elicitation, analysis, design, documentation,
development, implementation, quality assurance management and testing, user acceptance testing,
and training. As a Business Analyst, managed diverse groups; perform business process and system
analysis, architecture, design and development of custom enterprise business solutions following
best practices in Microsoft and Java technologies. Recognized by managers and peers for ability to
exceed project goals, group motivate, problem solve, push projects to completion, and fulfill
clientele expectations with a focus on web based B2B and eCommerce solutions.

Management:            Client Facing Business Analyst, Quality Assurance Manager, Project Manager,
                       Technical Team Lead, Cross Functional Team and Outsourcing Coordination

Computer Languages: ASP, ASP.Net, HTML, DHTML, XML, CSS, C#, 2003,2005, VB.Net, Visual Basic 6,
                    Transact-SQL, JSP, JavaScript, Java, J2EE, PL-SQL, knowledge of C++, C, Perl

Database Systems:      MS SQL Server 6.5, 7 & 2000, 2005 Oracle 8i & 9i, MySQL

Operating Systems:     Windows XP, 7 and Servers, SUN Solaris, Unix

Development Tools: MS ASP, ASP.Net, Visual Studio 2003-8; Java SunOne Studio, JCreator,
                   WinSQL, Weblogic 5.1-7.0, Struts, PUTTY, CVS, ANT, Defect Tracking,
                   Javadocs, TopLink, IIS, Transact SQL, Query Analyzer, Quest SQL Optimizer,
                   MS Enterprise Manager, IIS Manager, SourceSafe, Paint Shop Pro, XML Spy,
                   ERWin, Visio/UML, MS Office, Knowledge of MS Project, SharePoint,
                   wireframes, SEO, paid search, email marketing, meta tags, link exchange,
                   social marketing, content management, Agile and waterfall methodologies

Training and           .Net course training 2003, 2005, Microsoft MCSD certification 1999,
Certifications:        Sun Microsystems JSP/Java/J2EE course training, JSP/Java/J2EE OTJ,
                       classroom, and course training, classroom and OTJ training in
                       ReqPro and Websphere, working toward CBAP Certification

Self Employed, West Palm Beach, FL                                               4/2010 – Present
Senior Business Analyst, Financial - IT

Perform analysis on historical and real-time data, create process documentation, use technical and
analytical skills to determine and verify data trends, make decisions regarding data trends and
manage key accounts using various stock and stock options strategies.

                                                                                       1 of 4
IBM Global Services (Acquisition of Americas Systems / Maersk Data USA Inc.)      8/1999 – 4/2010
Business Analyst/Technical Team Lead/Senior Software Engineer/ IT Specialist

Lead Projects Overview:
In a client facing capacity participated in and lead diverse teams through successful project
initiation, gathering business process requirements from users and existing documentation, use
case development, process and workflow diagrams, project documentation, UI Prototyping,
functional technical design and data mapping, all phases of product development, creation and
execution of test strategies and plans, user acceptance testing, training, and production
deployment of custom mission critical systems. Proven successes in analyzing business and system
process requirements, adding value through innovation and product improvement, ability to
develop good peer to peer working relationships with internal and external business partners at all
levels, and delivering solutions that meet stakeholder needs on-time and on-budget for multi-
million dollar accounts:

- In a team environment led analysis and development of enhancements for a mission critical
Java/JSP/J2EE solution performing requirements elicitation, documentation, analysis, design and
implementation of enhancements including XML integration.

- Interfaced with clients, gathered requirements, architected, designed, created project
documentation and diagrams including database design and mapping, and led enhancement efforts
of a mission critical B2B Global OLTP solution. Suggested analyzed, designed, documented,
implemented and tested security enhancements in compliance with best practices including digital
certificate, proxy server and firewall security requirements. Analyzed and re-architected their
ASP/DCOM/COM/C++ web application to ASP.Net.

- Completed development of a business critical web based Java/JSP/J2EE solution analyzing and
adding invoicing, miscellaneous charges, business rules modules, enhancement of other
functionalities including XML legacy systems integration, and performance optimization. Provided
application support for the system based on client needs and performed system maintenance.

- Gathered requirements, documented, diagrammed, designed, architected and developed a
nationally deployed B2B ASP/COM/C++ web based application which automated a paperless B2B
process, with online vendor service acceptance, review, approval, invoicing, and payment for
services. Systems interfaces were via electronic data interchange and a secured web based user
interface with a SQL Server back end. This solution completely replaced a paper system which
required a series of fax, Federal Express, manual review, and duplicate data entries, and facilitating
payment of invoices which had otherwise been delayed several months. The result was significantly
reduced costs of doing business, better turnaround times, and improved vendor relationships.

- Analyzed, designed and developed including process and work flow diagrams and project
documentation, a cross browser compatible, Active Server Pages/IIS/Oracle database driven web
solution for providing services to the military featuring business to business vendor solicitation
processing including proposal downloads, managing submissions and award information, and the
ability to complete and submit job applications over the internet. System functionality includes the
ability for administrators and company managers to dynamically update major portions of the
website including managing their Solicitation and Bidding process, Frequently Asked Questions,
Quality and Safety information, and daily news via a secured web based back office.

   Frank J Galan                                                                         2 of 4
– Worked with stakeholders to analyze business needs, gather and document requirements,
architected, designed, developed, diagramed, performed database design, and implemented a Jobs
Posting solution for a Human Resources department. This system has a Visual Basic front end for
database management, a web based user interface, and SQL Server back end.

– Conceived of, architected, designed, documented, developed, and implemented a fully
configurable active server pages Security Module which featured the ability to grant page level and
page element permissions. This reusable module was used for asp based web applications
implementing ID/Password security. This reusable plug-in resulted in reduced development time
and costs, higher profit margin due to reusability of ID/Password security implementation.

- Analyzed requirements, developed use cases, specified hardware, and led team in creation of a C#
and VBScript.Net nationwide OLTP order system. Developed rates implementation, scheduling,
product management, XML legacy system integration, order creation, invoicing, management of
allocations, tracking, and identified and implemented performance improvements.

- Developed a Visual Basic application to process payroll with the ADP payroll service; automated
and configured the ADP upload process to eliminate transcription errors occurring during manual
payroll processing which facilitated timely and accurate transmission of payroll data.

- Assisted in the analysis and development of a secure ASP/IIS/SQL Server web portal site;
developed functionality for users to create, edit and review cargo bookings, provide cargo tracking
including integration with legacy systems; supervised and supported other developers and
contractors in completion of their tasks.

- Received multiple Commendation awards from IBM in recognition of meeting client expectations,
on time under budget delivery, work efforts exceeding expectations, innovation, and meeting
business objectives.

Broden Inc., Consulting firm Specializing in Developing                            2/1999-6/1999
Software Solutions and Providing Consulting Services to Fortune 500 Clients
Business Analyst/Software Engineer/Contractor

- Provided consulting services and project development for fortune 500 companies, including
project initiation, design, architecture and hardware specification, software development, customer
acceptance, and assisting team members in fulfilling project requirements.

- Enhanced a Sales Force Automation (SFA/CRM) system for a venture capital dot com startup using
JSP, Java, JavaScript, SQL Server, and database synchronization.

- Developed and enhanced a nationwide resource/marketing program for a major industry client
using Visual Basic 5.0 & 6.0, and SQL Server.

McLaren Hart, Global Leader in Consulting for Chemical and                         9/1994-11/1998
Pharmaceutical Industries
QA Manager/Laboratory Manager/Software Engineer

   Frank J Galan                                                                       3 of 4
- Performed Quality Assurance assessment of data in the Czech Republic over a six month period.
Worked directly with the client, regulators and personnel in the Czech Republic to evaluate data
locate discrepancies and correct deficiencies. Performed data assessments ensuring accurate
Quality Assurance reports for all analyses; was presented with a commendation for my
persistence, dedication, and work ethics.

-Obtained certifications and regulatory approvals for analytical testing of the first NJ State Certified
Mobile Laboratory. Working directly with regulators, implementing NJ State and Federal
Regulations, application of Quality Assurance methodologies, knowledge of New Jersey State and
Federal regulations and attention to detail, was able to accomplish this first in the State of NJ
achievement for this worldwide chemical and pharmaceutical industry consulting firm. This
resulted in the ability to perform on site analyses facilitating turnaround time and increasing profit
margins while reducing wait time expenses for the client.

- Resource allocation, cost analysis and project budgeting.

- Developed and enhanced systems to generate statistics, automate data gathering and reporting,
and instituted quality assurance procedures in compliance with applicable standards.

E.I. DuPont De Nemours & Company, Global Chemical Products Company                    2/1992-4/1994
Quality Assurance Manager/Project Manager/Software Engineer

- Managed implementation of QA program and project workflow.

- Acquired governmental certifications based on experience with subject matter, team building,
knowledge of certification regulations, implementation of those regulations, working with
regulators, and conveying required regulatory project and quality assurance requirements to
management and team members.

- Created and implemented quality assurance standards and testing procedures. Led software
development efforts to meet governmental compliance requirements for regulatory certifications
and obtained approvals for analytical testing.

- Proven record in meeting regulatory requirements and generation of data consistent with those
requirements through data analysis automation, and implementation of standard operating

Bachelor’s of Arts: Chemistry, with a concentration in computer programming. Rutgers University
Diploma: Computer Programming, Honors Program Participant, 1999                The Chubb Institute
Diploma: Advanced Programming Techniques and Technologies, Top of Class.       SetFocus LLC
Accreditation: Microsoft Certified Solutions Developer Certification (MCSD) 1999
                 Java/J2EE Certificate 2003

Spanish: Basic to Intermediate Speaking and Reading
Russian: Basic Speaking and Reading

   Frank J Galan                                                                           4 of 4

Description: Frank Galan is a performance driven client facing technology professional experienced in proposal preparation, scope determination, stakeholder support, participating in and guiding teams through project and software development life cycles, requirements elicitation, analysis, design, documentation, development, implementation, quality assurance management and testing, user acceptance testing, and training.