SUMMARY:

• Motivated with sound technical knowledge - drives projects/deliverables from inception to implementation.
• Excellent communication and inter-personal skills - works with all groups and stakeholders effectively.
• Consistent meticulous planning - manages and measures risks, schedules (EPI/SPI), defects, budgets, and SLAs effectively. Cost, Speed and Efficiency are the top priorities.
• Self directed and Self driven Architect - scalability, reliability and measurability are the most important goals.
• Leader and Individual contributor - mentor juniors, leads them to make them a catalyst for future.

TECHNICAL SKILLS:

Database: Oracle 12c/11g, SAP HANA, Teradata V2R6, DB2, MS SQL Server.

OLAP Tools: OBIEE, SAP Business Objects, Microstrategy, Tableau.

ELT Tools: Informatica 9 PC, Oracle SQL*Loader.

Data Modeling: ERWin 7.x, S-Designer and Oracle Designer 2000.

Hardware:: HP 9000, NCR 5400, RS 6000, ProLiant, Intergraph TD-3, Sun 6800.

OS Environment: Windows Servers, Sun Solaris 5.10, HP UNIX 11.x, IBM AIX 6.x, Linux 9.2

Office Tools: MS Project, MS PowerPoint, MS Word, MS Excel and Microsoft IIS.

Others: Hadoop, MongoDB, Cassandra, Python,Spark, Tomcat, AWS and XML.

Industry: Banking, Finance, Logistics Services, Pharmaceutical,Telecommunication, HR.

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh NC

Associate Partner, Solution Architect

• Develop Informatica mappings with performance, accuracy and efficiency in mind.
• Develop Reports & Dashboards using Hadoop and Tableau for HIPAA projects.
• Design analytical queries for aggregation mappings and Reports/Dashboards in OBIEE presentation Layer.
• Design SDE, SIL mappings and processing strategy in Informatica and Oracle Fusion Middleware OBIA.
• Deploy physical model in the database by creating and maintaining Oracle objects like tables, materialized views, Indexes, triggers, partition tables and stored procedures.
• Project consisted 2000 Informatica mappings transformations and 1200 workflows and 300 OBIEE Reports.
• Install, Administer RAC, DataGuard,Monitor and upgrade Informatica 8.6.1/9.x using LDAP authentication.
• Coordinate with DBA's for Oracle SQL Tuning and Oracle 10g database upgrade testing.

Programming Environment: Oracle 12c, Informatica 9, OBIEE 10.1.3.3, Business Objects, SAP Netweaver, SAP HANA, Oracle Fusion Middleware 11g, Hadoop, HBase, Hive, Tableau, Oracle GoldenGate, ERWin7, Perl, XML, AIX unix.

Confidential, Raleigh NC

Software Engineer

• Developed ETL process design, error handling process design, development and implementation.
• Developed robust mappings transformations and workflows with built in reconciliation and error handling.
• Develop Informatica mappings with performance, accuracy and efficiency in mind.
• Install, Administer and upgrade Oracle 10g/9i database on UNIX.
• Delivered Logical and Physical model - Used Relational modeling to develop dimensional model.
• Implemented scripts for database security, general administration and tune application using TKPROF utility.

Programming Environment: Oracle 10G, Oracle 9i, Informatica 8.1/7, ERWin7, Perl, XML, AIX Unix.

Confidential, Raleigh NC

Datawarehouse ETL Consultant

• Responsible for resource allocation, object sizing, user administration and performance tuning of database. (Production datawarehouse 150 TeraBytes, 40,000+ entities and 50,000+ users).
• Developed ETL process design, error handling process design, development and implementation.
• Developed ETL process and utilize Teradata BTEQ, SQL Assistant, fastexport, Tpump, fastload and multiload.
• Developed robust mappings transformations and workflows with built in reconciliation and error handling.
• Develop Informatica mappings with performance, accuracy and efficiency in mind.
• Deployed Informatica MetadataExchange for migrating source and targets in Informatica.
• Install and develop metadata dashboard and reports in Informatica Power Analyzer 5.0.2.
• Install and Administer Informatica 8.1/7.1 and create Oracle 10g/9i database on UNIX.

Programming Environment: Oracle 10G, Oracle 9i, Informatica 8.1/7, Metadata Exchange, Teradata V2R6, ERWin7, Microstrategy 7.1, Perl, XML, Sun Solaris 5.9, Windows XP, JavaScript, J2EE, Interdev 6, NCR 5400 server, Sun 6800 server.

Confidential, Atlanta, Georgia

Sr. Oracle Database Administrator / Developer

• Primary DBA responsible for resource allocation, object sizing, user administration and performance tuning of large production databases (550 GB, 1200+ entities and 9000 users).
• Create and manage advanced Multi-Master Replication "asynchronous" to 3 sites for the client.
• Configure RMAN for Hot Backup and recovery processes in clustered RAC environment. d esign realignment PL/SQL module used for transferring data from one laptop to another.
• Developed global functions, packages and PL/SQL procedures for business requirements.
• Install and create Oracle 8i/9i database on Windows NT and Unix, configure LDAP and apply upgrade/patches.
• Delivered Logical and Physical model - Used snowflake schema design to develop a dimensional model.
• Understanding of client/server architecture with knowledge of Siebel eBusiness architecture and applications.

Programming Environment: Oracle 9i/8.1.7 & 9iAS, Oracle Portal, J2EE, Perl, XML, Windows NT/2000, Siebel 7.0, Microsoft IIS, Veritas, Legato, HP Unix 11.0, DEC Unix 4.X, Sun Solaris, Linux, AIX Unix 4.X, ERWin 3.5, JavaScript, Interdev 6, DreamWeaver, DataStage, Brio, RS6000 server, Sun 3000/4000, Compaq ProLiant server, HP 9000.