SUMMARY:

• Over 8+ years of SQL Server Development experience in SQL 2005/2008/2012 with an emphasis on design, development, automation, tuning, optimization, Performance and Security.
• Extensive experience in SQL Server 2012/2008/2005, Business Intelligence tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Highly proficient in constructing Triggers, Tables, stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity using T- SQL.
• Extensive knowledge of Normalization and Relational Database Management Systems. Experienced in supporting web based, mission critical applications including Logical and Physical Database Design, Development and Performance Tuning.
• Handled different types of encryption and decryptions in SQL as per client requirements to secure data.
• Experienced in migrating Data from Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS), BCP and DTS utility. Expert in Creating, Configuring and Fine-tuning ETL workflows in SSIS.
• Experienced in Designing, maintaining and building Cubes, Dimensions, and Data source views, data mining Models, Deployment and Processing using SSAS. Proficient in writing MDX queries and use Client tools like Excel to provide visualizations on Multidimensional or Tabular model Cube data.
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports. Good command in generating on demand and scheduled reports for business Analysis and Management decisions using SSRS 2012/2008/2005.
• Experienced in writing expressions and fine tuning reports. Created many Drills through, Sub, Parameterized and Drill Down reports using SSRS.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.
• Efficiently helped in Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Experienced in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.
• Experienced in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling SQL Server Agent Jobs
• Very good communication and interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS

• Operating Systems: Microsoft Windows XP/2008/2003/2000/NT, DOS.
• Languages: C, C#, T - SQL, SQL, PL/SQL, ADO.NET, ASP.NET, HTML, XML.
• Tools: SQL Server Management Studio, Enterprise Manager, SSIS, SSAS, SSRSBusiness Intelligence Development Studio, Tableau.
• Utility: SQL Profiler, Query Analyzer, Windows Performance Monitor, Data Base Engine Tuning Advisor.
• Database: MS SQL Server 2012/ 2008 R2, /2005//7.0,MySQL, MS Access 2007.

PROFESSIONAL EXPERIENCE

Confidential, Saint Paul, MN

MS SQL/ SSIS /SSAS Developer

Responsibilities:

• Prepared the complete data mapping for all the migrated jobs using SSIS
• Responsible for creating and designing SSIS package
• Written T-SQL Stored Procedures and queries for accessing Data from Teradata Database
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Use different control flow control like for each loop container, sequence container, execute SQL task, send email task
• Use package configuration to migrate SSIS package from one environment to other
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Involved In writing Complex T-SQL Queries.
• Backing up master & system databases and restoring them.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
• Involved in testing and debugging stored procedures.
• Designed, built and tested SSAS Cubes on SQL Server.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Process the cubes (SSAS), partitions as and when required.
• Writing the DAX statements for Cube
• Designing Visualizations in Tableau 9.2

Environment: MS SQL Server 2008/2012, SSIS, SSAS, TFS, Teradata, Windows 2003/2008,Deployment Wizard, Visual Studio 2010, MS Excel 2007,Tableau,C#, ASP .Net

Confidential, Yardley, PA

MS SQL/ SSIS /SSRS/BI Developer

Responsibilities:

• Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
• Created SSIS packages to migrate the existing DTS packages.
• Scheduled and Maintained Multiple SSIS packages.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008/2012 (using SSRS, T-SQL, scripts, stored procedures and views)
• Designed ETL packages for different data sources (Excel, SQL Server, and Flat Files). Created indexes for the fast retrieval of data from the database.
• Create SSRS reports against Team Foundation Sever Database.
• Deployed SSRS reports using report server and TFS.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote customized Team foundation reports according to the companies’ customized workflow.
• Used SQL Server Reporting Services to generate different types of Ad-hoc Reports.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Involved In writing Complex T-SQL Queries.
• Backing up master & system databases and restoring them.
• Worked on Query Optimization through query Analysis and Index Optimization.
• Actively involved Normalization & DE normalization of database.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
• Involved in testing and debugging stored procedures.

Environment: MS SQL Server 2005/2008/2012, SSIS, SSRS, TFS, Windows 2003/2008,SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g,Enterprise Manager, ERWIN Data Modeller, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net,ASP.NET, Power Shell Scripting, Visual Studio 2005, MS Access, Crystal Reports, MS Excel 2007.

Confidential, Jersey City, NJ

MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

• Created complex Stored Procedures, tables, views and other SQL joins and statements for applications by using T-SQL.
• Performance tuning, and optimization of procedures and queries.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Extensively created new reports and modified existing reports using SRSS
• Excellent report creation skills using Microsoft Reporting Services (SSRS). Extensively used SQL Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data; Wrote queries to generate reports for analysis of data; Used table control, matrix control to create cross tab reports; handled sub reports and defined query for generating drill down reports in SSRS.
• Extensively used T-SQL in creating and altering stored procedures, functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Writing reports using Microsoft Reporting Services (SSRS)
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Designed, built and tested SSAS Cubes on SQL Server 2005.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Process the cubes (SSAS), partitions as and when required.
• Enhanced performance using optimization techniques: normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Worked with development teams in the design of physical databases and in modification.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created packages in SSIS with error handling.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Worked with different methods of logging in SSIS and advanced data mapping.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Have deployed packages on different servers by configuring it.
• Installed and configured SQL Server 2008/2005 in Test environment with latest service packs and migrated few databases.

Environment: MSSQL Server 2008 R2/2008/2005, SQL Server SSAS/SSRS/SSIS, MDX Cubes, OLAP, Microsoft Windows 2003 Advanced Server, ASP.NET, C#, ETL, Enterprise Edition, Microsoft Visual Basic 6.0, SQL Lite Speed, OLAP.