PROFESSIONAL SUMMARY:

• 6 years of IT experience as SQL developer in 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/2008/2008 R2/2012.
• 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 ( Confidential ) 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 ( Confidential ).
• 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 Confidential .
• Involved in by DNSUnlocker">optimizing code 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 Confidential for accessing and analyzing cubes and dimensions.
• 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 ( Confidential ) 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.

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:

Sr. ETL MSBI developer

Confidential

Responsibilities:

• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Design and tune ETL process.
• Working closely with the Guideware team on business aspects.
• Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Configured files to deploy the SSIS packages across all environments.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Used Confidential to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in Confidential .
• Designed and implemented Parameterized and Cascading Parameterized reports using Confidential .
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using Confidential . Configured and maintained Report Manager and Report Server for Confidential .
• Creating ad hoc queries according to business need and tuning existing queries to meet business standards.

Environment: MS SQL Server 2008/2012, Red Gate tools, PowerPivot, TFS 2013, MS Confidential /SSIS 2012, T-SQL, Visual studio 2013, MS Visio

Confidential, Springfield, MA

MSBI Developer

Responsibilities:

• Involved in the analysis of the requirements and gathering requirements for closed loop project.
• Involved in creating tables and their relationships in the data warehouse.
• Created Technical Report Requirement document for the Standard Reports.
• Developed large number of standard and customized reports usingSSRSfor data feeds and for Reports on server.
• DevelopedDynamic Report Enginefor creating the customized reports inSSRS.
• Involved in creatingDynamic Stored Procedures and views.
• Involved in analyzing and gathering the requirements forRow level SecurityandRole based security.
• Created the technical requirementDocumentationfor Row level Security and Role Based SecurityETL’s.
• Implemented Row level security and Role based Security in the Standard Reports.
• Involved in creating the tree view folder structure in the application usingC#.netto handle different reports.
• Involved in Creating and Testing theSSISpackages developed for security.
• Involved in creatingSSISpackages to migrate large amounts of data.
• Involved in usingSSASdata sources inSSRSreports.
• CreatedDatabases,Tables,Cluster/Non-Cluster Index,Unique/Check Constraints,Views, Stored Procedures, Triggers.
• Involved inperformance tuningof queries for query efficiency.

Environment: MS SQL Server Management Studio,MS SQL Server Integration Services (SSIS), MS SQL

Confidential, Pleasanton, CA

Sr. MSBI Developer (SSIS/ Confidential 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 Confidential . Tasks included defining requirements, design, develop, test, implement and maintain reports using Confidential 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 UPDATEand delete data from OLTP systems.
• 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, Confidential 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 s.

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

Confidential, Pittsburgh, PA

MS SQL BI Developer (SSIS/ Confidential Developer)/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 Confidential 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 Confidential .
• 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 Confidential . Tasks included defining requirements, design, develop, test, implement and maintain reports using Confidential 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 Confidential report templates for ease of report development.
• Created daily, weekly, monthly, quarterly, semi-annual and annual Confidential reports for Military commanders.
• Used TFS to Check in and check out SSIS packages, Confidential 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, Confidential, SQL Profiler.

Confidential

MS SQL Developer

Responsibilities:

• Conducted Performance tuning/MS SQL server development - SQL Profiler, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, advanced queries, views, Indexes, and Functions for databases.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Responsible for database security of the operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: MS SQL Server 2000/2005, MS Projects 2007(v12.0), T-SQL, DTS, Microsoft Visual Source Safe, MS Visio 2007, SQL Server Management Studio (SSMS).