SUMMARY

• 8+ years of experience in Database programming, Design, Development & Support of MS SQL Server2005, 2008, 2008 R2, 2012 and 2014.
• Experience in MS - SQL Server Development and Administration including Design and implementation of Distributed/ Replicated Databases, planning/ implementing backup/ recovery strategies, and Performance tuning.
• Experience in Creating Dynamic-Queries, stored procedures, functions (UDF), sub queries, triggers and SDLC.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Excellent backend skills in creating T-SQL objects like Tables, Views, Indexes, Triggers, Temporary tables, user defined data types, CTE and functions.
• Experience in using tools like index Tuning Wizard, SQL Profiler, Execution Plan and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Worked on various infrastructures like Azure, AWS servers
• Created Custom Reports for SQL SERVER 2008/R2 for ad-hoc queries for individual databases and also various database performance counters.
• Created and Designed a Multi-Dimensional Analysis (Configured OLAP Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views and Star and Snow Flake schema) using SQL Server 2008 and 2012 Analysis Services (SSAS).
• Hands on experience in SQL Server Analysis Services (SSAS) development and also in designing, processing and partitioning cubes, Aggregations, KPI’s, Measures, Calculations, Actions, Translations and Perspectives.
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Experience in installation and configuration of SQL Server 2008/2008 r2, 2012, 2014.
• Very good experience in Creating SSRS REPORTS.
• Expert in creating Business Intelligence reports, defining queries for generating drill down reports, parameterized reports and in designing report layout using SQL Server Reporting Services (SSRS) 2005/2008/R2,2012,2014
• Excellent experience in developing stylish Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
• Hands on experience on SSRS Configuration and generating reports.
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Created SSIS packages to import the data from one server to SQL server management studio/ required server and also performed few transformations on the data imported.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Did debugging using break points and data viewers and performance tuning of ETL data flows.
• Experience in extracting and transforming (ETL process) data using SSIS Import Export Data from various sources, Bulk Insert, BCP and SSIS Packages.
• Experience in using TFS for version control and configuration management.
• Close contact with customers, to gather their requirements and design as per their request.

TECHNICAL EXPERTISE:

Relational Database: SQL Server 2008, 2008R2, 2012, 2014, 2016, MS Access 2007

Operating System: Windows 2008 Advanced server, Windows 2008 Server suite

Windows: NT 4.0, Windows XP.

Languages: PL/SQL, Oracle, SSIS, SSRS, SSAS

SQL Server Tools: SQL Server Management Studio, SQL Profiler, SQL Server Agent

Database: Tuning Advisor, Query Analyzer, SSIS and SSRS, SSAS

Other Tools: MS Excel, MS Word, Power Point, Outlook, SharePoint, .NET

Version Control Tools: Microsoft team foundation server (TFS).

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr.SQL Server Developer (MSBI)

Responsibilities:

• Involved in data migration from various platform to SQL Server.
• Designed and developed Data Base, created tables and maintained relationship among those tables.
• Involved in writing SQL queries, triggers, stored procedures, CTE, sub-queries, temptables, table variables, Joins, functions, views as per requirement and maintaining its database.
• Created and maintained Roles and Database users.
• Created Alerts to report successful or unsuccessful completion of Jobs.
• Scheduling Backups whenever it is necessary and restoring it as per requirement.
• Allotting the permissions for the roles / Users (Grant, Revoke) to secure the Database.
• Involved in installations of Visual studio, SQL Server, SharePoint etc.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created SSIS packages to import data from various sources like Excel, CSV, Flat file, OLEDB etc to required server.
• Deploying and scheduling of SSIS Packages.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, SQL task, Script task and Send Mail task etc.
• Scheduled the jobs to send the Excel/Flat files to remote location using FTP tasks.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Designed and deployed various reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions and Functions, Sorting the data and Subtotals for the reports using SSRS 2008R2/2012/2013.
• Developed complex reports using multiple data providers, user defined objects, charts, aggregate aware objects and synchronized queries.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Performed table partitioning to increase the performance.
• Managed index, statistics and optimizing queries by using execution plan.
• Responsible for Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Worked closely with business users in defining and documenting reporting requirements in order to design, develop and maintain SQL Server 2016, 2014 and 2012 reporting services.
• Established Connection Strings between the Database and the Front End Application like OLEDB/ ODBC Connections.
• Worked in Agile methodology.
• Research and recommend new technologies and solutions

