Marazban Ogra

* ********* **** ****** ***** IL **061

847-***-****

ac86q9@r.postjobfree.com

Summary:

IT experience specializing in Database Support / Design / Development of MS SQL Server

Knowledge creating Logical and Physical Data Models

Upcoming MCSA Certification Dec’2019

Front End Development (8 years Ago) In WEB and CLIENT / SERVER apps on a 2 tier and 3 tier architecture platform using HTML / ASP.Net / C# / VB .Net / Java

DBA Experience 2 years): Backups / Restores / Maintenance Plans and other miscellaneous DBA tasks (Security – LogIns, Users, Roles; Server Objects – Linked Servers, Triggers)

Database Development: Design, create, modify, database objects (tables, views, stored procedures, referential integrity (PK, FK), constraints, and indexes).

SSIS Package Development Experience (Between 2.5 And 3.0 Years) : BIDS (Package deployments) and SSDT (project deployments)

SSRS Report Development Experience (Table / Matrix Reports - Native Report Server - 2.0 Years, (Bids And SSDT)

SSAS Cube Development Experience (6 Months) Exposure to Power BI

Recent Experience with SQL Server 2008, 2008R2, 2012, 2014 And 2016

EDUCATION:

DePaul University, Chicago, IL

Bachelor of Science, Computer Information Systems 1986

CERTIFICATION:

Institute of Professional Development (DePaul University, Chicago, IL)

11 Weeks DBA Certificate Program (Winter 2010)

10 Weeks .Net Certificate Program (Spring 2010)

4 Weeks Advanced SQL Certificate Program (Spring 2010)

SKILLS:

Operating Systems: Windows 10.0 / 7.0 / NT / 2000 / XP / Vista

Languages: C#, VB .NET, Transact SQL, SQL, Office 2010 / 2007 / 2003

Web Applications: HTML, ASP, ASP.NET, ADO.NET, ODBC, OLEDB and Web Services

Databases: Microsoft SQL Server (Versions 2000 – 2016)

Source Control: Microsoft Visual Source Safe And TFS

Reporting SQL Server Reporting Service (SSRS)

Data Import /Export SQL Server Integration Service (SSIS)

Front End GUI: Visual Studio (2005, 2010)

Work Experience:

New.IO, Vernon Hills, IL Oct 2018 – Present

Free Lance SQL Server Consultant

Created / Modified Various Database Objects

Created / Modified Various SSIS Packages

Created / Modified Various SSRS Reports

Used SQL Server 2014 and SQL Server 2016

United Airlines, Chicago, IL Jan 2018 – Jun 2018

SQL Server Developer / BI Consultant

Created / Modified Ad Hoc Queries and created custom SQL queries

Created / Modified various Stored Procedures, Triggers, Views, Functions, Database Tables for Revenue Management System ETC

SSIS Package development and modifications. Worked with numerous Data Sources (Flat Files, XML Files, Oracle Databases, CSV Files, OLE DB Sources) to extract, transform and load data into Microsoft SQL Server Databases using various Control Flow Task (Data Flow, Execute SQL, File System, and Script Task, Containers (For/For Each/Sequence). Transformations included (Derived Columns, Data Conversion, Conditional Split, LookUp, Sort, Script Components)

Created / modified several SSRS Reports. (Table and Matrix Reports) ranging from simple tabular reports having 10 – 15 Columns to complex Matrix reports summarizing revenue per order ETC

Used SQL Server 2014

Lake Forest College, Lake Forest, IL Aug 2017 – Oct 2017

SQL Developer / SQL Consultant:

Knowledge transfer from resource who was leaving the company after 12 years.

Development work involved projects interacting with Web and Client/server Interface.

Back-end database development (SQL Server 2008R2, SQL Server 2012, SQL Server 2014).

Additional project work involved development entirely in Microsoft Access where each department utilized their own Access database repository

Created Forms and Reports in Access to help automate data entry and reporting

New.IO, Vernon Hills, IL Mar 2016 – Jun 2017

Free Lance SQL Server Consultant

Created / Modified Various Database Objects

Created / Modified Various SSIS Packages

Created / Modified Various SSRS Reports

Used SQL Server 2008 R2, SQL Server 2012 And SQL Server 2014

(Jan 2015 – Dec 2015)

Took time off (Family Medical Reasons)

DMD Connects Rosemont, IL May 2013 – Sep 2014

SQL Server Developer / BI Developer / SQL Server Consultant

Created / Modified various Queries and Database Objects using SQL Server 2008 R2, 2012

Created numerous Ad-Hoc Queries and stored procedures for Reporting

Created / Modified SSIS packages for ETL, scheduled SSIS Packages (Agent Jobs) to populate data from various data sources

Worked as a Junior DBA

Created a Cube in MS SQL Server 2008 R2 (SSAS) using the wizard

Created new SSRS Reports migrating VB.Net Reports using Visual Studio/Report Builder

G Treasury Lake Zurich, IL Jan 2013 – Apr 2013

SQL Server Developer / Report Writer / SQL Server Consultant:

Consultant-based project (placed by Robert Half Technologies)

Created / Modified Table, Matrix reports in Visual Studio/Report Builder

Process involved creating various Queries / Ad-Hoc Reporting Queries / Database Objects

and documenting the reports

Used SQL Server 2008 R2

Heitman, Chicago, IL Jun 2012 – Dec 2012

SQL Server Developer / BI Developer

Documented existing SSIS Packages created in MS. SQL Server 2008

Worked to consolidate 15 SSIS Packages into one master SSIS Package

Evaluated various 3rd.Party Data Flow Tasks

Used SQL Server 2008 R2

Sunrise Bidders, Itasca IL Sept 2011 -- Dec 2011

SQL Server Developer / Reports Writer / SQL Server Consultant:

Created / Modified SSRS Reports (Table / Matrix Reports)

Created / Modified various Database Objects to enhance their existing Web Application

Created SQL Server Agent jobs for Alerts

Tuned various Database Objects for Performance

Used SQL Server 2008 R2

Department Of Natural Resources Springfield, IL Jan 2011 – Jun 2011

Database Programmer / SQL Server Consultant:

The project was all new development. (Wild Life Habitat Planning)

Created various SQL Server Queries and Database Objects

Created various Tables and their respective relationships for this project

Inserted test data in all tables using SSIS Packages for this project

Used SQL Server 2008

Independent Consultant (SQL Server / BI Developer) Jan 2004 – Dec 2010

A)JPMorgan Chase IL 2004 -- 2005

B)Stericycle Corporation IL 2006 -- 2007

C)Allstate Insurance IL 2008 -- 2009

D)Bacons IL 2010 – 2010

Created / Modified various Queries / Database Objects / SSIS Packages / SSRS Reports

Supported Data Warehouse Structures (OLAP)

Tuned various Database Objects for Performance

Wrote various Web Pages (Asp.Net / C#)

Lead a team of 5 Off Shore Developers

Worked with Various Microsoft Tools and Languages

Used SQL Server 2005, SQL Server 2008

Cardinal Health, Allegiance, Baxter Waukegan, IL Jan 1989 –Jan 2003

Technical Specialist I / Technical Specialist II / Senior Developer / Developer / Associate Developer

Served as the only Developer. Was assigned a rebate team member for coordinating and approving all analysis, design and implementation activities. Developed two prototypes before full rebate system Implementation

Served as developer on seven-member outsourced team for an international order processing and inventory control system. Completed system testing of order processing and inventory components

Led four Senior Consultants in design, development and implementation of Broad Vision.

Directed three-member team of consultants in development and implementation of enhanced order assembly and catalog management system. Oversaw e-commerce reengineering systems initiative encompassing enhanced catalog management functionality and 3-tier architecture deployment on Windows NT platform. Maintained accountability for all integration, unit and system testing

Worked on various projects that included process integration, just-In-time order processing and inventory control

Worked with Various Microsoft Tools and Languages

Contact this candidate