PROFESSIONAL SUMMARY:

• 7+ years of administration and development experience on Database Design and Development in SQL server 2005/ 2008/2012/2014 system in OLTP and OLAP environment.
• Excellent command on SQL SERVER 2008/2012/2014 .
• Data modeling using Erwin Data Modeler and MS Visio.
• In - depth knowledge of Transact-SQL (DDL, DML).
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Excellent skills in implementing ETL Packages using SSIS 2014/2012/2008/ 2005 .
• Experience in creating master and child packages, package configurations and logging.
• Excellent knowledge of using variables and expressions in packages.
• Migrated DTS packages to SSIS and modified using DTS editor.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility. Involved in transformation of OLTP data to the Data Warehouse using DTS and SQL commands.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Expertise in generating reports using MS Reporting Services 2014/2008/2005.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Created dashboard reports for financial and mortgage domain.
• Good knowledge of financial domain data.
• Excellent command on subscriptions, report snapshot and report cache.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team.
• Some experience in DB2 queries.
• Experience in .NET coding.
• Good skills in MSACESS.
• Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives.
• Good skills with computer science concepts and programming.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS:

Languages: TSQL, PL/SQL, VB, XML, C, C++, HTML, .Net tools

Data Warehouse Tools: DTS, Enterprise Manager, SQL Profiler, SSIS, SSRS, SSMS, Business Intelligence Development Studio, SQL Server Data Tools

Database: MS Access, MS SQL Server 2000/2005/2008/2008 R2/2012/2014, Oracle 8i/9i/10g

Tools: / Utility: SQL Server Management Studio(SSMS), Database Tuning Advisor, Analysis Manager, BCP, SQL Profiler, Attunity 2.0, Toad, Team Explorer

Other Tools: MS Office, Visio, Ms Excel, MS-Project 2000, Informatica 7.1.1, SQL Search 2, SQL Compare 11, SQL Prompt 6, SQL Source Control 3, Team Foundation Server (TFS).

Reporting Tools: Excel, SQL Server Reporting Services 2005, 2008,20122014 Crystal Reports

Operating System: Windows NT/98/2000/XP/2003/2008/7 server

PROFESSIONAL EXPERIENCE:

Confidential, Grand Rapids, MI

SQL Server Developer SSRS/ SSIS

Responsibilities:

• Using SSRS from OLTP and OLAP data sources and deployed on report server Integration SSIS
• Used Team Foundation Server (TFS) for version control, source control and reporting.
• Designing and developing SQL Server 2014 Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, History data and audit analysis.
• Written complex SQL queries using joins, sub queries and correlated sub queries.
• Created T-SQL Triggers and Stored Procedures to retrieve updated and deleted data from Different servers from different locations
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Created several SQL scripts in order to have required check constraints, Indexes, and Views as per existing Business Rules. Also Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/file groups/Files/transaction logs.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery for the data
• Actively participated in User Acceptance Testing and Debugging of the system.
• Updating the team in daily scrum about the status of the tasks assigned
• Creating complex stored procedures to support the .net front end application
• Discussing with solution architect and deployment engineers about changes to the proposed solution
• Used TFS (Team Foundation Server) to maintain the SSIS packages
• Monitoring SQL Agent Jobs and reporting issues to DBA and working on bug fixing.
• Administering TFS server, managing security, branching, merging, and comparing codes for various projects
• Provided production support for the ETL jobs and also to the code deployed into the production environment.

Environment: MS SQL Server 2008, MS SQL Server Reporting Service 2005/2008, MS SQL Server Integration Access, MS Excel, Erwin, Windows Server 2014 T-SQL,TFS,VSS, HTML, XML, ODBC, MS Visio 2014

Confidential, Grand Rapids, MI

SQL Server Developer SSRS/SSIS

Responsibilities:

• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), DB2 and Excel Spreadsheet to SQL Server 2008.
• Worked extensively on DTS Package designs for Import/Export from various Data Sources; Flat file, Excel, MS Access to MS SQL Server.
• Created and executed SQL SSIS packages to populate large volume of data from the various data sources. .
• Used merge statement for slowly changing dimension type1 and type2.
• 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(Control flow transformations such as Ftp Task, For Loop Container, For Each Loop Container, Execute package task, Execute process tasks, Script tasks, send mail task, Data Reader Task, XML Task and Data flow transformations such as Lookup, Conditional Split, Derived Column, Audit, Merge, Merge Join, Sort ) using SQL Server Integration Services (SSIS).
• Created pre and post execution process to track package with error handling event handler.
• Used cache transformation to temporary load data in cache from flat files and used lookup transformation to compare data for incremental updates, separated suspended records.
• Used merge statement to populate sdc1 and scd2.
• Provided notifications for error, success and load details of packages.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2005/2008.
• Wrote Stored Procedures for various reports such as Grouping, Sorting, Drill-down, and Parameter prompts using SQL Server SQL Server 2005/2008.
• Created subscriptions.
• Deployed reports on report server.
• Created parametric reports, sub reports based on business requirements.
• Used multiple data sources and complex queries to extract data for reports.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Provided production support for the ETL jobs and also to the code deployed into the production environment.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: MS SQL Server 2008, MS SQL Server Reporting Service 2005/2008, MS SQL Server Integration Access, MS Excel, Erwin, Windows Server 2003, T-SQL,TFS,VSS, HTML, XML, ODBC, MS Visio 2003.

Confidential, Columbus, OH

SQL Server/ BI Developer

Responsibilities:

• Created SSIS packages to clean and load data to data warehouse.
• Documented framework as proto type of package design.
• Created package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created a table to save dirty records.
• Used merge transformation to populate sdc1 and sdc2.
• Extracted data from oracle,DB2 to load to data warehouse.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Created report snapshots and cache for better performance.
• Used Notification services to generate error messages and send them.
• Created ad-hoc reports, drill down, and drill through reports.
• Reviewed and adjusted deliverables involved during SDLC involving database changes/development.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Successfully designed reports in MS BI tool.
• Provided knowledge transfer to the company’s SQL programmers.
• Designed stored procedures and cursors.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: SQL Server 2005/2008, BIDS 2008, Reporting services 2005/2008, Integration services 2005/2008, Windows Server 2003, HealthCare database, Oracle 9i,DB2,Share point server, MS BI, Visual studio.

Confidential

SQL Server Developer SSIS/ SSRS

Responsibilities:

• Worked with Business Analysts and Users to understand the requirement.
• Implement logical design into physical design.
• Maintained design structure (Schema) by directing implementation of SQL standards and guidelines.
• Created a virtual machine and migrated databases.
• Migrated DTS packages using DTS editor wizard in SSIS, validated and tested all packages on development server.
• Tested all stored procedures on testing server.
• Created Stored Procedures, triggers, UDF, views, tables and generated TSQL script for application
• Created indexes for better performance.
• Tested the data with complex queries, joins and sub queries.
• Successfully migrated the data from SQL Server 2000 to SQL Server 2005.
• Created packages to migrate data from different data sources to data warehouse.
• Created packages for database maintenance.
• Executed Back up database task, check database integrity, rebuild indexes, update statistics task for m
• Data migration (Import & Export using BCP) from text to SQL Server2005.
• Used BI tools to create packages and reports.
• Identified the Measures and Dimensions from the Excel Sheet.
• Successfully Extracted transformed and load data into data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Deployed the generated reports directly on the client’s workstation.
• Created complex Stored Procedures for better performance to generate reports.
• Created standard and data driven Subscription, used report manager for securities.
• Created report model for Ad-hoc reporting, generate report in XML format.

Environment: SQL Server 2005, SSIS, SSRS, Query Analyzer, Index Tuning Wizard-SQL MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition.