SUMMARY:

• Over 8 years of IT experience in Database with expertise on ETL Process and Reporting usingSQLServer 2005/2008 R2/2012, SSIS and SSRS.
• Experience in client requirement Analysis, Physical, Logical design, Development, Resource Planning, Coding, Debugging, Testing, Development, Support and Maintenance of Business application usingSQLserver 2012/2008 R2/2005, DTS, SSIS, SSAS, SSRS.
• Experience in writing complexSQLqueries involving multiple table inner and outer joins.
• Experience in optimizing the queries by creating various clustered and non - clustered indexes and indexed views.
• Experience in creating Tables, Views, Stored Procedures, Triggers, User defined Function and Other T-SQLstatements for various applications.
• In-depth knowledge of T-SQLDDL/DML, perform most of theSQLServer Enterprise Manager and Management Studio functionality using T-SQLScripts and Batches.
• Experience in Data Migrating /data integration using SSIS.
• Experience in data validation and cleaning, data mapping using SSIS.
• Expert in Data Extraction, transforming and Loading (ETL) usingSQLServer Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy (BCP).
• 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 usingSQLServer Reporting Services (SSRS) based on Relational and OLAP databases.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports usingSQLServer Reporting Services (SSRS) based on client requirement.
• Extensive experience in OLTP/OLAP environment and Experience in OLAP Cubes.
• Extensive experience in creatingSQLserver Analysis Projects using MSSQLServer 2008R2/2012.
• Experienced in data loads, database integration/conversions, performance tuning, optimization,SQLReplication models (like Snapshot, Merge and Transactional), Locking and Analysis services.
• Experienced in design of logical and physical data modeling using Erwin data modeling tool.
• Absolute knowledge of software development life cycle (SDLC), database design, RDBMS, data warehousing and data modeling concepts.
• Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.

TECHNICAL SKILLS:

Database Tools: SQLEnterprises Manager,SQLProfiler, Query AnalyzerSQL Server setup, Security Manager, Service Manager,SQLServer Analysis Services (SSAS),, Database Engine Tuning Advisor

ETL Tools: Data Transformation Services (DTS),SQLServer Integration Services (SSIS), Import Export Data, Bulk Insert

Data Modelling Tools: ERWIN, MS Visio.

Programming Language: T-SQL, JAVA, C#, C++, HTML, XML, and Visual Basic 6.0 Java Script

Web Tools: MS-Front Page, Macromedia 6 (Flash, Fireworks, Dream Weaver, MS-Outlook Express.

Reporting Tools: Crystal Reports 9/10/11,SQLServer Reporting Services (SSRS), MS Access, MS Excel.

Databases: SQLServer 2005/2008 R2/2012, Oracle 10g / 9i, MS Access.

Operating Systems: Windows 9x/Me/NT/XP/Vista/2003/2000, Mac.

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, PA

Sr. SQL Server Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Triggers, Stored Procedures, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Managed the ETL and DW release processes, including schema changes and data migration scripts.
• Designed, tested, deployed, and optimized SQL Scripts and stored procedures as required.
• Monitored ETL performance, identified recurring data quality issues, and establish audit, balance, and control procedures, alerts and reports.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Performed extract, transform, and load (ETL) data into the repository and Created Complex Stored procedure, Functions, Views, and Indexes for the Logic package.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Used multicast transformation in SSIS services to create the multiple logical copies of the source data for the multiple purposes.
• Wrote SSIS packages and configuring T-SQLJobs usingSQLServer Agent.
• Created ETL packages inSQLServer Integration Services to facilitate database upgrade task.
• Performing database consistency checks using DBCC Utilities and handling data corruption in user databases.
• Created and managed schema objects such as Tables, Views, Triggers, UDF(User Defined Functions), Stored Procedures, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating Linked Servers between differentSQLServers inSQLServer 2008/2005 environments to access database objects in remote locations.
• Generated daily report on the job failures, backup failures, disk space and involved in performance issues and resolving deadlocks.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Grant privileges to user(s), role(s), and object(s). Support column level privileges.
• Administrate security for server's logins (Windows andSQLAccounts).

Environment: MSSQLServer 2012/2008R2, Windows 2000/2003 servers, IIS Web Server, DTS, MS Access, SSIS, SSRS, SSAS, PowerShell, Lite speed, SS Management Studio, T-SQL,SQLserver Enterprise manager, JDK 1.5

Confidential, Southfield, MI

SQL Server Developer

Responsibilities:

• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Worked as adeveloperin creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and otherSQLjoins for building various applications.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Used various transforms in SSIS to load data from flat files, Database sources and FTP to theSQLdatabases.
• Designed and developed data load jobs using SSIS package and scheduled inSQLAgent.
• Created Grouping, Sorting columns and writing expressions according to the business requirements.
• Migrated old data from MS Access and Excel intoSQLServer 2008/2012 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages andSQLscripts.
• Good Knowledge of Installation and Configuration of Clustered Servers in Active/Passive and Active/Active mode.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.
• Created and maintained logins, roles and permissions on theSQLinstances 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 (SQLtuning).
• Created parameterized and drill through reports in SSRS.
• Designed developed and deployed reports in SSRS portal and made available to render them to HTML and PDF formats.

Environment: SQLserver 2005/2008 on Windows 2003 server, IIS, Visual Studio, SSIS, SSAS, SSRS, Database Mirroring, Replication, Log shipping, Framework Manager, BIDS and SSMS.

Confidential, Brookfield, WI

SQL Developer

Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Designed and implemented ETL processes based on T-SQL, stored procedures, triggers, views, tables, indexes, constraints, user defined functions, and security usingSQLServer 2012,SQLServer Integration Service (SSIS).
• Designed and implemented SSIS package to migrate data from multiple data source (Oracle, Informatica) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Created Clustered and Non-Clustered index to improve the access of data within the database.
• Actively involved in Normalization (3NF) & De-normalization of database.
• 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, and Conditional Split.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Used UNIX shell scripting for data flow and Error Handling using Script Component in MS SSIS.
• Implemented data mart, facts, dimensions and OLAP cubes based on Kimball's dimensional modeling standards usingSQLServer Analysis Service (SSAS).
• Implemented client applications, which make use of Reporting Services to connect to cubes.
• Generated underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed Custom Reports, drill through, drill down, parameterized, cascaded and sub-reports, Ad-hoc Reports by usingSQLServer Reporting Services (SSRS).
• Created partition function, schema and file groups for fact tables to optimize the fact.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Optimized queries and performances using variousSQLServer tools such asSQLProfiler,SQLPerformance Monitor, Execution plan and Index tuning wizard.

Environment: MSSQLServer 2012, T-SQL,SQLServer Integration Services (SSIS),SQLServer Reporting Services (SSRS),SQLServer Analysis Services (SSAS), MS Visio 2010, UNIX, Oracle, Informatica,SQLProfiler, Visual Studio 2008, DDL, Data Warehouse.

Confidential, Detroit, MI

SQL Server Developer

Responsibilities:

• Installed and configuredSQLServer 2008 in test environment with latest service packs and migrated few databases.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Created Complex Stored Procedures, triggers, cursors, tables, and views and otherSQLjoins and statements for applications by using T-SQL.
• Extensively used T-SQLin constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Conducted data migration processes in theSQLServer environment usingSQLServer Integration Services (SSIS).
• Developed SSIS packages to extract, transform and load into the Reporting database from OLTP database.
• Performed transformations of data such as adding derived column, sorting of data, merging of data while pulling data fromSQLServer 2005 to theSQLServer 2008.
• Created copies of operational Databases using the Import/Export Wizard.
• Created multidimensional cubes using SSAS and designed Data Warehouse schemas.
• Developed Sub Reports, Matrix Reports, Tabular reports, Charts, Drill down reports and parametric reports, usingSQLServer Reporting Services (SSRS).
• Worked with building complex Ad Hoc and Standard Reports using SSRS and worked with tuning the large complex reports onSQLServer Database.
• Created high quality reports, dashboards and analytics to meet the needs of various business clients such as Operations, Sales, Customer Service, Finance, and Executives.
• Configured and managed database maintenance plans for update statistics, database integrity check, and backup operations.
• Regularly performed Query Performance tuning, and Optimization.
• Developed test reports and conducted quality assurance testing.
• ETL process was documented for future references.

Environment: MicrosoftSQLServer 2008/2005, Windows XP, TransactSQL, SSIS, SSRS, Erwin,SQLQuery Manager, MS Visual Source safe, Performance Monitor, Query Optimizer.