SUMMARY

• 9 years of IT experience as SQLdeveloperin design and development of various applications for Financial, Banking and Manufacturing Industries.
• Experience wif 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 TEMPeffective 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 teh 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 wif drop down menu option, sorting teh 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 wif 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 wif interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS

Operating Systems: Windows

Version control tools: Visual Source Safe (VSS), Subversion (SVN), and Team Foundation Server (TFS)

Others: ER-Win, and MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Sr. MSBI Developer (SSIS/SSRS/SSAS Developer)

Responsibilities:

• Understanding teh business requirements.
• Extracted teh data from teh different sources and stored teh data into teh intermediate Staging Database using teh 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 teh SQL documents which included installationand data conversion Procedure documents.
• Migrated all teh reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing teh version on Sand Box.
• Conducted data migration processes in teh 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 wif 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 wif teh use of triggers.
• Deployed teh SSIS Packages to teh MSDB as well as File System based on teh requirements
• Involved in teh development of custom SQL, T-SQL, custom stored procedures, functions and triggers.
• Created teh automated processes for teh 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 teh Import/Export Wizard.
• Developed Cross-Tabbed and Sub-Reports in SSRS2008R2/2012.
• Designed and Developed matrix, tabular and parametric Reports in teh 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, Pittsburgh, PA

MS SQL BI Developer (SSIS/SSRS/SSAS Developer)/ETL Developer

Responsibilities:

• Actively interacted wif end users, team lead, and business analysts to fully understand teh requirements.
• Developing database and data feed solutions; administering databases and database servers.
• Participating in teh build and deployment cycle.
• Contributing in all phases of development projects while providing support to existing clients.
• Created/developed/maintained teh stored procedures, triggers to interpret complex business rules.
• Performed Data modeling organizing teh 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 teh datasets for generating teh report.
• Designed and written teh queries in teh query builder for retrieving teh data.
• Created and worked wif drill down reports and identified teh report parameters.
• Used various report items like tables, sub report and charts to develop teh reports in SSRS.
• Deployed and generated reports on to teh server using teh Reporting Services Report Manager.
• Worked wif various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created subscriptions to provide a daily basis reports.
• Created Dimensions wif teh cube wizard and also individually and Generated Named calculations and named queries.
• Used multiple transformations in SSIS to meet teh business requirements by extracting data from heterogeneous source systems, transform and finally loaded into teh 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 wif 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 teh coding standards and procedures.

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