PROFESSIONAL SUMMARY

• 8 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
• Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 7.0/2000/2005/2008/R2
• Created, modified, maintained and optimizedSQL server database, Responsible for the management of the database performance, backup, replication, capacity and security
• Configuring Log Shipping, and supported failover/failback to/from DR environment. Configuring SQL MAIL and Automating SQL MAIL notification
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups
• Expertise inT - SQL queries,Normalization, indexed views, complex stored procedures, effective triggers, cursors and functions to facilitate efficient data manipulation and consistent data storage.
• Strong technical knowledge in MS SQL Server development including DTS, MS Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BIsuite, Reporting and Analytics. SQLServer 2000/2005/2008 RDBMS database development including T-SQL programming.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions; Thorough understanding of Kimball’s’ theory, KPIs, SQL 2005 Architecture.
• Experience in SQL Server DTS and SSIS package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture,Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects, Understanding the OLAP processing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Worked in creating star, Data modeling and snowflake schemas in SSAS. Also used tools like Erwin.

TECHNICAL SKILLS

Languages: Visual Basic,C#,VB.net, C,T-SQL,PL/SQL

RDBMS: MS SQL Server 2008, 2005, 2000, MS-Access,DB2,Sybase

ETL/BI Tools: Import/Export wizard, SSIS 2005,2008, DTS, SSAS, Pro Clarity, SSRS, PPS, Hyperion

Reporting Tools: SSRS, Crystal Reports, Excel Spread SheetBIDS,SQL Server Management studio, DB2, Aqua Data, AQT

Data Modeling&Version Control Tools: Microsoft Office, Microsoft Visio, Erwin, Adobe Photoshop, Visual Source Safe, PVCS, Rational Clear case

Scheduling Tools: SQL Server Agent, Autosys, Maestro

Operating Systems: Windows NT 2000 Server/ Server/ Server 2003/server 2008/Professional/ 4.0, Win XP Prof/Standard, Win 98, HP Unix 10.x

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Senior SQL Server/BI Developer

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Performance tuning, and optimization of procedures and queries.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Transformed data from different data sources like Oracle, Flat files, SQL data bases to SQL Server 2008 using OLEDB connection providers by creating various SSIS packages. Data transformed from hub (ODS) to data warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for residential, business, large business users.
• Created SQL server Analysis Projects andcreated multi-dimensional databases and OLAP cubesand dimensions for the analysis of capacity planning task in specific areas for departmental manager using SSAS.
• Created jobs to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQLServer Agent job.
• Migrated the data from the appropriate databases to end database and maintained batch log files. Involved in the usage of variables to make the packages dynamic and scheduling the package in SSIS (sequential scheduling).
• Implemented AD HOC reporting with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Generating Drill- through, Drill down, Matrix, Snapshot reports using the data from the Data warehouse using SSRS with Microsoft Share Point Integration 2007.
• Involved in identifying and creating data sources and data source views in SSAS. Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.
• Implemented the elements of T-SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like Retailers Debit, Credit etc.
• Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.
• Created Batch scripts, FTP scripts for file downloads. Worked with heterogeneous data like Mainframe files, XML, Flat/Fixed width files, Excel, CSV, SQL, DB2 and MS Access.

Environment: MSSQL Server 2008, SSIS, SSRS with Microsoft Share point Integration 2007, SSAS 2008, Windows XP.

Confidential, Oakbrook, IL

SQL Server Developer/ DBA

Responsibilities:

• Installation and configuration of MS SQL Server 2008 R2 on New Production and Test Servers with latest Security updates involving Service Packs and Security patches
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disasterrecovery scenarios
• Creation of schema objects, granting roles and privileges to the users, compilation of procedures etc.
• Responsible for Database and Log Backups&Restoration, Backup Strategies and Scheduling Backups, database performance, replication, capacity and security
• Worked in Configuring, Maintaining and TroubleshootingReplication
• Refreshed databases whenever necessary, worked in SQL ServerPerformance Tuning and Query Optimization
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures
• Monitored performance and optimizedSQL queries for maximum efficiency, worked with SQL Server 2005 Service Broker Applications
• Implementing Log Shipping and DataBaseMirroring. Monitoring with SQL Profiler to capture and save data about the event to a file or table to analyze later
• Worked in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server, involved in Performance Tuning of Code using execution plan and addedIndexes to improve performance on tables
• Installing and configuring MS SQL Server 2008/2005(Personal, Standard and Developer Editions)
• Apply Service Packs for SQLServerdatabase. Creation of new database, starting from scratches i.e. deciding the location of data files and logfiles on the disks. Reorganization of existing databases to standardize the placement of various databases related files
• Developed, monitored and deployedSSIS packages
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services
• Experience in MS SQL Server CLUSTERING. experience in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server

Environment:MS SQL Server 2008/2005 Enterprise Edition, MS SQL Server Reporting Services 2005, Windows Server 2003, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Data Transformation Services (DTS).

Confidential, Omaha, NE

SQL Server / BI Developer

Responsibilities:

• Creating high level design of the ETL process to Load data from Text or Excel Files
• Creating three step ETL process to get the files from the server and load the data into database.
• Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Monitoring SQL jobs, Performance bottlenecks, configuring databases, backup/restore DBs.
• Implemented different types of Replication Models like Snapshot, Merge and Transactional using SQL SERVER 2008.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Designing of SSIS Packages to get data files fromFTPandSFTPServer and decrypting thePGPfiles,batch processingof incoming data and purging of old files
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Generated periodic reports based on the statistical analysis of the data, developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and created cubes in SSAS; Deployed and processed SSAS cube weekly to update information by using SQLServer Agent.
• Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.

Environment: SQLServer 2008, Oracle, MS Access, Excel, IIS, Visual Source Safe, Share point Server, Cold Fusion, Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML Parsing, VB6, VB Script, Java Script and C#, SSAS, SSRS, SSIS, MDX Cubes.

Confidential, Houston, TX

SQL Server Developer/ SSIS, SSRS Developer

Responsibilities:

• Enhanced the application functionality to implement the new hierarchical changes requested by the business users.
• Designed, developed and debugged Stored Procedures, User Defined Functions, and Views.
• Designed, created, configured, scheduled SSIS Packages from different sources like Flat Files,Dat Files, CSV Files and Excel Files in different environments.
• Worked on the Data warehouse module of the project MS SQL Server 2005/2000.
• Actively involved in designing and developing the data migration modules (delta, cws) that migrates data using SSIS packages containing tasks and transformations.
• Analyzed and designed the ScriptComponents in SSIS Packages using VB.NET.
• Designed and implemented a Promotion Process to deploy the SSISPackages, Configuration Files on to different environments.
• Designed and implemented error handling at different levels using Stored Procedures, SQL Queries, SSIS Packages, etc to feed the downstream systems.
• Deployed and scheduled jobs using SQL server agent to get done all daily, weekly, monthly and quarterly task.
• Coordinating with front-end .NET team and Share Point team to fix the user reported issues.
• Creating Reports with MS Reporting Services 2005.
• Developed Report Models as per the requirements and generated Ad hoc Reports using SQL Server Reporting Services (SSRS).
• Generated Drill Through, Drill Down,and Ad hoc Reports.

Technologies: SQL Server 2000/2005, COGNOS, .NET, SHAREPOINT

Confidential, Roseland, NJ

SQL Server Developer/SQL DBA

Responsibilities:

• Using performance tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Upgrade/Migrate strategies from earlier/legacy version to MS SQL Server 2005/2008 using suitable methods
• Install and configure SQL Server 2008 in Windows Server 2008 Clustered environment
• Implement Recovery and Backup Strategy, Log Shipping, Database Mirroring and snapshot for Disaster Recovery and reporting purpose.
• Planning for and carrying out installation and upgrade of SQL Servers.
• Performance Tuning of SQL 7.0 / 2000 Servers.
• Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
• Created Linked Servers between SQL Server 2000 & Oracle 9i. Also created DTS package for data transfer between the two environments.
• Successfully implemented physical database on MS SQL Server 2000. Supported complex relationship using triggers.
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
• Created audit trails of activities on database using triggers on backend.
• Implemented the business logic and processing of the payment by developing stored procedures and scripts.
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.

Environment:MS SQL Server2000/ 2005,T-SQL, Visual Basic 6.0, Windows 2003/2000 Server,NT and SQL LiteSpeed

Confidential, Malvern, PA

SQL Server/ BI Developer

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference. Involved in installation and configuration of MS SQL Server 2005/2008.
• Involved in designing database using Erwin 7.2 data modeler tool. Involved in migratingdata from MS SQL server 2000/2005 database to MS SQL server 2005/2008 database.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages. Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Developed unit test plans for SSIS packages. Modified the existing SSIS packages to meet the changes specified by the users. Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Designed, developed and deployed reports in MS SQL server environment, Generated Sub-reports, Drill down, Drill through and Parameterized reports using SSRS 20005/2008.
• Involved in the development and designing of XML, HTML using cascading style sheets for displaying the reports on the report server. Configured the report viewing security for various users at various levels using report manager.
• Fine-tuned SQL queries for maximum efficiency and performance. Provided documentation for all kinds of reports and SSIS packages. Designed and implemented stored procedures and triggers for automating tasks.

Environment:MS SQL Server 2008/2005/2000, SSRS, SSAS, SSIS,T-SQL, MS Visio 2003, Windows 2003/2000 Advanced Server, Erwin data modular, C#.Net 2005.

Confidential, Dublin, OH

SQL Server Developer

Responsibilities:

• Involved in creating database objects, complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins.
• Transferred Flat Files from the old system to the staging area by using BCP and then to SQL Server 2005.
• Extensively worked with FTP (file transfer protocol) for transmitting and receiving file from vendors and clients.
• Created logical and physical database design, data structures, and implemented databases using Erwin.
• Created Stored Procedures, User Defined Functions and improved efficiency by critically evaluating the code and optimized the slow running queries
• Worked on MS SQL Server tasks such as data loading, batch jobs, DTS, and Indexes
• Created DTSPackage to import and export data from SQL Server to Text and Excel files.
• De-normalized some tables that used lots of computations and joins thus improving the performance,Documentation of the entire system flow and guidance points for using the application

Technologies: SQL Server 2000, Query Analyzer, DTS,HTML,T-SQL, UNIX shell scripting, Sybase, Erwin, Windows 2000