Summary

• 9 Years Sr. Database Developer 6 Years designing and implementing database systems, 6 Years designing and implementing SQL Server 2005 or higher 5 Years DTS/SSIS Packages 4 Years MS Visual Studio 2005 or higher 5 Years Stored procedures 5 Years Triggers 5 Years T-SQL scripts 1 Year SQL Profiler 5 Years Windows System monitor 4 Years Indexing strategies 4 Years Query/index tuning 4 Years Index management 4 Years Relational data modeling principles and techniques
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Expert Knowledge of Integration Services SSIS , Analysis Services SSAS , Reporting Services SSRS .
• Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment.
• ETL implementation using SQL Server Integration Services SSIS .
• Expert in using tools like Bulk Copy BCP , Data Transformation Services DTS in SSIS.
• Experiencing in creating reports using cubes.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Developing reports on SQL Server 2000/2005 . Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in creating the MDX cubes and dimensions and understanding of SSAS, OLAP cube and Architecture.
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008/2005/2000.
• Experience in SSRS with Report authoring, Report management, Report Delivery and Report Security.
• Great ability to create and manage various database objects like tables, views.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

Technical Skills

Professional Experience

Confidential

Sr.SQL Server/ SSRS

Responsibilities:

• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Design and development of custom controls.
• Developing the stored procedures according to business requirements.
• Developing and updating Lookup pages to populate values to the controls
• Performed Analysis and design of implementing a Start Schema Data Mart with Facts and Dimensions.
• Involved in creating various reports using SSRS that helped users made informed decision.
• Responsible for analyzing post implementation issues by looking at the various reports created based on the new system.
• Installed and configured systems and trained team members that were responsible for creating reports based on the new system.
• Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQL server database.
• Worked with the DBA and Database developers to convert the functional specification to technical specification.
• Closely monitored the system performance after implementation to address any minor performance issues and evaluate the overall system.
• Wrote complex SQL queries to pull and process data from multiple data sources SQL Server, flat files, etc .
• Designed and programmed re-usable SQL code to prepare data for analysis.
• Downloaded data from various sources.
• Loaded data into SQL database and convert it to applicable dataset to make it ready for report generation.
• Responded to users' requests for additional data
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using Sql Server Reporting Services 2008.
• Experience in creating Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS. SMTP Server Campaign.

Confidential

SSRS/ SSIS Developer

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports,
• Linked Reports, and Reports using stored procedures using Sql Server Reporting Services 2008.
• Experience in creating Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Involved in scheduling, creating snapshots and subscriptions for the reports. SSRS 2005/2008 .
• Designed and developed packages for data warehouse using Integration services SSIS SQL Server 2005/2008.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in using C .Net in script Task while creating SSIS Packages.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003.

Confidential

Responsibilities:

• Design and development of pages according to the client requirement.
• Design and development of custom controls.
• Developing the stored procedures according to business requirements.
• Developing and updating Lookup pages to populate values to the controls
• Updating and developing of encrypting data before store in to database using certificates.
• Updating and developing customized grids to populate the information.
• Developed entity objects to wrap information in database tables and to hand over it to Business and Workflow tiers instead of passing datasets.
• Coordination with testing team to carry out unit, integration testing.
• Proficiency with Process Modeling, Relational Data Modeling, Database Programming and Application Development using Microsoft Visio
• Extensive RDBMS experience on designing tables, database schema, triggers and stored procedures in Microsoft SQL Server.
• Experience on Version Control System like Microsoft Visual Source Safe and MKS.
• Integrated SSRS Reports with ASP.net Pages.

Environment: ASP.Net 2.0, C , MS SQL Server 2000/2005/2008, Windows 2003,Enterprise Manager, Management Studio SSMS ,SSRS, Data Modeling, T-SQL, Tuning Advisor, SQL Profiler, MKS, Visual Source Safe.

Confidential

Sr. SQL BI Developer /Report Developer

Responsibilities:

• Using SQL Server Reporting Services SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Creating Reports as per user requirements using MS Reporting Services 2005/2008.
• Created report models using the report model designer to support Ad hoc reporting.
• Developed detail and summary reports including line and pie charts, trend analysis reports and sub-reports using SSRS
• Created Reports with complex formulas and to query the database for business Intelligence.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked with different methods of logging in SSIS.
• Migrated DTS Packages from SQL Server 2000 to 2005 as SSIS Packages.
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Incorporating business logic in SSIS while converting from Oracle, MS Access, Excel and Text to SQL Server.
• Installed and Configured SQL server 2005 on windows 2003 advance server system.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Developed reports where the data extracted from SSAS cubes in SSRS.
• Optimized query performance by creating indexes. Optimized stored procedures for performance tuning.
• Monitor and tuned indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2000.
• Moved the static data from various text files to SQL Server 2005 database using BCP Import and Export, Bulk Insert.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Provided support to the application developers on the application databases.
• Configured and Deployed different reports in the Servers using SQL Server 2008 Reporting Services.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Used Ms Visual Source Safe to handle version history of the files in database.
• Environment: MS SQL Server 2000/2005/2008, Windows 2003,Enterprise Manager, Management Studio SSMS , Integration Services, SSRS 2008, OLAP, Data Modeling, Analysis Services, T-SQL, C .Net, Tuning Advisor, SQL Profiler, SQL Server Agent, Data ware Housing, Crystal Report9.0, MS Access.

Confidential

SR SQL BI Developer SSIS/SSRS/SSAS

Responsibilities:

• Creation of SSIS packages to request a dump of weekly page views from Staples databases to our databases.
• Excellent report creation skills using Microsoft Reporting Services SSRS .
• Creating complex SQL Queries to partition and aggregate the data based on cookie and session ids of visitors.
• Created dimensions using SQL Server Analysis Services SSAS .
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.
• Developed Multi dimensional Objects Cubes, Dimensions using MS Analysis. Involved in Performance optimization created a Log tables to capture the SSIS events and used it to Perform Debugging of packages.
• Experienced in designing reports through Report Builder and Report Designer.
• Identified and worked with parameters for parameterized reports in SSRS 2005/2008.
• Created and scheduled a SSIS package to run our stored procedures to create the output report tables and regenerate reports automatically on weekly or monthly bases using SSRS 2005 and SSRS 2008.
• Identified the data source and defined them to build the data source views.
• Created and Maintained Database Maintenance Plans.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Schedules jobs for DTS packages.
• Creation of temporary tables, efficient index mechanisms and optimizing joins to match the performance expectations of the system.
• Creation of reference tables, mapping of page ids to the product line categories and the sources of information.
• Developed SSIS packages not only for Initial Data Loads but also for incremental/delta loads.
• SSRS module to request data from output tables, design of report templates, use of bar and pie charts, drill-down and drill-through reports, use of parameters, global variables and functions to generate final reports.
• Designed ad-hoc reports using Report Model and configured using Report Manager.
• Environment: MS SQL Server 2000/2005, MS SQL Server Reporting Services 2005,SSIS,SSAS, MS SQL Server Integration Services 2005.

Confidential

• Project Management Information Systems PROMIS External Manufacturing Management Information System EMMIS
• The system is designed to collect Productivity, Savings and Cost Avoidance projects
• It is a web-based application accessible online allowing various user roles
• Has a Crystal reporting tool attached to the database
• Different areas/users Commodities, EME can use different modules but share the same Master Data for locations, currencies, etc.
• Access rights are managed by the system administrator independently of the third party.
• Procurement Direct Materials, Commodities, EME and IM S are using the system across Europe, Asia Pacific and North America

Responsibilities:

• Developed and maintained Create Projects functional module used upon initiation of the program/project
• Developed and maintained Update Projects functional module quick updates on amounts and implementation probability
• Developed and maintained List Projects functional module project filter allowing fast navigation and deletion of projects
• Developed and maintained Standard Reports: Selection parameters and report layout have been designed in advance and users choose the report which fits best with their needs. Reports support drill-down browsing
• Created Data Download function that allow quick data download and all Standard reports can be downloaded in Excel, Word, Adobe
• Developing the SP'S for the reports.
• Enhancements Development.
• Project Tracking.
• Handling the support request

Environment: MS SQL Server 2000/2005, Crystal Reports 9.0, ASP.NET, C .NET, ADO.NET, CSS.

Confidential

Jr. Developer

• HDFC Bank is India's leading private sector bank in India. I started my IT career with this project as a Jr. SQL Developer.
• Responsibilities:
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Data transfer between Development, Testing and Production databases.
• Provided support to development staff about database related issues.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Scheduled database backup and performed full, incremental and differential backups of database and transaction logs.
• Alteration of tables and fields as per requirements and recreation of indexes.

Environment: SQL Server 7.0/2000, T-SQL, Query Analyzer, Windows NT/2000 server