PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience in Data Design and Development on Microsoft SQL Server 2012/2008R2/2008/2005/2000, T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, and Data-warehousing.
• Experience in using Business Intelligence tools(SSIS,SSAS,SSRS) in MS SQL Server 2008
• Extensive experience wif T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008r2/2005/2000.
• Great ability to create and manage various database objects like tables, views.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008, MS SQL 2005 and DTS in MS SQL 2000
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Experience wif logical and physical data modeling and database design using Erwin.
• Experience in Designing and Building teh Dimensions and cubes wif star schema using SQL Server Analysis Services (SSAS).
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Extensive experience in XML, XML Web Services, XSLT & Security in ASP .NET.
• Proficient in developing, implementing applications and products using C#.Net,ASP.Net,ADO.Net, VB.Net, .Net Framework 2.0/3.0/3.5/4.0/4.5&SQL Server 2005/08.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning teh reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008,SQL Server 2005 Management Studio, DTS, SSIS, SSRS

Database: MS SQL Server 2012,2008R2,2008,2005, 2000, MS-Access

Language: C, C++, T-SQL, VB.Net, ADO.Net, ASP.Net, Java script

Operating System: Windows XP/NT/2000, DOS, Windows Server 2003

Tools: Erwin, Microsoft Visual Studio 2012/2008/2005,Share Point Server 2007, Microsoft Project Server 2007, GOLDTIER

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools: SSRS (SQL Server Reporting Services), Crystal Reports

ETL Tools: SSIS (SQL Server Integration Services), Data Transformation Services(DTS), BCP, SQL Server Analysis Service(SSAS)

Scripting: C#

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

SQL BI Developer/SSIS/SSRS

Responsibilities:

• Upgrading Server 2005 to 2012, SSIS packages and SSRS Reports.
• Creating SQL Agent Jobs, Upgrading and fixing teh 2005 jobs in 2012.
• Created packages for loading teh CSV files and flat files from Server into SQL Server using SSIS 2012.
• Tuning teh Store Procedures when needed, creating indexes, Hash Join, etc. so dat teh report execution time is minimized.
• Checked each and every Stored Procedure; rewrite teh paths in sp send dbmail, xp cmdshell and cmdexec’s.
• Managing Report Server and Database Server.
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and also used configuration files for production deployment.
• Created New different kind of reports using Reporting Services (SSRS) 2012 and created different Parameterized reports and Subscribed through Data Driven Subscription.
• Participated in teh whole life cycle of teh project including design phase of teh project, which was designed using ASP.NET, VB.NET and ADO.NET
• Working on Windows Server Administration to change teh settings according to Server 2012 to run Server 2005 applications.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s& MDX Queries using SQL Server 2008 Analysis Services(SSAS)

Environment Server 2012/2008 R2, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), T-SQL, XML, VSTF, MS Excel, MS Access, SharePoint 2010, Visual Studio 2013. ASP.NET, ADO.NET, VB.NET.

Confidential, Long Beach, CA

MS SQL Server / SSIS/SSAS/SSRS Developer

Responsibilities:

• Scheduled teh packages to run automatically for incremental data and deploy them to their destination servers
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Understanding teh OLAP processing for changing and maintaining teh data warehouse, optimizing dimensions, hierarchies and adding aggregations to teh cube.
• Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.
• Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.
• Worked in extracting transforming and loading (ETL) data across multiple databases using SSIS packages.
• Performed data consistency and performance tuning effectively wif SQL Profiler, Index Tuning Wizard.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Improved data load performance by analyzing database design and query plans.
• Deployedanduploaded teh SSRS reportstoReport Manager &SharePoint serverfor teh end users and involved in enhancements and modifications.
• Performed changes in teh schema of teh proposed database as required and informed those changes to teh application development team.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created and Configured OLAP cubes (star schema and Snow flake schema) using SQL Server 2008 Analysis Services (SSAS).
• Documented different stages of data transformation, procedures and scripts.
• Optimized teh query performance wif modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Environment: SQL Server 2005/2008, T-SQL, SSIS, Excel, Advanced Windows 2003 Server & PVCS Version Control Management

Confidential -Herndon, VA

SSIS/SSAS/SSRS/ Data Warehouse Developer

Responsibilities:

• Gathered business requirements, created specification documents, data mapping, data quality analysis, working in conjunction wif teh data warehouse team on teh development of logical data models.
• Worked as a developer in creating complex stored procedures, triggers, and user defined functions.
• Managed index statistics, tables, views, cursors and optimizing queries by using execution plan for tuning teh database. Implemented different types of constraints on tables.
• Performance tuning to optimize SQL queries to improve data retrieval using query analyzer and DMV.
• Tested to optimize teh procedures and triggers to be used in production.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions, handled dead lock scenarios.
• Extensively used SSIS import/export wizard, for performing teh ETL operations.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created database maintenance planner for teh performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Worked as a Microstrategy consultant and performed end to end development, testing and migration related activities.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Create SSIS template complete wif event handlers and logging to audit SSIS package used to load warehouse.
• Designed web forms using ASP.NET and used VB.NET as code behind.
• Created various SSRS dashboard reports for commission, sales and profit analysis.
• Involved in mapping customer requirements to Microsoft Dynamics CRM.
• Authored performance based reports for teh managers to show sales against various measures like time, area, and price-range.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, and Packages.
• Responsible for automation of maintenance jobs, locks and indexes configurations.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition, Microsoft Visual studio 2008,C#, VB.Net, SSIS, SSRS, Windows server 2003, Internet Information Server (IIS), MS Excel 2007

Confidential -Austin, TX

SQL MSBI Developer

Responsibilities:

• Worked wif complex SQL statements using joins, sub queries and correlated sub queries for report generations using SSRS.
• Designed and developedmonthly, quarterly and yearly reports at branch and bank level.
• Involved in creation of data modeling techniques and set up SQL Server configuration settings.
• Analyzed complex queries and tune teh same to optimize application and system performance.
• Coordinated wif DBA in creating and managing tables, indexes, triggers etc.,
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Involved in converting all existing earlier versions of SQL Server DTS packages by using different SSIS tasks.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Involved in Data migration, development and implementation of SSIS on an enterprise level.
• Developed Report Models for building Adhoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Created SSIS package to load data from Flat File to Flat File and Flat File to Data warehouse and Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation and Slowly Changing Dimension.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Involved in setting up SQL Server Agent Jobs for periodic Backups wif backup devices, database maintenance plans and recovery.
• Using different databases cross-reference other database wif Primary Key, Foreign Key and linking their related knowledge together.
• Developed PL/SQL-Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate teh historic data.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools like PL/SQL Developer, SQL* Plus, Toad.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Worked wif T-SQL to create Tables, Views, and triggers and stored Procedures.
• Implemented user based security in SSRS reports to limit teh access of reports.
• Involved in Analyzing, designing, building &, testing of OLAP cubes wif SSAS 2005 and in adding calculations using MDX.

Environment:SQL Server 2005/2008/2012, T-SQL, C#, VB.Net, SQL Profiler, SSIS, SSRS, MS Visio, MS Excel

Confidential

SQL Server Developer

Responsibilities:

• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded Stored Procedures, functions and triggers at high level.
• Fine Tuned teh SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of database servers.
• Participated in User Acceptance Testing for different modules.
• Implementing user training and providing technical support.
• Prepared proper backup and recovery plans.
• DBA activities like creating users, roles and granting and revoking privileges.
• Merging data into a single server for achieving better control, consistency & security of data.
• Designed teh Logical and Physical design of database for projects on basis of user requirements.