Professional Summary:

• 8.5 years of strong MS SQL Server Developer experience in Retail, Insurance, Telecommunications, and Banking domains with expertise in MS SQL Server 2012/2008/2005/2000 suite of products like SSIS, SSRS and SSAS.
• Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2008/2005/ 2000 and Microsoft Access 2007-97 databases. Some experience with Oracle and MYSQL Databases.
• Proficiency as Teradata developer and strong expertise in SQL queries, stored procedures, Teradata Macros.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP , andSQL Server Integration Services SSIS 2005/2008 .
• Excellent in Teradata Data warehousing environment.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Experienced in Data Extraction, Transformation and Loading ETL between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008/2005.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process BCP , Data Transformation Services DTS and SSIS with MS SQL 2008/2005.
• Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services SSRS based onclient requirement.
• Expertise in developing and extending MS SQL Server Analysis Services 2008/2005 SSAS cubes, data mining models, deploying and processing SSAS objects, and writing MDX queries.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

confidential

SQL Developer/DBA:

Responsibilities:

• Automate complex business processes with SSIS package.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Develop SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic VB scripts.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Used differentControl Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed Event Types.
• Created SSIS package with variables and automate SSIS package to handle error with script and send mail task using SSIS 2008.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis..
• Working with business users on data analysis and reporting needs
• Implemented Framework for historical data cleanup for very large Database.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Created complex stored procedure and sql query to fetch data for reporting need. Fetch 50 million record on daily basis and load into qvd file with the help of Qlikview.
• Created data models with the help of qvd for VMU project..
• Load the data into QVD with Incremental load.
• Creation of different types of reports such as master/detail and cross tab for trend analysis. Designed and developed extensive Qlikview reports using combination of charts, different table types and gauges.
• Created program, customer tracking, NLAD, Review, recertification, state trackers, Intuit reports with the help of Qlikview.

confidential

SQL Server SSISand SSRS Developer:

Responsibilities:

• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services SSRS .
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Created and reviewed the conceptual model for the EDW Enterprise Data Warehouse with Business user
• Analyzed the source system to understand the source data and table structure along with deeper understanding of business rules and data integration checks.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Create automation process to archive historical data.
• Interacting with Onsite people, Taking clarifications regardingapplications
• Involved in writing SQL queries
• Analyzing the requirements and discussed with managers and leads on the functionality.
• Participate in Walk-through sessions with onsite people
• Designed and Implemented Tables, Functions, Stored Procedures and Triggers in SQL Server 2008
• Wrote the SQL queries, Stored Procedures and Views
• Built data connection to the database using MS SQL Server.
• Regression testing was performed after each new build of the application.
• Defect logging and Defect follow up in Team Track
• Have worked with Database testing and SQL queries and Preparing Status reports
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression CTE .
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Backup and restore automation using most recent backup archive. Developed an auto-restore process using TSQL.

confidential

Teradata SQL and SSRS Developer Subject Matter Expertise:

Responsibilities:

• Interacted with end users in identifying the requirements and developed a detailed design document including technical specification
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Used SSIS containers to load the multiple files with loops.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fast load while loading data into the target tables in Teradata Database.
• Did error handling and performance tuning in Teradata queries and utilities.
• Did data reconciliation in various source systems and in Teradata.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Used Teradata utilities fastload, multiload, tpump to load data.
• Involved in loading of data into Teradata from legacy systems and flat files using complex MLOAD scripts and FASTLOAD scripts.
• Write numerous BTEQ scripts to run complex queries on the teradata database
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL
• Wrote Teradata Macros and used various Teradata analytic functions.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports thus making them user friendly.
• Created report at all-time level hierarchy like hourly, daily, weekly, monthly, yearly.
• Created Holiday reporting with the crystal report 2011.
• Involved in creating multi-tiered and multithreaded applications using .Net framework.
• Analyzed the user requirements and defined technical specifications. Involved in all activities of Software Development Life Cycle SDLC .
• Participated in Requirement gathering and analysis to check feasibility of data and created physical and logical data models for walkthroughs
• Created data mover Job to refresh the data from production to Development on daily basis which helped the developer for quality analysis

1. Supported daily batches and worked on production issue and tickets based on priority.
2. Performance tuning, optimization of procedures and queries and also support, maintain, monitor and tune database systems.
3. Extensively worked with Teradata utilities like BTEQ, Fast Load, and export and load data to/from different source systems.
4. Good knowledge on Agile Methodology and the scrum process.

confidential

Application Architecture Designer and SSIS Developer

Tools and Technologies: MS SQL Server 2008, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Visual Studio 2010.

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Involved in creating multi-tiered and multithreaded applications using .Net framework and Developed Custom controls to enable Reusability and have good working knowledge with ASP.NET Web Server controls like Grid View, Data List and Repeater for displaying the records.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source Oracle , Excel Spreadsheet to SQL Server 2005/2008.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed Data Access Layer DAL using LINQ, invoked Database tables and stored procedures and Involved in Development of Data Access, Business and application layer using C .Net and ASP. NET MVC
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Designed and architected of cubes for building reports using SQL Server Business Intelligence Development Studio to support business reporting processes
• Developed, implemented and maintained various database objects such as Stored Procedures, Cursors, Triggers, Indexes and Views.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Worked on Structure exceptional handling of stored procedure by adding error handlers and updated application related stored procedure in team foundation server.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.

confidential

MS SQL/SSIS/SSAS Developer

Tools and Technologies: MS SQL Server 2008, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS .

Responsibilities:

• Assisted in Business Analysts to gather technical requirements.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL server Profiler.
• Created and managed SQL Server login, database users and Roles.
• Created proper Primary Index PI talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Loading data by using the Teradata loader connection, writing Teradata utilities scripts Fastload, Multiload and working with loader logs.
• Write numerous BTEQ scripts to run complex queries on the teradata database.
• Reduced Teradata space used by optimizing tables adding compression where appropriate and ensuring optimum column definitions.
• Worked on loading of data from several flat files sources to staging area using Teradata utilities like MLOAD, FLOAD, TPUMP.
• Worked on Tuning, and troubleshooting Teradata system at various levels
• Created various SSIS packages to transfer data from OLTP databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.
• Made SSIS package dynamic with variable and expression.
• Used various SSIS tasks for Data Scrubbing and validation checks while loading data to Staging.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports and also parameterized reports.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Modified existing reports according to requirements of the end users

confidential

MS SQL/SSIS/SSRS Developer

Tools and Technologies: MS SQL Server 2008, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS .

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Created Clustered and Non-Clustered Index to improve the access of data within the database.
• Involved in Performance tuning of the slow running queries and Stored Procedures.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Developed performance utilization charts, optimized and tuned SQL and designed physical databases. Assisted developers with Teradata load utilities and SQL.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata database. Wrote Teradata BTEQ and FASTEXPORT scripts to export data to various data marts.
• Done Query optimization explain plans, collect statistics, Primary and Secondary indexes Used volatile table and derived queries for breaking up complex queries into simpler queries. Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Created stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Developed and deployed data transfers packages to the appropriate destinations using SSIS
• Involved in restores of databases, troubleshooting security issues, performance issues, clustering, replication, monitoring of space utilization and adding space as required, Log shipping patching and installations. Applying the SQL Server Security updates into servers.

Confidential

MS SQL Server SSIS / SSRS Developer

Tools and Technologies:

MS SQL Server 2008 R2, SQL server Reporting Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Red-Gate Sql Source Control, MS Visio 2008, SQL Profiler.

Responsibilities:

• Assisted in Business Analysts to gather technical requirements.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created various SSIS packages to transfer data from OLTP databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic configuration packages in SSIS.
• Used various SSIS tasks for Data Scrubbing and validation checks while loading data to Staging.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Designed both logical and physical data models in Erwin r 7.2.

confidential

MS SQL Server SSIS/SSRS Developer

Tools and Technologies:

MS SQL Server 2008 R2, SQL server Reporting Services 2008, SQL Analysis Server 2008, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Responsibilities:

• Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.
• Generated reports on account information, detailed summary reports using adhoc reporting to be used by the clients and advisors.
• Created many complex database code objects such as Stored Procedures/ views/ Functions and used them in Reports directly to generate reports on the fly.
• Included 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.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression MDX to access them
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008 R2.

confidential

MS SQL Server / SSIS/SSAS/SSRS Developer

Tools and Technologies:

MS SQL Server 2005, SQL Server Reporting Services SSRS , MS Access, MS Excel, SSIS, BCP, T-SQL.

Responsibilities:

• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed, Managed, Monitored and Administered database and system perform-acne which included optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes
• Created SQL server Reports using SSRS 2005 for the manager and the brokers involved and formatted the report layout for the requirement of the end users.
• Monitored and explained plan assessment, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics Query Optimizer in both 2000 and 2005 for databases.
• Generated reports for end user requirements using SSRS.
• Deployed developed reports on to the server for the end users.

confidential

MS SQL Server Developer

Tools and Technologies:

MS SQL Server 2005, MS SQL Server Reporting service 2005, MS SSIS, T-SQL, Windows 2003

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects
• Designed data models using Erwin.
• Wrote user requirement documents based on functional specification.
• Developed source to target specifications for Data Transformation Services.
• Created functions, views and triggers for automation
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects for optimization.