OBJECTIVE

A versatile goal oriented developer with 8+ years of IT Experience in Database Design, Web Development and Business intelligence Development Studio(BIDS) of Microsoft SQL Server 2012/2008/2005 /2000 attaining Development, Test and Production Environments with various business domains like financial, judiciary and health care. SSIS/SQL Developer who excels at analyzing, prioritizing and completing tasks in a professional manner.

SUMMARY

• Over 8 years of SQL database experience in a high transaction and multi-server production environment, current experience with SQL 2012/2008.
• Expert Knowledge of Integration Services (SSIS), Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio. Experience in developing UML diagrams including Use Case diagrams, Class diagrams, Interaction diagrams, State diagrams and Deployment diagrams.

SQL Server Services

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• SQL Server 2012/2008/2005 /2000 RDBMS database development including T-SQL programming.
• ETL implementation using SQL Server Integration Services (SSIS)
• Developing reports on SSAS & SSRS on SQL Server ( 2012/2008/2005 /2000 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Experience in creating Pipeline Custom Component such as Error handling to get error description of failure.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Worked on OLAPData warehouse , Model ,Design, Implementation
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Experience in scheduling SSIS packages using SQL Server Agent and BAT file through ESP Scheduling Tool.

Stored Procedure

• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in using T-SQL in SQL Server 2000/ 2005/2008/2012 platform
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in writing complex T-SQL queries using Inner, Outer, Merge and Cross Joins.
• Experience in using Try Catch block introduced in SQL Server 2012/2008/2005 .
• Experience in using Transactions blocks in SQL Server 2012/2008/2005 .

Query Optimization and Tunin

• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Good Knowledge in managing Data and Transaction log files, Files Groups.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server

Database Design and Implementation

• Experence in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Good knowledge of System Development Life Cycle (SDLC).
• Good in implementing SQL Server Security and Process Control.
• Experience in Creating Roles and Assigning Permissions to the users.
• Good knowledge in SQL Server 2012/2008/2005 /2000 Client Server Architecture.

SKILLS

.NET Technologies

• ASP.NET 1.1/2.0/3.5/4.0
• ADO.NET 1.1/2.0
• C#.Net
• VB.Net
• VB
• C
• C++
• Java
• SQL
• PL/SQL.

Web Technologies

• HTML
• CSS
• JavaScript
• XML
• AJAX
• Web Services
• ASP 4.0
• MS SQL Server 2012/2008/2005 / 2000
• MS SQL Server Integration Services 2005/2008/2012 (SSIS)
• MS SQL Server Reporting Services 2008/2005 (SSRS)
• MS SQL Server Analysis Services 2005/2008(SSAS)
• Oracle 9i/10g
• ODBC
• OLTP
• OLAP
• SQL Server Management studio (SSMS)
• SQL Query Analyzer

GUI & IDE

• Visual Studio.NET 2003/2005/2008/2010.

Reporting Tools

• SQL Server Reporting services 2005/2008 and VB Macros Excel Report

Web Server Technologies

• IIS 5.1/6.0

Data Modeling Tool

• ERWIN 4.0
• Visio 2002

Operating System

• Windows 2000 Advanced Server
• Windows 2000 data center
• Windows NT
• Windows 95/98/2000/XP/2007

EXPERIENCE

Project Lead

Confidential

• Principle responsibility is to handle multiple applications and schedule meetings for review of all the task assigned to developers
• Analyzed, Designed and developed the core modules.
• Interacted with users to gather the business requirements.
• Initiating, monitoring & controlling of automation, integration & normalization projects
• Maintained and enhanced several Console, Windows and Web Forms Applications.
• Gathering functional requirements & translating into technical specifications
• Designed Enrollment process, Payment Details, Account Activity, Linking Multiple student functionality.
• Responsible for performance tuning, and optimization of procedures and queries.
• Developed a cross- platform activity feed client for the social software product.
• Organized and held meetings with stakeholders, contractor product teams and customers.
• Resolved customer issues by establishing workarounds and solutions and by debugging and creating defect fixes.
• Drafted detailed design objectives and developed architectural and system design documents.
• Communicated with back- end servers to provide real- time updated information.
• Involved in system design and for creating database Schemas.
• Creating complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications by using T-SQL.
• Extensively use T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Create SSIS packages with error handling.
• Creating complex SSIS packages using proper control and data flow elements.
• Deploying packages on different servers by configuring it.
• Creating T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key SQL performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for SQL RDBMS.
• Implement Complex business logic with User-Defined-Functions, Index Views and also create User Defined Data type, Clustered & Non-clustered Indexes.
• Integrate the SSIS package with the front end that requires .NET development on a large scale.
• Create several web pages and integrate the SSIS, SQL or OLEDB connections as per the requirement.
• Create several user controls, class files and also include WEB services if needed following the coding standards and the work flow.
• Use C# while scripting on the server side for the web pages.
• Create and update C# Script in SSIS packages Script Component according to the requirement.
• Contribute to the test and production environment of the project after the completion of the development work assigned.
• Create several batch files for scheduling the SSIS packages through ESP Scheduler.
• Collaborated with other team members on special projects and events.

Environment: SQL Server 2012/2008/2005 , BIDS 2008/2012, Microsoft Visual Studio 2012/2010, T-SQL, Windows 2007/XP Server, IBM DB2, CA Workstation

Sr. SQL Developer

Confidential

Accomplishments

• Principle responsibility is to implement support, maintain, monitor and tune high available and clustered database systems.
• Responsible for performance tuning, and optimization of procedures and queries.
• Made various Data Flow and Control Flow objects for the report linking with several Stored procedures, Views and Functions
• Effectively worked on Defect fixing, Making new web pages, Integration testing.
• Created Stored Procedures/Functions/Triggers/Views in SQL Server using T- SQL.
• Worked on Performance related Issues in SQL Server database
• Used CSS classes/skins for client side control UI formatting and provide same look and feel throughout the application.
• Used Switched Virtual Network (SVN) for source repository and version control.
• Made several Console Applications using Visual Studio 2010 to meet the requirements given
• Console applications related to sending daily reports to the client attaching the transaction details of the users
• Hosted different sub versions of the website using IIS 6.0
• Analyzed, Designed and developed the core modules.
• Designed Quotation, Policy, Banking Transactions and Message Screens.
• Creating complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications by using T-SQL.
• Extensively use T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Create SSIS packages with error handling.
• Creating complex SSIS packages using proper control and data flow elements.
• Deploying packages on different servers by configuring it.
• SSIS Development on a daily basis working on the control and data flows as per the requirements mentioned in specific documents assigned.
• Integrate the SSIS package with the front end that requires .NET development on a large scale.
• Create several web pages and integrate the SSIS, SQL or OLEDB connections as per the requirement.
• Create and update C# Script in SSIS packages Script Component according to the requirement.
• Contribute to the test and production environment of the project after the completion of the development work assigned.
• Create several batch files for scheduling the SSIS packages through ESP Scheduler.
• Collaborated with other team members on special projects and events.

Environment: SQL Server 2012/2008/2005 , BIDS 2008, Microsoft Visual Studio 2012/2010, T-SQL, Windows 2007/XP Server, IBM DB2, CA Workstation

Sr. SSIS/SQL Developer

Confidential

Accomplishments

• Developed and implemented SSIS ETL development standards and requirements.
• Analyzed project business document and discuss requirement with manager.
• Created pipeline custom component such as Error handling to get error description of failure.
• Created custom logging component to get logging info at task level.
• Instrumented and modified unit and integration tests to improve software quality and reliability
• Developed and maintained accurate network documentation and Visio diagrams to provide management with proper understanding of organizational needs.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Good knowledge of key SQL performance related features such as Query Optimizer, Execution Plans and Indexes.
• Executed and monitored standards for user interfaces, page design and graphics development.
• Developed web- site mock- ups for clients to ensure quality control and client satisfaction before project development phase.
• Auditing stored procedures for optimization and improving the performance tuning.
• Involved in extensive testing and debugging of all the modules coded.
• Expert in writing SQL code to avoid data flow components such as merge join, data conversion, aggregate transformation.
• Deployed SSIS packages from dev environment to testing environment using xml package configuration file.
• Expert in debugging SSIS packages using data viewer and break point.
• Traced user variables and system variables while running SSIS packages.
• Address any issues reported in conversion program testing and provide solutions in a timely manner.
• Used Cache transformation to cache lookup excel data and used in look up transformation.
• Created SSIS packages using data flow transformation such asderived column, conditional split, multicast, lookup, data conversion, Oledb command, union all etc.
• Expert in using control flow component while creating SSIS packages such as for each loop, execute SQL task, script task, sequence container, file system task etc.

Environment:

SQL Server 2008, BIDS 2008, Integration Services 2008, Microsoft Visual C # 2008 Express Editions, Microsoft Visual SourceSafe, T-SQL,Windows XP/2003 Server

SQL/SSIS Developer

Confidential

Accomplishments

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Analyzed, Designed and developed the core modules.
• Interacted with users to gather the business requirements.
• Deployed SSIS packages and Reports to Production Servers.
• Migrated data using ETL Tool in SSIS.
• Created partition table for very large database for good performance.
• Worked on Migration of packages from DTS using SQL Server Reporting Service (SSIS).
• Participated Databases Architecture and data modeling design.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Analyzed HP Quality Centre and create release name, release cycle and assign to test script folder
• Used VB macros to automate excel dashboard report.
• Automation of excel report to minimize manual effort.
• Analyze HP Quality Centre such as requirement to figure out linked and unlinked requirement.
• Analyze architecture on HP quality centre and linkage of backend oracle database to generate SQL.
• Provide data and solutions to IT BA and testers to quickly figure out linked and unlinked requirement.
• Discuss requirement with business analyst and testing manager to create report.

Environment: SQL Server 2008/2005, BIDS 2008/2005, Integration Services 2008/2005, Microsoft Visual Studio 2008, Oracle 9i/10g,HP Quality Centre 10, T-SQL,PL/SQL,Windows XP/2003 Server

Confidential

Accomplishments

• Analysis of Business design document.
• Involved in requirement gathering, design and development.
• Created table scripts, stored procedure in SQL server Database
• Created SSIS packages to load data from excel text files to data warehouse.
• Extensively designed the packages using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Foreach loop Container, File System Task and Script Task in SSIS Designer.
• Used an Execute SQL Task to retrieve the rowset into SSIS Object variable.
• Used Select statement in the execute SQL Task with Full Result set and assign result to Object variable in Result set tab.
• Used a Foreach Loop Container with the Foreach ADO Recordset enumerator to loop over Object typed SSIS variable.
• Created string variables - one for the full source pathname, and one for the full destination pathname and set both to EvaluateAsExpression.
• Used variable properties to write an expression to the source path plus the filename variable into the source pathname variable and similar expression for the destination pathname variable.
• Used File System Task inside the Foreach Loop Container to copy or move files and set the source and destination to variables.
• Implemented various business logic classes in C# and ADO.NET.
• Involved in system design and for creating database Schemas.
• Used ADO.NET objects for database communication.
• Design and development of user controls in the web page.
• Responsible for documenting and providing the help system for the new users.
• Created several ASP.NET pages with code behind in C#.
• Used stored proc in execute sql task for inserting unmatched variable data in sql server table by passing variable valuesby using parameter mapping as an input.
• Created EventHandler for OnPreExecute and OnPostExecute in the first and lasttaskof SSIS Package and put script task inside the EventHandler to get startDate and EndDate variable value
• Deployed the SSIS Packages from development server to production server.
• Documentation for all kind of stored procedure, scalar valued function and SSIS packages

Environment:

SQL Server 2008/2005, BIDS 2008/2005, Microsoft Visual Studio 2008, Integration Services 2008/2005, Oracle 9i/10g, T-SQL, Windows XP/2003 Server

Sr. SQL/SSIS Developer

Confidential

Accomplishments

• Analysis of SDLC Scope and high-Level Business Requirements document.
• Discussed requirement for each asset types from business analyst.
• Involved in requirement gathering, analysis, design, development, change management,
• Involved in conversion of business requirements into functional requirement.
• Developed source to target specifications.
• Created table scripts, scalar valued functions, stored procedure in SQL server Database
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Used functions to integrate module from existing application to enhance performance
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS Created a web service to Export the data from sql server to web.
• Created several web pages for fixing several issues using ASP.net, C#/VB.Net, JavaScript, AJAX, and SQL as back end.
• Created user controls (.ascx) and reused them in several ASP.NET pages.
• Involved in importing and exporting files to and from BarraOne system.
• Combined data flow of each asset types into single SSIS package and integrate with existing application
• Created several lookup tables and updated couple of existing lookup tables.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SSIS.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting.
• Modified and redesigned existing database by adding tables and relationships in the development database.
• Created complex TSQL queries to retrieve data from tables as per requirement.
• Data conversion from Excel File into SQL Server Table.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Tested the data with complex queries, joins and sub queries.
• Deployed the SSIS Packages from development server to production server.
• Documentation for all kind of stored procedure, scalar valued function and SSIS packages

Environment:

SQL Server 2008/2005, BIDS 2008/2005, Microsoft Visual Studio 2008, Integration Services 2008/2005, Oracle 9i/10g, Perl scripting, T-SQL, MS Access, BarroOne, Windows XP/2003 Server

Sr. SQL/SSIS Developer

Confidential

Accomplishments

• Created SSIS packages to clean and load data to data warehouse.
• Created package to transfer data between OLTP and OLAP databases.
• Used ADO.NET objects for database communication.
• Design and development of user controls in the web page.
• Responsible for documenting and providing the help system for the new users.
• Created several ASP.NET pages with code behind in VB.NET
• Created SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created a table to save dirty records.
• Extracted data from oracle to load to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Used Notification services to generate error messages and send them to the user through e-mails.
• Reviewed and adjusted deliverables involved during SDLC involving database changes/development.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Provided knowledge transfer to the company’s SQL programmers.
• Involved in system design and for creating database Schemas.
• Created and tuned stored procedures, triggers and tables.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs and System stored procedures.
• Experience in using update statistic and run Sp Recompile for the table to test the table script

Environment:

SQL Server 2008/2005, BIDS 2008/2005, Integration Services 2008/2005, Oracle 9i, Microsoft Visual Studio 2008, Visual SourceSafe, T-SQL,Autosys, MS Access, Windows XP/2003 Server

SQL Server DBA/Developer

Confidential

Accomplishments

• Responsible for the systems study, analysis, systems design and database design, ER modelling, coding, testing, implementation and documentation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Developed ER Diagrams using Erwin 3.5.2.
• Migrated data from the MS Access database.

Environment:

SQL Server 2000/2005, BIDS 2005, Integration Services 2005, Oracle , Perl , T-SQL, MS Access, Windows XP/2003 Serve