SUMMARY:

• 8+ years of 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.
• Migration of SSRS reports from SQL 2012 to SQL 2014.
• Extensive experience with data modeling techniques, logical and physical database design.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008/2008 R2/2012/2014
• 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.
• Tuned complex SQL Queries.
• 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).
• 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 SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• 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.
• Experience in writing complex SQL queries involving multiple table’sinner and outer joins, stored procedures.
• Excellent report creation skills using Microsoft SQL Server 2012/2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Designed various reports using MS Access reports in datasheet views. This information ran automatically from user interface by clicking button based on Access data or SQL server data linked through ODBC by writing queries).
• Experience with TFS (Team Foundation Server), a ticketing system and also code integration system.
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2005/2008 R2,2012,2014), MS Access, MS Excel

Database: MS SQL Server 2014/2012/2008 /2005/2000, MS Access, Oracle 9i/8i

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL, VB Script, ADO.NET

Operating Systems: Unix, Windows NT/XP/2003/2000,Windows 9x and MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential,Bloomington, IL

Sr.MS SQL server BI Developer

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Scheduling the SSIS packages and Jobs.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Created Power Pivot models and Power Pivot reports, publish reports onto sharepoint and deploy models into SQL Server SSAS instance.
• Created SQL Server Reports based on the requirements using SSRS 2012,2014
• 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 2008R2 to SQL Server 2012 as SSIS packages.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Created different reports based on the requirements, and retrieve data using stored procedures that accept parameters using SSRS.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Chart diagrams .
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Developing T-SQL scripts/PowerShell scripts/SSRS reports for database maintenance purpose.
• Configured Merge and TransactionReplication from Production to DR Servers and Reporting Server with Multiple subscribers on SQL server 2012 and 2014.
• Developed a process to store historical data using appropriate stored procedure, triggers, tables and various shell scripts.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• 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.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Created sub reports, bar charts and matrix reports, Triggers to enforce data and referential integrity, Check constraints, Business Rules, Indexes, and Views, Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Designed, developed, implemented and maintained Informatica Power Center and IDQ 8.6.1 application for matching and merging process.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• 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.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2012, MS SQL Server 2012/2014, SQL Server Analysis services (SSAS), MS SQL Server Reporting Services (SSRS) T-SQL, SQL Server Integration Services (SSIS), Data Modeling DTS, SQL Profiler, Erwin VB SCRIPT, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET,VB Script.

Confidential, Bellevue, WA

MS SQL server BI Developer

• 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.
• Created SSIS Packages to migrate slowly changing dimensions.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring, Always ON, SQLServer clustering&configured Snapshot and Transaction Replication.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• 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.
• Have experience with Team Foundation Server (TFS) for logging the defects that exists, also experienced in using integrating the Production code in TFS.
• Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers from other developers to achieve maximum efficiency and scalability.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Developed interactive web-based reports and forms with VB Scripts and ADO.NET and html.
• Creating DTS Packages migration of data across different servers and Other Databases such as Oracle, Sybase and DB2 UDB.
• Performed the task of data transfer from files in remote server to folders in another server using FTP. And Expert in writing complex SQL queries involving multiple tables inner and outer joins
• Create a Tabular models based on an existing model already in SQL Server Data Tools and by extracting the metadata and data from a PowerPivot for Excel file (.xlsx).
• Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries
• Developed different types of Tabular models,Matrix Reports , Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Developed many asp.net web applications using SQL Server and C#, to provide solutions for companywide needs. (ASP.NET, C# Windows apps, C# console Apps, SQL Reporting Services).
• Interrogated Active Directory with C# to use existing user data. (C# console app) Grabbed data from distribution lists and copied to our Data warehouse in SQL server.
• Experienced 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.
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Highly responsible for development and management of PPS,SSAS, SSRS and SSIS projects.
• Building KPI reports for the cubes and optimizing the reports.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Performed business and system analysis, designed application and database structure, converted existing data into SQL Server using Data Transformation Services (DTS) and VB Script
• Involved in partitioning of cubes in order to increase the performance of cubes ( SSAS ).
• Designing, debugging, and optimizing T -SQL and MDX queries, T-SQL and CLR stored .
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (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
• Design and create report models based on user’s requirements, explain and train users to use report builder to generate their own personalized reports.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2008R2,2012, IIS 6.0, MS SQL Server 2008 SSAS, SSRS, SSIS, Tabular Data models, Microsoft Business Intelligence Development Studio (BIDS), T-SQL, DTS, OLAP, OLTP, VB Script,C#.NET, Microsoft Excel, SQL Server Agent, TFS 2010, Office-2008, MS Excel.

Confidential,Long Beach,CA

SQL Server/SSIS/SSRS/SSAS Developer

• 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.
• Involved in writing and executing SQL Queries for backend testing.
• 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.
• By Tabular Model the bypass in-memory model, allowing client applications to query data directly at the source.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Used Joins, correlated and non-correlatedsub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• 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 OLAPcubes, 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 at 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.
• 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: MS SQL Server 2005, SSIS, SSRS,SSAS, T-SQL, Tabular Models, Crystal Reports 10,Visual Studio 2005, MS Office 2003, SQL Profiler, Windows 2000/2003, Tabular Data, VB Scripts, SQL Queries, Stored Procedures, Excel, ERWIN.

Confidential, NEW YORK

SQL Server/SSIS/SSRS/SSAS Developer

• Analyzed all the Database Structure and prepared a reference guide to understand the existing system better.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.
• Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.
• Experienced in writing complex SQL Queries , Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL,DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Responsible for identifying and defining Data Source and Data Source views.
• Implemented business logic as .NET Framework assemblies (C#, VB.NET).
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
• Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Developed reports that deliver data from cubes.
• Created and managed subscriptions for the reports.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.
• Defined specific read/process permissions for the users in SSAS instance.

Environment: Windows 2003/XP, SQL Server 2005 BI Suite, SSAS, SSIS, SSRS-2005,T-SQL, ETL, OLAP, OLTP, ASP.NET, ProClarity, C#, VB Script, MDX, T-SQL, MS Visual Studio 2005, Tabular Models, Windows 2000/2003, Crystal Reports 10,Visual Studio 2005, MS Office 2003, SQL Profiler.

Confidential

SQL Server/SSIS/SSRS/ Developer

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• 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).
• Created Indexes to get the high level performance.
• 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.
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project
• 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 linked servers between different SQL Servers and also created linked server with different access files used across various departments.
• 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.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in migration from Oracle to SQL Server 2005 using SSIS.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• 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.
• 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.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: MS SQL Server 2005, Query Analyzer, T-SQL, Excel, SSIS, SSRS Windows 2000/XP, OLTP,, VSS, MS Access, Classic ASP, SQL.