Resume

Sign in

Sql Server, Oracle, SSIS, Informatica, OBIEE, Tableau, DataWarehousing

Location:
San Jose, California, United States
Salary:
140,000
Posted:
February 28, 2018

Contact this candidate

Resume:

Abhishek Kumar

ac4m2i@r.postjobfree.com

Cell no: 408-***-****

Professional Summary:

** ***** ** ********** ** the IT industry with emphasis on Data Analysis, Database Design, Data warehousing, ETL and Dimensional modelling projects.

Involved in complete life cycle development and deployment of applications.

Extensive hands on end-to-end large scale Enterprise Data warehouse and Report Development experience.

Implemented functional domains like Banking, Supply Chain and Marketing Analytics through BI and ETL tools on source systems.

Used tools like Informatica, SSIS, OBIEE, Tableau, Adobe Site Catalyst along with scripting language like – UNIX Shell scripting, Python.

Consolidated data from multiple sources/API’s into central data warehouse environment using SSIS as an ETL tool.

Installation, upgrading and configuring OBIEE 11g tool.

Experience on relational databases like Oracle 11g, MS-SQL Server, IBM DB2 9.1/8.1 and different heterogeneous source systems like flat files, MS Excel.

Expertise in writing advanced SQL/PLSQL programs in Oracle Database, MS-SQL Server and PostgreSQL.

Configuring and Implementing of OBIA.

Good knowledge of Hadoop ecosystem, HDFS and Big Data.

Hands on Experience in working with ecosystems like Hive.

Improved technical skills horizontally & vertically in the business groups by providing trainings & mentoring.

Lead multiple projects for designing and maintaining the data warehouses and delivering business intelligence solutions.

Perusing Data Science course in Berkley Extension. As part of the program, submitted a mini-project based on Python to Perform Stock Analysis.

Technical Skills and Certifications

Concepts

Business Intelligence, Data Warehousing

ETL Tools

Informatica Power Center, Microsoft SSIS.

Reporting Tools

OBIEE 11g, OBIEE 10g, OBIA 7.9.5, Tableau 10.2

Operating Environment

MS Windows NT/2000/2003/XP, Unix 9.0, Linux, AWS

Languages

SQL, PL/SQL, Python, UNIX shell scripting, Java Script, CSS, HTML.

Databases

Oracle, SQL Server, PostgreSQL, DB2.

Certifications

Basics of Banking – IIBF, Credit Card Operations – IIBF, Python

With Data Analysis – Berkley Extension (2017)

Education Details:

Bachelor of Engineering from National Institute of Technology Karnataka, First class with distinction in Information Technology in year 2004.

Professional Experience:

Client: Cisco Systems, San Jose CA Dec 2013 – Till Date

Project Description Within Cisco, Lifecycle Services Business Intelligence team provides analytic support for all the programs driven by the Lifecycle Services Organization. The BI Team maintains the Lifecycle Services Dashboard, a single point of service for data related to Service Compliance – RMA and TAC Data, Delivery Quality, User to Contract associations, LDoS, Entitlement keys and more.

Roles & Responsibilities:

Interact with business users to gather Business requirements and then converting those requirements into technical specifications.

Prepare Requirement, Design Test Case Documents and various dashboard mock ups.

Involved in performance testing of the mappings and optimizing them.

Installing, Configuration and maintenance of OBIEE 11g on different Windows servers.

Creation of repository/reports/dashboards, testing the components and then finally deploying it into Production environment.

Created/Upgraded the backend repository, front-end reports, dashboards and all other associated components from OBIEE 10g to OBIEE 11g single handedly.

Performance tuning of the reports using Indexes, Database Partions, Aggregate tables, Cache Management.

Writing complex SQL queries for data analysis.

Security Management- Data level and Object level for the dashboards/reports.

Involved in creating different mapping for dimensions and fact tables in ETL using SSIS.

Developed stored procedures, functions and triggers involving complex business logic.

Used Python scripts to fetch the data thru Kafka Consumer into SQL Server and then published dashboard in OBIEE.

Generated few interactive Reports/Dashboards using Tableau 10.2 for RMA and TAC Compliance/Asset Management/CEEM Exceptions.

Worked on Hive to support the database migration from Oracle to Hadoop. Created Hive Scripts.

Tools Used: OBIEE 11.1.1.7.0, SQL Server 2012, SSIS, Tableau 10.2

Client: Amazon, Seattle US July 2012- Nov 2013

Project Description The goal of AWS Business Intelligence (BI) Web Analytics platform is to provide an end-to-end integrated view of converting AWS prospects into customers. The use of web traffic tracking tool, an enterprise data warehouse (EDW) and robust BI platforms will improve sales and marketing team efficiencies. AWS BI platform requires data from essential AWS source systems like Salesforce.com, Billing, Usage, Web Analytics (Adobe SiteCatalyst), and Oracle eBS.

Roles & Responsibilities:

Interact with business users to gather Business requirements.

Prepare Requirement, Design Test Case Documents and various dashboard mock ups.

Created Mapping document between Adobe Site Catalyst tool and EDW fields.

Involved in developing various Mappings with multiple Sources, targets, Transformations using Power Center Designer.

Writing complex SQL queries for data analysis, providing reports to the users.

Generated tableau dashboards for sales with forecast and reference lines.

Creating/maintaining various OBIEE reports/dashboards.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Created Users Traffic dashboards in Tableau.

Tools Used: OBIEE 11.1.1.6.0, Oracle 11g, Informatica 9.1, Python, SQL Developer, Tableau 10.2

Client: CSC Dallas, US Oct 2007 – Apr 2012

Project Description Celeriti project is a part of CSC Global initiative to increase its business world-wide. The project is to modernize the banking solutions from legacy Mainframe systems into GUI enriched BI environment

Roles & Responsibilities:

Played a role of onsite coordinator and handled the coordination between onsite and

Offshore team.

Interact with business users to gather Business requirements.

Created Mapping document between legacy systems and ETL fields.

Prepare Requirement, Design Test Case Documents and various dashboard mock ups.

Created Mapping document between Adobe Site Catalyst tool and EDW fields.

Involved in the development of ETL mappings, sessions and workflows according to

Client’s requirement.

Writing complex SQL queries, stored procedures to provide business data.

Configuring Financial modules – AR, GL in OBIA.

Design OBIEE Web Components including OBIEE Answers and Intelligence

Dashboards.

Monitor data loads jobs and resolve the issues in data failures.

Tools Used: OBIEE 10.1.3.4.2, Informatica 9.1.1, Oracle 11i/10g, IBM Mainframes, DB2, SQL.

Project: CAMS II Support CSC India Sept 2004 – Oct 2007

Project Description: This includes working on CAMS II legacy system to support banking modules – Credit Cards, Debit Cards.

Role / Responsibilities:

Requirement gathering in the form of FSDs

Design in the form of CSDs.

Design COBOL scripts and Modules based on the project requirements

Tools Used: IBM Mainframes, IBM 3090, COBOL, JCL, SQL, VSAM, DB2, UMBRELLA, OS/390, Librarian, File Aid, Expediter.



Contact this candidate