Experience

Confidential

BI Delivery Consultant

• Serve as senior business consultant for the Information management and analytics division where I help develop enterprise wide strategies for clients in regards to managing their data and how to increase its value. Using reporting tools and data/project management methodologies as well as functional data analysis, I design and implement solutions that increase efficiency and add value to client operations. Some of my responsibilities include managing project teams, facilitating JAD sessions, requirement identification and documentation, process re engineering, creation of data warehouse schemas and data models and process flow diagrams, advising clients on long term enterprise goals, strategies, and tools.
• Completed a comprehensive analysis of ETL Processes, Data Architecture, Data Governance and Analytics efforts of HP's Channel Sales Division. This is HP's Hardware Sales Channel at a world wide scale. I worked as the team lead of three other consultants doing process, architecture, and data governance analysis and requirements definition work. The goal is to enable our Sales Channel teams to define and implement a robust and efficient network of data marts and warehouses. Defined Analytic Processes, Data Sources, Functional and Non-Functional requirements, Facts and Dimensions, and Business drivers which exist in our Sales Channel Business model. Documented and presented our findings and suggestions Senior managers and directors. We identified our Key Performance indicators and delivered them with conceptual Data Models. This enabled our sales teams to increase revenue, profitability, efficiency, as well as forecast ability.

Confidential

Lead ETL and DW Architect

• Served as lead ETL and DW architect for Confidential of Health RFP. This was a 15 million dollar project. Designing and architecting solution for communicable disease Data Warehouse. Designing the data models and security models for new DW and Report Delivery system. I was tasked with designing the architecture for initial DW loads as well as incremental loads that will keep the application databases in sync with the DW. Documented the functional requirements and tied them into the data models. The need is to integrate the existing application data as well as a new application that is being developed to track disease, population, immunization, and provider information. Was in charge of design sessions, communicating with the Ministry with questions and issues, Estimated resources needed to complete the effort, and estimating the hardware needed to support the solution. Lead a team of other architects to develop the complete BI solution including Information Delivery, Analytics, and Governance.

Confidential

Project manager

• Conversion team lead and Project manager for Confidential Assistance Eligibility system project leading a team of 9 developers and 2 Business Analysts. Performed process analysis and re-engineering to improve efficiency and costs. Removed dependency on a third party tool saving project over 100,000.00. Managed defect resolution process, driving team to make these a priority by adding estimates and deadlines and holding bi weekly meetings to go over progress and issues. Developed an automated process that will save the team over 100 hours of future manual work. Developed an onboarding document to help make new employees productive within first two days of being on the project. Drove team to break out tasks not on the project plan and get estimates and set deadlines in a more detailed and manageable manner. Managed Change request process to manage scope and determine estimates for completion of the work. Modified the existing 9,000 line Conversion project plan to remove redundant effort and define processes to client satisfaction. The resulting plan was consolidated into less than 3200 tasks making it much easier to report accurate status updates and identify issues earlier.

Confidential

Process improvement engineer

• Developed and re-engineered several processes for a Reporting Delivery Group Supporting xpedx in Confidential. To better support their client and to develop a robust and high quality delivery system, I was asked to review their processes, redesign the ones that were flawed or inefficient, create new ones where needed, and document the processes at a detailed level. This included developing a configuration management plan and implementing version control software, Creating a One stop Onboarding document for new hires, creating a Best Practices guide for developing Crystal Reports, and developing process guides for creating/modifying reports. I also integrated a new test/QA environment to help resolve issues found by the client while reports are still under development. I led Process review sessions with team leadership and identified issues and resolutions. I also filled in on a few report modifications during my assignment. I am currently completing this assignment. I attempted to implement CMMI methodology and some form of it is still being used by the client today.

Confidential

Team Lead and Project manager

• Data Architect, Team Lead and Project manager for Confidential Project Data Conversion team. Managed team of up to 14 data analysts and 15 ETL developers developing processes to load legacy application County Court data into the databases for new Confidential applications. Interface with client and upper management setting priorities, delegating tasks to meet deadlines. Designing solutions based on customer and application requirements. Delivering metrics of weekly progress to ensure meeting the project plan for conversion team. Developing testing strategies and technologies to prove our conversion is acting correctly to the customer's satisfaction. Responsible for design and access to our testing environments for ad hoc testing. Interviewed and hired new development staff. Estimated effort and assigned resources. Updated weekly team progress to project plan and updated status report which was delivered to upper management on a weekly basis. Liaison between Testing team, Training team, IT Support group and the conversion team. Conducted requirements gathering effort. Facilitated Joint Application Design JAD and other design sessions. Coordinated activities with client and external agencies and interface partners. Oversight and administration of all project administration deliverables. Creation, Oversight and administration of detailed work plan and dashboards. Identified and documented Risks both internal and external to the project via risk management meetings and a risk tracking application. Helped set up our project schedule determining estimates and priorities, as well as assigning/leveling resources. Responsible for release management and Change management for all conversion related code/data.
• Technologies utilized
• MSProject, Office 2010, Sharepoint, Visio, SQL Server 2008, .NET 2.0/3.0, TFS, vb.net, C .net, Visual studio, CoreFTP, Erwin

Confidential

Owner/Consultant

• Clients include an Accounting Firm, a third party Claim Processing Bureau for The Second Injury Fund, a Large Financial Institution based in Columbia as well as a consultant for an Application Integration company. I have been responsible for managing all facets of these projects. Including supervising less experienced developers.

Some projects included ..

• Confidential - Created a Custom Accounting browser app for a small business including payroll, timekeeping, and an invoicing system. ASP.NET
• Confidential - Processed 4 separate data conversions with over 15 million records using SQL 2000, Visual Basic 6 , and ADO.
• Confidential - Created Custom Claim processing system to track file info for over 30,000 clients. VB.NET Met with the owner and end users to design an application which transformed their business from a file based system to a computer based system.
• Confidential ASP.Net VB.Net, C , SQL, Crystal Reports - Customized third party application so it was a better fit for the client's business model. Modifications and enhancements to a back office app managing accounting, inventory, client relationships, job scheduling and tracking as well as job costing.

Confidential

Senior Conversion Analyst

• Worked as part of the data acquisition team to collect data from various public information channels to load in to national Background Check database. Primarily designed, developed and tested a process where business names were loaded into our database so that they could be searched/indexed for lookup. This had always been a people database and this was a new service that GIS was able to leverage and market to other clients.

Technologies utilized

T-SQL, Visual Studio 2005, SQL Server 2008

Confidential

Senior Information Management Consultant

• Managed Quarterly Data Collections for the State Department of Education. Currently in charge of the data collected from the individual school districts across South Carolina. Extracted data is delivered to other state agencies, universities, and government entities throughout the year. Designed/Developed applications in VB, using SQL 2005, and access.
• Used Actuate to report on student and other educational data. Developed stored procedures to mine this data.