Home

Santhosh K Rudra - Sr.SQL BI Developer

[email protected]

Location: Madison, Mississippi, USA

Relocation: prefer Remote

Visa: H1B

Professional Summary: >Over 10+ years' experience as MS-SQL Server Developer, involved in Design, Development and Support of MS SQL Server [2016, 2012, 2008 R2, 2008, 2005] for both OLTP and OLAP Systems. > Excellent working skills in MS SQL Server Business Intelligence tools SSIS, SSRS and SSAS. Configured report subscriptions both data driven and time driven. > Experience in Software Development Life Cycle (SDLC) specifically waterfall and Agile > Experience in working on source controller tools like Subversion (SVN) and GIT. > Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors. > Developed many ETL using SSIS (SSDT-2015), created security model using SSAS Tabular Model (DAX), using GitHub as source control. Generated hierarchy based - role based reports in SSRS/PowerBI for the management. > Programmed Tasks Stored Procedures, Triggers, Cursors using SQL Server 2012/2014 with T-SQL, database exception handlers, cursors, cursor variables. > Good knowledge of Data Marts, Data warehousing, and operational data store (ODS), data modelling such as Dimensional, star schema, snowflakes and good understanding of Facts and dimensions. > Created Data marts for Staging and Production databases for Operational Data Stores (ODS). > Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system. > Create SSAS Tabular Model and SSAS Multidimensional Model and support the existing database components. > Designed and Developed new SSAS Tabular Models and used DAX expressions/formulas for creating calculated measures and columns. > Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL [2012, 2008 R2, 2008, 2005]. > Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. > Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS > Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS. > Responsible for creating SQL datasets for Power BI and Ad-hoc Reports. > Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports. > Designed and Developed new SSAS Tabular Models. > Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power BI. > Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages. > Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder. > Expert in creating multiple kinds of Power BI Reports, Dashboards and Visualizations. > Performed Data Mining activities on central repository for various application and dashboard functionalities. Actively involved in the analysis of Cubes and added the Key Performance Indicators (KPI) to the created cubes. > Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards. > Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans. Creating and Managing logins, users, roles and assigning necessary permissions. > Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills. > Robust MS Access and Excel skills with power Pivot, pivot table, Pivot Chart, Power View, PowerBI, VLOOKUP Functions and Formulas. Education: > Bachelor of Technology in Computer Science & Engineering, India. Technical Skills: Operating Systems : UNIX, LINUX, Sun Solaris 5.8/5.9/5.10, Windows NT/95/98/2000/XP Databases : Oracle 11g/Oracle 10g, Oracle 9i, MS Access Utilities : SQL*Loader, Explain Plan, FTP, SFTP, SCP Tools : TOAD, SQL Developer, Erwin, SQL Navigator, SQL*Loader, SQL*Plus, MS- FrontPage, MS Office Suite, iSQL Plus, (REPORTS 6i/9i/10g/11g, FORMS 6i/9i/10g/11g). ETL Tools : Informatica power center 8.6.x, Data stage Professional Experience The Home Depot, Madison, MS Jan 2023 Present Sr BI Developer The Home Depot, Inc., often simply referred to as Home Depot, is an American multinational home improvement retail corporation that sells tools, construction products, appliances, and services, including fuel and transportation rentals. Home Depot is the largest home improvement retailer in the United States. Responsibilities: > As a part of BI/Database team, involved in Requirement gathering, Development, Testing and Implementation of BI Analytics and Reports. > Worked with business users and stakeholders to refine requirements. > Created T-SQL stored procedures, functions, etc. and tuned them using query analyzer and explain plans. Performed data profiling, data analysis to identify legacy data that needs to cleanse prior to the migrations using SSIS Data Profiling Task, Data Profile viewer and T-SQL queries. > Creating Database Objects like Tables, Indexes, User defined functions, Triggers, Parameterized Stored Procedures and Constraints > Extensively used Joins to simplify complex queries/sub queries involving multiple tables and optimized the procedures and Indexes, Cursers and triggers. > Created several Schemas, Tables, Cursers, Triggers and Indexes, Identity Column, Identity Seeding, Calculated Columns as per the requirement. > Create SSAS Tabular Model and SSAS Multidimensional Model and support the existing database components. > Designed Table, matrix, sub reports and linked reports by using SQL server reporting services (SSRS) and deployed in production server. > Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. > Designed and Developed new SSAS Tabular Models and used DAX expressions/formulas for creating calculated measures and columns. > Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. > Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files using SSRS. > Used Team Foundation Server (TFS) to provide a set of collaboration tools that work with the existing IDE or editor, to work effectively on the project. > Designed different visualizations in Power BI according to the requirements > Publishing Power BI Reports from Power BI Desktop to Power BI Service. > Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse. > Developed, monitored and deployed many SSIS packages > Using transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse. > Create SSAS Tabular Model and SSAS Multidimensional Model and support the existing database components. > Optimized ETL packages by increasing the memory buffer size and by implementing various advanced SSIS features like optimizing different Control Flow & Data Flow components. > Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, and Drill through, Sub reports using SSRS. > Developed Tableau data visualization using Pie Charts and Bar Charts and Density Chart. > Designed and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau. Environment: MS SQL Server 2016/2014, T-SQL, SSIS, GIT, TFS, SSMS 2016, SSRS, ER-Win, Excel, SSDT, Visual Studio 2015, SharePoint, Tableau, Power BI, SSAS Tableau. Santander Bank, Boston, MA Aug 2020 Dec 2022 SQL/SSIS/SSAS/POWER BI Developer Santander Bank, is one of the country s largest retail and commercial banks with $89.5 billion in assets. With its corporate offices in Boston, the Bank s approximately 9,000 employees and more than 2 million customers are principally located in Massachusetts, New Hampshire, Connecticut, Rhode Island, New York, New Jersey, Pennsylvania and Delaware. Responsibilities: > Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. > Skilled in writing T-SQL - simple and complex joins, sub-queries, stored procedures, triggers, cursors, functions, views, CTE, DDL, DML. > Written and modified some existing Stored Procedures, complex queries and Indexes in SQL Server 2012 environment. > Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. > Created complex procedures to perform Index maintenance, data profiling, for loading data marts. > Created SSIS package to import and export data from Excel, XML and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages. > Created few stored procedures for report parameterization & dynamic SQL generation. > Designed ETL Jobs/Packages using SQL Server Integration Services SSIS > Using transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse. > Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. EDI 820 testing for APTC/ CSR payments from federal exchange (FFM). > Created Reports using SQL Server Reporting Services (SSRS) sourcing from Staging and Data-Marts. > Designing dashboards with use of visualization tools like Tableau. > Designing dashboards with the use of visualization tools like Tableau, Using SQL for managing large volume of data. > Recognizing areas for automation. > Restricting data for users with the help of User filters. > Filtered bad data from legacy system using Derived column, Lookups, Conditional split. > Created SQL scripts to insert/update and delete data in MS SQL database. > Identified and worked with parameters for parameterized reports in SSRS 2005/2008 and used SSIS import/export wizard for performing the ETL operation. > Deployed SQL mail agent for sending automatic emails. > Deployed SSIS packages to the production server using Environment Variables and SQL server configurations. > Created and Implemented complex ETL Strategies utilizing SSIS Packages that removed the information from various heterogeneous sources like Flat Files, Excel Files and dumped it into a concentrated Data store. > Optimized ETL packages by increasing the memory buffer size and by implementing various advanced SSIS features like optimizing different Control Flow & Data Flow components. > Debugged SSIS packages using checkpoints, event handlers and loggings as well as redirecting errors for further processing. > Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures. > Optimized the database by creating various clustered, non-clustered indexes and indexed views. > Used SQL server Agent for scheduling jobs and Optimized queries using SQL profiler. Environment: MS SQL Server 2016/2014, T-SQL, SSIS, GIT, TFS, SSMS 2014, SSRS, ER-Win, Excel, SSDT, Visual Studio 2015, Service Now, SSAS Tableau. Synchrony Financial, Stamford, CT Jul 2018 Jul 2020 SQL Server/BI Developer Synchrony Financial is an American consumer financial services company with its headquarters in Stamford, Connecticut, United States. The company offers consumer financing products, including credit, promotional financing and loyalty programs, installment lending to industries, and FDIC-insured consumer savings products, through Synchrony Bank, its wholly owned online bank subsidiary. Responsibilities: > Involved in development and implementation of SSIS, SSRS application solutions for various business units across the organization. > Highly skilled in T-SQL - simple and complex joins, sub-queries, stored procedures, triggers, cursors, functions, views, CTE, DDL, DML. > Extensively used Joins to simplify complex queries/sub queries involving multiple tables and optimized the procedures and Indexes, Cursers and triggers. > Created few stored procedures for report parameterization & dynamic SQL generation. > Written and modified some existing Stored Procedures, complex queries and Indexes in SQL Server 2012 environment. > Developed complex reports for the client using SSRS 2008. > Created Tableau worksheets based on prioritized KPIs and data sources. > Implement trend analysis and forecasting on real-time data from multiple sources using Tableau and apply in business solutions. > Involved in creating calculations like string manipulation, arithmetic calculations, custom aggregations and ratios, logic statements and quick table calculations. > Communicate to business users on sprint basis for development update and confirmations > Created a SSRS exception report that is emailed to the recipients when data could not be loaded into the main tables due to data issues. > Deployed reports to the report server. Scheduled daily and weekly reports using SSRS subscriptions to the Sales managers and various other users. > Generated reports using SQL Server Reporting Services (SSRS), integrated and deploying them in SharePoint > Generated several Drill down and Drill through reports using SSRS. > Worked on the Reports module of the project as a developer on MS SQL Server 2012 (using SSRS, T-SQL, scripts, stored procedures and views). > Focused on modifying existing reports for changes in business rules. > Hands-on working experience in Installing, configuring, upgrading and managing SQL Server [ ] and required Service Packs. > Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, and Drill through, Sub reports using SSRS. > Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server. > Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals and alerting. > Worked on handling performance issues, Troubleshooting of Mappings, evaluating current logic for tuning possibilities. Environment: MS SQL Server 2012/2008 R2, T-SQL, SSRS, Crystal Reports, SSIS, SSAS, Erwin, T-SQL, Report Builder Elevance Health, Inc., Indianapolis, IN Jul 2016 to Jun 2018 SQL Developer Elevance Health, Inc. operates as a health company, which engages in improving lives and communities, and making healthcare simpler. It operates through the following segments: Commercial and Specialty Business, Government Business, CarelonRx, and Other. The Commercial and Specialty Business segment provides insurance products and services such as stop loss, dental, vision, life, disability and supplemental health insurance. The Government Business segment includes Medicare and Medicaid businesses, national government services, and services provided to the federal government. Responsibilities: >Involved in ER diagrams and mapping the data into database objects, design of the Database and the Tables. > Setup the database with suitable memory and hard disk space allocation, creating different user and security profiles for the team. > Strong reporting experience using Excel, Access. > Worked on Client/Server tools like MS SQL Server 2008/2005 Enterprise Manager and Query Analyzer to Administer SQL Server > Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2008/2005. > Worked on Excel 2008, Power Pivot for providing ad-hoc reporting for the clients. > Experience in DTS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper mapping. > Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. > Review and implement migration plan from Vault to TFS. > Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates. > Worked in Agile/Scrum Methodology with daily stand up meetings and vast knowledge in TFS (Team Foundation Server) 2010. > Execution of SQL queries to extract data from DB2 tables for running test scripts. > Created many complexes Query's and used them in Power BI Reports directly to generate reports on the fly. > Generated database SQL scripts and deployed databases including installation and configuration. > Experience in creating Indexes for faster performance and views for controlling user access to data. > Performed unit testing, provided bug fixes and deployment support. Environment: SQL Server 2008/2008R2, DDL, DML, Tableau, TFS, Visual studio 2008/2010 Store Procedures, Views, UDFs, VSS, Power BI, C#.NET, Waterfall methodology. Cencora, Inc., Conshohocken, PA Dec 2015 Jun 2016 SQL Developer Cencora, a company building on the legacy of AmerisourceBergen, is a leading global pharmaceutical solutions organization centered on improving the lives of people and animals around the world. Responsibilities: > Creating and analyzing existing high level ETL design documents and data mapping documents. > Involved in Agile Process, Part of Sprint Meeting and Scrum Calls. > Created SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, > Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task. > Imported data, built scheduling packages, defined integration flow and log data error exceptions using SSIS. > Migrated data from different sources (text based files, Excel spreadsheets) to SQL Server databases using SQL Server Integration Services (SSIS). > Developed Package configurations for Integration, Test and Production environments and execution of SSIS packages automatically. > Designing Enterprise reports using SQL Server Reporting Services (SSRS 2012) which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service. > Hands on experience on SSAS tabular model. > Worked on Power Pivot to generate repots and create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts etc. > Created sub-reports, drill down reports, summary reports, parameterized reports using SSRS Optimized existing reports and process new changes as per business requirements. > Assisted in building a company specific Data Mart for the Claims related data. > Optimized the performance of queries with modification in T-SQL queries, removed the unnecessary columns and redundant data, normalized tables, established joins and created index. > Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases. > T-SQL used for creating various complex objects like Tables, views, functions, store procedure for storing and processing data in required form. Environment: SQL Server 2008/2008R2, DDL, DML, Tableau, TFS, Visual studio 2008/2010 Store Procedures, Views, UDFs, VSS, Power BI, C#.NET, Waterfall methodology. Keywords: csharp business intelligence database active directory information technology microsoft Connecticut Massachusetts Pennsylvania