Data Arch and Analytics available on c2c

May 08, 2020

Data Arch and Analytics available on c2c

Greetings of the day

Kindly find the details of my consultant available for your direct client requirement, on c2c. Kindly share the complete Job description at sadath@mutexsystems.com

Consultant"s info:-

Name: Gunasekaran D

Total exp: 12+ years

Current location: NYC NY

Relocation: Open
Visa: H1b

Availability: 2 weeks' notice

Resume Summary

. 12+ Years of experience in Data warehousing technologies and methodologies with extensive experience in Business Intelligence Tool Business Objects, Tableau, Birst and considerable experience on cloud Tool Amazon Web Services. He has strong querying knowledge on DB2, Oracle, SQL Server, Postgres SQL, Teradata, snowflake and Informix databases. He has significant experience in Requirement Analysis, Design, Quality Reviews, Development, deployment and support of large-scale enterprise warehouse and applications for Banking, Insurance, Retail, Healthcare and Telecommunication customers.

. Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.

. Working with team of Business owner designed, developed and implement a Tableau Dashboard and ad-hoc reports Solution for Enterprise supplier management and Workplace solution.

. Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (9.1 / 2018.1) reports.

. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

. Hands-on experience in creating space in BIRST using admin tool, knowledge in creating hierarchy, grains, custom attributes, measures, subject areas.

. Generated BIRST dashboard with multiple charts, filters & parameters.

. Develop BIRST reports that provide clear visualizations of various industry-specific KPIs.

. Expertise in Business Objects Enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, BI4.1 Information Designer Tool, Infoview) and its deployment.

. Ability to solve universes problem in BO. Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.

. Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.

. Monitor the Business objects schedules, calendar events creation, User & group; Setup the triggers in the Business Objects CMS.

. Responsible for implementation of BOBJ reports by creating BIAR file in the Import wizard and rollout the changes in the QA and Prod region.

. Extensively worked on Mappings built through Scala framework using various transformations like Filter, Sorter, Aggregator, Union, Joiner, Read data from multiple formats type, API call, Rank, XML etc.

. Hands-on experience in implementing SCD (Type1 & Type2).

. Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De Normalization Concepts.

. Exposure to Production support projects, handing of incidents, job monitoring and problem managements.

. Have excellent inter-personal and client interfacing skills and the ability to quickly understand technical scenarios and formulate efficient solutions.

. Expertise in Design and development of ETL logic through Spark Scala.

. Invoking multiple libraries in Spark using Scala and utilizing Data frames and Spark SQL API for faster processing of data.

. Designed and developed data loading strategies, transformation for business to analyze the datasets, responsible in performing sort, join, aggregations, filter, and other transformations on the datasets using Spark

. Wrapper script to call the SPARK Scala program for execution and archived the output files in S3 bucket, email or load the data into Database.

. Good knowledge and an experience in UNIX shell scripting, Python.

. Good analytical, technical, design skills, strong defect fixing and problem solving skills.

EDUCATION & CERTIFICATIONS:

. Bachelor of Engineering in Electronics and Communication University, 2005.

. Certified SQL in ORACLE 9i.

. AWS Certified-Developer- Associate.

TECHNICAL SKILLS:

Hardware / Platforms:	UNIX, Windows 98/XP/2000/7
ETL:	Informatica 9.0.1/9.5.1, Spark Scala
Business Intelligence:	BI 4.1, Business Objects XIR 3.1, 2.0, Business Objects 6.0 &5.1.9, Tableau 9.1&2018.1, BIRST 5.32, Business Objects XIR 3.1 Server
Databases:	Oracle 9i/11G, MS- SQLSERVER, DB2, Teradata, Postgressql, Snowflake, Informix DBA Access
Programming Languages:	Informix 4GL, PL/SQL
Scripting Languages:	Unix scripting, Python, PYSPARK, Databricks