PROFESSIONAL SUMMARY:

• Over 7+years’ experience in Database design, development and administration using MS SQL Server 2016/2014/2012 and 2008 in Production, Test and Development environment.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Strong working experience in SQL Server and T - SQL in constructing triggers, tables, Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non Clustered indexes on tables.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, DTS Packages, Bulk Insert and BCP, SSIS).
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Expert in maintaining existing SSIS packages and build new packages from scratch using SSIS for all types of applications.
• Expertise in Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS relational and multidimensional data.
• Expert in generating Drilldown reports, Parameterized reports, Linked reports, Sub reports and charts in SSRS 2012/2014/2016 .
• Experience in Troubleshooting of Report Processing, Subscription Delivery and Configuration Problems.
• Experience in writing Expressions in SSRS and Expert in fine tuning the reports.
• Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
• Familiarity with Star and Snowflake schema data modelling techniques for OLAP database design.
• Delivered BI reporting solutions in Power BI, Reporting services (SSRS), Tableau and MicroStrategy.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and calculations created SSAS storage partitions and aggregations.
• Knowledge in SQL Server Clustering, Replication, Data Mirroring, Snap Shot, Linked Servers and Log Shipping.
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Security, User management and Performance Tuning.
• Identifying & resolving blocking and deadlocks.
• Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
• Expertise in creating and maintaining jobs in various job scheduling systems includes SQL Server Agent job, Active Batch Scheduler.
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role and 24x7 on call Production support.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

Databases: SQL Server 2012/2014/2016 , Oracle

Operating Systems: Windows 10/7, Windows Server 2012, Windows XP

Languages: SQL, PL/SQL, C/C++, HTML, DHTML, XML, VBScript, Share point 2013/2016

ETL Tools: DTS, C#, Visual Basic, ASP.net

Reporting Tools: SQL Server Integration Services (SSIS), BCP

Tools: SQL server Reporting Services (SSRS), Tableau, Power BI Desktop, EPM.

SQL Server: Enterprise Manager, Active Batch Scheduler, TFS, HPQC Agile/Scrum, Jira Project Management, Visio, Red Gate, SQL Server ProfilerSharePoint 2013/2016 Visual Source Safe

Protocol: FTP, TCP/IP, Named Pipes

WORK EXPERIENCE:

Confidential, Carlisle, PA

Sr. SQL Server Developer/SSIS/SSRS

Responsibilities:

• Actively involved in gathering and analyzing the user requirements in coordination with Business.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Performance tuning, and optimization of procedures and queries.
• Automation of creating stored procedure module with using Cursors.
• Creating dashboards for different departments based on their Unique Requirement.
• Bulk data migration using SSIS from flat files.
• Analyzed data by using SSAS and building a series of MDX statements to query your SSAS cube and produce Pivot tables.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS).
• Built reports from Cube using MDX scripting.
• Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Extensively worked in analyzing Stored Procedures on Legacy Environment, produce documentation and re-create them on new environment.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2 and Flat files.
• Proficient in create and manage Database(s) on SQL Azure.
• Provided continue maintenance and development of the bug fixes for theexisting and new Power BI reports.
• Experienced in Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
• Proficient in Subscribe SQL Azure Cloud services.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional, Split, Derived columns etc.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Involved in dimensional modeling (Star &Snowflake) and creating the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.
• Maintains Data warehouse loads and Reports based on SSAS Cube and Enterprise Data Warehouse.
• While developing reports from Cubes also used the KPI's for decision making, also implemented Cube Partitions and also debugged data connections, data sources and Data Source Views.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.

Environment: SQL Server 2014/2016,MS Access, Query/Report Studio, Power shell, ORACLE, EXCEL, HTML, XML, Windows 07, ASP.NET, C#, VB.NET, Visual Studio2008/2010, BIDS, Team Foundation Server, EPM, Power BI, Import Export Wizard.

Confidential, Conshohocken, PA

Sr. SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Extensively used SSIS to move data from text files to SQL Server.
• Views using T-SQL in Development and Production environment for SQL Server 2008.
• Created Quality Assurance stats reports using SSRS.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Published Reports in SharePoint.
• Managed subscriptions through SharePoint.
• Created SSIS packages for new projects utilizing Business Intelligence Development.
• Writing complex Stored Procedures to meet the business requirements.
• Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created data sources, connection strings and defined the datasets for generating the report.
• Worked on all types of report types like tables, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports
• Developed, monitored and deployed SSIS packages.
• Implemented Change Data Capture (CDC) on dynamic tables to capture DDL changes.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job Scheduler
• Created subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time

Environment: MS SQL Server 2012/2014, Excel, TSQL, Microsoft Visual Studio 2008,SQL Reporting Services, SQL integration services, SharePoint, Import Export Wizard.

Confidential, Oak Brook, IL

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Owns and drive the technical design, development, and on-going support of Enterprise Data Warehouse and associated ETL processes.
• Analyzes, tune and optimize ETL packages, Stored Procedures & SQL scripts to ensure peak performance.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Support the ongoing data quality and data integrity initiatives through the creation and expansion of audit, balance, and control procedures, alerts and reports.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Monitored and modified Performance using execution plans and index tuning.
• Used various SSIS tasks such as Conditional Split, Derived Column which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.
• Created stored procedures using Common Table Expression (CTE) and various types of UDF functions.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Created Complex SSIS packages for XML, CSV and Excel file generation from SQL Server Database.
• Worked on all types of reports like tables, matrix, charts, sub reports etc.
• Report Manager set up, Deployment of RDL files and Standard Subscriptions set up.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created Save scripts for DML operations of Application.
• Subscribed SQL Server Azure Cloud Services.
• Created Database(s) on SQL AZURE.
• Worked on Setting up SQL Azure Firewall.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
• Worked on Incremental loading with Merge statement in Stored Procedures.
• Scheduled SSIS packages with SQL Agent Job.
• Created Data-driven subscriptions in SSRS to accommodate customized file names as per Client request.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Published different kinds of reports in SharePoint and Subscribed.
• Used Team Foundation Server to maintain different versions of code effectively.
• Involved in Post-Production testing of each deployment.
• Serving as the team’s Application DBA as required to support database deployments and performance tuning.

Environment: MS SQL Server 2014/2016, Windows 7, Excel, TSQL, Microsoft Visual Studio 2013, Team Foundation Server 2012,XML,Tableau, Power BI Desktop, Share Point 2013, Master Data Management (MDM), Import Export Wizard.

Confidential

SQL Server Developer

Responsibilities:

• Created new database objects like, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• 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.
• Created SQL queries for data verification and analysis.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Wrote various Transact SQL utilities to add functionality to E-enterprise system.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, and Indexes.

Environment: SQL Server 2008, Windows 2003 Server, C++, T-SQL, DTS, BCP.

Confidential

SQL Server Developer

Responsibilities:

• Participated in requirement gathering, data warehouse design, application design, and SSIS development, training operational staffs and mentoring junior staffs.
• Created SSIS packages for new projects utilizing Business Intelligence Development Studio.
• Designed data flow diagrams for new projects.
• Involved in Designing of ODS, Star Schema and Staging area.
• Created user interface application to insert file folder path information to SQL tables.
• Created execute SQL task to retrieve the folder path from the SQL table to bulk load text files to the warehouse and assigned that folder path info to package level variable.
• Created For each loop to iterate through a number of suppliers having multiple text files to be loaded to the warehouse.
• Created File enumerator to iterate through a number of files per supplier and assign that file path to package level variable, which is used by the Flat file source.
• Created a script component to read the title of the columns from the text file, to read SQL table to find the appropriate mapping columns and to map columns dynamically.
• Created mapping document and database diagrams Load access tables to SQL to create look up tables.
• Load text file to staging area, edit columns based on the business logics, created unique identifiers.
• Generated stats reports based on the data in staging area to analyze the quality of the data.
• Created SSIS package to uploaded data to the warehouse, once the data is verified.
• Generated stats based on the uploaded data and existing data to check the data accuracy and export them to excel for distribution.
• Created ActiveX tasks to create file, edit text source file, to change DTS task properties dynamically and to edit and map column dynamically.
• Reviewed existing project document, suggested correction and updates.
• Created several stored procedures and views for Reporting.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed reports using SSRS and published as PDF formats.

Environment: SQL Server 2008/2012, Windows server 2003, VBScript, VB.Net, ASP.Net, HTML, SSIS, SSRS, XML, Erwin.