Software Developer Data
Resume:
Balaraju H R ***********@*****.***
SUMMARY
Having 5.5 years of Professional experience in IT industry, Involved in SQL Server 2008R2,2012,2016 & MSBI Technologies such as SQL Server Integration Services (SSIS), Power BI, MYSQL & knowledge on Azure Sql Data Warehouse, projects with extensive usage of ETL & Reporting tools.
Have worked in multiple projects as BI Developer in Designing ETL Packages and reports in development and implementation stages of the Project according to client requirements.
Having experience in designing and developing the SSIS packages with different types of control flow tasks and d data flow Transformations, security and deploying the packages.
Experience in Debugging, Error handling and deploying the SSIS Packages.
Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, multicast, Derived column, Union All, Merge Join, Merge and Scd to load data into SQL Server destination.
Creating the reports as per client’s requirements in the form of table, matrix, and list.
Having knowledge in creating cube
Extensive knowledge on SQL Server 2005 and SQL Server 2008R2,2012,2016.
Having good knowledge in indexes, joins, views, stored procedures, functions, constraints, cursor and triggers.
Good communication, inter-personnel skills and good team player.
Self-motivated individual with strong analytical and problem solving abilities, Proactive, Dedicated, enjoy learning new technologies and willing to take on extra responsibilities to get work done.
EDUCATIONAL QUALIFICATION
Qualification
Name of the institution
University / Board
Year of passing
Marks in %
MCA
Dr Ambedkar Institute of Technology, Bangalore
VTU
2013
79.49
B.Sc(Computer Science)
Bharathi Education Trust.
University of Mysore
2010
62.21
WORK EXPERIENCE
Working as Software Developer in Flipkart Internate Pvt Ltd. from Mar 2016 to till now.
Working as Software Developer in Empulse Global Pvt Ltd, Mysore from Mar-2014 to Mar 2016.
TECHNICAL SKILLS
Database
SQL Server2008R2,2012,MYSQL
Operating systems
Windows 2003/XP/Windows7
ETL tools
SQL Server 2008 Integration Services
Reporting tools
Power BI
Language
Php, Javascript & HTML
PROFESSIONAL EXPERIENCE
Project #1
Title :Call Drivers
Client : Flipkart
Environment : Windows7.
Tools Used :SSIS,SQL Server 2016,Power BI
Role : Development and Support.
Duration : 6 year
Team Size : 2
PROJECT DESCRIPTION
The plan is to create an interface for issue types data model which customers contacting for issues. Created all possible dimensions like Channel, Partner, Location & Month, weekly, day & Interval wise on number of issues contacted by customers. Data process: All different types batch files to be processed in SSIS package. Data have been pushed every hour by automated in task scheduler.
Roles and Responsibility:
ETL development and support.
Wrote simple queries to be used in the SSIS packages.
Analysis and Development of query for Ad-hoc reports based on user requirements.
Design and implement a new data warehouse for F&B executives to show them various Operational metrics
Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.
Project #2
Title : Voice Dashboard
Client : Flipkart
Environment : Windows 7.
Tools Used :SSIS,SQL Server 2012, Power BI,MDX,DAX
Role : Development and Support.
Duration : 1 year
Team Size :5
Flipkart is planning to build an analytic solution which will help the Customer experience teams and other operational stakeholders to analyze the Operational performance of various components/processes across the organization and will provide support in Decision making Main objectives of the Voice Dashboard Reporting project are to:
1.Design and implement a Power BI voice Dashboard to show them various Operational metrics.
2.Experience in working with SSIS & Power BI, data source views, named queries, dimensions and deploying of analysis services projects.
3.Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.
Responsibilities:
Responsible for creating SSIS packages to extract data from different sources and merge into one source.
Created custom and Ad hoc reports using POWER BI.
Generated several drill down and drill through reports using POWER BI
Used SSIS packages to implement Extraction, Transformation and Load (ETL)
Modified existing SSIS packages to meet current business needs
Project #3
Title : CSAT
Environment : Windows 7.
Tools Used : SSIS, SQL Server 2012, Power BI
Role : Development and Support.
Duration : 6 Months
Team Size :3
PROJECT DESCRIPTION
The Key of KPI’s enabled is NPS,Promoter%, Rating spread, Agent rating by Time series, Channel, Partner, Location, Journey node dimensions and Agent/LOB/Partner Comparison analysis by week/month helps end user to take quick decision.Dash pushed by csv unformatted files.
Roles and Responsibility:
ETL Development
Requirement Master, Data Modeling, Data Migration,
Design the package, Creating table for Requirement Master.
Creating Power BI Visual.
Development & Support.
PERSONAL DETAILS:
Current Address
LNS PG,#2/2 Govardhan Residency, Near Intel & Accenture, Bellandur Post, Devarabisanahlli, Bangalore - 560037 Hyderabad -500016
Languages Known
English, Kannada, Hindi
DECALRATION:
I hereby declare that the information mentioned above is true to the best of my knowledge.
Bangalore (Balaraju H R)
Contact this candidate