SUMMARY

• Over 9 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 & Cluster environments.
• 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.

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++, Java, Java Script, COBOL, ASP, HTML 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, NT Performance monitor/System monitor, TSQL, SQL Profiler, SQL Query Analyzer, OSQL

PROFESSIONAL EXPERIENCE

Confidential, Iowa

Senior SQL Server 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 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 the 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 specially 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 the server performance
• Involved in production support for all kind of technical issues.

Confidential, Philadelphia

Sr SQL Server Developer

Responsibilities:

• Involved inGatheringBusiness 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).
• 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 the 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 Hiearchies between different attributes and Dimension.
• Involved in Creating paramerterized as dyanamic 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 optimisation 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 the server performance
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in production support for all kind of technical issues.

Confidential, Seattle

Sr SQL Server 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 the 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 Hiearchies between different attributes and Dimension.
• Involved in Creating paramerterized as dyanamic 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 improving the 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 the 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 the server performance
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design through Visio Tool.

Confidential, Dayton, OH

Sr SQL Server Developer

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 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 the 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 the data warehouse.
• Involved in creating and development of cubes and hierarchies between their attributes.
• Involved in improving the 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 the 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.

Confidential, Columbus, OH

SQL Server Developer

Responsibilities:

• Involved in migration of 2000 Databases to 2005 Databases. Migration include the migrating the 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 the 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 the 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 Hiearchies between different attributes and Dimension.
• Involved in Creating paramerterized as dyanamic 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 the 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.

Confidential, Seattle, WA

SQL Server Developer

Responsibilities:

• Gathering business requirements from users and doing impact analysis and delivering it to the offshore team for development
• Reviewed code and deployment guide prior to release to testing team.
• Involved in deployment of code in all the 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 the data at SQL server Backend through SSIS packages.
• Involved in Designing Dimensional Modelling specially Star Scheme.
• Involved in creating Cubes and Hiearchies between different attributes and Dimension.
• Involved in Creating paramerterized as dyanamic 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 the current Performance Point (PPS) application.
• Worked on SQL Server Integration Services Packages(SSIS) and PPS for loading the data into the 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 the data to be loaded to the 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 the application context diagram using MS-Visio tool Installed, configured and maintained

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 the 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 the 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 the 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 retrive the 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 Hiearchies 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 the backup schedule for production, test and development servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Resolved bugs during testing cycle of application.

Confidential, NC

SQL Server 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, stored procedures, indexes.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Involved in Designing Dimensional Modelling specially Star Scheme.
• Involved in creating Cubes and Hiearchies between different attributes and Dimension.
• Involved in Creating paramerterized as dyanamic 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 the application after the upgrade, make sure everything is working fine.
• Experienced wif improving SQL Server using windows performance monitor to improve the server performance.
• Involved in creating SSIS packages for loading incremental loading to full Loading.
• Created the DTS packages to import the data from MS Access and Oracle server to SQL Servers. .
• Involved in securing the SQL Server environment and involved in setting up the 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 the backup schedule for production, test and development servers.
• Experienced in troubleshooting production servers and fixed the 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.

Confidential, OH

SQL Developer/DBA

Responsibilities:

• Involved in gathering the client requirements, Technical documentation and impact Analysis.
• Created Store Procedures, Triggers, Functions, and Indexes as per the requirement.
• Involved wif testers during the 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 Hiearchies between different attributes and Dimension.
• Involved in Creating paramerterized as dyanamic 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 the 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 the DTS packages to import the data from MS Access and Oracle server to SQL Servers.
• Experienced wif creating logical and physical database design for development projects.
• Involved in securing the SQL Server environment and involved in setting up the 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 the database schema changes and database restore requests.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced wif creating change management tickets for production and test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

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 the DTS packages
• Involved in Data Migration from DB2 to SQL Server.
• Used Visual Source Safe for Configuration Management and Version Tracking.
• Created the logical and physical data modeling using Erwin tool.
• Configured Log shipping from one production server to the 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 the SQL queries and stored procedures.
• Used different environment included Development, Staging, Testing, and Training & Productions for Implementations

Confidential

SQL Developer/DBA

Responsibilities:

• Involved in gathering the client requirements, Technical documentation and impact Analysis
• Involved in Production support for all types of technical issues.
• Created Logical & Physical Database Design, Data Modeling using Erwin tool.
• Created database maintenance plan for SQL Server backups, optimization, integrity check and transaction log backups.
• Responsible to execute SQL Server DBAs team, Capacity planning, sizing, monitoring Disk me/O, Server Rebuild & migration.
• Experienced wif SQL Server performance improvement and optimize the databases. Involved in performance tuning and index tuning.
• Work wif business team to implement the business rules and developed logical and physical database design.
• Created the Standards for SQL Server environment.
• Created the backup and restore strategy for production, development and test environments.
• Monitored production server’s activity, scheduled jobs, SQL Server Error Log, space usage.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Responsible to convert MS Access 2000/97 databases into MS SQL Server 2000 databases.
• Installed SQL Server Analysis Services and developed the OLAP cubes.

Confidential

SQL Server Developer

Responsibilities:

• Involved in gathering the users requirement and technical documentation
• Created Logical and physical data modeling for databases using Erwin.
• Installed and configured the transactional replication for 2 environments.
• Installed, configured SQL Server 7.0 and 2000 on windows 2000 server platform.
• Upgraded the MS SQL Server 6.5 to SQL 2000.
• Responsible for User administration and granting permission to application users.
• Involved in creating tables, indexes, stored procedures and triggers.
• Optimized the database to improve the performance, halped the SQL Server developers to tune the Queries.
• Involved in database backup and restore operations.
• Imported the data to MS SQL Servers using DTS Packages.
• Used DBCC commands to check the consistency of the databases.
• Created the documentation for production server changes.