PROFESSIONAL SUMMARY

• Over 8 years of experience in System Analysis, Design, Development and Support of MS SQL Server 2008/2005/2000 in Production, Test, Development and Replication & Cluster Server Environments.
• Strong experience in MS SQL Server 2008/2005 with Business Intelligence in SQL Server Integrationservices (SSIS), SQL Server Reportingservices(SSRS) andSQL Server Analysisservices (SSAS).
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development LifeCycle).
• Hands on experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2008/2005/2000.
• Good Hands on Database and Data Warehousing concepts (OLTP & OLAP). Involved with logical and physical data modeling and database designusing Erwin, MS Visio.
• Experience with SQL Server and T-SQL in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
• Extensive experience with SQL scripts, Performance tuning and Transactions Analysis.
• Expert in designing SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert etc.
• Experience in data migration using SSIS and DTS services across different databases like Oracle, MS access & flat files.
• Expertise in Report generation using MS SQL Server Reporting Services (SSRS).
• Experience in generatingDrill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Experienced in using global variables, expressions and functions for the reports.
• Hands on experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions in SSAS.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005.
• Experienced in defining Granularity with in a measure group and drill through actions.
• Excellent hands on experience in creating groups and measures, KPIs in SSAS 2005.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
• Highly motivated, committed and a natural team player with capability to work independently, strong analytical ability coupled with excellent written and verbal communication skills.

TECHNICAL SKILLS

• ETL Tools: DTS, SSIS , Informatica 5.1/6.1.4
• Dataware House Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, SSAS, SSIS, SSRS, Data Transformation Services
• Data Modeling Tools: Erwin 5.14,MS Visio 2005
• Databases: MS SQL Server 2008/2005/2000, DB2 UDB, MS Access 2000/7.0, Oracle 9i/10g/11g
• Data migration: DTS, SSIS, BCP, Import/Export Wizard
• Reporting Tools: SSRS 2008/2005/2000, Crystal Reports
• Operating Systems: Windows NT, Windows 2K/2K3/XP/Vista/ 7
• Packages: MS-Office 2007/2003/2000

Confidential, April 2009 - Till Date
SQL Server Developer /SSIS/SSRS/SSAS
Plano, TX

XO Communications is one of the nation’s largest communications service providers focused exclusively on businesses, government, and carrier and wholesale service providers nationwide. It currently has an OLAP systems from where data is pulled from source systems like Ordering, Billing, Trouble ticketing, ISP and generate integrated reports. It also has Front End based Executive dashboard that is extensively used by top management and legal department for any order and billing related count. The project mainly dealt with creating SSIS packages, building cubes on the OLAP systems, generate reports by extracting data from the cube and checking the performance tuning of stored procedures,troubleshooting and maintenance.
Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Interacted with the business people and database administrators to identify the business requirements and data realties.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Used Try catch and @@error for exceptional handling.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Responsible for developing, monitoring and deploying SSIS packages.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Created and tuned Event Handlers, Checkpoints and logging to maintain active SSIS packages.
• Extensively utilized SSIS packages functionality to create complete ETL Process using scripts, stored procedures, functions, transformation of data etc.
• Setup partitions, Usage based Aggregations and automated cube processing tasks via SSIS.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created queries for generating drill down reports in SSRS 2005. Formatted the reports using the Global variables, expressions and Functions.
• Created cubes and dimensions for the analysis of sales in specific areas.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Services (SSAS).
• Processed cube to perform incremental updates.
• Wrote multi dimensional expressions (MDX) to create name sets and calculated members.
• Created reports by extracting data from cube.

Environment: SQL Server 2008/2005, T-SQL, MS Reporting Services, Management Studio 2008/2005, Query Analyzer, Oracle 9i/ 10g.

Confidential, June 2008 – Feb 2009
SQL Server Developer /SSIS/SSRS
Lewisville, TX

One of the largest bank in the financial sector having many branches and services network in the country. The project involved database administrator, supporting OLAP/OLTP production server, development and Export/Import data between servers, Replication, Database Object creations, development and script, programming, quality assurance and Production stages of SQL Server 2005/2000 Installation & Oracle client installation, Configuration and Maintenance.
Responsibilities:

• Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore.
• Create and maintain SQL Server procedures, functions, views and triggers.
• Setup SSIS package configuration, logging for error detection.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Developed, monitored and deployed SSIS packages.
• Developed SSIS solution for developing a fully fledged data warehouse solution.
• Created reports using MS visual studio 2005/2000 and deploy on report server using SSRS.
• Identified the database tables for defining the queries for the reports.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area and Price-Range.
• Identified and defined the Datasets for the report generation.
• Formatted the reports using the Global variables and expressions.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Deployed the generated reports on to the server.
• Fine tuned the database objects and server to ensure efficient data retrieval.

Environment: SQL Server 2005, T-SQL, DB Artisan, MS Reporting Services, Management Studio 2005/2000, Query Analyzer, Windows 2003/2000 Server, Oracle 9i/ 10g.

Confidential Jan 2007 – April 2008
SQL Server Developer/SSIS/SSRS
NYC, NY

Life Insurance is an OLTP systemwhich stores the customer information regarding members and their payments and policies. The repository was running on SQL Server 2005 with a web based Dot Net front-end, Implemented infrastructure to support over 15 database servers consisting of more than 150 databases.

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Alter the schema for the required objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Expert in extracting data using SSIS from OLTP to OLAP.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and optimized all the SSIS packages.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Created Drill Reports which gives all the details as per business requirements which runs on daily basis using SSRS Reporting services.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Designed and implemented stylish report layouts.
• Identified the Data Source and defining them to build the Data Source Views.
• Identified and defined the Datasets for report generation and also included report parameters.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Implemented full and differential backups and alsocreated and managed DB objects.
• Make recommendations for File group Creation and Placement.
• Scheduling backups and automating weekend maintenance tasks.
• Created users and roles for login authentication and validating permissions.
• Designed DDL and DML statements for MS SQL Server 2005/2000.
• Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.
• Upgraded SQL Server 2000 to SQL Server 2005.
• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.

Environment : SQL Server 2005/2000, T-SQL, DB Artisan, MS Reporting Services, Management Studio, Query Analyzer, Windows 2003/2000 Server, Oracle 9i.

Confidential April 2006 – Oct 2006
SQL Server BI Developer
Titusville, NJ

Confidential was formed by the year 1993 merger of Ortho Pharmaceutical Corporation and McNeil Pharmaceuticals. Ortho-McNeil-Janssen Pharmaceuticals, Inc. is a leader in health care, providing innovative products, safe and effective treatments and unsurpassed quality.

Responsibilities:

• Worked with application team to analyze architectural diagram and design disk layout structure to get optimum performance.
• Implemented database mirroring for hot standby disaster recovery solution to keep environment stable.
• Set up and configured Snapshot and Transactional Replication on MS SQL Server 2005/2000.
• Worked on SQL query tuning, execution plan to enhance query performance.
• Setup SQL jobs to rebuild/reorganize index to run periodically based on index fragmentation.
• Design and implementation of Performance Tuning and Maintenance plan for database consistency checks, backup/restore.
• Managed upgradation of DTS packages to SSIS packages.
• Designed DTS package to export data from access data source to SQL Server and vice versa.
• Created and maintained SSIS packages to run jobs and export data in SQL server 2005/2000.
• Used SQL Server Profiler to track database activities to identify conflict between application and database.
• Created reports using MS visual studio 2005 to present data to the management.
• Run various DBCC commands like checkdb/checktable, showcontig, show statistics etc. For checking database/table consistency and system performance.
• Involved with various business groups while developing their applications, assisting in database design.

Environment :SQL Server 2005/2000 Enterprise Edition, SSRS 2005, SSIS 2005, SSAS 2005, MS Visio 2003, Windows 2003/2000 Advance Server, XML, Informatica Power Center 5.1/6.1.4, Oracle 8i, Pl/SQL, MS Excel, MS Access and Visual source safe.

Confidential, Oct 2004– Feb 2006
SQL Server Database Developer
Hyderabad, India

Patient Data Management, it is basically an intranet application. This project manages all the aspects of the data management in a doctor’s office including billing. The objective of this application is to help the company employees to keep track of company database, which included doctors, patient information and customer details throughout intranet.
Responsibilities:

• Developed stored procedures, triggers and functions and added/changed tables for data extraction, transformation and loading.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL.
• Writing database triggers, procedures and packages for applications.
• Involved in creating high level and low level design of the ETL process.
• Handling database objects with Enterprise Manager and Query Analyzer.
• Involved in Informatica Performance tuning of SQL Queries, Sources, Targets and Informatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit intervals.
• Created complex mappings in Informatica Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, and Stored procedure transformations. Developed Object Fields Attributes, Functions, Triggers Using Object Designer.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created reports using SSRS.
• Developed scorecards for the system using SQL Server reporting services(SSRS).
• Used DTS to transfer files from Excel datasheets to SQL server database.
• Took part in data normalization process along with senior data base analyst.
• Creation, manipulation and supporting the SQL Server Database.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stores procedures, checked deadlocks and created scheduled jobs.

Environment: MS SQL Server 2000, MS Access, ANSI SQL, C#.Net, ADO.Net, CSS, Oracle, Windows 2000

Confidential Nov 2002 – Aug 2004 SQL
Server Developer
Hyderabad, India

ICICI InfoTech Services Limited isIT solutions provider by consolidating all IT resources within the ICICI Group. ICICI group also offers a full range of financial services products to serve the needs of small and large corporations, governments, and institutional and individual investors.

Responsibilities:

• Setup new MS SQL Server instances and databases.
• Capacity planning of MS SQL Servers. Implemented and maintained database security.
• Going through the clients\' requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Written many stored procedures and Triggersas per clients requirements.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans, DTS packages and did performance tuning of the existing processes.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000, Transact-SQL, Enterprise Manager, Query Analyzer, Oracle 8i, PL/SQL, MS-ACCESS 2000

EDUCATION:

• Bachelor of Technology in Computer Science and Engineering, Confidential, India. 2002.