SUMMARY

• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005/2008/2012 in MS SQL Server 2000/ 2005/2008/2012
• Expert in designing and implementing relational database model as per business needs
• In - depth knowledge of Transact-SQL (DDL, DML), Indexes, Views, Stored Procedures and Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005/2012
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS and SSRS
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into a data warehouse.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, CTE’s Views and Cursors
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance
• T-SQL Programming using DDL, DML commands for various business applications
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks
• Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues
• Well-versed in usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot)
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) ( 2005/2008/2012 )
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import and Export Data
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas
• Hands on experience in creating the MDX cubes and dimensions
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008
• Worked with report manager for deploying the reports across all the environments
• Created different SSIS packages to pull data from EXCEL files, FLAT files to multiple destinations.
• Created SSIS packages for Error Handling.
• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions ( 2005/2008/2012 ) features.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Built reports and dashboards using different tools like Tableau, Qlikview and Spotfire.
• Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and Performance Point 2010 and Microstrategy (Mstr) and Dashboards.
• Worked with Microsoft Dynamics AX for data migration.
• Imported data into Microsoft Dynamics AX using Excel files which were created from SSIS.

TECHNICAL SKILLS

RDBMS: SQL Server 2000/2005/2008/2008 R2/2012, MS Access, Visual Studio 2008, 2010

Languages: C, C++, T-SQL, PL/SQL, Visual Basic 6.0., Unix, Scripting

Operating Systems: Windows Server 2003, Windows 2000 Advanced Server/Server, Windows NT 4.0, Windows XP, Windows 7

ETL Tools: SSIS, DTS (Data Transformation Services)

Tools: SSAS, Erwin 4.0/3.5,Performance Point 2010

Reporting: SSRS (MS SQL Reporting Service), Crystal Reports, MS Access, Excel, Data Analyzer

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

• Built SSIS packages with proper control flow and data flow elements to transfer data.
• Data mapping by consulting with the Business.
• Developed, deployed and monitored SSIS packages.
• Built multiple Views in which data from different databases.
• Built a tabular-dimensional cube (Star schema) using SSAS to access the data for reporting purposes.
• Built parameterized reports involving pie charts, bar charts using SSRS and Tableau.
• Built reports using power pivot.
• Led an offshore team for BI to assign daily work. Followed Scrum Methodology.

Environment: Microsoft SQL Server 2012, Windows 8, Microsoft Visio, Microsoft Excel, SQL Server Integration Service (SSIS), SQL Server Management Studio (SSMS) and Microsoft Visual studio 2008/2010, TFS, Scrum Methodology.

Confidential, Houston, TX

SQL Server Developer/SSIS

Responsibilities:

• Built SSIS packages with proper control flow and data flow elements to transfer data from JDE (JD Edwards) server to MS - DAX.
• Data mapping by consulting with the Business.
• Developed, deployed and monitored SSIS packages.
• Created complex SSIS packages to extract data from staging tables to partitioned tables.
• Built dynamic SSIS packages for incremental load on different sources and destination to suffice the requirements.
• Built SQL agent jobs that run nightly, weekly and monthly.
• Extract out data to flat files and excel files, use the same files as a source as well.
• Used a lot of Error handling techniques for all the SSIS packages created.
• Worked on Data modeling.
• Created multiple Spotfire reports using data from SQL Server.

Environment: Microsoft SQL Server 2014, Windows 8, Microsoft Visio, Microsoft Excel, SQL Server Integration Service (SSIS), SQL Server Management Studio (SSMS) and Microsoft Visual studio 2008/2010, TFS, JDE, MS DAX.

Confidential, Houston, TX

SQL Server Developer/SSIS

Responsibilities:

• Built database right from scratch along with all the right indexes and other requirements.
• Built SSIS packages to transfer data from one server to another on MSBI 2012
• Built dynamic packages to upload/download files from the FTP server onto a local folder and a database on the SQL Server
• Built dynamic packages to upload data onto a share point site and also do an incremental load accordingly.
• Worked on building a data ware house right from scratch involving star Schema and snow Flake Schema
• Build SQL Server agent jobs that run nightly, weekly and monthly.
• Worked on Data modeling
• Extract out data to flat files and excel files, use the same files as a source as well
• Worked extensively on creating Stored Procedures that involved dynamic SQL
• Created multiple reports like drill down, drill through and pie charts using SSRS
• Built Configuration Tables for the packages and Error handling techniques for all the packages created. created different reports using crystal reports tool

Environment: Microsoft SQL Server 2012, Windows 8, Microsoft Visio, Microsoft Excel, SQL Server Integration Service (SSIS), SQL Server Management Studio (SSMS) and Microsoft Visual studio 2008/2010, Meta data, TFS

Confidential, Houston, TX

SQL Server Developer/SSIS

Responsibilities:

• Built many SSIS packages on 2005 and 2012
• Built packages using variety of transformations like script task, data flow task, data conversion, execute SQL task and for each loop containers, Execute Package Task.
• Worked on bringing in the data from different databases and storing them into one destination.
• Dealt with creating and optimizing Stored Procedures and there by using them in the Packages that were built.
• Built data ware house and data marts involving both star schema and snow Flake schema
• Used CHECKSUM to figure out the updates between huge tables which consisted of 25 to 30 columns.
• Created different loads for pulling data based upon Historical or Incremental time.
• Involved in Performance Tuning of Stored Procedures and SSIS packages that were built
• Built Configuration Tables for the packages and Error handling techniques for all the packages created.

Environment: Microsoft SQL Server 2005/ 2008/2008 R2/2012, Windows 7/ Windows 8, Microsoft Visio, Microsoft Excel, SQL Server Integration Service (SSIS), SQL Server Management Studio (SSMS) and Microsoft Visual studio 2008/2010.

Confidential, Houston, TX

SQL Server Developer/SSIS

Responsibilities:

• Worked on building and maintaining SSIS packages
• Involved in redesigning of the database
• Built packages using variety of transformations like script task, data flow task, data conversion, execute SQL task and for each loop containers
• Created XML, Excel, CSV and Text (Tab Delimited) files
• Also worked on loading the data from XML files to the database
• Loaded data into the database from a different kind of File formats like Excel, CSV and Text Files
• Dealt with creating and optimizing Stored Procedures which had to be constantly changed or modified according to the business need
• Provided front end (Entity Framework) by creating Views to suffice the needs
• Used TFS to save code and packages, also to move code to different environments like QA and Production
• Involved in Performance Tuning of Stored Procedures and SSIS packages that were built
• Built Error handling techniques for all the packages created.
• Worked with Team Track System.

Environment: Microsoft SQL Server 2008/2008R2/2012, Windows 7, Microsoft Visio, Microsoft Excel, SQL Server Integration Service (SSIS), SQL Server Management Studio (SSMS), Team Foundation Server (TFS) and Microsoft Visual studio 2008/2010.

Confidential, Minneapolis, MN

SQL Server Developer/SSRS

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the clients of VI.
• Involved in the Creating Databases for the project I was hired at VI.
• Prepared the complete data mapping and Report Definitions for the project which involved around 40 reports.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Added Localization/Internationalization to all the reports that were created during this project, the localization consisted of 6 different languages.
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications
• Developed couple of reports based from Tableau reporting tool. created reports using crystal reports tool created different reports using crystal reports tool

Environment: Microsoft SQL Server 2008/2008R2/2012, Windows 7, Microsoft Visio, Microsoft Excel, SQL Server Reporting Service (SSRS), SQL Server Management Studio (SSMS), Team Foundation Server (TFS), Share point 2010 and Microsoft Visual studio 2008/2010.

Confidential, San Antonio, TX

SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Working knowledge in Data modeling, creating star and snowflake schemas in SSAS
• Created KPI Objects in line with Requirement Docs
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Scheduled tasks to run every day to update changes in the base tables
• Designed and developed various types of reports using SSRS
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications
• Published reports on to Share-Pointandcreated Web Parts in Share-Pointto show various reports generated fromExcel andSSRSin one Page.

Environment: Microsoft SQL Server 2005/2008, Windows Server 2003, Windows XP, Microsoft Visio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

Confidential, Addison, TX

MS SQL Server / SSRS /SSIS Developer

Responsibilities:

• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders.
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies.
• Formatted the reports using the Global variables and expressions.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server.
• Fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005, ASP.Net, MS Excel, Window XP, Toad.