SUMMARY:

• Over 5+ years of strong MS SQL Server Developer experience with expertise in MS SQL Server 2014/2012/2008 R2/2008/2005 suite of products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis services (SSAS).
• Expertise in all the stages of Software Development Life Cycle and in the migration and up gradation of databases.
• Expertise in developing and deploying reports and creating reports by using MS SQL Server Reporting Services (SSRS) 2014/2012/2008 R2/2008 Report Builder.
• Expertise in designing and developing ETL solutions using SSIS SQL Server SSIS packages (ETL) to import, extract, and transform data between databases and external data sources.
• Extensive doing SSIS Control Flow items such as For Loop, Foreach loop, Execute package/SQL Tasks, FTP, File System Task, XML Task, Script Task, Send Mail Task, Bulk Insert Task.
• Expertise in SSIS and T - SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS transformation such as Aggregate, Lookup, Merge, Merge Join, Multicast, Sort, Union All, Conditional Split, Derived Column, Data Conversion, Audit, Copy Column, Import Column, Export Column , Cache, Fuzzy lookup, Fuzzy Grouping, Pivot, Unpivot, Slowly Changing Dimension, Percentage sampling, RowCount, Row Sampling, Script Component, Term Extraction, Term Lookup data validation checks during Staging, and finally transfer into data warehouse.
• Extensive in using Data warehouse and BI Reporting to analyze and manage related Data.
• Expertise in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes.
• Expertise in creating User Variables.
• Expertise in designing complex Drill-Through, Drill-Down, Parent-Child, Parameterized Reports, Sub-Reports,and Report Models and Ad-hoc reports using SQL Server Reporting Services (SSRS), from sources like SQL table, Oracle, Db2.
• Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Expertise in Creating business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance
• Expertise in creating/modifying Tables, Views, Stored Procedures, User Defined Functions (UDFs), Common Table Expressions (CTEs),Joins, Indexes, Triggers and Cursors scripting in T-SQL.
• Expertise in writing Sub-Queries and Joins to simplify complex queries involving multiple tables and established relationships between tables using Primary Key and Foreign Key Constraints.
• Expertise in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Expertise in creating Function Requirement Document, Technical Documents.
• Expertise in creating package and project level deployments using XML, SQL, and Environment variable configurations.
• Expertise in automating T-SQL scripts, stored procedures and SSIS jobs using SQL Server Job Agent.
• Expertise in creating, scheduling, monitoring, maintaining old and new SQL jobs, using SQL Server Job Agent.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2014/2012/ 2008 R2/2008.

TECHNICAL SKILLS:

BI Tools: BIDS/SSDT, SSIS, SSAS, SSRS.

Database: SQL Server 2014/2012/2008 R2/2008,Oracle.

Database Modeling: ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas.

Reporting Tools: MSAccess, Excel, MS SQL Server, Reporting Services 2014/2012/2008 R2/2008, SSIS, SSAS.

Languages: T-SQL, PL/SQL, C, C#.NET, java.

Web Development: HTML, XML, Microsoft.NET framework, Ado.net, ASP.NET, CSS, Visual Studio.

Operating Systems: Windows 10/8/7/VISTA/XP, and LINUX

Others: MS Office, MS Excel, MS Project, MS PowerPoint,Erwin.

PROFESSIONAL EXPERIENCE:

Confidential, DesMoines, IA

Sr. SQL BI developer

Responsibilities:

• Gathered the requirements from the client and translated the business design into technical design.
• Extracted data from various sources like SQL Server, Oracle, DB2, Excel, Access, CSV and Flat files from Client servers.
• Extensively used Control Flow items such as For Loop, Foreach loop, Execute Package Task, Execute SQL Task, FTP Task, Script Task, Send Mail Task.
• Worked with transformations like Conditional Split, Lookup, Merge Join, Aggregate, Audit, Derived Column, Union All, Multicast, Fuzzy Grouping, Import Column, Export Column , Cache , Percentage Sampling, RowCount ,Row Sampling, Script Component, Pivot, Unpivot, Term Extraction, Term Lookup for creating many SSIS packages.
• Created Variables to pass parameterized values into the package, to makes the package Dynamic.
• Developed, monitored, scheduled and executed SSIS package by using MS BIDS and SQL Server Agent.
• Extensively used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Worked on automating SSIS jobs using SQL Server Job Agent.
• Developed, deployed, and monitored SSIS Packages.
• Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
• Identified dimensions and Involved in building Facts and Dimension tables.
• Created and deployed cubes in Star and Snowflake schema.
• Extensively involved in working with dimensions, measures, generating KPI.
• Extensively involved in writing MDX queries for cube-calculated members to meet business requirements.
• Created Sub-Reports, Drilldown-Reports, Dynamic sorting, Summary Reports, and Parameterized Reports, Matrix reports, Charts (like, Gantt Chart) based on Business requirements in SSRS.
• Created reports with query parameter to present only the required data to the users and reduce the required data retrieval time.
• Created Ad-hoc reports and modified them by using SSRS and MS Report Builder.
• Responsible for configuring Report server and report manager using reporting server configuration manager.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Analyzed the data from multiple sources such as Microsoft (MS) SQL Server, MS Access.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables using T-SQL.
• Created/developed/maintained the stored procedures, triggers to interpret complex business rules.
• Optimizing code and improving efficiency in databases by creating re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Involved in creating Function Requirement Document, Technical Documents.

Environment: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server 2012/2014, T-SQL, SQL Server Management Studio (SSMS), BIDS, Microsoft Visual Studio, ASP.NET, Windows 7, MS Office, MS Access.

Confidential, CA

MS SQL Server /BI Developer

Responsibilities:

• Designed, reviewed, and created objects (Views, Indexes, etc.) based on logical design models, user requirements and physical constraints.
• Wrote various T-SQL queries, Stored Procedures and used them to build packages.
• Created Triggers, Tables, Views and SQL Joins for various applications.
• Responsible for Database and Log backups & Restoration, backup strategies and scheduling backups. Scheduled the SSIS packages and Jobs.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Created SSIS process design architecting the flow of data from various sources to target.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS.
• Used SQL Server 2008 tools like SQL Server ManagementStudio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

Environment: MS SQL Server 2012/2008R2,Oracle,SSIS, SSRS, SSAS Business Intelligence Studio, SQL Profiler, Windows 7, Microsoft Access.

Confidential, DesMoines, IA

MS BI/ SQL Server Developer

Responsibilities:

• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Created SSIS packages for File Transfer from one location to the other using SQL Server, Oracle, Excel, Access, CSV and Flat files from Client servers.
• Created and deployed SSIS packages and applied various data transformations like Sort, Union All, Conditional Split, Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Conditional Split, Lookup, Aggregate, Derived Column, and Data Conversion Transformations.
• Created several SSIS schedule tasks and monitored those tasks regularly.
• Extensively used C#,.Net to write Script in SSIS tasks like Script Task and Script Component.
• Developed SSIS packages using different types of Error Handling for various events.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Handled Performance Tuning and Optimization of SSIS packages.
• Created and deployed Star Schema (data marts) for OLAP Cube generation.
• Extensively involved in creating calculated members, named set and KPI’S for the SSAS cubes.
• Worked on summary Reports, Sub Reports, Drill down Report, dynamic grouping.
• Generated ad-hoc reports using MS Reporting services.
• Developed Ad-hoc reports and modified them by using SSRS and MS Report Builder.
• Created subscriptions for reports to be sent on fixed schedules (daily/weekly/monthly/Yearly).
• Monitored server performance, creating user logins and granting security privileges.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Extensively involved in Unit Testing, Integration and deployment in Production and Staging Servers.
• Deployed packages on different servers by configuring it.
• Wrote T- SQL queries, Store Procedures.
• Used Joins and Sub-Queries to simplify complex queries involving multiple tables using T-SQL.
• Improved Performance of the database by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler, Performance Monitor, and Database Engine Tuning Advisor.
• Reviewed and fine-tuned T-SQL stored procedures and triggers before production migration
• Extensively worked on creating Visio diagrams to explain the design process.
• Managed program plans, deadlines, and dependencies across initiatives, risk and coordination of project team activities.

Environment: MS SQL Server 2008R2,Oracle, SQL Server Integration Services 2008, MS SQL Server Analysis Services, SQL Server Reporting Services 2008R2,Visual Studio, T-SQL,XML.

Confidential, Franklin, WI.

SQL Server Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Created SSIS Reusable Packages to extract data from various sources Multi formatted Flat files, Excel, XML files into Database.
• Successfully transferred data from various sources like MS Access, Fat Files, Oracle and Excel into MS SQL Server using SSIS.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Used Control Flow task, For loop, ForEach loop, Send Mail Task, Execute Task, FTP task.
• Created SSIS packages to load data into SQL Server using various transformations Aggregate, Audit, Derived column, conditional Split, Import Column, Union All , Export Column, Lookup, Fuzzy Lookup, Fuzzy Grouping in SSIS.
• Implemented various different SSIS features like logins, transactions, checkpoints, deployment,
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Extensively used various Package configurations available for SSIS Packages like XML files and SQL Server Tables.
• Scheduled & Maintained ETL packages in terms of data validation and consistency.
• Created SQL Server Agent jobs, SSIS log and Event Handler.
• Secured and Configured SSIS packages for deployment.
• Created multiple parameterized stored procedures, which were used by the reports to get the data.
• Migrated SSRS 2008 reports to SSRS 2008R2.
• Designed Drill down, Parameterized Reports, Linked,and Cascaded Parameterized reports using SSRS business needs and involved in report deployment.
• Managed SSRS report subscriptions for end users
• Optimized the performance of reports.

Environment: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server 2008R2, Oracle,T-SQL, SQL Server Management Studio (SSMS), BIDS, MS Excel, Access.

Confidential

Jr.SQLServerDeveloper

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: : SQL Server 2008, SQL, T-SQL, BCP, Crystal Report.