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 the 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 the 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.
• Have Clear understanding on Data Warehousing Concepts with 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 with 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 with users to gather requirements, analyze them, and subsequently use design tools to model the 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 with developers, project managers and application end-users.
• Creative and aggressive self-starter with 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 with the business analysts in gathering the 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 then 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 the content of Report, according to user specifications using SSRS.
• Involved in creating SSAS cubes through Business Intelligence Development Studio (BIDS) and deploying the cubes to the server and processing the OLAP cubes to generate aggregate data for faster querying.
• Hosted SSRS Reports on SharePoint Server using web parts.
• Deployed the SSRS Reports to various environments like SIT, UAT and PROD Environments using Report Manager and Dashboard Designer.
• Extensively used Excel Pivot reports by querying the MS Analysis services Database and MS SQL Server Database
• Extensively worked on designing Forms and Reports for users to enter the data through Performance Point Excel 2007 input templates.
• Involved in creating MDX and SQL Rules through PPS Business Modeler for calculating the data on the forms and writing the data to the 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 the production support.
• Worked with Performance Point Business Modeler in order to load the dimensions and hierarchies.
• Developed various test cases for Unit testing the Data before releasing to Testing environment.
• Coordinated with 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 with Confidential Visual Studio Team Explorer to create Sprint Backlog Item bugs, Impediments and Items.
• Involved in preparing the deployment guides and guiding the deployment process on SIT, UAT & PROD Environments for various releases of the applications.
• Monitoring and troubleshooting the jobs that are running, scheduled, completed and failed. Troubleshooting the failed jobs.

Confidential, Redmond, WA

MS SQL Server Developer

Responsibilities:

• Worked closely with the business users in gathering the requirements
• Worked in an Onsite - Offshore model, leading the offshore team for requirements communication and review the code and delivering to End users.
• Involved in documenting the requirements and Change Requests.
• Used Common Table Expressions (CTE) to retrieve the data from various hierarchy tables.
• Involved in writing SQL queries to retrieve the result sets and transforming the 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 the Business Rhythm on to Share point location.
• Supported the users in serving the Change requests and answering all the 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 the requirements.
• Scheduled the 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 the data from flat files and load it into sql tables.
• Used script tasks and conditional splits when loading the data.
• Created SSIS packages to compare the data between source system and target systems slicing by different dimensionality and sending the notification with data discrepancies.
• Created shared dimension tables, measures, hierarchies, levels, cubes, aggregations, KPIs on MS OLAP/ Analysis Server (SSAS).
• Automated the data validation process by developing different SSRS Reports which compares and shows the Data discrepancies.
• Effectively 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 with the 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 the users in answering the data related queries and business related questions.
• Involved taking Back up of SQL Server Databases and SSAS Databases
• Involved in monitoring the Log spaces and clearing the Transactional logs.
• Worked with Team Foundation Server’s Source Control Explorer to Apply labels to Changesets. Create folders, Manage the data, Lock and Unlock folders and files, View historical data.

Confidential, Dallas, TX

MS SQL Server Developer

Responsibilities:

• Implemented New Objects according to the Business requirements.
• Created and Modified Stored Procedures, According to the business rules.
• Worked with Control Flow tasks, Data flow tasks and Data flow transformations using SSIS 2005.
• Created efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Transformations of data such as adding derived column, count of records, merging of data has been done while pulling data from Source to the Target.
• Used script tasks and conditional splits when loading the data and handled dirty data.
• Used fuzzy lookups/lookups for loading the data based on the requirement and grouping the data.
• Involved in creating the reports through SSRS according to the requirement.
• Fine Tuning of Stored Procedures and SQL Queries.
• Developed various reports to validate the data between source and the target systems.
• Involved in providing security to the 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 the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• 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 the 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 the Stored procedures, Triggers, and Views for managing efficient data retrieval.
• Written T-SQL statements using DML and DDL for retrieval of the 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 the performance of database servers.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Designed, Developed and managed the 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 the application.
• Developed complex TSQL code for the 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 the batch data cleansing and data loading).
• Manage and monitor the system utilization.
• Manage the backup and recovery of the team.