Data Analyst Ssis

Name: Navaneethan S

Mobile : +91-967******* E-mail: addav7@r.postjobfree.com

Professional Summary

* ***** ** ********** ** Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments.

Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Integration Services and having knowledge in SQL Server Reporting Services 2008.

Experience in maintaining one to many and many to one relationships while moving data between two databases

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

Handled Performance Tuning and Optimization on MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments.

Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.

Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

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

Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.

Experience in ETL processes involving migrations and in sync processes between two databases.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2008/2016).

Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

Strong knowledge in project life-cycles (from requirements to project closure), software development life cycles

(SDLC), software process methodology, and product deployment. Followed and implemented Agile-Scrum Methodologies.

Experience in creating configuration files to deploy the SSIS packages across all environments.

Work collaboratively to isolate problem domains and implement simple and repeatable solutions.

Strong Communication Skills, Interpersonal skills and team player.

Strong debugging and problem solving skills with excellent understanding of system development methodologies, techniques and tools.

Educational Details

Course

Board/University

Year

CGPA/Percentage

B.E. (Electronics& Communication Engineering)

Sri Venkateswara College of Engineering, Kancheepuram.

2017

7.83

HSC

St.John’s Matriculation Higher Secondary School,Mandaveli,Chennai-600028

2013

93.5%

SSLC

St.John’s Matriculation Higher Secondary School,Mandaveli,Chennai-600028

2011

87.4%

Skill Set:

Tools: MS SQL Server Studio, MS Office

Database: MS SQL server, SSIS,MS Access

Programming: C,C++,SQL

Professional Experience:

Accenture-2017-Present

Project: Pfizer

Role : MSBI/SQL Developer

Description: OSCAR is a capacity planning and forecasting tool used in Pfizer to forecast the component items needed for manufacturing a medicine and report to the user. Basically the application built on .NET application whereas all the data of customers are maintained in MS SQL server database/ETL, SSIS.

Roles & Responsibilities:

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008/2016 and SSIS in Business Intelligence Development Studio (BIDS).

Involved in creating multiple parametrized stored procedures which were used by the reports to get the data.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Involved in the Migration of Databases from SQL Server 2008 to SQL Server 2016.

Prepared the complete data mapping for all the migrated jobs using SSIS.

Developed, deployed, and monitored SSIS Packages.

Created databases and schema objects including tables, indexes, views and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.

Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.

Involved in Staging Partitions and Usage Based Optimization mechanisms for SSAS 2012 and 2008 OLAP databases.

Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.

Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.

Interacted directly with the onsite client for the requirement gatherings.

Successfully transferred inbound data from various sources like flat files and Excel into database using SSIS Packages.

Coordinate with multiple scrum teams in planning a solution for the requirement.

Perform ad-hoc analysis of production data where necessary to develop solutions to reported incidents

Created and debugged complex SSIS package, providing the most efficient solution for the client.

Effectively develop, and collaborate with others to develop, database-centric solutions within a distributed team of SQL / ETL, Java, and .NET developers

Declaration:

I do hereby declare that the particulars of information and facts stated above are true, correct and complete to the best of my knowledge and belief.

Place: Chennai

Date: Navaneethan

Contact this candidate