SUMMARY

• SQL Server developer with 7+ years of IT experience in design, development & analysis of SQL Server and SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS with expertise on ETL process.
• Experience in Designing and Implementation of Relational Database Model for business requirements using Normalization forms.
• Experienced in creating Tables, Views, Stored procedures, Functions, Clustered, Non-clustered indexes as per the business and design requirements using T-SQL.
• Good at writing complex SQL queries involving multiple tables' joins, common table expressions (CTEs), user defined functions, indexed views, cursors and DDL/DML triggers for data consistency and data manipulation.
• Implemented Triggers at different levels of Database Objects to apply Security Constraints.
• Implementation of OLTP and OLAP environment using SQL server 2012.
• Well experience in ETL methodology for designing and developing Extraction, Transformation and Load processes in dynamic and high volume data environments using various tools such as SQL Server Integration Services.
• Experienced in Importing/Exporting Data from various data sources like Flat file, Excel file, and SQL server OLEDB destinations using SSIS services.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Experience in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Experience in generating Drill down, Drill through reports using Local and Global Variables, Expressions and Filters in SSRS.
• Involved in writingT-SQLcode for implement Stored Procedures and Functions for different tasks.
• Proficiency in creating Ad-hoc Reports, Drill-Down, Drill-Through, Cascaded, Matrix, Sub-reports, Pie Chart Reports and Tabular Reports for different business domains depending on the specifications and requests.
• Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using Reporting services.
• Extensive experience in report deployment on report manager and share point server
• Analyzed SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor. Hands on experience in using tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitoring.
• Good at improving Performance using Table Indexes, Indexed Views by implementing Schema Bindings.
• Developed OLAP cubes using SQL Server Analysis Services and calculated the metrics dat were revealed in the functional analysis.
• Strong conceptual, analytical, and design skills with leadership qualities. Able to work with a team or individually with excellent communication skills, and ability to meet deadlines in a fast-paced work environment.

TECHNICAL SKILLS

Operating system: Windows Servers, Windows NT/XP, UNIX.

RDBMS: SQLServer 2000/2005/2008/2012 , Oracle 9i MS Access, MYSQL.SAP.

Data Warehousing &BI Tools: SQL Server, Business Intelligence Dev Studio,T-SQL, SSIS, SSAS, Power Play, DB Visualizer,Access Manager,)SQLServer Analysis Services andSQLReporting services.

Programming languages: C, C++, VB.NET, ASP.NET, SQL, PL/SQL, FTP

Web Designing Tools: HTML, XML, XSLT, Websevices

ETL Tools: DTS, SSRS, SSIS (SQLServer Integration services), SSAS

Development Tools: SQLServer Business Intelligence Development studio, Visual Studio, WCFVersion control Visual SourceSafe, Team Foundation Server.

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling.

DB Design Tools: ERWIN, MS VISIO

PROFESSIONAL EXPERIENCE

Confidential, Bridgeton, MO

Sr. SQL BI Developer

Responsibilities:

• Created complex Stored Procedures, triggers, tables, views and other SQL joins for applications.
• Involved in gathering requirements, business rules and deliver them in time.
• Involved in complex Views and other T-SQL code and SQL joins for applications.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Worked on Performance Tuning to reduce the runtime and increase performance & efficiency.
• Involved in SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Worked with different types of dataflow transformations like Derived Column, Data Conversion, Lookup and Conditional Split, Multicast etc.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc using SQL Server 2014.
• Used Change data capture (CDC) to load initial and incremental loads in data.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Configured Server for sending automatic mails to the respective people when a DTS/ETL process failure or success.
• Has good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Automated several legacy tasks using a combination of SQL Server and .NET (VB)
• Involved in Installation, Configuration and Deployment of Reports using SSRS.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report.
• Extensively worked on reporting using Excel Power Pivot, developed multiple pivot charts and tables while improvising the old reports.
• Designed ETL package, with ETL Import/Export wizard for transferring data.
• Designed the reports layout for creating tabular and matrix reports.
• Implemented change data capture to log the inserts, updates and process the data to different servers.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading.

Environment: SQL Server 2008/2008R2/2012/2014,ETL, Change Data Capture, SQL Server Business Intelligence tools (BIDS), SQL Server Integration Services (SSIS), MS Business Intelligence (BI) tool, VB .net, T-SQL, MS-Excel, MS SQL Reporting Services, Visual Studio 2012.

Confidential, NY

SQL (SSIS/SSRS/SSAS) BI Developer

Responsibilities:

