We provide IT Staff Augmentation Services!

Tech Lead /data Architect/it/data Analyst/ Consultant Resume

Milpitas, CA

SUMMARY:

  • Over 20+ years of IT experience includes, Project Management, Analysis, design, Data Model. Extensive experience in Development, Deployment, Testing, Enhancement, Migration and implementation of large and complex Client/Server applications as well as web - based applications.
  • Delivering and managing multi-million dollar projects using offshore & onshore models.
  • 16+ years of experience in development of applications in Oracle 7.x/8.x/8I,9i,10x,11g, 12x C/C++, Pro*C,unix shell Script, perl,SQL, PL/SQL, SQL*Forms 4.5/6.0/6i, SQL*Reports 2.5/3.0/6i, Developer 2000.
  • 2+ years of experience in analysis, conversion and implementation of Oracle HRMS 11i/12.
  • Experience in functional and technical systems analysis & design, systems architectural design, presentation, process interfaces design, process data flow design, and system impact analysis, Gap analysis, Feasibility analysis and design documentation and presentation.
  • Designed conceptual data model and physical data model for applications for Industries in Insurance, Purchase, Order management/tracking, Sales, Stocks, Finance, HR, Inventory and Manufacturing applications.
  • Experienced in working with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
  • Conduct Business user/business acceptance testing
  • Oracle 7.x/8i/9i Analysis, Designer, Development, Shell scripts, Testing and Implementation using Erwin, Designer 2000 and Data Modeling.
  • Good knowledge in oracle apps11i AR, TCA,OAF.
  • Proficient in Upgrade and migrate the Forms & Reports from 4.5/2.5 to 6i.
  • 4+ years experience with developing front end with java Servlets, JSPs.
  • Strong skills in Oracle are SQL*PLUS, PL/SQL & PRO*C, especially, back end programming like Packages, Functions, Procedures and Database Triggers as well as writing ksh/bsh/csh Shell and PERL scripts.
  • Interaction with other technical groups including Oracle DBAs, Unix Administrators, business analysts and product analysts
  • Other skills include Team Management, Quality Assurance, Software Testing, Business Process Re-engineering, Information Systems Planning Study, Reverse Engineering etc
  • POC’s for tableau,Big Data using Mongo DB, Cassandra, Flume, Hadoop/HDFS, Kafka, spark,Hive, Pig latin, map reduce, Sqoop using python for data lake etc. architecture POC /use cases on various big data scenarios where/how industry can be benefitted with this technology . POC on various Data Pipelines flow.
  • Independent POC for AWS architecture(VPC,EC2,RDS,S3), Google Cloud, Microsoft azure cloud .

TECHNICAL SKILLS:

Databases: Oracle 9I,8i/8.x/7.x, SQL, MS Access 97/2000

Languages: PL/SQL, Java, XML,XSL, Servlets, JSP, C++, Pro* Cobol, Pro* C, C, CGI-Perl, Unix Shell Scripting, Developer 2000, Forms 4.5/6.0/6i, Reports 2.5/3.0/6i, Visual Basic 6.0, SQL*Plus, SQL*Loader, Explain Plan, TKProf, Import/Export, MS Project, TOAD, peoplesoft 8.x, SQR, Mongo DB, Cassandra, Hadoop, HDFS, flume, kafka, pig latin, spark, hive, map reduce, python, tableau

Data Modeling: Power Designer 6.0, Designer 2000, ERwin

Source Control: Visual Source Safe 6.x, PVCS 6.x, SCCS, and RCS

O/S HP: UX 10.20/11.0/11.11 , Solaris 2.x, Sun 4.1.x, DG-UX 4.2, AIX 3.x/4.xUnixWare/SCO 7.x, Windows 3.1/95/98/2000/ NT

Tools: TOAD, Oracle Replication, Oracle Enterprise Manager, Oracle IFSInformatica 5.1,7.x,superglue, Business Objects. Oracle Application Server, Oracle Portal

