SUMMARY:

• Administration of SQL Servers using Management Studio and Enterprise Manager.
• Perform software installation, database design and development, security, and database optimization.
• Create and manage database and transaction log backups as well as DB maintenance jobs.
• Creation of SQL objects including tables, views, stored procedures, triggers, SSIS\DTS packages, automated jobs, logons, roles etc.
• Perform day - to-day database administration activities to ensure integrity, security and availability of Production, QA and testing environments.
• Creation of SSIS packages used for data warehousing/data migration.
• Migrating packages to Integration Services Catalog, Automate transfer and cleansing of data from SQL Server, Mainframe, Flat files, etc by using various Control flow and Data flow transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task and Send Mail task for initial as well as incremental data loads. Creation of DB Maintenance plans.
• Report creations in Business Intelligence Studio. Create and modify various types of reports including Dashboards, Score Cards, Tablix\Matrix, Drill Downs, as well as Charts. Reporting from SQL Server databases as well as SSAS cubes and Access. Involved in performance tuning and deployment of reports. Create and maintain subscriptions for automated reporting delivery. Administration of security\roles using Report Manager as well as Management Studio. Involved in requirements gathering and report design.
• Develop and maintain SSAS 2012 Cubes. Creation and modification of Dimensions and Measures. Cube modification and deployment. Creating KPI’s and calculated fields.
• Tableau, Power BI, Excel, Power Pivot, Python.

PROFESSIONAL EXPERIENCE:

Confidential, Carpinteria, CA

Data warehouse Developer

Responsibilities:

• Responsible for creating and modifying SSIS packages to support Confidential ’s data warehouse.
• Using SQL 2014 and 2016 as the platform, imported SSIS packages into Integration Services Catalog from file based repository.
• Modified existing package to use newer features of 2016 and to account for additional business rules logic.
• Run daily data validation checks to insure data integrity for company web site and Agent\Client reports.
• Created reports in SSRS as well as Power BI.

Confidential, Mayfield Village, OH

BI Developer

Responsibilities:

• Creating\maintaining SSIS packages to support reporting data mart. Transfer of data from DB2, flat files and SQL Server into a SQL Server data store.
• Export of data to raw files and staging tables and used various transforms to stage data.
• Heavy use of lookups, conditional split, data conversion, and merge join transformations to satisfy desired business rules.
• Responsible for unit testing and QA testing as well as documentation of all SSIS packages and processes.
• Responsible for creating SSRS reports using SQL Server tables and SSAS cubes as data sources.
• Meeting with Business users to gathering requirements.

Confidential, Coral Gables, FL

BI Developer

Responsibilities:

• Responsible for creating SSIS packages to import incoming data files.
• Created tasks such as looping through a directory, unzipping and processing files meeting a given criteria, moving files, and transforming the data using various Data flow tasks to stage\cleanse data.
• Created stored procedures to in corporate business logic as required for the various components of the application.
• Testing and validating of data in a Development and QA environment before promoting to production.

Confidential, Streetsboro, OH

SSIS\Reporting Services Developer

Responsibilities:

• Responsible for converting SQL Server 2000 DTS packages to SSIS packages. In addition, responsible for creating new SSIS packages to support the systems upgrade as well as in house application processes.
• Other duties involve creating Reporting Services reports as requested by the clients, database maintenance especially database backup, index monitoring, and security.

Confidential, Cleveland, OH

Reporting Services Report Developer

Responsibilities:

• Reports developer for conversion from Business Objects\Crystal Reports to Microsoft Reporting Services.
• Analyzed current Crystal Reports catalog and reporting requirements with Business Analysts.
• Created reports using MS Reporting Services and tested functionality with end users in development and QA environments.
• Created various types of reports such as summary, trend analysis, matrix, and charting.
• Set up subscriptions for various reports and delivered via email as well as file location.

Confidential, Miami, FL

Database Administrator

Responsibilities:

• Split current Production SQL Server database into two separate components.
• Creation of new database objects such as tables\view\stored procedures to enhance current application.
• Tested performance and integrity of new application\processes.
• Performed stress testing, implemented and tested roll back procedures.
• DBA support for production as well as test applications.
• Database management, which includes db backups, security, user support.
• Maintain testing environments and create new and redesigned database\objects, added users and roles, performance testing of new processes, and roll out to Production.

Confidential, Miami, FL

Database Administrator

Responsibilities:

• Responsible for the creation of SSIS\DTS packages to move data from Sybase to testing db’s in SQL server environment, testing and verifying schema and data integrity between the 2 platforms, conversion testing and roll back procedures, and finally implementing the conversion to a SQL Server platform.
• Maintenance of all Production and Test servers.
• Created and maintained database and transaction log backups, reindexing\defragmenting of tables, creation of new database objects, adding users and roles for security, reviewed stored procedures\code written by developers and implemented into Production databases.

Confidential, Ft. Walton Beach, FL

Database Administrator

Responsibilities:

• Daily administration of 11 servers on site and at remote locations for car dealership CRM application.
• Creation of databases\tables\objects.
• Develop and monitor backups, transaction log backups, database maintenance plans.
• Design and implement of DTS\SSIS Packages and SQL jobs to move\transform data as required.

Confidential, Akron, OH

Database Developer/Crystal Reports Writer

Responsibilities:

• Responsible for developing and maintaining SQL Server Data Warehouse which includes daily administration, database development and design, indexing, user and security set up, monitoring of backups and user activity.
• Validating data to comply with the HIPAA standards required for the Medical\Insurance business.
• Development and Maintenance of ETL processes from Confidential system into SQL Server 2000 databases via DTS packages.
• Created Crystal Reports accessing the data warehouse for various departments.