SUMMARY:

• 8+ years of experience in IT industry as a SQL Server Developer in database designing and developing jobs in Microsoft SQL Server 2005/2000/7.0/6.5/2008/2008 R2, BIDS (Business Intelligence Development Studio).
• Good understanding of Star Schema and Snow flake schema (SSAS)
• Design and develop database using SQL SERVER 2000/2005/2008/2008/2010/2012/2014 R2.
• Extensive experience in Change management and Capacity planning.
• Experienced in Normalization and demoralization of the Database Schema.
• Good Experience in Data Modeling using Erwin and Visio.
• Involved in all phases of System Development Life Cycle (SDLC), and gathering business requirements for new applications using Agile development methodologies.
• Experienced in creating advanced T - sql queries using DDL, DML, and Indexes, Views, Cursors, Triggers.
• Hands on experience in creating ETL (Extract, Translate and Load ) packages using SQL Server 2005 Integration Services (SSIS), DTS and also experience UNIX scripting.
• Import & Export of various data formats using DTS, BCP, Bulk Insert and SQL 2005 Integration Services.
• Experience in Installing, configuring and maintaining SSRS server.
• Experienced in developing reports, canned Reports & Ad-Hoc Reports in SSRS.
• Experienced in creating Reports like Chart, List and Matrix, and Chart and Sub Reports- SSRS.
• Hands on experience in working with Azure Data warehouse.
• Updating the instance counts in the production for the services in the Production Azure Subscription.
• Experienced in i mporting data and build stored procedures on SQL Azure.
• Helped in Building DataSync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure.
• Experienced in BI/Reporting/ETL: Crystal Reports, Excel, PowerPivot, Power BI.
• Extensive Experience in Migrating SQL 2000 databases to SQL 2005/2008/2010.
• Experience with monitoring, troubleshooting/tuning the performance of queries, stored procedures, triggers, cursors.
• Experience in Analysis Services (SSAS) for designing cubes (multidimensional cubes) and dimensions.
• Performed OLTP data marts and OLAP data analysis (MDX scripts, KPI) using SSAS cubes.
• Experienced in executing scripts launching SSAS processes and submitting Data mining queries
• Good Knowledge on Microsoft Office Share point Server, Microsoft Office Suit.
• Experienced with different source control, TFS(Team Foundation) and SVN(Subversion).
• Worked on Performance point server for creating scoreboards and reports analyzing the performance.
• Experience in Database Backup, Recovery and setting up high availability solutions (replication, log shipping, mirroring).
• Preparing Project Documents, Installation Documents and User Manuals.
• Strong written, presentation and verbal communication skills for the management, development and control of documentation.
• Effective interpersonal, conflict resolution skills. Ability to work independently and as part of a team.

TECHNICAL SKILLS:

Database: MS SQL SERVER 7.0/2005/2008/2008//2010/2012/2014/2016 R2, ORACLE 8/8i, MS Access, Sybase, Teradata, DimensionalModeling, Azure.

Database Tools: Enterprise manager, server management Studio, BI developmentStudio, Configuration Manager, Surface Area Configuration, QueryAnalyzer, SQL Profiler, SQL Server Agent, Database Tuning Advisor

Operating Systems: Windows NT (4.0)/2000, Windows 2000 Server, Windows2000/2003Advanced Server

Languages: Transact SQL, PL/SQL, C, C++, C# and java, dot Net COBOL, XMLand HTML

Web Tools: JAVA, ASP, Java Script and VB Script, IIS

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

SQL Server Developer Data/System Analyst

Responsibilities:

• Analyze and document existing system architecture and code.
• Interact with business and prioritize the requirements along with Analyzing the Report Requirements from the users.
• Map existing functionality to the new system.
• Prepare CDM, LDM, STM Documents and created Technical Specification Documents and incorporated them into a holistic business process review
• Weekly status reporting.
• Keep track of open tasks, follow up with the respective owners and drive to completions.
• Do the risks and issues tracking and management.
• Interact with the client in understanding design level issues and resolve; Work hands-on to develop the assigned functionality along with project teams ensuring best practices are followed to ensure high quality code delivered on time.
• Provide support for resolving issues/queries/dependencies with other teams and stakeholders /take part in the status review meetings and any other project related meetings.
• Design and develop Reporting Services packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Onsite-Offshore Co-ordination for all the team deliverable's.
• Frequent sync up with Microsoft leads to ensure the health of the project and address any open questions/issues/concerns.
• Led the development of stored procedures and complex queries, sub-queries and joins as per the business requirements.
• Drive UAT and Manage the UAT issues being reported.

SQL Server Developer

Responsibilities:

• Gathered and Analyzed Report Requirements from the users and created Technical Specification Documents.
• Onsite-Offshore Co-ordination for all the team deliverables.
• Participate in the effort to perform functional decomposition and overall effort estimation in collaboration with the team
• Develop schedules and integrate into the overall release plan, ensure all activities are covered, dependencies are identified and mapped and a realistic release plan is developed.
• Interact with the client in understanding design level issues and resolve; Work hands-on to develop the assigned functionality along with project teams ensuring best practices are followed to ensure high quality code delivered on time.
• Guide the project team in defect fixing.
• Wrote stored procedures and complex queries, sub-queries and joins as per the business requirements.
• Worked on SSIS and ETL data transfer.
• Used table control, matrix control for cross tab reports. Built and deployed Reports in Report Manager.
• Build DataSync job on Azure to synchronize data from SQL 2012 databases to SQL Azure.
• Worked on creating Cache Memory on Windows Azure to improve the performance of data transfer between SQL Azure and WCF services.
• Created SSAS Cubes and wrote various MDX queries.
• Participated in BI Technical meetings, weekly standup meetings and code review meetings.
• Increased the performance of the reports by tuning the performance of the queries.
• Formatted the reports using Global variables, custom formats and expressions.
• Wrote and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Used CTE’s and many other features in SQL Server to optimize the stored procedures.
• Automated reports using TIDAL Enterprise Scheduler.

Environment:Visual Studio 2012/ 2010R2, SQL Server 2014/2012/R2, SQL Server Reporting Services 2014/2012R2, SQL Server Analysis Services 2014/2012/R2, SSIS, TFS.

SQL Server Developer

Responsibilities:

• Involved in Designing Logical and Physical Database Designing using ERWIN Tool.
• Design/develop data modeling and dimensional modeling of the database using SQL SERVER 2012/2010
• Responsible for creating Databases, Tables, Indexes, Unique/Check Constraints, Views, Stored Procedures, User defined functions, Triggers, Rules and Defaults.
• Created packages in DTS and SSIS, for data conversion using various transformation tasks
• Transformed data from various data sources using OLE DB connection; also scheduled automated tasks.
• Designed high level ETL (Extract, Translate and Load) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Migrated Sql server 2000 DTS packages to SQL Server 2010 SSIS packages.
• Creating complex T-SQL stored Procedures, Functions, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Worked on XML parameters for inserting data into tables using FOR XML, OPEN XML.
• Monitored and modified Performance using execution plans and Index tuning.
• Optimized database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Developed custom crystal reports, ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, Drill Down, Parameterized, cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Worked on performance point server for analyzing the performance of the organization. Developed Unit test cases, perform Unit testing and also resolved issues.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files and Oracle databases.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data base backups, restoring.
• Migrated various SSRS reports, Stored Procedures from Development Server to Production Server using change control.

Environment: SQL Server 2012/2010, SSIS, SSRS, TSQL, DTS, C#.Net, VB.Net, ASP.Net, ADO.Net, Erwin, UNIX, TOAD, Excel, Access, Java, XML.

SQL Server Developer

Responsibilities:

• Involved in upgrading from SQL Server 2000 to SQL Server 2005
• Actively involved in the complete software development life cycle for a design of database for new Financial Accounting System.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Created Crystal reports and various reports using SQL Server 2005 Reporting Services.
• Created store procedures, configuration files, tables, views, and functions, XML data type, triggers and implemented best practices to maintain optimal performance.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Performed data transfers using BCP and BULK INSERT utilities.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Designed and developed SSIS packages for loading data ETL (Extract, Translate and Load ) from Oracle, text files, CSV files to SQL Server databases.
• Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Crystal Reports, Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Built effective queries for high-performance reporting and rendered them to HTML, Adobe life cycle, XML, PDF, PHP, and Excel formats using SSRS 2005.
• Data Warehouse - Designed cubes, dimensions with star schema using SQL Server Analysis Services (SSAS), ETL (Extract, Translate and Load ).
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Performed Full and Differential backup with simple and bulk-logged recovery models.
• Performed Unit testing and also resolved issues.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Defined Check constraints, rules, indexes and views based on the business requirements. Documented all the procedures involved in the database for future reference.
• Managed the historical data in the Data Warehouse from various data sources.

Environment: SQL Server 2005, SQL Server 2000, SQL Server Enterprise Manager, SQL Profiler,, Net, SSIS, SSRS, SSAS, Monitor, VBA, MS Excel, Access, DTS, UNIX and Visual Source Safe, Java XML.

SQL Server Developer

Responsibilities:

• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Created Crystal reports and various reports using SQL Server 2005 Reporting Services.
• Converted logical database design into Physical Schema using either 2nd or 3rd Normalization to obtain highest performance.
• Successfully implemented the physical design of the new designed database into MSSQL Server 2005.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Efficient Stored Procedures and effective functions were written to handle major business crucial calculations.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries and Stored Procedures.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Generating SSRS (SQL Server Reporting Services) reports at the end of each job
• Designed the reports using SQL Server Reporting Services.
• Created Linked Server for load balancing and increasing performance of the Data warehouse.
• Created necessary triggers on tables to ensure data and referential integrity incorporating business logic. Also worked on ETL (Extract, Translate and Load).
• Created OLAP cubes (Multidimensional cubes) and Dimensions and tables using SSAS.
• Implemented Snapshot and Transactional Replication models and Validation of Replicated data.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.

Environment: SQL Server 2005, SQL Server 2000, SQL Server Enterprise Manager, SQL Profiler, Erwin, MS Excel, Access, SSIS, SSRS, SSAS, .Net, VBA, Crystal Reports DTS, UNIX, Java, XML, VSS, Windows 2003/2000/NT/XP.