SUMMARY

• Around 6 years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Experience in Designer in making Business Intelligence Solutions like SSIS, SSAS, SSRS and aptitude in outlining and actualizing Relational Database model according to business needs in various domains.
• Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like waterfall model and agile methodology.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export and Cursors.
• Good knowledge in Normalizing and De - normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating User defined Functions, Views and Cursors.
• Experience in SQL Server OLAP/OLTP database development including KPIs, Data mining, working with changing dimensions.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Expert in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool.
• Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.

TECHNICAL SKILLS

SQL Server Tools: SQL Profiler, Management Studio, DTS, QNXT, SSIS, SSRS, SSAS.

Database: MS SQL Server 2014, 2012, 2008R2, 2005, Oracle, MS-Access.

Language: C#, T-SQL, Vb.net.

Operating System: Windows Server

Tools: Microsoft Visual Studio, Point Server, Microsoft Project Server

Architecture Relational: DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools: SSRS (SQL Server Reporting Services), Crystal Reports

ETL Tools: SSIS (SQL Server Integration Services)

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

BI/SQL Server Developer

Responsibilities:

• Gathered functional requirements and Business requirements and documented the technical specifications.
• Designing, Developing, Testing and Deploying a series of SQL stored procedures using Microsoft SQL server Management studio, are automated by scheduling to process the data on a daily basis.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, triggers, functions and packages etc. using SQL server.
• Involved in migration of SQL Server .
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Involved in developing/Deploying SSIS packages using BIDS for Data loads required for Reports
• Identify columns for Primary Keys, Foreign Keys and Constraints in all the tables at the design time and create them.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Used Joins, Sub-Queries, Common Table Expressions (CTE's) for complex queries involving multiple tables.
• Used Temporary Tables and Table Variables to break large queries into smaller queries and improved the performance.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Organized data from a data warehouse into multidimensional cubes with SQL Server Analysis Services (SSAS) to allow the execution of sophisticated reports and complex queries.
• Responsible for creating database objects like table, views, store procedure, triggers, functions etc. using TSQL to provide structure to store data and to maintain database efficiently.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Managed subscriptions and data-driven report subscriptions to provide timely reports to the clients and end users, also created snapshots to reduce loading time.
• Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: Windows 2003 Server, MSSQLServer2012/2008, SQL Server Analysis Services (SSAS), Reporting Services (SSRS 2012/2008), Microsoft Visual Studio 2010, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS), .Net, Visual Source Safe (VSS), Web Services, SOAP, WSDL, MDX

Confidential, Minneapolis, MN

Business Intelligence/SQL Server Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers and created documentation for the same.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Wrote standard & complex T-SQL queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages.
• Created partition using partition scheme and functions of SQL server to achieve better performance in retrieval of data from database.
• Developed complex Stored Procedures and Functions and incorporated them in Crystal Reports to enable report generation on the fly (SSRS).
• Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
• Supported team in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 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.
• Used Multi-dimensional expressions (MDX) to present the date asked by the user, to simultaneously query on different dimensions.
• Backup user’s databases and perform database restore and run consistency checks from SQL Server and application.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Tested applications for performance, data integrity and validation issues.

Environment: Microsoft SQL Server 2012/2008R2 Enterprise edition, SISS, DTS, DTS Xchange, SSRS, BIDS, Erwin, C#, ActiveX VB Scripting.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated and interacted with project manager and other team members to process the complex business logic and requirements of the project.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Involved in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using Sql Server Reporting Services 2008.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Worked on Common Table Expressions (CTEs) which makes a reusable expression part of a query.
• Generated Reports using Global Variables, Expressions, and Functions and formatted the report layout for the requirement of the end users.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task and different data flow tasks.
• Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
• Created Sub Reports and Drill down Reports as per the client requirements using SSRS.
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS-2008.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Identified and optimized long running queries, poor indexing, parallelism issues, etc. and their effects on the database application.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition, SSAS, SSIS, SSRS, BIDS, visual C#, Java frame work, Windows server 2003, MS Excel 2007.

Confidential

SQL Developer

Responsibilities:

• Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions
• This involved index creation, index removal, index modification, file group Modifications and updating statistics in databases.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Generated reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple TSQL.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Written complex stored procedures and functions and integrated it with the front end application.
• Created multi-dimensional cubes with different dimensions and measures in it using SSAS.
• Created pivot tables turns the values of a specified column into column names, effectively rotating a table
• Created Report Snapshots to improve the performance of SSRS.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.

Environment: Windows server 2003, MS SQL Server 2000/2005, Business Intelligence Development studio (SSRS and SSIS), Crystal Reports, Microsoft.NET, MS Office Access 2003, VBScript, Erwin and Visio.