SUMMARY:

• Over 7 years of IT experience in Database Design and Development on Microsoft SQL Server 2008/2005/2000 . Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• High degree of proficiency in gathering user specifications from business users and preparing detailed Business Requirement Documents (BRD’s).
• Experience of Relational Database Management systems (RDBMS) and Database design issues like normalization and de - normalization.
• Extensive experience with T-SQL, Functions, Views. Experienced in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Developed complex stored procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Implemented cursors for rebuilding indexes.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service (SSIS).
• Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Expertise in designing Data Flow task, Work Flow task and designed various SSIS Transformations like OLEDB Command, Conditional Split, Aggregate, Multicast and Derived Column.
• Excellent in High Level Design of ETLDTS Packages &SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and unionall.
• Experienced in performing Incremental Loads and Data cleaning in SSIS. Managed Error handling, logging using Event Handlers in SSIS.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix Reports, Tabular Reports, Charts/Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing Expressions in SSRS and Expert in fine tuning the reports.
• Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS.
• Hands-on experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Good knowledge of defining, developing and deploying StarSchema, SnowflakeSchema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).
• Involved in developing OLAP dimensions, cubes, measures, and calculated members with SQL Server Analysis Services 2005/2008.
• Worked in OLTP & OLAP environments that include QA, Production and development, implemented and maintained database schema and Entity relationship diagrams from business requirements.
• Experienced on Performance monitoring using SQLProfiler scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation.
• Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation
• Managed all database servers in development, staging, test and production environments.
• Worked with internal enterprise architects and consultants, assisting in the development of current and target state enterprise data architectures.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and also worked in a technically challenging environment.

TECHNICAL SKILLS:

Languages: T-SQL, SQL, Dynamic SQL, .NET Framework, C, C++, C#, ASP.NET, VBScript, XML, HTML, DHTML, HTTP.

RDBMS: SQL Server 2012/ 2008/2005/2000, Oracle 11g/10g/9i/8i and MS Access 2003/2000/97

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio.

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Web Services, SOAP.

Operating Systems: Unix, Windows NT/XP/2003/2000,Windows 9x and MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

SQL Server BI Developer

Responsibilities:

• Involved in gather user requirements and system specifications.
• Actively involved in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code.
• Significantly used T-SQL Statements in developing user defined functions (UDF), indexes, relational database models, and data integrity.
• Maintained referential integrity and implemented complex business logic.
• Involved in installation and configuration of SQL Server 2008 and SQL Server 2012 with latest service packs.
• Created and executed SSIS packages to populate data from the various data sources.
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB Source SQL Server, Text file to SQL Server 2008.
• Migrated DTS packages to SSIS packages by modifying those packages.
• Designed ETL packages dealing with different data source and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Migrated and recreated existing dimensions and cubes using Star Schema on SQL Server 2008 to achieve the efficiency of SSAS.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, cross tabs and charts.
• Design, deployment and maintenance of various SSRS in SQL Server 2008.
• Designed and implemented parameterized and cascading parameterized reports using SSRS
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Responsible for backup, restore systems and other databases as per requirements and also scheduled those backups.
• Managed the security of servers, creating the new logins and users, changing roles of users.
• Involved in developing logical and physical model of database using Microsoft Visio.
• Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008, SQL Server Business Intelligence Development Studio 2008/2005, DTS to Import & Export Data, VB Script, Windows XP.

Confidential, Atlanta

Sr.SQL Server Developer

Responsibilities:

• Gathered business requirements from users and translated them as technical specification for development.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Identified various data sources, formulated data dictionaries, design and develop data models based on the given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraintsetc on various database objects to obtain the required results.
• Transferred data from various data sources/business systems including MS Excel, MS Access & Flat Files etc to SQL Server using SSIS/DTS.
• Developed highly scalable report automation system utilizing SSIS, T-SQL, stored procedure, cursor, Enterprise Manager, Query Analyzer
• Created ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats
• Migration of stored procedures and database objects between development and test environments.
• Author concise functional/technical documentation and provide status and project updates using Visual Studio Team Foundation Server.
• Attend regular project meetings and weekly status meeting.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services2008 (SSIS), MS SQL Server Reporting Services 2008(SSRS), MS SQL Server Analysis Services 2008(SSAS),T-SQL, Visual Studio 2008.

Confidential, Pittsburgh, PA

SQL Server Developer/Support

Responsibilities:

• Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
• Created Views, indexes and done performance tuning to T-SQL code used in SSIS Packages.
• Developed some complex Stored Procedures as per the need of business to in corporate the changes in requirements.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Modified the existing SSIS Packages to improve the performance of data load.
• Created SSIS Packages to load the data from various sources like Excel, Flat Files and SQL Tables by applying multiple transformations.
• Successfully migrated SSIS packages fromdevelopment to test and Productionenvironments using SSIS Configuration files and deployment wizard.
• Hands on Job Scheduling of SSIS Packages through SQL Server Agent.
• Done some Data Validations for the existing Procedures and SSIS Packages.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management and Report delivery.
• Developed Complex Queries to generate Reports.
• Generated various Tabular, Matrix and Drill Down Reports based on the requirements.
• Actively participated in changing the current Billing System as per the Business Need.

Environment: SQL Server 2008/2005, T-SQL, SSIS, SSRS, MS-Excel, Visual Studio 2008,Windows Server 2003 Enterprise Edition, HTML, MS Access.

Confidential, Houston,TX

SQL Server Developer

Responsibilities:

• Checking database integrity, Creating new databases, tables, views and Stored Procedure.
• Involved in migration of SQL 2000 to SQL 2005.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Developed complex T-SQL code, stored procedures, functions, views and triggers for the application.
• Created ETL SSIS packages both design and code to process data to target databases.
• Fine tuned DML, DDL scripts with lock hints for performance boost.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers
• Responsible for writing T-SQL code for creating cursor and handling data validations.

Environment: MS SQL Server 2000/2005, SQL Server 2005/2000 Enterprise Edition, SSIS, Windows Server 2003, Windows XP.

Confidential, Atlanta

SQL Developer/DBA

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.
• Managed index statistics, Tables, Views, cursors and optimized queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Done Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed and deployed SSIS packages.
• Provided application support. Developed and tested Windows command files and SQL Server queries for Production database monitoring in 24/7 support.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

Environment: MS SQL Server 2005/2000/7.0, DTS, Windows 2003, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Query Analyzer, Erwin, FTP Communication, MS-Visual Studio, UNIX.

Confidential

Junior SQL Server Developer

Responsibilities:

• Involved in various phases of Software Development Life Cycle (SDLC) and developed use Case diagrams, Object Diagrams, Class Diagrams, and Sequence diagrams to represent the detail design phase using Rational Rose
• Implement high availability through database mirroring and Merge Replication.
• Performed Import / Export using DTS
• Configured Log Shipping between Primary and Secondary servers.
• Created database, tables, Indexes and views.
• Created linked server between SQL servers.
• Dropped and recreated the indexes on tables for performance improvements.
• Designed DTS packages to refresh data on Development and QA/Staging.
• Wrote dynamic stored proc to create Database Roles and grant permission to roles and adding logins to specified roles.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.

Environment: Microsoft SQL Server 2000, Windows XP.