Principal Software Engineer Resume

SUMMARY

A rare blend of sound architectural and deep hands - on experience in ETL, BI/ Data Architecture and Data Modelling.
Designed and implemented several Data marts for companies big and small.
Data Modeling - Both 3 NF Relational and Dimensional schemas using ERWIN/ ER Studio.
Exceptionally strong SQL skills, wif ability to form complex queries and excellent performance tuning abilities.
Designed and built several ETL solutions, involving SQL Server, MYSQL . AWS Redshift
Good knowledge on cloud based architecture on AWS Redshift and familiarity wif EMR and in the usage of associated tools (Hive).
Expert level knowledge wif MS suite of BI Products including SSIS and SSAS.
Good competency in Tableau dashboards development and Python.
Since Feb-2017, working as a consultant Data/Solution Architect for the design of Data mart for a health Care targeting application at Confidential Medical Network.
From 2014 Dec to 2016 Oct, worked as Principal Software Engineer at Rovi Corporation, responsible for fine tuning the data architecture (Redshift), ETL, Performance tuning and Data visualization ( Tableau), designing and building dash Boards for a Project on Audience Analytics to analyze Viewership Patterns and Ratings.
From 2010 to 2014 Dec, worked as a BI/Data Architect in Confidential Medical Network, responsible for design, development & maintenance of Data-Warehouse & OLAP cubes. Also functioning as Tableau Administrator and deeply involved in developing Tableau Reports - Dash-Boards.
Worked as Sr Data Architect at Confidential, responsible for the development of Multi tenant structure and overall ETL design.
Worked as a Consultant at Microsoft - Seattle, since 2007 June and played the roles of Data Architect/Analyst, BI Architect and ETL-Cube designer/developer in several major Data Warehouse/ Data Mart Initiatives. ( 2.5 Years).
(Only last 10 years’ experience is indicated here.)

PROFESSIONAL EXPERIENCE

Confidential

Principal Software Engineer

Responsibilities:

Key player in a major project on Audience Analytics to analyze Viewership Patterns and Ratings for customers.
Designed and developed Tableau Dashboards on the audience analytics. Helped in the interpretation of product requirements into a performant design.
Designed and implemented ETL solutions ( SSIS) and database development ( SQL Server 2012) for custom entertainment metadata extraction.
Participated in the design of a data mart for entertainment music meta data, based on specific customer requirements, for an external customer
Involved in the Data architecture on MS Sql Server, AWS Redshift and undertook several Performance tuning activities.
Involved in a Data Analysis Project using Python.

The technologies Used: MS Sql Server, AWS-Redshift, Tableau, Python, MYSQL and Hive.

Confidential

BI Architect

Responsibilities:

Integrating legacy systems into the Data Warehouse after due cleansing of data and integration of business entities
Building of the OLAP cube, to satisfy both tactical and strategic needs of the organization.
Tableau Administration and Development of Reports

The technologies used: SQL Server 2008, SSIS, SSAS.

Confidential

Senior Data Architect

Responsibilities:

Responsible for setting up a Multi Tenant Environment for a Web based application, integrating several customer based schemas into a common schema.
Responsible for improving and fine tuning the ETL Process.

Confidential

Microsoft Corporation

Responsibilities:

Building a Enterprise wide data Warehouse ( EDW)
Data Marts for supporting a very high volume of Sales Transactions and analysis.
Data Mart for analyzing high volume of Web traffic.

Data Architect, BI Architect/Developer, ETL Designer/Developer, Cube Designer/Developer

Confidential

Design and Build SSIS packages to support high volume Transactions from the Web and other Systems.
Design and build SSAS cubes to support specific Business Requirements, wif advanced features and MDX scripting (Named sets, Calculated members, Dynamically partitioned cubes).
Designed the interface between the Cube and the SSIS.
Logical Modeling in two Subject Areas in 3NF ( Using ERWIN 7.3 ModelMart)
Dimensional Modeling for three major Data Marts, supporting Sales activities involving very high volume of global transactions.
Physical modeling including development of pre and post scripts for generating DDL scripts.

Confidential

Senior Systems Analyst

Responsibilities:

Senior Systems Analyst involved in identifying the process gaps, recommending amendments to the Package to bridge the gap, extensive systems analysis activities in identifying the mapping of data from the legacy systems to the new Package, defining the ETL processes for loading of data, Business re-engineering activities.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship