SUMMARY:

• Graduate student in Computer Science with 5 years of experience in various databases like ORACLE, SQL SERVER, DB2, TERADATA.
• 2.5 years of IT experiencein analysis, design, development and testing of user interface, software and web applications.
• Certified by Oracle SQL, PL/SQL and Base SAS.
• 2 years of experience in Business Intelligence Domain working on various phases of data warehouse cycle like Dimensional Modeling, Data Quality, ETL and Reporting.
• 2 years of experience in developing and implementing various mappings in Informatica.
• Have a good experience working on Powercenter
• Hands on experience in relational database design, relational integrity constraints, OLAP, OLTP and normalization.
• Good SQL and T-SQL experience especially in writing PL/SQL Procedures, Functions, Triggers, Indexes and Packages.
• Well versed with UNIX shell scripting.
• Developed several reports using Cognos reporting tool.
• Worked on Oracle Data warehouse Console (DAC).
• Worked on several query processing tools like TOAD, SQL * Plus, SQL Developer, Teradata SQL Assistant.
• Know how in open source cloud computing on Hadoop mapreduce concept and Datameer.
• Developed a web application using PHP and MySQL.
• Have a good experience in various kinds of testing and Data Validation.
• Have a good understanding on all stages of software development life cycle (SDLC).

EDUCATION:

Masters in Computer science

Bachelor of Technology in Computer Science & Engineering
Course Work
DBMS, Algorithms and Data structures, Software Engineering, Web Technologies,
UNIX Programming, Computer Networks, Management Information Systems,
Data warehousing and Data Mining, Object Oriented Analysis and Design, Programming Languages

TECHNICAL SKILLS:

• Languages : C, C++, Java, SQL, PL/SQL, SAS
• Databases : My SQL,MS-Access, DB2,Oracle(9i,10g,11i),Teradata,MS SQL Server
• Web skills : HTML, Java Script, PHP, Ext Designer, Dreamweaver
• ETL Tools : Informatica, Ab-initio
• Reporting Tools : Cognos, Business Objects, Oracle Business Intelligence

PROFESSIONAL EXPERIENCE:

Project: Enterprise Data warehouse
Role: ETL Developer
Environment: Oracle (10g, 11i), Microsoft SQL server, Teradata, Informatica 9.1.0, Powercenter,Oracle Business Intelligence Enterprise Edition, SQL Developer, Linux OS, Unix shell scripting
Description: Enterprise Data warehouse team is responsible for building a data warehouse and creating dashboards for helping the users to analyze and make decisions. In this project the source systems are Oracle 10g, Oracle 11i, Microsoft SQL server and salesforce data and the target database is Teradata.
Responsibilities:

• Worked as a Data warehouse team member
• Worked on Informatica Powercenter
• Developed Informatica mappings on source systems as SQL Server, Oracle, Salesforce and Target Database as Teradata
• Created Mapping Documents for the Informatica Mappings
• Developed several SQL queries for Unit Testing
• Worked on Data Warehouse Administration Console (DAC) for monitoring the Oracle Business Analytics Warehouse
• Developed complex SQL queries on the backend for Interactive Dashboards in Oracle Business Intelligence Enterprise Edition
• Supported in various areas like Finance, Sales and Billing etc...
• Gained Good Knowledge in Hadoop MapReduce concept and Netezza

Confidential, King of Prussia Mar 2011 - May 2011

Project: Building reoprts for Travel agency
Role: SQL Developer
Environment: PHP, MySQL, MAMP Server, Apache Tomcat, PHPMyadmin
Description: The project is to build WebPages for a travel agency called Bell Travels. Besides developing front end have to maintain the whole database.
Responsibilities:

• Developed an administrator website for a client called Bell travels, Bangkok
• Worked on HTML,PHP and MYSQL using a MAMP server
• Developed Complex SQL Queries on the back end for generating user reports

Confidential, Pune, India Sep 2008 - Jun 2009

• Worked in the domain of Business Intelligence on various ETL and Reporting Tools.
• Participated in Fresher Learning Program on UNIX, RDBMS, SQL, PL/SQL, SQL Loader, ETL Concepts, Informatica 8.5.1, Powercenter, Cognos, SAS 9.1, and Testing.

Project: Branch Banking and Trust(BB & T)
Role: ETL Developer
Environment: SAS, Informatica , DB2, TOAD, Cognos, Oracle, UNIX, Windows, Microsoft Office.
Description: The project's aim is to migrate history SAS data sets to DB2 based credit risk mart and then applying all the business logics or rules using various transformations in Informatica 8.5.1.

Responsibilities:

• Developed several Informatica Mappings according the business requirements.
• Did unit testing by developing complex SQL queries and comparing the source and Target data.
• Developed SAS procedures.
• Created the mapping documents for the ETL process.
• Developed reports using Cognos.

Project #2: Insurance Analytics Service
Role: ETL Developer
Environment: SAS, Informatica , Oracle, SQL.PL/SQL, Cognos, UNIX, Windows, Microsoft Office.
Description: This is done as a complete Data warehouse implementation in three phases Data Quality, ETL and Reporting. Done as a part of Fresher learning Program. The source data will come from .CSV files and then they are imported into SAS datasets where the Data Quality checks are done using SAS Procedures. The ETL phase is done using both Informatica and PL/SQL procedures. Then the reporting is done using cognos.
Responsibilities:

• Developed the Data model analyzing the raw data and the user requirements.
• Developed SAS procedures for Data Quality.
• Developed PL/SQL procedures to implement Slowly Changing Dimension type1 (SCD1) and Slowly Changing Dimension type2 (SCD2).
• Implemented the SCD's using lookup transformation in Informatica.
• Did unit testing by developing complex SQL queries and comparing the source and Target data.
• Created the mapping documents for the ETL process.
• Developed reports using Cognos.

Project #3: New Order MIS
Role: SQL Developer
Environment: SQL Loader, Oracle, SQL, PL/SQL, UNIX, Windows, Microsoft Office.
Description: The purpose of this project is to create a secondary stand alone "New Orders Database" for North windTraders on a remote location to enable reporting and decision support. This is also done as a part of Fresher learning Program to get a better understanding of ETL process.
Responsibilities:

• Developed the Data model analyzing the raw data and the user requirements.
• Used SQL Loader to load data from excel sheets and CSV files into Oracle.
• Developed PL/SQL procedures to implement ETL process.
• Did unit testing by developing complex SQL queries and comparing the source and Target data.
• Created the mapping documents for the ETL process.
• Automated the entire system by writing Unix Shell scripts.

Department of Computer Science, Villanova University Aug 2010 - Jan 2011

Role: Graduate Assistant
Responsibilities:

• Worked as teaching assistant for the Programming Languages.
• Held the responsibilities of teaching, grading, and helping the students in their course work and their projects.

Confidential, Villanova University Nov 2009 - Aug 2010

Role: Assistant System Administrator
Environment: Microsoft SQL Server, MS Access, UNIX, Symantec Ghost, Windows, Shell Scripting.
Responsibilities:

• Helped in maintaining the library database.
• Worked on Microsoft SQL Server.
• Developed Complex SQL Queries for generating reports for Library staff.
• Did the role of an Administrator by granting permissions to users and by maintaining the Library Database
• Installed various software on library computers and maintaining those machines

ACADEMIC PROJECTS:

Super Market Database System:
Built an efficient database system for supermarket maintenance using Java and Oracle

• Collected business requirements and designed ER diagrams
• Implemented the Database with relevant SQL queries and PL/SQL Procedures
• Developed GUI in Java

Digital Library for Villanova University Events:
Worked on DSPACE project, where we build a digital library for a collection of photographs

• Collected Various Photographs of the events in the University
• Developed a front end for the Digital Library using DSPACE

ACHIEVEMENTS:

• Best learner award during the Fresher Learning Program in CAPGEMINI
• Best programmer award in C language during under graduation
• Captain of computer science cricket team in under graduation
• Elected as Vice-President for Villanova Indian Students Association
• Captain of Villanova Cricket Club from past One year