We provide IT Staff Augmentation Services!

Lead Database Architect/engineer Resume

3.00/5 (Submit Your Rating)

CA

SUMMARY:

  • 12 years of extensive experience in software industry, specialized in software development and administration including Oracle SOA technologies, PL/SQL, Java, Spring MVC, Hibernate ETL, Dataware Housing, EDI and Oracle WebLogic 10g/11g.
  • Enterprise and IT Architect with 5 years of leadership experience in Project Management, Web Application Development and Information Management.
  • Proficiency and experience in Oracle SOA - Service Oriented Architecture (BPEL, OSB and ADF), Java Rest, Event Driven and Message Based (JMS) architectures.
  • Good experience and knowledge of HTML & CSS, JavaScript, XML Technologies (XML, DTD, XSLT and Style sheet etc.).
  • Demonstrated expertise utilizing ETL tools, like Informatica and ETL package design, and RDBM systems like Oracle, and DB2.
  • Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers, Views, DB Links to retrieve, manipulate and migrating complex data sets in Oracle Databases 10g/9i/8.x/7.x.
  • Experience in Data Modeling (ERWIN) & UML Modeling, Data Migration, Data Conversion and Interface.
  • Extensively used UNIX shell Scripts for automating batch programs.
  • Good Knowledge of Big Data /Hadoop Ecosystem.
  • Extensive exposure to concepts of Data warehouse like Design, Data Modeling, OLAP and OLTP processing. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Adapts to new systems and environments quickly and capable of transforming business requirements into technical solutions.
  • Detail-oriented with excellent analytical, troubleshooting and problem-solving skills.
  • Worked on functional domains like Finance, Banking, Retail, Insurance, Pharma, Utilities, Logistics, Security and End-User support.

SOFTWARE SKILLS:

Languages: SQL, PL/SQL, Java, Shell Script Programming, Python

Oracle Fusion Middleware: Oracle SOA Suite 11.1.1.6 (BPEL, OSB, ADF), JMS, JDBC, Adapters - DBFile, JMS, AQ

ETL/Reporting/BI: Informatica, BI Publisher, Tableau

Hadoop Ecosystem: HDFS, MapReduce, PIG, Hive, Sqoop

Administration: WebLogic Server Administration & Oracle Database Administration

Development Tools: Oracle JDeveloper Studio 11g, TOAD, SQL Navigator, SQL*PlusSQL*Loader, Erwin, Microsoft Visio, Eclipse, SOAP UI, Edifecs

Databases: Oracle 8.x/9i/10g/11g, Sybase, IBM DB2

Others: XML, XSL, XSLT, JSON, Microsoft Office, SOAP, JDBC, FTP, HTTP.

UI Development: Oracle ADF, HTML, CSS, Javascript

OS: Linux, UNIX, Windows XP/2003/2000/NT.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Lead Database Architect/Engineer

Responsibilities:

  • As an Architect/Lead Developer involved in Analysis, Design, Build and testing of Data Warehouse project.
  • Involved in Data Migration project - Teradata is being replaced by Oracle Exadata.
  • Meet with end user groups to gather detailed business requirements and use cases, and translate technical specifications into product requirements.
  • Prepare the Business Requirement documents and Technical design documents.
  • Generate Data reports for the State Health boards and other groups.
  • Using Informatica as ETL tool schedule daily, weekly, monthly, quaterly data pull jobs.
  • Apply transformations and business logic to transform the Epic Clarity Data and pull all the data from Teradata to Oracle DB.
  • Generate SAS Datasets from the Oracle table data and store them on the UNIX servers.
  • Generate Tableau monthly reports for the end users.
  • Wrote Java programs to interact with SnappyData, Spotfire databases and pull data into Oracle DB.
  • Involved in analyzing group how AWS Redshift can be used to replace Teradata.
  • Prepared Flow diagrams for the projects using Microsoft Visio tool.
  • Represent the Data Warehouse team in the monthly PAG status meeting along with Director of SPG and give status report of entire team to the Division of Research management.

Confidential, CA

Lead Database /Integrations Architect

Responsibilities:

  • As an Architect/Lead Developer involved in Analysis, Design, Build and testing of Data Conversion project.
  • Analyze and define Clients business strategy and determine system architecture requirements to achieve business goals.
  • Meet with Business owners to gather detailed business requirements and use cases, and translate technical specifications into product requirements.
  • Prepare the Business Requirement documents and Technical design documents.
  • Analyze the Historical data present in IBM DB2 and identify which modules needs to be converted and in what order.
  • Using Informatica ETL tool schedule daily and weekly data pull jobs.
  • Pull module by module data from DB2 Database and load the data to Oracle staging database. Apply transformations and business logic to the staging table data and then prepare the export table which needs to be loaded to Campus solutions.
  • Prepare the Validation log document and work with Business testing and validation team to identify gaps in the code.
  • Involved in code reviews of onsite team members and offshore team.
  • Written test cases to test the Conversion modules.
  • Prepared Flow diagrams for the projects using Microsoft Visio tool.
  • Represent the Data Warehouse and Reporting team in the weekly status meeting along with manager and give status report of entire team to the SIS project higher management.

Confidential, CA

Enterprise Integration Architect

Responsibilities:

  • Lead Hitachi Consulting team of 4 OSB and 2 PLSQL resources in Analysis, Design, Build and testing of OSB integrations based on business requirements.
  • Developed applications to integrate various Confidential orgs like RMB, EEP and MTV.
  • Designed, developed, and managed web-based applications, databases and programs.
  • Worked on HIPPA 5010 Transaction sets (834/820/999/TA1), EDI/X12 and Edifecs, Medical trading partner format agreements and Transaction Companion guides.
  • Development of UI components using Oracle ADF, HTML, Javascript.
  • Creating Technical ADF workflows (Task flows for the business process).
  • Involved in production and post-production activities.

Confidential, CA

Enterprise Integration Team Lead

Responsibilities:

  • Developed web services to integrate various PGE orgs like CC&B, Myenergy Portal with each other and with outside orgs like Kubra & Genesys.
  • Developed Java / web services and OSB web services.
  • Converted JSON data to xml and vice versa while making REST calls to Genesys.
  • Called Database Procedures, Functions from BPEL using DB Adapter.

Confidential

OFM Scrum Master/SOA Tech Lead/Sr Integration Developer

Responsibilities:

  • Developed applications to integrate various force.com orgs like Org62, Peopleforce, and Supportforce & Oracle Financials with each other and with outside orgs like Coupa & Workday.
  • As Scrum master for the CE Scrum team manage the offshore team and eliminate any blockers for successful delivery of the projects in each sprint.
  • Designed and created complete BPEL processes for orchestration using different process activities for Cisco Order Submission process.
  • Prepared the partner WSDLs for all the services involved in orchestration.
  • Involved in code reviews with other offshore team members and groups.
  • Build the SOA environment and train CSI employee’s to handle the future development.

Confidential, CA

Sr. Oracle Database Developer

Responsibilities:

  • Developed number of database Procedures, Functions and Triggers according to business rules using PL/SQL.
  • Involved in Analysis, Design, Construction and testing of Oracle database based on business requirements.
  • Done code reviews, written test cases and prepared TDD’s and BRD’s.

Confidential, Fairbanks, AK

C++ Developer

Responsibilities:

  • Designed and created a C++ program based on business requirements.
  • Made use of the VRJuggler packages to virtualize the data into a 3d graphics model.
  • Wrote UNIX shell scripts to perform batch routines & integrate applications.

We'd love your feedback!