SUMMARY:

• Senior SQL Server Developer with over ten years of experience in SQL Server 2016/2014/2012/2008/2005 database development, database troubleshooting, performance tuning, database design and ETL design.
• Currently working at Confidential Insurance on development and support of SQL Server databases.
• ETL development and administration, database design performance tuning, etc. for multiple SQL server database servers.

TECHNICAL SKILLS:

DBMS: MS SQL Server 2016,2014, 2012/2008R 2/ 2008/2005/2000 , MySQL 5.8, Sybase 10/11, Oracle 11G

OS: Windows

Tool: Crystal Reports 12.0,Python 3.6,Cassendra 3.10,DTS, SSIS, SSRS, Ms Azure, ASP, VB, COM, .NET, Sharepoint

PROFESSIONAL EXPERIENCE:

Confidential, Somerville, NJ

Sr Database Developer/Analyst

Responsibilities:

• Collaborated with system architects, design analysts to understand business or industry requirements.
• Partnering with IT to ensure system integration and approach data loads, governance, and logic.
• Developing and installing appropriate levels of controls per interim data loads, and also focus on long term systems approach.
• Focus on specific issues / data challenges unique to each BU while ensuring appropriate steps to drive harmonization.
• Collaborate with Data Integrity Manager and IT product owner to ensure comprehensive and aligned approach to IT roadmap per additional systems (i.e. CRM).
• Designing multiple SSIS packages for retrieving data from heterogeneous systems.
• Creating and maintaining upload scripts to a hierarchical database as part of a data migration using SSIS.
• Creating stored procedure to imports internal XML feeds into a SQL Server 2005 tables.
• Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows).

Confidential, NJ

Senior SQL server Developer

Responsibilities:

• Hands - on experience in Azure Cloud Services (PaaS & IaaS)
• Azure Data Factory to create a pipeline to move data from your local server up to AzureStorage.
• Experience working as a DEVOPS Automation Engineer for database deployment
• Experience in designing ETL for data movement between excel, flat file, RDBMS like Oracle, DB2 and SQL Server using Bulk Insert, BCP utility, DTS and a variety of SSIS(ispac) packages including custom transformations for a wide range of business requirements
• Extracted data from internal data warehouse system to SSRS
• Created reports in SSRS
• Modified SP's and formulated basic coding and scripting to be utilized for reports
• Analyzed data models, data relationships, and dependencies for greatest optimization
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Performed functional and performance QA testing
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Conduct code walkthroughs and review peer code and documentation.
• Build efficient SSIS packages for processing fact and dimension tables
• Created system for capturing, reporting, and correcting error data.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Provide on-call support to production system to resolve any issues.
• Gather requirements and design of data warehouse and data mart entities.
• Perform data validations and data cleansing
• Good understanding of MS-SQL Server database model and infrastructure; about tables, views, stored procedures, functions, keys, indexes, constraints, triggers, database replication, as well as SQL Server Agent (Jobs).
• Capture audit information during all phases of the ETL process.
• Responsible for deployment of packages and database projects
• Preparing and providing database development requirement specifications to SQL Server database developer
• Analyzes and generation of all tables and index statistics -Monitoring and resolving blocking and dead lock issues
• Create indexes to achieve optimum response time for time consuming quries and reports. understanding of Software Development Life Cycle Documentation on sharepoint
• Documentation management in sharepoint

Environment: SQL Server 2017, 2016, 2014, 2012, AlwaysOn, MS Azure, ERwin, SSIS, PowerBI, VSTS, Windows Server 2012

Confidential, Murray Hill, NJ

Sr. SQL Server Developer

Responsibilities:

• Working as Primary SQL Server Developer in SQL server 2014,2012 environments performed Devops work for continuous integration and continuous deployment using VSTS
• Understanding of code version control using TFS
• Involved in the conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design,development,Unit testing,
• Proficient in scripting T-SQL queries, Ranking functions,Derived tables, common table expressions (CTEs),stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Proficient in the use of majority of the SSIS transformations,Containers,Tasks,migration of data from various source DB' s like Sybase, Access, Excel, Flat File to SQL Server, package configurations,logging,checkpoints,master and child packages,packagedeployment,variables and expressions,error handling and troubleshooting.
• Aanalyze SQL query execution plan to optimize performance
• Wrote Powershell scripts for to automate database operations
• Experience in developing and performance tuning of complex SQL quires on high volume of data.
• Partitioning for large tables in SQL server databases to improve performance.
• Design and develop ETL (SSIS) processes for Datamart to load data from other heterogeneous sources(Oracle, Excel, Flat Files)
• Experienced in Database design, Coding, unit testing and Implementation.
• Proficient in creating Index, Views, Complex Stored Procedures and appropriate User defined functions.
• Expertise in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
• Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent
• Good knowledge in developing and designing reports through SSRS
• Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.

Environment: SQL Server 2017, 2016, 2014, 2012, 2008R 2/ 2008/2005/2000 , AlwaysOn, MySQL, MS Azure, ERwin, SSIS, PowerBI, VSTS, Git, Python, OS Windows Server 2008/2003, Redhat Linux

Confidential, NJ

Senior SQL server Developer

Responsibilities:

• Worked on all phases of development lifecycle, from gathering requirements to testing, implementation, and support.
• Effective designing of databases including: logical & physical data design, tables, normalization techniques, relationships, primary & foreign keys, and data types,
• Invoved in Database Design of data mart.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Contributed in creating ETL designs and provided end users an easy accession to data marts.
• Troubleshot and resolved data models issues and formulated reports
• Tested, adjusted and monitored alterations in designs using ERWIN tool.
• Maintained data marts up-to-date and in accordance with company’s requirements and practices.
• Documented data discovery, designs, patterns and mining projects.
• Develop reports using SQL server reporting services and utilizing SQL queries and stored procedures.
• Performance tuning for slow running queries
• Follow SDLC, Change Control Management of the daily deployment of database code to UAT and production environment.
• Extensive experience writing and performance tuning of T-SQL queries
• SQL Development - ability to write and troubleshoot SQL Code and design ( stored procedures, functions, views, triggers, indexes, constraints )
• Manage Indexes and statistics to improve performance and storage requirements.
• Establish SQL coding standards, naming conventions, & data access policies.
• Create report using crystal reports tool
• Document company's database environment, processes, & procedures

Environment: SQL Server 2014, 2012, 2008R 2/ 2008/2005/2000 , Oracle 10G/11G, MySQL, ERwin, SSIS/DTSCassandra, OS Windows Server 2008/2003, Redhat Linux

Confidential, Radnor, PA

Senior SQL server Developer

Responsibilities:

• Collaborated with system architects, design analysts to understand business or industry requirements.
• Designing multiple SSIS packages for retrieving data from heterogeneous systems.
• Creating and maintaining upload scripts to a hierarchical database as part of a data migration using SSIS.
• Creating stored procedure to imports internal XML feeds into a SQL Server 2005 tables.
• Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows).
• Resolved blocking and deadlocking issues in concurrent queries.
• Database modeling, Database architecture and normalization techniques.
• Deployment of Microsoft standard maintenance jobs for optimization of databases like re-indexing, index defrags, updates statistics.
• Performance tuning and optimization of SQL Server database and quires.
• Implemented table partitioning to improve performance and data management.
• Developed SSIS package to refresh data from production.

Technology/Software: SQL Server 2008R 2/ 2008/2005/2000 , ERwin, SSIS, SSRS, TSQL, XML, OS Windows Server 2008/2003, Linux, Idera SQL Diagnostic Tool, MySQL

Confidential

Senior SQL Server Database

Responsibilities:

• Database administration activities as an on call production support DBA for SQL Server databases for EASM supported applications like Estore. Created ER data models for product and pricing data.
• Designed databases to support business applications, ensuring system scalability, security, performance and reliability.
• Developed data models for applications, metadata tables, views or related database structures.
• Designed and developed scripts to refresh selective data from production to development, QA and production support environments.
• Involved in resolving the blocking and deadlocking issues and performance improvement using index tuning and other techniques.
• Performed capacity planning and disk configurations for new hardware infrastructure.
• Database modeling, database architecture and capacity planning and normalization techniques.
• Code development and optimization (optimizing SQL queries). SSIS development and troubleshooting for data load.
• Worked in SSRS administration and report creation. Performance test using tools like SQL profiler or server side traces.
• Implemented table partitioning to improve performance and data management.

Environment: SQL Server 2008R 2/ 2008/2005/2000 , SSIS/DTS, TSQL, OS Windows Server 2008/2003, Idera SQL Diagnostic Tool

Confidential

Production Database Support - SQL Server - 2008, 2005, 2000 DBA Developer

Responsibilities:

• Development and support for data warehousing in SQL server database system.
• Designing fact and dimension tables for data warehouse database.
• Creating SSIS packages to load data from OLTP database into data warehouse database.
• Database administration activities as an on call production support DBA for SQL Server and part of RITS DBA account managers’ team.
• On boarding new servers from different BUITS as per the RITS standard.
• Handling SQL 2008/2005/2000 Installations (Cluster and Standalone).
• Involved in installing SQL server single instance and multi instance clusters with active/active or active/passive configuration.
• Migration from SQL 2000/2005 to SQL 2008.
• Backup, restoration and recovery in different scenarios.
• SQL server optimization job scheduling and maintenance.
• Partitioning for large tables in SQL server databases.
• Maintaining database documentation at team site.
• Part of tier3 team and account manager for tier1 offshore team (PSITOPS).

Environment: SQL Servers 2008/2005/2000 , SSIS/DTS, TSQL, OS Windows Server 2008/2003, LiteSpeed

Confidential

SQL Server - 2005, 2000 DBA Developer

Responsibilities:

• Database development activities as Production Database support for SQL Server 2005/2000.
• Create Stored procedures, triggers, views and functions. Wrote complex queries to create reports.
• Creating performance tests using SQL profiler (client side and server side traces).
• SQL server 2005 installation (including integration and analysis services).
• Database Design: Forward and Reverse engineering of ERD and Schema.
• Backup, restoration and recovery in different scenario.
• Managing user creations, assigning roles to SQL databases.
• Requirement analysis and capacity planning for database designing, maintenance, update application schema structure/data models/ERDs and relations between objects as per requirement analysis using Erwin.
• Installation of SQL server 2000\2005, applying service packs and hot fixes.
• Development of DTS and SSIS packages, migration from DTS (SQL 2000) to SSIS (SQL 2005).
• Administrator for Hyperion Essbase application. Developing reports using Hyperion Essbase.

Environment: SQL Servers 2005/2000/7/6.5 , SSIS/DTS, SQL, TSQL, ERwin, MySQL 5.0, Sybase 10/11, Windows

Confidential

SQL Server - 2000 Database Support

Responsibilities:

• Installation of SQL server binaries, service packs and hot fixes.
• Maintaining DTS packages, SQL server agent jobs and performance tuning.
• Backup, restoration and recovery in different scenario.
• Managing user creations, assigning roles to SQL Databases.
• Server side and client side DB trace to monitor the activities on the database server.
• Capacity planning for new servers.

Environment: SQL Server 2000, ERwin, DTS, SQL, TSQL, Windows

Confidential

SQL Server DBA

Responsibilities:

• Wrote stored procedures in SQL Server Using TSQL.
• Performance tuning. Database backup and restore.
• SQL 2000 log shipping and replication.
• Installation of components in MTS.

Environment: SQL Server 2000, ASP, VB, COM, MTS, Windows