SUMMARY

• Over 10 years of IT experience in Sr.SQL Server Developer/Team Lead, Design, Development, System Analysis and Support of MSSQL Server 2008 R2, 2005, 2000, 7.0, MS - Access in Development, Test, Production and Replication & Clusterenvironments.
• Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) SQL ServerReporting Services (SSRS).
• Knowledge of Relational Database Management systems and Data Modeling.
• Worked on configuring Service Broker for message Queuing system.
• Experience in Database Backup, Logshipping, Replication Recovery and Disaster Recovery procedures.
• Experience wif Data Transformation Services, Batch processes, Import/Export and Backup/Restore.
• Experience in Performance Tuning, Query Optimization, Client/ ServerConnectivity, Database Consistency Checks using DBCC Utilities.
• Hands on experience in Troubleshooting database issues.
• Experience in writing and debugging Stored Procedures, Views, triggers, Functions using T-SQL Scripts
• Extensive experience in creating business, functional and technical documentation.
• Excellent verbal, written communication and presentation skills, problem solving and conflict resolution skills.
• Maximum Team Handle on Onsite to Offshore range between 10 -35 including Manager as Team Lead.

TECHNICAL SKILLS

RDBMS: MS SQL Server 6.5, 7.0,2000, 2005 and 2008, 2008 R2,DB2, MS Access 2000/97and Oracle.

Programming: C, C#, C++,PL/SQL, T-SQL, Java, Java Script, COBOL, ASP, HTML Perl script, and Visual Basic

Operating Systems: Windows 2000, Workstation, Windows NT/XP/95/98, MS DOS, UNIX

Applications: MS Office, MS Visio, Dream Weaver

Tools: Erwin, NetIQ, Clustering, Remedy, Attunity, NT Performance monitor/System monitor, TSQL, SQL Profiler, SQL Query Analyzer, OSQL

PROFESSIONAL EXPERIENCE

Confidential, Jersey City

Sr. SQL/BI Developer

Responsibilities:

• Involved inGatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in writing T-SQL script for databases and tables.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Involved in building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Involved in scheduling and deploying teh packages on SQL Server.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved in creating paramerterized as dyanamic reports from cubes using Expressions.
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in BCP in and out of data from one environment to another environment.
• Involved in creating Dynamic and parameterized reports using expression and mdx query from cube.
• Involved in production support for all kind of technical issues.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Created teh backup schedule for production, test and development servers.
• Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non Clustered) for improving teh server performance

Confidential, OH

Sr.SQL/BI Developer

Responsibilities:

• Involved in building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Involved in writing T-SQL script for databases and tables.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Involved in scheduling and deploying teh packages on SQL Server.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Involved in creating Attributes and Dimension hierarchy in cube
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in writing MDX query against cubes to browse data and creating reports from Cubes.
• Involved in writing Calculations, Named sets, KPI, Translation for cubes to use them for reports and browsing data
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved inGatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in BCP in and out of data from one environment to another environment.
• Involved in creating Dynamic and parameterized reports using expression and mdx query from cube.
• Involved in writing shell scripting for UNIX data
• Involved in improving teh performance of cubes by creating aggregations, partition of cube.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in production support for all kind of technical issues.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Created teh backup schedule for production, test and development servers.
• Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non Clustered) for improving teh server performance
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design through Visio Tool.

Confidential, Ohio

Sr. SQL/BI Developer

Responsibilities:

• Involved in Developing SSIS package for incremental and full loading of data to Data warehouse.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages by using Fuzzy looks up task
• Involved in Data Migration from Oracle to SQL Server 2008R2.
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in creating dynamic SSIS packages along wif XML configuration file.
• Involved in Creating SSIS packages for importing data through different data sources (Excel, CSV, SQL, Oracle, Teradata).
• Involved in Writing PL/SQL script for retrieving data from Oracle databases.
• Involved in Developing SSIS by using Merge join, Conditional Split, pivot or Unpivot task to output teh data by using complicated logics.
• Involved in Writing Expression for Dynamic parameter generated during run time of SSIS packages.
• Involved in security of SSIS packages.
• Involved in Error Handling, Package Logging and Configuration of packages
• Involved in Dimension Modeling design. Design Dimension and Fact Tables especially Star Schema for creating Fact and Dimension tables.
• Involved in writing PL/SQL code using TOAD for retrieving data from Oracle.
• Involved in creating indexes (Clustered and Non Clustered) for improving teh server performance
• Involved in production support for all kind of technical issues.
• Involved in Creating cubes, performance of cubes for MOLAP storage option.
• Involved in creating perspective, translation KPI, Calculations using MDX query.
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in optimization of cubes by Aggregations, Partitions of cubes
• Involved in Error Handling, Package Logging and Configuration of packages
• Involved in Creating Expressions and Dynamic variables in SSIS.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in Scheduling and working on performance of reports.
• Involved in writing T-SQL script for databases and tables.
• Involved in Error Handling, Package Logging and Configuration of packages
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases.
• Involved in developing customized reports like Matrix, Flat reports
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Involved in creating indexes (Clustered and Non Clustered) for improving teh server performance
• Involved in production support for all kind of technical issues.

Environment: MS SQL SERVER 2008 R2, SQL Server 2005, Oracle,MS SQL Server 2005/2008, SSIS, SSRS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Iowa

Sr.SQL/BI Developer

Responsibilities:

• Involved inGatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in creating SSIS package for incremental and full loading of data to Data warehouse.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages by using Fuzzy looks up task
• Involved in developing SSIS for moving data from Oracle to SQL databases.
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in creating dynamic SSIS packages along wif XML configuration file.
• Involved in Creating SSIS packages for importing data through different data sources (Excel, CSV, SQL).
• Involved in Developing SSIS by using Merge join, Conditional Split, pivot or Unpivot task to output teh data by using complicated logics.
• Involved in Writing Expression for Dynamic parameter generated during run time of SSIS packages.
• Involved in writing shell scripting for UNIX data
• Involved in Writing PL/SQL script for retrieving data from Oracle databases.
• Involved in security of SSIS packages.
• Involved in writing PL/SQL code using TOAD for retrieving data from Oracle.
• Involved in Error Handling, Package Logging and Configuration of packages
• Involved in Dimension Modeling design. Design Dimension and Fact Tables especially Star Schema for creating Fact and Dimension tables.
• Involved in Creating cubes, performance of cubes for MOLAP storage option.
• Involved in creating perspective, translation KPI, Calculations using MDX query.
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in optimization of cubes by Aggregations, Partitions of cubes
• Involved in Error Handling, Package Logging and Configuration of packages
• Involved in Creating Expressions and Dynamic variables in SSIS.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in writing T-SQL script for databases and tables.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases.
• Involved in developing customized reports like Matrix, Flat reports
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Involved in creating indexes (Clustered and Non Clustered) for improving teh server performance
• Involved in production support for all kind of technical issues.

Environment: MS SQL SERVER 2008 R2, SQL Server 2000, MS SQL Server 2005/2008, SSIS, SSRS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Philadelphia

Sr. SQL/BI Developer

Responsibilities:

• Involved in Gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000,Oracle).
• Involved in Writing PL/SQL script for retrieving data from Oracle databases.
• Involved creating SSIS packages for Full and incremental loading of data for building Data warehouse.
• Involved in building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Involved in scheduling and deploying teh packages on SQL Server.
• Involved in Error Handling, Package Logging and Configuration of packages
• Involved in creating Web Config File OR Tables for storing all variables for Security purpose.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design through Visio Tool.
• Involved in writing T-SQL script for databases and tables.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Involved in creating Attributes and Dimension hierarchy in cube
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in writing MDX query against cubes to browse data and creating reports from Cubes.
• Involved in writing Calculations, Named sets, KPI, Translation for cubes to use them for reports and browsing data
• Involved in optimization of cubes by Aggregations, Partitions of cubes
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non Clustered) for improving teh server performance
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in production support for all kind of technical issues.

Environment: MS SQL SERVER 2005,2008 R2, SQL Server 2000, MS SQL Server 2005/2008, SSIS, SSRS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Seattle

Sr. SQL/BI Developer

Responsibilities:

• Involved inGatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in writing T-SQL script for databases and tables.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Involved in building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Involved in scheduling and deploying teh packages on SQL Server.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved in Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Involved in creating Attributes and Dimension hierarchy in cube
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in writing MDX query against cubes to browse data and creating reports from Cubes.
• Involved in writing Calculations, Named sets, KPI, Translation for cubes to use them for reports and browsing data
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in BCP in and out of data from one environment to another environment.
• Involved in creating Dynamic and parameterized reports using expression and mdx query from cube.
• Involved in writing shell scripting for UNIX data
• Involved in improving teh performance of cubes by creating aggregations, partition of cube.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in production support for all kind of technical issues.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Created teh backup schedule for production, test and development servers.
• Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non Clustered) for improving teh server performance
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design through Visio Tool.

Environment: MS SQL SERVER 2005, 2008 R2, SQL Server 2000, Oracle, MS SQL Server 2005/2008, SSIS, SSRS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Dayton, OH

Sr.SQL/BI Developer/Lead

Responsibilities:

• Involved inGatheringBusiness Requirements, Impact Analysis and Technical Specification Documentation.
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design.
• Create database objects including tables, triggers, views, stored procedures, indexes.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved in writing PL/SQL code using TOAD for retrieving data from Oracle.
• Involved in data migration from DB2, Access data source to SQL Server.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Involved in building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Involved in scheduling and deploying teh packages on SQL Server.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Involved in writing package for incremental load to teh data warehouse.
• Involved in creating and development of cubes and hierarchies between their attributes.
• Involved in improving teh performance of cubes by partition and creating aggregation of cubes.
• Involved in creating paramertized and Dynamic reports using expressions from cube.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in creating Table Partitioning for large tables by Partition Schemas and Partition Functions
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in creating indexes (Clustered and Non Clustered) for improving teh server performance
• Involved in creating strategies for Backup and Restore of Prod databases.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in production support for all kind of technical issues.

Environment: MS SQL SERVER 2005, 2008 R2, Oracle, MS SQL Server 2005/2008, SSIS, SSRS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Columbus, OH

SQL/BI Developer

Responsibilities:

• Involved in migration of 2000 Databases to 2005 Databases. Migration include teh migrating teh SQL 2000 DTS packages to SQL server 2005 SSIS packages
• Created Packages for synchronization of Production Databases to UAT, SIT, DEV Databases, Tables comparison, Row-by-Row comparison.
• Involved in Tuning Store Procedures and query optimization for SQL server 2005
• Involved in Creating and Altering Tables, Triggers, Views, Stored Procedures, Functions and Indexes.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Involved creating SSIS packages for Full and incremental loading of data for building Data warehouse.
• Involved in building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Involved in scheduling and deploying teh packages on SQL Server.
• Involved in Error Handling, Package Logging and Configuration of packages
• Involved in creating Table Partitioning for large tables by Partition Schemas and Partition Functions
• Involved in data mapping from DB2 to SQL Server 2008.
• Involved in creating indexes (Clustered and Non Clustered) for improving teh server performance
• Involved in Database tuning by using DTA (Database Tuning Advisor) and other third party tools
• Involved in Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Involved in creating Attributes and Dimension hierarchy in cube
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in writing MDX query against cubes to browse data and creating reports from Cubes.
• Involved in writing Calculations, Named sets, KPI, Translation for cubes to use them for reports and browsing data
• Involved in creating designing parameterized reports using datasets and expressions.
• Involved in creating reports both Custom and Matrix by SSRS.
• Involved in deployment of code in all teh environments (SIT, UAT, PROD) and troubleshooting any technical issue
• Involved in creating strategies for Backup and Restore of Prod databases.
• Experience in improving SQL Server performance by using Index tuning wizards, performance Tuning methods, execution plans and profilers.

Environment: MS SQL SERVER 2005, 2008 R2, 2000, MS SQL Server 2005/2008, SSIS, SSRS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Seattle, WA

SQL/BI Developer

Responsibilities:

• Gathering business requirements from users and doing impact analysis and delivering it to teh offshore team for development
• Reviewed code and deployment guide prior to release to testing team.
• Involved in deployment of code in all teh environments (SIT, UAT, PROD) and troubleshooting any technical issue
• Involved in production support for all kind of technical issues.
• Involved in migration of existing Application from 32 bits to 64 bits environment including installation of Performance Point Server 2007 (PPS).
• Created dimensions and Hierarchies in Performance point server for user interface and loading teh data at SQL server Backend through SSIS packages.
• Involved in Designing Dimensional modelling especially Star Scheme.
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Resolved bugs during testing cycle of application.
• Involved in development of features like optimization, security, and audit log in existing application.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Created a POC and given presentation on Master data management (MDM) to business users as a future implementation for teh current Performance Point (PPS) application.
• Worked on SQL Server Integration Services Packages (SSIS) and PPS for loading teh data into teh SQL Server databases.
• Monitored and created tasks and bugs in MS visual studio Team Foundation Server (TFS, also VSTF) and assigned to proper authorities (offshore development team, test team, etc).
• Involved in analysis teh data to be loaded to teh PPS through PPS commands.
• Involved in smoke testing in UAT (User Acceptance Testing) for final sign off
• Performed impact analysis during design changes in upstream and downstream systems.
• Design teh application context diagram using MS-Visio tool Installed, configured and maintained

Environment: MS SQL SERVER 2005, 2008, 2000, MS SQL Server 2005/2008, SSIS, SSRS, SSAS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, MO

SQL Server Development Lead/Developer

Responsibilities:

• Involved inGatheringBusiness Requirements, Impact Analysis and Technical Specification Documentation.
• Involved in creating SSIS packages forloadingdata from data source (oracle or sql database) to Staging databasefollowed bymigrating teh data to ODS (operation data source) and finally to PDS (productiondata source)
• Create database objects in SQL Server 2005 including Tables, Triggers, Views, Stored Procedures, Functions and Indexes.
• Involved in deployment of code in all teh environments (SIT, UAT, PROD) and troubleshooting any technical issue
• Involved in production support for all kind of technical issues.
• Experienced wif improving SQL Server using windows performance monitor to improve teh server performance.
• Experience in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Experienced wif SQL Server 2005 profiler, SQL Server management studio and Business intelligent development studio.
• Created SSAS Cubes from dimensional model and used MDX Query to retrieve teh data from cube.
• Involved in Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Involved in creating Attributes and Dimension hierarchy in cube
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in writing Calculations, Named sets, KPI, Translation for cubes to use them for reports and browsing data
• Experienced wif creating database maintenance plans for efficient operations.
• Created teh backup schedule for production, test and development servers.
• Experienced in troubleshooting production servers and fixed teh user and application issues.
• Resolved bugs during testing cycle of application.

Environment: MS SQL SERVER 2005, 2000, MS SQL Server 2005/2008, SSIS, SSRS, SSAS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, NC

SQL/BI Developer

Responsibilities:

