OBJECTIVE:

• Facing challenges in the area of software development and contribute to the growth of the organization, along with updating myself with the latest emerging technologies.

SUMMARY:

• 9 years of experience as Sr. SQL Server Database Developer/Business Intelligence (BI) Developer. Primary skills include expert knowledge of MS SQL Server 2000/2005/2008 and Business Intelligence.
• Hands on experience in MS SQL Server Management Studio, MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Integration Services (SSIS).
• Involved in Database designing and modeling (ER Diagram)
• Advance knowledge of Relational database theory and Normalization.
• Responsible for creating/ editing various SQL Server database objects (e.g. T - SQL, Joins, Indexes, Constraints, Stored Proc, Trigger, User Defined Functions (UDF), User Defined Data types).
• Working experience of large databases (approx 10 terabyte) with zero interruption.
• Have created Development utilities like Command (LST (list of tables), and LSP (list of stored proc)).
• Experience in Transactional Replication
• Configuring SQL Server 2005 for XML Support along with using new SELECT statement options to retrieve results in XML (FOR XML)
• Working knowledge of Clustering
• Structuring XML: DTDs and XML Schemas
• Worked on SAN environment
• Proficient in Performance Tuning, Query Optimization, client /Server Connectivity, stored procedure and in checking database consistency using DBCC Utilities.
• Monitoring and tuned MS-SQL Server databases with tools like Index Tuning Wizard, SQL Profiler and windows Performance Monitor for optimal Performance Tuning
• Used Linked servers for connecting various other database Servers
• Expertise experience in data migration from MS SQL Server 2000/Mainframe DB2/VSAM Files/Oracle 9i/Flat files Files To MS SQL Server 2005/2008.
• ETL expertise in using tools like DTS/SSIS, Bulk Insert and creating DTS/SSIS Packages.
• Used MS- Access for Data Validation.
• Used VB /C# Scripting with in SSIS and SSRS
• Configured /Used Share point for Deploying SSRS Reports.
• Proven experience designing complex and ad hoc reports. Experience gathering requirements and translating them into technical specification.
• Used Dundas tool for chart/graph/Gauge with SQL Server Reporting Services
• Developed reports in Seagate Crystal tool
• Knowledge of statistical concepts and their application in reporting and data mart applications
• In-Depth Knowledge in Data Warehouse Design
• In - depth knowledge of MS SQL Server Analysis Services, Cubes, Data Mining, MDX, DMX
• Performance Tuning and Optimization of Cubes/MDX
• Used data warehouse methodologies(Kimball)
• Working Knowledge in ProClarity and Performance Point
• Exposure in Team foundation Server (TFS) Scripting
• Used Visual Source Safe (VSS) and Team Foundation Server 2008 (TFS) for configuration management and versioning.
• Proven track record of an excellent team player with problem solving and troubleshooting capabilities.
• Good Exposure in Documentation (technical design document, detailed design stored proc document and front-end User development guide).

TECHNICAL SKILLS:

Databases/ Servers: MS- SQL Server 2008/2005//2000/7.0 , Microsoft SQL Server Analysis Services 2005/2008, Microsoft SQL Server Integration Services 2005/2008, Microsoft SQL Server Reporting Services 2000/2005/2008 , Oracle 8i and DB2, MS SharePoint 2007 and Team Foundation Server 2008

OLAP/Data warehousing: OLAP/OLTP, Data warehousing schema (Star/Snowflakes), Cubes, MDX Query

Modeling: Microsoft Visio 2007

Programming/ Technologies: T-SQL, PL/SQL/ Embedded SQL, O-SQL, SQL CMD, BCP, ASP 3.0, ActiveX Script, VB Script, C#, Transact- SQL(T - SQL), ODBC, ADO

Tools: DTS, SSIS, SQL Profiler, SQL Management Studio, SQL Query Analyzer, SQL Mail, SQL Server Agent, Export/Import Utility, SQL Reports, Crystal Report 9/8.0/7.0/6.5 , Dundas, MS Visual Studio 2005/2008, Visual Source Safe, Team foundation Server 2008, Execution plan, Ultra Edit, MS- Access and MS Excel Sheet.

PROFESSIONAL EXPERIENCE:

Confidential, Lincoln N E

Sr. SQL Server Developer / BI Consultant

Environment: MS SQL Server 2008 and Main Frame DB2, Business Intelligence - MS SQL Server Integrated Services (SSIS), SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS), Team Foundation Server 2008 MS SharePoint 2007, C# and TFS Scripting

Responsibilities:

• Involved in creating SSIS packages (1000) for data Conversion through SQL Server Integration Services Tool.
• Code Development using SQL Server 2008, SQL Server Integration Services 2008, C# and Team Foundation Server 2008
• Used Agile methodology for project management process
• Prepared SSIS Packages Design Pattern for developing the SSIS Packages.
• Used Report Builder 2.0 for creating the report
• Worked on Microsoft Visual Studio 2008
• Used Kimball data warehouse methodologies for designing the data warehouse
• Develop, Code and test Data conversion Programs
• Used Share point 2007 for Deployment of Reports and documents repository
• Migrate data from Mainframe DB2 to SQL Server 2008
• Responsible for the writing/creating of the T-SQL, Joins, Stored Proc, UDF, User Defined Data types
• Analyze and develop data validation methodologies and documentation
• Analyze and develop conversion processes to streamline conversion activities
• Developed Automated (PRESS BUTTON) Release Management Process, in that process, I used TFS and C# scripting. I have written batch(.bat) file for this process
• Used C# scripting/Function for implement the complex business rule
• Used Stage Database for Data integrity and validation
• Prepare technical design documents for SSIS Packages and automated process
• Used Ultra Edit for SQL Scripting.
• Cube building and MDX in SSAS 2008
• Used Cube and Stored Procedure for Developing Medicaid reports in SSRS 2008
• Work to optimize conversion program performance
• Support and mentor other staff.

Confidential, Portland, OR

S r. SQL Server Developer / Sr. BI Developer

Environment: MS SQL Server 2005, C# Scripting, Java Script, Business Intelligence - MS SQL Server Integrated Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).

Responsibilities:

• I was involved in creating packages for data Conversion through SSIS.
• For data ware house design, I used star schema and define dimensions & measures
• Using Business Intelligence Visual Studio 2005
• Using Edit Plus for SQL Scripting.
• Have created agent for scheduling SSIS package
• Responsible for the writing/creating of the T-SQL, Joins, Stored Proc, UDF, User Defined Data types
• Optimization and Performance Tuning of Stored Proc and MDX Queries
• Used Visio for database modeling/ designing/Flow Chart.
• Kimball data warehouse methodologies
• Used Information Technologies Infrastructure Library(ITIL) Management Fundamentals
• Writing Technical design document based on stored proc and application.
• Worked on data migration from SQL Server 2000 & CSV/Flat files to SQL Server 2005 through SSIS.
• Have written maintenance Utilities for database optimization.
• Created Cubes/ MDX Queries
• Used MS- Access for Data Validation Process
• Implemented Service Broker 2005 for finance transaction in SAP
• Used Dundas tool for chart in SQL Server Reporting Services
• Created Data based/Graphical Reports with cubes.
• Used ASP.Net C# functions for reports
• Used DBCC Commands and Update Statistics for SQL Server Maintenance and clearing cache.

Confidential, Edina, MN

Sr. SQL Server Developer

Environment: MS SQL Server 2005, C# Scripting, Business Intelligence - MS SQL Server Integrated Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS)

Responsibilities:

• Involved in creating packages for in-bound / out bound process through SQL Server Integration Services.
• Used Business Intelligence Visual Studio 2005
• Used Ultra Edit for SQL Scripting.
• Optimization and Performance Tuning of SQL Server database Objects
• Solved performance problems for most of the existing stored procedures and helped developers for creating new stored procedures
• Had been involved in writing/ debugging complex stored proc for the application
• Used SSRS for Graphical/data report
• Used in Transactional Replication
• Followed Agile methodology for project management process
• Responsible for the writing/creating of the T-SQL, Joins, Stored Proc, UDF, User Defined Data types
• Used Visio for database modeling/ designing.
• Involved in writing Technical design documents based on stored proc.
• Worked on Production server performance issues.
• Written complex view and trigger.
• Worked on data migration from SQL Server 2000 & CSV/Flat files to SQL Server 2005 through SSIS.
• Written Utility for wipe up junk data into database
• Written maintenance Utility for database optimization.
• Created Cubes/ MDX Query
• Written SQL/.Net C# functions for reports
• Used Star Schema
• Worked on Data warehouse / Data marts Structure
• Used new SELECT statement options to retrieve results in XML (FOR XML)
• Used SQL Profiler effectively for optimizing stored procedures and Transact - SQL.
• Used DBCC Commands and Update Statistics for SQL Server Maintenance and clearing cache.

