Steven Gara
The resume has not yet been entered.
A highly qualified Business, Technical and Data Analyst with 10 years’ experience demonstrating success in linking business needs with technical solutions.
· Solution Concept to Execution: Unique competency in translating business issues into customer solutions including opportunity identification, requirements development, software development management, delivery, support, and analysis.
· Innovative Application of Technology: Unique capability to understand technology to solve a particular business problem or create business opportunity.
· Product development: Full lifecycle experience in scoping, designing, developing, deploying, and supporting enterprise scale software applications such as Human Resource and Financial application packages.
· Teaming and collaboration: Specialize in creating cross-functional, cross-organizational teams with the customer to identify, prioritize, and design solutions for business or technical needs. Able to liase, communicate and make effective presentations to Senior Level Management such as CIOs and VPs.
· Business Intelligence/DW: Expert functional and technical analytical skills translating business intelligence into business action including deliverables such as reports, cubes and dashboard/scorecarding using various tools.
CAREER HIGHLIGHTS
Carnival Cruise Lines, Miami, FL – Business Analyst (IT and Ops.)
Sept. 2007 to Present
· Analyzes historical data for forecasting purposes
· Liaison with other departments to document workflows and gather requirements for system enhancements
· Proactively identifies problematic issues and work diligently in getting them resolved in a timely manner.
· Provide support to existing systems and participates in all testing of new system modifications
· Manages special projects as assigned by management
SJG Consulting, Hallandale, FL – Business/Data Analyst – Project Based Independent Consultant
Client Companies Consulted:
Towncare Dental Miami, FL (Kronos, Great Plains support and Cognos migration)
Sept. 2006 to Dec. 2006
Qpay, Inc Miami, FL (Business Analysis for Finance and Datawarehousing efforts)
Dec 2006 to June 2007
AlphaStaff, Inc. Ft. Lauderdale, FL (Business Analysis and system support)
Nov 2005 to June 2006
· Provided business analysis, gathered requirements, designed and developed integrated IT solutions and business processes to meet client and internal user requirements.
· Met regularly with all operational departments to determine IT/Data software processes and solutions to make the businesses run overall more efficiently.
· Worked with high level business line department managers including Directors, VP’s, CIO, COO and President to effectively prioritize activities, gather requirements and achieve defined objectives
· Created complex technical, functional and business specifications along with UML diagrams for Payroll/HR and GL/Financial related imports from external clients.
· Worked with IT/business managers to effectively prioritize activities and achieve defined objectives. Translated business requirements into IT solutions.
· Created and participated in JAD and similar sessions.
· Sketched diagrams of proposed and existing systems using Visio.
· Provided application level technical support to the Enterprise on an ad hoc basis on System related issues.
· Performed data analysis/development using various tools such as Crystal Enterprise to present data to senior management.
· Performed some manual QA/Testing activities related to payroll and GL data imports and exports and the processes that were documented as well as reporting.
· Performed Project Management duties, kept cost, timelines and milestones on small-midsize projects and tasks using MS Project.
· Developed and tracked projects, enhancements and fixes to business applications as well as documented any support and technical issues with applications and helped to resolve.
· Assisted the organization in identifying business process gaps and creating solutions to fill them.
· Helped Analyze and Design multidimensional, small and medium scale database and BI solutions; created reports and cubes (Cognos and Business Objects)
· Installed and configured software; wrote technical documentation; developed tracking tools measuring program performance.
· Performed small to mid level Project Management duties as needed and kept cost, timelines and milestones using MS Project.
· Collaborated with internal end-users for custom tailored reporting and cube development.
· Provided technical support on the Finance System (MS Dynamics).
· Defined and developed BI reports for accessing/analyzing data from data warehouse/marts.
· Optimized reports, cubes and database SQL queries; supported Cognos batch reports on a 24/7 rotating basis.
BankUnited FSB, Miami Lakes, FL - Senior Applications Systems and Business Analyst
Mar 2004 to Nov. 2005
· Provided business, process and technical analysis, design and documentation for existing and proposed technology architecture frameworks.
· Participated in the full life cycle of technical solutions, including analysis, design, development, testing, implementation and deployment.
· Worked with IT/business managers to effectively prioritize activities and achieve defined objectives. Translated business requirements into business, technical and functional specifications which led to IT solutions.
· Fulfilled business objectives including implementation, administration, support and documentation for HRIS System, Compliance and Imaging products (ADP, Ocean Systems and FiServ).
· Participated in JAD and similar sessions.
· Sketched diagrams of proposed and existing systems using Visio.
· Advised senior management and staff on budgeting software/hardware purchases.
· Managed Vendors and scorecarding for software demos and implementations.
· Defined opportunities to improve efficiency of the IT infrastructure.
· Managed, administered and installed applications for end-users; assist in training and related programs.
· Developed and maintained reports, databases and BI cubes for BI related queries, problem-tracking, trends and issue resolution (Crystal, Hyperion and Cognos)
· Developed and interpreted technical documentation and programming code developing diagrams of workflows in system design and processes.
· Acted as technical liaison between end-users and IT developers on various internal projects
· Increased operational efficiency by research and implementation of imaging and scanning technology.
· Conducted training sessions and workshops enhancing end-users’ understanding of new systems
· Created project plan, managed and implemented Enterprise-Wide & Attendance System and Enterprise-Wide HRIS System.
· Performed some manual QA/Testing activities related to HR reporting as needed.
· Assisted in budget development for three projects costing over $100K each; provided in-house maintenance and SQL and Oracle database administration.
· Designed and documented plans for disaster recovery of various systems.
· Supported the initiatives of several departments including assisting users in defining a Business Need for technological improvements, building a Business Case, researching Vendors and creating ballpark budgets based on the need.
· Optimized queries and created reports using SQL.
Kronos, Boca Raton, FL and Miami, FL – Sr. Applications, BI, Data & Systems Consultant -
Jan 2003 to Feb 2004
· Managed up to six engagements simultaneously; managed entire technical projects completing 20 small to medium-sized implementations.
· Conducted client system surveys and analyzed business requirements and processes.
· Translated user requirements to business/technical solutions.
· Designed and developed reporting and delivering analytical solutions as well as data management and data warehousing.
· Installed and configured SQL Server databases and applications.
· Imported data and created Crystal Enterprise and Cognos reports for validating data integrity.
· Translated end-user surveys into technical documents thereby maximizing efficiency.
· Provided end-user training; led broad range SQL server database administration functions including, database creation, tables and indexes; loaded and reorganized data ensuring data integrity and system security.
· Utilized ETL process to extract, tranform and load data from databases/applications.
· Utilized backup, recovery configuration, and export/import techniques.
· Optimized sort operations; monitored and detected lock contention.
· Resolved SQL and multi-threaded server tuning issues and performed tuning for various applications.
· Customized and configured data marts and data warehouse implementations meeting client business requirements.
· Utilized Business Intelligence software such as Cognos Impromptu, PowerPlay, Upfront, Visualizer 7.0, and Crystal Reports 9 to develop custom reports and OLAP Cubes.
· Performed extensive data analysis on existing systems; innovated design adapting to Auxis’ multi-tiered business model.
· Led complex migration of data; implemented company-wide use of data marts and databases.
· Developed accurate management reports; installed SQL server databases and BI decision analysis tools.
· Optimized, tuned databases and queries/reports using SQL.
ANC/ Vanguard Car Rental, Ft. Lauderdale, FL - Cognos/Data Warehouse Technical Analyst –
Nov 2000 to Dec 2002
· Designed multidimensional, medium and large-scale database solutions; created reports, Star Schemas, Universes and OLAP objects (Cognos and Business Objects)
· Installed and configured software; wrote technical documentation; developed tracking tools measuring program performance.
· Collaborated with internal end-users for custom tailored project solutions; managed help desk team.
· Defined and developed BI reports for accessing/analyzing data from data warehouse/marts.
· Optimized reports, cubes and database SQL queries; supported Cognos batch reports on a 24/7 rotating basis.
Ultimate Software, Ft. Lauderdale, FL – Technical Support Engineer –
Jul 1998 to Nov 2000
· Provided Technical Support for issues relating to the Ultipro HRMS/Payroll system for clients.
· Performed troubleshooting for reports and databases issues as well as creating new reports for clients using Cognos Impromptu and Powerplay.
ACADEMIC CREDENTIALS
CORNELL UNIVERSITY /BARUCH COLLEGE New York, NY
1996
· M.S. Management
TEMPLE UNIVERSITY Philadelphia, PA
· Bachelor of Arts – Arts & Sciences 1990
University of Phoenix and DeVry, Online – PT Adjunct Faculty –
Aug 2002 to present (Part time, eves only)
· Teaching undergraduate business courses online in Management and Communication skills, Employment Law, Human Resources Management, Critical Thinking and Organizational Behavior
TRAINING & CERTIFICATIONS
In Progress: Prep for Certified Business Analyst – CBAP Certification (2008)
In Progress: ITIL Foundations Certification
Brainbench Certified – Public Transcript ID# 4260630 – Brainbench.com
Formerly certified in: MS SQL Server Administration, Data Modeling Concepts, Data Warehousing Concepts
Software Systems Analysis & Networking Concepts
KEY TECHNICAL SKILLS/KNOWLEDGE AREAS
Project Management
Business Analysis
Requirements Gathering
Datawarehousing and Business Intelligence
Systems and Data Analysis/Design
Manual QA/Testing
End-User Training & Support
General Networking & PC Hardware
Data Transfer & Migration
Database Testing / De-Bugging
Cognos/Crystal/Bus. Objects Reports
Reporting and Data Analysis from Oracle and SQL Server databases
UML, MS Visio, SQL, HTML/XML
SDLC (Software/System Dev. Life Cycle) Flowcharting/Diagrams (Visio)
ADDITIONAL TECHNICAL SKILLS
Cognos BI/Business Objects/Crystal Reports, Star Schemas and Dimensional Modeling, MS SQL Server 2000 and 2005 Admin and (DTS/OLAP), Oracle, Win NT/2000/XP Professional and Server, UltiPro (HRIS), Great Plains/MS Dynamics, Visio, SQL, Crystal Reports, MS Project, Visio, MS Office (Access, Excel, PowerPoint, Word), General Networking and PC Hardware.
AFFILIATIONS
Miami User Group – MS and SQL Server Database Administrators
Society of Human Resource Management
South Florida Business Analyst User Group (IIBA Member)
PUBLICATIONS
White Paper published: “The Impact of Technology on HR for the next Century” – Society of Human Resources Management
Member number:9954
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2006 Steven Gara and Software Contractors' Guild,
3 Country Club Dr., #303, Manchester, NH USA 03102