MOHAN DIVYA KAMOJALA

BI Senior Consultant

aczvyz@r.postjobfree.com

Mob: +1-248-***-****

SUMMARY OF EXPERIENCE:

** ***** ** ** ********** in Analysis, Development, Testing and Deployment of Business Intelligence Projects.

Expertise in working on complex data warehouse projects.

Strong ETL and Report development experience using ETL tool SSIS and Reporting tool SSRS.

Have basic knowledge on SQL Server Analysis Services.

Have in-depth knowledge in Data analysis, Data warehousing and ETL (Extract Transform and Load) techniques.

Experience in functional and technical systems analysis & design, systems architectural design, presentation, process data flow design, and system impact analysis and design documentation and presentation.

Ability to communicate clearly, having good problem solving skills and attention to minute details.

Great experience in working under high pressure with tight deadlines on the projects.

TECHNICAL COMPETENCIES:

ETL Tools : SSIS

Reporting Tools : SSRS

Databases : Sql Server 2012, Oracle 10g

Version Maintenance: Team Foundation Server

PROFESSIONAL EXPERIENCE:

DELOITTE CONSULTING INDIA PRIVATE LIMITED (Oct 2013-Mar 2017)

DAS

Senior Consultant

May2016 - Mar2017

TASMANIAN ALKALOIDS

Senior Consultant

Oct2015 - Apr2016

ANTHEM

Senior Consultant

Oct2013 - Sep2015

Responsibilities:

Involved in all phases of SDLC from requirements gathering, design, development and testing of ETL process using SSIS.

Gathered, analyzed business requirements and created mapping documents for the integration process.

Reported development based on user requirements and present dashboards.

Developed test scripts and performed unit tests on the ETL mappings ensured results are accurate before moving to QA.

Migrated database from Oracle 10g to SQL Server 2012 using SQL Server Migration Assistant Tool.

Accountable to successful implementation of project across various work streams being executed offshore.

Environment: SQL Server 2012, SSIS, SSRS, SSAS, SSMA, Oracle 10g, TFS

TATA CONSULTANCY SERVICES (May 2010-Oct 2013)

AC Nielsen, USA

Senior Developer

Oct2012 - Oct2013

Microsoft, USA

Senior Developer

May2010 - Sep2012

Responsibilities:

Requirement analysis and preparation of design documents

Development of T-SQL and SSIS packages

Optimized application performance to a considerable level by tuning the SQL queries

SQL 12 Migration for the applications US EPG Datamart, from existing SQL Server 2008

Conducted code reviews

Mentored new resources in the team

Environment: SQL Server 2008, SQL Server 2012, SSIS, SSAS, VSTF.

INFOSYS TECHNOLOGIES LTD (Feb 2006-Apr 2010)

Shinsei Bank, Japan

Developer

Oct2007 - Apr2010

British Telecom

Developer

Jun2006 - Sep2007

Responsibilities:

Documented business requirements

Designed and developed SSIS packages

Designed application user interface as per client’s requirements and received an appreciation for the same

Worked on T-SQL and created Stored procedures as a part of database population

Environment: SQL Server 2005, SSIS

Contact this candidate