ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
V JYOTHSNA DEVI
EMAIL:vjyothsnadevi25@gmail.com
MOBILE:+7286038865
Professional summary:
 Ambitious and self-motivated SQL developer with a strong technical background
and 1.5 years of work experience.
 Experience in developing Data warehouse applications using MSBI.
 Having knowledge on SDLC from project initiation to post-implementation
 Experience in ETL processes. Worked extensively on data extraction, cleansing/data
integration, and loading from different data sources using SSIS.
 Good knowledge in DBA Skills (Backup, Restore & SQL Jobs configuration. Database
Performance/optimization Tuning, index rebuilding and reorganized
 Good at installation and configuration of SQL Server 2008/2012.
 Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers,
Tables, cursors, User Defined Functions and SQL joins.
Educational qualification:
 Bachelor of Technology from JNT University, Hyderabad, Telangana, April-2014.
Work Experience:
 Working as a SQL Developer in Tech Mahindra Limited, Bangalore from June 2014 to
Till Date.
Technical Skills:
 Languages : SQL, HTML, XML, C
 Business Intelligence Tools : MSBI (SSIS)
 Database : MS SQL Server 2008 R2
 OS : Windows NT and LINUX
Projects:
Project 1
Project : Molson Billing
Client : Bell, Canada
Role : Development
Project Description:
Bell Is Canada’s Largest Telecommunications Company, Providing Mobile Phone, TV, High Speed
and Wire Less Internet, And Residential Home Phone Services, headquartered in Quebec. This
project involved in fulfill their business need about to extract data of their users information from
flat files, cleanse the data and load into excel file by using some business rules. Data will be
extracted from flat file & populated to SQL tables and use as source to populate Malson Billing
excel file. End user can view the information about their users information using downstream of
excel file.
Responsibilities:
 Designing and development of SSIS package for migration of consultants data from various
sources like Flat files, Excel files and Databases
 Importing Source/Target tables from the respective databases by using Execute Package
Task using Control Tasks in SQL Server 2008R2 Integration services.
 Created Transformations and Mappings using Data Flow Tasks.
 Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential
Container, Execute Task, Email Task, and Data Flow Task.
 Extensively used Derive Column, Row Count, Data Conversion, Conditional Split and
Aggregate.
 Involved in performance tuning of the packages.
 Train and manage developers, advising other groups in organization on SSIS
development, data warehouse development, and ETL development best practices.
 Generating the reports using new OUP Archive solution to meet customer’s requirements.
 Preparation of Detailed Design Documents and Functional Documents for all existing
reports in the system.
Project no: 2
Project : Sales Analysis System
Client : Advantis Technologies Inc, GA
Role : SQL server SSIS /SSRS developer
Project Description:
Advantis Technologies is a leading manufacturer of surface water chemical, pool and spa chemicals
and accessories. The project involved sales information ,providing timely and sales reports to
territory managers by streamlining the custom reporting process .it enabled the business users to
quickly and easily analyze profitability of products, cost, volume, and product mix using the
packaged reports and and the flexibility
Responsibilities:
 Identified various transformations in SSIS and their use at various Situations in the
project and prepared documents and packages.
 Worked with various tasks such as Control Flow(Execute SQL task, For each loop
container, Data Flow task, File System etc..) and transformations such as Aggregate,
Sort, Lookup, Fuzzy Lookup, Merge join, multicast, conditional split, derived column
etc..
 Used logging for auditing the information.
 Implemented error handling to load erroneous data the error tables and files.

More Related Content

What's hot (20)

Naveen_MSBI_Senior_Developer
Naveen_MSBI_Senior_DeveloperNaveen_MSBI_Senior_Developer
Naveen_MSBI_Senior_Developer
Naveen Meti
Ìý
ETL Developer Resume
ETL Developer ResumeETL Developer Resume
ETL Developer Resume
Teferi Tamiru
Ìý
Rakesh
RakeshRakesh
Rakesh
Rakesh Kuchana
Ìý
Resume_Navneet_Formatted
Resume_Navneet_FormattedResume_Navneet_Formatted
Resume_Navneet_Formatted
Navneet Tiwari
Ìý
RakeshCS_5.4years
RakeshCS_5.4yearsRakeshCS_5.4years
RakeshCS_5.4years
Rakesh CS
Ìý
Scott_Laurel_Resume
Scott_Laurel_ResumeScott_Laurel_Resume
Scott_Laurel_Resume
Scott Laurel
Ìý
Shashi.Kiran_CV
Shashi.Kiran_CVShashi.Kiran_CV
Shashi.Kiran_CV
Shashi Kiran
Ìý
Swetha Nelwad Resume (1)
Swetha Nelwad Resume (1)Swetha Nelwad Resume (1)
Swetha Nelwad Resume (1)
Swetha Nelwad
Ìý
Ponmagal(SQL)Resume
Ponmagal(SQL)ResumePonmagal(SQL)Resume
Ponmagal(SQL)Resume
ponmagal nanmaran
Ìý
SQL Server Integration Services – Enterprise Manageability
SQL Server Integration Services – Enterprise ManageabilitySQL Server Integration Services – Enterprise Manageability
SQL Server Integration Services – Enterprise Manageability
Dan English
Ìý
resume mumbai
resume mumbairesume mumbai
resume mumbai
siva prasad
Ìý
Resume of Jay Zabinsky
Resume of Jay ZabinskyResume of Jay Zabinsky
Resume of Jay Zabinsky
jzabinsky
Ìý
SR.SQL_RAJARAM
SR.SQL_RAJARAMSR.SQL_RAJARAM
SR.SQL_RAJARAM
K Rajaram
Ìý
James Henry Robinson
James Henry RobinsonJames Henry Robinson
James Henry Robinson
James Henry Robinson
Ìý
Qidb resume
Qidb resumeQidb resume
Qidb resume
Bin Qi
Ìý
William Lu
William LuWilliam Lu
William Lu
William Lu
Ìý
ShashankJainMSBI
ShashankJainMSBIShashankJainMSBI
ShashankJainMSBI
Shashank Jain
Ìý
MANISH SHARMA(MSBI-QLIKVIEW)
MANISH SHARMA(MSBI-QLIKVIEW)MANISH SHARMA(MSBI-QLIKVIEW)
MANISH SHARMA(MSBI-QLIKVIEW)
manish sharma
Ìý
Armando Marrero Resume Sql Server Database Developer
Armando Marrero Resume Sql Server Database DeveloperArmando Marrero Resume Sql Server Database Developer
Armando Marrero Resume Sql Server Database Developer
Armando Marrero
Ìý
Resume - Courtney Ammons
Resume - Courtney AmmonsResume - Courtney Ammons
Resume - Courtney Ammons
Courtney Ammons
Ìý
Naveen_MSBI_Senior_Developer
Naveen_MSBI_Senior_DeveloperNaveen_MSBI_Senior_Developer
Naveen_MSBI_Senior_Developer
Naveen Meti
Ìý
ETL Developer Resume
ETL Developer ResumeETL Developer Resume
ETL Developer Resume
Teferi Tamiru
Ìý
Resume_Navneet_Formatted
Resume_Navneet_FormattedResume_Navneet_Formatted
Resume_Navneet_Formatted
Navneet Tiwari
Ìý
RakeshCS_5.4years
RakeshCS_5.4yearsRakeshCS_5.4years
RakeshCS_5.4years
Rakesh CS
Ìý
Scott_Laurel_Resume
Scott_Laurel_ResumeScott_Laurel_Resume
Scott_Laurel_Resume
Scott Laurel
Ìý
Shashi.Kiran_CV
Shashi.Kiran_CVShashi.Kiran_CV
Shashi.Kiran_CV
Shashi Kiran
Ìý
Swetha Nelwad Resume (1)
Swetha Nelwad Resume (1)Swetha Nelwad Resume (1)
Swetha Nelwad Resume (1)
Swetha Nelwad
Ìý
SQL Server Integration Services – Enterprise Manageability
SQL Server Integration Services – Enterprise ManageabilitySQL Server Integration Services – Enterprise Manageability
SQL Server Integration Services – Enterprise Manageability
Dan English
Ìý
resume mumbai
resume mumbairesume mumbai
resume mumbai
siva prasad
Ìý
Resume of Jay Zabinsky
Resume of Jay ZabinskyResume of Jay Zabinsky
Resume of Jay Zabinsky
jzabinsky
Ìý
SR.SQL_RAJARAM
SR.SQL_RAJARAMSR.SQL_RAJARAM
SR.SQL_RAJARAM
K Rajaram
Ìý
Qidb resume
Qidb resumeQidb resume
Qidb resume
Bin Qi
Ìý
William Lu
William LuWilliam Lu
William Lu
William Lu
Ìý
ShashankJainMSBI
ShashankJainMSBIShashankJainMSBI
ShashankJainMSBI
Shashank Jain
Ìý
MANISH SHARMA(MSBI-QLIKVIEW)
MANISH SHARMA(MSBI-QLIKVIEW)MANISH SHARMA(MSBI-QLIKVIEW)
MANISH SHARMA(MSBI-QLIKVIEW)
manish sharma
Ìý
Armando Marrero Resume Sql Server Database Developer
Armando Marrero Resume Sql Server Database DeveloperArmando Marrero Resume Sql Server Database Developer
Armando Marrero Resume Sql Server Database Developer
Armando Marrero
Ìý
Resume - Courtney Ammons
Resume - Courtney AmmonsResume - Courtney Ammons
Resume - Courtney Ammons
Courtney Ammons
Ìý

Viewers also liked (11)

Subin Joseph_ETL_Lead
Subin Joseph_ETL_LeadSubin Joseph_ETL_Lead
Subin Joseph_ETL_Lead
Subin Joseph
Ìý
NiveditaResumeDBA
NiveditaResumeDBA NiveditaResumeDBA
NiveditaResumeDBA
Nivedita Alure
Ìý
RESUME - SANTANU GHOSH 2016
RESUME - SANTANU GHOSH 2016RESUME - SANTANU GHOSH 2016
RESUME - SANTANU GHOSH 2016
Santanu Ghosh
Ìý
Siva_Resume
Siva_ResumeSiva_Resume
Siva_Resume
Sivaramakrishna kommana
Ìý
MANISH_CGI_MSBI
MANISH_CGI_MSBIMANISH_CGI_MSBI
MANISH_CGI_MSBI
Manish Kumar
Ìý
NaveenKumarGV
NaveenKumarGVNaveenKumarGV
NaveenKumarGV
NaveenKumar GV
Ìý
CHETHAN RESUME_MSBI DEVELOPER
CHETHAN RESUME_MSBI DEVELOPERCHETHAN RESUME_MSBI DEVELOPER
CHETHAN RESUME_MSBI DEVELOPER
Chethan a
Ìý
NikhilBhalodkarResume
NikhilBhalodkarResumeNikhilBhalodkarResume
NikhilBhalodkarResume
Nikhil Bhalodkar
Ìý
Naveen CV
Naveen CVNaveen CV
Naveen CV
NaveenKumar GV
Ìý
Balamurugan msbi cv
Balamurugan msbi cvBalamurugan msbi cv
Balamurugan msbi cv
bala murugan
Ìý
Zaheer's Resume
Zaheer's ResumeZaheer's Resume
Zaheer's Resume
zaheeruddinvallur
Ìý
Subin Joseph_ETL_Lead
Subin Joseph_ETL_LeadSubin Joseph_ETL_Lead
Subin Joseph_ETL_Lead
Subin Joseph
Ìý
NiveditaResumeDBA
NiveditaResumeDBA NiveditaResumeDBA
NiveditaResumeDBA
Nivedita Alure
Ìý
RESUME - SANTANU GHOSH 2016
RESUME - SANTANU GHOSH 2016RESUME - SANTANU GHOSH 2016
RESUME - SANTANU GHOSH 2016
Santanu Ghosh
Ìý
MANISH_CGI_MSBI
MANISH_CGI_MSBIMANISH_CGI_MSBI
MANISH_CGI_MSBI
Manish Kumar
Ìý
CHETHAN RESUME_MSBI DEVELOPER
CHETHAN RESUME_MSBI DEVELOPERCHETHAN RESUME_MSBI DEVELOPER
CHETHAN RESUME_MSBI DEVELOPER
Chethan a
Ìý
NikhilBhalodkarResume
NikhilBhalodkarResumeNikhilBhalodkarResume
NikhilBhalodkarResume
Nikhil Bhalodkar
Ìý
Balamurugan msbi cv
Balamurugan msbi cvBalamurugan msbi cv
Balamurugan msbi cv
bala murugan
Ìý

Similar to sql resume (20)

Ganesh CV
Ganesh CVGanesh CV
Ganesh CV
Ganesh Kamble
Ìý
Sophia wang (2)
Sophia wang (2)Sophia wang (2)
Sophia wang (2)
Dibakar27
Ìý
Ganesh profile
Ganesh profileGanesh profile
Ganesh profile
Ganesh Kamble
Ìý
Msbi power bi_ lead
Msbi power bi_ leadMsbi power bi_ lead
Msbi power bi_ lead
Kota Sudhake
Ìý
Resume_Alka
Resume_AlkaResume_Alka
Resume_Alka
Alka Shukla
Ìý
ChakravarthyUppara
ChakravarthyUpparaChakravarthyUppara
ChakravarthyUppara
Chakravarthy Uppara
Ìý
Milind_Dhotarkar - MSBI
Milind_Dhotarkar - MSBIMilind_Dhotarkar - MSBI
Milind_Dhotarkar - MSBI
milind dhotarkar
Ìý
Rakesh
RakeshRakesh
Rakesh
Rakesh Kuchana
Ìý
Resume_Krishna.M
Resume_Krishna.MResume_Krishna.M
Resume_Krishna.M
KRISHNA KISHORE MOTURU
Ìý
durga_resume
durga_resumedurga_resume
durga_resume
durga p
Ìý
NITIN_DIXIT
NITIN_DIXITNITIN_DIXIT
NITIN_DIXIT
Nitin Dixit
Ìý
Kasi
KasiKasi
Kasi
kasi visweswaraRao
Ìý
Satwinder SQL.SSK_Brd_2015
Satwinder SQL.SSK_Brd_2015Satwinder SQL.SSK_Brd_2015
Satwinder SQL.SSK_Brd_2015
Satwinder Khural
Ìý
HamsaBalajiresume
HamsaBalajiresumeHamsaBalajiresume
HamsaBalajiresume
Hamsa Balaji
Ìý
Siva-CV
Siva-CVSiva-CV
Siva-CV
siva prasad
Ìý
Nitin Paliwal
Nitin PaliwalNitin Paliwal
Nitin Paliwal
Nitin Paliwal
Ìý
Shane_O'Neill_CV_slim
Shane_O'Neill_CV_slimShane_O'Neill_CV_slim
Shane_O'Neill_CV_slim
Shane O'Neill
Ìý
Akshita_Resume
Akshita_ResumeAkshita_Resume
Akshita_Resume
Akshita .
Ìý
Resume-pradeep SQL DBA
Resume-pradeep SQL DBAResume-pradeep SQL DBA
Resume-pradeep SQL DBA
Pradeep GP
Ìý
Balavenkatanaveen.MSBI
Balavenkatanaveen.MSBIBalavenkatanaveen.MSBI
Balavenkatanaveen.MSBI
Naveen M
Ìý
Sophia wang (2)
Sophia wang (2)Sophia wang (2)
Sophia wang (2)
Dibakar27
Ìý
Ganesh profile
Ganesh profileGanesh profile
Ganesh profile
Ganesh Kamble
Ìý
Msbi power bi_ lead
Msbi power bi_ leadMsbi power bi_ lead
Msbi power bi_ lead
Kota Sudhake
Ìý
Resume_Alka
Resume_AlkaResume_Alka
Resume_Alka
Alka Shukla
Ìý
Milind_Dhotarkar - MSBI
Milind_Dhotarkar - MSBIMilind_Dhotarkar - MSBI
Milind_Dhotarkar - MSBI
milind dhotarkar
Ìý
durga_resume
durga_resumedurga_resume
durga_resume
durga p
Ìý
NITIN_DIXIT
NITIN_DIXITNITIN_DIXIT
NITIN_DIXIT
Nitin Dixit
Ìý
Satwinder SQL.SSK_Brd_2015
Satwinder SQL.SSK_Brd_2015Satwinder SQL.SSK_Brd_2015
Satwinder SQL.SSK_Brd_2015
Satwinder Khural
Ìý
HamsaBalajiresume
HamsaBalajiresumeHamsaBalajiresume
HamsaBalajiresume
Hamsa Balaji
Ìý
Shane_O'Neill_CV_slim
Shane_O'Neill_CV_slimShane_O'Neill_CV_slim
Shane_O'Neill_CV_slim
Shane O'Neill
Ìý
Akshita_Resume
Akshita_ResumeAkshita_Resume
Akshita_Resume
Akshita .
Ìý
Resume-pradeep SQL DBA
Resume-pradeep SQL DBAResume-pradeep SQL DBA
Resume-pradeep SQL DBA
Pradeep GP
Ìý
Balavenkatanaveen.MSBI
Balavenkatanaveen.MSBIBalavenkatanaveen.MSBI
Balavenkatanaveen.MSBI
Naveen M
Ìý

sql resume

  • 1. V JYOTHSNA DEVI EMAIL:vjyothsnadevi25@gmail.com MOBILE:+7286038865 Professional summary:  Ambitious and self-motivated SQL developer with a strong technical background and 1.5 years of work experience.  Experience in developing Data warehouse applications using MSBI.  Having knowledge on SDLC from project initiation to post-implementation  Experience in ETL processes. Worked extensively on data extraction, cleansing/data integration, and loading from different data sources using SSIS.  Good knowledge in DBA Skills (Backup, Restore & SQL Jobs configuration. Database Performance/optimization Tuning, index rebuilding and reorganized  Good at installation and configuration of SQL Server 2008/2012.  Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, cursors, User Defined Functions and SQL joins. Educational qualification:  Bachelor of Technology from JNT University, Hyderabad, Telangana, April-2014. Work Experience:  Working as a SQL Developer in Tech Mahindra Limited, Bangalore from June 2014 to Till Date. Technical Skills:  Languages : SQL, HTML, XML, C  Business Intelligence Tools : MSBI (SSIS)  Database : MS SQL Server 2008 R2  OS : Windows NT and LINUX Projects: Project 1 Project : Molson Billing Client : Bell, Canada Role : Development Project Description: Bell Is Canada’s Largest Telecommunications Company, Providing Mobile Phone, TV, High Speed and Wire Less Internet, And Residential Home Phone Services, headquartered in Quebec. This project involved in fulfill their business need about to extract data of their users information from flat files, cleanse the data and load into excel file by using some business rules. Data will be
  • 2. extracted from flat file & populated to SQL tables and use as source to populate Malson Billing excel file. End user can view the information about their users information using downstream of excel file. Responsibilities:  Designing and development of SSIS package for migration of consultants data from various sources like Flat files, Excel files and Databases  Importing Source/Target tables from the respective databases by using Execute Package Task using Control Tasks in SQL Server 2008R2 Integration services.  Created Transformations and Mappings using Data Flow Tasks.  Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task, and Data Flow Task.  Extensively used Derive Column, Row Count, Data Conversion, Conditional Split and Aggregate.  Involved in performance tuning of the packages.  Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.  Generating the reports using new OUP Archive solution to meet customer’s requirements.  Preparation of Detailed Design Documents and Functional Documents for all existing reports in the system. Project no: 2 Project : Sales Analysis System Client : Advantis Technologies Inc, GA Role : SQL server SSIS /SSRS developer Project Description: Advantis Technologies is a leading manufacturer of surface water chemical, pool and spa chemicals and accessories. The project involved sales information ,providing timely and sales reports to territory managers by streamlining the custom reporting process .it enabled the business users to quickly and easily analyze profitability of products, cost, volume, and product mix using the packaged reports and and the flexibility Responsibilities:  Identified various transformations in SSIS and their use at various Situations in the project and prepared documents and packages.  Worked with various tasks such as Control Flow(Execute SQL task, For each loop container, Data Flow task, File System etc..) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, multicast, conditional split, derived column etc..  Used logging for auditing the information.  Implemented error handling to load erroneous data the error tables and files.