SUMMARY

• 7 years of IT experience on Database Development and Administration with MS SQL Server technology.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services in SQL Server 2008/2012/2014.
• Hands on experience in Transact - SQL (T-SQL), MS Access, vb.net Programming.
• Extensive experience with Backing Up, Restoring and Moving of Databases.
• Configuring SQL Server Agent Jobs. Designing Database Security.
• Hands on experience in Installation and Configuration of SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005 and SQL Server 2000 technology, service packs and hot fixes.
• Experience in SQL database design, architecture, data modeling using Erwin, Data Warehousing and analysis skills, ETL tool with Microsoft Technologies like SSIS/SSRS.
• Strong understanding of RDBMS concepts and Data Modeling Concepts, which includes Logical and Physical Modeling.
• Ability to create new databases. Capacity Management of SQL Server and Databases.
• Implementing and Managing of Replication in SQL Server 2014, 2012, 2008 and 2005.
• Ability to Migrate Databases from Microsoft Access to SQL Server 2005 and SQL Server 2000 to SQL Server 2005 and to SQL Server 2008 and SQL Server 2008 to SQL Server 2012 and SQL Server 2014.
• Expertise in Database Maintenance by using Managing Index Fragmentation. Managing Statistics, Shrinking Files and Using DBCC Commands.
• Expertise in Failure Diagnosis with Database Failures, Physical Server Failures and SQL Server Service Failures.
• Monitoring and Troubleshooting SQL Server Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions, Partitioning and Resolving Blocking and Deadlocking Issues.
• Expert in creating Dashboards using Tableau
• Ability to handle the projects as a SME (Subject Matter Expert).
• Good Ability to debug the code issues in Web Applications communicating with SQL Servers.
• Hands on experience in Deployment of DTS and SSIS packages using ETL Tool.
• Designing SSIS packages for extraction, transformation and loading of data.
• Configuring SSRS. Generating Reports using SSRS.
• Expert noledge of client connectivity TDS/TCP/IP packages including ODBC, OLEDB, and JDBC.
• Working with developers to move all dynamic SQL into stored procedures and connection strings into web.config files.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/ 2012/ 2008/ 2005 and Oracle 9i/10g/11g/12c.

SQL Server Tools: SQL Server Management Studio, SQL Server Profiler, DTS, Replication and Mirroring, Always on Availability groups, SQL Server Migration Assistant

Operating Systems: Window 9x, Windows NT, Win 2000, Windows 2003/2008/2012 Server.

Languages: C, C++, T-SQL, PL-SQL, C#

Internet Technologies: ASP.NET, HTML, XML, DHTML, VB.NET, JavaScript, Active Server Pages (ASP)

Tools: Redgate, SQL Lite Speed

Ticketing Tool: Remedy 7.6, Jira, Asana

Monitoring Tools: SQL Diagnostic Manager (Idera)

ETL Tool: SQL Server Integration Services

Reporting Tool: SQL Server Reporting Services

Analysis Tool: SQL Server Analysis Services

PROFESSIONAL EXPERIENCE

Confidential, KY

Senior SQL Developer

Responsibilities:

• Responsible for designing new schemas, table structures in database.
• Responsible for creating and maintaining database objects like stored procedures, functions, tables and views.
• Analyzing the performance issues in SQL Server database and created Clustered and Non-Clustered indexes.
• Identified the unique combination on table’s data and implemented unique non-clustered indexes to avoid inserting duplicates.
• Used SQL Profiler and default system tools for troubleshooting the issues in SQL Server.
• Designed dataware house and with required fact and dimension tables scheduled jobs to move data from production databases to dataware house periodically.
• Designed SSISPackagesto transfer data from flat files to SQL Server
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task.
• Migrated SQL Server 2008 to SQL Server 2012 and SQL Server 2012 to SQL Server 2014.
• Created T-SQL scripts to take user defined and system databases backups and stored them in S3 bucket.
• Responsible to setting up and supporting the Always on Availability group on Production databases.
• Actively participated in Scrums to interact with other developers.
• Provided 24x7 Production support in handling the databases and other applications.
• Handled the databases as a database owner and responsible for assigning the required permissions for the users with in the team.
• Responsible for building, maintaining and deploying Tabular Reports, Matrix Reports, Sub Reports, Drill-Through Reports using SQL Server Reporting Services.
• Responsible to setting up the transactional replication in SQL 2012 and SQL 2014.
• Created T-SQL scripts to monitor deadlocks.
• Responsible to create ad-hoc reports using Izenda.
• Queried against Postgre SQL database and generated a SSRS report.

Environment: Microsoft SQL Server 2008/ 2012/2014, SSIS, SSRS, Microsoft Office 2007/2010/2013, .Net 3.0, .Net 4.0, .Net 4.5 and .Net 6.0, Windows server 2008/2012, Mongo db, Izenda, Postgre SQL, AWS, Angular, Node js

Confidential

SQL\SSRS Developer

Responsibilities:

• Responsible for migrating the databases from Microsoft Access to SQL Server 2005, and SQL Server 2005 to SQL Server 2012.
• Successfully migrated the JDA Application from JDA 2005 to JDA 8.0.0
• Successfully migrated the Oracle 10g database to SQL Server 2012 using SQL Server Migration Assistant.
• Responsible for designing new schemas, table structures in new server.
• Maintaining the databases on current system (Microsoft Access).
• Responsible for creating the database objects like stored procedures, functions, tables and views.
• Created front-end design using Microsoft Access for the business users to view the table’s data and reports.
• Created new forms and reports using Microsoft Access to build the front end.
• Analyzing the performance issues in SQL Server and created Clustered and Non-Clustered indexes.
• Identified the unique combination on table’s data and implemented unique non-clustered indexes to avoid inserting duplicates.
• Generated code for the front-end design using visual basic.
• Responsible for troubleshooting the issues in Microsoft Access and in SQL Server.
• Actively participated in Scrums to interact with other teams and developers.
• Provided 24x7 Production support in handling the databases and other applications.
• Analyzing and fixing the performance issues on Oracle 10g databases.
• Good noledge and experience working on .net applications.
• Responsible for Onshore and Offshore coordination.
• Handled the databases as a database owner and responsible for assigning the required permissions for the users with in the team.
• Responsible for creating and generating the Tabular Reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Handled couple projects as a SME and delivered them successfully on time.
• Responsible for documenting Business requirements, Functional Specifications and Technical Specifications documents.

Environment: Microsoft SQL Server 2000/2005/2008/2012, Microsoft Share Point, Data Stage, SSRS 2005, Micro Strategy, Microsoft Office 2007/2010, .Net 3.0, .Net 4.0, .Net 4.5, Windows server 2003/2008, Site minder, JDA 2005, JDA 8.0.0, Oracle 10g, Power Designer

Confidential

SQL Analyst/SSIS Developer

Responsibilities:

• Responsible for migrating the databases from SQL 2005 to SQL 2008.
• Used Microsoft Access as a staging environment and tan migrated the data to Production SQL Servers.
• Responsible for organizing the data comes in various formats in Microsoft access.
• Used SQL Server 2005 and 2008 to view and manage the data.
• Used Red gate SQL tool belt for any changes in scripts and schemas.
• Responsible for creating the database objects like stored procedures, tables and views.
• Managing SSIS Packages and scheduled them to run in Production servers.
• Responsible for troubleshooting the failed packages.
• Handled the Errors at Control and Data flow level in SSIS Packages.
• Actively participated in Scrums to interact with other teams and developers.
• Generated Master and Validation reports from Microsoft Access and uploaded them to Microsoft Share point Portal.
• Used Internal Utilities to map the data in Microsoft Access databases.
• Used VB.Net to build the macros in Microsoft Access.
• Responsible for solving the performance issues.

Environment: Microsoft SQL Server 2005/2008, Microsoft Access, Microsoft Office 2007, SSIS, SQL.net, Windows 2007 and Business objects.

Confidential

SQL Developer

Responsibilities:

• Participated in Requirement Gathering sessions with end users
• Created SSIS packages to transfer data between OLTP and OLAP databases
• Created couple of reports using SSRS and used SSIS for transforming data from various input sources to the application.
• Developed various front end Screens using C#.Net
• Used Telerik Controls for Various Grid objects and graphical representations
• Responsible for writing Oracle packages & queries
• Responsible for ETL operations within the Engineering groups including client feeds and Data ware house systems.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, TSQL.