| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Data EngineerPHONE NUMBER AVAILABLE EMAIL AVAILABLETampa, FLSummary:Total 14 Years of IT experience as MS SQL Server Developer, BI Developer, Reporting and Azure Data services, ADF, Data bricksExperience in Installing, Configuring, Managing, and Troubleshooting SQL Server, Microsoft CRMExperience in Data Schema Design and Table Design, T-SQL in constructing Tables, Triggers, User Function, Views, Stored Procedures, CTEs, Temp Tables, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.Experience in Using multiple join statements to retrieve data from multiple tablesExperience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reportsWorked in SDLC (Systems Development Life Cycle) for developing systems/SoftwareExperience with Azure Data Factory, Data Warehouse and Migrated existing SSIS into ADF, ADF job automation.Experience with Azure transformation projects and Azure architecture decision making Architect and implement ETL and data movement solutions using Azure Data Factory (ADF), SSISRecreating existing application logic and functionality in the Azure Data Lake, Data bricks, Data Factory, SQL Database, and SQL data warehouse environmentDatacentre Migration, Azure Data Services have strong virtualization experienceExperience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuningExperience in MS Business Intelligence tools SSIS, SSRS.Experienced in developing Data Marts and Data Warehousing loads with ETL toolsMigrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2005 via SQL Server Integrated ServicesImplemented SSIS data, created maintenance procedures, and provided data integrity strategies.Created ETL packages using SSIS to move data from various heterogeneous data sources.Created logs for package level and task level, implemented error handling and rollback process in ETL load, Configured SSIS packages using Package configuration wizard to allow packages to run on different environments.Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databasesExtensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.Expertise in creating Property Expressions, Script Tasks for SSIS packages, and removing the Duplicate (De-duplication), lookup, Incremental loads.Worked with Financial companies for application-related pricing and security applicationsExperience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snowflakes Schema and Star SchemaExperience in multidimensional databases with demonstrated ability to create calculated members and MDX scriptingProficient in building Cubes, defining Referenced Relationships, and creating Hierarchies in SSASExpert in uploading SQL Server Reports onto the report manager and Developed Reports using efficient data retrieval techniquesExpert in reporting and visualization tools SSRS/Tableau/PowerBI, efficient data retrieval techniques and different types of reports.Developed different types of reports including Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrolment count summary report, Billing reportDeveloped visualizations and dashboards using SSRS/Power BI and Tableau, workbooks from multiple data sources using Data Blending, workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.Expert in Reports using efficient data retrieval techniques from multiple sources.Excellent communication, presentation, interpersonal skills, strong troubleshooting, and organizational skillProactive, independent, self-managing and teamwork spirits.Education: Masters in Computer Science, Indiana State University 2008.LinkedIn: https://LINKEDIN LINK AVAILABLETechnical Skills:Databases: SQL Server 7.0/2000/2005/2008/2012/2016/2019, Oracle 8i/9i/10g, DB2, TeradataLanguages: C, C++, T-SQL, PL/SQL, ASP.NET, Visual Basic 6.0, Visual Studio, VB.Net.Scripting Languages: HTML, DHTML, Unix Shell Scripting, JavaScript, Perl, CGI, VBScriptOperating Systems: Windows Server 2000, Windows Server 2003, Windows NT 4.0, Windows XP.ETL Tools: SSIS (MS SQL Integrated Services), DTS, Informatica, ADF Azure Data FactoryTools SSAS (MS SQL Analysis Services), SSAS-Tabular Model, Erwin 4.0/3.5, TOAD, IIS, Lite Speed, Spotlight, ProClarity, QNXTReporting: SSRS (MS SQL Reporting Service), Power BI, Tableau, Crystal Reports XI, MS Access, Excel, Data Analyzer.Professional Experience:NRUCFC Corporation, Tampa, FL Oct2021 - CurrentSr Data EngineerResponsibilities:Created Tables, Views, Indexes, Stored Procedure, Triggers, join statements.Performance tuning in Stored Procedures, views for reporting, and ETLsWorking with CTEs (Common Table Expressions) and Temp tables for increasing the performance of the Views and Stored ProceduresImplemented Change Data Capture (CDCs) for the daily load to DataMart sync. For daily and weekly sync from Transaction DB to DW/DataMart.Extensively used Extract Transform Loading (ETL) tool to populate data from various data sources, Data Migration and Data Conversion processWorking on Developing Data Warehouse/Data Marts and SDLC process to populate data from OLTP to OLAPDeveloped, monitored, and deployed SSIS/SSRS/SSAS-Tabular/PowerBI, Tableau packages.Worked in transferring the data using SQL Server Integration Services packagesUtilized Integration Services (SSIS) to produce a Data migration and data martsStrong experience in working with BCP, SSIS (DTS, DTSX) packages for Data Integration Services.Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.Experience with Azure Data Factory, Data bricks, Data Warehouse, and Migrated existing SSIS into ADF.Worked on Azure transformation projects and Azure architecture decision making Architect and implement ETL and data movement solutions using Azure Data Factory (ADF), SSISExtensive knowledge of using Package Configuration wizard to configure SSIS packages.Expertise in creating Property Expressions, Script Tasks for SSIS packages.Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2005 via SQL Server Integrated ServicesImplemented SSIS data, created maintenance procedures, and provided data integrity strategies.Experience in multidimensional databases with demonstrated ability to create calculated members and MDX scripting.Worked in SQL Server Analysis Services (SSAS) OLAP Cubes and Tabular Model, and Mining, Involved in Analysing, Designing, Building, and testing of OLAP Cubes using SQL Server Analysis Services (SSAS)Regular responsibilities for updating staging and dimensional databases as well as rebuilding the Dimensions and Cubes in Analysis Services.Implemented Snowflakes Schema and Star SchemaWorked with Development teams in relation to application tuning and Performance tuningInvolved in the Database design (Logical Data Modelling and Physical Data Modelling)Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.Created views and Stored Procedures for generating reports. Responsible for creating the reports based on the requirements using SSRS. Extensively worked in sorting the data, defining subtotals for the reportsDelivered the reports using pulled and pushed methodologies and formatted the reports using the Global variables and expressions.Worked on Reporting tools SSRS, Tableau, Crystal Reports, Power BI for Client reporting.Worked in SDLC (Systems Development Life Cycle) for developing systems/SoftwareHands on experience in Unit testing the Code and packages before handing to Testing teams.Installed and Configured Microsoft SQL Server toolsEnvironment:MS SQL Server Stack, SSRS, Power BI, Tableau, Query Analyzer, VB.Net, C#, Unisys, Wintel, Visual Studio, HTML, Script, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, SQL Clustering, Oracle, SAN, Source Control Management System, Index Tuning Wizard, SDLC, Azure Data Factory, SSAS, and Tabular Model, Tableau, Data Warehousing.CareSource, Dayton, OH March2020 - Oct2021Data EngineerWorked with Development teams in relation to application tuning and Performance tuning.Expertise in creating Property Expressions, Script Tasks for SSIS packages and complicated SSIS packages.Involved in the Database design (Logical Data Modelling and Physical Data Modelling)Created Tables, Views, Indexes, Stored Procedure, Triggers, join statements.Performance tuning in Stored Procedures, views for reporting, and ETLsWorking with CTEs (Common Table Expressions) and Temp tables for increasing the performance of the Views and Stored ProceduresImplemented Change Data Capture (CDCs) for the daily load to DataMart sync. For daily and weekly sync from Transaction DB to DW/DataMart.Extensively used Extract Transform Loading (ETL) tool to populate data from various data sources, Data Migration and Data Conversion processInvolved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.Created complex views and Stored Procedures for generating reports. Responsible for creating the reports based on the requirements using SSRS. Extensively worked in sorting the data, defining subtotals for the reportsDelivered the reports using pulled and pushed methodologies and formatted the reports using the Global variables and expressions.Worked on Reporting tools SSRS, Tableau, Power BI reporting with requirement gathering/AnalysisWorked in SDLC (Systems Development Life Cycle) for developing systems/SoftwareHands on experience in Unit testing the Code and packages before handing to Testing teams.Installed and Configured Microsoft SQL Server toolsMoffitt, Tampa, FL Oct2019- March2020BI-DW/Reporting DeveloperCreated views and Stored Procedures for generating reports. Responsible for creating the reports based on the requirements using SSRS. Extensively worked in sorting the data, defining subtotals for the reportsPerformance tuning in Stored Procedures, views for reporting, and ETLsWorking with CTEs (Common Table Expressions) and Temp tables for increasing the performance of the Views and Stored ProceduresExpert in reporting and visualization tools SSRS/Tableau/PowerBI, efficient data retrieval techniques and different types of reports.Created complex views and Stored Procedures for generating reports. Responsible for creating the reports based on the requirements using SSRS. Extensively worked in sorting the data, defining subtotals for the reportsDeveloped monitored and deployed SSIS packages.Responsible for transferring the data using (ETL) SSIS packages.Created ETL packages using SSIS to move data from various heterogeneous data sources.Created logs for ETL load at package level and task level to log the number of records processed by each package and each task in a package using SSIS.Implemented error handling and rollback process in ETL load.PWC, Tampa, FL Jan2019- Oct2019BI/DW DeveloperCreated tables, views, indexes, stored procedures, triggers and provide constraints and user-defined rules and defaults. Used multiple join statements to retrieve data from multiple tablesWritten T-SQL Procedures using temp tables, cursors, subqueries, and functions developed, monitored, and deployed SSIS packages. Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sourcesMS CRM Implementation, Maintenance, installation.Day to Day Server maintenance, monitoring jobs and deployments of SSIS and SSRS to productionConfigured SSIS packages using Package configuration wizard to allow packages to run on different environments.Health Integrated, Tampa, FL August2013- Jan2019Lead BI-DW/ReportingResponsibilities:Developed monitored and deployed SSIS packages.Worked on migrating all 2005 projects to 2008/2010 and implemented new projects in 2012Responsible for transferring the data using (ETL) SSIS packages.Created ETL packages using SSIS to move data from various heterogeneous data sources.Created logs for ETL load at package level and task level to log several records processed by each package and each task in a package using SSIS.Implemented error handling and rollback process in ETL load.Configured SSIS packages using Package configuration wizard to allow packages to run on different environments.Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.Used XML and environmental variables in the package configuration for Deploying SSIS packagesExtensively used SQL Server Analysis Services SnowFlakes Schema and Star SchemaInvolved in Analysing, Designing, Building, and testing of OLAP Cubes using Analysis Services-SSASRegular responsibilities for updating staging and dimensional databases as well as rebuilding the Dimensions and Cubes in Analysis Services.Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sourcesInvolved in creating SQL server Analysis Projects using MS SQL Server 2005.worked in sorting the data, defining subtotals for the Reports, and Creating Adhoc ReportsWorked with Clear Case and Autosys applications for version controlGenerating scripts using Erwin and Created and Altering the DatabasesWorked in SDLC (Systems Development Life Cycle) for developing systems/SoftwareTested the application for deployment, Function, and behaviourDME Automotive Jacksonville, FL March2012-Aug2013BI/DW DeveloperData Migration project from scratch for AON merged with Benfield.Migration of Benfield schema to Aon schema including tables, views, and stored procs. Used SPs and SSIS for data migration of the Benfield scheme to Aon. Complex schema handling and performance tuningImplemented error handling and rollback process in ETL load.Configured SSIS packages using Package configuration wizard to allow packages to run on different environments.Aon Benfield Minneapolis MN Oct2010-March2012SQL Server Developer/BI Data Migration-insurance/reinsuranceCreated tables, views, indexes, stored procedures, triggers and provide constraints and user-defined rules and defaults. Used multiple join statements to retrieve data from multiple tablesextensively used Tsql for SP, Views Performance tune existing and worked on new as per business requirements.Migrated existing procs to a new change in business requirementsExtensively worked on migrating old website to new website, migrating all backend procsTesting and validating migration of SP, views, and DDLCoordination and teamwork with multiple teams.UHC.EDU (University Health System Consortium) Chicago, IL April2010-Sep2010SQL Server Developer/BI DeveloperMicrosoft Corp., Bellevue, Seattle, WA Oct09-March2010SQL Server Developer/BI DeveloperFEI Company, Hillsboro, Oregon July09-Oct09SQL Server Developer/DBA |
