SUMMARY

• Senior SQL Server developer with 10 Plus years of IT experience in Database and with expertise on Microsoft Business Intelligence tools DTS, SSIS, SSRS in various domains - finance, healthcare, insurance and banking.
• Experience in Client requirement analysis, Physical, Logical design, Estimation, Resource Planning, Coding, Debugging, Testing, QA and UAT Support and Maintenance of Business applications using SQL Server 2000/2005/2008/2012.
• Hands on experience in creating ETL packages using SQL Server 2008/2012 Integration Services (SSIS) and creating reports using SQL Server 2008/2012 Reporting services (SSRS).
• Experience in writing complex SQL queries involving multiple table inner and outer joins.
• Experience in optimizing the queries by creating various clustered and non-clustered indexes and indexed views.
• Expertise in Extraction, Transformation, Loading data from SQL Server, Access, Excel, Flat Files and XML using SSIS.
• Experience in creating Tables, Views, Stored Procedures, Triggers, User defined Function and Other T-SQL statements for various applications.
• In-depth knowledge of T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and SQL Server Management Studio functionality using T-SQL Scripts and Batches.
• Experience in Data Migrating /Data Integration using SSIS
• Experience in data validation and cleaning, data mapping using SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP).
• Experience in providing Logging, Error handling by using event handler and custom logging for SSIS packages.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, and Drill down, Top N, Summary and Sub reports using SSRS and formatting them.
• Excellent in creating SSIS Package for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transactions provide by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS).
• Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS 2005/2008 which resulted in efficient decision making.
• Extensive experience in creating SQL server Analysis Projects using MS SQL Server.
• Experienced in data loads, database integration/conversions, performance tuning and optimization using MS SQL Server.
• Replication models (like Snapshot, Merge and Transactional), Locking and SSAS Analysis services.
• Absolute knowledge of software development life cycle (SDLC), database design, data migration concepts.
• Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Excellent analytical and communication skills to present points precisely and solve problems efficiently.

TECHNICAL SKILLS

Database Tools: SQL Enterprises Manager, SQL Profiler, Query Analyzer SQL Server setup, Security Manager, Service Manager, SQL Server Analysis Services (SSAS), Database Engine Tuning Advisor and Business intelligence development studio

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export wizard.

Languages: T-SQL, COBOL, and Visual Basic 6.0

Reporting Tools: SSRS, MS Excel, Oracle SQL developer and Oracle report designer.

Databases: SQL Server 2000, 2005, 2008 and 2012, Oracle 10g, MS Access.

OS: Windows 95/2000/2003/ XP/VISTA, UNIX, MVS.

Other tools: Serena Team track, PVCS version control, CA Autosys scheduler

PROFESSIONAL EXPERIENCE

Confidential, Roseland, NJ

Lead SQL BI Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2000, 2005, 2008.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created adhoc reports using Import and Export Wizard.
• Used MS SQL Server 2012 SSIS to create SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging and before loading the data.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS and Created Ad-Hoc Reports, Summary Reports, Sub Reports.
• Used SQL Server 2008R2/2012 Reporting Services (SSRS) for generating reports which resulted in efficient decision making.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer Representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS)
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services and finally to Reporting service.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Diagnosing and tuning the server optimal performance using SQL Profiler and Database Engine Tuning Wizards.
• Deployed the databases from old servers to new servers using Replication, based on the business goal.
• Implementing error handling strategies for the packages which includes error logging and error handling methods
• Deploying the packages (both the methods File system & SQL Server system) to different environments (test environment, production environment)
• Worked on Oracle SQL and Oracle Report designer to design and deploy the reports to Oracle report servers.
• Used CA Autosys and SQL Agent job schedulers.
• Used Serena Teamtrack tool for tracking the requests and issues during the whole application life cycle.

Environment: MS SQL Server 2012/2008 R2, SSIS, SSRS, DTS, T-SQL, Unix, CA Autosys, Oracle PL/SQL, Oracle SQL developer, Oracle Report designer, Microsoft Visual Studio 2008R2, Microsoft Visual Studio 2010, Windows 2003 professional server, Serena Teamtrack and Business intelligence development studio.

Confidential, Scranton, PA

Senior SQL BI Developer

Responsibilities:

• Worked entirely on SSIS script task, look up transformations and data flow tasks using T-SQL.
• Migrated data from MS SQL source databases to destination database in SQL Server 2008 database using SSIS.
• Developed ETL’s using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Designed SSIS packages to export and import data from SQL Server to MS Access, Oracle, text files and Excel files.
• Experience in ETL tools like SSIS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper data mapping and data cleansing.
• Writing SSIS packages for loading the data (100 million records) from source to target as per the requirement.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Developed ETL’s using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Used the Default logging as well as Custom Log to keep track of the package
• Setting up the Test SQL database to be in Sync with production after the data scrambling.
• Participation in source code walk through and reviews the components.
• Tested the Integration of different modules.
• Generated adhoc reports for Tax cover letters, state forms and few federal reporting forms using DTS packages.

Environment: SQL Server 2000 and 2008 management studio, Business intelligence development studio, DTS, SSIS, SSRS, T-SQL, Report manager, Report Configuration manager, SQL Enterprise manager, SQL profiler, Microsoft Visual Studio 2008R2 and Windows 2003 professional server.

Confidential, Bloomington, Illinois

Senior SQL BI Developer

Responsibilities:

• Actively involved in business rule analysis and gathered user requirements.
• Experienced with SSIS in creating, loading, and modifying new packages or existing packages and add or configure components, making changes in object by using Control Flow Tools and Data Flow Tools and then validating them.
• Used Batch Files to Import Data from other Data Base.
• Carry out creation of SDLC documentation for existing applications.
• Created packages in SSIS with error handling and worked with different methods of logging.
• Applied various data transformations like Slowly Changing Dimension (SCD), aggregate, sort, Multicasting, Conditional Split, Derived column etc.
• Created ETL SSIS packages both design and code to process data to target databases.
• Responsible for migration of databases from old SQL server versions to SQL Server 2008.
• Experience in managing Alerts, Creating Jobs, and Operators through SQL Server Agent.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the front end.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created views to restrict access to data in a table for security in SQL server databases.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report in the Report designer.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
• Created Cross-Tab and Sub-Report using RDL and promoted RDL’s to Reporting Service Server and scheduled the monthly/weekly/daily reports to run automatically and send the reports via email.

Environment: SQL Server 2000 and 2008 management studio, DTS, SSIS, SSRS, Visual Studio 2008, MS DOS Batch scripting, SQL server agent scheduler, SQL profiler, T-SQL and COBOL

Confidential, Dallas, Texas

SQL BI Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server 2000 and 2008 databases.
• Involved in the Data modeling, Physical and Logical Design of SQL Database
• Created tables, indexes, constraints, triggers and procedures.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Import & Export of data from one server to other servers using tools like SSIS.
• Write T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries.
• Created documentation on the all the tables, stored procedures, views and user defined functions.
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Migrated SSIS 2005 packages to SSIS 2008 packages.
• Deployed, Tested and Scheduled SSIS packages using SQL Agent job scheduler.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load.
• Created report models for ad hoc reports and deployed on report server using SSRS.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: SQL Server 2000 and 2008 management studio, SQL profiler, DTS, SSIS, SSRS, Visual Studio 2008, SQL Enterprise manager, SQL Query analyzer, Microsoft Visual Studio 2008R2 and Windows 2003 professional server.

Confidential

Microsoft SQL Server Developer

Responsibilities:

• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers.
• Developed Tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Developed SQL scripts to INSERT, UPDATE and DELETE data in MS SQL database tables in OLTP environment.
• Performed data consistency and performance tuning effectively with SQL Profiler.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.

Environment: MS SQL Server Management Studio 2008, Query Analyzer, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visual Studio 2008R2 and Windows server.

Confidential, Union, NJ

Microsoft SQL Server Developer

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Involved in performing Extraction, Transformation and Loading using SSIS (utilized SCDs)
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Used SQL Server 2008 Reporting Services (SSRS) for generating reports which resulted in efficient decision making.
• Worked extensively with client gathering requirements to generate customized SSRS Reports (Subscriptions Created for users)
• Worked Extensively on SQL Server 2008 and 2008R2
• Developed all the required Stored Procedures, user defined Functions, Triggers, Views using T-SQL as per business logic.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon for ETL Loads and Reports processing
• Worked extensively on all the Environments: Development, Testing and Production

Environment: SQL Server 2008 and 2008R2, SQL profiler, DTS, SSIS, SQL Enterprise manager, SQL Server agent, T-SQL, MS Excel, power pivot, Microsoft Visual Studio 2008R2 and Windows server.

Confidential, New York, NY

Microsoft SQL Server Developer

Responsibilities:

• Created database objects such as tables, indexes, stored procedures, functions and triggers in SQL Server 2000.
• Involved in installation and configuration of SQL server 2005 on Servers.
• Created Stored Procedures and views in SQL Server using T-SQL to collect data for the crystal reports.
• Implement and maintain database security.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Going through the client’s requirements and coming up with database design and application architecture.
• Developed and tested complex Transact-SQL on MS SQL Server 2000.
• Designed, developed, modified and enhanced the database structures and database objects using complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Applied patches and service packs to keep the database at current patch level.
• Implemented database standards and naming convention for the database objects.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Fine tuned Stored Procedures, using Execution Plan in T-SQL for better performance.
• Monitor failed and long running MS SQL Server jobs in SQL Enterprise manager .
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000 and 2005, SQL profiler, DTS packages, SSIS, SQL Enterprise manager and SQL Server agent, Microsoft Visual Studio 2008R2, Windows 2000/2003/NT/XP.

Confidential

Microsoft SQL Server Developer

Responsibilities:

• Mainly involved in Performance Tuning of the Teller Application for various Modules.
• Actively Coded and Unit Testing using AS 400 tables and SQL server 2000.
• Worked on data migration from Db 400 to SQL server.
• Developed, maintained and Monitored SQL server agent jobs using SQL Enterprise manager.
• Developed all the required Stored Procedures, user defined Functions, Triggers, Views using T-SQL as per business logic.
• Developed DTS packages for data flow from one source files like Excel, Tables, and Views to other databases or files with proper data mapping and data cleansing.
• Prepare Small Project Report, RDD (Requirement Definition Document).
• Interacting with the client to fulfill the requirements.
• Prepared High/Low level design documents..
• Support various testing (Regression testing, Assembly testing, UAT, etc.,)
• Involved in QA Meetings for the code and construction tasks with the Client.
• Reviewed Unit & Integration Test Plan.
• Tested the Integration of different modules.
• Worked with SQL to test database integrity.
• Developed Test Cases and Test Scripts.
• Installation of the changes, Production Support.

Environment: Microsoft SQL server 2000, SQL Agent job scheduler, SQL Enterprise manager, DTS, AS 400, Turnover, MS Excel, Visio, DOS batch scripting.