Soumya V
ad5gev@r.postjobfree.com
Professional Summary:
Information Technology Professional with 6 years of strong experience as an SQL BI, Power BI, Tableau, and Visual Studio developer.
Strong experience in SQL development, ETL development using Microsoft SQL server integration services (SSIS), Azure Data Factory, reporting solutions utilizing Microsoft SQL server reporting services (SSRS), Power BI, and Tableau.
Extensive knowledge and experience in dealing with relational database management systems, including normalization, stored procedures, views, constraints, querying, joins, keys, indexes, data import/export, triggers, and functions.
Expert in creating SSIS packages for ETL processes from various data sources like Oracle, Excel, CSV, and SQL Server.
Extensive experience delivering OLAP solutions by developing corporate dashboard reports utilizing SQL server reporting services (SSRS), and Power BI.
Experienced in developing drill-down SSRS reports to generate daily, weekly, and monthly reports for customers.
Utilized Power BI to create reports by connecting to a SQL Server database.
Experienced in hands-on development of multiple dashboards and reports using Power BI.
Excellent interpersonal and communication skills, and I am ready to tackle challenges.
Technical skills:
SQL Server Tools
Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS
Database
MS SQL Server 2019, 2016, 2014, 2012, MS-Access, Oracle, Essbase, FoxPro, Teradata, Azure
Language
C#, T-SQL, PL/SQL
Operating System
Microsoft Windows
Reporting Tools
MS Reporting Server (SSRS), Tableau, Power BI, QlikView, Crystal Reports
Architecture
Relational DBMS, Client-Server Architecture, OLAP, OLTP
Data warehouse Tools
OLAP, SQL data transformation services (DTS)
Education:
Bachelors in Computer Science & Engineering, GITAM University, Hyderabad, India
Professional Experience:
AT&T, Millington, NJ Oct 2021 -Jan2023
Role: SQL BI Developer
Responsibilities:
Worked with business group in identifying the requirements
Created database objects including schemas, complex stored procedures, user defined functions, tables, views, indexes, SQL joins, constrains on SQL server 2019
Created Entity-Relationship diagrams on SQL server
Created deployment scripts after the development are done for project
Worked on performance tuning and query optimization
Extensively worked on views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design
Using business intelligence development studio (BIDS) created dynamic ETL SSIS packages to validate, extract, transform and load data from different sources into SQL server
Worked on huge data transfers to SQL server databases using SSIS
Transferred data from dev to test and test to prod based on the requirement
Created ETL load process using SSIS
Used SSIS to extract data from Salesforce to SQL server using kingswaySoft Salesforce components
Created batch load process to transfer millions of records between tables on SQL server 2019 and 2016
Created SQL server agent jobs and automated based on the requirement
Worked on loading spatial data from precisely to SQL server 2019
Worked on creating spatial relationship between address and spatial data
Created spatial index based on the requirement
Created tabular, matrix, chart, drill down reports, and parameterized, cascaded reports according to business requirement using SSRS
Documented for all kinds of reports and SSIS packages
Created dashboards based on business requirements using Power BI
Collaborated with database administrators to optimize database performance and query tuning, enhancing the efficiency of Crystal Reports' data retrieval process
Troubleshot and resolved Crystal Reports issues
Integrated Crystal Reports with databases and data sources
Created data visualizations (e.g., charts, graphs) for data clarity using Crystal Reports
Maintained DB schema and code change management using TFS
Tools and Technologies: SQL Server 2019, 2016, SSIS, SSRS, Crystal Reports, Teradata, Excel, C#, T-SQL, PL/SQL
Accenture/India Dec 2017- Sep 2021
Role: SQL BI Developer
Responsibilities:
Created star schema and snowflake schema based on the requirement in SQL server 2016
Created stored procedures, joins, views, tables, triggers, functions, indexes, security, service catalogs, SQL agent jobs and database structure
Used batch load process to transfer millions of records between the tables
Automated data loads using task scheduler from Oracle to SQL server
Automated the SSIS packages using the SQL Server Agent Jobs
Imported various files provided by the clients into SQL server
Imported data from Teradata to SQL server using script task component
Used SSIS to extract data from different data sources to SQL server
Created a process to import data from SQL server to FoxPro database
Used SSIS and Alteryx to extract data from different data sources to SQL server
Extensively worked on BCP (bulk copy), data migration, data conversions, data extraction/ transformation/loading (ETL) using SSIS/Alteryx, Oracle and PL/SQL
Worked on all activities related to the development, implementation, organization and support of ETL procedures for large scale data warehouses using SQL server SSIS and Alteryx
Created reports using SSRS, QlikView and Tableau
Created tabular, cross-tab, conditional, matrix, chart, drill down reports, and parameterized, cascaded reports according to business requirement using SSRS
Designed, developed, tested, and maintained Tableau functional reports based on user requirements
Converted existing SSRS reports to Tableau dashboards
Developed Tableau data visualization using Cross tabs, Heat maps, Geographic Map, Pie Charts and Bar Charts
Interacted with business users to gather requirements and provided guidance for data warehouse team in how to structure data for optimal use in Tableau
Developed Power BI reports and dashboards from multiple data sources using data blending
Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density charts
Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
Troubleshooted the SSIS/SQL job agent whenever necessary
Involved in data migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, and SSIS
Experience with source code control system GIT
Used TFS to maintain database change and updated TFS everyday based on DB changes
Tools and Technologies: SQL Server 2016, SSIS, SSRS, Oracle, Teradata, Essbase, FoxPro, Alteryx, Excel, QlikView, Tableau, Power BI, SQL Azure, Azure Data Factory, C#, T-SQL, PL/SQL
Entersol Technologies (India)
Role: SQL BI Developer (Intern) May 2015 - June2016
Responsibilities:
Designed, reviewed, and created objects (views, indexes etc.) based on logical design models, user requirements and physical constraints
Wrote various T-SQL queries, stored procedures and used them to build packages
Created triggers, tables, views and SQL joins for various applications
Experience in using SQL server 2008 tools like SQL server management studio, SQL server profiler, SQL server agent, and database engine tuning advisor
Designed SSIS packages to transfer data from various sources like text files, XML files, Excel, flat files to SQL server 2008
Involved in building and maintaining SSIS packages to import and export the data from various data sources using BIDS based on the design data models
Used SSIS to create ETL packages, validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
Designed, developed and deployed reports in MS SQL server environment using SSRS 2008
Generated sub-reports, drill down reports, drill through reports and parameterized reports using SSRS
Created reports to retrieve data using stored procedures that accepts parameters
Tools & Technologies: SQL Server 2008, SSIS, SSRS, MS Access, Excel, T-SQL, PL/SQL