PROFESSIONAL SUMMARY -

• 7 years of experience in design, development, testing, performance optimization and reporting using SQL Server Database Engine and Studios.
• Extensive experiences in developing Stored Procedures, Views, Triggers and Complex Queries, generating cubes on SQL Server 2000/2005/2008/2012/2012R2.
• Excellent experience and understanding of database design, migrating data using SSIS, relational integrity, Constraints, OLAP, OLTP, Cubes and normalizations.
• Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2008.
• Experience in working with SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Proficient in Database performance optimization, debugging and tuning using the SQL Editor, SQL Profiler and SQL Server Debugger.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008.
• Extensive expertise in implementing High availability: Mirroring, Log shipping and Replication.
• Extensive experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access
• Knowledge regarding cubes and developed measures and dimension members using Multi Dimensional Expression (MDX) to meet additional needs dat were calculated from existing measures.
• Excellent experience as a Crystal Reports Developer working on large-scale enterprise projects involving complex business case functions, web integration, and data management.
• Proficient in using Crystal Management Console, Crystal Configuration Manager, Crystal Repository, Crystal Migration Wizard and Crystal Publishing Wizard for publishing reports on the Intranet.
• Experienced with converting Crystal reports to SSRS reports and migrate crystal reports to higher versions.
• Experienced in capturing data changes made to the tables.
• Maintained Data quality, experienced in loading and transforming complex data using Talend open studio.
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, SQL Profiler, Tuning Advisor, SQL Analyzer, Query Analyzer, Replication, SQL Server Business Development Studio (BIDS), SSAS (SQL Server Analysis Services).

Databases: SQL Server 2012/2008R2/2008/2005, Oracle, MS-Access.

Scripting Languages: T-SQL,PL/SQL,ASP.NET, VBScript, Java Script

ETL and Reporting: DTS/SSIS, SSRS.

Operating Systems: Windows 7/Vista/XP/2008/NT/, Unix/Linux

Other Tools: VS, Erwin, IBM Rational Clear Case, MS Word, MS Office, MS Visio, Adobe Acrobat (Reader, Photoshop).

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

MSBI/ SQL Developer

Responsibilities

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Involved in writing stored procedures, Triggers, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules. Experience in creating joins for complex queries involving multiple tables.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Involved in query optimization and tuning stored procedures for better performance.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds ofTransformations (Data Conversion, Lookup, Derived Column, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Slowly Changing Dimension, Union All etc)inSSISas per the clients Requirement.
• Experience in providing Error handling by using Event Handler for SSIS Packages.
• Worked with different methods of logging in SSIS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Created stylish Report Layouts and Deployed the Reports using SSRS.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.

Environment:SQL Server 2012, SQL Server Management Studio, Enterprise Manager, Erwin, Windows Server, SQL Server Business Development Studio (BIDS), DTS/SSIS, SSRS, SSAS, MDX, DMX, SSRS, Windows.

Confidential, Richardson, TX

MS BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Create indexes on the feed store production Database to improve performance.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Views to reduce database complexities for the end users.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports dat take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Used SQL Profiler for creating traces by which a suggestion for the query is analyzed by SQL query analyzer.
• Generated reports using SSRS dat could be used to send information to different Primary Vendors, Clients, and managers.
• Migrated data from one database to other database using SSIS.
• Developed test reports for the test cases and updated the changes of the test cases in the data ware house.
• Generated reports based on the test cases.
• Performed Documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Involved in database performance and maintenance duties such as Tuning.
• Documented the project work and process

Environment: SQL Server 2008 R2/2012, Crystal Reports, SSRS, DTS/ SSIS, Enterprise Manager, SQL Server Business Development Studio (BIDS), Visual Studio, Windows.

Confidential, Fort Lauderdale, Florida

MS SQL Developer/ETL/SSIS/SSRS Developer

Responsibilities:

• Gatheird user requirements and analyzed and designed software solution and database.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Created complex Stored Procedures, triggers, tables, views and SQL joins and statements for applications.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2008.
• Developed measures and dimension members using Multi Dimensional Expression (MDX) to meet additional needs dat were calculated from existing measures.
• Implemented the calculations to aggregate physical measures using management studio.
• Defined Referenced relationships with the measure groups and fact tables.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Communicated with the business users for gathering of requirements.
• Involved in Quality Assurance checks on data retrievals on a daily basis.
• Documented the project work and process.

Environment: SQL Server 2008 R2/2012, SQL Management Studio, T-SQL, Windows Server, DTS/SSIS, SSRS, Windows.