Sowmya Komatireddy

Ph no: +1-315-***-****

Email: ad4esz@r.postjobfree.com

PROFESSIONAL SUMMARY:

9+ years of IT experience with SQL Server database Development and Administration.

Migrate On-Premises databases to Azure SQL Database (PASS) and Azure SQL VM (IASS).

Experience in System Analysis, Development & Support of MS SQL Servers 2008/2012/2016 in Production, Development, Testing and Data warehouse Environment.

Experience in working with Windows 2016/2012/2008.

Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL Server Performance Alerts. Experience in configuring and deploying SSIS packages across all environments.

Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations and involved in package configurations and deployment process.

Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.

Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.

Experience in Creating Databases based on Functional Requirement and System Design.

Experience in Performance Monitoring and Tuning, Query Optimization, Client/Server Connectivity, resolving Blocking /long running queries/ Dead Locks, Database consistency checks using DBCC Utilities.

Expert in Implementing high availability features of SQL Server solutions, including Log shipping, Replication, Mirroring and Cluster Environment

Experience in Database Backup, Recovery and Disaster Recovery procedures in SQL SERVER and Design Tested and Implemented various Failure Strategies based on business requirements.

Experience in implementing Table Partitioning, CDS and Encryption features.

Experience in Supporting Development/Testing/Data warehouse/ Sysadmin Teams

Maintain Database Authentication mode, creation of users, configuring permissions and assigning roles and Profiles.

Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.

Experience in implementing business logic by using TSQL, Stored procedures, triggers.

Experience working in SAN network and RAID configure Environment.

Optimum Utilization of Operating System Resource to SQL Server

Involved in design of SQL triggers, and correcting database errors.

Experience in Automation of Schedule Maintenance jobs and defining Alerts.

Experience in Logical and Physical Database Design and Capacity Planning

TECHNICAL SKILLS:

Cloud Computing: Microsoft Azure - Cloud Services (PaaS & IaaS), Active Directory, Application Insights, Azure Monitoring, Azure Search, Data Factory, Key Vault and SQL Azure, Azure Devops, Azure Analysis services, Azure Synapse Analytics (DW), Azure Data Lake.

Database Development & BI Tools: SQL, T-SQL, SSIS, SSRS, SQL Server Management Studio (SSMS)

2016/2014, SQL Server Job Agent, Import and Export Data, Linked Servers, Oracle Exadata, Amazon Redshift.

IDE Tools: Visual Studio 2017/2015 TFS, IIS, Visio, SVN

Reporting Tools: SSRS, Power BI reports, Excel

PROFESSIONAL EXPERIENCE:

Client: Guidewire,Remote USA Oct 2022- current

Role: SQL Developer/Data Engineer

Responsibilities:

Implementation of data movements from on-premises to cloud in Azure.

Developed complex SSIS and Azure Data Factory pipelines for various reporting and data development projects.

Excellent T-SQL development skills, including the ability to write queries involving multiple tables.

Strong ability to develop and maintain complex Stored Procedures, User Defined Functions, and other SQL Objects using MSSQL server and Sybase.

Created different types of tabular reports like cascaded parameters, drill through, drilldown, sub-reports and matrix reports and developed some graphical reports using report designer.

Used power bi, power pivot to develop data analysis prototype, and used power view and power map to visualize reports.

Applied various data transformations like slowly changing dimension, aggregate, sort, multicasting, cache transform, conditional split and derived column etc.

Involved in extensive DATA validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.

Developed complex data models to support reporting requirements, ensuring optimal data retrieval and performance.

Proficient in writing efficient and maintainable SQL code for various data manipulation tasks and reporting needs.

Extensive experience in managing and optimizing Microsoft SQL Server databases, including performance tuning, indexing, and query optimization.

Demonstrated proficiency with SQL query writing, including complex joins, subqueries, and aggregations, with over 3 years of experience.

Designed and created reports using SQL Server Reporting Services (SSRS), presenting data in a clear and actionable format for stakeholders.

Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2016.

Generated parameterized reports, sub reports, tabular reports using SSRS-2016.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2016

Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2016.

Proven ability to design, implement, and maintain SQL Server databases for optimal performance and reliability.

Experienced in index management, query optimization, and database tuning to enhance overall system performance.

