SUMMARY:

• 19 years of IT experience in analysis, design, development, documentation, implementing using Core Java, J2EE, in Spring and Struts frame work and C#, Aspnet in Visual Studio with Oracle, SQL server, Sybase, DB2 environment.
• Strong experience with Use - Case design, Class, Sequence diagrams using UML with Java EE design patterns such as MVC, Singleton, Session Facade, DAO, and Business Delegate.
• Strong hands-on experience with Spring MVC, Spring Security, Spring JDBC/JPA/Hibernate, Spring Boot,
• Restful service / microservices, Servlet, JSP, JMS, AJAX, Soap, JavaScript, jQuery, AngularJS, XML.
• Exceptional programming skill sets in Unix shell script (Perl, sh, ksh, csh), TSQL, PL/SQL stored procedure. Strong performance tuning ability in system/database/application code level.
• Working experiences in AWS and big data analysis using EC2, S3, RDS, Redshift, Hive, Spark/Scala and Hbase in Hadoop environment. The Knowledge of SDLC with methodologies like Agile/Scrum.

TECHNICAL SKILLS:

Application language and server: J2ee, Core Java, Servlet, JSP, JPA, Spring/Struts framework, Spring Boot/JDBC/JPA/Hibernate, Strut, JMS, RESTful, Swing, Angular 2, Microservices, Web Service/Soap, Perl/Python, Scala, Hive, Spark, Hbase, EC2, Docker, Jenkins, C#, Net/ASP.net, Junit, LINQ, WCF, Toad, MQ, JSON, IIS, Tomcat,VS, Eclipse, IntelliJ, Angular 2, JavaScript, JQuery, Ajax, Jira, Spark/Scala, Ant/Maven, Junit, Hadoop, AWS

Database: ORACLE 12c/11g/10g/9i PL/SQL, Data Pump, SQL Loader, Data Guard, RAC, Oracle Data warehouse/BIMS SQL 2016/2014/2012/2008 (T-SQL, replication, mirroring, log shipping, SSRS, SSIS, Failover Cluster)SYBASE ASE 12.5/17.5, Sybase Replicate, Sybase IQ, Rapid SQL, DB Artisan, MySQL DB2 UDB/LUM, DB2 Z/OS, MongoDB, HBASE, Hadoop, EC2, S3, RDSOperation system and network: Windows, Unix/Linux/Solaris/AIX, SAN/VMware, NetApp, Hadoop, AWS.

Application Server: Tomcat/JBoss, WebLogc/WebSphere

Operation Language: PowerShell, Unix shell script (Perl, ksh, sh, csh, awk), C/C++

Design and ETL tool: CA Erwin, Confidential Universe, Microsoft Visio, SSIS/DTS, Informatics, Oracle Designer, DataStage

PROFESSIONAL EXPERIENCE:

Confidential (New York)

Sr. Architect/Sr. Java Developer

Responsibilities:

• Responsible for administering multiple database application in varied operation environments: Solaris/Linux/AIX and Window OS.
• Responsible to application/database architecture, modeling, web application integration, reporting implementation and maintenance included Trade software Murex and Business Object application for Risk management. Perform configuration, deployment of web application and database server.
• Attention to detail. Quickly identify and respond to application/database incident (improperconfiguration parameters, issues of connectivity, application hang, query optimization, process blocked, indexes or table fragmentation) in a short time. Optimize SQL query/stored procedure to improve response time and Throughput.
• Write Perl and Python script to create automation tools for database, application process or parse text file sent from FTP or other server
• Migrate SQL and Oracle Database/Warehouse to AWS cloud using EC2, S3, RDS and Redshift.
• Install and configure Hbase, Have in HDFS. Write programming of Hive, NoSQL,Spark/Scala for big data analysis in Hadoop environments.Project ( Confidential ): As key person to Develop Network Service web application using Java Networ
• Responsible for the full life cycle development of Network Service web application architecture using core Java, Spring framework, Spring Boot and Microservice.
• Worked closely with users for data and functional requirements. Gathered and defined the requirements.Ensured that each capability, mission to be analyzed and documented. Translated them into detail design and the plan for action.Responsible for application design. Created application component diagram,class diagram, processdiagram and sequence diagram (UML) to capture business logic. Provided baseline real time
• Network engine web application architecture.
• Implemented the core components (run multithreading in daemon to store, extract data from the serversocket through multithread concurrency and bulk data load into near real time database and generate the failed process to network Center using Spring Boot, Microservices / Restful Service, multithread, SpringJDBC/JPA/Hibernate, oauth2/Spring Security to create NetCall Service, Gateway API, Admin View
• Dashboard, and Client Service for user to consume Microservices.
• Created GUI using Jsp, Java script, AngularJS 2, Jquery, Ajax, CSS, DTD, XLT and HTML.
• Created JDBC stored procedure modules. Worked on query optimization.
• Reponding to client requests in a timely manner. Analysized alternative to develop recommenation, quick troubleshoot, or effective design and implemeation new capibilities in various levels for production enhancement using Object orientation implementation after application release.
• Responsible for code review.
• Worked on web site navigation design.
• Developed Business Layer and Data Access Layer using Spring IOC and Spring JDBC which in corporate N-tier architecture and database connectivity.
• Designed and developed Web Forms using Java Swing, Core Java, CSS, and HTML. Designed and developed Web Forms using Java Swing, CSS, and HTML. Created Java script, Ajax and JQuery to handle web page mouse over, cascade Dropdown list selection, upload imagine, calendar pop up, pdf file viewer, user request entry validation, page refresh / reload / submission, event or form trigger action, etc.
• Created database objects with Hibernate and Java Application Context.
• Developed Role base Security to authorize user to a specific Role using Spring Security.
• Implemented Exception Handling and Validation of incoming requests.
• Lead planning, and design to meet business requirements such as initiatives of logical and physical data models, access method (index or partition), security enhancement, database and system configuration.
• As a key person, responsible to design and develop Centralized Enterprise Data warehouse which is included legacy system and other RDBMS with consistent central view.
• . Reviewed existing warehousing models and architecture leading to new development that improved existing warehouse and reporting loading. Define roadmap.
• . Identify the existing system and business processes associated with line operational activity in
• . Identify the existing system and business processes associated with line operational activity in each of the key service areas with operations staff and system users to gather requirements.
• . Translate business requirements to detail design. Architect data systems and business processes perational data store and warehouse models for centralized reporting customer.
• . Developed business process models, E/R models, dimensional data Models, and naming standards.
• . Refine and implemented ETL process (data Extract, Transform and Load for warehouse and
• Operational Data Store (ODS) included analyzing the cause of data inconsistence and data incompletion and perform de - dup, look up and data clean to ensure data quality.
• . Created Database/Data Warehouse associated physical structure (table, view, keys, index and partition) environments. Ensured adequate database resources allocated to delivery effective and efficient database process.
• . Highlighted gaps in reporting and data management capabilities, developed mitigation strategies.
• . Created multiple business level documents around data and business processes and metadata
• Management including data dictionaries, data flow diagram, and database policies.
• . Support OLAP data requirements to develop customer analysis & reporting.
• . Enhance data warehouse database performance tuning including configuration and loading process.

Confidential

Architect Leader/ Sr. Java Developer

Responsibilities:

• Lead planning, design, and development tasks/projects to meet business requirements, developing implementation for enterprise infrastructure and application. Maintained PBGC production web application and databases/data warehouse in mission critical environments (Oracle, SQL Server, Sybase, DB2).
• Wrote the boundle of Unix shell and Python script to automately refresh database which is integrated with web application. Provided effective solution to improve stored procedure performance by restructuring the poor designed programming created by Confidential team in Oracle replication.
• Provided the suggest to infrastructure director that DBA team had to migrate selected databases to ther servers to solve serious memory problems that caused database and application slowness.
• Project: Developed Missing System Java web application
• Worked as application and database architect. Developed and maintained large scare, complex enterprise application for PBGC using J2ee/Core Java, Spring frame work and web service. The system processes documentation authorization, reconciliation, payment and debit management.
• Responsible to identify requirement and application detail design. Provided effective solution on integration to meet business requirements.
• Throughly understood the system processes included system documentation authorization, reconciliation, payment, debit and archive management. Create Java class diagram and process diagram and presentaion tire UML diagram.
• Designed the data modeling for payment and debit system and generated physical model.
• Implemented components of payment system and debit management using core Java, Spring MVC, Severlet, JMS, Web Service, JAXRPC,Python, JavaScript, JSP, CSS, XSLT, and XML.
• Wrote complex Oracle stored packages of “Invoice”, “payment” and ‘Debit’.
• Configured and deployed application in Tomcat server.
• Performed continuous analysis of system activity to proactively identify areas of improvement and concern. Improved the overall performance of data processing by Query optimation and identfiedAnd solved the root cause that data processes was blocked.
• Responsible for code view and helping junior developer. Maintain MongoDB database.
• Worked on Business Process and Data Flow Analysis, extended logical and physical data models creation using Erwin, included star schema schema design.
• Worked on ETL process using Informatics.
• Support OLAP data requirement for data cubes such as aggregated and transactional

Confidential

Lead Database Administrator / Sr. Developer

Responsibilities:

• Performed support and participated in Java web application design, development and deployment.
• Implemented Struts, Core Java, DAO and JDBC module based on Spring framework environment.
• Tuned Java application performance by adding connection pool.
• Conducted one-on-one sessions with business users to gather data warehouse regarding to data warehouse detailed design: descriptions of business entities and attributes. Analyzed business process and rules, translated them into technical specification. Developed strategies to consolidated diverse data sources from different system.
• Created dimensional modeling by identifying required dimensions and facts conformed data mart. Created data objects with naming standard, data optimizing storage and index option.
• Worked on target data mapping, transformation, loading, which conducted data flow and control flow in processes of ETL package. Performed data warehouse performance tuning. Solved the problem of batch job slowness. Tuned queries that fact table joins with dimension table and memory setting.
• Administered all database objects and database security. Implemented users privileges, and wrote

Confidential

Sr. Database Architect/Sr. Java Developer

Responsibilities:

• Worked on remedy tickets and code review.
• Performed database and application health check: proactive and reactive responses to monitor/tune performance. Diagnosed complex issues or bottleneck in system, database, application processing using a variety of diagnostic and performance tools. Implemented database administration utilities using Unix, SQL or stored procedure for database backup, monitoring, and DBMS job schedule.
• Performed after- hours troubleshooting and scheduled off-hour maintenance operations., such as database patching, upgrading, installation and configuration

Confidential

Project leader

Responsibilities:

• Defined, analyzed and prepared data and information for the planning and execution of strategicplans, and work breakdown structure. Consulted with customers to identify and specify requirements, as well as needed assessment.
• Worked with team to gather and analyze detail information from source system, identify internal and external data sources, performed complex implementation analyses between SAP and Oracle Financial system, conducted data conversion, interface strategy, and process flow.
• Communicated with users intensively related the requirement of data maps between SAP financials (MS SQL Server based) and Oracle financial system. Ensured integration of all systems components.
• Lead the team to perform migration tasks used Oracle Financials framework for inbound and outbound communications. Implementing Oracle stored procedure, control file, shell script to handle data extracting, cleaning, transformation, and integration and load to the stage tables, and then populate the accounting base tables using Oracle financials web GL/AP/AR/PO modules.
• Resolved and traced critical issues to minimize the risk.

Confidential

Database Administrator/Sr. Java Developer

Responsibilities:

• Performed the tasks of creating Confidential Voice IP web application using Strut framework & web service.
• Initiated and developed relation databases design. Provided logical, physical data modeling and Entity Relationship(ER) diagrams.
• Created application database, implemented security control and Backup & recovery strategies.
• Created database schema, objects, indexes, constraints, and triggers.
• Created web application components backend end classes and GUI pages using Strut MVC,
• Core Java, JDBC, Java network programming and Unix Perl and Java programming to extract data from internet, categorize by VOIP types and load into database.
• Designed and implemented Backup & recovery strategies and Security policy
• Configured application server and deployed the application
• Performed application database and application maintenance, monitoring and tuning. Tuned database instances/servers to maintain optimal server health allowing maximum throughput and minimal resource contention.
• Performed application code query optimization, capacity analysis and database performance tuning. Reviewed and recommended improvements to meet user expectations.

Confidential

DBA / Software Engineer 5 (Java based)

Responsibilities:

• Worked with the function analysts to understand the business process, prioritize and rationalize the tasks. Identifying and documenting the business, technical, product and process requirements for Defense Travel System (Strut based Java Application) .
• Participated in application architecture design under struts, detail design and test plan. Developed an integrated system included six subsystems.
• Reverse and forward engineered the data structures of the newly system. Created data models f following subject areas: travel document, payment, and debt management.
• Participated in application module and class design. Viewed system design and application UML diagrams. Provided technical oversight and input.
• Supported web application development. Created application “System” modules and wrote PL/SQL stored packages for web user to manipulate data.
• Worked on analysis, security requirement, data/application structure change for customer

Confidential

Sr. Perl Programmer /Java Developer /DBA

Responsibilities:

• Participated in design and implementation of the components of acquisition, storage, distribution,maintenance of materiel and transport of personnel. As key programmer, responsible to write Perl modules for the most complex transportation background processes and PL/SQL stored procedures for web database application modules.
• Based client request, converted CGI Perl based web application to Java based web application in an intense and multi - tasking environment using OOA design, OOP implementation/conversion with Java, JDBC, Servlet, XML and Jsp.
• Developed and performed data conversion ETL program which handled imported files fromdisparate legacy formats, operational data store, data cleansing and business rule enforcement.
• Created aggregation tables for geographic and demographic account periodic snapshots basedn the requirements.
• Created index, trigger and wrote shell script to automatically execute script on remote server.
• Administered database objects and security. Performed database backup, migration, and patch.
• Worked on database health check (proactive and reactive); Provided impact information onproposed changes to application and its database structure.