Business Intelligence Resume

Business Intelligence Resume

***** **********
Email: **************@gmail.com
Voice: 91-**********
               
Seeking challenging assignments for a career encompassing professional & personal advancement.

Experience Overview:
   
•Having 4.8+ Years of experience in Development, Implementation & Maintenance  Support of Business Intelligence and Integration Services using MS SQL Server
 2008, 2008R2 SSIS, SSAS, SSRS in client/server environment.       
•A systematic , Organized, hardworking team player with an analytical bent of mind Determined to be a part of a growth-oriented organization.
•A team player with strong communication ,analytical ,organizational and relationship Management skills. Successful track record in accomplishing assigned projects.
•Good exposure to documentation like Unit Test Cases and Test results.
•Excellent time management skills with proven ability to work accurately and quickly Prioritize coordinate and consolidate tasks.
•Successfully developing various projects within the strict time frame.
•Having experience in tool like MSBI (SSIS,SSAS,SSRS).
•Sound knowledge about Software Development Life Cycle Process.
•Good experience in T-SQL/Stored Procedure creation, functions, and DML queries.
•Implemented checkpoints at package level.
•Compiling strategic analysis for moving typical data from one source system to another source system and to warehouse and implemented ETL operations.
•Created solutions, projects and packages and managing them.
•Extensive knowledge on Data warehousing concepts.
•Involved in various tasks such as Control Flow( Execute SQL Task, For Each Loop   Containers, Data Flow Tasks, File System Etc..) and transformations such as Aggregate, sort, lookup, Fuzzy lookup, Merge join, Multicast, Conditional split, derived column.
•Worked with logging and Error handling in various projects.
•Implemented SCD’s while History maintenance in tables.
•Querying cubes using MDX.

Professional Experience:

•Worked as a Software Engineer for SumTotal Systems India Pvt. Ltd, Hyderabad from March 2009 to July 2011.
•Working as a Software Developer for Trigent Software Ltd, Bangalore, and Karnataka from Aug 2011 to Till Date.


Educational Qualification:

•Completed M.C.A from Andhra University in the year of 2008, Visakhapatnam.

Skills Summary:

•    RDBMS          :  SQL Server 2005/2008 R2.
•    ETL Tools    :  SQL Server Integration Services (SSIS).
•    Reporting Tools    :  SQL Server Reporting Services (SSRS).
•    OLAP Tools       :  SQL Server Analysis Services (SSAS).
•    Languages    :  C#.NET

Project #1:

Title    : ANV Data Warehousing and Reporting.
Technology: C#,SSIS,SQL,T-SQL
Client    : ANV Insurance ,UK
Role    : Team Member
Duration  :XXXXXXX.
Company    : SumTotal Systems India Pvt. Ltd

Description: 

ANV is insurance company, backed by some of the strongest reinsurance and financial partners in the market, the underwriting specialists at ANV understand the unique risks of unique markets. All ANV products are available on a worldwide basis and can be priced as either stand alone regional solutions or as bended global policies for any combination of the markets.

Roles:  

•Worked on dynamic SSIS package.
•Prepared number of source files for dynamic package to import the from various sources.
•Created target tables for various layers.
•Create non cluster indexes to improve the package performance.
•Worked on various issues found in dynamic package.

Project #2:

Project    : TOPS.
Client    : United Health Care.
Role    : Team Member
Duration    : XXXXXXXXX.
Company : Trigent Software Ltd

Project Exposure:
   
TOPS” is the system utilized by UnitedHealth Care for the administration, processing and payment of the majority of healthcare claims for large business customers.  These customers are typically self-funded, national or regional corporations that require processing, single billing and reporting on a large number of claims or membership groups spread over a wide geographic area.

“TOPS” was originally purchased from an outside vendor by the Travelers Insurance Company.  The TOPS claims processing platform evolved from its original name as the “Travelers Online Payment System”, with the “Travelers” replaced by “The” following the Travelers acquisition.
“TOPS” is a legacy system that streamlines the claim processing function through automation.  It interacts with other applications in the UNET Systems family to intake, edit, and auto adjudicate more than 82 percent of all claims received. As of 2009, the TOPS application encompasses 22 production engines, adjudicates more than 250 million medical claims annually.

Responsibilities:

•Extracted data from various sources like SQL Server 2008R2, Excel and Text file from Client server and through FTP.
•Involved in review of functional requirement specifications and supporting documents.
•Created Transformations and Mappings using Dataflow Tasks.
•Created Event Handlers for the package Using Event Handler Tab.
•Handled Performance Tuning and Optimization on SSIS and MDX, with Strong
•analytical and Troubleshooting skills for quick issue resolution in large -scale production environments located globally.
•The package created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy look up, Multicast, and Data Conversion.
•Involved in Package Deployment by using Deployment Manifest File.
•Studied existing OLAP system(s) and writing MDX Queries for data extraction from cube to generate the Reports.
•Having good knowledge over creation of cubes.
•Generate the different types of reports as per the Client Requirements.
•Rendering Reports in the form of PDF, Excel, CSV and Word Formats.
•Prepared Unit Test Specification Requirements.
•Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client Team, and Development Team.

Environment:

SQL Server 2005/2008 R2, DTS, SSIS, SSAS, SSRS, SQL Server Agent-SQL.


Project #3:

Project    : CARD PORTIFOLIO.
Client    : American Express.
Role    : Team Member.
Duration    : XXXXXXXX.
Company : Trigent Software Ltd.

Project Exposure: 
      
Amex is one of the leading financial institutions offering credit card services & banking services to its customers which operate in US, UK some parts of Europe. This application becomes an income generator to the client apart from Account receivables like annual fees, Interest charges, finance charges, late payment fees etc..It is an online financial authorization system (FAS) that provides you with the means to authorize transactions online in a real-time, file update environment. FAS supports private label authorization requests, as well as Visa, MasterCard, and Euro card transactions. FAS interfaces with the following authorization networks virtually 24hours a day, seven days a week.
FAS interact primarily with the Credit Management System (CMS) in an issuing environment. FAS holds all of the parameters needed to make authorization decisions, while CMS holds all of the account information. During the authorization process, the FAS rules are applied against the account information in order to determine if the authorization is approved, declined, referred, or queued for a manual decision. Authorizations impact the open-to-buy for a CMS account online in real-time. FASpasses all authorization approval and reversal information to CMS during batch processing.

Responsibilities:
•Implementation and delivery of MSBI platform solutions to Develop and Deploy ETL Reporting on SQL Server 2008R2 using SSIS, SSRS.
•Used Control flow Tasks and For Loop Container, For Each Loop Container, Script Task, Execute SQL Task, Data Flow Task.
•The package created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy look up, Multicast, and Data Conversion.
•Involved in Package Deployment by using Deployment Manifest File.
•Coding/Programming tasks to specification and in accordance with Development standards.
•Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client Team, and Development Team.

Environment:

SQL Server 2005/2008 R2, C#,DTS, SSIS, SSRS, SQL Server Agent-SQL.

0 comments:

Post a Comment