• Creation, Development and Maintenance of SSIS Packages and SSRS Reports.
• Responsible for designing and managing project specific ETL codes using SSIS and SQL Server 2008 R2, 2012 and Oracle - fetching data across various source systems into Client specific Enterprise Data Warehouse.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle DB etc.).
• Loaded the data into destination tables: both full and incremental load, by performing different kinds of transformations like row count, Look-up, derived column, merge, script task using SSIS packages and also performed with truncating, modifying and creating tables in data base as per requirements.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages. Extensively used Joins and CTE'S for complex queries involving multiple tables from different databases.
• Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Developed SSIS template framework which can be used to develop SSIS packages in such a way dat they can be dynamically deployed into Dev, UAT and production environments.
• Created SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies based on the OLAP needs. Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
• Automated execution process, scheduling, deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and FTP and Used SQL Profiler to optimize Stored Procedures.
• Loaded fact and dimension tables as part of modified data warehouse solution. Deployed SSIS packages with minimal changes using XML configuration file.
• Used Execution Plan, SQL SERVER Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.
• Created and scheduled packages using incremental load and SCD. Written with Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server.
• Used DDL and DML for writing triggers, stored procedures to check the Pre-ETL conditions and reconciliation of data.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created SSRS Reports: involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters Tablix control and also involved in Dashboard reporting, Share Point with Power View tool, TFS etc.
• Scheduled reports to automatically generate bi-weekly, bi-monthly reports for Administrators of CMS Application. Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Microsoft SQL Server 2012/2008 R2, (SQL Server Management Studio) SSMS, (SQL Server Integration Services) SSIS, SSRS, Visual Studio 2010/2008, SQL Server Agent, SQL Profiler, TFS, Windows 2008, Oracle, MS-Office.

Confidential, Scottsdale, AZ

SQL BI Developer

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Involved in designing and implementing database applications using MS SQL Server 2008/2012 and Business Intelligence (BI) tools to support transactions and business decision-making.
• Developed complex T-SQL code for the application.
• Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Created various database objects such as tables, indexes and views based on the requirement.
• Implemented constraints on tables.
• Created various kinds of reports like Aging reports.
• Automation of creating Accounting code module for each bill.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Used different Transformation in SSIS as per design specifications.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.
• Wrote complex T-SQL queries for data extraction.
• Created DTS/SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.
• 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 various report items like tables, sub report and charts to develop the reports in SSRS.
• Created Report Subscription and Data Driven Subscription using SSRS 2008.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Monitor and provide support to the application during the testing and production environments

Environment: SQL Server 2012, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), ASP, Crystal Report, Enterprise Manager, MS Excel

Confidential, Covington, KY

SQL BI Developer

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Designed process for Push reporting using Data driven subscriptions.
• Created new schemas in data warehouse and OLTP databases to load data form production.
• Designing the SSRS reports using Table, Matrix and Sub reports with expressions.
• Designed flexible and rich report layouts using SSRS.
• Created Parameterized reports, Cross-Tab reports, Drill down, Drill-through reports using SSRS.
• Generated reports from cubes using MDX queries.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created dimensions and facts for the creation of the cubes using SSAS.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Created report models and deployed on report server.
• Intensively tested reports with Business users and implemented custom error formatting.
• Created windows forms using VB.net to manage configuration of the SSIS packages stored in SQL server Tables.
• Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like DB2 to SQL Server.
• Moved Data from flat files and Excel sheets using SSIS.
• Involved in partitioning large sized tables, to improve the performance of the queries running against them.
• Identified slow running query and optimized stored procedures and tested applications for performance, data integrity using SQL Profiler.

Environment: SQL Server 2005/2008, SSIS, SSRS, SSAS, DTS Designer, SSIS, SQL Profiler, Index Tuning Wizard, Windows 2003, XML, MS Access, MS Word.

Confidential

MS SQL Server/SSIS/BI Developer

Responsibilities:

• Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• 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 using SQL Server Integration Services (SSIS)
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Created and enhanced streamline data models and data integration strategies.
• Predictive modeling/scoring system development to calculate the risk of improper payments.
• Performance optimization for maximum efficiency, Query tuning using SSMS and troubleshoot slow running queries and stored procedures.
• Using DMV and DBCC commands for identifying missing indexes, index stats and fragmentation levels of indexes for query/stored procedure tuning.
• Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.
• Highly used T-SQL for developing complex Stored Procedures using CTE.
• Responsible for rebuilding the indexes and tables as a part of performance tuning
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Troubleshooting various issues encountered while converting existing DTS Packages to SSIS Packages.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way dat they can be dynamically deployed into Development, Test and Production Environments.
• Interacted with concerned application team in fixing the problems when ever needed.
• Modified Job scheduling, alert and notification Email settings.

Environment: SQL Server 2008/2005, T-SQL, ETL, SSIS, SSRS, SSMS, CTE, DTS

Confidential

SQL Developer

Responsibilities:

• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database to SQL Server.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights.
• Maintained a good client relationship by communicating daily status and weekly status of the project.
• Created linked servers between different SQL Servers and also created linked server with different access files used across various Used Data departments
• Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import Export wizard
• Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Develop code dat matches the prototype and specification, is maintain and, as necessary, portable to other environments.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Logical Data Modeling using ER-Win to fit business requirement.

Environment: SQL Server 2005, Enterprise Manager, SQL Profiler, DTS, T-SQL.