Database developer

Aleksandr Babichev

**** **** ****** **., ******, TX, 78749

Phone : 404-***-**** e-mail: ************@*******.***

OBJECTIVE: Seeking a database developer position utilizing strong designing and programming skills with a company that values creative and highly motivated professionals.

SUMMARY: Over 20 years of software design, development, maintenance, implementation, and end-user support experience.

SKILLS:

Operating Systems: Windows NT, Windows 2000, 2003, 2008, XP, Windows 7, Windows 10, Linux

Languages: C#, VB.NET, SQL, PL-SQL, Teradata SQL, Visual Basic 5.0, 6.0, ASP.NET, ASP, HTML, XHTML, XML, KornShell

Databases: Teradata, SQL Server, Oracle, Microsoft Access

Tools: .NET 4.5 and earlier, ADO.NET, Microsoft Visual Studio, MS Office, ADO, ActiveX, Commerce Server 2000, Embarcadero ETL,SSIS,SSRS, Kronos tools.

EXPERIENCE:

September 2021– Current CVS Pharmacy remote Senior Teradata Engineer

Took an important part in migration AETNA insurance data into Teradata,

analyzing, creating and testing table driven exports with migrated insurance data for the clients. Development was done in cooperation with offshore team located in India [Teradata, Teradata tools (BTQ, TPT), KornShell]

May 2018 – September 2021 Whole Foods Market Austin, TX Senior Software Engineer/SQL server developer

Was integral part of the project that allowed automated scheduling for bakery and prepared food teams. [Teradata, Teradata tools (TPT), SQL Server 2016, Kronos proprietary tools (WIM)]

Developed system that allowed to maintain list of active registers in the stores. [Teradata, SQL Server 2016, Kronos proprietary tools (WIM)]

Created and fixed several SSRS reports and loaded data using SSIS. [SQL Server 2016, SSRS, SSIS]

Created few small utilities, text formatting jobs using Python [Python].

2014 – May 2018 Whole Foods Market Austin, TX Teradata Data warehouse developer

Took an important part in 2 Teradata migrations, from on premises system to Teradata Cloud and then to AWS.

Participated in several business-critical projects, for example:

Creating new retail region for smaller three six five stores and later converting them to regular store hierarchy. [Teradata, Teradata tools (BTQ), KornShell]

Designed and developed table-driven exports for Kronos to allow automated labor scheduling. [Teradata, Teradata tools (BTQ, TPT), KornShell]

Created complicated aggregations that allowed to create Tableau data sources for new company wide reporting system. [Teradata, Teradata tools (BTQ, TPT), KornShell]

Developed numerous ETL processes to move data from different data sources into Teradata data warehouse SCD1 and SCD2 tables. Data was coming from SQL server and Oracle databases or was delivered as text files through SFTP or S3 bucket. [Teradata, Teradata tools (BTQ, TPT), KornShell]

Built dozens of data exports from Teradata data warehouse to internal and external clients using Fast export and TPT technologies. Exports were created as delimited files and delivered to SFTP or S3 bucket. [Teradata, Teradata tools (BTQ, TPT), KornShell]

Built many complicated aggregation jobs to support business analytics request in various areas. [Teradata, Teradata tools (BTQ, TPT), KornShell]

2012 – 2014 Whole Foods Market Roswell, GA .Net Developer

Participated in back-end IRMA (Inventory system) enhancements including but not limited to designing a way to avoid system lock during daily sales load. [VB.NET, SQL Server 2008]

Led the development of Global Distribution Audit Team (GDAT) reporting tool that allows users to perform a variety of audits to ensure UNFI is in compliance with the current cost agreement. [C#, SSRS, SSIS, SQL Server 2012]

2007 –2012 GA Department of Revenue Atlanta, GA .Net Developer/SQL server developer

Developed a service that checks different data sources to ensure that documents are successfully processed. Service sends report to users with a list of documents to guarantee end-users that documents are ready to be destroyed. [C#, Oracle PL-SQL]

Developed dynamic, table driven interface that allows sending individual tax form data to audit systems. Data is used for data warehouse audit campaigns. [C#, Oracle]

Involved in the development of a business occupational tax submittal system that allows counties and cities of the state of Georgia to provide business license information to the Georgia DOR to compare and determine if the business in question is paying proper taxes. This system consists of two parts: Secure FTP, which allows users to upload flat files of a predetermined format; and a website, that allows users to enter data manually. [ASP.NET, C#, Oracle access manager, Oracle, and Connect Direct]

Developed an application that allowed Levy Compliance Agents to create individual taxpayer letter packages for county court systems to garnish a taxpayer’s wage based on IRS provided data. [ASP.NET, C#, Oracle]

Participated in the development process with software vendor to load data into a data warehouse environment. [Embarcadero ETL tool and PL-SQL stored procedures]

Developed an approval system that allowed Compliance Managers to authorize penalty and collection waivers submitted by field agents. [C#, AJAX, ASP.NET, SQL Server 2005, and SQL reporting services]

As a member of a development team, created a web application that manages audits against partnerships and corporations, including audit creation, assignment, assessments, and various required documents. [C#, AJAX, SQL Server 2005, Oracle 10, and Telerik controls]

Developed a system that enabled Revenue Agents to construct documents in PDF format based on audit data provided by the IRS. [C#, SQL Server 2005, and SQL reporting services]

Developed a library, as a part of a vendor product that was used by a tablet computer application for calculations of sales and withholding assessments. [C# and VB.NET]

1999 –2007 Web Oracle Dunwoody, GA Application Developer//SQL server developer

2003 – 2007 Created a package of over 30 reports for a die manufacturing company. The reporting solution used the main calculation logic and formulas of a custom developed .DLL Libraries. [C#, SQL reporting services for SQL Server2000]

Participated in the development of an E-commerce site (internet store) for Aloette Cosmetics implementing custom caching and significantly improving performance of the site.[C#, SQL Server 2005, ASP.NET]

Integrated an MAS90 database with a custom payment gateway, which linked the utility billing provider with a number of clients.[C#]

Converted a custom progress billing package from Microsoft Access to a web based .NET application. [C#, SQL reporting services for SQL Server2000, ASP.NET]

2001 – 2003 As a member of a small development team, participated in the implementation of an Internet store for Mori Luggage and Gifts based on Microsoft Commerce Server 2000. Integrated an E-commerce gateway (YourPay) with MoriLuggage.com. [ASP, ADO with SQL Server]

Designed a proprietary Content Management System (CMS) that allowed users to take advantage of the CMS substitution-based template to edit HTML blocks and upload images. New at the time, CMS gave the users the ability to create personalized websites. [XML, ASP, with SQL Server 2000]

1999 – 2000 As a member of a large team, participated in the development of Auctionworks.com.

Auctionworks.com consolidates auctions from several major auctioneers (Yahoo, EBay, etc.) [ASP, ADO with SQL Server]

Developed a shopping component for qtytakeoff.com. The code handles a full shopping cycle and catalog maintenance including product variations, discounts, and featured products. [ASP, ADO with SQL Server]

EDUCATION: Shipbuilding University. St-Petersburg, Russia.

Computer Science

INTERESTS: Chess

1996 and 1997: Georgia State Chess Champion in Blitz

Contact this candidate