尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
Nithin C
628 Yosemite Ave, Naperville, Illinois - 60563
Email: sqldev.nithin@gmail.com Ph: (662) 631-4639
SUMMARY
 Over 3 years of strong experience in Analysis, Design and Development of Business Intelligence Solutions in 
Data Warehousing using Microsoft BIDS 2008 or Informatica PowerCenter 9.1 as an ETL tool on Windows
and UNIX based operating systems. 
EXPERIENCE
Apr’15 – Current DW & ETL Analyst, Blue Cross Blue Shield, Naperville, IL
Blue Cross Blue Shield is a well reputed health insurance company. The project I’m working on is: ‘ACH Email
Notification’, which sends pre notification to the member regarding draft information. It calculates the estimated
amount to be drafted on a specific day and sends a notification to the member with specific prior days to draft day.
The project involves multiple teams, communicated well with different teams to make sure project timelines didn’t
get affected. I created ETL’s to indentify the specific day population, process the estimated amounts and send
notification. For estimated amounts, I created Aggregate transformation, Conditional Split task. I used fixed length
flat file source to import data from Nacha file. The project was developed based on Agile methodology.
 Worked with SSIS packages and zena scheduler.
 Used transformations like Fixed Length Flat File Source, lookup, Aggregator, Store Procedure, Rank, Data
Conversion, Conditional Split and Sequence generator.
 Used performance tuning techniques to minimize the run time and create pre-session caches with good
load being balanced on server.
 Created email task to send an email on package failure.
 Used Zena to schedule the SSIS package.
 Worked with testing team and provided required support to them. Quickly fixed the issues and provided
new build to the testing team.
 Handle the Migration process from Development, Test and Production Environments.
 Communicated well to project manager and team on the impact of the issues to the overall timeline, and
project deliverables.
 Reviewed the design and requirements documents with architects and business analysts to finalize the
design.
Environment: Microsoft Visual Studio 2008, Microsoft Visual Studio 2013, Microsoft SQL Server 2008, Zena,
WinSCP.
Oct’11 – July’13 Data Analyst, GGK Technologies, Hyderabad, India
 Worked with Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server
Manager and Workflow Monitor.
 Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filters, Aggregator,
Store Procedure, Rank, Update Strategy, Router and Sequence generator.
 Created workflows containing command, email, session, decision and a wide variety of tasks.
 Prepared ETL flow of data from Staging to Data Mart.
 Used Informatica as an ETL tool to extract data from sources systems, loaded the data into the ORACLE
database. 
 Designed and Developed mappings to extract data from heterogeneous sources, applied transform logics to
extracted data and Loaded into Data Warehouse Databases.
 Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected &
unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner and Update Strategy for
developing mappings involving complex business logics.
 Developed shell scripts, PL/SQL procedures for creating/dropping of table and indexes of performance for
pre and post session management.
 Used ETL, Informatica Designer to design mappings and coded it using reusable mapplets.
 Developed workflow sequences to control the execution sequence of various jobs and to email support
personnel.
 Implemented Type 2 slowly changing dimensions to maintain dimension history and Tuned the Mappings
for Optimum Performance.

Environment: Informatica PowerCenter 9.1, Oracle 10g/ 9i, TOAD, MySQL, PL/SQL, UNIX, Eclipse Helios.
Aug’11- Oct’12 Associate Software Engineer, GGK Technologies, Hyderabad, India
 Developed java project using Springs 2.0 and Hibernate.
 The RTRS project was developed based on MVC based architecture for better handling of work
request.
 Used Hibernate to fetch data from MySQL database and send the response to the controller.
 Used Springs for business logic.
 Used JQuery, Javascript and CSS for look and feel of the UI.
 Supported testing team and fixed issues in quickly manner.
Environment: Eclipse Helios, MySQL.
EDUCATION:
 Masters of Science, Computer Software Engineering (2013-2014) from University of Houston - Clear
Lake, Houston with CGPA of 3.45. 
 Bachelor of Engineering, Computer Science from Jawaharlal Nehru Technological University - Hyderabad,
