PROFESSIONAL SUMMARY:

• Over 7 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, QA, UAT and Production Environment).
• Strong technical Experience in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Expertise in Stored Procedures, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Experience in Dimensional Modelling, ER Modelling, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Expertise in T-SQL, SSRS, SSAS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Expertise in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Expertise Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2012/2014).
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes.
• Expert on Tableau Desktop, Tableau Reader and Tableau Server.
• Blended data from different data sources (Flat File, MS Excel, MS Access, SQL Server, Oracle, TeraData and many more.)
• Expertise in SQL Server 2008/2008R 2/2012/2014/2016 RDBMS database development including T-SQL programming.
• Expertise in SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Experience in ETL implementation using SQL Server Integration Services (SSIS).
• Experience in designing and building Data Warehouse and Data Mart pulling data from different Business sources. The Data Mart was used for different Dashboard usage.
• Expertise in developing reports on SSAS & SSRS on SQL Server (2012/2014).
• Sound Experience of SSAS, OLAP cube and Architecture.
• Worked with different version controls such as TFS and worked in an agile environment.
• Built 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.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin
• Worked with different version controls such as TFS and worked in an agile environment.
• Confident in work independently and proactively. Strong leadership, good communication and excellent interpersonal skills, problem-solving and multi-tasking abilities. Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

TECHNICAL SKILLS:

Databases: MS SQL server 2008/2008R 2/2012/2014/2016, Teradata, MS Access

Transact: SQL, SQL,HTML,C#

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica. MDM,MDS

OLAP/Reporting Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), Tableau, workday report writer, Performance Point

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler.

Data Modeling Tools: Erwin tool, Microsoft Visio 2000/2003

Operating Systems: Windows NT/98/2000/XP/Vista/2003, MS-DOS

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio, MS Excel, Workday, TFS SharePoint

PROFESSIONAL EXPERIENCE:

Confidential - Spring Valley, NY

Sr. SQL Server/SSRS Developer

Responsibilities:

• Created entity relationship (ER) diagram for proposed database to display the various relationships between entities
• Used T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• 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
• Analyzed Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, and Operational Data Stores.
• 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
• Worked with SSDT to create SSIS packages, write C3 and VB scripts, and created data mappings using different SSIS transformations such as Conditional Split, Lookup, Merge, Multicast, Slowly changing Dimension, OLE DB Command, Derived Column
• Worked with different package configuration types such as Project Package configuration, XML configuration.
• Created error handling on packages by redirecting errors, error Log shipping and saving error log in RDBMS
• Created Models (Tabular / Multidimensional) and writing DAX or MDX to create calculated measures and members in the cube.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created SSRS reports both from relational data warehouse using T-SQL and for OLAP cube both Multidimensional model and Tabular model using MDX and DAX.
• Implemented the COPY command successfully to insert huge amounts of data into the target system from ODS.
• Loaded data from ODS to Data Warehouse using SSIS packages.
• Performed 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
• Created object documentations to serve as data dictionary to enable other developers to understand project development life cycle
• Created control field to handle package metadata
• Identified and wrote best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• 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).
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
• Worked towards monthly report release and Report release BI tickets

Tools and Technologies: MS SQL Server 2016, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, C# scripting, Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server, Workday.

Confidential - New York City, NY

Sr. SQL Server/SSRS Developer

Responsibilities:

• Developed and created enterprise Data Warehouse from scratch using DTS and creating a Multidimensional Model for data analysis
• Worked with Data warehousing concepts - Star Schema, Snow Flake schema and Data Modeling.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for the application.
• Created Power Pivot report and SSRS report to help check for discrepancies between data sources and data warehouse.
• Worked in a .Net environment using Internet Information Services (IIS) and participated in migration of the server and database.
• Created SSIS Packages to Extract, transform and load data from various sources in the Company into the Enterprise Data Warehouse created Such as: (Workday, PTO, Net steps, Salesforce Dynamics and so on).
• Created Master packages to house the child packages and set up Sql job to call the Master package.
• Worked with SSIS Integration catalog in creating custom reports to check status of executed packages.
• Designed the dimensional modelling of star schema for the enterprise data ware house of ODS
• Created and worked with different development environments such as UAT, Prod and Dev.
• Used C# and VB Scripts in ETL Packages wherever necessary.
• Participated in requirement gathering and backlog grooming for task to be assigned
• Created and monitored SQL Agent job to run and refresh data at the scheduled times.
• Implemented Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created reports using workday application (Workday report writer)
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS. Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on bus
• Created Data Warehouse dictionary using tools from RedGate and Xquery to create Data dictionary for the Integration packages.

Tools and Technologies: MS SQL Server 2014/2016, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010/2013 (MS Visual Studio.NET# 2008, MS Visual Studio.NET# 2010, Team Foundation Server (TFS 2012), Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server, Workday.

Confidential - New York City,NY

SQL Server/SSRS Developer

Responsibilities:

• Wrote stored procedures, Triggers, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules. Experience in creating joins for complex queries involving multiple tables.
• Implemented the Exception handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Implemented query optimization and tuning stored procedures for better performance.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2012.
• Created ad-hoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Migrated of SSRS 2012 to SSRS 2014
• Created stylish Report Layouts and Deployed the Reports using SSRS 2005.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Configured and deployed SSRS reports onto Microsoft Office SharePoint Server.
• Worked on daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Created and modified OLAP cubes both Tabular and Multidimensional cubes for the analysis of sales in specific areas using SSAS.

Tools and Technologies: MS SQL Server 2012/2014, Enterprise Edition, SQL Server Reporting Service (SSRS), T-SQL, Erwin 7.1, Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS).

Confidential - Hamilton Square, NJ

SQL Server 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.
• 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.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports, Drill Through as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services(SSRS).
• 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.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.
• Reversed engineer backend database to change the T-SQL scripts, create Views, Index, Stored Procedures, Triggers, CTE, Constraints and UDF to improve performance drastically.

Tools and Technologies: MS SQL Server 2012/2008R2, SQL Server Integration Services, SQL Server Reporting Services 2008, Erwin 7.2, SQL Server Profiler, C#, VB.NET, Windows 2007.

Confidential - Jersey City, NJ

JR.SQL Server

Responsibilities:

• Created database objects like Table, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Used SQL Server profiler for auditing and analyzing the events, which occurred during a particular time horizon and stored in script.
• Used Master Data Services in managing Master Data, creating objects, maintaining the master Data web services and importing and exporting master data
• Created daily tasks including backup and restore by using MS SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server.
• Documented all work, so user can easily understand the flow of process.

Tools and Technologies: MS SQL Server 2008/2008R2, VSS, Microsoft Visual Studio, SQL, MS Excel, T-SQL, Erwin7.2, SQL Server Profiler, Database Engine Tuning Advisor.