Post Job Free

Resume

Sign in

Project Sql Server

Location:
North Miami Beach, FL
Posted:
September 04, 2014

Contact this candidate

Resume:

Patricia Marin

*** ***Th Drive Apt *** • Sunny Isles Beach, FL, 33160 • acfrpz@r.postjobfree.com

786-***-****

**MICROSOFT CERTIFIED PROFESSIONAL GREAT PLAINS FINANCIAL**

Professional Profile

Provide systems consulting including project planning and management, business analysis and design including

requirements definition, user support activities, testing and documentation. Areas of expertise include financial,

billing and human resource systems, and other mainframe and workstation platforms. Active participant in the

Microsoft forums to stay up to date on new technology

Technical Proficiency

Microsoft Dynamics Great Plains Expert

SDLC Strong

UML Strong

Business Analysis (Specifications, Requirements and Strong

documentation)

Functional testing ( Unit, Integration, System testing) & Testing Strong

Documentation

Microsoft Project Strong

Microsoft Office (Word, Excel, PP, Access Outlook, Visio) Strong

MS SQL Strong

SQL Server Reporting Services (SSRS) Strong

Oracle Advanced

Agile Advanced

Crystal Report Strong

.Net Architecture Advanced

Professional Experience

K brand Marine, (Cruise Line Distributor) Miami, FL (Apr 2010 Current)

GP Analysis/Accounting

MS Dynamics Great Plains full range support for line of business software Accounting, Inventory

Control, AR/AP, Project Accounting, Purchasing. User Account maintenance, Security management.

Troubleshoot user issues across all modules and phases of user experience. Test and deploy solutions according to

Change management policy. Ensuring that system issues are resolved in a timely and efficient manner to meet

the month end and quarter end deadlines. Work with the functional teams to evaluate and develop detailed

documentation of system enhancements and business cases supporting the enhancement, define business process,

modeling and business Analysis. Performed technical project, initiation, collection and documentation of client

business and functional requirements, solution alternatives, functional design, testing and implementation

support.

• Manage SQL Server side of business in support of GP System including writing SQL code for reporting,

building Smart Lists, importing data, writing custom GP macros, writing stored procedures for SSRS reports

analyze & troubleshoot day to day issues. Develop management tools to measure and analyze financial and

operational information

• Process A/P, maintained up to date vendor statements to ensure timeliness and completeness, communicated

with vendors to resolve questions and concerns on invoices, issued of checks to vendors, process ACH and

WIRE payments, ran aging as required to identify current items due for payment.

• A/R by recording cash, checks, and credit card transactions. Summarizes receivables by maintaining invoice

accounts, coordinating monthly transfer to accounts receivable account; verifying totals; preparing report,

month closing, an reconciled bank accounts, prepare financial statement as required. Processes weekly payroll,

and taxes.

• Managed the overall administration of Microsoft Dynamics Great Plains, run all these applications through

Dynamics Utilities, apply service packs, hot fixes, Create a company database, add/change/delete Intercompany,

add/change/delete Currencies, Exchange Tables, and Multicurrency Access, add/change/delete a user,

add/change/delete user access to a company, add/change/delete tasks to security roles, add/change/delete

security roles, assign user security, run any maintenance.

The Poolzone.com, (E Commerce) Balharbour, FL (Jan 2008 Mar 2010)

Bookkeeper

Received, recorded, and deposited cash and checks as well as reconciled records of bank transactions.

Received approval of all accounts payable invoices and supplied payments to vendors on a weekly basis.

Reconcile all bank and credit card accounts, and merchant companies. Researched and resolved collections

and billing disputes.

All around Maintenance, Pembroke Pines, FL (Mar 2007 Dec 2007)

System Administrator/Bookkeeper

Maintain and administer computer networks and related computing environments, including computer

hardware, systems software, applications software, and all configurations. Plan, coordinate, and implement

network security measures in order to protect data, software, and hardware.

Operate master consoles in order to monitor the performance of computer systems and networks, and to

coordinate computer network access and use. Perform routine network startup and shutdown procedures, and

maintain control records.

Received, recorded, and deposited cash and checks as well as reconciled records of bank transactions.

Receive approval for supplied payments to vendors on a weekly basis. Create a new invoicing program in

Excel. Reconcile all bank and credit card accounts. Researched and resolved collections and billing disputes.

Processed payroll, electronic deposits, issued paychecks to contractors on a bi weekly basis, issued W2 s to

employees & 1099 s to contractors.

National Police of Peru, Lima, Peru. (Jan 97 Dec 2006)

Logistic PNP.

BA/Project management

• Plan, schedule and execute all stages of enterprise software, hardware and system implementations. Assessed

business implications for each project phase and monitored progress to meet deadlines, standards and cost

targets.

• Guiding the work of technical teams. Articulated project goals and scope, translated business needs into

technical terms, prepared detailed work breakdown structures (WBS) and instilled shared accountability for

achieving project milestones for Distribution Management System and Reimbursement System (relocation).

Oversaw working of project life cycle and coordinated with various departments.

Software Engineering Department

System Analyst

Gathering, business process flow, process, modeling and business Analysis. designed specialized features

using SWOT and Knowledge of the Software Development Life Cycle (SDLC) phases such as Planning,

Analysis/Design, Development, and Testing for the software/system development process. Develop

customized client reports with Visual Basic and SQL server. Performed DB design, and system maintenance,

Prepared functional requirements documents to identifying options for potential solutions and assessing them

for both technical and business suitability; drawing up specific proposals for modified or replacement

systems; producing project feasibility reports.

Peru National Police Hospital/ System Analyst

Gathered user requirements, designed the framework using UML that included identifying the use cases and

its surroundings, drawing use case diagrams, identifying classes, drawing class diagrams and sequence

diagrams for Outpatient management system. Extensively involved in the Database design and used

ADO.NET and Visual Basic tools for retrieving information from the database. Extensively involved in

database migration. Written SQL Queries, Stored Procedures, Triggers, Backup and Restore Database,

Defining roles, creating database users, Assigning Roles to users using SQL Server 2005. Extensively

involved in Stored Procedures Optimization. Participated in full software development life cycle. Prepared

project plan using Microsoft Project. • Done unit testing, integration testing and regression testing. Testing of

database, queries optimization and performance.

Emergency Central 105/ System Administrator

Windows NT Administrator, Windows server, AD, (Setting up User Accounts. Setting Up Group accounts

administering User and group accounts Securing Network Resources with Shared Folder Permissions).

Troubleshoot server hardware and software issues and escalate accordingly. Assist as part of a team in

building and managing lab environments with complex settings, configurations, topologies and equipment

including servers and various network elements. Prepared the environment for deployment of Windows

Server 2003. Analyzed the hardware and software requirements of Active Directory. Installed, configured,

and provide troubleshooting for Server 2003. Migrated Windows Server 2003 from test environment to the

production environment. Implemented and managed IP Addressing; configured TCP/IP addressing on a

server. Created the Forest Root domain, and a Child domain in a production environment. Installed and

configured an Active Directory Domain Controller.

Education

Strayer University, Fort Lauderdale, FL 2009 Jun14

BS Information Technology

Federico Villarreal University, Lima, Peru 1997 2002

BA Public Business Administration

ESAN Graduate School of Business, Lima, Peru 2003

PEE Information Technology

Development of strategies to support the transformation of the organization into new business models.

Develop business plans to obtain a maximum value of the investment in technology infrastructure.

Planning a successful IT strategy to support the organization.

Currently preparing the Six Sigma Yellow Belt certification.



Contact this candidate