CANDIDATE INFO

H*B US Visa

**+ years in workforce

** ***** **** *** **

** ***** **** *******

BE Computer Science

KEY SKILLS

MS Azure Data Lake,

Azure Data Factory.

MS-SQL, BI

ETL SSIS, SSRS

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 Data Warehouse, MS Azure, ETL, Business Intelligence, Azure Data Factory clusters, MS SQL, SSIS, SSRS. 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.) MS SQL:

• Specialized in identifying database requirements, database design, SQL query development, debugging, testing. Adept at architecting scalable database solutions and Views, Index, Triggers, Joins, Stored procedures with parameters.

• Performed disaster recovery, system upgrades. Conducted performance tuning for SQL Server. Improved SQL performance by monitoring and optimizing queries. 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.

• Deployment of SSIS Jobs/Packages in SQL Server Agent. Used PowerShell scripts to create SSIS jobs and their deployment. Handling Excel, 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.

• SQL Reporting Services (SSRS) and crystal reports. Automated SSIS job execution.

• Created ETL specifications/ design/ release and deployment documents. 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. Other: Jira, Code review, TFS, Oracle, .NET framework, Develop .NET, VB6 applications, MS Access, Appian Certification.

STRENGTHS

MS Azure, Data Factory, Data Lake Store Gen2, clusters, Pipelines, jobs. SQL Database Design and all types of queries with administration. ETL, SSIS, SSRS and Crystal report creation.

Snehal Magadum

ad4q78@r.postjobfree.com

+1-945-***-****

Valley Ranch Parkway West,

Irving, Texas, 75063.

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 (Azure Data Lake Store Gen 2, clusters, Data Factory, Azure SQL, Data Pipelines, jobs, linked services, storages accounts)

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.) Project: SMART (SQL Server 2016, SSIS, Nifi-Kafka, .NET, Oracle, Agile).

Created, tested, deployed, and scheduled SSIS jobs with PowerShell scripts and manually.

Customize existing SSIS packages with error-handling capabilities.

Developed ETL packages for data Extraction, multiple Transforms and Load.

Created SSIS deployment scripts and technical documentation and Sending emails using SP in SSIS.

Created Nifi flow to fetch data from Kafka queues and transfer into SMART Oracle database.

Leading the database development team and client interaction. Project/task Timeline estimation and code review. Manage, evaluate, coach and mentor the team members.

Get requirement from Business, analyze, get inputs/clarifications for doubts. 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) Personal Details: Date of Birth: 15th Feb 1986; Languages Known: English, Hindi, and Marathi.

Contact this candidate