SUMMARY:

Around 8 Years of Extensive experience in Design, Analysis, and Development & Administration of Database systems using MSSQL 2000/2005/2008 /2008R2 for both OLTP (Batch Processing, Online Processing) & Data Warehousing Systems BI applications(SSIS, SSAS, SSRS).

Database Design

• Experienced in OLTP and OLAP design and implementations and in dimensional modeling using Star /Snowflake schemas
• Good understanding of Normalization/De-normalization, Database design, Entity-Relationship (E\\R) model and application oriented design.
• Hands-on experience with Erwin Data modeling tool and Microsoft Visio for designing the logical and physical data models for the data warehousing systems

Development

• Expertise in writing 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, in Microsoft SQL Server2000/2005/2008.
• Experience in optimizing the database and data integrity by creating various Clustered, Non-clustered Indexes.
• Efficient usage of DBCC commands to increase the performance of the query.
• Created recursivequeries using Common Table Expression (CTE) instead of temp tables.
• Created Table- valued parameters (TVP) for passing table as a parameter.
• Experience in Database Backup and planning of Recovery procedures.
• Experienced with working variety of large complex and flat files (advanced excel )
• Experience in Performance Tuning, Query Optimization, and running database consistency checks using DBCC Utilities various tools like SQL Server Profiler, Index Tuning Wizard, Database Engine Tuning Advisor (DTA).
• Experience in Diagnosing, Code Debugging and Troubleshooting performance issues in SQL Server Databases using Dynamic Management Views (DMV).
• Experienced in setting of isolation levels on database level to avoid dirty read, phontom read, nonrepeatable read.
• Efficient in installation and data migration from SQL Server 2005 to SQL Server 2008
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.

Business Intelligence

• Highly experienced in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages using various data transformations such as Multicast, Merge Join, Lookup, Conditional Split, Aggregate, Derived Column etc.
• Experience in Extract, Transform and Load data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS/SSIS, BCP utilities.
• Experience in scheduling job (SQL Agent) and monitoring ETL Processes using DTS Exec utilities and batch files.
• Conversion of DTS packages to SSIS and Interfacing Legacy components within SSIS for complex transformations and logic
• Experience in providing Logging, Error handling by using Custom Logging and Event Handlers for SSIS Packages.
• Designed, Developed and implemented SSAS Cubes using SQL Server Analysis (SSAS)
• Experience in using Multi Dimensional Expressions (MDX) to query the SSAS Cubes, identifying Key Performance Indicators (KPIs), and in creating Dashboards Score Cards.
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Worked on ProClarity Analytics server to analyze results produced in the Dashboard
• Good Experience in Installation, Configuration, Development, Deployment.
• Troubleshoot Reporting services using SSRS2000/2005/2008 across various environments
• Expert in generating drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts using SSRS(SQL Server Reporting Services)
• Created Crystal Reports,MSExcel and experienced in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB, ODBC and SQL client.
• Possessed very good communication and have strong analytical, trouble shooting and problem-solving skills, documenatation skills dedicated to maintain the high quality standards.

EDUCATION:

Bachelor's of Technology

TECHINCAL SKILLS:

• Operating Systems: Windows 98/NT/2000/XP, 2003/2008 Server, UNIX, LINUX
• Databases: MS SQL Server 7.0/2000/2005/2008/2008R2, Oracle 11g/10g,
• Access 97/2000/2003
• SQL Server Tools: Management Studio(SSMS), Business Intelligence Development Studio(BIDS), Import & Export Wizard ,Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard,
• Microsoft SharePoint
• ETL Tools: DTS, SQL Server Integration Services (SSIS), SQL Server
• Analysis Services (SSAS)
• Reporting Tools: SQL Server Reporting Services(SSRS)
• Development Skills: Transact SQL(T-SQL), PL/SQL
• Languages: Visual Basic(VB), HTML, C, XML,C#
• Application Packages: MS Office Suite 2000/2003/2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Plantation, FL March 2011-Present
SQL Server/SSIS/SSAS/SSRS Developer
Alorica is an outsourced contact Management Solutions for both Business-to-Businesses (B2B) and Business-to-customer (B2C) Sectors in the United States. It creates and maintains customer relationships. Data warehouse was built to retrieve customer information of customers .This includes the Alternative Collateral Deals which has data to determine whether a customer is eligible for deals.

Responsibilities:

• Installed and configured MS SQL Server 2008 enterprise edition per client request
• Created database objects like tables, stored procedures, views, functions, and triggers using T- SQL.
• Created the clustered/non-clustered indexes on tables for data integrity, and traced out for any table required any indexes and determine the type of index on it.
• Created triggers to enforce complex business rules and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE and experienced in operating procedures.
• Involved in development and debugging of batch T-SQL Procedures and functions.
• Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files.
• Migrated databases from MS SQL Server 2005 to MS SQL Server 2008.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task, For each container etc and used different data flow tasks in SSIS
• Worked on SSISscript task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Responsible for creating batch files and schedulingthejobs of SQL Server Agent.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Experienced in securitysetting to SSIS packages.
• Developed cubes for reporting based on the business requirements using SSAS 2008.
• Identified KPIs and created different scorecards and dashboards.
• Experienced in writing MDX queries for extracting data from Cubes .
• Worked on creating calculated measures that measures that fits logics using MDX quries.
• Involved in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and developed Cubes using theidentified Fact and dimension tables in SSAS
• Created different types of reports such as Cross-Tab, Drill-down, Summary, Sub reports, Charts and Graphs and formatting them using SSRS2005/2008.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Deployment of SSRS Reports on SharePoint portal and integrating reports, Analysis Reports with SharePoint.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery when ever needed.
• Experienced Connecting of Java applications to standard SQL server database.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Decrypt , Encrypt and FTP of Files using Unix shell scripts
• Involved in Writing documentation to describe program development.logic, coding and corrections.
• Involved in design and development of Data warehouse
• Advanced web application development experience using Silverlight 4.0
• Involved in database designing using Normalization
• Involved in designing the Logical and Physical data models for the data warehouse using Erwin 7.2.
• Studied the existing OLTP system(s) and created facts, dimensions and star schema representation for the data mart.

Environment: MS SQL Server 2008/2005, SSIS 2005/2008, SSRS 2005/2008, SSAS 2005/2008,DTS, T-SQL, OLAP Service, Visual Studio 2005, ASP.NET,Java script, Visual Basic (VB) scripts SQLServer Profiler, Erwin Data Modeller 7.2, Windows Sever 2000/2003/2008, SQL ServerManagement Studio, SQL Server Business Intelligence Development Studio (BIDS).

Confidential, NC Mar'10 - Feb'11
SQL Server/SSIS/SSAS/SSRS Developer
Confidential, is one of the largest financial Services companies in the United States. This project involved developing data warehouse for TIAA-CREF. The system monitors the claims and policy transactions including coverage like theft, collision damage and personal liability. The most and least profitable coverage, profit over time measurement, covered item, country and employees are measured and stored in different fact and dimension tables. Finally various reports are created to understand what happens during the life of a policy, when a claim is processed.

Responsibilities:.

• Upgraded the existing database to SQL Server 2005.
• Experience in designing Database Models using Erwin 7.0.
• Designing and building data load procedures, using MS SQL Server 2005.
• Worked with SSIS to import, export and transform the data between the linked servers.
• Involved in business analysis and technical design sessions with business and technical staff to developEntity Relationship/data models,requirements document, and ETL specifications.
• Created database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL and PL/SQL in Development and Production environment for SQL Server 2005.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Partitioned many tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Developed SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs)
• Generated complex custom Reports using SSRS 2005 as per the customer requirement.
• Created parameterized reports using SSRS
• Migrated DTS objects to SQL Server Integration Services (SSIS) environment by using migrate DTS200 package wizard in BIDS
• Responsible for extracting and transforming data using DTS Import/Export, DTS Packages, MS SQL Server Integration Services (SSIS) Packages, Bulk Insert and Utilities like BCP.
• Extensively used Control & Data Flow Transformations like OleDB command, execute SQL task, sequence generator, send mail task, derived column, conditional split, lookup, multi cast and script component task in SSIS
• Created Cubes using SQL Server Analysis Services (SSAS) according to business requirements.
• Refreshing the cubes to get the latest information and deployment of cubes to the production server.
• Fine tuned SQL queries using hints for maximum efficiency and performance.

Environment: MS SQL Server 2005, SSIS 2005, SSAS 2005, SSRS 2005, DTS, T-SQL, PL-SQL,VSS,Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer,Erwin 7.0

Confidential, Portland, ME Jan'09 - Feb'10
SQL Server/SSIS/SSAS/SSRS Developer
Confidential, is one of the leading banks in the United States for commercial banking, home and auto insurance in the United States. Data warehouse was built to retrieve loan level information of a customer who is a part of countywide home loan services. This includes the Alternative Collateral Deals which has data to determine whether a customer is eligible for a deal by TD bank.

Responsibilities:

• Installed and Configured SQL Server 2005 and Upgraded the existing database to SQL Server 2005.
• Designing and building data load procedures, using MS SQL Server 2005.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created trace files on the queriesand optimized the queries which were running slowly.
• Efficient use of Error Logs, Event Logs, and Configuration manager tools for error handling.
• Partitioned many tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions.
• Efficient use of DBCC utilities to improve the performance of the queries.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source according to the user requirements.
• Generated database SQL scripts and deployed databases, installation and configuration.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Migrated DTS objects to SQL Server Integration Services (SSIS) environment.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Created ETL packages for transforming the excel files into the database using various transformations in SSIS 2005
• Wrote DTSActiveX scripts that extract data from database tables and write the data to text files.
• Generated complex custom Reports using SSRS 2005 as per the customer requirement.
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Deployed the generated reports directly on the client's workstation.
• Created complex Stored Procedures for better performance to generate reports using SSRS

Environment: MS SQL Server 2005, SSIS 2005, SSRS 2005, SQL Server Management Studio, BIDS, DTS, T-SQL, Windows Sever 2003, SQL Profiler, Query Analyzer, Erwin 7.0

Confidential, Chicago,IL Apr'06 - Dec'08
SQL Server/Business Intelligence Developer
Confidential, based in Chicago,IL provides market-leading solutions for the imaging systems, in-patient clinical, Physician office electronic medical records and practice management applications.GE healthcare provides transformations medical technologies and services that are shaping a new age of patient care.

Responsibilities:

• Created Stored Procedures, Triggers, Views and Functions for the application.
• Migrated the legacy Databases in SQL Server 2000 to SQLServer 2005 using SSIS.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries and Stored Procedures.
• Trouble shooting of Reports by cross checking the Report Layouts, Stored Procedures and SSIS Packages.
• Developed several Complex Reports using SQL Server Reporting Services (SSRS).
• Created Ad-hoc Reports, Drill-Down Reports, Pivot and Tabular Reports.
• Upgraded SQL Server 2000 DTS Packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services (SSIS).
• Worked with SQL Server Analysis Services (SSAS) that delivers Online Analytical Processing (OLAP) and data mining functionality for business intelligence applications
• Defined and processed the Facts, Dimensions & cubes using MS OLAP
• Involved in generating Multi-Dimensional Cubes and reports using OLAP Services
• Worked in building Multidimensional Expression (MDX) queries and Data Mining Expression (DMX) queries for Analysis Services.

Environment: SQL Server 2000/2005, SQL Server Reporting services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, .Net, Windows XP/2003 Server.

Confidential, Hyderabad, India Mar '05 - Feb' 06
SQL Server Developer/Jr. DBA
Confidential, one of the biggest telecommunication companies in India, provides not only wireless and wire communication but also broadband internet access service as well, serving millions of customers nationwide. In this project responsibilities as a developer involved in designing database and developing packages for extraction/loading

Responsibilities:

• Coded the SQL Server Stored procedures for the enhancements. Unit, System, Integration and Regression testing of the procedures.
• Tuning and optimization of the stored procedures.
• Enhancement involved implementation of SQL Server with the usage of Stored Procedures, SQL Execution Statistics / Plans, Optimizer and SQL Profiler for back end.
• Planning & organizing the work structure, configuration, risk and delivery management.
• Administered various applications like Maintenance Management and Financial Account System.
• Maintained the client\'s policies and Customer Databases and tuning of the database instances.
• Worked with all database objects, including tables, clusters, indexes, views, and procedures.
• Troubleshoot problems concerned with the Databases, Applications, and Development tools.
• Created new databases for users as required. Checking the alert logs daily for oracle errors.
• Tuning of I/O to reduce disk contention by distributing I/O.
• Creating and maintaining roles and profiles for security and limited access of data. Design and implementation of Backup & Recovery strategies..
• Creation of logins and user ids and setting up privileges and procedures for protection of data.
• Designed screens and reports layout.

Environment: Windows 2000, SQL Server 2000, VB Script, IIS, HTML, CSS, MS Visio.

Confidential, Hyderabad, India May' 04 - Jan' 05
SQL Server Developer/Jr. DBA

Responsibilities:

• Assisted in database design, creation of ER diagrams, phasing from development to QA and to production environment
• Creation of user databases and installation of MS SQL SERVER 2000/7.0.
• Worked in Project planning, Designing & Implementation.
• Involved in creating Stored Procedures, triggers, cursors, tables, view and other SQL joins and statements for applications.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration. Data transfers between various servers using BCP.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Resolving various performance issues and running DBCC commands, SQL trace SQL profiler and NT monitoring tools.
• Using data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.
• Installing SQL SERVER service packs based on the errors and flaws that are found in application.
• Testing the stored procedures performance and its path of execution by using SQL profiler.
• Recovering the backups of SQL SERVER production databases in test server environment

Environment: MS SQL Server 2000/7.0, Windows 2000 Advanced Server, T- SQL, VB 6.0, XML, and Erwin 3.5