SUMMARY

• Around 7 years of Strong experience in SQL Server Development and DBA, TSQL coding, Performance and Tuning, Physical and logical Database Designs.
• Extensive experience in database activities like data modeling, database design, development, database creation and maintenance.
• Extensive experience in using Confidential BI studio (SSAS,SSIS,SSRS) 2008 and 2005 for implementation of ETL methodology in data extraction, transformation and loading.
• Strong SQL Server T - SQL programming for writing stored procedures, user-defined functions, Triggers, Cursors, Views.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS to import and export teh data.
• Expertise in transforming data from various data sources using OLE DB / MS Access connection by creating various DTS packages.
• Expertise in creating multidimensional cubes, processing and deploying through Analysis Services (SSAS) 2005 for teh data warehouse.
• Expert in creating, designing, managing SQL server Reports using SSRS 2005.
• Worked on major application development using Oracle 9i including PL/SQL, stored procedures, database triggers, transaction processing.
• Has Clear understanding on Data Warehousing Concepts wif emphasis on ETL, Experienced in designing FACT & Dimensions Tables, Physical and Logical Data Models using ERWIN Tool.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Solid hands on experience wif Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Good SQL Server administration skills including user authorizations, Database creation, Tables, and indexes.
• Excellent skills in database backup and recovery.
• Highly experienced in all aspects of SDLC such as requirement analysis, design, development, testing, implementation, deployment, & maintenance of Projects.
• Highly proficient in working wif users to gather requirements, analyze them, and subsequently use design tools to model teh requirements.
• Ability to handle multiple tasks and capable of handling responsibilities independently as well as a proactive team member.
• Excellent Communication and inter personal Skills when working wif developers, project managers and application end-users.
• Creative and aggressive self-starter wif integrative thinking skills, capable of forming and maintaining positive and productive working.

TECHNICAL SKILLS

RDBMS: SQL Server 2008/2005/2000/7 , Oracle10g/9i, DB2 8.0/7.2, Sybase, Confidential Access 2000/2007/2010 , Confidential Excel 2000/2007/2010 , MySQL.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Business Intelligence Development studio

Application Servers: MS Office Performance Point Server 2007, MS Office Share Point Server 2007, Oracle Application Server, Team Foundation Server(TFS).

ETL Tools: SQL Server Analysis Services 2005, SQL Server Integration Services 2005, Import Export Data, DTS, BCP, Data stage 7.5

Reporting Tools: SQL Server Reporting Service 2005, Dashboard Designer, Confidential Excel 2010 Reporting and Pivoting

Data Modeling: ER-Win 4.0, Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling.

Programming Languages & Technologies: C, C++,.NET,T-SQL,SQL,PL/SQL, Java 1.5/ 1.4, JavaScript 1.4, XML, XSL, Shell Scripts, HTMLOperating Systems Windows 98/2000/XP/NT, UNIX and Linux.

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

MS SQL Server Developer

Responsibilities:

• Worked closely wif teh business analysts in gathering teh requirement and analysis.
• T-SQL programming for writing stored procedures, user-defined functions, Triggers, Cursors, Views.
• Responsible for Migrating data from, Oracle and third party sources (MS Access 2007 and flat files) and tan importing into database through SSIS-data flows and control flows packages
• Created various complex reports like Form, Tabular, Drill Down, Drill Thru, and chart reports using group, filter and format teh content of Report, according to user specifications using SSRS.
• Involved in creating SSAS cubes through Business Intelligence Development Studio (BIDS) and deploying teh cubes to teh server and processing teh OLAP cubes to generate aggregate data for faster querying.
• Hosted SSRS Reports on SharePoint Server using web parts.
• Deployed teh SSRS Reports to various environments like SIT, UAT and PROD Environments using Report Manager and Dashboard Designer.
• Extensively used Excel Pivot reports by querying teh MS Analysis services Database and MS SQL Server Database
• Extensively worked on designing Forms and Reports for users to enter teh data through Performance Point Excel 2007 input templates.
• Involved in creating MDX and SQL Rules through PPS Business Modeler for calculating teh data on teh forms and writing teh data to teh fact table.
• Involved in writing MDX queries in MS Excel 2007 in order to build Excel based scorecards.
• Involved in working on High Priority Change Requests (CRs) during teh production support.
• Worked wif Performance Point Business Modeler in order to load teh dimensions and hierarchies.
• Developed various test cases for Unit testing teh Data before releasing to Testing environment.
• Coordinated wif QA team in reviewing their test cases and end-to-end testing.
• Resolved high priority bugs and various sprint blog items logged in VSTF on adhoc basis.
• Involved in working wif Confidential Visual Studio Team Explorer to create Sprint Backlog Item bugs, Impediments and Items.
• Involved in preparing teh deployment guides and guiding teh deployment process on SIT, UAT & PROD Environments for various releases of teh applications.
• Monitoring and troubleshooting teh jobs that are running, scheduled, completed and failed. Troubleshooting teh failed jobs.

Confidential, Redmond, WA

MS SQL Server Developer

Responsibilities:

• Worked closely wif teh business users in gathering teh requirements
• Worked in an Onsite - Offshore model, leading teh offshore team for requirements communication and review teh code and delivering to End users.
• Involved in documenting teh requirements and Change Requests.
• Used Common Table Expressions (CTE) to retrieve teh data from various hierarchy tables.
• Involved in writing SQL queries to retrieve teh result sets and transforming teh results into Reports.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to SQL Server data warehouse Staging tables and to fact tables and deployed packages to different environments(DEV, QA, UAT and PROD).
• Extensively used Confidential Excel to produce reports based on SQL server Analysis server and SQL Server Database Server.
• Involved in developing reports using SQL Server Reporting services.
• Involved in maintaining teh Business Rhythm on to Share point location.
• Supported teh users in serving teh Change requests and answering all teh Business queries.

Confidential, Redmond, WA

MS SQL Server Developer/DBA

Responsibilities:

• Created Technical design document, Development plan, Test plan and Final implementation plan for various applications.
• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.
• Created Complex Stored Procedures, User Defined Functions (UDFs), Triggers, Views using T-SQL according to teh requirements.
• Scheduled teh stored procedures through jobs to run on weekly or daily basis.
• Developed Test cases for logging bugs using VSTF.
• Created complex SSIS packages to extract teh data from flat files and load it into sql tables.
• Used script tasks and conditional splits when loading teh data.
• Created SSIS packages to compare teh data between source system and target systems slicing by different dimensionality and sending teh notification wif data discrepancies.
• Created shared dimension tables, measures, hierarchies, levels, cubes, aggregations, KPIs on MS OLAP/ Analysis Server (SSAS).
• Automated teh data validation process by developing different SSRS Reports which compares and shows teh Data discrepancies.
• TEMPEffectively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.
• Worked in an onsite offshore model, providing Knowledge transfer to offshore team and co-coordinating wif teh offshore team for all deliverables.
• Developed ETL Technical specifications.
• Involved in 24 X 7 ETL production support to support different applications through Service desk ticketing system.
• Helped teh users in answering teh data related queries and business related questions.
• Involved taking Back up of SQL Server Databases and SSAS Databases
• Involved in monitoring teh Log spaces and clearing teh Transactional logs.
• Worked wif Team Foundation Server’s Source Control Explorer to Apply labels to Changesets. Create folders, Manage teh data, Lock and Unlock folders and files, View historical data.

Confidential, Dallas, TX

MS SQL Server Developer

Responsibilities:

• Implemented New Objects according to teh Business requirements.
• Created and Modified Stored Procedures, According to teh business rules.
• Worked wif Control Flow tasks, Data flow tasks and Data flow transformations using SSIS 2005.
• Created efficient SSIS packages for processing fact and dimension tables wif complex transforms.
• Transformations of data such as adding derived column, count of records, merging of data TEMPhas been done while pulling data from Source to teh Target.
• Used script tasks and conditional splits when loading teh data and handled dirty data.
• Used fuzzy lookups/lookups for loading teh data based on teh requirement and grouping teh data.
• Involved in creating teh reports through SSRS according to teh requirement.
• Fine Tuning of Stored Procedures and SQL Queries.
• Developed various reports to validate teh data between source and teh target systems.
• Involved in providing security to teh reports by restricting various users through Roles.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.

Confidential, Akron, OH

MS SQL Server Developer

Responsibilities:

• Extensive use of TSQL to manipulate and architect to produce results for users.
• Use of multiple join statements to retrieve data from multiple several tables.
• Created stored procedures, views, triggers, user defined functions to in corporate teh flow of business and called various stored procedures from DTS to make teh flow of DTS TEMPeffective.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Construction of Cubes based on data volumes mostly adhering to Star Schema.
• Efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Confidential, Cincinnati, OH

MS SQL Server Developer

Responsibilities:

• Involved in Developing teh Stored procedures, Triggers, and Views for managing efficient data retrieval.
• Written T-SQL statements using DML and DDL for retrieval of teh data.
• Data Import/Export through DTS.
• Creating database, tables, indexes, and rules.
• Configured data mapping between different Databases.
• Query optimization using SQL Profiler and performance monitors to enhance teh performance of database servers.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Designed, Developed and managed teh reports using SQL Server Reporting Services.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Created Replication models like Snapshot and Transactional.
• Created and scheduled various SQL Jobs using SQL Server Agent to perform various Administrative skills.

Confidential

MS SQL Server Developer

Responsibilities:

• Worked as a database developer on databases like MS SQL Server 2000, MS Access (using DTS, T-SQL, stored procedures and views).
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for teh application.
• Developed complex TSQL code for teh application.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Linked Servers and Indexes.
• Design and implementation of stored procedures and triggers for automating tasks.
• Worked on complex data loading (implemented teh batch data cleansing and data loading).
• Manage and monitor teh system utilization.
• Manage teh backup and recovery of teh team.