SUMMARY

• ConspectusOver 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 the 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, Netezza 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, TomcatOthers: 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 the Design and Development of projects.
• Gathered the requirements from the Business and did analysis based on all the requirements.
• Extensively worked in the performance tuning of ETL processes and SQL.
• Developed mapping parameters and variables to support incremental loads on the target database.
• Developed UNIX scripts for scheduling the jobs, cleanup of log files.
• Modified existing BOXI universe and reports based on the business requirements for the 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 the Design and Development of the projects.
• Gathered the requirements from the Business and did an Analysis based on all the requirements.
• Analyzed Test Cases and Test Plans. Involved in Unit, System testing and User Acceptance testing.
• Tested the 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 the business logic.
• Created BOXI universe and reports based on the business requirements for the 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 the requirements.
• Identify source systems, connectivity, tables, and fields ensure data suitability for mapping.
• Developed and documented Data Mappings/Transformations and Informatica sessions as per the business requirement.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Error checking and testing of the 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 the 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 the Design and Development of the projects.
• Used advanced techniques of Informatica to load data from flat files into the target Oracle database.
• Developed mapping parameters and variables to support connection for the target database as Oracle and source database as Oracle.
• Created different Oracle packages and ran them using Unix korn shell scripting.
• Optimized/Tuned all the oracle stored procedures for better performance and efficiency.
• Scheduled all the process of running the 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 the installation of informatica 7.1.4 on windows client and migrated the repository from informatica 6.2.2 to informatica 7.1.4.
• Used Informatica Power Connect for Netezza to pull data from Netezza data warehouse.
• Migrated all the views in sql server to the Netezza warehouse. Tuned the views to get better performance.
• Developed mapping parameters and variables to support connection for the target database as Netezza 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.