SUMMARY

• Over 7 years of extensive exposure in MS SQL Server Development involving full SDLC Environments.
• Interpreting and working with data models, data dictionaries and data flows, data architecture design, logical and physical Data modeling using ERWIN and SQL diagrams.
• Extensive Database programming experience in writing T - SQL stored procedures, User Defined Data types, triggers, constraints and indexes, joins using various DDL and DML commands.
• Experience in Database backup, Recovery, Performance Tuning, Error Handling and disaster recovery procedures.
• Tuning the performance of Stored Procedures and large T-SQL queries using Clustered indexes, DMV’s and efficient coding standards.
• Involved in VLDB configuration by DB Striping, placement of indexes across different drives, RAID levels.
• Extensive experience in 24*7 production support and troubleshooting Failures and System Errors.
• Involved in Security Administration, managing schemas (2005), creation of users, configuring permissions and assigning roles to users.
• Experience in Migrating/Upgrading SQL Server, usage of upgrade advisor, In-place upgrades and new server builds.
• Exposure to multiple database systems like MS SQL, Oracle, MS Access, MYSQL and SYBASE.
• Highly experienced in whole cycle of DTS/SQL Server Integration Services (2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Good Knowledge of Data Marts, Data warehousing, Operational Data Source(ODS), OLAP, OLTP, Data Modeling like Multi Dimensional Data Modeling, Star Schema, Snow Flake Modeling, Slowly Changing Dimensions(SCD), FACT and Dimension Tables using Analysis Services.
• Experience in providing Logging, Error Handling using Event Handler and Custom Logging for SSIS packages.
• Conversion of DTS packages to SSIS and Interfacing Legacy components within SSIS for complex transformations and logic and worked on Error Handling in SSIS.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock transformations.
• Developed OLAP cubes using SSAS 2005/2008 and Expertise skills in calculating measures and dimension members in SQL Server Analysis Services SSAS 2005 using Multi Dimensional Expressions (MDX), mathematical formulas and user-defined functions.
• Developed cubes using Partitions, KPI’s and Perspectives, slowly changing dimensions etc, and created various roles using SSAS 2005/2008 and worked on Performance Tuning is SSAS.
• Expert in generating drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Writing MDX scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboards in SSRS 2005/2008.
• Involved to develop theVB Script, C#, ASP.NET and frameworkcreation in SSASandSSIS.
• Worked in front end designing using .NET for developing Win forms, websites and console applications usingC#.
• Possesses good communication and analytical skills, self motivated as well as flexible to learn advancements in the IT industry and ability to think outside the box.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, C# (.NET), ASP .NET, VB.NET, XML, HTML, DHTML, HTTP, Shell Scripting, PHP Scripting.

RDBMS: SQL Server 2008/2005/2000 , Oracle 10g/9i/8i, Sybase Server, MS Visual Source Safe 2005, 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 techniques

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

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, Crystal Reports, Hyperion

Packages: MS Office, Microsoft Office Suit), Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

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, Business Objects,, Web Services, SOAP.

Version Control and Configurations: Visual SourceSafe 6.0/2005, Visual Studio Team Foundation Server (VSTS), Remedy Change Management

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

• Worked with Advertisers Insight Dashboard Team which is responsible for delivering different types (customer, account, campaign) of reports to yahoo.
• Responsible for the designing the advance SQL queries, stored procedures, cursors, triggers, scripts and worked on Dynamic SQL.
• Worked on automation of maintenance jobs, tuning SQL server, locks and index configurations, administering SQL server security and SQL server backup strategy and automation.
• Designed MS Test Projects using C#.NET to validate the generated reports.
• Worked on MSYFTA Microsoft yahoo file transfer automation project which transfers encrypted/decrypted files from Microsoft to yahoo and vice versa.
• Responsible for the designing, development and maintenance of MSYFTA by utilizing .net, C#.
• Responsible for the determination of the requirements of client and applied those requirements.
• Designed webpages using ASP.NET as part of UI for MSYFTA.
• Responsible for the designing the new database schema and created tables.
• Hosted the system on production server and trained the user about the system.

Environment: MS SQL Server 2008 Enterprise Edition, VS2010 Ultimate, MS Excel, Visual Source Team Foundation Server (VSTS), .Net (Asp .Net, C# .Net)

Confidential, NC

SQL/ BI Developer (SQL/SSIS/SSRS)

Responsibilities:

• Written complex T-SQL queries and stored procedures using joins, CTE’s to increase productivity and Reusability of code.
• Written T-SQL scripts to perform data cleaning which involves identifying and deleting duplicate records from database tables.
• Worked on distributed transactions, building linked servers, complex queries, error handling using SAVEPOINT in transactions.
• Worked on BCP utility to copy data from SQL Server into Flat files using DOS commands and Batch Files.
• Performed Efficient Tuning of SQL source queries for data load/usage of stored procedures or performance and Error Handling of T-SQL queries.
• Upgraded databases from SQL server 2000 Enterprise version to SQL server 2005 Enterprise version.
• Involved in planning and documentation of System development which includes requirements gathering, system design, data flow diagrams, project plans.
• Created SSIS packages with different data sources (SQL server, flat files, excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of data flow transformations.
• Worked on SSIS Performance tuning using Counters, Error handling, Event handling and re-running of failed SSIS packages using Check points.
• Created SQL server reports using SSRS 2005 which include drill down, drill through and parameterized reports.
• Worked on Ad-hoc reports, grouping and sorting using SSRS.

Confidential, CA

BI/SQL Server Developer (SQL/SSIS/SSAS/SSRS)

Responsibilities:

• Installation and Configuration of SQL Server 2005/2008 servers on test, development and production environments.
• Migration of SQL Server (prod/dev) servers side by side and in-place upgrade.
• Administered large databases and striping databases across multiple files and file groups.
• Developed and implemented Procedures and Policies for ensuring the security and integrity of the company database.
• Running DBCC consistency checks and fixing data corruption in user databases and Traced long running queries and deadlocks using SQL profiler and worked on Error Handing.
• Automated the Database consistency check (DBCC) using Maintenance plan at regular intervals.
• Used dynamic management views (DMV’S) and dynamic management functions (DMF’S) for Performance Tuning to check whether indexes are useful or not.
• Written complex T-SQL queries and stored procedures, joins (inner, self) to increase productivity and Reusability of code and worked on implementing Transactional Replication on production servers and troubleshoot errors.
• Implemented Database Mirroring for High availability.
• Based on Windows Script Host manipulated the files usingC# Script.
• Involved in creation of SSIS packages using different Transformations.
• Extraction and migration of data from different data sources like Excel, Text-Files, Ms Access, Oracle,DB2 to MS SQL server using import and export wizard, SSIS, BCP and Bulk insert utilities.
• Implemented SSIS data transformation scripts, created Maintenance plans, procedures and provided data integrity strategies and performance tuning of SSIS packages.
• Created complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Defined the d relationships with the measure groups, fact tables and automatic generation of grouping attribute members in SSAS.
• Extensively involved in SSAS storage and Partitions, Aggregations, calculation of queries with MDX, Data Mining models, developing reports using MDX and SQL.
• Responsible for identifying KPI’s in SSAS 2005 and constructed cubes based on data volumes mostly adhering to star schema.
• Created SQL server reports using SSRS 2005 which include drill down, drill through and parameterized reports.
• Responsible for Scheduling the Subscription report wizard and deployed the generated reports directly on the client’s workstation.
• Authored performance based reports to show sales against various measures like Time, Area and Price-Range and formatted Reports using the global variable expressions.
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.

Environment: MS SQL Server 2008/2005 Enterprise Editions, VS2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, PL/SQL, MDX, Microsoft Office SharePoint Server (MOSS ) 2007, Performance Point Server 2007, Oracle 10g/9i, Toad, MS Excel, Visual Source Team Foundation Server (VSTS), .Net (Asp .Net, C# .Net)

Confidential, Cincinnati, OH

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Upgraded databases from SQL server 2000 Enterprise version to SQL server 2005 Enterprise version.
• Migration of logins, DTS packages into SSIS packages and constructed new SSIS packages to extract, transform and load the data from old data ware house to new data ware house and OLTP and OLAP.
• Created various database objects such as tables, indexes and views based on the requirement.
• Involved in writing SQL Joins, Sub Queries and usage of Temp tables and Table variables.
• Created SSIS packages with different data sources (SQL server, flat files, excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of data flow transformations.
• Worked on SSIS Performance tuning using Counters, Error handling, Event handling and re-running of failed SSIS packages using Check points.
• Worked on Fuzzy look up and Fuzzy grouping transformations of SSIS for improving the data quality of the current data as well as the new data that is being loaded into the database.
• Removed the DTS package s from stored procedures and created as SSIS packages and embedded those procedures in the SSIS packages to maintain the load functionality of the database.
• Worked on SSIS script tasks, Lookup transformations and data flow tasks using T-SQL and visual basic (VB) scripts.
• Maintained the Database Backup strategies and monitored all production SQL servers.
• Based on Windows Script Host manipulated the files usingVB Script.
• Worked on Red Gate Dependency tracker tool to find inter server object s across databases.
• Maintained the business functionality in the process of ERP implementation and created views to be used in various load procedures as pointed to new database system.
• Designed cubes and dimensions using SSAS for the purpose of Analysis, Decision making based on historical data and designed new data ware house (DWH).
• Configured SQL Agent mail to send automatic Emails when errors occur and created automatically grouping attribute members.
• Created dimension members and calculated measures using MDX, defined referential relationships with the fact tables and measure groups.
• Configured Granularity within a measure group and drill through actions and implemented calculations to aggregate physical measures.
• Worked extensively to create Reports using SSRS 2005 and wrote queries for Drill down reports to get the dataset required to build reports.
• Worked with various delivery mechanisms of reporting including email/PDF/schedules etc.
• Created Subscriptions to provide reports on daily basis to users.

Environment: MS SQL Server 2005, MS SQL Server Integration Services 2005 (SSIS), MS SQL Server Analysis Services 2005 (SSAS), MS SQL Server Reporting Services 2005 (SSRS), MS Windows Server 2003, Visual Studio 2005, Business Intelligence Development Studio (BIDS), IIS 7.0/6.0, ERWIN

Confidential, Chicago, IL

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Configured SQL server 2000/2005 server on test, development and production environments.
• Created new instances, Databases, Schemas, objects and table spaces/file groups.
• Extensively involved in creation of DB objects like Indexes, stored procedures, Constraints and triggers, complex joins using T-SQL.
• Collaborated with the application team, SME, business leads and vendors to identify project requirements.
• Worked on Data modeling and responsible for Forward/Reverse engineering various database objects using ERWIN 4.2 and worked on Performance Tuning, Error Handling of T-SQL queries.
• Created logins, users, roles and database maintenance jobs to perform full, Differential and Transaction log backups with the SQL server agent job scheduler.
• Migrated SQL server 2000 to SQL server 2005 across various environments including dev, UA, production and DR environments.
• Configured active/passive two node clustering server for high availability.
• Worked on package migration from DTS to SSIS, running upgrade advisor against DTS packages before migration, resolving issues and conversion into SSIS using wizard and manually.
• Wrote SSIS data transformation scripts, maintenance procedures and provided data integrity strategies.
• Developed, monitored and Deployed many SSIS packages.
• Worked on enhancement of SQL server integration services (SSIS) data loads.
• Extensively involved in SSAS storage and Partitions, Aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL.
• Created Ad-hoc reports, grouping and sorting using SSRS.
• Designed Sub reports and linked reports depending on the user requirement and in order to limit the number of data sources.
• Worked with various Delivery mechanisms of reports including Email/PDF/schedules etc.
• Worked on Report administration and performance tuning of reports.
• Designed and created reports to show the customer interaction activity report e.g. emails sent, mail sent, phone calls made, catalogs mailed, customer complaints and customer waiting period on phone etc.

Environment: MS SQL Server 2000/2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), MS Excel, Data Analyzer, Visual Studio 2005, Advanced Windows 2000 Server, Erwin 4.0, Business Objects 6.5/ XI, VB Script

Confidential, Wood Land Hills, CA

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Designed and developed Data ware house, Data Mart and Business Intelligence using multi dimensional models such as Star schemas and Snow flake schema for developing cubes using MDX.
• Involved in all activities related to development, implementation, administration and support of ETL processes for large scale data ware houses using SSIS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Extensively used SSIS to create ETL packages to validate, extract, transform and load data to Data ware house database, Data Mart databases and process SSAS cubes to store data to OLAP databases.
• Worked on XML configuration files to make the Packages Dynamic and Parameterized.
• Configured packages to use Event logs and fine tuned DML scripts with lock Hints for performance boost.
• Created complex SSAS cubes with multiple fact measure groups based on OLAP reporting needs.
• Created calculated fields with MDX code and used SQL profiler to view index performances to eliminate table scan.
• Implemented standard ActiveX template Routines for transformation of data from source to destination.
• Developed cubes based on Data volumes mostly adhering to Star schema.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Worked on highly complex T-SQL queries, joins and SQL scripts and wrote multiple join T-SQL statements to perform efficient data load based on complex business rules.
• Performed Efficient Tuning of SQL source queries for data load/usage of stored procedures or performance and Error Handling of T-SQL queries.

Environment: T-SQL, MS SQL Server 2005 Enterprise Edition, Enterprise manager, SQL Server Integration Services, MS Analysis Services, MS Access 2005 & Windows NT platform, SQL Server Reporting Services, Crystal Report 8.0

Confidential

SQL Server/BI Developer

Responsibilities:

• Installed and Configured SQL server 2000 on windows 2000 advanced servers, applied service packs and Security fixes.
• Performed Backup/Restore and created Database objects such as tables, procedures, triggers, constraints, indexes, joins and views, user security management, implementation of version control with visual source safe.
• Perform code review on SQL and related code as needed.
• Implemented a successful Security plan by creating statement permissions, linked servers and encryption of connections by creating s.
• Worked on configuring and maintenance of Replication server.
• Applied schema change scripts to existing objects to synchronize with changing business rules by adding or enhancing relevant entities/ tables, columns etc.
• Configured SQL mail, created operators, jobs and alerts for automating databases.
• Involved in data transformation or data flow from sources like Excel, Tables and views to other databases or files with proper mapping.
• Worked on distributed transactions building linked servers, complex queries, error handling using SAVEPOINT in transactions.
• Involved in creation of DTS packages using ActiveX scripting for maintenance purposes.
• Created DTS packages with DTS import/export wizard for transferring data.
• Worked on Data migration (Import & Export - BCP) from text to SQL server.
• Involved in co-ordination between onsite and off-shore team members and worked efficiently round the clock to resolve the issues.

Environment: MS SQL server 2000 Enterprise Edition, Enterprise Manager, MS Analysis Services 2000, MS Access 2000& Windows NT Platform, Reporting Services, Crystal Report 8.0, DTS, ETL, Windows Active Directory, SSIS

Confidential

SQL Server Developer

Responsibilities:

• Responsible for creation, manipulation and supporting the SQL Server databases.
• Involved in creating database objects like tables, indexes, sequences, constraints, triggers and stored procedures and writing complex SQL joins.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL server, locks and index configurations, administering SQL server security and SQL server backup strategy and automation.
• Helped in integration of front end with the SQL server backend.
• Monitoring of log files, maintaining the database by taking the backup of the data and log files and restoring the backup files on different environments (development, test and production).
• Written complex T-SQL queries for retrieval of data and involved in performance tuning of TSQL queries.
• Involved in creating users, logins as part of security administration.
• Used DTS for data transformation from other sources like Excel, Access.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.