Description
Professional Summary * Over 8 years of professional experience in providing Business Intelligence, Data Warehousing solutions, and Database Administration, designing and implementing ETL Strategy and designing Data Warehouse * Experience in Data modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs. * In-depth knowledge about Extracting and Loading Data, Using Data Flow Transformations, Managing Control Flow, Scripting Tasks, Debugging Packages and Managing Package Execution. * Expert in Disaster recovery management such as log shipping, database mirroring, database snapshots and implementing replication. * Expert in Creation and maintenance of Databases, creating Roles and managing user permissions. * Strong experience in utilizing Event-handlers, Transactions and Checkpoints to detect and handle processing errors. * Extensive experience in auditing the packages using custom loggings, annotations and row counts and maintained the data warehouse using SSIS by implementing various maintenance tasks like Backup database, Check DB integrity, Index rebuilding and organizing, shrink database and Update statistics. * Identified and tracked the slowly changing dimensions and also determined the hierarchies in dimensions. * Experience in writing Complex Stored Procedures and Triggers or near real time ETL solutions ensuring a 5 minute interval of incremental data. * Hands on Experience in exposing and managing package properties to various environments using SSIS Package Configurations like XML Configuration, SQL Server Configuration and Environment Variable configuration. * Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, fact and dimension tables. * Created various types of documents like ETL mapping documents, Data Conversion documents, Data Dictionary documents, created test cases and testing documents on various DB objects. * Experience in creating multidimensional cubes using the SQL Server Analysis Services. * Involved in designing Aggregations, User Hierarchies, Optimizing Aggregations and Tuple-based Calculated Members. * Implemented and maintained database security by creating and maintaining users, roles and assigning privileges. Involved in Database tuning and performance monitoring. * Expert in Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors. * Extensive experience in creating Clustered, Non-Clustered, Covered indexes and indexed views. Balancing Index maintenance and using included columns. * Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers using SQL Server, T-SQL. * Experience in creating various reports using the Report builder tool in SQL server Reporting Services of SQL Server 2005/2008 like tabular, matrix and chart reports used in the dashboards as well as Crystal Reports. * Experience in creating Drill down, linked, sub cascading Reports and Reports with Parameters using SSRS. * Experience in Report Authoring with Custom Development, Programming Report Server Management and Building Custom Reporting Tools * Hands on experience in Troubleshooting database issues. * A well-organized, goal-oriented, highly-motivated effective team member with excellent analytical, troubleshooting, and problem solving Skill.
Accomplishments
Highlights:
Keywords