India with an aggregate of 68.32% that is CGPA of 3.2. 
Technical Skills:
ETL/Middleware Tools Informatica PowerCenter 9.1.1, Microsoft BIDS 2010.
Data Modelling Dimensional Data Modelling, Star Join Schema Modelling, Snow-Flake
Modelling, Fact and Dimension tables, Physical and Logical Data Modelling.
Business Intelligence Tools Microsoft Visual Studio 2012, Microsoft Visio 2010, OBIEE 11g/10.1.3.x
RDBMS Oracle 11g/10g/9i, MS SQL Server, DB2, MySql.
Programming Skills SQL, Oracle PL/SQL, Unix Shell Scripting, Ad-Hoc SQL, HTML, DHTML, Python,
CSS, XML, Java, C#.Net, Javascript, Object Oriented Programming.
Tools TOAD, SQL Plus, SQL*Loader, Quality Assurance, Soap UI, Fiddler
ALM, Eclipse.
Independent Course Hadoop.
Scheduling Tool Zena, Sql Agent.
Course Projects:
QuickConnect: “QuickConnect” is an ASP and C#.net based website related to International calls and their calling
rates. The website uses all major web designing concepts like javascript, XML, dynamic HTML, CSS and much
more. Backend supporting database is MySQL. Here is the quick weblink :
http://dcm.uhcl.edu/c563314fa02chepurin/Main%20code/Htmlpage.html%22
Electronic Room Scheduler (ERS): ERS is a University based scheduling webpage that gives control to manage all
the rooms, buildings and other department’s requirements. The website developed is inspired by the famous MVC
based architecture for better handling of work request. Created the project using Visual Studio 2012 for ASP and C#
related webpages.

More Related Content

What's hot

Chaitanya_Vemparala_Informatica_Resume(2)
Chaitanya_Vemparala_Informatica_Resume(2)Chaitanya_Vemparala_Informatica_Resume(2)
Chaitanya_Vemparala_Informatica_Resume(2)
Chaitanya Prasad
 
Resume ETL-Informatica developer
Resume  ETL-Informatica developerResume  ETL-Informatica developer
Resume ETL-Informatica developer
ajayagrawal92
 
Akram_Resume_ETL_Informatica
Akram_Resume_ETL_InformaticaAkram_Resume_ETL_Informatica
Akram_Resume_ETL_Informatica
Akram Bhuyan
 
Raginee_Sase _CV
Raginee_Sase _CVRaginee_Sase _CV
Raginee_Sase _CV
Raginee Sase
 
Renu_Resume
Renu_ResumeRenu_Resume
Renu_Resume
renu lalwani
 
Resume
ResumeResume
priya_new_resume
priya_new_resumepriya_new_resume
priya_new_resume
Priyanka Girimayagari
 
Himel_Sen_Resume
Himel_Sen_ResumeHimel_Sen_Resume
Himel_Sen_Resume
himel sen
 
"Business Analyst with PMP"
"Business Analyst with PMP""Business Analyst with PMP"
"Business Analyst with PMP"
Debasish Mahapatra
 
Srinivasa Reddy Thallapureddy Duck Creek Project Lead-6.6 Years Exp Resume
Srinivasa Reddy Thallapureddy Duck Creek Project Lead-6.6 Years Exp ResumeSrinivasa Reddy Thallapureddy Duck Creek Project Lead-6.6 Years Exp Resume
Srinivasa Reddy Thallapureddy Duck Creek Project Lead-6.6 Years Exp Resume
Srinivasa Reddy Thallapureddy
 
Resume_Dushiyant
Resume_DushiyantResume_Dushiyant
Resume_Dushiyant
Dushiyant Poptani
 
Rajat cv 1.8
Rajat cv 1.8Rajat cv 1.8
Rajat cv 1.8
Rajat Mohanty
 
Dariush Brief Resume Nov 2014
Dariush Brief Resume Nov 2014Dariush Brief Resume Nov 2014
Dariush Brief Resume Nov 2014
Dariush Navabi
 
Dhritiman banerjee_resume (1)
Dhritiman  banerjee_resume (1)Dhritiman  banerjee_resume (1)
Dhritiman banerjee_resume (1)
Dhritiman Banerjee
 
