SUMMARY

• Around 8 years of profound IT experience in data ware house complete life cycle using SQL server development, extensively worked on SSIS/SSRS/SSAS, OLTP and OLAP in different domains.
• Hands on experience in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Expertise in Upgrade/Migration of MS SQL Server
• Good understanding and experience in SQL 2008 new features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
• Strong knowledge of Relational Database Management Systems (RDBMS) conceptin several databases like SQL Server 2008/2005/2000 and Oracle 10g/9i/8i.
• Experienced in designing complex reports including sub reports and formulas with complex logic usingSQL Server Reporting Services (SSRS)
• Interacted with Developers, Business analysts, Database team, Deployment team, and Release Management in an efficient and effective manner.
• Experience in Building the Dimensions, Designing, cubes with star schema using SQL Server Analysis Services (SSAS).
• Expert in identifying KPI’s and defining Referenced relationships and analyzing data using SQL Server Analysis Services (SSAS).
• Strong Understanding of finance module and loan center application, performed dynamic calculations, developed, reviewed, and optimized SQL queries in SQL Server.
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Worked on activities related to the development, implementation, administration and support of ETL process for large - scale Data Warehouses using SQL Server SSIS.
• Experienced in data import/export, datamigrationbetween homogenous system using Data Transformation Service (DTS) Packages, Bulk Copy command (BCP) and Bulk Insert.
• Involved in summarizing data for analysis purposes usingSQL Server Analysis Services (SSAS).
• Extensive knowledge inmaintenance and optimization of SQL Server database using SQL tools (SQL Profiler, Index Tuning Wizard Indexes).
• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005.
• Excellent hands on experience in creating groups and measures, KPIs.
• Have good experience with designing and implementing MDX queries, OLAP architecture.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• Effective leadership skills with good written, verbal communication and presentation skills. Self-motivated with result oriented approach. Committed collaborator and team leader
• Provided 24x7 support and trouble shoot production issues on high availability systems.
• Ability to work under pressure with the ability to meet deadlines.
• Excellent analytical, communication, interpersonal and decision making skills and is well motivated to rapidly acquire new skills on the job.
• A quick learner with an easy adaptability to new environments, technology and people. Ability to conceptualize and analyze a problem with ease.

TECHNICAL SKILLS

Programming Languages: C/C++, C# .NET

Database: Oracle - SQL, PL/SQL, SQL Server, MS Access, T-SQL

Web Technology: HTML, JavaScript, CSS, PHP, ASP.NET

Software Packages: Dreamweaver, Photoshop, PageMaker, Flash (Designing)

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008, DTS

OLAP Tools: SQL Server Analysis Services (SSAS) 2000/2005/2008

Reporting Tools: SQL Server Reporting Services (SSRS) 2000/2005/2008 , Crystal Reports, Cognos Framework Manager, Report Studio

Data Base Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), SQL Profiler, Query Analyzer, VSS, TFS

Technologies: NET Framework 1.0/1.1/2.0/3.0/3.5 , XML, Object Oriented

Operating Systems: Windows 2008/2003 Server, Windows XP/Vista/7, Linux, UNIX

Ms-Office Tools: MS-Excel, MS-Word, Power Point, MS-Access, VISIO, MS-Publisher, MS-Outlook

PROFESSIONAL EXPERIENCE

Confidential, Mason, OH

Sr SQL Server/ SSIS / SSRS Developer

Environment: MS SQL Server 2008 R2, T-SQL, SQL SQL Server BIDS, SSIS, SSAS, SSRS, MS- Visual Studio 2005, XML, Windows 2008/XP.

Responsibilities:

• Participating in all phases of software development lifecycle: requirements analysis, technical design, implementation, acceptance testing, and warranty support.
• Database Developer for Development, Test and Production servers with MS SQL Server 2005 on Windows XP/Vista.
• Installed, configured, administered and secured SQL Server 2005 on Server and Clients.
• Migrated data’s from SQL and solved related issues.
• Experience in MS SQL Server upgrades from 7.0 MS SQL Server 2000 and from 2000 to MS SQL server 2005.
• Responsible for developing, monitoring and deploying SSIS packages.
• Migrating DTS packages to SSIS Packages. Created complex SSIS Packages for Data Migration and Transformation.
• Expert in extracting data using SSIS from OLTP to OLAP. Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and optimized all the SSIS packages.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases. Created SSIS packages to Export data from text file to SQL Server Database.
• Created SQL Server Reports using SSRS 2005. Identified the Data Source and defined them to build the Data Source Views. Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts. Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Created Drill Reports which gives all the details as per business requirements which runs on daily
• Set naming conventions for objects based on SQL standards.
• Currently contributing as the build lead to ensure the application is successfully deployed for testing.
• Representing the development team in all triage meetings to hash out major issues concerning application development and testing.
• Developing unit-tested high quality code.
• Proactively identifying and resolving application performance issues.
• Communicating with both technical and non-technical staff to support analysis, design, testing, and troubleshooting of project issues.
• Involving in requirements gathering, application design in web and windows forms, System Design and Code Development, Data Design recommendations, and technical writing.
• Working on additional projects and tasks as they are assigned.

