SUMMARY

• Expertise in SQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS)with good noledge on SQL Server Analysis Services(SSAS).
• More than 9+ years of experience as SQL Server Developer (2014, 2012, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP).
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions Using Log Shipping, Transactional & Merge Replication in SQL Server 2008/2012/2014.
• Involved in data center migration using the life and shift method.
• Experience in installing and configuring SQL Server 2014/2012/2008 R 2/2008/2005/2000 SQL Server versions
• Experience in Analysis, Design, Development and Validation of applications.
• Expertise in analyzing and coordinating clinical trial data, generating reports, tables, listings and graphs using SAS in accordance with the Statistical Analysis Plan(SAP),Standard Operating Procedures(SOPs) and departmental guidelines.
• Strong noledge involving all phases (me - IV) of clinical trials.
• Trained in Good Clinical Practice (GCP), Regulatory Compliance and FDA Guidelines.
• Strong experience on Base SAS, SAS/Stat, SAS/Access, SAS/Graphs and SAS/Macros, SAS/ODS and SAS/SQL in Windows Environment.
• Generate reports using PROC REPORT, DATA NULL and PROC TABULATE for customized report writing.
• Expertise in Data archival and Data migration, ad-hoc reporting and code utilizing SAS on UNIX and Windows Environments.
• Expertise in producing RTF, PDF, HTML files using SAS ODS facility.
• Extensively involved in UAT of iStars system for contract entry.
• Exclusively involved in Training and aiding RAMs and ADMs for template generation and contract entry process for all bilateral contracts.
• Working with Billing & Settlements team to develop various cross department protocols and new data forms as GSPM representative for the new iStars system.
• Provided monthly report to department, for sales of International Global Wholesale as a metric with respect to global competitors’ market share on volume and revenue basis.
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSISsuch asData Conversion,Conditional Split,Bulk Insert,Mergeandunion all.
• Developing reports onSSRSon SQL Server ( 2000/2005/2008 ). Sound Experience and understanding ofSSAS, OLAP cube and Architecture.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP),Data Transformation Services(DTS) andSQL Server Integration Services(SSIS)
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER usingDTS/SSIS
• Setup and configured AlwaysOn Availability Groups for DR and Reporting.
• Expert in MS SQL Server 2012/2008R 2/2008/2005/2000 suite of products like SSRS, SSAS, and SSIS.
• Good noledge in Data integration using ETL tools like SSIS (Microsoft BIDS) and Informatica.
• Extensive noledge in T-SQL queries (DDL and DML).
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2000/20 R2/2012.
• Good noledge in healthcare domain claim adjudication rules and provider matching and member matching rules.
• Experience in healthcare applications like FACETS data model and FACETS online claim processing.
• Experience with analyzing query plans, writing stored procedures, try-catch blocks, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking, Checking the threshold values and baselines.
• Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency TEMPEffects.
• Verifying and tuning stored procedures created by developers by using Execution plans, SQL Server Profiler, Data Tuning Advisor. Debugging stored procedures, optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Experience in administrative activates comprising Database health Check, Index optimization( Rebuild and reorganizing indexes with different fill factors and updating statistics.), Updating Statistics, Performance Tuning, Query Optimization, Client/Server Connectivity, data base security.
• Hands on experience and outstanding noledge of high availability SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering (Active/Active and Active/Passive).
• Proficient in SQL programming, physical database design, and SQL Performance tuning, replication.
• Used Erwin modeling tool for designing database objects.
• Development of Automated notification when SQL Server Backups and schedule maintained jobs.
• Migrated the SQL Server 2008 to SQL Server 2012.
• Migrated the SQL Server 2000/2005 to SQL Server 2012 and 2008 R2 versions.
• Used PowerShell script for SQL Server Maintenance activities.
• Handled very large databases (OLTP) which are in Terra Bytes (TBs).
• Extensive experience in Deploying and Consolidating Remote Instances.
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
• Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata.
• Monitored Sybase data servers and replication server for performance.
• Migrated the Data from an External Sybase SQL to an MS SQL Database by using SSMA.
• Installed and administered multiple VLDB Oracle 10g and 11g databases.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Designing and Deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Object Level Audits using Change Data Capture (CDC).
• Managing database systems using Query Governor and Activity Monitor.
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions, Triggers, and Distributed Queries.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
• 24/7 Production Databases on Call Support. Excellent Analytical, problem solving and communication skills.

TECHNICAL SKILLS

Databases: MS-SQL Server 2000/20, Oracle, MS Access 2003/2007.

Languages: C, C+, T-SQL, HTML, XML.

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import, Precise i3 for SQL Server.

Operating system: Windows 2012/2008/2003/2000/ Professional/ NT 4.0 Advanced Server

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Load Test Tools.: WAPT 7.5, WAPT Pro 3.1

PROFESSIONAL EXPERIENCE

Confidential, Bronx, NY

SQL Server Developer(SSIS/SSAS/SSRS/BI)/Tableau Developer

Responsibilities:

• Converted Data Transformation Services(DTS)application to SQL Server Integrated Services(SSIS)as assigned.
• Creating reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services(SSIS).
• Enterprise Data Warehouse (EDW) development and support.
• Developed SSIS packages and process to load data warehouse.
• Developing reports onSSRSon SQL Server ( 2000/2005/2008 ). Sound Experience and understanding ofSSAS, OLAP cube and Architecture.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports usingSSRS.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Experience in working withSSASin creatingcubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.
• Experience in Dimensional Data ModelingStarandSnow Flake Schemas.
• Working as a Tableau Desktop Consultant focusing on developing high-end visualizations driven by data coming in from SQL Server.
• Convert business requirements into story-telling viz by developing views and dashboards in Tableau Desktop and publish them to Tableau Server allowing end-users to control data and filter down further as desired.
• Participate in weekly meetings and document Tableau dashboard development progress. Manage timeline on project deliverable's.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groupsand sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within InteractiveDashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines,forecasting etc. in many tableau reports
• Publish the developed dashboard, reports on the Tableau Server so that the end users having accessto the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted toserver.
• Building, publishing customized interactive reports and dashboards
• Attending requirement gathering sessions, analyzing, designed software solution based on therequirements.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groupsand sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within InteractiveDashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines,forecasting etc. in many tableau reports
• Well versed with Business Objects Autantications and Authorizations, Creating/Administrating Users & Groups, designated their Security Levels in CMC, assigned Roles, & Access Levels on the Applications and folders.
• Diversified experience in implementation of Crystal Enterprise with multiple domains.
• Configured BW Publisher service for Crystal reports migration.
• Generated various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.
• Created and maintained around Crystal reports and Web Intelligence reports.
• Worked on Webi reports, Prompts and Report Layout and re-formatting.
• Developed Complex Universes by linking different data sources.
• Extensive noledge of commercial line insurance business
• Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Sevices(SSIS)
• Generated several drill down and drill through reports usingSSRS.
• Defined report parameters and wrote queries and procedures for drill down and parameterized reports using SSRS.
• Created and design the multiple dimensions and fact table for business report purpose.
• Created Report Snapshots to improve the performance of SSRS
• Generated parameterized/Drilldown reports to enable/disable the parameters based on user selection in SSRS
• Assisted in installation, management and tuning of Netezza databases and other records.
• Performed backup and recovery functions of databases through third party devices and Netezza utilities.
• Provided technical assistance for efficient performance and security functions of Netezza databases.
• Implemented procedures for allocation of hardware resources and performance tuning methodologies.
• Suggested enhancement methods, rollout and upgrades for maintenance of existing databases.
• Executed processes for timely release of database changes as per assigned timelines.
• Maintained system documentation of best database procedures, practices and standards.
• Resolved database problems and issues by troubleshooting and responding to service requests.
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Worked with SQL server logins, jobs, database backup and restore
• Develop SSIS packages, view, store procedures, and functions for data conversion.
• Performed database consistency checks
• Writing complex stored procedures/Triggers/Views/Functions in Transact SQL

Environment: Windows Server 20 bit/64bit, SQL Server 2000/2005/2008, SSMS, SSIS, Visual Studio 2005/2008, Visual Source Control, Windows XP Pro/Windows 7, C#, BI-Ready, AQT,Tableau Desktop 9.0/8.0/7.0, Tableau server / Administrator.

Confidential, Boston, MA

SQL Server /SSIS/SSAS/SSRS/BI Developer/Tableau Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers and created documentation for the same.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Created Financial and Retail Modeling Datasets. Used the proceuresSQL,TABULATE,FREQ,FORMAT, andGRAPHto generate modeling reports.
• Worked as Tableau Developer in standardizing Tableau for shared service deployment.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Created SSIS packages in SQL Server 2008 for sources database for Tableau dashboards.
• Extensively used data blending, embed functionalities in Tableau.
• Installed Tableau Server in Dev, QA, UAT and Prod environments.
• Worked as Tableau Developer in standardizing Tableau for shared service deployment.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Created SSIS packages in SQL Server 2008 for sources database for Tableau dashboards.
• Extensively used data blending, embed functionalities in Tableau.
• Installed Tableau Server in Dev, QA, UAT and Prod environments.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Monitored Vizql and WGSQL Server activity to track performance and system stability.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in license management SLA’s with Tableau support.
• Created scripts on windows task scheduler for auto sync of users from Active Directory groups.
• Involved in installation of Tableau desktop 7.0& 9.0, Tableau server Application software
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Creating New Schedule's and checking the task's daily on the server
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Monitored Vizql and WGSQL Server activity to track performance and system stability.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Worked with the users for defining the report needs and helped designing queries using Bex.
• Created complex formulas to support various business functionalities using crystal reports.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Worked on Real Time Info Cube and Data source object and also new and enhanced administration and monitoring features.
• Based on the Business Requirements granted rights on Public folders, Universe folders and Universe connections.
• Created the Test cases, Test Strategies and executed the Unit Testing and the UAT for the Entire environment.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On warning, On Pre and Post Execution, On Task Failed etc.)
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Confidential, Dallas, TX

Sr. SQL Server Developer(SSIS/SSRS/SSAS)/Tableau Developer

Responsibilities:

• Migration of databases from SQL Server 2005 to SQL Server 2008R2 and Sql Server 2012.
• Installed Sql Server 2012 and configured Always on With Primary and secondary Replicas, Read only databases, listener and with Application Intent.
• Created a complete plan on cluster shutdown and SQL server backups during data center migration.
• Wrote powershell scripts to query SQL server and SQL instances settings.
• Applied service packs to various versions of SQL server to make them compliant.
• Prepared strategic plans for data warehousing projects and related quality documentation.
• Assisted in designing and implementation of detailed data warehouse models and mappings.
• Provided technical expertise to technologies in fields of data warehouse and relevant analytics.
• Performed establishment and maintenance of databases for assigned projects as per business requirements.
• Implemented procedures for daily database monitoring, backup and configuration changes.
• Developed queries, backups, and session management and log management records in detailed manner.
• Executed processes for management of migration of tables, schemas, database as per defined and assigned locations.
• Supported optimal performance of databases by gathering statistics and indexes in coordination with architects and developers.
• Installed SQL Server 2008R2 on windows 2008R2 and migrated SSIS packages.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Provided deliverables related to Services, Sales and Quality KPIs defining overview and trending capabilities (Key metrics on bandwidth consumption, network inventory, leased line coverage area & customer feedback/complaints).
• Designed and developed various analytical views from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Built, published and customized interactive reports and dashboards using Tableau server.
• Performed time over time analysis of sales and performance related data.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Administered users, user groups, and scheduled instances for reports in Tableau.
• Wrote SQL queries for custom reports
• Monitored and modified Performance using execution plans with query hints and Index tuning.
• Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages and performance testing on stored procedures, indexes, and triggers.
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Performed horizontal data partitioning for efficient management of database tables and indexes.
• Working on Client/Server tools like SSMS, SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Used MDX queries for pre calculated measures and created reports model on SSAS cubes as well as changing default configuration on existing cubes. Created perspectives, partitions, and Designed aggregations in cubes using SSAS.
• Manipulated database security by creating autantication on databases. Created Window users, Work Group and SQL Server logins based on various security requirements. Created Cell Level Security in cubes using SSAS.
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.
• Developing T-SQL stored procedures, Log on & DDL triggers, views and adding/changing tables for data load and transformation, and data extraction and loading to data ware house.
• Working on different environments and a key resource for deployment of modified objects to production environments.
• Experience in writing scripts like retention of data using batch deletes.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Incremental loading of dimensions, facts, error handling in SSIS.
• Created Dynamic SSIS packages, to load Stage tables from text files.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Confidential, San Antonio, TX

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, IndexViews and also created User defined Data type, Clustered & Non-clustered Indexes
• Installed and configure servers and clients using SQL Server 2008,Upgraded SQL databases
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
• Managed database portioning across multiple disks
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrityconstraints and ACID properties
• Knowledge of Database Performance monitoring tools
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created ETL SSIS packages both design and code to process data to target databases
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Created jobs to collect status information from various servers and feed them to the Master Server
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking&deadlocks user counts and connections/locks etc.
• Implement automated Index Maintenance strategy run as SQL Job on a daily basis
• Created Snapshots, Subscriptions and Transactions using Replication services
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Developed custom reports using SSRS/SQL Server BI studio.
• Migrated SQL server 2000 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2008 Upgrade Advisor
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, BizTalk Server 2004 Erwin, Microsoft Visio 2003, SFTP

Confidential, Austin, TX

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Determined the MS SQL Server 2008 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented different security modes.
• Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances
• Analyzed and designed new business processes.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
• Assisted in generating business process flows, functional design documents and test plans.
• Developed ETL Packages in SSIS to transform data to MS SQL Server from Excel for further analysis.
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Designed ETL package, with ETL Import/Export wizard for transferring data using Informatica
• Data migration (Import & Export - BCP) from text to SQL Server.
• Applied schema change scripts to existing objects to synchronize with changing business rules by adding or enhancing relevant entities/tables, columns etc
• Implemented database consistency and security by creating groups, roles, users, and triggers on views

Environment: T-SQL, MS SQL Server 2008, MS Access 2008 MS-BI 2008, Data Warehouse (OLAP, ROLAP, MOLAP), Reporting Services, Crystal Report 8.0, ETL (SSIS, Informatica)

Confidential

SQL Server Developer

Responsibilities:

• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Monitored and modified Performance using execution plans and Index tuning.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Involved in Scheduling jobs using MS SQL server Agent.
• Created and managed users, login IDs, security, and add groups to Windows and SQL Server.
• Involved in Performance tuning of existing database objects such as stored procedures and complex stored procedures
• Prepared documentation related to database design, objects security and rules.
• Created DTS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat Files.
• Performed daily database backup & restoration and monitor the performance of Database Servers.
• Generate various ad hoc reports using MS Reporting services.

Environment: SQL Server 2000/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP