PROFESSIONAL SUMMARY

• Around 7 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 BI in SQL Server Integration services (SSIS), SQL Server Reporting services (SSRS) and SQL Server Analysis services (SSAS).
• Hands on experience on implementation of projects with full SDLC (Software Development Life Cycle). High proficiency in understanding relational and dimensional data models.
• Expertise in Requirements Gathering. System/DataAnalysis and documentation (HLD & LLD)
• Highly motivated, committed and a natural team player with capability to work independently, strong analytical ability coupled with excellent written and verbal communication skills.
• Hands on experience in installation and configuration in SQL Server 2008/2005/2000.
• 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.
• Hands on experience 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. Hands on writing SQL scripts, Performance tuning & Transactions Analysis.
• Hands on experience in Report generation using MS SQL Server Reporting Services (SSRS) & develop ad-hoc reports using SQL queries, MS Access and Excel.
• Experience in generating Drill 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, using global variables, expressions, functions and subtotals for the reports. And exposure to Dimensional and ER Modeling.
• 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, Optimization, Performance Tuning, Recovery and scheduling the backups.
• Good exposure to Database and Data Warehousing concepts (OLTP & OLAP). Involved with logical and physical data modeling and database design using Erwin, MS Visio.

TECHNICAL SKILLS

Database Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, SSAS, SSIS, SSRS, Data Transformation Services, DTS, SSIS

Data Modeling Tools: Erwin 5.14,MS Visio 2005

Databases: MS SQL Server 2008/2005/2003/2000, MS Access 2000/7.0, Oracle 8i/10g

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, Unix/Linux

PROFESSIONAL EXPERIENCE

Date Systems Analyst/MS SQL Developer

Confidential, Pennington, NJ

Responsibilities:

• Prepared the Low Level Design Document (LLD) from High Level Design Document (HLD).
• Gathering the requirements, analyzing and Analyze the data and Prepared Data Mapping documentation.
• Interacting with Developers and SME (Subject Matter Experts) about HLD & LLD.
• Interacting with other Teams to gather the requirements.
• Interacted with the business partners and database administrators to identify the business requirements and data realties.
• Analyzed the requirements, Data and prepared the technical design document for the developers.
• Analyzing the code, data and preparing the spec’s for Developers
• Defined Check constraints, Business Rules, Indexes and Views.
• Conducted database management, performance measurement, performance tuning for new and existing databases by using SQL Profiler, Tuning Advisor and index tuning wizard.
• Analyzing the system performance. 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) & developed ad-hoc reports using SAS/SQL queries and MS Access and Excel.
• Created queries for generating drill down reports in SSRS 2005. Formatted the reports using the Global variables, expressions and Functions.
• Implemented OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Services (SSAS) and SAS tool.
• Wrote multi dimensional expressions (MDX) to create name sets and calculated members.
• Created reports by extracting data from cube. Processed cube to perform incremental updates.
• Involved in Requirements Gathering, analysis and documentation.

Environment: MS SQL Server 2008/2005, SAS 9.0, T-SQL, MS Reporting Services, Management Studio 2008/2005, Query Analyzer, Aps.net, C#, Win XP.

Confidential

SQL Server Developer/ Systems Analyst

Responsibilities:

• Interacted with the business people and database administrators to identify the business requirements and data realties. Defined Check constraints, Business Rules, Indexes, and Views.
• Gatheird the Requirements, Analyzed the requirements, and prepared the technical design document for the developers (LLD & HDL).
• Developed complex queries in T-SQL, wrote Stored Procedures, Triggers and Queries with best execution plan. Created cubes and dimensions for the analysis of sales in specific areas.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• 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) & developed ad-hoc reports using SQL queries and MS Access and Excel.
• Created queries for generating drill down reports in SSRS 2005. Formatted the reports using the Global variables, expressions and Functions.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Services (SSAS).
• Wrote multi dimensional expressions (MDX) to create name sets and calculated members.
• Created reports by extracting data from cube. Processed cube to perform incremental updates.

Environment: MS SQL Server (SSAS/SSIS/SSRS) 2008/2005, T-SQL, Management Studio 2008/2005, Query Analyzer, Oracle 8i/ 10g.

SQL Developer /SSIS/SSRS

Confidential

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. Used SSIS Import/Export Wizard, for performing the ETL operations. Identified the database tables for defining the queries for the reports. Developed SSIS solution for developing a fully fledged data warehouse solution.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies. Developed, monitored and deployed SSIS packages.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Created reports using MS visual studio 2005/2000 and deploy on report server using SSRS.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to halp 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 TEMPeffective 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: MS SQL Server 2008/2005, T-SQL, DB Artisan, MS Reporting Services, Management Studio 2005/2000, Query Analyzer, Windows 2003/2000 Server, Oracle 9i/ 10g.

Confidential

SQL Server Developer/SSIS/SSRS

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. Designed and optimized all the SSIS packages.
• 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. Performed Bulk data migration using DTS and SSIS from flat files.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• 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. Designed and implemented stylish report layouts.
• 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.
• 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 also created and managed DB objects.
• Scheduling backups and automating weekend maintenance tasks. Created users and roles for login authentication and validating permissions.
• Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes. Make recommendations for File group Creation and Placement.
• 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

SQL Server /BI Developer

Responsibilities:

• Involved with various business groups while developing their applications, assisting in database design. Worked on SQL query tuning, execution plan to enhance query performance.
• Worked with application team to analyze architectural diagram and design disk layout structure to get optimum performance. Managed upgrading of DTS packages to SSIS packages.
• 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.
• 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. Designed DTS package to export data from/to access data source to SQL Server.
• 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.

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

Confidential, Oct 2005 - Feb 2006

SQL Server Database Developer Hyderabad, India

Responsibilities:

• Developed stored procedures, triggers and functions and added/changed tables for data extraction, transformation and loading. Writing database triggers, procedures and packages for applications. Writing database triggers, procedures and packages for applications.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL.
• Involved in creating high level and low level design of the ETL process.
• 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. Developed Object Fields Attributes, Functions, Triggers Using Object Designer. Handling database objects with Enterprise Manager and Query Analyzer.
• 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 NT/2000

Confidential

SQL Server Developer

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.
• Written many stored procedures and Triggers as 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. Troubleshoot and minimize production down issues.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method. Monitor failed and long running MS SQL Server jobs.
• Data conversions and data loads from various databases and file structures.
• 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