Methodology: SSAD,OOAD

Applications: Oracle Apps, 10.7,NCA, 11i, 12, peoplesoft

EXPERIENCE:

Confidential, Milpitas, CA

Tech Lead /Data Architect/IT/Data Analyst/ Consultant

Technologies - Oracle 12c, pl/sql, sql, Toad, Hadoop, Snowflake

Responsibilities:

  • Conceptual, logical, physical Analysis,Design, modeling and develop Backend of judicial information system (JIS).
  • Conversion, Validation and ETL integration of existing data to new structure.
  • Extensive coding and performance tuning in sql, pl/sql.
  • Collaborate with team members to troubleshoot and resolve issues.

Technologies - Oracle 12c, pl/sql, sql, Erwin, Jira, SVN, Sql loader, Toad, Tableau 10.x

Methodologies - Agile: SCRUM

Confidential, Milpitas, CA

Tech Lead /Data Architect/IT/Business Analyst/ Consultant

Responsibilities:

  • Gathering requirements from business users, Analyze Functional and Design specifications.
  • Lead the Onsite/Offshore development team.
  • Understanding Functional Use Cases provided by analysts and create High level and Low level Design for the same.
  • Lead backend Technical Design.
  • Custom integration, validation with other application (data load strategies, golden gate replication etc.)
  • Developed complex Backend code to interact with Middle tier service components written in Java/J2EE .
  • Extensive performance tuning of sql . pl/sql, scalability improvement of application.
  • Tested application in Load Test environment and fixed performance issues.
  • Perform Proof of Concept's, document Approaches and design details.

Technologies - Oracle 11g, pl/sql, sql, Kintana, Unix, Perl, Javascript, JAVA, Poc in mongo db, Cassandra, Shell Scipts, ERwin

Methodologies - Agile: SCRUM

Confidential

Responsibilities:

  • Gathering requirements from business users, Analyze Functional and Design specifications.
  • Lead the Onsite/Offshore development team.
  • Understanding Functional Use Cases provided by analysts and create Highlevel and Lowlevel Design for the same.
  • Involved in the Technical Design.
  • Developed complex Backend code to interact with Middle tier service components written in Java/J2EE .
  • Working on performance tuning, scalability improvement of application.
  • Validation, Tested application in Load Test environment and fixed performance issues.
  • Perform Proof of Concept's, document Approaches and design details.

Technologies - Oracle 11g, pl/sql, sql, Kintana, Unix, Perl, Javascript, JAVA, Poc in mongo db, Cassandra, Shell Scipts, Erwin

Methodologies - Agile: SCRUM

Confidential, San Francisco, Ca

Tech Lead / Consultant

Responsibilities:

  • Analysis of the existing code in the batch jobs for Bill Pay. Extensively working with pl/sql, sql tuning, development and re architecting exisiting code, convert from java to pl/sql packages for Performance tuning and scalability.
  • Worked on the data analysis, Gap analysis, Software requirement specification, tech specs, Data model, Scrum, Agile etc.
  • Worked on Wachovia - Confidential data Conversion, migration with application leaders and architecture teams on Consolidating application data sources.

Environment - Oracle 10G,Teradata, PL/SQL, SQL, Perl, Shell,Toad, Sqlloader, Java, Erwin, Visio

Confidential

Lead/Analyst

Responsibilities:

  • Building and utilizing an onshore/offshore model to deliver the project at reasonable cost for multiple clients.
  • Working closely with application leaders and architecture teams on Consolidating application data sources.
  • Mentor Junior Developers.
  • Analysis of As is processes and rearchitecting the TO BE architecture.
  • Performance Tuning of existing Oracle Backend pl/sql, sql Code.
  • Design, Develop, Implement data privacy protocol(data masking) for the Development environment of applications in order to comply with SOX regulation.
  • Involved with teams for review of business processes, Code Review, QA test cases, test plans

