PROFESSIONAL SUMMARY:

• Around 7 years of experience with design, development and implementation of SQL Server based Application methodologies in the field of commercial and business applications.
• Experience in installation, Upgrade and configuration of MS SQL Server database.
• Hands on expertise in migrations from MS SQL Server 2000 to MS SQL Server 2005 to MS SQL Server 2008.
• Experience in Microsoft SQL Server Database Administration including planning, implementing, backup, and recovery strategies.
• Strong Transact - SQL query writing skills (DDL, DML, and DCL).
• Good experience in creating objects such as Databases, Tables, Stored Procedures, Triggers and Cursors, Constraints, Indexes, Views, Indexed Views in Microsoft SQL Server 2000/2005/2008.
• Good understanding of Normalization/De-normalization, Database design, Entity- model and application oriented design.
• Experience in optimizing the database by creating various Clustered, Non-clustered Indexes.
• Efficient usage of DBCC commands to increase the performance of the query.
• Have strong analytical, troubleshooting and problem-solving skills dedicated to maintain the high quality standards. Good communication skill, ability to work independently.
• Experience in design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Knowledge of Dimensional Data Model concepts, Dimension and Fact tables, Surrogate keys, Star and Snow Flake Schema, Physical and Logical Data modeling.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages using various data transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Experience in Designing and Building the Dimensions, Fact Tables with star and snow flake schemas using SQL Server Analysis Services (SSAS).
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Experience in software Analysis, Design, Development, Testing, Implementation and Production, support of Client/Server and Web based applications.

TECHNICAL SKILLS:

RDBMS: SQL Server 2000/2005/2008/2012, Oracle 10g/9i/8i/7.1, MS-Access 2000MS-Access 2007, Teradata v2r4/ v2r5 and MS-Excel7.0

TOOLS: SQL Server Management Studio, Enterprise Manager, Query AnalyzerSQL Profiler, Database Engine Tuning Advisor, SSIS, SSRS, BusinessIntelligence Development Studio and Data Transformation Services

DATAWAREHOUSING: OLAP, OLTP, Star Schema Modeling, FACT and Dimension Tables.

PROGRAMMING & XML: C, C#, VB Script, Visual Basic, SQL, Transact SQL, PL/SQL, HTML. SCRIPTING LANGUAGES

OPERATING SYSTEMS: Windows 9x/2000/2003, Windows NT/XP and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, Missouri

SSIS/SQL Developer

Responsibilities:

• Worked closely with Business Team regarding scoping of requirements on regular basis.
• Worked on Migration of reports from IBM Cognos to Sql server Reporting services
• Synchronizing multiple reports, dynamically designing the Table headings, groups and Field values and creating Reports with Interactive sorting.
• Good knowledge in creating Reports which can be used to modify the Data from the Report.
• Creating Reports with Report parameters.
• Worked on Sql server integration services, Extracting data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations..
• Created Configurations to change the package properties dynamically.
• Maintained log information in SQL table to tracking Errors and recording package execution status.
• Creation of Package configurations, Logging, Deploying packages to target server
• Scheduling SSIS packages using SQL Server Agent in SSMS.
• Ensures Quality and Timely delivery of assigned tasks
• Closely worked with Testing and Business Team in fixing test environment issues.

Environment: SSIS 2008/2005, SSRS 2008/2008R2, IBM Cognos 8 BI, Server, MS SQL Server 2008R2/2012, DTS, T-SQL, Oracle 10g, PL/SQL, TOAD, T-SQL, Mainframes, C#. NET, VB.NET, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyser, Erwin 7, TFS

Confidential, Virginia Beach, VA

SQL Developer/SSRS

Responsibilities:

• Gathering the requirements by interacting heavily with the business users, multiple technical teams to design develop the work flows for the new functional piece.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes
• Extensively used joins and sub queries for complex queries involving multiple tables from different databases.
• Performance tuning of stored procedures and functions to optimize the query for better performance.
• Transformed complex business logic into database design and maintaining it by using Sql objects, stored procedures, user defined functions, views, T-SQL scripting and jobs.
• Successfully implemented indexes on tables for optimum performance.
• Developed complex stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting services.
• CreatedSub Reports, Parameterized and Drill down Reportsbased on the requirements provided using SSRS.
• Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
• Scheduled SSRS reports for end users and managed the security of the reports.
• Exported SSRS reports to various formats like PDF, Word and Excel and scheduled to reports to send as an email body.
• Strong analytical and problem solving skills coupled with interpersonal and leadership skills.
• Interaction with the clients to gather out the requirements and assist them in immediate workarounds for the issues with the application.
• As SSRS developer, working closely with Business Analysts gathering and clarifying data reporting requirements.

Environment: MS SQL Server 2008R2/2012, SSIS 2008/2005, SSRS 2008/2008R2, DTS, T-SQL, Oracle 10g, PL/SQL, TOAD, T-SQL, Mainframes, C#. NET, VB.NET, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0.

Confidential, Woonsocket, RI

Sr.SQL Server/Business Intelligence Developer

Responsibilities:

• Experience in Upgrading of SQL Server 2000/2005 databases to SQL Server 2005/2008.
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
• Created databases, tables, stored procedures, views, functions, and triggers using T- SQL.
• Created tabular, matrix, parametric and dashboards reports according to business requirement.
• Studied the existing source tables and created new tables in production database using TOAD
• Created Complex Stored procedures, triggers and used aggregations for conversion of data from staging to production.
• Worked on Stored Procedures, Functions and Triggers in the development of the application.
• Extensively worked on Database development and partly in administration.
• Complex querying skills, development of database objects such as T-SQL, Stored Procedures, Functions with database administration skills
• Strong analytical and problem solving skills coupled with interpersonal and leadership skills.
• Interaction with the clients to gather out the requirements and assist them in immediate workarounds for the issues with the application.
• As SSRS developer, working closely with Business Analysts gathering and clarifying data reporting requirements
• Creation of sub-reports, Drill down reports, Charts, Cube-Based Reports, Report Models for Ad-Hoc
• Synchronizing multiple reports, dynamically designing the Table headings, groups and Field values and creating Reports with Interactive sorting.
• Good knowledge in creating Reports which can be used to modify the Data from the Report.
• Creating Reports with Report parameters.
• Extracted data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.
• Good knowledge in creating Event Handlers for Error Handling.
• Created Configurations to change the package properties dynamically.
• Maintained log information in SQL table to tracking Errors and recording package execution status.
• Creation of Package configurations, Logging, Deploying packages to target server
• Scheduling SSIS packages using SQL Server Agent in SSMS.

Environment: MS SQL Server 2008/2008R2, SSIS 2008/2005, SSAS 2008/2008R2, SSRS 2008/2008R2, DTS, T-SQL, Oracle 10g, PL/SQL, TOAD, T-SQL, Mainframes, C#. NET, VB.NET, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0

Confidential, Columbus, OH

Sr.SQL SSIS/SSRS developer

Responsibilities:

• Worked with Business Analysts and Users to understand the requirement.
• Worked on different levels of ETL Loads to extract Data from Source System to Staging and then from Staging to load data into Production Data Base Tables.
• Deploying the SSIS/DTS packages in file system and MSDB databases.
• Created tabular, matrix, parametric and dashboards and scorecards reports according to business requirement.
• Scheduled reports, reports services documents and dashboards using Schedule Manager.
• Created packages to migrate data from different data sources to data warehouse.
• Created packages for database maintenance.
• Experience in applying various transforms, SCD (slowly changing dimensions) to maintain the history of the data, aggregate, multicasting, conditional split, Merge, Merge join, Pivot etc.
• Used SSIS control flow tasks Loop Containers, FTP, Bulk insert, Transfer job task etc. and different data flow tasks such as Derived Column, Fuzzy lookup, data conversion etc.
• Wrote scripts for Data Profiling, reported the risks, issues after running those scripts on the source systems and used those results in designing the ETL.
• As SSIS developer, worked on Designing and Implementing the ETL processes.
• Creation of Packages using SSIS to load data from source to DWH.
• Applying Derived Column, Multicast, and Conditional Split transformations while loading Data into DWH
• Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task.
• Extracted data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.
• Good knowledge in creating Event Handlers for Error Handling.
• Created Configurations to change the package properties dynamically
• As SQL developer, worked in the application development side like enhancements and letter (XML) changes as per the customer requirements.
• As a SQL database Developer, worked on Designing Tables, Designing Stored Procedures, Designing Functions, Designing Triggers, Designing complex scripts using T SQL, Designing complex scripts using BCP command.
• Experience working on 24X7 environment
• Involved in the overall systems analysis, design, development and implementation
• Developed complex SQL Server database to responsively handle data retrieval (T-SQL, DTS, Triggers, Stored Procedures) and SSIS Packages
• Involved in development of entire web applications and generate reports in the desired format of HTML and PDF using SQL Reporting Services.
• Extensively interacted with clients and business teams to provide technical support and measure the scalability, consistency and accuracy of the applications.

Environment: MS SQL Server 2008 R2/2008, SSIS 2008, SSRS 2008, DTS, T-SQL, Visual Studio 2005, Microsoft Visio, Windows 2007,SQL Server Business Intelligence Development Studio (BIDS) MS Access 2007

Confidential, Portland, ME

