SUMMARY:

• Having 7+ years of IT Experience in Confidential SQL Server 2005/2008/2008 R2/2012/2014, T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS), MS-Access, Excel and VBA in database and applications development and report design and development.
• Expert in   SQL   Server Import/Export wizard to migrate the Heterogeneous databases such as Oracle and MS Access database, flat files to   SQL   server 2005.
• Also worked with SQL Server 2014 new features.
• Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) and T-SQL.
• Experience in developing and deploying reports and creating ad-hoc reports by using Excel and Report Builder in MS SQL Server Reporting Services (SSRS) 2012/2008R 2/2008/2005.
• Experience in creating and deploying SSIS Packages on high-activity, normalized transaction systems (OLTP), highly-usable denormalized reporting systems (OLAP) as well as staging areas and data marts.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.
• Migrated DTS packages to SSIS and modified using DTS editor wizard.
• Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Experienced in using tools like Bulk Copy Program (BCP), Bulk Insert, Data Transformation Services (DTS) and SSIS with MS SQL Server.
• Experience in creating and deploying SSIS Packages on high-activity, normalized transaction systems (OLTP), highly-usable denormalized reporting systems (OLAP) as well as staging areas and data marts
• With Error Handing from development server to production server, migrating DTS Packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008, and using SSIS Import/Export Wizard for performing the ETL operations.
• Strong Expertise in building the OLAP cubes with SSAS.
• Developed interactive reports using SQL Server Reporting Services.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.
• Worked extensively in Query Optimization and Performance Tuning using tools SQL   Profiler, Index Tuning Wizard and database Engine Tuning Advisor.
• Exceptional T- SQL   scripting for creating various database objects like Stored Procedures, Functions, Triggers and Views.
• Develop and Maintenance Web application, Custom Application, Windows Service and Web Service in .NET environment.
• Excellent   Communication ,   Analyticalskills   and   Interpersonalskills . Exceptional ability to learn new concepts. Skilled at accessing client needs, working in a group, suggesting ideas that enhance Efficiency and Maximize Performance, Implementing Cutting-edge Technology Solutions and Training/Supporting end   users.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), Crystal Reports, Cognos.

Databases: SQL SERVER, MYSQL, Oracle and DB2, SQL Server 2014/2012/2008 R2/2005/2000

Languages: C, C++, T-SQL, .Net, C#, Java, Java Script, CSS.

Development skills: T-SQL,SSIS/SSRS/SSAS, PLSQL

Operating Systems: Windows NT, Windows 2008,2003, XP, UNIX, Windows 7, LINUX.

Technologies: .NET, ASP.NET, SQL, JAVA.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

SQL   Server   Developer/DBA

Responsibilities:

• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Handling Live site issue and monitoring night jobs.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev., UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Installed and maintained SQL Server database systems by ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Involved in migrating from SQL Server 2005 to 2008 R2.
• Updated database systems by reviewing, planning, testing and installing database security patches and service packs.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET and C#. 
• Responsible for Developing GUI Screens using ASP.Net and C# 
• Designed, documented, and promoted security "best practices", policies, standards and protocols
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Worked with T-SQL to create Tables, Views, and triggers and complex stored Procedures
• Used Script task for Data Flow and Error Handling in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Involved in scheduled reports on a weekly basis that was generated every Friday containing the details of weekly sales for our location for assessing the business for that week.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.

Environment: MS   SQL   Server 2008,/2012/2014 SSIS, SSAS,C#, ASP.net, SSRS 2008 / 2012, T- SQL , Visual Studio 2008/2012, MS Office 2007/2003,   SQL   Profiler, Windows 7, Erwin 7,TFS,Bugger.

Confidential, Bronx, NY

SQL Server Developer/DBA

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis
• Identified the data source and defined them to build the data source views.
• Involved in extracting the data from OLTP to OLAP using SSIS.
• Review developer SQL code to ensure adherence to client standards and general best coding practices.
• SQL Server 2005/2008 Database Administration.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Involved in the migration of SQL Server 2005 databases to SQL Server 2008R2.
• Involved in trouble shooting and fine-tuning of databases for performance and concurrency.
• Established Maintenance Plans for Regular Backups and Index rebuilding.
• Expertised in Tuning Slow running queries using Profiler and Statistics IO by using different approaches like evaluating joins, indexes, updating Statistics and code modifications.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS. 
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Built Reports in SSRS for errors generated in SSIS Packages.
• Used SQL Server Agent to automate the SSIS 2012/2008r2 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access and SQL Server using SSIS 2012/2008r2 and then created reports using this data using SSRS.
• Tested and managed the SSIS 2012 packages and was responsible for its security.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2012/2008r2.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Designed stylish Report Layouts and Deployed the Reports using SSRS 2012/2008r2.
• Wrote Complex Stored Procedures, Triggers, Views and Queries.
• Created indexes, Constraints and rules on database objects.

Environment: MS SQL Server 2012/2008r2, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, Erwin, MS Excel, MS word, Visual Studio 2008.

Confidential, Edison, NJ

SQL Server Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in daily loads (Full & Incremental) into Staging areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Developed a High level dashboard using SSRS 2008 R2.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008 R2.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.

Environment: SQL Server 2008R2/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), XML, MS Visual Source Safe and Windows Server 2003.

Confidential, NJ

SQL Developer

Responsibilities:

• Created SQL Server Reports using SSRS 2008 and Dashboard report using PPS.
• Identified the data source and defined them to build the Data Source Views.
• Developed query for generating drill down reports in SSRS.
• Designed and implemented stylish report layouts.
• Generated reports using global variables, expressions and functions for the reports.
• Identified and worked with parameters for parameterized reports in SSRS.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Responsible for transferring the data using SSIS packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications and implemented different types of constraints on tables.
• Managed index, statistics and optimized queries by using execution plan for tuning the database.
• Improve performance in inserting and then fetching the data from database objects by using partitions function and schema in database objects.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler and monitored scheduled jobs and alerts.
• Optimized the performance of TSQL queries and work in job scheduling and alerts.
• Analyzed and designed disaster recovery and replication strategies based on business requirements.
• Created Reports for Company budget like ledger report, transaction summery listing, made receipt & payment report.
• Involved generating reports like profit & loss statement and balance sheet statement for client.
• Identified and defined Key Performance Indicators (KPIs) in SSAS.
• Created complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Extensively involved in the SSAS storage and partitions, Aggregations, calculation of queries with MDX, Data Mining Models and developing reports using MDX and SQL in SSAS.

Environment: MS SQL Server, T-SQL, SSRS, SSIS, SSAS, Confidential Office Excel

Confidential

SQL Developer

Responsibilities:

• Created Indexes to get the high level performance.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSIS.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2000/2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Confidential SQL Reporting Services 2005 (SSRS), Windows 2000/XP, Oracle.