BI Developer resume Atlanta,GA - Hire IT People

Summary:

3+ Years of experience in SQL Server Developer.
Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user functions, SQL joins and query writing.
Knowledge in Microsoft Business Intelligence technology SQL Server ReportingServices (SSRS), SQL Server Integration Services (SSIS).
Knowledge in TIBCO BW, and Visual Studio.
Knowledge in Java Script, ASP.NET, and T-SQL with database analysis and design.
Knowledge in query analyzer, profiler and database components.
Knowledge with all phases of software development life cycle (SDLC).
Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

Certifications:
Microsoft Certified Technology Specialist (MCTS) SQL SERVER 2008, Database Development.

WORK EXPERIENCE:

Confidential,Atlanta,GA(11/2011- Current)
Role: BI Developer

Generated reports usingSQLServerReporting Services 2005/2008/R2.
Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.

Confidential, Atlanta,GA(01/2011- 11/2011)
Role: SQL Developer/SSRS Developer

Generated reports usingSQLServerReporting Services 2005/2008/2008R2.
Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
Created report models and deployed on reportserver.
Created and tuned stored procedures, triggers and tables.
Used Execution Plan,SQLProfiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
successfully tested all task in staging and stored all versions of data using team foundationserver (TFS).

Confidential, Baroda, India (01/2007 12/2007)
Role: SQL Developer/BI Developer

Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.
Created views to restrict access to data in a table for security.
Developed computer information resources, providing for data security and control, strategic computing, and disaster recovery.
Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.

Education:

Master of Science in Computer Science

Bachelor of Engineering, Information Technology