Confidential, Orlando, FL

Sr.SQL Server Developer

Environment: MS SQL Server 2000/2005, C# Scripting, Java Script, Business Intelligence - MS SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SSIS Packages

Responsibilities:

• Involved in creating new Drill Down/Graphical reports through SQL Server Reporting Services Tool.
• Published end user reports in HTML, PDF, Excel, and CSV formats
• Created Multi level sub reports in MS SQL Server Reporting Services.
• Used Business Intelligence Visual Studio 2005
• Worked on OLAP and OLTP Environment
• Used predefined function for Date, currency format, page number.
• Writing SSIS packages for data migration from Old systems (csv file and SQL Server) to SQL Server 2005.
• Performance Tuning of SQL Server Databases
• Solved performance problems for most of the existing stored procedures and helped developers for creating new stored procedures
• Migrate data from MS SQL Server 2000 to MS SQL Server 2005
• Responsible for the creation of various SQL Server Database objects (T-SQL, Joins, Indexes, Constraints, Stored Proc)
• Implemented security of SQL Server security model.
• Created Cubes and MDX Queries

Confidential, Lake Success, NY

Sr. SQL Server Developer

Environment: MS SQL Server 2000, DTS, VB Script, Linked Server, T-SQL, Joins, triggers and Store Proc, MS SQL Server 2000 Reporting Services and Seagate Crystal Report 9.

Responsibilities:

• Used Linked server to connected two different MS SQL Servers
• Created the documentation for stored proc and database structure.
• Performance Tuning of SQL Server Database Objects
• Migrated Crystal Report 9 to SQL Server 2000 Reporting Services
• Responsible for the creation of the following SQL Server database objects (T-SQL, Joins, Indexes, Constraints, Stored Procedures, UDF, User Defined Data types)
• Used XML Parsers
• Used MS - Access for data Validation process
• Used Report Builder for Creating New reports
• Used SQL Profiler effectively for optimizing stored procedures
• Used DTS Packages for SQL Server Database tables connect to Oracle Database tables.
• Performance Tuning of SQL Server Databases
• Used DBCC Commands and Update Statistics for SQL Server Maintenance and clearing cache.
• Implemented SSL layer on the server
• Have written Interface to extract data from excel sheet/Oracle 9i to database table through DTS Packages
• Change Default SQL Server TCP/IP Port for security

Confidential

SQL Server Developer

Environment: MS SQL Server 2000, SQL Query, triggers and Store Proc, Seagate Crystal Report 9

Responsibilities:

• Created the documentation for stored proc and database structure.
• Used Visio for database modeling
• Responsible for the creation of various SQL Server database objects (T-SQL, Joins, Stored Proc, UDF, User Defined Data types)
• Used indexed views, stored proc and user-defined functions for optimal performance.
• Created Management decision making reports in Crystal Report

Confidential

SQL Server Developer

Environment: MS SQL Server 2000, triggers, ASP and Java Script, Seagate Crystal Report 9

Responsibilities:

• Responsible for the creation of the following SQL Server database objects (T-SQL, Joins, Stored Proc, UDF, User Defined Data types)
• Created financial Statement, Invoice and sales reports in Crystal Report

Confidential

SQL Server Developer

Responsibilities:

• List of Resume, shows the list of all the resumes which are posted
• Search Resume, which searches posted resumes
• On the basis of available divisions, age range, experience, country,
• On the basis of a certain keyword
• On the basis of resume id (which is mailed to the user as soon he/she submits the resume form)
• News Letters, meant for updating or adding latest up comings.