We provide IT Staff Augmentation Services!

Senior Bi Developer Resume Profile

3.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY

  • I have 6 years of IT experience focusing on Data warehousing, Data Modeling, Data integration, Data Migration, ETL process and Business Intelligence.
  • Expertise in SSIS ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
  • Drawing on Experience in all aspects of analytics/data warehousing solutions Database issues, Data Modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions .
  • I have been key in delivering innovative database /data warehousing solutions to the Insurance and Healthcare Industries.
  • Strong understanding of Data Modeling Relational, dimensional, Star and Snowflake Schema , Data analysis, implementations of Data warehousing using Windows.
  • Extensive experience in SSIS ETL Package design, including data analysis, design, data mapping and conversion data load.
  • Created SSIS packages using Conditional Split, Data Conversion, and Fuzzy Logic and C .
  • Expertise in implementing script tasks with C scripting for complex business logic if needed.
  • Experience in Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008 and 2005.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by using SSRS
  • Experience in creating SSAS SQL Server Analysis Services Cubes in SQL 2005 and SQL 2008.
  • Experience in analysis of data through the three dimensional OLAP cubes and define hierarchies.
  • Created Aggregations, partitions and calculated members for cube as per business requirements. And expertise in writing MDX Query in OLAP Databases.
  • Involved in physical and logical database design and Transaction Management.
  • Extensive experience in T-SQL scripting with Stored Procedure, Views, Triggers, CTE etc.
  • Experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Have worked on database management activities such as scrubbing, metadata index and table creation.
  • Have configured, tested, patched and monitored all instances of database and experience in database segmentation and worked on designing the index and make partitioning.
  • Developed user audit strategies and major changes to the production tables using packages. Also managed user permissions on database objects.
  • Created custom-tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task. Upgraded/migrated databases from lower version of database to higher version.
  • Extensive experience in Installation, managing, monitoring, troubleshooting Configuration and Maintenance of MS SQL Server confidential Experience in supporting multiple Production database servers including backup and recovery, Performance Tuning.
  • Experience in resolving database performance and deadlocking issues.
  • Extensive Experience in developing Web Applications with ASP.NET and C .Net.
  • Able to work well independently and also in a team by helping to troubleshoot technology and business related problems.

PROFESSIONAL EXPERIENCE

Confidential

Project Name: confidential

Senior BI Developer

Description:

This process calculates contributions for the HDHP High Deductible Health Plan H.S.A. plan Health Savings Account and the H.R.A. plan Health Reimbursement Account .

The contributions for the H.R.A. plan are distributed on an annual basis per member based on when they become eligible for the plan. The process calculates contributions for the entire year during the February run for all members enrolled in the plan. Subsequent monthly runs will calculate prorated contribution amounts for any new member that has joined the plan. The contribution amounts are added to an accumulator bucket in the Claim facts accumulator file and are administered by GEHA. The contributions are also added to a custom VSAM file HDHPCTR and are viewable via the HSC VGEN screen. This process will build a new accumulator record for the New Year for the member if one does not already exist and will carry forward balances from the last 2 years. The contributions for the H.S.A. plan are distributed on a monthly basis for the previous month per member based on when they become eligible for the plan. The contribution amounts are sent to H.S.A. bank and added to a custom VSAM file HDHPCTR that is viewable and updateable via the HSC VGEN screen. If a member is enrolled in the H.S.A. plan but becomes ineligible for the H.S.A. plan they will be moved to the H.R.A. plan. This is usually a retro-active event. Therefore, this process looks at the H.S.A. plan and H.R.A. plan together for a member if they have switched plans to ensure we do not over contribute.

This process creates 4 flat files in SSIS Package.

  • Confidential Contribution File to send new H.S.A. contributions to confidential
  • H.S.C. Screen Update File to update custom VSAM file HDHPCTR with new H.S.A and H.R.A. contributions.
  • H.S.A. Over/Under Contribution File to create reports.
  • H.R.A. Accumulator Update File to update the Claim facts Accumulator file with new H.R.A. contributions. And this process creates 4 SSRS reports.
  • HRA ACCOUNT MONTHLY CONTRIBUTIONS details contributions made by member.
  • MONTHLY HDHP CONTRIBUTIONS ERRORS details overpayments found by member.
  • HSA ACCOUNT MONTHLY CONTRIBUTIONS details contributions made by month by member.
  • HSA ACCOUNT MONTHLY CONTRIBUTIONS BY MONTH/TYPE summarizes H.S.A. contributions made by plan and month.

Responsibilities:

  • Requirement gathering, analysis, process modeling, system and data modeling.
  • Created SSIS packages to copy the different source files from ftp site.
  • Implemented Error handling techniques.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Created the SSIS packages using different transformations Data conversion derived Column, Lookup union All, Slowly Changing Dimension.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by using SSRS.
  • Wrote SQL queries and stored procedures to generate data for reports
  • Created report snapshots to improve the performance of SSRS.
  • Created Non-Clustered indexes to improve query performance and query optimization.
  • Interacted with developers, Business Management Teams and End Users.
  • Participated in regular project status meetings.

Environment: Microsoft Business Intelligence Studio 2008, SQL Server 2008R2, Transact-SQL, SSIS, SSRS, C .Net.

Confidential

Project Name: Eligibility Extract process

Senior BI Developer

Description:

GEHA provides a monthly eligibility file of FEHB members to networks. The purpose is to allow contracted networks to have updated eligibility data to be able to determine patient eligibility when a member uses a contracted provider within the network. A file is sent to Accordant monthly with the following states excluded from the extract GA, PA, NC, SC these are Coventry states for FEHB client. A file is sent to Accordant monthly for PCIP client.

Responsibilities:

  • Requirement gathering, analysis, process modeling, system and data modeling.
  • Created SSIS packages to copy the different source files from ftp site.
  • Implemented Error handling techniques.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Created the SSIS packages using different transformations Data conversion derived Column, Lookup union All, Slowly Changing Dimension.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by using SSRS.
  • Wrote SQL queries and stored procedures to generate data for reports
  • Created report snapshots to improve the performance of SSRS.
  • Created Non-Clustered indexes to improve query performance and query optimization.
  • Interacted with developers, Business Management Teams and End Users.
  • Participated in regular project status meetings.

Environment: Microsoft Business Intelligence Studio 2008, SQL Server 2008R2, Transact-SQL, SSIS, SSRS, C .Net

Confidential

Project Name: Athenium Process

Senior ETL Developer

Description:

The project was an online scorecard for the Claim Representatives. The objective of the project is to integrate all the Claim representatives' data from different source databases and flat files to a data mart. We get data on a daily basis from different sources as flat files. After loading all the data the data had to be transformed to meet the requirement for the development team. The SSIS project had to be completely automated to execute when it finds new files uploaded on an FTP site.

Responsibilities:

  • Requirement gathering, analysis, process modeling, system and data modeling.
  • Created SSIS packages to copy the different source files from ftp site.
  • Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
  • Implemented Error handling techniques.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Created the SSIS packages using different transformations Data conversion derived Column, Lookup union All, Slowly Changing Dimension.
  • Developed Multi dimensional Objects Cubes, Dimensions using SQL Server Analysis Services SSAS .
  • Designed Dimensional Modeling using SSAS packages for End-User.
  • Created Hierarchies in Dimensional Modeling.
  • Developed Aggregations, partitions and calculated members for cube as per business requirements
  • Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by using SSRS.
  • Wrote SQL queries and stored procedures to generate data for reports
  • Created report snapshots to improve the performance of SSRS.
  • Created Non-Clustered indexes to improve query performance and query optimization.
  • Interacted with developers, Business Management Teams and End Users.
  • Participated in regular project status meetings.

Environment: Microsoft Business Intelligence Studio, SQL Server 2008/2008 R2, Transact-SQL, SSIS, SSRS, Oracle.

Confidential

Project Name: Scorecards Analyzers,

Senior ETL Developer

Description:

Scorecards/ Analyzers are basically used to evaluate the performance of employees of a company. It involves lot of performance criteria, objectives, KPI's Keep Performance Indicator . Performance criteria signify how efficiently an employee handles a claim or if an employee handles the claim within a date range. The objectives KPI's are calculated based on predefined formulae. The reports are based on different hierarchies in the company. Below are the few Scorecards/Analyzers

  • APD /LIABILITY
  • Commercial Casualty
  • COD Circle of Dependencies
  • No units/ Pending units
  • Cat Activity Report
  • Bulk Reserve report, etc

All above projects involves testing different metrics and for different levels like CR, Supervisor, manager and manger plus in farmers insurance. The primary intent is to provide accurate reporting of performance within the team. The reports will allow individual analysts the ability to access their own results, while the Supervisor and Manager will be able to view the individual and team results.

Responsibilities:

  • Requirement gathering, analysis, process modeling, system and data modeling.
  • Designed Staging Database and SSIS/DTS packages to stag the data from the different sources Oracle, SQL, Flat files.
  • Extracted required mapping fields from different sources
  • Created SSIS packages to clean and load data to data warehouse.
  • Created package to transfer data between OLTP and OLAP databases.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Created the SSIS packages using different transformations Cache Transform, Conditional Split, Lookup, Pivot, Script Component, Slowly Changing Dimension and union all.
  • Implemented Error handling techniques.
  • Developed Multi dimensional Objects Cubes, Dimensions using SQL Server Analysis Services SSAS .
  • Designed Dimensional Modeling using SSAS packages for End-User.
  • Created Hierarchies in Dimensional Modeling.
  • Developed Aggregations, partitions and calculated members for cube as per business requirements
  • Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by using SSRS.
  • Wrote SQL queries and stored procedures to generate data for reports.
  • Created report snapshots to improve the performance of SSRS reports.
  • Created Non-Clustered indexes to improve query performance and query optimization.
  • Created Reports Using OBIEE
  • Writing complex queries, Views.
  • Interacted with developers, Business Management Teams and End Users.
  • Participated in regular project status meetings.

Environment: Microsoft Business Intelligence Studio, SQL Server 2008, Transact-SQL, SSIS, SSAS, SSRS, OBIEE, Oracle, C .net. MS Sharepoint.

Confidential

Project Name: Pivot Sharp,

SQL BI Developer

Description:

Farmers Insurance Group of Companies is the country's third-largest insurer of both private Personal Lines passenger automobile and homeowners insurance. The project was to migrate data from various heterogeneous data sources such as oracle, MS Access, MS Excel and flat files into SQL Server 2005 and different reports for analytical purpose.

Responsibilities:

  • Designed Staging Database and SSIS packages to stag the data from the different sources Oracle, MS Access, MS Excel and flat files.
  • Analyzed and extracted required mapping fields from different sources
  • Created complex ETL Strategies to populate the Data warehouse/Data-mart facts and dimensions.
  • Created SSIS packages to clean and load data to data warehouse.
  • Created package to transfer data between OLTP and OLAP databases.
  • Performed database Tuning, monitoring, and Scalability Testing
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Created the SSIS packages using different transformations Cache Transform, Conditional Split, Lookup, Pivot, Script Component, Slowly Changing Dimension and union all.
  • Developed Multi dimensional Objects Cubes, Dimensions using SQL Server Analysis Services SSAS .
  • Created Hierarchies in Dimensional Modeling.
  • Developed Aggregations, partitions and calculated members for cube as per business requirements.
  • Wrote SQL queries and stored procedures to generate data for reports
  • Created Non-Clustered indexes to improve query performance and query optimization.
  • Created Reports Using OBIEE
  • Interacted with developers, Business Management Teams and End Users.
  • Participated in regular project status meetings.

Environment: Microsoft Business Intelligence Studio, SQL Server 2008, Transact-SQL, SSIS, SSAS, C .net., MS Sharepoint.

Confidential

Project Name: CCC KPI Reports

SQL BI Developer

Description:

Intent of this report is to automate the existing CMR4 report which is a CCC Excel report with COD, TOTAL LOSS and KPI FCR results. This report features key stats and metrics used by the APD team in monitoring and controlling the operation.

The entire APD staff will have access to this report in addition to APD management.

The report will provide information critical to managing efficient and cost effective file handling. Key metrics include:

  • Accuracy of the original estimate note that this calculation will not be the same as the scorecard Estimate Accuracy performance metric
  • Claim volume
  • Average costs per claim and per part
  • Alternative parts utilization
  • Labor hour stats
  • Cycle time stats
  • Frequency of supplements

Responsibilities:

  • Designed Staging Database and SSIS packages to stag the data from the different sources Oracle, MS Access, MS Excel and flat files.
  • Analyzed and extracted required mapping fields from different sources
  • Created complex ETL Strategies to populate the Data warehouse/Data-mart facts and dimensions.
  • Created SSIS packages to clean and load data to data warehouse.
  • Performed database Tuning, monitoring, and Scalability Testing
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Created the SSIS packages using different transformations Cache Transform, Conditional Split, Lookup, Pivot, Script Component, Slowly Changing Dimension and union all.
  • Created Hierarchies in Dimensional Modeling.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by using SSRS.
  • Wrote SQL queries and stored procedures to generate data for SSRS reports.
  • Created Non-Clustered indexes to improve query performance and query optimization.
  • Interacted with developers, Business Management Teams and End Users.
  • Participated in regular project status meetings.

Environment: Microsoft Business Intelligence Studio, SQL Server 2005, Transact-SQL, SSIS, Oracle, SSRS, C .net

Confidential

Project Name: Share accounting system

Dot net Developer

Description:

Share accounting system is designed mainly for co- operative bank. To open a new account in co-operative bank we need to take shares of bank, it also necessary to take share for loan purpose .My work contain the bank details, Opening new account ,and taking shares and its required parameters, and the customers can do share transaction through it, and also contain maintenance form and holiday information. Share transaction can do only depends on the various criterion of organization.

Responsibilities:

  • Gathering Requirements and documenting it
  • Understand requirements as stated in the Business Requirement document.
  • Build code samples and small prototype to help in technical design.
  • Develop code in C , ASP.NET.
  • Troubleshoot applications code build using C ,ASP.NET
  • Validate data for various activities.
  • Provide integration with other .NET front ends using MDX queries.
  • Query optimizing of SQL's by using SQL profiler.
  • Merge Scripts and Code artifacts into SVN configuration management system.
  • Provide support to the QA team in merging data across environments.
  • Help support the user community by answering production support and technical support queries.
  • Bug fixes and enhancements.

Environment: C , ASP.Net, MS SQL Server 2005,Javascript.

We'd love your feedback!