Description
SUMMARY * Over 7+ years' experience as Business Intelligence Developer using Microsoft BI framework (SQL server, SSIS, SSRS, SSAS) in various business domains including Finance, Insurance, and Information Technology. * Experience in Relational Database Management Systems, Including Normalization, Data Import/Export, Joins, Stored Procedures, Views, Keys, Constraints, Indexes, Triggers, Cursors. * Strong knowledge and experience in error handling of SSIS packages using transactions, checkpoints (package restart ability features), break points and error logging procedures. * Expert in building Data Integration, Workflow solutions, and ETL solutions for data warehousing using SQL Server Integration Services (SSIS). * Extensive experience in migrating data from various sources such as Excel, Oracle, MS Access, My, SQL, OLE DB, and flat files to different destinations using SSIS. * Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard. * Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub-queries, Complex joins. * Experience in Tabular Models in SSAS. * Worked with Dimensional data warehouse models. * Power-bi experience * Experience in Performance Tuning in SSIS package by using Row Transformations, Block and Unblock Transformations. * Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning * Comfortable working with calculations using DAX and MDX queries. * Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. * Set up security access and maintain auditable records. * Worked with T-SQL, DDL, and DML Scripts and established relationships between tables using Primary Keys and Foreign Keys. * Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity * Well-versed in usage of SSIS Control Flow items (For Loop, Execute SQL task, Send Mail Task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot). * Experience in developing crystal reports. * Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all etc. . * Developed cubes in SSAS. * Experience in creating and managing Error logging, Event Handlers, Package Configurations, creating Jobs, SQL Mail Agent, Alerts, Scheduling SSIS Packages and Custom Logging for SSIS Packages. * Strong communication and team-oriented skills with a strong attitude toward learning new technology quickly supporting the project requirement. * Expert and proficient in highly analytical & detailed reports that include drilldown, drill through, parameterized (Cascading parameters), Top N Summary, ad-hoc reports, OLAP, cross tab, linked and sub reports and filters, charts in SSRS 2005/2008/2012/2014. * Experience in Deploying reports in various sources like Web browser in XML and PDF formats. * Experience with Power-bi dashboard, reports. * Worked with end users/business analysts to understand business requirements, recommended technical solutions and documented functional requirements. * Experienced in Dimensional Data modeling, SSAS Performance Tuning, Cube Partitioning, ER diagrams and Data Flow Diagrams, Scripts and formulas, Refresh Strategy and Planning * Experience in working with Team foundation server to document the source code * Extensive Knowledge in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery.
Accomplishments
Highlights:
Keywords
