PROFESSIONAL SUMMARY:

• Over 7 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2014/2012 in Production, QA and Development Environments.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server.
• SQL Server 2012/2014 RDBMS database development including T - SQL programming.
• Strong technical knowledge in MS SQL Server development including SSRS, Microsoft Analysis Services, Performance tuning, Reporting, designing logical/physical databases and Troubleshooting.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), SSRS and SQL Server Integration Services (SSIS) (2012/2014).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Sound Experience and understanding of SSAS .
• Build MDX query for SSRS reports and SharePoint Performance Point reports and Dashboards.
• Experience working and creating ad-hoc reports, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Work with different version controls such as TFS and worked in an agile environment.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Written PowerShell scripts that are customized to execute SQL scripts in different servers.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations in informatic
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Worked with Business Analysts, Web development team, and users on database solutions.
• Expertise in using data modeling tools like MS Vision and Erwin Tool for logical and physical design of databases.

TECHNICAL SKILLS:

Database:: MS SQL Server 2012, MS SQL Reporting Services 2012, MS SQL Server Analysis Services 2012, MS SQL Server Integration Services 2012.Tools: Power designer Visual Studio 2005, T-SQL, MS Access, MS-Office, MS Excel, Tableau, SQL Developer, Microsoft Visio, PowerShell.

Operating Systems: Windows Variants, Linux/Unix

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

MS SQL Server /Tableau developer

Responsibilities:

• Created entity relationship (ER) diagram for proposed database to display the various relationships between entities
• Designed and developed dynamic SSIS package to perform extract, transform and load (ETL) data across different platforms, validate the data and achieve the data files into the database
• Extensively worked with SSDT to create SSIS packages and created data mappings using different SSIS transformations such as Conditional Split, Lookup, Merge, Multicast, slowly changing Dimension, OLE DB Command, Derived Column
• Experience working with different package configuration types such as Project Package configuration, XML configuration etc.
• Used MDX script for querying the data.
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services.
• Created stylish Report Layouts and Deployed the Reports using SSRS.
• Created error handling on packages by redirecting errors, error Log shipping and saving error log in RDBMS.
• Created database objects such as tables, Views, Stored procedures, functions, triggers etc. during the development of the database and to serve customized functionality as needed.
• Developed codes with better performance by testing and ensuring code run at optimal while keeping in mind blocking and deadlocking situation and creating codes to avoid such scenario
• Perform Unit testing of codes and packages with self-generated sample data following guidelines specified.
• Created SQL jobs to process packages and load data at specified times and specify certain action upon failure or success of the job.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines.
• Published Workbooks by creating user filters so that only appropriate teams can view it
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS.

Environment: Windows OS, MS SQL Server 2014, MS SQL Server Reporting Services, MS SQL Integration Services, SSAS.

Confidential, Hoboken,NJ

SSAS/BI Developer

Responsibilities:

• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more.
• Performed ETL mappings using MS SQL Server Integration Services (SSIS).
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created jobs on daily basis and schedule job to update recent data by using SQL Server Agent jobs.
• Scheduled execution and delivery of end of the day report using SSRS.
• Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.
• Written PowerShell scripts that are customized for a dataset - such as a morning health check, which outputs different base information on reporting every morning.
• Reversed engineer backend database to change the T-SQL scripts, create Views, Index, Stored Procedures, Triggers, CTE, Constraints and UDF to improve performance drastically.
• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked with development teams in the design of physical databases and in modification.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and SSRS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed SSRS packages to copy tables, schemas and views and to extract data from Excel using SSIS.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2012 Reports Services (SSRS).
• Involved in project status report updates/ creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: Windows OS, MS SQL Server 2012, MS SQL Server Reporting Services 2012, MS SQL Integration Services 2012, SSAS, PowerShell, T-SQL, ERWIN.

Confidential, Denver,CO

SQL server Developer

Responsibilities:

• Migrated heterogeneous databases to MS SQL Server 2008R2.
• Developed logical and physical data model using MS Visio and mapped the data into database objects.
• Migrated some databases from Oracle 11g to SQL server 2008R2
• Designed and created different ETL packages using SSIS from My SQL Source to SQL server 2008R2
• Managing SQL server using PowerShell scripts.
• Created SSIS Packages to export and import data from Text files, CSV files, Microsoft Access and Excel Spreadsheets
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Designed and implemented SSIS packages for data integration
• Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them
• Extensively worked on Cross Tabbed and Matrix reports using SSRS
• Designed and implemented indexing to optimize transactional and reporting performance.
• Designed drilldown, drill through, and parameterized report using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Designed, reviewed, and created primary objects such as views, indexes, views and store procedures.
• Worked with User Defined Functions, triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least update to improve the query performance.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files
• Defined referential relationships with the measure groups and fact tables.
• Documented the development work and production release for future reference.

Environment: Windows OS, MS SQL Server 2012, MS SQL Server Reporting Services 2012, MS SQL Integration Services, Oracle 10g, Toad, T-SQL, ERWIN, Microsoft Visio, SQL profiler.

Confidential

SQL Server/SSIS/SSRS developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Hands-on experience of setting up schedules for push and pull delivery methods using Standard and Data Driven subscriptions in SSRS

Environment: Microsoft SQL Server 2008 Enterprise Edition, MS Access, ETL Packages (SSRS, SSIS), HTML, Visual Studio 2008, SSRS, T-SQL, TFS.

Confidential

SQL Server Developer

Responsibilities:

• Analysis, Design and data modeling of Logical and Physical database using E-R diagrams.
• Involved in database Schema design and development.
• Designed tables, constraints, necessary stored procedures, functions, triggers and packages using PL/SQL.
• Audited the Front-end application calls to SQL Server.
• Created efficient Queries, Indexes, Views and Functions.
• Enforced Security requirements using triggers to prevent unauthorized access to the database.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Optimized the Database for best performance, with DBCC, partition table.
• Design and develop the payroll module using MS SQL Server 2008.
• Migrated data from MS Access to SQL Server.
• Performance Tuning of the client databases for better performance on a regular basis.
• Responsibilities include writing of scripts for Database tasks, releasing Database objects into production.
• Running DBCC consistency checks, fixing data corruption on application Databases.

Environment: MS SQL Server 2008, MS VB Access, Windows 2003 Standard Edition, Windows