We provide IT Staff Augmentation Services!

Data Warehouse Specialist Resume

2.00/5 (Submit Your Rating)
Hire Now

OBJECTIVE
Seeking the opportunity to be employed in an organization as a Java Developer. I have the skills and experiences to further improve the efficiency, accuracy, and delivery of the Information Technology Department.
SKILLS SUMMARY

  • Knowledge of Java including J2EE framework, Spring, Swing and EJB
  • Object Oriented Programming
  • Programmed with C++ using Borland
  • Programmed with C using Borland
  • Data Structures in C with pointers and arrays
  • Knowledge of Polymorphism and inheritance
  • Extensively worked using C# and ASP on the .Net platform.
  • Strong experience in system, design, analysis, implementation, testing, development, and maintenance of business applications using N-tier architecture with C#.NET, ASP.NET, Web Forms, VB.NET, Web Services, Win Forms, .Net 1.1/2.0/3.0/3.5/4.0 framework and Crystal Reports, Ajax Control Tool kit, ASP.Net Ajax.
  • Through understanding of ORM, OOPS and RDBMS principles.
  • Possessing excellent creative, analytical, problem solving skills.
  • Ability to meet demanding schedules and various work/process environments.
  • Ability to work closely with team members and understand client requirements.

PROFESSIONAL EXPERIENCE
Data Warehouse Specialist/Developer, Mar 2010 - Present
Confidential,

  • Optimize and maintain Customer Data Mart that keeps track of customers\' \'topup\' and handset behavior for different markets
  • Worked with DBAs, and Systems Support personnel in migrating from Oracle 10g on Solaris to Oracle Exadata on Linux server successfully
  • Develop UNIX shell scripts that extract, transform and load data from flat files to Oracle database with the aid of awk programs, SQLLDR and external tables
  • Developed Oracle packages, procedures, Data Integrator and Informatica Analyzer/Data Flow processes to extract data from various sources such as SQL Server and Oracle
  • Conducted extensive documentation of standards, best practices, and ETL procedures and data feeds
  • Reconciled data between source and staging to validate and verify the accuracy of ETL process
  • Install and configure SAS on multiple machines
  • Played role in the re-design of scalable, reusable, and low maintenance ETL templates by creating a central repository for Oracle and Data Integrator Jobs

Web Development, Summer 2011
Confidential,

  • Design and implement an Online Counseling website which allows for the interaction between patience and healthcare personnel in an anonymous and confidential manner.
  • Responsibilities:
  • • Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.
  • • Implemented user interface using HTML, CSS,AJAX and JavaScript
  • • Written stored procedures, triggers, Routines, PL/SQL Packages using SQL in MSSQL 2008, and MySQL SERVER version 5.6.2 and Oracle 10g and 11g.
  • • Create, Retrieve, Update, and Delete (CRUD) data using ADO.NET and OMR (LINQ) from various data source (MySQL and MSSQL).
  • • Used AJAX to trade data with a web server, without reloading the page.
  • • Developed Web Services retrieving dataset in XML format.
  • • Performed the initial unit testing during the development of code and functional testing of the business logic.
  • • Ensured Security to all the portals by using Tampered proofed URLs, Security Trimming, user authentication and authorization with the aid of Microsoft Membership Provider.
  • • Wrote triggers for sending Emails after to clients after a reply to question by admin has been made.
  • • Used Validation Controls in ASP.NET for validating Front-end form.

Confidential, (North Carolina-USA), Summer 2009

  • Help in the Development and maintenance of an online ecommerce website

TECHNICAL SKILLS

  • Languages - Basic, Prolog, CLIPS, C, C++, JavaScript, Pascal, Java, Visual Basic VBScript, ASP.NET, C#.NET, C++.NET, PHP, HTML, XHTML, HTML5, XML, ActionScript 3.0, Unix Shell script, SAP, AJAX, Silverlight
  • ETL - Data Integrator, Informatica
  • OS - Windows NT/2000/XP/Windows 7, Sun Solaris, UNIX/LINUX
  • Tools - Informatica, Data Integrator, SAS, Business Objects ,Toad for SQL Server, Toad for Oracle, Toad for MySQL, .NET Standard and Compact Framework (1.0, 1.1, 2.0, 3.0, 3.5, 4.0), Eclipse, Smart Draw, Adobe (Photoshop, Flash), Crystal Reports, Microsoft SQL Server (2000, 2005, 2008), Microsoft Visual Studio(2003, 2005, 2008, 2010), MySQL Server (5.0, 5.1, 5.5, 5.6), Oracle (10g, 11g), J2EE, Java SE 7, Netbeans, Zend Studio
  • Databases/RDBMS - Oracle, MySQL, MSSQL, Microsoft Access, PLSQL, Transact SQL, MySQL Routines

EDUCATION

  • B.Sc. Computer and Information Technology

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship