AVAILABLE SQL SERVER/BI DEVELOPER WITH SSIS,SSRS,SSAS CONSULTANT
Arun Kumar
· Nearly Eight years of IT experience in Database Design and
Development of SQL Server 2000/2005/2008.
· Extensive experience in installation and configuration of MS SQL
Server 2000/2005/2008 versions.
· Experience in working with Windows server 2003, Windows 2000 Advance
Server and Windows NT Server Installation and Administration.
· Experience in writing and debugging Stored Procedures and Triggers.
· Extensive knowledge of Relational Database Management Systems.
· Involved in optimizing code and improving efficiency in databases
including re-indexing, updating statistics, recompiling stored procedures and
performing other maintenance tasks.
· Experience in implementing business logic using Triggers, Views and
Stored procedures.
· Hands on experience in creating ETL packages using SQL Server 2005
Integration Services (SSIS) and creating OLAP cubes using SQL Server 2005
Analysis services (SSAS).
· Extensive experience in Data Migration, Data Conversions, Data
Extraction/ Transformation/Loading (ETL) using DTS and PL\ SQL Scripts.
· Experience in designing logical and physical data models using ERWIN
and Visio tools.
· Good understanding in database and data warehousing concepts (OLTP &
OLAP).
· Transformed data from one server to other servers using tools like
Bulk Copy Program (BCP) and Data Transformation Services (DTS).
· Migration from Oracle to SQL Server through DTS Packages.
· Upgrade DTS packages to SQL Server Integration Services (SSIS).
· Experience in Normalization and building Referential Integrity
Constraints, Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema,
FACT and Dimensional tables and Operational Data Store (ODS).
· Expertise in generating reports using SSRS and Excel Spreadsheet.
· Experience in designing, maintaining and implementing data marts.
· Experience in Performance Tuning, Query Optimization, Execution Plan,
Client/Server Connectivity, Database consistency checks using DBCC Utilities.
· Design and Development Experience in Large Complex Multi-terabyte data
environments.
· Using Performance Monitor/Profiler to solve Dead Locks/Long running
queries.
· Experience in Database Backup, Recovery and Disaster Recovery
procedures.
· Hands on experience in trouble shooting database issues.
· Comfortable working with Oracle 9i - PL/SQL programming and SQL * Plus.
· Has very strong background in a disciplined software development life
cycle (SDLC) process and has excellent analytical, programming and problem
solving skills.
Technical Skills:
Operating Systems
MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server, UNIX
Programming Languages
C, JAVA, Unix Shell Scripting, T-SQL, PL/SQL
RDBMS/Databases
MS Access, MS SQL Server 2000/2005/2008, Oracle 8i/9i
Data Modeling
ERWIN, MS Visio
Database Tools
SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL
Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence
Development Studio, Data Transformation Services, SQL * Loader.
Web Technologies
HTML, DHTML, XML, XSL, XSLT, ASP, VB, Java Script, JSP, Servlets
Multimedia
Adobe Photoshop
Web Servers
IIS, Tomcat 4.01
Sandeep
Business Development Executive
TT Technologies, Inc
Voice:516-439-7897
Fax: 212-658-9460
sa...@t3incorp.com
sandeep.t3inc...@gmail.com
www.t3incorp.com
--
You received this message because you are subscribed to the Google Groups
"REQSRESUMES" group.
To post to this group, send email to reqsresu...@googlegroups.com.
To unsubscribe from this group, send email to
reqsresumes+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/reqsresumes?hl=en.
