SUMMARY

• 7 years of SQL Server Development experience, Stored Procedure/TSQL coding, Physical and logical Database Design.
• Experience in writing complex SQL queries involving multiple tables, inner and outer joins, and stored procedures.
• Experienced in generating SQL server Reports using SSRS 2012.
• Migrated/Upgraded DTS packages from SQL Server 2000 to SQL Server 2008.
• Highly Proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Functions.
• Experienced in developing T-SQL (DDL, DML) statements, Data Integrity (constraints).
• Created complex DTS Packages in SSIS for Data Migration from Access/Excel Sheets to SQL Server 2008/2012 and Transformation.
• Experienced in creating Tables, Views, Indexes, Replication, and other SQL joins and query writing.
• Skilled in using tools like Bulk Copy (BCP) and Data Transformation Services (DTS) and SSIS with MS SQL Server 2008/2012.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Hands-on experience with Erwin and strong knowledge of Relational database modeling and Dimensional database modeling concepts.
• Experience of Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases.
• Capable of forming and maintaining positive and productive working relationship sin internal/external team environments.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Programming: T-SQL, PL-SQL, C, MYSQL

Database: MS SQL Server 2012/2008R2/2005/2000, MS Access

Reporting Tools: SQL Server Reporting Services (SSRS), MS Access, MS Excel, Crystal Reports.

Operating Systems: Windows 2008 R2, Windows NT 2000/2003 Server, Windows XP/7.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

SQL Developer/Production Support

Responsibilities:

• Responsible for maintaining production database, supporting development and testing environment.
• Upgrade/Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using SQL Server 2000 Package Migration Wizard.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, sub reports etc.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Extensively worked on Transformations for data loading as well as data validations. Designed and developed processes to identify the data errors and provided suggestions to resolve the data issues.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Building SSIS packages and Manage ETL operations for large data.
• Worked with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL and reporting needs.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers.

Environment: MS SQL Server 2008 Visual Studio, MS SQL Server 2000/2008R2 SQL Integration Services, SQL Query Analyzer, Import & Export Wizard.

Confidential, ST. Paul, MN

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Created SSIS packages to extract, transfer and load data into the data ware house on a daily basis.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012, Flat files etc.
• Worked on Drill through Report links and Hyperlinks to jump to other reports and web pages using Microsoft SQL Server Reporting Services (SSRS).
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• Expert Knowledge of Integration Services (SSIS) and Reporting Services (SSRS). Worked Extensively on ETL process using SSIS packages.
• Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.

Environment: MS SQL Server 2012/2008R2 SQL Integration Services 2012, MS SQL SSRS, SSIS, Windows 2003 Advanced Server.

Confidential, Eden Prairie MN

SQL Developer

Responsibilities:

• Gathered requirements from business users.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008 using DTS Packages.
• Built different types of chart reports for the business requirement like column chart, Pie Charts using MS SQL Server Reporting Services (SSRS).
• Created reports to retrieve data using Stored Procedures that accept parameters.
• And also Converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports.
• Created Stored Procedures for reports and developing reports using Crystal Reports. Maintaining proper Documentation of the reports for future reference.
• Created crystal reports with multiple drilldown and Sub-reports.

Environment: MS SQL Server 2008, MS Access, DTS, Erwin, Crystal reports 11x, SQL Query Analyzer, SQL Developer.

Confidential, Atlanta, GA

MS SQL Server Developer

Responsibilities:

• Performed Installation, Configuration and Maintenance of MS SQL Server 2008.
• Extensively Involved in Designing models of Database.
• Involved in designing and implementing databases for various SQL staging areas.
• Performed extensive database scrubbing in application to bring the database into consistency by removing duplicate records, removing marked for deletion records, and correcting various referential extensive use of T-SQL scripts.
• Applied business intelligence to perform extensive Data Scrubbing on existing data to meet new business requirement; automated the process for new records with exception report generation to maintain data quality and consistency.
• Created a batch processing to prepare data in staging area for final migration of application by applying various business logics into stored procedures, functions, and other SQL objects.
• Analyzed data for quality and consistency, as well as troubleshoot data errors.
• Rigorously tested and debugged all the scripts to test the validity of the data after the export/import/delete was completed.
• Performed intensive Data Quality Testing on various Data Migration processes and wrote various post scripts to perform data correction using T-SQL.
• Extensively used running jobs in Enterprise Manager using job-scheduling tool.
• Tested the data and data integrity among various sources and targets.
• Associated with Production support team in various performances related issues.

Environment: MS SQL Server 2008 Enterprise Edition, MS Access, DTS, Query Analyzer, BCP, SQL Profiler, Erwin 4.1, Business Objects 6.5, Import & Export Data, Windows 2000 Server.

Confidential

SQL Server Developer

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management, implementation of version control with Visual Source Safe.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Tested to optimize the procedures and triggers to be used in production.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Wrote user requirement documents based on functional specification.
• Managed Windows NT Server logins, folder permissions, and Share permissions.
• Created indexes, Constraints and rules on database objects for optimization.

Environment: MS SQL Server 2005, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer.