Architect – MSBI / SQL Server / Reporting
** + years experience in Enterprise Business Intelligence, Analytics and Data warehousing as a Strategic & focused Solution Architect/ Senior BI Architect, Lead in implementation of End to End Enterprise Data warehouse projects using BI Tools like SSIS, SSRS, SSAS, Power BI, Azure SQL database in Information Technology, Healthcare, Insurance and Retail Domains.
Extensive experience in Relational and Dimensional Data Modeling with strong Conceptual, Logical and Physical Data Modeling skills, Power Pivot and excel reporting.
Hands on experience in implementing Data Warehousing solutions using ETL tools like Microsoft SQL Server Integrations Services (SSIS) and reporting tools like MS SSRS and Power BI and using analysis tools for SSAS.
Hands on experience on Power BI and Azure SQL Database.
Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types, Cursors and functions.
Experience in Requirements gathering, Design, Development, Testing, Implementation, Data analysis & validations and resolving data quality issues.
Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
Experience in creating SSRS reports from cubes using MDX quires.
Experience in Error and Event Handling, Precedence Constraints, Break Points, Check Points, Logging.
Design and development in SSAS multidimensional model. Creating measure groups, calculative measures and process the cubes.
Extensive experience in Indexing, managing and monitoring indexes, fragmentation, reorganizes, rebuild indexing and tuning indexes. Experience with index tuning wizard.
Extensive experience in Performance Tuning, Query Optimization and Database Tuning Advisor.
Database Monitoring tools like SQL Profiler, performance monitor and Event viewer.
Good experience in version control tool like TFS and VSS, using version control to maintain different version of code for different environment like DEV, QA and PROD and doing regular code, Packages, Reports and Cube check in and check outs.
Experienced in regular interaction with the Business users, Application Users and Stake Holders.
Experienced working with agile project management methodologies
MS SQL SERVER 2016/2008/2005/2000/7.0
MS-BI Development studios 2005/2008, SSMS, BIDS, SSDT, Azure SQL Database, Azure SQL DW
EAI/ETL, Data warehousing, Database design, Reporting
SSRS, Power BI, MS Excel Reporting, Power Pivot
Awards / Certificates
Certificate of Achievement for successful implementation of project from Cognizant and BB&T
Completed Power BI Certificate in Analyzing and Visualizing Data with Power BI from EDX.ORG
Completed Delivering Data Warehouse in the Cloud from EDX.org
Bachelor of Information Technology (B.I.T) in computer science, from Jamia Hamdard, Hamdard University, New Delhi, India. (2003)
Master of Technology (M.Tech) in Computer Science, Rajasthan Vidyapeeth University, Rajasthan, India. (2006)
Sally Beauty Supply LLC Sep 2017 – Current BI Architect Denton, Texas
The purpose of the project was to build a comprehensive holding database (EDH) that stores all of the retailer’s data including store sales transactions, CRM customer data, online sales and professional sales. The comprehensive holding store will act as a single point to access enterprise wide data.
Operating System: Windows
Tools : SSIS, SSRS, Visual Studio, Management Studio, BIDS
Databases : SQL SERVER-2016/2008, Azure SQL Database
Designing and develop SSIS packages that load data from CRM, I-series (store sales), external vendors, and online sales into EDH database.
Created Technical Design for the application working alongside with Infrastructure team.
Designing the data warehouse used for enterprise wide reporting. Building packages that load data into the EDW.
Develop reports in SSRS for the business managers. This includes status reports, revenue report and sales reports.
Perform code optimization and identifying bottlenecks in packages, reports and queries.
Managing offshore teams day to day activities. Providing technical solutions to customer business needs.
Establish support process and manage BI user support team
Maintain SSAS cube and perform enhancements
BB&T Insurance April 2013 – Sep 2017 Reporting & ETL Lead Raleigh, NC
DBS (Direct Billing System) was built to meet FDIC and integral audits requirements. The system reconciles policy commission income with invoices in Sagitta, the insurance agency management system. The reporting system was created on MSBI platform.
Operating System: Windows
Tools : SSIS, SSRS, SSAS, Power BI, Power Pivot, BIDS
Databases : SQL SERVER-2008 R2
Designing and develop SSIS packages that load data from Sagitta, Benefit Point and electronic statements into DBS database.
Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS) for the business managers. Reports are created for business manager to review revenue projections and daily progress monitoring.
Created batch files that executes the ETL scripts which invokes SSIS packages.
Established SDLC and was responsible for planning, controlling and coordinating the development effort using agile methodologies
Responsible for writing Stored Procedures & Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
Build and maintain EB (Employee Benefits) Aging and Accrual logic and maintain the reports. The EB Aging process builds aging data and is reported using SSRS reports.
Develop reports in SSRS for the business managers. Reports were created for FDIC Audit, Internal business manager reviews and for progress monitoring.
Built prototype cube in SQL analysis services (SSAS) for EB Reporting.
Medsolutions DW Lead Franklin, Tennessee April 2012 – May 2013
Medsolutions IT systems handle Pre-Authorization, notification, steerage and decision support. Aiming is to provide pre-authorization for its provider customer. The data warehouse application provides business intelligence analysis capabilities to govern the process managed by the IT systems
Operating System: Windows
Tools : SSIS, Visual Studio, Management Studio, BIDS
Databases : SQL SERVER-2008, Data warehouse
Designing and develop SSIS packages that load data to MSI data warehouse.
Migrating existing SSIS packages developed in 2005 to 2012.
Understand business requirements and creating requirement (SRS) and mapping documents.
Performance code optimization and identifying bottlenecks in packages, reports and queries.
Managing and supporting existing data warehouse and resolving issues.
Managing offshore teams day to day activities. Also guiding team members and handling distribution of work within the team.
Providing technical solutions to customer business needs.
Microsoft Team Lead Redmond, WA May 2008 – Mar 2012
Advertisement Exchange service enables advertisers and ad networks to bid for inventory in real time. The Enablement team manages AppNexus exchange inventory. The Data warehouse and exchange cube built is used for Data analysis and reporting purposes.
Designing the ASTHDS Data warehouse for our team to load Ad Network data.
Designed and wrote specs for new feeds for data store, data mart, and BI.
Designing the exchange Datawarehouse (DW) and Cube.
Designed a Common database using star schema design, as a reporting platform extracting data by creating ETL packages in SQL Server Integration Services
Design and develop SSIS packages for loading data. This also includes writing new stored procedures for the package.
Develop reports in SSRS for the business managers.
Understand business requirements. Discuss the new data feeds with business managers and understand how they need the data for reporting.
Maintenance of data feeds and reports. Handling change requests
Guiding team members and handling distribution of work within the team.
Other Relevant Experience
Sr. Software Engineer (12/2006 – 06/2011) (India, USA): Joined Satyam Computer Services (now Mahindra Satyam) as an SSE. Worked on multiple projects in Satyam for clients like Caterpillar, Merrill Lynch and Microsoft using Microsoft technologies.
Software Engineer (09/2003 - 12/2006)(India): Became a fulltime employee in Birlasoft Ltd as software engineer after completing my training on 9/2003. Continued working for GE projects after that. Worked on multiple projects in Birlasoft for clients like Sun Chemical, GE etc.
Trainee (04/2003 - 09/2003)(India): Birlasoft Limited as Project Trainee from.
Worked on multiple projects for GE capital investment services (GECIS), technology worked on were ASP, VB 6 and SQL Server 7.0.