SUMMARY

• 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 R 2/2008/2005/2000 in Development, Test and Production Environments with various business domains.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Having good knowledge on Microsoft SQL Server 2014
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from /2008/R 2/2012/2014.
• Migration of SSRS reports from SQL 2005 to SQL 2008.
• Extensive experience with data modeling techniques, logical and physical database design.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Used MDX to interact with the back end OLAP Services
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T - SQL.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Expert ETL design.
• Assisted in the scheduling the reports to refresh and run on daily, weekly and monthly basis and also deployment of the reports using Direct deployment and Uploading files using the Report Manger.
• Involved in integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and Performance Point 2010 and Dashboards.
• Good knowledge of ADX/MDX Scripting to perform various tasks including creating Calculated Members.
• Expertise in data mining concepts like Building Cubes and Dimension Modeling, creating Data Marts, Kimball / Inman Methodologies, Star / Snowflakes Schemas with different architectures and data sources using SSAS.
• Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Experience in Creation and deployment of cubes on SSAS.
• Good understanding in Oracle 9i/10g Database.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
• Worked Extensively on ETL process using SSIS package.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008/2008 R2/2012

Languages: T-SQL, MDX, VB Script, PL/SQL

Developer Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Server Data Tool, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Visual Studio 2005/2008, BCP, Team Foundation Server (TFS),SVN

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Reporting Tools: SQL Server Reporting Services (SSRS)

Analysis Tools: SQL Server Analysis Services (SSAS),Tabular Models

Data Modeling: MS Visio 2000/2007/2010 , ERWIN 7.1, ERWIN 4.1

Operating Systems: Windows NT/ 98/2000/2003 Server XP/Vista, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Veron Hills, IL

SQL Server Developer / BI Stack

Responsibilities:

• UsedSQL Server 2012tools likeSQL Server Management Studio, SQL Server Profiler and SQL Server Visual Studio.
• Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts and Grids using SQL Server Reporting Services 2012.
• Design the ETL for the data load.
• DesignedSSIS Packagesto transfer data from various sources of the Company into the database that was modeled and designed.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created reports using crystal reports.
• Create Master Package to run different other ETL in one Master package.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Worked in an agile scrum methodology.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
• Created Informatica mappings with T-SQL procedures to build business rules to load data.
• Played roles like production support of SSIS and SSRS jobs.
• Perform T-SQL tuning and optimizing queries for and SSIS packages.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created SSIS packages to load dimensions and fact tables.
• Good knowledge on SSAS 2012 tabular models and design.
• Scheduling SSRS jobs and production support.
• Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS

Environment: MS SQL Server 2008, MS SQL Server 2012, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint MOSS 2010 ( MS Visual Studio.NET# 2008, Informatica, MS Visual Studio.NET# 2010, Team Foundation Server (TFS 2012), Windows 2008 Server, Visual Basic 6.0/VB.net, VB Script.

Confidential, Bothell, WA

Sr. MS SQL Server / BI Developer

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008 (SSAS)
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008R2.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Worked on some ETL development using Informatica.
• Wrote complex SQL scripts to avoid Informatica Lookups to improve the performance as the volume of the data was heavy.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Scheduling the SSIS packages and Jobs.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Informatica, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, Buffalo, NY

MS SQL Server / BI Developer

Responsibilities:

• Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.
• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS)
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, Tablix etc.
• Building KPI reports for the cubes and optimizing the reports.
• Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Created SSIS Packages to migrate slowly changing dimensions
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Scheduling the SSIS packages and Jobs.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, New York

MS SQL Server Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Participated in creating Jobs for various packages that run Confidential specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for Process CUBE Partitions and Dimensions.
• Involved in writing MDX queries for various calculated members.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL 2007.

Confidential

MS SQL Server Developer

Responsibilities:

• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created Indexes to get the high level performance.
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSIS.
• Developed Cubes using SQL Analysis Services (SSAS).
• Deployment of SSAS Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2000/2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), MS SQL Analysis Services(SSAS), Windows 2000/XP, Oracle 7.0

Confidential

MS SQL Server Developer/T-SQL Developer

Responsibilities:

• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Worked on advanced dimension Design and Cube design.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• 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 deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server (2003, 64 bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, ERWIN.