Data Architect Resume
Objective
- A Software Engineer with strong Data Architecture, Java/J2EE programming, Team leader and business skills.
- Progressive experience developing Logical and Physical Data Models, popular new algorithm - based software architectures and technologies for global industry leaders.
- Willing to apply all acquired knowledge, skills, ability to learn and adaptability by being an effective team member in dynamic business environments and to grow with the organization.
SUMMARY
- 8.5 years of experience in developing, implementing and testing leading edge Pharmacy and Health Insurance Data Models, Data Migration, Java and J2EE solutions for global client organizations.
- Expertise in Data modeling and Data administration and excellent experience in databases like Oracle, DB2 and Sybase. Proficient in SQL, PL/SQL, Views, Functions, Stored Procedures and Triggers.
- Expertise in programming, including Object Oriented Programming development in core Java
- Good understanding of SOA implementation using WSDL with SOAP, XML Web services standards
- Solid experience on various Web & Persistence frameworks like Struts, Spring, JSF and Hibernate.
- Knowledge in Spring Framework AOP (including transaction management)
- Good understanding of web technologies like HTML, AJAX, XML, CSS and JavaScript
- Familiar with Shell scripting and Unix commands
- Expertise in multi-threaded programming
- Hands-on experience in deploying web and J2EE enterprise applications on IBM WebSphere web/application servers.
- Hands-on experience with Integrated Development Environments (IDE’s) and tools like Eclipse, WSAD, RAD6.1, NetBeans and Toad.
- Experience working with the Facets system
- Expertise in ETL tools like Ab Initio.
- Interaction with various business teams for requirements gathering.
- Experience in working with teams spread across multiple geographic locations.
- Proven multidisciplinary, analytical and interpersonal skills to work in diverse team environments.
- Experienced in methodologies like Iterative, Agile, Scrum and Waterfall approaches.
TECHNICAL SKILLS
Programming Languages: Java 1.5/1.6, C/C++, PL/SQL, VBScript
Java Technologies: Servlets, JSP 2.0, EJB 3.0, JDBC, JNDI, WebServices 2.0 (Axis2)
Frameworks: Jakarta Struts 1.2, Spring 2.5, Hibernate 3.0, JPA, JSP 2.0
Web Development Technologies: HTML 5, AJAX, XML, CSS, JavaScript
Web/Application Servers: IBM WebSphere 6.x/7.x, WebLogic 8.x/9.x
Databases: Oracle 8i/9i/10g/11g, DB2 (UDB), SQL Server, MS Access, MySQL, Sybase
Configuration: CVS, Subversion, Rational Clear Case, Visual Source Safe
IDEs: Eclipse, RAD 6.1, WSAD, NetBeans
Methodologies: OOAD, UML, OOP, MVC & MVC2
Operating Systems: UNIX, Linux, Windows 98/2000/XP/vista/7, OS/390
Tools: and Other: Ant, Maven, Fusion Bamboo, JIRA, IBM MQSeries, JUnit, Log4J, SoapUI, Crucible
PROFESSIONAL EXPERIENCE
Confidential
Data Architect
Responsibilities:
- Design and implementation of the new Phoenix Data Model to support the Retail Networks Data.
- Interacting with business analysts to gather requirements and develop data model.
- Design of data migration to port data from the legacy Anchor system in mainfram DB2 to the new Phoenix DB spread on Oracle and mainframe DB2.
- Development of the data migration solution in COBOL, shell scripting, PL/SQL and SQL*Loader Control scripts.
- Unit testing of the data migration solution
- Performing code reviews, code walkthroughs, and troubleshooting from development phase to production.
- Co-ordination with offshore team to monitor progress on the design and development deliverables
Environment: Oracle 11g/12C, DB2 Mainframe, Oracle SQL Developer, Teradata SQL Developer, Shell scripting
Confidential
IT Architect, Developer
Responsibilities:
- Involved in discussions and data mapping preparations for the contact systems data migration, involving Phone call history, Prior Authorization and External Notes, Web Profiles and CS Notes data.
- Creation, execution and maintenance of scripts for migration the data for successive tiers involving multiple clients. Also worked on Ab Initio graphs for data migration.
- Co-ordinate all IMT issues being assigned to Patient Systems applications as part of Tier migration and drive them towards closure.
- As part of DOD requirements, involved in supression of VB and Java based campaigns. This involved the creation of a common table based suppression logic that could be implemented across all campaigns.
Environment: Oracle 11g, Mainframe DB2, Ab Initio, Core Java, WebServices, JEE-5(Annotations, JSP, JAX-RPC), Spring Framework-2.8, VB, VBScript, Eclipse
Confidential
Data Administrator
Responsibilities:
- Assessment of the data impact of the various projects and change requests as they go from planning stage to execution by interacting with the various project teams.
- Co-ordination with System Administrators and the development team to understand the requirements and development of data model solutions for the project/change request.
- Enforcement of enterprise structural and naming standards on the various data elements.
- Enforcement of standards in the documentation of the data mapping involved in the various software components that are affected by the projects and change requests.
- Effort estimation for both onsite and offshore resources for the various tasks.
Environment: Facets, Sybase
Confidential
Onsite Co-ordinator, Offshore Team Lead
Responsibilities:
- Requirement gathering from the client.
- Coordination of the development work by communicating the requirements to offshore and also updating the client on the status of the various tasks at different times.
- Implementation of the enhancements by coordinating with various teams like the WebSphere Administrators, DBAs, IIS Administrators and so on.
- Managing production support activities of the applications.
- Have been involved in various crucial projects like WAS migration, LDAP migration while at onsite
Environment: Java/J2EE, JSP, DB2 (UDB), Oracle, HTML, CSS
Confidential
Programmer Analyst
Responsibilities:
- Impact Reports Generation
- Analysis based on the Impact Reports
- Creating design documents for Impacts identified
- Code changes/Development based on the design with commit logic implementation
- Test cases preparation and code testing
Environment: Facets, Sybase