SQL Developer Resume Cincinnati, OH - Hire IT People

OBJECTIVE:

Accomplished software developer with a proven ability to develop and support stable, well - performing software and systems in a demanding and changing business environment. Primary focus on working with SQL Server (backend programming and direct work with Database).

TECHNICAL SKILLS

SQL Server 2008, 2012, 2014
SSIS and SSRS
T-SQL and query optimization, developing ETL strategies
Data warehousing and Business Intelligence
Python, SQL
Database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations
Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages
Oracle, Crystal Reports, FoxPro, Cognos, Informatica
Kafka
.NET, ASP, VBScript, JavaScript, HTML/DHTML, XML.
C#, VB.NET, C/C++, Visual Basic, ColdFusion, ActiveX Controls and DLL Documents, COBOL, FoxPro, PowerBuilder
Microsoft Visual Studio .NET, Team Foundation Server, Microsoft Visual SourceSafe, Subversion, Microsoft Visual Interdev, Microsoft SharePoint, Microsoft FrontPage, Dreamweaver.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

SQL Developer

Responsibilities:

Working on creating ETL processes for SQL Server, Oracle databases using Informatica. Created numerous reports in SSRS.
Extracted data from internal data warehouse system to SSRS.
Designed and developed stored procedures, queries and views necessary to support SSRS reports
Created ETL processes to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages using BIDS.
Created many Power BI Dashboards.

Confidential, Cincinnati, OH

SQL Developer

Responsibilities:

Created ETL process that moves data from transactional database to Data Warehouse designed in MS SQL Server Integration Services (SSIS).
Created custom reports that combine data from different sources such as MySQL, Access Database, SQL Server.
Monitoring SQL Server performance, optimizing queries, creating stored procedures.
Created multiple SSIS Packages and CLR Assemblies (written in C#) to handle encryption/decryption, YAML/XML parsing of the data.

Confidential

SQL Developer

Responsibilities:

Confidential

Software Developer

Responsibilities:

Supporting multiple Windows Services written in C# with SQL Server on the back end.
Created numerous SSRS reports and SSIS packages including packages to maintain Data in the Data Warehouse.
Working with SQL Server 2008/2012.
Working with Team Foundation Server.
Took part in creating Data Warehouse Database architecture and ETL package that provides data.
Performed Database restoration and recovery.
Involved in complete Life Cycle including Analysis, Design, Development and Testing.
Developed modules of the application in ASP.NET and involved in writing C# classes.
Used Web Services to communicate with the business layer objects.
Developed WCF services to enable effective communication between SOA.
Implementing LINQ queries on different data sources.
Implementing AJAX scripts.

Confidential

Software Developer/BI Specialist

Responsibilities:

Created numerous SSIS packages of SQL Server 2008.
Supporting applications written in C# with SQL Server 2005 on the back end.
Created SSIS packages for the nightly update of Data Warehouse.
Supported big reporting system using Cognos and Informatica.
Worked closely with DBAs on optimizing and executing queries of SQL Server 2008.
Contract position.