Marcus A. Babin

Kingwood, TX ***** Telephone: 281-***-**** Email: acvuln@r.postjobfree.com

PROFILE

Mr. Babin has 27 years of experience in application development, database analysis and design. He is experienced in all areas of automating business systems. These include client interaction involving analyzing user requirements and developing a productive system design, structured programming, implementation, end user training and support, enhancements, maintenance and documentation. He is experienced in developing a wide variety of databases and applications and participated in many team projects from the design level through development and support. He has a strong background in analyzing system specifications, troubleshooting, implementation, and development of complex systems. He is a Microsoft certified professional in MS Access.

TECHNICAL SUMMARY

Languages SQL, T-SQL, PL/SQL, VBA, VB

Views, Stored Procedures, Functions, Triggers

Databases/Tools SQL Server, Oracle, MS Access, Rbase, Dbase

Enterprise Manager, DTS, ODBC, Import/Export, Crystal Reports

Management Studio, SSIS, SSRS, ETL, SQL Server Agent, Linked Servers

Software/Systems MS Office, EDI, FTP, CITRIX, Terminal Server, Windows 8, 7, Vista, XP

Other Skills SQL Server DBA Skills – proficient, Business and Data Analyst, working

knowledge of Business Intelligence, MS Visual Studio, VB.Net, ADO.Net, ASP.Net, HTML, XML

WORK EXPERIENCE

June 2013 to Current Technical Lead, SQL Developer

Birlasoft Corporation Xerox Corporation – Houston, TX

Responsible for maintenance, enhancements and support of all Billing, Reporting and Electronic Data Invoice applications. Lead/SME for a team of developers in India doing development and production support for Asset Management, Billing and Reporting applications. Assisted and supported the team of programmers on troubleshooting, analysis and quick solutions to time critical business problems to keep pace with Customer Billing requirements.

Created/modified (Tables, Views, Stored Procedures, Functions) in SQL Server 2008 & 2012 to support billing requirements for new and existing Contracts

Created/modified Forms, Queries, Reports and developed VBA code using MS Access 2010 & 2013 to support the billing, reporting and electronic data invoicing requirements for multiple frontend applications

Met with Account Transition Managers and Business Partners to discuss new Billing requirements for complex billing needs for new accounts.

Resolved and assisted the development team with solutions to escalated production support time critical ticket requests

Performed Importing/Exporting of Excel spreadsheets to upload data, analyze data, troubleshoot issue, perform complex calculations for billing purposes

November 1999 to June 2013 Senior Programmer/Analyst, SQL Developer

Modis/Idea/Ajilon Xerox Corporation – Houston, TX

Responsible for maintenance, enhancements and support of all Billing, Reporting and Electronic Data Invoice applications. Assisted and supported the team of programmers on troubleshooting, analysis and quick solutions to time critical business problems to keep pace with Customer Billing requirements.

Completed the development of a Reporting Frontend application in MS Access to generate all standard and customized invoicing, billing detail and summary management reports, charts and graphs, Excel outputs for internal and external customers

Developed a new Billing System (AmPro) in MS Access and SQL Server to support business expansion to handling new billing requirements for new/existing customers for the Fleet Contracts of the North America region.

Completed the development of major enhancements to the Electronic Data Invoicing application in MS Access and SQL Server to generate text and Excel files of Invoicing data for internal/external customers and transmitted files via FTP

General support on in-house Asset Management Systems, Ad Hoc Queries,

Special Reporting and Billing requests

Performed maintenance and production support and development of the billing system Ampro from developing Stored Procedure and Views to create new Pricing Plans to bill new/existing Contracts and creating (table, queries, forms, reports and writing VBA code) to keep pace with Billing needs

Created Queries and Reports in MS Access for Invoicing (Summaries and Billing Details) and Volume Usage reports

Created Queries, Forms, Reports and developed VBA code to setup new Electronic Data Invoicing for internal/external customers and transmitted files via FTP.

Created DTS/SSIS packages to pulling data from other SQL and Oracle Servers

Created Jobs using the SQL Server Agent to schedule daily and nightly jobs to pull data needed in order to generate additional Billing for Accounts

March to November 2008 Developer

Popeye’s Chicken & Biscuits Cardinal SW, Houston TX

Developed a Reporting application to generate Sales reports for Stores, Menu Items sold, (Dine In, Drive Thru, Pick Up) by Daily, Weekly, Monthly, Quarterly, Yearly and Year to Date. Imported data from about nine MS Access databases used by the Point of Sale system into the Reporting Tool database in order to generate reports.

Developed a Fried Turkey Orders application to tracking fried Turkey Orders, Sales, and Pickup Data for Scheduling by Store locations during the month of November for Thanksgiving.

August 2008 Developer

Blue Bell Creameries, Brenham, TX

Worked on a small project to develop customized reports for a Time Tracking system using MS Management Studio 2005 & Visual Studio – Reporting Services. Worked on setting up the links and connections to the SQL Server and development of the report layouts and developed Stored procedures to generate and pull the data from the SQL Server Database for a Kronos Workforce Timekeeper web application.

February 2006 Developer

Blue Bell Creameries, Brenham, TX

Designed and developed an Employee Class Training application that tracked subjects, subjects required by job types, employees required to attend classes, class schedules, posting classes with students and test scores using Access 2003, SQL Server 2000.

April 2005 Developer

Blue Bell Creameries, Brenham, TX

Developed a Unit Movement Reporting Tool in Access 2003, SQL Server 2000 with Stored Procedures to replace an old application with an Oracle backend. The new Application provided speedy output from a Detail History Table with over a million records of summary and detail data and generated reporting by Account types, Daily Price/Discount, and Date ranges, multi-selection of Items, Branches and Stores.

Jan 2003 to July 2004 Developer

Sara Lee Coffee & Tea, Harahan, LA

Designed and developed a Coffee Scheduling System to track the manufacturing of Specialty Coffee Products from Importing and Replenishment Orders, Scheduling, Processing, Grinding, Roasting, Flavoring, Packaging, Material Inventory, Production and Shipping of Orders for the coffee division using Access 2000 & 2003.

April 1998 to October 1999 Programmer/Analyst

Integration Services, Inc. Dynegy – Houston, TX

Designed and developed a Software Tracking database to track software programs, versions, licenses and owners using Access 97. Responsible for production support of databases tracking Power, Coal, and Emissions Transactions, Prices, P&L and Volume Position reports for traders in various regions using Access 97. The Power database inserted, updated and deleted prices, counterparty, and P&L data from SQL Server 6.5 database tables.

July 1992 to March 1998 Programmer/Analyst

Application Systems, Inc. Application developer of Windows and DOS based projects. Responsible for detailed design, implementation and development of projects to completion. Developed a wide variety of systems for clients such as Blue Bell Creameries, Halliburton/Dresser, Texas/Sabine Pipeline Company, Mitsubishi Corporation, City of Houston Water Division, Coca Cola Foods/Minute Maid

EDUCATION

January 2005 to May 2005 Houston Community College, .Net Development certificates in VB.Net, ADO.Net, ASP.Net, and Ecommerce

December 1988 Associates of Occupational Studies in Microcomputer Software Technology, Microcomputer Technology Institute

Contact this candidate