Sr.SQL Server/Business Intelligence Developer

Responsibilities:

• Continuously interacted with end user to gather business requirements to develop Business Requirement Document (BRDs) and ETL specifications.
• Upgraded from SQL Server 2008 to SQL Server 2008R2.
• Involved in database design to define E-R (Entity- Relationship) models using Erwin 7.0 and implemented Ralph-Kimball methodology of dimensional modelling.
• Used T-SQL to create databases and database objects like tables, views, stored procedures, indexes and triggers.
• Worked with complex SQL statements using joins, sub queries and correlated sub queries.
• Using Dynamic SQL statements constructed and executed dynamically during run time, based on supplied users.
• Performance tuning in Database level, T-SQL level, Operating System level & Hardware level.
• Periodic checking of all databases with DBCC commands for maintaining data consistency and integrity and responsible for keeping system and databases up-to-date by making necessary changes.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Extracted data from XML to SQL server.
• Published migrated data using SSIS (SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.
• Responsible for Deploying, Scheduling, Alerting and Maintaining SSIS packages.
• Created OLAP Cubes and deployed those using SQL Server Analysis Services (SSAS).
• Created reports on the deployed cubes using SQL Server Reporting Services (SSRS).
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models, standard report Subscriptions and Data Driven report Subscriptions using SSRS.

Environment: MS SQL Server 2008/2008R2, SSIS 2008/2005, SSAS 2008/2008R2, SSRS 2008/2008R2, DTS, T-SQL, OLAP,, Oracle 10g, PL/SQL, TOAD, T-SQL, Mainframes, C#. NET, VB.NET, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0

Confidential, Fort Worth, TX

SQL Server DBA/Developer

Responsibilities:

• Worked Extensively on SQL Server 2005 and 2008/2008R2
• Involved in performing Extraction, Transformation and Loading using SSIS
• Developed all the required Stored Procedures, user defined Functions, Triggers, Views using T-SQL as per business logic.
• Used SQL Server 2005/2008 Reporting Services (SSRS) for generating reports, MDX queries utilized.
• Worked extensively with client gathering requirements to generate customized SQL Reports (Subscriptions Created)
• Used “SQL Profiler TSQL Duration” template for tracking execution time of TSQL Statements.
• Development and Implementation of Backup and Recovery strategies
• Database Backup Compression and Encryption using SQL 2008
• Implemented different types of Replication Models (Snapshot, Merge and Transactional) and Log Shipping.
• Optimized the performance of queries.
• Created Dashboard for the business using SSAS OLAP Cube and integrating it with Performance Point Server (PPS)
• Used SharePoint Enterprise Portal for hosting Scorecards and SSRS Reports
• Promoted database objects from DEV/TEST to Production. Coordinated and Communicated production schedules within Development and Testing team.
• Worked extensively on all the Environments: Development, Testing and Production
• Worked with front-end application developers to understand their requirements and create Procedures and Reports.
• Automated Database Maintenance tasks by creating Jobs, Alerts and Operators through SQL Server Agent.

Environment: SQL Server 2005/2008/2008 R2 Enterprise, T-SQL, MS-Excel, MS-Access, XML, SSIS, SSRS, SSAS, MDX, OLAP, PPS, SharePoint, Erwin, Microsoft Visual Studio 2005/2008, Windows 2000/2003/NT/XP.

Confidential

SQL Server Developer

Responsibilities:

• Installation, Configuration and Maintenance of MS SQL Server 2000.
• Gathered functional requirements and wrote the technical specifications.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Responsible for Query optimization and Performance tuning.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Managed replication issues.
• Secured the SQL Server by creating user logins with appropriate roles, dropping and locking the logins, creation of groups, granting the privileges to users and Groups.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Performed Project planning and scheduling database module in conjunction with project managers.
• Tested queries to optimize the procedures and triggers to be used in production.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Worked on DTS Packages, DTS Import/Export for transferring data between SQL Server.
• Analysed and designed disaster recovery/replication strategies with business managers to meet the business requirements.
• Developed processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
• Used SQL Profiler for getting the trace activity for the Various Stored procedures and used Index Tuning wizard for performance betterment.
• Checked Performance Tuning, Indexing, Query Optimization.
• Used database consistency checks using DBCC Utilities.
• Created DTS Packages to import data from Excel spread sheets.
• Used DTS to created jobs to populate some of the tables with data from other servers.
• Good exposure in running jobs in Enterprise Manager using job-scheduling tool.

Environment: MS SQL Server2000/2005, T-SQL, Excel, DTS, SSRS, SSIS, Data Analyser, ASP.NET, VB.Net,C#.NET, ADO.NET, VSS 6.0, Windows 2003