SUMMARY

• BI Architect/BI Lead with over eleven (11) years of experience in MS SQL Server 2005/2008 R2/2012 DTS/SSIS, SQL Reporting SSRS, SQL Server Analysis Services (SSAS), SQL BI Development and T - SQL
• Facilitated ETL packaging, design, build, testing and deployment using MS SQL Server Integration Services (20 )
• Designed scalable, reusable and low maintenance ETL templates
• Experience handling large DBs of around 1.5 TB size
• Migrated DBs, SSIS packages and SSRS reports from SQL Server 2005/2008 R2 to SQL Server 2012
• Significant experience in MS SQL Reporting Services (2005/2008 R2/2012)
• Created and formatted Cross-Tab, Conditional, Drill-Down, top n, Summary, Form, Sub Reports, parameterized reports, interactive reports and custom reports
• Experience in data marts, data warehousing, OLAP using the Dimensional Modeling techniques such as star schema and snow flake schema, FACT and Dimension Tables using MS Analysis Services (SSAS)
• Hands on experience in SSAS Cube Development, created report models on SSAS cubes as well as changing default configuration in the existing cubes
• Experience in writing MDX scripting and MDX queries
• Knowledge of Tableau and Power BI
• Experience in Table Partitioning, Indexing and Building Indexed views
• Used SQL Profiler for SQL queries optimization and performance tuning
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages
• Strong experience in database backup, restore and recovery procedures
• Created linked servers and DSN to SQL Server and other databases such as Oracle, MySQL and Informix etc.
• Experience working with Cognos reporting tool
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions, Performance Tuning and Query Optimization in the SQL server 2005/2008 R2/2012

TECHNICAL SKILLS

Languages: SQL, Transact SQL, PL/SQL, C, C++, Java

Databases: SQL Server 2012/2008 R 2/2008/2005/2000 , Oracle 9i

Reporting Tools: SQL Server Reporting Service (SSRS), Cognos, Power BI, Tableau

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Operating Systems: Windows 98/2000/2003/ XP/Vista/Windows Server 2008 R2/ Windows Server 2012 R2

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

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

BI Architect

Confidential, Memphis, TN

Responsibilities:

• Provided Business Intelligence (BI) solutions using SSIS, SSRS, SSAS and SQL server tools and technologies
• Led a five member offshore team
• Migrated databases and SSIS packages from SQL Server 2005/2008 R2 to SQL Server 2012
• Facilitated requirement analysis and design documents, interfaced with clients to define the business objectives, gathered report requirements, architected data warehouse solutions and balanced responsibilities between on/off-shore resources to maximize productivity
• Studied, troubleshot and configured corporate wide scheduling systems. Parallelized and optimized schedule implementation decreasing load time span by 50%
• Optimized corporate wide ETL/SSIS operations cutting the overall load time in half, which was a critical to support the data delivery service level agreement
• Implemented data archival and purge strategy by using SSIS, involved in server migration
• Involved in analyzing, designing, building and testing the OLAP cubes with SSAS 2005
• Created parameterized and Drill-Through reports in SSRS
• Involved in analysis of Power BI
• Gathered report requirements for both Cognos and SSRS, monitored the report performance and assisted Cognos developer to improve the performance
• Assisted the developers with release testing and application enhancements (improved searches, sorts, grooming and Web page displays)
• Installed, configured SQL 2005, 2008 R2, SSIS, SSRS and Cognos 8, set up test and stage servers
• Executed change management and the release management processes based on the business needs
• Recognized for displaying excellent problem solving and team management skills
• Maintained BI architecture documents and kept up-to-date

Environment: SQL Server 2005, 2008 R2, 2012, SSIS, SSRS, SSAS, IBM Cognos 8.2, Power BI, Visual Studio 2005, Visual Studio 2012, Microsoft TFS and Visio

BI Lead

Confidential, Portland, OR

Responsibilities:

• Applied architectural and engineering concepts to design a solution that met the operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability
• Managed an offshore team of eight resources and provided production support for the developed marts
• Developed multiple SSRS reports like parameterized, sub report, cascading and dynamic
• Worked on data driven subscription tables for quarterly reports, monthly reports as well as the daily reports
• Created complex SSIS packages using best practices including Error handling, Logging, configurations, deployments and maintenance
• Designed the OLTP database
• Designed high level ETL architecture for overall data transfers from the OLTP to OLAP with the help of SSIS
• Involved in analyzing, designing, building and testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX
• Worked with the technical architects and database analysts for the design of summary tables required for efficient report design
• Developed data archival utility to archive data older than seven years from the DB
• Developed SSAS cubes for different departments like finance, accounts, HR, and service desk
• Conducted end to end testing and review of all deliverables before they were pushed to production environment
• Delivered detailed reports to the business teams in a timely manner

Environment: SQL Server 2012, SQL Server 2008 R2, SSIS, SSRS, SSAS, Visual Studio 2008, Microsoft TFS and Visio

BI Lead

Confidential

Responsibilities:

• Gathered requirements from the client and translated the business design into technical design specifications
• Responsible for data warehouse modeling, ETL design and development and performance tuning
• Designed and implemented ETL architecture for the whole project using SSIS
• Generated various Drill-Through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the Web front end
• Implemented performance improvements in T-SQL scripts and handled data efficiently
• Effectively solved the ongoing issues in the test and QA environment
• Reviewed the specs, prepared the technical specification documents, analyzed the tasks and provided feedback to the businesses
• Created complex Stored Procedures, Triggers, Cursors and UDFs using T-SQL
• Mentored a team of five people with a single POC for all key issues and enhancements

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, Visual Studio 2008, Microsoft TFS

BI Lead

Confidential

Responsibilities:

• Built new business intelligence systems and re-designed existing ones
• Responsible for data warehouse modeling, ETL design and development and performance tuning
• Designed and implemented the ETL architecture using SSIS
• Designed and developed multi-dimensional Cube databases using SSAS
• Created and configured data source and data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s and MDX queries using SQL Server 2005 Analysis Services
• Generated reports using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes
• Involved in database management, performance measurement and performance tuning for new databases and the existing databases using SQL Profiler, SQL Analyzer and SQL Enterprise Manager
• Created maintenance plans in SQL Agent to back up the database
• Broad exposure to query optimization and performance tuning of Stored Procedures and Functions etc.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, SSAS, Query Analyzer, SQL Profiler