| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
Apex, NC+16037937522 EMAIL AVAILABLE https://LINKEDIN LINK AVAILABLE SummaryMicrosoft Certied Azure Data professional with over 8 years of experience in database design, development, and analysis. Procient in T-SQL/ETL development and skilled in creating SSIS packages for data migration. Experienced in Azure SQL Server DB and Azure VM migrations, with a solid foundation in SSRS and Power BI for reporting. Aiming to leverage extensive experience to drive data engineering initiatives and optimize data workows. SkillsSkills: MS SQL Server (2012/2014/2019), T-SQL, MySQL, Oracle, SSRS, SSIS, SQL Proler, Visual Studio 2019, SQL Server Report Builder, SSMS, Azure Data Factory, Azure Synapse Analytics, Salesforce, GitHub, Python, Power BI, C#, .NET, REST API, PowerShell, Jira, Relational Databases, ETLWork ExperiencePentegra Oct 2021 - Feb 2024Senior Database DeveloperDeveloped extensive ETL pipelines utilizing Azure Data Factory, leading to a 30% increase in workow eciency.Architected robust data models that supported business intelligence insights, driving a 25% lift in data driven decision making.Led the design and development of a scalable Azure-based analytics platform, enhancing data processing speed and reliabilityDesigned and created data mappings from various sources, including Flat les, DB2, Excel les, OLEDB, and ODBC data sources, ensuring seamless data integrationOrchestrated the development and deployment of SSIS packages, integrating data from diverse sources like Flat Files, Salesforce, and Excel into the Enterprise Data Warehouse, resulting in a 20% increase in data accuracy and consistency.Generated Daily, Weekly, Monthly, Subscriptions, and Dashboard reports using SSRS and optimized report performance.Converted Python scripts to SSIS packages and scheduled jobs using SQL Agent for daily execution.Developed a data warehouse that enabled users to easily query complex datasets.Created operational reports and analytical dashboards on Azure Data Warehouse using Power BI and Azure Analysis Services.Facilitated project planning by eectively estimating technical tasks, resulting in on-time sprint execution and delivery.Developed PowerShell scripts to automate full, dierential, and transaction log backups for SQL Server, reducing backup window time by 25% while maintaining data integrity and compliance. PoliteMail Software Sep 2015 - Oct 2021Software Developer II Portsmouth, NHDeveloped SQL Server stored procedures, T-SQL queries, Functions, Views, and Triggers, improving database performance and reliabilityCompleted a SQL migration from MySQL to SQL Server, xing critical defects addressed during conversion.Worked on Syncronym, a service-driven ETL tool from PoliteMail, and developed Web API Controllers, enhancing data processing eciencyCreated PoliteMail Custom Connector for automated workows and generated custom reports using Microsoft Power BI, streamlining reporting processesDesigned SSIS Packages for data extraction, transformation, and loading (ETL) operations, ensuring accurate and timely data integrationDeveloped stored procedures, triggers and functions that automated manual processes and improved performance by 30%.Developed a dashboard to visualize key performance metrics, allowing management to make informed decisions quickly. Techminds LLC Jul 2015 - Sep 2015SQL Developer Hampton, NHInvolved in Database Design using Normalization Techniques and developed complex T-SQL code for applications.Involved in writing scripts for querying databases. Developed queries, sub-queries, stored procedures, triggers, and functions.Created and Modied Tables, Stored Procedures, Views, Indexes, User-dened Functions, and Triggers as per business requirements.Tested to optimize the Stored Procedures and Triggers to be used in production.Implemented ne tuning of database objects and server to ensure ecient data retrieval. EducationSouthern New Hampshire UniversityMaster of Science in Information Technology Manchester, NH JNTUBachelor of Technology in Electronics and Communication Engineering, India CertificationsMicrosoft Azure Data Fundamentals |