SUMMARY

• Having 7+ Years of IT experience in design, development, testing, presentation, implementation and analysis ofSQLServer and SQL Server Business Intelligence tools (BIDS) - SSIS and SSRS.
• Good experience in TSQL, SSRS and SSIS.
• Extensive exposure in creation of databases, objects, stored procedures, triggers, security, SSIS (i.e. Import and Export), Bulk Loading of Data, Transact-SQL, andSQLServer Agent andSQLServer profiler.
• Domain knowledge in US healthcare insurance and Education.
• Expertise in developing Parameterized, Chart, Graph, Dashboard, Matrix Report using SSRS.
• Broad experience in database development, including effective use of database objects, SQL trace, execution plan, indexes, views and temporary tables.
• Experience in data migration through T-SQL Scripts.
• Extensive experience in Enterprise ETL process using SSIS
• Expertise in writing stored procedures, views, user defined functions and common table expressions.
• Experience in improving the performance of reports and T-SQL Queries.
• Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored procedures user Defined Functions and system Functions using SQL server, T-SQL
• Good experience in SQL server 2008 database development and data migration.
• Performed unit level testing based on unit test case document prepared from requirements.
• Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Good experience in resolving blocking and Dead Lock Issues by usingSQLcommands.
• Creating reports usingSQLReporting Service (SSRS) for Customized and Ad-hoc Queries
• Experienced in Coding, Unit testing, Deployment, Support and Maintenance of business applications using SQL Server 2005/2008R2/2012.
• Familiar with Software Development Life Cycle (SDLC) including requirements and programming
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Experience in working with Team Foundation Server & Visual Source Control (TFS & VSS).
• Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and communication skills.
• Strong analytical, problem-solving and organizational skills. Ability to handle multiple tasks and assignments concurrently in cross-functional teams and a flexible team player with excellent communication skills.
• Having good knowledge on sys tables and DMV’s.
• Have Good experience on temporary tables and table variables.

TECHNICAL SKILLS

DW/ETL Tools: MS SQL Server Integration Services (SSIS)

Reporting Tools: MS SQL Server Reporting Services (SSRS), Crystal Reports 2013, 2010, 2008

Databases: MS SQL Server 2012/2008 R2/2005, MS Access & Oracle 9i

Operating Systems: All version of Windows OS

Other Tools/Utilities: SQL server Management Studio(SSMS), Business Intelligence Development Studio(BIDS), SQL Profiler, File Zilla (for FTP Downloads), SQL Server Data Tools(SSDT)

Programming languages: C#.net, VB.net, Visual Basic 6.0, TSQL, PL-SQL, HTML, Java Script

Source Control: Visual Source Safe (VSS), Team Foundation Server(TFS)

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Developer

Environment: SQL Server 2012, C#, SSIS and SSRS, MSVisual Studio, Windows 2008 Server, DTS, MSExcel

Responsibilities:

• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Designed and developed ETL packages for extracting and loading the data into appropriate tables in the database usingSQLServer Integration Services (SSIS).
• Converted Data Transformation Services (DTS) applications toSQLServer Integrated Services (SSIS)
• Designed reports usingSQLReporting Service (SSRS).
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Involved in writing SQLjoins, sub queries, tracing and performance tuning for better running of queries.
• Creating and automating the regular Jobs.
• Loading data from various sources like OLEDB, Flat files toSQLServer database using SSIS packages and created data mapping to load the data from source to destination.
• Successfully migrated data between different heterogeneous sources such as flat files, Excel andSQLServer 2012 using SSIS, BCP and Bulk insert.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Used Various ETL tools like SSIS/DTS for data flow from source files like XML, Tables and Views to other databases or files with proper mapping. customize data entry into ourSaaSsystems, based on our - engineered a Shopping
• Delivered applications by usingSaaSandPaaS.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed, Developed and Deployed Reports inMSSQLenvironment using SSRS.
• Created Parameterized Reports and Linked Reports with thorough knowledge of report serving architecture (Table, Chart and Matrix Report).
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Developed different kind of reports such as Sub Reports, Charts, Matrix Reports, Linked Reports.
• Involved in writing heavy T-SQLstored procedures, complex joins.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.

Confidential

MS SQL developer/ ETL developer

Environment: ASP.NET v4.0, MVC, DB: SQL Server 2008 R2/2005, SSIS, SSRS.

Responsibilities:

• Created and modified tables, Rebuilding/Reorganizing Index (Cluster/Non-Cluster), Constraints (Unique/Check), and Views.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code andSQLjoins for applications followingSQLcoding standards.
• DevelopedSQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan)
• DevelopedUser Defined Functions and created Views.
• Created Triggers to maintain the Referential Integrity.
• Prepared detailed statistical reports inMS Accessand MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Utilized SSIS to develop ETL mechanisms to populate the data from multiple sources including event management, ERP/MRP and discovery components
• Designed, developed and deploy SSRS in support of delivering reports and metrics to customers, users and executives
• Interface with customers and internal stakeholders to incorporate feedback into adjusting the roadmap to balance the needs of the customer with the business strategies.
• Reviewed existing business procedures and recommended and implemented changes.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Worked on Documentation using MS word.
• Prepare detailed statistical reports inMS Accessand MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Ensure standardization ofSQLcoding practices and adherence to coding standards.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Confidential

Sr. SQL developer

Environment: MS SQL 2005, SQL, MS Access, MS Excel, MS Word.

Responsibilities:

• Gathered requirements from business analyst.
• Developed physical data models and created DDL scripts to create database schema and database objects
• Wrote user requirement documents based on functional specification.
• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Developed functions, views and triggers for automation
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Provideddisaster recoveryprocedures and policies forbackup and recoveryof Databases.
• Performance Tuningin SQL server 2005 ProfilerandData Loading.
• Installing SQL Server Client-side utilities and tools for all the front-end developers/programmers.
• Involved in performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects for optimization.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, PSD (Staging Database) to data warehouse (PDW).
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployedSSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created jobs on daily basis and schedule job to update recent data by using SQL Server Agent jobs.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services(SSRS).
• Scheduled execution and delivery of end of the day report using SSRS

Confidential

MS SQL Developer / ETL Developer

Environment: SQL Server 2008 R2, C#, SSIS and SSRS, MSVisual Studio, Windows 2008 Server, BI Development Studio, MSExcel.

Responsibilities:

• Created and modified tables, Rebuilding/Reorganizing Index (Cluster/Non-Cluster), Constraints (Unique/Check), and Views.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code andSQLjoins for applications followingSQLcoding standards.
• DevelopedSQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan)
• DevelopedUser Defined Functions and created Views.
• Created Triggers to maintain the Referential Integrity.
• Prepared detailed statistical reports inMS Accessand MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Utilized SSIS to develop ETL mechanisms to populate the data from multiple sources including event management, ERP/MRP and discovery components
• Designed, developed and deploy SSRS in support of delivering reports and metrics to customers, users and executives.
• Reviewed existing business procedures and recommended and implemented changes.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Worked on Documentation using MS word.
• Prepare detailed statistical reports inMS Accessand MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Ensure standardization ofSQLcoding practices and adherence to coding standards.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.