SUMMARY

• Around 7+ Years of total IT experience includingSQLServer Database Administration for very large and complex databases inSQLServer
• Experience in database administration and development activities like Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, Database Security and Patching SQL server.
• Experience in analyzing, designing, tuning and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC) using MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 DTS/SQL Server Integration, Reporting & Analysis Services.
• Experience in solving Real Time issues withIndex fragmentation, DBCC checks, Query Tuning, ErrorandEvent Handling
• Involved in Huge data migrations, transfers using utilities likeData Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Expert in developing T - SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
• Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• ETL implementation using SQL Server Integration Services (SSIS) and Talend.
• Excellent in High Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in creating and deploying SSIS Packages on high-activity, normalized transaction systems (OLTP), highly-usable renormalized reporting systems (OLAP) as well as staging areas and data marts.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Expertise in generating reports using SQL Server Reporting Services (SSRS), POWERBI, EXCEL services and Power View
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF
• Migration experience with multiple databases/servers from SQL 2000 to SQL 2005 and SQL 2005, SQL 2008R2 to SQL 2012.
• Expert in writing TSQL, Stored procedures, Views, Triggers and Functions.
• Experience in working high transacted OLTP systems.
• Experience in implementing different types of Replication like Snapshot and Transactional, Merge Replication.
• Expertise in database Backup, Recovery and Disaster Recovery procedures that alert lead developers / key functional users when it finds any issues. Developed and documented disaster recovery plans and backup and recovery strategies for production environment.

TECHNICAL SKILLS

RDBMSMS: SQL Server 2014/2012, 2008R2, 2008, 2005, 2000

Operating Systems: Windows server 2008/R2, 2003, Windows 2000, Windows NT 4.0, Windows 95/98/XP

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor, Database Tuning Advisor, SSRS, SSIS, POWERBI

BI Suite: SSAS, SSIS, SSRS, PPS 2007/2010, Powerview, Excel services etc.

ETL TOOLS: DTS, SSIS, Talend

Languages: C#, Vb.Net, C, C+, T-SQL, XML.

Third Party Tools: Spotlight, SQL Lite Speed, Idera’s diagnostic manager, Red Gate SQL Compare, Red gate Source Control.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia

Senior SQL Server Developer/BI Consultant

Responsibilities:

• Working with 24x7 Production support and On-Call rotation.
• Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
• Designed and normalized the databases, have written T-SQL Queries and created different objects like Tables, Views, Stored Procedures, User defined functions and Indexes
• Migrated DTS packages to SSIS
• Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments and maintenance.
• Worked on several complex drilldowns, parameterized reports and on reports that call sub reports using SSRS.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition of the reports.
• Designed Weekly and monthly reports using SSRS, Power pivot and power views
• Scheduled reports for daily, weekly, monthly subscription reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS) 2008/2008 R2.
• Implemented Database Mirroring on SQL Server 2012/2008 environments.
• Used ERWIN to carry out heavy duty Logical and Physical data modeling
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Used Tableau business intelligence software to design reports in different format
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Migrated database from SQL Server 2008 R2 to SQL Server 2012.
• Worked extensively in performance tuning of databases including query tuning, server tuning.
• Created and scheduled maintenance plans for Database backups, log backups and cleanup.
• Troubleshooting connectivity & other miscellaneous issues between Cognos &SQLServer.
• Supporting the business 24*7, maintaining 99.999 uptimes, depending on the application and business SLA requirements.
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: SQL Server 2008/2012/2014 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI Desktop, C#, .Net, Visual Studio.

Confidential, Atlanta, Georgia

Senior SQL Developer

Responsibilities:

• Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
• Involved in Gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the Source to the Target Data warehouse.
• Designed and normalized the databases, have written T-SQL Queries and created different objects like Tables, Views, Stored Procedures, User defined functions and Indexes.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated the update of the database statistics.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base.
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008/2012 tools like SQL Server Management Studio, SQL Server Profiler.
• Migrated DTS packages to SSIS.
• Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments and maintenance.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed ETL Packages using SQL Server 2012 Integration services to populate data from different sources like flat files/CSV Files to the staging databases. The packages created included a variety of transformations like Look up, Aggregate, Derived column, Conditional split, Multicast, Execute SQL Task, Term Extraction, Data Conversion etc.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Worked on several complex drilldowns, parameterized reports and on reports that call sub reports using SSRS.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition of the reports.
• Scheduled reports for daily, weekly, monthly subscription reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS) 2008/2008 R2.
• Maintained versions Using TFS.

Environment: SQL Server 2012, SQL Server 2008R2, SQL Server Business Intelligence Development Studio 2008, MS SQL Server DTS, SSIS, SSRS, T-SQL, Performance Point Server, T-SQL, Visual Source Safe, SQL prompt, Report Builder3.0

Confidential, Long Island, NY

SQL Server Database Developer\DBA

Responsibilities:

• Scheduled reports for daily, weekly, monthly subscription reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS) 2008/2008 R2.
• Maintained versions Using TFS.
• Maintained various client databases in MS SQL Server 2000, 2005, 2008, 2008R2 and 2012 versions.
• Wrote stored procedures for ease of administration and management.
• Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning the performance of the SQL Server.
• Scheduled maintenance on databases and capacity planning to increase performance and productivity.
• Administer client reports using Reporting Services (SSRS) in native and SharePoint integrated mode.
• Troubleshoot and minimize production down issues.
• Created and Implemented, scheduled maintenances and backup procedures to the database to enhance overall performance and disaster recovery methods.
• Extensive use of DTS/SSIS and scripting for various ETL processes.
• Configured and managed SQL Server Analysis Services and migrated /deployed cubes across various environments.
• Maintained 60 plus database instances in dev, test, stage and prod.
• Upgraded SQL Server 2000 and 2005 databases to higher versions 2008R2 and 2012.
• Performed SQL Server database consolidations, migrations, upgrades and downgrades.
• Configured and Managed Standby databases using Log Shipping.
• Installed, configured and maintained SQL Server Clusters.
• Actively involved in capacity planning.
• Co-ordinated with Oracle team on various administrative and development activities.
• Apply security updates/patches on Oracle Databases.
• Actively involved in the upgrade of oracle databases from 9i to 10g.

Environment: SQL Server ( 2000/20 R2/2012, SSIS, Reporting Services, Replication, MS Access, OSQL, Windows NT/2000/XP/2003/2008, Oracle (9i/10g/11g), AIX, Linux, Embarcadero DB Artisan & Performance Center

Confidential, Albany,NY

SQL Server Developer

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Created Complex Stored Procedures, tables, Views depending upon the project requirement.
• Created the deployment scripts after the development is done for every project.
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Experience in Troubleshooting the SSIS/SQL job Agent whenever necessary.
• CreatedSSISpackages to clean and load data to data warehouse.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Imported the various files provide by the clients into the relational database systems.
• Used the BCP to load the large volumes of data from files into tables.
• Worked with Business Analysts and Users to understand the requirement.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Responsible for creating internal reports based on the project requirements and deployed the generated reports directly on the client’s workstation.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Generated Reports using Global Variables, report expressions and Functions. Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL Server reporting services 2008.
• Defined Schemas, i.e. relationships between Measure groups and Dimensions in SSAS.
• Used Visual Source Safe as Version Control Tool.

Environment: SQL Server 2008/05, SQL Server Business Intelligence Development Studio 2008, DTS, SSRS, T-SQL, Performance Point Server, T-SQL, Visual Source Safe, SQL prompt.

Confidential

SQL Server Database Administrator

Responsibilities:

• Providing 24x7 supports to Production, QA and Development servers.
• Involved in installations, upgrades, patches and fixes.
• Worked with Terabytes of Data with over 500 databases.
• Successfully migrated the data from SQL Server 2000 to SQL Server 2005/2008.
• Worked on data compression features of SQL 2008 R2.
• Monitoring and Troubleshooting jobs, Backups and Restore database policies.
• Worked on high availability SQL solutions, including Log shipping, Replication and SQL Server clustering.
• Enabled Transparent Data Encryption on critical databases.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Configured SSRS using configuration manager, created and maintained security roles and created new reports.
• Deployed SSAS cubes to the server and created security roles.
• Created and scheduled maintenance plans (database and log backups and cleanups).
• Used server scoped DMV’s and database scoped DMV’s to trouble shoot issues.
• Identified and analyzed deadlocks in databases using SQL Server Profiler.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS).
• Upgraded DTS packages to SQL Server 2005 Integration Services (SSIS) packages.
• Involved in full life cycle of the project from Requirement analysis, Design, Development and Testing.
• Analyzed the requirements and significantly contributed in developing database architecture for the application.
• Responsible for creating the Entity-Relationship diagrams, Class diagrams, Sequence diagrams and Flow diagrams using Visio 2002 and documenting the project architecture.
• Performed Database consistency checks with DBCC, Index tuning and monitored SQL Server error logs.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.
• Designing Logical and Physical Data Model with Erwin tools.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005.
• Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Environment: SQL Server 2000/2005/2008 , MS Access, Windows NT/2000/2003 Advanced Server, T-SQL, SSIS, SSRS.

Confidential

Programmer Analyst

Responsibilities:

• Created Databases, Tables, Indexes, Views and Coded Stored Procedures, functions, triggers and Used SQL Profiler and performance monitors to enhance the performance of database servers.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
• DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in Data modeling to develop the database design using Erwin.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Designed the logical and physical databases and development of SQL Server Database and Database testing, maintaining the data and writing the procedure.

Environment: SQL Server 2000, T-SQL, SQL Query Analyzer, DTS, Windows NT, MS Access, MS Excel Microsoft SQL Server 2000, Windows 2003 enterprise server, SQL Profiler, Idera SQL Diagnostic Manager, Performance Monitor.