PROFESSIONAL SUMMARY:

• Over 7 Years of Experience as a Microsoft BI / SQL Server Developer using SQL Server 2012/2008R2/2008/2005 specialized in database design, development and administration. Experience in working different domains like Financial, Banking, Insurance and Health Care.
• Experienced in Software Development Life Cycle (SDLC) for Design, Development and Staging phases of the projects with support of Data flow.
• Experience in developing and monitoring ETL Packages using SQL Server Integration Services (SSIS), creating cubes for analysis using SQL Server Analysis Services (SSAS), developing reporting solutions using SQL Reporting Services (SSRS).
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Expertise in using different transformations provided by SSIS such as Script component, Look UP, Data Conversion, Conditional Split, Bulk Insert, merge, union all, Slowly changing dimension to transform the data before loading into the destination.
• Experience in Performance Tuning by using Row Transformations, Block and Unblock Transformations. Experience in Providing Error Handling using Event handlers and custom logging for SSIS Packages.
• Experience in Logical Modeling using Dimensional Modeling techniques such as Star Schema and Snow flake Schema. Created Multidimensional cubes using SQL Server Analysis Services (SSAS).
• Proficient in SSAS functions like Calculations, Key Performance Indicators (KPIs), Actions, Perspectives, Translations, and Security roles within a cube.
• Experienced in defining Fact relationships and Cube. Experience in using MDX, Expressions and Functions for the reports.
• Experience in developingUser reports and Management reports using MS SQL Server Reporting Services (SSRS). Generated KPI Score - card dashboard and pivot tables/charts for decision making.
• Expert in creating Tabular, Matrix and Ad- hoc reports according to business requirements in SSRS.
• Experience in migration of SQL Server 2005 to SQL Server 2008.
• Experience in executing complex T-SQL queries using stored procedures, Triggers, Cursors and User Defined Functions.
• Experience in SharePoint, .NET framework including C#, ASP.NET and Web Service.
• Confident, independent, leadership skills, good decision-making abilities, strong technical, communication, time management and interpersonal skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008 R2/2008/2005, My SQL, MS- Access

Database Tools: SSIS, SSAS, SSRS, Enterprise Manager, SQL Profiler, Business Intelligence Development Studio, Management Studio, SharePoint 2007, Crystal Reports 9.0/10.

Programming Languages: SQL, TSQL, VB.NET, XML, C++, Java, VB 6.0

Scripts: JavaScript, VBScript, HTML, DHTML and XML

Web Tools: MS-Front Page, Macromedia Suite, IIS, Outlook Express

Applications: Microsoft Office, Visio, and Visual SourceSafe

Operating Systems: Win 7/XP/2003/2000, UNIX (Linux).

PROFESSIONAL EXPERIENCE:

Confidential, Golden Valley, MN

SSIS/SSAS/SQL Server Developer

Responsibilities:

• Designedand developed SSIS (ETL) packages to Validate, Extract, Transform and Load data from OLTP system to the Data warehouse.
• Developed SSIS Packages from package design documents, build package and also perform Unit testing of the SSIS, extract by building validation packages to check the accuracy of the data migrated.
• Created SSIS package to load data from Flat File to Data warehouse usingLookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup including data validation checks during Staging, before loading the data into the Data warehouse.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server.
• Worked on writing Python and C# cripts,
• Create Baseline - all database schemas for BT, comparison of database objects between schemas used as the foundation for DDL script moved from DB to TEST and PROD using Eclipse, Notepad ++ and Python script to kickoff the objects - conversion script.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Wrote stored procedures, User Defined functions (UDF), which were used in the SSIS package while doing ETL process.
• Designed dimensional modeling using SSAS package for end user.
• Scheduled jobs for backup, and created alerts for error reporting.
• Created SQL Server Agent Alerts to monitor the SQL Server Events and SQL Server Performance Alerts and notify the Administrators of the critical situations.

Environment: Microsoft Azure, MS SQL Server 2012, Python, SQL server integration services (SSIS) 2012, SQL server analysis services (SSAS) 2012, TSQL.

Confidential, Jackson, MI

SSIS/SSRS/SQL Server Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and designed documents for development.
• Designedand developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse.
• Created SSIS package to load data from Flat File to Data warehouse usingLookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Developed the Windows Communication Foundation (WCF)services using REST, involved in defining Endpoints, Bindings, Service Contracts, Session management and Transaction management for exposing specific functionalities in client application.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup including data validation checks during Staging, before loading the data into the Data warehouse.
• Configured files to deploy the SSIS packages across all environments.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, Parameterized report using SSRS 2012.
• Generated Reports using Global Variables, Expressions and Functions.
• Created AD-HOC reports with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly and monthly based.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL.

Environment: MS SQL Server 2012, .NET Framework 3.5/4.0, Visual Studio.NET 2008/2010, SQL server integration services (SSIS) 2012, SQL server reporting services (SSRS) 2012, TSQL.

Confidential, Portland, Oregon

SSIS/SSRS/ SQL Server Developer

Responsibilities:

• Responsible for all phases of software development lifecycle: requirements analysis, technical design, implementation, acceptance testing.
• Developed ETL packages using SQL server integration services to integrate data from different databases.
• Developed stored procedures for applying business logic, cleansing, and performing different data transformations.
• Created various SSIS Packages as per business requirements. Modified existing packages to incorporate changes and to improve performance.
• Experience in SSIS for constructing packages; and the Integration Services service for running and managing packages.
• Involved in Creation of Reports, Created ODBC Connections and database Connections.
• Formatted reports for various Output formats such as PDF, EXCEL and WORD for the convenience of the end users.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Developed the ad-hoc reports using the report builder and providing training to the business users.
• Communicating with both technical and non-technical staff to support analysis, design, testing, and troubleshooting of project issues.

Environment: MS SQL Server 2008 R2, SQL Server BIDS, SSIS, SSAS, SSRS, T-SQL, SQL Server Enterprise Manager.

Confidential, CA

SSRS/SSIS/SSAS/ SQL Server Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Generated some reports using SSRS (SQL Server Reporting Services) from OLTP and OLAP data sources.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Working knowledge in Data modelling, creating star and snowflake schemas in SSAS.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, SQL, T-SQL.

Confidential, Ohio

SSIS/SSAS/ SQL Developer

Responsibilities:

• Managed the complete migration of SQL Server 2005 databases to SQL Server 2008.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created SSIS Packages to import data daily from OLTP Applications to data warehouse.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Created several cubes in SSAS and build MDX queries to query cubes and to access cube's data.
• Provided organizational reporting and timely reports utilizing SSRS (SQL Server Reporting Services).
• Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions.
• Managed Query Optimization and Performance Tuning of Stored Procedures, Functions etc.
• Managed production servers with multiple databases.
• Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning wizard.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases.
• Scheduled jobs for backup, and created alerts for error reporting.

Environment: SQL Server 2008, SSRS, SSIS, SSAS, T-SQL, ODBC, Excel, Access.

Confidential

SQL Server BI Developer

Responsibilities:

• Worked on the data warehouse design and analysed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server.
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information (As per business logic) by using SQL Server Agent and windows Scheduler.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Used MDX expressions to define calculated members in cubes to calculate values at run time.
• Created copies of operational Databases using the Import/Export Wizard.
• Optimized existing stored procedures to achieve improved performance.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.
• Created OLAP CUBEs using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2005, SSIS, SSAS, SSRS, Windows Server 2003, Enterprise manager, MDX, T-SQL, Agile.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries using Indexes and Execution Plan.
• Developed User Defined Functions and created Views.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Extensive experience in writing highly performed complex Stored Procedures, Queries and Views using the Indexes in order to accelerate the retrieval process of the data and display in the reports.
• Configured the Report Manager for the Users to use the report according to their security responsibilities.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.

Environment: SQL Server 2005, SSIS, SQL, T-SQL, Windows server 2003/XP, MS Access, MS Excel, MS Word, Crystal Reports.