SUMMARY

• 9 years of IT Experience in design, development, coding and testing of business/commercial applications in MS SQL Server 2012/2008/2005/2000 , MS Access.
• Extensively worked on development of T - SQL scripts, creating database, tables, indexes, stored procedures, views, triggers, T-SQL, DTS/SSIS using MS SQL Server 2005/2000.
• Extensively used SSAS, SSIS & SSRS for various BI requirements.
• Experience in MS SQL Server Migration from SQL Server 2000 to SQL Server 2005.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
• Good noledge of Data Marts, Data warehousing, Operational Data Store (ODS), Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Excellent noledge in RDBMS concepts.
• Experience in query optimization & performance tuning, Database Mirroring, Database Snapshots, backup and disaster recovery procedures like log shipping.
• Scheduled and monitored all maintenance activities of SQL Server to meet business requirements activities including database consistency check, and data backup & restore strategy, index fragmentation.
• Create an index on table to retrieve data faster from table and database.
• Experience in creation of logins, users and configuring permissions and assigning roles to users.
• Very Good Experience in Using SQL Server Reporting Services.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports and deploying SSRS reports on the portal for user accessibility.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Strong troubleshooting and organizational skill; independent, self-managing and teamwork.
• Ability to work in-groups as well as independently with minimal supervision.

TECHNICAL SKILLS

Databases: MS SQL SERVER 2000/2005/2008/2012 , ORACLE, MC Access

Database Tools: T-SQL, SQL Server Integration Service, SQL Server Reporting Services, bcp, SQL Agent, Server Configuration Utility, my sql.

Languages: MS SQL Server 2005/2000/2008 , T-SQL, VB.NET, Visual Basic 6.0, C, CCC+

Tools: MS Office 2003/2000/XP, MS Outlook 97/2000

Operating System: Windows 2000 Advanced Server/Server 2003/Professional/ NT 4.0, Win XP Prof/Standard.

Data Modeling: Microsoft Visio, DB Designer, Erwin

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created different types of User-defined functions.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Used Report Manager to assign roles, permissions and to create report schedules.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Conducted data import and export operations using the DTS wizard.
• Created SQL Jobs to scheduleSSIS Packages
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Configured and deployed SSRS reports to Share point
• Created mapping tables to find out the missing attributes for theETL process.
• Used the row count transformation and event handlers control flow to populate the special Log tables withhigh level SSIS packageexecution results
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Build efficientSSIS packagesfor processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Created Unit Test Plan, Unit Test Summary, SIT Test Plan, UAT Test Plan and UAT Summary documents.

Tools: &Technologies: MS SQL Server 2014, MS SQL Server Integration Services 2014, SQL server Reporting Service 2014, MS Excel, MS word, Prime.

Confidential, Jersey City, NJ

Lead MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Developed, deployed, and monitored SSIS Packages.
• Performed operations like Datareconciliation, validation and error handling after Extracting data into SQL Server.
• Worked on SSIS Package, Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL
• Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Arrange weekly, bi-weekly, monthly, quarterly, and annual reports.
• Ensure proper record-keeping of data collected and analyzed.
• Review and Test external entity derivation logics.

Tools: &Technologies: MS SQL Server 2012, MS SQL Server Integration Services 2012, SQL server Reporting Service 2012, MS Excel, MS word, Oracle SQL developer, Quality center 11.0.

Confidential, Philadelphia, PA

MS SQL Server SSIS/ SSRS Developer

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusing For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task,Lookup, Fuzzy Lookup, Derived Columns, Conditional Split, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Imported SQL Server Data from Multiple Data Sources into PowerPivot for Excel
• Deployed reports on Report Server and SharePoint Server also scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2012 Reporting Services (SSRS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and indexpartitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Tools: & Technologies:SQL Server 2012, Server Integration Services 2012, SQL server Reporting Service 2012, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN 7.2, C#

Confidential, West Chester, PA

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Performed Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access)
• Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• TEMPEffectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Wrote C# script in Script task of control flow.
• Experienced in Error handling and debugging coding issues and troubleshoot production problems.
• Experienced in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor.
• Well-versed in usage of SSIS Control Flow items(for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping).
• Developed SSIS package for implementing Slowly Changing Dimension. Fact Load and Dimension Load. Incremental Load.
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Involved in configuring and creating SSIS solutions for ETL and Business Intelligence Process for data integration and migration services.
• Experienced in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

Tools: & Technologies:SQL Server 2012, Server Integration Services 2012, SQL server Reporting Service 2012, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN 7.2, C#

Confidential, Radnor, PA

MS SQL Server Developer SSIS

Responsibilities:

• Transformed data from different data sources like Oracle, Flat files, SQL data bases to SQL Server 2008 using OLEDB connection providers by creating various SSIS packages. Data is transformed from hub (ODS) to data warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for residential, business, large business users.
• Created SQL server Analysis Projects andcreated multi-dimensional databases and OLAP cubesand dimensions for the analysis of capacity planning task in specific areas for departmental manager using SSAS.
• Migrated the data from the appropriate databases to end database and maintained batch log files. Involved in the usage of variables to make the packages dynamic and scheduling the package in SSIS (sequential scheduling).
• Implemented AD HOC reporting with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Generating Drill- through, Drill down, Matrix, Snapshot reports using the data from the Data warehouse using SSRS with Microsoft Share Point Integration 2007.
• Implemented the elements of T-SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like Retailers Debit, Credit etc.
• Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.

Tools: & Technologies:SQL Server 2008/2005, BIDS 2008/2005, Integration Services 2008/2005, Visual SourceSafe, T-SQL, MS Access, Windows XP/2007 Server, SQL Profiler, Index Tuning Wizard, C#

MS SQL SSIS/SSRS Server developer

Responsibilities:

• Involved in designing database and perform forward engineering, from conceptual data model to Logical and physical data model using Erwin 7.2 data modeler tool.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
• Extensive experience with optimizing existing stored procedures and various T-SQL queries.
• Involved in migrating data from MS SQL server 2000/2005 database to MS SQL server 2005/2008 database.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages. Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop )
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure
• Developed unit test plans for SSIS packages. 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/Weekly/Monthly basis.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008. Generated Sub-reports, Drill down, Drill through and Parameterized reports using SSRS 20005/2008. Created reports to retrieve data using stored procedures dat accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the dashboard. Responsible for monitoring and tuning SSRS Report Performance.
• Involved in the development and designing of XML, HTML using cascading style sheets for displaying the reports on the report server. Configured the report viewing security for various users at various levels using report manager.
• Fine-tuned SQL queries for maximum efficiency and performance. Provided documentation for all kinds of reports and SSIS packages. Designed and implemented stored procedures and triggers for automating tasks.

Tools: & Technologies: MSSQL Server, 2008, SSIS2008, SSRS2008 with Microsoft Share point Integration 2007, SSAS 2008, Windows XP, MS EXCEL.

Confidential, NY

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Participated with business analysts in order together requirements for design and implementation of database.
• 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.
• Worked on existing OLTP system(s) and created facts, dimensions, data models, star schema representation for the data mart of OLTP and Data warehouse databases.
• Expert in extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created local variables and global variables package configurations and error handling.
• Created parameterized reports and ad-hoc reports using Report builder for the brokers and clients.
• Responsible for designing, creating and deploying the reports into the production server.
• Created complex store procedure to copy Database Objects from remote server to local machine and vice versa.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Responsible for creating and implementation of data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Tools: & Technologies: MS SQL Server 2005, Oracle 9i, MS Access, MS Excel, DTS, BCP, T-SQL.

Confidential, Austin, TX

SQL Developer/DBA

Responsibilities:

• Optimized query performance by creating indexes.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Created Packages and T-SQL Stored Procedures for the ETL Process.
• Developed Database Backup Scripts and automated dis process.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Import & export data using DTS import &export wizard in SQL server 2000.
• Expertise in Database design, Entity Normalization & Database Creation, Maintenance, Monitoring, Performance Tuning and Troubleshooting.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Tools: &Technologies: MS SQL Server 2000/2005, T -SQL, Windows 2000 Server Edition, Visual Basic 6, MS Visio 2003.

Confidential

SQL Server Developer/SSRS

Responsibilities:

• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Worked as a developer on databases like MS SQL Server 2000, MS Access (using T-SQL, scripts, stored procedures and views)
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Developed source to target specifications.
• Scheduling transfer of backups and log files to different servers.
• Creation of schema objects, rules and granting of roles to the users
• Developed stored procedures, functions, views and triggers.
• Created indexes, constraints and rules on database objects.

Tools: & Technologies:MS SQL SERVER 2005/2000, SSRS20005/2008, SSIS 20005/2008, Erwin, Visual Studio 2005, MS Office 2003, Windows 2003.