• Involved in gathering business requirement and impact analysis.
• Created and maintain databases after logical and physical database design.
• Create database objects including tables, triggers, views, and stored procedures, indexes.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of teh databases.
• Involved in writing shell scripting for UNIX data
• Involved in Designing Dimensional modelling especially Star Scheme.
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in production support for all kind of technical issues.
• Involved in upgrading from SQL Server 2000 to SQL Servers 2005 and test teh application after teh upgrade, make sure everything is working fine.
• Experienced wif improving SQL Server using windows performance monitor to improve teh server performance.
• Involved in creating SSIS packages for loading incremental loading to full Loading.
• Created teh DTS packages to import teh data from MS Access and Oracle server to SQL Servers. .
• Involved in securing teh SQL Server environment and involved in setting up teh user permissions.
• Experienced wif creating database maintenance plans for efficient operations.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created teh backup schedule for production, test and development servers.
• Experienced in troubleshooting production servers and fixed teh user and application issues.
• Involved in creating backup strategy production, test and development servers.
• Experience in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Document server and database policies and procedures.
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.

Environment: MS SQL SERVER 2005, 2000, MS SQL Server 2005/2008, SSIS, SSRS, SSAS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, OH

SQL Developer/DBA

Responsibilities:

• Involved in gathering teh client requirements, Technical documentation and impact Analysis.
• Created Store Procedures, Triggers, Functions, and Indexes as per teh requirement.
• Involved wif testers during teh deployment of code in all phases (SIT, UAT, and PROD) of environments.
• Involved in production support for all types of technical issues.
• Involved in creating Deployment guide for deploying code.
• Involved in Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Involved in creating Attributes and Dimension hierarchy in cube
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in writing MDX query against cubes to browse data and creating reports from Cubes.
• Involved in writing Calculations, Named sets, KPI, Translation for cubes to use them for reports and browsing data
• Experienced wif improving SQL Server using windows performance monitor to improve teh server performance.
• Involved in creating SSIS packages, SSRS reports and SSAS Cubes in SQL Server 2005 servers.
• Experience in upgrading from SQL Server 7.0 to SQL Server 2000 servers and SQL Server 2000 to SQL Server 2005.
• Created teh DTS packages to import teh data from MS Access and Oracle server to SQL Servers.
• Experienced wif creating logical and physical database design for development projects.
• Involved in securing teh SQL Server environment and involved in setting up teh user permissions.
• Experienced wif creating database maintenance plans for efficient operations.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Experienced wif SQL Server 2005 profiler, SQL Server management studio and Business intelligent development studio.
• Worked wif teh database schema changes and database restore requests.
• Involved in restore operations to refresh teh data from production to test servers.
• Experienced wif creating change management tickets for production and test servers.
• Experienced in troubleshooting production servers and fixed teh user and application issues.

Environment: MS SQL SERVER 2005, 2000, MS SQL Server 2005/2008, SSIS, SSRS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential

MS SQL Developer

Responsibilities:

• Designed and implemented multiple systems using MS SQL Server 2000/7.0
• Performed all aspects of database administration, including data modeling, backups andrecovery. Performance Tuning and monitoring.
• Expertise in Security Issues such as creation and granting permissions on various Objects
• Responsible for MS SQL Server 2000, configuration, tuning and provide 24 X 7 dedicated support to all 95 Production, development and clustered servers
• Additionally, designed and implemented a disaster recovery system.
• Designing and Optimizing all teh DTS packages
• Involved in Data Migration from DB2 to SQL Server.
• Used Visual Source Safe for Configuration Management and Version Tracking.
• Created teh logical and physical data modeling using Erwin tool.
• Configured Log shipping from one production server to teh reporting server.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Upgraded from SQL 6.5, 7.0 to SQL 2000.
• Assist wif DBA to optimize teh SQL queries and stored procedures.
• Used different environment included Development, Staging, Testing, and Training & Productions for Implementations

Environment: MS SQL SERVER 2005, 2000, MS SQL Server 2005/2008, SSIS, SSRS, Confidential Visual Studio 2008, SQL Profiler, Confidential Visio, MS Office 2003,Excel 2003, Windows NT/2003.