cvldevautomation2016

Claude V. Lewis Jr.1809 Whitehead Rd | Richmond, VA 23225 | 804-372-8320 | [email protected]

INFORMATION TECHNOLOGY DEVELOPER AND PROJECT MANAGERHighly productive, versatile and certified developer and project manager with proven expertise in database development and business intelligence. Has successfully applied development concepts for analytics, technical support, and training projects to financial, energy, and government entities. Passionate about providing automated, user friendly access to business data to profoundly impact business decisions.

TECHNOLOGY SNAPSHOTDatabases: SQL Server ,MySQL, Oracle, DB2, MS Access, NOSQL, CassandraLanguages: Visual Basic.NET, VBScript, C#, Java, T-SQL, PL/SQL, XML, ASP (1.1,2.0,3.5), PHPMethodologies/Tools: Agile, Team Foundation Server, Version One, Rally, SharePoint, Lawson, PeopleSoft, Data Warehousing, SSIS, SSRS, SSAS, Crystal Reports, Business Objects, Informatica.

PROFESSIONAL EXPERIENCE

Micron, Business Intelligence Engineer (remote), Richmond, VA, May 2015-presentAccomplishments: Skills, tools used:Successful implementation of several ETL packages and processes in order to convert several product information databases into one Bill of Materials system in Master Data Services. Maintained project sprints and timelines for completion and deployment of packages

SSIS, Master Data Services, Visual Studio, .NET , SharePoint

Data Concepts, Richmond, VA, Federal Reserve Data Warehouse Developer/Scrum Master; November 2014-May 2015Accomplishments: Skills, tools used:Developed automation packages and SQL scripts for Federal Reserve banking applications

Informatica, SSIS, Oracle, SQL Server, Control-M, JavaScript, .NET

Served as Agile Scrum Master Agile, Version One, TFSDeveloped web services and automated test plans for existing Federal Reserve applications.

SQL Server, Java, Oracle, HP Quality Center - ALM

Verisk Health, Richmond, VA, ETL Developer; November 2013-November 2014Accomplishments: Skills, tools used:Automated inbound and outbound processing of health care claims using SSIS and .NET Technologies

SQL Server 2008/2012, SSIS, SSRS, .NET, Java, Scrum Methodology, Rally, TFS

Designed MYSQL (PL/SQL) database for a dashboard application for CMS Metrics

MYSQL, TOAD, PHP

Produced data models, process requirements and documentation SQL 2008, XML,SSRS

SNL Financial, Richmond, VA, Contract-BI Implementation Engineer; February 2013-November 2013Accomplishments: Skills, tools used:Implemented SNL Banker analytical product for banking institutions SQL 2008, 2012, Visual Studio, SSAS,TFSDeveloped SSRS financial reports SQL 2008, XML,SSRSDeveloped SSIS packages for warehouses and SSAS cubes. SSIS, SSAS, .NETBuilt MDX queries to support calculated measures SSAS, MDX


Southeastrans Inc, Atlanta GA, Contract-BI developer; August 2012-January 2013Accomplishments: Skills, tools used:Tuned SSIS packages and queries to support Trip Management System SQL 2008, 2012,.NET, Visual Studio,TFSDeveloped SSRS reports for using trip management and geospatial data SQL 2008, XML,SSRSInitiated Development of Self Service BI using SQL 2012 and some SSAS SQL 2012,SSAS

Developed a processing system for EDI X12 837 Health Claims Xtreme Translator, SSIS

Oldcastle Building Products, Atlanta, GA, Reports Developer; June 2011-August 2012Accomplishments: Skills, tools used:

Established new process to provide Sales data from Lawson to a BPW data warehouse using DB2 queries and SQL Server Analysis. Redefined facts and dimensions within SSAS Sales Cubes. Exported specific data to Biztalk for parallel sales analysis.

Lawson, Java,DB2, SQL Server ,SSIS,SSAS,.NET

Designed and developed several reports and dashboards for managers, developers and users.

Crystal Reports 2008, XML,SSRS

SunTrust Banks, Atlanta, GA, Information Security Analyst; May 2009-April 2011

