Sql Server Project

N Anjaneyulu

Email ID: **********.******@*****.***

Mobile: +91-990*******

Career Goal:

Seeking a challenging position where my knowledge and aptitude can be shared enriched; participate and contribute to the development of the business and organization, prove my true potential in the given tasks.

Work Profile Summary:

• Having Two years of Experience in developing application using the Sql Server.

• Hands on experience in developing the database objects like tables, views, functions and stored procedures.

• Good experience in creating SSIS Packages.

• Hands on experience in developing application with SSRS and SSAS.

• Strong Skills in performance tuning and following the best coding standards.

• Experience in SDLC and Agile development.

• Sometimes I handled Change Requests (CRs), Issue Logs and Defect Track Sheets.

• Hands on experience in managing different environments like Development, SIT and migrated data between them.

• Domain knowledge in Insurance management.

SSIS:

• Created Solutions, Projects and Packages and managing them.

• Worked with various tasks such as Control Flow (For loop Container, For each loop container, Data flow task, File system task etc.).

• Worked with various Transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge Join, Multicast, Conditional Split, Derived Column etc.

• Worked with Logging and Error handling in various projects.

• Implemented SCDs (Slowly Changing Dimensions) while history maintenance in tables.

• Involved in the loading of Direct, Incremental and Historical loading process.

• Involved in Performance Tuning at different levels.

• Created unit test cases and prepared technical specifications for SSIS packages.

• Implemented Check Points at Package level.

SSRS:

• Created Simple, Complex and Adhoc Reports using report builder and wizard.

• Implemented Sub totals, Aggregations and applied various formations.

• Created Parameterized reports in SSRS.

• Implemented Actions at various levels.

• Created Table, Matrix, Chart and other types of reports.

• Able to Analyse and Answer Adhoc queries of Business users.

• Involved in Performance Tuning at different levels.

Professional Experience:

• Organization : MindTree Ltd., Bangalore.

• Duration : April-2010 to till date.

Certifications:

• 70448- MSBI (Microsoft Business Intelligence) Application Development.

Achievements:

• Got the best IT Vendor award.

• Got many prizes in School and College levels in cricket.

Education:

• Completed Master of Computer Applications from SASTRA University (2008-2010) (76%)

• Completed Bachelor of Science from S.K. University (2005-2008) (78%).

Skill Set:

Programming Skill : C, C++ and .NET.

Data Bases : MS-Access, SQL Server 2005/2008.

Operating Systems : Windows Family.

Network Technologies : TCP/IP, FTP.

Projects:

Project#1:

Project Title : Insurance Management System.

Client : International Insurance Group Inc. (IIG), US.

Technologies : SSIS, C#, SQL Server 2008.

Duration : Aug-2011 to till date.

Environment : Sql Server Integration Services (SSIS), SQL Server 2008,

Windows Server 2000/2003.

Team Size : 6

Synopsis:

IIG is one of the leading U.S based international insurance and financial services organization. It is the largest commercial and industrial insurance in the US.

The Key features are

• To provide information on the sales of their products by the entire group of companies and marketing analysis.

• To view data into a structured format and designed to provide valuable information for their sales.

• Pull the data from different sources and exploring the processed data into reports in different formats.

• Help their business decision making.

My Role:

• Key responsibilities are designing and developing the SSIS packages.

• Creating SSIS packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Union, Sort and Multi cast to load data into database.

• Working with Data flow task and Execute Sql task frequently.

• Implementing Logging, Check Point configuration, Package configuration.

• Implementing SCDs (Slowly Changing Dimensions) while history maintenance in tables.

• Involving in the loading of Direct, Incremental and Historical loading process.

• Involving in Performance Tuning at different levels.

Project#2:

Project Title : EBDW (Enterprise Banking Data Warehouse).

Client : (5/3) Fifth Third Bank.

Technologies : SSRS, Sql Server 2008.

Duration : April-2010 to July-2011

Environment : Sql Server Reporting Services (SSRS), Sql Server 2005,

MS Access 2007.

Team Size : 7

Synopsis:

Fifth Third diversified financial services company has been providing quality financial products and services to its customers.

The key Features are

• This project focused on maintaining, and optimizing the existing databases.

• Monitoring database performance and growth, performance tuning.

• create reports according to the business requirements using

Sql Server Reporting Services (SSRS).

My Role:

• Created Simple, Complex and Adhoc Reports using report builder and wizard.

• Implemented Sub totals, Aggregations and applied various formations.

• Created Parameterized reports in SSRS.

• Implemented Actions at various levels.

• Created Table, Matrix, Chart and other types of reports.

• Designed and developed Matrix and tabular reports with drill down, drill through and drop down menu options using SSRS.

• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS).

Personal details:

Name : Namala Anjaneyulu

Marital Status : Single

Sex : Male

Date of Birth : 4th May, 1988.

Pan Card : AXXPA1072E

Languages : English, Telugu, Hindi and Tamil.

(N. Anjaneyulu)

Contact this candidate