Technologies Used: SQL Server 2012 /2014, SSIS, SSRS, visual studio 2012/2013, SharePoint

Confidential

Responsibilities:

• Expertise in Transact-SQL (DDL, DML, DCL) & in Design and Normalization of the database tables.
• Responsible for maintaining the MS SQL Environment’s Infrastructure, working with the infrastructure team to coordinate the support of (Hardware-Physical & Virtual, Storage, Software Versions & Licensing).
• Responsible for maintaining the MS SQL Environment’s Architecture (Database Design Plan, Job Maintenance Plan, Archival Plan, Auditing & Security Policy Plan and Disaster Recovery/High Availability Plan).
• Responsible to maintain and troubleshoot existing processes with thorough understanding of the processes and interrelationship with other programs and processes.
• Scheduling Backups whenever it is necessary and restoring it during the System failure.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Setting up the Application on to the Azure Server.
• Shrinking the log files or redirecting the default path or removing unnecessary transaction to empty up the space in order to prevent Execution failure.
• Created Indexes (Clustered & non-Clustered) for improvising the performance and also used SQL Profiler and Execution plan for performance Tuning.
• Closely worked with the Recruitment team in order to gather the requirements and also to get the feedback on the Application for Future Enhancements.
• Worked in Agile and Waterfall Methodology including Sprint and Scrum.
• Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.
• Did debugging using break points and data viewers and performance tuning of ETL data flows.
• Scheduled the jobs to send the Excel/Flat files to remote location using FTP tasks.
• Developed and deployed the SSRS Reports in the Report Server and used sub-scriptions and scheduled the jobs on daily basis.
• Created SSRS reports by gathering requirements and deployed them in report server.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Technologies Used: SQL Server 2012 / 2014, SSIS, SSRS, visual studio 2012/2013, SharePoint, Excel

Confidential, Spartanburg, SC

MS SQL Server Developer (MSBI)

Responsibilities:

• Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS 2008 packages.
• Configured OLAP Cubes (Star and Snow Flex Schema) using SQL Server 2008 R2, 2012, 2014, 2016 Analysis Services and Performance tuning MDX and dimensions design and scaling to large numbers of users.
• Responsible for performing T-SQL tuning, multi tasking and optimizing queries for reports which take longer time in execution with SQL Server 2016/2014/2012/2008r2/2008/2005.
• Document the entire requirement and issues encountered during the development process at the end of all data requests.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area using SSIS.
• Scheduled the jobs to send the Excel/Flat files to remote location using FTP tasks.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
• Data migration from Oracle / MySQL to SQL Server database using SSIS packages.
• Created T-SQL queries, created dynamic stored procedures that calculates the loan sanctioning details taking the customer details as input and also created report models for ad-hoc reports when the end users want to see the reports on fly.
• Gather the client’s requirement and break down the requirement into different data requests & prioritizing those requests.
• Involved in writing SQL queries, triggers, stored procedures, sub-queries, CTE, temp tables, table variables, Joins, functions, views as per requirement and maintaining their database.
• Used to do Log Shipping for Disaster Recovery.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collecting statistics.
• Generated complex SQL queries, designed beautiful dashboards, and presented insights to executive level stakeholders.
• Responsible for ongoing maintenance, change management and report performance optimization on existing report.

Technologies Used: SQL Server 2008R2, 2012, 2014, 2016, AWS Server, Excel

Confidential, BOSTON

MS SQL Server Developer (SQL/TSQL/SSAS/SSIS/SSRS)

Responsibilities:

• Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS 2008 packages.
• Configured OLAP Cubes (Star and Snow flex Schema) using SQL Server 2008 R2, 2012 Analysis Services and Performance tuning MDX and dimensions design and scaling to large numbers of users.
• Designed, processed and partitioned cubes using SSAS. Good experience in designing aggregations and Calculations. Experience in deploying SSAS objects using deployment wizard.
• Configured and created SSIS solutions for ETL and business intelligence process for data integration and migration service.
• Created SSIS packages to transform raw data into information stored in tables and also created SSIS packages to automatically update tables with monthly data using scheduled jobs.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Scheduled the jobs to send the Excel/Flat files to remote location using FTP tasks.
• Involved in writing SQL queries, stored procedures, CTE, sub-queries, temptables, table variables as per requirement and maintaining their database.
• Work closely with the business people to gather the client’s requirements.
• Migrate from Oracle, Mysql databases to MSSQL Server.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Developed and deployed the SSRS Reports in the Report Server and used sub-scriptions and scheduled the jobs on daily basis.
• Used various report items like tables, sub reports and charts to develop standard and customized reports in SSRS to help tracking performance and productivity

Technologies Used: SQL Server 2008R2, 2012, 2014, SSAS, SSIS, SSRS, AWS Server, Excel, CSV, Text, Log

Confidential, St. Louis, MISSOURI

SQL Server Developer (SQL/TSQL/SSIS/SSRS)

Responsibilities:

• Modified existing conceptual data model, logical data model and physical data model.
• Actively involved in designing Dimensional modeling using SSAS.
• Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS 2008 packages.
• Import data from one database to another database using SSIS
• Created SSIS packages to import data from accessed server to required server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Oracle Database to SQL Server.
• Responsible for data profiling, source-target mappings, SSIS/SQL tunings and optimization.
• Ability to work independently and proactively, and provided support and mentoring to data analysts
• Developed and deployed the SSRS Reports in the Report Server and used sub-scriptions and scheduled the jobs on daily basis.
• Created Tabular Reports, Matrix Reports, Charts etc based on Client Requirement.
• Designed and developed Data Transformation Process and used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient manner.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Involved in writing SQL queries, triggers, stored procedures, sub-queries, temp tables, table variables, joins, Functions, dynamic queries, CTE’s as per requirement and maintaining their database.
• Worked on SQL Profilers and Execution plan tools to optimize the performance.
• Used TFS as version control and worked in agile methodology.

Technologies Used: SQL Server 2008R2, 2012, 2014, SSIS,SSRS,SSAS, visual studio 2008 r2, C#.Net, ASP.Net 3.5

Confidential

SQL Server Developer (SQL/T-SQL/SSRS)

Responsibilities:

• Designing of database & related tables and maintain the relationship among them.
• Designed and developed Data Transformation Process and used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient manner.
• Used to install the required software’s for development of the application.
• Performed various activities like shrinking the database, taking backup on schedule basis and restoring it when it is necessary.
• Created multiple users instances and granted permissions as informed by manager.
• Involved in writing SQL queries, triggers, stored procedures, sub-queries, temptables, table variables, Joins, functions, views as per requirement and maintaining its database. And also involved in creating indexes to optimize the performance.
• Followed various procedures to optimize the performance of the query.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Developed and deployed the SSRS Reports in the Report Server and used sub-scriptions and scheduled the jobs on daily basis.
• Created Alerts to report successful or unsuccessful completion of Jobs.
• Generated reports based on analyzing business requirements.
• Involved in database architecture based on higher business design documents.
• Followed agile methodology and its user stories during the development of the application.
• Worked on SQL Profilers and Execution plan tools to optimize the performance.
• Developed database health check scripts and database maintenance scripts for automating administration tasks
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Designed and deployed various reports using SSRS.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize the performance of the queries and stored procedures.
• Worked closely with business users in defining and documenting reporting requirements in order to design, develop and maintain SQL Server 2000, 2008 R2 reporting services.
• 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
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Performed data modeling, backups andrecovery.
• Designed DTSX Packages to transfer data between servers, load data into database, archive data file from different databases using SQL Enterprise Manager on SQL Server 2005 environment, and deploy the data, scheduled the jobs to do these tasks periodically.

Environment: SQL Server 2008 and 2008R2, T-SQL, Windows 2003, C# .Net, ADO .Net, SSRS, Team Foundation Server