Sql Server Integration Services
Resume:
Sravani Solasa
Summary:
Over ** Years of experience in database design, development, analysis, testing, performance optimization and documentation.
Experience with latest versions of SQL Server, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS).
Experience in Extracting, Transforming, and loading the data using SQL Server Integration Services (SSIS) between homogenous and heterogeneous systems. Also importing and exporting data from excel, flat files to SQL server using BCP utility and DTS packages.
Knowledge in Microsoft Visual C# in script component in SSIS.
Experience in maintenance and Administration of SSIS by creating jobs, Alerts, SQL Mail Agent, and schedule packages through SQL Server Agent.
Extensive experience with SQL Server Reporting services (SSRS) in design, development and deployment of different kinds of reports: simple, parameterized, drill-down, ad hoc, linked, snapshot, Crosstab, sub reports etc.
Hands on experience in scheduling the reports and subscriptions using report manager in SSRS.
Expertise in writing and evaluating complex T-SQL queries using Joins, Stored Procedures, Triggers, Tables, Functions, Sub-queries, Cursors, and Views etc. in MS SQL Server database.
Expertise in writing T-SQL DDL, DML and Transactional queries in SQL Server database.
Strong experience in Query optimization techniques, Performance tuning in SQL server.
Have knowledge on BIRT Reporting tool, Data warehouse concepts and Database Administration.
Strong Knowledge on developing front end web pages using ASP.Net and VB.Net.
Strong experience in MS Access, Word, Visio, Excel (Pivot, Macros etc.), Excel Macros with Excel VBA.
Worked in Agile/SCRUM based environment. Used JIRA for bug tracking, issue tracking and Project Management.
Worked with Azure SQL Database (Paas) on cloud, configured and created the databases. Using Database Migration Assistant upgraded existing sql server to Azure SQL
Solid experience in creating and developing responsive web applications using both VB and ASP.Net Applications.
Experience in developing web applications using client server architecture with ASP.Net core, Entity Framework, Angular Typescript.
Experience in all phases of the Software Development Life Cycle (SDLC) including analysis, design, development, testing, implementation, and maintenance of client/server database driven applications.
Experience in creating reports using Telerik Reporting tool. Deploying the Telerik reports to Horizon Application.
Education:
Masters in Computer Science with Dr MGR Educational and research Institute (2010)
Bachelors of Computer science with Andhra University (2007).
Client: Sacramento Area Sewer District
Location: Sacramento, CA
Role: SQL Server/SSIS/SSRS Developer July 2014 –Till date
Description: Supporting one million people in Sacramento by providing sewer utility service. As a SQL Server SSIS/SSRS developer I am responsible for loading the business data into various database tables using ETL (SSIS) and also design, develop and providing various kinds of reports as per the business requirements.
Responsibilities:
Worked closely with the Business Analysts/Engineers/Vendors in gathering requirements and providing services as required.
Experience in writing and managing T-SQL queries - stored procedures, indexes, views, UDFs, Database Constraints to meet business requirements and policies.
Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
Created and developed SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.
Created SSIS packages to extract data from multiple access databases into SQL Server databases, and created SSRS reports using these database tables.
Worked on SSIS packages for transferring data from one database to the other database.
Design, developed and deployed reports using SQL Server Reporting services.
Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
Worked on scheduling the reports as required using normal and data driven subscriptions.
Created and deployed the reports in web portals and in share point sites as required.
Involved in migrating of SSRS reports to latest versions.
Worked on documenting the process of various kinds of reports and database architecture.
Used Report Builder to create Ad-hoc reporting.
Ability to perform VB.Net Programming.
Creating applications using vb.net and enhancing projects for .Net applications.
Implemented changes in coding and designs using Knowledge of Vb.Net and ASP.Net.
Creating Excel Macros with Excel VBA to import the data from SQL Server to the Spreadsheet.
Creating Excel Macros with Excel VBA to validate the SQL Server data with Spreadsheet data and send the email to users if there is a data mismatch.
Create and maintain Excel Spreadsheets and Macros.
Worked on JIRA for bug tracking, issue tracking and Project Management.
Designed and Developed Entity Framework Code-First approach with Repository-Pattern based, blackened and used Web API as transaction and communication technology to the client side.
Developed ASP.Net Core Web API based on departmental requirements and specifications.
Worked with advanced concepts of ASP.Net core MVC such as Models and Providers, Filters used for developing backend technology.
Implemented convention-based CRUD actions like GET, POST, PUT and DELETE.
Experience in testing the Web API application using Postman tool.
Used LINQ to Entities, LINQ to SQL to retrieve the data proficiently.
Designed and created models, components, modules, and services to apply client-side logic and dependency injection using Angular 8.
Developed front-end of the web application using Angular, HTML, and Bootstrap and pushing the code to Bitbucket.
Implemented various Angular Typescript directives, filters, routing, and services to implement better application functionality and performance.
Experience in working with GIT Source Control and migrating the code from Source Gear Vault to Bitbucket.
Experience in creating reports using Telerik Reporting tool.
Deploying the Telerik reports to Horizon Application.
Knowledge in creating reports using Power BI tool.
Environment: SQL Server 2019, Visual Studio 2019, SQL Server Reporting Services, SQL Server Integration Services, Telerik Reporting tool, T-SQL, Windows platform, .Net core, ASP.net, VB.net, Microsoft.net Framework 3.5/6.0, Angular 14, MS Access, MS Office, Excel, IBM Maximo, SharePoint Designer.
Client: Tennessee Valley Authority
Location: Chattanooga, TN
Role: SQL Server/SSIS/SSRS Developer Jan 2014 – June 2014
Description: The Tennessee Valley Authority is the nation's largest public power provider and a corporation of the U.S. government. The Tennessee Valley Authority, a corporation owned by the U.S. government, provides electricity for 9 million people in parts of seven southeastern states at prices below the national average. About 30 percent of TVA’s power supply comes from its nuclear plants. I am responsible in requirements gathering from business users and also worked with the CAP team through Agile Methodology.
Responsibilities:
Worked closely with the Business Analysts/Engineers/Vendors in gathering requirements and providing services as required.
Created SSIS Packages for file transfer from one location to the other using FTP task.
Created reusable SSIS packages to extract data from flat files, Excel, Access into SQL Server databases.
Designed and developed SSIS packages to move data from Production environment to different environments with in Organizations.
Extensively used SSIS to move data from text files to SQL Server.
Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load using Visual Studio.
Worked closely with CAP team in gathering the requirements and also done the mapping between the attributes in Maximo application and Cognos reports.
Converted all the existing Cognos reports into the SSRS reports.
Experience in writing and managing T-SQL queries - stored procedures, indexes, views, UDFs, Database Constraints to meet business requirements and policies.
Design, developed and deployed reports using SQL Server Reporting services 2005/2008/2008R2/2012.
Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
Created report model projects as per the requirements using Report builder in SSRS and provided for end users.
Worked on scheduling the reports as required using normal and data driven subscriptions.
Created Sub reports which were called from the main report to implement the business logic.
Worked closely with SQL Admins for installing and configuring the SQL server databases and SQL Server Reporting services (SSRS).
Worked on importing the work orders data from spreadsheets into the IBM Maximo.
Environment: SQL Server 2008R2/2008/2005, Visual Studio 2008, SQL Server Reporting Services, SQL Server Integration Services, Crystal Reports T-SQL, Windows platform, ASP.net, VB.net, Microsoft.net Framework 3.5, MS Access, MS Office, Excel, IBM Maximo, SharePoint Designer 2007.
Client: Shire Pharmaceuticals
Location: Wayne, PA
Role: SSRS Developer/SQL Developer Oct 2013 – Dec 2013
Description: Shire is a global biopharmaceutical company that works closely with specialist physicians, nurses, pharmacists, and other healthcare professionals to develop and market medicines that aim to improve quality of life for patients. As a SQL server reporting developer I am responsible for design, develop and providing various kinds of reports as per the business requirements.
Responsibilities:
Worked closely with the Business Analysts/Application owners/Vendors in gathering requirements and providing services as required.
Experience in writing and managing SQL queries - stored procedures, indexes, views, UDFs, Database Constraints to meet business requirements and policies.
Design, developed and deployed reports using SQL Server Reporting services 2005/2008/2008 R2.
Based on the requirements developed and provided weekly, monthly, yearly quality control reports.
Represented reports in different forms using graphs, charts, tabular, area and pie charts as required.
Created report model projects as per the requirements using Report builder in SSRS and provided for end users.
Applied validations to several controls to validate the user input in the web forms using ASP .Net.
Worked with finance people to compare values from different spread sheets, add formulas to the base spreadsheet to calculate the values based on other spread sheets. Adding and deleting the rows open and close the spreadsheets format the colors based on the values using Macros.
Worked on SQL Server Integration Services (SSIS) for migrating data from one or more databases to other databases.
Used different tasks and transformations in designing the SSIS packages and executed/deployed them as required.
Worked closely with SQL Admins for installing and configuring the SQL server databases and SQL Server Reporting services (SSRS).
Environment: SQL Server 2008R2/2008/2005, Visual Studio 2008, SQL Server Reporting Services, SQL Server Integration Services, T-SQL, Windows platform, ASP.net, VB.net, Microsoft.net Framework 3.5, MS Access, Macros, MS Office, Excel, SharePoint Designer 2007.
Client: HSBC
Location: Hyderabad, India
Role: SQL Developer April 2009 – Sep 2010
HSBC provides a full range of commercial and individual banking products and services. The project was to create client solutions that automate business process by sharing data with different systems in the bank.
Responsibilities:
Designed the database, tables and Procedures.
Designed the database schema using third party tools like Erwin.
Created Stored Procedures, Functions, Triggers, and Views, to meet the business requirements using T SQL.
Solved problems by reconfiguring parameters, creating/rebuilding Indexes, running DBCC commands and recompiling Stored Procedures.
Installed SQL server 2000 and 2005 applied service packs and security patches.
Imported data from text files and excel spreadsheets into SQL Server 2000/2005 databases using DTS/SSIS packages.
Environment: SQL Server 2005/2000/7.0, Unix, T-SQL, Enterprise Manager, Query Analyzer, MS Access, MS office, SSIS, SSRS, MS Reporting Services, DTS, Erwin 4.0.
Contact this candidate