Project Sql Server
Resume:
Patricia Marin
• *** ***Th Drive Apt *** • Sunny Isles Beach, FL, 33160 • **********@*********.***
**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