Project 1 Ssis

Samanvitha V

PROFESSIONAL SUMMARY

** ***** ** ** ********** as a software engineer which includes Software Development, Data Extraction, Business Intelligence, Performance Tuning, ETL Development, MS SQL Server, SSIS, SSRS, SSAS, MSSQL, C#, Ado.Net, ASP.NET, GIT HUB, Jenkins.

Highly skilled and experienced in agile process for diverse applications.

Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.

Extensive knowledge of Normalization and Relational Database Management Systems.

Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).

Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008r2/2005/2000.

Great ability to create and manage various database objects like tables, views.

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.

Strong Database skills in MS SQL servers, C#, ASP.NET, SSIS, SSRS, SSAS.

In depth knowledge on Transact SQL. DDL, DML, creating indexes Views, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.

Experience in Microsoft Visual C# in script component of SSIS.

Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, User-defined Functions, Views and Cursors.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Developing experience and understanding of SSAS, OLAP cube and Architecture.

Experience in Data Extraction, Transforming and Loading (ETL) between various systems using SSIS.

Experience in code repositories like GIT.

Worked on Autosys. Have knowledge in creating and monitoring Autosys Jobs.

Have basic knowledge on Jenkins.

Worked with onshore teams to coordinate with the development process.

Involved in designing and updating the application documentation as required.

Excellent knowledge of software development life cycle

Technical Expertise

Operating Systems Win 2008/2010 server.

RDBMS MS SQL SERVER 2008/2010/2012,Oralce.

Database Tools SQL Enterprise Manager, Management Studio,

SQL Server 2005, Query Editor, SSAS.

ETL Tools Data Transformation Services (DTS), MS SQL Server Integration Services

(SSIS)

Reporting Tools MS SQL Server Reporting Services (SSRS), Power BI.

BI Tools MS SQL Business Intelligence, Business Objects.

Programming Languages C#, Ado.Net, Asp.Net, and XML.

Professional Experience

Majesco Insurance, KPMG March 2020 – Till Date

Majesco is an application dedicated to managing all insurance data, where Data is enslaved from upstream .Using the data received from upstream values for all the parameters is calculated and will feed the down streams. Application is mainly required to transform raw data to the final estimate.

Key Contributions:

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.

Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Created custom tasks in ETL packages.

ETL, data profiling, data quality and clean ups for SSIS packages.

Involved in creating DB structures along with Architect.

Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.

Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.

Create, test and document the test scenarios.

Implementation of Complex Stored Procedures, CTE, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.

Technologies Used : SQL Server 2012, SSIS, ADO.Net, C#, POWER BI

SOCIETE GENERALE GSC April 2018 – March 2020

Sr MSBI/SQL Developer

EUREKA, is an application dedicated to referential management on controlling data management. Data is enslaved from upstream for main axis .For managing private axis required for management controlling applications and used for reorganization of tasks .Application is mainly required to centralize all referential data in single application and to centralize the modifications and then to downstream applications of the domain.

Key Contributions:

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

Wrote efficient stored procedures for the optimal performance of the system.

Monitored performance and optimized SQL queries for maximum efficiency.

Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.

Created indexed views and appropriate indexes to reduce the running time for complex queries.

To keep track of data manipulations using Audit functionalities.

Generated custom and parameterized reports using SSRS.

Created reports that call sub reports in SSRS.

Worked on MDS implemented stored procedures to integrate data with MDS DB.

Worked on Autosys job’s creation.

Provides technical documentation of the changes in given user story/bug.

Implementation of Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.

Created and managed OLAP cubes using SSAS to feed to Power BI.

Actively supported Business users for change requests and provide support to team members.

Technologies Used : SQL Server 2012, MDS, SSIS, SSAS, ADO.Net, C#, POWER BI

Thomson Reuters Jan 2017 – April 2018

Sr SQL Server/SSIS Developer

IRC (Investment Research Content), is an estimates delivery System Delivers detailed and summary (or consensus) analytics for estimates and actual. Thomson Reuters culls estimates from sell-side research and gets actuals from company statements; from both, we create analytics that help the buy-side make smart investment decisions quickly. Investors are the buy-side money managers who purchase and use sell-side (retail brokers and research departments that sell stocks and write research)data. A research document is an opinionated assessment of an individual company, industry or region and usually includes an estimate about future earnings as well as a recommendation to buy, hold, or sell.

Key Contributions:

Responsible for the systems study, analysis, understanding systems and design.

Implementation of MS SQL Server 2010/2012 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.

Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures.

Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes

Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Developed, deployed, and monitored SSIS Packages.

Worked on SSIS Package, DTS Import/Export for transferring data from Database (Text format data) to SQL Server.

Technologies Used : SQL Server 2012, SSIS, SRRS, ADO.Net, C#.

Original Equipment Manufacturer (OEM) is one of the biggest channels of software sales which generates high revenue for Microsoft. There is a huge supply chain management network which comprises of complex, Time critical applications which needs real time support and maintenance. This project comprises 40 mission critical applications based on Revenue, Sales, License verification, Processes, Billing/Invoice.

Key Contributions:

Involved in designing the application as required.

Implemented Data Access Layer using ADO.NET to connect and retrieve or manipulate database information.

Implemented Triggers for checking complex business conditions, providing security for the tables.

Physical Implementation of database into SQL Server using T-SQL.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.

Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.

Involved in migration of SSIS Packages 2008 and troubleshoot migration issues.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Involved in creating SP’s and Jobs.

Provided support by troubleshooting and solving the issues.

Technologies Used : SQL Server 2012, SSIS, ADO.Net, C#

Project 1 : OA

Technologies Used : ASP.Net, C#, SQL Server 2012, SSIS, SQL Profiler

Role : SQL/SSIS Developer April 2012 – Nov 2015

OEM Activation 3.0 is a highly secure, unique identifier that enables a new Microsoft technology platform to support efficient and secure validation of genuine Windows. OEM Activation 3.0 will reduce OEM configuration burden and overhead. OEM Activation 3.0 will reduce these frictions and drive improvements, efficiencies, and cost savings for our OEM partners. Today, Microsoft’s ability to detect the misuse of Windows is limited, but by binding software and service entitlements to hardware, Microsoft can confidently provide customers with immediate identification of genuine products and services.

Key Contributions:

Developed and Optimized Stored Procedures and Functions using T-SQL

Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic sql, Merge statements. Built and monitored indexes to bring down processing times

Created and scheduled SQL Agent jobs

Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.

Involved in data transfer using Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Education

Bachelor of Technology, Siddarth Institute of Engineering Technology, Puttur (JNTU ).

Contact this candidate