SUMMARY

• Almost 8 years of IT industry experience with Microsoft SQL Server 2000/ 2005/2008/2008 R2/2012, SSIS/SSRS/SSAS, and OLAP as SQL Developer.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive working experience in:
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Writing Complex Transact SQL (T - SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Programming in SQL Server .net- Stored Procedures, Triggers, User-defined Functions and Views, Cursors
• Performance tuning of Stored Procedures and T-SQL Queries
• Implementing SQL Server Indexing and Query optimization using Indexes
• Logical & Physical Data modeling, data architecture designs etc.
• Understanding existing data models, data flows and data dictionaries
• Creating new data models, data flows and data dictionaries
• Normalization and De-Normalization techniques
• Involved in Backing up databases and refreshing Data across environments
• Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Creating data load and Upgrade scripts for data migrations, data formatting and data validations implementing all high availability techniques like clustering, log shipping, replication
• Very Good Understanding and Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in Data Modeling, Normalization and building Referential Integrity Constraints, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2005/2008/2008 R2/2012 for both OLTP & Business Intelligence applications.
• ETL implementation using SQL Server Integration Services (SSIS).
• Experience working on Data Aggregation and Storage design of cubes in SSAS.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• Created Scorecard/Dashboard pages in Performance point server (PPS)
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Defined group level security standards for Tableau.
• Used Tableau to visually analyze data and create consise and actionable dashboards
• Generated reports from Analysis Services cube by using ProClarity tool.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box. Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, C#, ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server Denali,2012,2008R2,2008,2005,2000, Oracle 9i/10g (SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot. Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Raritan, NJ

SQL Developer

Responsibilities:

• Involved in beginning of the project, updated existing database from Oracle Servers to SQL server 2008. Managed database security policy login using Windows and SQL server authentication mode.
• Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
• Involved and supported users with ITSM incidents and Change issues.
• Resolved issues on Concur Travel and expenses configuration issues, configured Audit rules and Cognos reports.
• Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
• Involved in the Service Now implementation project.
• Configured and scheduled Kronos accrual jobs. Given support to End users for Vacation and accrual issues.
• Created job codes for roles in Kronos for all level of employees.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import / export data feeds to / from OLAP data warehouse and claim system.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Replicate data from acceptance to QA and production phase.
• Automated Maintenance Routines to complete monthly data updates and special maintenance activities for the OLAP data warehouse.
• Installed, configured, operated and troubleshot Web SharePoint Portal Services. Created and maintained websites using Windows SharePoint Team Services.
• Generated reports by using SSRS and provided them on web server Report manager.
• Worked with importing flat files and XML files, Share Point, fetched data from other data source like PL SQL, MySQL, and ETL (Extract, Transform and Load) to the database.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Checked database upgrade advisor for compatibility check for databases before updates. Performed in place and side by side migration of existing SQL server 2005 user’s client critical databases. Also changed configuration of databases like increased physical memory, and enabled text indexes. Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. exp/imp and attach/detach for SQL servers 2008 features.
• Created, altered, maintained system roles and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
• Created maintenance plans for database Full, Differential and Transactional backup. Also schedule for rebuild indexes, update statistic and check integrity. Performed restore operation and Point in Time recovery for mission critical databases.
• Configured database log shipping and mirroring to maintain, prevent from the disaster recovery and managed ASCO’s standards. Configured and managed primary- standby nodes for High availability of database for users and manage organization standards.
• Identified long running queries using Desk Board report. Generated XML plan for T-SQL performance. Resolved blocked and locked objects issues. Created new Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Migrated databases among the servers using BCP, attach/detach utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, ETL related operations.
• Enabled email notification, linked servers, certificates, symmetric keys for advance database use.
• Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.
• Worked with importing flat files and XML files, fetched data from other data source like MS Access, DB2, MySQL, Oracle and ETL (Extract, Transform and Load) to the database using SSIS. Created UNIX shell script to move file across the servers and automation of daily tasks.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2008 R2, IIS, Sybase, SharePoint, Clustering, SSIS, SSRS, T- SQL, Visual Basics, Visual Studio 2008, Indexes, Cluster, .Net Framework 3.5, snapshot, Replication, MS Office suite 2011, Cognos 10.

Confidential - Auburn Hills, MI

MSBI Developer / SQL SSIS SSRS SSAS

Responsibilities:

• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SSIS, SSRS, MS SQL Server 2012/2008, C#, Visual studio 2008, MS Access, MS Excel, MS Office Access 2007.

Confidential

SQL Server Developer

Responsibilities:

• Involved in new databases design and creation using Rational Rose.
• Created Database Diagrams using third party tool ER - Win in beginning of the project. Identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
• Worked on creation and improving the stored procedures and triggers performance.
• Implementation of Microsoft Office SharePoint Server 2007 Beta for corporate intranet, document management, collaboration.
• Experienced in Design of OLAP Data warehouse using Star Schema and Snow Flakes Schema.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions.
• Created Database Diagrams using third party tool ER-Win in beginning of the project. Defined relationship between tables and enforced the referential integrity constraints.
• Responsible for Query Performance tuning and Optimization.
• Created views, SQL joins DTS packages and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Generated T-SQL code for creating cursor and handling the data validations.
• Created SQL server Analysis Projects using MS SQL Server 2005.
• ETL packages are created to extract, transform and load data to data ware house using SSIS.
• Using SSIS the data is transferred to and from flat files, MS Excel, MS Access and SQL Server 2005. .
• Implemented the calculations to aggregate physical measures using management studio.
• Involved in creation of Multi - Dimensional Cubes and Relational Cubes.
• Used BCP techniques, Stored Procedures, Triggers, Cursors and Transaction management, T-SQL to convert data from various sources to MS SQL 6.5/7.0 databases.
• Developed and maintained MS Access database.
• Supported development of a speciation control documents for an MS Access Project Management Database.

Environment: MS Office suite 2000, MS-SQL Server Management Studio 2000/2005, T-SQL, DTS, Replication, Rational Rose, Windows 9x/Windows NT, MS SQL Reporting Services 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005, MS Access, Erwin, SQL Query Analyzer.

Confidential

SQL Server Developer

Responsibilities:

• Installation and configuration of SQL Server 2005 on Window XP.
• Managing of database objects like Tables, views, indexes etc.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Well experienced with tools like Query Analyzer, SQL utility.
• Implementation of data transfer through DTS and setting guidelines to automate recovery scenarios.
• Creation and management of Database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T - SQL and slow running queries.
• Automation and execution of data transformation scripts.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Optimized SQL queries for improved performance and availability.
• Designed, analyzed and upgraded databases.
• Developed Transact-SQL scripts to enforce business rules.

Environment: MS SQL Server 2005, Windows 2000, MS Access, T-SQL, DTS, VB 6.0.

Confidential

SQL Server Developer

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices,
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to back up the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: SQL Server 2005, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, IIS 6, Visual Source Safe 2003, Crystal Report 10, Crystal Enterprise 10, Microsoft Visio 2000