Dhilip Ramesh

*** ******** ****, **********, ** - 29607

704-***-****, acrx78@r.postjobfree.com

OBJECTIVE:

To secure a challenging position in a well-established organization where I can maximize my skills and experience. EDUCATION:

Master of Science, Information Technology, University of North Carolina, Charlotte Dec 2014 Bachelor of Engineering, Computer Science and Engineering, Anna University, India May 2011 WORK EXPERIENCE:

Business Intelligence Developer, AFL, Greenville, SC Feb 2015- Present

Designed a star schema based on user requirements to house data related to all Informatica tasks to read their performance.

Built "Informatica Monitor" data-mart using OBIEE and pulled data from the existing Data warehouse Admin Console (DAC) repository.

Built analyses using the OBIEE reports to monitor the performance of the Informatica jobs.

Currently working on a project to detect the hardware issues responsible for slowing the jobs by designing a schema using the OS/Hardware logs generated.

Business Intelligence Developer Intern, AFL, Greenville, SC Oct 2014- Dec 2014

Built data warehouse/data-mart to report data from the DAC (Data warehouse Admin Console) repository.

Researched on existing data and its structure, various SQL/PL-SQL queries and joins used for populating the database.

Used Informatica for data migration, created mapping, scheduled the mappings for data load and transfer.

Reported data using OBIEE tool, built dashboards/ reports on repository data.

Business Intelligence Analyst Intern, AFL, Greenville, SC May 2014- August 2014

Collected, consolidated and analyzed data from business users.

Created analysis, published reports and created Dashboards using OBIEE.

Created a BI Intranet page for the organization and uploaded my own training materials.

Coordinated with top management in understanding different process plans, business process, and functionality in depth. Conducted Training sessions and seminars for new resources.

Worked as a single resource on critical analysis/reports creation to calculate sales, revenue, performance, employee contribution etc.

Business Intelligence Developer, Mahindra Satyam, Hyderabad, India July 2011- July 2013

Trained on Oracle 10g, Teradata 12, Statistical Analysis System 9 and UNIX operating system.

Worked with CISCO client on an Enterprise Data warehousing project to migrate Webex communicator user data from Oracle database to Teradata using Informatica 9.1 (ETL tool).

Analyzed user data for the migration and designed Informatica mappings for the process, structuring the queries for fetching data, creation of tables to house the data.

Engineered a complete module for reducing the number of hops in existing mappings which included analysis,

restructuring the hops, scheduling using Dollar Universe (scheduling tool).

Helped in completing the project within the structured budget and reduced the time taken to complete it. SKILLS:

Programming Languages : C/C++, Java

Web Technologies and Scripting Languages : HTML, CSS, XML

Database Management System : PL/SQL, Oracle 11g, Teradata 12

Platforms : Windows, Unix MS Office (Excel, Access, SharePoint, Visio)

Tools : SAS 9 and Informatica 9.1, Rational Rose, Tableau 8.1, OBIEE PROJECTS:

Online Book stores Data warehouse (Advanced Databases) Spring2013 A real-time implementation of an online book store data warehouse. Modelled the data-warehouse, created tables

(dimension and facts), loaded data and generated reports for analysis.

Contact this candidate