TECHNICAL SKILLS:

• Client Server Developer
• 16 years MS Access and Excel development VBA
• Microsoft Dynamics AX
• SAP CRM
• 13 years of SQL Server
• 7 years of Oracle
• 7 years of data warehousing
• Sybase and Citrix
• SharePoint Development
• Web analysis and development
• 10 years ERP System life cycle development
• 13 Business Process Design
• 8 years of business process re - engineering
• 10 years of system testing
• BODS
• SAP Data Migration
• Technical Business Analyst
• PowerPoint

PROFESSIONAL EXPERIENCE:

Sr, Business Analyst

Confidential

Responsibilities:

• SQL Server upgrade and Administration for Clinical Evaluations
• SQL Server upgrade and Administration for Clinical Data Analysis
• Lead the appropriate teams to refine, prioritize and manage requirements using various tools (e.g., templates, team backlogs, requirements management or agile task management applications)
• Lead the appropriate teams to build the business case and project justification
• Lead requirement walk-throughs with key stakeholders using various methods (e.g., team demos, workshops, sprint planning and backlog refinement sessions)
• Identify and estimate anticipated work efforts based on priority using requirement work plans, program increment (PI) and sprint planning
• Define and resolve dependencies, issues and risks along with identification of impacted areas through team collaboration

Sr Analyst

Confidential, VA

Responsibilities:

• Upgrades to SQL Server and Access Front End for Production of Russian manufacturing facilities
• SharePoint administration and development for reporting purposes and work order creation
• Monitor application business, batch and system processes
• Respond to user requirements, problem resolution, develop designs, and process modeling.
• Collaboration with Business Partners to ensure project success
• Conduct configuration changes to accommodate change requests and prototype activities.
• Ensure common configuration across business units where appropriate.
• Defining maintenance and other improvements as needed.

Sr. Analyst

Confidential, Washington, DC

Responsibilities:

• Migration of Forest Service from Lotus Notes to Active Directory.
• Lead Analyst on Technical Issues on Updating Data Feed Structures and Mapping.
• Technical Resource for Architecture Updates in SQL Server Integration Services.
• Developed Complex reports to accommodate New Data elements in Access
• Managed Change Management Request for System Access for Government Employees on Daily Basis.

Sr. Analyst

Confidential, Richmond, VA

Responsibilities:

• Migration of 20 SQL Server Databases to Virtual Server. (SQL 2008)
• Evaluation/Migration of ICD 9 Billing Codes to ICD 10.
• Presentations of Changes to Emergency Room doctors and Nurses on Procedure Changes.

Sr. Migration Analyst

Confidential, Fort Lee, VA

Responsibilities:

• Successfully Engineered Training Confidential data for Web Based SAP Confidential Application.
• Assisted on Technical Issues with Completion of HR SAP Implementation.
• SQL Server 2008 Development

Sr. Migration Analyst

Confidential, Chicago Illinois

Responsibilities:

• Assisted senior leadership teams in making sound, innovated decisions based on data validation rules and business/industry knowledge for Europe Upgrade.
• Daily Transfer of CRM Data Validation Updates to be ran overnight by Japan to update data success rates.
• Analyzed performance benchmarks, summarized key Insights and recommended actions to improve.

Sr. Database Analyst

Confidential, Hampton, Virginia

Responsibilities:

• Analysis/Integration of New Rail Transportation Data with Access/People Soft.
• Developed Complex Rail Data reports for Executive Business Unit to Follow Metrics on new business line.

Sr. Analyst

Confidential, Washington, DC

Responsibilities:

• Identified Legacy programs for Data migration and tracked in Access
• Developed using SharePoint in SQL and Microsoft Access to create dashboard customizations
• Developed Transformation Logic for data Cleansing of Integrated Property Management division
• Managed Business Rules for Migration
• Developed/Conducted Workshops to Senior Managers
• Conducted weekly status meetings with Department Leads throughout Agency

Sr. Migration Analyst

Confidential, Washington, DC

Responsibilities:

• Developed Migration Strategy for 18 Confidential
• Traveled to Plants and delivered Migration Strategy to Plant Management
• Managed Business Rules for Migration
• Creation of Master Migration rules
• ERS extraction of Plant materials
• Conducted user workshops
• Development of Migration Scripts for all SAP modules
• Managed downloads from Plants
• Successfully Merged all plants data for SAP

Sr. Migration Analyst

Confidential, Washington, DC

Responsibilities:

• Lead developer on Financial tool in Access to track employee billing hours for data mart.
• Re-Engineered process to Track Naval Messages for reporting to Admirals.
• Initial ERP assessment for SD Naval Submarine Command.

Sr. ETL Migration Analyst

Confidential, Lynchburg, Virginia

Responsibilities:

• Design and create data migration system (VB/Access/SQL) for the conversion of Customer, Vendor, Material, and FI data; oversee the transfer of legacy data to business integration testing.
• Serve as Business Analyst for the Sales and Distribution module; acquire, test and document Customer Master Rules.
• Lead a "cleansing group" of legacy users to avoid bringing any poor, obsolete, or incomplete data into the new SAP system; structure a system, based on Access, SQL, and Visual basic, to normalize, cleanse, and transform data from the legacy system (JD Edwards) to the target system (SAP).
• Provide data and suggestions for homogenization of multiple SAP systems; build shared access form for the users to enter, alter, and comment on legacy data.
• Spearhead and manage cleansing of legacy data (JDE) and conduct weekly meetings with users to scrub selected data; trained 10+ users. Conduct master data integration workshops with functional consultants.
• Oversee redundant data accuracy, and LSMW table preparation. Coordinated LSMW mapping and execution Manage highly complex conversions and unresolved business rules to create accurate conversion data.
• Development of Cutover Task List, Run LSMW routines as necessary during cutover.
• Convert the data for Materials, Vendors, Purchasing Information Records, Inventory on Hand (all MM module), Customers (SD module), GRIR (FI module), and support 6-8 technical team members.

Sr. Analyst

Confidential, Richmond, Virginia

Responsibilities:

• Assisted IT auditors by researching SQL Server for errors found in patient’s financial history.
• Coding upgrades to check disbursement portion of application.
• Support of existing SQL Server and Stored procedures for General Ledger.
• Development of DTS for replication.
• Access, SQL Server 2005, DTS, Black Baud, Financial Edge, VB.Net.
• Upgrading application code for Oracle Migration

Sr. Analyst

Confidential, Richmond, Virginia

Responsibilities:

• SQL Server 2000 Upgrade to SQL Server 2005and migration of Apps to Office XP.
• Upgrade of code from ADO to .Net
• Creating test environment.
• Updating of Stored Procedures where needed.
• Access XP, SQL Server 2005, VB.Net, DTS