SUMMARY:

• MS SQL Server Developer with 6+ years of strong experience in various domains like Financial, Retail and insurance with expertise in MS SQL Server 2012/2008R 2/2008/2005/2000 and SSIS, SSRS, SSAS.
• Proficient in installing, configuring, managing, monitoring and troubleshooting MS SQL Server 2012/2008/2008 R2/2005.
• Developed Logical and physical data model using ERWIN, ER Studio and mapped the data into database objects.
• Generated sub reports, cross - tab, conditional, drill down reports, drill through reports and parameterized reports using SSRS 2012
• Introduced best practices for Data Services and Crystal Reports development.
• Expert Crystal Reports, stored procedures and Share point on SQL Server database
• Strong MS SQL Server 2012/2008/2008 R2/2005 Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.
• Expert in Microsoft Business Intelligent Studio 2010/2008 (SSIS/SSRS/SSAS).
• In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL).
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts, OLAP and OLTP technologies.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Designed and built SQL dash board for reporting to allow ad hoc reports for management and Intelligence.
• Developed reports & Dash board by using excel services and business Intelligence.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Extensive experience in Enterprise Data Management (MDM, BI/ETL) as a developer, business Intelligence.
• Experienced in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Mastery in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server.
• Good understanding in Database Backup, Recovery and highly experienced in investigating and applying necessary MS SQL Server database Service packs, hot fixes and Security Patches.
• Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.

PROFESSIONAL EXPERIENCE:

Confidential

SQL/SSIS Developer

Responsibilities:

• Worked closely with SME’s end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues.
• Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to
• Validate the solution met requirements. And prepared documentation for same.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.(used CTE, temporary tables, user defined table types in codes developed)
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index
• Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Involved in enhancing and deploying the SSIS Packages from development server to production server.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Advisor
• Designed and developed ETL solutions for transformation of data from source transactional systems or other data feeds, into a dimensional database, or other destinations
• C reated, Scheduled, Generated and optimized ETL jobs
• Created and maintained technical documentation using defined technical documentation templates.
• Contributed to the creation of solid coding techniques and recommended and reviewed coding standards. Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery for the data.
• Wrote documentation, data warehouse artifacts and data lineage for ETL tools.

Tools: & Technologies: MS SQL server 2012, SSRS, SQL Profiler and T-SQL, Windows 2008 server and Visual Studio 2010, Microsoft Office, SSIS, Index Tuning Wizard, Query Analyzer, SQL profiler.

Confidential, Gaithersburg, MD

Sr SQL BI Developer

Responsibilities:

• Worked with business users and development staff to understand/determine requirements, collaborated with application developers for delivering the requirement on time and with scalability.
• Worked closely with SME’s end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues.
• Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements. And prepared documentation for same.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.(used CTE, temporary tables, user defined table types in codes developed)
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012.
• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in given period.
• Wrote T-SQL queries, created dynamic Stored Procedures by using input values.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
• Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
• Created reports using Global Variables, Expressions and Functions using SSRS 2008R2.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes
• Design and create dash board reports which illustrate the data in tabular format and well formatted charts.
• Automating the Dash Board process to retrieve information on failed jobs on all the servers.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations
• Generated Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Using MDM method define and managed critical data to provide with data integration, a single point of reference.

Tools: & Technologies: MS SQL server 2012, SSRS, SQL Profiler and T-SQL, Windows 2008 server and Visual Studio 2010, Microsoft Office, SSIS, Index Tuning Wizard, Query Analyzer, SQL profiler.

Confidential

SQL developer/ SSRS, SSIS 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.
• Transformed Complex business requirements into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.
• 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 2012.
• 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 updated and deleted data from OLTP systems.
• Experienced in implementation of strong referential integrity and auditing with the use of triggers.
• Deployed the SSIS Packages to File System based on the requirements
• Develop of complex SQL queries, 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.
• Developed Cross-Tabbed and Sub-Reports in 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.
• Prepare documentation for ETL process future references.

Environment: Microsoft SQL Server 20012/2008R2, SQL Server Reporting Services (SSRS), XML, SQL Server Integration Services (SSIS), Windows Server 2008.