Sql Server Data
Resume:
SUDHAKARA N (:
*********.***********@*****.***
PROFILE SUMMARY
Having 3+ years of Professional experience in IT industry, Involved in MSBI
projects with extensive usage of ETL & Reporting tools like SQL Server
Integration Services (SSIS), SQL Server Reporting Service (SSRS) and SQL
Server.
> 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.
> Extensive experience in joins, indexes, views, stored procedures,
functions and sub queries.
> Used Control Flow Tasks like For Loop Container, For Each Loop Container,
Sequential Container, Execute SQL Task, FTP Task and Data Flow Task in
Designing packages.
> Proven proficiency at Data Transformations like Lookup, Derived Column,
Conditional Split, sort, data Conversion, Union All, Merge Join, SCD and
OLEDB Command to load data into SQL Server destination.
> Experience in providing Error Logging and Error handling for SSIS
Packages.
> Having extensive experience in deploying SSIS Packages and scheduling
them.
> Designed different reports like Matrix, Drill Down, Drill Through and Sub
reports.
> Creating the reports as per client's requirements in the form of table,
matrix and Chart.
> Experience on Report Design, Development and Deployment using SSRS.
> Scheduling the Reports Weekly and Monthly basis as per the Client
Requirements.
> Extensive knowledge on SQL Server 2008.
> Knowledge on Dynamic SQL evaluated in stored procedures.
> Good knowledge on data warehousing concepts.
> Good communication, inter-personnel skills and good team player.
TECHNICAL SKILLS
> Technologies : Microsoft Business Intelligence Tools (MSBI)
> Operating Systems : Windows 2007 / XP, Windows Server 2008
> Databases : SQL Server 2008 R2
> ETL Tools : SQL Server 2008 Integration Services
> Reporting Tools : SQL Server 2008 Reporting
Services
> Utilities : SQL Server Management
Studio(SSMS)
PROFESSIONAL EXPERIENCE
> Currently Working as a Software Engineer with NTT DATA Global Delivery
Services Limited in Bangalore from Aug 2013 - Till date.
> Worked as Software Engineer with Manhattan Associates Development centre
Pvt. Ltd. in Bangalore from May 2011 - July 2013.
EDUCATIONAL PROFILE
> Bachelor of Technology from Jawaharlal Nehru Technological University,
Anantapur.
PROJECT EXPERIENCE
Project #1
Title : Retail Sales Analysis Systems
Client : Tiger Direct, USA
Role : SSRS, SSIS Developer, T-SQL, SQL
Environment : SSIS, SSRS, SQL Server 2008
Duration : Aug 2013 - Till date
Description:
Tiger Direct is a direct online and catalog retailer of computers and
consumer electronics .The core aim of this project was to support the
broader set of analytic needs. This data Warehouse design process includes
data extracted periodically from the applications that support business
processes and validated, reformatted, reorganized, summarized, restructured
and finally loaded into Data warehouse systems. The resulting data
warehouse is the main source of information for report generation,
analysis, and presentation through ad hoc reports and dashboards.
Responsibilities:
> Extracting data from multiple sources like flat files, oracle, and SQL
server and transforming, cleansing, validating data and loading into
final Destination.
> Designing packages Using Control Flow Tasks like For Loop Container,
For Each Loop Container, Sequential Container, Execute SQL Task and
Data Flow Task.
> Extracting data from sources and transforming the data using different
transformations like data conversion, derived columns, look up,
Conditional Split, Aggregate, Union all, merge join and multi cast
transformations.
> Creating Event Handlers for the Packages Using Event Handler Tab for
Error Handling.
> Creating Configurations to change the package properties dynamically.
> Maintaining log information in SQL table to tracking Errors and
recording package execution status.
> Building and Deploying packages to SQL server and Scheduling Packages
for Intra Day and End of Day execution.
> As per requirements developing the reports in the form of Matrix,
Table and Chart using SQL Server 2008 Reporting Services.
> Designing Different Types of reports like Drill Down, Drill Through,
Sub Reports and Parameterized Reports.
> Development of reports using different SSRS Functionalities like sort
prompts and cascading parameters, Multi Value Parameters.
> Good knowledge in using report manager and giving security according
to roles hierarchy.
> Developing Report Models and Ad Hoc Reports using Report Builder.
> Scheduling Reports Weekly and Monthly basis as per the Client
Requirements.
Project #2
Title : Business Financial Services
Client : Weatherbys Bank Ltd, UK
Role : ETL Developer
Technology : SSIS, SSRS, SQL Server 2008
Duration : July 2012 to July 2013.
Description:
Weatherbys Bank Limited is a member of the Financial
Services Compensation Scheme.
The genuinely personal service we offer every one of our clients helps set
us apart from many of our competitors. The data ware house maintenance the
client information like customer profile, credit grade, banking location
and the details about which programs the client has been enrolled.
Performing regular data loads and data validation, production support and
monitoring the load activities. Resolving the defect tickets and designing
data marts for business. So the Bank wanted a Single Window Business
Intelligence Application for Bank's operational Efficiency. This project is
to provide different reports for making intelligent decision on data
available in various branches across the worldwide connected over a period
of time.
Responsibilities:
> Involved and understanding the requirements at KT sessions.
> Involved in developing ETL for loading data into Database.
> Created Packages on SSIS by using different data Transformations like
Derived Column, Conditional Split, Pivot, Multicast, Sort and Execute
SQL Task to load data into data warehouse.
> Identified and tracked the slowly changing dimensions.
> Involved in performance tuning.
> Generated the Drilldown Reports.
> Generated the Drill through reports.
> As per the requirements developed the reports in the form of Matrix,
Table and Chart Using SQL Server 2008 Reporting Services.
> Generated the Reports weekly, monthly, Quarterly and yearly basis as
per the client requirements.
Project #3:
Title : Health Care
Client : Sun Pharma, Mumbai
Role : ETL Developer
Environment : SSIS, SSRS, SQL Server 2008
Duration : May 2011- June 2012
Description: The sixth healthcare company in the top 10 list is Sun Pharma.
The core business of the company is Pharmaceuticals and making drugs. This
project is to automate the transactions of the Hospital Management System.
This project contains Patient care administration, Patient care services,
financial management system and Administrative service. Patient care
administration is the main module. In patient care administration, by
physician order, the patient is registered and further process is done. In
patient care service by physician order, we can give the clinical services
to the patient. In the financial management module contains patient bill
preparation payroll and vendor payments. Administrative Service module
contains scheduling of doctors, nurse, wards, and Inventory system.
Responsibilities:
> Involved in understanding the requirements and KT sessions.
> Created Packages on SSIS by using different data Transformations like
Derived Column, Conditional Split, Pivot, Multicast, Sort and Execute
SQL Task to load data into data warehouse.
> Developed of SSIS packages, which retrieve data from various sources
and used data transformations
> Created transformations and mappings using data flow tasks.
> Identified and tracked the slowly changing dimensions.
> Loaded data into fact and dimension tables by creating SSIS packages.
> Scheduled Jobs to execute SSIS packages.
> Generated the Drilldown Reports.
> Generated the Drill through reports.
> As per client requirements generate the reports in the form of Matrix,
Charts.
> Unit tested the packages.
Contact this candidate