SUMMARY

• Over 7 years of IT experience in Design, Analysis, Development & Management using Microsoft SQL Server 2008/2005/2000 and SQL server BI products SSIS, SSRS, and SSAS for OLTP and data warehouse solutions.
• Involved in all the phases of software development life cycle SDLC process (Design, Development and Unit Testing, System Integration Testing and Functional Testing).
• Experienced in SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services).
• Experienced in creating Views, Stored Procedures, functions and Triggers using T - SQL.
• Experienced in migrating DTS Packages to SQL Server 2005 and 2008 packages by using Migration Tools.
• Exceptional hands on working knowledge and recent experience working with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Experienced in ETL - Extract Transform and Load experience using DTS & SSIS (SQL Server Integration Services) in SQL Server 2000, 2005 and 2008.
• Experienced in migrating data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column.
• Written stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects and so on.
• Experienced in writing complex T-SQL quires and stored procedures, Performance tuning.
• Experienced in developing Custom Report and different types of Chart Reports, Tablix Reports, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services.
• Deploy and manage the reports to a report server and securing and managing the reports with Reporting server.
• Excellent communication and presentation skills, self starter, quick learner and team player.
• Expert in creating and maintaining Documents for future needs.
• Ability to work in tight schedules and efficient in time management and highly motivated team player with excellent interpersonal, technical and communication skills.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008 Windows XP/Vista

Languages: T-SQL, PL/SQL, C#

Tools: /Utilities: Enterprise Manager, SQL Server Management Studio (SSMS), Query Analyzer, BIDS, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008/2012, SQL * Plus, Rapid SQL

Databases: MS SQL Server 7.0/ 2000/2005/2008, Oracle10g/9i, MS Access

Data Modeling Tools: Microsoft Visio, Ervin, Visual Studio

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Business Objects

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

SSRS/SSIS Developer

Responsibilities:

• Partnered with various Business lines to improve existing reports and create new control reports to reduce errors and streamline the process.
• Provide suggestions to assigned business line to streamline reporting and procedures as necessary.
• Creates Ad-hoc Reports dat tracks potential Audit issues.
• Pulled the data from DB2 Server by using open queries and SSIS Packages to load data into SQL Server database to create SSRS Reports.
• Experienced in creating different types of reports Drill down Reports, drill through reports, parameterized reports, matrix reports, tabular reports, chart reports as per the user request.
• Created dashboard reports (daily, weekly, and monthly) for the upper management to monitor the Home Equity loan performance.
• Deployed the report rdl files to the report manger (or) share point site to make report visible for user by using web server link, it’s easy for upper management to view the reports in report manager or share point site.
• Utilized functions in DB2 Queries to concatenate, finding date differences, finding date part, finding part of the string in DB2 Server which are different from SQL Functions.
• Worked on Team Foundation Sever 2008 to store (check in or check out) the sql queries, packages, and reports to share them with the team members. Even if the local system crashes down we can able to use the code from TFS.
• Documented the process (Upper management reports) of pulling the data from DB2 Server and load it into the SQL Server tables, so dat it could be used as a training manual for new hires and for audit validations.
• Responsible for interacting with business users to learn the business requirements and business functionality to improve the reporting process.
• Transferred data from various data sources/business systems including MS Excel, MS Access, and Flat Files etc. to SQL Server using SSIS/DTS packages using various features.
• Involved in Creating SSIS Packages to pull the data from DB2 Server, Flat files and Excel Files then load the data into the SQL Server table destination.
• Utilized different types of task’s (Execute SQL task, Data flow task, For Loop Container, For each Loop Container, Bulk Insert task) to load the data from source to destination based on business requirement with all conditions applied by task functionality.
• Used different transformations (Derived Column, Data Conversion, Condition Split, Lookup transformation, multicast, and script component transformation) under Data Flow Task while pulling and loading data from one source to another source to makes the data clean and consistent.
• Responsible for creating and scheduling the jobs to run store procedures and SSIS packages on daily manner to automate the loading process by using SQL Server Agent, adding new steps to the existed jobs in the SQL server agent.

Environment: Enterprise Manager, SQL Server 2008/2012, Control - M Manager, Visual Studio 2008/2012, SSIS, SSRS, C #, T-SQL, Performance Tuning, Visio 2010

Confidential, CA

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages, maintaining metadata repository.
• Involved in Creating New SSIS Packages (loading data from Oracle to Sql server data ware house tables) based on the existed DTS Packages functionality.
• Experienced in creating Configuration files for the packages in order to store or change the server credentials while moving to another server location.
• Used parent package variable configuration type under package configuration to pass the variable value to the child packages under the master package instead of passing them separately.
• Had to write c# code by using script transformation under the data flow task while converting the DTS Package which had a VB Script under the dataflow properties.
• Created new store procedures to the store the logic of inserting and updating data into dimension tables and fact tables.
• Migrated SQL Server 2000 Data Transformation Services (DTS) packages from SQL Server Enterprise manager to SSIS 2008 Packages by using DTS Package Migration Wizard tool.
• Deployed multiple packages to integration services server by using Deployment utility method.
• Scheduled the jobs to run the packages on daily, weekly manner by using sql server agent.
• Used different types of tasks (Data flow task, Execute sql task, Execute package task) to make the package work efficient based on the business requirement and existed DTS Package.
• Experience with using different types of transformations (Script transformation, derived column, multicast, derived column, data conversion, OLEDB Command, conditional split) under data flow task to transform the flow of the data based on the business requirement.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Developed reports using SharePoint integration services for better interaction with the users
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.

Environment: Enterprise Manager, SQL Server 2000/2008, DTS, TOAD, Visual Studio 2008, SSIS, SSRS, C #, T-SQL, Performance Tuning, Visio 2010

Confidential, Atlanta, GA

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Minimize errors and improve productivity. Basically high-level dashboard of how the departments are working. Foundational reports.
• Developed SQL queries for initial load into data warehouse dimensional and fact tables.
• Experienced in identify first level data transformations for data consistency and determine error handling policies for initial load.
• Migrated some of the sql server 2000 DTS Packages to SSIS Packages.
• Experienced in determine rules for fuzzy lookups and identify fields in fact and dimensions dat need to conform.
• Involved in creating SSIS Packages to extract the data from relational tables to dump the data into data warehouse (dimensional and fact) tables.
• Experienced in gathering business requirements from the business end users to find the measures in fact table and related attributes in dimensional tables.
• Created process to store audit metadata related to every transaction loading.
• Created identity column to populate surrogate key in dimensional table.
• Excellent T-SQL Programming skills. Involved in performance tuning by using SQL Profiler, Execution Plan.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2000.
• Created DTS packages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Experienced in using lookup transformations to get the surrogate key from dimensional tables while inserting the data (foreign key) into fact tables.

Environment: SQL Server 2000/2005/2008, DTS, Visual Studio 2005/2008, SSIS, SSRS, C #, T-SQL, SQL Profiler, Visio 2008.

Confidential, NE

Sr. SSIS Developer

Responsibilities:

• Experienced in gathering business requirements for the project to provide the documentation.
• Experienced in working with Team Foundation Server (TFS) to distribute and share the packages in the project and to use the previous versions of packages.
• Involved in extract the millions of records data from of flat files (comma delimited, fixed width) to load into the data store relational tables.
• Created SSIS packages to extract the large data (15MB) from flat files to load into the relational tables in data store.
• Transferred data from various data sources/business systems including Oracle, DB2, Flat Files etc to SQL Server using SSIS using various features like data conversion etc.
• Used various types of tasks such as Conditional Split, Derived Column, Data Conversion to validating data and redirecting the data to insert and updating the data.
• Used the SSIS Script task, look up transformations, execute SQL task, for each loop container, Data flow task in control flow to create the package.
• Used script component in data flow task to clean up the data and generating identity keys while running the package.
• Experienced in applying indexes (clustered and non-clustered) to improve the performance of the query when inserting and updating large amount of data.
• Used staging tables and temporary tables to improve the performance.
• Used Row count transformation to count the number records are extracting from the flat files.
• Involved in creating variables on month and year of the particular monthly file and use them in parameter mapping of execute sql task and run the store procedure to create a table based on dat particular month and year.
• Involved in creating configuration file with contents like (variables, connection managers) to run the package in production without making any changes inside the package.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data et
• Participating in defining ETL strategies, preparing transformation rules and mappingdatafrom source to target

Environment: SQL Server 2005/2008, Visual Studio 2005/2008, SSIS, SSRS, C #, T-SQL, Performance Tuning.

Confidential, WI

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in requirement gathering, analysis, design, development, and deployment.
• Interacting with the developers and troubleshooting the problems involved with the development of Stored Procedures, triggers and problems related to the privileges.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Converting the legacy Databases in SQL 2000 to SQL Server 2005 using SSIS. Written-SQL programs for the same.
• Worked on DTS Package, DTS Import/Export for transferring data from Database
• Responsible for Database Backups & Restoration, Backup strategies and scheduling Backups.
• Created DTS packages to pull data from Oracle and Flat Files.
• Involved in planning and monitoring Log Shipping.
• Monitoring the event logs and server error logs for troubleshooting.
• Identified the data sources and created new datasets to design the queries in SSRS for the report generation.
• Created reports using tables, matrix, charts, including expressions and aggregate functions in SSRS.
• Created complex Stored Procedures and views to be used in the reports.
• Designed and deployed various complex reports such as Pie Chart reports, Sub Reports, Drill down reports using MS Reporting Services (SSRS).
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports in SSRS.
• Design, deployment and maintenance of various SSRS in SQL Server 2005.
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS).
• Created complex SSIS packages making use of various tasks, Send mail tasks, Data transformation task, stored procedures and T-SQL commands.
• Created For each loop to iterate through a number of suppliers having multiple text files to be loaded to the warehouse.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Extensively used SSIS to move data from text files to SQL Server.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations.

Environment: T-SQL, SQL Server 2005/2008, Visual Studio 2005/2008, DTS, HTML, BCP, C#,Crystal Reports, Performance Tuning, Windows 2000, MS Access.

Confidential

SQL Server Analyst/ BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Experienced in configuring the data sources and data source views, defining dimensions and measure groups, building measures and calculate measures in SSAS.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed source/target analysis of data structures & content.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Published reports and dashboards on WEB.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Used the SSIS Script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Performed intent locking to reduce the concurrency considerably in OLTP.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Performed T-SQL tuning and optimization of queries for reports dat took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Performed Documentation for all kinds of reports and SSIS packages.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: T-SQL, SQL Server 2005/2008, Visual Studio 2005/2008, Performance Tuning, SSIS, SSRS, XML, HTML, C #

Confidential

SQL Server Developer

Responsibilities:

• Analyzed business requirements and build logical data models dat describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access. Created and managed new security accounts.
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000, T-SQL, DTS Designer, MS-Office, Crystal Reports, VSS