Underwriter / BI Developer Resume

TECHNICAL SKILLS

Databases: SQL Server 2008/2008 R2/2012, MySQL, Oracle10g&11g, MS - Access 2013

Database/ BI Tools: SQL Server Management Studio, Microsoft Visual Studio 2012, SQL Server Profiler, SSIS, SSAS, SSRS, DTS, MS Access, Crystal Reports, Cognos, Tableau

Languages: strong understanding of T-SQL, familiar with C, C++, VB, XML

PROFESSIONAL EXPERIENCE

Confidential

SQL Reporting Analyst

Responsibilities:

Worked with SQL and database query tools by consolidating data from various data sources such as Oracle, SQL Server, MS Access, MS Excel, flat files using SSIS
Created financial reports and various ad hoc reports using SSRS
Interfaced with stakeholders to elicit, help articulate, and document business and reporting requirements, andtranslate those into the development and delivery of the final products

Confidential

Underwriter / BI Developer

Responsibilities:

Underwrite and re - underwrite personal Lines homeowners and renters policy
Modified and maintained SQL server databases related to underwriting department information
Performed analysis of findings and trends using statistical and risk analysis tools
Designed ETL packages with different data sources (flat files, Excel files, etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS
Developed TPH reports and numerous ad-hoc reports using SSRS on a daily/weekly/monthly basis

Confidential

BI Developer (project, part time)

Responsibilities:

Designed and created databases, tables, relationships, views, stored procedures and etc.
Developed packages using various transformations such as multicast, conditional split, data conversion, script component and lookup while loading the data into destination
Performed validation and error-handling of staging data using various conditions
Created SSAS cubes with multiple dimension hierarchies based on the OLAP reporting needs
Designed dashboards using matrix, drill down, pivot table, parameterized report and sub report
Analyzed mortgage lending trends based on demographics details, property usage, loan amount and etc.
Created data driven subscriptions for different users using Report Manager

Confidential

SQL Server SSIS/SSRS Developer /DBA

Responsibilities:

Created database and database objects such as tables, indexes, constraints, joins, triggers, UDFs, stored procedures, CTE, cursor, case statement, transactions and, etc.
Performed testing on stored procedures, indexes, triggers and handled the data validations
Used various data flow transformations such as lookup, derived column, union all, multicast, and conditional split while developing the packages (ETL)
Developed SSIS packages using different types of error handling for various events
Generated SSRS reports with drill down, matrix, filter, cascading parameter and sub report
Deployed and managed reports through Report Manager
Involved in backup, restore, performance tuning, monitoring and optimization of SQL server
Automated administrative tasks with jobs and alerts including SSIS package automation

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship