Analyst /Programmer Resume Carlsbad, CA - Hire IT People

SUMMARY

Experienced Analyst and Programmer wif strong analytical skills having worked in various industries including Manufacturing, Health Insurance, Mail Order Pharmacy, Banking.
Extensive experience wif Financial Systems including AR, AP, Data Warehouse, Inventory and Order Entry.
Project level assignments has included working wif all levels of management and staff through the SDLC process, such as Requirements gathering, Analysis, Design, Coding, Testing Training, Implementation as well as documentation including Flow diagrams, Functional specs., use case senarios etc. .
Non - project duties included remediation of System Failures, break/fix analysis, data analysis and ad-hoc reporting.

TECHNICAL SKILLS

Languages: Basic (VB, VBA & Vax), Cobol (Vax), SQL/T-SQL, DCL (scripting)

Database Platforms: MS-SQL Server, Sybase, MS-Access, VAX RDB & RMS

MS-SQL Server: SQL-stored procedures/ Views/ SSIS/ Administration

ERP / MRP/ Financial systems: M S-GP 2010, MAXCIM, MACPAC/D, Deltec Accounting, RX Express Order Entry

Project Management tools: MS-Project

Version Control / Change Management: CMS, Visual Source Safe

Documentation Tools: V ISIO, MS-Word

Operating Systems: VAX-VMS, MS-Windows

PROFESSIONAL EXPERIENCE

Confidential, Carlsbad, CA

Analyst /Programmer

Responsibilities:

Created and implemented a Financial Data Warehouse in SQL Server(2012) in order to faciitate inproved reporting and data access, this included working wif users on design and testing,
Created SSIS packages and setup batch jobs on WINS server to import data from legacy system. Also created database user profiles and assigned permissions based on users needs, created ODBC connections for users familiar wif MS Access.
Daily duties included using T-SQL to create summarized and detailed data extracts and Pivot tables for offsite Sales staff, also halping users wif database related issues (Access and SQL). Other daily duties included Ad-Hoc reporting using SSRS and Crystal reports also created parameterized Excel reports calling stored procedures using T-SQL and VBA.
Supported legacy VAX Financial and Manufacturing systems, resolving issues reported by users

Environment Windows, SQL-Server, MS-Access, Excel, VMS ( Basic, DCL and IDML)

Confidential, Woodland Hills, CA

Analyst /Programmer

Responsibilities:

Environment: VMS ( Cobol, Basic, RDB, SQL) Windows,, Excel

Confidential, St Louis, MO

Analyst /Programmer

Responsibilities:

Working on Order Entry system in the Retail Drug Dispensing market .
My responsibilities included analysis, coding and Implementing changes in response to requests arising from changing business and regulatory needs, This included amending order handling for states and certain classes of drugs, changing interaction handling for particular drugs and conditions .
Ad-Hoc reporting of drugs dispensed in States for given time periods.

Environment: VMS ( Cobol, RMS ), Windows, Excel

Confidential, Norwalk CA

Analyst /Programmer

Responsibilities:

Working on Payroll systems . Responsible for analysis, coding, testing and implementing new reports and screens in response to user requests .
Investigating Bugs and performing fixes .
Developing VB programs to upload Reports from Vax and converting to word format, then emailing to specified users .
Uploading data from RMS files to ORACLE Database .
Coding DCL procedures

Environment: VMS (Cobol, RDB, SQL.), Windows, SQL-Server, Visual Basic,