尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
Curriculum Vitae Dharani Sugumar
Dharani Sugumar
Experience Summary
• A Self-motivated and result-oriented professional with five years of extensive experience in
software development.
• Sound knowledge in Microsoft Business Intelligence SSRS, SSAS and SSIS Packages.
• Having prior onsite work experience in developing, Implementing and delivery of MSBI platform
solutions.
• Positive orientation to expand present knowledge base.
• Strong analytical, interpersonal and communication skills.
• Experience in interacting with business users and business analysts on multiple projects.
Education and Certifications
Title of the Degree with
Branch
College/University Year of Passing
Bachelor of Engineering in ECE. SSN College of Engineering, Anna
University, Chennai.
2011
Technical Skills
Hardware / Platforms Windows 7, Windows XP.
Technology SSRS, SSAS, SSIS, SQL Server
Databases MS SQL Server 2012, SQL server 2008, Oracle 11g Basics.
Programming
Languages
ASP.net, ASP, Java Script
Tools / Utilities Svn, Track It, Jira, Ms Office
Domain Knowledge Life Science, Insurance, Telecom
Page 1 of 7
Curriculum Vitae Dharani Sugumar
Certifications
Microsoft Certified Professional. (MCSA in SQL Server 2012)
Professional Experience
Cognizant Technologies Aug-2014 –At present
HCL Technologies May 2011- July 2014
Visa Details
Work permit Visa of JAPAN valid from Jul-2013 to Jul-2016
Passport No: J6621986 Valid Till 17-June-2021
Contact Details
Mobile No. 9741321634 Alternate No.9940290302
Relevant Project Experience
Organization: Cognizant Technology Solutions
Project #1
Title Microsoft Enterprise services(unity framework)
Client Microsoft
Operating System Windows 8
Tools and Technology SSAS, SQL server 2012, SQL profiler
Team Size 14
Role SSAS developer
Period Jan 2015 – Apr-2015
Location Client place (IMSHeath)-Bangalore
Project Objective/ Description
The purpose of the project will be the creation of the 'next generation' of pharmacy services (Pharmacy
as consumers), which will encompass all aspects of a pharmacy business, such as
• Coverage of Rx / OTC / Health & Beauty products
• Business performance & patient care
• Clinical performance
• Pricing & product mix
• Patient segmentation
• Inventory & purchasing
• Competitive growth opportunities
Page 2 of 7
Curriculum Vitae Dharani Sugumar
Role and Responsibilities
• Worked on OLAP Data warehouse, Design, and Implementation.
• Defined relationship between dimensions and measures groups.
• Creating calculated measures, aggregations, named queries etc.
• Enhancing Cube with creating views and stored procedures.
• Dynamically loading partition query into olap cube using SSIS packages.
• Involved in Backing up and Restoring of databases.
• Did performance optimization on olap cube and brought down the cube size to 50GB from
216GB which was much appreciated by the clients.
• Checking query performance using SQL profiler.
• Having considerable testing experience.
Organization: Cognizant Technology Solutions
Project #2
Title Store Level Pharmacy Services (SPS)
Client IMSHealth
Operating System Windows 7
Tools and Technology SSAS, SSIS, SQL server 2012, SQL profiler
Team Size 14
Role SSAS developer
Period Jan 2015 – Apr-2015
Location Client place (IMSHeath)-Bangalore
Project Objective/ Description
The purpose of the SPS projects will be the creation of the 'next generation' of pharmacy services
(Pharmacy as consumers), which will encompass all aspects of a pharmacy business, such as
• Coverage of Rx / OTC / Health & Beauty products
• Business performance & patient care
• Clinical performance
• Pricing & product mix
• Patient segmentation
• Inventory & purchasing
• Competitive growth opportunities
Role and Responsibilities
• Worked on OLAP Data warehouse, Design, and Implementation.
• Defined relationship between dimensions and measures groups.
• Creating calculated measures, aggregations, named queries etc.
• Enhancing Cube with creating views and stored procedures.
• Dynamically loading partition query into olap cube using SSIS packages.
• Involved in Backing up and Restoring of databases.
• Did performance optimization on olap cube and brought down the cube size to 50GB from
216GB which was much appreciated by the clients.
• Checking query performance using SQL profiler.
Page 3 of 7
Curriculum Vitae Dharani Sugumar
• Modifying data mart, Creating indexes on the table columns to fasten the data fetch.
Organization: Cognizant Technology Solutions
Project #3
Title UK Strategic Architecture
Client IMShealth
Operating System Windows 7
Tools and Technology Microsoft sql server reporting services, MDX, SQL profiler
Team Size 5
Role SSRS Developer
Period Sep 2014 – Dec 2014
Location Client place (IMSHeath)-Bangalore
Project Objective/ Description
To collect data from more than 330 hospitals and importing into desktop reporting applications where it
sends aggregated data to the clients using cubes and dashboards.
Role and Responsibilities
• Creating several reports such as drill down reports, parameterized reports, sub reports,
Matrix Reports using SQL Server Reporting Services and Writing complex MDX queries for
reports to fetch data from cube.
• Interacting with Users to know their approach and assist in developing and modifying
Reports accordingly
• Suggesting users technically to improve the performance of the report.
• Helping the team members to understand the requirements and providing technical
guidance.
Organization: HCL Technology Solutions
Project #1
Title Rockwell Collins
Client Rockwell Collins, USA
Operating System Windows 7
Technology SQL Server 2012, SSIS
Team Size 7
Role SSIS Developer
Period Jan 2014 – Jul 2014
Page 4 of 7
Curriculum Vitae Dharani Sugumar
Project Objective/ Description
Arthur Collins founded Collins Radio Company in 1933 in Cedar Rapids, Iowa, for the purpose of
designing and producing both shortwave radio equipment and equipment for the burgeoning AM
Broadcast industry. The purpose of this project is to create ETL packages on various aircrafts data
across all the branches and to maintain the data history.
Role and Responsibilities
• The packages created included a variety of transformations, for example Slowly Changing
Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup,
Multicast and Data Conversion.
• Good Experience in writing DOTNET code in Script Task.
• Involved in writing Stored Procedures, Cursors to run the cube partitions dynamically.
• Transformed data from various data sources using OLE DB connection by creating various
SSIS packages.
• Created SSIS Packages to import and export data from Excel, XML and Text files.
• Involved in gathering, analyzing, and documenting business requirements, functional
requirements and data specifications for Business Intelligence.
• Provided Support for Business analyst and QA.
• Tracking the bugs using Jira.
• Interacted with Users to know their approach and assist in developing Reports accordingly.
Organization: HCL Technology Solutions
Project #2
Title PETA-Sales Tool Illustration
Client ING Life Insurance, Japan
Operating System Windows 7
Technology SSAS, SSRS, SQL
Team Size 8
Role SSAS and SSRS Developer
Offshore Period Jan 2013 – Dec 2013
Onsite Work Period Aug 2013-Oct 2013
Project Objective/ Description
The objective of this project is to move away from the outdated VB6.0 technology in case of PC Mega
and to expand the limited set of products and agencies supported by Web Mega to the entire agency
base for these 9 products, into a Web based system.
Role and Responsibilities
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Defined relationship between dimensions and measures groups, calculated slowly changing
dimensions for different OLAP cubes.
• Involved in Backing up and Restoring of databases.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Responsible to support the issues with reports on the Business Objects reports
environments (Development, Test, UAT and Production).
Page 5 of 7
Curriculum Vitae Dharani Sugumar
• Had face to face interactions with business users to get them acquainted with Info view.
• Report Requirement Analysis.
• Designing, developing the reports and coding assistance.
• Deploying & testing the application on reports.
• Tracking the bugs using Jira.
Organization: HCL Technology Solutions
Project #3
Title Telepacific
Client Telecom pacific, USA
Operating System Windows 7
Technology/Languages ASP.Net, Classic ASP, SQL server, JavaScript, Crystal reports, SSRS.
Team Size 8
Role Junior Developer
Offshore Period Jul 2011 – Dec 2012
Project Objective/ Description
The objective of this project is to sell voice services, local and long distance phone services, Internet
access, private networking, data collocation, voice over IP applications, integrated services, and other
data services targeted to business customers primarily in California and Nevada.
Role and Responsibilities
• Generated reports using SQL Server Reporting Services integrated and deploying them using
web applications onto the web servers.
• Responsible to support the issues with reports on the Business Objects reports
environments (Development, Test, UAT and Production).
• Report Requirement Analysis.
• Designing, developing the reports and coding assistance.
• Deploying & unit testing the application.
• Tracking the bugs using Jira.
Page 6 of 7
Curriculum Vitae Dharani Sugumar
Personal details
Father’s Name: V. Sugumar
Mother’s Name: S. Sumathy
Date of Birth: 9th August 1990
Nationality: Indian
Sex: Female
Marital Status: Single
Passport No: J6621986 Valid Till 17-June-2021
Languages Known: English,TamilTelugu
Total Experience: 5 years
Relevant Experience: 4.6years
Permanent / Contract Employee: Permanent
Preferred Location: Bangalore
Notice Period: 2months
Mobile Number: 9940290302/9741321634
Current CTC: 6.15lak/annum
Expected CTC: 11Lakh(approx)
Current Company Name: COGNIZANT TECHNOLOGY SOLUTIONS
Declaration
I hereby declare that the details furnished above are true to the best of my knowledge and belief.
Dharani Sugumar
Page 7 of 7

More Related Content

What's hot

Sriramjasti
SriramjastiSriramjasti
Sriramjasti
Sriram Jasti
 
Resume
ResumeResume
Resume
Praveen G
 
Renu_Resume
Renu_ResumeRenu_Resume
Renu_Resume
renu lalwani
 
RENUGA VEERARAGAVAN Resume HADOOP
RENUGA VEERARAGAVAN Resume HADOOPRENUGA VEERARAGAVAN Resume HADOOP
RENUGA VEERARAGAVAN Resume HADOOP
renuga V
 
Nirmal Singh -Resume
Nirmal Singh -ResumeNirmal Singh -Resume
Nirmal Singh -Resume
Nirmal Singh
 
Shanthkumar 6yrs-java-analytics-resume
Shanthkumar 6yrs-java-analytics-resumeShanthkumar 6yrs-java-analytics-resume
Shanthkumar 6yrs-java-analytics-resume
Shantha Kumar N
 
Manoj(Java Developer)_Resume
Manoj(Java Developer)_ResumeManoj(Java Developer)_Resume
Manoj(Java Developer)_Resume
Vamsi Manoj
 
Resume Abhishek Vijaywargiya: Database Developer with 9 years of experience i...
Resume Abhishek Vijaywargiya: Database Developer with 9 years of experience i...Resume Abhishek Vijaywargiya: Database Developer with 9 years of experience i...
Resume Abhishek Vijaywargiya: Database Developer with 9 years of experience i...
Abhishek Vijaywargiya
 
