PROFESSIONAL SUMMARY:

• 8 years of strong experience with demonstrated success in the Database Design, development of SQL Server 2008/2008R 2/2012/2014.
• Designing, implement SQL Server Data Marts and Data Warehouses using practices in accordance with Microsoft guidance.
• Worked on building the data marts i.e. identifying the Dimension and fact, constructing tables and developed logical and physical models.
• Experience in working in Agile - Scrum environment with all phases of Software Development Life Cycle in different environments like Banking, Health Care, Engineering and Information Technology.
• Extensive experience in Database and Business Intelligence technologies with expertise in Installing, Upgrading, Troubleshooting and Configuring MS SQL Server Database, SSIS, SSRS, SSAS.
• Experienced in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and agile methodology.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experience in Data Modelling (Logical, Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Proficient in SQL Server, Azure, PL/SQL and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
• Good understanding and Designing of Star and Snow Flake data models Schema used in Relational, Dimensional and Multidimensional data modelling.
• Exhaustive experience in Data Extraction and Transforming and Loading ( ETL ) using SQL Server Integration Services ( SSIS ) in MS SQL Server to import/Export data, Bulk insert and BCP.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Lookup, Derived Column).
• Migrated data in various formats like text-based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services ( SSIS ) to overcome the transformation constraints .
• Experience in providing Logging , Error handling by using Event Handler , Query Optimization and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs , SQL Mail , Alerts and schedule SSIS Packages using SQL Server Agent .
• Good understanding of SSRS with Report authoring , Report management , Report delivery and Report security .
• Created different tabular reports using Power BI dashboards, Tableau and scheduled the job and refresh it in a timely manner.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, parameterized reports, Drill down, Drill through, Sub reports and rendered them to HTML, XML, PDF and Excel formats using SQL Server Reporting Services (SSRS).
• Strong experience in creating dashboards , KPI’s and scorecards using gauges and charts for analysis using SSRS 2016/ 2014/2012/2008 R2 and SharePoint 2010.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services ( SSAS ) 2005/2008.
• Experience in Dimensional modelling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse.
• Experience in working with Star Schema modelling to develop ROLAP/MOLAP Cubes using SQL Server Analysis Services.
• Excellent Communication, Analytical and Inter Personal Skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
• Worked with Power BI for creating and configuring dashboards, graphs and reports for analysis from different data base sources like SQL, Azure, Sales Force, SSAS, Oracle, and Excel, CSV, text files
• Worked on creating Power BI reports preview portal via Analysis connector with SSAS tabular cube
• Worked with Power BI for creating Power BI reports and dashboards and created custom visualizations and published them to power BI service
• Worked on creating the hierarchies using visualizations like bar chart, line, forecast, and created reports using clustered column, Tree map chart, KPI’s and pie charts in Power BI.

TECHNICAL SKILLS:

RDBMS: SQLSERVER 2014/2012/2008 R2/2008, Oracle 10G/9i, Teradata, MySQL

Database Tools: BIDS, SS Management Studio, Query Analyser, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, MSCS, Bulk Insert and BCP, Business Intelligence Development Studio, Data Quality Services(DQS), Master Data Services(MDS).

ETL & Reporting Tools: SSIS 2016/2014, Data Transformation Services (DTS), SSRS 2016/2014/2012 , SSAS, Tableau, Excel Power BI and Business Objects.

SQL, T: SQL, ANSI SQL, PL/SQL, C, C++, JAVA, C#, VB 6.0

Operating System: Windows 95/98, NT, Windows XP/2003/2000, Unix, Linux, MS-DOS

Web technologies: HTML, XML, VBScript, SharePoint 2010, C#, ASP.NET, ADO.NET, VB.NET, WINSCP.

Tools: Erwin 7.2, Visual Studio 2013/2010/2008/2005 , Visio, Visual Source Safe, Toad, FACETS, NASCO

PROFESSIONAL EXPERIENCE:

Confidential, Salem, OR

SQL Server SSIS/SSRS/MS BI Developer

Responsibilities

