SUMMARY:

Strong Business Analyst and Senior Technologist, with extensive Oracle and MSSQL Server design and implementation expertise. Experience in managing and leading several teams during design and implementation of enterprise level data warehouse installations. The ability to drive projects to success through proper management of resources and time as well as a proven track record of leading teams through a superior knowledge of both the technologies and the business. Willing to work at all levels to assist in implementing a successful project.

EXPERTISE AREA:

• Tools & Apps: Oracle Retail E - Business Suite, including:
• Data Warehouse
• Merchandising System
• Sales Audit
• Demand Forecasting
• Allocations
• Store Inventory Management
• Price Management
• Warehouse Management System
• ETL (RETL)
• JDA Enterprise Planning 7.6
• Logical, Physical & Business Process Modeling using Star and Snowflake models
• Erwin
• ER Studio
• Toad Data Modeler.
• Informatica, IBM WebSphere, Data Stage, Oracle Forms, PL/SQL, Package and Procedure writing, SQL Plus, T-SQL, SQL Loader, Toad, CRT, SSH AppWorx, Control M, and Tivoli Batch schedulers

TECHNICAL SKILLS:

Front-end and Middleware: MicroStrategy, Business Objects, Oracle Reports, OBIEE.PVCS, Remedy, Microsoft Office Suite, MS Project, MS Access

Languages: C, C++, Java, JMS, SQL, PL/SQL, RETL, Shell Script, Perl, VB, XML

Databases: Oracle 8i, 9i, 10g, 11g, 12c DB2, SQL Server (2005, 2008, 2008 R2, 2012), Teradata

Other: Have strong communication skills, experienced functional and technical document writer, experienced Business Analyst, Architect, and Data Modeler, as well as strong leadership and mentoring skills

PROFESSIONAL EXPERIENCE:

Confidential

Implementation Engineer

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 both 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 training classes for Oracle Retail modules RMS, RPM, ReSA and Allocations version 14.1

Confidential

Technical Consultant

Responsibilities:

• Worked on development of AppWorx batch
• Worked on RDF module, trouble shooting performance issues

Oracle Retail Technical Consultant

Confidential

Responsibilities:

• Working closely with the business, was charged to interview department heads, gathered business requirements from several teams and designed programs to meet these requirements
• Wrote functional and technical documentation as well as source-to-target mappings.
• As Business Analyst designed conversion from MSSQL to Oracle data warehouse
• Wrote many complex SQL scripts in both Oracle and MSSQL.
• Wrote programs in C#, Visual Basic, Perl, and other languages.
• Wrote technical designs for ETL processes, disaster recover as well as modeled database for major project
• Managed applications including with Cogent QC, Poly Paths, MSSQL and Oracle Databases, BCMS, and other banking applications, including promotion of new code through the Change Management system
• Facilitated several meetings everyday

Senior Applications Systems Analyst

Confidential

Responsibilities:

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

Senior Data Warehouse Architect/ Business Analyst

Confidential

Responsibilities:

• Analyze MNCIS configurations for each county in Minnesota
• Worked closely with Court Administrator, Court Clerks, and Site Managers to understand how each county processes various violations.
• Write configuration documentation that the team will use to make settings to individual county court systems
• Write complex SQL Queries on SQL Server 2005 as well as VBA code and SQL queries on MS Access
• Build Test Scenarios and manage user testing
• Manage go-live for each county, including managing issues and maintenance after go-live.

Confidential

Responsibilities:

• Developed analysis tool in MS Access that seeks out and modifies configuration issues as needed based on Statutory changes and other changes within, many (or one), counties
• Developed using Scrum methodologies
• Built using a combination of VBA code and complex SQL

Senior Business Analyst/ Systems Analyst

Confidential

Responsibilities:

• Worked with the business leads to analyze 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
• Configure and test the database and server connectivity
• Managed all environments, including versions of installed software, users access, and architecture used
• Transfer knowledge to the client’s technical team

Lead Technologist Consultant

Confidential

Responsibilities:

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

Senior Data Architect

Confidential

Responsibilities:

• Met with business to determine the criteria they would be required for this application.
• Configured RPAS module for various retailers.
• Built test scripts from scratch and automated them to make testing more accurate, faster and reusable.
• Oversaw the testing of Wal-Mart configurations.
• Worked on teams of between three and twenty-five people.

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, RDF and RDW, including the batch scheduling through Control-M
• Responsible for conversion of legacy data (DB2 and mainframe) into data warehouse, including configuration of database links.
• 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

Confidential

Responsibilities:

• Analyzed and advised the business on approaches to use in the data warehousing 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.
• Brought on to train personnel on RETL development.
• Developed training modules and taught classes.
• Advised on the hiring of three consultants.

Senior 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, Markdown, 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 Data Warehouse Specialist

Confidential

Responsibilities:

• 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