SUMMARY

• 7 years of strong experience in MS SQL Server development, DB Administration, System Analysis, Design, Development & Support of MS SQL Servers in Production and Development.
• Strongly expertise in MS SQL Server with Business Intelligence (BIDS) 2005/2008 in SQL Server Reporting Services SQL Server Integration Services and SQL Server Analysis Services.
• Experienced in defining Data Sources for creating data source views and writing complex stored procedure, SQL in SQL server.
• Strong experience in deploying SQL server Analysis Projects and defining Fact relationships in SSAS using MS SQL Server.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• Expert in creating SQL server Reports using SSRS and knowledge of upgrade from one edition of SQL Server to another edition.
• Expert in ETL, DSS and Data warehousing & OLAP technology and successfully created Fact Tables, Dimensions and joined them to extract meaningful data.
• Transformed data from various data sources like access, excel, flat file using OLE DB connection by creating various DTS packages & SSIS Packages.
• Strong SQL Server Developer skills including writing triggers, stored procedures, views, query writing, defining advanced attribute and dimensions properties.
• Strong Object Oriented Analysis, designing and programming technical skills, ability to learn new emerging technologies and adapt quickly.
• Extensively involved in installation of MS SQL Server, performance analysis, tuning, capacity planning, implementing backup and recovery strategy for application and database.
• Familiar with sizing and systems for specific applications, collecting and analyzing performance data using various tools, establishing baseline performance parameters and implementing tuning and performance improvement measures.

TECHNICAL SKILLS

• Microsoft SQL Server 2000/2005/2008
• XML
• XHTML
• SQL Server Analysis Services 2005/2008
• SQL Server Integrated Service 2005/2008
• MS SQL Reporting Services 2005/2008
• OLAP
• OLTP
• MDX (Multi - Dimensional Expression)
• DTS
• Toad
• Visio

PROFESSIONAL EXPERIENCE

Confidential, NewYork City, NY

MS SQL Server Developer

Responsibilities:

• Involved in designing and maintained complex ETL processes for enterprise Data Warehouse incremental and full loads using SQL Server Integration Services.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Extracted data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL serverusing multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Developed various stored procedures for creating transformations and validation of data coming from external systems like excel, access and flat files and Created a stored procedure to automate the execution of all the stored procedures and to schedule the jobs.
• Worked with data-modeling team and designed dimensions or tables and the requisite relationships to meet business requirements.
• Created SSIS packages for the data cleansing or transfer and transformation and also to clean the incoming data including address and to find out if the address is valid or not.
• Designed and developed Matrix and Tabular reports with Drill Down, Drill Through, Parameterized, Sub Reports and Drop down menu option using SSRS 2005/2008.
• Created reports that included formatting options such as Grouping, Sorting, Parameter prompts and developed reports with Charts and Multiple Datasets using Reporting Services (SSRS).
• Developed SSIS packages not only for Initial Data Loads but also for incremental or delta load and created a Log tables to capture the SSIS events and used it to Perform Debugging of packages.
• Scheduled a SSIS package to run our stored procedures to create the output report tables and regenerate reports automatically
• Performed tasks like Backup, Restore, Data Profiling using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler and SQL Server agent.
• Used Merge Join extensively to load the data from production database to operational database and to perform basic de duplication.

Environment: Windows XP, Toad, MS SQL Server 2005/2008, T-SQL, MS SQL Reporting Services 2005/2008, SQL Server Integrated Services 2005/2008, MS SQL Analysis Services 2005/2008.

Confidential, New York City, NY

MS SQL Server Developer

Responsibilities:

• Installed and Configured SQL Server 2005 enterprise edition per client request and Successfully implemented indexes on tables for optimum performance.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Transformed complex business logic into database design and maintaining it by using SQL objects like stored procedures, functions, views, T-SQL scripting and jobs.
• Developed complex stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting services and using Performance Monitor or Profiler to solve Dead Locks or Long running queries.
• Working Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Good knowledge in normalizing and de-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Maintained the database by monitoring performance integrity and optimize SQL Queries for high performance using SQL Profiler.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split and Successfully managed Extraction, Transformation and Loading (ETL) process by pulling data from various data sources using BCP in staging database from MS Access, Excel.
• Dimensional Data Modeling experience using Data Modeling, Star Schema or Snowflake Modeling, Fact & Dimensions tables.
• Created SSIS package to extract data from MS Excel, Access to SQL 2005 and Creating report model on SSAS cubes as well as changing default configuration on existing cubes.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table 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 service.
• Experienced in developing Ad-Hoc, Drill down, Drill through reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS).
• Worked with OLAP and Data warehouse application and worked with star schema, snowflakes schema dimensions and worked with implementing SSAS, and SSRS to support large Reporting needs.

Environment: MS SQL Server 2000/2005/2008 , SQL Server Analysis Services 2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008, windows 2003, T-SQL, DTS, VB.Net.

Confidential, Simsbury, CT

MS SQL Server Developer

Responsibilities:

• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Developed Cross-Tabbed and Sub-Reports in SSRS and Designed and developed matrix and tabular format drill down, Linked reports with drop down menu option using SSRS.
• Generated the various kinds of reports using Graphs and Images and Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, T-SQL Scripting.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases
• Monitored the performance of Database objects using Performance Monitor that ships with SQL Server and Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports and Prepare the List Report for each customer. Extensive use of T-SQL in DDL and DML commands for various applications.

Environment: MS SQL Server 2005 Enterprise Edition, Visio, DTS, T-SQL, SSRS, SSIS, Windows Server 2003, OLAP, OLTP, MDX, VB.Net.

Confidential, Abingdon, Virginia

MS SQL Server Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database and implemented the calculations to aggregate physical measures using management studio.
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Developed T-SQL (DDL, DML) statements using dynamically generated SQL and defined Referenced relationships with the measure groups and fact tables.
• Designed an OLAP system with the help of SQL Server Integration Services (SSIS) to visualize data structure.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2005.
• Improved query performance by cube partitioning and extensively used SQL Profiler to identify and repair database lockups, deadlocks, and other issues.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSRS.
• Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, DTS, MS Access, MS Excel, T-SQL.

Confidential

MS SQL Server Developer

Responsibilities:

• Performed backup or restore, created database objects such as tables, procedures, triggers, constraints, indexes and views.
• Responsible for developing process, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production and Experienced in performance tuning, query-inventory, analysis and optimization.
• Involved in project planning, scheduling for database module with project managers and Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Worked on analyzing and designing disaster recovery or replication strategies with business managers to meet the business requirements.

Environment: MS SQL Server 2000, MS Access, MS Excel, DTS, Erwin, SQL Query Analyzer.