Confidential, Charlotte, NC

SQL Server / BI Developer

Environment: SQL Server 2008 Enterprise Edition, IIS Web Server, MS Access, SSIS, SSRS, SSAS, T-SQL, ODBC, Excel, Access, DTS Packages, Windows 2008/XP, IIS 5.0.

Responsibilities:

• Continuously interacted with users to gather the business requirements. Modified existing database by adding tables and relationships.
• Created views as per the requirement of front-end developer for easier implementation on ASP.NET pages.
• Worked with BCP and DTS to load text files to SQL Server. Maintaining the data, database backups and restoration, backup strategies, scheduling backups. Migrating DTS packages to SSIS Packages.
• Wrote stored procedures and DTS packages as part of the ETL process.
• Responsible for transferring the data using SSIS packages. Developed, monitored and deployed SSIS packages.
• Involved in transfer of user profiles from SQL server 2000 to SQL Server 2005 using SSIS and migrated DTS packages using SQL Server Integration Services (SSIS).
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Worked with DTEXEC and DTUTIL utilities for SQL Server Integration Services (SSIS) and generated various reports using SQL Server Reporting Services (SSRS).
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Query for generating drill down and drill through reports in SSRS 2005.
• Formatted SSRS reports using Global Variables, Expressions and Functions for the reports.
• Created stored procedures and functions to support complex wealth management logic
• Ensured the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Worked on SQL Server 2005 Analysis Services to create and populate cubes, dimensions and fact tables
• Created views as required by front-end developer for easier implementation and wrote instead-of triggers on those views to provide efficient data manipulation.
• Created OLAP Databases and generated reports using reporting services. Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Involved in testing, bug fixing and documentation for the project. Migrated data from SQL and solved related issues. Created complex DTS Packages for Data Migration and Transformation

Confidential, Chantilly, VA

SQL Server / BI Developer

Environment: MS SQL Server 2005/2000, T-SQL, BIDS, Windows 2008/XP, MS- Visual Studio 2005, XML

Responsibilities:

• Migrated data’s from SQL and solved related issues.
• Gathered end user requirements and developed applications and different Audit functionalities depending on the Requirement acting both as a system analyst and an application developer.
• Wrote user requirement documents and developed functions, indexes, stored procedures, views and triggers for automation. Converted fast views in to EUP views and validated data.
• Used Team Foundation Server (TFS) as a tool for repository of codes and version control, also maintains test scripts and documentation following the standards of INTEL system.
• Worked with Exception Handling with @@error and with Try/catch.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Developed physical data models and create DDL scripts for database schema and objects.
• Identified the Data Sources and defining them to build the Data Source Views.
• Developed Query for generating drill down and drill through reports in SSRS 2005.
• Uploaded reports on to the report manager and organized them into folders.
• Built effective queries for high-performance reporting and rendered them into HTML, XML, PDF and Excel formats using Reporting Services.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Looked at the reports and fixed bugs in stored procedures.
• Improved Report Performance and performed unit testing.
• Responsible for developing, monitoring and deploying SSIS packages.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Worked with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Upgraded SQL Server software to new versions and applying service packs and hot fixes and unattended Installations.

Confidential, Dallas, TX

SQL BI Developer

Environment: MS SQL Server 2005/2000, Windows Server 2003/2000,.NET 2.0, DTS, SSIS, SSRS, SSAS, T-SQL, ERwin 4.0,MS Access, XML, MS Excel, XP, Windows 2003 Server, Visual Studio 2005.

Responsibilities:

• Created database objects like tables, views, indexes etc.Developed direct connection between Access and SQL databases.
• Created Application Roles and security using ADP. Identified the Data Source and defined them to build the Data Source Views
• Created SQL Server Reports using SSRS 2005.Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts. Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Generated professional charts and diagrams Using Microsoft Project Server 2007.
• Developed, monitored and deployed SSIS packages.
• Upgraded Analysis Service 2000 to SSAS 2005.Identified and Defined Key Performance Indicators (KPIs) in SSAS 2005.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables. Designed and applied entity and attributes description and definition for the models.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Confidential, Santa Clara, CA

SQL Server Developer

Environment: MS SQL Server 2000/7.0, T-SQL, DTS, MS- Visual Studio, XML, Windows 2003 Server, XP.

Responsibilities:

• Actively designed the database to expedite certain daily jobs and some stored procedures.
• Wrote Stored Procedures to handle complex calculations and wrote logic to maintain the history of entities which were also passed on to the application via Stored Procedures.
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored procedure and maximized the readability of such Stored Procedures.
• Used Visual Source Safe as a tool for repository of codes and version control, also maintained test scripts and documentation following the standards of the Project.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Handled development and production support, document reviews, test plan, integration of the system.
• Worked on DTS Package, DTS Import/Export for transferring data from different Databases (Oracle and Text format data) to SQL Server.