OBJECTIVE:

• Seeking for a responsible, challenging, and awarding role in software industry where in my skills and technical abilities can be utilized and enhanced, contributing to growth and success of individual as well as the company.

SUMMARY

• Over 8.5 years of experience in design, development & analysis of SQL Server 2005/2008/2012.
• Experience with Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2008.
• Development and Administration experience on Database Design and Implementation of OLTP.
• Experience in Designing and Implementation of Relational Database Model for business requirements using Normalization forms.
• Good at creating Tables and Views as per the business and design requirements using T - SQL.
• Extensive experience in developing Stored Procedures, Functions (Arithmetic, String and DateTime) using T-SQL.
• Good understanding of ACID properties, RDBMS, Normalization /De-normalization and database modeling.
• Implemented Triggers at different levels of Database Objects to apply Security Constraints.
• Good at improving Performance using Table Indexes, Indexed Views by implementing Schema Bindings.
• Expertise in designing of database in SQL Server 2008 and Reporting services.
• Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.
• Expertise in writing and debugging Stored Procedures and Triggers
• Expert level skill in Extraction, Transformation and Loading (ETL) in SQL Server database.
• Expert in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Created stored procedures for inserting, updating and deleting settings(MS-SQL)
• Used the existent procedures for calculation of data as per business requirements (MS-SQL)
• A multi tasking analytical thinker with the ability to work on fast paced work Environment.
• Strong communication skills and an ability to work individually or part of a team and good learner to adapt new technologies that improve the business.
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, XML).
• Experience in writing distributed queries.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.
• Involved in transformation of OLTP data to the Data Warehouse using DTS and SQL commands.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Experience in Microsoft SQL Server Database Administration including planning, backup, and recovery strategies.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.

TECHNICAL SKILLS

Relational Databases: SQL Server 2008/2005/2000 , Oracle 10g/9i/8.0, MS Access, DB2, MS Excel, DB2, Teradata, Sybase.

Tools: and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, Erwin, DTS, Microsoft Visual Source Safe, Crystal Reports9.0, Idera, Lite speed, MDX, Visual Studio .Net, ProClarity, Db Pro, Octopus, Visual Source Team Foundation

Languages: T-SQL, PL/SQL, V.B6.0, MDX, C, C#, ASP.Net, VB.Net.

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Database Design Tools: MS Visio, Erwin

Web Technologies: HTML, XML, XSL, JavaScript, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Integration Services(SSIS), Performance Point Server 2007

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SQL Developer

Responsibilities:

• Create database design, objects and metadata information for three different applications.
• Create and schedule Autosys jobs to run the delta framework.
• Performance tuning the SQL code to efficiently process all of the data.
• Writing ETL’s which will be scheduled on daily basis for loading the data.
• Using tools like, SSIS to load the data
• Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL.
• Good experience in database development and data migration.
• Good experience in creating SQL Server database objects like tables, views, procedures, functions and triggers for a project.

Confidential, Charlotte, NC

SQL DBA/ Developer

Responsibilities:

• Create database objects such as tables,views, stored procedures, Triggers etc
• Design and develop T-SQL procedures, query performance tunings.
• Create functions to provide custom functionality as per the requirements.
• Experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL.
• Create Users and assign permissions based on the level of database access the user would need.
• Design database Backup and Restoration Strategy
• Once created the database Backups, monitor those backups are being performed regularly.(SQL Server Agent)
• Troubleshoot various problems that arise in a day-to-day work and fix the issues.
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc)
• When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes.
• Perform restores from production to other environments.
• Run jobs/create new jobs using SQL Server agent.
• Performing re-building and re-organizing the indexes.
• Run trace to identify slow running queries and analyze the same in tuning advisor.
• Perform analysis on slow running queries with execution plan.

Confidential, Richmond, VA

SQL Developer

Responsibilities:

• Create Entity Relationship (ER) Diagrams to the proposed database
• Create database objects such as tables,views, stored procedures, Triggers etc.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Create functions to provide custom functionality as per the requirements.
• Be aware of potential blocking, deadlocking and write code to avoid those situations.
• Endure that the code is written keeping in mind any security issues such as SQL Injection.
• Good experience in using T-SQL (DML, DDL) in SQL Server 2008 platforms.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
• Expert Experience in Normalization, De-normalization.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio.
• Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.

Confidential, Indianapolis, IN

SQL Developer

