Reginald Dean Email & Phone Number

Chicago, Il, Us

Chicago

• Work as Microsoft Azure Administrator (data factory, data bricks, established self-hosted runtime)• Programmed Ring Down Console ASP.NET Core (MVC) web application for airport towers• Collaborated on Security Division's Vetting ASP.NET MVC web application• Created Vetting instructions manual while troubleshooting/test website• Development of Power BI applications including flight information (SQL Server), Airport Parking, Passengers (Oracle), Tweets and Tweet History, and In-house tickets dashboards and datasets for reporting• Initiate/issue/write SQL commands/queries and DAX language for use in Power BI, access and SQL Server• Ensure appropriate upgrade and establishment of Power BI Gateway server• Install, configure, and customize department’s open-source asset management system• Establish SAP BusinessObjects Web Intelligence 4.0 financial reports• Collaborate with Unisys team to setup virtual/software test, development, and production environments• Analyze FMPS system script/programming code for tracking accounts, tickets, budgets, contracts, and grants• Tested CATA timekeeping system for department• Attend and participate eBullder Software Development Life Cycle (SDLC)/technical meetings• Serve on CDA RFP for Information Technology Committee

Chicago, Illinois 60622

• Serve on the Data Unit, where various reports are generated for the Commissioner, internal and external staff and clients• Attend and provide input at technical/data requirements gathering meetings and committees in absence of Data Manager• Member of Data Allocations Committee. Working on initiative to enhance/improve the functionality and reporting capabilities of the department’s Head Start/Early Head Start/Child Care web application• Provide technical specifications to website vendor on various data elements needed for reporting to federal and state departments• Create statistical reports and dataset models, especially in accordance with Commissioner’s Strategic Framework initiative• Develop technological/innovative/creative ways to ensure data accuracy and consistency while reporting information to federal, state and city stake holders

Chicago, Illinois 60622

• Nominated for Kathy Osterman Award and years of Superior (Exceeded Expectations) Employee Evaluations• Extensive use of ASP.NET, C#, Visual Studio and SQL Server. Reporting tools consist of MS Access, ITextSharp, use of Gridviews for exporting data to Excel and Crystal Reports. Append GIS data• Established various daily “real time” reports for all DFSS divisions (Children, Domestic Violence, Homeless, Human Services Delivery, Senior, Workforce and Youth Services, which consists of over 500 staff members)• Supported Executive Approval (EA) system, which included ASP.MVC & SQL Server database application support• Facilitated and participate in user requirements gathering meetings• Utilized and imported datasets into on-premises database systems• Developed delegate agency and contracts/funding systems and reporting component. Contracts system has served over 500 staff and maintained records on over $250 million dollars of contracts each fiscal year• Designed registration and informational web pages and applications for Information Technology team (HTML, JavaScript, VBA)• Created ASP.NET Webforms Homeless Programmatic Tracking System (HPTS) for Homeless Division. System allows homeless staff to track delegate agency contacts, program models/names, site locations, site bed counts, budget amount and real-time reporting• Programmed Delegate High Risk Tracking System (DHIRTS) for Finance Unit. System tracks delegates considered high risk• Gathered requirements and established Requests for Proposals (RFP) system. Data transferred from RFP system to City of Chicago’s CDGA system• Setup and configured hardware, software, peripheral devices, and developed/designed the registration website for each year’s Annual Childcare and Youth Fiscal Conference• Graphics/banners created for documents and COPA website using Photoshop• Taught childcare agencies how to effectively utilize Child Care Management Information billing system• SharePoint training and modification

Schaumburg, Illinois

• Earned Direct Marketing Certification while employing ISO 9000 concepts.• Meet deadlines for over fifteen (15) accounts including Costco, Sara Lee, Sears, etc. (approximately two (2) million records per account).• Issue basic proprietary SQL-like queries and commands against a DB2 database.• Collaborate with Client Services Representative to meet client technical needs.• Design, create, test, and maintain code modules using Experian’s proprietary language for DB2 databases.• Create modules to query and overlay customer data for client use.• Interpret client specifications and translate them into object oriented/proprietary code modules. • Design system flowcharts and data flow diagrams using Visio software.• Execute and analyze statistics on customer data and submit results to Client Services Representative for Experian client’s review.

Lincolnshire, Illinois

• Utilized Capability Maturity Model methodology to ensure that clients receive quality products and services.• Received highest number of customer satisfaction calls.• Provided customer support to 900,000 Verizon employees. (largest client team at Hewitt)• Enrolled employees in health and welfare benefits.• Answered and resolved customer health and welfare/benefits related issues.• Interpreted and explained general benefit options.• Developed retiree income verification documentation.• Created and utilized Microsoft Excel spreadsheets for customer statistical data.

Northbrook, Illinois And Chicago, Illinois (Downtown)

• Interacted with Project Manager to gather and interpret user requirements and specifications.• Analyzed, developed, designed and implemented front-end web (HTML, ASP, ADO, VBScript, JavaScript) and Lotus Notes applications. (LotusScript, Lotus Formulas, Java)• Created database applications using Access 97/2000 and SQL Server 2000, including table normalization.• Executed SQL queries via SQL 2000 database and ensured that data posted to database formatted appropriately.• Served as Lotus Notes developer, tester, troubleshooter, and peer reviewer of the Accenture’s global (70,000 employees) Lotus Notes and web application.• Provided general technical support for Lotus Notes and web application.• Developed LotusScript and Lotus Formula agents, views, questionnaires, and forms.• Established test plans and detailed technical specifications for various Accenture applications.• Prepared utilities that resulted in the detection, evaluation and eventual repair of application bugs.• Supplied global technical support to users in the Americas, Asia, and European regions.

Chicago, Illinois

• Created web applications using HTML, ASP, ADO, VBScript, and JavaScript.• Re-engineered the TransUnion.com web security application.• Developed, designed, tested, debugged, and documented web applications and ensured that web application available on different system platforms.• Collaborated with business analysts to prepare program specification documentation. • Conducted data migration procedures. Migrated data from DB2 to LDAP directory and SQL Server database. • Installed software for new clients and members of the programming team.• Performed successful Y2K testing and development.• Designed a detailed test plan, including test conditions/scripts for Quality Assurance project.

Master’S Degree, Masters In Information Technology And Management And Certificate In Web Design And App Development

Special interests: Web Development, Web Design, Open Source Technologies, Oracle, JavaScript, Mobile Application Development, Content.

Depaul University Modern .Net Web Development Program, A

DePaul University's Modern .NET Web Development Program is designed to provide programmers with an intensive and comprehensive.

Certificate Of Complet, A

DePaul University's Modern .NET Web Development Program is designed to provide programmers with an intensive and comprehensive.

Bachelor Of Science, Information Systems

Degree: Earned Bachelor of Science, Information Systems Special interests: Completed three Masters Degree in E-Commerce courses (Internet.