SUMMARY:

• Currently working as a data warehouse solution architect which involves design the architecture for ETL and reporting framework involving Big data tools and languages (Hive, Athena, Spark) and AWS technologies (EMR, Redshift, Glue, Data pipeline, S3, EC2, Athena, Kinesis) in order to process several
• Terabytes of Data on a daily basis. Designed Data lake architecture for Viacom with Amazon S3 as the storage.
• Managing a team of ETL and report developers who are working on to deliver Analytical functionality at Viacom from weblog data. In addition to previously mentioned responsibilities, designed the ETL architecture for various data warehouse projects at
• Viacom and designed the dimension modeling for the data warehouse.
• 14+ years of experience in IT Industry, which includes design, development, and implementation of Data warehouse solutions using tools like MS BI SSIS, SSRS, SSAS, Informatica 8,7.1 (Power Center/Power Mart)
• Extensive experience in Dimensional Data modeling, Logical data model, Physical data modeling.
• Experience with using ERwin for data modeling.
• 5 Years of experience working with Big Data technologies HDFS, Hive, Amazon Web Service Technologies (EMR, S3, Presto, Athena, Glue, RedShift, Data pipeline, EC2, Kinesis, SNS, SES, Lambda), SPARK, Databricks and Reporting tool like SSRS, Tableau.
• Working in Viacom Data warehouse team as a Manager Analytics.
• Extensive domain Knowledge in Media and Entertainment industry.
• Have a good working experience in agile methodologies.
• Good knowledge about Master Data Management, worked on Microsoft MDS tool.
• Experience in SQL query optimization and performance tuning for the ETL and Reporting purpose.
• Well exposed to the Software Development Life cycle, Project Management, Business Requirement Analysis, and Quality Process Adherence

TECHNICAL SKILLS:

Data warehouse Tools: MS BI suite 2008R2, MS BI suite 2014, ERwin.

Big data / Cloud Platform Tools: Hadoop, Hive, Spark, Databricks, Datorama, Domo, AWS Technologies (EMR, S3, Presto, Athena, Glue, RedShift, Data pipeline, EC2, Kinesis, SNS, SES, Lambda)

Relational database: SQL Server 2008r2, 2014, Oracle, Postgres, Redshift, Teradata

Reports and Analytics tools: SSRS, SSAS, Tableau

Software Language: Python, VB .Net, VC# .Net, TSQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential

Analytics Manager / Solution Architect

Responsibilities:

• Architect, design and implementation experience with various AWS services EMR, EC2, S3, IAM, Athena, Glue, Data pipeline, Redshift database, SNS, SES, Kinesis, Lambda etc.,
• Designed the logical and physical data model for the data warehouse using Erwin.
• Designed and involved in development of Daas (Data as a service) architecture for Viacom datalake using AWS platform.
• Lead a team in migration of ETL / reports from Datorama to Databricks Spark using Python and Tableau as part of Daas.
• Leading a team in migration of ETL / reports from Domo to Databricks Spark using Python and Tableau as part of Daas.
• Experience with creating DAG’s in Airflow for jobs.
• Created dimensional modeling for various data warehouse projects.
• Modeled and Created MSBI SSAS cubes with partition.
• Developed reports using MSBI SSRS.
• In the period of 10 years at Viacom, designed, developed data warehouse data models and ETL / ELT (MS BI SSIS) for various projects specific to Marketing team, Ad Sales team, Product Analytics, Analytics science group, Social Media Analytics team, Mobile Apps Analytics team, Content Royalty Analytics team.
• Worked with 1000’s of GB of data on daily ETL processing.
• Performance tuning the ETL, reports query
• Upgradation of SQL Server 2008R2 to SQL Server 2014, along with upgrading SSIS packages from 2008R2 to 2015.
• Developed analytics reports using Tableau
• Ensure Agile Methodologies are followed in the development of the ETL and Reports.
• Leading a team in migration of databases from Sybase to MySQL, MySQL to MongoDB.

Confidential

Technical Lead

Responsibilities:

• Leading a team in migration of databases from Sybase to MySQL, MySQL to MongoDB.
• Designed the logical and physical data model for the data warehouse
• Created dimensional modeling for various data warehouse projects.
• Modeled and Created MSBI SSAS cubes with partition.
• Developed reports using MSBI SSRS.
• Performance tuning the ETL, reports query
• Ensure Agile Methodologies are followed in the development of the ETL and Reports.
• Coordinating with Offshore team for allocating work and tracking the project progress

Confidential

Senior Software Engineer

Responsibilities:

• Assessment of Cognos Report Net reports - Creation of Inventory list and Complexity derivation
• Analyze Cognos Report Net reports which are to be migrated to Cognos 8
• Importing and Exporting reports and packages from CRN to C8
• Publishing packages in Cognos Framework Manager
• Identifying the Migration Issues and apply fix to the reports
• Creation of process documents like Technical Solutions, Functionality Issues and Fixes, etc.
• User on the Cognos 8.2 version
• Application Monitoring: Provide operational Support for the identified applications
• Corrective Maintenance: Provide problem resolution to programming errors (Bug Fixing)
• Regular Maintenance and Support: Answering queries about applications and helping with configuration
• Minor Enhancements: Provide Application changes due to changing business requirements using Informatica and Oracle.

Confidential

Software Engineer

Responsibilities:

• Analyzing and documentation of business user requirements.
• Analyze and Creation of data models for Clickstream Data.
• Develop ETL using Informatica 7.3 from Various source of information
• Unit / System Testing and User Acceptance Testing
• Develop stored procedures for the ETL.
• Testing and Production Deployment

Confidential

Software Engineer

Responsibilities:

• Involved in analyzing the accommodation of the ETL requirement using 4GL.
• Involved in writing SQL scripts for ETL processing from source to staging and staging to fact and dimension tables.
• Developing Report using Java, Servlets, Jasper Reports & iReport.
• Involved in Analysis, Design & Documentation
• Validation of user inputs using Java Script
• Involved in front-end Design using JSP

Confidential

Software Engineer

Responsibilities:

• Initial Study and Design of the system
• Involved in Designing logical and physical model of data mart
• Analyzing and preparing low level ETL design documents
• Involved in coding of DTS Packages for SCD Type 2 dimensions
• Involved in coding and implementation of complex business rules using PL/SQL and VB Scripting.
• Prepared and executed Test Case for DTS logic