Developer Sql Server
Resume:
Marazban Ogra
* ********* **** ****** ***** IL **061
************@*****.***
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