Market Strategy

Worked on Sqoop for data Ingestion, Hive & Spark for Data Processing & Oozie for designing complex work flows in Hadoop frame work.

Leveraging Lambda Architecture using Kafka Connectors using Hbase schema designs.

Good working knowledge of the various layers in the Lambda Architecture (Batch, Speed & Service layers)

Familiarity with HDFS, MapR filesystem, M3 & M5 clusters, Oozie, scooping, Hive, Spark frame work

Great knowledge on Spark framework with Scala and Java APIs.

Handling the Data level issues while writing UDFs.

Income Asset Projections Project:

Developing SSIS ETL packages in optimal way

Developing SQL procedures ,SQL function implementing business logic

Developing OLAP cubes for users reporting

Improving Stored Procedures performance by using SQL profiler and Database tuning advisor

Improving the OLAP Cube performance by implementing Measure group Monthly partitions for faster reports generation and faster cube processing

Came up with different test scenarios for automating Unit test cases, Build verification test cases and Environment test cases

Developing deployment and build document for the application

Handling new change requests and defects for the existing phases in the production environment

Worked on running audits, automated data controls, and scheduling tools

Responsible for ETL Design

Part of Dimensional model after analyzing all the systems together.

Worked on Building Complex SSAS Cube based on Kimball’s Structure

Estimate the effort required to develop the components

Designed primary database version by adding tables, relationships, creating stored procedures, views.

Analyzed and discussed the gaps between different modules of the system and discussing the gaps with the functional personal

Experience in SharePoint architecture, design, development experience and can support custom applications built on the MS Office SharePoint Server Moss platform in an agile environment. Developed overall scope and work plan for implementing requirements.

Working knowledge of design tools (e.g. Photoshop, Illustrator, Dreamweaver,Adobe Software, MS Office, Wordpress)

Comfortable working in a distributed team environment.

Experience in C#, .NET, ASP.NET, XML, SQL, SQL Server. Also, HTML and CSS, VS 2010 and TFS experience.

Worked on the various styles of data analysis and business intelligence (reporting, dashboards, advanced data discovery, OLAP, data mining, geospatial analysis, etc.)

Understanding of the functional and technical concepts within the ETL and DW domains

Functional knowledge of the broad BI and EIM solution landscape

Working proficiency with SQL Server, Oracle, MySQL, and/or DB2 database management systems in order to analyze and profile client data