OBJECTIVE:

To obtain a challenging position with growth opportunities in the information technology industry, in which I may effectively utilize my education, technical skills and management experiences.

SUMMARY OF CAPABILITIES:

• Background includes practical experience and education, which have provided detailed working knowledge in these key areas:
• Management experiences include:
• Purchasing, Production and Inventory Control
• Supervising, hiring and training of personnel
• Developing effective marketing techniques
• Shipping and Receiving, Credit and Collection procedures
• Technical abilities include:
• Microsoft SQL Server 2005 2008, SQL Reporting Services 2005, 2008 SSRS R1 R2, SSIS
• SAP Crystal Reports 2011
• C, C , Unix, Linux
• Rational Methodology RUP, UML
• Microsoft Windows Windows NT, Windows 2000, Windows XP , Microsoft Office Suite, Visio, Microsoft Visual Studio
• ORACLE 10g, 11 database, ORACLE Designer/Developer 2000 series including: ORACLE PL/SQL, ORACLE Forms, Data Modeling, ORACLE Database Administration, ORACLE Smart Client, SQL Server Tool for Oracle Developers TOAD , ORACLE ERP modules RMS
• PL/SQL, T-SQL, FOCUS/RAMIS and DYL280 reporting languages
• Visual Basic, Crystal Reports
• Remedy Suite Incident Management, Change Control Management
• Microsoft Sharepoint 2010
• ITIL Framework
• COBOL Mainframe PC , CICS, DB2, IMS/DB/DC
• IBM Mainframe - OS/MVS, JCL, ISPF/TSO, UCC/CA7, ACF2/RACF
• VSAM, IDCAMS, File-Aid, Endeavor, Xpediter, Librarian

EMPLOYMENT HISTORY:

Confidential

Senior Business Systems Analyst

Major responsibilities include:

• Business and technical system analyst for Boot Barn's retail operations systems Shipping, Receiving, Planning, Buying, Inventory . This included all SDLC Methodology including requirements gathering, analysis, design, creating functional and technical specifications, construction, Unit UAT testing and deployment.
• Area of work involving developing and maintaining complex queries multiple table joins, CTEs, Cursors and Sub Queries , stored procedures, user-defined functions and triggers Data and Event using MS SQL Server 2005 2008 and Epicor ERP software.
• Created ETL Extract, Transform, Load processes to extract data from Epicor Enterprise databases and load SSIS, BCP and Bulk Insert into Boot Barn's in-house Data Warehouse.
• Data base modeling for new Data Warehouse. This included developing Star Schema models, designing and building new databases, tables, creating development and UAT environments.
• Tuned and Monitored new MS SQL Server databases for peak performance using SQL profiler, Tuning Wizard and SQL Query Analyzer for Query optimization.
• Created various parameterized Matrix Crosstab and ad-hoc Summary, List, and Tabular reports extensively using SSRS 2008 for the Sales, Inventory and Planning business users.
• Created Custom Layout Vendor Management reports Matrix, List/TAB, Drill down and Drill Thru, Sub Reports and Charts using SSRS for the Buying users.
• Developed Data Visualizations Dashboards for various business users using SSRS.
• Deployed SSRS reports to Report Manager, administered reports, subscriptions and user permissions for report execution.
• Designed, developed and implemented Production Sales and Inventory reports using Crystal Reports 2011.
• Provide technical expertise to business users to resolve problems, recommend system improvements and enhance system performance.

Confidential

Senior Programmer/Analyst

Major responsibilities include:

• Supported a stand-alone in-house flash-sales reporting system for daily sales metrics using SQL Systems Reporting Services SSRS
• Programmer and technical system analyst for the RMS - Oracle Retail software formerly known as Retek project.
• Task performing in a full cycle of a project implementation including business requirement gathering, functional design, technical design, writing program built-code application, unit test plan, UAT and system test plan document, modifying and enhancing custom add-on applications to enhance the base RMS software.
• Area of work involving RMS, RDW, RPM, Allocation, Purchase/Order, Trade Promotion Deals Allowance, Warehouse Management System using Oracle database 10g, Pro C, Oracle PL/SQL and Unix Shell script to write program codes for new custom programming, enhancement of existing application of the RMS software package.
• Participating in project planning session, programming methodology, quality assurance testing, cut-over and go-live in production environment for the RDW, and RMS system.
• Responsible for RMS and RDW applications and systems in defect fixing, code enhancement, data research and analysis, user questions and answers on technical/functional business area as subject-matter-expert, 24/7 on-call support for applications break-down and resolution for one year duration.
• Quality Assurance Testing team member as a technical programmer analyst/advisor. Designing test script with test case scenario, data set up, program execution, log and error file program result run validation. Writing new programming code, fixing incorrect existing programming code due to defects while performing QA tasks writing complex SQL query for testing team, running test script execution, maintaining support for other testing team members in the capacity of Unix, Java coding and debugging, error and log file research/analysis, Oracle data base SQL performance tuning.
• Acting as mentor to other team members in application programming methodology improvement, application testing and quality assurance works, bug defects fixing as knowledge expertise in the area of Oracle database and Unix system environment.
• SME area in RMS Purchase Order, Deals Allowance, Allocation, Promotion, RMS Data Warehousing, RMS Pricing Manager.
• Technology using in the project: Oracle data base 10g, Pro C, PL/SQL, Oracle Form/Report, UNIX programming and UNIX shell scripting.
• Provide technical expertise to business users to resolve problems, recommend system improvements and enhance system performance.
• Upgrade system interfaces between Markdown Optimization MDO and
• Retail Price Management RPM
• Supported Wet Seal's Sales Auditing system to ensure accuracy and performance
• Redesigned and tuned various SQL and PL/SQL processes and Oracle Forms and Oracle Reports
• Supported nightly batch processes to insure successful execution using Autosys job scheduling system.

Confidential

Technical Specialist

Major responsibilities include:

• Developed ETL processes, new reports rdf and publishing procedures for Logistics Database project using SSRS, SSIS
• Gathering user requirements, developed business use cases using RUP UML, writing functional technical specs, designed test scripts, data extraction and User Acceptance Testing per department policies
• Design, Code and Test Application Software for Ingram Micro IM-FIRST Warehouse Management ERP logistics systems using C/C , Oracle PL/SQL, Linux, KRON job scheduling and Oracle database system.
• Coordinate interface data mappings for SAP conversion project
• Key member in Global Warehouse Management System Installation in Sydney, Australia
• Technical Lead for Expand Control Id project to enhance purchase order processes
• Key member of Logistics Database project centralized reporting repository for Logistics data warehouse using Microsoft SSRS, SSIS, Oracle PL/SQL
• Gathering user requirements, writing functional technical specs,
• designed test scripts, data extraction and User Acceptance Testing
• per department policies
• Technical datamart, data cube and Stored Procedures, T-SQL reporting languages

Confidential

Senior Consultant

Major responsibilities include:

• Gathering user requirements, developed business use cases using RUP UML, writing functional technical specs, designed test scripts, data extraction and User Acceptance Testing per department policies
• Design, Code and Test Application Software for Yamaha Motors COMAND Vehicle logistics systems using MVS COBOL CICS Batch , VSAM files.
• Project Coordinator work with Project manager on plans, schedule meetings and update project schedules and status, coding costs and estimates, adhere to SDLC methodologies.
• Coordinate requirements, specifications and documentation between end user community and technical staff
• Gathering user requirements, writing functional technical specs,
• designed test scripts, data extraction and User Acceptance Testing
• per department policies
• Help coordinate interface data mappings for SAP conversion project

Confidential

Senior Consultant

Major responsibilities include:

• Gathering user requirements, developed business use cases using RUP UML, writing functional technical specs, designed test scripts, data extraction and User Acceptance Testing per department policies
• Design, Code and Test Application Software for Pacific Life Reinsurance ERP financial systems using Oracle PL/SQL, MVS COBOL, VSAM files and Focus Reporting languages.
• Developed Executive Management Life Insurance product reports using MS/SQL and SQL Reporting Services SSRS SSIS . Included data mapping and rdl file creation for reports.

Confidential

Senior Consultant

Major responsibilities include:

• Project Coordinator for Personal Watercraft project PWC for American Honda Motor Co., Inc. Assist in scoping, design and development phases for major implementation project of new product line, work with Project manager on plans, schedule meetings and update project schedules and status, coding costs and estimates, adhere to SDLC methodologies
• Gathering user requirements, developed business use cases using RUP UML, writing functional technical specs, designed test scripts, data extraction and User Acceptance Testing per department policies
• Coordinate requirements, specifications and documentation between end user community and technical staff
• Design, Code and Test Application Software using COBOL II, VSAM files, CICS/DB2 programming languages