Azure Data Sql Server
Resume:
CANDIDATE INFO
H*B US Visa
**+ years in workforce
BE Computer Science
KEY SKILLS
ETL SSIS, SSRS.
MS-SQL, BI, DWH.
MS Azure Data Lake,
Azure Data Factory.
ACHIEVEMENTS
Certified with:
Appian Certified
Associate Developer
(Nov2022).
70-461: Querying
Microsoft SQL Server
2012 (Dec2014)
70-483: MS
programming in C#
(July2017).
70-519: Pro Designing
and Developing Web
Apps Using MS .NET
Framework.
PROFILE SUMMARY
Database Lead professional with 12+ years of rich experience with MS SQL, SSIS, SSRS, Data Warehouse, MS Azure, ETL, Business Intelligence, Azure Data Factory. SSIS and SSRS:
• Developed/Deployed new SSIS jobs to retrieve data from source, transform and transfer it to destination DB. Update, debug, test and maintain SSIS packages.
• Created new SSIS Solutions, projects, packages, ispac, dtsx files and performed their vice versa conversions.
• Deployment of SSIS Jobs/Packages in SQL Server Agent. Used PowerShell scripts to create SSIS jobs and their deployment. Handling Excel, File system, CSV, Text files.
• Implemented: Error and Exception handling, send emails alerts, SSIS jobs (manual/ scheduled), SSIS templates to reusable logic. Performed Data Mapping for data migration, data integration, production server configuration using config files.
• Demonstrated problem-solving capability, technical support, debugging, replicated issues in tickets, find root causes, and resolved them.
• Check SSIS job execution reports, find bugs/issues in execution reports, create and upgrade multiple versions of code, track versions, restore older/required version.
• Extract, transform, and load data using SSIS, upgrade SQL jobs/SSIS packages.
• Used SSIS controls: Send email, slowly changing Dimension, Expression Tasks, Script tasks, Execute Process Tasks, Loops and containers, Bulk Insert task, Multicast, Sort.
• Used Big bucket for code storage and used Harness, Jenkins for CICD deployments.
• Created/scheduled/customized/Automated SSIS job execution in DEV, UAT, PROD.
• Used SQL Reporting Services (SSRS) and crystal reports for creating reports.
• Created ETL specifications/ design/ release and deployment documents. MS SQL:
• Specialized in identifying database requirements, database design, SQL query development, debugging, testing. Adept at architecting scalable database solutions like Triggers, Joins, Unions, Stored procedures with parameters, Group by, Views, Index, CTE (WITH clause), Partition By, Having, Exists, Intersect, Except, Functions.
• Performed disaster recovery, system upgrades. Conducted performance tuning for SQL Server. Improved SQL performance by monitoring and optimizing queries. Client communication and Leading:
• Led the technical team; managed, evaluated, coached, and mentored team members. Coordinated with .NET developers, technical project managers and database developers to architect data structures and schemas.
• Strong client-facing and communication skills. Interacted with the client to understand project requirements and finalize its scope.
• Working independently, Requirement, Analysis, Estimation, design, and development, and maintain high performance software solutions. MS Azure: ETL using Data Lake Store Gen2, clusters, Data Factory. Develop, manage, configure, support to:
• Create Azure SQL DB, SQL tables, data sets, Authentication for SQL DB.
• Azure storages account, Blob, container, linked services.
• Create and publish pipeline, add trigger to pipeline.
• data pipelines in ADF using connectors, transformations, and activities.
• Multiple types of sources and sinks (MS SQL, CSV, Excel, Oracle.) Other: Big Bucket, Harness, Jenkins, Agile, Jira, Code review, TFS, Oracle, .NET framework, Develop .NET, VB6 applications, MS Access, Appian Certification. Work Experience
Mar’22 to current: Charles Schwab Southlake TX, USA as Technology Lead Project: EMOST Lower Environment: My role was to support, troubleshoot, find RCA, do deployments in UAT login for multiple applications using Splunk, PCF, Harness, Redbutton and Thousand Eyes. Dec’13 to Mar’22: Infosys Limited Pune, India as Technology Lead Project: SMART (SQL Server 2016, SSIS, Nifi-Kafka, Big bucket, Jenkins, .NET, Oracle, Agile, Jira).
Created, tested, deployed, and scheduled SSIS jobs with PowerShell scripts and manually.
Customize existing SSIS packages with error-handling capabilities and Sending emails using SP.
Created Nifi flow to fetch data from Kafka queues and transfer into SMART Oracle database.
Check SSIS job execution reports, find bugs/issues in execution reports, create and upgrade multiple versions of code, track versions, restore older/required version.
Extract, transform, and load data using SSIS, upgrade SQL jobs/SSIS packages.
Used SSIS controls: Send email, slowly changing Dimension, Expression Tasks, Script tasks, Execute Process Tasks, Loops and containers, Bulk Insert task, Multicast, Sort.
Used Big bucket for code storage and used Harness, Jenkins for CICD deployments.
Created/scheduled/customized/Automated SSIS job execution in DEV, UAT, PROD.
Leading the database development team and client interaction. Project/task Timeline estimation and code review. Manage, evaluate, coach and mentor the team members. Project: SMART (Azure Data Lake Store Gen 2, clusters, Data Factory, Azure SQL, Data Pipelines, linked services, jobs, storages accounts)
To Develop, manage, configure, support for:
Create Azure SQL DB, SQL tables, data sets, Authentication for SQL DB.
Azure storages account, Blob, container, linked services.
Create and publish pipeline, add trigger to pipeline.
Data pipelines in ADF using connectors, transformations, and activities.
Multiple types of sources and sinks (MS SQL, CSV, Excel, Oracle.) Previous Experience
Dec’11 to Sep’13: Euronet Services India Pvt. Ltd., Mumbai as Senior Developer Project Financial Accounting System (FA) (VB.NET, MS SQL, Crystal Reports)
Creating database objects and test data as per requirement. Debug and update code-based database objects. Worked on updating the stored procedures to handle the business logic.
To fix SQL issues and handle its user support. To develop and update reports using Crystal Report.
Developing patches and automation in code. SQL performance tuning, database design. Aug’10 to Aug’11: Greytrix India Pvt. Ltd., Mumbai as Software Developer Project: Tax Deducted at Source (TDS) (VB6, MS SQL 2005, Crystal Reports 8.5)
Perform Database Backup and recovery. Point in time recovery of database.
To fix issues in SQL code and database space management operations.
Created T-SQL scripts to take user defined and system databases backups.
Create basic SQL queries as a part of existing SP, SQL system upgrades.
Restored production database into UAT/Testing environments, identifying database requirements. Education: B.E. Bachelor’s degree in computer science engineering from Shivaji university, India (2008)
Contact this candidate