SUMMARY

• IT Professional with over 8 years of experience in Analysis, Design, Development, Production Support, Testing and Deployment of software systems.
• Deft in database designing skills and experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2012/ 2008 R2/2005.
• Experience in Managing Security of SQL Server 2005/2008 R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Strong experience in Implementing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models and T - SQL(DDL & DML).
• Extensively used tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005/2008 R2 Reporting Services (SSRS) and SQL Server 2005/2008 R2 Integration Services (SSIS) in Business Intelligence (BI).
• Excellent knowledge of creating jobs, SQL Mail Agent and scheduling DTS/SSIS Packages. Using SQL Server Agent.
• Experience in developing, configuring, deploying and scheduling Ad-hoc Reports Parameterized Reports and complex reports using SSRS.
• Worked extensively on creating, configuring, deploying in SSIS Packages for Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML.
• Experienced in Agile development methodology like SCRUM.
• In-depth knowledge of understanding all stages of Software Development Life Cycle (SDLC).
• Competent, reliable and committed professional with a proven track record of successful implementations.
• Worked with development team and 24 x 7 on call environments and documenting all Database architecture according to established standards.
• Interacted with Microsoft Technical Support Team in resolving the mission critical issues, and used to follow up on the opened tickets, by analyzing the respective logs and configuration files and did a follow up on the open incidents.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008 R2/2005/2000, MS AccessMy SQL Programming LanguagesC, C++, C#, VB.NET Web TechnologiesASP.NET 2.0, 3.0, 4.0 HTML, XML, CSS, Java Script, Web Services, WCF.

Reporting Tools: Reporting Service (SSRS), Crystal Reports.

BI Tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS)

Application/Web Servers: Internet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP

Other Tools: Visual SourceSafe, Team Foundation Server, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, IL

SQL/BI DEVELOPER

Responsibilities:

• Well versed with the various business processes/activities addressed like Channel Management, Customer Information Management, Inventory Management, Invoicing Process, and Integration with other systems, MIS and Reports.
• Worked with BA and development teams to implement functionalities related to Customer Information.
• Involved in database development by creating logins and assigning Roles.
• Involved in File group Creations and Partitions of the tables.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Worked with various SSIS packages which involve Transactions, and Roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Involved in SSRS report deployment and report server configuration.
• Formatted the reports using the Global variables and expressions.
• Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down, and Cross Tab Reports in SSRS.
• Involved in creating backup strategy production, test and development servers.
• Experience in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Involved in working on Incidents and also track change requests using BMC Remedy.
• Involved in troubleshooting production issues.

Environment: Microsoft Visual Studio.NET 2008, 2010, ASP.NET 2.0, ASP.NET 3.5, SQL Server 2012/2008R2, JavaScript, CSS, JQuery, HTML, and AJAX.

Confidential, RICHMOND, VA

SQL /BI DEVELOPER

Responsibilities:

• Working very closely with other developers for their SQL requirements and Worked with Business Analyst and end users to understand the report requirements.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Involved in writing T-SQL, stored procedures, views, indexes, constraints & business rules wherever applicable.
• Used SSIS to populate data from various data sources, created SSIS packages for different data loading operations for applications.
• Design, develop & test the ETL processes according to industries best practices using SSIS.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Extensively worked on Data Flow tasks like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Configured SQL mail agent for sending automatic emails when a package is failed or succeed using SSIS.
• Wrote custom triggers for audit by logging changes on databases, preserve referential integrity and provide additional application functionality.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, SQL profiler and execution plans.
• Experience in Dimensional Modeling, applying Kimball’s methodology, designing Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

Environment: SQL Server 2008R2 Enterprise Edition,.NET, T-SQL, MS Access, MS Excel, & Windows 2003 server, TFS, Business Intelligence technologies like SSIS,SSRS,SSAS.

Confidential, MADISON, WI

SQL /BI DEVELOPER

Responsibilities:

• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, DB triggers and problems related to the privileges.
• Implemented full and differential backups and also created and managed DB objects and Placement.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
• Experience in creating snapshots of static reports and configure subscription.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.

Environment: SQL Server 2005/2008, Windows 2000/2003, MS Access 2000/2003,T-SQL,SQL Server Integration Services(SSIS), SSRS, Crystal Reports, SharePoint (MOSS) 2007, Visio

Confidential, DETROIT, mi

SQL /BI DEVELOPER

Responsibilities:

• Involved in implementing different types of reports & schedule them for reporting purposes using SSRS As per customer requirements.
• Normalized the data, created different tables, views, indexes, triggers and efficient stored procedures and Functions.
• Created partition table for very large database for good performance.
• Developed optimal stored procedures and queries to create data sets for reports.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.
• Worked with SQL server agent for scheduling jobs, SQL profiler for database tuning.
• Created DTS/SSIS packages for Uploading of Various different format of files and databases to MS SQL Server using Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.

Environment: SQL Server 2005 Enterprise Edition,.NET, Windows 2003 server, TFS, Business Intelligence technologies like SSIS,SSRS.

Confidential

System Engineer

Responsibilities:

• Interacted with Team to Analyze, Design and Develop database using ER Diagram, Normalization and relational database concepts.
• Designing and developing stored procedures, User-defined Functions, Views to support business application system needs.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries.
• Creating and automating the regular Jobs.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created DTS packages to import the data from MS Access and Oracle server to SQL Servers.

Environment: ASP.NET 2.0, ADO.NET, C#, Microsoft Visual Stuidio.NET 2005, HTML, SQL Server 2000, 2005, Query Analyzer, SQL Profiler,.NET Framework 2.0.