Himel_Sen_Resume
Himel_Sen_ResumeHimel_Sen_Resume
Himel_Sen_Resume
himel sen
 
Rakesh_Resume_2016
Rakesh_Resume_2016Rakesh_Resume_2016
Rakesh_Resume_2016
Rakesh Lunawat
 
Jayaram_Parida- Big Data Architect and Technical Scrum Master
Jayaram_Parida- Big Data Architect and Technical Scrum MasterJayaram_Parida- Big Data Architect and Technical Scrum Master
Jayaram_Parida- Big Data Architect and Technical Scrum Master
Jayaram Parida
 
sudipto_resume
sudipto_resumesudipto_resume
sudipto_resume
Sudipto Saha
 
SatheeshPerugu_Resume
SatheeshPerugu_ResumeSatheeshPerugu_Resume
SatheeshPerugu_Resume
satheesh perugu
 
hadoop resume
hadoop resumehadoop resume
hadoop resume
Hassan Qureshi
 
Pankaj Resume for Hadoop,Java,J2EE - Outside World
Pankaj Resume for Hadoop,Java,J2EE -  Outside WorldPankaj Resume for Hadoop,Java,J2EE -  Outside World
Pankaj Resume for Hadoop,Java,J2EE - Outside World
Pankaj Kumar
 
Abdul ETL Resume
Abdul ETL ResumeAbdul ETL Resume
Abdul ETL Resume
Abdul mohammed
 
Yogeesh ETL Developer
Yogeesh ETL DeveloperYogeesh ETL Developer
Yogeesh ETL Developer
yogeesh9611
 
Ali_Resume_Oracle
Ali_Resume_OracleAli_Resume_Oracle
Ali_Resume_Oracle
Ali Asger
 
Pradeepa dharmappa
Pradeepa dharmappaPradeepa dharmappa
Pradeepa dharmappa
Pradeep Pradeep
 
Vijay_Kr_Singh_Oracle_SQL_PLSQL_Developer
Vijay_Kr_Singh_Oracle_SQL_PLSQL_DeveloperVijay_Kr_Singh_Oracle_SQL_PLSQL_Developer
Vijay_Kr_Singh_Oracle_SQL_PLSQL_Developer
Vijay Kumar Singh
 

