TECHNICAL SKILLS

Database: MS SQL Server, MySQL, Oracle

DB Types: OLTP, OLAP and Hybrid

Languages: SQL, T - SQL, MDX, PL/SQL, SQL*PLUS, VB.NET,C#, VB Script, ASP.NET, XML, UML, C/C++, HTML, JavaScript, Jason2

Tools: and Technology: SQL stack 7/2000/2005/2008/2012/2014/ Azure, SSMS, SSIS, SSAS, SSRS, TOAD, Rational Rose, Report Builder, Crystal Reports, Embarcadero ER/Studio, Red Gate SQL Bundle, Visual Studio.NET, MS Visual Studio, SQL Sentry Monitor, Idera SQL Diagnostic Manager, MS Visio, Visual Source Safe, Ervin Data Modeling, SQL Sentry, Visual Sourcesafe, Team Foundation Services

Operating Systems: Windows Servers, Windows, Linux

Certifications: MCITP in SQL Server (SQL Server DBA)

PROFESSIONAL EXPERIENCE

Confidential, Lincolnshire, IL

SQL Server Consultant

Responsibilities:

• Identification of Business requirements for Data Migration project
• Design and implement change for Logical/Physical models for SQL database structure
• Migrate database and data from MySQL to SQL Server 2014
• Create SSIS packages
• Create st.procs, tables, views, functions for Variable Data Print processing
• Create SSRS Reports

Confidential, Woodridge, IL

Consultant DBA/Data Warehouse Architect

Responsibilities:

• Determining Business requirements
• Working close with Operations, Accounting, Sales departments and gather requirements for data warehouse.
• Design and developed of Logical/Physical models for EDW and other applications
• Create and SQL standard and best practices
• Establish and maintain engagements with the business partners regarding on-boarding of the data ensuring the integrity of the data.
• Develop Data Management Strategy and roadmap in alignment with the corporate goals.
• Worked with the Subject Matter Experts (SMEs) to obtain buy-in on the common definitions
• Database design, implement and document details for architecture, functionality.
• Ensures integrity and quality of data
• Identification and creating processes of Historical data changes for dimensions in EDW
• Migration of SQL Server from v2008 to v2012
• Create database related procedures, such as SQL coding and database dev. standards.
• Design and create tables, indexes, views, complex stored procedures and functions
• Create/Modify/Support MySQL databases and ETL process for it
• Code reviews and staging/production releases.
• Creation SQL Server AlwaysOn high-availability solutions that has multiple datacenters
• Create, modify and support for production OLAP cubes
• Redesigned and Developed solutions for optimization and improving performance of SQL Instances, databases and T-SQL code
• Helped developers with DB tasks

Confidential, Chicago, IL

Data Architect/Manager

Responsibilities:

• Create and enforce a standard format for the delivery of the data to EDW.
• Create, OLAP cubes and ETL processes and Reports for it.
• Establish and maintain ETL Automation and Business procedures for data transfer standards, quality and support with business partners.
• Support 24/7 corporate info structure (SQL Server Instances, NAS, Windows)
• Create and support Data Repository procedures
• Implementation of Security procedures for Data Repositories.
• Database design, implement and document details for architecture, functionality.
• Design and create ERD Diagrams for existed and new databases
• Migration of SQL Server from v2000 to v2005 and to v2012
• Create database related procedures, such as SQL coding and database dev. standards.
• Design and create and support tables, indexes, views, complex stored procedures, functions and reports.
• Reverse engineering and modification of existing database objects
• Code reviews and staging/production releases.
• Create, modify and support for production OLAP cubes and reports
• Redesigned and Developed solutions for optimization and improving performance of SQL Instances and databases.
• Helped developers with DB tasks

Confidential, Terrace, IL

Consultant SQL DBA

Responsibilities:

• As a part of DBA group responsible for support and development of existing and new Database solutions for the company internal and external clients in EDW environment (Databases, data marts, ETL, Reports)
• Implemented BI warehouse architecture for aggregating data and managing digital healthcare data.
• Re-architected current database solution utilizing SSIS, SQL Server 2008 partitioned databases and SQL Server Analysis Services.
• Automated DBA tasks such as index maintenance, database backups, and partitioning solutions.
• Interfaced with multiple data sources and feeds like: Mango, SQL Server, XML documents and Flat files

Confidential, Arlington Heights, IL

Consultant DBA/Developer

Responsibilities:

• Investigate and create solution for performance optimizing SQL Server server and 3rd party CRM Application database.
• Design and implement SQL Server Automated DBA tasks such as index maintenance, database backups.

Confidential, Buffalo Grove, IL

Consultant DBA/Developer Lead

Responsibilities:

• DBA/Developer with new projects and 24/7 support. Design and implement Security, Data Quality and development standards for the company.
• Design and manage and accountable for data related projects.
• Designed/Created Complex ETL processes file data from over 100 sources into a normalized database environment for variable print B2B customers.
• Performance tuning, troubleshooting, and implementation of new software packages as well as in house developed software running with a SQL 2000/2008 back end.
• Database migration SQL 2000 to 2008. Development in T-SQL for stored procedures, views, and ad-hoc queries for business needs.

Confidential, Buffalo Grove, IL

Consultant DBA/Developer

Responsibilities:

• Installed, configured, upgraded and maintained database servers. Monitored replication, job execution, database installations and upgrades.
• Implemented disaster recovery, backup and restore strategies, standards and scripts. Maintained and enforced corporate database security policies. Managed hardware requirements.
• Troubleshot network, system and applications to resolve all database issues.
• Designed, developed, and maintained numerous database reporting solutions, tables, views, stored procedures, and various functions employing SQL server 2005 and 2000.
• Developed highly reliable and scalable SQL back-end to meet business needs. 3rd level support for Confidential clients worldwide.

Confidential, Rosemont, IL

Consultant DBA/Developer

Responsibilities:

• As a part of Enterprise Data Warehouse group responsible for support and development of existing and new custom reporting solutions for the company internal and external clients in EDW environment (Databases, data marts, data flow/validation and QA processes, Reports)
• Designed and created database, processes and solutions for needs of EDW group (products, process tracking, Data quality email notification processes) Designed and re-created security/encryption and backups for EDW Databases, Data warehouse and Data-marts.
• Redesigned and implemented new version of stored procedures, functions, indexes and DTS packages for improving business functionality and performance.

Confidential, Deerfield, IL

Consultant DBA/Developer

Responsibilities:

• As a technical lead consultant, analyzed, redesigned, developed and implemented new business functionality to existing Data Repository in SQL Server 2000 for Project Management group.
• Redesign and Recreated Budget Tool database of DT3 for 2006 on time and under-budget.
• Conducted reverse engineering and redesigned data repository according to the new business requirements for budget data repository.
• Redesigned and re-created Logical and Physical tables, views, triggers, stored procedures and functions.
• Modified existing and created new DTS packages for transferring Budget data from the network drive to the SQL Server Repository.
• Maintained and optimized physical database structures, stored procedure and functions.
• Provided database support as backup and restored databases. Modified Security access for data repository. Creating tech documentation of the system.

Confidential, Glenview, IL

Database Consultant

Responsibilities:

• As a member of Vending System supporting Non List Price application (NLP) with backend Oracle 8i/9i in Windows 2000 and Unix Environment.
• Redesigned and recreated the Load Purchase process with T-SQL in SQL Server 2000 repository in Windows 2000 server environment.
• Provided support for Non List Price (NLP) repository in Oracle 8I (Creation and modification of packages, stored procedures, functions) Performed conversion of NLP database and batch process from Oracle 8I to Oracle 9I under Unix IBM and HP Servers.

Confidential, Chicago, IL

Software Engineer - System Administrator

Responsibilities:

• Analyzed, redesigned, re-created, tested and supported of contact-management databases on new business and security requirements.
• Created and support databases in SQL Server 2000, with Windows 2000 Server. Administrated, troubleshot, restored and migrated of MS SQL Server 2000 databases.
• Created Back-Up strategy for Windows Server and Databases. Created/Re-designed DML (CRUD) for CRM backend.

Confidential, Schaumburg, IL

Software Engineer

Responsibilities:

• As a member of an Administration team, analyzed, designed and built the system that transfers data from XML files to Oracle 8.i database using SAX2 as a parser and Java2/JDBC to PL/SQL stored procedures and functions.
• Modified an existing Redemption Batch Process to meet new Users Requirements using PL/SQL in Oracle 8.i as a data repository in UNIX environment.
• Created new DB Module as a result of analyzing new business requirements for Fraudulent Daily Report and developed the stored procedures and functions accordingly. Built system prototype and GUI using HTML through Oracle 8i Server.

Confidential, Melrose Park, IL

Consultant - E-Commerce Programmer / Analyst

Responsibilities:

• Created Intranet Website with ASP using Visual InterDev 6.0. Utilized Visual Basic 6.0 to build ActiveX Components performing a full text search.
• Used SQL Server 7.0 as a data repository and utilized ADO 2.0 for DB Connectivity.
• Performed full business and database analysis and design with UML in Visio 5.0. Was responsible for the creation of the Data Repository.
• Built GUI and ActiveX Components for Music World Library Department using VB 6.0 and connecting to SQL Server 7.0 database

Confidential, Tinley Park, IL

Consultant

Responsibilities:

• Analyzed, designed and built a new Database for Admission Department of a Health Facility using PL/SQL in Oracle 7.3 as data repository.
• Created ActiveX components with Visual Basic 6 and used ADO for Database Connectivity.
• Built new packages in database and modified the existing stored procedures/functions to reflect new business rules.

Confidential, Chicago, IL

Consultant

Responsibilities:

• As a member of development team, participated in a full-life cycle development of Client/Server system for a Dating Agency.
• Designed and developed of GUI using VB5. Was responsible for design, development, implementation and support of Order Processing and Inventory System for Medical Company written in Visual Basic 4.0, using MS Access as a data depository.
• Performed modifications in existing systems and classes written in Borland C++ 5.0 & VC ++.

Confidential

Junior Programmer

Responsibilities:

• Developed employee Tracking System using C under Unix platform.
• As a part of a team, designed and developed applications for Human Resources Department.
• Provided complete support and user training.