SUMMARY:

• 20 years. proven track record of implementing BI solutions for various business.
• An information technology expert with Database architecting, Data warehousing solution using SQL Server BI stack and Amazon Cloud BI in commercial and public sector organizations.
• Excellent experience in managing diverse teams and remote workforces, Onshore and Offshore team management.
• Proven track record of delivering database solutions on time, in budget and exceed expectations.
• 20 years of Experience in Information Technology, and Delivering Enterprise database solutions.
• 12 Years of experience with Data warehouse and BI solutions using SQL server (SSIS, SSRS, SSAS, MS Power BI).
• Experience Amazon Cloud solutions (Amazon AWS, Amazon S3, Matillion ETL tool, Amazon Redshift, Amazon QuickSight and Tableau)
• Excellent Experience as OLTP and BI database architect.
• Extensive experience in Database/Application Architecture and Software Development Life cycle.
• Expert experience in Project management, Requirement Analysis and Documentation.
• Proven experience in delivering complex solutions working with onshore and offshore team.
• Years of experience in managing developers, tester, DBA and other IT professionals
• 15 years of experience in Software Development Life Cycle (SDLC)

TECHNICAL SKILLS:

Database: SQL Server 7, 2000, 2005, 2012, 2014, 2016 (SSIS, SSAS, SSRS, CDC, DQS, Replication, Always - on, Mirroring, Performance Tuning, Optimization, T-SQL Development, OLAP- Dimensional, OLTP - Transactional, Administration, Installation, Migration, Backup, Recovery, Monitoring), Amazon Redshift, Access, MySQLDatabase architecture, Database Designing, BI modeling (Star, Snowflake schema), Dimensional Modeling, Tabular modeling, Column store modeling, Matillion ETL tool

Visualization and Reporting: Microsoft Power BI, Amazon QuickSight, LogiXML Business intelligence tools, Tableau Server, Tableau Desktop, Dundas BI Dashboard and Visualization, Excel powerpivot

Functional Skills: Requirement Analysis Documentation, Project Planning and Budgeting, Proposal Writing, Disaster Recovery Plan, Project Management, SDLC, User Training, Technical and Business Presentations, Visio, iRise

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Lead SQL Server DBA and BI Architect

Platform: SQL Server 2012/14, SSIS, SSAS, SSRS, CDC, DQS, Replication Tableau Server, Tableau Desktop, MySQL.

Responsibilities:

• SQL Server administration and Development
• SQL Server Performance tuning and Optimization
• Architecting and Designing data warehouse solution for Confidential .
• Building DW Data Mart for various government agencies that support Confidential .
• Working with stakeholders to define the requirements and documentation
• Architecting and Implementation of data warehouse solution using SQL Server and Tableue.
• Designing reporting features (Presentation, Drilldown and drill through reports)
• Mentoring and leading developers and team members.
• Training and Presentation of Data warehousing concepts, visualization and ETL tools to management and decision makers.
• SQL Server 2014 Performance tuning and Administration

Confidential, Columbus, OH

Lead SQL Server DBA and BI Architect

Platform: SQL Server 2012/14, SSIS, SSAS, SSRS, CDC, DQS, Replication, MS Power BI, Amazon AWS, Amazon S3, Matillion ETL tool, Amazon Redshift, Amazon QuickSight, Tableau Server, Tableau Desktop, MySQL, Amazon DynamoDB

Responsibilities:

• SQL Server administration and Development
• SQL Server Performance tuning and Optimization
• Architecting and Designing data warehouse for multiple companies include Energy, Hospitality, Construction and Leasing.
• Building DW Data Mart for various companies and defining Facts and Dimensions
• Working with stakeholders to define the requirements and documentation
• Architecting and Implementation of data warehouse solution using Amazon Redshift and SQL Server BI Stack.
• Designing reporting features (Presentation, Drilldown and drill through reports)
• Designing Dashboards, Visualization and reports using Ms Power BI, Amazon QuickSight and Tableau
• Design and implementation of Matillion ETL tool and SSIS Packages to get data from various sources to Amazon Redshift and SQL Server Data warehouse.
• Implementation and Administration of MS Power BI, Tableau server and Desktops
• Publishing Tableau Dashboards and reports to Tableau server
• Building and publishing QuickSight Dash boards and reports
• Mentoring and leading developers and team members.
• Training and Presentation of Data warehousing concepts, visualization and ETL tools to management and decision makers.
• SQL Server 2012 Performance tuning and Administration
• Implementation and Administration of SQL Server Transactional replication.

