Pallavee Gajera
Business Intelligence Developer @Commonwealth of Kentucky
Signup · Get unlimited contacts
WORK HISTORY
Business Intelligence Developer @Commonwealth of Kentucky
EDUCATION
Campbellsville University
Master's degree, Information Technology Management
Gujarat Technological University (GTU)
Bachelor of Engineering - BE, Information Technology
ABOUT PALLAVEE GAJERA
Seasoned Business Intelligence Developer with over 8 years of hands-on experience in SQL and MSBI. Adept at working with diverse data warehouse projects, specializing in star schemas, snowflake schema, and comprehensive data modeling.Key Skills and Achievements:• Proficient in SQL Server, excelling in developing complex stored procedures, views, triggers, user-defined functions, CDC, and index creation.• Strong expertise in SQL programming, utilizing advanced features for optimal performance, including Bulk Binds, Materialized views, Joins, Inline views, and Global Temporary Tables.• Extensive experience across the entire MSBI stack, encompassing SQL, SSIS, SSAS, SSRS, and Power BI.• Designed SSIS Packages for extracting data from various heterogeneous sources, such as Access databases, Excel spreadsheets, and flat files, into SQL Server for in-depth data analysis and reporting.• Proficient in creating diverse report types, including complex drill-down & drill-through reports, matrix reports, sub-reports, and charts, using SQL Server Reporting Services (SSRS) based on both Relational and OLAP databases.• Successfully led the migration of data from Excel and flat files to MS SQL Server using SSIS packages.• Implemented data transformations between servers using tools like Bulk Insert, Data Replication, Data Transformation Services (DT), and SQL Server Integration Services (SSIS).Technical Skills:• SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio• Languages: C/C++, C#.NET, T-SQL, MySQL, HTML, CSS, JavaScript, XML• Operating Systems: Windows Server Windows Server 2003, Windows XP, Windows 2008, Unix• Databases: MS-SQL Server, MS Access• ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), DTS• Reporting Tools: SSRS, Excel reporting• DB Utilities and Design Tools: SQL Server Management Utility, Query Analyzer, SSAS Cubes, MDX scripting• Application Software: Visual Studio, MS Office, MS Visio• Methodologies: Agile, Waterfall• Source Code Control: TFS, GitLet\'s connect and explore opportunities to leverage my skills in your projects.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.