• Participate in project meetings, providing input to project plans and providing status updates.
• Involved in the working and interacting with the business units for the requirement gathering, involved in writing the data dictionary and worked under the agile environment for defining the objectives and bi-weekly task.
• Creating workflows to extract data from SQL Server and Flat File Sources and load into various Business Entities.
• Monitoring of processes to automate the process of loading data into data targets and monitoring scheduled daily/weekly/monthly jobs.
• Involved in complex SQL queries and stored procedures perform data transformations as per mapping documentation.
• Created DTS packages to copy tables, schemas, views and to extract data from Excel using SSIS .
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Converted data types using Derived Column, Data Conversion Transformation.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS .
• Built SSIS Packages for processing cubes and Dimensions.
• Responsible for mentoring team members, helping with assignments, providing guidance and technical oversight, and making key decisions on the technical design.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source , Excel Spreadsheet to SQL Server 2012.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Performed ETL operations to support the incremental , historical data loads and transformations using SSIS .
• Migrated SSIS Packages from SQL Server 2008 to SQL Server 2012.
• Created standard Reports and Chart Reports, Cross Tab Reports and Drill Through reports .
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Developed different reports SSRS reports and Crystal reports as per business requirements and worked with Report Manager for Deploying, Scheduling, and setting the security setting of the developed Reports.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Served as a SSRS Reports Developer and SQL Server Developer in support of Service Management System.
• Worked on creating Power BI reports preview portal via Analysis connector with SSAS tabular cube
• Worked with Power BI for creating Power BI reports and dashboards and created custom visualizations and published them to power BI service
• Worked on creating the hierarchies using visualizations like bar chart, line, forecast, and created reports using clustered column, Tree map chart, KPI’s and pie charts in Power BI

Environment: MS SQL Server 2012/2014, Visual Studio 2010/2013, SQL Server Reporting Services 2016/2014 and SQL Server Integration Services2016/2014.

Confidential, AZ

MS SQL Server Developer/SSRS/ SSIS/SSAS Developer

Responsibilities:

• Created T-SQL (DDL, DML) queries, complex Stored Procedures , User-defined Functions , designing and implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.
• Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization .
• Defined Check constraints , Business Rules , Indexes , and Views .
• Responsible for ETL operations using SQL Server Integration Services (SSIS) and Worked with users in training and support and also has experience in incremental data loading .
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Involved in implementing BI strategy and road map for the project and Worked on SSIS in Development and Production environments, building packages, deploying, and execution. Worked with Event Handlers and Error Handling in SSIS packages.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used different Transformations in SSIS Dataflow like Merge Join Multicast, and in Control Flow task like Merge Join, FTP, Script Merge and SQL script for creating Packages
• Created Drill Through and Various Cross tabbed reports using SSRS.
• Developed various kinds of Tabular, Matrix, Drill-down, Charts and web receiving reports using SSRS.
• Defined calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Created the Cubes and Dimensions.
• Responsible for creating dimensional and fact tables and building cubes using SSAS.
• Responsible for maintaining and tuning existing cubes using SSAS.
• Worked with the Planning team to forecast the business requirements.
• Experience in Designing, building the Dimensions, Cubes on star and snowflake schema using SQL Server Analysis Services (SSAS) for business analysis.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Worked mainly on Tabular models for SSAS using the DAX Queries for creating hierarchies, levels, measures, and calculated columns as per business requirements
• Created custom calculations in Data Analysis Expressions (DAX) in PowerPivot and SSAS
• Worked on implementation of Row level security for different users in cubes using MDX expression using SQL SSAS. Created custom columns in Tabular module using DAX in Microsoft Excel PowerPivot
• Worked with Power BI for creating and configuring dashboards, graphs and reports for analysis from different data base sources like SQL, Azure, Sales Force, SSAS, Oracle, and Excel, CSV, text files
• Worked with Power BI for Creating and deploying inter-active Dashboards or Analysis using excel Power Pivot.
• Created custom visualizations and dashboards using Power BI desktop and published them to Power BI service and worked on developing Ad-hoc reports, KPI’S for analysis teams using Power BI

Environment: MS SQL Server 2014/2012, Visual Studio 2010/2013, MS Access, SSIS 2014, SSRS 2014, SSAS, Windows XP Professional, MS-Access

Confidential, San Jose, CA

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created Table, Stored procedures and defined functions .
• Performed data conversions from Flat files into a normalized database structure
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Responsible for creating constraints, Indexes, and Views
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Optimized existing stored procedures to achieve improved performance.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
• Developed Cross-Tabbed and Sub-Reports in SSRS .
• Generated reports using the Reporting Services Analyser using Server analysis ( SSAS ).
• Experience in creating Multidimensional Cubes and Tabular Models, shared dimension tables, measures, hierarchies, levels and experience in implementing KPI’s, Aggregation, Partitions, Perspectives, Hierarchies and Calculated Members using SQL server Analysis Server (SSAS)
• Experienced in creating row level security for SSAS Tabular Models and their deployment and worked on DAX and MDX in SSAS in tabular and multidimensional cubes
• Designed and Developed matrix, tabular and parametric Report s in the SQL Server Reporting Services.
• Created Dimensions and cubes with star schema using SQL Server Analysis Services ( SSAS ).
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
• Design, deployment, and maintenance of various SSRS Report s in SQL Server.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, Flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union
• Experience in Performance Tuning in SSIS Packages by using Sorting, Design Alternatives and by Measuring Performance
• Experience in Error Handling by using event handlers and provide custom logging for SSIS packages
• Experience in handling Heterogeneous Data Sources and databases APS, EDW, Oracle, IBM DB2, CSV and XML files using SSIS

Environment: SQL Server 2014/2012, UML, MS Project, SSIS 2014, SSRS 2014, SSAS, Team Foundation Server (TFS), SQL Server Agent.

Confidential, White Plains, NY

SQL Developer

Responsibilities:

• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation
• Responsible for MS SQL Server Installation and configuration , applied service packs and hot fix.
• Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server .
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server .
• Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS .
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files , and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 and MS SQL Server 2000 databases/ servers
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Wrote User Defined Functions and Stored Procedures , and also defined Roles and Privileges to control access to database.

Environment: MS SQL Server 2014/2012, SQL Integration Services (SSIS), SSRS, Data Transformation Services (DTS), T-SQL, Visual Studio 2008, MS Office 2010.

Confidential, CA

MSBI Developer

Responsibilities

• Analyse business requirements to build a data mart design for various business processes conformed to the business rules.
• Analyzing the business requirements and building logical and physical data models and creating high level design of the ETL process .
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers.
• Troubleshoot of various SSIS ETL packages and its Performance Tuning, implemented failure alerts using email in SSIS.
• Utilized SSRS reports from different source formats satisfying clients by representing reports and presentations.
• Developed different reports like Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for various categories and regions based on business needs using SQL Server Reporting services.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Developed SSRS reports by sourcing cubes and Excel reporting and created custom reports in reporting tools.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers and Rules.
• Proficient in creating ETL packages, extracting data from various heterogeneous sources like: Oracle and SQL server and transformed it using different transformations.
• Experience in writing SQL Queries for pulling large volume of records from database using stored procedures, and Extraction Transformation and Loading (ETL) process using SSIS.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files.
• Using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes.

Environment: MS SQL Server 2012, MS Business intelligence (BIDS ), SSIS, SSRS, SSAS, MS Visual Studio 2012/2010, SharePoint Server 2010, MS-Office 2010, XML and Windows Server 2008

Confidential

SQL Programmer

Responsibilities:

• Created DTS packages to Copy Tables, Schemas and Views and Extract data from Excel and Oracle using SSIS.
• Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers & maintaining Referential Integrity.
• Implementing SSIS data transformations scripts, creating and maintenance of procedures and providing data integrity strategies.
• Developed reports using SSRS.
• Created standard Reports and Cross Tab Reports and Drill Through reports .
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the Subscription Reports with the subscription report wizard.
• Created different Chart Reports helped in analyzing perform counters using SSRS 2005.
• Import Data from MS-Access Database and XML to SQL Server Database.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment : Microsoft SQL Server 2008 R2, SSIS 2008, SSRS 2008, Visual Studio 2005/2008, Microsoft Office share point 2007, Windows 2000/2003/XP, .NET Framework, C#, VB, ASP.NET, ADO.NET.

Confidential

Jr SQL Developer

Responsibilities:

• Worked as a developer on databases like MS SQL server 2005, MS Access.
• Worked in Enterprise Manager for job scheduling and batch queries. Installed and maintained MS SQL Server 2005.
• Wrote complex T-SQL queries, stored procedures, triggers, cursors and user-defined functions (UDF’s).
• Imported XML data file and put into the desired database.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Developed DTS/SSIS packages to transfer the data between SQL server and other database and files.
• Experience with stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-
• Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy/exact lookups.

Environment: MS SQL Server 2008, Windows XP, SQL Server Management Studio (SSMS), Visual Source Safe (VSS), T-SQL, VB, Excel, HTML, XML, Database Engine Tuning Advisor, SQL Profiler.