SUMMARY:

• Database Engineer with around 8 years’ IT experience in Microsoft Business Intelligence (BI) technologies like SSIS for SQL & ETL development, SSRS for reporting solutions, and SSAS for BI delivery.
• Strong SQL skills to build database systems that are high - quality, scalable, and high-performance to meet the demands of rapidly growing and ever-changing environment.
• Deft at working with Developers & Business Analysts to handle performance-tuning of SQL code, recommending appropriate indexes, creating tables &complex stored procedures to integrate the front end application with the backend database as per client’s business needs.
• Experience with PowerShell, VBScript & .Net development.
• Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers &Cursors
• Development, implementation, administration &support of ETL processes for large-scale Data Warehouses using SSIS 2008 with various control flow, data flow tasks and store procedures for work order validation process
• Creating, deploying SSIS Packages and Migrating DTS Packages from 2000 to 2005/2008
• Migrating SSRS Reports from SQL 2000 to SQL 2005, SQL 2008 & SQL 2008 R2
• Creating and managing fragmentation of Indexes to achieve better query performance
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy
• SQL tools, execution plans, trace, statistics, index tuning wizard for troubleshooting SQL issues
• SQL Server Profiler to monitor SQL server for deadlocks, long running queries optimization and performance tuning
• Bulk Copy (BCP), Data Transformation Services (DTS) &SSIS for dealing with high volume transactional data in SQL
• SSRS in BI Development Studio (BIDS)to deliver OLAP solutions by developing corporate dashboard reports, report model for tabular reports, matrix reports, ad hoc reports &distributed reports using Report Builder functionality

TECHNICAL SKILLS:

Languages: T- SQL, C, PowerShell Script, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML

Databases: SQL Server 2012/2010/2008 R 2/2008/2005/2000

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)

ETL Tools: DTS, SSIS, Data Stage

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2007/2003/2000, Report Builder 3.0

Operating Systems: Windows/ 98/2000/2003/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE:

Sr.BI Developer (SSIS/SSRS/SSAS)

Confidential, Sacramento, CA

Responsibilities:

• Create complex reports like adhoc reports, table report, matrix report, cascading report, sub reports, drill down, drill through, chart reports using complex data set queries, stored procedures, views in SSRS 2012 & report builder 3.0.
• Actively participated in gathering business requirements to implement functional and technical specifications
• Migrating databases instances from SQL Server 2008 to SQL Server 2016 version.
• Installed, managed and administrated SQL Server 2016/2014/2012/2008 R2 Databases.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
• Used USHER product for convenient and secure way to control the Digital access.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment
• Developed SSIS ETL Packages & also modified packages into different environment (Development, Testing & Production), as ongoing requirement changes
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Enhance SSIS packages to perform dynamic functionalities from static configuration and changed many of the packages by using C# coding for generic usage within the organization.
• Created & modified SSRS reports (2012 & 2016) depend on the requirement on the priority basis from the DW & BW bug tracker applications.
• Worked on the performance and high priority critical issues to meet deadlines for SSIS package execution and for SSRS reports rendering.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tool Targit
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Designed SSAS Cubes, Named Calculations for Dimensions.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created Development and Production support documents.
• Used Subversion for centralized storage within the Data Warehouse department.

Environment: MS SQL Server 2016, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2016/2013, Visual Source Safe, MS Office, Oracle 12c/11g, .Net Framework 4.0, C#.Net, Asp.Net 4.0, JavaScript, SQL Profiler, Red Gate Tools, Excel and Access, Team Foundation Server (TFS).

Senior SQL BI Developer

Confidential, SFO, CA

Responsibilities:

• Involved in brining 2005 SQL database to SQL 2008 R2 by migrating/ re-writing DTS &updating to SSIS packages
• Worked on Data Flow tasks; executed process task& transferred SQL Server Objects, Jobs&Logins tasks
• Worked with SSIS packages for FTP tasks, fuzzy grouping, merging, pivot & unpivot control flow transformation; used Text Files/ SQL Server Logging for all SSIS packages; SQL Server Package Configuration for dynamic configurations
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Created On demand (Pull) &Event Based Delivery (Push) of reports; deployed &configured reports in Report Server
• Extracted Data from heterogeneous databases - Oracle &Access, DB2, flat files to SQL server 2008R2 using SSIS
• Used SSIS to create ETL packages to validate, extract, transform &load data into data warehouse &data marts
• Implemented event handlers & error handling in SSIS packages and notified process results to user communities
• Worked with various SSIS packages which involve Transactions, Restart and Roll back techniques
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created databases, tables, cluster/non-cluster index, unique/check constraints, views, stored procedures, triggers
• Created User Defined Functions to encapsulate business logic making system more modular, secured &extensible
• Optimized stored procedures &long running SQL queries using indexing strategies &query optimization techniques
• Worked on scheduling the packages to keep extracting the data from OLTP at specific time intervals
• Involved in rebuilding indexes &tables for performance tuning and optimized SQL queries for maximum efficiency
• Used SQL Server Agent for scheduling jobs &alerts; configured & deployed all reports across various SDLC environments and deployed packages to production using XML package configuration

Environment: SQL Server 2012/2008R2/2008/2005, SSRS 2008, SSIS 2008, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe

SQL BI Developer

Confidential

Responsibilities:

• Worked with Technical Architects &Database Analysts to design summary tables required for efficient report design
• Created complex SQL stored procedures using Microsoft SQL Server 2008 &2008 R2
• Designed functional &technical documents, report templates &reporting standards to work on report developmentusing SSRS 2008 &SSRS 2008 R2; generated reports from cubes with SSRS Connection.
• Created cubes, dimensions &measures and calculated measures as per business requirements; created several SSIS packages to perform ETL operations like data transformation from a cube using MDX
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008 and deployed SSIS Packages & Reports to Production Servers; created database maintenance plans & deletion of history data using SSIS packages
• Performed data transfer from files in remote server to folders in another server using FTP
• Developed SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005; created interface stored procedures used in SSIS to load/transform data to the database
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup &management of linked servers to Non-SQL-Server databases
• Involved in Report Authoring, Report Delivery using Pull & Push strategy and Report Management for various reports
• Created snapshots of static reports and configured subscription.
• Created hierarchies for date ®ion dimension tables, browsed cube for data analysis &validation and processed cubes &dimensions using SSIS tasks; developed and extended OLAP Cubes, dimensions and data source view
• Built cubes for production application, partitioned cubes to decrease processing time &increase performance of queries running on front end application using SSAS 2008
• Involved in SSAS storage & partitions, aggregations, calculation of queries with MDX, Data Mining Models &developing reports using MDX &SQL; built database queries & test cases to test reports
• Handled logical/physical data analysis, modeling, database design, star schema, programming &implementation
• Extracted data from CSV files, Oracle, &MS SQL 2000 and stored in intermediate Staging Database using SSIS ETL
• Transformed the data from the staging database and performed the transformation using the Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS
• Scheduled Reports to run on daily/weekly basis in Report Manager and emailed to director &analysts for review
• Prepared reports for daily/weekly/monthly purposes in various formats like MS Excel, PDF, HTML, XML, etc.
• Led the team of developers to write efficient code.

Environment: SQL Server 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ProClarity, MS Excel

Software SQL Server Developer

Confidential

Responsibilities:

• Gathered end user requirements, developed applications and different audit functionalities depending on the requirement acting for both system analysts and application developer.
• Wrote user requirement documents, created technical specs and design documents for various projects.
• Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc.
• Wrote stored procedures, triggers, views, user-defined functions and CTEs
• Involved in database design, normalization, de-normalization in building data warehouse and reporting systems.
• Involved in query tuning by creating cluster and non-cluster indexes on tables, and used index tuning wizard.
• Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
• Used event handlers for event handling which includes on pre execute, post execute and error.
• Involved in package logging in SQL server &file based and custom logging using customer stored procedure &tables
• Deployed SSIS packages across Dev, UAT, &production using DTEXEC utility, command prompt with .bat files
• Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.
• Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.
• Created adhoc reports as per end user needs and formatted reports using global variables, expressions & functions
• Performed daily DBA activities, security assignment, user setup, backup, restore &job monitoring on MS SQL server
• Developed parameterized reports using single values, multi values and cascading parameters.
• Build queries for high performance reporting to render to html, xml, pdf, MS word &excel using SSRS (2005/2008)
• Managed & implemented SSIS packages, answered technical inquiries, responded to troubleshooting requests

Environment: SQL server 2000/2005/2008, SQL Query Analyzer, SQL Profiler, IIS 6.0, Oracle 9i, Enterprise Manager, ERWIN Data Modeler, SSIS, SSRS, SSAS, Windows Server 2003/2008, OLTP, OLAP, DTS, HTML, XML, C#, .Net, Visual Studio 2008, ETL, MS Access