Resume(1)
Resume(1)Resume(1)
Resume(1)
Murali Ayancha
 
Resume - Santosh B
Resume - Santosh BResume - Santosh B
Resume - Santosh B
Santosh Boggavarapu
 
Shilpa Govindrao Lathkar
Shilpa Govindrao LathkarShilpa Govindrao Lathkar
Shilpa Govindrao Lathkar
Shilpa Lathkar
 
Manoj(Java Developer)_Resume
Manoj(Java Developer)_ResumeManoj(Java Developer)_Resume
Manoj(Java Developer)_Resume
Vamsi Manoj
 
Bhanu prasad profile
Bhanu prasad profileBhanu prasad profile
Bhanu prasad profile
Bhanu Prasad
 
Archana_New (1) (1) (2)
Archana_New (1) (1) (2)Archana_New (1) (1) (2)
Archana_New (1) (1) (2)
Archana Priyankar
 

What's hot (20)

Chaitanya_Vemparala_Informatica_Resume(2)
Chaitanya_Vemparala_Informatica_Resume(2)Chaitanya_Vemparala_Informatica_Resume(2)
Chaitanya_Vemparala_Informatica_Resume(2)
 
Resume ETL-Informatica developer
Resume  ETL-Informatica developerResume  ETL-Informatica developer
Resume ETL-Informatica developer
 
Akram_Resume_ETL_Informatica
Akram_Resume_ETL_InformaticaAkram_Resume_ETL_Informatica
Akram_Resume_ETL_Informatica
 
Raginee_Sase _CV
Raginee_Sase _CVRaginee_Sase _CV
Raginee_Sase _CV
 
Renu_Resume
Renu_ResumeRenu_Resume
Renu_Resume
 
Resume
ResumeResume
Resume
 
priya_new_resume
priya_new_resumepriya_new_resume
priya_new_resume
 
Himel_Sen_Resume
Himel_Sen_ResumeHimel_Sen_Resume
Himel_Sen_Resume
 
"Business Analyst with PMP"
"Business Analyst with PMP""Business Analyst with PMP"
"Business Analyst with PMP"
 
Srinivasa Reddy Thallapureddy Duck Creek Project Lead-6.6 Years Exp Resume
Srinivasa Reddy Thallapureddy Duck Creek Project Lead-6.6 Years Exp ResumeSrinivasa Reddy Thallapureddy Duck Creek Project Lead-6.6 Years Exp Resume
Srinivasa Reddy Thallapureddy Duck Creek Project Lead-6.6 Years Exp Resume
 
Resume_Dushiyant
Resume_DushiyantResume_Dushiyant
Resume_Dushiyant
 
Rajat cv 1.8
Rajat cv 1.8Rajat cv 1.8
Rajat cv 1.8
 
Dariush Brief Resume Nov 2014
Dariush Brief Resume Nov 2014Dariush Brief Resume Nov 2014
Dariush Brief Resume Nov 2014
 
Dhritiman banerjee_resume (1)
Dhritiman  banerjee_resume (1)Dhritiman  banerjee_resume (1)
Dhritiman banerjee_resume (1)
 
Resume(1)
Resume(1)Resume(1)
Resume(1)
 
Resume - Santosh B
Resume - Santosh BResume - Santosh B
Resume - Santosh B
 
Shilpa Govindrao Lathkar
Shilpa Govindrao LathkarShilpa Govindrao Lathkar
Shilpa Govindrao Lathkar
 
Manoj(Java Developer)_Resume
Manoj(Java Developer)_ResumeManoj(Java Developer)_Resume
Manoj(Java Developer)_Resume
 
Bhanu prasad profile
Bhanu prasad profileBhanu prasad profile
Bhanu prasad profile
 
Archana_New (1) (1) (2)
Archana_New (1) (1) (2)Archana_New (1) (1) (2)
Archana_New (1) (1) (2)
 

Viewers also liked

Big Data Analyst at BankofAmerica
Big Data Analyst at BankofAmericaBig Data Analyst at BankofAmerica
Big Data Analyst at BankofAmerica
Ganaparthi Jagadeesh
 
Nikunj arun lotia resume data analyst
Nikunj arun lotia resume   data analystNikunj arun lotia resume   data analyst
Nikunj arun lotia resume data analyst
Nikunj Arun Lotia
 
Emtg Resume
Emtg ResumeEmtg Resume
Emtg Resume
Shahramlotfi
 
kevinhangerresume
kevinhangerresumekevinhangerresume
kevinhangerresume
Kevin Hanger
 
C. Mark Frost Resume
C. Mark Frost ResumeC. Mark Frost Resume
C. Mark Frost Resume
Mark Frost
 
Calvin resume-2007
Calvin resume-2007Calvin resume-2007
Calvin resume-2007
Calvin Harasemchuk
 
Buddy Fambro 2015 resume ver.5
Buddy Fambro 2015 resume ver.5Buddy Fambro 2015 resume ver.5
Buddy Fambro 2015 resume ver.5
Buddy Fambro
 
Resume May 2015
Resume May 2015Resume May 2015
Resume May 2015
Peter Dykhuizen
 
Joseph Guerrero Resume Mark VII
Joseph Guerrero Resume Mark VIIJoseph Guerrero Resume Mark VII
Joseph Guerrero Resume Mark VII
Joseph Guerrero
 
Shirley McDonough Resume_Data Analyst
Shirley McDonough Resume_Data AnalystShirley McDonough Resume_Data Analyst
Shirley McDonough Resume_Data Analyst
Shirley McDonough
 
Data Analyst Resume - Ron Banonis
Data Analyst Resume - Ron BanonisData Analyst Resume - Ron Banonis
Data Analyst Resume - Ron Banonis
Ron Banonis
 
Busman,C_Resume2016
Busman,C_Resume2016Busman,C_Resume2016
Busman,C_Resume2016
Charlene Busman, MS, RN, ANP-BC
 
Caitlin_Resume
Caitlin_ResumeCaitlin_Resume
Caitlin_Resume
Caitlin Frances
 
Most Recent Resume
Most Recent ResumeMost Recent Resume
Most Recent Resume
Michael Angelo Santana
 
Angel_Ocasio Resume
Angel_Ocasio ResumeAngel_Ocasio Resume
Angel_Ocasio Resume
Angel Ocasio
 
Scott hample marketing_mgt
Scott hample marketing_mgtScott hample marketing_mgt
CaseyRichardsonResume
CaseyRichardsonResumeCaseyRichardsonResume
CaseyRichardsonResume
Casey Richardson
 
Basler kate resume_
Basler kate resume_Basler kate resume_
Basler kate resume_
Kate Basler
 

Viewers also liked (18)

Big Data Analyst at BankofAmerica
Big Data Analyst at BankofAmericaBig Data Analyst at BankofAmerica
Big Data Analyst at BankofAmerica
 
Nikunj arun lotia resume data analyst
Nikunj arun lotia resume   data analystNikunj arun lotia resume   data analyst
Nikunj arun lotia resume data analyst
 
Emtg Resume
Emtg ResumeEmtg Resume
Emtg Resume
 
kevinhangerresume
kevinhangerresumekevinhangerresume
kevinhangerresume
 
C. Mark Frost Resume
C. Mark Frost ResumeC. Mark Frost Resume
C. Mark Frost Resume
 
Calvin resume-2007
Calvin resume-2007Calvin resume-2007
Calvin resume-2007
 
Buddy Fambro 2015 resume ver.5
Buddy Fambro 2015 resume ver.5Buddy Fambro 2015 resume ver.5
Buddy Fambro 2015 resume ver.5
 
Resume May 2015
Resume May 2015Resume May 2015
Resume May 2015
 
Joseph Guerrero Resume Mark VII
Joseph Guerrero Resume Mark VIIJoseph Guerrero Resume Mark VII
Joseph Guerrero Resume Mark VII
 
Shirley McDonough Resume_Data Analyst
Shirley McDonough Resume_Data AnalystShirley McDonough Resume_Data Analyst
Shirley McDonough Resume_Data Analyst
 
