PROFESSIONAL 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, 2008R2, 2005.
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• 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 using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, script components.
• Experience in various Extracting, Transforming and Loading (ETL) data flows using SSIS with complex integration of SQL with Oracle, flat file sources, MS Access
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, DTS Packages, Bulk Insert and BCP, SSIS)
• 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.
• Proficient in migrations of earlier versions of SSRS reports to new 2012 formats.
• 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)
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• 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.
• Proficient in Debugging, Testing, Deploying Complex Stored Procedures and different Database Objects across various SDLC environments.
• Good hands on Experience on Performance tuning
• 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: SQL, T-SQL, PL/SQL, .Net (C#, VB)

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: DTS, SSIS, BCP, Import/Export Wizard, BI Studio

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Sr.SQL BI Developer

Responsibilities:

• Interacted with Business Analysts and Developers in identifying the requirements, designing strategies and implementation.
• Good experience working in Agile Environment and Rally Ticketing Systems.
• Developed and maintained stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs and C# code as required.
• 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.
• Experienced in slowly changing dimension in 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 2008R2 DTS 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 packages
• 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.
• Responsible for fine tuning of the database, troubleshooting, memory management
• Worked on Performance tuning by optimizing the queries, and created useful Indexes.
• Created reports based on database usage and perform capacity planning.
• 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.

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

Confidential, Austin, TX

SQL/BI 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.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Performed activities like creation and indexing of the tables.
• 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. Identified the Data Source and defined them to build the Data Source Views.
• 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.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Created Views and Indexed Views to reduce database complexities for the reports.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created DTS packages to transfer objects from development server to production Setup and maintained Linked Servers.
• Involved in developing test cases for Unit Testing.

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

Confidential . Union, NJ

SQL Server SSIS/SSRS 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
• Design and develop SSIS packages, stored procedures, configuration files, tables, views, and functions, implemented best practices to maintain optimal 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.
• 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 Server 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

ENVINORMENT: Windows 2003 Advanced Server, MS SQL Server 2005, MS Outlook, T- SQL, Erwin,, SSIS, SSRS,VB