Responsibilities:

• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications
• Currently working as a SQL Lead for more than 3 clients.
• Working on Netezza and SQL server environments as destinations to load the data from user feeds
• Develop cube, intersection and lookup tables to load the data from with T-SQL ETL’s.
• Analysis, Design and data modeling of Logical and Physical database using E-R diagrams.
• Involved in database Schema design and development.
• Used script components for reading and writing variables for capturing the dates.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Writing ETL’s which will be scheduled on daily basis for loading the incremental loads.
• Using tools like, SSIS to load the data
• Experience in designing Database Models using MS Visio and ER-Win for both Relational and dimensional modeling.
• .Experience in Error handling and debugging coding issues and troubleshoot production problems.

Confidential, Westminster, CO

SQL Developer

Responsibilities:

• Data analysis, Logical and Physical data modeling, and database design support for retirement plans development team.
• DataModelerwith strong Conceptual and LogicalDataModeling skills, has experience with JAD sessions for requirements gathering, creatingdatamapping documents, writing functional specifications, queries.
• Extensive experience in Relational and DimensionalDatamodeling for creating Logical and Physical Design of Database and ER Diagrams using multipledatamodeling tools like ERWIN, ER Studio.
• Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modifieddatabase design document with detailed description of logical entities and physical tables.
• Excellent knowledge of waterfall and spiral methodologies of Software Development Life Cycle (SDLC).
• Possess strong Documentation skill and knowledge sharing among Team, conducteddatamodeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Extensive Experience working with business users as well as senior management.
• Strong understanding of the principles ofDatawarehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementingData Modeling changes.
• Understanding the requirements and work within a team to assist in design, develop and maintain integrated enterprise business intelligence BI) Solutions
• DimensionalDataModeling, RelationalDataModeling, Star and Snowflake Schema, Fact and Dimension Tables.
• Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modifieddatabase design document with detailed description of logical entities and physical tables.
• Excellent knowledge of waterfall and spiral methodologies of Software Development Life Cycle (SDLC).
• Extensive experience in developing stored procedures, triggers and views in SQL Server 2008
• Good hands on experience in working with Team Foundation Server 2008/2010.
• Develop ETL packages to perform full load/ delta or incremental load based on package type and schedule type.
• Perform Type1, Type 2 and Type 3 loads based on package type and schedule type using SSIS.
• Send emails to the users to update the status of errors while loading the data.
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Excellent skills in implementing ETL Packages using DTS and SSIS2008/ 2005.
• Proficient in implementing all transformations available on the SSIStoolbox.
• Experience in creating master and child packages, package configurations and logging.
• Excellent knowledge of using variables and expressions in packages.

Confidential, Mobile AL

SQL Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and maintaining referential integrity
• Responsible for creating users and roles and assigning permissions to access database objects
• Monitor and manage SQL Server Agent Jobs to ensure successful completion.
• Monitor overall database standards and procedures.
• Responsible for General Database Administration, Query Performance tuning.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine
• Worked with DTS packages to load the massaged data into Data warehousing system
• Trouble shooting problems by using SQL server profiler Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Maintained client relationship by communicating the daily status and weekly status of the project.
• Designed and implemented the Logical and Physical model of the database.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Installed and maintained MS SQL Server 2000.
• Monitored performance and optimized SQL queries for maximum efficiency.

Confidential

Software Developer

Responsibilities:

• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created Databases, Tables, Views, Indexes.
• Managed index, statistics and optimizing queries by using execution plan.
• Responsible for transferring the data using SSIS packages.
• Gathered user requirements.
• Developed Analysis Services Project.
• Responsible for Dimensional modeling.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Responsible for identifying and defining Data Source and Data Source views.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Designed dimensional modeling with star and schema flakes Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems
• Documented all database objects and packages for future references.
• Educated team on load process and data movement changes.
• Analyzed and designed of software and database solutions. Created tables, views, stored procedure as per design needs.
• Maintained data integrity by performing validation checks.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
• Developed, monitored and deployed SSIS packages.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Identified the database tables for defining the queries for the reports.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Actively supported business users for change requests.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Involved in entire life cycle including database Design, Development, Testing, Optimizing, deploying on development and production servers

Environment: MS SQL Server 2005, MS SQL Server 2000,, MS SQL Server Integration Services (SSIS), MS Access, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, Oracle, T-SQL, Query Analyzer.