SUMMARY:

• Over 8 years of Professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2014/2012/2008 R2/2005/2000 in Banking, Finance, Insurance, and Health Care Domains.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Strong Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
• Excellent in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
• Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
• Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Thorough understanding of Kimball/Inman strategies, KPI, Data mining structures.
• Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports .
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• In depth understanding of SQL Server Migrations and problem management
• Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Responsible to maintain the efficiency of all the software and applications that run on UNIX system
• Intensively working for graphic design Database backend programming in C# for dynamically generating components in front Database. Working knowledge with HTML.
• Having excellent communication skills, analytical skills, understanding of business requirements in various domains.

TECHNICAL SKILLS:

Programming Skills: T-SQL, C, HTML, CSS,, ASP.NET, VB, C#

RDBMS: MS SQL Server 2016/ 2014/2 /2000 , MS Access, Teradata.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables. SQL Query Analyzer, ETL, SQL Enterprise Manager, Solution Explorer, Analysis Manager, Reporting Server.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2010/2013 Crystal Reports, DAX

Operating Systems: UNIX, LINUX, Windows7 Vista/XP/2003/2000, NT & Windows 9x and MS-DOS

Systems familiarity: OLTP,DSS,OLAP,MDX

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Greenwood Village, CO

Sr. ETL MSBI developer

Responsibilities:

• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Design and tune ETL process. Working closely with the Guide ware team on business aspects.
• Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Configured files to deploy the SSIS packages across all environments.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS. Configured and maintained Report Manager and Report Server for SSRS.
• Creating ad hoc queries according to business need and tuning existing queries to meet business standards.

Project Environment: MS SQL Server 2008/2012, Red Gate tools, PowerPivot, TFS 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio

Confidential, Englewood, NJ

Sr. SQL Server/BI developer

Responsibilities:

• Analyzed the Reports, Tables and ETL process, Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Created packages using SSIS Designer for exporting heterogeneous data from OLE DB Source.
• Configured Server for sending automatic mails to the respective people when a SSIS package fails.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript.
• Wrote complex TSQL queries to get data from different sources and test results with expected results.
• Extensively worked on Data Flow transformations like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Created drill down, drill through, sub reports and many more complex reports.
• Involved in implementation of reporting tool Power BI for advanced and interactive business intelligence reporting.
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Involved in creating report models and applying row level security filters for report model.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Responsible for creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using SQL Server Reporting Services 2012.
• Used SQL Server Agent for scheduling jobs and alerts.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2012.
• Written several SQL Scripts such as finding tables with Identity Columns, tables that do not have primary key in order to streamline the process of replication.

Project Environment: MS SQL Server 2012/2014, MS dynamics 2013/2015, Red Gate tools, PowerPivotTFS 2013, Agile/SCRUM SharePoint 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio.

Confidential - Newark, NJ

Sr. MSBI developer

Responsibilities:

• Created reports using various data visualization like SSRS and Tableau.
• Support in deploying and scheduling the BI solutions.
• Worked in loading data from Microsoft APS server.
• Worked on performance tuning and reduced the time for the daily running jobs.
• Heavily worked and involved in weekly migrations.
• Extensively created and used various Teradata Set Tables, Multi-Set table, global tables, volatile tables, temp tables.
• Expertise in SQL Server and T-SQL (DDL and DML) in constructing Tables, Indexes, Stored procedures, Views, Normalization techniques on database Tables.
• Worked in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions using SQL Server Integration Service (SSIS).
• Demonstrated expertise in utilizing ETL tools Informatica power center 9.x, 8.x for developing the Data warehouse loads as per client requirement Experience in Data Warehouse development working with Data conversion, Data migration and (ETL) Extraction/Transformation/Loading using Informatica Power center with Oracle.
• Developed Workflows to create an efficient way of communication among different Agencies by Auto-Email notifications for key updates on any Dynamics CRM records.
• Worked with Logical and physical models in Erwin.
• Wrote SSAS cube with MDX and DAX.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Wrote complex queries utilizing joins, sub queries, CTE, and set operators involving multiple tables.
• Extract the Data from Cosmos to SQL layer, and Build SSAS Cubes.
• Created perspectives in SSAS and configured security levels for the Cubes.
• Creating Power BI dashboards using Power BI Desktop and Power Query.
• Developed SQL queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2.
• Worked as production support for ongoing jobs and responsible for creating new jobs and maintaining them.
• Coordinate with Onsite and Offshore team and get it approved by client.
• Daily interaction with team in assisting and clarifying their queries.
• Developed complex T-SQL stored procedures using joins and unions to create crystal reports and also optimized SQL queries for efficiency and the front end developer with their queries and procedures.
• Designed and coded Win Forms using C#.NET.
• Wrote complex T-SQL queries to get data from different sources and test results with expected results.
• Deployed packages and ETL stuff like procedures, DDL's etc with Octopus Model Deployment.
• Major and minor enhancements, bug fixes and production support.
• Implemented best practices, query optimization and performance tuning.
• Analysis of the specifications provided by legacy systems.

Project Environment: MS SQL Server 2012/2008, Enterprise Edition, Bamboo, Performance point server, MS SSRS 2012, MS SSIS 2012, T-SQL, VB Script, Windows Server 2007, Erwin 8.0

Confidential

Sr. SQL Server/ETL/SSIS Developer /SSRS Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects. Designed data models using Erwin.
• Created indexes, constraints and rules on database objects for optimization.
• Designed and developed SSIS ETL/SSIS packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Configured files to deploy the SSIS packages across all environments.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, using SSRS. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.
• Used event handlers to send custom e-mail notifications to business users as well as technical teams.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Performed user acceptance testing on new and modified reports.
• Displayed pie charts, bar graphs for analysis by top-level management using Analyzer in the reports.
• Developed database triggers and stored procedures using SQL tables.
• Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent.

Project Environment: MS SQL Server 2008R2, SQL server integration services (SSIS) 2008R2, SQL server reporting services (SSRS) 2008R2, SQL server analysis services (SSAS) 2008R2, VB.Net, C#, SQL profiler, EDI, Pro clarity, TSQL. Erwin tool 7.2, Windows 2007

Confidential

MS SQL Server BI Developer

Responsibilities:

• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Performed a multitude of ETL, data operations to support data loads and transformations with SSIS.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Analyzed business requirements and built logical and physical data models that describe all the data and relationships between the data using Erwin.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI's & MDX Queries using SQL Server 2008R2 Analysis Services.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2.
• Generated multi parameterized reports in MS SSRS 2008R2 allowing users the ability to make selections before executing reports, thus making them user friendly.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Created Ad Hoc and parameterized various Reports using SSAS and SSRS.
• Assisted in handling escalating billing issues and propagating bug fixes in production environment.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.

Environment: SQL Server 2008R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer, ETL