www.dharbor.com Digital Harbor Pvt Ltd Bangalore : PL SQL Database Developer

[Admin]

Company Name : Digital Harbor P Ltd
Company Location : Bangalore
Designation (of vacancy) : Database Developer
Company E-mail ID : lakshmi.chirravuri@dharbor.com
Company Website : www.dharbor.com/indexchange.html

Job Description, Candidate Profile, Company Profile, Company Address :
Greetings from Digital Harbor P Ltd!!
Digital Harbor is a leading edge US based Software Product Company.
Our Company : Digital Harbor, A Norkom Company is recognized as the most innovative and advanced Composite Applications Platform Company by Gartner and Forrester. As part of Norkom it is one of the fastest growing companies growing 40% YTY and delivering next-generation enterprise technologies in integration, workflow and analytics. Recent global economic challenges are driving tremendous growth in Risk Management solutions across all industries and our unique solutions in detection, investigation and risk assessments are widely acknowledged as the most advanced in the industry. For more information about Digital Harbor visit www.dharbor.com/indexchange.html. For more information about Norkom visit www.dharbor.com
Our Platform and Products : Digital Harbor offers the industry's most advanced "Composite Application Virtualization Environment (CAVE)" platform in the industry. Our platform components include SOA based EII engine, BPEL Workflow engine, BRML Rules engine, XML based Messaging Framework on the server side and Web 2.0 based Rich Client framework on the client side. Developed over 8 years and $60M in R&D it is the Industry's only model-driven enterprise application development platform. Leveraging this platform are our advanced detection, scoring and investigations and case management frameworks as well as Vertical Industry Solutions across Defense, Intelligence, Banking, Insurance, Healthcare and Retail.

Role : Database Engineer/Developer
Exp : 4+ yrs
Location : Bangalore
Job Profile :

• Understanding Application Requirements from Business Analysts and converting those into Application Specification
• Actively participate in High level and Low Level Design
• Create Application development task breakdowns and provide effort estimates
• Learn and develop Applications using PiiE™, Digital Harbor’s award winning model driven Application Development Platform
• Data Modeling and Process Modeling
• Follow the SDLC and Agile methodologies in a multi-site development environment
• Create development related documents
• Deploy Applications at customer site and provide user training
• Support Application Customers

DB Skills :

• Considerable experience in developing complex Stored Procedures, user-defined functions, triggers and replication in PL SQL and/or TSQL
• Must have SQL aptitude including ability to execute SQL troubleshooting procedures, analyze SQL code and results from SQL queries
• Good Understanding of ER Diagrams & knowledge in physical structure of DB
• Should have extensive in depth development experience with SQL & Oracle DB, Query optimization and data modeling
• Expertise in troubleshooting DB anomalies such as performance, deadlocks etc
• Experience of working with large volumes of data and managing associated performance and throughput challenges.
• Good experience in Installation, Configuration, Maintenance, tuning & performance monitoring of DB

If skill sets match and interested, share your updated resume with lakshmi.chirravuri@dharbor.com with the following details :

Total IT Experience :
Relevant Experience in SQL or Oracle development :
Current CTC :
Expected CTC :
Notice Period :

Regards
Lakshmi CV
Digital Harbor P Ltd
#310/7,8 Industrial Main road, 5th Block Koramangala,
Bangalore -560095
Lakshmi.Chirravuri@dharbor.com
Office : +91 80 25635179

[Guest-IJT]

Name : sobanasaikrishnan
Email : shobi_m AT rediffmail.com
Designation / Skillset : Technical Lead

Resume :
Resume – Sobana Saikrishnan

