| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Street Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLESummary: IT experience 10 + Years specializing in Database Support / Design / Development of MS SQL Server. Knowledge / Experience of Logical and Physical Data Models Front End Development (9 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 / Python DBA Experience 2 years): Backups / Restores / Replication / Log Shipping
Database Development: Design, create, modify, database objects (tables, views, stored procedures, referential integrity (PK, FK), constraints, and indexes) using T-SQL. Also usedPerformance Tuning of Databases, and all objects of SQL Server(5 Years) SSIS Package Development Experience (5.0 Years)
SSRS Report Development Experience (Table / Matrix Reports - Native Report Server - 2.0 Years, (Bids And SSDT).
SSAS Cube Development Experience (1 Year)
Blocking, Deadlocking, Execution Plans, DMVs, DMFs, Dynamic SQL, Table Normalization Database Architecture Data Warehouse Design / Development (Star / Snowflake Schema) Query Performance Experience with data modelling (ErWin) Also used SQL Profiler, DTA (Index Tuning) MCSA Certificate Dec 2024 Recent Experience with SQL Server 2008, 2008R2, 2012, 2014, 2016 and 2017EDUCATION:DePaul University, Chicago, IL Bachelor of Science, Computer Information Systems
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, Git, And TFS Reporting SQL Server Reporting Service (SSRS)
Data Import /Export SQL Server Integration Service (SSIS) Front End GUI: Visual Studio (2005, 2010)
SSIS, SSRS SSAS Visual Studio Shell (2008,2010,2017)Work Experience:
Alpha Money Guy LLC., Chicago, IL Sep 2019 Present
SQL Server Developer / Consultant Created / Modified Various Database Objects like Tables, Triggers,
Stored Procedures, UDF Functions, Complex Queries, Created / Modified Various SSIS Packages Created / Modified Various SSRS Reports Database Modeling (Logical and Physical) Erwin. Also used SQL Profiler, DTA Worked with Large Data Sets
Worked with Multi Tenant Databases Backups, Restores, Maintenance Plans. Data Warehouse Design and Development (Star Schema) Data Migration / Conversion to Microsoft SQL Server Used SQL Server 2014 and SQL Server 2016 2017
Baxter Healthcare, Round Lake, IL Jan 2018 Dec 2018
SQL Server Developer / SSIS Developer Created / Modified Ad Hoc Queries and created custom SQL Queries. Created / Modified various Stored Procedures, Triggers, Views, Functions, Database Tables
SSIS Package development and modifications. Worked with numerous Data Sources (Flat 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) Helped in Converting Code / SSIS packages from SQL Server 2005 to SQL Server 2014 Used SQL Server 2005, 2012 and 2014Lake Forest College, Lake Forest, IL Jan 2017 Dec 2017
SQL Server Developer / Access Developer: 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 MS Access to help automate data entry and reporting
(Jan 2015 Jun 2016)
Took time off (Family Medical Reasons)
DMD Connects Rosemont, IL May 2013 Sep 2014
Solutions Developer 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 Converted various SSRS Reports (Table & Matrix) from VB .NET Worked as a Junior DBA (Backup s, Restores, Maintenance Pans ETC)G Treasury Lake Zurich, IL Jan 2013 Mar 2013
SQL Server Developer / Report Writer
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 Objectsand documenting the reports Used SQL Server 2008 R2Heitman, Chicago, IL Jun 2012 Dec 2012
SQL Server Developer / SSIS 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 R2Sunrise Bidders, Itasca IL Sept 2011 -- Mar 2012
SQL Server Developer / SSRS Report Writer
Created / Modified SSRS Reports (Table / Matrix Reports) Created / Modified various Database Objects to enhance their existing Web Application Created SQL Server Agent jobs. Tuned various Database Objects for Performance
Used SQL Server 2008 R2Department of Natural Resources Springfield, IL Jan 2011 Jun 2011
Database Programmer / SSIS Developer The project was all new development. (Wildlife 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 R2Independent Consultant (SQL Server / BI Developer) Jan 2004 Dec 2010
A) JPMorgan Chase IL
B) Stericycle Corporation IL
C) Allstate Insurance IL
D) Bacons IL
Created / Modified various Queries / Database Objects / SSIS Packages / SSRS Reports Experience in converting from SQL Server 2000 to SQL Server 2005 Created / Supported Data Warehouse Structures (OLAP)
Tuned various Database Objects for Performance Wrote various Web Pages (Asp.Net / C#) Lead a team of 5 Offshore Developers Worked with Various Microsoft Tools and Languages Conversion from Microsoft Access to Microsoft SQL Server Used SQL Server 2005, SQL Server 2008Cardinal Health, Allegiance, Baxter Waukegan, IL Jan 1993 Jun 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 |