Extensive expertise in working with relational databases, including designing, and optimizing database structures to support marketing campaigns effectively.

Applied in-depth knowledge of database marketing principles to drive targeted and personalized marketing strategies, resulting in improved customer engagement and conversion rates.

OpenText Waterloo, Canada July 2016 – Aug 2022

Role: SQL Server /MS BI Developer

Responsibilities:

Designed MS SSIS Packages to extract data from various OLTP sources, Text Files, XML (Extensible Markup Language) Files, MS SQL Server 2012/2016, Excel and MS Access 2007 to EDW system (SQL Server 2016).

Experience in database administration (DBA) of MS SQL server.

Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.

Led successful database migration projects, ensuring minimal downtime and data integrity during the transition.

Wrote T-SQL queries with the help of Stored Procedures, Functions, Triggers, Cursors, Views, and Indexes.

Planned, Defined and Designed data based on business requirement and provided documentation.

Designed Database using Erwin data modeler.

Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.

Implemented robust data management practices, including data security measures and data hygiene procedures, to safeguard customer information and maintain data quality.

Proven expertise in creating and optimizing SQL queries for data analysis and reporting.

Extensive experience in leading legal, HR, and finance teams through data identification and interpretation activities.

Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.

Developed SSIS packages using uzzy Look Up and Fuzzy Grouping for data cleansing purpose.

Used SSIS Variables for storing the values which are used in various components of Data Flow Task.

Modified the existing SSIS packages to meet the changes specified by the users.

Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.

Created reports to retrieve data using Stored Procedures that accept parameters.

Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.

Responsible for Monitoring and Tuning Report performance.

Configured the report viewing security for various users at various levels using Report Manager

Fine-tuned SQL Queries for maximum efficiency and performance.

Provided documentation for all kinds of reports and SSIS packages.

Environment: MS SQL Server 2012/2016/2019, SSRS, T-SQL, SSIS, Team Foundation Server, Advanced Server, PowerBuilder 5, Erwin v8.0, ASP.Net, C#,I),ITSM.

Client: IBM Toronto, Canada Sep 2015 – Jun 2016

Role: MS SQL Server SSIS/SSRS/SSAS

Responsibilities:

Installing, Configuring and Maintenance of MS SQL 2012 and 2014 Server.

Routine Hourly, daily, weekly, and monthly database backups and rebuilding indexes and running of update statistics on PROD databases.

Developed Reports with different styles using Table Sub Reports and Matrix.

Performing Database administration and Management activities in a safe, recoverable, and professional manner that ensures the optimal operation at all database environments.

Monitor the database systems to ensure secure services with minimum downtime and testing and load testing.

Implemented Disasters Recovery plans to reduce the downtime of the SQL Server using Log shipping and mirroring and Replication models.

Successfully planned and executed direct marketing campaigns, utilizing data-driven strategies to effectively reach and engage target audiences for Walmart.

Design/Build Extract Transform Load procedures to import/export data feeds to/from data warehouse to populate the data using SSIS.

Created reports using SSRS in SQL server 2012 in various occasions and deployed for user’s access.

Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS).

Developed Report using SQL Server Reporting Services (SSRS).

Developed Reports by using Report Server Project Wizard Report Server Projects and Report Model Project.

Creating and maintaining users and roles, assign privileges, monitoring the online sales forecast and maintaining the security on retails websites.

Environment: MS SQL Server 2012, 2014, MS Access, Excel, SQL Query Analyzer, Enterprise Manager, DTS, SQL Developer, SSIS, SSAS, SSRS, MS Excel, IIS, .NET, Azure, Crystal Reports.

Client: Sushee Infra & Mining Limited, Hyderabad, India Feb 2013 – sept 2014

Role : Database Developer

Responsibilities:

Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Created the Load packages for loading the excel files into SQL Server using SSIS 2008 R2

Migrating databases from sql server 2008 R2 to sql server 2012.

Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.

Scheduled report and exported in PDF format.

· Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

· Used SQL Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.

Environment: MS SQL Server 2008 R2,MS SQL Server 2012, SSRS, T-SQL, SSIS, Visual SourceSafe, ASP.Net, C#.

Education: Bachelor of Engineering in Computer Science, Osmania University, Hyderabad, India

Contact this candidate