SQL developer
Resume:
Swetha Voruganti
**********@*****.***
BI/SQL DATAWAREHOUSE & AZURE DEVELOPER
A self-motivated and result oriented professional with 8+ years of development experience in SQL Server database, ETL and Reports in OLTP, OLAP, Client-Server & Enterprise Data warehouse Environments in various domains like Financial, HealthCare, Manufacturing and Retail.
Strong experience in database technologies – Snowflake, SQLServer(2012, 2014, 2016), PostgreSQL (9.6, 11, 13) and Oracle, Teradata, ETL tools – SSIS, Talend and Reporting tools – SSRS, PowerBI, Tableau.
Skilled at developing complex stored procedures, user defined functions, cursors, triggers, views, indexes, user profiles, relational database models and data dictionaries using SQL (TSQL, PLSQL, PSQL).
Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
Experience in troubleshooting performance issues using Query tuning, Index tuning techniques, redesigning data model and make decisions with help of execution plans.
Experience working different types of Azure functions such as HTTP trigger, Timer trigger, Durable functions, Service bus trigger, event-bus trigger and many others.
Experience with Azure logic apps with different triggers and worked on ISE environment in logic apps.
Experience with Azure Data factory to move data between various endpoints/services/databases.
Experience working with Azure Infrastructure provisioning, Database provisioning/configuration and storage accounts.
Experienced in SQL Server Integration Services Package - Development, Deploying, Scheduling, Troubleshooting and monitoring.
Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, Oracle, flat file) by using multiple transformations provided by SSIS like Data Conversion, Conditional Split, Bulk Insert, merge, union all.
Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Experience developing Visualization, Scorecard, Dashboard and Snapshot, Workday reports using various reporting tools like Tableau, PowerBI, SSRS, Crystal reports, HR Reports.
Expert in generating Drilldown reports, Parameterized reports, Linked reports, Sub reports and filters, Snapshot Reports, Visualization Reports (charts) in SSRS 2012/2014/2016.
Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
Excellent skills in Data Modeling using Power Designer & DB Schema and good knowledge of Star and Snowflake Schemas.
Experience in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
Experience in following software development life cycle (SDLC) models like Agile and Waterfall methodologies and used JIRA ticketing, Source/version control tools like TFS, GIT, SVN.
Excellent communication, presentation and interpersonal skills.
Ability to work in a team and as an individual with minimal supervision.
Education:
Bachelors in Engineering – Computer Science, JNTU University, INDIA
AREAS OF EXPERTISE
Category
Technology
Databases/ETL/Reports
Snowflake, SQL Server 2012/2014/2016 Enterprise & Standard editions. Oracle, PostgreSQL(9.6, 11)
T-SQL, PL-SQL, PSQL
Performance Tuning, Query optimization, Index tuning.
Monitoring - Perfmon Counters, Profiler, Extended events
ETL – SSIS, Talend.
Reports – SSRS, Tableau, PowerBI, Crystal and Excel Reports
Data Modeling tools - Power Designer, DB Schema
OS
Windows 2008/2012/2016, Linux – Ubuntu/RedHat
Languages
.NET, C#, HTML, PowerShell, Bash, Python
DevOps Tools/Methodologies
GIT, TFS, Jenkins, Docker, CI/CD tools, SDLC practices, Agile, Waterfall.
Cloud
Azure and AWS
Project Management
MS Office [Excel/Word/PowerPoint/Access/Visio], SharePoint, JIRA, Wiki.
EXPERIENCE
Jeffries, Raleigh, NC
Nov 2021- Current
Sr SQL BI/DWH Consultant
Jeffries is a global investment banking firm that has served companies and investors for over 60 years. The web and analytical applications we support provide services in equity, fixed income and foreign exchange markets.
Responsibilities:
Worked with the application developers and provide necessary SQL Scripts using T-SQL.
Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis.
Designed and created SQL Databases, tables, indexes, and views based on user requirements.
Create joins and sub-queries for complex queries involving multiple tables.
Created User Defined Functions, Stored Procedures, and Triggers.
Responsible for logical and physical data modeling, database design, data analysis, programming, documentation and implementation.
Worked with Cloud data platform team to move some of the data infrastructure like databases, FTP/SFTP to Azure.
Migrated few SSIS Packages to Azure data factory and redesigned the ADF with Json config.
Enabled Azure logic apps workflow to move files for various clients from existing FTP/SFTP to Azure storage and further processed data to azure databases thru ADF.
Moving our Kafka workload to Azure Service Bus to enable messaging service across all our applications.
Collaborated in dramatically increasing OLTP transactions on systems handling several billion transactions weekly through the implementation of advanced database techniques such as join optimization, table structure and fragmentation analysis, bulk inserts, analysis of indexes and locks, creation of custom timers to detect bottlenecks.
Implemented Common Table Expressions (CTE).
Created SSIS Packages using SSIS Designer; used various transformations like Derived Column, Merge Join, Union All, Conditional Split, Multicast, Data Conversion, Look Up to load the data from OLEDB Source, Excel Source and flat file extracts into SQL Server 2012 database to perform initial and quarterly loads.
Created highly complex SSIS and Talend packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
Converted data types using
Derived Column, Data Conversion Transformation in SSIS and Talend.
Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions and Perspectives using SSAS 2008 R2, 2012.
Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading nested JSON formatted data into snowflake table.
Extensive Experience on Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS.
Perform testing, working closely with HR and IT to validate data accuracy.
Assist in the establishment of a HR Data/Report Governance and best practices and procedures for Business Intelligence tools and architecture.
Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS) and Tableau.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Strong Experience with Workday Report Writer - Custom Reporting (Calculated Fields, Advanced, Standard Reports)
Restricted data for particular users using Row level security and User filters.
Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.
Capable of processing large sets of structured, semi-structured and unstructured data and supporting systems application architecture.
Able to assess business rules, collaborate with stakeholders and perform source-to-target data mapping, design and review.
Reviewed and Analyzed the Business and Functional Requirement Documents.
Good working knowledge on Agile Projects.
Environment: Windows server 2012/2008R2, Snowflake, MS SQL Server 2012/2014/2016, Teradata Sql, Business Intelligence Development studio (SSRS and SSIS) Talend, PowerBI and Visual Studio, Tableau, Workday, MS Excel, Tabular Model, HR Report, TFS (Team Foundation Server 2010).
VillageMD, Chicago, IL
July 2020- October2021
Sr SQL BI/DWH Developer
VillageMD is a health care organization which provides Value based primary care. We develop Analytical, Web and mobile solutions that are used by Providers and Payers to deliver supreme patient services.
Responsibilities:
Extensive use of T-SQL DDL and DML commands for various applications.
Implemented an extra level of security by creating views and creating stored procedures to query the confidential data.
Created Talend Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
Extensive Experience on Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
Developed Full Analysis Life Cycle Project.
Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
Generated reports using SSRS 2005 from OLTP and OLAP data sources.
Consulting on Snowflake Data Platform Solution Design, Development and deployment focused to bring the data driven culture across the enterprises.
Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
Strong Experience with Workday Report Writer - Custom Reporting (Calculated Fields, Advanced, Standard Reports)
Used Micro strategy to produce daily reports required for the analysis of Process managers.
Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
Perform testing, working closely with HR and IT to validate data accuracy.
Assist in the establishment of a HR Data/Report Governance and best practices and procedures for Business Intelligence tools and architecture.
Worked with analysts and management to develop an overall dashboard for Director and specific dashboards for each Division Manager to be able to monitor performance of the processes for which they are responsible.
Used good code migration practices by doing all development and testing in a development environment, user Acceptance Testing in a QV environment and moving into the Production.
Provide training and documentation to end users for everything we develop.
Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
Environment: Windows server 2008/2008R2/2012, Snowflake, MS SQL Server 2008/2012/2014, Teradata Sql, Business Intelligence Development studio (SSRS and SSIS) Visual Studio, Talend, Power BI, Workday, HR Report, Microsoft.NET, MS Office Access 2010, VBScript, DB Schema and Visio.
Wells Fargo Financial Services, Chicago, IL
May 2017- June 2020
Sr SQL BI/DWH Developer
Wells Fargo & Company is a diversified financial services company providing banking, insurance, investments, mortgage, and consumer and commercial finance.
Responsibilities:
Efficiently used Microsoft SQL server 2005/2008/2008 R2/2012, SQL server management studio.
Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis.
Used SQL server business Intelligence Development Studio to design SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
Designed DTS/SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server 2005/20082005/2008/2008 R2/2012 environment.
Generated reports using SQL server Reporting Services, and created user friendly templates, indexes, using xml.
Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
Generated reports using SSRS 2005 from OLTP and OLAP data sources.
Identified and included report parameters.
Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
Created Cube in Tabular model, created hierarchies in VS 2012 for Cube.
Conducted Performance tuning/MS SQL server development - SQL Profiler and PerfMon, SQL scripts, stored procedures, triggers, functions and transactions analysis.
Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
Environment: VS2005/2008/2008R2, Snowflake, MS SQL Server 2008/2008R2/2012, Reporting Services (SSRS 2005/2008/2012), Business Intelligence Development Studio (BIDS), SSIS/DTS, Visual SourceSafe, DTS, OLTP and OLAP, Enterprise Manager, Query Analyzer, SQL Profiler, VSS.
R1 RCM (Accretive Health), Chicago, IL
June 2015- April 2017
SQL BI/DWH Developer
Accretive Health is a Revenue Cycle Management company servicing Hospitals, Physician groups and health systems across US. EI project mainly focus is on Data ingress process among all the business units, process must have the ability to Data Acquisition, Data standardization and Validation etc. EDW Project, Creating the Dashboard reports regarding the customer survey results, specific to their enrolled services, designing the Dashboard Report structures.
Responsibilities:
Efficiently used Microsoft SQL server 2005/2008, SQL server management studio.
Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis.
Used SQL server business Intelligence Development Studio to design SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
Designed DTS/SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server 2005/2008 environment.
Generated reports using SQL server Reporting Services, and created user friendly templates, indexes, using xml.
Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
Identified and included report parameters.
Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
Conducted Performance tuning/MS SQL server development - SQL Profiler and PerfMon, SQL scripts, stored procedures, triggers, functions and transactions analysis.
Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
Manulife Insurance (Value Labs)
Oct 2013- May 2015
Database Developer
Responsibilities:
Involved in complete Software Development Life Cycle.
Worked with the application developers and provide necessary SQL Scripts using T-SQL.
Designed and created SQL Databases, tables, indexes, and views based on user requirements.
Create joins and sub-queries for complex queries involving multiple tables
Created User Defined Functions, Stored Procedures, and Triggers.
Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
Experience in creating complex SSIS packages using proper control and data flow elements.
Created data loads and Performed Data validations
Created packages in SSIS with error handling.
Worked with different methods of logging in SSIS.
Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
Reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
Generate various ad hoc reports using MS Reporting services.
Deployed and generated reports on to the server using the Reporting Services Report Manager.
Environment: SQL Server 2008/2008R2/2005, Query Analyzer, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.
Contact this candidate