SUMMARY

• Overall 8 years of experience as SQL Server Developer (2014, 2012, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP).
• Expertise inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS).
• 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
• 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 on SSRSon 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 knowledge in Data integration using ETL tools like SSIS (Microsoft BIDS) and Informatica.
• Extensive knowledge 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 knowledge 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 Effects.
• 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 knowledge 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.
• 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.
• 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.

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, Greensboro, NC

SQL Server Developer(SSIS/SSRS/BI)

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.
• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed SSIS packages and process to load data warehouse.
• Designed and Document Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Created Full client, Web I and Crystal Reports based on the END Users and Business requirements and Modified the existing Reports based on the specifications and requirements.
• Analyze the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports.
• Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checked the integrity.
• Created universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Implemented the Object-Level Security and Row-level security in Universe. Implementing the Table Mapping in Universe to restrict certain data in a table to only one group of users.
• Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005 Analysis Services.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functionsandpackagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Data conversion project from SQL Server 2008 to CSC Point-In application running custom SQL server 2008 database.
• Experience with moving database from one server to another
• Developed SSIS packages and work flow to load data from XML source to Data warehouse
• Extensive knowledge 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
• Expert in creating Star schema cubes usingSSAS.
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Worked with SQL server logins, jobs, database backup and restore
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Develop SSIS packages, view, store procedures, and functions for data conversion.
• Performed database consistency checks
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• Set up ODBC connection on windows server.
• Set up database maintenance plan to clean up and backup’s dev and stage servers.
• Create Linked Servers to SQL Servers and other databases such as Oracle
• 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

Confidential, Bronx,NY

SQL Server Developer(SSIS/SSRS/BI)

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.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdatastructures.
• Involved in the continuous enhancements and fixing of production problems.Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL. Involved in data replication and high availability design scenarios withOracle Streams. DevelopedUNIXShellscriptsto automate repetitivedatabaseprocesses.
• 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.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• 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.
• Prepared technical and functional designs in collaboration with teams and business users for Netezza
• 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)

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.
• Installed SQL Server 2008R2 on windows 2008R2 and migrated SSIS packages.
• 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 authentication 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 Authentication 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, Index Views 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 integrity constraints 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