SUMMARY

• Over 7 years of experience in IT industry as a SQL Server Developer with specialized skills in SSIS, SSRS
• Experience in all phases of Software Development Life Cycle (SDLC)
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Expert in handling errors, logging using Event Handlers using SSIS
• Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS.
• Proven noledge of enterprise Reporting and Business Intelligence
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Highly motivated and adaptive with the ability to grasp things quickly and possess excellent interpersonal technical and communicational skills.
• Strong troubleshooting and problem solving skills and strong ability to prioritize multiple tasks.
• Extensive noledge of Relational Database Management System (RDBMS) Concepts
• Well versed in Normalization/De - normalization techniques for optimum performance in relational and database environments.
• Experience in using SQL Server 2008, 2005, 2000 and Oracle 10g
• Expertise in writing Stored Procedures, Triggers, Views and Functions using SQL and PL/SQL.
• Experience in Query optimization/Performance tuning.
• Extensive experience in using T-SQL (DML, DDL, DCL) in SQL Server 2000/20005/2008 platforms.
• Experience in Deploying reports in various sources like Web browser in XML and PDF formats.
• Experience in building Deployment environment in ETL projects.
• Excellent analytical, interpersonal and communication skills & desire to excel, fast learner, hardworking and versatile team player.

TECHNICAL SKILLS

Database: SQL Server 2012/2008/2005 , Oracle 10g

Operating System: Windows 95/98/2000/XP/2003/07, Unix, Linux

Tools: SSIS

Source Control Tools: Microsoft Visual SourceSafe

Languages: T-SQL, PL/SQL, UNIX Shell ScriptingDB Utilities,SQL Profiler, SSMS,SQL Developer

Web Technologies: HTML, XML

Other Applications: MS Office, Adobe Acrobat Reader/Writer

Reporting: SSRS, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Senior Sql Developer

Responsibilities:

• Wrote complex Stored procedures to fetch the data from the give Jobs.
• Created databases, tables, views, functions, and triggers using T- SQL.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• Designed many technical documents individually to halp the team understand the requirement for Building packages using SSIS.
• Built deployment environment for the data feed inbound development.
• Responsible for Deploying, Scheduling, Alerting and Maintaining SSIS packages
• Built controller package which halps associating all the packages.
• Migrated data from Legacy to CRM using SSIS
• Used Execution Plan to optimize and enhance the performance of SQL Queries
• Handled error logging and row level loggings while creating dynamic packages
• Performed unit testing for every package created
• Worked on latest version of all software’s like visual studio 2012 ultimate, Management Studio 2012
• Have great ability to work on TFS
• Worked on Agile Method with 3sprints.

Environment: MS SQL Server 2012, Visual Studio2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Windows Server 2008, MS - Visio

Confidential, Alpharetta, GA

Sr BI Developer

Responsibilities:

• Gathered business requirements for creating the new mission-critical databases from business analyst, project manager, other internal employees as well as customer feedbacks.
• Migrated databases from old servers to the new server.
• Created subscriptions in Report Manager as an automated process to deliver the reports directly to the client (end user) as an email attachment.
• Worked with different report items like Tablix, Matrix, Charts etc.,
• Sub-reports were created and called into Master report to show various parts of information on a single display.
• Developed performance efficient stored procedures and transact SQL queries to pull the data into reports.
• As per the client requirements, rendered the Reports in the form PDF, Excel and .CSV formats
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced features of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Migrated DTS packages to SQL Server Integration Services and modified the existing packages by using the advanced features and tools
• Extracted, cleaned and validated from XML file into database using SSIS task (XML source).
• Used Execution Plan to optimize and enhance the performance of SQL Queries.
• Developed new objects (me.e. Tables, Views, and Stored Procedures) in SQL server 2008R2 database
• Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.
• Developed and Deployed reports/report model using SQL Server Reporting Services.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: MS SQL Server2008R2, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), Windows Server 2008, MS - Visio, MS- Access

Confidential, Bethesda, MD

Sql/BI Developer

Responsibilities:

• Involved in all phases of project development life cycle.
• Created logical and physical database design using Microsoft Visio.
• Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Worked with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Conversion, Term Extraction, Conditional Split, Derived Column, Pivot etc.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Deployed different SSIS packages on development and test environments.
• Developed reports in SSRS 2008R2 using Table Control, Matrix Control for Cross Tab reports.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports using SSRS.
• Designed Report Templates, Bar Graphs and Pie Charts based on the sales data.
• Worked on querying data for Creating On-demand Reports using Report Builder in SSRS and send the reports via email.
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
• Enhanced performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
• Implemented best practices in structuring SQL queries, Debugging Unexpected SQL Results etc.
• Developed and created the new database objects including Tables, Views, Index, Stored procedures, Functions and Advanced Queries.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), Windows Server 2003/2000, MS - Visio

Confidential, Portland, ME

SQL/BI Developer

Responsibilities:

• Involved in requirement gathering and database design using Erwin.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and developed Complex SSIS packages for auditing using SQL Server Integration Services (SSIS).
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Worked with different Control Flow elements like For Loop Container, for each Loop Container etc
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2005.
• Created Parameterized Reports and Linked Reports and thorough noledge of report server architecture using SSRS.
• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Created Complex Stored Procedures and automated them using SQL Server Agent.
• Created Triggers (Instead Of and After) for Auditing Purpose.
• Created Views and Indexed Views for the Performance Tuning.
• Created automated T-SQL scripts to process summary database transactions that run off-hours.
• Created Linked Servers to retrieve data from other databases.
• Monitored and modified Performance using execution plans and Index Tuning.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: MS SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS)

Confidential, Norristown, PA

BI Developer

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2008R2.
• Experience in creating reports using SSRS and worked on OLTP environment
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations (For loop, bulk insert, Data flow, Data mining, FTP, XML tasks, etc) using SQL Server Integration Services (SSIS).
• Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Used Package Configurations to pass parent package variable values to child package variables.
• 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, Conditional Split.
• Created SQL tables for storing Rejected rows.
• Deploying SSIS packages from various sources like bids, Management Studio, file systems etc.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Developed Cross-Tab, Drill-down, Drill Through and Sub-Report using SSRS. Promoted RDLs to Reporting Server.
• Used Subscriptions and Snapshots to set up Push based Report Delivery.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Designed and implemented SQL Server database objects (stored procedures, functions, views and complex T-SQL/queries) to support data integration (SSIS), reporting and various business processes.

Environment: SQL Server 2008, Query Analyzer, SSIS, SSRS, SQL Profiler, C#, Visual Basic, MS Excel, Window Server.

Confidential

DataBase Developer

Responsibilities:

• Interacted with users to collect and analyze the specifications and designed documents, includes functional and technical specifications.
• Designed Logical and Physical design of database for project on basis of user requirements.
• Created new tables, stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Responsible for designing Schema and finalization of naming and coding standards throughout project life cycle.
• Designed various E-R diagrams for different modules by using Erwin and Visio
• Entity Relationship Diagrams (ERD) to successfully design a flexible database. Maintaining online documentations for the entire source code.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Experience in planning and implementing MS SQL Server Security and database permissions.

Environment: SQL Server 2000, Oracle 9i, HTML, T-SQL, PL/SQL, SQL Loader and Windows NT