SUMMARY:

• Business Analyst with strong analytical and requirements gathering skills, for retail, banking, healthcare and government.
• Excellent interviewing, communication, and writing skills. Extensive reporting with Oracle and MSSQL Server design and implementation expertise.

TECHNICAL SKILLS:

Tools: & Apps Data Warehouse (RDW) Warehouse Management System (RWMS) Merchandising System (RMS) Demand Forecasting (RDF) Price Management (RPM) Retek ETL (RETL) Sales Audit (ReSA) Store Inventory Management (SIM) Logical, Physical, Business Process Modeling, star and snowflake models using Erwin ER Studio Toad Data Modeler

Database tools: PL/SQL - Package and Procedure writing ETL SQL Plus Toad T-SQL Informatica Power Center

Batch schedulers: AppWorx Control - M Tivoli

Reporting tools: MicroStrategy Oracle Reports Business Objects OBIEE

Other tools: Microsoft Office Suite Remedy MS Project PVCS

Languages: SQL (various forms) JMS PL/SQL R Shell Scripting C++ ETL Java

Databases: Oracle 8i,9i,10g,11g,12c MySQL SQL Server NoSQL DB2 Teradata MS Access

PROFESSIONAL EXPERIENCE:

Senior Business Analyst

Confidential

Responsibilities:

• Working various clients, with focus on Oracle Retail Merchandising suite, worked on a variety of tasks, including:
• Implementing and integrating various modules, RMS, ReSA, Payload Mapper, and Oracle 12c database.
• Designed and built the following to handle data importing, exporting and conversions between various Oracle Retail modules, as well as external and legacy systems.
• Packages Indexes Procedures Views Triggers Sequences
• Wrote complex SQL queries to investigate and validate data. Performance tuned the databases. Lead, and/or worked with, a team of off-shore developers from Vietnam at various times.
• Worked on various versions of Oracle Retail products from v12.0.3 to v16.0
• Worked on RMS, ReSA, RPM, RWMS, SIM, Allocations, Payload Mapper, PO

Implementation Engineer

Confidential

Responsibilities:

• Working with the BA assisted in implementing and troubleshooting the various modules
• Design and develop database components
• Had a strong focus on the batch processing using Control-M
• Setup and ran various manual and automated batches to progress the testing of each module.
• Developed the original conversion plan for RMS and RPM modules with data coming from 7 legacy systems
• Wrote many complex SQL scripts in Oracle.
• Writing in shell scripting language, developed many programs to run various custom processes on demand.
• Developed the batch diagrams and batch scripts for RMS, RPM, ReSA and Allocation
• Developed scripts on demand for the MFP team
• Attending classes for Oracle Retail modules RMS, RPM, ReSA and Allocations version 14.1
• Worked on development of AppWorx batch
• Worked on RDF module, trouble shooting performance issues

Oracle Retail Technical Consultant

Confidential

Responsibilities:

• Interviewed department heads, gathered business requirements from several teams, and designed programs to meet these requirements
• Documented business requirements, assisted in designing conversion from MSSQL to Oracle data warehouse
• Wrote functional and technical documentation including source-to-target mappings.
• Wrote many complex SQL scripts in both Oracle and MSSQL.
• Wrote programs in R, Perl, and other languages as needed
• Wrote technical designs for: ETL processes, disaster recover, and modeled database for database changes.
• Managed banking applications: Cogent QC, Poly Paths, and others
• Promoted new code through the change management system, PVCS
• Facilitated several meetings weekly with various departments

Business Analyst

Confidential

Responsibilities:

• Interviewed with each team lead for analytics and operations
• Gathered business requirements for data processing, storage, retention and SLAs
• Designed and built requirements document, both functional and technical
• Architected/modeled the data warehouse using Toad Data Modeler.
• Designed and built technical documents including:
• Functional and technical design for EDW
• Functional and technical designs for ETL processes
• Functional and technical designs for staging database
• Worked closely with DBE to define all data types, triggers, and aggregation levels
• Made tool recommendations for the business intelligence layer

Senior Data Warehouse Architect/ Business Analyst

Confidential

Responsibilities:

• Worked closely with Court Administrator, Court Clerks, and Site Managers from each county, to understand how each processed various violations and fees, to design a consistent and accurate process
• Wrote configuration documentation that the team will use to make settings to individual county court systems
• Wrote complex SQL Queries on SQL Server 2008 R2 and VBA code to query against MS Access database
• Built test scenarios and managed user testing, throughout
• Manage go-live for each county, including managing issues and maintenance after go-live
• Developed analysis tool in MS Access that seeks out and modifies configuration issues as needed based on statutory changes and other changes within, one, or many, counties
• Project used Scrum methodologies throughout entire project

Senior Business Analyst/ Systems Analyst

Confidential

Responsibilities:

• Worked with the business leads to analyze and document the businesses requirements
• Facilitated technical design sessions, then wrote technical design documents
• Installed and configured JDA Enterprise Planning (EP) back-end using architect for foundation and architect for quartz
• Built all fact table families (FTF)
• Granite tables
• Quartz cubes
• Created all new measures and attributes as well as migrate current measures and attributes
• Designed the database and quartz cubes, loaded the data and structures into EKBF, EKBS and EKBQ
• Configured and tested the database and server connectivity
• Managed all environments, including versions of installed software, users access, and architecture used
• Transferred knowledge to the client’s technical team

Lead Technology Consultant/ Business Analyst

Confidential

Responsibilities:

• Initially worked closely with the business to understand the requirements for the new data warehouse
• Interviewed business users, managers, leads and users to gather a consensus on the requirements.
• Analyzed source systems, then mapped to target systems, using Informatica and SQL Explorer.
• Worked on logical and physical data model using star schema on ERWin Data Modeler.
• Aided in ETL development using Informatica.
• Worked closely with BI team using Business Objects to build out sample reports
• Build complex functions SQL queries to aggregate, extract, join and formulate data for reports
• Assisted the company in implementing Oracle Retail MOM suite which would connect to the system above.

Senior Business Analyst / Data Architect-Modeler

Confidential

Responsibilities:

• Interviewed business leads to determine the scope and requirements for the project
• Configured RPAS module for various retailers, including Wal-Mart, Maurice's, and Dress Barn.
• Built test scripts from scratch and automated them to make testing more accurate, faster and reusable.
• Oversaw the testing of Wal-Mart configurations.

Senior Oracle Retail Consultant

Confidential

Responsibilities:

• On project for full life cycle.
• Worked closely with the BA to understand all aspects of the development.
• Wrote functional and technical designs.
• Responsible for entire batch process including RMS, ReSA, RPM, RDF and RDW, including the batch scheduling through Control-M
• Responsible for conversion of legacy data (DB2 and mainframe) into Oracle data warehouse.
• Managed between 3 and 25 personnel at various times.
• Wrote complex SQL code as well as RETL code, including packages and triggers.
• Reported to Senior Managers and Business Owners.
• Designed and wrote a batch operations guide.
• Facilitated many meetings between business owners and IT team.
• Lead support team during go-live.
• Was mentor for a team of 20 ethnically diverse individuals
• Key "go to" person during go-live, on-call 24 hours a day.

Senior Oracle Retail Specialist

Confidential

Responsibilities:

• Role was as interim Project Manager.
• Wrote a base project plan using MS Project including estimation of man-hours, and rough financials.
• Met with all department heads to design a strategy for building and converting the data warehouse.
• Lead the requirements gathering, met with 70 business owners.
• Designed documentation to be used in this process.
• Lead database architects, contributing expertise in data warehousing to aid in design.
• Role was based on preparing for the perm Project Manager while waiting for my VISA approval from Australia.

Interim Project Manager / BusinessAnalyst

Confidential

Responsibilities:

• Analyzed and advised the business on approaches to use in data warehouse, as well as the tools to use.
• Analyzed the data from both the Retek Merchandising System (RMS) and the Legacy (DB2) system.
• Configured conversion of legacy systems to Retek.
• Developed functional and technical designs as well as unit test plans (UTP).
• Modeled data marts as required.
• Lead team of five personnel, mentoring them on the nuances of ETL.
• Trained personnel on RETL development.
• Developed modules and taught classes.
• Advised on the hiring of three consultants.

Senior Oracle Retail Data Warehouse Specialist

Confidential

Responsibilities:

• As Business Analyst, was the key link with business owners, analyzing client’s requirements.
• Assessed scope and impact of the client’s business needs and translated them into technological terminology.
• Identified and documented data issues as well as functional requirements.
• Designed workflow and process diagrams along with gap analysis.
• Performed data analysis, data architecture and data modeling using ERWin Data Modeler.
• Wrote functional and technical designs for 6-modules including; Return-To-Vendor (RTV), Retek Demand Forecasting (RDF), Receipts, Markdowns, On-Order, And Inventory Aging.
• Using SQL Plus, SQL loader and PL/SQL wrote load modules for Legacy data extracted from DB2 (NOTE: the business decision was made to use SQL technologies instead of RETL),
• Worked closely with the MicroStrategy front-end development team designing and building metrics and formulas.

Senior Oracle Retail Data Warehouse Specialist

Confidential

Responsibilities:

• Automated the reporting process behind the Healthy Pregnancy Program.
• Took process from MS Excel and MS Access process to a fully automated data access tool.
• Modeled the data marts and designed process maps using MS Visio
• Configured database links to various off-site databases including Galaxy
• Wrote Policies and Procedures manual.
• Set Standards for naming conventions as well reporting standards
• Updated and prepared a physicians and surgeons survey.
• Worked with SQL Server 2000 and T-SQL

Senior Data Analyst

Confidential

Responsibilities:

• Made custom modifications to modules written in RETL in UNIX AIX
• Modified and fixed Shell Script (USS) code that was previously modified by Ross’s IT department.
• Corrected many problems in both design and function quickly, making for little or no down time.
• Performance tuned the
• Suggested many modifications that were implemented to help the batch monitoring
• Designed several reports on the batch to simplify the batch review process.
• Monitored the batch process, was on-call 24x7, using AppWorx Batch Scheduler

Retek RDW Specialist

Confidential

Responsibilities:

• Worked on various projects including Office Depot, Nordstrom's, and Sav-A-Lot
• Built and modified Oracle Forms using PL/SQL packages, procedures and triggers for RMS.
• Worked on data warehouse (RDW) team writing RETL and SQL in SQL Plus, SQL Loader, and PL/SQL
• Built and modified MicroStrategy metrics, prompts and reports.
• Wrote Batch Detailed Designs (BDD), Front-End Designs (FED), and Unit Test Plans (UTP)
• Managed project for a web portal development built on Java based platform
• Developed batch schedules in AppWorx
• Mentored young team of 20 developers
• Design project plans using MS Project