SUMMARY

• Over 9 years of IT experience with more than 8 years of experience in Design, Development, Implementation and Support of applications and systems as Architect/ Database/ETL Developer.
• Engineering/Technology Leader with extensive experience defining, delivering and supporting complex engineering solutions.
• Profound experience with various databases like Oracle, SQL server, Sybase, DB2, Data warehouse Appliance Netezza.
• Over 5+ years using Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin.
• Strong in Database Design, Creation, Migration, Upgrading, Performance Tuning, Logical and Physical Design,Database Tuning, Installation and Upgrade of Database, as well as managing teh Object and System Privileges.
• Experience working in different development methodologies including Agile, Test Driven and global delivery model.
• Excellent communication, interpersonal skills and a team-worker with good customer interaction.

TECHNICAL SKILLS

Platforms: Windows 2003 Server, UNIX, Red Hat Enterprise Linux, Fedora, Sun Solaris 2.7/2.6,HP-UX 10.20/9.0, IBM AIX 4.3/4.2, MS-DOS 6.22, Novell Netware 4.11/3.61, Win 98/95/3.x, Win NT 4.0

ETL/ Reporting Tools: Informatica Power Center 9.5/ 9.1/8.1/7.1/6.2/5.1/4.7 , Power Mart 5.1/4.7, SQL*Plus, SQL* Loader, Business Objects XI/ 6.5.1/6.0/5.1

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema, Snow-Flake Schema, FACT and Dimension Tables, Physical and Logical Data Modeling, ERWIN 4.2/3.5.2/3. x, ER Studio Data Architect 9.1

Databases: Oracle 11g/10g/9i/8i/8.0/7.0, MS SQL Server 2008/2005/2000/7.0/6.5/8.0, MS Access 2003/2000/97, DB2 8.0/7.0, Confidential 3.03,, Sybase Power Designer 12.0

Languages: .Net (C#, Vb.Net and Asp.Net), C, C++, Visual Basic 6.0, PL/SQL, SQL, SQL*Plus, Transact SQL, HTML, DHTML, Unix Shell Scripting

Web Technologies: Java, JSP, ASP, XML, VBScript

Servers: IIS 6.0, Apache, Tomcat

Others: Visio Data modeling, TOAD, SQL Navigator, PVCS/CVS, Autosys, Control-M, Visual Source Safe, ClearCase,ClearQuest,Embarcadero Rapid SQL, Maven, Junit, SVN

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Reports Developer

Responsibilities:

• Analyzed Test Cases and Test Plans. Involved in Unit, System testing and User Acceptance testing.
• Extensively involved with Production support team in various performances related issues.
• Extensively involved in fixing production bugs.

Environment: Informatica Power Center 9.1/8.1, SVN, SQL Server 2008/2012, Windows 7, Oracle 10g,Business Objects XI,Unix (ksh) Shell, Control-M, .NET 4.5, BPM, MicroStrategy

Confidential, Billerica, MA

Sr. Architect

Responsibilities:

• Extensively involved in teh Design and Development of projects.
• Gatheird teh requirements from teh Business and did analysis based on all teh requirements.
• Extensively worked in teh performance tuning of ETL processes and SQL.
• Developed mapping parameters and variables to support incremental loads on teh target database.
• Developed UNIX scripts for scheduling teh jobs, cleanup of log files.
• Modified existing BOXI universe and reports based on teh business requirements for teh end user.

Environment: Informatica Power Center 9.5/9.0.1,SVN, Windows XP, Oracle 11g,Business Objects XI,Unix (ksh) Shell, SAP Business Object Data Services 4.0, ER Studio Data Architect 9.1

Confidential, Boston, MA

Sr. Reports Developer

Responsibilities:

• Involved in teh Design and Development of teh projects.
• Gatheird teh requirements from teh Business and did an Analysis based on all teh requirements.
• Analyzed Test Cases and Test Plans. Involved in Unit, System testing and User Acceptance testing.
• Tested teh data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Created complex stored procedures and views to handle teh business logic.
• Created BOXI universe and reports based on teh business requirements for teh end user.

Environment: Informatica Power Center 9.1/8.1, Clearcase, Sybase, SQL Server 2008/2005, Windows XP, Findur 9.1/8.1 AVS Scripting, Oracle 10g,Business Objects XI,Unix (ksh) Shell, Control-M, Access 2003, .NET 4.5, BPM

Confidential

Sr. DATABASE/INFORMATICA DEVELOPER

Responsibilities:

• Collection of requirements from business users and analyzed based on teh requirements.
• Identify source systems, connectivity, tables, and fields ensure data suitability for mapping.
• Developed and documented Data Mappings/Transformations and Informatica sessions as per teh business requirement.
• Extensively worked in teh performance tuning of programs, ETL procedures and processes.
• Error checking and testing of teh ETL procedures and programs using Informatica session log.
• Designed and developed Oracle PL/SQL Procedures.
• Involved in fixing invalid Mappings, Unit and Integration Testing of Informatica Sessions, Batches and teh Target Data.

Environment: Informatica Power Center 8.11, Oracle 9i, Flat files, PL/SQL, SQL, Toad 9.0, Windows 2000

Confidential, Boston, MA

Sr. ORACLE AND INFORMATICA DEVELOPER

Responsibilities:

• Involved in teh Design and Development of teh projects.
• Used advanced techniques of Informatica to load data from flat files into teh target Oracle database.
• Developed mapping parameters and variables to support connection for teh target database as Oracle and source database as Oracle.
• Created different Oracle packages and ran them using Unix korn shell scripting.
• Optimized/Tuned all teh oracle stored procedures for better performance and efficiency.
• Scheduled all teh process of running teh aggregates using Control-M.

Environment: Informatica Power Center 7.1.2, Control-M, Oracle 9i, Flat files, PL/SQL, SQL, Toad 9.0, Windows 2000, HP-UX 11.x, Unix (ksh) Shell, Sybase Power Designer, Visual Source Safe

Confidential, Boston, MA

Sr. INFORMATICA DEVELOPER

Responsibilities:

• Business Analysis and Requirements Gathering.
• Did teh installation of informatica 7.1.4 on windows client and migrated teh repository from informatica 6.2.2 to informatica 7.1.4.
• Used Informatica Power Connect for Confidential to pull data from Confidential data warehouse.
• Migrated all teh views in sql server to teh Confidential warehouse. Tuned teh views to get better performance.
• Developed mapping parameters and variables to support connection for teh target database as Confidential and source database as Oracle OLTP database.

Environment: Informatica Power Center 7.1.4/6.2.2, Netezza, Oracle 8i/9i, MS SQL Server7/2000, Flat files, PL/SQL, SQL, Toad 7.0, Win-SQL, Windows 2000, HP-UX 11.x Unix (ksh) Shell.

Confidential

ETL/Datawarehouse Developer

Responsibilities:

• Project deals with teh Circuit City credit cards.
• Data warehouse is built to decide whether teh credit cards have to be given to teh applicants.
• Reports are generated based on teh credit bureau scores and on teh applicant’s background.

Environment: Informatica Power Center 7.1, Informatica Power Mart 5.x, Oracle 9i, UNIX, Windows NT, ERWIN 4.2, PL/SQL, Shell Programming, SQL * Loader, TOAD, Unix Scripting.