What's hot (20)

Sriramjasti
SriramjastiSriramjasti
Sriramjasti
 
Resume
ResumeResume
Resume
 
Renu_Resume
Renu_ResumeRenu_Resume
Renu_Resume
 
RENUGA VEERARAGAVAN Resume HADOOP
RENUGA VEERARAGAVAN Resume HADOOPRENUGA VEERARAGAVAN Resume HADOOP
RENUGA VEERARAGAVAN Resume HADOOP
 
Nirmal Singh -Resume
Nirmal Singh -ResumeNirmal Singh -Resume
Nirmal Singh -Resume
 
Shanthkumar 6yrs-java-analytics-resume
Shanthkumar 6yrs-java-analytics-resumeShanthkumar 6yrs-java-analytics-resume
Shanthkumar 6yrs-java-analytics-resume
 
Manoj(Java Developer)_Resume
Manoj(Java Developer)_ResumeManoj(Java Developer)_Resume
Manoj(Java Developer)_Resume
 
Resume Abhishek Vijaywargiya: Database Developer with 9 years of experience i...
Resume Abhishek Vijaywargiya: Database Developer with 9 years of experience i...Resume Abhishek Vijaywargiya: Database Developer with 9 years of experience i...
Resume Abhishek Vijaywargiya: Database Developer with 9 years of experience i...
 
Himel_Sen_Resume
Himel_Sen_ResumeHimel_Sen_Resume
Himel_Sen_Resume
 
Rakesh_Resume_2016
Rakesh_Resume_2016Rakesh_Resume_2016
Rakesh_Resume_2016
 
Jayaram_Parida- Big Data Architect and Technical Scrum Master
Jayaram_Parida- Big Data Architect and Technical Scrum MasterJayaram_Parida- Big Data Architect and Technical Scrum Master
Jayaram_Parida- Big Data Architect and Technical Scrum Master
 
sudipto_resume
sudipto_resumesudipto_resume
sudipto_resume
 
SatheeshPerugu_Resume
SatheeshPerugu_ResumeSatheeshPerugu_Resume
SatheeshPerugu_Resume
 
hadoop resume
hadoop resumehadoop resume
hadoop resume
 
Pankaj Resume for Hadoop,Java,J2EE - Outside World
Pankaj Resume for Hadoop,Java,J2EE -  Outside WorldPankaj Resume for Hadoop,Java,J2EE -  Outside World
Pankaj Resume for Hadoop,Java,J2EE - Outside World
 
Abdul ETL Resume
Abdul ETL ResumeAbdul ETL Resume
Abdul ETL Resume
 
Yogeesh ETL Developer
Yogeesh ETL DeveloperYogeesh ETL Developer
Yogeesh ETL Developer
 
Ali_Resume_Oracle
Ali_Resume_OracleAli_Resume_Oracle
Ali_Resume_Oracle
 
Pradeepa dharmappa
Pradeepa dharmappaPradeepa dharmappa
Pradeepa dharmappa
 
Vijay_Kr_Singh_Oracle_SQL_PLSQL_Developer
Vijay_Kr_Singh_Oracle_SQL_PLSQL_DeveloperVijay_Kr_Singh_Oracle_SQL_PLSQL_Developer
Vijay_Kr_Singh_Oracle_SQL_PLSQL_Developer
 

Viewers also liked

Biodiversidad,vida silvestre y extincion de las especies
Biodiversidad,vida silvestre y extincion de las especiesBiodiversidad,vida silvestre y extincion de las especies
Biodiversidad,vida silvestre y extincion de las especies
Julio Alvarado
 
Nsn 789 1
Nsn 789 1Nsn 789 1
105年0 3歲兒童發展早期介入活動彙整表
105年0 3歲兒童發展早期介入活動彙整表105年0 3歲兒童發展早期介入活動彙整表
105年0 3歲兒童發展早期介入活動彙整表
台中市 兒童發展啟蒙資源中心
 
無礙 有愛
無礙 有愛無礙 有愛
Presentación1
Presentación1Presentación1
Presentación1
mayra roman
 
üslü sayılardan köklü sayılara geçiş süreci
üslü sayılardan köklü sayılara geçiş süreciüslü sayılardan köklü sayılara geçiş süreci
üslü sayılardan köklü sayılara geçiş süreci
Fatma Deligönül
 
105.07.03 「以家庭為中心的跨專業合作」研討會簡章
105.07.03 「以家庭為中心的跨專業合作」研討會簡章105.07.03 「以家庭為中心的跨專業合作」研討會簡章
105.07.03 「以家庭為中心的跨專業合作」研討會簡章
台中市 兒童發展啟蒙資源中心
 
El conde lucanor
El conde lucanorEl conde lucanor
El conde lucanor
Gabriel Useche
 

Viewers also liked (8)

Biodiversidad,vida silvestre y extincion de las especies
Biodiversidad,vida silvestre y extincion de las especiesBiodiversidad,vida silvestre y extincion de las especies
Biodiversidad,vida silvestre y extincion de las especies
 
Nsn 789 1
Nsn 789 1Nsn 789 1
Nsn 789 1
 
105年0 3歲兒童發展早期介入活動彙整表
105年0 3歲兒童發展早期介入活動彙整表105年0 3歲兒童發展早期介入活動彙整表
105年0 3歲兒童發展早期介入活動彙整表
 
無礙 有愛
無礙 有愛無礙 有愛
無礙 有愛
 
Presentación1
Presentación1Presentación1
Presentación1
 
üslü sayılardan köklü sayılara geçiş süreci
üslü sayılardan köklü sayılara geçiş süreciüslü sayılardan köklü sayılara geçiş süreci
üslü sayılardan köklü sayılara geçiş süreci
 
105.07.03 「以家庭為中心的跨專業合作」研討會簡章
105.07.03 「以家庭為中心的跨專業合作」研討會簡章105.07.03 「以家庭為中心的跨專業合作」研討會簡章
105.07.03 「以家庭為中心的跨專業合作」研討會簡章
 
El conde lucanor
El conde lucanorEl conde lucanor
El conde lucanor
 

Similar to Resume_DharaniSugumar

Ponnaganti Rajasekhar Yadav
Ponnaganti Rajasekhar YadavPonnaganti Rajasekhar Yadav
Ponnaganti Rajasekhar Yadav
Raja Sekhar Yadav Ponnaganti
 
Latha Venkata-Nov-1-2016
Latha Venkata-Nov-1-2016Latha Venkata-Nov-1-2016
Latha Venkata-Nov-1-2016
Latha Venkata
 
Big Data Analyst at BankofAmerica
Big Data Analyst at BankofAmericaBig Data Analyst at BankofAmerica
Big Data Analyst at BankofAmerica
Ganaparthi Jagadeesh
 
Sohan Sharma MSBI
Sohan Sharma MSBISohan Sharma MSBI
Sohan Sharma MSBI
Sohan Sharma
 
Ashok_CV
Ashok_CVAshok_CV
Ashok_CV
Ashok Howlader
 
Balavenkatanaveen.MSBI
Balavenkatanaveen.MSBIBalavenkatanaveen.MSBI
Balavenkatanaveen.MSBI
Naveen M
 
Malli Resume_30 Jun 2012
Malli Resume_30 Jun 2012Malli Resume_30 Jun 2012
Malli Resume_30 Jun 2012
mallikarjun ch
 
Resume_Krishna.M
Resume_Krishna.MResume_Krishna.M
Resume_Krishna.M
KRISHNA KISHORE MOTURU
 
priyanka resume.docx
priyanka resume.docxpriyanka resume.docx
priyanka resume.docx
PriyankaTripathi306218
 
Resume_Sunil_Faroz
Resume_Sunil_FarozResume_Sunil_Faroz
Resume_Sunil_Faroz
Sunil Faroz
 
ORACLE DEVELOPER AND DBA CONSULTANT
ORACLE DEVELOPER AND DBA CONSULTANTORACLE DEVELOPER AND DBA CONSULTANT
ORACLE DEVELOPER AND DBA CONSULTANT
stholasamma s
 
Ananthavalli_Resume
Ananthavalli_ResumeAnanthavalli_Resume
Ananthavalli_Resume
Ananthavalli Gopalakrishnan
 
Muruga logeswaran CV-Senior .Net Developer
Muruga logeswaran CV-Senior .Net DeveloperMuruga logeswaran CV-Senior .Net Developer
Muruga logeswaran CV-Senior .Net Developer
Muruga logeswaran Muthaiah
 
Resume_SAP PI
Resume_SAP PIResume_SAP PI
Resume_SAP PI
Anurag Gupta
 
Jeevan_Mitkari_Resume
Jeevan_Mitkari_ResumeJeevan_Mitkari_Resume
Jeevan_Mitkari_Resume
Jeevan Mitkari
 
SAP BO Resume
SAP BO ResumeSAP BO Resume
SAP BO Resume
veenu arora
 
CV_ShobhitPaliwal
CV_ShobhitPaliwalCV_ShobhitPaliwal
CV_ShobhitPaliwal
Shobhit Paliwal
 
Subrat K Panigrahi Resume
Subrat K Panigrahi ResumeSubrat K Panigrahi Resume
Subrat K Panigrahi Resume
Subrat Kumar Panigrahi
 
Hasan jawaid cv
Hasan jawaid cvHasan jawaid cv
Hasan jawaid cv
Hasan Jawaid
 
Murali tummala resume in SAP BO/BI
Murali tummala resume in SAP BO/BIMurali tummala resume in SAP BO/BI
Murali tummala resume in SAP BO/BI
Murali Tummala
 

Similar to Resume_DharaniSugumar (20)

Ponnaganti Rajasekhar Yadav
Ponnaganti Rajasekhar YadavPonnaganti Rajasekhar Yadav
Ponnaganti Rajasekhar Yadav
 
Latha Venkata-Nov-1-2016
Latha Venkata-Nov-1-2016Latha Venkata-Nov-1-2016
Latha Venkata-Nov-1-2016
 
Big Data Analyst at BankofAmerica
Big Data Analyst at BankofAmericaBig Data Analyst at BankofAmerica
Big Data Analyst at BankofAmerica
 
Sohan Sharma MSBI
Sohan Sharma MSBISohan Sharma MSBI
Sohan Sharma MSBI
 
Ashok_CV
Ashok_CVAshok_CV
Ashok_CV
 
Balavenkatanaveen.MSBI
Balavenkatanaveen.MSBIBalavenkatanaveen.MSBI
Balavenkatanaveen.MSBI
 
Malli Resume_30 Jun 2012
Malli Resume_30 Jun 2012Malli Resume_30 Jun 2012
Malli Resume_30 Jun 2012
 
Resume_Krishna.M
Resume_Krishna.MResume_Krishna.M
Resume_Krishna.M
 
priyanka resume.docx
priyanka resume.docxpriyanka resume.docx
priyanka resume.docx
 
Resume_Sunil_Faroz
Resume_Sunil_FarozResume_Sunil_Faroz
Resume_Sunil_Faroz
 
ORACLE DEVELOPER AND DBA CONSULTANT
ORACLE DEVELOPER AND DBA CONSULTANTORACLE DEVELOPER AND DBA CONSULTANT
ORACLE DEVELOPER AND DBA CONSULTANT
 
Ananthavalli_Resume
Ananthavalli_ResumeAnanthavalli_Resume
Ananthavalli_Resume
 
Muruga logeswaran CV-Senior .Net Developer
Muruga logeswaran CV-Senior .Net DeveloperMuruga logeswaran CV-Senior .Net Developer
Muruga logeswaran CV-Senior .Net Developer
 
Resume_SAP PI
Resume_SAP PIResume_SAP PI
Resume_SAP PI
 
Jeevan_Mitkari_Resume
Jeevan_Mitkari_ResumeJeevan_Mitkari_Resume
Jeevan_Mitkari_Resume
 
SAP BO Resume
SAP BO ResumeSAP BO Resume
SAP BO Resume
 
CV_ShobhitPaliwal
CV_ShobhitPaliwalCV_ShobhitPaliwal
CV_ShobhitPaliwal
 
Subrat K Panigrahi Resume
Subrat K Panigrahi ResumeSubrat K Panigrahi Resume
Subrat K Panigrahi Resume
 
Hasan jawaid cv
Hasan jawaid cvHasan jawaid cv
Hasan jawaid cv
 
Murali tummala resume in SAP BO/BI
Murali tummala resume in SAP BO/BIMurali tummala resume in SAP BO/BI
Murali tummala resume in SAP BO/BI
 

