SUMMARY:

• Microsoft certified Technology Specialist with over 7yrs of IT experience that includes System Analysis and Design, Development & Support of MS-SQL 2000/2005/2008R2.
• Extensive experience and detailed knowledge of Telecom, Insurance, Financial, Computing, Banking and Mortgage.
• Experienced in working with Oracle - PL/SQL programming and SQL * Plus.
• Extensive knowledge in maintenance and optimization of Database and Server using various SQL tools (SQL Profiler, Indexes, Statistics, File Groups, DBCC).
• Extensive experience in Database design and development of applications using SQL Server 2000/2005/2008R2, Integration Services (SSIS), Reporting Services (SSRS), SQL Server Analysis Services (SSAS),MDX queries, OLAP Cubes, Star schema and Snowflake schema.
• Strong experience with Teradata SQL Assistant 7.1.
• Excellent understanding of full Software Development Life Cycle (SDLC).
• Performed SQL Development & Troubleshooting that included File Groups, ODBC, Indexes, Stored Procedures, Triggers and table structures for application behavior manipulation.
• Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries.
• Hands on experience in creating reports using Crystal Reports.
• Strong experience in defining Referenced relationships inSSAS.
• Extensive experience in writing queries by using Joins, Indexes, Views, Stored Procedures and Triggers.
• Used tools such as Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Knowledge in Job Scheduling, Replication, Performance Tuning, Normalization/De-normalization concepts, database design methodology.
• Expert in generating formatted SQL server Reports and skilled in handling sub reports in SSRS 2005/2008.
• Ability to work independently with a high degree of personal initiative.
• Effectively maintained positive and productive working relationships in internal/external and team environments.

CERTIFICATIONS:

• 70-431 Microsoft SQL Server 2005 – Implementation and Maintenance.

TECHNICAL SKILLS

Languages: T-SQL, SQL, PL/SQL, Dynamic SQL, MDX, C, C# (.NET), ASP.NET, VB.NET, XML RDBMS:SQL Server 2008R2/2005/2000, Oracle10g/9i, Teradata. 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 Operating Systems:Windows 7/Vista/XP/2003/2008 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 Packages: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. Version Control and Configurations:Visual SourceSafe 6.0/2005, Visual Studio Team Foundation Server (VSTS), Remedy Change Management

PROFESSIONAL EXPERIENCE:

Confidential, Grapevine, TX Nov 2009 – Present 
SQL/BI Developer 
Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Supported Users for various Reporting and Analytics requirements across multiple Business Units and departments.
• Designed and developed enterprise reports (SSRS) using the data from Teradata, SSAS Cubes and various heterogeneous data sources.
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions in SQL Server 2005.
• Created Tables, Macros in Teradata SQL Assistant 7.1 and generating the sample reports using Excel 2007.
• Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Flat Files, Excel and other OLEDB, ODBC data sources.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services (SSIS).
• Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent on a weekly basis.
• Experience in configuring package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Developed many MDX queries for creating calculated measures that fits business logic.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2005) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting services.
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005.
• Created official Templates, Mailing Subscriptions and created shared data sources that can be used across different processes.
• Complete administration of SSAS Cubes which involved creating logins, maintaining item level security, managing roles and granting permissions.
• Involved in Database Administration activities like Back Up, Security etc.

Environment:
SQL Server 2005, Visual Studio 2005, Reporting Services (SSRS 2005), Integration Services (SSIS 2005), MS Office 2007, Lotus Notes, SQL Server Analysis Services (SSAS 2005), ETL, MDX, Visual Source Safe (VSS), Teradata SQL Assistant 7.1, SQL Server Profiler. 

Confidential, Secaucus, NJ Apr 2008 – Oct 2009
MS SQL Server Developer/SSIS/SSRS 
Responsibilities:

• Creating tables, relationships, triggers and indexes for enforcing business rules.
• Importing and Exporting Excel records to SQL server database.
• Designing and implementing Stored Procedures, Views, Indexes (Clustered and Non-Clustered), Functions and Triggers for automating tasks.
• Writing distributed queries for Linked Servers.
• Designing and building data load procedures, using MS SQL Server.
• Installing/administrating SQL Server Reporting Services (SSRS), creating schedule reports and delivering via email.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Developing Queries for generating drill down reports in SSRS 2005.
• Identifying and working with Parameters for parameterized reports in SSRS 2005.
• Deploying generated reports on to the server.
• Designing and implementing ETL processes to make data available for reporting purpose within a data warehouse.
• Developing, monitoring and deploying SSIS packages.
• Identifying the data source and the data source views.
• Creating Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers, Parameterized Stored Procedures, Constraints and Roles.
• Experience in making elegant report layouts.
• Developing Sub Reports, Matrix Reports, Charts, Drill-down reports using SSRS.
• Created basic reports using Crystal Report Writer.
• To mentor the development team and using SQL Statements to present Query responses.
• Developing SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008.
• Creating interface stored procedures used in SSIS to load/transform data to the database.
• Responsible for deploying the generated reports directly on clients work stations.
• Transforming data from various data sources using OLE DB connection by creating various DTS packages.
• Reconciling data for transformation from SQL 2005 to SQL 2008 using SSIS.
• Managing and coordinating a team of various technical resources.

Environment: 
SQL Server 2005/2008, T-SQL, Data Transformation Services (DTS), Reporting Services (SSRS), Integration Services (SSIS), SQL Profiler, Crystal Reports, Windows 2000/XP

Confidential, Long Beach, CA Sep 2007 – Mar 2008 
SSAS/MS SQL Server Developer/DBA
Responsibilities:

• Created SQL server Analysis Projects using MS SQL Server 2005.
• Designed/ developed SSAS (OLAP) MDX developing components.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Deployed/Designed cubes in SSAS environment.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes usingMDX.
• Built cube (business requirements including KPI’s were already declared before development) and mentored internals on procedures.
• Identified and defined Fact relationships in SSAS.
• Worked with QA team on fixing data quality or process bugs.
• Developed procedures and functions for business & data transactions with Error Handling.
• Tuned SQL statements (Using Indexes) and Stored Procedures.
• Used Query Analyzer to optimize SQL Queries.
• Converted various SQL statements into stored procedures thereby reducing the number of database accesses (since Stored Procedures passes the whole block at one time).
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION Operator and using the TOP operator to limit the Select Statement in certain Queries.
• Developed Stored Procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data into fact tables.
• Optimized queries tuned and monitored server performance using SQL Profiler.
• Worked closely with the developers, end users and the administrator in designing and creating the database.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Fine tuned database objects and server to ensure efficient data retrieval.
• Successfully loaded data from Excel, Access and Flat Files (.txt) into a SQL Server database Table.
• Wrote procedures to prepare databases for replication.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.

Environment: 
SQL Server 2005, Query Analyzer, Enterprise Manager, SSIS, DTS Designer, SQL Profiler, Index Tuning Wizard, T-SQL, Analysis Services (SSAS), ASP.NET, XML, Windows OS.

Confidential, Portsmouth, New Hampshire Dec 2006 – Aug 2007
SQL Server Developer/SSIS
Responsibilities:

• Wrote various stored procedures for the purpose of application development.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS process design and architected the flow of data from various sources to target.
• 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.
• Used multiple join statements to retrieve data from multiple tables.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Continuously interacted with users to gather business requirements.
• Wrote parameterized queries for generating reports in SSRS 2005.
• Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Successfully migrated a huge amount of data from heterogeneous source using BCP and Dynamic DTS Packages.
• Done research and suggested new methods to further enhance performance, compatibility.
• Developed third party reporting components for the storage, retrieval and querying of a database across multiple servers. Also served as the administrator of SQL client/server for applications.

Environment:
SQL Server 2000/2005, T-SQL, Data Transformation Services (DTS), Reporting Services (SSRS), Integration Services (SSIS), BCP, SQL Profiler, SQL Developer, Unix, Windows XP.

Confidential, New York, NYMar 2006 – Sep 2006
SSRS/SQL Server Developer
Responsibilities:

• Responsible for creating the reports based on the requirements using SSRS 2005.
• Identified the database tables for defining the queries for the reports.
• Identified and included report parameters.
• Deployed generated reports on to the server.
• Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore and Indexes.
• Conducted performance monitoring and measurement including Tuning and executed DBCC Commands, Sizing Procedure cache, Sizing Data cache, configured locks and Transaction Isolation levels andIndex Management.
• Wrote (T-SQL) and fine-tuned complex stored procedures. Strategically designed and implemented data warehouses, data marts and data stores, while ensuring high levels of data availability.
• Designed and developed data warehouse data stores, and analyzed business requirements, developed target-source data mappings and delivered ETL processes for end-user OLAP and reporting initiatives (Used report services as an OLAP client schedule reporting tool).
• Migrated Microsoft Analysis Services to SQL Server Analysis Services (SSAS) (BI Microsoft Visual Studio 2005).
• Responsible for analyzing and fine-tuning slow running queries and stored procedures.
• Support and maintenance of existing code and analyzing the impact of changes in scripts and data model.
• Analyzed database performance utilizing SQL Server Profiler and performed maintenance related enhancements to database objects using T-SQL.
• Experience in migration of Data from Excel, Flat file Oracle to MS SQL Server by using DTS utility. Extracting, Transforming and loading of data using SQL Server DTS.

Environment:
SQL Server 2000/2005, T-SQL, Data Transformation Services (DTS), Query Analyzer, Enterprise Manager, SSIS, DTS Designer, SSRS, SQL Profiler, Index Tuning Wizard, Analysis Services (SSAS), Oracle 9i.

ConfidentialAug 2004 – Feb 2006
SQL Server Developer
Responsibilities:

• Created tables, triggers and indexes for enforcing business rules.
• Wrote Complex Stored Procedures as well as analyzed and debugged existing complex stored procedures.
• Migrated SQL Server 2000 Database objects to SQL Server 2005.
• Built and managed sophisticated BI solutions.
• Built a unified data warehouse for storage and access of data across the enterprise.
• Increased the reach of business intelligence solution to empower all service providers by creating a secure web based solution.
• Consolidated business view across claims, premiums, providers and products.
• Improved customer and regulatory reporting through integrated customer and external agency data.
• Gathered data from the source systems and transformed and loaded into data staging area.
• Unified data warehouse for data storage and access.
• Query Management, Standard Reporting and Activity Monitor.
• Reviewed existing stored procedures and optimized code.
• Optimized all web site databases, which resulted in substantial performance gains. Optimizations included table redesign, indexing, query rewrites, and stored procedure rewrites. Used Quest–Spotlight, SQL Profiler to identify bottlenecks.

Environment: 
SQL Server 2000/2005, Quest–Spotlight, SQL Profiler, Query Analyzer, T-SQL, Windows 2000/XP

Educational Qualification:

• Bachelor of Technology (B.Tech.)