Confidential, Reston, VA

Lead SQL Server DBA / BI Architect

Platform: SQL server 2014, SSRS, DQS, SSAS, SSIS, OLAP, MS VISIO, Tableau Server, Tableau Desktop, .net, TFS, Amazon Redshift, amazon S3

Responsibilities:

• SQL Server administration and Development
• SQL Server Performance tuning and Optimization
• Architecting and Designing CDP DW database (Star schema) in SQL server 2014.
• Building DW DataMart for various programs
• Working with stake holders to define the requirements and documentation
• Architecting and Implementation of OLAP using SSAS (Analysis Services).
• Designing reporting features (Presentation, Drilldown and drill through reports)
• Designing Dashboards and reports using Tableau and SSRS
• Design and implementation of SSIS packages for Data transformations.
• Design and Implementing MS DQS for maintaining DW data quality.
• SQL Server Performance monitoring and Trouble shooting.

Confidential, Boston, MA

Lead SQL Server DBA / BI Architect

Platform: SQL Server 2008 r2, SQL Server 2012, SSAS, OLAP, SSIS, SSRS, Logi-XML Business Intelligence Tools, Dundas BI, SharePoint, Tableau, .net., TFS, Tableau Desktop

Responsibilities:

• Architecting and Designing Confidential DW database (Star schema) in SQL server 2008 r2 later migrated to SQL Server 2012.
• Architecting and Implementation of OLAP Cubes using SSAS (Analysis Services).
• Designing reporting features (Presentation, Drilldown and drill through reports) - SSRS
• Design and implementation of SSIS packages for Slowly Changing Dimensions and Data transformation.
• Managed and administrated database and database applications 24x7
• Manage Team of Developers, database developers and deliver project on time.
• Project management, Requirement gathering and Analysis.
• Performance tuning and monitoring (SQL server 2008 R2, 2012)
• Implementing Dashboards and Reports using Tableau and Dundas visualization tool
• Implementing Disaster recovery plan, Backup and Recovery procedures.
• User training and Presentations.
• Project planning, Budgeting and resource management.
• Integration of National Clearing House and Charter and Public Schools Data.

Confidential, Fairfax, VA

Lead BI Database Architect / Database Administrator (SQL Server)

Responsibilities:

• Architecting and Designing Confidential Longitudinal student tracking database in SQL server 2000.
• Designing reporting features (Presentation, Drilldown and drill through reports) - SSRS
• Design and implementation of Confidential packages for data migration and database updates.
• Managed and administrated database and database applications 24x7
• Manage Team of Developers, database developers and deliver project on time.
• Project management, Requirement gathering and Analysis.
• Performance tuning and monitoring.
• Implementing Dashboards and Reports using SSRS
• Implementing Disaster recovery plan, Backup and Recovery procedures.
• User training and Presentations.
• Project planning, Budgeting and resource management.

Confidential, Washington, DC

Lead Database Administrator / Architect

Responsibilities:

• Provide 24x7 support and maintenance.
• Build and execute Database refreshes from production to test and development databases.
• Implement database changes and releases.
• Create and schedule scripts for routine database maintenance.
• Install, Configure and Administration of SQL Server (Production and Development)
• Designed and Implemented Physical databases model on SQL server.
• Performance monitoring and Tuning SQL server and Queries.
• Manage and Implement database releases and Moving database from Test and Stage to Production.
• Provide support to users and Development team.
• OLAP and data warehousing modeling and implementation
• ETL Scripting and automation
• Confidential and SSIS package design and implementation.