Summary:

• Over 8 years of IT Experience in Analyzing, Database Designing, Tuning, and Developing Client/Server, Business Intelligence BI database applications and various segments of Software Development Life Cycle SDLC , using, MS SQL Server 2012/2008/2005/SQL Server Integration, Reporting Analysis Services.
• Extensive experience in Database design and development of applications using SQL Server 2005/2008R2/2012, Integration Services SSIS , Reporting Services SSRS .
• Knowledge of SQL Server Analysis Services SSAS , MDX queries, OLAP Cubes, Star schema and Snowflake schema.
• Experience in Huge Data Migrations, Transfers using utilities like SSIS, Bulk Copy Program BCP and Bulk Insert.
• Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files. Expertise in Unit Testing, Functional Testing, System Integration Testing, Review Test Cases and Test Results.
• Knowledge in Job Scheduling, Replication, Performance Tuning, Normalization/De-normalization concepts, database design methodology.
• Ability to define and develop Report Structure with Data Definition, Report Layout and Report Definition Language.
• Extensive experience in creating several reports such as Drill Down Reports, Parameterized Reports, Linked Reports, Sub Reports, Matrix Reports and Chart reports using SQL Server Reporting Services.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit Issues as per Standards.
• Excellent in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.
• Involved in the complete Data Warehouse Development Life Cycle. Actively supported business users for change requests.
• Excellent in High Level Design of ETL - SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources Excel, CSV, flat file, Text Format Data by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Generated multiple Enterprise reports and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports Hyperlink etc.
• Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting
• Experience in generating On-demand and Scheduled Reports for Business Analysis or Management Decision using SQL Server Reporting Services.
• Excellent hands on experience Scheduling and the Deployment of the reports and uploading files to a Report Server Catalog from the Report Manger.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill and project oriented team player.

Skill Summary:

Professional Experience:

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed stored procedures, User Defined Functions, Triggers, Views, Cursors, CTE's, T-SQL scripts schemas, permissions and performance issues.
• Worked on huge data sets and live databases.
• Developed SSIS packages for data integration.
• Developed different kind of reports such as Sub Reports, Charts, Matrix and Linked reports while using cascaded parameters to generate reports from two different Data Sets about potential risks and benefits of probable locations of new branches.
• Performed Database Administration activities.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
• Closely worked with Business to better understand the requirement.
• Extensively used Joins and Common Table Expressions CTE to simplify complex queries involving multiple tables.
• Worked on different transformations like merge join, look up, Conditional Split, Union all, Script Component, Aggregate, Data Conversion etc.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder. Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked on Visual Studio Team Foundation Server VSTF .
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Participated in Business Requirement document reviews, Code Reviews and support.
• Developed SQL scripts to Insert, Update, Delete and Merge data in the database tables along with SQL Joins.
• Performed T-SQL performance tuning and Query optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Created packages in SSIS to import data from production for Ad-hoc reporting.
• Created roles in SQL and Analysis Services databases to restrict the access to specific objects.
• Involve in creating the builds and preparing patches to the builds and release them to the appropriate Testing Environments using VSTF.
• Participated in document reviews, Code Reviews and support.
• Created Report Subscription and Data Driven Subscription and Job Scheduling using SSRS 2008.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: SSRS 2008/2012, DTS, T-SQL, OLAP Service, Visual Studio 2005, SQL Server Profiler, Windows Sever 2003/2008, Share point, SQL Server Management Studio, Erwin, SQL Server Business Intelligence Development Studio BIDS

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specification.
• Identified various data sources, formulated data dictionaries, design and develop data models physical/logical data models based on the given specs and requirements.
• Involved in designing and implementing database applications using MS SQL Server 2005/2008 and Business Intelligence BI tools to support transactions and business decision-making.
• Developed complex T-SQL code for the application.
• Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Created various database objects such as tables, indexes and views based on the requirement.
• Implemented constraints on tables.
• Designed drill down, parameterized reports, linked, and cascaded parameterized reports using SSRS.
• Created various kinds of reports like Aging reports.
• Automation of creating Accounting code module for each bill.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Used different Transformation in SSIS as per design specifications.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.
• Wrote complex T-SQL queries for data extraction.
• Created DTS/SSIS packages to transfer data from heterogeneous database different files format Text File, Spread Sheet to SQL Server.
• Created stored procedure for generating reports using SQL Server Reporting Services SSRS .
• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Created Report Subscription and Data Driven Subscription using SSRS 2008.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Monitor and provide support to the application during the testing and production environments

Environment : SQL Server 2008/2005, SSRS SQL Server Reporting Service , SSIS SQL Server Integration Services ,Business Intelligent Studio, SQL Server Management Studio, ASP, Crystal Report, Enterprise Manager, MS Excel

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams Physical and Logical using Erwin and mapped the data into database objects.
• Developed stored procedures, functions, views and triggers.
• Created SSIS packages to extract data from OLTP to datamart and Scheduled Jobs to call the packages and Stored Procedures.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• 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.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Created indexes, constraints and rules on database objects.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Experienced in making technical specifications report by gathering information from end user.

Environment: Windows XP Professional, SQL Server 2008/2005,SQL Reporting, Business Intelligence Studio, Visual Studio 2008/2005, ADO.Net, OLE DB, DTS Package, SSIS.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Gathered requirements and design of data warehouse entities.
• Conduct code walkthroughs and review peer code and documentation.
• Created and maintained the Data Mart for different LOB.
• Fine-tuned of database objects and server to ensure efficient data retrieval.
• Developed complex programs using T-SQL queries, including Procedures, Triggers, and Functions.
• Used Visio for diagramming in the design phases.
• Build efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 and type 2 changes.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Designed and developed SSIS packages, designed stored procedures, configuration files, tables, views, and functions.
• Created SSIS log files and configuration files to store configuration and to log execution of packages.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Performed Data Migration from SQL Server 2000 to SQL Server 2005.
• Assisted in defining Query for generating Drill Down reports in SSRS.
• Developed SQL Server Integration Services SSIS packages to transform data from various data sources to MS SQL 2005.
• Experience in using global variables, expressions and functions for the reports.
• Experience in handling parameterized reports in SSRS.
• Deployed packages from one environment to another Development to testing to production .
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries. Oversaw unit and system tests and assisted users with acceptance testing.
• Implemented best practices to maintain optimal performance and optimized SQL queries for maximum efficiency.
• Performed documentation of standards, best practices, and ETL procedures
• Work with developers, DBA, and systems support personnel in elevating and automating successful code to production.
• Provided on-call support to production system to resolve any issues.

Environment: Windows 2007 server, Windows 2003 Server, Rational Clear Quest SSIS 2005, DTS, Oracle 9i/10g, SQL Server 2005, MS Access, T-SQL, PL/SQL, SQL, Erwin 4.2, SSRS

Confidential

SQL Server SSRS Developer

Responsibilities:

• Have used SQL Server 2005 Integration Services SSIS transformations in the data flow of a package to aggregate, merge, distribute, and modify data. Performed Data Cleansing and Profiling using Transformations in Packages.
• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Building a Dimensional Data Model, Testing, Implementation, Debugging Maintenance of applications
• Used the SSIS ActiveX script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Helped designing the ETL Specifications document and naming conventions for the project.
• Designed SSIS Packages to transfer data between servers, load data into database Scheduled the jobs to do these tasks periodically
• Created SSIS packages for application that would transfer data among servers and perform other data transformations.
• Involved in migration of DTS packages to SSIS
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Handled performance tuning to optimize SQL queries using query analyzer
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
• Used .NET Provider Data Reader Source Task to Read from RDBMS sources.
• Worked on XML Web Services Control Flow task to read from XML Source.
• Performed Unit Testing and Prepared maintenance plans.

Environment: Windows 2000 Server, Windows 2003 Server, IBM Rational Clear Quest, SSIS 2005,Oracle 9i/ 10g, SQL Server 2005,T-SQL, PL/ SQL, Triggers, Packages Stored Procedures, Erwin 4.2, SSRS.