CHANDU N

IT PROFESSIONAL WITH * YEARS OF EXPERIENCE

SQL SQL Server SSIS Database Developer Power Bi

Phone: +91-970*******

Email: adt5hk@r.postjobfree.com

PROFILE SUMMARY

A qualified B.Tech with 4 years of IT experience in software development using T-SQL, MS SQL Server 2014/2016, Microsoft Business Intelligence technologies like SSRS,SSIS, developing dashboard & BI reports or visualization using Power BI and working at all stage analysis, design, development, testing, implementation and bug fixing of applications.

Proficient in creation, modification and effectively use of database objects like Tables, Constraint, Sequences, Indexes, Group Functions, Views, T-SQL jobs, Stored Procedures, Triggers and Functions

Strong knowledge of RDBMS concepts with good database knowledge and experience

Knowledge of database maintenance such as backups, restores and created, modified, maintained, optimized server databases and query optimization

Implementing end to end data integration solutions.

Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics.

Experience in using SSIS tools like import and export wizard, package installation and SSIS package designer.

Good knowledge on importing /exporting data between different sources and send it to different destinations.

Good knowledge on all Power BI scenarios like Calculations, Filters, Actions, Graphs.

Good Knowledge on Import data from multiple data sources into BI Tools, created relationships between data.

Having experience in creating different charts like bar chart, line chart, table chart, matrix table, area chart, scattered chart.

Good experience in developing visual reports, dashboards using power BI desktop.

Drafted prompts calculated fields, customized calculations, conditions and filter for reports & dashboard

Possess strong problem analytical skills with ability to follow project standards and procedures as per the client specification.

Identified data issues and provided recommendations for resolution to ensure optimal performance.

Flexible and adaptable; able to work in ambiguous situations.

Sound communicator with good analytical, decision-making skills & organizational abilities.

SKILLS SUMMARY

Languages T-SQL, HTML

Databases SQL Server 2014/2016

ETL Tool SSIS

Reporting Tool POWER BI

Operating Systems Windows Family, Ubuntu 16.04 LTE, Elementary

Scripting Language Bash Shell scripting

ACADEMIC DETAILS

Bachelor of Technology from JNTU - Anantapur, aggregate of 66% passed out on in MAY 2018

Intermediate from Board of Intermediate - A.P, aggregate of 78% passed out on April 2014

S.S.C from Board of Secondary Education - A.P, aggregate of 68% passed out on April 2012

CERTIFICATIONS

Microsoft Certified: Power BI Data Analyst Associate. Microsoft SQL Server Databases

Udemy PowerBI Certification and SQL server Certification

PROFESSIONAL EXPERIENCE

1.

2. 1. Company: Kyungshin Industrial Motherson Private Ltd Nov 2018 to Jan 2021

SQL Developer

3.

4. 2. Company: Sopra steria Feb 2021 to Till Date

Database Developer -SQL,SSIS

Responsibilities

Responsible for providing solutions to all data related needs to support existing and new applications.

Working closely with the business analysts and business users to understand the business requirements.

Developing custom stored procedures to support new enhancement needs.

Responsible for the designing the complex SQL queries, procedure, cursor, triggers, Tables, Constraint, Sequences, Indexes, Group Functions, Views, T-SQL jobs

Maintained the documents and create reports for the business analysts and end-users.

Effectively building data transformations with SSIS, including importing data from files as well as moving data between database platforms.

Responsible for developing visual reports, KPI scorecards, and dashboards using Power BI desktop

Analysis, Design, Coding, Testing of new requirements, enhancements and bug fixes

Responsible for analysis of output and rectifying the bugs

Monitored and provided front-line support of daily processes.

DECLARATION

I hereby affirm that the information provided by me is accurate and true to the best of my knowledge.

PLACE:

DATE: (CHANDU N)

Contact this candidate