Data Analytics Resume CA - Hire IT People

SUMMARY:

Seeking a role where I can expand upon my strong Oracle and PL/SQL database, BI and Informatica development experience.
Sound knowledge in Oracle 12c,11g,10g, 9i, Informatica Power center 9.1, Power BI, Tableau 8.3.
Having 7 years of experience in Oracle Developer.
Extensive work knowledge in DDL, T - SQL, PL/SQL, Stored procedures, Triggers, Functions, views and packages.
Experience in creating mapping, transformation and performance tuning (Informatica).
Extensive work experience in health care domain and banking sector.
Experience of managing data migration projects, Deployment and Production support activities with RCA.
Sound technical knowledge in Informatica data quality, ETL (Extract Transform Load), creating dashboard in tableau with MYSQL server.
Extensive knowledge and experience in dealing with Relational Database Management Systems, including normalization, constraints, querying, joins, keys, indexes, data import/export.
Resourceful in the completion of projects and effective at multitasking.
Experience in data mapping, performance tuning.

TECHNICAL SKILLS:

Skills: Spreadsheet Management, Time Management, Ordering Process, Customer service Oriented

Programming Languages: MySQL, XML, Oracle 11g,12c,9i, UNIX, J2EE, LINUX shell scripting

Business Intelligence tools: Tableau, Business Intelligence Development Studio (SSIS/SSRS), Informatica Power Center 7.1/8.6/9.1.

Data Base: Server 2000/2005/2008/2008 R2/2012, MS Access

Operating Systems: XP, Windows NT / 2000. Windows Server 2003/2008/2008 R2, Linux

Reporting Tools: Power BI, Tableau 9.x, Excel, Qlik view, Crystal Reports

Scripting language: JavaScript, HTML, CSS

PROFESSIONAL EXPERIENCE:

Confidential

Data Analytics

Responsibilities:

Objective of the project is to collect the Alumni details of Confidential International graduates from various sources that includes International department, social networking sites (Gmail, Facebook, Instagram), and LinkedIn.
Converted raw data into Table format for accuracy.
Wrote Queries to filter the data’s and for creating the unique column.
Performed Query Optimization on each level to correlate with the requirement
The collected information is then shortlisted based on their academic background and send for data Cleansing, data parsing.
Worked on transformations in the Power BI query editor.
Loaded data to Power BI to represent the final output and created dashboards.
Created stored procedures and SQL queries to pull data into Power BI.
Created measures and counts based on the column name.
The data then is loaded to Power BI to represent the final output in the form of dashboards to the Reporting manager and other Business Development board people.

Environment: MYSQL, Power BI, SQL SERVER 2008, Windows 10, MS Excel.

Confidential, CA

PL/SQL Developer

Responsibilities:

Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Data manipulation, Functions, Triggers, Cursors using Oracle 11g.
Used SQL*Loaders to download the data into warehouse database from the flat files and other data files across different platforms.
Performance tuning was done at the functional level and map level in Informatica. Used relational SQL wherever possible to minimize the data transfer over the network.
Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
Created Tables, Views, Materialized views, and constraints.
Create Oracle Stored Procedures to implement the ETL Process control logic.
Created Oracle Stored Procedures for Segment Dimension which holds all the dimension keys.
Designed Oracle views that generate these extracts for upstream applications and created ETLs to read these views and drop them in a file.
Documented all the ETL and Oracle Procedures developed.
Designed and developed the Forms and Reports for the user Interface.

Environment: Oracle Database 11g, Windows XP, UNIX, Informatica 9.1, Tableau.

Confidential

Oracle Developer

Responsibilities:

Performed Database Design and Analysis.
Design and Developed data validation, load processes using Stored Procedures, Functions, and Triggers using Oracle 11g.
Formulated general methodologies, naming conventions and coding standards for various procedures and packages.
Performed performance tuning, Debugging, troubleshooting and query tuning.
Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
Developed complex triggers in reports before/after for validation of user input.
Coordinated between management, users and technical teams for Requirement Gathering.

Environment: Toad Oracle, Excel, MS SQL Server 2005, UNIX, LINUX