Rakesh Soni

Email ID: acxv7g@r.postjobfree.com Contact: 281-***-****

Professional Summary:

Extensively worked on SQL Server and Oracle databases

Strong experience on T-SQL and query optimization, developing ETL strategies.

Designed and created databases, tables, views, store procedures and triggers.

Experienced in writing complex TSQL Queries involving various tables using SQL joins and writing Sub Queries. Experienced in writing complex-SQL Stored Procedures and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports

Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert

Developing reports on SSRS on SQL Server (2000/2005/2008/2012 Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Expertise in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert, and Merge Join

Expertise in various phases of project life cycles (Design, Analyzing, Implementation and testing

Expertise in various phases of Software Development life cycle

Skills Summary:

Programming Languages:

Proficient in C++, C, MySQL, Python

SQL Server, SQL Management Studio, MS Visual Studio, MS Office, SSRS, SSIS.

Familiar with Hadoop, Apache Spark, Pig, Hive, HBase, Sqoop,

Familiar with Matlab

Software:

Dreamweaver, MySQL, MS SQL Server, MS Access.

Familiar with Visual Studio, MS Windows, Microsoft Word, Microsoft Excel, Microsoft Project.

Familiar with Linux operating system

Educational Details:

MBA in Management Information System at Dallas Baptist University

Professional Experience:

The Go Solution, Houston, TX Feb 2016 – Present

SQL Server Developer

The Go Solution is a nationwide marketer and retail service provider of home telecommunications, security and insurance products

Job Description:

Created databases for MS SQL Server 2008, MS Access.

Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.

Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.

Created T-SQL triggers and Stored procedures encompassing business rules.

Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.

Developed stored procedures and triggers to facilitate consistent data entry into the database.

Involved in migration of SSRS from SQL 2005 to SQL 2008.

Tested to optimize the Stored Procedures and Triggers to be used in production.

Monitored performance and optimized SQL queries for maximum efficiency.

Imported data from text files and excel spread sheets into SQL Server database using SSIS package.

Worked on various SSIS packages

Tenaris Houston, TX Aug 2015 - Jan 2016

SQL Server Developer

Tenaris is a leading supplier of tubes and related services for the world’s energy industry and certain other industrial applications.

Responsibilities:

Experienced in working with different tasks in SSIS.

Experience working with Different Sources and Destinations.

Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling

Work on Database Development using Transact-SQL Proven experience with SQL Server 2000/2005/2008/2012 Designing database.

Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.

Worked on designing relational data ware house.

Strong understanding of SQL Server design patterns.

Experience working with Data Analysis.

Analyzing and troubleshooting SQL Server performance issues, like slow queries, locks and deadlocks.

Design SQL Server Databases under strong and smart patterns.

Interact with programmers to ensure high quality of database design and queries.

Analyze and propose improvements to existing databases and queries.

Created SSRS Reports for different Mills.

Created Dashboards for showing the sales and profits of the company.

Design and develop T-SQL procedures, query performance tunings and SSIS packages.

Perform and execute data extraction, transformation and loading using ETL tools.

Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

Translate business requirements into software applications and models.

Mini Project: - FM radio signal transmitter. Study of signal which is transmitted in radio

•Final year project: Seed sowing robot with material handling using

Gloves (using flex sensor)

Contact this candidate