Sr. SQL BI Developer (SSIS/SSRS/SSAS)
Around 6 years of IT experience as a SQL Server Developer that includes Database Design and Development of MS SQL Server 2016/2012/2008.
Experience in Data Modeling, Database Design, SQL Scripting, Development and Implementation of Client-Server & Business Intelligence (SSIS, SSAS, and SSRS) applications.
Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
Good experience in writing MDX queries while creating and customizing Cubes using SQL server Analysis Services (SSAS).
Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
Expertise in writing and debugging Stored Procedures and Triggers in SQL Server and PL/SQL.
Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML).
Expert in creating SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
Experience in PerformanceTuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
Experienced in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Creating and deploying parameterized reports using Power BI.
Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
Expert in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS-Excel spreadsheets.
ETL processes include migrating data from a DB2 database to SQL Server. Implemented high availability on the various servers using replication/mirroring.
Design, develop and test ETL (SSIS) packagesin order to extract, transform and load data from multiple sources into the data warehouse.
Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
Worked with team in developing interfaces using C#.NET.
Expert in generating Drilldown reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, charts in SSRS 2012/2008.
Experience in Performance Tuning, Monitoring and Optimization of T-SQL blocks in both Development and Production environment for SQL server database.
Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS).
Experience in Database Mirroring, Log Shipping,Database Replication, CDC and Database Snapshots
Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, parameterized reports, interactive reports & custom reports
Knowledge on Active Directory Administration and Good understanding of Change Control process
Created analytical reports and visualizations with Microsoft Excel 2013Power BI tools (Power View, Power pivot and Mapping) for exploratory analysis by data analysts
Worked in OLTP &OLAP environments that include QA, Production and development, implement maintain database schema and Entity relationship diagrams from business requirements.
Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports. Good command in generating on demand and scheduled reports for business Analysis and Management decisions using SSRS.
Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
Created SSIS packages with script task using .NET code to perform business requirements which are not provided by default SSIS components
Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures
Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
MS SQL Server 2016, 2012, 2008 R2, 2008/2005, Oracle 8i/9i/10g/12c, MS-Access 97- 2007.
SQL Server Integration Services (2005/2008), Data Stage, DTS.
Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.
SQL Server Reporting Services (SSRS), Micro strategy, Crystal Reports 8/9/10.
C#, C, C++, VB.NET, ASP.NET, Visual Basic for Applications (VBA), XML, MDX and.
MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Profiler Database Engine Tuning Advisor (DTA).
Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize, Quick Test Professional (QTP) and Quality Center (QC).
Version Control Tools
Visual Source Safe 6.0, Source gear Vault, SVN, Subversion and TFS.
Data Modeling Tools
Erwin, Red gate, Lite Speed
Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling, 1.1 using Rational Rose.
EC Info Systems, NYC July 2017 - August 2018
Sr. SQL BI Developer/SSAS/SSIS
Extensively worked on Data Flow tasks like foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
Facilitated (JAD) JointApplicationDevelopment sessions to identify business rules and requirements and documented them.
Deployed and configured the reports in the Report Server.
Created EntityRelationship (ER) diagrams for the proposed database utilizing conceptual, logical and physical data models.
Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
Experienced in Developing Power BI Reports and Dashboards from multiple data sources using DataBlending.
Created various kinds of reports using Power BI and Tableau, SSRS, Excel, and PowerPivot based on the client's needs.
Hands on experience in creating ETL packages to build data marts using SQL Server Integration Services (SSIS) and creating OLAP cubes using SQL Server Analysis services (SSAS).
Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment.
Used Text Files/ SQL Server TableLogging for all SSIS packages.
Developed interactive pages of the application using ASP.NET, ADO.NET, Ajax, Entity Framework, Web Forms pages with C# for the code behind modules and agile methodologies for .Net Framework.
Used SQL Server Package Configuration technique to make Dynamic configurations.
Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
Created SSIS/ETL packages for moving data from OLTP database to operational database (ODS) for reporting.
Hands on experience in writing SSIS scripts/ Script component task using C#, VB script for customized data manipulation of complex SSIS packages.
Deployed SSIS packages with a simple one-click deployment to the integration server.
Maintaining Tableau reports and analysis and work on enhancements to existing reports or creating new reports based on business needs
Used Dynamic SQL extensively in T- SQL increasing usability of code and also used dynamic query to create SSRS reports
Built Tableau visualizations for adhoc reporting against various Data Sources like Flat Files (Excel, Access)
Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2012/2008R2 using SSIS.
Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Worked with various SSIS packages which involve Transactions, restart ability and roll backtechniques.
Created Data Source and Dataset using OLAP Cube to create Tabular and Matrix reports as per user requirements.
Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files.
Used .NET code in script task to perform some business requirements when dealing with images.
Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application.
Created user defined functions in SSRS using VB script.
Environment:SQL Server 2012/2008R2/2008, SSRS 2008, SSIS 2008, Power Pivot, Tableau, DB2, Oracle 9i/10g, .NET, XML, XSLT, MS Office and Visual source safe, Visual Studio 2012.
US Steel, Pittsburgh, PA October 2016 - July 2017
Sr. SQL BI Developer (SSRS /SSIS/SSAS)
Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
Implemented C# code in Script tasks to implement customized requirements.
Migrated DTS packages from SQL Server 2012 to SQL Server 2016 as SSIS packages.
Responsible for developing and maintaining Tableau dashboards
Extracted data from various sources like MS SQLServer 2012/2008, DB2, flat files, Excelspreadsheets, Oracle and XML files and loaded into the oracle database.
Excellent report creation skills using Microsoft SQL Server 2012 ReportingServices (SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint.
Created calculated members and KeyPerformanceIndicators (KPIs), perspectives and partitions with existing SSAS cube objects for better analysis.
Implemented report manager to set up roles, security, and subscripts (data driven/standard) on the existing SSRSreports.
Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI and SSAS.
Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard utilizing Power BI.
Creating and deploying parameterized reports using Power BI and Tableau.
Transferring the data (ETL) to Data warehouse with SQL Server 2005 and 2008R2 Integration Services.
Good Knowledge on data visualization tools PowerBI and Power Pivot.
Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
Created complex reports which involve a greater number of groupings and multi-value parameters.
Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
Restructuring the stored procedure, designing, coding and developing using the T-SQL Programming.
Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
Created multiple reports with drop down menu option having complex groupings within the report.
Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
Wrote multi-Dimensional Queries (MDX) to generate reports for analysis of data.
Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS).
Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
Created cube partitions and aggregations to improve the MDX query performance.
Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
Created various complex reports using Crystal Reports XI R2 and worked on existing reports toenhance/modify by creating new Parameters, Formulas.
Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non- SQL-Server databases.
Used Dynamic SQL extensively in T- SQL queries and stored procedures increasing usability of code.
Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
Working experience with ASP .NET to display reports and experience using C# in SSIS scrip task.
Worked very closely with Business Customers, End Users and resolved any business process related issues.
Environment: Windows server, IIS 6.0, MS SQL Server-2016/2012/2008Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Power BI, Erwin VB.NET, OLAP, OLTP, Erwin, UNIX, Performance Point Server, Office-2007, MS Excel, C#.NET, ProClarity Analysis, MS SharePoint.
American Family Insurance, Madison, WI March 2014 - July 2016
Role: SQL BI Developer
Designed and developed SQL Server Reporting Services (SSRS)SQL Server 2012/2008.
Involved in Report writing per business requirement usingSSRS and Crystal Reports.
Generated database monitering and data validation reports in SSRS.
Expert in creating Tabular reports, Matrix reports, List report, Parameterized reports, Sub reports, Ad-hoc reports (SSRS).
Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL.
Experienced on creating multiple kinds of Reports in Power BI, Ad-hoc and present it using Story Points.
Configure the Report Server and generated the Report Models for user interactions.
Involved in Partition of cubes to increase the performance of cubes.
Sound Experience and understanding of SSAS, OLAP cube, Data mining and Architecture.
Involved in Performance Optimization of Microsoft SQL Server stored procedures, Analysis Services and cubes.
Deployed SSRS Reports in SharePoint for web-based access for multiple end users.
Usedwindows Power Shell Script to automate application deployment process.
Generated dynamic stored procedures, triggers, Cursors, Joins for the database development.
Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
Interacting with Business users and BA’s to gather requirements for creating ETL Packages and Reports.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
Creating SSIS Packages using different type’s task and with Error Handling.
Developed many scripts while designing the SSIS package using C#, VB.NET
Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
AzureStorage development and design utilizing Blobs, Pages, Queues, Tables and VM's
Fine-tuned the complex database stored procedures to increase performance.
Performance tuning and optimization of procedures and queries.
Experience in creating complex SSIS packages using proper control and data flow elements.
MigratedDTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005.
Successfully deployed reports in various sources like XML, Web browser and PDF.
Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
Worked on OLAP Data warehouse, Model, Design, and Implementation.
Designing OLAPcubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
Expert in writing stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language
CreatedSQL Server Profiler traces and used with Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX queries.
Improved the MDX query performance by changing the dimension structure and measure group properties.
Wrote MDX queries according to the business requirements.
Experience in Designing and Buildingthe Dimensions and cubeswith star schema and snowflake schemausing SQL Server Analysis Services (SSAS).
Created Analytical reports by ProClarity tool.
Designing Cubes, Star Schema and Data models for Data Warehousing Applications.
Involved in Unit testing process.
Environment: MS SQL Server 2005/2008, Management Studio(SSMS), ETL, DTS, Azure, Notification Services, Crystal Reports9.0, Data Modeling, OLAP, Data ware Housing, MDX, Share point (2003/2007), Asp.Net, T-SQL, SQL Profiler, IIS 6.0, Windows 2003 Advanced Server, SSAS, SSIS, SSRS 2005/2008, community server, Er
NSG INDIA, Hyderabad, India Jan 2013 - March 2014
SQL Server BI Developer
Worked with project lead and business users to understand business processes
Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008
Worked with T-SQL to create Tables, View and stored Procedures
Created triggers on DML actions for security purpose
Worked with Scalar and Table Value User Defined Function as per business requirement
Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables.
Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service and available in Web clients and Mobile Apps.
Encapsulated frequently used SQL Statements into stored procedures and reduced the execution time.
Wrote Merge Statement to handle insert, update and delete within single statement between source and destination table.
Scheduled jobs to call the packages and Stored Procedures as per business requirement
Created packages in SSIS with error handling and worked with different methods of logging in SSIS
Created SSIS Packages to move the data from tab delimited flat flies into SQL database.
Made dynamic SSIS packages which did data scrubbing, including data validation.
Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS 2008.
Deployed, configured and managed reports using Report Manager and Report Builder.
Created Cross-Tab and Sub-Report using RDL.
Promoted RDLs to Reporting Service Server.
Used Visual Source Safe (VSS) for version control.
Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle)
Environment: SQL Server 2008, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager),
SSRS, SSAS, Business Objects, Windows Server, MS Visio, Oracle, MS Excel.
UBS Bank, Hyderabad, India June 2012 – December 2012
Jr. SQL Developer
Upgraded to latest version from SQL Server 7.0 to 2005.
Developed User Defined Functions for giving Scores and views for the application
Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
Wrote various Stored Procedures for application development
Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
Worked on replication of data (Transactional method used)
Designed and implemented data access stored procedures and triggers for automating tasks
Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails
Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
Involved in deploying, configuring and managing reports using Report Manager and Report Builder
Formatted the reports using the Global variables and expressions
Performed job scheduling and alerts
Designed and implemented user log in and security
Resolved any deadlocks issues with the databases/servers on a real-time basis
Environment: Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT.