Name:Anderson
EMail-Id:[email protected]
Contact No:9854658210

CAREER OBJECTIVES

To obtain a challenging position, utilizing abilities developed through my education, with the opportunity for professional growth based on performance.

WORK EXPERIENCE
1.) Software Developer

MGM Data Warehouse acquires data from the various data sources of the system and insert or update data into Data warehouse. This data warehouse allows the Management for effective decision-making and to transform product centric approach to customer centric approach to gain competitive advantage by combining data from different sources. The system has heterogeneous data stores and operational systems supporting its operational infrastructure.

Roles & Responsibilities:

  • Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.
  • Creating jobs for scheduling the SSIS packages.
  • Getting data from different data sources.
  • Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc.
  • Loading these data into data warehouse like SQL server.
  • By using these data warehouse, based on client requirement we generate the multilingual reports in SSRS.
  • Identifying of performance bottlenecks, Performance tuning of packages.
  • Developed different types of reports according to the requirements, also generated Adhoc reports.
2.) SSRS and SSIS Developer

Title: Hospitality – Host

PMS Development includes different modules. Client Module used to maintain client information such as Contracts, Reservation, Account, Marketing Tours, and Customer Services.Reservation module with reservation types, agents, rates, marketing information, segments and rules. Maintenance of different type such as Club, Exchange, Fixed, Floating, Free Stay, Marketing (Non Owner), Marketing (Owner), Rental, Tour Operator and Trial Membership.

Roles & Responsibilities:

  • Analyzing the requirements and design documents and understanding the functionality of both source and target systems.
  • Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.
  • Created systems for capturing error data in flat file using flat file destination, sending the error data in flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data.
  • Created Jobs and implemented it, Reconciliation across various source systems.
  • Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.
  • Identifying the bottlenecks (in sources, targets, and packages) and tuning it.
  • Created simple reports for the end user delivery purpose.
3.) SSRS and SSIS Developer

Title: Staffing Guide

This project is developed to forecast the number of staff required on one particular day across several roles in a resort based on the occupancy of the resort. Staff requirement shall be calculated by providing number of rooms occupied. On any given situation the management shall calculate the number of staff required and the cost involved in it. Application suggests the number of staff required for each role on a specific date but the management has the right to change it

Roles & Responsibilities:

  • Understand data requirements from the business analyze source data and derive required datasets.
  • Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, and sort and execute SQL Task to load data into Data Warehouse.
  • Created Event Handlers to Handling Errors and Debugging for the Packages.
  • Designed and developed the ETL process (SSIS packages) to make the data available from various relational databases, excel, flat files etc., for analysis and reporting purposes.
  • Created Jobs and implemented it for scheduling the SSIS packages on a daily basis.
  • Utilized multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union-all.
EDUCATION
Course (Stream)/ Examination
Institution/University/School
Year of Passing
Performance
B.E. in CSEAnna university – Chennai, Tamil Nadu201380%
HSCVetri Vikkaas Higher Secondary School200984%
SSLCVetri Vikkaas Higher Secondary School

2007

80%

SKILLS
  • .Net (Less than 1 year)
  • ASP (Less than 1 year)
  • ASP.Net (Less than 1 year)
  • BI (Less than 1 year)
  • BUSINESS INTELLIGENCE (Less than 1 year)
ADDITIONAL INFORMATION

Technical Skills:

  • ETL Tools: SQL Server Integration Services (SSIS)
  • Reporting Tools: SQL Server Reporting Service (SSRS)
  • Data Visualization tools: Power BI and Datazen
  • Platform: C#.Net, ASP.Net
  • DBMS Packages: SQL Server (2008 & 2012)
  • Front-end: Microsoft Visual Studio .NET (V4.0)
  • Design: Expression Studio (Blend & Web)
  • Web Technologies: HTML

Strengths:

  • An effective team player with strong troubleshooting and problem solving skills.
  • Achievement oriented and smart worker.
  • Maintains a healthy relationship with all team players and ensure in getting maximum productivity from each.
  • Strong communication, interpersonal, learning and organizational skills

Date:
Place:                                                                                                                                                                    (Name)

Categorized in:

Developer Resume

Tagged in:

, , , , , , , , , , , ,