SUMMARY

• Over 8+ years of MS SQL Server Development experience in Finance, Ecommerce, Telecommunications and Health Insurance domains with expertise in MS SQL Server 2012/2008r2/2008/2005 and Microsoft suite of products like SSIS, SSAS, and SSRS.
• Expert in Creating, Configuring and Performance - tuning ETL workflows designed between Homogeneous and Heterogeneous Systems using SSIS of MS SQL Server 2012/2010/2008/2005.
• Responsible for creating SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Experience in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling
• Involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• Proficient in creating On-demand and Schedule reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services
• Expert in writing Parameterized Queries for generating Tabular reports and Sub-reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS
• Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization.
• Highly proficient in the use of T-SQL for developing Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Highly Experience in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Excellent communication and interpersonal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Ability to handle multiple tasks and responsibilities Ability to work independently as well as a proactive team member.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005
• MS Access
• SQL
• Transact-SQL(T-SQL)
• PL/SQL
• C
• C++
• Java
• C#
• Visual Basic
• Visual C
• XML
• SAS
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Reporting Service (SSRS)
• SQL Profiler
• MS SQL Server Index Tuning Wizard
• MS Visual Studio 2010/2008
• DTS SQL Developer
• ERWIN 8/7.3/7
• Crystal Reports 8.5
• Windows Server
• Windows 2000/XP/Vista/7/8

PROFESSIONAL EXPERIENCE

Confidential, Bridgeport, CT

MS SQL Server SSIS/ ETL Developer

Responsibilities:

• Created Star schema dimensional modeling for the data mart and created dimension and fact tables based on the business requirement.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or an Excel pivot table
• Created, modified, and fixed ETL processes, by applying industry standards for data extractions, transformation and load for various data environments in a data warehouse.
• Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access transform them and load into Dimension and Fact tables in Data Warehouse using SSIS
• Created and modified SSIS (ETL) packages to validate, extract, transform and load data into database.
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2012 environment.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Cache Transform and Derived column while developing the packages.
• Developed SSIS Packages using Lookup Values & implementing rules provided by business in the mapping document.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Used ETL to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Conducted the Error handling in SSIS (ETL) using the Event Handlers.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• 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.
• Ensured data quality and for resolving data quality issues, by understanding the data elements in the source, in the metadata definitions, and in the data destination for existing processes as well as new projects.
• Implemented data modeling, using ERWIN creates new relational or dimensional data models or reverse engineers legacy databases to move into a new environment.
• Supported and built business intelligence environment, using SQL reporting services
• Produced operational reports in SSRS 2012 i.e. drill-down, drill-through, dashboard and matrix reports.
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2012 from the relational database
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Configured the report server and generated the report models for user interactions
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.

Tools: & Technologies:MS SQL Server 2012, SQL Server Reporting Services 2012, SQL Server Integration Services 2012,ETL, MS SQL Server Management Studio 2012, SAS, C#, ASP.NET, VB.NET,MS Excel, T-SQL, ERWIN.

Confidential, Garden City, NY

MS SQL Server ETL /SSRS Developer

Responsibilities:

• Worked on the complete life cycle of the project from design to implementation
• Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst
• Analyzed thebusiness requirement and functional specifications provided by the data specialist.
• Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
• Created SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL server, Excel & Access to SQL Server
• Created SSIS Packages to extract data from OLTP to Data Warehouse & scheduled Jobs to call the packages & Stored Procedure.
• Analyzed, designed, coded, and tested highly complex ETL processing to support data warehouses and/ or operational data stores.
• Involved in upgrading packages from SQL server 2005 to SQL server 2008
• Made sure reports are scheduled and delivered in a timely manner
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Designed high level ETL architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL mapping processes and maintained the mapping documents.
• Created ad Hoc and parameterized various reports using SQL server 2008R2 with data from SQL Server and MS Access as data sources
• Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server 2008R2 environment
• Documented the complete data warehouse environment, including all dimension and fact tables, the relationship between SSIS packages and the target tables, which packages were valid and in use, the relationship between the jobs and SSIS packages, and the relationship between the source tables and the OLAP tables used in the SSAS Cube
• Created ad hoc SSRS reports in the test environment for data validation & Created dynamic Reports from the cube using SSRS and stored procedures.
• Troubleshoot the deployment of reports in the test and production environment using SSRS

Tools: & Technologies:MS SQL Server 2008R2, MS SQL server Reporting Services 2010,MS SQL Integration Services 2010, MS Excel, ERWIN 7.3, SAS, C#, ASP.NET, VB.NET, Windows 7

Confidential, Detroit, MI

MS SQL Server SSIS /SSRS Developer

Responsibilities:

• Worked closely with business unit(s) to understand key business drivers and then identify the individual business metrics and key measures that support them
• Designed and configured, including parameters, settings, metrics, data elements and objectives
• Worked with management to develop strategies to support company needs
• Resolved data conflicts and inappropriate use of data
• Wrote complex SQL queries using joins, stored procedures, used defined functions to verify the data from the database to generate reports based on the business requirement
• Developed dependent, dynamic menu objects to allow end-users selection and data filtering capabilities
• Structured conditional formatting logic to control components behavior and appearance
• Produced parameter driven, matrix, sub-reports and integrated report hyper-link functionality to access external applications.
• Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users
• Used ETL to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Data Migration from Flat files, CSV, MS-Access, Excel and OLE DB to SQL Database.
• Using SSIS, loaded XML data to the Database tables. Generated XML files from Database tables.

Tools: & Technologies:MS SQL Server 2008, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, T-SQL, MS Visio, MS Excel, Java, JavaScript, Share point, Windows XP

Confidential, Cleveland, Ohio

MS SQL Server Business Intelligence Developer

Responsibilities:

• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Interacted directly with the SME(Subject Matter Export)for gathering the business requirement
• Involved in Design Data Warehouse of Star Schema (Dimensional model and Fact tables) based on business requirements.
• Created /modified and maintained the ETL packages- Extraction, Transformation and Loading of data from various Database Source Tables to Mapping the Target table in respective databases.
• Collected data from Various Heterogeneous database/files like MS SQL, DB2, ORACLE, Flat File, Access, Sybase, EXCEL sheets, CSV format and used complex data conversion to target.
• Scheduled and monitored the regular jobs and ETL packages, Used ADO.net connection, .net and C# code in SSIS Script task.
• Involved in Query optimization, performance tuning and index creation as well Database Backup and restoring the database.
• Validated and Tested of the Database data, SQL codes and application (White box and Black box)
• Prepared Documentation of the system from functional requirement & created package.
• Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations
• Implemented multiple grouping into several reports using visibility and toggle options
• Administrated and scheduled mailing subscriptions on SSRS reporting server

Tools: & Technologies:MS SQL Server 2008, SQL Server Integrating Services 2008, T-SQL, SQL Server Reporting Services 2008, MS-Access, DB2/UDB, ERWIN, VB Script, Windows XP.

Confidential, Bellevue, WA

MS SQL Server Business Intelligence developer

Responsibilities:

• Extensively worked in Installing SQL Server 2008 with latest service package, creating database, database objects such as view, table, stored procedure, trigger and function using T-SQL.
• Performance tuning of stored procedure & Wrote complex join queries using T-SQL.
• Created the Logical and Physical Data Model using Erwin Data Modeler tool.
• Performance tuning of server, Stored Procedure and SQL Server Integration services 2005.
• Involved in creation of MOLAP Using MDX Objects, creation of measure & cubes.
• Created Multiple Reports by extracting data from different data sources MS Access, Oracle, DB2 Deploy those reports on server & manage reports.
• Monitoring the application and database performance using SQL Profiler and Performance Monitor
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly Reports.
• Managed Windows Admin Scripts to monitor Disk and Tape Backups, Disk Space and Service Status for different servers and generate alerts Using SQL server Integration services.
• Headed the team of Crystal Reports Developers, developed the reports as well as got them done by team on time for the releases.
• Created SQL Server Job Agent to schedule to generate the package on time to Administrator & Manager to monitor the SQL Server Events and SQL Server Performance Alerts and notify the Administrators of the critical situations.
• Managed Stored Procedures, User-Defined Functions, Ad-hoc Scripts and Cursors on Development and Test servers for pre-deployment testing.

Tools: & Technologies:MS SQL Server 2005, Enterprise Manager,SQL Server Visual Studio 2005, Database Maintenance Plan Wizard, System Monitor/Performance Monitor, Event Viewer, T-SQL, Crystal Reports, Window 2003.

Confidential

MS SQL Server Developer

Responsibilities:

• Extensively involved in installing and configuring SQL server 2005.
• Improved Performance of databases by analyzing Indexes, Fill Factor and Fragmentation issues
• Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
• Created Scripts to monitor Backups, Drive Space, Log Size, Database Size and Service Status monitoring.
• Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail
• Gained expertise in Security Issues by creating Users and granting Permissions on various Objects
• Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert the users with the field status changes.
• Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
• Monitoring server performance by using Performance counter & Created complex Stored Procedures and Cursors to support applications using T-SQL.
• Prepared Estimates for Database Files and Table size growth.
• Created Distributed Partition views Using T-SQL.

Tools: & Technologies:MS SQL server 2005, Windows 2000, Enterprise manager, Query analyzer