Resume_DharaniSugumar

  • 1. Curriculum Vitae Dharani Sugumar Dharani Sugumar Experience Summary • A Self-motivated and result-oriented professional with five years of extensive experience in software development. • Sound knowledge in Microsoft Business Intelligence SSRS, SSAS and SSIS Packages. • Having prior onsite work experience in developing, Implementing and delivery of MSBI platform solutions. • Positive orientation to expand present knowledge base. • Strong analytical, interpersonal and communication skills. • Experience in interacting with business users and business analysts on multiple projects. Education and Certifications Title of the Degree with Branch College/University Year of Passing Bachelor of Engineering in ECE. SSN College of Engineering, Anna University, Chennai. 2011 Technical Skills Hardware / Platforms Windows 7, Windows XP. Technology SSRS, SSAS, SSIS, SQL Server Databases MS SQL Server 2012, SQL server 2008, Oracle 11g Basics. Programming Languages ASP.net, ASP, Java Script Tools / Utilities Svn, Track It, Jira, Ms Office Domain Knowledge Life Science, Insurance, Telecom Page 1 of 7
  • 2. Curriculum Vitae Dharani Sugumar Certifications Microsoft Certified Professional. (MCSA in SQL Server 2012) Professional Experience Cognizant Technologies Aug-2014 –At present HCL Technologies May 2011- July 2014 Visa Details Work permit Visa of JAPAN valid from Jul-2013 to Jul-2016 Passport No: J6621986 Valid Till 17-June-2021 Contact Details Mobile No. 9741321634 Alternate No.9940290302 Relevant Project Experience Organization: Cognizant Technology Solutions Project #1 Title Microsoft Enterprise services(unity framework) Client Microsoft Operating System Windows 8 Tools and Technology SSAS, SQL server 2012, SQL profiler Team Size 14 Role SSAS developer Period Jan 2015 – Apr-2015 Location Client place (IMSHeath)-Bangalore Project Objective/ Description The purpose of the project will be the creation of the 'next generation' of pharmacy services (Pharmacy as consumers), which will encompass all aspects of a pharmacy business, such as • Coverage of Rx / OTC / Health & Beauty products • Business performance & patient care • Clinical performance • Pricing & product mix • Patient segmentation • Inventory & purchasing • Competitive growth opportunities Page 2 of 7
  • 3. Curriculum Vitae Dharani Sugumar Role and Responsibilities • Worked on OLAP Data warehouse, Design, and Implementation. • Defined relationship between dimensions and measures groups. • Creating calculated measures, aggregations, named queries etc. • Enhancing Cube with creating views and stored procedures. • Dynamically loading partition query into olap cube using SSIS packages. • Involved in Backing up and Restoring of databases. • Did performance optimization on olap cube and brought down the cube size to 50GB from 216GB which was much appreciated by the clients. • Checking query performance using SQL profiler. • Having considerable testing experience. Organization: Cognizant Technology Solutions Project #2 Title Store Level Pharmacy Services (SPS) Client IMSHealth Operating System Windows 7 Tools and Technology SSAS, SSIS, SQL server 2012, SQL profiler Team Size 14 Role SSAS developer Period Jan 2015 – Apr-2015 Location Client place (IMSHeath)-Bangalore Project Objective/ Description The purpose of the SPS projects will be the creation of the 'next generation' of pharmacy services (Pharmacy as consumers), which will encompass all aspects of a pharmacy business, such as • Coverage of Rx / OTC / Health & Beauty products • Business performance & patient care • Clinical performance • Pricing & product mix • Patient segmentation • Inventory & purchasing • Competitive growth opportunities Role and Responsibilities • Worked on OLAP Data warehouse, Design, and Implementation. • Defined relationship between dimensions and measures groups. • Creating calculated measures, aggregations, named queries etc. • Enhancing Cube with creating views and stored procedures. • Dynamically loading partition query into olap cube using SSIS packages. • Involved in Backing up and Restoring of databases. • Did performance optimization on olap cube and brought down the cube size to 50GB from 216GB which was much appreciated by the clients. • Checking query performance using SQL profiler. Page 3 of 7
  • 4. Curriculum Vitae Dharani Sugumar • Modifying data mart, Creating indexes on the table columns to fasten the data fetch. Organization: Cognizant Technology Solutions Project #3 Title UK Strategic Architecture Client IMShealth Operating System Windows 7 Tools and Technology Microsoft sql server reporting services, MDX, SQL profiler Team Size 5 Role SSRS Developer Period Sep 2014 – Dec 2014 Location Client place (IMSHeath)-Bangalore Project Objective/ Description To collect data from more than 330 hospitals and importing into desktop reporting applications where it sends aggregated data to the clients using cubes and dashboards. Role and Responsibilities • Creating several reports such as drill down reports, parameterized reports, sub reports, Matrix Reports using SQL Server Reporting Services and Writing complex MDX queries for reports to fetch data from cube. • Interacting with Users to know their approach and assist in developing and modifying Reports accordingly • Suggesting users technically to improve the performance of the report. • Helping the team members to understand the requirements and providing technical guidance. Organization: HCL Technology Solutions Project #1 Title Rockwell Collins Client Rockwell Collins, USA Operating System Windows 7 Technology SQL Server 2012, SSIS Team Size 7 Role SSIS Developer Period Jan 2014 – Jul 2014 Page 4 of 7
  • 5. Curriculum Vitae Dharani Sugumar Project Objective/ Description Arthur Collins founded Collins Radio Company in 1933 in Cedar Rapids, Iowa, for the purpose of designing and producing both shortwave radio equipment and equipment for the burgeoning AM Broadcast industry. The purpose of this project is to create ETL packages on various aircrafts data across all the branches and to maintain the data history. Role and Responsibilities • The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion. • Good Experience in writing DOTNET code in Script Task. • Involved in writing Stored Procedures, Cursors to run the cube partitions dynamically. • Transformed data from various data sources using OLE DB connection by creating various SSIS packages. • Created SSIS Packages to import and export data from Excel, XML and Text files. • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Intelligence. • Provided Support for Business analyst and QA. • Tracking the bugs using Jira. • Interacted with Users to know their approach and assist in developing Reports accordingly. Organization: HCL Technology Solutions Project #2 Title PETA-Sales Tool Illustration Client ING Life Insurance, Japan Operating System Windows 7 Technology SSAS, SSRS, SQL Team Size 8 Role SSAS and SSRS Developer Offshore Period Jan 2013 – Dec 2013 Onsite Work Period Aug 2013-Oct 2013 Project Objective/ Description The objective of this project is to move away from the outdated VB6.0 technology in case of PC Mega and to expand the limited set of products and agencies supported by Web Mega to the entire agency base for these 9 products, into a Web based system. Role and Responsibilities • Worked on OLAP Data warehouse, Model, Design, and Implementation. • Defined relationship between dimensions and measures groups, calculated slowly changing dimensions for different OLAP cubes. • Involved in Backing up and Restoring of databases. • Created star schema in SSAS and developed SSRS reports based on the cubes. • Responsible to support the issues with reports on the Business Objects reports environments (Development, Test, UAT and Production). Page 5 of 7
  • 6. Curriculum Vitae Dharani Sugumar • Had face to face interactions with business users to get them acquainted with Info view. • Report Requirement Analysis. • Designing, developing the reports and coding assistance. • Deploying & testing the application on reports. • Tracking the bugs using Jira. Organization: HCL Technology Solutions Project #3 Title Telepacific Client Telecom pacific, USA Operating System Windows 7 Technology/Languages ASP.Net, Classic ASP, SQL server, JavaScript, Crystal reports, SSRS. Team Size 8 Role Junior Developer Offshore Period Jul 2011 – Dec 2012 Project Objective/ Description The objective of this project is to sell voice services, local and long distance phone services, Internet access, private networking, data collocation, voice over IP applications, integrated services, and other data services targeted to business customers primarily in California and Nevada. Role and Responsibilities • Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers. • Responsible to support the issues with reports on the Business Objects reports environments (Development, Test, UAT and Production). • Report Requirement Analysis. • Designing, developing the reports and coding assistance. • Deploying & unit testing the application. • Tracking the bugs using Jira. Page 6 of 7
  • 7. Curriculum Vitae Dharani Sugumar Personal details Father’s Name: V. Sugumar Mother’s Name: S. Sumathy Date of Birth: 9th August 1990 Nationality: Indian Sex: Female Marital Status: Single Passport No: J6621986 Valid Till 17-June-2021 Languages Known: English,TamilTelugu Total Experience: 5 years Relevant Experience: 4.6years Permanent / Contract Employee: Permanent Preferred Location: Bangalore Notice Period: 2months Mobile Number: 9940290302/9741321634 Current CTC: 6.15lak/annum Expected CTC: 11Lakh(approx) Current Company Name: COGNIZANT TECHNOLOGY SOLUTIONS Declaration I hereby declare that the details furnished above are true to the best of my knowledge and belief. Dharani Sugumar Page 7 of 7
  翻译: