SUMMARY

• Over 8+ years of IT experience in Analysis, Database Design, Development, Implementation, Debugging and Testing of various software applications to support ETL, Clover ETL, Reporting and Analysis of data using MS Business Intelligence initiatives.
• Exceptional hands on experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) for 2012, 2008 R2, 2005.
• Possess solid understanding of logical and physical data modeling techniques for both relational and dimensional models.
• Proficient in database modelling for OLTP, Data Marts, Operational Data Store (ODS) and OLAP.
• Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
• Familiarity with Star and Snowflake schema data modelling techniques for OLAP database design.
• Hands on expertise with ETL process using DTS/SSIS to load and process high volumes of data for front - end, web and reporting applications.
• Proficient in migrations of earlier versions of SSRS/Cognos reports to new 2008/2012 formats.
• Strong T-SQL skills to define queries for generating drill down reports, handling parameterized reports and to create stylish report layouts in SSRS 2005/2008/2012.
• Proficient in Debugging, Testing, Deploying Complex Stored Procedures and different Database Objects across various SDLC environments.
• Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Experienced in creating different types of Tabular, Matrix, and Drill-Down, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, DTS Packages, Bulk Insert and BCP, SSIS).
• Expert in maintaining existing SSIS packages and build new packages from scratch using SSIS for all types of applications.
• Better understanding of how to handle environmental related issues and to capture data related errors in custom logging process for SSIS/ETL Packages.
• Experience in using FTP and SFTP servers to upload and retrieve files for ETL process.
• Have hands on experience and proven track record of expertise with performance tuning.
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Security, User management and Performance Tuning.
• Knowledge and exposure to perform database backup and recovery using Log Shipping and Database Mirroring techniques.
• Expertise in creating and maintaining jobs in various job scheduling systems includes SQL Server Agent job, Maestro Scheduler and Tivoli Work Load Scheduler.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages.
• Ability to comprehend business concepts and translate them into technical requirements.
• Desires to show initiative in solving problems and can work both independently and in team environments.
• Has the ability to prioritize and adapt quickly to work load changes.

TECHNICAL SKILLS

Languages and Software: MS SQL Server 2012/20 /7.0, Oracle 10g/9i, SSRS 2012/2008/2005, Share point 2010, OBIEE, Cognos, SSIS 2012/2008/2005, DTS, Informatica, C#, Visual Basic, MS Visual Studio 2008, Report Manager, MS Access, DB2, SQL, C/C++, MS-Office Professional Applications

Hardware and Operating Environments: Windows XP, Windows 2003, Windows Vista, Windows 7, IBM 30xx, PC's.

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, FL

Sr. SQL BI Developer

Responsibilities:

• Review and approve the modification of existing databases and database management systems.
• Write and code logical and physical database descriptions and specify identifiers of database to management system.
• Approve, schedule, plan and supervise the installation and testing of new products and improvements to computer systems.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Created joins and sub-queries, User Defined Functions, Stored Procedures, Triggers, for complex queries involving multiple tables.
• Involved in complete Software Development Life Cycle.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Experience in creating complexSSIS packages using proper control and data flow elements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML, Oracle, and DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created data loads and Performed Data validations.
• Created packages inSSIS with error handling, Worked with different methods oflogging in SSIS.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• DesignedDimensional ModelingusingSSASpackages for End-User and CreatedHierarchiesin Dimensional Modeling.
• Created complex expressions using the MDX scripting to solve complex designs.
• Worked on SSRS to generate reports for various user groups and developer groups with BI reporting using Excel and Power Pivot.

Environment: MS SQL Server 2012/2008R2/2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel 2013/2010, Power Pivot, Windows XP, Cognos, Star Team.

Confidential, Long beach, CA

Sr. SQL BI Developer/SSRS

Responsibilities:

• Designed and developed full-scale reporting solution for a multi-client environment using MS SQL Server 2008 and MS SSRS 2008, 2005.
• Created, implemented and maintained reporting suite of over 36 standard reports while also customizing many reports to meet individual client needs.
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created dashboards using benchmarked data to provide an analytical snapshot of point in time data.
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Deployed and Generated SSRS reports using the Reporting Services Report Manager and Microsoft SharePoint 2010.
• Deployed and maintained reports in SharePoint 2010 and played critical role in providing the support to the business users.
• Provided MS SSRS 2008 training to clients in order for them to develop their own ad-hoc reports.
• Converted Cognos Reports to SSRS Reports based on users requirements.
• Converted MS SSRS 2005 and Excel based reports to MS SSRS 2008 based reports.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Provided back-end support for functional tuning and performance testing.
• Created parameterized reports for the brokers and clients.
• Deployed the developed reports and upgraded the system.
• Deployment of the developed reports on to the server for the end users.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.

Environment: Windows 7/XP, MS SQL Server 2008/2005, SQL Server Reporting services, SQL Server Integration Services.

Confidential, Atlanta, GA

Sr. BI Developer

Responsibilities:

• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• 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.
• Setup and Maintained Snapshot Replication across multiple server environments.
• Setup and maintained Linked Servers.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008 R2/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports.

Confidential

SQL Server Developer

Responsibilities:

• Installed SQL Server 2005 on development and production servers setting up databases, users, roles and permissions.
• Upgraded all SQL Server 2000 to SQL Server 2005 without any service interruption.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• Involved in the normalization and de-normalization of the databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2005.
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2005.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Created SSIS packages to transfer data from different data sources load it to data warehouse.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
• Migrated DTS packages to SSIS packages using package migration wizard.
• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services. Wrote MDX queries according to the business requirements.
• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2005 Reporting Services (SSRS).
• Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies and scheduled jobs using SQL Server Agent.
• Deployed code into the production environment. Provided 24/7 production support for the production database.

Environment: MS SQL Server2005, SQL, T-SQL.

Confidential

SQL Server Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access (using DTS, T-SQL, scripts, stored procedures and views).
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests from the clients and from the development teams.
• Designed and developed the Logical and Physical model of the database.
• Worked on Performance testing of the Application using Load Runner.
• Created automated test scripts using QTP and Win Runner.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, and Indexes.
• Created and automated the regular jobs.
• Managed and monitored the system utilization.
• Managed the security of the servers (Logins and users).
• Developed complex T-SQL code for the application.
• Designed stored procedures and triggers for automating tasks.
• Worked on complex data loading (implemented the batch data cleansing and data loading).

Environment: MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.