Accomplishments: Skills, tools used:Developed SSIS processes for user security access data in all SunTrust applications. Provided real time reports to monitor incoming feed files. Utilized Linked Server functions between Oracle and PeopleSoft databases.

SQL Server, XML, Java, PeopleSoft, Oracle,.NET

Implemented the Courion Access Assurance Suite(version 7.70) within project budget and timelines

VB.NET, C#, JavaScript

Designed and developed several reports and dashboards for managers, developers and users to give specific metrics for auto provisioning data to reduce lookup time in support calls. Used SSAS to build cubes for analysis of security access levels.

SharePoint, SSRS 2005/2008, SSAS

Database Developer; Tucker, GA; Apogee Interactive, Inc.; March 2008 - February 2009

Accomplishments: Skills, tools used:Completed the total migration of all objects and accounts from SQL Server 2000 to SQL Server 2005 to which involved all of Apogee’s customized websites, images, and applications

SQL Server 2000/2005, SSIS/DTS, VB.NET

Implemented new website search function to replace the Index Catalogs previously used for all websites

SQL Server 2005, C#, SOAP,

Developed and implemented customized web pages, utility applications, and customized reports for utility customers

C#, VB.NET, CSS. ASP 2.0, 3.5, Java,Dreamweaver, GIMP, SSRS 2005


Database Consultant; Good Cents, Inc. - Loganville, GA; Nov 2007- March 2008Accomplishments: Skills, tools used:

Developed reports and automated application troubleshooting for customer data supporting Good Cents Route match Implementation used to help track customer data and dispatch field installers.

SQL Server 2005, Visual Studio .NET,, Reporting Services (SSRS), ASP 1.1/2.0, Microsoft Office 2007, SharePoint

Implemented a system of automated ETL (Extract, Transfer, and Load) Scripts from SSIS packages to ensure notification and delivery for comma separated (CSV) and Excel data to be processed by external customers.

DTS/SSIS

Technical Support Engineer ;Philips Medical Systems, Atlanta, GA ;Nov 2005 to Nov 2007 Accomplishments: Skills, tools used:

Provided resolution on many issues involving Windows and SQL Server Security to allow clinicians and doctors to review cardiac studies. Led team with call volume in answering and resolving calls over several months. Helped RTAC maintain or exceed service level agreements during my tenure. Provided resolution and issue management on issues including site implementation, performance enhancement, disaster recovery, and archive/retrieval functions. Provided import and export support using SSIS scripts in SQL 2005.

SQL Server 2000/2005 (TSQL, Stored Procedures, Security), Windows 2003 Active Directory, SSIS/DTS, DVD Jukebox (Plasmon, Pioneer), SAN (EMC), DICOM, HL7, Clarify, Lotus Notes

Database and CRM Independent Consultant; Claucworc Inc, Atlanta, GA/Washington DC; Oct. 1998 to Nov. 2005Accomplishments: Skills, tools used:

Implementation and troubleshooting of Great Plains 8.0 with the Sales, Financial, Service Order, Inventory, and FRx modules, responsibility for all SQL Server applications and nightly backups, disaster recovery and implementation plans, and upgrades to existing servers and applications.

SQL Server Reporting Services, Oracle, Great Plains, Business Objects, and Crystal Reports

Successfully integrated membership and customer databases while maintaining the profit/non-profit business/security rules. Developed Mailing List application using SQL Server and Visual Studio. Developed reporting capabilities for Crystal Reports and Excel for management. Responsible for SQL Server 2000 development to several agency application development projects utilizing T-SQL scripts, stored procedures, and data transformation services (DTS). Helped develop reports and forms for Great Plains Finance and CRM modules using TSQL skills

Great Plains, Visual Studio, SQL Server 2000, Crystal Reports , IMIS, Active Directory

EDUCATION/CERTIFCATIONHoward University B.S. - Systems and Computer Science Engineering, Washington, DC Microsoft Certified Systems Engineer – August 1999Microsoft Certified Technology Specialist – SQL Server 2005- May 2008Certified Scrum Master, November 2013

cvldevautomation2016

Documents