| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
SQL/SSIS/DBACitizenPHONE NUMBER AVAILABLEPHONE NUMBER AVAILABLEEMAIL AVAILABLEExperience Summary:Over 6+ Years of IT professional in database Design and Development on Microsoft SQL Server 2022/2019/2016/2014/2012, T-SQL, Performance Tuning, Troubleshooting, SSIS, SSRS, SSAS and data warehousing.Full Software Development Life Cycle (SDLC) experience including Analysis, Design, and Review of Business and Software Requirement SpecificationsExpertise in Transact-SQL (DDL, DML, DCL) and the Design and Normalization of the database tables.Created and updated database objects like Complex stored procedures, joins, tables, User Defined Functions (UDF's) for business logic.Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.Designed and developed ETL packages to validate, extract, transform, and load data from OLTP systems to the Data warehouse.Worked on all activities related to the development, implementation, and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL tasks in SSIS.SSRS - Reporting using parameters, Sub reports, Drill down Reports, expressions and report development using Tabular modeling SSIS - Development and deployment of SSIS using various sources like Oracle/SQL Server/Flat Files/SAP systems.Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.Created SSIS packages using Conditional Split, Aggregate, Merge, Multicast, Term extraction Data Conversion, Fuzzy Lookup, Pivot, Lookup.Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.Expert in presenting multi-platform data visualization like pie/bar/graph chart and Dundas chart.Designing SSAS cube, writing MDX Queries, used Partition to manage and store the data and Translation.Experience in using Tableau and Power BI to generate various reports.Experience in writing Sub-queries, Joins, T-SQL queries to create database objects and to simplify complexExperience working with Agile and Waterfall methodologies in SDLC Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool.Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS PackagesExcellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.Technical Skills:DatabasesSQL Server 2022/2019/2016/2014/2012, Azure (Cloud Server), Access, My SQL, Oracle 10g, 11g,12c.Database Technologies/Tools:SQL Server Enterprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER StudioBI Tools:Power BI, SQL Server Reporting Services, Crystal Reports, Tableau, Excel, SSIS, SSAS, SSRSOperating Systems:Windows Server 2013, 2011, 2010, Windows 8/NT/XP/Professional, MS-DOS, Red Hat LinuxProgramming Languages:T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, JavaScript, CSS, Windows Scripts, Power Shell, VB.NET, ASAP.NETDesign Technologies/Tools:Erwin, MS Visio, Rational RoseData Warehouse / Business Intelligence ToolsSQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2013/2010/2008, SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio ShellCloud TechnologyMicrosoft AzureVersion ControlTFS/GIT/SVNProfessional Experience:Client: Markel - Richmond, VADuration: Oct 2021 Till DateRole: DBA Developer/ SQL DeveloperResponsibilities:Extensive experience in database backup and restoring in testing production environmentExperience creating and rebuilding indexes.Experience creating scheduled jobs and maintenance plan.Updated statistics with full scan on a weekly basis to make sure that the query optimizer uses the mostrecent statistics.Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands to find the slow runningqueries to get the performance metrics and performance tuning.Used SQL Server Profiler (Tracing), Perform and windows task manager to monitor query performanceand SQL Server resource utilization.Utilized Power Query in Power BI to Pivot and Un Pivot the data model for cleaning and massing.Utilized Power BI Gateway to keep the dashboards and reports up to date.Configuring Power BI Gateway for SSAS live connection. Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.Installed and configured Power BI Desktop.Created Power BI Visualizations and Dashboards as per the requirements.Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.Optimized queries by looking at Execution Plan for better tuning of the database.Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.Performed database backup and deployment to the production server.Involved in modifying existing DataStage Jobs for better performance.Created detail technical documentation of various staging area operations for future reference and guidance.Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.Involved in Normalization and De-Normalization of existing tables for faster query retrievalInvolved in SIT (System Integration Testing) and UAT testing, bug fixing and documentation for the project.Designed STAR, SNOW FLAKE Schemas.Utilized DBT to manage data transformations, ensuring efficient and scalable data models in a Star Schema, aligning with best practices for data warehousing.Utilized DBT to manage data transformations, ensuring efficient and scalable data models in a Star Schema, aligning with best practices for data warehousing.Developed advanced SQL queries and stored procedures to manipulate and analyze large datasets, significantly improving data retrieval times and supporting complex data analysis.Implemented data models in Star Schema, working with multi-dimensional datasets to enhance analytical capabilities and report performance.Utilized Power BI to import data from Oracle DB, SQL Server DB, and Azure SQL DB, cleaning up datasets, creating DAX Queries, and developing visual reports, dashboards, and KPI scorecards to meet business requirements.Environment: MS SQL Server 2016/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8.Client: Change HealthCare - Nashville, TNDuration: Feb 2019 Sep 2021Role: SSIS DeveloperResponsibilities:Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server 2014Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based the design data modelsCreated reports on Power BI Desktop and published on Power BI Report Server.Created access for users to use the Power BI reports on the web and across mobile devices.Applied various data transformations such slowly changing the dimensions, aggregates, sorting, multicasting, conditional split, and derived columnDesigned, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraintsDesigned and developed Tabular Model Cubes using SSAS 2014. Developed calculated columns and measures using DAXUsed Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to databaseWrote T-SQL queries, stored procedures and used them to build SSIS packages, SSRS reports and in Tableau.Involved in planning, defining and designing data base using Erwin on business requirement and provided documentationTranslating business requirements into technical design specificationsInstalled and configured and maintained Power BI Report Server.Created Power BI dashboard and generated reports using the SQL server tables as source. Lock objects on the reports.Created user interface reports using Tableau sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.)Created SQL queries and developed Dashboard style of reports as per business needsCreated and schedules tasks for reloading and distribution of Data in TableauDesigned, developed and deployed reports in MS SQL Server environment using SSRS-2014Created reports to retrieve data using Stored Procedures and parameterizationUsed SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored them in the script.Used SQL Profiler TSQL Duration template for tracking execution time of TSQL StatementsResponsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of softwareCreated traces using SQL Server profiler to find long running queries and modify those queries as a part of Performance Tuning operationsPerformed daily tasks including backup and restore by using SQL Server 2014 tools such as SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning AdvisorEnvironment: SQL Server 2014, SQL BI Suite (SSIS, SSRS, SSAS), T-SQL, DAX, Power Query, SQL* Profiler, TFS, DTS, OLAP, Windows 2008/XP, MS Visio 2010, ALM, Anaplan, Tableau, Power BIClient: Truist Bank Richmond, VirginaDuration: Mar 2018 Jan 2019Role: SSIS/SQL DeveloperResponsibilities:Generated SQL Scripts for copying/migrating databases and database objects.Gathered data for validation and populate them into tables using stored procedures.Modified current database by adding tables, altering referential integrity and relationships to support online system.Extensive use of Stored procedures, writing new stored procedures and modifying existing ones and tune them such that they perform well.Involved in designing various reports to flat files generated by the database script.Create Stored Procedures, Triggers, Views, joins and Functions for the Application.Create, debug, and execute T-SQL scripts and stored procedures.Extensively involved in error handling stored procedures.Imported various Sources, Targets and Transformations using Transact-SQL Server.Used SSIS for data population from different sources and create packages for data conversions and load data from flat flies or excel files.Extensive Testing on the Performance of the Stored Procedures.Worked closely with Application Developers and Business Analysts to produce all required documentationIdentified, tested and resolved database performance issues to ensure database optimization.Created complex views, partition views for the application to increase the performance and reduce server load.Write complex T-SQL statements for retrieval of data.Testing the Performance of the database and fine-tuning is also done for complicated queries that take time to carry out, Analysing and creation of appropriate indexes to optimize application performance.Create joins and sub-queries for complex queries involving multiple tables.Design and create SQL Database, tables, indexes.Environment: MS SQL 2012, SSIS, SSRS XML, T-SQL, DAX, MS Word, MS Excel, MS CRM, VBA (Visual Basic for Applications), Share point, DTS, C#, ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP serverEducation Details:Bachelors degree in Data Base and Information System |