Environment - Oracle 8i/9i /10G, PL/SQL, SQL, Perl, Shell script, Oracle Forms 6i,Reports, Toad, Sqlloader, Informatica, Java, Erwin, Visio

Confidential, San Jose

Consultant/Sr. IT Analyst

Responsibilities:

  • Architecting and developing SSOT(Single Source of truth) data warehouse for the provisioning of HR information for the enterprise, coded in Informatica, pl/sql, sql, unix.
  • Leading the Data Privacy effort for HR( Peoplesoft HRMS), and collaborating with other departments to consult them about the data privacy, coded in pl/sql.
  • Design, Develop, Implement data privacy protocol(data masking) for the Development environment of applications in order to comply with SOX regulation.
  • Cosult Siebel team to mask HIPPA related sensitive Data.
  • Involved in SOX compliance for unix, database account access methodology.
  • Re-architecting existing data flow for employee data to down stream applications. Setup AQ for data integration between the production database and ODS system for the workforce Data hub project.
  • Write test cases and perform UAT.
  • Evaluation team member for cutting edge technology i.e evaluating technologies for EAI etc.
  • Contribute in Partner architecture Team to setup guidelines, consult on data models etc.
  • Research new technologies for the organization to help them to be leader in industry.
  • Involved in 30 to 1 applications strategy to reduces/eliminate redundant functionalities and convert them to SOA.
  • Meta Data Collection to redesign single source of truth(SSOT) and eliminate redundant functionalities in different applications. Provide business requirement to convert them to SOA. Conduct POC for metadata collection product (superglue by informatica).
  • Evaluate oracle AQ, Oracle interconnect and tibco technology. Involved in tibco, AQ proof of concept (POC) for data movement and integration.
  • Involved in CIXS(Common Integration Exchange Specification) for developing an XML schema for common attributes which are used for integration between various enterprise systems
  • Create Business/Functional requirement documents.
  • Mentor junior developers / Programmers.

Environment - Oracle 8i/9i, PL/SQL,SQL,AQ, Java, JSP, Servlets, Struts, JDBC, XML, XSLT, Erwin, designer 2000, Perl, Shell Scripts, Informatica powercenter 7.x, Superglue, peoplesoft 8.3, 8.8, SQR, Toad, sqlLoader, visio.

Confidential, San Francisco

Tech Lead / Consultant

Responsibilities:

  • Design, Develop backend using oracle 8i/9i,sql, pl/sql, Pro*c Unix Shell Scripts.
  • Functional design/development for the Accounts Payable(AP), Check Printing Functionality for the CODA financial and responsible for the technical development .
  • Functional design Lockbox functionality for the CODA financial Systems and responsible for technical development.
  • Design guidelines for the Standardization of the naming convention.
  • Application tuning, Sql performance tuning, pl/sql Tuning.
  • Co-coordinated with QA team to complete the testing within assigned deadline and efficiently figure out the root cause of the bugs/defects raised by the QA.
  • Coordinated with Business/IT Analyst with the requirements.
  • Mentor Junior Developers / programmers

Environment - Oracle 8i/9i, PL/SQL, SQL, CODA financial, Erwin, Perl, Shell Scripts, pro*c, unix, Cognos.

Confidential, San Jose

Consultant/Sr. IT Analyst

Responsibilities:

  • Rearchitect Customized Partner Relationship Management (PRM).
  • Lead team for backend development using oracle 8i/9i, sql, pl/sql and coordinating with front end developers developing User Interface using Java, JSP, Servlets, Struts, JDBC, XML.
  • Design and Develop the Stored Procedures using PL/SQL, used varrays, nested tables, Record, indexby tables(pl/sql tables) collections, bulk collect, bulk bind, Autonomous transactions.
  • Created utility packages which include all the reusable queries for the application to provide the uniform access instead of each developer using their own code each time.
  • Involved in the Standardization of the naming convention.
  • Application tuning, Sql performance tuning, pl/sql Tuning.
  • Coordinated with QA team to complete the testing within assigned deadline and efficiently figure out the root cause of the bugs/defects raised by the QA.
  • Coordinate UAT (User acceptance testing).
  • Coordinated with Business Analysts with the requirements.
  • Write the Sync utility to transfer data between Walker (company conduct the survey for Confidential ) and Confidential for the surveys sent and received. Monitor the trend of the records failed /accepted which allowed Confidential to figure out and help fixing many issue with the walker system in order to minimize/eliminate the errors causing loss of data.
  • Created seeding scripts to Migrate existing database data to the newly architected application for partner relationship management using SQL, PL/Sql. Validated the accuracy of the data migrated as well.
  • Always meet the deadlines.

Environment - Oracle 8i/9i, PL/SQL, SQL, Java, JSP, Servlets, Struts, JDBC, XML, XSLT, Erwin, Perl, Shell Scripts.

Confidential, Thousand Oaks

Lead / Sr .Consultant

Responsibilities:

  • Extract the Oracle report 6i to output to excel (standard functionality has lot of bugs and cannot be used ) using XML, XSLT, Java Parser .Enhance the Pro*c Process to automate the execution of reports.
  • Enhance current applications (Contract and chargeback system) to convert them to web based application. (From Client Server to 3 Tier Architecture).
  • Working on data migration from a newly acquired company.
  • Design and develop various Data Migration tools for the heterogeneous databases.
  • Co-ordinate with developers in the fine-tuning of Pl/sql codes for backend, forms and reports. Fixing the problems in triggers, procedures and functions.
  • Write Pro*c programs to be executed in batch daily thru cronjob.
  • Customized forms/reports for Oracle 11i,AR,AP TCA api's.

Environment - Oracle 8i/9i,Teradata, Oracle 9iAS, Developer 2000, Forms 5/6i, Reports 6/6i,PL/SQL, Java, Servlets, Struts, XML, XSLT, Erwin, Perl, Shell Scripts, Pro*c, Oracle Portal, Informatica 5.1, Business Objects, SAS.

Confidential, Indian town, FL

Tech Lead /Consultant

Responsibilities:

  • Made technical recommendations, advice technical resources to improve performance with adequate training and skills and completed the project on time and within budget.
  • Design and developed various applications using Erwin. Responsible for a lot of backend design, data modeling and design using ERWIN.
  • Coordinating with developers in the fine-tuning of Pl/sql codes for forms and reports. Used advance feature of reports i.e reports with ref cursors, Conditional Reporting, web reports etc. Fixing the problems in triggers, procedures and functions.
  • Always meet the deadlines.
  • Design and Develop Stored Procedures for data population for the web site.
  • Wrote Shell and PERL scripts for automate Business process.
  • Modify forms and reports of the Existing Oracle 11i Application, AR, AP exposure to TCA API's.
  • Mentored technical and non-technical teams.
  • Did Pilot project for AQ in oracle.
  • Design and develop front end in JSP for loan Management.
  • Design and Develop the Stored Procedures using PL/SQL to automate the priority to assign the loan application for the case manager based on the no. And type of loans a case manager can handle. Used varrays, nested tables, Record, index by tables (pl/sql tables) collections, bulk collect, bulk bind, Autonomous transactions, objects, xmltype.
  • Design and develop various Data Migration tools for the heterogeneous databases.
  • Develop Credit check Program in Java where Credit check request is sent to the credit Bureau in XML Format (having validated XML Schema) and response is also received in XML Format.
  • Exposure to Oracle IFS.
  • Design and developed PL/SQL interfaces from an existing ORACLE database system to the legacy reporting system (3rd party tax reporting/EDI product/SAP).Tuning existing PL/SQL Code.

Environment: Oracle 8i/9i,Oracle 9iAS, Oracle portal, Oracle IFS, Designer 6.0/6i, PL/SQL, SQL, Java, Java Servlets, JSP, XML, Erwin, Perl, Shell Scripts, Informatica, Unix and Windows NT, Business Objects, Solaris, AIX.

Hire Now