PROFESSIONAL SUMMARY:

• Over 9 years of extensive experience in IT industry as SQL Developer in MS SQL Server 2012/2008R2/2008/2005/2000/7.0 in Production, Quality Development environments.
• Worked on Software Development Life Cycle SDLC , data modeling, business analysis, and data warehouse.
• Experienced in Database design using Normalization Forms, Entity Relationship Design ERD model and application oriented design.
• Proficient in design of logical and physical data modeling using Erwin, VISIO data modeling tool.
• Hands on experience in writing, testing unit testing and debugging stored procedures, triggers and troubleshooting database issues.
• Experience in implementing different types of Replication models like Snapshot, Transactional and Merge Replication.
• Experience in SQL server 2012/2008R2/2008/2005 Installation, Monitoring, Backup, Restoration, Disaster recovery planning and High Availability Strategies.
• Experience in ETL Extraction, Transformation and Loading using Data transfer services DTS , Service Broker and SQL Server Integrated Services SSIS from various Data sources.
• Efficient in building recursive queries using CTEs Common Table Expressions .
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys Foreign Keys.
• Expert in creating Database Objects Schemas, Tables, Indexes clustered and non clustered , Views, User defined functions UDFs , Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Expertise in developing Transact-SQL scripts for reuse in normalizing incoming files along with creating SQL queries, ad hoc queries to produce custom data extracts.
• Experience in query optimization SQL tuning using SQL Profiler, Database Tuning Advisor DTA , Index tuning wizard and Performance monitor for performance tuning.
• Experience in building SSIS packages .Dtsx involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in developing, configuring and deploying the SSIS packages and providing security for the packages.
• Expert in developing T-SQL DDL, DML statements, Data Integrity constraints , Rules, Performance Tuning, Query Optimization and Data Validation issues.

• Expertise in managing project versions and source code changes using source control tools like Visual source safe.

• Hands on experience in dealing data with different databases like Sybase IQ, Oracle 8i/ 9i/10g, SAP and developing ad hoc queries from Distributed Databases.

• Expert in creating SQL Reports using SSRS and defining queries for generating drill down reports and embedding then into web services in .Net.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SSRS.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr SQL Server SSIS/SSRS Developer

• Worked on Full life cycle development SDLC involving in all stages of development.
• Designed the process for Payments, Content Providers and Accrual for Comcast finance team.
• Created SSIS Packages and SSRS Reports for Comcast Accrual and Payment process.
• Worked and lead the off-shore team in all phases of the project development.
• Created Database Objects Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex Stored Procedures using SQL, Dynamic SQL queries having good performance.
• Extensively used Joins, CTEs, Table Variables, Global and Local Temp Tables.
• Developed complex SSIS packages to load the data from SQL Server, Oracle databases.
• Used various transforms in SSIS to load data from flat files and FTP to the SQL databases.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Worked on migration of SSIS packages in 2008 to 2012.
• Involved in day-to-day maintenance of database Objects, SSIS packages and SSRS Reports.
• Provided Index tuning as required for performance improvement of the applications SQL tuning .
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Worked with scheduling and publishing of reports in SQL server reporting services and integration with Microsoft Office tools like automatically emailing reports in various formats such as Excel, PDF etc.,
• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user's requirements.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
• Designed, tested unit testing and integration testing and implemented stored procedures and triggers for data processing of huge volume of data.

Environment: MS SQL Server 2008/2008R2/2012 on windows 2007/2012 server, IIS, Visual studio, SSIS, SSRS, Framework Manager, BIDS, SQL Server Data Tools, SSMS.

Confidential

Role: Sr SQL Server SSRS/SSIS Developer

• Worked on Full life cycle development SDLC involving in all stages of development.
• Managed project versions and source code changes by check in and checkout using source control tools like TFS, Visual source safe
• Created Database Objects Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex Stored Procedures using SQL, Dynamic SQL and MDX queries having good performance.
• Extensively used Joins, CTEs, Table Variables, Global and Local Temp Tables.
• Developed complex SSIS packages to load the data from SQL Server, Oracle and DB2, MS Access databases.
• Used various transforms in SSIS to load data from flat files and FTP to the SQL databases.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Worked on migration of dts and SSIS packages in 2005/2008 to 2012.
• Involved in day-to-day maintenance of database Objects, SSIS packages and SSRS Reports.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Regular responsibilities for updating, staging and dimensional databases using ETL as well as rebuild the Dimensions and Cubes in SSAS
• Implemented the concept of dynamic reporting using common templates for multiple reports.
• Migrated Cognos Reports code to SSRS using Cube as the Source.
• Worked with scheduling and publishing of reports in SQL server reporting services and integration with Microsoft Office tools like automatically emailing reports in various formats such as Excel, PDF etc.,
• Good Knowledge of Installation and Configuration of Clustered Servers in Active/Passive and Active/Active mode.
• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user's requirements.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
• Designed, tested unit testing and integration testing and implemented stored procedures and triggers for data processing of huge volume of data.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
• Provided Index tuning as required for performance improvement of the applications SQL tuning .

Environment: MS SQL Server 2008/2008R2/2012 on windows 2003/2007 server, IIS, Visual studio, SSIS, SSAS, SSRS, Database Mirroring, Replication, log shipping, Cognos Report Studio, Framework Manager, BIDS, SQL Server Data Tools, SSMS.

Confidential

Role: Sr SQL Server SSIS Developer

• Worked on Full life cycle development SDLC involving in all stages of development.
• Created and maintained Databases for development, testing and production environments.
• Managed project versions and source code changes by check in and checkout using source control tools like TFS, Visual source safe and clear case.
• Created Database Objects Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Extensively used Joins, CTEs and Sub-Queries to simplify complex queries involving multiple tables.
• Developed complex Stored Procedures using Dynamic SQL and MDX queries.
• Developed complex SSIS packages to load the data from SQL Server, Oracle, DB2 and Hyperion databases.
• Used various transforms in SSIS to load data from large flat files via Network and FTP to the SQL databases.
• Worked on complex SSIS packages loading the Data Warehouse from Staging.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Wrote stored procedures and User Define scalar Functions UDFs to be used in the SSIS packages and SQL scripts.
• Diagnosed the health of servers and databases using Server related, Database related and index related Dynamic Management views DMVs .
• Good Knowledge of Installation and Configuration of Clustered Servers in Active/Passive and Active/Active mode.
• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user's requirements.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
• Involved in building business objects and data accessing from SQL databases using ADO.NET.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Designed, tested unit testing and implemented stored procedures and triggers for data processing of huge volume of data.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Created Linked Servers for building Distributed queries using OLE DB data sources.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
• Provided index tuning as required for performance improvement of the applications SQL tuning .
• Created parameterized, drill down, drill through and aggregation type of reports in SSRS.
• Applied Security to Web Server and Database Server that affects SSRS Report server installation and managed role-based security to reports and reporting resources.
• Designed developed and deployed SSRS reports in MS SQL Server environment using SSRS and rendered them to HTML, XML, PDF and Excel formats.

Environment: MS SQL Server 2008/2008R2 on windows 2003/2007 server, IIS, Visual studio, SSIS, SSAS, SSRS, Database Mirroring, Replication, log shipping, Cognos Report Studio, Framework Manager, BIDS, SQL Server Data Tools, SSMS.

Confidential

Role: Sr SQL Server SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages for transferring data from various data sources like SAP R3 system, Oracle, MS Access, Excel, .Txt file, .CSV files.
• Involved in database designing using Normalization.
• Exported reports to various formats like PDF, Word and Excel.
• Involved in security and user role assignment to different reports.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
• Converted Non-Unicode data from different databases into Unicode data and move the data to staging databases.
• Migrated databases from SQL Server 2005 to SQL Server 2008.
• Studied the existing OLTP system s and created facts, dimensions and star schema representation for the data mart.
• Created tables, stored procedures, views, functions, and triggers using T- SQL.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Responsible for creating batch files and scheduling the jobs.
• Experienced in analyzing the Dashboards, including Action Items, KPI's.
• Involved in analyzing Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services SSRS .
• Involved in preparing detailed technical documents.

Environment: MS SQL Server 2008,SAP ECC, SSIS 2008, SSRS 2008, SSAS 2008, DTS, T-SQL,OLAP Service, Visual Studio 2005, ASP.NET, SQL Server Profiler, Erwin Data Modeller 7.2, Windows Sever 2000/2003/2008R2, SQL Server Management Studio, SQL Server Business Intelligence Development Studio BIDS .

Confidential

Role: MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Extensively used T-SQL in constructing user functions, views, indexes.
• The Tasks involved writing lot of T-SQL code, including use of complicated joins and cursor loops.
• Created Complex Stored Procedures, Views and functions and other statements for various Applications, maintained referential integrity and implemented complex business logic.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Joins, Database links and formatted the results.
• Involved in translating business requirements into technical design specifications.
• Converted Complex business logic into SQL Stored procedures and User-defined functions to achieve functionality required by the UI team.
• Created and generated reports to display data.
• Developed complex T-SQL code for the application conversions.
• Developed XML file Parsing in SSIS.
• Validate change requests and made appropriate recomendations.standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Developed and Involved in optimizing Stored Procedures and queries for faster retrieval and Server efficiency.
• Involved in mock testing and Unit testing in SSIS.
• Created Automated Stored procedure for day end operation using SQL Server agent.
• Coordinated with Front-end for implementing logic in stored procedures and functions.
• Performance Tuning of SQL queries and Stored Procedures using SQL Profiler and Index Tuning.
• Automate tasks using active X script.
• Developed Query for generating drill down reports in SSRS 2008 prepared AD HOC reports through report builders.
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Handling the change requests and estimating the work efforts.

Environment: SQL Server 2008 R2, SQL Server 2008, Windows 2003/2000, VBScript,VB.Net, ASP.Net, HTML,SSIS, SSRS, XML.

Confidential

Role: SQL Server/SSIS Developer

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created data-related documentation e.g., file descriptions and definitions, entity relationships and attributes .
• Deploying new Database objects in production environment.
• Designed new SSIS packages and deployed them.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Writing Stored Procedures, Triggers, Cursors and creating indexes.
• Fixing Bugs and Automating jobs.
• Testing and loading the data on Development and Production.
• Created DTS Package designs for Import/Export from different servers like oracle to SQL Server. Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Created user defined data types and added them to model database for future purpose.
• Worked on Authoring Reports and managing reporting services.
• Logical and physical database design using ERwin Tool.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.
• Performing query plans and making sure each query is using appropriate indexes.
• Provided on - call 24/7 provide support.
• Provided support for in-house and off-shore Development Team.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL, Enterprise Manager, T-SQL, ERWIN 4.0, XML, MS PowerPoint, MS Project Windows 2003 server.

Confidential

Role: SQL Server Developer

Responsibilities:

• Responsible for designing data model for staging database and implementing.
• Creating application specific server logins and granting access to appropriate databases.
• Designed and developed an approach to consolidate data from multiple source entities into single flat file.
• Responsible for implementing the ETL Extract Transform Load process.
• Designed and developed dynamic SSIS packages to process dynamic queries and dynamically produce flat files at runtime.
• Created web service to enable the remote execution of the SSIS from the database server.
• Integrated the web service with web application to allow users to kickoff the extraction process from intranet/internet web application.
• Created user access module to allow specific group of users to be able to login to the intranet/internet system and submit the data extract request.
• Responsible for creating new SSIS packages and maintaining existing SSIS packages which are used for data load.
• Extensively used SQL Server Profiler to debug the application execution flow and dynamic queries being executed against the database.
• Effectively handled hacking and SQL injection attacks on database application.
• Implemented effective error handling to notify the support person about any errors raised in SSIS package during the extraction process by sending emails with complete error details.
• Created views to retrieve data from one or more tables.
• Creating indexes on existing tables and updating the existing indexes over a period of time.
• Creating and debugging SQL stored procedures.
• Extensive T-SQL development to create stored procedures and user access control.
• Finding bottle necks in queries and stored procedures and fine tuning.
• SSIS packages extracts data from different sources each time and produce different output files and uploaded to different FTP folders. The options selected by user determine the files to be produced and queries to be executed.
• Used Serena PVCS for version controlling.
• Publishing the actual and plan data from Cognos Planning cubes into SQL Server database.
• Synchronizing the Dev and Model databases of Cognos Planning from Production.
• Testing and bug fixing before moving the application to Production.

Environment: SQL Server 2005, ASP.NET, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Business Intelligence Development Studio BIDS , Management Studio, Transact-SQL, MS Excel, Excel VBA, .NET framework 2.0, Web Services, TextPad, Live Meeting and Windows XP/2003.

Confidential

Role: SQL Server Developer

Responsibilities:

• Responsible for analyzing the requirements, designing the data flow and development of DTS components and business logic
• Responsible for preparing the requirement, specification and technical documents and reviewing the documents
• Implemented the ETL process to Extract data from flat files, transform and load into SQL server data base
• Responsible for testing the deliverables at off-shore and fixing the bugs that are uncovered during testing
• Implementing efficient error handling mechanisms to handle most of the errors that can occur during execution
• Implementing process improvement mechanisms by identifying the bottle necks in the application
• Developed VB Script and Scheduled the DTS packages using SQL Server Agent
• Preparing test cases in all possible scenarios and executing test cases and documenting the test results
• Training the support team on how to use the DTS Packages
• Worked individually and also responsible for the delivery

Environment: MS SQL Server-2000, Enterprise Manager, Query Analyzer, Profiler, Data Transformation Services DTS , Transact-SQL, ODBC, VB Script and Windows XP/2003.