Project Manager – Data Management
• T-SQL Proficiency: Expert in crafting T-SQL stored procedures, Indexing, triggers, and user-defined functions and implementing security protocols alongside DML and DDL commands• Query Optimization: Adept at optimizing queries for improved performance and efficiency in data retrieval processes• Reporting and Dashboards: Skilled in generating ad-hoc reports and dynamic dashboards using Power BI and SSRS, tailored to immediate user requirements and strategic KPIs like billing hours and QA details, Implementation of Role and security.• SSRS Reporting: Competent in creating diverse report formats (tables, matrixes, charts) and developing Drilldown/Drillthrouh/sub-reports and linked reports using SSRS, based on client specifications, Implementation of Role and security.• ETL and Data Warehousing: Extensive experience in ETL processes using SSIS, with a strong understanding of data warehousing concepts, OLAP, and dimensional data modelling (Star Schema/Snowflake Schema)• SSAS Tabular Model: Proficient in Designing and Deploying SSAS Tabular Cube and Measures as the analytic layer.• Data Transformation and Integration: Proficient in developing ETL mappings and transformations such as Derived Columns, Conditional Splits, and Lookups for staging and data warehouse loading• Data Management and Release Policy: Developed and implemented data management policies and procedures like Data Archival, De duplication, Partition, and Role securities that resulted in a 60% increase in data accuracy. Implemented Project Release Governance policies on UAT and Production Servers.• Configuration and Scheduling: Implemented checkpoint and package configurations in SSIS for enhanced package reusability; experienced in creating scheduled jobs and alerts• Error Management: Established systems for error logging and handling within SSIS packages to ensure data integrity and process continuity
