RAKESH KUMAR TRIPATHI

Hyderabad, India

Visa Status: Holding Canadian PR Visa

Mobile: +91 - 987-***-****

Email: acru6w@r.postjobfree.com

Best time to call: Any Time

Skype Name: rtripathi1234

LinkedIn URL: https://in.linkedin.com/pub/rakesh-kumar-tripathi/103/5b0/b35

Aspiring for a challenging position with a leading organization, where acquired knowledge and experience can be enriched and enhances the organizations bottom line profitability

PROFESSIONAL SUMMARY

AREAS OF EXPERTISE

Experience: An innovative expert and technically sophisticated IT professional with more than 6 years of experience in the design and development of Business Intelligence solution using Microsoft BI

Excellence: In-depth knowledge of system analysis, requirement gathering and specification, software design, development and complete SDLC

Acumen in business applications and business intelligence by utilizing MSBI tools like SSIS, SSRS, and SSAS

Competency: Well versed in SQL Server Integration Services as per ETL tool, SSRS reporting, SSAS cubes and MDX queries, and Data Analytics

Expertise in SQL Server Reporting (SSRS) and Integration Services (SSIS), Visual Basic, IBM Cognos and Tableau Analytics

Proficient in SQL Server 2005/2008/2012 database design and development with Agile based methodology

Skilled in Analysis Services using SQL Server Analysis Services (SSAS) using Multidimensional and tabular model.

Superior in Power BI, Power Pivot, Power View and MDX based analysis using SSAS Solutions.

Mastery in Designing, Developing and maintaining Enterprise Datawearhouse solution

Highly experienced working in client facing roles and interacting with various teams during the different project life cycle

Strong domain knowledge, including Banking Capital market, Mortgage, Property and casualty insurance and Financial Domain

Familiar with translating business requirements into technical solution concepts and designs and provide technical governance and guidance throughout the complete solution delivery lifecycle

Thought Leadership:

Excellent communication & relationship management skills, enthusiastic & self-driven, with a high degree of commitment

CERTIFICATION

70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012

70-466 Implementing Data Models and Reports with Microsoft SQL Server

70-467 Designing Business Intelligence Solutions with Microsoft SQL Server

Requirement Elicitation

Project Management

Application Development

Service Delivery

Strategic & Tactical Planning

Solution Implementation & Development

Product Designing

System Integration & Testing

Defect & People Management

Scripting & Documentation

Problem Resolution

Production Application Support

Team Management

EDUCATION

Bachelor of Engineering in Computer Science from VTU Technical University, India - 2008

Diploma in Computer Science, India - 2004

GLOBAL EXPERIENCE

Interacted with clients from USA, UK and Australia

Experience of working in UK

Experience of working in top MNC's like Mphasis, Genpact and MetLife Global

TECHNICAL FORTE

MSBI Versions:

2005, 2008, 2012

Reporting Tools:

ETL Tools:

Analysis Tools:

SSRS, SAP BO, Cognos

SSIS

SSAS, tableau

Database:

SQL Server 2005 / 2008 / 2012

Operating Systems:

Windows 7 /8 / XP

CAREER PATH

Employer

Designation

Duration

Value Momentum Software Service, India

Tech Lead

May 2015 - Till Date

JK Technosoft, India

System Analyst

Dec 2013 - May 2015

MetLife, India

Consultant

May 2013 - Dec 2013

Headstrong/Genpact, India

Senior Associate

Oct 2011 - May 2013

Mphasis, India

Software Engineer

Feb 2009 - Oct 2011

OVERALL RESPONSIBILITIES

Determine technology limitations and deficiencies in existing systems and associated processes, procedures and methods

Forecast technical tasks and job scheduling and performing a code review

Create new reporting techniques, data collection sources and constraints of developing business

Collaborate with the BI team for development of BI architecture and components

Define the scope, use, and requirements of business data warehousing

Determine business and system requirements and create reports

PROJECTS UNDERTAKEN

Title#1:

GEICO Umbrella Insurance May 2015 - Till Date

Client Name:

GEICO Insurance

Role:

Integration Developer

Description:

Used to

oMigrate mainframe based system to SQL Server

oDesign integration Solution using SSIS ETL and SSRS based dashboards

oDevelop ETL solution and feeds for Enterprise data ware house

Responsibilities:

Responsible for designing solution architecture and approving the design

Developing business logic in SSIS and scrutinizing the code for changes

Performing quality analysis for all SQL and SSRS release activities

Environment:

SSIS,SSRS, SQL Server

Title#2:

Multi Lingual Reporting Solution Jan 2015 - May 2015

Client Name:

Mansfield Oil Company

Role:

System Analyst

Description:

The main objective of the project is to create new scalable, easy to maintain and flexible solution for multilingual reporting

Environment:

SSIS, SSRS, SQL Server 2012

Title#3:

BI/SQL R&M (Business as usual) Dec 2013 - Jan 2015

Description:

Utilized to

oMaintain and enhance the existing Business Intelligence Solution, reporting solution, Multidimensional Cube and ETL process

oDesigned and developed Tabular Model, Power Pivot and Power BI solution

Responsibilities:

Accountable for maintaining existing BI/SQL solution

Designed Power BI end to end solution

Environment:

SSRS, SSIS, SQL Server, SSAS

Title#4:

Data Analytics Solution May 2013 - Dec 2013

Client Name:

MetLife Global

Role:

Consultant

Description:

This application is used to develop data analytics capability for the Internal Audit Department of the organization

Responsibilities:

Identified process audit parameters and analyzed the data

Liable for understanding business risk and mitigating controls

Created risk buckets as per the received data

Environment:

MSBI(SSRS,SSIS), SQL Server, Tableau Desktop

Title#5:

Open Box UK Reports (Tactical Reporting) May 2012 - May 2013

Client Name:

Iron shore (P&C Insurance)

Role:

Senior Associate

Description:

Provided reporting solution to Open Box London Policy system, cube based reports and enhancement in existing reports

Responsibilities:

Started the project at offshore

Responsibly offered necessary application support to clients

Developed reports based on SQL and MDX SSRS

Environment:

SSRS,SSAS,SQL Server

Title#6:

Open Co Bermuda/Open Box/MFX (Enterprise level Dataware house) Oct 2011 - May 2012

Description:

Used to create a new Enterprise Dataware house of Iron shore for its business in US, Bermuda and UK

Responsibilities:

Participated in

oDimensional modeling of database

oDeveloping ETL packages from OLTP system to Staging and Dataware house

oError Handling

Environment:

SSIS, SQL Server

Title#7:

Management Information Team Feb 2009 - Oct 2012

Client Name:

Westpac Bank Australia (Mortgage Domain)

Role:

Software Engineer

Description:

The main goal of the project is to provide reporting services to the Home Loan Department of the client organization

Also used to develop new Reports to meet new business requirement

Responsibilities:

Offered workflow reports to different team

Provided support for

oReporting Services in SSRS

oSSIS packages needed for ETL into reporting server

KEY ACCOLADES

Monthly Wining Culture award across the globe in Mphasis (2010)

Monthly performer award (Oct - 2010)

Star performer of the team

Bronze award from Genpact

Gold Award

Appreciation certificate from both on-site and best-shore group manager and project managers

MOBILITY

Ready to relocate as soon as possible

Do not possess a bond with current employer

Ready to attend the interview

LANGUAGE SKILLS

Fluent in English

Scored 7 bands in IELTS

References available upon request

Contact this candidate