SUMMARY:

Serve as technical support to the marketing team for franchise marketing, customer marketing, and sales process optimization; procure customer sales leads for target growth markets. Plan and coordinate testing changes, upgrades, and new services, ensuring the different applications will operate correctly in current and future environments. Work closely with application development teams and vendors to tune and troubleshoot applications. Sets up administrator and service accounts. Provides technical support for all corporate sales and marketing applications.

TECHNICAL SKILLS:

Commercial Cleaning, Windows Server 2012, 2016, Microsoft SQL Server 2012, 2016, ASPX.NET 2.0 - 4.5, Visual Studio 2017, SQL, SSRS, SSIS, Kentico, Scribe, Microsoft Dynamics 365, eMaximation.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL Server/ASP.Net Developer, SQL Server DBA, SQL Server Reporting

Responsibilities:

• Provide the development and management teams with leading the development/production of ETL processes and BI reports using Microsoft BI stack (SSIS, SSRS, some SSAS), designing relational database structures, prescribing and implementing database development standards, and SQL server database administration.
• Used SQL Server database technologies such as: table and view design, stored procedures, bulk file loading and processing, data validation, exception handling and reporting, batch processing, automated processing, database optimization.
• Working with business users and gathering data and reporting requirements.
• Design, document, and implement development, staging and production databases for maximum performance, scalability, flexibility, and reliability.
• Analyze and recommend database improvements.
• Determine common reporting needs and develop SSRS reports to fulfill business requirements from various management levels within the Company.
• Enhance Report Builder data model with new data objects.
• Create and maintain existing SQL Server Integration Services (SSIS) packages.
• Manage requests and scheduling for production reports.
• Manage data migration and integration between internal SQL Servers and other systems using ETL processes.
• Work with business users and QA with testing of various data transformation, ETL jobs and reports.
• Determine business requirements, design and implement complex data models.
• Create logical models, build physical models and create databases.
• Monitor system resource utilization and trending for future capacity planning.
• Install, test and maintain DBMS software including patches, fixes, and version upgrades.
• Develop, manage and test database and information system backup and recovery plans.
• Monitor database logs for hardware, memory or disk space/capacity issues and take appropriate action.
• Review and implement database parameter and configuration changes for optimal performance with the host operating system.
• Manage the support of multiple application systems and their databases.
• Collaborate with the application development team and ensure that overall application design is optimal.
• Communicate and collaborate with all project team members to ensure high quality and timely product delivery.

Environment: Health Care Provider, Windows Server 2012, 2016, Microsoft SQL Server 2008r2, 2016, ASPX.NET 2.0-4.5, Visual Studio 2012-2015, SQL, SSRS, SSIS, SSAS

Confidential, West Palm Beach, Florida

SQL Server/ASP.NET Developer, SQL BI Reporting

Responsibilities:

• Working under direct supervision of Data Architect on designing and developing SSRS/SQL reports.
• Working with business users and gathering data and reporting requirements.
• Implement data models, database designs and data access.
• Perform code releases from development to staging and production environments
• Design and Development of Schema, Aggregations, Indexes, SQL, Stored Procedures etc.
• Develop and support database activities, such as data loading and unloading.
• Responsible for troubleshooting complex production issues and escalation to needed groups.
• Design and Develop SSRS reports along with using SSIS for integration with other system.
• Developed and implemented ETL Processes by using SSIS to move data from different sources to targets.
• Develop ASP.NET, primarily Visual Studio 2013, C#, web application code.
• Build/create database utilizing MS SQL Server 2008, 2012 for the applications.
• Work closely and cooperatively with the Project Manager, Business Analyst(s), and IT Operations.
• Creates a wide variety of complicated reports including; sub-reports, parameterized reports, graphical reports, formula based, well-formatted reports, drill-down reports, analysis reports and data reports.
• Responsible for the analysis, coding, problem resolution, and user support for one or more system report applications.

Environment: TV/Cable Media, Windows 2003, 2008, 2013 Server, Microsoft SQL Server 2000, 2008r2, 2012, ASP.NET 2.0-4.5, Visual Studio 2012, SSIS, SSRS, SSAS

SQL Server/ASP.NET Developer

Confidential, West Palm Beach, Florida

Responsibilities:

• Provide maintenance changes to several asp.net applications centered on medical care enrollment process, and scheduling.
• Design and Developed new medical care enrollment application to support multiple clients.
• Used DDL Statement in support of the Data Structure
• Used T-SQL to interaction with enrollment applications and database objects
• Modify database objects such as tables, indexes, stored procedures to support the development of these enrollment applications.
• Clarifying what actions, the program is intended to perform
• Breaking down program specification into its simplest elements and translating this logic into a programming language
• Combining all elements of the program design and testing it
• Testing sample datasets to check that output from the program works as intended
• Conducting testing and installing the program into production
• Reacting to problems and correcting the program as necessary
• Evaluating and increasing the program's effectiveness
• Adapting the program to new requirements, as necessary
• Conducting user acceptance testing to ensure the program can be used easily, quickly and accurately

Confidential, Chicago, Illinois

SQL Server/ASP.NET Developer/ETL Developer

Responsibilities:

• Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
• Create and or modifying development of SSIS (ETL) packages using BIDS (Business Intelligence Development Studio).
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Implemented SSIS with DDL, DML, DCL, and T-SQL for data manipulations.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Worked on SSIS, for removing duplicate records with data standardization.
• Implemented incremental loading process with cumulative loading process.
• Created mappings to load data extracted from other SQL like SQL Server, Oracle to staging area using SQL Server SSIS.
• Created mappings to extract data from Staging area and load into enterprise data warehouse with applying various business rules.
• Extracted customer data from SQL Server database and loaded to warehouse.
• Implemented incremental loading process with cumulative loading process.
• Implemented weekly error tracking and correction process using SSIS.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Created schedules/jobs for automation of ETL load process.
• Involved in the move to production and transferring knowledge to the other team members.
• Worked with the marketing, sales and consultant staff of Vangent in support of development several applications for resale.

Confidential, Chicago, Illinois

SQL Server Developer

Responsibilities:

• Worked with internal development staff in moving an asp.net application to the Deltek vision.
• Creates database objects such as tables, indexes, stored procedures
• Development workflow process for Deltek integration
• Provide decision analysis and report development in SSRS and Deltek reporting.
• Using Microsoft SQL Integration Services (SSIS)
• Provided ongoing support and development corporation web site using Kentico CMS.

Environment: Engineering Health Care, Windows XP, 2003, 2008 Windows Server, Microsoft SQL Server 2005/2008, SSIS, SSRS, T-SQL, ASP.NET, Visual Studio 2008, Visual Studio 2010, Business Intelligence Development Studio, DelTek Vision, Kentico CMS for Asp.NET

Confidential, Chicago, Illinois

SQL Server/ASP.NET Developer

Responsibilities:

• Worked in the IT department migrating over 1000 reports from Crystal Reports version 9 and 10 and over 500 reports running under Crystal Enterprise version 10 to Crystal Reports XI and Crystal Reports Server XI.
• Worked with and assisted department in consolidating several redundancy reports that were run across 10 different company accounts.
• Provide one-one training/support to financial group in using Crystal Reports version XI.
• Install and configure Crystal Reports Server XI.
• Develop an ASP.NET application (VS2005) that allow department to access report without have to install crystal reports on their desktops.
• During this development I work with these departments to determine what reports would be access via asp.net interface, crystal reports (desktop) and scheduled reports using Crystal Reports Server XI.
• This development allows department personnel to access 5 difference SQL servers, and 10 different company databases using the same reports across all companies.
• I also created the SQL tables, views, triggers, DTS and stored procedures used in this application
• Design and programmed complex stored procedures, views and data aggregation/manipulation though table joins/queries
• Work in troubleshooting application and database issues.
• Creates database objects such as tables, indexes, stored procedures
• Design and programmed complex Data Transformation Services packages to import, execute, transform and load data
• Document database application

Environment: Health Care, Windows 2000, 2003 Server, Microsoft SQL Server 2000, Crystal Reports v8, 10 and XI, Crystal Report Enterprise ver. 10, Crystal Report Server XI, ASP.NET 2.0, Visual Studio 2005

Confidential, Chicago, Illinois

SQL Server/ASP.NET Developer

Responsibilities:

• Worked with the marketing group in assisting them several small projects.
• Like developing reports from marketing database, automate client survey distribution, data collection, import/exports process and development of analysis reports.
• Assist marketing personnel in developing on-line Deltek training videos for employee.
• Developing SEC new website using Kentico CMS tools

Environment: Engineering, 2003 Server, Microsoft SQL Server 2005/2008, SSIS, SSRS, T-SQL, ASP.NET, Business Intelligence Development Studio, DelTek Vision, Kentico CMS for Asp.NET

Confidential, Chicago, Illinois

SQL Server Developer

Responsibilities:

• Worked in Quality Assurance group creating a SQL application that would test the performances of their Learning Management System.
• This development consists of data generated and loading of data using different sizing profiles.
• The data generated sql database consists of about thirty stored procedure, fifty tables and couple of dts packages.
• The import/executing sql database consisted of about fifty stored procedure, fifty tables and fifty to sixty dts package to migrate data.
• Their Learning Management System contains 850 tables, 300 views, 2500 stored procedures.
• With the development of this tool I was required to:
• Design and programmed complex stored procedures, views and data aggregation/manipulation though table joins/queries
• Work in troubleshooting application and database issues.
• Creates database objects such as tables, indexes, stored procedures
• Design and programmed complex Data Transformation Services packages to import, execute, transform and load data
• Perform database analysis, tuning and optimization
• Perform hardware capacity planning for machines supporting MS-SQL database servers
• Documents database application

Environment: Consulting, Windows 2003 Server, Microsoft SQL Server 2000

Confidential, Chicago, Illinois

SQL Server Developer

Responsibilities:

• These interfaces were developed using MS SQL 2000 Server technology, with this I:
• Design and programmed complex Data Transformation Services packages to extract, transform and load data (Text files, Excel files, SQL Tables, etc.)
• Design and programmed complex stored procedures, views and data aggregation/manipulation though table joins/queries
• Scheduling jobs for processing and emailing of reports
• Develop reports in Access, Crystal Reports and using SQL Server 2000 Reporting Services
• Also assisted in the project planning and requirement creation of many of these interfaces

Environment: Windows 2003 Server, Microsoft SQL Server 2000, Access, Excel, Crystal Reports 8 & XI, SQL Server 2000 Reporting Services

Confidential

ASP NET Developer

Responsibilities:

• Worked within the Information System Division updating Lotus Notes and Excel applications to ASP.NET applications.
• These applications consisted of an order entry system and a shipping order system.
• Work with project manager in redesigning and add more functionally to this application.
• The databases used with these systems were Oracle8i and Oracle 10g.
• Responsibilities included designing web forms using ASP.NET
• Design SQL data structure, view, stored procedures, tables
• Design and written crystal reports
• Created Indexes for various tables in the database to perform database tuning.

Environment: Windows 2003 Server, Novell, Visual Studio.NET (ASP.NET, ADO.NET and VB.NET), Pl/SQL, .NET Architecture, JavaScript, IIS Web Server, Oracle 8i, Oracle 10g, Crystal Reports 10