SUMMARY:

• 9+ years of extensive experience as a MSSQLServerSQLServer 2008/2012/2014 Developerwif major focus on T - SQL, SSIS, SSRS, SSAS and sound experience as a databasedeveloperin banking, IT and financial sectors. Having noledge of software development life cycle (SDLC) wif substantial experience wif object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment
• Profound noledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries wif complex joins and aggregate functions. Expertise wif DDL and DML statements, RDBMS's, data dictionaries and normal forms
• Exceptional hands on working noledge and recent experience working wifSQLServer Integration Services (SSIS) andSQLServer Reporting Services (SSRS).
• Thorough experience wifSQLServer 2005/2008 R2 instance installation, up gradation and migrating from SQLServer 2000 to 2005.
• Experience in writing Stored Procedures in DW environment and tan created packages in SSIS to load the data into Data Warehouse & sending alerts usingSQLMail.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES toSQLSERVER using DTS/SSIS.
• Involved in claim adjudication process of facets application.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Expertise in planning and implementing MSSQLserver Security and database permissions.
• Solid noledge and recent experience wif all aspects ofSQLServer Management Studio (SSMS) including Query Editor, Server objects,SQLServer Agent, Replication, Management and Notification Services.
• Proficiency in using different Transformation tools like DTS packages, BCP and Bulk Insert as well asSQLServer Integration Services (SSIS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS) (like using dashboards, scorecards, building reports) wif proficiency in using Report Designer as well as Report Builder.
• Monitor the production server using tools likeSQLProfiler, Windows Perform, Performance Counters andSQLserver logs for Monitoring and TuningSQLServer.
• Strong experience wif creating Linked Servers for connecting servers at remote site locations and tan querying the group of servers using T-SQLstatements. Strong working noledge on Query Optimization and server performance tuning strategies.
• Successfully implemented Transactional and Snapshot Replication methods for Backup and Restore of Database. Good understanding of high availabilitySQLServer solutions using active-active and active-passive Clustering modes.
• Expertise wif job scheduling usingSQLServer Agent to perform hourly/ daily/ nightly updates. Expert in performing database consistency checks using DBCC Utilities.
• Experience in Data Modeling using Erwin, Rational Rose (UML) and MS-Visio to create logical and physical data models; use case diagrams and data flow diagrams respectively.
• Worked on FACETS up-gradation project.
• Authorized to work in the US for any employer.

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee

SQL/ SSIS Developer

Responsibilities:

• Designed Logical data model using Erwin
• Developed tabular reports using SSRS
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Installation and configuration ofSQLServer on Windows 2000/2003/2008/ XP OS
• Managing of database objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary, Used BCP utility to publish table content to text files
• Developed SSIS Packages to transfer the data betweenSQLServer database and files
• Created and managed database maintenance plans for various database consistency checks
• UsedSQLProfiler to monitor the server performance, debug T-SQLand slow running queries
• Managed users including creation/alteration, grant of system/db roles and permission on various database objects
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them
• Assisted admin team wif Log Shipping to ensure full database backup and disaster recovery
• Had to integrate the Medicare (Part A, Part B, Part C, Part D) data all in one single system for a smooth flow through the claims processing system Facets 4.71

Environment: MSSQLServer (Query Analyzer,SQLProfiler), SSRS (SQLServer Reporting Service), SSIS (SQLServer Integration Services), SAS, Facets, Business Intelligent Studio,SQLServer Management Studio, ASP, Crystal Report, Enterprise Manager, MS Excel, Windows XP Professional, TFS

Confidential

SQLBI Developer(SSIS/SSRS)

Responsibilities:

• Involved in designing and implementing database applications using MSSQLServer 2008/ 2012 and Business Intelligence (BI) tools to support transactions and business decision-making
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet toSQLServer 2008
• Designed ETL packages dealing wif different data sources (SQLServer, Flat Files) and loaded the data into target data sources by performing different kinds of transformations (For loop, bulk insert, Data flow, Data mining, FTP, XML tasks, etc) usingSQLServer Integration Services (SSIS)
• Used Package Configurations to pass parent package variable values to child package variable
• Deploying SSIS packages from various sources like bids, Management Studio, file systems etc
• Monitored performance and optimizedSQLqueries for maximum efficiency
• Responsible for creating reports based on the requirements using SSRS
• Experience in creating reports using SSRS and worked on OLAP/OLTP environment
• Advanced extensible reporting skills, developed SSRS reports & generated them onSQLServer 2005
• Used Subscriptions and Snapshots to set up Push based Report Delivery
• Responsible for scheduling the subscription reports wif the subscription report wizard
• Developed stored procedures and used SSIS 2005 to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables
• Designed and implementedSQLServer database objects (stored procedures, functions, views and complex T-SQL/queries) to support data integration (SSIS), reporting and various business processes

Environment: SQLServer SSRS 2008, SSIS 2008, SSAS Data Stage, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, SSAS, MS Office and Visual source safe.

Confidential

SQL ReportDeveloper

Responsibilities:

• This Project involves development of integrated package for order entry and inventory management. The Package enables order entry for taking customers orders, maintaining inventory and shipping to the customers. The Package consists of an information system to enable the user to access the status of the sales orders, stock balances, stock value and shipped orders.
• Developed complex T-SQLstored procedures using joins and unions to create crystal reports and also optimizedSQL queries for efficiency and the front enddeveloperwif their queries and procedures
• Developed crystal reports using Crystal Reports 10 for detail information to the sales team regarding sales of all stores according to the criteria given, which helped the sales team to take their decisions
• Developed E-R diagram for reports which gives all the relationships of the tables from huge De-normalized database using Microsoft Visio
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
• Developed various functions usingSQLServer 2008 for the interfaces which were automatically run on daily, weekly and monthly basis usingSQLserver task in SSIS
• Responsible for optimization of the T-SQLqueries to give the faster results from whole bunch of data usingSQLProfiler and also provided 24/7 Support for Production, Development & Test Servers of MSSQLServers
• Developed temporary tables and views of the databases for faster use and faster retrieval of the data and helped developer's team to reduce the complexities of fetching data and access complex database
• Developed Demo Results of the reports which are useful for the UAT phase to get the approval from the key users
• Involved in Data conversion to clean the legacy database and reuse it for annual decisions of the sales and also created mapping between legacy tables and current tables in the database

Environment: MSSQLServer 2008, Windows Server 2003, DTS,SQLprofiler, Performance Monitor, Query Optimizer, T-SQL, Microsoft Visio 2007, MS Visual Studio 2008, Crystal Report 10.

Confidential

MS SQL Server DBA

Responsibilities:

• Created and maintained various databases for Production, Development and Testing environments usingSQLServer.
• Actively involved in setting up Active-Active/Active-Passive clustering in Production and Testing Environments and also troubleshoot issues wif the same; applied hot fixes and Service Packs in clustering environments.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshoot issues wif witness servers.
• Migration ofSQLServer 2005 TOSQLServer 2008 & 2008R2 versions Performed daily/weekly/monthly based backups and restore.
• Migration of the data across different databases and different servers using SSIS, BCP and Import/ export tools.
• Performance tuning using windows performance monitor andSQLprofiler ofSQLserver; usedSQLServer error logs and event viewer to troubleshoot issues.
• Troubleshoot issues wif log file full and database size increasing beyond thresholdCapacity Planning, data modeling and Logical/Physical database Design.
• Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Provided support to the application developers on the application databases.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues wif deadlocks & other locking issues.
• Performed Database consistency checks wif DBCC, Defrag, Index tuning and monitored error logs.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• UsingSQLServer Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports dat draw content from a variety of data sources.
• Refreshes from Production backup to Stage and Development environments.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting/Ad hoc reporting.
• Worked closely wif development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources such asSQLServer … Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• ITIL process such as Change management, Incident Management & Problem ManagementMaintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Experience on Configuring and Maintaining Backup strategies using Lightspeed and SQL Maintenance Jobs and implemented log shipping using LightSpeed.
• Configuring and monitoring multiple servers using Spotlight.
• Experiences on Diagnostic servers, Notification Alams, Reporting wif using Spotlight.

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

Confidential

SQL Server DBA

Responsibilities:

• Installation of MS SQL 2005 Enterprise servers on test and development boxes.
• Recommended system design approaches, which are consistent wif the application's business requirements.
• Interacting wif Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Performing Database Administration and Management activities in a safe, recoverable and professional manner dat ensures the optimal operation of all database environments.
• Handling database objects wif Enterprise Manager and Query Analyzer.
• Administering the MS SQL Server by creating user logins wif appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Perform Capacity Monitoring and short and long-term capacity planning in collaboration wif development resources, System Administrators and System Architects.
• Automated processes using SQL Server jobs.
• Proper use of Views to prevent unauthorized access.
• Using the Database Maintenance Wizard to make some necessary changes and keeping the performance of the server at acceptable levels.
• Database design, creation of user databases and installation of MS SQL Server & Clients.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources using the concept of OLEDB.
• Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional Replication.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Worked on linked servers to run distributed queries between SQL servers

Environment: MS SQL Server 2008/2005/2000, Windows 2000/2003, DTS

Confidential

MS SQL Developer

Responsibilities:

• Created Tablix Reports, Matrix Reports, and Parameterized Reports and Sub reports using SQL Server Reporting Services 2008.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports
• Worked on row and Column Grouping.
• Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Experience in writing complex MDX queries for calculated members and measure groups.
• Experience in building Reports on Analysis Services cubes.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.(SSRS)(2005/2008 R2).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL
• Identified and defined Fact relationships in SSAS
• Responsible for identifying KPIs in SSAS 2005.
• Development, improvement, customization and deployment of SSRS reports in Business Development Studio
• Involved in creating Indexes, Constraints on database objects.
• Created various Weekly and Monthly reports showing detailed information in SSRS.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 R2 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements wif error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.
• Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.
• Responsible for scheduling the subscription reports wif Data Driven Subscription Windows File share and Email Delivery using SSRS.
• Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
• Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Defined MDX scripts for data validation process against OLAP cubes for business validation.
• Worked on backups scheduling.
• Experience in Reviewing Cube wif End user and changing the cube and documentation according to their requirements.

Environment: SQL Server 2005/2008 R2, SSAS, SSIS, T-SQL, SSRS, Oracle 9i, Performance Point Server 2007.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Assisted clients wif physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Involved in Administration of the SQL Server by creating users & login ids wif appropriate roles & grant privileges to users.
• Involved in writing T-SQL statements for retrieval of data.
• Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.
• Designed and developed tables, view, stored procedures and triggers in MS SQL Server database on Windows NT platform.
• Designed and developed reports using Crystal Reports

Environment: MS SQL Server 2000, Windows server 2003, Enterprise Manager, MS Access, MS Excel, MS Word, Windows 98/NT/2000, T-SQL, DTS, Query Analyzer, SQL Profiler, Crystal Reports.