SUMMARY

• Over 8 years of strong experience in the IT industry as a MS SQL Server Developer
• Excellent experience in MS SQL Server 2005/2008 with Business Intelligence in MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS).
• Expert in developing T - SQL (DDL, DML) statements using dynamically generated SQL.
• Efficient in Database up gradation and migration from MS SQL Server 2000 to MS SQL Server 2005/2008
• Expert in designing high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS utility
• Extensive experience in designing OLAP cubes with the help of SSAS
• Proficient in manually transferring DTS packages to SSIS packages using SSIS 2005
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools
• Extensive knowledge in design of logical and physical data modeling using Erwin tool
• Versatile in writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS 2005
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user defined functions, user profiles, relational database models and data integrity, SQL joins and query writing
• Expert in preparing ETLmappingprocess and maintaining mapping documents
• Expert in Data Integrity constraints, Performance Tuning, Repairing dead locks, Query Optimization and Validation issues
• Experienced in manual, automation, integration and performance testing
• Experience in working on administration tasks such as data loading, batch jobs, data unloading, user and application table management, upgrades, creating databases/ file groups/ files/ transaction logs
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication
• Team player and self-starter with excellent Communication skills

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL,.Net(C#,VB)

SQL Server Tools: BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , MS Access

ETL Tools: DTS, SSIS, BCP, Import/Export Wizard, BI Studio

OLAP Tools: SSAS, MS Excel

Reporting Tools: SSRS, MS Excel

Business Tools: Word, Excel, PowerPoint, Access, Outlook

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Senior MS SQL/SSIS/SSRS Developer

Responsibilities:

• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008
• Installed SQL Server 2008 and Management tools using SQL Server Setup Program
• Wrote T-SQL queries, Store Procedures and used them to build packages
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on SQL Server 2005
• Extracted the data from Oracle, Flat Files, transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005)
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, and Access to SQL Server
• Developed SQL scripts for pre-calculated aggregates, summaries, and user specific calculations
• Handled slowly changing dimensions to maintain the history of the data
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
• Designed, reviewed and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS 2005
• Developed Ad hoc request/reports for the clients as per their requirements using SSRS
• Created views and used them for generating Reports
• Developed Variance reports using Reporting Services (SSRS)
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation
• Involved in User Acceptance Testing, debugging of the system and taking data objects across different data stages namely Development, Test and Production
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.

Environment: MS SQL Server 2005/2008, SSRS 2005/2008, SSIS 2005/2008, SSAS 2005/2008, SSMS, Crystal reports XI, T-SQL, PL/SQL, Oracle 10g, Access and Excel.

Confidential, ROCKY HILL, CT

Sr.MS SQL/SSRS Developer/SSIS Developer

Responsibilities:

• Gathered Requirements from the users and checked the structure of the schema and data with the Data Modular
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models
• Designed and developed DTS packages to move data from production environment to different environments within the organization
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages and dashboards using SharePoint server 2003
• Migrated database from SQL server 2000 to SQL server 2005 using Bridging Scripts, Column
• Mapping Tool and Source Control Explorer in Visual Source Safe (VSS)
• Used ADO.NET objects such as data reader, data adapter and dataset to fetch and handle user data with stored procedures from SQL Server 2008
• Involved in the development of web pages with ASP.NET, AJAX control as per CSS with C# as back-end coding language
• Experienced in writing SSIS script tasks, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Extensively used SSIS for transferring data manually from DTS packages to SSIS packages using SSIS 2005
• Generated reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2005
• Identified the database tables for defining the queries and defined datasets for report generation
• Defined report layouts including report parameters and wrote queries for drill down reports as per client’s requirements using SSRS 2005
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005
• Generated daily, weekly and monthly reports for the managers
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005
• Tested the reports and fixed bugs in the CLR integrated C# stored procedures
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler
• Established backup and recovery of SQL reporting services

Environment: MS SQL Server 2005, SSRS 2005, SSIS 2005, T-SQL, C#, .NET, Visual Basic 6.0, ASP, DTS, Performance Point, Data Analyzer, Visual Studio 2005, VB Script, MS Access, Excel, SQL Profiler, Windows XP, Erwin 4.2.

Confidential, Omaha NE

Sr MS SQL/SSAS/SSIS/SSRS Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database
• Updated functional specification and technical design documents
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications
• Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL
• Designed an OLAP with the help of ERWIN to visualize data structure
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2005
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS
• Developed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2005
• Generated reports using SSRS 2005 as per business requirements
• Developed measures and dimension members using multidimensional expression (MDX) to meet additional needs that were calculated from existing measures
• Developed MDX expressions for cube calculations and KPIs
• Implemented the calculations to aggregate physical measures using management studio
• Identified and defined the scoped assignments using script commands
• Defined Referenced relationships with the measure groups and fact tables
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Established a sound backup and recovery policies and procedures

Environment: MS SQL Server 2005 Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, DTS, T-SQL, VB Script, Windows Server 2003, Erwin 4.0.

Confidential

MS SQL Server Developer

Responsibilities:

• Created Logical and Physical data models using Erwin data modeling tool
• Developed complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications
• Designed and implemented stored procedures and triggers for automating tasks
• Re-designed and enhanced an automated response Multi-User Access 2000 database for the Data Warehouse Team
• Tested the reports and fixed bugs in Stored Procedures, Tables and Triggers
• Schedules and performed data transfers using DTS including filtering appropriate to the data mart for data analysis
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes
• Compressed data files by removing empty database pages and updating index statistics
• Configured snapshot replication for reporting, user acceptance test and development servers
• Developed and edited many complex reports with Crystal Reports 9.0
• Designed and implemented user log in and security
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries
• Planned the complete back up of databases for disaster recovery scenarios

Environment: MS SQL Server 2000 Enterprise Edition, MS Access, DTS, T-SQL, AS 400, Query Analyzer, BCP, SQL Profiler, Windows 2000 Server, ASP .Net, Erwin 4.0, Crystal Reports 9.0.

Confidential

SQL Developer

Responsibilities:

• Designed DTS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000 environment, and deploy the data
• Scheduled the jobs to do these tasks periodically
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports
• Made sure that standards and best practices in database development were followed and maintained
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency checks and index defragmentation
• Set up database backup and recovery strategies
• Maintained all records of project status and followed changes as per control procedures
• Provided technical support to internal developers and external clients
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, PDAs and window messengers
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2000 Enterprise, Windows Enterprise Server 2000, .NET 2002, Microsoft Visual Studio 6.0/7.0, T-SQL, SSIS Packages, ETL, Schema Design / Erwin 4.0, UDM, User Notification Services developing database backup/recovery procedures, providing technical support