OBJECTIVE:

To work for a progressive organization in a highly motivating and challenging environment that provides the best opportunities to grow and utilize my potential to the fullest to achieve the organization’s goal while achieving my personal goals.

SUMMARY:

• 7 years of experience as Business Intelligence Developer and SQL Developer in Production, Development and Staging Environments.
• Worked in various domains like Banking and Tele Communication.
• Experienced in Software Development Life Cycle (SDLC) involving system analysis, design development and implementation using Waterfall Methodology and Agile Methodology.
• Involved in Huge data migrations, transfers data using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in Installation, Configuration and Updates of SQL Server 2005/2008/2008 R2/2010/2012.
• Excellent T - SQL Developer skills including Stored Procedures, Indexed Views, Joins, Sub Query, User Defined Functions, Triggers and Distributed Transactions.
• Good knowledge in Performance Tuning, Optimization and Data integrity by using SQL Profiler.
• Experience in solving Real Time issues with Index Fragmentation, Query Tuning, Error and Event Handling.
• Experience in BI Development and Deployment of SSIS packages from MS-Access, Excel and Oracle.
• Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad hoc and Sub Reports.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS:

Languages: TSQL, PLSQL, Java, C, C++, C#

Databases: MS SQL 2005, 2008/R2, 2012, MS Access, Oracle 9i, SQL Azure Database

ETL Tools: SSIS 2005/2008/R2/2012

Reporting Tools: SSRS 2005/2008/2012, Crystal Reports

Scripting Languages: HTML, VBA, PHP, SCOPE

Operating Systems: Windows XP/Vista/2000/2003, UNIX, MS-DOS

Source Control: Visual Studio TFS 2008/2010/2012, SourceSafe

Servers: Windows Server 2003,2005,2008,2012,2015 Advanced Server

Data Model: Erwin, Toad Data Modeller

PROFESSIONAL EXPERIENCE:

Confidential, WA

SQL Server BI Developer

Responsibilities:

• Designed and implemented the Logical and Physical model of the database using Erwin.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure and Constraint by SQL Server.
• Developed and optimized data structures, Stored Procedures, Dynamic Management views, DDL Triggers and User-Defined Functions .
• Tuned, Monitored and maintained SQL Server Jobs.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Involved in Query Optimization, Performance Tuning and Rebuilding the Indexes Confidential regular intervals for better performance.
• Worked with SQL Server Analysis Services (SSAS).
• Multidimensional Expressions (MDX) is to make accessing data from multiple dimensions.
• Pulling data on daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Used link servers in cases where data is to be pulled form a different database like oracle.
• Worked in OLAP environment where star schema is implemented, creating and identifying fact, dimension tables and establishing proper relations between them.
• Created special dimension tables like time dimensional tables.
• Created cubes and dimensions and measures and calculated measures per the business requirements .
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Browsing the cube for analysis and validation of the data.
• Processing the cubes and dimensions on daily basis using the SSIS tasks.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using SSIS 2014.
• Export or Import data from other data sources like flat files using Import/Export through SSIS 2014.
• Created SSIS package to load data from Flat File to Data warehouse using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation and Slowly Changing Dimension.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through reports and Sub reports using SSRS 2014.

Environment: Windows Sever 2014, MS SQL Server 2012/2014, SSIS 2012/2014, SSRS 2012/2014, T-SQL, SQL Server Profiler, Team Foundation Server and Erwin.

Confidential, NJ

SQL Server Developer

Responsibilities:

• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package
• Involved in Creation of Dimensions using STAR Schema
• Used Lookups Transformation to get the data from reference data sets
• Scheduling the SSIS packages and Jobs
• Created SSIS Packages to migrate slowly changing dimensions.
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
• Transferring data between XML document and SQL server.
• Performed activities such as database creation, database tuning, performance planning, backup planning and database administration
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.

Environment: SQL Server 2014 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, Erwin, XML, VB.NET, MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2000, Oracle.

Confidential, CA

T-SQL SSIS/SSRS Developer

Responsibilities:

• Installed SQL server 2012.
• Designed and implemented the Logical and Physical model of the database using Erwin.
• Created database tables using normalization technique.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Involved in migrating huge amount of data from legacy database to the newly designed Normalized database using SSIS.
• Involved in using migration techniques like BCP, SSIS and regular stored procedures and scripts.
• Pulling data on daily basis from OLTP database to OLAP or staging database using SSIS packages.
• Created indexes to increase the reports performance.
• Used the reporting tools MS SSRS 2012 to build the reports.
• Expertise Confidential using SSRS 2012 to build various kinds of reports based on requirements. Developed Drill-through, Drill-down, Sub reports and Cascading reports.
• Developed complex stored procedure using T-SQL to generate reports using SSRS 2012.

Environment: Windows Sever 2012, MS SQL Server 2012, SSIS 2012, SSRS 2012, T-SQL, SQL Server Profiler, Team Foundation Server and Erwin

Confidential, CA

SQL Server BI Developer

Responsibilities:

• Designed Database Models, Entity Relationship diagrams using Toad data modeler and MS Visio 2010.
• Involved in performance tuning and optimization of stored procedures and queries.
• Extensive use of Dynamic SQL, to increase the performance, efficiency and quality of code.
• Involved in development and debugging of complex batch T-SQL Procedures and Functions.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables and Views to implement business rules.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Generated scripts to Backup and Restore Data bases.
• Created SSIS packages to clean data and load data to SQL Server.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, term extraction, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task 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.
• Experience in creating scheduling jobs, alerts, SQL Mail Agent and scheduled SSIS packages.
• Configured SQL Mail Agent for sending automatic emails when SSIS packages are failed or succeeded.
• Done Migration from 2005 packages to 2008 R2 using SSIS Packages.

Environment: Windows Sever 2008 R2, MS SQL Server 2005/2008 R2, SSIS 2008 R2, T-SQL, Toad data modeler, SQL Server Profiler and Team Foundation Server.

Confidential

SQL Server Developer

Responsibilities:

• Installed SQL Server 2008/2008 R2.
• Designed Database Models, Entity Relationship diagrams using Toad data modeler.
• Involved in Normalization & De-normalization of database.
• Created and modified database objects like Table, Views, Store Procedure, Triggers and Functions using T- SQL.
• Designed and developed the required SQL Stored Procedures and Database functions using SQL Server 2008.
• Involved in performance Testing and Performance Tuning.
• Created complex queries by using Joins and Sub Queries.
• Involved in improving the performance of query by using Query Optimization Techniques.
• Worked on Clustered and Non-Clustered index to improve the access of data within the database.
• Maintained the physical database by monitoring Performance, Integrity and Optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Deployed database objects from Development/Testing environment to Production environment.

Environment: Windows Sever 2008/R2, MS SQL Server 2008/R2, T-SQL, OLAP Service, SQL Server Profiler, Team Foundation Server, Toad Data Modeller.