SUMMARY

• Over 7 years of IT experience in Database Design, Development, Implementation, Debugging and Testing of various software applications to support ETL and Reporting of data using MS Business Intelligence initiatives.
• Exceptional hands on experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) for 2012, 2008R .
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Hands on expertise with ETL process using DTS/SSIS to load and process high volumes of data for front - end, web and reporting applications.
• Expert in maintaining existing SSIS packages and build new packages from scratch and used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer and Creating, Configuring, Deploying and Testing SSIS Packages.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Expertise in creating and maintaining jobs in various job scheduling systems includes SQL Server Agent job.
• Working knowledge on Microsoft Visual C# in script component of SSIS.
• Strong T-SQL skills to define queries for generating drill down reports, handling parameterized reports and to create stylish report layouts in SSRS 2005/2008/2012.
• Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Experienced in creating different types of Tabular, Matrix, Drill-Down, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS)
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, Store Procedures user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Expert in T-SQL DDL/DML operations, writing Complex T-SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries
• Exposed to all phases of software development life cycle (SDLC) including in-depth knowledge of agile methodology and Waterfall Models.
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C#, C, C++, Java, UNIX shell scripts, XML, HTML

SQL Server Tools: BCP, DTS, Import/Export Wizard, SQL Mail, SSMS, SSIS, SSRS.

Databases: SQL Server 2012/2008R2/2008/2005, MS Access

Operating Systems: Windows Server 2008/Vista/XP/Windows7

ETL Tools: SSIS (SQL Server Integration Services)

Reporting Tools: SSRS, MS Excel, Crystal Reports and MicroStrategy

Business Tools: Word, Excel, PowerPoint, Access, Outlook.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr. SQL Server/BI Developer

Responsibilities:

• Actively participated in interaction with users, Team lead, DBA’s and technical managers to fully understand the requirements of the system.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Configured Reporting Services in SQL Server 2012 and Deployed reports in to Report Manager.
• Created standard Reports and Cross Tab Reports and Drill Through reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created different chart reports helped in analyzing performance counters using SSRS 2012.
• Detection and resolving of blocking and deadlocks using Profiler, DBCC utilities.
• Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Improved query performance by adding covered indexes, adding file groups.
• Designed SSIS (ETL) Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2012
• Performed Data profiling tasks In SSIS (ETL) using the Data Profile Viewer and then clean and standardize the data as appropriate for the Databases.
• Conducted the Error handling in SSIS (ETL) using the Event Handlers.
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Worked with migrating data from flat files, mainframe data, Oracle, Db2 data to SQL server 2012 using SSIS services.
• Developed Slowly Changing Dimensions (SCD) in SSIS (ETL) to perform the Incremental and Historical loads of data in the data warehouse.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Used Agile methodology (SCRUM) for the development.

Environment: T - SQL, SQL Server2012, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, Windows XP, Visual Studio 2010, MS-Access 2010, VB.Net.

Confidential, Phoenix, AZ

SQL Server SSIS/SSRS Developer

Responsibilities:

• Interacted with Business Analysts and Developers in identifying the requirements, designing strategies and implementation.
• Developed and maintained stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs and C# code as required.
• Designed and developed variousSSIS packages (ETL)to extract and transform data and involved in Scheduling SSIS Packages.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Performed incremental Data Load using CDC (Change Data Capture).
• Created SSIS packages with Error and Event Handling, Precedence Constraints, Break Points, and Logging.
• Upgraded more than 40 packages from 2008R2 to 2012 SQL Server
• Migrated SQL Server 2008DTS packages to 2012 SSIS packages.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packagesand Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldown, drill through, sub-reports, navigation reports etc.
• Worked on Performance tuning by optimizing the queries, and created useful Indexes.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers
• Created lot of custom reports for the Global complaints using complex stored procedures and Crystal reports.
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Used Agile methodology (SCRUM) for the development.

Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services 2008, Crystal Reports 10 and IX, MS SQL Server Reporting Services, T-SQL, Windows XP, Visual Studio 2010, MS-Access 2010.

Confidential, Austin, TX

SSIS Developer

Responsibilities:

• Design and normalize the databases and created different objects like tables, views, Stored Procedures, indexes rules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Involved in the SQL-tuning, performance/Query optimization for the application using SQL-Joins and Indexes.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Designed SSIS Packages to handle data migration (ETL Processes) from transaction system to dimensional model.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created the Staging tables, successfully migrated old data from legacy system into SQL Server using SSIS Packages.
• Used Sequence Container in Control Flow for linking all dimension tables.
• Extensively used SSIS transformations such as Slow Changing Dimension, Lookup, Conditional split, Sort, Merge Join, Aggregate, and Execute SQL task etc.
• Generated reports using SSRS.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Scheduled monthly/weekly/daily reports to run automatically. Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Responsible for scheduling the subscription reports with the subscription report wizard. Deployed the generated reports directly on the client's workstation.
• Created Views and Indexed Views to reduce database complexities for the reports.
• Created DTS packages to transfer objects from development server to production Setup and maintained Linked Servers.
• Involved in developing test cases for Unit Testing.
• Used agile methodology (SCRUM) for the development.

Environment: MS SQL Server 2005/2008R2, SQL Server Integration Services (SSIS) 2008, SQL Server Reporting Services (SSRS) 2008, T-SQL, Visual Studio 2008, Erwin Data modeler, MS Office, Windows Vista

Confidential, Union, NJ

SQL BI Developer

Responsibilities:

• Involved in Requirements, Design, Development and implementation of the SQL Server Database.
• Performed Extraction, Transformation and Loading (ETL) using SSIS.
• Designed SSIS packages to migrate the data from Development Database to Application Database (OLAP).
• Designed Fact tables, Dimension tables and scheduled data transfer from real time database to data warehouse.
• Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages.
• Designed SQL SSIS Packages to extract data from various data sources such as FTP site, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Used Joins, Sub-queries for complex business queries involving multiple tables from different databases.
• Developed the reports using business intelligence development studio (BIDS) and SQL Server reporting services (SSRS) based on the business logic by implementing efficient stored procedures.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various format from (PDF, Excel) and resolved formatting issues.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Wrote complex T-SQL queries/Views to match data which came from different sources. Processed high volume data everyday using SSIS and efficient Stored Procedure.
• Extensively worked on Query Optimization and Performance Tuning of databases
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure completeness of batch processes, scripts and processes.
• Created standard report subscriptions, report snapshots and cache for better performance.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.

Environment: MS SQL Server 2005/2008, SSIS, T-SQL, Micro-Strategy, SSRS, C# within Script Task, XML, Windows 2003 Server, ERWIN

Confidential, Dublin, OH

SQL BI Developer

Responsibilities:

• Wrote complex T-SQL queries/Views to match data which came from different sources. Processed high volume data everyday using SSIS and efficient Stored Procedure.
• Implemented complex business logics to fulfill the reporting requirements of the business using complex T-SQL stored procedures and Views.
• Scheduled a job to run the whole process of getting the zipped files from the FTP site and then unzipping, staging, transforming and finally inserting into to the reporting DW tables.
• Designed SQL SSIS Packages to extract data from various data sources such as FTP site, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. Used Joins, Sub-queries for complex business queries involving multiple tables from different databases.
• Design and develop SSIS packages, stored procedures, configuration files, tables, views, and functions, implemented best practices to maintain optimal performance.
• Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
• Reduced the T-SQL overhead successfully by avoiding unnecessary joins, wildcard syntax & parsing using char index, pad index within the select statement to optimize the query performance.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Used Ad-Hoc queries to generate Reports using SSRS to meet ad-hoc requests from different client's needs. Created effective views for Micro-Strategy to generate reports.

Environment: MS SQL Server 2005, SSIS, T-SQL, Micro-Strategy, SSRS, C# within Script Task, XML, Windows 2003 Server, ERWIN

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in gathering Business requirements to implement functional and technical specifications.
• Involved in Data modeling, designing and building relational databases.
• Installing and Configuration of SQL Server 2003 instances.
• Created new tables, views, indexes and user defined functions.
• Developing T-SQL queries, triggers, functions, cursors, and stored procedures.
• Create the Database and manage the Database locations files and size.
• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Optimized query performance by creating indexes.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package.
• Created the SQL Scripts and Stored Procedures required for the Organization.
• Responsible for Logical and Physical design of SQL Server databases.
• Used DDL and DML for writing triggers, stored procedures, and data Manipulation.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries and Stored Procedures.
• Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures.
• Developed complex stored procedures to create various reports.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Performed Unit testing