SUMMARY:

• High proficiency with 6 years of experience in Database System Analysis, Design, Data Mining and Implementation of MS SQL Server 2008R2/2008/2005.
• Extensive knowledge of Relational Database Management Systems like SQL Server.
• Expertise in developing Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2008R2/2008/2005 to facilitate efficient data manipulation and data consistency.
• Experienced in defining Data Sources for creating data source views.
• Expertise in working with and designing SQL Server 2008R2, SQL Server 2008R2/2008/2005
• Extensive working knowledge of Oracle databases with forms and reports and MS SQL Server 2008.
• Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and OLAP
• Applying data mining algorithms to data acquired from social media for business intelligence, preparing graphical summaries for clients, monitoring social media during crisis situations for clients
• Strong experience in T- SQL development with MS- SQL Server 2008R2/2008/2005.
• Experience in upgrading of SQL Server from version 2000 to 2005, 2005 to 2008 and 2008 to 2008R2
• Sound Knowledge of Db2
• Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
• Excellent Expertise in integration Services using SSIS.
• 5 years Experience in developing, monitoring, extracting and transforming data using SSIS/DTS Import Export Data, Bulk Insert and SSIS/DTS.
• Experience in authoring reports using SSRS.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Proficient in performing DBA tasks like installing and configuring SQL servers, creating maintenance plans, checking job failures and troubleshooting issues.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Performed database health checks using SQL profiler, SQL performance monitor and performance counters.
• Experience in design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services SSRS .
• Sound Knowledge of different modeling schemas like Star Schema and Snow Flake Schema and also Cubes.
• Extensively involved in tuning stored procedures and T-SQL queries.
• Knowledge of Microsoft Business Intelligence Development Studio BIDS .
• Migrated Data from MS Access, MS Excel, DB2 to SQL Server 2008/2005 by using SQL Server Integration Services SSIS .
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Outstanding experience in SQL Enterprises Manager and SSMS creating and scheduling jobs, alert and operators with SQL Server Agent, SQL Profiler, restoring database.
• Hands on experience on Reporting Services and Integration Services to manage data ware house environment.
• Expertise in testing applications manually as well as using Automated Testing Tools.

SKILLS:

Professional Experience:

Confidential

Sr.SQL Server Developer

• Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Worked Extensively with SSIS to import, export and transform the data between data sources.
• Created new database objects like Tables, Schemas, Procedures, Functions, Triggers, Cursors, Indexes and Views using T-SQL in Development and Production environment to implement business logic.
• Provided support to database Servers in Production, QA and Development.
• Created SSIS Packages to import data into the data warehouse and also to transport data across data sources.
• Created matrix reports for the management to have high level of knowledge on the appeals filed under various categories in any specific period. The reporting period is specified by the user through parameters.
• Used SVN Subversion for source and version control.
• Responsible for maintenance of the existing reports by modifying the stored procedures/RDLs based on the changes in the business requirements.
• Scheduled and maintained packages using Tidal Scheduler.
• Used dynamic connection string to populate the report with date timestamp and also the version number of the report.
• Created SSIS packages for reports that have special templates and cannot be accommodated through SSRS.
• Created subscriptions and data driven subscriptions to run the reports on a monthly or quarterly basis.
• Scheduled and maintained packages using Tidal Scheduler.

Confidential

Data Mining Lead/Sr.SQL Server Developer

• Assisted on specialized research and data mining that resulted in positive outcomes for the clients. Returned requested data and source material in a timely manner that allowed for any additional legal action.
• Redesigned and reduced stored procedure execution time. The stored procedure code was greatly simplified and executed more quickly.
• Designed tables and ETL processes into a standard set of tables for the support of business analysis reports.
• Converted SQL Server 2000 DTS Packages to SQL Server 2008 Packages.
• Loaded data into different destination, SQL Server, MS Excel, MS Access etc. using SSIS.
• Successfully extracted data from FTP locations using FTP tasks using SSIS.
• Transformed data using various transformations like Lookup, Derived Columns, Pivot, Unpivot etc. using SSIS.
• Involved in analyzing business requirements and design documents.
• Involved in interacting with business people on daily basis for better understanding and implementation.
• Created reports from data warehouse using SQL Server Reporting Services SSRS .
• Involved in complete software development life cycle SDLC of the project.
• Performed tuning and optimization of complex SQL queries.
• Created SSIS Packages, Jobs and Sending Alerts using SQL Mail.
• Designed data models using Star and snow flake schemas. Resolved complex many - many relationships and referenced relationships between the dimensions and the measures.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.

Environment: MS SQL SERVER 2008R2, MS SQL Server 2008, SSIS, SSRS, Business Intelligence Studio, SQL Profiler, Microsoft Visio, MS Office.

Confidential

Data mining consultant / Sr.SQL Server/SSRS/SSIS Developer

.

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources SQL Server, Flat Files and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Analyzed and built data acquisition mechanism.
• Designed and built data warehousing environment incorporating feeds from eight internal and external data
• sources to support analytical reporting needs for finance, marketing, merchandising, pricing, purchasing,
• operations, accounting using exclusively free, open sources tools the PostgreSQL and Infobright databases, and the Pentaho data analysis suite .
• Reworked the Business intelligence delivery mechanism to use Microsoft SQLServer Business Intelligence
• Edition, which provides OLAP and dashboards via SSAS and Excel, standardized web reporting via SSRS, and uses SSIS for ETL.
• Provided some more sophisticated data analysis on a special project basis e.g., analyzing the effect of the changes in sales tax collection policies in different status, data mining analysis to try to identify customers

who are more likely to become repeat customers .

• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination using SSIS.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for Database and Log Backups Restoration, Backup Strategies and Scheduling Backups.
• Creating Ad Hoc and parameterized various Reports using SQL server 2005 Reporting Services.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL SERVER 2005, MS SQL Server 2008, SSIS, SSRS, Business Intelligence Studio, SQL Profiler, Microsoft Visio, MS Office.

Confidential

SQL Server Developer

Responsibilities:

• Worked in DTS for data flow from one of the source files like Excel, Tables and Views to other databases or files with proper mapping.
• Designed GUI interfaces using various controls provided by ASP.NET environment.
• Integrated SQL traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Configured SQL servers to use more than 2GB Physical memory.
• Used Aggregation Design Wizard to decide best possible aggregation for given amount of disk space.
• Installed and maintained database applications to improve processing performance which includes applying upgrades, patches and bug fixes in all database instances.
• Determined MS SQL Server 2005 Installation options. Installed SQL Server Management Tools using SQL Server Setup program. Tested the installation of SQL Server and implemented different security modes.
• Set up Partitioned Tables and Indexes for Parallel Processing of queries using SQL Server 2005 Partition functions and schemes.
• Used the UDM Model to create Named Queries in the Data Source View.
• Designed relationships between the dimensions and measures. Resolved complex many - many relationships and referenced relationships between the dimensions and the measures.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Implemented a Successful Security plan by creating statement Permissions, linked servers and encryption of connections by creating certificates.
• Involved in Distributed transactions, building Linked Servers, complex queries, error handling using save points in OLTP transactions.
• Fine tuned queries for performance of reports which were being developed in SSRS.
• Wrote Stored Procedures for Reporting purpose. Also developed various reports using SQL Server Reporting Services.
• Creating Distributed Partitioned Views, debugging/troubleshooting Stored Procedures, upgrading existing ones.
• Involved in creating, debugging DTS packages using Active X Task, dynamic properties task to file check, sending mails upon package completion and file archiving.
• Designed DTS packages with DTS Import/Export Wizard for transferring data.
• Data migration Import Export-BCP from text files to SQL Server.

Environment: MS SQL Server 2005 Enterprise Edition, Enterprise manager, MS Analysis services 2005, MS Access 2000 Windows NT platform, Reporting Services, Crystal reports 8.0, DTS, Windows Active Directory.

Confidential

SQL Server Database Administrator/Developer

Responsibilities:

• Installation and configuration of SQL Server 2000 on Window 2000/NT OS.
• Managing of database objects like Tables, views, indexes etc.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Managing Backup and restore, export and import.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Well experienced with tools like Query Analyzer, SQL utility.
• Implementation of data transfer through DTS and setting guidelines to automate recovery scenarios.
• Creation and management of Database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Automation and execution of data transformation scripts.
• Developed Transact-SQL scripts to enforce business rules.

Environment: MS SQL Server 2000, Windows 2003, MS Access, T-SQL, DTS, VB 6.0.