Objective
Looking for a challenging career in Software Development and Support where I will have the opportunity to grow with the company I work with.
Career Snapshot
An Oracle professional with 12 years of experience in IT industry
Scholastics
- M.C.A 73% (First class) 1998 Madurai Kamaraj University
- B.SC.,(App Science) 73% (First class) 1994 Madurai Kamaraj University
- 12th 83% (First class) 1991
- 10th 85% (First class) 1989
Certification
- Took 90%on Oracle brain bench exam conducted by Wipro Technologies during selection
Skill Set
Software Professional :
- Business Interaction : Experience in interfacing with business stakeholders to elicit business requirements and explaining the technical challenges and technical limitations if any.
- Team Interaction : Handling the Team and able to achieve the deliverables on time.
- Functional specifications : High Level and Detailed Functional Requirements, Use cases.
- Workshops : Conducted training continuously for past 2 years for fresher’s in metric stream to understand the platform concepts of metricstream as well as oracle.
- Requirements Testing : Involve test team into requirements to layout test execution plan. Write functional test scenarios and carry out functional testing.
- Change Request : Maintain CRs for enhancements and defects.
- Estimation : Maintain Estimation for Each CRs
Functional :
- Pharmaceuticals : Governance, Risk and Compliance
- Banking & Financial : Consumer Banking & Financial Printing
Technical :
- Applications/Tools : Documentation- MS Office, MS Visio, MS Share Point Report Tools- Open Office
- Languages : PL/SQL,Power Builder 6.5,Visual Basic 6.0,Developer 2000
- Database : Oracle 10G
- Web Technologies : HTML, JSP
- Operating System : MS Windows
Career Contour :
Metric Stream InfoTech (P) Ltd– Bangalore – August 2007-May2011
Technical Lead
Domain :
Governance, Risk and Compliance
Project #1 :
Integrated Audits Management Tool
Client:
- Nestle VEVEY.
Duration:
- September 2010 to May 2011
Project location:
- Off shore- Bangalore. Onsite- Switzerland
Technologies:
- ECP 5.5 Build Oracle 10g R2
Project details:
- Nestle is a Privileged customer on the European countries. Nestle uses our audit module to audit their system. Metric Stream Audit Management module allows creating an audit program with a well-defined objective and scope tied to quality, compliance and risk management processes. Auditors can organize an audit in a logical structure and hierarchy with detailed audit templates and work orders. Evaluation and pass/fail criteria, checklists, and tasks that need to be performed for executing the audit can also be defined.
Responsibilities:
- Leading the Project.
- Interacting with functional team and client to understand the requirements
- Involved in demo preparation to clients and explaining the technical limitations, if any
- Involved in design discussion and estimation of the project
- Interacting with team members and mentoring the team members
- Code Review
- Helping the team to meet the deliverables in time
- Interacting with platform team to resolve the issues related to platform.
- Maintaining change request document for all change requests
- Interacting with functional team and helping functional team for updating the Functional specification documents on timely basis.
- Involved in Full development of open office tool reports.
Project #2:
Inspection Module
Client:
- Nexen Oil and Gas company, Canada.
Duration:
- April 2009- September 2010
Project location:
- Off shore- Bangalore. Onsite- Canada
Technologies:
- ECP 5.5 Build Oracle 10g R2
Project details:
- Nexen is oil and gas based company. Nexen uses the Inspection module to inspect the tags and items and to record the vendor inspection report done on the tags. This module provides the option to release the tags and reassign the Quality surveillance process to other specific user.
Responsibilities:
- Leading the Project.
- Interacting with functional team and client to understand the requirements
- Involved in showing demo to client and explaining the technical limitations if any
- Involved in design discussion and estimation of the project
- Interacting with team members and mentoring the team members
- Code Review
- Supporting the team members to achieve deliverables on time
- Interacting with platform team to solve the issues related to platform.
- Maintaining change request document for all change requests
- Interacting with functional team and helping functional team for updating the Functional specification documents on timely basis.
- Involved in Full development of open office tool reports.
Project #3:
Enterprise Risk Management
Client:
- Central Bank of Omen, Omen.
Duration:
- October 2008 – March 2009
Project location:
- Off shore- Bangalore. Onsite- Dubai
Technologies:
- ECP 5.5 Build Oracle 10g R2
Project details:
- Risk management is a structured approach to managing uncertainty thorough risk assessments and developing efficient strategies to mitate risk ERM is managing Enterprise Risks, Operational Risks.
MetricStream provides an integrated and flexible framework for documenting and assessing risks, defining controls, managing assessments and audits, identifying issues and implementing recommendations and remediation plans. The risk management system includes powerful tools for risk analysis and monitoring such as configurable risk calculators and risk heat maps.
Responsibilities:
- Involved in Development
- Interacting with client for showing the demo and understanding the requirements
- Interacting with platform team to solve the issues related to platform.
- Maintaining change request document for all change requests
- Interacting with functional team and helping functional team for updating the Functional specification documents on timely basis.
Project #4:
Change Control System
Client:
- Covedian,USA.
Duration:
- September 2007 – September 2008
Project location:
- Off shore- Bangalore. Onsite- USA
Technologies:
- ECP 5.5 Build Oracle 10g R2
Project details:
- Change Control is one of the most difficult areas in the development and manufacture of products in our industry. Inadequate change control has literally cost companies that make pharmaceuticals, biopharmaceuticals, and medical devices millions of dollars in lost product lots due to unauthorized process changes, not to mention the industry standards and product recalls involving poorly thought-out product or formulation changes.
- Change control activities and procedures apply to: design; components, including software; labeling and packaging; device manufacturing processes; production equipment; manufacturing materials; and all associated documentation such as quality system procedures; standard operating procedures; quality acceptance procedures and data forms, and product specific documentation.
- The Change Control (CCL) module from Metric Stream is designed to help companies manage the CCL process and maintain the relevant data to comply with the FDA and QS regulations.
Responsibilities:
- Involved in Development
- Interacting with client for showing the demo and understanding the requirements
- Interacting with platform team to solve the issues related to platform.
- Maintaining change request document for all change requests
- Interacting with functional team and helping functional team for updating the Functional specification documents on timely basis.
Extra Responsibilities:
- Involved in Training all the fresher of the metric stream
- Active members in conducting Interviews and training and demos of metric stream products.
Career Highlights:
- Appreciated by the client Nestle for 100% perfection in reporting requirement using open office tool reports.
- Awarded “Good Employee Contribution Award” for excellent ownership taken in Change Control System project.
Wipro Technologies– Bangalore –Jul 2004 to Jul 2007
Project Engineer
Domain:
Financial Printing
Project #1:
Capacity Monitor System
Client:
- RR Donnelley, Lancaster, U.S.A
Duration:
- Jul 04 to Sep 06
Project location:
- Off shore- Bangalore, Onsite- USA
Technologies:
- Power Builder 8.3, Oracle V 9.X
Project details:
- The Capacity Monitor System (CMS) is an application that is used by Network Production Coordinators and composition system users to view and manage composition assignments throughout the business unit. It interfaces with LINK Order Entry (OE), Data Entry (DE), and the Composition Job Scheduler (CJS).
Responsibilities:
- Involved in Production Support and development for enhancements
- Interacting with client for support requirements and clarifications and enhancements
- Preparing the Impact analysis document for the changes
- Preparing Effort estimation for the enhancements
Extra Responsibilities:
- Updating the Functional Specifications and Power point demos on timely basis to keep the Spec and Demo stuffs up to date.
Patni Consultants systems (p) Ltd – Mumbai – May 2004 to Jun 2004
Senior Software Engineer
Project #1:
Task Management System
Client:
- Internal.
Duration:
- May 04 to Jun 04
Project location:
- Off shore- Mumbai
Technologies:
- Visual Basic 6.0, Oracle V 9.X
Project details:
- This application that is used by Resource team. Keep tracks of the new project added and have details about the resource allotted for the project, duration of the project and project status.
Responsibilities:
- Involved in Development
Kale Consultants (P) Ltd – Chennai & Mumbai - Dec 2001 to May 2004
Programmer Analyst
Domain:
Consumer Banking
Project #1:
Back Office Service System
Client:
- Standard chartered Bank, Mumbai
Duration:
- Dec 01 to May 04
Project location:
- Off shore- Chennai & Mumbai
Technologies:
- Visual Basic 6.0, Oracle V 9.X
Project details:
- Depository Operations-Consumer Banking Division of Standard Chartered uses BOSS. Boss Is Developed in GUI and Compatible with Windows NT and windows 95/98/2000. Boss At Standard Chartered Bank is a Wan Based Multi-user System having its Main Branch at Mumbai and connected to its Branches all over the India. The System stores the Data of the Depository Transactions of the customers. The System Act as Interface between the End Customers and NSDL.
Responsibilities:
- Involved in Development
- Leading the Project.
- Interacting with functional team and client to understand the requirements
- Involved in showing demo to client and explaining the technical limitations if any
- Involved in design discussion and estimation of the project
- Interacting with team members and mentoring the team members
- Doing the code Review
- Supporting the team members to achieve deliverables on time
- Maintaining change request document for all change requests
Project #2:
Standing Order System
Client:
- Citibank, Chennai.
Duration:
- Aug 01 to Dec 01
Project location:
- Off shore- Chennai
Technologies:
- Pro C, Oracle V 8.x
Project details:
- This system would enable CITIBANK customers to pay their Bills (either one time or recurring) by placing a Standing Instruction with the bank. The beneficiary could be anybody from the banks Payee list (Beneficiary with whom the Bank has a tie-up) or the customer payee list (Beneficiary with Whom the Bank does not have a tie-up and may or may not have a relationship with the bank).
Responsibilities:
- Involved in Development
- Involved in production support
- Interacting with client for understanding the Enhancements
Project #3:
Management Information System
Client:
- Citibank, Chennai.
Duration:
- Dec 00 to Jul 01
Project location:
- Off shore- Chennai
Technologies:
- Pro C, Oracle V 8.x
Project details:
- This system provides information in detail about the various Products. It also gives detail about the categories of Customer and the Products owned by them. In addition to this it provides with essential details like total value in each category of accounts & products in corresponding account currency as well as in any reference currency.
Responsibilities:
- Involved in Development
- Involved in production support
- Interacting with client for understanding the Enhancements
UNIT TRUST OF INDIA INVESTOR SERVICES (P) Ltd– Mumbai - Feb 1999 to Nov 2000
Asst Manager (Systems)
Project #1:
Monthly Withdrawal Plan
Client:
- Unit Trust of India, Mumbai.
Duration:
- May 00 to Nov 00
Project location:
- Off shore- Mumbai
Technologies:
- Developer 2000, Oracle V 7.x
Project details:
- This Project Was Developed For UTI Bond Fund Scheme. This Project will calculate the Post Dated Monthly Cheques to be paid to the customers and printing the cheques and keeping Track of the Amount paid. This Project did all calculations and the Validations Involved in that plan.
Responsibilities:
- Involved in Requirement Gathering
- Involved in Designing the Table
- Involved in Development and Implementation and support
- Interacting with client for understanding the Enhancements
Project #2:
Repurchase and Register Generation
Client:
- Unit Trust of India, Mumbai.
Duration:
- Dec 99 to Apr 00
Project location:
- Off shore- Mumbai
Technologies:
- Developer 2000, Oracle V 7.x
Project details:
- This project was developed For UTI Bond Fund Scheme. The Project Involves in repurchasing the units of the Investors and returning back the amount based on the Net Asset Value (Nav) they repurchased. The project did all validations Involved in this repurchase.
Responsibilities:
- Involved in Development
- Involved in production support
- Interacting with client for understanding the Enhancements
Project #3:
Additional Purchasing Units
Client:
- Unit Trust of India, Mumbai.
Duration:
- Feb 99 to Nov 99
Project location:
- Off shore- Mumbai
Technologies:
- Developer 2000, Oracle V 7.x
Project details:
- This project was developed for UTI Bond Fund Scheme .The project involves the additional investment of units on the same Folio. This Project keeps track of all the additional Investments made and generating the account statement for each additional investment made. The project did all validations involved in this additional investment.
Responsibilities:
- Involved in Development
- Involved in production support
- Interacting with client for understanding the Enhancements
------------------------------------------------------
More Information about this submission and submitter:-
___________________________________________________
Submission ID : 4365696
Date & Time : 13th Jul 2011 8:18 AM (UTC)
IP Address : 59.92.155.235
Browser Info : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.2)
Predicted Country : India