Sql Server Project
Resume:
SUSSAN JARA
Mountain View, CA ********@*****.*** 408-***-****
94040
Summary of Qualifications
. Over 10 years experience in the Information Technology industry.
. Strong analytical, interpersonal, communication and organizational
skills.
. Strong financial systems and business application skills including
relational databases.
. Experience in the public and private sectors, diverse industries
(banking, insurance, telecommunications, utilities, and industrial).
. Experience in customer support, sometimes day-to-day activities included
heavy interaction with end-users in a variety of computing environments.
. Solomon ERP.
. Proficient in Microsoft Office Suite (Excel, MS Word, PowerPoint,
Access).
Professional Experience
ACCESS GROWTH (USA)
June'2010 to August'2010
Business Analyst
- Technologies analysis developed in science parks/innovation centers
around the world.
- Team support in terms of technology and basic market research.
- Evaluate information gathered from multiple sources and decompose high-
level concepts into details.
- Automate business processes by building Excel and/or Access applications.
LINDE GAS AGA (Peru)
Oct'2004 to Jan'2008
Financial/Systems Analyst
- Administer, enhance and support of Solomon.
- Modify existing Crystal and FRX reports and develop new ones.
- Configure and administer MS-SQL 2000 database for use with Solomon.
- Write SQL scripts to manipulate information in Solomon tables and create
reports.
- Customize Solomon (VB codes) and establish proper access rights for the
modules.
- Research and correct failed transactions.
- Year end and quarter end procedures and processes.
- Assisting with special projects as required by IT and Finance.
- Liaise with the financial/accounting analysts.
- Analyze, develop, document and test new and existing processes.
- Upgrade Solomon to version 6.5
PROCTER & GAMBLE S.R.L (Outsourcing ADECCO - Peru )
Jan'2004 to Set'2004
Systems Analyst
- Applications Development and Maintenance (Visual Basic/SQL Server)
- Responsible for all phases of the development lifecycle (analysis,
design, development, testing and deployment).
- Designs, implements, and maintains database backup and recovery
functions.
- Development and Maintenance of macros (VBA Excel, VBA Access).
- Development of internal tools (queries, link tables, pivot tables, look
up tables, charts, graphs and other financial resources) to facilitate
data analysis.
- Create training documentation as needed for new or existing
modules/processes.
- Design and build a Visual Basic interface integrated with Pegasus mail.
- Create views and stored procedures in SQL Server.
- Collaborate with marketing to elicit key reporting requirements and
performance indicators.
GESFOR OSMOS (Peru)
Set'2001 to Dec'2003
Systems Programmer
- PACIFICO VIDA Project: Applications Development and Maintenance (Visual
Basic/SQL Server).
- Convert processes from VB6 to TSQL Stored Procedures.
- BANK BOSTON Project: SQL Server Database Migration, Applications
Maintenance (Visual Basic) and Reports (Crystal Reports).
- Help to solve complex business problems.
- Improve processes, analyses and reporting.
- Conduct design reviews and presentations.
- Create documentation.
- Responsible for unit testing.
- Maintain and/or construct programs.
- Design, implement, and maintain database backup and recovery functions.
BANCO CENTRAL DE RESERVA DEL PERU Jun'1998
to Aug'2001
Systems Programmer
- Applications Development and Maintenance (VBA, Visual Basic, Power
Builder, FoxPro and Cobol).
- Create applications from detailed specifications.
- Develop Excel and Access via VBA (macros).
- Provide VBA support services for all bank's employees.
- Develop new processes and implement solutions.
- Prepare financial/accounting reports as necessary.
- Month-end close and reporting activities.
- Liaise with external auditors on their requests.
- Troubleshooting, analysis and resolution of application software issues.
- Design queries, link tables, pivot tables, charts and graphs.
- Document issues and resolutions in user facing helpdesk and knowledgebase
system.
Administration and Support of Informix Database.
DESARROLLADORES PERUANOS S.A.
Jan'1997 to May'1998
Systems Programmer
- TELEF NICA DEL PERU Project: VIP Support Systems Application (Power
Builder/SQL Server )
- TELEF NICA DEL PERU Project: Migration of SQL Server Database and
Maintenance of Systems Applications (Power Builder/Visual Fox)
- Analyze tradeoffs required to meet business needs
- Support in the day-to-day running of the IT business
- Create new user accounts, and correcting issues reported by users.
- Analyze information system requirements, create designs, and provide
documentation by utilizing Visio.
- Maintain and construct programs.
- Create data dictionary.
- Research and correct failed transactions
Education
San Jose State University Fall 2009 -
Present
Master of Science in Industrial and Systems Engineering
Universidad Nacional Mayor de San Marcos - Peru 05/1992
- 12/1996
Bachelor of Science in Computer Science
Universidad Nacional Federico Villarreal - Peru 05/1994-
12/1998
Bachelor of Accounting
Additional training:
. Supporting Users and Troubleshooting MS Windows Desktop Operating Systems
. Information Technology Audit.
. Oracle DBA and Developer
. Web Programmer :Windows NT, SQL Server, Java Script y DHTML, Visual
Interdev and Asp
Technical Proficiencies
Platforms : Microsoft Windows NT/98/2000/XP/2003, Linux
Programming : Microsoft Visual Basic, .Net, Power Builder
Databases : SQL Server, Oracle.
Utilities : Rational Rose (UML), Erwin.
Hardware : IBM/HP servers, IBM/Dell/HP Desktops and Notebooks;
printers and print servers; hubs and switches; wireless
equipment.
Software : Lotus Notes, Outlook, MS Office, Open Office, Crystal
Reports, different software Anti Virus, Adobe Acrobat, Norton
Ghost, MS Visio, Ms Project, MS Access.
Other Personal Details
. Spanish / English
. French (intermediate level)
. F1 Visa/ US Employment Autorization Document
Contact this candidate