Data Analyst Resume - Ron Banonis
Data Analyst Resume - Ron BanonisData Analyst Resume - Ron Banonis
Data Analyst Resume - Ron Banonis
 
Busman,C_Resume2016
Busman,C_Resume2016Busman,C_Resume2016
Busman,C_Resume2016
 
Caitlin_Resume
Caitlin_ResumeCaitlin_Resume
Caitlin_Resume
 
Most Recent Resume
Most Recent ResumeMost Recent Resume
Most Recent Resume
 
Angel_Ocasio Resume
Angel_Ocasio ResumeAngel_Ocasio Resume
Angel_Ocasio Resume
 
Scott hample marketing_mgt
Scott hample marketing_mgtScott hample marketing_mgt
Scott hample marketing_mgt
 
CaseyRichardsonResume
CaseyRichardsonResumeCaseyRichardsonResume
CaseyRichardsonResume
 
Basler kate resume_
Basler kate resume_Basler kate resume_
Basler kate resume_
 

Similar to Data Analyst - Nithin C Resume

Nirmal Singh -Resume
Nirmal Singh -ResumeNirmal Singh -Resume
Nirmal Singh -Resume
Nirmal Singh
 
Yogeesh ETL Developer
Yogeesh ETL DeveloperYogeesh ETL Developer
Yogeesh ETL Developer
yogeesh9611
 
Mani_Sagar_ETL
Mani_Sagar_ETLMani_Sagar_ETL
Mani_Sagar_ETL
Mani Sagar
 
Ashish_Maheshwari_Data_Analyst
Ashish_Maheshwari_Data_AnalystAshish_Maheshwari_Data_Analyst
Ashish_Maheshwari_Data_Analyst
Ashish Maheshwari
 
Informatica_Rajesh-CV 28_03_16
Informatica_Rajesh-CV 28_03_16Informatica_Rajesh-CV 28_03_16
Informatica_Rajesh-CV 28_03_16
Rajesh Dheeti
 
Sriramjasti
SriramjastiSriramjasti
Sriramjasti
Sriram Jasti
 
Resume_Alka
Resume_AlkaResume_Alka
Resume_Alka
Alka Shukla
 
RajeshS_ETL
RajeshS_ETLRajeshS_ETL
RajeshS_ETL
Rajesh Sundaram
 
Prasad_Resume
Prasad_ResumePrasad_Resume
Prasad_Resume
Kommoju Prasad
 
ananth_resume
ananth_resumeananth_resume
ananth_resume
Ananth Ram Rallabhandi
 
Pradeepa dharmappa
Pradeepa dharmappaPradeepa dharmappa
Pradeepa dharmappa
Pradeep Pradeep
 
Geetha 6 yrs cv_july-2016
Geetha 6 yrs cv_july-2016Geetha 6 yrs cv_july-2016
Geetha 6 yrs cv_july-2016
Geetha Gayathri G B
 
Geetha_6 yrs_CV_July-2016
Geetha_6 yrs_CV_July-2016Geetha_6 yrs_CV_July-2016
Geetha_6 yrs_CV_July-2016
Geetha Gayathri G B
 
Sreekanth Resume
Sreekanth  ResumeSreekanth  Resume
Sreekanth Resume
srikanth gorantla
 
Resume_Gulley_Oct7_2016
Resume_Gulley_Oct7_2016Resume_Gulley_Oct7_2016
Resume_Gulley_Oct7_2016
William (Bill) Gulley
 
Resume ratna rao updated
Resume ratna rao updatedResume ratna rao updated
Resume ratna rao updated
Ratna Rao yamani
 
Resume_Ratna Rao updated
Resume_Ratna Rao updatedResume_Ratna Rao updated
Resume_Ratna Rao updated
Ratna Rao yamani
 
Resume_Kiran
Resume_KiranResume_Kiran
Resume_Kiran
Kiran Konagala
 
Sr_MicroStrategy_Consultant
Sr_MicroStrategy_ConsultantSr_MicroStrategy_Consultant
Sr_MicroStrategy_Consultant
Mohammed Kaleem
 
AnujGupta_TechnologyConsultant
AnujGupta_TechnologyConsultantAnujGupta_TechnologyConsultant
AnujGupta_TechnologyConsultant
Anuj Gupta
 

Similar to Data Analyst - Nithin C Resume (20)

Nirmal Singh -Resume
Nirmal Singh -ResumeNirmal Singh -Resume
Nirmal Singh -Resume
 
Yogeesh ETL Developer
Yogeesh ETL DeveloperYogeesh ETL Developer
Yogeesh ETL Developer
 
Mani_Sagar_ETL
Mani_Sagar_ETLMani_Sagar_ETL
Mani_Sagar_ETL
 
Ashish_Maheshwari_Data_Analyst
Ashish_Maheshwari_Data_AnalystAshish_Maheshwari_Data_Analyst
Ashish_Maheshwari_Data_Analyst
 
Informatica_Rajesh-CV 28_03_16
Informatica_Rajesh-CV 28_03_16Informatica_Rajesh-CV 28_03_16
Informatica_Rajesh-CV 28_03_16
 
Sriramjasti
SriramjastiSriramjasti
Sriramjasti
 
Resume_Alka
Resume_AlkaResume_Alka
Resume_Alka
 
RajeshS_ETL
RajeshS_ETLRajeshS_ETL
RajeshS_ETL
 
Prasad_Resume
Prasad_ResumePrasad_Resume
Prasad_Resume
 
ananth_resume
ananth_resumeananth_resume
ananth_resume
 
Pradeepa dharmappa
Pradeepa dharmappaPradeepa dharmappa
Pradeepa dharmappa
 
Geetha 6 yrs cv_july-2016
Geetha 6 yrs cv_july-2016Geetha 6 yrs cv_july-2016
Geetha 6 yrs cv_july-2016
 
Geetha_6 yrs_CV_July-2016
Geetha_6 yrs_CV_July-2016Geetha_6 yrs_CV_July-2016
Geetha_6 yrs_CV_July-2016
 
Sreekanth Resume
Sreekanth  ResumeSreekanth  Resume
Sreekanth Resume
 
Resume_Gulley_Oct7_2016
Resume_Gulley_Oct7_2016Resume_Gulley_Oct7_2016
Resume_Gulley_Oct7_2016
 
Resume ratna rao updated
Resume ratna rao updatedResume ratna rao updated
Resume ratna rao updated
 
Resume_Ratna Rao updated
Resume_Ratna Rao updatedResume_Ratna Rao updated
Resume_Ratna Rao updated
 
Resume_Kiran
Resume_KiranResume_Kiran
Resume_Kiran
 
Sr_MicroStrategy_Consultant
Sr_MicroStrategy_ConsultantSr_MicroStrategy_Consultant
Sr_MicroStrategy_Consultant
 
AnujGupta_TechnologyConsultant
AnujGupta_TechnologyConsultantAnujGupta_TechnologyConsultant
AnujGupta_TechnologyConsultant
 

Data Analyst - Nithin C Resume

  • 1. Nithin C 628 Yosemite Ave, Naperville, Illinois - 60563 Email: sqldev.nithin@gmail.com Ph: (662) 631-4639 SUMMARY  Over 3 years of strong experience in Analysis, Design and Development of Business Intelligence Solutions in  Data Warehousing using Microsoft BIDS 2008 or Informatica PowerCenter 9.1 as an ETL tool on Windows and UNIX based operating systems.  EXPERIENCE Apr’15 – Current DW & ETL Analyst, Blue Cross Blue Shield, Naperville, IL Blue Cross Blue Shield is a well reputed health insurance company. The project I’m working on is: ‘ACH Email Notification’, which sends pre notification to the member regarding draft information. It calculates the estimated amount to be drafted on a specific day and sends a notification to the member with specific prior days to draft day. The project involves multiple teams, communicated well with different teams to make sure project timelines didn’t get affected. I created ETL’s to indentify the specific day population, process the estimated amounts and send notification. For estimated amounts, I created Aggregate transformation, Conditional Split task. I used fixed length flat file source to import data from Nacha file. The project was developed based on Agile methodology.  Worked with SSIS packages and zena scheduler.  Used transformations like Fixed Length Flat File Source, lookup, Aggregator, Store Procedure, Rank, Data Conversion, Conditional Split and Sequence generator.  Used performance tuning techniques to minimize the run time and create pre-session caches with good load being balanced on server.  Created email task to send an email on package failure.  Used Zena to schedule the SSIS package.  Worked with testing team and provided required support to them. Quickly fixed the issues and provided new build to the testing team.  Handle the Migration process from Development, Test and Production Environments.  Communicated well to project manager and team on the impact of the issues to the overall timeline, and project deliverables.  Reviewed the design and requirements documents with architects and business analysts to finalize the design. Environment: Microsoft Visual Studio 2008, Microsoft Visual Studio 2013, Microsoft SQL Server 2008, Zena, WinSCP. Oct’11 – July’13 Data Analyst, GGK Technologies, Hyderabad, India  Worked with Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor.  Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filters, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.  Created workflows containing command, email, session, decision and a wide variety of tasks.  Prepared ETL flow of data from Staging to Data Mart.  Used Informatica as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.   Designed and Developed mappings to extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.  Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner and Update Strategy for developing mappings involving complex business logics.  Developed shell scripts, PL/SQL procedures for creating/dropping of table and indexes of performance for
  • 2. pre and post session management.  Used ETL, Informatica Designer to design mappings and coded it using reusable mapplets.  Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.  Implemented Type 2 slowly changing dimensions to maintain dimension history and Tuned the Mappings for Optimum Performance.  Environment: Informatica PowerCenter 9.1, Oracle 10g/ 9i, TOAD, MySQL, PL/SQL, UNIX, Eclipse Helios. Aug’11- Oct’12 Associate Software Engineer, GGK Technologies, Hyderabad, India  Developed java project using Springs 2.0 and Hibernate.  The RTRS project was developed based on MVC based architecture for better handling of work request.  Used Hibernate to fetch data from MySQL database and send the response to the controller.  Used Springs for business logic.  Used JQuery, Javascript and CSS for look and feel of the UI.  Supported testing team and fixed issues in quickly manner. Environment: Eclipse Helios, MySQL. EDUCATION:  Masters of Science, Computer Software Engineering (2013-2014) from University of Houston - Clear Lake, Houston with CGPA of 3.45.   Bachelor of Engineering, Computer Science from Jawaharlal Nehru Technological University - Hyderabad, India with an aggregate of 68.32% that is CGPA of 3.2.  Technical Skills: ETL/Middleware Tools Informatica PowerCenter 9.1.1, Microsoft BIDS 2010. Data Modelling Dimensional Data Modelling, Star Join Schema Modelling, Snow-Flake Modelling, Fact and Dimension tables, Physical and Logical Data Modelling. Business Intelligence Tools Microsoft Visual Studio 2012, Microsoft Visio 2010, OBIEE 11g/10.1.3.x RDBMS Oracle 11g/10g/9i, MS SQL Server, DB2, MySql. Programming Skills SQL, Oracle PL/SQL, Unix Shell Scripting, Ad-Hoc SQL, HTML, DHTML, Python, CSS, XML, Java, C#.Net, Javascript, Object Oriented Programming. Tools TOAD, SQL Plus, SQL*Loader, Quality Assurance, Soap UI, Fiddler ALM, Eclipse. Independent Course Hadoop. Scheduling Tool Zena, Sql Agent. Course Projects: QuickConnect: “QuickConnect” is an ASP and C#.net based website related to International calls and their calling rates. The website uses all major web designing concepts like javascript, XML, dynamic HTML, CSS and much more. Backend supporting database is MySQL. Here is the quick weblink : http://dcm.uhcl.edu/c563314fa02chepurin/Main%20code/Htmlpage.html%22 Electronic Room Scheduler (ERS): ERS is a University based scheduling webpage that gives control to manage all the rooms, buildings and other department’s requirements. The website developed is inspired by the famous MVC
  • 3. based architecture for better handling of work request. Created the project using Visual Studio 2012 for ASP and C# related webpages.
  翻译: