SUMMARY

• Worked as an Enterprise Data Architect with over 15+ years of hands on experience in Data Management System, project, product and team management Diverse background in technical and managerial areas with expertise including software development, product strategy, portals and information security in the domain areas of Healthcare Insurance, Financial, Pharmaceuticals, Shipping and others.
• Experience in system/Data architecture, Application Architecture, Business & Technology transformation, SDLC, Waterfall & Agile Methodologies.
• Extensive experience in information technology with specialization in data management and data architecture
• Proficient with database architecture tools and programs
• Understand the value of architectural design and the standards of best practice
• Expert in data analysis, migration, modeling, integration and data warehousing concepts and application
• Ability to translate and present the ideas into design and implementation
• Work in a team environment and potential of providing individual effort
• Hands on experience in activities including Logical and physical database design, Data Modeling, Metadata Management, Data mapping, Process flow diagram, performance tuning and software development activities
• Highly skilled in all facets of IT delivery from application strategy formulation to systems implementation and operations.
• Consistently successful in aligning technology organizations to better meet the needs of their enterprises and delivering superior business results for stakeholders.
• Effective organizational manager, accustomed to orchestrating multiple development projects and technical support operations, multi - million-dollar budgets and multidisciplinary teams
• Extensive Experience in designing Web Based applications, Service Oriented Architecture (SOA), Three Tier Architecture, Client /Server Methodology, On-line Transaction processing (OLTP) system, Batch Processing System
• Extensive experience in design, development, testing, implementation and support of application.
• Expert knowledge and hands on experience in Oracle database 10g/11g and oracle related products.
• A keen communicator with exceptional analytical and relationship management skills. Ability to work under cross-cultural and multi-lingual environments
• Experience in Oracle RAC Architecture and Knowledge in Teradata Architecture and design.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, HTML, JAVA, C#,XML

Database: ORACLE 11g/10g, SQL SERVER,DB2

Shells: BOURNE, KRON, C, PERL

Operating System: UNIX (SUN, HP, AIX), Linux, WINDOWS

Software: SQL*LOADER, Oracle Business Intelligence (OBIEE), Oracle Enterprise Data Quality (OEDQ), Oracle Data Integrator (ODI), ORACLE ENTERPRISE MANAGER, Microsoft .net Framework, ASP.Net, Visual Studio 2012, SharePoint 2010/2013, MS OFFICE, MS PROJECT, ERWIN, ERSTUDIO, INFORMATICA, Planview, PVCS, TOAD,HP Quality Center, SIPERIAN(Informatica) MDM, JDBC CONNECTION (OCI & THIN DRIVER),Jdeveloper, Eclipse,SqlDeveloper.

Knowledge In: Hadoop, MapReduce, BigData, Cloud Computing,TOGAF framework,ITIL

PROFESSIONAL EXPERIENCE

Confidential

Technical Architect

Responsibilities:

• Developed Shipment Tracking System which include Quote Confirmation, Customer Profile, Equipment Tracking, Dispatch, Container/Roro Booking, Driver Check-in, Voyage Scheduling, Vessel Management, Bill of Lading, Cargo Manifest,EDI Transaction, Invoice and Reports
• Developed and implemented strategies, policies and standards for data architecture
• Developed various database packages, procedures, functions and triggers using SQL/PL-SQL
• Logical and Physical Database design/Modeling using Erwin and visio.
• Co-ordinate with Europe Stakeholders and Business Analyst.
• Provide Technical Expertise to the development Team and Perform Technical Code Review
• Hands on Experience in developing XML Documents and publish Transaction over BPEL Server.
• Experienced in SOAP-UI, XSD, XSLT and WSDL for testing web service call

Environment: MS Project, MS Office, Java, Oracle 12cg, PL/SQL, Unix/Windows NT/2000/XP, Web logic

Confidential, VA

Technical Consultant

Responsibilities:

• Participate in the design and development client’s applications and Service architecture.
• Collaborated with key stakeholders and internal teams to define enterprise architecture principles, standards and guidelines.
• Translated business requirements into systems qualities and repeatable design strategies and patterns, such as adaptability, scalability, availability, and reusability.
• Performed design reviews across company and collected enterprise architecture performance metrics to assure continuous improvement.
• Create future vision architecture to expedite delivery of new products and services to market while meeting company’s cost and risk reduction objectives.
• Coordinate with architects and business experts across IS to translate key strategic objectives into actionable and governable roadmaps and designs.
• Logical and Physical Database design/Modeling using Erwin/ER Studio
• Analyze business and technology challenges, assess costs, and suggest solutions.
• Design and execute proofs-of-concept for critical enterprise capabilities, including building business case with costs, benefits, and efficiency measures.
• Partner with all other teams (database management team, software development team, designers) and users to provide best solutions by maintaining the best standards of practice
• Hands on experience in Metadata Management, Data analysis, Data integrity, Data governance, Data Quality Data Mapping/Data Transformation
• Support the organizational data warehouse through appropriate utilization of ETL tools
• Used Sparxsystems Enterprise Architect (EA) Software for designing Process flow Diagram and End - End System Architecture
• Developed various report using Qlikview reporting tool.
• Maintaining SharePoint for Project related documents and Issue logs
• Managed relationship with external service providers

Environment: Enterprise Architect (EA), MS Project, MS Office, Java, Informatica, Sqlserver 2008, DB2, Oracle 11g, PL/SQL, Sharepoint, Unix/Windows NT/2000/XP, Cognos, Web logic, OEDQ,OBIEE

Confidential, Newark NJ

System Architect

Responsibilities:

• Managed Confidential Member’s Benefits and eligibility system (from enrollment to access to their benefits in portal)
• Provide technical leadership for enterprise IT architecture, integration and standards of enterprise systems
• Maintain detailed architecture diagrams for the current architecture and future-state architecture of enterprise applications, middleware and enterprise tools (SOA, BI, DW), security systems, and enterprise infrastructure
• Work closely with developers and engineers to develop road maps for applications, align development plans, and to ensure effective integration among information systems and the IT infrastructure
• Provide support in database architecture of the organization through database design, modeling and implementation
• Develop plans, strategies and standards for data within the enterprise
• Understand the end-to-end scope of work and design architectural solutions accordingly
• Integrate all data in the data management platform enabling accessibility
• Ensure that the database is secured and updated
• Partner with all other teams (database management team, software development team, designers) and users to provide best solutions by maintaining the best standards of practice
• Oversee that the database back-up and recovery system are available in the enterprise for current and future use, including a potential crisis time
• Control and maximize the data resources and processes within the organization
• Support the organizational data warehouse through appropriate utilization of ETL tools
• Used Sparxsystems Enterprise Architect (EA) Software for designing Process flow Diagram and End - End System Architecture
• Logical and Physical Database design using Erwin.
• Developed Pie-Chart, Bar Chart, Gauge chart and various reports for management using Qlikview Tool
• Migrated legacy applications to modern applications using Re-hosting, Re-architecting Migration Strategy
• Data analysis, Data integrity, Data cleansing /Data scrubbing, Data governance, Data Quality
• Data Mapping/Data Transformation
• Provide Technical Expertise to the development Team.
• Maintaining SharePoint for Project related documents and Issue logs
• Managed relationship with external service providers

Environment: MS Project, MS Office, Java, Informatica, Sqlserver 2008, DB2, Oracle 10g/11g, PL/SQL, Sharepoint, Unix/Windows NT/2000/XP,Planview, Cognos, Web logic

Confidential, Plainsboro, NJ

Database Analyst

Responsibilities:

• Developed Customer master Hub architecture diagram for consolidating customer data using Master Data Management Technology using siperian.
• Developed and implemented strategies, policies and standards for data architecture in the enterprise
• Ensure that designing, Creating, Implementation, backup and recovery of Hub database is carried out effectively
• Involve in data cleaning procedure by removing old, corrupted or irrelevant data in consultation with the teams
• Transform the data from individual system to a common accessible data layer
• Ensure the security and accessibility of data to all users across the enterprise and also the end-users
• Perform database work along with database management team, development teams and external users
• Regularly check the performance of the data architecture to meet strategic business goals
• Deal with the vendors or business partners for product and service development
• Implemented Service Oriented Architecture (SOA) for Customer lookup
• Provide Technical Expertise to the development Team and Perform Technical Code Review
• Generating XML Documents and validate against XSD schema.
• Maintaining SharePoint for Project related documents and Issue logs
• Experienced in SOAP-UI for testing web service call.
• Successfully coordinated with operational, QA and related business groups
• Data analysis, Data integrity, Data governance, Data Quality and working with data stewards.
• Experience in Migration of Database and Applications using Re-fronting, Replacement Migration Strategy
• Managed Informatica process for loading data from various sources (vendors).
• Implemented SIPERIAN MDM Tool for external data (cleanse, scrub and standardization, match, merge, etc)
• Experience in Implementing 21 CFR part 11 guidelines, Installation Qualification (IQ), Operational Qualification(OQ), Performance Qualification ( PQ)

Environment: Share point, Java, Dot.net,Web-Methods, Weblogic,Cognos,Oracle 10g,PL/SQL, ERWIN, Unix/Windows NT/2000/XP.

Confidential, NEWYORK

Database Lead

Responsibilities:

• Logical and Physical Database design.
• Designing Application Logic and wrote High-Level Design Document and Technical Design Document.
• Perform Technical Code Review and Implemented coding standards
• Provide Technical Expertise to the development Team
• Work towards the improvement of the system in terms of maintainability and scalability.
• Developed Various Oracle PL/SQL stored procedures, packages and database Triggers.
• Generating XML Documents and validate against XSD schema.
• Developed XML/XSL Transformation using PL/SQL
• Tuning SQL Queries to improve performance.
• Developed reports using Qlikview Tool
• Database Migration and developed new application using interoperation migration strategy.
• Application Rollout from Development to Production and Used Surround SCM for source code management.
• Developed various reports using OLAP Concepts (multi-dimensional analytical queries).

Environment: Cold Fusion,Oracle 9.2.0.4.0,Orcle Enterprise Manager,PL/SQL, SQL*LOADER,Oracle Export/Import, Unix/Windows NT/2000/XP.

Confidential, NUTLEY, NJ

Project Lead

Responsibilities:

• Successfully managed /developed various applications
• Implemented various interface process between different systems.
• The following applications are Developed / Customized
• Activity Base
• Rodin
• GRT (Global Registration Tool)
• ESM (Enterprise Substance Manager) Migration
• Developed several PL/SQL Procedures, Packages and Database Triggers.
• Implemented Oracle Replication process to reflect different sites informational data.
• Implemented automated notification/messaging to users for incomplete test sets using oracle UTL SMTP.
• Implemented Error handling routine to record any error accord during nightly batch process.
• Experience in Application Development using Waterfall methodologies
• Wrote Functional & technical specifications documents
• Designed logical and Physical data model using ERWIN.
• Coordinate with System testing and User acceptance team for application rollout

Environment: Oracle 10g/ 9.2.0.3.0/8.1.7.4.1 , Orcle Enterprise Manager,PL/SQL, SQL*LOADER,Oracle Export/Import, Activity Base 5.2, Unix/Windows NT/2000/XP.

Confidential

Senior Programmer Analyst

Responsibilities:

• Maximize cross-selling across Geographic’s and product boundaries.
• Maximize ease of use / navigation and deliver comprehensive value.
• Capabilities should be extendible to include remote access devices such as mobile phones and PDA’s.
• Implemented Oracle Advance replication (Multi master and Snapshot),
• Developed Various PL/SQL stored procedures, packages using latest features.
• Application Rollout from Development to Production.

Environment: JHTML/JAVA(Front End), ATG Dynamo(Application Server), Iplanet (Web Server) and Oracle 8i (Database), Unix/Windows NT.