| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
DATABASE DEVELOPERSUMMARYEngrossing grand 5 Years of experience with passion for building end to end direct capabilities, writing scalable code, as well as debugging integration packages, pipelines required for optimal ETL of data from a wide variety of sources.A certified SQL Server developer in MS SQL Server 2022/2019/2016/2014 MSBI Technologies (SSIS, SSAS and SSRS), C# and .NET. Expertise in various phases of project life cycles (Design, Analysing, Implementation and testing).Highly experienced in software development life cycle, business requirement analysis, design, programming, database design, data warehousing and business intelligence concepts, Star Schema and Snowflake Schema methodologies.Experienced on PaaS Services for Data ingestion, transformation, and storage of data from OnPrem to Cloud and vice versa, Worked on Cost Optimization by porting live reporting data to OnPrem from Cloud storage partitioned based on time series.Conversant with Data Distribution algorithms like Round Robin, ASCII and Replicator, implemented Data Partitioning using Round Robin in Data Warehouse built using Azure MS SQL PaaS service.Well experienced on Server less Azure Data Factory Author and Monitor features in order to build Cost efficient pipelines to port data from multiple sources.Implemented Azure Data Factory Integration Runtimes to execute SSIS packages, collecting On Prem data scenarios, Parametrized Linked Services and re used existing Data Sets across most of the activities in a Pipeline.Experience with logical and physical data modelling and database design, handling granularity, cardinality to optimum performance and storage.Well versed in Data Modelling, Design, Development, Implementation & Administration of Database systems using MSSQL 2022/2019/2016/2014 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS).Proficient in programming complex queries using stored procedures, Triggers, Cursors, User Defined Functions using T SQL to handle complex business scenario.Partitioning tables at different custom ranges to improve performance of data loading in tables using SQL Server Enterprise edition.Highly experienced in Dimension modelling using star and snowflake schemas, handling Slowly changing dimension using different techniques like row hash (MD5 and SHA), Slowly changing dimension wizard and Lookup, especially in incremental load of data.Experienced in handling late arriving dimension and late arriving facts scenarios in a Data Warehouse.Experienced in Designing, Creating and processing of cubes using SSAS. Created and Configured Data Sources and Data Source Views, Cubes, and calculated measures for OLAP cubes.Worked on defining Measures Groups and Dimensions by analyzing Data Warehouse in order develop multidimensional cubes and tabular models in SSAS and Responsible for developed MDX queries for faster retrieval historical data from cubes.Developed and Configured Data Sources and Data Source Views, Dimensions, Hierarchies Levels, Measure Groups, Dimension Usage Tab to define relation between Dimension and Measure Groups, Calculated Measures, KPIs and Storage Partitions in OLAP Cubes.Created different Power BI reports utilizing the desktop and the online service and schedule refresh.TECHNICAL SKILLSRDBMS Servers: MS SQL Server 2022/2019/2016/2014Cloud Utilities: Azure Data Factory Studio, Azure Portal, Azure IAM, Azure CI /CD platform, Azure MS SQL and Apache SuperSet.Database Utilities: SQL Server Management Studio, SQL Profiler, Query Analyzer, Visual StudioETL Utilities: SQL Server Integration Service (SSIS)Data Analytics Utilities: SQL Server Analysis Service (SSAS)Reporting Utilities: SQL Server Reporting Service (SSRS) Microsoft Power BI, MS-ExcelProgramming Utilities: T-SQL, C#,YAMLWeb Technologies: HTML, Java ScriptOperating Systems: Windows Server DOS, LinuxOther Utilities: MS Office Suite (Microsoft Word, Power Point, Microsoft Visio), ERWIN.EDUCATIONBachelor's degree in Information Systems, UTAEXPERIENCESQL/SSIS/SSAS DEVELOPER (Sept 2023 to Present)COMERICA BANK - Dallas, TX 75201Unified with Business Analysts and customers to develop business requirements and specifications documents using Microsoft word and Power Point.Worked on OnPrem version of DataWarehouse initially and moved to Cloud version in order to solve the challenges faced on OnPrem Servers, Leveraged power of Server less Azure Services which in turn used Apache Spark and Apache Superset.Implemented Data Factory Pipelines to load data from OnPrem SQL Server to Azure Data Lake Storage in the form of comma separated value format and further loaded this data into Azure MS SQL.Implemented Data Vault schema to store data in the form of Hub, Satellite and Link in order to support scalability and ease of adding new tables and attributes.Designed physical and logical data models and handling data repository for data models.Analysed and performed Data modelling and mapping which involved identifying the source data fields, identifying target entities and their lookup table ids and translation rules.Responsible for the development and management of Enterprise Data Warehouse processes and policies, following strategic direction on best practices for holistic architecture.Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.Optimized stored procedures and long running scripts using execution plan, temp tables, and code rewriting and indexing strategies to increase speed and reduce run time.Designed Data Warehouse ETL packages to handle data change tracking using slowly changing dimension transformation for type 1 and type 2 dimension attributes.Design, develop, and implement SSIS packages and projects to efficiently process high-volumes of data from multiple sources and meet nightly processing windows requirements.Developed configurable metadata driven ETL solution to track execution parameters, logging, and decision-making during jobs execution in order to ease debugging process in case of job failure.Designed and developed ETL packages using SQL Server Integration Services (SSIS) to load the data from SQL server, XML files to SQL Server database through custom C# script tasks.Used various SSIS tasks such as Conditional Split, Derived Column, lookup, for each loop container, sequence container, script task etc. for Data Scrubbing, data validation checks during Staging.Utilized SSIS Project Configuration to enable ease of deploying between dev, test, stage, and prod servers, by configuring environment variables to assign project parameters.Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.Designed, developed, and deployed OLAP cubes and SSIS packages to process OLAP cubes through source views having dimension and fact tables listed. Utilized XMLA file for deployment of cube.Involved in development of MDX queries for cubes in Business Intelligence Development Studio (BIDS), deploying them on the server through SSIS package for cube processing.Generating Corporate Reports for Management Committee using SQL Server Reporting Services (SSRS) and Excel.Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution.Environment: - MS SQL Server 2022/2019, Azure Data Factory, Azure MS SQL, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Microsoft Visual Studio 2022, Windows Server 2022, MDX, Erwin, SQL Profiler, SQL Server Management Studio, MS Excel, T-SQL, MS Access, TFS.SQL/ETL DEVELOPER - (May 2021 to Aug 2023)HUMANA - San Antonio, TX 78229Interconnected with Business Analysts and customers to develop business requirements and specifications documents using Microsoft word and Power Point.Maintained business intelligence models to design, develop and generate both standard and ad-hoc reports using SSMS, SSIS, SSRS and Microsoft Excel.Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.Designed dynamic SSIS packages control flow using BIML to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.Review, resolve and edit data to ensure accuracy and then convert non-Excel files to Excel format, sort, filter, and create pivot tables using Excel.Data Cleaning and data manipulation such as Concatenation, LEN, Find & Replace, Filter & Sort, Conditional Formatting, Index Match, Remove Duplicates, Logic Functions, and Short-Cut functions were done using Microsoft Excel.Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.Developed reports using SSRS for internal and external customers for business performance monitoring and business decision making.Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.Worked in Development, Testing, and Production environment.Worked with Project Manager in developing and executing project plans within assigned schedule and timeline.Environment: - MS SQL Server 2019/2017, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Microsoft Visual Studio 2017, Windows Server 2022, MDX, Erwin, SQL Profiler, SQL Server Management Studio, MS Excel, T-SQL, MS Access, TFS.POSITION: JR. SQL DEVELOPER - (June 2019 to Apr 2021)CHRISTUS HEALTH - Irving, TX 75039Embroiled in requirement analysis for new development or change requests, understanding existing defect in system.Work closely with Report Analysts and Operation Staff for support in problem resolution and root cause analysis.Worked on change requests pertaining to existing database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to support ongoing business change requests.Extensively used SSIS Data Profiler Task to profile target source systems (tables & views) prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing the table structures.Data Cleaning and data manipulation such as Concatenation, LEN, Find & Replace, Filter & Sort, Conditional Formatting, Index Match, Remove Duplicates, Logic Functions were done using Microsoft Excel on sample data.Used various SSIS tasks such Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.Responsible for implementation of SSIS Logging, error configurations for Error handling the packages.Updated Package Configurations of entire database from XML Configurations to SQL Server Configurations so as to assist in execution of packages in various environments.Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SSRS.Created dashboards with charts, graphs that convey meaningful data and insights using Power BI.Deployed reports to Report Manager and involved in troubleshooting for any error occurs in execution.Manage subscriptions and rendered reports in different formats (PDF, Excel, etc.) to be executed automatically on daily, weekly and monthly basis.Environment: - MS SQL Server 2017/2016 SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Microsoft Visual Studio 2013, Windows Server 2016, MDX, Erwin, SQL Profiler, SQL Server Management Studio, MS Excel, T-SQL, MS Access, TFS and Power BI.Garland, TX, 75043PHONE NUMBER AVAILABLEEMAIL AVAILABLE |
