Gaurav Gupta
BI Architect - Microsoft Certified Solutions Associate: SQL Server 2012/2014
- Role
- Bi Architect at Hilton
- Location
- Memphis, TN, US
- LinkedIn followers
- 500 followers
About Gaurav Gupta
Seasoned technical BI lead with over 11 years of professional experience specialized on…
Experience
Bi Architect
Jan 2014 — Present · Memphis, TN, US
Led team of 5 people and communicated over 20 people in diverse group to achieve internal development goal.• Migrated DBs and SSIS packages from SQL Server 2005/2008 R2 to SQL Server 2012.• Requirement analysis and design document, Interfaces with clients to define business objects, gather report requirements, architects data warehouse solutions, and balance responsibilities between on/off-shore resources to maximize productivity.• Studied, troubleshoot and configured corporate wide scheduling system. 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 critical achievement to support data delivery service level agreement.• Executed change management and release management processes based on business needs.• Report requirement gathering for both Cognos and SSRS; monitor report performance and assisted Cognos developer to improve the performance.• Assisted developers with release testing and application enhancements (improved searches, sorts, grooming, web page displays).• Installed, configured SQL 2005, 2008 R2, SSIS, SSRS and Cognos 8 – setting up Test and Stage servers.• Recognized for displaying excellent problem solving and team management skills.Maintained BI architecture documents up-to-date.• Implemented Data archival and purge strategy by using SSIS; involved in server migration.• Technologies: SQL Server 2005, 2008 R2, 2012, SSIS, SSAS, SSRS, Cognos 8.0, MS TFS, Visio.
Education
St. Francis School
Xth
1985 — 1997
Motivational Pathway
Master of Computer Applications (MCA), Computer Science
2002 — 2005
Skills
- Web Services
- Microsoft Sql Server
- Core Java
- Testing
- Rdbms
- Software Development Life Cycle (Sdlc)
- Oracle Pl/Sql Development
- Struts
- Sql Server Integration Services (Ssis)
- Business Intelligence
- Pl/Sql
- Databases
- Sql
- Requirements Analysis
- Requirements Gathering
- Software Development
- Data Warehousing
- Database Design
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.