Developer Information Systems

Avraham (Avi) Stein

Database Developer / Reporter

Oak Park, MI 48237-1565

Email: ***************@*****.***

Phone: 313-***-****

SKILLS

oMS SQL – Complex joins, nested “case when” queries, sub queries, stored procedures, date/text manipulation, grouping/aggregate/pivot queries, data imports, looping/branching, triggers, CTE’s, UDF’s

oData reporting (Active Reports, Crystal Reports, SSRS, Access), importing, and data cleansing

oExcel, HTML, ASP

oVisual Basic 6 – ADO, Classes, VBA

oExposure to: VB.NET, BIDS, SSIS, Tableau, ADO.NET, MSSQL versions 10-16

WORK EXPERIENCE / SELECTED ACCOMPLISHMENTS

oLivingston International Inc. - Southfield, MI - April 2017 to July 2017 (contract with Opusing Inc.)

Reporting Analyst

Reduced company’s backlog of import/export metrics reports. Gathered requirements and coded T-SQL (SSRS).

Reviewed team-mates’ T-SQL code, and learned and shared best practices (MSSQL, SSRS).

Figured out Spanish database’s complex legacy reports and re-wrote in efficient code.

oEducators Preferred Corporation - Southfield, MI - October 1998 to June 2016

Senior Database Developer and Reporter (3/2012 - 6/2016)

Stepped in and assumed programming responsibilities when department head left.

Expanded company's client base by researching data from the U.S. Census Bureau and Department of Education to pinpoint feasible prospects.

Maintained online data correction and validation program (ASP).

Created customized reports to banks, universities, and school districts (Excel/Active Reports).

Resolved root-cause issues with Billing Report Generator (Excel/SQL).

Database Developer and Reporter (1/2005 - 2/2012)

Created individualized retirement counseling booklets (using T-SQL, Active Reports, VB6).

Illustrated 30-years of retirement income showing different annuity options, social security income, and tax liabilities for employees considering retirement (produced printed and on-line versions).

Analyzed 11 different state retirement systems, determined if eligible to retire, pension amounts, beneficiary options, and early-reduced benefits (implemented algorithms via Stored Procedures, VB6, Active Reports).

Cleaned and imported all incoming data from hundreds of universities, school districts, and municipalities (Excel and SQL Server).

Responsible for all stored procedures/ad-hoc queries for internal and external users (T-SQL).

Generated Excel Reports to school districts showing breakdown of individualized retirement incentives (SQL, Excel, VB6).

Customized and re-formatted Welcome Letters and Severance Documents (MS Word, VB6, VBA).

Mentored new employees, worked with a team and individually.

Associate Database and Application Developer (10/1998 - 12/2004)

Solved rounding inconsistencies in benefit components which caused discrepancies in Billing Rosters.

Using SQL and Crystal Reports, created individualized versions of legal severance documents, determined retirement eligibility, health-care classifications and costs.

Created efficient, user-friendly counseling appointment scheduler for office and online users (T-SQL, VB6, ASP).

EDUCATION

Computer Information Systems, Michigan Jewish Institute - Farmington Hills, MI

Computer Information Systems, Oakland County Community College - Farmington Hills, MI

Master’s Degree in Rabbinic and Talmudic Studies (Analytics), Beth Midrash Govoha - Lakewood, NJ

Dale Carnegie Graduate

Contact this candidate