SUMMARY

• Over 7+ years of IT experience as a MS SQL Server Developer 2012/2008R 2/2008/2005/2000 in various Industry verticals like Finance, Health Care, Insurance and Educational Institution.
• Extensive experience with different phases of software development life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Experience in Installation and Configuration of SQL Server 2012/2008R 2/2008/2005/2000.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Highly experienced in complete cycle of SQL Server Integration Services (2005/2008), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Experience in creating SSIS packages using Active X scripts, script task and with Error Handling.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Experience in Scheduling and Monitoring ETL processes using DTS Exec utilities and batch files.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2005
• Experience in creating complex drill down reports, parameterized reports, dropdowns and images, charts using SSRS 2005/2008, Crystal Reports and MS Excel for the analyzation of the data at an enterprise level.
• Knowledge in creating Ad-hoc reports and data driven subscription reports by using Report Builder (version).
• Expertise in creating Cubes with dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data with pre-calculated aggregations and also in summarized fashion which can be modeled into a report accordingly.
• Involved to develop the VB Script, C# in SSIS.
• Good at collaboration and interpersonal skills
• Can work as individual as well as a team player

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL. C, C++,C#, VB 6.0,Perl,CSS, HTML, XML, MHTML

Databases: SQL Server 2008R 2/2008/2005/2000/7.0, Oracle 9i/8.x, Toad for Oracle 11g, DB2 MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Other Software: MS Office- 2010/2007/2003/2000, Adobe Professional, SharePoint, Visual studio 2010/2008.

Operating Systems: Windows / 98/2000/2003/ XP/Vista/2008, Unix.

Database Tools: SQL Query Analyzer, SWIFT Tool, ERWIN, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential

SQL Server BI Developer

Responsibilities:

• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Involved to develop the VB Script, C# in SSIS and SSRS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created ETL packages to call the XML web service through Execute Process Task in the Control Flow.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into stage tables by performing different kinds of transformations using SSIS/DTS packages
• Created another set of ETL packages to load the data from Stage Tables to Main Table and used referential integrity model.
• Created data loads and Upgrade scripts for data migrations and validations
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.
• Worked on SSRS to generate more than 60+ reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Implemented Unit Tests and Integration Tests.
• Prepared documentation related to database design, objects security and rules.

Environment: SQL Server 2012/2008R2, Query Analyzer, TFS, C#, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2008/2000/XP, Toad for Oracle 11g,SharePoint server 2010.

Confidential, Columbia, MD

SQL Server BI Developer

Responsibilities:

• Responsible for Data Modeling based on the client requirements.
• Prepared the Technical and Function specifications based on the project requirements.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Redesigning the ETL process from the existing legacy DTS packages into SSIS Packages.
• The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Modified stored procedures to meet current design and used them in SQL Server.
• Developed queries in Data Warehouse in OLTP/OLAP environment.
• Created complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.
• Modified web pages to do database inserts, deletes, modify.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Created ad-hoc reports using SQL server 2008 Reporting Services (SSRS).
• Created report models from OLTP & OLAP.
• Trained 10 business users so that they can create reports from the report model I created.
• Troubleshooting Database performance issues and implementing necessary database changes.
• Involved in Development, Review and testing of the new system by implementing business rules and transformations.

Environment: SQL Server 2008R2/2008/2005, Query Analyzer, C#, Enterprise Manager, DTS, TFS, SSIS, SSRS, T-SQL, Windows 2000/XP/2008, SharePoint server 2007.

Confidential, Berkeley Heights, NJ

SQL Server BI Developer

Responsibilities:

• Involved in Installation and Configuration of MS SQL Server 2008.
• Created Database Objects like Stored Procedures, Triggers and User Defined Functions (UDF) for this project.
• Created Views to maintain security of customer data.
• Created Indexes to get the high level performance.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Designed SSIS packages for synchronizing the data between two different servers.
• Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution.
• Created SSIS Packages to migrate slowly changing dimensions.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created Ad-hoc reports and cascading reports for historical data using SSRS..
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Created Partition table for very large database for good performance.
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.
• Created partition function, schema and file groups for fact tables.
• Involved in the post deployment maintenance of canned reports and cubes.
• Involved in the design, development and maintenance of different cubes using SSAS

Environment: MS SQL Server 2008/2005, TFS, Query Analyzer, Windows 2003, SSAS, Excel, Oracle10g.

Confidential, Richmond, VA

SQL Server BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference.
• Maintained the table performance by following the tuning tips like Normalization and Creating Indexes.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Designed, Developed and Deployed reports in MS SQL Server2008 environment using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Generated various reports using SSRS 2008.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance.
• Scheduled reports and exported in PDF format.
• Fine tuned SQL Queries for maximum efficiency and performance.
• Provided documentation for all kinds of SSIS packages.
• Designed and implemented Stored Procedures for automating tasks.

Environment: MS SQL Server 2005/2008, T-SQL, MS SQL Server Integration Services 2005, MS SQL Server Reporting Services 2005, MS SQL Profiler, SQL Query Analyzer, Visual Studio 2005, Erwin v4.1, Windows XP, MS Office 2003/2007, MS Access.

Confidential, Morgantown, WV

SQL Server BI Developer

Responsibilities:

• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005.
• Used various transformation components in the data flow task to implement business logic.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Migrated data using ETL Tool in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Used SSIS for data population from different sources and create packages for data conversions and load data into flat flies or excel files.
• Conversion of DTS packages SQL Server 2000 into SSIS packages SQL Server 2005.
• Created complex variables, multiple breaks, sorts in the reports.
• Created Tabular and Matrix reports using SSRS.
• Developed multiple reports using reporting services.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Created ETL package for data conversion using various transformations tasks.
• Created various scheduled jobs to handle the data migration from SQL periodically.
• Created Stepped and Block reports using SSRS.
• Experience in building star schema and snowflake schema depending on the business data requirement. Rebuilding Indexes and Tables as part of performance tuning exercise.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created datasets for reports using T-SQL and stored procedures
• Responsible for Query optimization and Performance tuning.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Created logins, roles, and groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS 2005, SSRS 2005,.NET Framework, C#, ASP.NET, ADO.NET, Erwin, XML, T-SQL, SQL Server 2000, SQL Server 2005, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, ASP, XML, T-SQL, MS Excel, MS Access, Visual Studio 05.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in different stages of Project Life Cycle.
• Actively participated in gathering Business Requirements and System Specifications.
• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Indexes.
• Used SQL Server System Catalog to find Stored Procedures, UDF, Triggers, indexes and constraints on existing databases.
• Implemented batch processing using Jobs and DTS.
• Migrated data from Flat files to SQL server 2000 using DTS (Import and Export Wizard)
• Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Scheduled Jobs using SQL Server Agent.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Designed and implemented several complex reports.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using crystal Reports.
• Created different user level groups, and assigned appropriate permission level to the database.
• Preparation of project documentation.

Environment: SQL Server 2000, DTS, MS Access, MS EXCEL, T-SQL, Windows 2000 server.

Confidential

MS SQL Server Developer

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, historical data and audit analysis
• Conducted database management, performance measurement and tuning for new and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Conducted logical and physical database design including maintenance, problem diagnosis and resolution.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Responsible for database security of the operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: MS SQL Server 2000, T-SQL, SQL Server Enterprise Manager, SQL Profiler, Excel, Data Import, DBMS, C.