SUMMARY:

• 9 years of IT experience as SQLdeveloperin design and development of various applications for Financial, Banking and Manufacturing Industries.
• Experience with scripting in T - SQL, constructing tables, joins user functions, views, indexes and user profiles.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective Triggers to facilitate efficient data manipulation and data consistency in MS SQL Server SQL 2005 and SQL 2008 and SQL 2008 R2 and SQL2012.
• Experience working on Normalized Databases and designed database/tables and the requisite relationships, designed partition tables and partition views.
• Implemented cursors for rebuilding indexes.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL Server Analysis Services (SSAS) of MS SQL server
• Expertise in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server
• Proficient in merging data from various data sources using SSIS.
• Developed Tableau visualizations to support ad-hoc analyses.
• Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS).
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS … …
• Experience in creating Multidimensional cubes using SSAS.
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).
• Involved in by DNSUnlocker">optimizingcode and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Strong individual with Technical, organizational, analytical and design skills.
• A skilled problem-solver and an efficient Team player, collaborative and self-starter, excellent oral and written skills.
• Experience in creating reports through SSRS for accessing and analyzing cubes and dimensions.
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS/SSDT).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr. MSBI Developer

Responsibilities:

• Understanding the business requirements.
• Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transformed Complex business requirements into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.
• Maintained all the SQL documents which included installationand data conversion Procedure documents.
• Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2012.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2008R2.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Wrote complex Stored Procedures, coding and triggers to capture UPDATEDand deleted data from OLTP systems.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Experienced in implementation of strong referential integrity and auditing with the use of triggers.
• Deployed the SSIS Packages to the MSDB as well as File System based on the requirements
• Involved in the development of custom SQL, T-SQL, custom stored procedures, functions and triggers.
• Created the automated processes for the activities such as database backup.
• Processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and WINDOWS Scheduler.
• Created copies of operational Databases using the Import/Export Wizard.
• Developed Cross-Tabbed and Sub-Reports in SSRS2008R2/2012.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2012.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Created complex SSIS packages using various transformations.
• ETL process was documented for future references.

Environment: Microsoft SQL Server 2008R2/2012, SQL Server Reporting Services (SSRS), Management studio, XML, SQL Server Integration Services (SSIS), Windows Server XP.

Confidential, Pleasanton, CA

ETL Developer

Responsibilities:

• Actively interacted with end users, team lead, and business analysts to fully understand the requirements.
• Developing database and data feed solutions; administering databases and database servers.
• Participating in the build and deployment cycle.
• Contributing in all phases of development projects while providing support to existing clients.
• Created/developed/maintained the stored procedures, triggers to interpret complex business rules.
• Performed Data modeling organizing the data and provide proper structure to database by implementing constraints to tables.
• Extensively involved in debugging and tuning of T-SQL queries, SSIS packages and SSRS reports.
• Created data sources, connection strings and defined the datasets for generating the report.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created subscriptions to provide a daily basis reports.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally loaded into the Database.
• Implemented full text indexes for property address searches.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2008R2.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Wrote complex Stored Procedures, coding and triggers to capture updatedand deleted data from OLTP systems.
• Created SSRS report templates for ease of report development.
• Created daily, weekly, monthly, quarterly, semi-annual and annual SSRS reports for Military commanders.
• Used TFS to Check in and check out SSIS packages, SSRS Reports and database code (Version Control).
• Documented all the coding standards and procedures.

Environment: SQL Server 2008R2/2012, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSRS, SQL Profiler.